PivotTables in Excel Course for Beginners

Learn a quick and interactive way of summarizing large data with Pivot Tables in Excel!
4.81 (29 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
PivotTables in Excel Course for Beginners
186
students
7.5 hours
content
Mar 2023
last update
$74.99
regular price

What you will learn

How to clean and prepare your data

Creating a basic PivotTable

Using the PivotTable fields pane

Adding fields and pivoting the fields

Formatting numbers in PivotTable

Different ways to summarize data

Grouping PivotTable data

Using multiple fields and dimension

The methods of aggregation

How to choose and lock the report layout

Applying PivotTable styles

Sorting data and using filters

Create pivot charts based on PivotTable data

Selecting the right chart for your data

Apply conditional formatting

Add slicers and timelines to your dashboards

Adding new data to the original source dataset

Updating PivotTables and charts

Related Topics
4511482
udemy ID
1/24/2022
course created date
2/6/2022
course indexed date
ANUBHAV JAIN
course submited by