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