Microsoft Excel Courses

Most Excel users spend up to 10x longer than necessary to complete tasks. It's time to optimize your team's efficiency!

Live Online / In-Person Excel Training

Choose from 21 different Excel courses, from beginner to advanced.
Each course is 3 ½ hours in length and includes a PDF reference manual and 30 days of technical support. 
Learn more about how our online training works. 

  • Public courses (open to anyone) are $ 150 each/per person and are delivered online (live and fully interactive).  Speak with the Instructor at any time during the course or use the Chat and Q&A features. 
  • Private training is available for your team in a live online format or in-person at your office, in your company meeting room.   Choose from our standard Excel courses, or build your own custom course by using our Master Topic List to select the topics you would like covered.  (Learn more about build your own courses.)  Get in touch for pricing or to book the most convenient time for your team!
 
ezgif.com-webp-to-png

Course 1A: Getting Started

$ 150 per person / 3 ½ hours

Start from the beginning and create a file from scratch.  This course is for you if you’re new to Excel, would like a refresher of the basics, or want to improve your knowledge and become more confident using Excel.

Dates & Times

Fri Oct 7 (1:30pm to 5pm)
Thu Jan 5 (9am to 12:30pm)
Wed Apr 5 (1:30pm to 5pm)

Course hours are EST (Eastern Standard Time).  Our Instructors are located in Toronto, Canada.

Course Topics

Entering Data
– Entering Text and Numbers
– Entering & Working with Dates
– Selecting Cells
– Understanding Cell Pointer Icons
– Cut, Copy, Paste and Fill Basics

Formatting Cells
– Horizontal Cell Alignment
– Formatting Numbers
– Using Format Cells
– The Format Painter
– Cancel vs Undo
– Delete and Clear Options

Sheet Tasks
– Column Widths / Row Heights
– Insert / Delete Columns and Rows
– Add, Rename, Delete, Move Sheets
– Zooming In and Out
– Printing and Preview
– Saving, Open, New, Close

After taking this course, the next step is Course 1B: Basic Formulas.

ezgif.com-webp-to-png

Course 1B: Basic Formulas

$ 150 per person / 3 ½ hours

All the formula essentials are covered in this course: operators, the order of operations, using built-in functions, and understanding relative vs. absolute cell referencing.

Dates & Times

Wed Oct 19 (1:30pm to 5pm)
Fri Jan 13 (9am to 12:30pm)
Tue Apr 18 (1:30pm to 5pm)

Course hours are EST (Eastern Standard Time).  Our Instructors are located in Toronto, Canada.

Course Topics

Take this course if you feel comfortable with the basics in Excel (Course 1A), but have little or no experience creating formulas.

Formulas / Functions
– Entering a basic formula
– Operators & order of operations
– General Use of Excel Functions
– Using these Functions:
     – Sum, Average, Max, Min
     – Count, CountA, CountBlank
     – Round, Today, Now

Absolutes ‐ $
– What is a Relative Reference?
– What is an Absolute Reference?
– Using Full Absolutes
– Using Partial Absolutes

Trouble Shooting / Tips
– Display Formulas
– Editing and Finding Formulas
– Errors & Error Checking

ezgif.com-webp-to-png

Course 2A: Format & Validation Rules

$ 150 per person / 3 ½ hours

Conditional Formatting and Data Validation are features so widely used today that knowing how they work is essential.   They are two very useful Excel features.

Dates & Times

Thu Nov 3 (1:30pm to 5pm)
Mon Jan 23 (9am to 12:30pm)
Wed Apr 26 (1:30pm to 5pm)

Course hours are EST (Eastern Standard Time).  Our Instructors are located in Toronto, Canada.

Course Topics

Conditional Formatting
-Highlight Cell Rules
-Top/Bottom Rules
-Data Bars, Color Scales, Icon sets
-Using Manage Rules
-Clearing Rules
-Using Formulas for a Rule
-Absolute References in Rules
 
