1-day Microsoft Excel 2016 – Level 1 (CORE) training course

This is our most popular course. After taking our 1-day Excel 2016 training course you will be able to create workable 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 skills that you learn in this course can also be used with Excel 2010 and Excel 2013.

Click here to see if you have the skills to bypass Level 1 (CORE)

What we cover:

  • The RIBBON
  • The Quick Access Toolbar
    • How to customize it for faster, more efficient use
  • The FILE tab – what’s on it; how to use it
  • Formulas: keyboard vs mouse
    • =SUM
    • =MAX
    • =MIN
    • =AVERAGE
    • =COUNT
    • =COUNTA
  • 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
  • The amazing Fill button
    • The FILL HANDLE performs two tasks, depending on the contents of the original cell: it COPIES the contents of the cell (ie, an equation or text) or COMPLETES A SEQUENCE (ie, days of the week; months of the year).
      – How to use and manipulate the pre-programmed lists (days of the week; months of the year)
      – How to create your own custom fill lists (for your most often-used column and row headings)
      – Using the Fill Handle to quick-copy data and formulas
  • Flash Fill
  • Data alignment
  • Merge & Centre
  • Inserting/deleting columns/rows
  • Adjusting column widths efficiently
  • Using the Format Painter efficiently
  • Proper spreadsheet layout
  • 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
    • You can have data formatted based on conditions that you specify. This function is particularly useful for worksheets that show financial figures (black = positive, red = negative), test results (results change color based on their value), or any time you want to highlight data that falls within a certain value.
  • Basic charts/graphs
  • Introduction to =IF equations (if time)

Excel Course Cost

$175 per person (+ HST)
Hours: 9am – 4pm (approx)
Excel 2016 course manual is included
After-course email and telephone support included with your course
If you want us to come to you: Contact us for on-site Excel 2010, Excel 2013 and Excel 2016 training course prices
Maximum 10 Students per class.