Blog







Excel 2013 Highlights

Microsoft Excel 2013 offers many new features and functions worth exploring. This post provides a few highlights and a link to my May-2013 CalCPA Technology and Business Resource Guide article, “Spreadsheet Nerdiness” which goes into more detail. Summary Design With the exception of some minor cosmetic changes and some animations, the design is similar to […]




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 […]