MO-211: Microsoft Excel Expert (Microsoft 365 Apps)

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

Learn the skills for the new MO-211 Excel certification. Create PivotTables, simple macros, advanced charts and formulas

1 - Introduction

1 - Introduction

2 - Welcome to Udemy.html

3 - How to get the best out of your Udemy course

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

5 - Curriculum

6 - CustomFormatting.pdf

6 - MO-211ExamRequirements230303.pdf

6 - Resources.html

6 - Section-2-Start.xlsx

2 - Manage workbooks and Prepare workbooks for collaboration

7 - Reference data in other worksheets

7 - Section-2-Start.xlsx

8 - 2 Reference data in other workbooks

9 - 4 Manage workbook versions

10 - 5 6 Protect worksheets and cell ranges and Restrict editing

11 - 7 Protect workbook structure

12 - Practice Activity Number 1.html

13 - Practice Activity Number 1 The Solution

3 - Format and validate data

14 - 12 Create custom number formats integers

14 - CustomFormatting.pdf

14 - Section-3-Start.xlsx

15 - 12 Create custom number formats fractions

16 - 12 Create custom number formats dates and adding text and symbols

17 - 12 Create custom number formats sections and colors

18 - 13 Configure data validation numbers

19 - 13 Configure data validation dates text and circle invalid data

20 - 16 Remove duplicate records

21 - Practice Activity Number 2.html

22 - Practice Activity Number 2 The Solution

4 - Create and modify PivotTables and PivotCharts

23 - 39 Create PivotTables

24 - 44 Configure value field settings

25 - 40 Modify field selections and options PivotTable options and Refresh

26 - 40 Modify field selections and options the PivotTable Analyze and Design tabs

27 - 42 Group PivotTable data

28 - 41 Create slicers

29 - 41 Create timelines

30 - 43 Add calculated fields

31 - 4548 PivotCharts

32 - Practice Activity Number 3.html

33 - Practice Activity Number 3 The Solution

5 - Create and modify advanced charts

34 - 37 Create and modify dualaxis charts

35 - 38a Box Whisker chart

36 - 38b Combo chart and adding a dynamic chart title

37 - 38c Funnel chart

38 - 38d Histogram chart

39 - 38e Sunburst chart

40 - 38f Waterfall chart

41 - Practice Activity Number 4.html

42 - Practice Activity Number 4 The Solution

6 - Perform logical operations in formulas

43 - 20a n 33 IF NOT and using the Evaluate Formula button

44 - 20l m AND and OR

45 - 20l m Nesting AND and OR functions

46 - 20b c IFS SWITCH

47 - 20df SUMIF AVERAGEIF COUNTIF

48 - 20gk SUMIFS AVERAGEIFS COUNTIFS MAXIFS MINIFS

49 - 20o LET

50 - Practice Activity Number 5.html

51 - Practice Activity Number 5 The Solution

7 - Look up data by using functions and use advanced date and time functions

52 - 21bc The VLOOKUP function

53 - 21b The difference between VLOOKUP and SUMIF

54 - 21c HLOOKUP and looking for approximate matches

55 - 21d MATCH

56 - 21e INDEX

57 - 21a XLOOKUP

58 - 22 23 NOW TODAY and WEEKDAY

59 - 23 WORKDAY

60 - Practice Activity Number 6.html

61 - Practice Activity Number 6 The Solution

8 - Perform data analysis

62 - 25 Perform whatif analysis by using Goal Seek

63 - 25b Perform whatif analysis by using Scenario Manager

64 - 26 Forecast data by using the AND IF and NPER functions

65 - 27 Calculate financial data by using the PMT function

66 - 28 Filter data by using FILTER

67 - 29 Sort data by using SORTBY

68 - Practice Activity Number 7.html

69 - Practice Activity Number 7 The Solution

9 - Other formula topics

70 - 8 Configure formula calculation options

71 - 11 Generate numeric data by using RANDARRAY

72 - 14 Group and ungroup data

73 - 15 Calculate data by inserting subtotals and totals

74 - 24 Summarize data from multiple ranges by using the Consolidate feature

75 - 30 Trace precedence and dependence

76 - 31 Monitor cells and formulas by using the Watch Window

77 - 32 Validate formulas by using error checking rules

78 - Practice Activity Number 8.html

79 - Practice Activity Number 8 The Solution

10 - Fill cells based on existing data and apply advanced conditional formatting

80 - 9 Fill cells by using Flash Fill

81 - 10 Fill cells by using advanced Fill Series options

82 - 17 19 Create custom conditional formatting rules and managing rules

83 - 18 Create conditional formatting rules that use formulas number conditions

84 - 18 Create conditional formatting rules that use formulas datetext conditions

85 - Practice Activity Number 9.html

86 - Practice Activity Number 9 The Solution

11 - Create and modify simple macros

87 - 34 35 Record and name simple macros

88 - 3 Enable macros in a workbook

89 - 36 Edit simple macros

90 - 1 Copy macros between workbooks

91 - Practice Activity Number 10.html

92 - Practice Activity Number 10 The Solution

12 - Conclusion

93 - Whats Next

94 - Thank you very much

189,000 تومان

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

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

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

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