Unformatted text preview: + + - + - + + + Introduction Excel Basics Working with Formulas Using Absolute, Relative Addresses Showing Formulas in R1C1 Notation Using Range Names Auditing Formulas Calculation Options AutoSum button Evaluating a Formula Using External Formula References Working with Charts Working with Functions Function Help + Two Essential Excel Functions + Counting, Summing, Averaging Functions + Math Functions + Text Functions + Date Functions + Statistical Functions - Financial Functions PMT Function NPV, XNPV Functions IRR Function + Reference Functions Tools for Analyzing Data Importing External Data Making Professional Applications Click on any + to expand a main topic click on - to collapse them. Alternative buttons to expand all topics or collaps Click on any hyperlink to go to the she ...
View Full Document
- Fall '10
- Expression, Auditing Formulas Calculation, Addresses Showing Formulas