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

Determining the Median and Mode Sometimes determining the average is not sufficient. For example, if ...