Stop letting Excel slow you down. Discover how to turn
time-consuming tasks into quick wins.

Microsoft Excel Training

One Membership. Company-Wide Training. No Limits.

In today’s challenging economy, businesses need cost-effective ways to keep their teams sharp. That’s why we’ve revolutionized corporate training with an unbeatable approach designed to maximize value and minimize costs.

Starting at just $499/month (billed annually) your organization can become a member and receive unlimited, company-wide access to all of our 50+ live public courses — no per-person fees, no limits, no hidden costs. One flat fee covers all the training your entire team needs for a full year. 

Secure your membership today and enjoy unlimited learning for your workforce!

For over three decades, GUMP has been a trusted source for corporate computer training, offering the most extensive array of Excel courses in the market today. With a choice of over 20 Excel courses, you can pinpoint the exact areas of Excel expertise you need to boost your efficiency and productivity in your role. Elevate your Excel skills with us.

At GUMP, we don't just teach Excel

We empower individuals and organizations to harness its full potential, equipping them with practical skills that can enhance their personal and professional endeavors.

Ready to embark on a journey toward Excel mastery with a exceptional training provider?  We’ll show you how to excel at Excel!

Dual Learning and Explanation Mastery

At GUMP Training, we excel in dual learning methodologies, ensuring that our training programs cater to various learning styles and preferences. We don’t just teach; we empower and inspire participants. Our team possesses a unique ability to simplify intricate Excel concepts and communicate them clearly and engagingly, setting us apart from the rest.

Unwavering Patience

Patience is our hallmark. We recognize that learning Excel or any other skill can be a challenging process, and our dedicated instructors are here to provide unwavering support every step of the way. We create a nurturing and supportive learning environment where questions are encouraged, and each participant’s pace is respected.

Profound Excel Expertise

Excel is our playground, and our team boasts an extensive and profound understanding of this versatile tool. Our training programs cover not only the basics but also advanced techniques and strategies, ensuring that participants gain a comprehensive understanding of Excel’s capabilities.

public

Public Courses
(Virtual)

Our live, online Excel courses are open to everyone and delivered via Zoom, offering real-time interaction with the instructor through conversation or chat. Members enjoy unlimited access to all courses with no course fees ($0).  Non-members pay $175 for half day courses or $350 for full day courses.

private

Private Training
(In-Person or Virtual)

Private training is exclusively tailored for your team and can be scheduled at your convenience. You can select from our standard Excel courses or specify the topics you want to cover. These training sessions can be conducted in-person at your office (within the GTA/Southern Ontario area) or virtually via Zoom.

Excel Course Listing

Excel

Course 1A: Getting Started

Course Fee:  Members: $ 0  /  Non-members: $ 175
Course Length:  3 hours

New to Excel or just want to sharpen the basics? This course walks you through building a file from scratch and gives you a solid foundation in the essentials—perfect for beginners, anyone needing a refresher, or those ready to boost their confidence and skills.

Dates & Times

Mon Oct 5, 2026 (9am to 12pm)

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

Course Manual
PDF Course Reference Manual Included

Course Topics

Entering Data
– Entering Text, Numbers and 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.

Excel

Course 1B: Basic Formulas

Course Fee:  Members: $ 0  /  Non-members: $ 175
Course Length:  3 hours

Get comfortable with the building blocks of Excel formulas. You’ll learn how to use operators, understand the order of operations, work with built-in functions, and confidently handle relative and absolute references. By the end, you’ll be ready to dive into more advanced formulas like IF and VLOOKUP with ease.

Dates & Times

Mon Jul 27, 2026 (9am to 12pm)
Tue Oct 20, 2026 (1:30pm to 4:30pm)

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

Course Manual
PDF Course Reference Manual Included

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, and NOW

Absolutes ‐ $
-What is a Relative Reference
-What is an Absolute Reference
-Using Full Absolute References

Trouble Shooting
-Common Error Messages
-Error Flags
-The IFERROR Function

Excel

Course 1C: Working with Dates & Times

Course Fee:  Members: $ 0  /  Non-members: $ 175
Course Length:  3 hours

Get a handle on dates and times in Excel—without the confusion. This course walks you through the basics like serial numbers and then dives into a variety of built-in Date and Time functions that help you work smarter with schedules, timelines, and more.
 

