Ditch tedious steps, uncover spreadsheet issues, and make complex workbooks easier to handle.

Many Excel tools are optional extras, but these six are essentials I rely on in every workbook.

Microsoft Excel 2013 charts are dynamic in that they automatically update when the current data changes. However, if you add a series of data points to a spreadsheet, Excel doesn't know to include ...

It's often useful to put a header or footer on the top or bottom of Excel spreadsheets. The header or footer might contain information about who prepared the spreadsheet, a disclaimer about the ...

To begin, you need to enable the Developer tab in Excel. This tab provides access to the tools required for form creation, but it is not enabled by default. To enable ...

You don’t have to add a header to every Excel worksheet individually when you can group them first. Adding a header (or footer) to an Excel sheet is a simple task using Excel’s Page Layout view.

If you’re a full-time spreadsheet jockey, or just a casual number-cruncher, you’ve come to know and either love or hate Excel’s interface. Well, your world just changed. Throw away almost everything ...