Advanced Functions

• What are Excel 2007 Advanced Functions?
• Getting Help Using a Particular Function
• TODAY
• DAY
• MONTH
• YEAR
• SUMIF
• ROUND
• COUNT
• COUNTA
• COUNTIF
• PROPER
• UPPER
• LOWER
• CONCATENATE
• FV
• NPV
• PMT
• PV
• RATE
• HLOOKUP
• VLOOKUP
• IF
• AND
• OR
• ISERROR
• DSUM
• DMIN
• DMAX
• DCOUNT
• Nested Functions

One/Two-Input Data Tables and What-If Tables

• Using One Input Data Table Command
• Using a Two Input Data Table Command
• Using What if Tables

Pivot Tables

• Creating a Pivot Pable
• Dropping Data into the Pivot Table
• Modifying Data and Refreshing the pivot table
• Grouping Data within a Pivot Table

Scenarios

• Scenario Manager
• Showing a Scenario
• Viewing an Alternative Scenario
• Create a Scenario Summary

Auditing

• Tracing Precedent Cells
• Tracing the Dependants of a Cell
• Displaying all Formulas within a Worksheet
• Adding Comments
• Displaying Comments
• Removing and Editing Comments

Macros

• Displaying the Developer Tab
• Recording and Running Macros
• Lowering your Macro Security Level
• Customising the Quick Access Toolbar
• Changing the Quick Access Macro Icon
• Removing a Macro Icon from the quick Access toolbar
• Raising your Macro Security level