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

Microsoft Excel Courses

Master Excel like a Pro with Our Expert-Led Courses

Are you in search of an exceptional Excel training provider that stands out from the competition? Look no further! Our company is the perfect choice for your Excel training needs.

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 22 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 online public courses, available to all, are priced at $175 per person. These courses are conducted live, ensuring full interactivity. You have the opportunity to engage with the instructor throughout the 3 ½-hour session over Zoom, either through direct conversation or the chat feature.

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.

22 Excel Courses

ezgif.com-webp-to-png

Course 1A: Getting Started

$ 175 per person / 3 ½ hours

Start fresh and build a file from the beginning. This course is tailored for individuals who are new to Excel, seeking a recap of the fundamentals, or aiming to enhance their proficiency and confidence in using Excel.

Dates & Times

Mon Mar 4, 2024 (9am to 12:30pm)
Tue May 21, 2024 (1:30pm to 5pm)
Mon Sep 9, 2024 (9am to 12:30pm)
Mon Dec 2, 2024 (1:30pm to 5pm)

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

$ 175 per person / 3 ½ hours

This course comprehensively covers all the essential aspects of formulas: operators, the order of operations, utilization of built-in functions, and a clear grasp of relative vs. absolute cell referencing.

Dates & Times

Thu Mar 7, 2024 (9am to 12:30pm)
Mon May 27, 2024 (1:30pm to 5pm)
Wed Sep 11, 2024 (9am to 12:30pm)
Wed Dec 4, 2024 (1:30pm to 5pm)

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

$ 175 per person / 3 ½ hours

Understanding Conditional Formatting and Data Validation is vital in today’s context, given their widespread use. These are highly valuable features in Excel that can significantly enhance your data management capabilities.

Dates & Times

