Microsoft Excel training
at your office.

Learn from the 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 ›

View all Excel Course Outlines (PDF) ›

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.

  

  • Getting Started with Excel

  • The startup screen
  • Workbooks and sheets
  • Customize the Quick Access Toolbar
  • Using the Ribbon
  • Entering Text, Numbers & Formulas

  • Rules for entering data
  • Deleting cell contents
  • Editing cell entries
  • Moving around a worksheet
  • Selecting cells (shortcuts)
  • Using Clear
  • Using Undo and Redo
  • Formulas & SUM/AVERAGE

  • Entering a basic formula
  • Operators & order of operations
  • Using the Sum & Average functions
  • Using Number Formats

  • Choosing number formats
  • Date formats & custom date formats
  • How Excel stores dates
  • The Today and Now functions
  • Setting decimal places
  • Negative value display
  • Cell Alignment Options

  • Left, center and right
  • Vertical cell alignment
  • Centering a heading
  • Wrapping text
  • Rotating text
  • Using indent to create space
  • Columns & Rows

  • Column widths & row heights
  • Hiding and unhidng
  • Inserting and deleting
  • Cut, Copy, Paste and Paste Special

  • Drag & Drop to move or copy
  • Cut, Copy, & Paste (different in Excel)
  • Using Paste Special
  • Using Fill

  • Automate entering months, days, a series of numbers, and more
  • Using Fill to copy formulas
  • Fill options / Fill tricks
  • Using Flash Fill (2013/2016)
  • Fonts, Borders & Cell Colour

  • Changing fonts and sizes
  • Bold, italic, underline
  • Font colour & cell colour
  • Applying borders
  • Databases - Quick Overview

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

  • Saving & opening
  • Working with multiple files open
  • Closing files
  • Creating new files
  • Page Layout & Printing

  • Portrait & landscape
  • Scaling
  • Paper size
  • Margins
  • Centre on page
  • Print preview
  • Printing
  • Zooming In and Out

  • Using the zoom bar & dialog box
  • Zoom to selection
  • Optional Topics (if time permits)

  • Using AutoCorrect
  • Using Find and Replace

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. (The depth of each topic covered is tailored to the needs of the group. For example, some groups do not require an in-depth knowledge of Charts. This outline lists each topic in full detail.)

  

  • Setting up a Database

  • Proper database design
  • The current region
  • Sorting

  • Multiple level sorting
  • Sort options
  • Sort warning
  • Custom sorts & custom lists for Fill
  • Sorting by colour/icon
  • Back to original sort order
  • Filtering With AutoFilter

  • Activating filter
  • Using the search box / check marks
  • Entering custom criteria
  • Understanding arguments
  • And vs. Or
  • Filter on cell values
  • Formulas with filters
  • Reapplying a filter
  • Clearing filters
  • Using the Subtotal function
  • Saving filters (see Custom Views)
  • Split & Freeze

  • Splitting the screen into 2 or 4 panes
  • View widely separated areas simultaneously
  • Freezing panes to lock headings
  • Removing a split or freeze
  • Conditional Formatting

  • Highlight cell rules
  • Top/bottom rules
  • Data bars, color scales, icon sets
  • Using Quick Analysis (2013/2016)
  • Pre-set and custom formats
  • A trick for finding duplicates
  • More rules / new rules
  • Using manage rules
  • Clearing rules
  • 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
  • Sheet background picture
  • Protecting a Workbook
  • Multiple Windows

  • Creating & switching windows
  • View multiple sheets/multiple files
  • Arranging together on the screen
  • Hiding windows
  • Closing all windows
  • Save Workspace (2007/2010)
  • Creating Custom Views

  • Saving multiple print settings/switching
  • Saving multiple filters/displaying
  • Saving window, zoom and other settings
  • Advanced Page Setup & Printing

  • Normal, layout and page break views
  • Headers & footers and print titles
  • The Page Setup options
  • Using page breaks
  • Charts

  • Create column, bar, line & pie charts
  • Instant charts
  • Selecting, moving & sizing charts
  • Changing the chart type
  • Transposing the data
  • Chart titles & data labels
  • Printing charts
  • Quick chart layouts & chart styles
  • Selecting, moving & sizing elements
  • Formatting chart elements
  • Other Topics

  • Using format painter to copy formats
  • Customize the Ribbon (2010-2016)
  • Customize the Quick Access Toolbar

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
  • Using Functions

  • Using Sum & Average
  • Using AutoSum
  • Quick Analysis Totals (2013/2016)
  • Using Insert Function
  • The Function icons
  • Understanding Function Syntax
  • Absolute Formulas

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

  • Why use a range name
  • Range name rules
  • Different ways to create range names
  • Using Range Names in new and existing formulas
  • A Quick Look at These Functions

  • Count / CountA / CountBlank
  • Max / Min / Average
  • Round / RoundUp / RoundDown
  • SumIf
  • Left / Mid / Right / Search
  • Lower / Upper / Proper
  • Value / NumberValue (2013/2016)
  • Trim / Len
  • Entering and Formatting Dates

  • Entering dates and times properly
  • How Excel interprets dates & times
  • Formatting – pre-set and custom
  • Formulas to calculate dates or times
  • Date and Time Functions

  • Today / Now
  • Day / Month / Year / Weekday / Date
  • Edate / DateValue
  • NetworkDays / Workday
  • Value with dates
  • Days (2013/2016)
  • The IF Function

  • Quick overview
  • Rules and conditions
  • True and false
  • Using Data Validation
  • Ifs without IF
  • Nesting IF’s
  • Closing brackets
  • Multiple conditions with AND/OR
  • The VLOOKUP Function

  • Quick overview
  • Creating a lookup table
  • Using VLookup with that table
  • Numbers outside the range
  • Using IF and OR with VLookup
  • Using IFNA with VLookup (2013/2016)
  • Using Data Validation with VLookup
  • Vlookup vs. HLookup
  • More About Formulas

  • Using Transpose to flip data
  • Tips for editing formulas
  • Displaying formulas (sheet or cells)
  • Reference a single cell in a formula
  • Concatenating formulas
  • Converting formulas to values
  • Splitting one column into several
  • Flash Fill to split data (2013/2016)
  • 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
  • Error checking
  • The watch window
  • Text with Values

  • Showing text with a value
  • Performing calculations
  • Trouble Shooting – Error Messages in Formulas

  • How to fix errors
  • Error indicators

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.

  

  • Quick Review of Databases

  • Setting up a Database
  • Sorting
  • Using AutoFilter
  • Create and Format a Table

  • Why use a table and how to create one
  • Using table tools
  • Filtering & Sorting with Tables
  • Using Slicers (2013/2016)
  • Displaying Totals
  • Design Your Own Table Style
  • Group, Outline & Subtotals

  • Grouping rows/columns on a sheet
  • Showing/hiding details in an outline
  • Display/hide outline symbols
  • Creating Groups
  • Adding automatic subtotals
  • Adding other automatic analysis (Average, Count, etc)
  • Removing subtotals
  • PivotTables – Part 1

  • Proper Database Design
  • Use a Table as the Source
  • Creating a PivotTable
  • Using/Modifying the Fields List Adding Column/Rows/Values/Filters
  • Moving & Removing fields
  • Inside vs Outside the PivotTable
  • Changing Report Layout
  • Applying Basic Formatting
  • Refreshing a PivotTable
  • PivotTables – Part 1 (continued)

  • Changing the Source Range
  • Editing Database Data
  • Editing the PivotTable Data
  • Saving Formatting on Refresh
  • Undo with PivotTables
  • Grand Totals On/Off
  • Changing the Summary Function
  • Basic Filters with Filter Fields
  • Modifying the Fields List Window
  • PivotTables – Part 2

  • More About Multiple Rows/Columns
  • Changing the Field Order
  • Expanding/Collapsing
  • Showing All Items in Each Group
  • Increase/Decrease Indent
  • Blank Lines Between Groups
  • Multiple Subtotals
  • Handling Blank Values
  • Showing Details (Drill Downs)
  • The PivotTable Cache
  • Using Multiple Value Columns
  • Percent, Running Totals, Ranking, etc.
  • Using and Creating Styles
  • Move / Copy a PivotTable
  • Sorting Data
  • More About Filters
  • Data Filters
  • Creating Filter Pages
  • Hiding/Keeping Items
  • Applying Label & Value Filters
  • Creating Custom Groups
  • Grouping Dates
  • PivotTables – Part 3

  • Calculations/Formulas
  • Adding Calculated Fields
  • Adding Calculated Items
  • Listing Formulas
  • Calculations Outside the PivotTable
  • Using Conditional Formatting with Values
  • Adding Timelines (2013/2016)
  • PivotTable Slicers (2010/2013/2016)
  • Multiple Consolidation Ranges
  • Creating Pivot Charts
  • Creating a PivotTable/Chart Dashboard
  • Importing Data

  • From another spreadsheet
  • Paste link / Insert Object
  • Importing other formats such as Access, CSV, text, etc.