| 1. | Introduction to this course |
Welcome Introduction and objectives Getting help with the course How the course is structured About the case studies Summary |
2. | Advanced Data Entry and Design |
Objectives Overview Good spreadsheet design Basic data entry and formatting Referencing cells 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 Accounting Data |
Objectives Overview Importing data into Excel Linking to external data Working with multiple workbooks Consolidating data Working with text Advanced 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 ODBC and Microsoft Query Using Excel's Data tools Using basic pivot tables Summarising pivot tables Formatting pivot tables Creating pivot charts Exercise Review questions Summary |
| 7. | Mastering Pivot Tables and Macros |
Objectives Overview Advanced pivot tables Actual to Budget pivot tables Creating VBA macros Running VBA macros Creating form controls Creating user forms Exercise Review questions Summary |
8. | Extending Excel with Add-ins |
Objectives Overview Add-ins explained Small Business Financial Manager Using the Lookup Wizard Using the Conditional Sum Wizard Miscellaneous add-ins Exercise Review questions Summary |
| 9. | The Accountant's Toolbox |
Objectives Overview Using templates Adding to the default template Formatting with style Creating new functions Exercise Review questions Summary |
10. | Contacting the Authors |
Contacting Us About Courses on Disk Contacting Courses on Disk The Knowledge Base Other courses for accountants Credits and acknowledgements Summary |
| 11. | Module Summary |
Congratulations Your quiz score Good luck |
|||
