Excel Course Files
Use tab to navigate through the menu items.
LIVE QA ON MICROSOFT EXCEL - June 24th, 2020
LIVE QA ON MICROSOFT EXCEL
Microsoft Excel Power Query Cleaning Nested Data with Conditional Columns and Fill Command
Windows Task Scheduler
WOW!!! New Microsoft Excel Functions Coming Soon
Microsoft recently announced a handful of new Microsoft Excel Functions. And, they are blowing my mind!! "Note: September 24, 2018: The...
AND THE WINNERS ARE...
HAPPY THANKSGIVING! What better way to finish up a contest then to celebrate by giving thanks. I want to thank everyone that has been...
Become a Microsoft Office Specialist (MOS)
It's time for another contest! Participating in this contest could help you on the path to becoming a Microsoft Office Specialist,...
Dynamic Charts with Excels Offset Function
Create dynamic, interactive Charts with Microsoft Excel Offset Function. What is the OFFSET() Function Description Returns a reference to...
Microsoft Excel Two Way Lookup with Index() and Match()
As many of you know, I recently released a new course on working with Advanced Excel Formulas using the built in Index() and Match()...
Update to May 2018 Course Contest
It's May 22nd, only 9 more full days to participate in the Microsoft Office Specialist Practice Exam contest. HOW TO PARTICIPATE A quick...
MAY 2018 - MOS Certification Practice Exam Contest
It's that time again. Time for another Microsoft Office Specialist Practice Exam contest. I've run a few of these contests before and...
2018 Microsoft Office Specialist Practice Exam Contest
2018 is about you! Take all the time and knowledge you invest learning the Microsoft Office applications and get certified and let me...
Look Up Data with Microsoft Excels INDEX(), MATCH() and MAX() Functions
The technique of NESTING Microsoft Excel functions within one another allows for more dynamic and powerful formulas. I got an excellent...
Create Dynamic Excel Formulas with the OFFSET() Function
Microsoft Excel offers many ways to work with and analyze your data. There are loads of functions to calculate and lookup data, charts to...