PivotTables in Excel Course for Beginners

Focused View

Simon Sez IT

7:35:47

46 View

1. Introduction

1. Course Introduction.mp4

05:10

2. WATCH ME Essential Information for a Successful Training Experience.mp4

02:11

3.1 Pivot Tables Exercise Files.zip

3. DOWNLOAD ME Course Exercise Files.html

4.1 Pivot Tables Course Files.zip

4. DOWNLOAD ME Course Support Files.html

5. What are Pivot Tables and Why are They Useful.mp4

06:12

6. Section Quiz.html

2. Preparing Data for Analysis

1. The Importance of Cleaning Data.mp4

03:05

2. Removing Blank Rows.mp4

05:30

3. Removing Duplicate Rows.mp4

02:37

4. Clearing Formatting.mp4

04:26

5. Applying Number Formatting.mp4

08:38

6. Changing the Case.mp4

09:16

7. Removing Spaces and Non-printing Characters.mp4

10:06

8. Merging and Splitting Columns.mp4

13:00

9. Convert Numbers Stored as Text.mp4

02:28

10. Finding and Replacing Text.mp4

06:07

11. Spell Check.mp4

03:57

12. Exercise 01.mp4

04:01

13. Section Quiz.html

3. The Importance of Excel Tables

1. Excel Tables vs Pivot Tables.mp4

05:24

2. Format Data as a Table.mp4

08:47

3. Exercise 02.mp4

01:50

4. Section Quiz.html

4. Creating a Basic Pivot Table Report

1. Using Recommended Pivot Tables.mp4

05:29

2. Creating a Pivot Table from Scratch.mp4

05:45

3. Pivot Table Ribbons and Fields.mp4

06:39

4. Pivoting the Fields.mp4

05:32

5. Adding Multiple Dimensions.mp4

02:48

6. Deleting Fields and Locking the Report Layout.mp4

03:41

7. Exercise 03.mp4

01:37

8. Section Quiz.html

5. Aggregation and Grouping

1. Methods of Aggregation.mp4

04:09

2. Combining Methods of Aggregation.mp4

05:37

3. Grouping and Ungrouping Data.mp4

09:45

4. Exercise 04.mp4

03:23

5. Section Quiz.html

6. Formatting Values

1. Applying Number Formatting.mp4

04:45

2. Handling Cells with No Data.mp4

04:00

3. Exercise 05.mp4

02:18

4. Section Quiz.html

7. Layout Options

1. Subtotals and Grand Totals.mp4

04:27

2. Choosing a Report Layout.mp4

04:44

3. Inserting Blank Rows.mp4

02:14

4. Exercise 06.mp4

01:30

5. Section Quiz.html

8. Formatting Pivot Tables

1. Applying Pivot Table Styles.mp4

04:15

2. Modifying Pivot Table Styles.mp4

04:19

3. Creating a Custom Pivot Table Style.mp4

05:37

4. Exercise 07.mp4

03:30

5. Section Quiz.html

9. Sorting and Filtering

1. Sorting Pivot Table Data.mp4

08:31

2. Filtering Pivot Table Data.mp4

07:20

3. Top 10 Filter.mp4

03:31

4. Exercise 08.mp4

01:57

5. Section Quiz.html

10. Creating Pivot Charts

1. Selecting the Right Chart Type.mp4

08:40

2. Clustered Column and Bar Charts.mp4

13:40

3. Line Charts.mp4

09:55

4. Pie and Donut Charts.mp4

11:31

5. Map Charts.mp4

08:47

6. Applying Chart Layouts.mp4

03:06

7. Exercise 09.mp4

04:07

8. Section Quiz.html

11. Formatting Pivot Charts

1. Adding a Slicer.mp4

07:38

2. Formatting a Slicer.mp4

06:23

3. Adding a Timeline.mp4

05:22

4. Connecting Slicers and Timelines.mp4

05:30

5. Exercise 10.mp4

03:00

6. Section Quiz.html

12. Applying Conditional Formatting

1. Highlight Cell Rules.mp4

05:37

2. Data Bars.mp4

04:08

3. Color Scales.mp4

03:21

4. Icon Sets.mp4

04:26

5. Exercise 11.mp4

01:30

6. Section Quiz.html

13. Updating Pivot Tables and Pivot Charts

1. Adding Data to the Dataset.mp4

02:37

2. Updating Pivot Tables and Pivot Charts.mp4

01:41

3. Exercise 12.mp4

01:39

4. Section Quiz.html

14. Course Close and Next Steps

1. Course Close and Next Steps.mp4

01:53

15. Additional Training

1. READ ME This Additional Training Is Optional.html

2. Ten Excel Tips and Tricks - Part 1.mp4

43:23

3. Ten Excel Tips and Tricks - Part 2.mp4

40:36

4. Ten Excel Tips and Tricks - Part 3.mp4

37:09

Description

Learn a quick and interactive way of summarizing large data with Pivot Tables in Excel!

What You'll 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

Who is this for?

Users with basic knowledge of Excel 2019/365 and those upgrading from previous software versions

Users who have a foundation of Microsoft Excel and seeking to advance their Excel 2019/365 knowledge.

People looking to perform Data Analysis using Excel

Beginner Excel users who want to learn how to use Pivot Tables

What You Need to Know?

Microsoft Excel for Windows. The course was created using Excel 2019/365 for Windows. All of the code used in this course except for one property is compatible for Excel 2007, Excel 2010, Excel 2013, Excel 2016 and Excel 2019.

Basic knowledge of Microsoft Excel is beneficial but not required

More details

Description
This course includes downloadable course instructor files and exercise files to work with and follow along.

Data analysis is essential in todayâ€™s data-driven world. Data is crucial in understanding businesses, analyzing trends, and forecasting your business needs. Due to such weight placed on data analysis, it is crucial for you to have relevant skills to handle and analyze data efficiently.

PivotTable is a vital Excel skill for big data analysis and visualization jobs. PivotTables are an interactive way of quickly summarizing large amounts of data by grouping and aggregating datasets while letting you analyze data in a clear and effective manner.

This course will discuss the importance of cleaning your data before creating your first PivotTable. You will also learn how to create Pivot Charts and format your PivotTables and charts.

This course is aimed at those brand-new to PivotTables or for beginner Excel users looking to expand their skills. This course includes downloadable excel data files that the instructor uses in the tutorial so you can follow along.

In this course, 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

This course bundle includes:
5+ hours of video tutorials
64 individual video lectures
Certificate of completion
Course and exercise files to follow along
Who this course is for:
Users with basic knowledge of Excel 2019/365 and those upgrading from previous software versions
Users who have a foundation of Microsoft Excel and seeking to advance their Excel 2019/365 knowledge.
People looking to perform Data Analysis using Excel
Beginner Excel users who want to learn how to use Pivot Tables

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Pivot Tables

Simon Sez IT

Instructor's Courses

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 8,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 630,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.