Blog

Perform Approximate Match and Fuzzy Lookups in Excel

This post explores Excel’s lookup functions, approximate matches, fuzzy lookups, and exact matches.  The built-in Excel lookup functions, such as VLOOKUP, are amazing. When implemented in the right way for special projects or in recurring use workbooks, they are able to save a ton of time. The VLOOKUP function alone has saved countless hours in […]


Make an Excel Worksheet Very Hidden

Did you know that Excel has two levels of hidden worksheets?  Excel has “hidden” worksheets, and, “very hidden” worksheets. This post walks through the differences, and how to hide worksheets at each level. By default, all new worksheets are visible.  A visible worksheet’s tab appears in the bottom of the Excel window, enabling the user […]



Excel University Interactive

I am excited to announce the launch of Excel University Interactive!  Up until now, the Excel U content was delivered only through a book format (both paperback and digital).  Starting now, the content is officially available as an online interactive group study format as well. This course is the result of a project I started […]