Duration:
1 day
Versions Available:
97, 2000, XP, 2003, 2007, 2010
COURSE OUTLINE
| Refreshing the intermediate
More formulae
Summing conditionally Lookup tables Text functions Views and Reports
Outlining a worksheet Creating worksheet views Printing reports Templates and Auditing
Creating templates Conditional formatting Auditing a worksheet Adding a comment Tracking changes Sharing workbooks Drawing and graphics Diagrams and organisation charts |
Working with Lists Using the data form Entering subtotals Data validation Pivot Tables
Summarising data using pivot tables Formatting the pivot table Creating a pivot table chart What If Analysis
Goal seek Solver Scenarios Data tables Toolbars
Editing an existing toolbar Creating a new toolbar Introduction to Macros
Recording and running a Macro |
PDF 
