Complete Introduction to Excel Pivot Tables [2022 Edition]

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

Learn to analyze & summarize data in seconds using Excel's most powerful data feature - Pivot Tables & Pivot Charts!

1 - Introduction

1 - Introduction to the Course

2 - About the Course

3 - Data.xlsx

3 - Download the course data files.html

4 - Correctly Setup Data

2 - Create Pivot Tables

5 - Introduction to Pivot Tables

6 - Creating Pivot Tables

7 - Working with Multiple Dimensions

8 - Working with Multiple Measures

9 - Practical Activity Pivot Tables.html

10 - Complete Practical Activities Pivot Tables

3 - Methods of Aggregation and Grouping

11 - Introduction to Methods of Aggregation and Grouping

12 - Methods of Aggregation

13 - Combining Methods of Aggregation

14 - Grouping Data

15 - Formatting Pivot Tables

16 - Comparison Graphs

17 - Practical Activity Methods of Aggregation.html

18 - Practical Activity Completed Methods of Aggregation

4 - Trend and Date Analysis

19 - Introduction to Trend Analysis

20 - Grouping Date Fields for Trend Analysis

21 - Creating Fields for Trend Analysis

22 - Creating Fields for Trend Analysis Part 2

23 - Trend Charts

24 - Practical Activity Trend Analysis.html

25 - Completed Practical Activity Trend Analysis

5 - Filtering and Top 10 Analysis

26 - Introduction to Filtering and Top 10 Analysis

27 - Filtering Pivot Tables

28 - Top 10 Analysis

29 - Report Filters

30 - Using Slicers to Filter Data

31 - Using Slicers to Filter Multiple Pivot Tables

32 - Practical Activity Filtering.html

33 - Completed Activity Filtering

6 - Analyzing Data and Calculations

34 - Introduction to Analyzing Data and Calculations

35 - Contribution Analysis

36 - Contribution Analysis Part 2

37 - Pie Charts and Contribution Analysis

38 - Difference From and Running Total Calculations

39 - Practical Activity Contribution Analysis.html

40 - Completed Practical Activity Analyzing Data

7 - Frequency Analysis

41 - Introduction to Frequency Analysis

42 - Download the Training Data File.html

42 - EmployeeMaster.xlsx

43 - Frequency Analysis

44 - Frequency Analysis and Charts

45 - Practical Activity Frequency Analysis.html

46 - Practical Activity Completed Frequency Analysis

8 - Conditional Fomatting

47 - Introduction to Conditional Formatting

48 - Conditional Formatting using Rules

49 - Conditional Formatting using Top 10 Analysis

50 - Conditional Formatting using Icons Data Bars and Colour Scales

51 - Practical Activity Conditional Formatting.html

52 - Completed Practical Activity Conditional Formatting

9 - Interactive Dashboards

53 - Introduction to Interactive Dashboards

54 - Practical Activity Human Resource Dashboard.html

55 - Interactive Human Resource Dashboard Part 1

56 - Interactive Human Resource Dashboard Part 2

57 - Practical Activity Finance Dashboard.html

58 - Interactive Finance Dashboard

59 - Interactive Finance Dashboard Part 2

10 - Course Conclusion

60 - Course Conclusion

139,000 تومان

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

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

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

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