MicroKnowledge Excel 2000 Intermediate

Excel XP Intermediate

Work with large worksheets, link and consolidate data, customize the Excel environment, enhance charts, use advanced formatting features, create and manage lists, document and audit workbooks, create templates.

Recommended Preparation: Excel 2000 Basic or equivalent knowledge.

Lesson 1: Working with large worksheets

Viewing options
Zooming in and out on a large
Worksheet
Hiding/displaying data
Printing large worksheets

Lesson 2: Multiple worksheets and workbooks

Linking worksheets using 3-D formulas
Consolidating data
Linking workbooks

Lesson 3: Customizing Excel

Changing options
Customizing toolbars and menus

Lesson 4: Advanced charting

Formatting chart options
Creating combination charts
Adding graphic elements

Lesson 5: Advanced formatting

Borders and shading
Special number formats
Dates
Styles
Other advanced formatting

Lesson 6: List management

Creating lists
Sorting and filtering lists
Advanced filtering

Lesson 7: Documenting and auditing

Comments and text boxes
Auditing features
Protection

Lesson 8: Using templates

Built-in templates
Creating and managing templates