by C. J. Benton (Author)
Learn Pivot Tables By Example - Updated for 2019
With this practical and to-the-point guide on Pivot Tables and basic Dashboards, you'll develop the skills to build and modify reports with step-by-step examples and screenshots including how to:
Organize and summarize data Format & filter Pivot Table resultsCreate Pivot ChartsDisplay averages & percentagesGroup data into predefined rangesUse Slicers, Timelines, and Sparklines
Rank resultsApply calculated fieldsUse Power Query to create and combine 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:
Incorporate Pivot Charts, Sparklines, and performance symbols into your reporting
Refresh and protect your Pivot Table data A great resource for:
Business Analysts Data AnalystsFinancial 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(R) Excel's(R) best features
Number of Pages: 176
Dimensions: 0.38 x 9.21 x 6.14 IN
Publication Date: November 18, 2019