Excel Pivot Tables Laminated Tip Card Pivot Table Tricks from MrExcel

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.

Bill Jelen is an Excel expert at www.mrexcel.com, a regular on TechTV Canada’s Call for Help, and a video podcaster who is regularly listed in the iTunes top 50. He is the author of Excel Gurus Gone Wild, Pivot Table Data Crunching, Slaying Excel Dragons, and 14 titles in the Excel for Professionals series. He has been named a Microsoft MVP for seven years and is a contributor to CFO Magazine and Strategic Finance Magazine. He lives in Akron, Ohio.