What starts as a simple Microsoft Excel typo can lead to massive excel spreadsheet errors: company-wide public misstatements, billion-dollar losses, tarnished reputations, and career terminations. While that sounds like an exaggeration, it’s not. At least one mistake is present in 70–80% of US spreadsheets, and the ramifications can be severe….
1. VLOOKUP VLOOKUP stands for Vertical Lookup and can be a really handy tool if you’re looking for specific information in a list or table and want to save time. Instead of reading through the whole list or table, simply find a cell where you can enter a VLOOKUP formula….
1. Simultaneously Format Multiple Pages Sometimes when you’re formatting a worksheet in Excel, you know you’re going to want to format a second or third worksheet the exact same way. Doing that manually seems tedious and unnecessary – and it is! You can actually use Excel’s grouped worksheets feature to…
1. ADD A CALCULATOR TO WORD If you’re using Microsoft Word for work, chances are, at some point, numbers are going to come into play. You can save yourself a trip to your dashboard, Excel, or that junk drawer where you thought you last saw your calculator by simply adding…