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.

Half Price Course Offer

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

ezgif.com-webp-to-png

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:

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

Register

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.

Half Price Courses

Book One or More People

Total Amount and Payment

Credit Card *
ezgif.com-webp-to-png

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:

Intermediate Topics
– 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

Advanced Topics
– 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)

ezgif.com-webp-to-png

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. 

Course Topics
-Custom Fill Lists / Custom Number Formats
-Customize the Ribbon / QAT
-Concatenating Formulas
-Setting Defaults not in Options
-Ways to use Absolutes
-Show Several Sheets Together
-Set the same Print Settings for Entire Workbook
-Save Multiple Filters or Print Settings
-Useful Quick Tips:
    -Select Formulas, Blanks, etc.
    -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.