Register for your FREE Online Excel course today.
We're so sure you're going to love our Excel courses, that we're willing to prove it!
Courses Available
To see a complete course listing with dates, click one of the below buttons.
Please contact us to book your free test course.
Current FREE Course Offers for New Clients
Our Excel courses are live and fully interactive. Speak with the Instructor at any time during the course or use the Chat and Q&A features. Each course is 3 ½ hours in length and includes a PDF reference manual and 30 days of technical support.
Course hours are EST (Eastern Standard Time). Our Instructors are located in Toronto, Canada.
Excel Course 1B
Basic Formulas
Regular Price $ 125
Your Price $ 0
Mon Dec 6 (1:30pm to 5pm)
All the formula essentials are covered in this course: operators, the order of operations, using built-in functions, and understanding relative vs. absolute cell referencing.
Excel Course 3
Using IF & VLOOKUP
Regular Price $ 125
Your Price $ 0
Thu Dec 9 (9am to 12:30pm)
Learn how to effectively use the two most popular functions in Excel – IF and VLOOKUP. We also cover a feature called Range Names, which is incredibly useful with formulas.
The IF Function
– IF Arguments
– Using IF
– Nesting IF’s
– Multiple Conditions with AND/OR
– Conditional Formatting with IF
– The IFS Function (Excel 365/2019)
Range Names
– Why Use Range Names?
– Creating and Referencing a Range Name
– Go to a Range Name
– Edit and Delete a Range Name
The VLOOKUP Function
– What is VLOOKUP?
– VLOOKUP vs. HLOOKUP
– Using VLOOKUP
– Approximate & Exact Match
– IFNA with VLOOKUP
– What is the New XLOOKUP Function (Excel 365)?
Excel Course 5
PivotTables Part 1
Regular Price $ 125
Your Price $ 0
Mon Dec 13 (1:30pm to 5pm)
Learn how to produce meaningful reports quickly and easily by leveraging PivotTables. By the end of this session you will feel confident building PivotTables in Excel.
Create and Format a Table
– Valid Database Setup
– Create a Table
– Dynamic vs Static Ranges
– Tables with VLOOKUP, Data Validation & Charts
Get Started with a PivotTable
– What is a PivotTable?
– Creating a PivotTable
– Inside/Outside a PivotTable
– Adding Columns, Rows, Values and Filters Fields
– Moving & Removing Fields
– Applying Formatting
Working with a PivotTable
– Edit PivotTable Data
– Expand / Collapse
– Changing Report Layout
– Hide/Show/Modify Subtotals
– Hide/Show Grand Totals
– Sorting and Manual Sort
– Filtering Labels & Values
– Field Settings
– PivotTable Options
– Refresh Data
– Changing the Summary Function
– Percent, Running Totals, Ranking, etc.
Excel Course 7
Introduction to Macros
Regular Price $ 125
Your Price $ 0
Thu Nov 18 (1:30pm to 5pm)
Understanding macros will make you far more efficient. We start with the basics (recording, edit & saving) and then we’ll get you started in the visual basic programming language.
Recording Macros
– What is a Macro?
– Recording & Playing a macro
– Using Relative Referencing
– Workbook vs Personal Workbook
– Buttons & Illustrations to Run Macros
– Adding Macros to the QAT or Ribbon
– Saving and Opening Files with Macros
– Understanding the Personal Macro Workbook File
Introduction to VBA
– What is Visual Basic?
– Working in the VBA Editor
– Editing Recorded Macros
– Creating Macros that Cannot be Recorded
– Creating Macros that are Triggered by Events
Using the Following in VBA:
– With & End With
– Show Message Boxes
– Add Comments
– The IF Statement
– The Range Object
– Intersect
– Exit a Procedure
Looking for Other Courses?
This page shows our current FREE course offers for new clients, but we offer many other courses. To see a complete list, click one of the below buttons.
Register
To register for your FREE course, please complete this form.
What You Need to Attend a Course
To attend our live online courses you will need a computer (desktop or laptop), an internet connection and a web browser.
If you work with a laptop, it might be difficult to show the Instructor’s screen and work in the program at the same time, so for smaller screens, we recommend you have a second monitor or second computer.
It would be helpful if you have a microphone so you can speak during the course, but if you don’t you will still be able to ask questions and make comments using the Q&A or Chat features.
Does Your Team Need Excel Training?
Did you know that most Excel users spend up to 10x longer than necessary to complete tasks?
Understanding Excel is essential for nearly everyone in the workplace today, but most people are ‘self-taught’ and have gaps in their knowledge that cause 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 to free up their valuable time for more important tasks.