Excel in Microsoft Excel 2: Intermediate to Expert advanced

Focused View

Phillip Burton,I Do Data Limited

10:59:47

132 View

1 - Introduction

1 - Introduction.mp4

01:45

2 - Welcome to Udemy.html

3 - Introduction to Udemy.mp4

02:00

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

5 - Curriculum and the Official Microsoft Certifications.mp4

10:24

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.mp4

04:56

6 - Service-invoice-Number-2.xlsx

7 - Modifying custom templates.mp4

03:57

8 - Copy styles from template to template.mp4

03:19

9 - Using a formula to refer to another spreadsheet.mp4

05:53

10 - Reference data in another workbook.mp4

03:15

11 - Refresh and edit workbook links.mp4

07:15

12 - Reference data by using structured references.mp4

05:08

13 - PracticeInvoice1.xlsx

13 - PracticeInvoice2.xlsx

13 - Practice Activity Number 1.html

14 - Answers to Practice Activity 1.mp4

04:12

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.mp4

04:28

16 - Lock and unlock cells.mp4

06:08

17 - Lock and unlock objects and hide formulas.mp4

03:02

18 - Hiding Formulas.mp4

02:32

19 - Protect Workbook.mp4

03:50

20 - Sharing Workbooks.html

21 - Sharing Workbooks.mp4

04:36

21 - linktoarticle.zip

22 - Track Changes.mp4

05:46

23 - Manage Workbook Versions.mp4

06:37

24 - Encrypt a workbook with a password.mp4

04:14

25 - Importing and exporting XML data.mp4

05:56

25 - linktoarticlexml.zip

26 - PracticeActivity.xlsx

26 - Practice Activity Number 2.html

27 - Answers to Practice Activity 2.mp4

03:27

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.mp4

03:53

29 - Perform logical operations by using AND and OR.mp4

05:09

30 - Perform logical operations by using nested functions.mp4

09:49

31 - Perform statistical operations by using COUNTIFS.mp4

06:03

32 - Perform statistical operations by using SUMIFS and AVERAGEIFS.mp4

05:08

33 - Using FREQUENCY.mp4

02:04

34 - Trapping errors with IFERROR and ISERROR.mp4

02:43

35 - PracticeActivity.xlsx

35 - Practice Activity Number 3.html

36 - Answers to Practice Activity 3.mp4

04:53

5 - Level 7 Section 1 Creating PivotTables

37 - Creating our first PivotTable.mp4

07:12

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

38 - PivotTable Options.mp4

07:59

39 - Filtering Data including using Slicers.mp4

05:01

40 - Group PivotTable data.mp4

04:57

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

06:26

42 - PracticeActivity.xlsx

42 - Practice Activity Number 4.html

43 - Answers to Practice Activity 4.mp4

03:14

6 - Level 7 Section 2 Advanced Formatting

44 - Formatting number values.mp4

03:58

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

45 - Custom Formatting number formatting.mp4

11:45

46 - Custom Formatting dates and text.mp4

09:06

47 - CustomFormatting.pdf

47 - Custom Formatting sections and colors.mp4

08:26

48 - Create and manage custom conditional formatting rules.mp4

07:29

49 - Create conditional formatting rules that use formulas.mp4

09:17

50 - PracticeActivity.xlsx

50 - Practice Activity Number 5.html

51 - Answers to Practice Activity 5.mp4

03:20

7 - Level 7 Session 3 Creating PivotCharts and advanced charts

52 - Create PivotCharts.mp4

02:34

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

53 - Manipulate options in and apply styles to existing PivotCharts.mp4

02:54

54 - Create dualaxis charts.mp4

05:37

55 - Add trendlines to charts.mp4

06:36

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

03:07

57 - View chart animations.mp4

04:18

58 - PracticeActivity.xlsx

58 - Practice Activity Number 6.html

59 - Answers to Practice Activity 6.mp4

03:56

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.mp4

04:50

61 - Extract dates and times.mp4

04:36

62 - Serialise numbers by using date and time functions.mp4

05:15

63 - Financial functions.mp4

05:58

64 - PracticeActivity.xlsx

64 - Practice Activity Number 7.html

65 - Answers to Practice Activity 7.mp4

01:26

9 - Level 8 Session 1 Troubleshoot formulas

66 - Level-8-Session-1.xlsx

66 - Trace precedence and dependence.mp4

05:42

67 - Monitor cells and formulas by using the Watch Window.mp4

03:26

68 - Checking for errors.mp4

04:37

69 - Enable iterative calculations and setting iterative calculation options.mp4

04:17

70 - Perform whatif analysis by using Goal Seek.mp4

06:51

71 - Enabling or disabling automatic workbook calculation.mp4

06:21

72 - PracticeActivity.xlsx

72 - Practice Activity Number 8.html

73 - Answers to Practice Activity 8.mp4

02:52

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

74 - Display data in multiple international formats.mp4

11:34

74 - Level-8-Session-2.xlsx

75 - Apply international currency formats.mp4

03:19

76 - Manage multiple options for Body and Heading fonts.mp4

03:55

