HOT
blank

PivotTables in Excel Course for Beginners

Office Productivity

PivotTables in Excel Course for Beginners, available at $74.99, has an average rating of 4.75, with 71 lectures, 13 quizzes, based on 11 reviews, and has 127 subscribers.

Rating4.8
Enroll Now

You will learn about 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 is ideal for individuals who are Users with basic knowledge of Excel 2019/365 and those upgrading from previous software versions or Users who have a foundation of Microsoft Excel and seeking to advance their Excel 2019/365 knowledge. or People looking to perform Data Analysis using Excel or Beginner Excel users who want to learn how to use Pivot Tables It is particularly useful for Users with basic knowledge of Excel 2019/365 and those upgrading from previous software versions or Users who have a foundation of Microsoft Excel and seeking to advance their Excel 2019/365 knowledge. or People looking to perform Data Analysis using Excel or Beginner Excel users who want to learn how to use Pivot Tables.

Enroll now: PivotTables in Excel Course for Beginners

Summary

Title: PivotTables in Excel Course for Beginners

Price: $74.99

Average Rating: 4.75

Number of Lectures: 71

Number of Quizzes: 13

Number of Published Lectures: 71

Number of Published Quizzes: 13

Number of Curriculum Items: 84

Number of Published Curriculum Objects: 84

Original Price: $89.99

Quality Status: approved

Status: Live

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

Who Should Attend

  • 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

Target Audiences

  • 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

**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:

  1. 5+ hours of videotutorials

  2. 64 individual video lectures

  3. Certificate of completion

  4. Course and exercise files to follow along

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Introduction

Lecture 2: WATCH ME: Essential Information for a Successful Training Experience

Lecture 3: DOWNLOAD ME: Course Exercise Files

Lecture 4: DOWNLOAD ME: Course Support Files

Lecture 5: What are Pivot Tables and Why are They Useful?

Chapter 2: Preparing Data for Analysis

Lecture 1: The Importance of Cleaning Data

Lecture 2: Removing Blank Rows

Lecture 3: Removing Duplicate Rows

Lecture 4: Clearing Formatting

Lecture 5: Applying Number Formatting

Lecture 6: Changing the Case

Lecture 7: Removing Spaces and Non-printing Characters

Lecture 8: Merging and Splitting Columns

Lecture 9: Convert Numbers Stored as Text

Lecture 10: Finding and Replacing Text

Lecture 11: Spell Check

Lecture 12: Exercise 01

Chapter 3: The Importance of Excel Tables

Lecture 1: Excel Tables vs Pivot Tables

Lecture 2: Format Data as a Table

Lecture 3: Exercise 02

Chapter 4: Creating a Basic Pivot Table Report

Lecture 1: Using Recommended Pivot Tables

Lecture 2: Creating a Pivot Table from Scratch

Lecture 3: Pivot Table Ribbons and Fields

Lecture 4: Pivoting the Fields

Lecture 5: Adding Multiple Dimensions

Lecture 6: Deleting Fields and Locking the Report Layout

Lecture 7: Exercise 03

Chapter 5: Aggregation and Grouping

Lecture 1: Methods of Aggregation

Lecture 2: Combining Methods of Aggregation

Lecture 3: Grouping and Ungrouping Data

Lecture 4: Exercise 04

Chapter 6: Formatting Values

Lecture 1: Applying Number Formatting

Lecture 2: Handling Cells with No Data

Lecture 3: Exercise 05

Chapter 7: Layout Options

Lecture 1: Subtotals and Grand Totals

Lecture 2: Choosing a Report Layout

Lecture 3: Inserting Blank Rows

Lecture 4: Exercise 06

Chapter 8: Formatting Pivot Tables

Lecture 1: Applying Pivot Table Styles

Lecture 2: Modifying Pivot Table Styles

Lecture 3: Creating a Custom Pivot Table Style

Lecture 4: Exercise 07

Chapter 9: Sorting and Filtering

Lecture 1: Sorting Pivot Table Data

Lecture 2: Filtering Pivot Table Data

Lecture 3: Top 10 Filter

Lecture 4: Exercise 08

Chapter 10: Creating Pivot Charts

Lecture 1: Selecting the Right Chart Type

Lecture 2: Clustered Column and Bar Charts

Lecture 3: Line Charts

Lecture 4: Pie and Donut Charts

Lecture 5: Map Charts

Lecture 6: Applying Chart Layouts

Lecture 7: Exercise 09

Chapter 11: Formatting Pivot Charts

Lecture 1: Adding a Slicer

Lecture 2: Formatting a Slicer

Lecture 3: Adding a Timeline

Lecture 4: Connecting Slicers and Timelines

Lecture 5: Exercise 10

Chapter 12: Applying Conditional Formatting

Lecture 1: Highlight Cell Rules

Lecture 2: Data Bars

Lecture 3: Color Scales

Lecture 4: Icon Sets

Lecture 5: Exercise 11

Chapter 13: Updating Pivot Tables and Pivot Charts

Lecture 1: Adding Data to the Dataset

Lecture 2: Updating Pivot Tables and Pivot Charts

Lecture 3: Exercise 12

Chapter 14: Course Close and Next Steps

Lecture 1: Course Close and Next Steps

Chapter 15: Additional Training

Lecture 1: READ ME: This Additional Training Is Optional

Lecture 2: Ten Excel Tips and Tricks – Part 1

Lecture 3: Ten Excel Tips and Tricks – Part 2

Lecture 4: Ten Excel Tips and Tricks – Part 3

Instructors

  • Simon Sez IT
    Simon Sez IT
    870,000+ Students, 260+ Courses, Learners in 180+ Countries

Rating Distribution

  • 1 stars: 0 votes
  • 2 stars: 0 votes
  • 3 stars: 1 votes
  • 4 stars: 3 votes
  • 5 stars: 7 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Chatgpt And Ai Tools Courses to Learn in November 2024

Top 10 Excel Vba Courses to Learn in November 2024

Analytical Methods for Effective Data Analysis