When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

Productivity
SkillShare logo

Microsoft Excel Pivot Table Masterclass- Become a Pivot Table SuperHero

Unlock creativity with Skillshare! Learn acrylic painting, AI writing, graphic design, and photography.

     0 |
  • Reviews ( 0 )
Free
Microsoft Excel Pivot Table Masterclass- Become a Pivot Table SuperHero

Related Courses

This Course Includes

  • iconskillshare
  • icon0 (0 reviews )
  • icon4 hours 12 minutes
  • iconenglish
  • iconOnline - Self Paced
  • iconcourse
  • iconSkillShare

About Microsoft Excel Pivot Table Masterclass- Become a Pivot Table SuperHero

1 Introduction

2 Creating Your First Pivot Table

3 Field Well Options

4 Cleaning the Source Data

5 Using Data Tables

6 Merge Data Tables

7 Pivot Table Layouts

8 Subtotals and GrandTotals

9 Grouping and Ungrouping

10 Aggregation

11 Cumulative Sum

12 Percentages

13 Top X and Bottom X

14 Calculated Field

15 Formatting Values

16 Understanding AutoUpdate

17 Pivot Table Styles and Designs

18 Conditional Formatting

19 Build In Data Filters

20 Slicers

21 Date Filters and Timelines

22 Slicer Connections

23 Basic Sort

24 Custom Sort

25 Value Sort

26 Double Click

27 GETPIVOTDATA

28 Pivot Charts

29 Auto Refresh

30 Points to Remember

What You Will Learn?

  • Pivot tables are one of Microsoft Excel's most powerful features. A pivot table allows you to extract the significance from a large, detailed data set and this course clarifies and simplifies the key information you need to get started using pivot tables in excel and teaches you all the nuts and bolts to get a strong hold on Pivot Tables in Excel..
  •  A Pivot Table is a summary of a large dataset that usually includes the total figures, average, minimum, maximum, etc. With pivot table in excel you can filter meaningful data from a large data set to come to conclusions..
  • Let's say you have a sales data for different regions, with a pivot table, you can summarize the data by region and find the average sales per region, the maximum and minimum sale per region, etc. Pivot tables allow us to analyse, summarize and show only relevant data in our reports..
  • This online course is designed to give you a solid understanding of Pivot Tables, taking you from Novice to Ninja!.
  • In this course you will explore the Ultimate power of Pivot Tables in Sorting, Filtering, Analyzing and Presenting complex data in an easy-to-Understand Format and derive meaningful outputs for decision making..
  • The course will Equip you with the Best Practices for preparing source data, using database, preserve formats and create custom styles, sorting and filtering techniques, and much more..
  • Every lecture comes with ample to resource files and case studies for your practice and hands on experience..
  • Download the Resource File Before You Start and Make Use of the Index to Refer to the necessary Resources Needed for Every Lecture. .
  • Whether you are new to the world of Excel or a regular User, this course will be a milestone on your journey to become a Excel Ninja and a Go To Person at Work..
  • I am totally Excited to see you inside the course. See You Inside..