MO-200 Microsoft Excel 365/2019 Associate Certification

Focused View

Dave Murphy

6:34:20

177 View

1 - Introduction

1 - Course Introduction.mp4

04:09

1 - MO-200-Associate-Exercise-Book-Excel-365-2019-V1-2021.pdf

1 - MO-200-Objective-Domain-MOS-Uni.pdf

2 - Extracting the Student Resource files.mp4

01:04

2 - MO-200-Final-Student-Resource-Files.zip

3 - Certiport Registration.txt

3 - Certiport Remote Testing Facilities.txt

3 - Certiport Testing Centre Locator.txt

3 - Exams from Home Test Candidate Guide.txt

3 - Exam Interface Tutorial Review.txt

3 - How the exam is conducted.mp4

05:55

3 - Microsoft Official MO200 Site.txt

4 - Try It Yourself Exercises.mp4

01:16

2 - Introducing the Microsoft Excel User Interface

5 - Introducing the Excel User Interface.mp4

08:38

6 - Essential Navigation Skills.mp4

09:28

7 - Entering Information.mp4

16:49

3 - 11 Import Data into Workbooks

8 - 111 and 112 Part 1 Import Data from txt and csv Files.mp4

07:21

9 - 111 and 112 Part 2 Import Data from txt and csv Files.mp4

07:10

9 - 1112TIY.pdf

9 - Customers.csv

9 - HelpLess-Details.txt

9 - Names.txt

4 - 12 Navigate Within Workbooks

10 - 121 and 122 Search for Data within a Workbook.mp4

07:28

10 - 1212.xlsx

10 - 1212TIY.pdf

11 - 121 Excel 365 Comments and Notes.mp4

01:27

12 - 123.xlsx

12 - 123TIY.pdf

12 - 123 Insert and Remove hyperlinks.mp4

03:58

5 - 13 Format Worksheets and Workbooks

13 - 131.xlsx

13 - 131TIY-v2.pdf

13 - 131 Modify Page Setup.mp4

06:30

14 - 132.xlsx

14 - 132TIY.pdf

14 - 132 Adjust Row Height and Column Width.mp4

02:47

15 - 133.xlsx

15 - 133TIY.pdf

15 - 133 Customise Headers and Footers.mp4

05:26

15 - mos-university.zip

6 - 14 Customise Options and Views

16 - 141.zip

16 - 141TIY.pdf

16 - 141 Customise the Quick Access Toolbar.mp4

02:24

17 - 142.xlsx

17 - 142TIY.pdf

17 - 142 Display and Modify Workbook Content in different Views.mp4

03:12

18 - 143 Freeze Worksheet Rows and Columns.mp4

02:27

19 - 144.xlsx

19 - 144TIY.pdf

19 - 144 Change Window Views.mp4

06:00

20 - 145.xlsx

20 - 145TIY.pdf

20 - 145 Modify Basic Workbook Properties.mp4

02:24

21 - 146.xlsx

21 - 146TIY.pdf

21 - 146 Display Formulas.mp4

01:36

7 - 15 Configure Content for Collaboration

22 - 151.xlsx

22 - 151TIY.pdf

22 - 151 Set a Print Area.mp4

01:09

23 - 152.xlsx

23 - 152TIY.pdf

23 - 152 Save Workbooks in Alternative File Formats.mp4

02:18

24 - 153.xlsx

24 - 153TIY.pdf

24 - 153 Configure Print Settings.mp4

04:39

25 - 154TIY.pdf

25 - 154 Inspect Workbooks for Issues.mp4

08:20

25 - 1541.xlsx

25 - 1542.xlsx

25 - 1543.xlsx

8 - Manage Worksheets & Workbooks Exam Seminar

26 - Seminar Series Manage Worksheets & Workbooks.mp4

31:05

9 - 21 Manipulate Data in Worksheets

27 - 211.xlsx

27 - 211TIY.pdf

27 - 211 Paste Data by Using special Paste Options.mp4

07:50

28 - 212.xlsx

28 - 212TIY.pdf

28 - 212 Fill Cells by using Auto Fill.mp4

02:43

29 - 212 Additional Clarification on Fill Series.mp4

03:37

30 - 213.xlsx

30 - 213TIY.pdf

30 - 213 and 214 Insert and Delete Multiple Columns Rows and Cells.mp4

02:16

30 - 214.xlsx

30 - 214TIY.pdf

10 - 22 Format Cells and Ranges

31 - 221 Merge and Unmerge Cells.mp4

02:05

32 - 222 Modify Cell Alignment and Indentation.mp4

01:54

33 - 223 Format Cells by using Format Painter.mp4

01:34

