I recently recorded a handful of videos for my Complete Microsoft Excel course and thought I would share these videos. I've placed them...

TEXTJOIN() FUNCTION DEFINITION =TEXTJOIN(delimiter, ignore_empty, text_1, [text_2], [text_3], …) BENEFITS The TEXTJOIN function combines...

(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 announced a brand new function for Microsoft Excel called the XLOOKUP(). This function provides an enhanced method of looking...

Microsoft Excel's VLOOKUP() Function is a very popular and powerful function, but it has some limitations. In the video below, you will...

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

Microsoft recently announced a handful of new Microsoft Excel Functions. And, they are blowing my mind!! "Note: September 24, 2018: The...

Create dynamic, interactive Charts with Microsoft Excel Offset Function. What is the OFFSET() Function Description Returns a reference to...

As many of you know, I recently released a new course on working with Advanced Excel Formulas using the built in Index() and Match()...

The technique of NESTING Microsoft Excel functions within one another allows for more dynamic and powerful formulas. I got an excellent...