Data Validation
-Restrict Entries in Cells
-Customized Error Messages
-Suppress Error Messages
-Add Input Messages
-Simple Drop-Down Lists
-Create Drop-Down Lists from Data
-Circumvent Validation Settings
-Modify Validation Settings
-Clear Validation
 
ezgif.com-webp-to-png

Course 2B: Working with a Database

$ 150 per person / 3 ½ hours

Understand how to setup and work with database data. Topics include setting up a valid database, sorting & filtering and working with Tables.

Dates & Times

Tue Nov 8 (1:30pm to 5pm)
Mon Feb 6 (9am to 12:30pm)
Tue May 9 (1:30pm to 5pm)

Course hours are EST (Eastern Standard Time).  Our Instructors are located in Toronto, Canada.

Course Topics

Setup a Valid Database
-Why Correct Setup is Important
-Valid Database Rules
-Selecting and Navigating Data
-Freeze Headings & Print Titles
 
Sort & Filter
-Basic and Custom Sorting
-Activating Filter
-Entering/Selecting Filter Criteria
-Totalling Filtered Data
-Clear & Reapply
-Copy/Paste and Delete Filtered Data
 
Format as Table
-Static vs Dynamic Ranges
-Working in a Table
-Filter with Table Slicers
 
ezgif.com-webp-to-png

Course 2C: Printing & Sheets

$ 150 per person / 3 ½ hours

Learn how to set print settings, add comments and notes to cells, work with sheets and protect sheets and cells.

Dates & Times

Tue Oct 11 (1:30pm to 5pm)
Wed Feb 15 (9am to 12:30pm)
Wed May 17 (9am to 12:30pm)

Course hours are EST (Eastern Standard Time).  Our Instructors are located in Toronto, Canada.

Course Topics

Page Layout & Printing
-Print Preview / Printing
-Scaling / Paper Size / Orientation
-Margins / Centre on Page
-Normal, Page Layout & Page Break Views
-Headers and Footers
-Print Titles / Page Breaks
-The Page Setup Dialog box
 
Cell Comments / Notes
-Adding Comments & Notes to Cells
-Edit, Delete, Move, Size, Print Comments
-Comment Colour / Adding Pictures
-Threaded Comments in 365
 
Working with Sheets
-Add, Rename, Hide, Delete Sheets
-Move & Copy Sheets
-Using Group Mode
-View Multiple Sheets Together
 
Protect
-Protect a Workbook
-Protect a Sheet
ezgif.com-webp-to-png

Course 2D: Creating Charts

$ 150 per person / 3 ½ hours

Learn how to create charts in Excel – from the basics to more advanced techniques and tips. We also look at adding shapes, pictures and icons to a chart.

Dates & Times

Mon Oct 24 (9am to 12:30pm)
Thu Feb 23 (1:30pm to 5pm)
Thu May 25 (9am to 12:30pm)

Course hours are EST (Eastern Standard Time).  Our Instructors are located in Toronto, Canada.

Course Topics

Charts Basics
-Create Bar/Line and Pie charts
-Selecting, Moving & Sizing Charts
-Change Chart Type / Transpose
-Quick Chart Layouts & Chart Styles
-The Chart Buttons / Printing Charts
 
Chart Settings & Formatting
-The Chart Tabs / The Format Pane
-Change Data Ranges / Adding Elements
-Select, Movie & Sizing Elements
-Formatting Chart Elements
-Creating Pie of Pie / Bar of Pie
-Creating Combo Charts (bar and line)
-Trendlines, Error Bars, Up/Down
 
Other Objects
-Adding Shapes, Icons & Pictures
-Arrange, Align and Rotate
-Group and Ungroup
-Shape Size & Position Options
 
Creating Effective Charts
-Convey Your Message
-Use of Colours, Elements & Objects
-Cools Effects for Better Visuals
ezgif.com-webp-to-png

Course 3: Using IF & VLOOKUP

$ 150 per person / 3 ½ hours

Learn how to effectively use the two most popular functions in Excel – IF and VLOOKUP.   We also cover a feature called Range Names, which is incredibly useful with formulas.

Dates & Times

