Microsoft excel courses PK2



Live Webinar Style Training During COVID-19 Crisis

  • Live Instructor-led 2 hour sessions available in April
  • These are interactive sessions where you can ask Instructor questions or use chat
  • Follow along with the exercise files we provide or just watch
  • Session recording included so you can re-watch the webinar later
  • PDF Quick Reference Included
  • Course Fees as low as $ 25 each

Boost Your Team's Performance With Microsoft Excel Training in Toronto and Surrounding Areas

At Gump, we bring the training to you with live, in-person courses led by our career professional instructors.  Build your own completely tailored Excel course (including customized course reference manuals), or choose from one of our standard courses shown below.

Our Microsoft Excel Training takes place in your company meeting room, on the dates that work best for your team.  Courses are hands-on, using your computers or our laptops.

1 day of training at your office, reference manuals and 30 days of technical support

Whether you’ve never touched Excel in your life, or you’ve been using it for years and are self-taught, this course starts from the beginning, filling in those self-taught gaps along the way.  By the end of the day, you will find you have learned many time-saving shortcuts that will make you far more efficient in Excel.

You will learn:

  • 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 

Full Course Outline

1 day of training at your office, reference manuals and 30 days of technical support

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.

What you will learn:

  • 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

Full Course Outline

1 day of training at your office, reference manuals and 30 days of technical support

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.

What you will learn:

  • Absolute Formulas
  • Range Names in Formulas
  • The IF Function
  • Conditional Functions (SumIf, CountIf, etc.)
  • The VLOOKUP Function
  • Multiple Sheet/File Formulas
  • Concatenating
  • Protecting Formulas
  • Mapping Formulas with Auditing
  • Trouble Shooting Errors

Full Course Outline

1 day of training at your office, reference manuals and 30 days of technical support

Ever wonder “what the heck is a PivotTable, 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.

Course Topics:

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

Full Course Outline

1 day of training at your office, reference manuals and 30 days of technical support

Once you’re learned how to work with formulas and databases, it’s time to learn some of Excel’s more useful features.

  • Learn how to get started with macros so you can start automating repetitive tasks and gain a basic understanding of VBA.
  • Learn how to control nearly any setting in Excel so new workbooks start the way you want, the Ribbon and Quick Access Toolbar are set the way you want, and sheet formatting is made easy with styles.
  • 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.

Course Topics:

  • 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

Full Course Outline

1 day of training at your office, reference manuals and 30 days of technical support

On Dec 3, 2019 Microsoft released a significant update to monthly subscribers of Office 365 ‐ a new Calculation Engine, called Dynamic Arrays. This is by far the biggest change ever made to Excel formulas.

This 1‐day course looks at this change and how it impacts your use of Excel.  Once you understand Dynamic Arrays you will want to use them right away.  Dynamic Arrays allow you to quickly and easily produce results that were difficult or time‐consuming using the old‐style formulas (now referred to a Legacy Formulas).

The new calculation engine produces a formula spill effect and contains 6 new Dynamic Array functions. By the end of the day, you will understand the new engine and will even be able to quickly produce beautiful interactive dashboard‐style reports.

This course is not for novice Excel users. It is intended for intermediate and advanced Excel users who are most impacted by this change. You should already be familiar with basic formulas and functions such as SUM, COUNT, IF and VLOOKUP, etc. and relative vs. absolute cell referencing.

Course Topics:

  • Overview of Arrays
  • Dynamic Array Spill
  • New Dynamic Array Functions
  • Impact on Formulas
  • Understanding Array Constants
  • Interactive Reports Made Easy

Full Course Outline

1 day of training at your office, reference manuals and 30 days of technical support

Our build‑your‑own‑course program provides the ultimate level of flexibility to ensure your team gets the most out of their training. Simply mix‑and‑match any of the topics from our Master Topic List. Each section shows the approximate time required in minutes or hours. A full day course is 6 hours (360 minutes).

Build-your-own courses include a customized reference manual for each person featuring your selected topics, and the same 30 days of technical support as our standard offerings.

Master Topic List (PDF)

Does Your Team Need Excel Training?

Understanding Excel is essential for nearly everyone in the workplace today.  But did you know that most people are ‘self-taught’ and that means they likely have gaps in their knowledge that are causing 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 so they can free up their valuable time for more important tasks.

Most Excel users spend up to 10X longer than necessary to complete tasks

Basic computer course

Choose The Company With 30 Years Of Experience & Top Industry Instructors

At Gump Training, our instructors are all career professionals with extensive corporate training experience. We pride ourselves on having the best instructors in the industry and our loyal clients are proof that our training solutions work. That's why we’re still here after 30 years.

Our Professional Instructors Are
Dedicated To Helping Your Team Succeed With
Our Microsoft Excel Training in Toronto and Surrounding Areas

Get Started With Our Training Assessment

Ensure you choose the right course for your team by using our free Excel training assessment. This fillable form will show you what each person already knows in Excel and the features they would like to learn more about. We can evaluate the results and work with you to select the right standard course level, or build the right custom course for your team.

Quick Tips in Excel

What Our Customers Are Saying

Frequently Asked Questions

A private meeting room with enough space for each person attending and a TV or Projector for the Instructor to use. Some classes also require connection to the internet.
The ideal class size is up to 10 people. We can teach as many as 15, but more than that is simply too many people to provide enough personal attention. Also, as the class size increases, the amount of material that can be covered decreases. We cover topics at the pace of the group – we never leave anyone behind.
Yes! This is essential. To be successful, the training session must be hands-on, with no computer sharing. If you do not have enough (or any) computers available for training, we can bring in laptops for a fee of $ 50 /ea.
Yes. Our “build your own” course program is an entirely new approach to customized training. Simply send us your list of topics or choose from our ‘Master List’ and we will work with you to create a full‑day course that matches your team’s exact needs. Each “build your own” course also includes custom reference manuals tailored to your specific curriculum.
Yes. We offer discounts for groups of 6 or more and for multiple training days. Please contact us for details.
No, we do not have training facilities. Training takes place at your office, in your company meeting room.

We do not have a training center location. Our Instructors travel to you to teach your team at your office – anywhere in the Toronto GTA and most Southern Ontario locations.

Yes. We are a corporate training company. We provide training to both private and public sector organizations.
Since we bring the training to you, we do not have pre-set dates. The dates are completely up to you.
Most standard courses are a full day in length, from 9am to 4pm (6 hours of training). For custom training, the course length is up to you; however, our minimum rate is a full day. If you are looking for courses that are less than a full day, we can run multiple classes in a single day – e.g. two half-day classes, or three two-hour classes, etc.

Gain Confidence In Your Technology