Microsoft Excel training
at your office.

Learn from professionals in instructor‑led training.

Excel has become an essential tool for modern business. Ensure your team is ready to embrace the future with Gump Training's comprehensive one-day courses, delivered by our highly experienced instructors throughout Southern Ontario and the GTA. Choose from four standard courses, or build your own course to meet your specific needs.

Microsoft Excel training at your office.

Learn from professionals in instructor‑led training.

We travel to you.

Training delivered right to your office on a day that works best for your team.

Hands-on experience.

Professional instruction, lots of practise time, and solutions for your Excel concerns.

No computers? No problem.

If you're short on computers, we will gladly supply a laptop for each person.

Everything you need to succeed.

Fill out our free assessment and we will determine the right course content for your team.

Excel has become an essential tool for modern business. Ensure your team is ready to embrace the future with Gump Training's comprehensive one-day courses, delivered by our highly experienced instructors throughout Southern Ontario and the GTA. Choose from four standard courses, or build your own course to meet your specific needs.


Standard Excel Courses

1 day of training, reference manuals and 30 days of technical support: $ 250 / person

Minimum charge of 3 people. Discounts available for groups of 6 or more.

Level 1

Creating Spreadsheets

Learn all of the basics, from creating your own spreadsheets to adding formulas and applying formatting. You'll also learn time‑saving tips to maximize your efficiency. No prior Excel knowledge required.

Learn more ›

Level 2

Expand Your Knowledge

Build upon your basic knowledge with multi‑page spreadsheets, then create beautiful charts/graphics, and set up automatic formatting based on changing data.

Learn more ›

Level 3

Working with Formulas

Multiply your knowledge of formulas, and common functions like IF and VLOOKUP.

Learn more ›

- or -

Pivot Tables & Managing Data

Master pivot tables, the hottest Excel topic today, and other database techniques.

Learn more ›

Build your own custom course.

Have specific needs, or just want a more personalized experience? Simply send us your list of topics or pick from our comprehensive list and we will work with you to create a full-day course. Mix‑and‑match beginner, intermediate, and advanced topics to ensure every person gains valuable knowledge.

Every "build your own course" includes a customized reference manual featuring your topics, and the same 30 days of technical support as our standard offerings.

      $ 275 / person

Minimum charge of 4 people. Discounts available for groups of 6 or more.

$ 275 / person

Minimum charge of 4 people. Discounts available for groups of 6 or more.

Level 1: Creating spreadsheets

1 day of training, reference manuals and 30 days of technical support: $ 250 / person (discounts available)

Whether you've never touched Excel in your life, or you've only used spreadsheets created by others, this course will cure that Excel phobia and get you well on your way to being a pro. By the end of the day you will know how to create your own spreadsheets, add text & data, and make it all look pretty.

  

  • Worksheet entries

  • Rules for entering data
  • Deleting cell contents
  • Editing cell entries
  • Moving around a worksheet
  • Selecting cells (shortcuts)
  • Formulas

  • Entering a basic formula
  • Operators
  • Using functions for sum & average
  • Intro to Quick Analysis
  • Spreadsheet formatting

  • Setting column widths
  • Setting row heights
  • Choosing number formats
  • Date formats & custom date formats
  • Setting decimal places, negative display
  • Aligning entries in cells - left, centre, right
  • Centering a heading
  • Using Paste Special
  • Copy, move, & fill

  • Drag & Drop
  • Clipboard Cut, Copy, & Paste
  • Using Paste Special
  • Using Fill to automate entering months, days, numbers, and to copy formulas
  • Flash Fill
  • Inserting & deleting

  • Columns
  • Rows
  • Partial columns & rows
  • Cell formatting

  • Changing fonts
  • Bold, italic, underline, font colour, etc.
  • Applying borders
  • Filling cells with colour
  • Database Overview

  • Understanding/setting up a database
  • A quick look at sorting
  • A quick look at filtering
  • Files

  • Saving & opening
  • Working in multiple files
  • Closing & creating files
  • Page setup

  • Portrait & landscape
  • Scaling
  • Paper size
  • Margins
  • Centre on page
  • Print & print preview

  • Page breaks
  • Page break preview
  • Preview
  • Print options

Level 2: Expand your knowledge

1 day of training, reference manuals and 30 days of technical support: $ 250 / person (discounts available)

