77-728 Microsoft Excel 2016 Expert Certification

Focused View

Dave Murphy

9:49:54

144 View

1 - Introduction

1 - Introduction.mp4

02:13

2 - March-2021-Objective-domain-Excel-Expert.pdf

2 - Understanding the Objective Domain.mp4

03:14

3 - COVID19 Testing Arrangements Exams From Home.txt

3 - Certiport Testing Centre Locator.txt

3 - Certiport Tutorial.txt

3 - Console 8 Testing Interface.txt

3 - How is the exam be conducted and what will it be like.mp4

06:06

3 - MOS Expert Excel Microsoft Information.txt

3 - Microsoft Official MOS Site.txt

4 - Try It Yourself Exercises.mp4

01:18

2 - 11 Manage Workbooks

5 - 111T.pdf

5 - 111 Save a Workbook as a Template.mp4

02:55

6 - 112.pdf

6 - 112 Copy Macros between Workbooks.mp4

06:26

6 - macro-version-of-marketing-budget-workbook.zip

7 - 1-pm.xlsx

7 - 9-am.xlsx

7 - 11-am.xlsx

7 - 113TIY.pdf

7 - 113 Reference Data in Another Workbook.mp4

09:33

8 - 1.1.4-Structured-References.pdf

8 - 114 Reference Data by using Structured References.mp4

07:53

9 - 115TIY.pdf

9 - 115 Enable Macros in a Workbook.mp4

03:57

10 - 116TIY.pdf

10 - 116 Display Hidden Ribbon Tabs.mp4

02:07

3 - 12 Manage Workbook Review

11 - 121 Restrict Editing.mp4

09:32

12 - 122 Protect a Worksheet.mp4

10:05

12 - 121122TIY.pdf

12 - Hours-Worked.xlsx

13 - 123TIY.pdf

13 - 123 Configure Formula Calculation Options.mp4

02:50

13 - Hours-Worked.xlsx

14 - 124TIY.pdf

14 - 124 Protect Workbook Structure.mp4

01:12

15 - 125TIY.pdf

15 - 125 Manage Workbook Versions.mp4

06:00

16 - 126TIY.pdf

16 - 126 Encrypt a Workbook with a Password.mp4

04:26

4 - Objective Domain 1 Exercises & Solutions

17 - Domain Objective 1 Manage Workbook Options and Settings Exercises & Solutions.mp4

22:23

17 - HelpLess-Airlines-Passenger-Numbers.xlsx

17 - Objective-Domain-1-Exercises.pdf

17 - Sales-Information-Data.xlsx

5 - 21 Apply Custom Data Formats and Validation

18 - 2.1.1-Custom-Number-Formats.pdf

18 - 211.xlsx

18 - 211TIY.pdf

18 - 211 Create Custom Number Formats.mp4

13:01

19 - 212TIY.pdf

19 - 212 Populate Cells by using Advanced Fill Series Options.mp4

07:10

19 - 212-Resource.xlsx

20 - 9-am.xlsx

20 - 213TIY.pdf

20 - 213 Configure Data Validation.mp4

14:36

6 - 22 Apply Advanced Conditional Formatting and Filtering

21 - 221TIY.pdf

21 - 221 Create Custom Conditional Formatting Rules.mp4

05:09

21 - 221-Monthly-Revenue.xlsx

22 - 222TIY.pdf

22 - 222 Create Conditional Formatting Rules that use Formulas.mp4

03:23

22 - 222-Sales-Information.xlsx

22 - Excel-workbook-for-2.2.2-Conditional-formatting-rules-that-use-formulas.xlsx

22 - Monthly-Revenue.xlsx

23 - 222 TIY Explanatory Lecture.mp4

05:57

24 - 223TIY.pdf

24 - 223 Manage Conditional Formatting Rules.mp4

03:57

24 - 223-Conditions.xlsx

7 - 23 Create and Modify Custom Workbook Elements

25 - 231 Create Custom Colour Formats.mp4

03:15

26 - 232 Create and Modify Cell Styles.mp4

08:45

27 - 233 Create and Modify Custom Themes.mp4

07:54

28 - 234 Part I Create and Modify Simple Macros.mp4

06:49

29 - 234 Part II Create and Modify Simple Macros.mp4

08:15

30 - 235 Part I Insert and Configure Form Controls.mp4

12:01

31 - 2.3.5-Part-II-HelpLess-Airlines-Query-Form.pdf

