Microsoft Excel 2003: Level Two

Who Should Attend (Prerequisites)...

All students should take our “Level 1” class first, unless they have intermediate level Excel 2003 skills.

What...

• Produce and link multiple spreadsheets.

• Practice with drop down lists, formatting, conditional formatting, linking, and embedding.

• Receive an introduction to Pivot Tables.

• Use enhanced charting facilities, advanced functions, formulas, and long formulas.

• Learn to use Excel as a database.

• Use Menus, Dialog Boxes, Toolbars, and Shortcuts.

• Create a formula with several operators and cell ranges.
   

• Work with the Insert Function button on the Formula toolbar.

• Create and use range names.
   

• Select nonadjacent cell ranges.
   

• Use the AutoCalculate feature.
   

• Create a conditional formula with the IF function.
   

• Use the PMT function.
   

• Display and print formulas in a worksheet.
   

• Identify and fix formula errors.
   

• Learn advanced functions for Graphs and Charts.
   

• Format a Data Series and Chart Axis.
   

• Add headers, footers, and page numbers to a worksheet.
   

• Reference external data sources.
   

• Adjust the margins, page size and orientation, and print scale.
   

• Protect and hide a worksheet.
   

• Save a “reader friendly” Custom View.
   

• Create and use templates.
   

• Add records to a list using a Data Form.
   

• Work with Lists.

• Hands-on exercises with time set aside to practice what you have learned.
   

Why You Should Attend...

Our training features a two-instructor approach to maximize learning and allow for more “hands-on” practice. You also receive a copy of How to Do Everything with Microsoft Office Excel 2003 – a 400+ page manual.

Course includes lunch, continental breakfast, refreshments, certificate, and course materials.