Dates & Times

Tue Aug 25, 2026 (9am to 12pm)
Thu Nov 19, 2026 (1:30pm to 4:30pm)

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

Course Manual
PDF Course Reference Manual Included

Course Topics

Knowledge of Course 1B topics is required for this course.

Entering Dates & Times
-Entering Dates & Times Properly
-Date/Time Formats and Custom Formats
-Understanding Date/Time Serial Numbers
-Using Fill with Dates or Times
-Today’s Date (Static and Dynamic)
-Current Time (Static and Dynamic)
 
Date Formulas/Functions
-Numbers of Days or Years Between Dates
-The Importance of DATE Function
-YEAR, MONTH, DAY, DAYS
-EDATE, EOMONTH
-WEEKDAY, WEEKNUM, ISOWEEKNUM,
-WORKDAY, NETWORKDAYS
-YEARFRAC
-DATEDIF
 
Time Formulas/Functions
-Create a Time Sheet to Calculate Hours
-TIME, HOUR, MINUTE, SECOND
Excel

Course 2A: Format & Validation Rules

Course Fee:  Members: $ 0  /  Non-members: $ 175
Course Length:  3 hours

Conditional Formatting and Data Validation aren’t just nice-to-haves—they’re must-know tools in Excel. This course helps you use them to spot patterns, highlight key info, and keep your data clean, accurate, and easy to manage.

Dates & Times

Fri Oct 23, 2026 (9am to 12pm)

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

Course Manual
PDF Course Reference Manual Included

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
-Conditional Formatting with Checkboxes

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
 
Excel

Course 2B: Working with a Database

Course Fee:  Members: $ 0  /  Non-members: $ 175
Course Length:  3 hours

Learn how to manage data like a pro in this course. We cover the essentials of building a solid database, sorting and filtering like a champ, and getting the most out of Tables—to keep your data organized, clean, and easy to work with.

Dates & Times

Fri Oct 2, 2026 (1:30pm to 4:30pm)

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

Course Manual
PDF Course Reference Manual Included

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
-What are Custom Views and Sheet Views
 
Format as Table
-Static vs Dynamic Ranges
-Working in a Table
-Filter with Table Slicers
 
Excel

Course 2C: Printing & Sheets

Course Fee:  Members: $ 0  /  Non-members: $ 175
Course Length:  3 hours

Get comfortable with the behind-the-scenes tools that make Excel easier to use and share. In this course, you’ll learn how to set up print options, add comments and notes, move smoothly through your sheets, and protect your data with sheet and cell security.

Accordion Content

Dates & Times

Fri Sep 11, 2026 (1:30pm to 4:30pm)

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

Course Manual
PDF Course Reference Manual Included

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
Excel

Course 2D: Creating Charts

Course Fee:  Members: $ 0  /  Non-members: $ 350
Course Length:  6 hours

Learn how to create charts in Excel that actually tell a story. This course takes you from the basics to more advanced techniques, with plenty of tips and tricks to help your visuals stand out and get your message across clearly.

Accordion Content

Dates & Times

Tue Nov 10, 2026 (9am to 4pm)

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

Course Manual
PDF Course Reference Manual Included

Course Topics

Charts Basics
-Create Column/Bar/Line/Pie/Donut charts
-Select, Move & Size Charts
-Change Chart Type / Transpose
-The Chart Buttons / The Chart Tools tabs
-Printing Charts
 
Chart Settings & Formatting
-Change Data Ranges / Add Series
-Select, Move & Size Elements
-Navigate the Format Pane
-Format Chart Elements
-Add Trendlines, Error Bars, Up/Down
 
More Chart Types
-Combined Charts / Modern Bar Chart
-Waterfall Chart / Dumbbell Chart
 
Creating Effective Charts
-Convey Your Message
-Use of Colours, Elements & Objects
-Use Illustrations as Bars
-Add Text Boxes, Shapes, Icons & Pictures
 
Excel

Course 3: Using IF & VLOOKUP

Course Fee:  Members: $ 0  /  Non-members: $ 175
Course Length:  3 hours