31 - 235 Part II Insert and Configure Form Controls.mp4

12:20

31 - Template-for-Part-II-Insert-and-Configure-From-Controls.xlsx

32 - 235 Part III Insert and Configure Form Controls.mp4

08:23

8 - 24 Prepare a Workbook for Internationalisation

33 - 241 and 242 Display Data in Multiple International Formats.mp4

10:33

34 - 243 Manage Multiple Options for Body and Heading Fonts.mp4

02:47

9 - Domain Objective 2 Exercises & Solutions

35 - Domain Objective 2 Apply Custom Data Formats and Layouts Exercises & Solutions.mp4

21:49

35 - HelpLess-Airlines-Marketing-Plan-2017-to-2022.xlsx

35 - Objective-Domain-2-Exercises.pdf

35 - Sales-Information-Data.xlsx

10 - 31 Apply Functions in Formulas

36 - 311 Perform Logical Operations by using AND OR and NOT Functions.mp4

05:55

36 - HelpLess-Nested.xlsx

36 - Sales-Information.xlsx

37 - 312 Perform Logical Operations by using Nested Functions.mp4

06:44

38 - 313 Perform Statistical Operations by using SUMIFS AVERAGEIFS and COUNTIFS.mp4

04:42

11 - 32 Look Up Data by using Functions

39 - 321 and 322 Look Up Data by using the VLOOKUP & HLOOKUP Functions.mp4

15:17

40 - Hlookup Clarification Lecture.mp4

08:27

41 - 323 Look Up Data by using the INDEX and MATCH Functions.mp4

15:36

41 - 321234TIY.pdf

41 - Lookup-Functions.xlsx

12 - 33 Apply Advanced Date and Time Functions

42 - 331TIY.pdf

42 - 331 & 2 NOW TODAY Functions and Serialise Numbers.mp4

14:25

42 - 331-Functions.xlsx

13 - 34 Perform Data Analysis and Business Intelligence

43 - Introduction to Domain Objective 34.mp4

06:01

44 - 341 Part I Connecting to Data with Power Pivot.mp4

10:37

45 - 341 Part II More on Power Pivot.mp4

05:54

46 - 341 Part III Measures.mp4

09:24

47 - 341 Part IV Get and Transform.mp4

11:00

48 - 342TIY.pdf

48 - 342 Consolidate Data.mp4

06:30

48 - 342-4-pm.xlsx

48 - 342-9-am.xlsx

49 - 343TIY.pdf

49 - 343 Perform Whatif Analysis by using Goal Seek and Scenario Manager.mp4

09:36

49 - 343-HelpLess-Charter-Scenario.xlsx

49 - 343-HelpLess-Income-Ranges.xlsx

50 - 344 Cube Functions Part I.mp4

07:44

51 - 344 Cube Functions Part II.mp4

05:09

52 - 344 Cube Functions Part III.mp4

06:41

53 - 345TIY.pdf

53 - 345 Calculate Data by using Financial Functions.mp4

10:26

14 - 35 Troubleshoot Formulas

54 - 351 Trace Precedence and Dependence.mp4

02:55

55 - 352 Monitor Cells and Formulas by using the Watch Window.mp4

02:42

56 - 353 Validate Formulas by using Error Checking Rules.mp4

03:46

57 - 351-HelpLess-Income-Ranges.xlsx

57 - 354 Evaluate Formulas.mp4

05:34

57 - 351234TIY.pdf

15 - 36 Define Named Ranges and Objects

58 - 361 and 362 Name Cells and Data Ranges.mp4

06:23

59 - 363 Name Tables.mp4

04:40

60 - 364 Manage Named Ranges and Objects.mp4

03:05

60 - 361234.xlsx

60 - 361234TIY.pdf

16 - Domain Objective 3 Exercises & Solutions

61 - Consolidation-Exercise.xlsx

61 - Cube-functions.xlsx

61 - Domain Objective 3 Create Advanced Formulas Exercises & Solutions.mp4

25:52

61 - Flight-Date-and-Times.xlsx

61 - HelpLess-Airlines-Marketing-Plan-2017-to-2022.xlsx

61 - HelpLess-Charter-Scenarios.xlsx

61 - Raw-Sales-Data.xlsx

61 - Sales-Information-Data.xlsx

61 - Section-3-Exercises-Jan-2019.pdf

61 - Trace-Problems.xlsx

61 - Training-Sales.xlsx

17 - 41 Create Advanced Charts

62 - 411 Add Trendlines to Charts.mp4

05:38

63 - 412TIY.pdf

63 - 412 Create Dualaxis Charts.mp4

05:55

63 - 412-Combo-and-Dual-Axis-Charts.xlsx

64 - 413 Save a Chart as a Template.mp4

02:49

18 - 42 Create and Manage Pivot Tables

65 - 421TIY.pdf

65 - 421 Create Pivot Tables.mp4

08:28

65 - Training-Sales.xlsx

66 - 422TIY.pdf

66 - 422 Modify Field Selections and Options.mp4

05:26

66 - Sales-Information.xlsx

67 - 423TIY.pdf

67 - 423 Create Slicers.mp4

04:53

67 - Sales-Information-Data.xlsx

68 - 424TIY.pdf

68 - 424 Group Pivot Table Data.mp4

03:20

68 - 424-Sales-Information-Data.xlsx

69 - 425 Reference Data in a Pivot Table by using the GETPIVOTDATA Function.mp4

05:40

70 - 426 Add Calculated Fields.mp4

06:00

71 - 427 Format Data.mp4

01:52

19 - 43 Create and Manage Pivot Charts

72 - 431TIY.pdf

72 - 431 Create PivotCharts.mp4

03:16

72 - 431-Training-Sales.xlsx

73 - 432TIY.pdf

73 - 432 Manipulate Options in Existing PivotCharts.mp4

02:58

73 - 432-Training-Sales.xlsx

74 - 433 Apply Styles to PivotCharts.mp4

01:09

75 - 434TIY.pdf

75 - 434 Drill Down into PivotChart Details.mp4

02:20

75 - 434-Training-Sales.xlsx

20 - Domain Objective 4 Exercises & Solutions

76 - Domain Objective 4 Create Advanced Charts and Tables Exercises & Solutions.mp4

19:40

76 - Exercises-Domain-4-Jan-2019.docx

76 - HelpLess-Airlines-Marketing-Plan-2017-to-2022.xlsx

76 - Raw-Sales-Data.xlsx

21 - CUBE Functions Special Lecture

77 - CUBE Function Questions.mp4

06:56

77 - cube-functions-questions-november-2018.zip

22 - 77728 Practice Exam and Video Solutions

78 - Special Exam Considerations.mp4

04:18

79 - How to use the Practice Exam Files.mp4

02:28

80 - Integrated-Project-1-Pilots-and-Passengers-1.xlsx

80 - Project 1 Pilots and Passengers Solution.mp4

04:27

81 - Integrated-Project-2-Income-Analysis.xlsx

81 - Project 2 Income Analysis Solution.mp4

03:34

82 - Integrated-Project-3-Sales-Analysis.xlsx

82 - Project 3 Sales Analysis Solution.mp4

03:41

83 - Integrated-Project-4-Pilot-Performance.xlsx

83 - Project 4 Pilot Performance Solution.mp4

04:39

84 - Integrated-Project-5-Monthly-Merchandise-Sales-Analysis.xlsx

84 - Project 5 Monthly Merchandise Solution.mp4

05:31

85 - Zipped Exam Files.html

85 - Zipped-Exam-Files.zip

23 - Bonus Lecture Discount Coupon Facebook Group

86 - Bonus Lecture MOS University.mp4

01:37

86 - MOS University Facebook Home.txt

86 - MOS University Private Facebook Group.txt

86 - MOS University Website.txt

86 - MOS University YouTube Channel.txt

Description

77-728 Microsoft Certified Excel Expert - includes lectures, test exercises and video solutions PLUS Practice Exam

What You'll Learn?

You will be fully prepared to take the 77-728 MOS exam in Excel Expert
Be familiar with every aspect of the Objective domain for the 77-728 exam
Be expert in the advanced use of Microsoft Excel 2016
Be ready to pass the 77-728 exam

Who is this for?

Anyone who wants to obtain independent certification from Microsoft that they have achieved expert level in the use of Microsoft Excel 2016.

Students who have abilities in Excel and want to achieve independent recognition for those abilities

Students who have passed the 77-727 Core Excel exam and want to progress to the next level

Experts in Excel who would like to get their expertise recognised officially

More details

