Excel in Microsoft Excel 2: Intermediate to Expert advanced

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

Get Expert certified! Levels 6-10 for Microsoft Excel 2010, 2013, 2016 and Excel 2019. 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

5 - Curriculum and the Official Microsoft Certifications

2 - Level 6 Section 1 Manage workbooks

6 - CD-collection-from-template.xlsx

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

6 - Save a workbook as a template

6 - Service-invoice-Number-2.xlsx

7 - Modifying custom templates

8 - Copy styles from template to template

9 - Using a formula to refer to another spreadsheet

10 - Reference data in another workbook

11 - Refresh and edit workbook links

12 - Reference data by using structured references

13 - PracticeInvoice1.xlsx

13 - PracticeInvoice2.xlsx

13 - Practice Activity Number 1.html

14 - Answers to Practice Activity 1

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

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

15 - Restrict editing by protecting a spreadsheet

16 - Lock and unlock cells

17 - Lock and unlock objects and hide formulas

18 - Hiding Formulas

19 - Protect Workbook

20 - Sharing Workbooks.html

21 - Sharing Workbooks

21 - linktoarticle.zip

22 - Track Changes

23 - Manage Workbook Versions

24 - Encrypt a workbook with a password

25 - Importing and exporting XML data

25 - linktoarticlexml.zip

26 - PracticeActivity.xlsx

26 - Practice Activity Number 2.html

27 - Answers to Practice Activity 2

4 - Level 6 Section 3 Using Logical and Statistical Functions

28 - Level-6-Session-3-Start.xlsx

28 - Perform logical operations by using the NOT function

29 - Perform logical operations by using AND and OR

30 - Perform logical operations by using nested functions

31 - Perform statistical operations by using COUNTIFS

32 - Perform statistical operations by using SUMIFS and AVERAGEIFS

33 - Using FREQUENCY

34 - Trapping errors with IFERROR and ISERROR

35 - PracticeActivity.xlsx

35 - Practice Activity Number 3.html

36 - Answers to Practice Activity 3

5 - Level 7 Section 1 Creating PivotTables

37 - Creating our first PivotTable

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

38 - PivotTable Options

39 - Filtering Data including using Slicers

40 - Group PivotTable data

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

42 - PracticeActivity.xlsx

42 - Practice Activity Number 4.html

43 - Answers to Practice Activity 4

6 - Level 7 Section 2 Advanced Formatting

44 - Formatting number values

44 - Level-7-Session-2-Start.xlsx

45 - Custom Formatting number formatting

46 - Custom Formatting dates and text

47 - CustomFormatting.pdf

47 - Custom Formatting sections and colors

48 - Create and manage custom conditional formatting rules

49 - Create conditional formatting rules that use formulas

50 - PracticeActivity.xlsx

50 - Practice Activity Number 5.html

51 - Answers to Practice Activity 5

7 - Level 7 Session 3 Creating PivotCharts and advanced charts

52 - Create PivotCharts

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

53 - Manipulate options in and apply styles to existing PivotCharts

54 - Create dualaxis charts

55 - Add trendlines to charts

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

57 - View chart animations

58 - PracticeActivity.xlsx

58 - Practice Activity Number 6.html

59 - Answers to Practice Activity 6

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

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

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

61 - Extract dates and times

62 - Serialise numbers by using date and time functions

63 - Financial functions

64 - PracticeActivity.xlsx

64 - Practice Activity Number 7.html

65 - Answers to Practice Activity 7

9 - Level 8 Session 1 Troubleshoot formulas

66 - Level-8-Session-1.xlsx

66 - Trace precedence and dependence

67 - Monitor cells and formulas by using the Watch Window

68 - Checking for errors

69 - Enable iterative calculations and setting iterative calculation options

70 - Perform whatif analysis by using Goal Seek

71 - Enabling or disabling automatic workbook calculation

72 - PracticeActivity.xlsx

72 - Practice Activity Number 8.html

73 - Answers to Practice Activity 8

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

74 - Display data in multiple international formats

74 - Level-8-Session-2.xlsx

75 - Apply international currency formats