Get the hang of two of Excel’s most powerful functions—IF and VLOOKUP—and learn how to use Range Names to make your formulas smarter and easier to manage. This course gives you practical tools to level up your data game with confidence.

Accordion Content

Dates & Times

Fri Aug 21, 2026 (1:30pm to 4:30pm)
Thu Nov 19, 2026 (9am to 12pm)

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

Course Manual
PDF Course Reference Manual Included

Course Topics

The IF Function
– IF Arguments
– Using IF
– IF with Checkboxes

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

Excel

Course 4: More Useful Formulas

Course Fee:  Members: $ 0  /  Non-members: $ 175
Course Length:  3 hours

Learn how to get quick, reliable results in Excel—without jumping through hoops. This course explores powerful tools like conditional functions, XLOOKUP, and formula linking to help you work smarter and solve complex problems with ease.

Accordion Content

Dates & Times

Fri Sep 11, 2026 (9am to 12pm)
Mon Dec 7, 2026 (1:30pm to 4:30pm)

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

Course Manual
PDF Course Reference Manual Included

Course Topics

Conditional Functions
-SUMIF / SUMIFS
-COUNTIF / COUNTIFS
-AVERAGEIF / AVERAGEIFS
-MINIFS / MAXIFS
-Bonus: The SUBTOTAL Function
 
Using XLOOKUP
-XLOOKUP instead of VLOOKUP
(Knowledge of VLOOKUP required)
 
Formulas Between Sheets
-Link to a Cell on Another Sheet
-Formulas that Reference Other Sheets
-Creating 3D Formulas
 
Linking Formulas to Other Files
-Create Linking Formulas
-Working in Linked Files
-The Workbook Links Pane
Excel

Course 4A: More Lookup & Logic

Course Fee:  Members: $ 0  /  Non-members: $ 175
Course Length:  3 hours

Continue from Courses 3 and 4 and take your formula skills to the next level. This course explores a bit more depth with some of Excel’s most commonly used functions, helping you build confidence with practical techniques you can apply right away.

Accordion Content

Dates & Times

Thu Jul 30, 2026 (9am to 12pm)
Mon Nov 2, 2026 (1:30pm to 4:30pm)

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

Course Manual
PDF Course Reference Manual Included

Course Topics

Knowledge of the topics covered in Excel Course 3 and Course 4 is required for this course, which focuses on the advanced application of functions learned in those courses.

Advanced IF Function
-Nesting IF’s
-Conditional Formatting with IF
-Multiple Conditions with AND/OR
-Using Wildcards
-The IFS Function
-The SWITCH Function
 
Advanced XLOOKUP
-Automated Lookups
-TRIMRANGE and dot
-Approximate Match
-Other Argument Options
 
Conditional Functions
-Criteria Data Types
-Advanced Use Examples
 
More Range Names
-Create from Selection
-Range Name Constants
-File to File Copy
Excel

Course 5: PivotTables Part 1

Course Fee:  Members: $ 0  /  Non-members: $ 175
Course Length:  3 hours

Learn how to use PivotTables to quickly turn your data into clear, insightful reports. This course builds your skills step by step, so you can confidently organize, summarize, and analyze information like a pro.

Accordion Content

Dates & Times

Mon Sep 14, 2026 (9am to 12pm)
Fri Dec 11, 2026 (1:30pm to 4:30pm)

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

Course Manual
PDF Course Reference Manual Included

Course Topics

Create and Format a Table
– Dynamic vs Static Ranges
– Table Features

Get Started with 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.

Excel

Course 6: PivotTables Part 2

Course Fee:  Members: $ 0  /  Non-members: $ 175
Course Length:  3 hours

Build on your PivotTable know-how with practical techniques for creating customized reports and adding visual elements that make your data easier to understand—and more impactf

Accordion Content

Dates & Times

Tue Sep 22, 2026 (9am to 12pm)
Mon Dec 14, 2026 (1:30pm to 4:30pm)

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

Course Manual
PDF Course Reference Manual Included

Course Topics

Data Source & Details
-Table vs Range
-Refresh vs Refresh All
-Add PivotTable to Sheet
-Move & Copy PivotTables
-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 Multiple PivotTables
-Create PivotCharts
 
PivotTable Functions
-What are the GroupBy and PivotBy functions
 
