Pivot tables are a highly useful feature in Excel, the leading desktop spreadsheet program, once the user masters their many abilities of summarization—a task made much less daunting with this special tip sheet that offers condensed must-know information on how to work with pivot tables. Ideal for creating one-page summary reports, pivot tables can be used by spreadsheet creators to report on such key data items as the top five customers, top 10 products, annual revenue changes, and many others. The card is helpful to users of either Excel 2010 or 2013, and includes necessary lessons, such as creating the first pivot table, as well as advanced topics that include date rollups, grouping, calculated fields, and basic troubleshooting.
| ISBN: | 9781615479955 |
| Publication date: | 1st October 2013 |
| Author: | Bill Jelen |
| Publisher: | Holy Macro! Books |
| Format: | Pamphlet |
| Pagination: | 2 pages |
| Genres: |
Spreadsheet software |