Microsoft Excel for Mac 2: Intermediate to Expert advanced

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

Get Expert certified! Levels 6-9 for Microsoft Excel for Mac. Covers 77-728, 77-427 & 77-428.

1 - Introduction

1 - Introduction

2 - Welcome to Udemy.html

3 - Introduction to Udemy

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

2 - Level 6 Section 1 Manage workbooks

5 - Level-6-Session-1-Start.xlsx

5 - Save a workbook as a template

6 - Modifying custom templates

7 - Copy styles from template to template

8 - Using a formula to refer to another spreadsheet

9 - Reference data in another workbook

10 - Refresh and edit workbook links

11 - Reference data by using structured references

12 - PracticeInvoice1.xlsx

12 - PracticeInvoice2.xlsx

12 - Practice Activity Number 1.html

13 - Answers to Practice Activity 1

3 - Level 6 Section 2 Protect documents and Manage workbook review

14 - Level-6-Session-2-Start.xlsx

14 - Restrict editing by protecting a spreadsheet

15 - Lock and unlock cells

16 - Lock and unlock objects and hide formulas

17 - Hiding Formulas

18 - Protect Workbook

19 - Sharing Workbooks

20 - Track Changes

21 - Encrypt a workbook with a password

22 - PracticeActivity.xlsx

22 - Practice Activity Number 2.html

23 - Answers to Practice Activity 2

4 - Level 6 Section 3 Using Logical and Statistical Functions

24 - Level-6-Session-3-Start-Mac.xlsx

24 - Perform logical operations by using the NOT function

25 - Perform logical operations by using AND and OR

26 - Perform logical operations by using nested functions

27 - Perform statistical operations by using COUNTIFS

28 - Perform statistical operations by using SUMIFS and AVERAGEIFS

29 - Using FREQUENCY

30 - Trapping errors with IFERROR and ISERROR

31 - PracticeActivity.xlsx

31 - Practice Activity Number 3.html

32 - Answers to Practice Activity 3

5 - Level 7 Section 1 Creating PivotTables

33 - Creating our first PivotTable

33 - Level-7-Session-1-Start.xlsx

34 - PivotTable Options

35 - Filtering Data including using Slicers

36 - Group PivotTable data

37 - Reference data by using GETPIVOTDATA and add and utilise calculated fields

38 - PracticeActivity.xlsx

38 - Practice Activity Number 4.html

39 - Answers to Practice Activity 4

6 - Level 7 Section 2 Advanced Formatting

40 - Advanced-Formatting-Mac.xlsx

40 - Formatting number values

41 - Custom formatting in graphs and fractions

42 - CustomFormatting.pdf

42 - Custom Formatting number formatting

43 - CustomFormatting.pdf

43 - Custom Formatting dates and text

44 - CustomFormatting.pdf

44 - Custom Formatting sections and colors

45 - Create and manage custom conditional formatting rules

46 - Create conditional formatting rules that use formulas

47 - PracticeActivity.xlsx

47 - Practice Activity Number 5.html

48 - Answers to Practice Activity 5

7 - Level 7 Session 3 Creating PivotCharts and advanced charts

49 - Create PivotCharts

49 - Level-7-Session-3-Start.xlsx

50 - Create dualaxis charts

51 - Add trendlines to charts

52 - Save a chart as a template and create custom chart templates

53 - View chart animations

54 - PracticeActivity.xlsx

54 - Practice Activity Number 6.html

55 - Answers to Practice Activity 6

8 - Level 7 Session 4 Apply advanced date and time and financial functions

56 - Level-7-Session-4-Start.xlsx

56 - Reference the date and time by using the NOW and TODAY functions

57 - Extract dates and times

58 - Serialise numbers by using date and time functions

59 - Financial functions

60 - PracticeActivity.xlsx

60 - Practice Activity Number 7.html

61 - Answers to Practice Activity 7

9 - Level 8 Session 1 Troubleshoot formulas

62 - Level-8-Session-1-Mac.xlsx

62 - Trace precedence and dependence

63 - Checking for errors

64 - Enable iterative calculations and setting iterative calculation options

65 - Perform whatif analysis by using Goal Seek

66 - Enabling or disabling automatic workbook calculation

67 - PracticeActivity.xlsx

