| 1. | Introduction to this course |
Welcome Introduction and objectives Getting help with the course How the course is structured About the model workbooks About the exercises Summary |
2. | Advanced Data Entry |
Objectives Overview Good spreadsheet design Editing and formatting data Adding checks and auditing Protecting cells and sheets Validating data Exercise Review questions Summary |
| 3. | Using Advanced Functions and Tools |
Objectives Overview Using advanced functions Naming ranges of cells Using Goal Seek Using Scenario Manager Sharing workbooks with others Exercise Review questions Summary |
4. | Adding Value to Information |
Objectives Overview Importing data into Excel Linking to external data Working with multiple workbooks Consolidating data Working with text Using conditional formatting Advanced charting Exercise Review questions Summary |
| 5. | Linking Excel with Word and PowerPoint |
Objectives Overview Embedding charts in Word Linking charts to Word Including cell values in Word text Linking to PowerPoint Exercise Review questions Summary |
6. | Using the Data Analysis Tools |
Objectives Overview Linking to external data Sorting data Filtering data Finding and changing data Subtotalling data Creating pivot tables Summarising pivot tables Formatting pivot tables Creating pivot charts Exercise Review questions Summary |
| 7. | Mastering Pivot Tables |
Objectives Overview Summarising pivot tables Sorting and grouping pivot tables Exercise Review questions Summary |
8. | Creating Macros and Forms |
Objectives Overview Creating VBA macros Running VBA macros Creating form controls Creating user forms Exercise Review questions Summary |
| 9. | Extending Excel with Add-ins |
Objectives Overview Introducing Excel add-ins Using the Lookup Wizard Using the Conditional Sum Wizard Using the Analysis ToolPak add-in Using the Access Links add-in Using the Report Manager add-in Using the Template Wizard Using Small Business Financial Manager Creating an add-in Exercise Review questions Summary |
10. | Working with Templates |
Objectives Overview Using templates Adding to the default template Formatting with styles Exercise Review questions Summary |
| 11. | Module Summary |
Congratulations Your quiz score Good luck |
|||
