Microsoft Excel Courses

We offer a wide range of live Excel courses. Pick the one that's right for you, or contact us to design your own!

Choose Your Delivery Style

Our live Excel classes are flexible and accommodating. Choose the option that best suits your delivery needs.

Online Excel Courses - LIVE and Interactive

All our online Excel courses are live and fully interactive.  You can speak with the Instructor at any time during the course and can also use the Chat and Q&A features.  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 courses work.

ezgif.com-webp-to-png

Course 1A: Excel Basics

If you’re new to Excel or have never created your own Excel file, this course if for you.  We look at entering data, formatting cells and sheets, saving and printing your work.

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 Basic Print Settings
– Saving, Open, New, Close

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

This 3-hour course is live and fully interactive (you can ask questions and use the in-class Chat and Q&A).

We are located in Toronto (Canada), but you can attend this course from anywhere.   All that is required to attend is a computer with internet access.   

PDF course reference manual and 30 days of technical support are included.  

Course Fees are in Canadian Dollars:

  • Book 1 or 2 Courses at $ 95 each
  • Book Any 3+ Courses for 5% Off
  • Book Any 6+ Courses for 10% Off
  • Book Any 10+ Courses for 15% Off

Have a Question?  Please contact us or use the Chat widget below to speak with one of our Instructors.

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

Mon Aug 17 (2pm to 5pm)
Wed Sep 2 (9am to 12pm)
Thu Sep 17 (2pm to 5pm)
Thu Oct 1 (9am to 12pm)
Wed Oct 21 (2pm to 5pm)
Tue Nov 3 (9am to 12pm)
Wed Nov 11 (2pm to 5pm)

ezgif.com-webp-to-png

Course 1B: Basic Formulas

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.

Take this course if you feel comfortable with the basics in Excel, 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
– Error Checking
– Using IFERROR

This 3-hour course is live and fully interactive (you can ask questions and use the in-class Chat and Q&A).

We are located in Toronto (Canada), but you can attend this course from anywhere.   All that is required to attend is a computer with internet access.   

PDF course reference manual and 30 days of technical support are included.  

Course Fees are in Canadian Dollars:

  • Book 1 or 2 Courses at $ 95 each
  • Book Any 3+ Courses for 5% Off
  • Book Any 6+ Courses for 10% Off
  • Book Any 10+ Courses for 15% Off

Have a Question?  Please contact us or use the Chat widget below to speak with one of our Instructors.

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

Tue Aug 18 (9am to 12pm)
Fri Sep 11 (9am to 12pm)
Tue Sep 22 (9am to 12pm)
Thu Oct 8 (1pm to 4pm)
Fri Oct 23 (9am to 12pm)
Mon Nov 9 (2pm to 5pm)
Thu Nov 19 (9am to 12pm)
Tue Dec 8 (9am to 12pm)
Fri Dec 18 (2pm to 5pm)

ezgif.com-webp-to-png

Course 2A: Intermediate Topics

Conditional Formatting and Data Validation are features so widely used today that knowing how they work is essential. We also look at some useful sheet tips & features.

Conditional Formatting
– Highlight cell rules
– Top/bottom rules
– Data bars, color scales, icon sets
– Using manage rules
– Clearing rules
– Using formulas for a rule

Data Validation
– Set Values Allowed in Range
– Create Drop‐down Lists
– Information Messages
– Unacceptable Entry Messages
– Modifying Validation Settings

Working with Sheets
– Quick Navigation/Copy
– Using Group Mode
– Protect a Workbook

This 3-hour course is live and fully interactive (you can ask questions and use the in-class Chat and Q&A).

We are located in Toronto (Canada), but you can attend this course from anywhere.   All that is required to attend is a computer with internet access.   

PDF course reference manual and 30 days of technical support are included.  

Course Fees are in Canadian Dollars:

  • Book 1 or 2 Courses at $ 95 each
  • Book Any 3+ Courses for 5% Off
  • Book Any 6+ Courses for 10% Off
  • Book Any 10+ Courses for 15% Off

Have a Question?  Please contact us or use the Chat widget below to speak with one of our Instructors.

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

Tue Aug 18 (1pm to 4pm)
Thu Aug 27 (9am to 12pm)
Fri Sep 4 (9am to 12pm)
Wed Sep 30 (1pm to 4pm)
Tue Oct 13 (9am to 12pm)
Wed Oct 28 (1pm to 4pm)
Fri Nov 13 (9am to 12pm)
Fri Nov 27 (2pm to 5pm)
Thu Dec 3 (9am to 12pm)

ezgif.com-webp-to-png

Course 2B: More Intermediate Topics

Learn three important and widely used features in Excel: working with a database, protecting data from being changed or erased and creating basic charts.

Basic Database Topics
– Valid Database Setup Rules
– Freeze Headings & Print Titles
– Using Sort and Custom Sort
– Using AutoFilter

