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

Microsoft Excel 2016 - Level 2

Skills learned in this course can be used with Excel 2010 and Excel 2013.

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

After taking our Excel 2016 - 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
  • =RIGHT / =LEFT
  • The Text-To-Columns feature
  • 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 2016 computer training courses.

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

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





Excel 2013 training courses Mississauga

Excel training

Excel 2013