77-727 Microsoft Excel 2016 Core Certification

Focused View

Dave Murphy,Ann Murphy

7:29:55

117 View

1 - Introduction

1 - What is Microsoft Office Specialist MOS Certification.mp4

04:33

2 - Objective-Domain-MOS-Uni.pdf

2 - Understanding the Objective Domain.mp4

03:17

3 - Certiport Testing Centre Locator.txt

3 - Certiport Tutorial.txt

3 - Compass Overview.txt

3 - Exams from Home Information.txt

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

05:12

3 - MOS Core Excel Microsoft Information.txt

4 - Try It Yourself Exercises.mp4

01:18

2 - Introducing the Microsoft Excel User Interface

5 - Introducing the Excel User Interface.mp4

08:42

6 - Essential Navigation Skills.mp4

09:32

7 - Entering Information.mp4

17:07

3 - Student Exercise Files

8 - Course Exercise Workbook.html

8 - Course-Workbook-March-2020.pdf

9 - Student Files.mp4

01:01

9 - Student-Resource-Files-April-2020.zip

4 - 11 Create Worksheets and Workbooks

10 - 111.pdf

10 - 111 Create a Workbook.mp4

02:44

11 - 112TIY.pdf

11 - 112 Importing Data from a Delimited Text File.mp4

05:03

11 - Customers.csv

11 - HelpLess-Details.txt

11 - Names.txt

12 - 113TIY.pdf

12 - 113 Add a Worksheet to an Existing Workbook.mp4

02:01

12 - Multi-Sheets.xlsx

13 - 114.xlsx

13 - 114TIY.pdf

13 - 114 Copy and Move a Worksheet.mp4

02:59

14 - Exercises Domain 11.mp4

07:53

14 - Objectives-1.1-Exercises-MOS-University.pdf

5 - 12 Navigate in Worksheets and Workbooks

15 - 121 & 122 Search & Navigate to a Named Cell Range or Workbook Element.mp4

07:51

15 - 1212.pdf

15 - 1212.xlsx

16 - 122 Named Ranges.mp4

04:25

17 - 123.pdf

17 - 123.xlsx

17 - 123 Insert and Remove hyperlinks.mp4

03:57

18 - Exercises Domain 12.mp4

07:46

18 - Objective-1.2-Exercises.pdf

6 - 13 Format Worksheets and Workbooks

19 - 131 to 133 Changing Worksheet Characteristics.mp4

02:11

19 - 13123.xlsx

19 - 13123TIY.pdf

20 - 134.xlsx

20 - 134TIY.pdf

20 - 134 Modify Page Setup.mp4

06:33

21 - 135.xlsx

21 - 135TIY.pdf

21 - 135 Insert and Delete Columns or Rows and Cells.mp4

05:08

22 - 136.xlsx

22 - 136TIY.pdf

22 - 136 Change Workbook Themes.mp4

01:55

23 - 137.xlsx

23 - 137TIY.pdf

23 - 137 Adjust Row Height and Column Width.mp4

02:50

24 - 138.xlsx

24 - 138TIY.pdf

24 - 138 Insert Headers and Footers.mp4

05:27

25 - Exercises Domain 13.mp4

06:31

25 - Objective-1.3-Exercises-MOS-University.pdf

7 - 14 Customise Options and Views for Worksheets and Workbooks

26 - 141 and 142 Hide or Unhide Worksheets Columns and Rows.mp4

02:19

26 - 1412.xlsx

26 - 1412TIY.pdf

27 - 143.zip

27 - 143TIY.pdf

27 - 143 Customise the Quick Access Toolbar.mp4

02:27

28 - 144.xlsx

28 - 144TIY.pdf

28 - 144 Change Workbook Views.mp4

03:16

29 - 145.xlsx

29 - 145TIY.pdf

29 - 145 Change Window Views.mp4

08:12

30 - 146.xlsx

30 - 146TIY.pdf

30 - 146 Modify Document Properties.mp4

02:28

31 - 147.xlsx

31 - 147TIY.pdf

31 - 147 Change Magnification by using Zoom Tools.mp4

01:17

32 - 148.xlsx

32 - 148TIY.pdf

32 - 148 Display Formulas.mp4

01:40

33 - Exercises Domain 14.mp4

05:03

33 - Objective-1.4-Exercises-MOS-Uni.pdf

8 - 15 Configure Worksheets and Workbooks for Distribution

34 - 151.xlsx

34 - 151TIY.pdf

34 - 151 Set a Print Area.mp4

01:12

35 - 152.xlsx

35 - 152TIY.pdf

35 - 152 Save Workbooks in Alternative File Formats.mp4

02:21

36 - 153 Print All of Part of a Workbook.mp4