67 - Practice Activity Number 8.html

68 - Answers to Practice Activity 8

10 - Level 8 Section 2 Prepare a workbook for internationalisation accessibility

69 - Display data in multiple international formats

69 - Level-8-Session-2-Mac.xlsx

70 - Apply international currency formats

71 - Manage multiple options for Body and Heading fonts

72 - Modify worksheets for use with accessibility tools

73 - PracticeActivity.xlsx

73 - Practice Activity Number 9.html

74 - Answers to Practice Activity 9

11 - Level 8 Section 3 Manage and reference defined names

75 - Level-8-Session-3-Start-Mac.xlsx

75 - Name cells and reference a named formula

76 - Name data ranges and tables

77 - Modify named ranges by using Names Manager

78 - Navigate across worksheets by using named ranges

79 - PracticeActivity.xlsx

79 - Practice Activity Number 10.html

80 - Answers to Practice Activity 10

12 - Level 8 Section 4 Formula Arrays

81 - Level-8-Session-4-Start-Mac.xlsx

81 - Using an array formula and SUMing the result

82 - Using an array formula and outputting the result to a range

83 - Using MINFS and MAXIFS and equivalent Array Formulas

84 - Using the TRANSPOSE function

85 - Limitations of array formulas

86 - Bonus Addingdeleting rows and array formulas

87 - PracticeActivity.xlsx

87 - Practice Activity Number 11.html

88 - Answers to Practice Activity 11

13 - Level 9 Session 3 Create and modify custom workbook elements

89 - Level-9-Session-3-Start-Mac.xlsx

89 - Populate cells by using advanced Fill Series options

90 - Create custom colour formats

91 - Create and modify cell styles

92 - Create and modify custom themes

93 - PracticeActivity.xlsx

93 - Practice Activity Number 14.html

94 - Answers to Practice Activity 14

14 - Level 9 Session 4 Create advanced formulas

95 - Level-9-Session-4-Start-Mac.xlsx

95 - Look up data by using the VLOOKUP function

96 - Look up data by using the HLOOKUP function

97 - The difference between VLOOKUP and SUMIF or SUMIFS

98 - Using VLookup for appropriate matches

99 - Look up data by using the MATCH function

100 - Look up data by using the INDEX function

101 - Using the INDIRECT function

102 - Create a dynamic named range

103 - Use the Solver addin

104 - Perform whatif analysis by using Scenario Manager create compare scenarios

105 - PracticeActivity.xlsx

105 - Practice Activity Number 15.html

106 - Answers to Practice Activity 15

15 - Level 10 Section 1 Link form controls to cells

107 - Inserting form controls

108 - Insert Scroll bars and Setting form properties

109 - Insert List and Combo boxes

110 - Insert check boxes Insert labels and other form controls

111 - Practice Activity Number 16.html

16 - Conclusion

112 - Thank you very much

17 - Level 9 Section 1 PC only Perform data analysis and business intelligence

113 - Welcome to Level 9 Sections 1 and 2.html

114 - Choosing data sets from external data connections

114 - Level-9-Session-1-Start.xlsx

115 - Manage external data connections

116 - Power Query installing in Excel 2010 and 2013

117 - Importing Data and Display and connect to data

118 - Managing Queries

119 - Transform and redisplaying reloading data

120 - Combine or Append data sets

121 - Merge data sets

122 - Consolidate data

123 - Consolidating data using PivotTables

124 - Level9Section1PracticeActivity.xlsx

124 - Practice Activity Number 12.html

125 - Answers to Practice Activity 12

18 - Level 9 Section 2 PC only The Data Model and PowerPivot

126 - Introduction to the Data Model

126 - Level-9-Session-1-Start.xlsx

127 - Activating PowerPivot on Excel 2013 and 2016

128 - Activating PowerPivot on Excel 2010

129 - Utilise PowerPivot and create a PivotTable based on the Excel data model

130 - Manage relationships

131 - Use cube functions to get data out of the Excel data model

132 - PracticeActivity.xlsx

132 - Practice Activity Number 13.html

133 - Answers to Practice Activity 13

19 - Bonus Section

134 - Bonus Lecture

134 - idodatabonuslecture230113.zip

139,000 تومان

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

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

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

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