77 - Modify worksheets for use with accessibility tools.mp4

04:43

78 - PracticeActivity.xlsx

78 - Practice Activity Number 9.html

79 - Answers to Practice Activity 9.mp4

01:28

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.mp4

05:05

81 - Name data ranges and tables.mp4

03:20

82 - Modify named ranges by using Names Manager.mp4

05:13

83 - Navigate across worksheets by using named ranges.mp4

01:53

84 - PracticeActivity.xlsx

84 - Practice Activity Number 10.html

85 - Answers to Practice Activity 10.mp4

01:31

12 - Level 8 Section 4 Formula Arrays

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

86 - Using an array formula and SUMing the result.mp4

05:51

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

05:00

88 - Using Min and Max in Array Formulas.mp4

07:28

89 - Using the TRANSPOSE function.mp4

04:23

90 - Limitations of array formulas.mp4

06:53

91 - Bonus Addingdeleting rows and array formulas.mp4

06:59

92 - PracticeActivity.xlsx

92 - Practice Activity Number 11.html

93 - Answers to Practice Activity 11.mp4

01:58

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

94 - Choosing data sets from external data connections.mp4

07:16

94 - Level-9-Session-1.xlsx

95 - Manage external data connections.mp4

09:06

96 - Power Query installing in Excel 2010 and 2013.mp4

05:59

97 - Importing Data and Display and connect to data.mp4

05:10

98 - Managing Queries.mp4

04:09

99 - Transform and redisplaying reloading data.mp4

05:36

100 - Combine or Append data sets.mp4

04:41

101 - Merge data sets.mp4

04:43

102 - Consolidate data.mp4

07:06

103 - Consolidating data using PivotTables.mp4

06:06

104 - Level-9-Session-1.xlsx

104 - Practice Activity Number 12.html

105 - Answers to Practice Activity 12.mp4

05:47

14 - Level 9 Section 2 The Data Model and PowerPivot

106 - Introduction to the Data Model.mp4

05:07

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

107 - Activating PowerPivot on Excel 2013 and 2016.mp4

02:43

108 - Activating PowerPivot on Excel 2010.mp4

04:05

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

04:17

110 - Manage relationships.mp4

04:28

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

06:25

112 - Power Pivot Advanced Valeries Question Part 1.mp4

07:30

113 - Power Pivot Advanced Valeries Question Part 2.mp4

06:34

114 - Practice Activity Number 13.html

115 - Answers to Practice Activity 13.mp4

02:01

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.mp4

06:22

117 - Create custom colour formats.mp4

02:40

118 - Create and modify cell styles.mp4

03:32

119 - Create and modify custom themes.mp4

03:02

120 - PracticeActivity.xlsx

120 - Practice Activity Number 14.html

121 - Answers to Practice Activity 14.mp4

01:58

16 - Level 9 Session 4 Create advanced formulas

122 - Level-9-Session-4.xlsx

122 - Look up data by using the VLOOKUP function.mp4

05:46

123 - Look up data by using the HLOOKUP function.mp4

02:37

124 - The difference between VLOOKUP and SUMIF or SUMIFS.mp4

03:56

125 - Using VLookup for appropriate matches.mp4

04:25

126 - Look up data by using the MATCH function.mp4

04:17

127 - Look up data by using the INDEX function.mp4

05:35

128 - Using the INDIRECT function.mp4

03:29

129 - Create a dynamic named range.mp4

05:58

130 - Use the Solver addin.mp4

08:15

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

06:51

132 - PracticeActivity.xlsx

132 - Practice Activity Number 15.html

133 - Answers to Practice Activity 15.mp4

05:26

17 - Level 10 Section 1 Link form controls to cells

134 - Inserting form controls.mp4

03:17

135 - Insert Scroll bars and Setting form properties.mp4

05:58

136 - Insert List and Combo boxes.mp4

07:20

137 - Insert check boxes Insert labels and other form controls.mp4

06:04

138 - Practice Activity Number 16.html

139 - Answers to Practice Activity 16.mp4

01:24

18 - Level 10 Session 2 Visual Basic for Applications VBA

140 - Record a macro and Running a macro.mp4

05:02

141 - Running a macro when a button is clicked.mp4

02:08

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

03:46

143 - Opening the VBA Editor.mp4

05:23

144 - Running a macro when a workbook is opened.mp4

06:49

145 - Copy macros between workbooks.mp4

03:33

146 - Assign a shortcut key to an existing macro.mp4

02:14

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

05:26

148 - Create a userdefined function UDF.mp4

05:10

149 - Practice Activity Number 17.html

150 - Answers to Practice Activity 17.mp4

02:32

19 - Conclusion

151 - Where next.mp4

06:10

152 - Thank you very much.mp4

01:07

153 - Bonus Lecture.mp4

07:08

153 - idodatabonuslecture230113.zip

Description

Get Expert certified! Levels 6-10 for Microsoft Excel 2010, 2013, 2016 and Excel 2019. Covers 77-728, 77-427 & 77-428.

What You'll Learn?