01:23

37 - 154 Set Print Scaling.mp4

03:31

38 - 155 Display Repeating Row and Column Titles on Multipage Worksheets.mp4

02:00

38 - 15345.xlsx

38 - 15345TIY.pdf

39 - 156.xlsx

39 - 156TIY.pdf

39 - 156 Inspect a Workbook for Hidden Properties or Personal Information.mp4

02:16

40 - 157.xlsx

40 - 157TIY.pdf

40 - 157 Inspect a Workbook for Accessibility Issues.mp4

03:40

41 - 158.xlsx

41 - 158TIY.pdf

41 - 158 Inspect a Workbook for Compatibility Issues.mp4

02:48

42 - Exercises 15.mp4

03:09

42 - Objective-1.5-Exercises-MOS-Uni.pdf

9 - Manage Worksheets & Workbooks Exam Seminar

43 - Seminar Series Manage Worksheets & Workbooks.mp4

31:05

10 - 21 Insert Data in Cells and Ranges

44 - 211.xlsx

44 - 211TIY.pdf

44 - 211 Replace Data.mp4

03:01

45 - 212.xlsx

45 - 212TIY.pdf

45 - 212 Cut Copy or Paste Data.mp4

03:50

46 - 213.xlsx

46 - 213TIY.pdf

46 - 213 Paste Data by using Special Paste Options.mp4

04:21

47 - 214.xlsx

47 - 214TIY.pdf

47 - 214 Fill Cells by using Auto Fill.mp4

02:47

48 - 215.xlsx

48 - 215TIY.pdf

48 - 215 Insert and Delete Cells.mp4

01:19

49 - Exercises Domain 21.mp4

05:48

49 - Objectives-2.1-Exercises-MOS-Uni.pdf

11 - 22 Format Cells and Ranges

50 - 221 Merge Cells.mp4

02:02

51 - 222 Modify Cell Alignment and Indentation.mp4

01:53

52 - 223 Format Cells by using Format Painter.mp4

01:38

53 - 224 Wrap Text Within Cells.mp4

01:16

53 - 221234.xlsx

53 - 221234TIY.pdf

54 - 225.xlsx

54 - 225TIY.pdf

54 - 225 Apply Number Formats.mp4

06:59

55 - 226 Apply Cell Formats.mp4

06:31

56 - 227 Apply Cell Styles.mp4

02:17

56 - 2267.xlsx

56 - 2267TIY.pdf

57 - Exercises Domain 22.mp4

07:07

57 - Objective-2.2-Exercises-MOS-Uni.pdf

12 - 23 Summarise and Organise Data

58 - 231.xlsx

58 - 231TIY.pdf

58 - 231 Insert Sparklines.mp4

04:07

59 - 232 and 233 Outline Data and Insert Subtotals.mp4

08:10

59 - 2323.xlsx

59 - 2323TIY.pdf

60 - 234.xlsx

60 - 234TIY.pdf

60 - 234 Apply Conditional Formatting.mp4

05:27

61 - Exercises Domain 23.mp4

04:55

61 - Objective-2.3-Exercises-MOS-Uni.pdf

13 - 31 and 32 Create and Manage Tables

62 - 311 and 312 Create an Excel Table from a Cell Range and Reverse.mp4

05:11

63 - 313 Add or Remove Table rows and Columns.mp4

01:30

64 - 321 to 323 Table Styles.mp4

02:10

64 - 3123.xlsx

64 - 3123TIY.pdf

65 - Exercises Domain 31 and 32.mp4

02:28

65 - Objectives-3.1-and-3.2-Exercises-MOS-Uni.pdf

14 - 33 Filter and Sort a Table

66 - 331.xlsx

66 - 331TIY.pdf

66 - 331 Filter Records.mp4

05:11

67 - 332 and 333 Sort Data.mp4

05:47

68 - 334 Remove Duplicate Records.mp4

01:15

68 - 33234.xlsx

68 - 33234TIY.pdf

69 - Exercises Domain 33.mp4

04:23

69 - Objective-3.3-Exercises-MOS-Uni.pdf

15 - 41 Summarise Data by Using Functions

70 - 411 Part I Insert References.mp4

09:47

71 - 411.xlsx

71 - 411TIY.pdf

71 - 411 Part II Absolute References.mp4

06:25

72 - 412 Perform Calculations by using the SUM Function.mp4

05:15

73 - 413 to 415 Using the Average MIN MAX and COUNT Functions.mp4

03:34

73 - 4125.xlsx

73 - 4125TIY.pdf

74 - Exercises Domain 41.mp4

07:11

74 - Objective-4.1-Exercises-MOS-Uni.pdf

