Microsoft Excel Pivot Table and Analysis Beginner to Pro

سرفصل های دوره

Create and Analyze Data with Pivot Tables

1 - Introduction

1 - Introduction to the Course

2 - Downloadable Practice Files.html

2 - Pivot-Table-Practice-File-Questions.xlsx

3 - Introduction to Pivot Tables

4 - Pivot Table Interface and our First Pivot Table

5 - How Pivot Table Works

2 - Pivot Table Basics

6 - First Pivot Table with a Calculation

7 - Different Calculations from the Same Field

8 - Using Rows and Columns in Pivot Tables for the Same Field

9 - Using Rows and Columns for 2 different fields

10 - Managing Labels of a Complex Pivot Table

11 - Sorting Values in Pivot Table

12 - Label Filtering in Pivot Tables

13 - Values Filtering in Pivot Tables

14 - Report Level Filters in Pivot Tabels

15 - Formatting Values in Pivot Table

16 - Managing Date Information in Pivot Tables

17 - Moving and Managing Pivot Tables

3 - Intermediate Level Pivot Table Situations

18 - Multi Field Calculations in Pivot Tables

19 - Top 3 and Bottom 3 in Pivot Tables

20 - Changes in the Data Source

21 - Adding New Rows of Data to the Pivot Table Manual Method

22 - Column Referencing and the Challenges of Blanks

23 - Range Vs Table Source for Pivot Tables

4 - Advanced Pivot Tables Features

24 - Grouping Data in Pivots

25 - Using Slicers to Filter Reports

26 - Using Timelines to Filter Reports

27 - Pivot Tables Assignment Question

28 - Pivot Tables Assignment Answer

29 - Answer File for Pivot Tables So far.html

29 - Pivot-Table-Practice-File-Answers.xlsx

5 - Complex Calculations with Pivot Table

30 - Advanced-Pivot-Table-Practice-File-Questions.xlsx

30 - Practice file for this section.html

31 - Introduction to Advanced Pivot Tables

32 - Understanding Distribution and Converting Insights into Actionable Ones

33 - Calculating of Grand Total and its Significance

34 - How of ROW Total works

35 - Calculating of Row Total on a Dataset

36 - Visualizing Complex Pivot Data

37 - Calculating of Column Total

38 - Changing the Calculations to of Column Total

39 - Visualizing the Distribution Charts

40 - Calculating of Custom Field

41 - Calculating of Parent Row Total

42 - Calculating Difference From in

43 - Running Total and Assignment Walkthrough

44 - Advanced-Pivot-Table-Practice-File-Answers.xlsx

44 - Practice file with answers Download.html

6 - Conclusion

45 - Bonus Lecture.html

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy