‹ HOME   |   TIPS & TRICKS 705.728.5761   |   
Excel training    
CTC Computer Training offers Excel 2007 and Excel 2010 onsite training courses
Microsoft Excel 2010 Courses Ontario

Microsoft Excel 2010 - Level 2

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

After taking our Excel 2010 - Level 2 training course, you will see how you can get the multi-talented Excel program to work efficiently 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 computer training courses.

COURSES COST:
$175 per person (+ HST)
9am - 4pm (approx)
Excel 2010 Level 2 manual included
After-course email and telephone support included
Please contact us for on-site Excel 2003, Excel 2007 and Excel 2010 training course prices
Maximum 10 Students.
 

Upgrading to Office 2010 on-site training  Excel 2010 training in Toronto, Mississauga and the GTA

 

 

 

 
 

Excel 2010 training courses Mississauga
 

Excel training
 

Excel 2010