16 - 42 Perform Conditional Operations by Using Functions

75 - 421.xlsx

75 - 421TIY.pdf

75 - 421 Perform Logical Operations by using the IF Function.mp4

10:55

76 - 422 to 424 Using the AverageIF COUNTIF and SUMIF Functions.mp4

04:05

76 - 4224.xlsx

76 - 4224TIY.pdf

77 - Exercises Domain 42.mp4

08:55

77 - Objective-4.2-Exercises-MOS-Uni.pdf

17 - 43 Format and Modify Text by Using Functions

78 - 431 to 433 Format Text by using Text Functions.mp4

08:17

78 - 4313.xlsx

78 - 4313TIY.pdf

79 - Exercises Domain 43.mp4

04:28

79 - Objective-4.3-Exercises-MOS-Uni.pdf

18 - 51 Create Charts

80 - 511 Create a New Chart.mp4

03:32

81 - 512 and 513 Add Additional Data Series and Switch Rows and Columns.mp4

01:05

82 - 514 Analyse Data by using Quick Analysis.mp4

02:18

82 - 5114.xlsx

82 - 5114TIY.pdf

83 - Exercises Domain 51.mp4

03:23

83 - Objective-5.1-Exercises-MOS-Uni.pdf

19 - 52 Format Charts

84 - 521 Resize Charts.mp4

01:44

85 - 522 Add and Modify Chart Elements.mp4

02:11

86 - 523 and 524 Apply Chart Layouts and Styles and Move Charts.mp4

01:34

86 - 5214.xlsx

86 - 5214TIY.pdf

87 - Exercises Domain 52.mp4

03:27

87 - Objective-5.2-Exercises-MOS-Uni.pdf

20 - 53 Insert and Format Objects

88 - 531 Insert Text Boxes and Shapes.mp4

02:15

89 - 532 Insert Images.mp4

03:10

90 - 533 Modify Object Properties.mp4

10:16

91 - 534 Add Alternative Text to Objects for Accessibility.mp4

00:53

91 - 5314.xlsx

91 - 5314TIY.pdf

91 - moss-university-logo4.zip

92 - Exercises Domain 53.mp4

05:11

92 - Objective-5.3-Exercises-MOS-Uni.pdf

21 - 77727 Sample Practice Exam

93 - How To Use the Practice Exam.mp4

01:56

94 - Project 1 Solution.mp4

04:36

94 - project-1-pilots-and-passengers.zip

95 - Project 2 Solution.mp4

04:10

95 - project-2-income-analysis.zip

96 - Project 3 Solution.mp4

04:30

96 - project-3-sales-analysis.zip

97 - Project 4 Solution.mp4

03:25

97 - project-4-pilot-performance.zip

98 - Project 5 Solution.mp4

03:39

98 - project-5-monthly-merchandise-sales-analysis.zip

99 - Project 6 Solution.mp4

03:49

99 - project-6-helpless-airlines-marketing-plan-2017-to-2022.zip

100 - Project 7 Solution.mp4

04:00

100 - project-7-training-sales.zip

22 - Bonus Lecture

101 - Bonus Lecture About MOS University.mp4

02:33

Description

Prepare with confidence for the 77-727! Includes complete exercise book, individual lecture exercises and practice exam!

What You'll Learn?

How to successfully pass the 77-727 Microsoft Certified Exam in Core Excel and become a Microsoft Office Specialist
Be confident and competent in your use of Microsoft Excel for everyday business use
Be ready to begin to study to become a certified Microsoft Office Specialist
Guarantee potential Employers of your competence in Microsoft Excel

Who is this for?

Students who are either total beginners with Microsoft Excel or who are intermediate users who want to obtain certification in Core Excel

Existing users of Excel who want to learn how to pass the 77-727 exam and obtain official certification for their skills.

Existing users of Excel who want to have access to the type of exercises which will ensure they will pass the Microsoft Office Specialist certification in Core Excel 2016

Graduates seeking to gain professional qualifications

More details

