On the Trails

Intermediate Skills

Using Templates

1. Create templates
2. Edit templates
3. Create new workbooks based on
4. User-defined templates
5. Modify Workbook properties
6. Change Default Templates & modify template settings

Working with Ranges

1. Create Named Ranges
2. Use named ranges in Formulas
3. Use Lookup Functions
4. Create & Modify List Ranges

Formatting Cells

1. Create & Apply Custom Number Formats
2. Apply conditional formatting
3. Add data validation criteria to cells

Importing & Exporting Data

1. Import Data from Text Files
2. Export Data to Other Applications
3. Link to Web page data
4. Publish Worksheets to the web
5. Examine XML in Office
6. 2003 Use XML to share Excel data

Add, Modify & Delete XML Maps

1. Using PivotTables & PivotCharts
2. Create PivotTables
3. Format PivotTables
4. Show & hide information in PivotTables
5. Add, hide & show detail info in PTables
6. Preview & save PivotTables as Interactive Web Pages
7. Create PivotCharts

Formatting Graphics

1. Crop & rotate Graphics
2. Control Image Contrast & Brightness
3. Scale & resize graphics
4. Apply formats to Data Series (charts)

Auditing & Analyzing Worksheets

1. Explore Formula Auditing
2. Trace Precedents
3. Trace Dependents
4. Locate Errors in Formulas
5. Circle invalid data
6. Evaluate a Nested Formula
7. Watch all cells with formulas

Summarizing Data

1. Group & Outline Structured
2. Data Add Subtotals to Worksheets
3. Create & Remove custom filter
4. Use database functions
5. Use the Histogram Analysis Tool
6. (make sure Analysis ToolPak is installed from TOOLS-add-ins)
7. Create Scenarios (what if tool)
8. Use Solver (add-in; what if tool)

Managing Worksheets

1. Consolidate data from several worksheets
2. Create Shared Workbooks
3. Track changes
4. Accept or reject changes
5. Merge Workbook revisions
6. Protect & Unprotect Cells & Worksheets
7. Protect Workbooks

Customizing Excel

1. Record Macros
2. Run Macros
3. Change security levels for macros
4. Understand editing macros
5. Add & remove buttons from toolbars
6. Add Custom Menus
7. Modify Default Font Settings
8. Set the default no. of worksheets