34 - 224 Wrap Text Within Cells.mp4

01:12

34 - 221234.xlsx

34 - 221234TIY.pdf

35 - 225.xlsx

35 - 225TIY.pdf

35 - 225 Apply Number Formats.mp4

07:06

36 - 226 Apply Cell Formats from the Format Cells Dialog Box.mp4

06:19

37 - 227 Apply Cell Styles.mp4

02:14

37 - 2267.xlsx

37 - 2267TIY.pdf

38 - 228 Clear Cell Formatting.mp4

01:09

11 - 23 Define and Reference Named Ranges

39 - 231 Define a Named Range.mp4

04:06

40 - 232 Name a Table.mp4

02:19

40 - 2312.xlsx

40 - 2312TIY.pdf

12 - 24 Summarise Data Visually

41 - 241.xlsx

41 - 241TIY.pdf

41 - 241 Insert Sparklines.mp4

03:54

42 - 242.xlsx

42 - 242TIY.pdf

42 - 242 Apply Builtin Conditional Formatting.mp4

05:38

43 - 243.xlsx

43 - 243TIY.pdf

43 - 243 Remove Conditional Formatting.mp4

01:34

13 - 31 Create and Format Tables

44 - 311 & 313 Create Excel Tables and Convert Tables from and to Cell Ranges.mp4

05:08

44 - 3113.xlsx

44 - 3113TIY.pdf

45 - 312 322 and 323 Apply and Configure Table Styles including Total Rows.mp4

02:07

14 - 32 Modify Tables

46 - 321 Add or Remove Tables Rows and Columns.mp4

01:30

46 - 3213.xlsx

46 - 3213-and-312TIY.pdf

15 - 33 Filter and Sort Table Data

47 - 331.xlsx

47 - 331TIY.pdf

47 - 331 Filter Records.mp4

05:06

48 - 332.xlsx

48 - 332TIY.pdf

48 - 332 Sort Data by Multiple Columns.mp4

05:44

16 - 41 Insert References

49 - 411 Part 1 Insert Relative Absolute and Mixed References.mp4

09:44

50 - 411.xlsx

50 - 411TIY.pdf

50 - 411 Part 2 Insert Relative Absolute and Mixed References.mp4

06:22

51 - 412.xlsx

51 - 412TIY.pdf

51 - 412 Reference Named Ranges and Named Tables in Formulas.mp4

03:37

17 - 42 Calculate and Transform Data

52 - 421 Perform Calculations using the AVERAGE MAX MIN and SUM Functions.mp4

07:53

53 - 422 Count Cells using the COUNT COUNTA and COUNTBLANK functions.mp4

01:35

53 - 4212.pdf

53 - 4212.xlsx

54 - 423.xlsx

54 - 423TIY.pdf

54 - 423 Perform Conditional Operations by using the IF Function.mp4

10:47

18 - 43 Format and Modify Text

55 - 431 and 432 Format Text RIGHT LEFT MID Upper Len Functions.mp4

03:44

56 - 433 Format Text by using the CONCAT and TEXTJOIN Functions.mp4

04:48

56 - 4313.xlsx

56 - 4313TIY.pdf

19 - 51 Create Charts

57 - 511 Create Charts.mp4

03:24

58 - 512 Create Chart Sheets.mp4

01:17

58 - 5112.xlsx

58 - 5112TIY.pdf

20 - 52 Modify Charts

59 - 521 and 522 Add and Switch Data Series in Charts.mp4

01:02

60 - 523 Add and Modify Chart Elements.mp4

02:08

60 - 52123.xlsx

60 - 52123TIY.pdf

21 - 53 Format Charts

61 - 531 and 532 Apply Chart Layouts and Styles.mp4

01:23

61 - 5312.xlsx

61 - 5312TIY.pdf

62 - 533.xlsx

62 - 533TIY.pdf

62 - 533 Add Alternative Text to Charts for Accessibility.mp4

00:54

22 - MO200 Practice Exam

63 - How To Use the Practice Exam.mp4

01:56

64 - Equipment-Details.txt

64 - Project 1 Solution.mp4

06:49

64 - exam-1-project-1.zip

65 - Project 2 Solution.mp4

03:50

65 - exam-1-project-2.zip

66 - Project 3 Solution.mp4

04:25

66 - exam-1-project-3.zip

67 - Project 4 Solution.mp4

04:51

67 - exam-1-project-4.zip

68 - Project 5 Solution.mp4

04:24

68 - exam-1-project-5.zip

69 - Project 6 Solution.mp4

06:14

69 - exam-1-project-6.zip

23 - Solutions to Course Exercises

70 - Objective Domain 11.mp4

02:26

