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