COURSE LIST / MICROSOFT EXCEL 2003 - LEVEL 3
 

Microsoft Excel 2003 - Level 3

In our Excel 2003 - Level 3 training course, you will learn to create Excel macros that manipulate spreadsheets. Combine powerful tools like lookup tables and macros to implement efficient, time-saving Excel spreadsheets, and explore Pivot Tables.

• Applying & Using Range Names
• Date Calculations
• Vertical (VLOOKUP) and Horizontal (HLOOKUP) lookup tables
• Basic Excel macros
• Editing basic Visual Basic code in Excel
• Adding dialog boxes to Excel macros (making them interactive)
• Adding macros to the toolbar
• Pivot tables
  - Creating
  - Customizing
    ~ Removing items from a table
    ~ Changing/removing sub-totals
    ~ The Format Report button

Hot Tip: See the “Name Box” just above columns A & B? Once you use the Name command to name ranges of cells, you can click the down-arrow to the right of the Name Box and click the range that you want to go to.
 
This nifty Excel feature is terrific for moving around really large spreadsheets quickly. This is just one of the many tips that you will discover in our 1-day Excel 2003 computer training courses (onsite and classroom).

COURSES COST:
$165 per person (+ HST)
9am - 4pm (approx)
Excel 2003 manual included
After-course email and telephone support included
Contact us for on-site (Toronto, GTA, or anywhere in Ontario) Excel 2003 training prices
Maximum 10 Students.
 

↑ BACK TO TOP