Build upon your basic Excel knowledge with the power to handle large datasets and display information graphically. By the end of the day you will know 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

  • Format as table
  • The current region
  • Multiple level sorting
  • Sorting by colour/icon
  • Using Filter to extract information
  • Custom criteria
  • And vs. Or
  • Reapplying a filter
  • Clearing filters
  • Using data forms
  • Using the Subtotal function
  • Multiple sheets

  • Navigating from sheet to sheet
  • Sizing sheet display area
  • Adding, deleting, renaming sheets
  • Setting sheet tab colour
  • Moving and copying sheets
  • Hiding & unhiding sheets
  • Setting defaults for all sheets
  • Setting default number of sheets
  • Format sheet

  • Sheet background
  • Background picture
  • Split & freeze

  • Splitting a window into 2 or 4 panes
  • See widely separated areas simultaneously
  • Freezing panes
  • Removing a split or freeze
  • Multiple windows

  • Adding windows
  • Switching to windows
  • Arranging on the screen
  • Viewing windows side by side
  • Hiding windows
  • Closing all windows
  • Multiple files

  • Opening multiple files
  • Displaying multiple files
  • Closing all files
  • Find & replace

  • Finding text, values, functions
  • Replacing text or functions
  • Advanced page setup and printing

  • Headers and footers
  • Printing column and row titles
  • Printing gridlines
  • Page order
  • Review of page breaks and printing
  • Conditional formatting

  • Highlight cell rules
  • Top/bottom rules
  • Data bars, color scales, icon sets
  • Conditional formatting with quick analysis
  • Manage rules
  • Stop if true
  • Clearing rules
  • Charts (Graphs)

  • Creating and editing
  • Recommended chart
  • Formatting items in a chart
  • Chart animations
  • Chart buttons
  • Changing chart types
  • Naming charts
  • Printing charts
  • Unlinking charts from data
  • Sparklines
  • Misc

  • Using AutoCorrect
  • Using format painter to copy formats
  • Customize the Ribbon

Level 3A: Working with formulas

1 day of training, reference manuals and 30 days of technical support: $ 250 / person (discounts available)

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.

  

  • Formulas Basics

  • Creating a Basic Formula
  • Copying and Filling Formulas
  • Order of Calculation
  • Introduction to Functions

  • Using Sum & Average
  • Using AutoSum
  • Using Quick Analysis for Totals
  • Absolute Formulas

  • Relative vs Absolute
  • Full & Partial Absolute Formulas
  • Range Names in Formulas

  • How to Create a Range Name
  • Using Range Names in Formulas
  • Using Functions

  • Using Insert Functions
  • Function Icons
  • Understanding Syntax
  • An In-depth Look at These Functions

  • If, Nesting If's, And, Or
  • Vlookup, HLookup, IFNA
  • Data Validation with Vlookup/If
  • A Quick Look at These Functions

  • Count / CountA
  • Max / Min
  • Round / RoundUp / RoundDown
  • SumIf
  • Left / Mid / Right / Search
  • Lower / Upper / Proper
  • NumberValue
  • Trim / Len
  • Today / Now
  • NetworkDays / Workday
  • Date / Day / Month / Year / Weekday
  • Value / Text
  • More About Formulas

  • Transpose
  • Editing Formulas
  • Displaying Formulas
  • Reference a Single Cell
  • Concatenating Formulas
  • Converting Formulas to Values
  • Splitting Cells
  • Flash Fill
  • Manual Calculation
  • Protecting Formulas
  • Multiple Sheet/File Formulas

  • Formulas that Reference Other Sheets
  • Formulas that Reference Other Files
  • Mapping Formulas with Auditing

  • Tracing Formulas
  • Tracing Dependents and Precedents
  • Step Into a Formula
  • Watch Window
  • Text Formulas

  • Adding Text to Value Cells
  • Trouble Shooting – Error Messages in Formulas

Level 3B: Pivot tables & managing data

1 day of training, reference manuals and 30 days of technical support: $ 250 / person (discounts available)

Ever wonder "what the heck is a pivot table, and why do I always hear so much about them?" By the end of the day you will learn how to use one of Excel's most powerful - and intimidating - features to make sense of large sets of data. You will also learn other techniques for building/managing an Excel database.

  

  • Review of setting up a database

  • Format as table
  • The current region
  • Multiple level sorting
  • Sorting by colour/icon
  • Using Filter to extract information
  • Custom criteria
  • And vs. Or
  • Reapplying a filter
  • Clearing filters
  • Using data forms
  • Format as Table

  • Using The Table Tools, Design Tab
  • Filtering & Sorting with Tables
  • Format as Table Slicers for Filtering
  • Displaying Totals
  • Design Your Own Table Style
  • Advanced filter

  • Setting up the ranges
  • Performing the filter
  • Copy unique records to another location
  • Using Subtotal, Sumif/ifs, Averageif/ifs and Countif/ifs
  • Group, Outline & Subtotals

  • Grouping rows/columns on a sheet
  • Showing/hiding details in an outline
  • Display/hide outline symbols
  • Adding automatic subtotals
  • Adding other automatic analysis (Average, Count, etc)
  • Removing subtotals
  • Basic Pivot Tables

  • Creating a pivot table
  • Recommended pivot tables
  • Adding columns, rows & filters
  • Moving & removing fields
  • Adding multiple fields in an area
  • Hiding/showing data
  • Accessing tools and options
  • Refreshing data
  • Using value field settings
  • Using and creating styles
  • Advanced Pivot Tables

  • Creating and working with groups
  • Adding a timeline (2013/2016)
  • Collapse and expand fields
  • Changing report layout
  • Using subtotals and grandtotals
  • Using calculated fields
  • Using calculated items
  • Listing formulas used
  • Creating drill-downs
  • Creating report filter pages
  • Filtering pivot table fields
  • Using slicers
  • Setting pivot table options
  • Multiple consolidation ranges
  • Creating pivot charts
  • Importing data

  • From another spreadsheet
  • Paste link
  • Insert object
  • Get external data

  • Importing from Access
  • Importing text files
  • Importing from web
  • Working with connections
  • Open external files