Protecting Sheet Data
– Locking/Unlocking Cells
– Protection Options
– Protect On/Off
– Forgot Your Password?

Chart Basics
– Insert a Chart
– Use the Chart Buttons
– The Chart Tools Tabs
– Move, Size and Print Charts

This 3-hour course is live and fully interactive (you can ask questions and use the in-class Chat and Q&A).

We are located in Toronto (Canada), but you can attend this course from anywhere.   All that is required to attend is a computer with internet access.   

PDF course reference manual and 30 days of technical support are included.  

Course Fees are in Canadian Dollars:

  • Book 1 or 2 Courses at $ 95 each
  • Book Any 3+ Courses for 5% Off
  • Book Any 6+ Courses for 10% Off
  • Book Any 10+ Courses for 15% Off

Have a Question?  Please contact us or use the Chat widget below to speak with one of our Instructors.

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

Tue Aug 25 (9am to 12pm)
Wed Sep 2 (2pm to 5pm)
Thu Sep 10 (2pm to 5pm)
Thu Oct 1 (2pm to 5pm)
Thu Oct 15 (9am to 12pm)
Tue Nov 17 (9am to 12pm)
Fri Dec 11 (2pm to 5pm)

ezgif.com-webp-to-png

Course 3: Using IF & VLOOKUP

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.

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 and List Range Names
– Edit and Delete a Range Name

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

This 3-hour course is live and fully interactive (you can ask questions and use the in-class Chat and Q&A).

We are located in Toronto (Canada), but you can attend this course from anywhere.   All that is required to attend is a computer with internet access.   

PDF course reference manual and 30 days of technical support are included.  

Course Fees are in Canadian Dollars:

  • Book 1 or 2 Courses at $ 95 each
  • Book Any 3+ Courses for 5% Off
  • Book Any 6+ Courses for 10% Off
  • Book Any 10+ Courses for 15% Off

Have a Question?  Please contact us or use the Chat widget below to speak with one of our Instructors.

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

Fri Aug 14 (9am to 12pm)
Mon Sep 14 (9am to 12pm)
Tue Sep 22 (1pm to 4pm)
Tue Oct 6 (9am to 12pm)
Thu Oct 22 (1pm to 4pm)
Tue Nov 10 (9am to 12pm)
Mon Nov 30 (2pm to 5pm)
Wed Dec 9 (9am to 12pm)
Thu Dec 17 (2pm to 5pm)

ezgif.com-webp-to-png

Course 4: More Useful Formulas

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

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
– INDEX MATCH instead of VLOOKUP
– INDEX MATCH or XLOOKUP (Excel 365) ?
– Using MATCH alone
– Using INDEX alone
– Using MATCH with VLOOKUP
– Using XMATCH (Excel 365)
(Knowledge of VLOOKUP required)

This 3-hour course is live and fully interactive (you can ask questions and use the in-class Chat and Q&A).

We are located in Toronto (Canada), but you can attend this course from anywhere.   All that is required to attend is a computer with internet access.   

PDF course reference manual and 30 days of technical support are included.  

Course Fees are in Canadian Dollars:

  • Book 1 or 2 Courses at $ 95 each
  • Book Any 3+ Courses for 5% Off
  • Book Any 6+ Courses for 10% Off
  • Book Any 10+ Courses for 15% Off

Have a Question?  Please contact us or use the Chat widget below to speak with one of our Instructors.

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

Wed Aug 12 (9am to 12pm)
Mon Aug 24 (1pm to 4pm)
Fri Sep 4 (1pm to 4pm)
Thu Sep 24 (9am to 12pm)
Wed Oct 14 (9am to 12pm)
Mon Oct 26 (1pm to 4pm)
Mon Nov 16 (9am to 12pm)
Thu Nov 26 (2pm to 5pm)
Mon Dec 7 (9am to 12pm)
Wed Dec 16 (2pm to 5pm)

ezgif.com-webp-to-png

Course 5: PivotTables Part 1

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.

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.

This 3-hour course is live and fully interactive (you can ask questions and use the in-class Chat and Q&A).

We are located in Toronto (Canada), but you can attend this course from anywhere.   All that is required to attend is a computer with internet access.   

PDF course reference manual and 30 days of technical support are included.  

Course Fees are in Canadian Dollars:

  • Book 1 or 2 Courses at $ 95 each
  • Book Any 3+ Courses for 5% Off
  • Book Any 6+ Courses for 10% Off
  • Book Any 10+ Courses for 15% Off

Have a Question?  Please contact us or use the Chat widget below to speak with one of our Instructors.

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

