GET A QUOTE

Boost Your Team's Performance
With Microsoft Excel Training

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 four standard courses shown below.

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.

LEVEL 1: Creating Spreadsheets

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

LEVEL 2: Expand Your Knowledge

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:

Full Course Outline

LEVEL 3A: Working With Formulas

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
A Quick Look at Some Useful Functions
Date and Time Functions
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

Full Course Outline

LEVEL 3B: Pivot Tables & Managing Data

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

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.

What you will learn:

Create and Format a Table
Group, Outline & Subtotals
Basic to Advanced Pivot Tables
Customize the Ribbon
Introduction to Macros

Full Course Outline

Build Your Own Course

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

Our Professional Instructors Are
Dedicated To Helping Your Team Succeed

We understand
adult learning

Our instructors explain topics and concepts clearly for learners of all ages. We know all of the common mistakes, concerns, questions, and problems and we address them before they happen.

We make
learning fun

Say goodbye to training sessions that are dull and boring. We keep participants engaged by making training sessions interesting and fun, and by including activate participation by the group.

We know
Excel

Our instructors have worked with Excel in virtually every job and industry. We provide the knowledge and the tools to use every Excel feature with confidence and can deviate from a set outline to cover any topic or question raised in a class.

We match the right Instructor to your organization’s culture

Different companies have different requirements. We consider your organization's culture and send the right instructor that matches your company's needs.

We tailor the
training to each group

No two groups are alike, so following a script does not work. We assess the skill level of each group and tailor our course topics to help them learn. We also include valuable time‑saving shortcuts in every course.

We provide
quality reference
manuals

Learning does not end after the course is complete. We provide each person with a reference manual that contains in-depth information about each topic covered, exercises to try after the course and lots of tips and tricks.

Previous

Next

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. All at no charge.

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

What Our Customers Are Saying

I am very happy with the SharePoint training we received from GUMP Training. They were very professional and reworked the program to suit our needs. The attendees all had different experiences and needs and the trainer did a wonderful job making sure everyone got what they needed.

GUMP Training was an absolute pleasure to work with! We are so pleased we chose them as our training provider for our recent Excel Training. GUMP was able to custom design a training course that met the needs and goals of our organization. Our trainer was easy to learn from, and adapted well to different audiences and learning styles. I would highly recommend GUMP for your next training!

Our Administrative team had GUMP Training Services come to teach the level two Microsoft Access course recently and found it very beneficial. We had a wonderful instructor, who was very knowledgeable and fun to work with. The course was very well organized, as was the training manual. The hands-on experience and practice time really let us dive into the program to see how everything worked. I would certainly have GUMP back to teach again!

I cannot believe how far our company has come in achieving IT projects in the last few months, thanks to the SharePoint courses and work flow consultation GUMP Training has provided us. Your responses were always promptly on time and the training we received was tailored to our exact needs. The instructor was wonderful at explaining concepts and getting us started with our SharePoint sites. We would definitely recommend GUMP Training. Thanks!

Since 2002 GUMP has provided training for York Support Services Network. We have always been impressed with the quality and preparation of the trainers who lead the classes as well as the very thorough content coverage and supporting materials that are provided. We will not hesitate to use GUMP for our future training needs.

The Town of Collingwood uses GUMP Training for onsite MS Office training. The trainers are personable, knowledgeable, and the sessions are not only easy to follow, understand, and retain, but also fun! Our staff has varying levels of familiarity with MS Office, and the trainers are accommodating to all participants and ensure that everyone leaves a session feeling comfortable with their new knowledge and skills.

We had 4 participants in our session, all of whom were feeling the stress of having to be a part of the session. The stress quickly subsided as we carried on in the day and each participant started to realize how they were going to be able to reduce their frustrations by using Excel properly while using the new tools being taught. All participants ended the day feeling it was very much worth their while and want to work with GUMP again.

Previous

Next

Frequently Asked Questions

Q: What kind of room do I need for the training?

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.

Q: How many people can be trained at once?

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.

Q: Does everyone need a computer?

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.

Q: Can courses be customized?

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.

Q: Do you offer discounts?

Yes. We offer discounts for groups of 6 or more and for multiple training days. Please contact us for details.

Q: Can we come to you for training?

No, we do not have training facilities. Training takes place at your office, in your company meeting room.

Q: Where is your training center located?

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

Q: Do you offer training to companies only?

Yes. We are a corporate training company. We provide training to both private and public sector organizations.

Q: When do you run classes?

Since we bring the training to you, we do not have pre-set dates. The dates are completely up to you.

Q: How long are your courses?

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