71 - Objective Domain 12.mp4

05:08

72 - Objective Domain 13.mp4

03:28

73 - Objective Domain 14.mp4

04:56

74 - Objective Domain 15.mp4

03:08

75 - Objective Domain 21.mp4

04:58

76 - Objective Domain 22.mp4

06:05

77 - Objective Domain 23 and 24.mp4

05:53

78 - Objective Domain 31 and 32.mp4

03:59

79 - Objective Domain 33.mp4

03:36

80 - Objective Domain 41 and 42.mp4

08:32

81 - Objective Domain 43.mp4

07:27

82 - Objective Domain 51.mp4

03:52

83 - Objective Domain 52 and 53.mp4

05:07

24 - Bonus Lectures

84 - Bonus Lecture About MOS University.mp4

02:33

Description

80 lectures, individual practice exercises, comprehensive Exercise eBook AND MO-200 practice exam and video solutions

What You'll Learn?

How to successfully pass the MO-200 Microsoft Certified Excel Associate Exam
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 Associate in Excel 365/2019
Guarantee potential Employers of your competence in Microsoft Excel 365/2019

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 MO-200 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 Associate Certification in Excel 2019 or Excel 365

Graduates seeking to gain professional qualifications

What You Need to Know?

The only prerequisite is that you have access to Excel 365/2019 and the willingness to complete the exercises and practice tests.

Please note that MOS exams are all Windows based. This course uses Excel in a Windows environment. Apple Mac users should note that there are differences between the Windows and Mac versions of Excel which are not covered in this course or in the exam.

More details

Description
NEW! Complete MO-200 Practice Exam and Video Solution Added
The course now includes a Practice Exam and Video Solution. The exam has 6 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 MO-200 exam.
NEW! Extra Lecture - Exam Prep Seminar Series MOS University (February 2022)
The course now includes a replay of our MOS University Exam Prep Seminar on Manage Worksheets & Workbooks. This seminar focusses on the style and standard of the project tasks posed in the MO-200 exam. In valuable insights on how you should approach your exam prep!
Reviews Update 1 - Two Students scores 1000/1000 in MO-200 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."

"Hi Dave,
Just wanted to say a quick thank you as I've just completed the MO-200 exam with 1000/1000! I had been putting the training and exam off for far too long but eventually found the time to complete it and am incredibly pleased having done so at last. Your course is brilliant and gave me absolutely everything I needed for the exam as well as some great new techniques I can use on a daily basis at work.
Thanks again,
Danny"

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 Office Specialist (MOS)
The Microsoft Office Specialist: Excel Associate Certification demonstrates competency in the fundamentals of creating and managing worksheets and workbooks, creating cells and ranges, creating tables, applying formulas and functions and creating charts and objects. The exam covers the ability to create and edit a workbook with multiple sheets, and use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs. An individual earning this certification has approximately 150 hours of instruction and hands-on experience with the product, has proven competency at an industry associate-level and is ready to enter into the job market. They can demonstrate the correct application of the principal features of Excel and can complete tasks independently.
Use your knowledge to become a certified Microsoft Excel Associate by preparing for the MO-200 Microsoft Office Specialist exam. 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 MO-200Â Microsoft ExcelÂ Associate exam. A comprehensive series of lectures are provided which cover every step needed to succeed.Â
Become a Microsoft Office SpecialistÂ and Enhance Your Career
Use your knowledge to obtainÂ certified status
Understand the MO-200 Exam
Learn how to correctlyÂ prepare for the test
Get advice from a seasonedÂ professional who knows how to pass the exam

Microsoft ExcelÂ Associate with theÂ MO-200Â 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 MO-200 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 for the MO-200 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.
We have also provided a COMPLETEÂ practice exam set to the standard of the MO-200. This will ensure that on the day of the exam you will be fully confident that your preparation is complete and that you are FULLYÂ ready to get that certification.
When you pass the MO-200 exam, Microsoft issue you with the MOS, or Microsoft Office Specialist Associate certificationÂ status, in 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 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 MO-200 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.Â A comprehensive exercise book covering each section of the Objective Domain is provided. Video solutions for all of the exercises are also included. Having completed this course you will be confident in your skills to become a Microsoft Excel Associate in Excel 365/2019.
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 MO-200 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 Associate Certification in Excel 2019 or Excel 365
Graduates seeking to gain professional qualifications

User Reviews

Rating

average 0

Total votes0

Focused display

Excel VBA

Excel

Excel Analytics

Excel Dashboard

Excel Modeling

Excel Formulas and Functions

Excel Macros

Excel Charts

Excel Shortcuts and Tips

Dave Murphy

Instructor's Courses

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.