MX2003-2 - Microsoft Excel 2003 Intermediate
This intermediate Microsoft Excel training course goes into more depth on topics such as Editing and Formatting techniques, Functions, Tables, Absolute Cell References, Charts, Lists, controlling Worksheet Display, Workbooks, Adding
pictures and diagrams to a worksheet, Templates, Hyperlink and interfacing with the Internet.
"I learned several shortcuts that will help me to work smarter. This is a valuable class to people who are new to Excel or self taught. The instructor had a lot of energy and was very knowlegeable about the subject. She was good about answering some application questions outside of Excel.." -- Sondra A. from San Diego, CA
"I liked everything about this course. Excellent Instructor. Good Course to take.." -- Maria A. O. from San Diego, CA
"I would highly recommended this course. I feel [the instructor] covered everything I had questions on and didn't know before I came. Extremely interesting and easy to follow, excellent communicator and patient.." -- Angie T. from San Diego, CA
"I think that employers and employees should take these classes to really learn how to save time by knowing the fastest or easiest way to make a change or correction. I think [the instructor] really did an excellent job. She asked each one of us what we would like to get out of this class and she made sure we each got that covered. I feel the class was especially tailored to my needs.." -- Dee F. from San Diego, CA
"Very valuable class. All expectations were met. Great [instructor]. wonderful personality. very easy to learn from.." -- Michael H. from San Diego, CA
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
Web discussions
Creating and responding to Web discussions
Microsoft Office Specialist exam objectives maps
Specialist exam objectives
Expert exam objectives