Wed Aug 12 (1pm to 4pm)
Thu Aug 20 (9am to 12pm)
Tue Sep 1 (1pm to 4pm)
Wed Sep 16 (9am to 12pm)
Mon Oct 5 (9am to 12pm)
Tue Oct 20 (1pm to 4pm)
Wed Nov 4 (9am to 12pm)
Tue Nov 24 (2pm to 5pm)
Fri Dec 4 (9am to 12pm)
Tue Dec 15 (2pm to 5pm)

ezgif.com-webp-to-png

Course 6: PivotTables Part 2

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. 

Intermediate Topics
-How to Add Filter Pages
-Show Details (Drill Downs)
-Grouping Dates & Numbers
-Creating Custom Groups
-Printing Options
-Creating and Using Styles
-Defer Layout
-Creating PivotCharts
-Using Slicers & Timelines
-Setting PivotTable Default Options
-Conditional Formatting in a PivotTable

Advanced Topics
-Understanding the PivotCache
-Adding Calculated Fields
-Adding Calculated Items
-Create a Basic Dashboard
-Using GetPivotData

(Knowledge of PivotTables Part 1 is required for this course)

This 3-hour course is live and fully interactive (you can ask questions and use the in-class Chat and Q&A).

We are located in Toronto (Canada), but you can attend this course from anywhere.   All that is required to attend is a computer with internet access.   

PDF course reference manual and 30 days of technical support are included.  

Course Fees are in Canadian Dollars:

  • Book 1 or 2 Courses at $ 95 each
  • Book Any 3+ Courses for 5% Off
  • Book Any 6+ Courses for 10% Off
  • Book Any 10+ Courses for 15% Off

Have a Question?  Please contact us or use the Chat widget below to speak with one of our Instructors.

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

Fri Aug 14 (1pm to 4pm)
Thu Aug 27 (1pm to 4pm)
Fri Sep 18 (9am to 12pm)
Mon Sep 28 (9am to 12pm)
Wed Oct 14 (1pm to 4pm)
Fri Oct 30 (9am to 12pm)
Mon Nov 9 (9am to 12pm)
Fri Nov 20 (2pm to 5pm)
Tue Dec 8 (2pm to 5pm)
Thu Dec 17 (9am to 12pm)

ezgif.com-webp-to-png

Course 7: Intro to Macros

Understanding macros will make you far more efficient. We start with the basics (recording, edit & saving) and then we’ll get you started in the visual basic programming language.

Recording Macros
– What is a Macro?
– Recording & Playing a macro
– Using Relative Referencing
– Workbook vs Personal Workbook
– Buttons & Illustrations to Run Macros
– Adding Macros to the QAT or Ribbon
– Saving and Opening Files with Macros
– Understanding the Personal Macro Workbook File

Introduction to VBA
– What is Visual Basic?
– Working in the VBA Editor
– Editing Recorded Macros
– Creating Macros that Cannot be Recorded
– Creating Macros that are Triggered by Events

Using the Following in VBA:
– With & End With
– Show Message Boxes
– Add Comments
– The IF Statement
– The Range Object
– Intersect
– Exit a Procedure

This 3-hour course is live and fully interactive (you can ask questions and use the in-class Chat and Q&A).

We are located in Toronto (Canada), but you can attend this course from anywhere.   All that is required to attend is a computer with internet access.   

PDF course reference manual and 30 days of technical support are included.  

Course Fees are in Canadian Dollars:

  • Book 1 or 2 Courses at $ 95 each
  • Book Any 3+ Courses for 5% Off
  • Book Any 6+ Courses for 10% Off
  • Book Any 10+ Courses for 15% Off

Have a Question?  Please contact us or use the Chat widget below to speak with one of our Instructors.

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

Mon Aug 24 (9am to 12pm)
Wed Sep 9 (1pm to 4pm)
Mon Sep 21 (9am to 12pm)
Thu Oct 8 (9am to 12pm)
Fri Oct 23 (1pm to 4pm)
Fri Nov 6 (9am to 12pm)
Thu Nov 19 (2pm to 5pm)
Tue Dec 1 (9am to 12pm)
Mon Dec 14 (2pm to 5pm)

ezgif.com-webp-to-png

Course 8: Time-Saving Shortcuts

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.

Great Features
-Custom Number Formats
-Customize the Ribbon
-Customize Quick Access Toolbar
-Concatenating Formulas
-Setting Defaults not in Options
-Ways to use Absolutes
-Show Several Sheets Together
-Set the same Print Settings for Entire Workbook
-Save Multiple Filters or Print Settings
 
Quick Tips
-Select Formulas, Blanks, etc.
-Go Back to Cell Pointer
-Copy Cell Above
-Quick Move & Insert
-Hold Multiple Items in Clipboard for Pasting
-Useful Shortcut Keys
-Excluding Hidden Cells
-Quick way to Paste Values
-Add Notes Inside a Formula
-Editing in Range Boxes