(Knowledge of PivotTables Part 1 is required for this course)
Excel

Course 6A: Advanced PivotTables

Course Fee:  Members: $ 0  /  Non-members: $ 175
Course Length:  3 hours

Dive into the world behind the PivotTable. This course unpacks the Pivot Cache and Data Model, showing you how they work together to help you build more flexible reports and pull in data from multiple sources—all in one place.

Accordion Content

Dates & Times

Fri Sep 25, 2026 (9am to 12pm)

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

Course Manual
PDF Course Reference Manual Included

Course Topics

Setting Defaults
-Default PivotTable Options
-Default Layout
 
The Pivot Cache
-What is a Pivot Cache
-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
 
After this course, consider taking Excel Course 6B to link to external data and Course 6C to fully understand the Data Model.
Excel

Course 6B: Using Power Query

Course Fee:  Members: $ 0  /  Non-members: $ 350
Course Length:  6 hours

If you’re constantly updating spreadsheets or battling slow files packed with lookup formulas, it’s time to let Power Query do the heavy lifting. This course shows you how to connect to your source data, shape it to fit your needs, and create smart, streamlined reports like PivotTables—without all the hassle. You’ll also learn best practices for structuring data so it’s Power BI-ready, giving you a strong foundation for building interactive dashboards and reports in Power BI later.

Accordion Content

Dates & Times

Tue Oct 6, 2026 (9am to 4pm)

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

Course Manual
None

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 5). 
 
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
-Change Case
-Work with Dates
-Extract, Merge, Split
-Fill & Replace Values
-Basic Calculations
-Conditional Columns
 
Other Features
-Data Types
-Sort & Filter  
-Working with Steps
-Remove Duplicates
-Data Statistics
-Find & Fix Data Errors
Excel

Course 7: Introduction to Macros

Course Fee:  Members: $ 0  /  Non-members: $ 175
Course Length:  3 hours

Ready to save time and cut out repetitive tasks? This course teaches you how to create and tweak macros in Excel—from simple recordings to basic edits and smart ways to run and store them. It’s all about working smarter, not harder.

Accordion Content

Dates & Times

Fri Nov 13, 2026 (1:30pm to 4:30pm)

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

Course Manual
PDF Course Reference Manual Included

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

Course 7A: Intermediate Macros

Course Fee:  Members: $ 0  /  Non-members: $ 350
Course Length:  6 hours

Take a deeper dive into Excel’s VBA Editor and learn how to bring your macros to life. This course helps you go beyond basic recordings by teaching you how to modify existing macros and write custom code using VBA—so you can automate tasks and boost your productivity.

Accordion Content

Dates & Times

Wed Dec 9, 2026 (9am to 4pm)

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

Course Manual
PDF Course Reference Manual Included

Course Topics

You should already be familiar with recording macros in Excel 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
-For, Next
-The Range Object
-Intersect
-Exit a Procedure
-Display and Calculation
Excel

Course 8: Time-Saving Shortcuts

Course Fee:  Members: $ 0  /  Non-members: $ 175
Course Length:  3 hours

Boost your productivity by exploring Excel’s hidden gems—those underused features that can seriously streamline your workflow. This course highlights time-saving tools that make a real difference, with topics adjusted based on time and learner needs.

Accordion Content

Dates & Times

Mon Sep 14, 2026 (1:30pm to 4:30pm)

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

Course Manual
PDF Course Reference Manual Included

Course Topics

 
Great Features
-Show Sheets in Separate Windows
-Hyperlinks to Navigate Workbook
-Custom Number & Date Formats
-Customize the Quick Access Toolbar
-Concatenating
-Create Custom Fill Lists
-Checkboxes
-Goto Special to Select
-Cell Styles
-Data Types
-Quicker Hide Columns & Rows
-Save Filters or Print Settings
 
Quick Tips
-Trick with Absolute Referencing
-Copy Visible Cells Only
-Quick Ways to Navigate, Select & Move Data
-AutoFit Column Cell Range
-Zoom to Width of Data
-Formatting Tricks
-Quick Paste Values  
-Better than Merge Cells
-Go Back to Cell Pointer
-Copy Cell Above
-Cell Messages
-In Cell Pictures
-Focus Cell
 