Manage workbooks and workbook review
Create and manage PivotTables
Present data visually, using PivotCharts and advanced charts
Perform data analysis and business intelligence
Troubleshoot formulas
Manage and reference defined names and custom workbook elements
And learn lots of formulas, including VLOOKUP, MATCH, INDEX, TRANSPOSE and INDIRECT

Who is this for?

This is for you if you want to develop your Excel skills to an Expert level.

This is also for you if you want to take the Microsoft Office Specialist Expert Exams.

This may not be for you if you are not already at least at an Intermediate level (already done levels 1-5 or equivalent).

More details

Description
This course series has been recorded on Excel 2016 and Excel 2010, but the content also covers Excel 2013 and 2019.
Building on the skills learnt in "Excel in Microsoft Excel 1", here'sÂ levelsÂ 6-10. By the end of this course, you willÂ have the skills needed for the official MicrosoftÂ ExcelÂ Expert exam. How would that look on your resume?
Reviews
"Well thought out and explained in a way which makes it easy to learn & understand." - Arnold Schwartz
"This course is very well structured and the teachers knowledge is very good. His teaching style is capturing and he is very structured. The small tests after each section is great, and even greater is that he takes time to show his thoughts on how is should have been done, not just leaving one to wonder if it was right or not. The resources used in this course is also very suitable. Highly recommend this one" - Daniel Sandberg
------------
Most people who use Excel are up to Level 3 in some aspects, and Level 2 in others. Why not go all the way to Level 10?
In this course, learn how to:
Manage workbook options and settings
Manage ExcelÂ workbooks,
Manage workbook review,
Apply workbook settings, properties and data options, and
Apply logical and statistical functions
Create advanced charts and ExcelÂ tables
Create and manage PivotTables,
Advanced formatting,
Create and manage PivotCharts,
Create advanced charts,
Apply advanced date and time functions
Preparing for advanced formulas
Troubleshoot ExcelÂ formulas,
Manage and reference defined names,
Prepare a workbook for internationalisation and accessibility,
Array formulas.
Automation and advanced formulas
Perform data analysis and business intelligence in Excel.
Visual Basic for Applications (VBA) macros and form controls.
Create and modify custom workbook elements
Look up data by using functions (VLOOKUP, HLOOKUP, MATCH, INDEX, TRANSPOSE and INDIRECT). translated into 15 different languages.
This course teaches allÂ the skills that Microsoft want you to know for the Expert exams. Specifically, they are the skillsÂ required to undertake the Microsoft Certificate 77-851 (for Excel 2007 Expert), 77-888 (for Excel 2010Â Expert), 77-427 and 77-428Â (for Excel 2013Â Expert) and 77-728Â (for Excel 2016 Expert)Â and will be useful if you wish to take the exam, or which to learn more about Microsoft Excel
The core skills which are taught are those tested by Microsoft in the exam. There are topicsÂ thatÂ it wants you to learn aboutÂ Microsoft Excel,Â and this course teaches you all of them.
Each module is taught in order, and is divided in sub-topics, and generally each sub-topic will have an individual lecture lasting 5-7 minutes.
The course will take about 8Â hours to complete, plus will you need additional time to test yourselves to ensure that you have learned the necessary skills.
You should take this course if:
you want to learn more about Microsoft Excel, or
you want to learn the Excel skills you need toÂ become a certified Microsoft Office Specialist Expert.
Regardless whether you have Excel 2007, Excel 2010, Excel 2013, Excel 2016 or Excel 365, this course will help you get to an advancedÂ level, and maybe even want you to get more!
Who this course is for:
This is for you if you want to develop your Excel skills to an Expert level.
This is also for you if you want to take the Microsoft Office Specialist Expert Exams.
This may not be for you if you are not already at least at an Intermediate level (already done levels 1-5 or equivalent).

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Phillip Burton

Instructor's Courses

Hi. I'm Phillip, and I'm proud to Teach with Udemy as a Udemy Instructor Partner. I have been teaching on Udemy since 2015, and I have over 500,000 students and more than 40 video courses, including over a dozen Bestseller courses.My courses include Power BI, Tableau, SQL Server, Power Platform (Power Apps, Power Automate, etc.), Azure, Microsoft Office, and more. Many of my courses follow requirements for official Microsoft certifications - so with a bit of practice, you could enter the exam and put it on your CV or resume.I have been a Computing Consultant providing expert services in the development of computer systems and data analysis. I am one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards. My interests are working with data, including Microsoft Power BI, Excel, Access, SQL Server, and the Power Platform.

I Do Data Limited

Instructor's Courses

I Do Data is dedicated to creating video courses on Udemy in a variety of computer-related topics, such as SQL in its different dialects and Microsoft Office.Are you wanting to learn a new skill from the beginning? Or are you wanting to build on an existing skill? In either case, welcome.Our courses are available on Udemy at any time, so you can watch them whenever you like, as often as you like.For many of our courses, if you master the skills taught, you are able (if you wish) to take (and hopefully pass) the official certification offered by Microsoft, Tableau or other companies. That would look good on your CV or resume? It could make the difference between getting a promotion, or a more rewarding job. I Do Data courses are dedicated to enabling you to succeed.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.