Excel formulas don’t have to be ugly.

Microsoft has recently added a new feature to excel in the form of the extremely useful Scan Function. This guide aims to provide a quick overview of how you can get the most from this new function ...

If you've ever found yourself copying the same formula down hundreds of rows in Excel, you know how tedious it gets. The usual approach, dragging formulas, adjusting cell references, and hoping ...