MICROSOFT
EXCEL
COURSES
GET A QUOTE
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
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
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
- Using INDEX MATCH
- Multiple Sheet/File Formulas
- Concatenating
- Protecting Formulas
- Mapping Formulas with Auditing
- Trouble Shooting Errors
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)
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
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
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.
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
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
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.
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
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.
Gain Confidence In Your Technology
