Learn how to create Pivot Tables quickly and easily with this step-by-step guide!


Updated for Microsoft® Excel® 2016! This book contains easy to follow step-by-step examples with screens...

Buy Now From Amazon

Product Review

Learn how to create Pivot Tables quickly and easily with this step-by-step guide!


Updated for Microsoft® Excel® 2016! This book contains easy to follow step-by-step examples with screenshots demonstrating how to create Pivot Tables and basic Dashboards. In just a few short hours, you’ll learn how to:

  • Organize and summarize data
  • Format & filter Pivot Table results
  • Create Pivot Charts
  • Display averages & percentages
  • Group data into predefined ranges
  • Use Slicers
  • Rank results
  • Apply calculated fields
  • Create Pivot Table reports from imported files
  • And more!

    In addition to the above, you will also learn how to create, format, and update a basic Dashboard using Pivot Table data. Including how to incorporate charts and performance symbols into your reporting.

    A great resource for:

  • Business Analysts
  • Data Analysts
  • Financial Analysts
  • Administrative and Support staff

    Imagine the time you'll save by not having to search the internet or help files to learn the most practical ways of using one of Microsoft® Excel’s® best features!



  • Similar Products

    Excel Conditional Formatting: Tips You Can Use Immediately To Make Your Data Stand Out (Data Analysis With Excel Book 3)The Step-By-Step Guide To The VLOOKUP formula in Microsoft Excel (The Microsoft Excel Step-By-Step Training Guide Series Book 3)Mastering Excel: Pivot TablesExcel Shortcuts: 130 Shortcuts that will change your life foreverExcel 2016 The 30 Most Common Formulas & Features - The Step-By-Step GuideExcel Importing & Exporting Text Data: Quickly Turn Raw Data Into Excel Tables (Data Analysis With Excel)Excel 2016 Pivot Table Data Crunching (includes Content Update Program): Exce 2016 Pivo Tabl Data C_p1 (MrExcel Library)Mastering Excel: Building DashboardsExcel Pivot Tables: A Visual Introduction For Beginners (Data Analysis With Excel Book 5)