This advanced spreadsheet course will learn to use advanced features of Microsoft Excel such as using multiple worksheets and workbooks, create advanced charts, template, documenting and auditing, advance formatting, and work with large worksheets. |
|
|
|
Course schedule
Duration: 1 day.
To view the schedule for this class, click here.
Who should attend
This course is intended for all IT Professionals who want to learn the Excel XP or 2003.
Prerequisites
Experience in Microsoft Excel XP / 2003 Fundamental.
Course Outline
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
|
|