Duration: 1 Day
Excel 2003 Intermediate
Working with large worksheets
- Viewing options
- Hiding, displaying, and outlining data
- Printing large worksheets
Using multiple worksheets and workbooks
- Using multiple worksheets
- Linking worksheets by using 3-D formulas
- Consolidating data
- Linking workbooks
- Managing workbooks
Customizing Excel
- Using the Options dialog box
- Customizing toolbars and menus
Advanced Formatting
- Borders and shading
- Using special number formats
- Working with dates
- Working with styles
- Other advanced formatting
List management
- Examining lists
- Sorting and filtering lists
- Advanced filtering
Advanced charting
- Chart formatting options
- Using combination charts
- Using graphic elements
Documenting and auditing
- Auditing features
- Comments and text boxes
- Protection
- Workgroup collaboration
Using templates
- Built-in templates
- Creating and managing templates
|
