<ul><li>Microsoft Excel is an excellent spreadsheet application for complex data analysis.</li><li>Pivot tables let you analyze the same data from different angles to spot trends.</li><li>Organize data in a tabular form with good column headers and consistent data.</li><li>Use Excel tables to add rows for your pivot table or identify columns for new data.</li><li>Excel offers a Recommended PivotTables tool that takes a look at your data and offers a variety of options.</li><li>PivotTable Fields dialog box determines how your pivot table will work.</li><li>Individual selections in the dialog box include Fields, Filters, Columns, Rows, and Values.</li><li>Pivot tables let you manipulate data easily by selecting and removing fields.</li><li>To start a pivot table from scratch, go to Insert > PivotTable and manually select your data.</li><li>Invest in some learning to use pivot tables more effectively and discover Excel's other advanced features.</li></ul>

How to create a pivot table in Excel to slice and dice your data

Discover more