| 1. | About 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. | Creating and Formatting Data |
Objectives Overview Combining cell contents Using conditional formatting Creating a custom number format Creating a custom date format Creating and applying a style Exercise Review questions Summary |
| 3. | Creating and Formatting Content |
Objectives Overview Inserting clip art Inserting graphics Moving graphics Resizing graphics Formatting graphics Creating and modifying diagrams Moving and resizing diagrams Formatting diagrams Annotating a chart Filling data series with pictures Changing the chart type Manipulating pie charts Selecting and saving a chart template Exercise Review questions Summary |
4. | Using the Research Tool |
Objectives Overview Using the Thesaurus to find synonyms Using research services Exercise Review questions Summary |
| 5. | Validating Data |
Objectives Overview Using totals as visual checks Using formulae for automatic checks Using the Range Finder Auditing a worksheet Using error checking Watching and evaluating formulae Exercise Review questions Summary |
6. | Importing Data into Excel |
Objectives Overview Importing from an external data source Using a database query Importing data from a Web page Exercise Review questions Summary |
| 7. | Working with Tables |
Objectives Overview Creating an modifying a table Using data forms to manage tables Using advanced filters Using subtotals Grouping and outlining data Using data validation Circling invalid data Exercise Review questions Summary |
8. | Analysing Data with Automated Tools |
Objectives Overview Using the Analysis ToolPak Using Goal Seek Using a data table Using the Solver Exercise Review questions Summary |
| 9. | Analysing Data with Scenarios |
Objectives Overview Creating and showing scenarios Merging scenarios Creating a scenario report Exercise Review questions Summary |
10. | Using PivotTables and PivotCharts |
Objectives Overview Creating a PivotTable report Specifying the data to analyse Modifying a PivotTable report Updating a PivotTable Grouping dates in a PivotTable Using the Report Filter area Drilling down to the detail Changing the type of calculation Filtering in a PivotTable Grouping data in a PivotTable Sorting PivotTables Formatting a PivotTable Charting a PivotTable Exercise Review questions Summary |
| 11. | Analysing Data with Functions |
Objectives Overview Using the Lookup functions Using the Conditional Sum Wizard Using Database functions Exercise Review questions Summary |
12. | Protecting Cells, Sheets, and Books |
Objectives Overview Protecting cells Protecting worksheets Protecting workbooks Attaching and viewing digital signatures Adjusting macro settings Exercise Review questions Summary |
| 13. | Collaborating with Others |
Objectives Overview Creating a shared workbook Viewing and removing users Resolving conflicting changes Viewing the change history Comparing and merging workbooks Tracking changes to a workbook Accepting and rejecting changes Removing workbook sharing Exercise Review questions Summary |
14. | Using XML |
Objectives Overview Using XML in Excel Introducing XML files Adding a data map Mapping the worksheet cells Exporting to an XML data file Opening an XML data file Saving as an XML Spreadsheet Importing an XML data file Deleting a data map Setting XML options and properties Exercise Review questions Summary |
| 15. | Managing Data and Workbooks |
Objectives Overview Publishing workbooks as Web pages Creating a workbook template Editing a workbook template Consolidating worksheets Hiding columns, rows, sheets, and books Saving a custom view Viewing and changing workbook properties Exercise Review questions Summary |
16. | Module Summary |
Congratulations Your quiz score Good luck |