Tue Nov 15 (9am to 12:30pm)
Tue Feb 28 (1:30pm to 5pm)
Fri Jun 2 (9am to 12:30pm)

Course hours are EST (Eastern Standard Time).  Our Instructors are located in Toronto, Canada.

Course Topics

The IF Function
– IF Arguments
– Using IF
– Nesting IF’s
– Multiple Conditions with AND/OR
– Conditional Formatting with IF
– The IFS Function (Excel 365/2019)

Range Names
– Why Use Range Names?
– Creating and Referencing a Range Name
– Go to a Range Name
– Edit and Delete a Range Name

The VLOOKUP Function
– What is VLOOKUP?
– VLOOKUP vs. HLOOKUP
– Using VLOOKUP
– Approximate & Exact Match
– IFNA with VLOOKUP
– What is the New XLOOKUP Function (Excel 365)?

ezgif.com-webp-to-png

Course 4: More Useful Formulas

$ 150 per person / 3 ½ hours

Learn how to quickly produce results that are difficult or time‑consuming using other methods. We look at conditional functions, index match, xlookup and linking formulas.

Dates & Times

Thu Nov 24 (9am to 12:30pm)
Wed Mar 15 (9am to 12:30pm)
Thu Jun 8 (1:30pm to 5pm)

Course hours are EST (Eastern Standard Time).  Our Instructors are located in Toronto, Canada.

Course Topics

Conditional Functions
– The Subtotal Function
– SumIf / Sumifs
– CountIf / CountIfs
– AverageIf / AverageIfs
– MinIf / Maxif (Excel 365/2019)

Linking Formulas to Other Sheets
– Link Cell/Formulas/3D Formulas

Linking Formulas to Other Files
– Create Linking Formulas
– Edit Links Dialog Box
– Finding Links in a File

Using INDEX MATCH & XLOOKUP
-INDEX MATCH & INDEX MATCH MATCH
-Using XLOOKUP (365)
-Using MATCH with VLOOKUP
-Using XMATCH (365)
-What’s Better: VLOOKUP, INDEX MATCH or XLOOKUP? 
(Knowledge of VLOOKUP required)

ezgif.com-webp-to-png

Course 5: PivotTables Part 1

$ 150 per person / 3 ½ hours

Learn how to produce meaningful reports quickly and easily by leveraging PivotTables. By the end of this session you will feel confident building PivotTables in Excel.

Dates & Times

Thu Nov 10 (1:30pm to 5pm)
Fri Mar 24 (9am to 12:30pm)
Wed Jun 21 (1:30pm to 5pm)

Course hours are EST (Eastern Standard Time).  Our Instructors are located in Toronto, Canada.

Course Topics

Create and Format a Table
– Valid Database Setup
– Create a Table
– Dynamic vs Static Ranges
– Tables with VLOOKUP, Data Validation & Charts

Get Started with a PivotTable
– What is a PivotTable?
– Creating a PivotTable
– Inside/Outside a PivotTable
– Adding Columns, Rows, Values and Filters Fields
– Moving & Removing Fields
– Applying Formatting

Working with a PivotTable
– Edit PivotTable Data
– Expand / Collapse
– Changing Report Layout
– Hide/Show/Modify Subtotals
– Hide/Show Grand Totals
– Sorting and Manual Sort
– Filtering Labels & Values
– Field Settings
– PivotTable Options
– Refresh Data
– Changing the Summary Function
– Percent, Running Totals, Ranking, etc.

ezgif.com-webp-to-png

Course 6: PivotTables Part 2

$ 150 per person / 3 ½ hours

Once you’ve learned the basics, it’s time to see what a PivotTable can really do! Produce reports that output exactly what you need with visuals that will impress any reader. 

Dates & Times

Mon Dec 12 (9am to 12:30pm)
Thu Mar 30 (1:30pm to 5pm)
Mon Jun 26 (9am to 12:30pm)

Course hours are EST (Eastern Standard Time).  Our Instructors are located in Toronto, Canada.

Course Topics

