Craft Excel Pivot Tables for Data Reporting
Course
Online
Description
-
Type
Course
-
Methodology
Online
-
Start date
Different dates available
Improve data processing and reporting for your Excel data sheets by learning to set up pivot tables to summarize your data. Using mock-up sales data, you will learn to extract and aggregate large sets of data into easy-to-use pivot tables with a single click. Not only will you gain advanced techniques for sorting, filtering, grouping, and displaying data, but you will also make reporting and analyzing large data sets easier with clear tables and charts that can be interacted with by anyone.
You will learn how to:
Create pivot tables and pivot charts for visual representations of your data
Sort and group data based on values, labels, and more
Format pivot tables manually and with conditional formatting
Manipulate how data is calculated and displayed for your pivot table
Refresh pivot tables when data is updated
Use slicers to create interactive reports
Frameworks and tools covered: Microsoft Excel 2019
Your Courses, Your Way
All of our project-based courses are designed to be flexible – you can access courses 24/7 to fit them around your schedule, and choose the learning materials that suit you best.
You can even download your course videos and watch them offline using the Zenva app, available on iOS and Android.
Learn from World-Class Instructors
Our course instructors participate in elite developer programs and have been recognized for their demonstrated excellence in development and teaching.
That way, you can be confident that you’re learning the most up-to-date content from industry experts.
Interactive Lessons with Codemurai
Our unlimited access package comes with free access to all of the courses in our mobile app, Codemurai!
Available on iOS and Android, it’s full of interactive programming lessons and exercises so you can continue your learning on the go.
Achieve Real Results
Facilities
Location
Start date
Start date
About this course
A basic working knowledge of Excel.
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 3 years
Subjects
- Excel
- Access
- MS Excel
- IT
- Information Systems management
Course programme
Introduction 3:44
Introduction 3:44
3:44
Creating your First Pivot Table 8:29
Creating your First Pivot Table 8:29
8:29
Changing the Pivot Table Calculation 3:14
Changing the Pivot Table Calculation 3:14
3:14
Changing the Number Formatting 2:57
Changing the Number Formatting 2:57
2:57
Sorting Pivot Table Values and Labels 3:02
Sorting Pivot Table Values and Labels 3:02
3:02
Grouping Pivot Table Data 4:13
Grouping Pivot Table Data 4:13
4:13
Using the Report Filter 3:43
Using the Report Filter 3:43
3:43
Value as a Percentage or Difference 6:57
Value as a Percentage or Difference 6:57
6:57
Create Pivot Table Styles 6:08
Create Pivot Table Styles 6:08
6:08
Using Pivot Charts 7:27
Using Pivot Charts 7:27
7:27
Refreshing your Pivot Table Data 4:14
Refreshing your Pivot Table Data 4:14
4:14
Conditional Formatting 5:26
Conditional Formatting 5:26
5:26
Using Slicers for Interactive Reports 9:28
Using Slicers for Interactive Reports 9:28
9:28
Conclusion 2:49
Conclusion 2:49
2:49
Additional information
Craft Excel Pivot Tables for Data Reporting