.png)
Analyze and visualize data with PivotTables and Charts
in Data Analytics with Microsoft ExcelAbout this course
Welcome to this course on PivotTables for Data Analytics and Reporting!
PivotTables are a powerful feature in Excel that allow you to summarize, analyze, and visualize large amounts of data with ease. Whether you're new to PivotTables or looking to enhance your skills, this course will provide you with the knowledge and tools you need to become proficient in using PivotTables for data analysis.
By the end of this course, you will have a comprehensive understanding of PivotTables and how to use them to gain valuable insights from your data. Whether you're a business professional, analyst, or student, the skills you learn in this course will be valuable in your day-to-day work.
Learning Objectives
1. Understand the basics of PivotTables, including how to create them and navigate the various areas.
Learn how to analyze data using multiple fields in a PivotTable.
2. Explore different types of calculations and summaries that can be applied to PivotTables.
3. Customize PivotTable styles and layouts to enhance visual appeal.
4. Sort and filter PivotTables to focus on specific data points.
Create PivotCharts to visualize your data.
5. Apply conditional formatting and use Sparklines for additional visual insights.
6. Learn advanced features such as showing report filter pages and using the GETPIVOTDATA function.
Prerequisites
FAQ
Comments (0)
Course introduction
Download the dataset for the course
Datasets walkthrough
Create your first PivotTable
Course Overview
Explore the areas of a PivotTable
Work with multiple fields in a PivotTable
Practice with a hands-on demo
Customize your PivotTable name
Changing default summarization in PivotTable
Express values as % of Total
Express values as % of Row Total
Express values as % of column Total
Show values as % of Parent Row Total
Calculating running totals
Perform time-based calculations
Show ranking
Add custom calculations
Adding calculated fields
Calculated Fields 3
Apply styles to PivotTables
Design your own PivotTable Style
Changing PivotTable layouts
Applying different layout options
PivotTables Fields Pane
Apply sorting to PivotTable values
Filtering PivotTables
Working with Slicers
Connect slicers to multiple PivotTables
Working with Timelines
Group data with PivotTables
Visualize data with Pivotcharts
Visualize PivotTable data using modern charts
Apply conditional formatting to PivotTables
Visualize data with Sparklines
Visualize data with Sparklines
Working with Sparklines - Win/ Loss
Split PivotTable Reports to multiple pages
Show PivotTable details
Reference values from PivotTables using the GETPIVOTDATA function
Apply your skills to a challenge
Apply your skills to a challenge
Download the capstone file
Final Capstone Project
Congratulations for completing the course.
.png){kind=small}
.png){kind=small}
.png)