Data Source & Details
-Table vs Range
-Refresh vs Refresh All
-Add PivotTable to Sheet / Move it
-Creating Filter Pages
-Showing Details / Disable Details
 
Grouping & Calculations
-Date Grouping 
-Number Grouping / Custom Groups
-Using Formulas Instead of Grouping
-Creating Calculated Fields / Calculated Items
-What is GetPivotData?
 
Printing & Appearance
-Print Options / Print Titles
-Blank Lines & Page Breaks
-Using and Basic Creating Styles
-Adding Conditional Formatting
 
Slicers & PivotCharts
-Add Slicers / Slicer Settings & Options
-Connect Slicers to Additional PivotTables
-Create PivotCharts
-How to Create a Basic Dashboard
 
(Knowledge of PivotTables Part 1 is required for this course)
ezgif.com-webp-to-png

Course 6A: Advanced PivotTables

$ 150 per person / 3 ½ hours

This course introduces some advanced PivotTable concepts such as the Pivot Cache and the Data Model. Understanding these will allow you to create more customized PivotTables and link multiple data sets together in a PivotTable.

Dates & Times

Tue Jan 10 (1:30pm to 5pm)
Wed Apr 5 (9am to 12:30pm)
Thu Jul 6 (9am to 12:30pm)

Course hours are EST (Eastern Standard Time).  Our Instructors are located in Toronto, Canada.

Course Topics

Setting Defaults
-Default PivotTable Options
-Default Layout
 
The Pivot Cache
-What is it ?
-Saving the Cache / Saving the Data
-Creating a Separate Cache
-Using the Same Cache
-Cache Count
 
The Data Model / Relationships
-Setting Relationships Up
-Multiple Databases in a PivotTable
-Working with Sets
-Drill Downs
-Additional PivotTable Settings
-Distinct Count
-Options Unavailable
ezgif.com-webp-to-png

Course 6B: Using Power Query

$ 150 per person / 3 ½ hours

If you’re constantly updating or appending datasets, or working in slow files filled with lookup formulas, then it’s time to learn Excel’s Power Query to link to source data, shape it the way you want, and then report on it (e.g. in PivotTables).   
 

Dates & Times

Thu Feb 16 (1:30pm to 5pm)

Course hours are EST (Eastern Standard Time).  Our Instructors are located in Toronto, Canada.

Course Topics

To effectively participate in this course, you will need to understand the concept of setting up a valid database, the Table feature and basic PivotTables (topics from Courses 2B and 5).  Knowledge of Course 6 and 6A is helpful, but not required.
 
Getting Data
-Connect to Excel or Other Data
-Load Queries into Excel / Edit Queries
-Refresh / Refresh Options
-Reference / Duplicate Queries
-Merge Datasets / Use Group By
-Update Names (File, Sheet, Table, Column)
 
Basic Column Transformations
-Transform vs Add Column
-Remove, Duplicate, Format
-Extract, Merge, Split / Fill & Replace Values
-Change Case / Work with Dates
-Basic Calculations / Conditional Columns
 
Other Features
-Data Types / Sort & Filter  
-Working with Steps
-Remove Duplicates
-Data Statistics / Find & Fix Data Errors
ezgif.com-webp-to-png

Course 6C: Using Power Pivot

$ 150 per person / 3 ½ hours

Learn how to effectively work with The Data Model using Excel’s Power Pivot tool. Whether the data you use comes from Excel files, or other sources, this course will teach you how to fully understand relationships and build flexible PivotTable formulas using the DAX language.

Dates & Times

Wed Apr 12 (1:30pm to 5pm)

Course hours are EST (Eastern Standard Time).  Our Instructors are located in Toronto, Canada.

Course Topics

To effectively participate in this course, you should already know the topics in Excel Course 6A. Knowledge of Course 6B is very helpful, but not required.

Overview
-Quick Review of Relationships
-Quick Review of the Data Model
-The PowerPivot Window
 
More About Relationships
-Relationships in Diagram view
-Snowflake vs Star
-How Relationships Flow
-Hide Fields or Tables
-Creating Hierarchies
 