This 3-hour course is live and fully interactive (you can ask questions and use the in-class Chat and Q&A).

We are located in Toronto (Canada), but you can attend this course from anywhere.   All that is required to attend is a computer with internet access.   

PDF course reference manual and 30 days of technical support are included.  

Course Fees are in Canadian Dollars:

  • Book 1 or 2 Courses at $ 95 each
  • Book Any 3+ Courses for 5% Off
  • Book Any 6+ Courses for 10% Off
  • Book Any 10+ Courses for 15% Off

Have a Question?  Please contact us or use the Chat widget below to speak with one of our Instructors.

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

Thu Aug 20 (1pm to 4pm)
Mon Sep 14 (1pm to 4pm)
Mon Sep 28 (1pm to 4pm)
Fri Oct 16 (9am to 12pm)
Fri Oct 30 (1pm to 4pm)
Fri Nov 13 (2pm to 5pm)
Fri Nov 27 (9am to 12pm)
Mon Dec 7 (2pm to 5pm)
Tue Dec 15 (9am to 12pm)

ezgif.com-webp-to-png

Course 9: Cleaning Up Imported Data

Using Excel to report on data that has come from another program often involves fixing and formatting before you can build the reports you need. This course looks at the best ways to clean up imported data.
 

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

This 3-hour course is live and fully interactive (you can ask questions and use the in-class Chat and Q&A).

We are located in Toronto (Canada), but you can attend this course from anywhere.   All that is required to attend is a computer with internet access.   

PDF course reference manual and 30 days of technical support are included.  

Course Fees are in Canadian Dollars:

  • Book 1 or 2 Courses at $ 95 each
  • Book Any 3+ Courses for 5% Off
  • Book Any 6+ Courses for 10% Off
  • Book Any 10+ Courses for 15% Off

Have a Question?  Please contact us or use the Chat widget below to speak with one of our Instructors.

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

Tue Aug 25 (2pm to 5pm)
Thu Sep 17 (9am to 12pm)
Fri Oct 9 (2pm to 5pm)
Tue Nov 3 (2pm to 5pm)

ezgif.com-webp-to-png

Course 10: More Data Features

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).

Advanced Filter
– AutoFilter vs. Advanced Filter
– The three ranges
– Simple and formula‐based criteria
– Performing a 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

This 3-hour course is live and fully interactive (you can ask questions and use the in-class Chat and Q&A).

We are located in Toronto (Canada), but you can attend this course from anywhere.   All that is required to attend is a computer with internet access.   

PDF course reference manual and 30 days of technical support are included.  

Course Fees are in Canadian Dollars:

  • Book 1 or 2 Courses at $ 95 each
  • Book Any 3+ Courses for 5% Off
  • Book Any 6+ Courses for 10% Off
  • Book Any 10+ Courses for 15% Off

Have a Question?  Please contact us or use the Chat widget below to speak with one of our Instructors.

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

Wed Aug 26 (9am to 12pm)
Wed Sep 23 (2pm to 5pm)
Thu Oct 15 (2pm to 5pm)
Mon Nov 23 (9am to 12pm)

ezgif.com-webp-to-png

Course 11: Dynamic Arrays

The new Calculation Engine now available to all Excel 365 subscribers is by far the biggest change ever made to Excel formulas.  Dynamic Arrays allow you to quickly and easily produce results that were difficult or time-consuming using the old-style formulas (now referred to a Legacy Formulas).    

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

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

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

This 3-hour course is live and fully interactive (you can ask questions and use the in-class Chat and Q&A).

We are located in Toronto (Canada), but you can attend this course from anywhere.   All that is required to attend is a computer with internet access.   

PDF course reference manual and 30 days of technical support are included.  

Course Fees are in Canadian Dollars:

  • Book 1 or 2 Courses at $ 95 each
  • Book Any 3+ Courses for 5% Off
  • Book Any 6+ Courses for 10% Off
  • Book Any 10+ Courses for 15% Off

Have a Question?  Please contact us or use the Chat widget below to speak with one of our Instructors.

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

Thu Sep 10 (9am to 12pm)
Wed Oct 21 (9am to 12pm)
Tue Nov 17 (2pm to 5pm)

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 course, with the topics you would like included.

Select one of the standard courses listed on this page. $795 / flat rate for up to 15 people for any of our 3-hour Excel courses.

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

“Build your own course” means you tell us what topics you would like included in your course. You can use our Master Topic List to select the topics you would like covered.  $895 flat rate for up to 15 people for a 3‑hour session.

Learn more about build your own courses. Contact Us or Register to book the most convenient time for your team!

Private In-Person Courses

In-Person private training is held at your office, in your company meeting room. Choose from one of 6 different 1-day courses or build a completely customized course for your team. For pricing information, please contact us.

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

Michele Kennedy — Chief Rockstar

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.

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