Last Minute Course Registration 50% OFF
Half Price 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 half price course offers at the moment. Please check back again later.
Contact Us if you have a question.
Excel Course 4: More Useful Formulas
Thu Sep 24 – 9am to 12pm (EST)
** Book Now at $ 47.50 **
Learn how to quickly produce results that are difficult or time‑consuming using other methods. We look at conditional functions, index match and linking formulas. Topics Include:
– 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
– INDEX MATCH instead of VLOOKUP
– INDEX MATCH or XLOOKUP (Excel 365) ?
– Using MATCH alone
– Using INDEX alone
– Using MATCH with VLOOKUP
– Using XMATCH (Excel 365)
(Knowledge of VLOOKUP required)
To register, please complete this form.
This course is $ 47.50 per person (that’s 50% OFF the regular price of $ 95).
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.
Excel Course 6: PivotTables Part 2
Thu Aug 27 – 1pm to 4pm (EST)
Once you’ve learned the basics, it’s time to see what a PivotTable can really do! Produce reports that output exactly what you need with visuals that will impress any reader. Topics Include:
– How to Add Filter Pages
– Show Details (Drill Downs)
– Grouping Dates & Numbers
– Creating Custom Groups
– Printing Options
– Creating and Using Styles
– Defer Layout
– Creating PivotCharts
– Using Slicers & Timelines
– Setting PivotTable Default Options
– Conditional Formatting in a PivotTable
– Understanding the PivotCache
– Adding Calculated Fields
– Adding Calculated Items
– Create a Basic Dashboard
– Using GetPivotData
(Knowledge of PivotTables Part 1 is required for this course)
Course 8: Time-Saving Shortcuts
Thu Aug 20 – 1pm to 4pm (EST)
Getting the job done efficiently is everyone’s goal. This course will dramatically improve your productivity by showing you the useful time‑saving features that are hidden in plain sight.
-Go Back to Cell Pointer / Copy Cell Above
-Quick Move & Insert / Quick way to Paste Values
-Hold Multiple Items in Clipboard for Pasting
-Useful Shortcut Keys / Editing in Range Boxes
-Excluding Hidden Cells / Add Notes Inside a Formula
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.