Excel spreadsheets do so much, from making lists to crunching numbers to acting as sophisticated flat-file databases. We’re creating this guide to make sure you master all the essentials and more.

You can use Microsoft Excel to set up a simple row-and-column matrix of information, listing income data, itemizing expenses and documenting events. These tasks barely scratch the surface of Excel's ...