Description
NEW! Complete 77-727 Practice Exam and Video Solutions Added (March 2023)
The course now includes a Practice Exam and Video Solution. The exam has 7 individual projects with 5 or 6 tasks per project. Video solutions are provided for every task. As MOS Examiners and University Lecturers we really know what is required to pass at the 1st attempt. These practice exam projects are set to the standard and style of the exam and will ensure that you are completely familiar with the style and terminology used in the actual 77-727 exam.
Reviews Update 1 - Student scores 1000/1000 in exam!
"I like having multiple project tasks to be able to complete/practice; with a good variety in questions. Its also extremely helpful to my learning to then to be able to watch the video solutions after. Update: I took the certification exam and scored 1000/1000!!! Using this course, I was completely prepared for the questions!!!! Definitely recommend."
Reviews Update 2 - Student winsÂ UK & Ireland MOS Excel Championship. Qualifies for World Championship!
One of our students has completed against 30,000 other competitors to win the UK & Ireland MOSÂ Championship in Excel. She will now go on to compete in the World Championship in November. This is a major achievement and we are proud to have been part of this students preparation and success!
The above level of achievement doesn't happen without effort and the correct preparation. Our instructors REALLYÂ know what is required if you are to succeed in your MOSÂ exam at the 1st attempt. Don't risk your exam fees! MOSÂ University will make sure that you have the best possible chance to obtain these valuable certifications. Our expert instructors are all MOSÂ Masters and University Professors with many years experience in preparing students to take MOSÂ exams. Up to date materials, expert tuition, focused exercises and sample exam questions will all ensure that your pathway to success is assured.

Microsoft Certification in Core Excel (MOS 77-727)
This course will prepare youÂ for the Microsoft Office SpecialistÂ Exam 77-727. Developed by University Lecturers who are also MOSÂ Masters, Microsoft Certified Professionals and MOSÂ examiners, no course on Udemy or any other educational platform can surpass this content.Â With over 90 lectures covering every possible aspect of the 77-727 syllabus, you can be 100% certain that your knowledge of the skills required to succeed will be excellent. In addition to an explanation of every required certification technique, the course provides an overview of the exam, the objective requirements set by Microsoft,Â tips on how to prepare and what to expect on the day of the test.Â It includesÂ a comprehensive bank of test exercisesÂ which reflect the style of questions asked in the 77-727Â Microsoft Core ExcelÂ exam. Virtually every lecture has a special set of exercises called 'Try It Yourself' which allow you to make sure you've understood the techniques demonstrated in the lecture.
Become a Microsoft Office SpecialistÂ and Enhance Your Career
No prior knowledge required
Start from scratch and get Microsoft to certify your skills in this hugely important technical skill
Understand the requirements of the 77-727Â Certification Exam
Learn how to correctlyÂ prepare for the test
Get advice from seasonedÂ professionals who know how to pass the exam

Core ExcelÂ with theÂ MOS 77-727Â Exam
This course is suitable forÂ people at all levels of proficiency in Microsoft Excel.Â If you are new to the subject, then the course will lead you step by step through every single technique which is tested in the 77-727 exam. If you are already proficient in the use of Excel to some extent, then this course will help you to understand what is required in order to obtain a valuable certification in the subject.Â
Every element of the objective domain (Microsoft Syllabus)Â for the 77-727 exam is comprehensively covered, together with exercises designed to ensure that you know the style and types of questions which you are required to answer in the exam.
When you pass the 77-727Â exam, Microsoft issue you with the MOS, or Microsoft Office Specialist certificationÂ status, in core Excel. Obtaining this certification provides tangible evidence that you are proficient in your use of Microsoft Excel and your LinkedIn profile will be automatically adjusted by Microsoft to reflect this achievement.Â
If you follow and complete the course and exercises you will really optimise your chances of gaining that qualification, you will enhance your status in your existing job and boost your job prospects in the marketplace.Â Â
Content and Overview
Suitable for beginners or for anyoneÂ who has a reasonable knowledge of Microsoft Excel,Â this course is aimed at you obtaining certification status from Microsoft by passing the 77-727Â exam. Rather than simply provide sample questions, the course explains how the exam is structured, the way that the questions shouldÂ be approached and how to study successfully to pass. The course alsoÂ includes invaluable advice on the best way to prepare and what to expect from the testingÂ process.Â
Who this course is for:
Students who are either total beginners with Microsoft Excel or who are intermediate users who want to obtain certification in Core Excel
Existing users of Excel who want to learn how to pass the 77-727 exam and obtain official certification for their skills.
Existing users of Excel who want to have access to the type of exercises which will ensure they will pass the Microsoft Office Specialist certification in Core Excel 2016
Graduates seeking to gain professional qualifications

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.

Ann Murphy

Instructor's Courses

With over 25 years teaching at university level, Ann has been teaching Microsoft Office Applications to both undergraduate students and business clients for many years and has multiple MOS Certifications, in addition to being a MOS Examiner.She has a 1st class Honors B.Sc. degree in Information Technology and a Postgraduate qualification in IT for Strategic Management.Prior to her career as a University Lecturer, Ann owned her own consultancy company delivering business solutions and training to many varied clients. She enjoys interacting with enthusiastic students and wants to bring her expertise to as many Udemy students as possible. This combination of experience from both a teaching and learning background makes Ann uniquely qualified to develop and deliver courses to Udemy students.

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.