• Post category:StudyBullet-6
  • Reading time:4 mins read


Create your First Pivot Table Project

What you will learn

Pivot Tables

Pivot Table Caluculations

Grouping within Pivot Tables

Calculated Fields in Pivot Tables

Slicers and Timelines in Pivot Tables

Description

PIVOT TABLES are the most sought out feature of Excel and is often used at work environment.

In this course you will learn a lot about Pivot Tables.

You’ll get to learn about the below scenarios:

  • Inserting a Pivot table from a simple dataset
  • Inserting Fields and giving a shape to Pivot Table
  • Changing Views and understanding Views for different data
  • Moving Pivot Tables
  • Inserting and Managing Timelines
  • Inserting and Managing Slicers
  • Grouping Data on Excel
  • Filtering Data on Excel

Pivot Tables has been critical for most of the tasks at work. However it had its disadvantages and is often time consuming if the data is complex.


Get Instant Notification of New Courses on our Telegram channel.


YourExcelGuy is the first and only platform that provides animation videos for excel skills. We have put together more than 100 videos that demonstrate every excel skill you can imagine – whether it’s for absolute beginners or advanced users. Our content includes transformations, graphics, conditional formatting, data tables, pivot tables, dashboards, or VBA macros.

About the Instructor: I’m a Microsoft Certified Excel Expert and a full time Excel coach, I train people on Excel and that’s something I really love doing.

Currently I have trained over 8000+ students in 2022 and have impacted over 15000 students in the year of 2021. With over 3 years of training experience and 11+ years of using Excel every single day I’ve learnt a lot of tricks in excel

English
language

Content

Introduction

Introduction to the Course
Introduction to Pivot Tables
Advantages and Structure of Pivot Tables

Pivot Table Basics

Creating our First Pivot Table
Changing the Default Calculations
Formatting PivotTable Data
Filtering the Pivot Table Data
Managing the Data Source of Listed Data or Range Data
Moving and Managing Pivot Tables

Slicers and Timelines

Filtering with the Slicer Tool
Filtering with the Timeline Tool
Connecting Slicers and Timelines to Multiple Pivot Tables
Pivot Table from Table Data Vs List Data (Range) – PT
Grouping Data on Pivot Tables