(This course is for Intermediate + users, who also have a solid knowledge of basic formulas – at least the topics covered in Course 1B).
Excel

Course 8A: New Features

Course Fee:  Members: $ 0  /  Non-members: $ 175
Course Length:  3 hours

Excel 365 has added plenty of powerful new features—and this course helps you make the most of them. From adding checkboxes to building quick PivotTable reports with just one formula, you’ll discover handy tools that save time and boost productivity.

Accordion Content

Dates & Times

Fri Sep 18, 2026 (9am to 12pm)

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

Course Topics

This session is perfect for individuals with an intermediate + understanding of Excel.
 
A Quick Look at these New Functions
-GroupBy / PivotBy
-Sort
-Filter
-Unique
-XLookup
-TextBefore / TextAfter
-Let
-Lambda
 
New Features
-Checkboxes
-Focus Cell
-High Contrast Colours
-Pictures in Cells
-Stale Formulas
-Sheet Views
-Navigation
-Cell Changes
-New Shortcut Keys
-Forms Icon
-What is Python
Excel

Course 9: Cleaning Up Imported Data

Course Fee:  Members: $ 0  /  Non-members: $ 175
Course Length:  3 hours

Sharpen your data reporting skills by learning how to clean up messy spreadsheets quickly and effectively. This course teaches practical techniques to tidy your data and keep your reports accurate, efficient, and easy to manage.

Accordion Content

Dates & Times

Thu Sep 24, 2026 (9am to 12pm)

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

Course Manual
PDF Course Reference Manual Included

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 / Find / Trim / Text / Clean
– Lower / Upper / Proper
– Value / NumberValue
– Substitute / FormulaText
– The IS Functions
– TextBefore / TextAfter

Excel

Course 10: More Data Features

Course Fee:  Members: $ 0  /  Non-members: $ 175
Course Length:  3 hours

Boost your Excel game with practical skills in advanced filtering, grouping, and consolidating. This course shows you how to shape and organize your data for clear, accurate results—without the extra hassle.

Accordion Content

Dates & Times

Wed Sep 16, 2026 (9am to 12pm)

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

Course Manual
PDF Course Reference Manual Included

Course Topics

Advanced Filter
– Filter vs. Advanced Filter
– Criteria, List and Output Ranges
– Simple and Formula‐based Criteria
– Performing a Filter
– Using OR Conditions
– 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

Excel

Course 11: Dynamic Arrays - Part 1

Course Fee:  Members: $ 0  /  Non-members: $ 175
Course Length:  3 hours

This course is essential for every Excel user today. With Excel’s new Calculation Engine and Dynamic Arrays at the heart of many modern functions, you’ll learn how to work faster, smarter, and more efficiently—without getting lost in complexity. It’s the update everyone should understand.

Accordion Content

Dates & Times

Fri Sep 4, 2026 (1:30pm to 4:30pm)
Mon Dec 7, 2026 (9am to 12pm)

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

Course Manual
PDF Course Reference Manual Included

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.
 
Arrays
– What is an Array
– Old CSE Arrays vs DA Arrays
– How to “Spill” a Formula
– The #SPILL! Error
  
Dynamic Reports
– Creating Reports with DA Functions
– Creating Dynamic Charts
 
Dynamic Array Functions
– Sort
– Filter
– Unique
– Sequence
– GroupBy
– PivotBy
– VStack / HStack
Excel

Course 11A: Dynamic Arrays - Part 2

Course Fee:  Members: $ 0  /  Non-members: $ 175
Course Length:  3 hours

This course builds on your foundation with Dynamic Arrays and introduces more practical ways to use them in everyday work. You’ll explore how they interact with other Excel tools, learn the difference between regular and array formulas, and try out new functions like TRIMRANGE to help you shape your data faster and easier.

Accordion Content

Dates & Times

Thu Oct 22, 2026 (9am to 12pm)

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

Course Manual
PDF Course Reference Manual Included

Course Topics

You must know the topics in Course 11 before taking this course.

Dynamic Arrays
– Implicit Intersection
– Compatibility with other Features
– Forward & Backward Compatibility
– Array Constants
– DA Formulas with Regular Functions
 
Array Functions
– SUMPRODUCT vs SUM
– TRANSPOSE & FREQUENCY Now Easy
 
