Pivot Tables for Beginners

——   Created by Simon Sez IT

Share this course:

NEW
Course
64
Lessons
5h 32m
Lesson time
beginner
Skill level

More about this course

We all need to analyze data these days since we live in a very data-driven world. Data is so important when it comes to understanding your business, looking for trends, or forecasting future business needs. Because there is a lot of importance placed on data analysis, it is important that you have the relevant skills to analyze data effectively.

Pivot Tables is an essential Excel skill for jobs that involve analyzing and visualizing large amounts of data. Pivot Tables are an interactive way of quickly summarizing large amounts of data by grouping and aggregating sets of data and let you analyze data in a clear and effective way.

This course will discuss the importance of cleaning your data before you can create your first Pivot Table. You will also learn how to create pivot Charts and how to format your Pivot Tables and Charts.

This beginner course is aimed at people who never used Pivot Tables before and would like to get started UTIs also helpful for those who have a rough knowledge of Pivot Tables but would like to expand their excel 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
  • How to create a Basic Pivot Table
  • How to use the Pivot Table Fields pane
  • How to Add Fields and Pivoting the Fields
  • How to format numbers in Pivot Table
  • What are the different ways to Summarize Data
  • How to Group Pivot Table Data
  • How to use Multiple Fields and Dimension
  • What are the Methods of Aggregation
  • How to choose and lock the Report Layout
  • How to apply Pivot Table Styles
  • How to sort data and use Filters
  • How to create Pivot Charts based on Pivot Table data
  • How to select the right chart for your data
  • How to Apply Conditional Formatting
  • How to add Slicers and timelines to your dashboards
  • How to add new Data to the original source dataset
  • How to update pivot Tables and Charts

64 Lessons

Introduction
0:05:10
Course Introduction
free preview
0:06:11
What are Pivot Tables and why are they useful?
free preview
Preparing Data for Analysis
0:03:05
The Importance of Cleaning Data
0:05:30
Removing Blank Rows
0:02:37
Removing Duplicate Rows
0:04:26
Clearing Formatting
0:08:38
Applying Number Formatting
0:09:15
Changing the Case
0:10:06
Removing Spaces and Non-printing Characters
0:13:00
Merging and Splitting Columns
0:02:28
Convert Numbers Stored as Text
0:06:07
Finding and Replacing Text
0:03:57
Spell Check
View more lessons +
This course is included in Arbington Premium
$15/month gets you access to every course. Start your 14 day trial today. ☝️

Class benefits

  • Certificate of Completion
  • 30 day satisfaction guarantee
  • 24/7 streaming access
  • Direct teacher access
  • 5h 32m of on-demand video
  • 13 downloadable files
  • Have a coupon?

About the instructor

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 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no …

View full profile

For super learners, get unlimited access for $15 per month

Start your 14 day free trial. Cancel at any time.

Join Today Learn More