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

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

Excel Power Query makes transforming and cleaning up data a breeze. By using Conditional Columns and Excel Power Query Fill Command...

Microsoft Excel is full of keyboard shortcuts that will speed up your production. Below is a link to the Microsoft site with loads of...

Microsoft Excel is full of keyboard shortcuts that will speed up your production. Below is a link to the Microsoft site with loads of...

Microsoft announced a brand new function for Microsoft Excel called the XLOOKUP(). This function provides an enhanced method of looking...

(Watch the video for a demonstration) The Microsoft Excel function, SUM, is the most used function in all of Excel. We typically use the...

Experience true Excel power by using Microsoft Excels Power Query (GET AND TRANSFORM - Excel 2016+) feature. In this video I will...