Wed Mar 13, 2024 (9am to 12:30pm)
Tue Jun 18, 2024 (9am to 12:30pm)
Thu Sep 12, 2024 (1:30pm to 5pm)
Mon Dec 9, 2024 (9am to 12: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 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

$ 175 per person / 3 ½ hours

Learn the intricacies of setting up and managing database data effectively. This course covers essential topics such as establishing a valid database, mastering sorting and filtering techniques, and efficiently working with Tables.

Dates & Times

Thu May 2, 2024 (9am to 12:30pm)
Mon Aug 12, 2024 (1:30pm to 5pm)
Mon Nov 4, 2024 (9am to 12: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
 
Format as Table
-Static vs Dynamic Ranges
-Working in a Table
-Filter with Table Slicers
 
ezgif.com-webp-to-png

Course 2C: Printing & Sheets

$ 175 per person / 3 ½ hours

Acquire expertise in configuring print settings, incorporating comments and notes into cells, navigating sheets proficiently, and implementing sheet and cell protection measures.

Accordion Content

Dates & Times

Wed May 22, 2024 (1:30pm to 5pm)
Tue Aug 20, 2024 (9am to 12:30pm)
Thu Nov 7, 2024 (1:30pm to 5pm)

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
ezgif.com-webp-to-png

Course 2D: Creating Charts

$ 175 per person / 3 ½ hours

Master the art of crafting charts in Excel, progressing seamlessly from fundamental techniques to advanced strategies and insider tips.

Accordion Content

Dates & Times

Thu May 23, 2024 (9am to 12:30pm)
Fri Aug 23, 2024 (1:30pm to 5pm)
Thu Nov 21, 2024 (9am to 12:30pm)

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

$ 175 per person / 3 ½ hours

Acquire proficiency in harnessing the power of two of Excel’s most sought-after functions – IF and VLOOKUP. This course also delves into the versatile feature of Range Names, amplifying the utility of your formulas.

Accordion Content

Dates & Times

Tue Jun 25, 2024 (1:30pm to 5pm)
Fri Sep 13, 2024 (9am to 12:30pm)
Tue Dec 10, 2024 (1:30pm to 5pm)

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
– 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 XLOOKUP Function (Excel 365)?

ezgif.com-webp-to-png

Course 4: More Useful Formulas

$ 175 per person / 3 ½ hours

Perfect the skill of swiftly generating results that might otherwise be challenging or time-consuming with alternative methods. Explore the efficiency of conditional functions, INDEX MATCH, XLOOKUP, and the intricacies of linking formulas.

Accordion Content

Dates & Times

Tue Mar 19, 2024 (1:30pm to 5pm)
Thu Jun 27, 2024 (9am to 12:30pm)
Tue Sep 24, 2024 (1:30pm to 5pm)
Thu Dec 12, 2024 (9am to 12: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
-MINIF / MAXIF (Excel 365/2019)
 
Linking Formulas to Other Sheets
-Link Cells
-Link Formulas
-Link 3D Formulas
 
Linking Formulas to Other Files
-Create Linking Formulas
-Edit Links Dialog Box / Pane
-Finding Links in a File
 
Using INDEX MATCH & XLOOKUP
-XLOOKUP (365)
-INDEX / MATCH / XMATCH (365)
-MATCH with VLOOKUP
-VLOOKUP, XLOOKUP, or INDEX MATCH?
(Knowledge of VLOOKUP required)
ezgif.com-webp-to-png

Course 5: PivotTables Part 1

$ 175 per person / 3 ½ hours

Master the art of producing insightful reports swiftly using PivotTables. Gain confidence in building them to enhance your Excel skills.

Accordion Content

Dates & Times

Fri Mar 8, 2024 (1:30pm to 5pm)
Mon Jun 17, 2024 (9am to 12:30pm)
Tue Sep 10, 2024 (9am to 12:30pm)
Tue Dec 3, 2024 (1:30pm to 5pm)

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

$ 175 per person / 3 ½ hours

Elevate your PivotTable proficiency! Learn advanced techniques to create reports tailored to your needs, complete with impressive visuals.

Accordion Content

Dates & Times

Thu Mar 14, 2024 (9am to 12:30pm)
Wed Jun 26, 2024 (1:30pm to 5pm)
Tue Sep 24, 2024 (9am to 12:30pm)
Thu Dec 12, 2024 (1:30pm to 5pm)

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 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
 
(Knowledge of PivotTables Part 1 is required for this course)
ezgif.com-webp-to-png

Course 6A: Advanced PivotTables

$ 175 per person / 3 ½ hours

This course delves into advanced PivotTable concepts, unveiling the significance of the Pivot Cache and Data Model. Mastery of these elements empowers you to craft highly customized PivotTables and seamlessly connect multiple datasets within a single PivotTable.

Accordion Content

Dates & Times

Mon Jun 17, 2024 (1:30pm to 5pm)
Mon Nov 18, 2024 (9am to 12:30pm)

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

$ 175 per person / 3 ½ hours

If you find yourself frequently updating or appending datasets, or grappling with sluggish files laden with lookup formulas, it’s high time to harness the power of Excel’s Power Query. Discover how to seamlessly link to source data, mold it to your specifications, and generate insightful reports, such as PivotTables.

Accordion Content

Dates & Times

Mon Aug 19, 2024 (9am to 12:30pm)

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 2B and 5).  Knowledge of Course 6 and 6A is helpful, but not required.
 
NOTE: The topics listed are comprehensive for a full-day session; however, in this half-day course, coverage will be based on available time.
 
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

$ 175 per person / 3 ½ hours

Master the intricacies of Excel’s Power Pivot tool to efficiently navigate the Data Model. Whether your data originates from Excel files or other sources, this course empowers you to grasp relationships fully and construct adaptable PivotTable formulas using the DAX language.

Accordion Content

Dates & Times

Tue Oct 15, 2024 (1:30pm to 5pm)

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

$ 175 per person / 3 ½ hours

Unlock greater efficiency by mastering macros. This course guides you through recording macros, basic macro editing, and diverse methods for running and storing macros.

Accordion Content

Dates & Times

Fri May 24, 2024 (9am to 12:30pm)
Wed Aug 14, 2024 (1:30pm to 5pm)
Wed Nov 6, 2024 (9am to 12: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.
ezgif.com-webp-to-png

Course 7A: Intermediate Macros

$ 175 per person / 3 ½ hours

Explore the VBA Editor in-depth with this course. Gain proficiency in modifying recorded macros and creating customized ones using VBA to execute actions beyond recording capabilities.

Accordion Content

Dates & Times

Fri Jun 28, 2024 (1:30pm to 5pm)
Tue Oct 29, 2024 (9am to 12:30pm)

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 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
-The Range Object
-Intersect
-Exit a Procedure
-Display and Calculation
 
Note: This course serves as an introduction to VBA. Achieving a comprehensive understanding of VBA requires more than a half-day session.
ezgif.com-webp-to-png

Course 8: Time-Saving Shortcuts

$ 175 per person / 3 ½ hours

Uncover the secrets to heightened productivity with this course. Delve into the often overlooked yet powerful time-saving features that will transform your workflow significantly. Topics covered as time permits.

Accordion Content

Dates & Times

Tue May 28, 2024 (9am to 12:30pm)
Tue Sep 10, 2024 (1:30pm to 5pm)
Mon Dec 2, 2024 (9am to 12: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
-Check Boxes in Cells
-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  
-Don’t Merge Cells!
-Go Back to Cell Pointer
-Copy Cell Above
-Cell Messages
-In Cell Pictures
 
(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

$ 175 per person / 3 ½ hours

Perfect your data reporting in Excel by mastering efficient data cleanup techniques. This course equips you with the skills to streamline and optimize your reporting process.

Accordion Content

Dates & Times

Wed Jun 19, 2024 (1:30pm to 5pm)
Fri Oct 25, 2024 (9am to 12:30pm)

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 / Trim / Text / Clean
– Lower / Upper / Proper
– Value / NumberValue
– Substitute / FormulaText

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

Course 10: More Data Features

$ 175 per person / 3 ½ hours

Refine your Excel skills with this course, exploring three powerful features—advanced filtering, grouping, and consolidating. Learn to effortlessly manipulate data for the precise results you seek.

Accordion Content

Dates & Times

Tue Apr 9, 2024 (9am to 12:30pm)
Wed Jul 17, 2024 (1:30pm to 5pm)
Fri Oct 11, 2024 (1:30pm to 5pm)

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
– 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 - Part 1

$ 175 per person / 3 ½ hours

Explore the transformative power of the new Calculation Engine in Excel—its most significant formula change to date. Dynamic Arrays empower you to swiftly achieve results that were once challenging and time-consuming.

Accordion Content

Dates & Times

Fri Mar 22, 2024 (9am to 12:30pm)
Mon Jul 8, 2024 (1:30pm to 5pm)
Thu Oct 10, 2024 (9am to 12:30pm)

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
– Implicit Intersection
– Compatibility with other Features
– Forward & Backward Compatibility
– Array Constants
 
Array Functions
– SUMPRODUCT vs SUM
– TRANSPOSE & FREQUENCY Now Easy
 
Dynamic Array Functions
– Sort
– Filter
– Unique
– Sequence
ezgif.com-webp-to-png

Course 11A: Dynamic Arrays - Part 2

$ 175 per person / 3 ½ hours

Discover the art of crafting fully dynamic reports with advanced Dynamic Array functions. Building on the foundation laid in Course 11, this session explores more intricate and powerful techniques.
Accordion Content

Dates & Times

Wed Jul 10, 2024 (1:30pm to 5pm)
Fri Nov 8, 2024 (1:30pm to 5pm)

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 Array Functions
– SortBy
– Advanced Criteria using Filter
– RandArray
– TextSplit  
– VStack / HStack  
– Expand
– ToRow / ToCol
– WrapRows / WrapCols
– Take / Drop
– ChooseRows / ChooseCols
 
Dynamic Reports
– Creating Reports with DA Functions
– Creating Dynamic Charts
ezgif.com-webp-to-png

Course 12: Advanced Formulas

$ 175 per person / 3 ½ hours

In this Excel 365 course, unlock the potential of advanced functions and gain insights into the impact of specific formulas and range names on your workbooks.

Accordion Content

Dates & Times

Wed Apr 3, 2024 (1:30pm to 5pm)
Thu Jul 25, 2024 (9am to 12:30pm)
Thu Oct 24, 2024 (1:30pm to 5pm)

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, as well as the concept of Dynamic Arrays covered in course 11. 

Functions Covered
-INDIRECT
-OFFSET
-MOD
-ROW / ROWS
-COLUMN / COLUMNS
-SHEET / SHEETS
-TEXTBEFORE / TEXTAFTER
-TEXTJOIN / ARRAYTOTEXT
-CELL
-LAMBDA
-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

$ 175 per person / 3 ½ hours

In this Excel 365 course, master the art of crafting interactive dashboards with form controls, enhancing your data visualization skills.
 
Accordion Content

Dates & Times

Fri Apr 19, 2024 (9am to 12:30pm)
Thu Jul 18, 2024 (1:30pm to 5pm)
Mon Oct 28, 2024 (9am to 12:30pm)

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

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?

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

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