Description
Important Course Update 2023
We've added some very valuable resources to the course in 2023. An additional section entitled "Practice Exam and Video Solutions" has been included at the end of the course. This section includes a complete practice exam set to the standard of the 77-728 exam. This consists of 5 exam projects together with a video solution for each. Don't review the solutions until you make an attempt at the exam project exercises. This will give you a very real sense of how well prepared you are for the 77-728 expert certification exam.
We've also added a new lecture within this section entitled "Special Exam Considerations". This lecture summarizes some important points about this specific exam that you need to consider carefully. The suggestions are based on direct student experience in taking the exam. In particular we focus on:
Technical issues which arise with the exam interface
Being strategic in your preparation and focus
The best approach to the use of formulas
Use of shortcut keys
Using the 'Mark for Review' option
Issues with the exam interface
Coping with nerves
Lots of really good practical exam advice!

Become a Microsoft Certified Excel Expert
Our Students Understand Value
Expert-level candidates for the Microsoft Excel 2016 exam have an advanced understanding of the Excel environment, and the ability to guide others to the proper use of the programâ€™s features. They can create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations. They can customize their Excel environments to meet project needs and to enhance productivity. Expert workbook examples include custom business templates, multiple-axis financial charts, amortization tables, and inventory schedules. Candidate roles may include accountants, financial analysts, data analysts, commercial bankers, and others.
This course will prepare you to take the 77-728 Excel Expert certification exam from Microsoft. Every aspect of the 77-728 exam is covered in detail, together with exercises and solutions. Delivered by a University professor with many years experience in teaching Excel to undergraduate students, and who is also a Microsoft Office Specialist examiner, if you take this course and follow the guidelines provided, you will enhance your chances of obtaining this valuable qualification. Prove your skills by obtaining independent certification from Microsoft.
This certification is highly regarded by employers because it is independent proof that you have the skills to become productive straight away. That saves a lot of time and effort on the employers part and that value that very highly indeed! The messages and reviews speak for themselves. Our mission is to make you succeed in passing the 77-728. You can do it with our help!

Some recent messages and reviews.....
From Amanda
"I studied Lynda and took the Excel Expert Exam and made a 389. I regrouped and bought Dave's study material, including the practice exams. I learned so much more material that wasn't covered on Lynda through Dave's videos. I took the exam three weeks after studying Dave's tutorials and passed the exam with a 795."
From Christie
"Dave,
Thanks for the great course! I easily passed the Excel Expert exam a couple weeks ago thanks to the materials covered in your course! The lectures were easy to understand and all of the content from your course very relevant in preparing for the exam.
Cheers!
Christie"
From Aicha
" I just passed the test today with 769 !! :) Just can't be happier. The course is really well structured and helpful especially the exercises at the end of each objective !! Thanks Dave , You did a great Job"
From Branislav
"Very specific and targeted topics. I believe it a must for all who attempt the exam."
From Taylor
I can't post it here but I will show my badge earned in the facebook group. I've been studying for roughly a month, with basic data entry experience, and a BCIS course I took in highschool. Needless to say I wasn't very well versed in excel to begin with, and now im an Excel Expert. Im always skeptical about what I buy and strive to recommend as little as possible to friends and family through fear of worth. But this course here is incredible and I can't thank Dave enough for the time and effort he put into it. I'm a bit of a talker to, and Dave was able to get back to me with answers regarding questions I had about the Exam in a very timely manner. Regards, Taylor"

Who this course is for:
Anyone who wants to obtain independent certification from Microsoft that they have achieved expert level in the use of Microsoft Excel 2016.
Students who have abilities in Excel and want to achieve independent recognition for those abilities
Students who have passed the 77-727 Core Excel exam and want to progress to the next level
Experts in Excel who would like to get their expertise recognised officially

User Reviews

Rating

average 0

Total votes0

Focused display

With over twenty years experience as a systems analyst and project manager with significant experience in the design and implementation of major projects for some of the worlds largest companies, Dave Murphy changed career track in 2000 and has been a professional university educator for over 20 years. Dave is currently a lecturer in Business Information Systems with the Technological University Dublin. His main interests are in Microsoft Certifications, Project Management and Business Process Analysis. Dave has a Bachelor in Science degree (Hons) from Trinity College Dublin and a Masters Degree in Computing. In addition to obtaining PRINCE2 Practitioner status, Dave is also a Microsoft Certified Professional in Managing Projects with Microsoft Project, is a MOS Master and a MOS examiner.

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.