76 - Manage multiple options for Body and Heading fonts

77 - Modify worksheets for use with accessibility tools

78 - PracticeActivity.xlsx

78 - Practice Activity Number 9.html

79 - Answers to Practice Activity 9

11 - Level 8 Section 3 Manage and reference defined names

80 - Level-8-Session-3-Start.xlsx

80 - Name cells and reference a named formula

81 - Name data ranges and tables

82 - Modify named ranges by using Names Manager

83 - Navigate across worksheets by using named ranges

84 - PracticeActivity.xlsx

84 - Practice Activity Number 10.html

85 - Answers to Practice Activity 10

12 - Level 8 Section 4 Formula Arrays

86 - Level-8-Session-4-Start.xlsx

86 - Using an array formula and SUMing the result

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

88 - Using Min and Max in Array Formulas

89 - Using the TRANSPOSE function

90 - Limitations of array formulas

91 - Bonus Addingdeleting rows and array formulas

92 - PracticeActivity.xlsx

92 - Practice Activity Number 11.html

93 - Answers to Practice Activity 11

13 - Level 9 Section 1 Perform data analysis and business intelligence

94 - Choosing data sets from external data connections

94 - Level-9-Session-1.xlsx

95 - Manage external data connections

96 - Power Query installing in Excel 2010 and 2013

97 - Importing Data and Display and connect to data

98 - Managing Queries

99 - Transform and redisplaying reloading data

100 - Combine or Append data sets

101 - Merge data sets

102 - Consolidate data

103 - Consolidating data using PivotTables

104 - Level-9-Session-1.xlsx

104 - Practice Activity Number 12.html

105 - Answers to Practice Activity 12

14 - Level 9 Section 2 The Data Model and PowerPivot

106 - Introduction to the Data Model

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

107 - Activating PowerPivot on Excel 2013 and 2016

108 - Activating PowerPivot on Excel 2010

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

110 - Manage relationships

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

112 - Power Pivot Advanced Valeries Question Part 1

113 - Power Pivot Advanced Valeries Question Part 2

114 - Practice Activity Number 13.html

115 - Answers to Practice Activity 13

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

116 - Level-9-Session-3.xlsx

116 - Populate cells by using advanced Fill Series options

117 - Create custom colour formats

118 - Create and modify cell styles

119 - Create and modify custom themes

120 - PracticeActivity.xlsx

120 - Practice Activity Number 14.html

121 - Answers to Practice Activity 14

16 - Level 9 Session 4 Create advanced formulas

122 - Level-9-Session-4.xlsx

122 - Look up data by using the VLOOKUP function

123 - Look up data by using the HLOOKUP function

124 - The difference between VLOOKUP and SUMIF or SUMIFS

125 - Using VLookup for appropriate matches

126 - Look up data by using the MATCH function

127 - Look up data by using the INDEX function

128 - Using the INDIRECT function

129 - Create a dynamic named range

130 - Use the Solver addin

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

132 - PracticeActivity.xlsx

132 - Practice Activity Number 15.html

133 - Answers to Practice Activity 15

17 - Level 10 Section 1 Link form controls to cells

134 - Inserting form controls

135 - Insert Scroll bars and Setting form properties

136 - Insert List and Combo boxes

137 - Insert check boxes Insert labels and other form controls

138 - Practice Activity Number 16.html

139 - Answers to Practice Activity 16

18 - Level 10 Session 2 Visual Basic for Applications VBA

140 - Record a macro and Running a macro

141 - Running a macro when a button is clicked

142 - Creating a custom macro button on the Quick Access Toolbar

143 - Opening the VBA Editor

144 - Running a macro when a workbook is opened

145 - Copy macros between workbooks

146 - Assign a shortcut key to an existing macro

147 - Creating forms and Modify tab order among workbook elements and objects

148 - Create a userdefined function UDF

149 - Practice Activity Number 17.html

150 - Answers to Practice Activity 17

19 - Conclusion

151 - Where next

152 - Thank you very much

153 - Bonus Lecture

153 - idodatabonuslecture230113.zip

45,900 تومان

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

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

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

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