Introduction Dax
-Adding Calculated Columns
-Implicit vs Explicit Measures
-Creating Explicit Measures
 
Calendar Tables
-Why Not Group by Dates?
-Create a Calendar Table in Power Pivot
-Create Calendar Table in Excel
-Dynamic Calendars in Power Query
ezgif.com-webp-to-png

Course 7: Introduction to Macros

$ 150 per person / 3 ½ hours

Understanding macros will make you far more efficient. In this course you will learn how to record macros, do basic macro editing and see different ways to run and store macros.

Dates & Times

Mon Oct 3 (1:30pm to 5pm)
Thu Jan 19 (9am to 12:30pm)
Fri Apr 21 (1:30pm to 5pm)

Course hours are EST (Eastern Standard Time).  Our Instructors are located in Toronto, Canada.

Course Topics

Recording Macros
-What is a Macro?
-Recording Macros
-Running Macros
-Buttons & Illustrations to Run Macros
-Add Macros to Quick Access Toolbar
-Saving and Opening Files with Macros
-Using Relative Referencing
-Workbook vs Personal Workbook Macros
 
A Quick Look at VBA
-What is Visual Basic?
-Working in the VBA Editor
-Basic Editing of Recorded Macros
 
The next step is Excel Course 7A to more fully understand working in the VBA Editor.
ezgif.com-webp-to-png

Course 7A: Intermediate Macros

$ 150 per person / 3 ½ hours

In this course we look in more detail at the VBA Editor.  You will learn how to modify recorded macros and create macros by writing VBA to perform actions that cannot be recorded.

Dates & Times

Tue Jun 6 (1:30pm to 5pm)

Course hours are EST (Eastern Standard Time).  Our Instructors are located in Toronto, Canada.

Course Topics

You must have a solid understanding of all Excel Course 7 topics before taking this course.
 
Writing Macros
-Macros You Can’t Record
-Macros Triggered by Events
-Macro Arguments
-Sub vs Function
-Module, Sheet or Workbook
 
Commands/Features
-Variables
-With, End With
-Message Boxes
-IF, Else, Endif
-Select Case, Case Else, End Select
-The Range Object
-Intersect
-Exit a Procedure
-For, Next
-Display and Calculation
-Create a Basic Function
 
Note: this course is intended to get you started in VBA only.  For a solid working knowledge of VBA, it will take much more than just a ½ day course.
ezgif.com-webp-to-png

Course 8: Time-Saving Shortcuts

$ 150 per person / 3 ½ hours

Getting the job done efficiently is everyone’s goal. This course will dramatically improve your productivity by showing you the useful time‑saving features that are hidden in plain sight.  

Dates & Times

Wed Oct 19 (9am to 12:30pm)
Wed Jan 25 (1:30pm to 5pm)
Mon May 1 (9am to 12:30pm)

Course hours are EST (Eastern Standard Time).  Our Instructors are located in Toronto, Canada.

Course Topics

Great Features
-Show Sheets in Separate Windows
-Hyperlinks to Navigate Workbook
-Custom Number & Date Formats
-Customize the Quick Access Toolbar
-Concatenating in Formulas
-Goto Special to Select
-Create Custom Fill Lists
-The Windows Clipboard
-Save Filters or Print Settings
 
Quick Tips
-Trick with Absolute Referencing
-Copy Visible Cells Only
-Quick Ways to Navigate & Select Data
-AutoFit Column Cell Range
-Zoom to Width of Data
-Quick Ways to Format Cells
-The F2 and F9 Keys
-Switch Column Order Quickly
-Quick Paste Values
-Don’t Merge Cells!
-Go Back to Cell Pointer
-Copy Cell Above (Formula or Result)
 
(This course is for Intermediate + users, who also have a solid knowledge of basic formulas – at least the topics covered in Course 1B).
ezgif.com-webp-to-png

Course 9: Cleaning Up Imported Data

$ 150 per person / 3 ½ hours

