‹ HOME   |   TIPS & TRICKS 705.728.5761   |   
   
CTC Computer Training
Microsoft Excel Courses Ontario

Microsoft Excel 2003 - Level 2

Click here to see if you have the skills to bypass Excel 2003 - Level 2

After taking our Excel 2003 - Level 2 training course, you will see how you can get the multi-talented Excel program to work for you. An interesting and challenging course for average Excel user who wants to move beyond average-user status.

  • =IF equation use
    - Multiple-condition IFs
    - Nested IFs
  • =SUMIF
  • =COUNTIF
  • =RIGHT / =LEFT
  • =SUBSTITUTE
  • The Text-To-Columns feature
  • =CONCATENATE
  • Three-dimensional spreadsheets
  • Linking sheets with equations
  • Linking files with equations
  • Data Validation
  • Creating and Editing Graphs
    - Bar / Column / Line charts
    - Pie charts
  • Sorting data
  • Non-alphanumeric sorting
  • AutoFilter
  • Data sub-total function (group reporting)

Hot Tip: To link a figure on one sheet to a cell on other sheet (in the same file), sit the cellpointer in the blank cell into which you want the figure pulled; type an = sign; click the page tab (bottom of screen) that contains the value to which you want to link; click on the desired cell; press ENTER.
 
Every time the original value changes – your linked cell will instantly update itself. This is just one of the many tips that you will learn in our 1-day Excel 2003 computer training courses.

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 manual included
After-course email and telephone support included
Contact us for on-site (Toronto, GTA, Ontario) Excel 2003, Excel 2007 or Excel 2010 training prices
Maximum 10 Students.