1. Introduction
2. Advanced data entry and formatting techniques
- restricting cell entries to specific numbers, dates or times
- restricting cell entries to specific entries in a list
- applying number formats to cell entries
- creating a custom number format
- applying conditional formatting to a worksheet
3. Naming ranges
- defining a range name, using a range name in a formula
- moving the cell pointer to a named range
4. Using lookup functions
- using the VLookUp function, using the HLookUp function
5. Working with a template
- creating a template, modifying the default template style
- basing a new workbook on a custom template
6. Auditing a worksheet
- tracing precedents and dependents in a worksheet
- tracing errors in a worksheet
7. Linking multiple workbooks
- entering a formula to link multiple workbooks, creating a workspace
|
8. Working with a database
- what is a database, sorting database records
- totaling database entries, filtering database records
- specifying a criteria range in a filter operation
- using a data form to enter database records
- querying an external database
9. Analyzing data (Part 1)
- creating a PivotTable report
- resetting a summary function in a PivotTable report
- creating a PivotChart report, creating a PivotTable report for the WWW
10. Analyzing data (Part 2)
- using the solver, outlining a worksheet
- additional data analysis topics
11. Importing and exporting data
- importing data from other applications into Excel
- importing data in a text file into Excel,
- importing a table in an HTML file into Excel
- exporting Excel data into other applications
12. Using Excel workgroup features
- tracking changes in a workbook, inserting comments in a worksheet
- accepting and rejecting proposed changes/reviewing comments
- protecting a shared workbook, protecting an unshared workbook
- additional workgroup topics
13. Final case study
- importing elements of another web site into a FrontPage web
- linking a page to a Microsoft Word file
- performing a copy and paste operation |