Using Excel to report on data that has come from another program often involves fixing that data first. This course looks at the best ways to ‘clean up’ your imported data.

Dates & Times

Wed Nov 9 (9am to 12:30pm)
Fri Feb 3 (1:30pm to 5pm)
Tue May 9 (9am to 12:30pm)

Course hours are EST (Eastern Standard Time).  Our Instructors are located in Toronto, Canada.

Course Topics

Import & Fix Text Files
– Import .CSV, .TXT, .PRN
– The Text Import Wizard
– Fix Bad Dates and Bad Numbers
– Transpose
– Finding Duplicates

Splitting Data
– Using Flash Fill to Split Columns
– Using Text to Columns

Concatenating
– Combining Cell Contents
– Combining Different Data Types

Use Text Functions to Fix Data
– Left / Mid / Right
– Len / Search / Trim / Text / Clean
– Lower / Upper / Proper
– Value / NumberValue
– Substitute

New 365 Functions Coming Soon!
– TextBefore
– TextAfter
ezgif.com-webp-to-png

Course 10: More Data Features

$ 150 per person / 3 ½ hours

This course looks at three great features in Excel that will help you quickly and easily manipulate sheet data to display the results you need (advanced filter, grouping and consolidate).

Dates & Times

Wed Nov 16 (1:30pm to 5pm)
Thu Feb 9 (9am to 12:30pm)
Wed May 17 (1:30pm to 5pm)

Course hours are EST (Eastern Standard Time).  Our Instructors are located in Toronto, Canada.

Course Topics

Advanced Filter
– Filter vs. Advanced Filter
– The 3 Ranges
– Simple and Formula‐based Criteria
– Running the Filter
– Using OR Conditions
– Using Range Names
– Copy Unique Records
(You should already be familiar with the regular Filter feature.)

Creating Groups & Subtotals
– Using Auto Outline
– Manually Creating Groups
– Collapse and Expand
– Hide/Show Outline Symbols
– Adding Subtotals
– Subtotal Options
– Removing Subtotals

Data Consolidation
– Consolidate by Position
– Consolidate by Category

ezgif.com-webp-to-png

Course 11: Dynamic Arrays

$ 150 per person / 3 ½ hours

Dynamic Array formulas, new to Excel 365, are by far the biggest change ever made to Excel formulas, allowing you to quickly and easily produce results that were difficult before.

Dates & Times

Fri Nov 25 (1:30pm to 5pm)
Wed Feb 22 (9am to 12:30pm)
Thu May 25 (1:30pm to 5pm)

Course hours are EST (Eastern Standard Time).  Our Instructors are located in Toronto, Canada.

Course Topics

This course is for intermediate and advanced Excel users who are already familiar with basic formulas, relative and absolute cell referencing and functions such as SUM, COUNT, IF and VLOOKUP, etc. 

Arrays
– What is an Array?
– Old CSE Arrays vs DA Arrays
– How to “Spill” a Formula
– The #SPILL! Error
– Implicit Intersection
– Compatibility with other Features
– Forward & Backward Compatibility

Existing Functions
– SUMPRODUCT vs SUM
– TRANSPOSE & FREQUENCY Now Easy

Dynamic Array Functions
– Sort / SortBy
– Filter
– Unique
– Sequence
– RandArray

New DA Functions Coming Soon!
– TextSplit
– VStack / HStack
– ToRow / ToCol
– WrapRows / WrapCols
– Take / Drop
– ChooseRows / ChooseCols
– Expand
ezgif.com-webp-to-png

Course 12: Advanced Formulas

$ 150 per person / 3 ½ hours

In this Excel 365 course, we show you how to use some advanced functions and understand more about how certain formulas and range names effect your workbooks.

Dates & Times

Fri Dec 16 (9am to 12:30pm)
Fri Mar 10 (1:30pm to 5pm)
Thu Jun 8 (9am to 12:30pm)

Course hours are EST (Eastern Standard Time).  Our Instructors are located in Toronto, Canada.

Course Topics

