To create a PivotTable in Microsoft Excel, follow the steps below: Open the Excel spreadsheet you wish to analyze.; Ensure your data has no empty rows or columns and only has a single row heading.

Hyperlinks have been around for a long time, but some Excel users just don’t use them. One way your users can put them to good use is to create a simple table of contents sheet.

Users will appreciate a chart that updates right before their eyes. In Microsoft Excel 2007 and Excel 2010, it's as easy as creating a table. In earlier versions, you'll need the formula method.