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
Excel LOOKUP Functions
I recently recorded a handful of videos for my Complete Microsoft Excel course and thought I would share these videos. I've placed them...
Microsoft Excel TEXTJOIN() Function
TEXTJOIN() FUNCTION DEFINITION =TEXTJOIN(delimiter, ignore_empty, text_1, [text_2], [text_3], …) BENEFITS The TEXTJOIN function combines...
Microsoft Excel Running Total with SUM and SUMIF Functions
(Watch the video for a demonstration) The Microsoft Excel function, SUM, is the most used function in all of Excel. We typically use the...
Microsoft Announces a New XLOOKUP Function for Excel
Microsoft announced a brand new function for Microsoft Excel called the XLOOKUP(). This function provides an enhanced method of looking...
Microsoft Excel VLOOKUP Function with Multiple Criteria
Microsoft Excel's VLOOKUP() Function is a very popular and powerful function, but it has some limitations. In the video below, you will...
Use Microsoft Excels Camera Tool with Formulas
Everyday I take some time to get through the questions I get in my online courses. I enjoy getting questions for a couple of reasons....
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...
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()...
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...