This course is for Excel 365 users who are already familiar with basic and intermediate formulas and functions that we cover in Excel courses 1B, 3, and 4, as well as the concept of Dynamic Arrays covered in course 11. 

Functions Covered
-CHOOSE
-INDIRECT
-OFFSET
-MOD
-ROW / ROWS
-COLUMN / COLUMNS
-LET
  
Advanced Range Names
-Range Name Constants
-Relative Range Names
-What are Dynamic Range Names?
 
About Formulas
-Manual Recalculation
-What are Volatiles?
-Improving Performance  
ezgif.com-webp-to-png

Course 13: Creating a Dashboard

$ 150 per person / 3 ½ hours

In this Excel 365 course you will learn how to create an interactive dashboard with form controls, data and charts.
 

Dates & Times

Thu Jan 5 (1:30pm to 5pm)
Wed Mar 22 (1:30pm to 5pm)
Wed Jun 21 (9am to 12:30pm)

Course hours are EST (Eastern Standard Time).  Our Instructors are located in Toronto, Canada.

Course Topics

You must understand Dynamic Arrays (Course 11) and creating charts (Course 2D) before taking this course. You should also be familiar with the IF function (Course 3), INDEX (Course 4) and Conditional Functions such as SUMIF (Course 4).

Using Form Controls
-Drop Down
-List Boxes
-Scroll Bars
-Option Buttons
 
Creating the Dashboard
-Linking Formulas to Display the Data
-Interactive Charts with Form Controls
-Data Selection Form Controls
-Text Boxes with Linked Formulas
-Design/Format the Final Dashboard
-Hide and Lock Raw Data/Formulas
gear3

Private Training for Your Team

Private training is a course dedicated to your team only, on the date that works best for you. Choose any of our standard Excel courses or build your own custom course, with the topics you would like included. 

Pick a Standard Excel Course

You can select any of the 3½ hour Excel courses listed on this page and we will deliver it to your team in a live online format, or in-person at your office.

Get in touch for pricing or to book the most convenient time for your team!

Build Your Own Course

“Build your own course” means you tell us what topics you would like included in your course.

Use our Master Topic List to select the topics you would like covered in your live online or in-person private course.

Learn more about build your own courses. 

Get in touch for pricing or to book the most convenient time for your team!

Michele Kennedy — Instructor

Does Your Team Need Excel Training?

Did you know that most Excel users spend up to 10x longer than necessary to complete tasks?

Understanding Excel is essential for nearly everyone in the workplace today, but most people are ‘self-taught’ and have gaps in their knowledge that cause them to spend much more time than necessary to accomplish tasks – sometimes spending hours every single day to do what should take minutes!  

With professional Microsoft Excel training from GUMP your team will learn the fastest, most efficient way to get the job done to free up their valuable time for more important tasks.

ezgif.com-webp-to-png

Course 1: Creating Spreadsheets

Whether you’ve never touched Excel or been using it for years, this course starts from the beginning, filling in self-taught gaps along the way. You will learn many time-saving shortcuts that will make you far more efficient.

  • Getting Started With Excel
  • Entering Text, Numbers, Dates & Formulas
  • Entering Formulas & Using Functions
  • Using Number Formats
  • Cell Alignment Options
  • Columns & Rows
  • Cut, Copy, Paste and Paste Special
  • Using Fill
  • Formatting (fonts, colours, borders, etc.)
  • Zoom & Views
  • Freeze Headings on Screen
  • Files (Open, New, Save, Close)
  • Printing

Contact Us or Register to book the most convenient time for your team!

ezgif.com-webp-to-png

Course 2: Expand Your Knowledge

Handle large datasets and display information graphically. Learn how to deal with multi-page spreadsheets, create automatic formatting based on changing data, and display information with beautiful charts and graphs.

  • Setting Up a Database
  • Sorting
  • Filtering With AutoFilter
  • Using Data Validation
  • Conditional Formatting
  • Custom Number Formats
  • Multiple Sheets
  • Multiple Windows
  • Adding Cell Comments/Notes
  • Basic Charts

Contact Us or Register to book the most convenient time for your team!

