Flash Fill If you download data or use a lot of Text functions, Flash Fill is  a good trick to know. It is a feature that sometimes al...

Tired of Nesting IF after IF? Get off the Nest and use IFS() IFS()  is a Logical Function that can be found in Excel 2019 and Office 3...

This is a guest post from Joseph Helstrom, CPA. Adding VLookup as a Control for Your Month-End Workpapers When closing for t...

If you need to join a lot of text together in a string, check out TEXTJOIN. It   is a text function that was introduced in Excel 2016 to ...

Using Keywords to Find Your Excel Files If you have lots and lots of files, you know how difficult it can be to locate one, particularl...