Excel in Microsoft Excel 3: Pivot Tables Intro & Masterclass

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

Create data analysis in Excel using Pivot Tables with just a few clicks, together with summary Pivot Charts. Exam 70-779

1 - Introduction

1 - Welcome

2 - Welcome to Udemy.html

3 - Curriculum

4 - Do you want autotranslated subtitles in more languages.html

5 - Introduction to Udemy

2 - Creating our first PivotTable and PivotChart

6 - Our first PivotTable

6 - PivotTablesStart.xlsx

7 - PivotTable Menus

8 - Our first PivotChart

9 - PivotChart Menus and An Introduction to Practice Activity 1

10 - Practice Activity Number 1.html

11 - Answer to Practice Activity 1

3 - Expanding our PivotTable

12 - Source data requirements

13 - Adding additional values

14 - Recommended PivotTables

15 - Moving PivotTable

16 - Refresh PivotTable why it doesnt autoupdate

17 - Extracting data

18 - Sorting

19 - Practice Activity Number 2.html

20 - Answer to Practice Activity 2

4 - Going deeper in our PivotTable

21 - Adding additional row fields

22 - Different layouts - Compact Outline and Tabular

23 - Blank Rows

24 - Group Records

25 - Showing or hiding additional detail the buttons

26 - Adding columns

27 - Adding page fields

28 - Adding filters

29 - Changing source

30 - Using a table source

31 - Final options

32 - Introduction to Practice Activity 3

33 - Practice Activity Number 3.html

34 - Answers to Practice Activity 3

5 - Modify field selections

35 - Change aggregate COUNT MIN MAX

36 - Repeat All

37 - Using Conditional Formatting to hide Repeat All

38 - Grand Totals

39 - Adding subtotals

40 - Show items with no data

41 - Other field settings

42 - Practice Activity Number 4.html

43 - Answers to Practice Activity 4

6 - PivotTable Options

44 - Layout

45 - Totals & Filters and Alt Text

46 - Display

47 - Print

48 - Data

49 - Practice Activity Number 5.html

50 - Answers to Practice Activity 5

7 - Slicers Excel 2010 and later

51 - Create slicers

52 - Identifying impossible options and selecting more than one option at once

53 - Join to multiple PivotTables

54 - Options

55 - Practice Activity Number 6.html

56 - Answer to Practice Activity 6

8 - Dates and Timeline

57 - Aggregates

58 - Group by time period

59 - Timelines

60 - Practice Activity Number 7.html

61 - Answer to Practice Activity 7

9 - Formatting

62 - Formatting number values

63 - Custom Formatting number formatting

64 - Custom Formatting dates and text

65 - CustomFormatting.pdf

65 - Custom Formatting sections and colors

66 - Conditional Formatting Highlighting cells

67 - Conditional Formatting Data Bars and Color Sets

68 - Formatting printing

69 - PivotTableFormatting170416.pdf

69 - Styles

70 - Practice Activity Number 8.html

71 - Answer to Practice Activity 8

10 - Advanced calculations

72 - Percentage of total

73 - Percentage of total Advanced

74 - Cumulative totals

75 - Index

76 - Difference from

77 - Calculated fields

78 - Calculated Items

11 - PivotCharts

79 - Relationship of PivotChart with PivotTable

80 - Options and Styles

81 - Bubble charts

12 - Conclusion

82 - Thank you for joining me

83 - Bonus Lecture

45,900 تومان

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

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

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

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