ezgif.com-webp-to-png

Course 3: Working With Formulas

Multiply your knowledge of formulas. By the end of the day, you will have the skill set to leverage Excel’s hundreds of built-in formulas/functions (such as IF and VLOOKUP) and handle almost any situation, simple or complex.

  • Absolute Formulas
  • Range Names in Formulas
  • The IF Function
  • Conditional Functions (SumIf, CountIf, etc.)
  • The VLOOKUP Function
  • Using INDEX MATCH
  • Multiple Sheet/File Formulas
  • Concatenating
  • Protecting Formulas
  • Mapping Formulas with Auditing
  • Trouble Shooting Errors

Contact Us or Register to book the most convenient time for your team!

ezgif.com-webp-to-png

Course 4: Working With PivotTables

Learn how to use one of Excel’s most powerful – and most intimidating – features to make sense of large sets of data. You will also learn other techniques for building and managing an Excel database.

  • Setting Up a Valid Database
  • Create and Format a Table
  • PivotTables Part 1 – Introduction Topics
  • PivotTables Part 2 – Intermediate Topics
  • PivotTables Part 3 – Advanced Topics
  • PivotTables Part 4 – Expert Topics (if time permits)

Contact Us or Register to book the most convenient time for your team!

ezgif.com-webp-to-png

Course 5: Spreadsheet Management

Learn macros and control nearly any setting in Excel. Data topics covered include finding and showing duplicate data, grouping data for easy viewing and performing advanced filters not possible with the standard filter feature.

  • Introduction to Macros
  • Templates
  • Setting Program Defaults
  • Creating Groups & Adding Subtotals
  • Customize the Ribbon
  • Customize the Quick Access Toolbar
  • Using Advanced Filter
  • Hyperlinks
  • Creating Custom Views
  • Cell Styles, Themes, Fonts & Colours
  • Managing Database Duplicates
  • Importing & Fixing Text Files

Contact Us or Register to book the most convenient time for your team!

ezgif.com-webp-to-png

Excel 365: Dynamic Arrays

Learn how to use the new Calculation Engine, called Dynamic Arrays (available to all Excel 365 subscribers as of in July 2020).  This is by far the biggest change ever made to Excel formulas and will allow you to easily produce results and reports.

  • Overview of Arrays
  • Dynamic Array Spill
  • New Dynamic Array Functions
  • Impact on Formulas
  • Understanding Array Constants
  • Interactive Reports Made Easy

Contact Us or Register to book the most convenient time for your team!

gear3

Build Your Own (Private In-Person)

Use our Master Topic List to select the topics you would like included in your course.  Learn more.

Excel YouTube Tutorials

How to Navigate a Database in Excel

How to Create a Quick Drop Down List in Excel

How to Select Ranges to Enter Data in Excel

How to Zoom In & Out in Excel

How to Select Multiple Ranges in Excel

Our Clients Love Us

I'm so glad we hired the Gump team for our training needs... they've saved us from countless hours of tedious and unnecessary work by optimizing our efficiency in every aspect of Excel. We have taken 7 private in-person Excel courses with Gump, and our team is now far more confident using Excel ... thank you so much.
Jill Spriet
Fernlea Flowers
All our employees were always very happy with the training we received from Gump. Excel can be a dry topic, but they made it fun and easy to follow and were very accommodating in allowing us to choose topics for many custom courses this past year. They also provide very professional textbooks for all of their courses.
Lena Sun
Lafarge Canada Inc.
Gump provided excellent training for a variety of skill levels. Michele was willing to travel to our Mississauga and Sudbury facilities and everyone enjoyed her thoroughness and flexibility with learning styles. I'm often asked when the next session will be and I was quickly able to see people apply their knowledge.
Eamonn Doorly
Epiroc
Michele is an excellent instructor and pleasant to deal with. She's very well spoken and explained the steps in a way we were all able to understand and took the extra time if someone needed more help. She also kept it light, entertaining and funny. I highly recommend GUMP for any Microsoft Office training!
Ian Stewart
Detour Gold