Book Last Minute and Save!

Current Course Offers

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. 

There are no last minute course offers at the moment.   Please check back again later.

Contact Us if you have a question.

Current Course Offers

All 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.5 hours in length and includes a PDF reference manual and 30 days of technical support. 

ezgif.com-webp-to-png

Excel Course 4
More Useful Formulas

*** Now $ 65.40 ***

Mon Apr 19 (9am to 12:30pm)

Learn how to quickly produce results that are difficult or time‑consuming using other methods. We look at conditional functions, index match, xlookup and linking formulas.

Conditional Functions
– The Subtotal Function
– SumIf / Sumifs
– CountIf / CountIfs
– AverageIf / AverageIfs
– MinIf / Maxif (Excel 365/2019)

Linking Formulas to Other Sheets
– Link Cell/Formulas/3D Formulas

Linking Formulas to Other Files
– Create Linking Formulas
– Edit Links Dialog Box
– Finding Links in a File

Using INDEX MATCH & XLOOKUP
-INDEX MATCH & INDEX MATCH MATCH
-Using XLOOKUP (365)
-Using MATCH with VLOOKUP
-Using XMATCH (365)
-What’s Better: VLOOKUP, INDEX MATCH or XLOOKUP? 
(Knowledge of VLOOKUP required)

ezgif.com-webp-to-png

Excel Course 5
PivotTables Part 1

*** Now $ 65.40 ***

Thu Apr 22 (9am to 12:30pm)

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.

ezgif.com-webp-to-png

Excel Course 7
Introduction to Macros

*** Now $ 65.40 ***

Mon Apr 19 (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

Register

To register for a course, please complete this form.    
Each course is $ 65.40 per person (that’s 40% OFF the regular price of $ 109).
Payment must be made at time of booking.  We accept Visa, Mastercard and American Express (secure payment using Stripe).
Note: All last minute registrations are non-cancellable and non-refundable (see below).

Half Price Courses

Registrations

Summary & Payment

Credit Card *
Please read the following BEFORE you SUBMIT this registration:

All last minute course bookings are NON-CANCELLABLE and NON-REFUNDABLE. If the participant does not attend the course(s), you will be forfeiting the entire course fee paid (no alternate date selection is allowed). Substitutions are welcome, so you can have someone else take this course in place of the participant.

What You Need to Attend

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.