Excel® - Pivot Tables & Introduction to Dashboards
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:
****Exercise Files Included!****
-
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
