‹ HOME   |   TIPS & TRICKS 705.728.5761   |   
   
CTC Computer Training
Microsoft Office 2010 Training

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:
Excel 2003 courses are only available on an on-site basis.
Please contact us for onsite training prices.
Courses run from 9am - 4pm (approx)
Excel 2003 Level 3 manual included
After-course email and telephone support included
Contact us for on-site Excel 2003, Excel 2007 and Excel 2010 training courses in Toronto, GTA, Ontario.
Maximum 10 Students.