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

VLOOKUP versus INDEX MATCH! Which is Better? Chris Chau of Defeatexcel.com asked twenty-seven (27) Excel MVPs and community experts ...