Following on from our time saving Excel shortcuts, we continue offering updated advice for the time-sensitive spreadsheet enthusiast. Back in 2013 John Gagnon wrote a very popular post about VLOOKUP ...

Microsoft Excel, despite its popularity, isn’t exactly the most intuitive piece of software. Moreover, to fully understand how Excel works, most users need professional training, which can also be ...

Charts and sparklines are powerful data visualization tools in Excel. Here’s a guide to the most popular chart types in Excel and how to best use them. Microsoft Excel offers a plethora of tools for ...

Microsoft discontinued the lower-priced Microsoft Works suite, but you can convert old documents to use current Microsoft Office formats. If you have a spreadsheet from Works versions 6 and later, you ...

Excel's IF function validates a cell's contents, determining whether it meets criteria that you set. It provides no information beyond what your workbook already contains, but it analyzes the data ...