Dynamic Array Functions
– SortBy
– RandArray
– TextSplit  
– Expand
– ToRow / ToCol
– WrapRows / WrapCols
– ArrayToText
– Take / Drop
– ChooseRows / ChooseCols
– TrimRange
 
Excel

Course 12: Advanced Formulas

Course Fee:  Members: $ 0  /  Non-members: $ 175
Course Length:  3 hours

This course is designed for experienced Excel users who regularly work with formulas and want to take them further. You’ll explore advanced functions such as INDIRECT, LET, and LAMBDA, along with techniques for working with relative references, dynamic logic, and named ranges. The course also focuses on how formulas behave—covering topics such as recalculation, volatile functions, performance considerations, and writing clearer, more maintainable formulas.

Accordion Content

Dates & Times

Tue Nov 24, 2026 (1:30pm to 4:30pm)

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

Course Manual
PDF Course Reference Manual Included

Course Topics

Participants must have an extremely strong, practical working knowledge of Excel formulas and functions, gained through regular, real‑world use. This course is not appropriate for participants whose experience with formulas is primarily recent or instructional.
 
Advanced Functions
-INDIRECT
-MOD
-ROW / ROWS
-CELL
-LET
-LAMBDA
 
Advanced Formula Techniques
-Manual Recalculation
-What are Volatiles
-Improving Performance  
-Relative Range Names
-Improving Formula Readability & Clarity
-Working Efficiently with Formulas
Excel

Course 13: Creating a Dashboard

Course Fee:  Members: $ 0  /  Non-members: $ 350
Course Length:  6 hours

Learn how to build interactive dashboards in Excel using form controls and smart design techniques. This course walks you through practical steps—from using combo boxes and checkboxes to shaping your data with formulas and charts—so you can create dashboards that are dynamic, user-friendly, and easy to maintain.

Accordion Content

Dates & Times

Mon Nov 16, 2026 (9am to 4pm)

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

Course Manual
PDF Course Reference Manual Included

Course Topics

Advanced Excel skills are required, including a strong working knowledge of dynamic array formulas (Excel Course 11) and the ability to confidently create and format charts in Excel. While full knowledge of Excel Course 2D is not required, familiarity with its core charting concepts is needed.

Using Form Controls
Combo Boxes
List Boxes
Scroll Bars
Option Buttons
Check Boxes

Data Preparation
Dynamic Array Formulas to Summarize Data
Build Charts

Creating a Dashboard
Interactive Charts with Form Controls
Data Selection Form Controls
Text Boxes with Linked Formulas
Create Scrolling Tables
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. 

Accordion Content

Pick a Standard Excel Course

You can select any of the 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 — Lead Instructor

Does Your Team Need Excel Training?

Most Excel users spend far longer than they need to on everyday tasks—sometimes hours on work that should take minutes. Why? Because most people are self-taught and have gaps in their knowledge that slow them down.

Understanding Excel is essential in today’s workplace. With professional Microsoft Excel training from GUMP, your team will master the fastest, most efficient techniques to get the job done—freeing up valuable time for the work that really matters.

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

Live Instruction In Person & Virtual

Unlock your team’s potential with our LIVE Instructor-led training. Private courses, held in-person or virtually over Zoom, cater to your team’s specific needs. Individuals can join our virtual Public courses exclusively on Zoom for a dynamic learning experience. Elevate your skills with us – choose LIVE training for exceptional results.

Toronto / Mississauga (GTA/Southern Ontario)

Elevate your team’s capabilities with tailored, in-person training right at your doorstep in southern Ontario. Whether you’re in Toronto, Mississauga, Oakville, Burlington, Markham, Oshawa, Newmarket, or beyond, our expert instructors bring the learning experience directly to your office. Maximize convenience and effectiveness—empower your team with personalized in-person training in the heart of southern Ontario.

Private Team Training
& Public Courses

Elevate your team’s skills with our flexible hands-on training solutions. Choose private sessions tailored to your needs, conducted either in-person at your office or seamlessly over Zoom. Dive into our dynamic public courses, accessible to everyone and delivered virtually via Zoom. Join us in empowering growth, wherever you are on your application knowledge journey.