CTC Computer Training offers 1-day Microsoft Excel 2010, 2013 and 2016 computer training courses - Toronto / GTA / all of Ontario
   ‹ HOME   |   TIPS & TRICKS 705.728.5761   |   
1 day Excel 2013 courses Toronto    
Excel 2013 training Toronto GTA
Microsoft Excel 2013 Training London Ontario

Microsoft Excel 2016 - Level 1 (CORE)

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 - CORE

After taking our 1-day Excel 2016 training course you will be able to create workable Excel spreadsheets that convey concise, up-to-the-minute data and look good doing it. We also offer this course on-site, anywhere in Ontario - including the Greater Toronto Area (GTA).

  • The RIBBON
  • The Quick Access Toolbar
  • The FILE tab
  • Typing equations vs. Autosum
  • Formatting
    - Selecting multiple, random ranges
    - shading
    - text font
    - text colour
    - vertical alignment
    - wrapping text
    - text orientation
    - borders
  • Selecting cells/ranges (5 shortcuts)
  • Copy
  • Move
  • Drag & Drop
  • Formulas
    - =SUM
    - =MAX
    - =MIN
    - =AVERAGE
    - =COUNT
    - =COUNTA
  • The amazing Fill button
    - Using pre-programmed lists
    - Creating your own custom lists
    - Using it for copying formulas
  • Data alignment
  • Centering across a span of cells
  • Inserting/deleting columns/rows
  • Adjusting column widths
  • Using the Format Painter efficiently
  • Proper spreadsheet layout
  • Creating custom fill lists
  • Understanding BEDMAS (Proper Order of Operations)
  • Understanding and using ABSOLUTE cell addresses
  • The Freeze Panes function`
  • Print preview
  • Printing
  • Repeating headings at the top of each printout page
  • Using the Conditional Formatting function
  • Introduction to =IF equations

Hot Tip: To quickly add a GROUP of cells (meaning: numerous columns and rows at once), select the cells – including the blank (total) cell beneath each column AND the blank (total) cell to the right of each row, then click the AutoSum button on the toolbar.
You will get ALL column and row sums in one fell swoop. This is just one of the many tips that you will learn at our 1-day Excel 2016 computer training courses (onsite and Barrie classroom).

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

Excel 2016 training courses GTA  Excel 2016 training Toronto


We also offer ON-SITE Word 2016 and Upgrading to Office 2016 and full-level Office 2016 hands-on courses anywhere in Ontario (including Toronto and the GTA)




onsite Excel 2013 courses GTA

Excel 2013 training Toronto

Converting to Office 2013 courses