Excel 2003 Intermediate
Who is this training course suitable for?
Our Microsoft Excel 2003 Intermediate course is suitable for those with a basic working knowledge of Excel.
Prerequisites
A working knowledge of Excel or our Excel Introduction course.
Benefits
This course is designed for those users who wish to step up their current knowledge of Excel to take advantage of the more complex features. To be able to create, edit and format large or multiple spreadsheets. Delegates will also be able to perform calculations and functions within a workbook, manipulate data lists and create custom charts which will enable the user to maintain and present data in a professional environment.
After completing this course you will be prepared to attend the Excel Advanced training course.
Course Syllabus
Working with Large Worksheets
Viewing options
Hiding and displaying data
Printing large worksheets
Working with Multiple
Worksheets and Workbooks
Using multiple worksheets
Linking worksheets by using 3-D formulas
Consolidating data
Linking workbooks
Managing workbooks
Customising Excel
Changing options
Customising toolbars and menus
Advanced Charting
Chart formatting options
Creating combination charts
Using graphic elements Advanced Formatting
Borders and shading
Using special number formats
Working with dates
Working with styles
Other advanced formatting
List Management
Working with lists
Sorting and filtering lists
Advanced filtering
Documenting and Auditing
Comments and text boxes
Auditing features
Protection
Workgroup collaboration
Using Templates
Built-in templates
Creating and managing templates