Online Courses

Andy Lanning's Online Webinars
through 3rd party providers
(listed below by Topic, then by Date)

Pivot Tables have been a 'data summary tool' of the Excel program for over two decades, and yet they remain little understood. This short course solves the mystery... It's easier than expected! 

Excel: Pivot Tables Crash Course on Wednesday, 9 July 2025 at 10:00 AM PDT | 01:00 PM EDT

https://www.complianceiq.com/trainings/livewebinar/10880/excel-pivot-tables-crash-course?preview=1 

Excel: Pivot Tables Crash Course on Wednesday, 27 August 2025 at 10:00 AM PDT | 01:00 PM EDT

https://www.complianceiq.com/trainings/livewebinar/11157/excel-pivot-tables-crash-course?preview=1 

Excel: Pivot Tables Crash Course on Wednesday, 24 September 2025 at 10:00 AM PDT | 01:00 PM EDT

https://www.complianceiq.com/trainings/livewebinar/11159/excel-pivot-tables-crash-course?preview=1 

_______________________________________________________________

In this Excel Formulas webinar, you will learn a handful of the most useful and often used formulas in Excel. These will include: VLookup, HLookup, XLookup, Flash Fill, Text to Columns, Concatenate, and remove Duplicates, IF functions and more!

 

Excel: Useful Formulas on Thursday, 29 May 2025 at 10:00 AM PDT | 01:00 PM EDT

Excel: Useful Formulas - Wednesday, 11 June 2025 at 10:00 AM PDT | 01:00 PM EDT

Excel: Useful Formulas on Wednesday, 18 June 2025 at 10:00 AM PDT | 01:00 PM EDT

Excel: Useful Formulas on Wednesday, 16 July 2025 at 10:00 AM PDT | 01:00 PM EDT

https://www.complianceiq.com/trainings/livewebinar/10887/excel-useful-formulas?preview=1 

Excel: Useful Formulas on Wednesday, 17 September 2025 at 10:00 AM PDT | 01:00 PM EDT

https://www.complianceiq.com/trainings/livewebinar/11158/excel-useful-formulas?preview=1

_______________________________________________________________

Excel: Data Visualization (charts and data layout) will introduce the theory of looking at data with fresh eyes and mindset. It challenges the old-fashioned styles and rules. Data presentation will no longer look drab or ordinary, but instead, professional and interesting.


Excel: Data Visualization Crash Course on Wednesday, 4 June 2025 at 10:00 AM PDT | 01:00 PM EDT

_______________________________________________________________ 

Excel Power Query is a “data-clean-up” tool useful in prepping data for further Excel analysis spreadsheets.  

Excel: Power Query Intro on Wednesday, 13 August 2025 at 10:00 AM PDT | 01:00 PM EDT