Complete Techniques for MO-210 Excel 365 Apps Certification

Focused View

Dave Murphy

5:34:34

32 View

01 - Introduction

001 Course Introduction.mp4

04:34

001 Exercise-Book-for-MO-210-Excel-Associate.pdf

001 MO-210-Skills-Measured.pdf

002 How the exam is conducted.mp4

05:55

003 Try It Yourself Exercises.mp4

01:16

external-links.txt

02 - Introducing the Microsoft Excel User Interface

001 Introducing the Excel 365 Apps User Interface.mp4

08:02

002 Essential Navigation Skills.mp4

09:07

003 Entering Information.mp4

16:32

03 - Import Data Into Workbooks

001 Customers.csv

001 HelpLess-Details.txt

001 Import Data into Workbooks.mp4

12:01

001 Import-Data-into-Workbooks-TIY.pdf

001 Names.txt

001 employees.zip

04 - Navigate Within Workbooks

001 Search for Data within a Workbook.mp4

09:56

001 Search-For-Data-within-a-Workbook-TIY.pdf

001 Search-for-Data.xlsx

002 Hyperlinks.xlsx

002 Navigate.xlsx

002 Navigate to Named Cells, Ranges etc - Insert and Remove Hyperlink.mp4

04:50

002 Navigate-Within-Workbooks-TIY.pdf

05 - Format Worksheets and Workbooks

001 Modify Page Setup.mp4

06:07

001 Modify-Page-Setup.pdf

001 Modify-Page-Setup.xlsx

002 Adjust Row Height and Column Width.mp4

02:45

002 Adjust-Row-Height-and-Column-Width.xlsx

002 Adjust-Row-Height-and-Column-Width-TIY.pdf

003 Customise Headers and Footers.mp4

05:19

003 Customise-Headers-and-Footers.pdf

003 Customise-Headers-and-Footers.xlsx

004 Customise-the-QAT.pdf

004 Manage the Quick Access Toolbar.mp4

02:30

004 customise-the-qat.zip

005 Display and Modify Worksheets in Different Views.mp4

03:17

005 Display-and-Modify-Worksheets-in-Different-Views-TIY.pdf

005 Display-in-Different-Views.xlsx

006 Freeze Worksheet Rows and Columns.mp4

03:22

007 Change Window Views.mp4

05:59

007 Change-Window-Views.pdf

007 Change-Window-Views.xlsx

008 Modify Built-in Workbook Properties.mp4

02:25

008 Modify-Built-in-Properties.pdf

008 Modify-Properties.xlsx

009 Display Formulas.mp4

01:39

009 Display-Formulas.pdf

009 Display-Formulas.xlsx

06 - Prepare Workbooks for Collaboration and Distribution

001 Set a Print Area.mp4

01:07

001 Set-a-Print-Area.pdf

001 Set-a-Print-Area.xlsx

002 Save and Export Workbooks in Alternative File Formats.mp4

04:10

002 Save-Alternatives.xlsx

002 Save-and-Export-Workbooks-in-Alternative-File-Formats.pdf

003 Configure Print Settings.mp4

04:38

003 Configure-Print-Settings.pdf

003 Configure-Print-Settings.xlsx

004 Inspect1.xlsx

004 Inspect2.xlsx

004 Inspect3.xlsx

004 Inspect Workbooks and Correct Issues.mp4

08:15

004 Inspect-and-Correct-Issues.pdf

005 Manage Comments and Notes.mp4

03:11

005 Manage-Comments.xlsx

005 Manage-Comments-TIY.pdf

07 - Manipulate Data in Worksheets

001 Paste Data by using Special Paste Options.mp4

07:58

001 Paste-Special.pdf

001 Paste-Special.xlsx

002 Auto-Fill.pdf

002 Auto-Fill.xlsx

002 Fill Cells by using Auto Fill.mp4

02:43

003 Insert and Delete Multiple Columns, Rows and Cells.mp4

02:22

003 Insert-Delete.xlsx

003 Insert-and-Delete.pdf

004 Generate Numeric Data by using RANDBETWEEN() and SEQUENCE().mp4

02:20

004 RANDBETWEEN-SEQUENCE.xlsx

004 Randbetween-Sequence.pdf

08 - Format Cells and Ranges

001 Merge and Unmerge Cells.mp4

02:03

002 Modify Cell Alignment, Orientation and Indentation.mp4

01:48

003 Format Cells by using Format Painter.mp4

01:43

004 Merge-Align.pdf

004 Merge-Align.xlsx

004 Wrap Text within Cells.mp4

01:10

005 Apply Number Formats.mp4

07:04

005 Apply-Number-Formats.pdf

005 Apply-Number-Formats.xlsx

006 Apply Cell Formats from the Format Cells Dialog Box.mp4

06:17

007 Apply Cell Styles.mp4

02:09

007 Apply-Cell-formats.xlsx

007 Apply-Cell-formats-and-Styles.pdf

008 Apply-Cell-formats.xlsx

008 Apply-Cell-formats-and-Styles.pdf

008 Clear Cell Formatting.mp4

01:07

09 - Define and Reference Named Ranges

001 Define and Reference a Named Range.mp4

04:04

001 Define-and-Refererence-Named-Range.pdf

001 Named-Range.xlsx

10 - Summarize Data Visually

001 Insert Sparklines.mp4

03:52

001 Insert-sparklines.pdf

001 Sparklines.xlsx

002 Apply Built-in Conditional Formatting.mp4

05:36

002 Apply-Conditional.pdf

002 Apply-Conditional.xlsx

003 Remove Conditional Formatting.mp4

01:32

003 Remove-Conditional.pdf

003 Remove-Conditional.xlsx

11 - Create and Format Tables

001 Create Excel Tables from Cell Ranges & Convert Tables to Cell Ranges.mp4

05:06

001 Create-Tables.pdf

001 Create-Tables.xlsx

12 - Modify Tables

001 Apply and Configure Table Styles including Total Rows.mp4

02:03

002 Add or Remove Table Rows and Columns.mp4

01:25

002 Modify-Tables.pdf

002 Modify-Tables.xlsx

13 - Filter and Sort Table Data

001 Filter Records.mp4

04:55

001 Filter-Records.pdf

001 Filter-Records.xlsx

002 Multiples.xlsx

002 Sort Data by Multiple Columns.mp4

05:41

002 Sort-by-Multiples.pdf

14 - Insert References

001 Insert Relative, Absolute and Mixed References (Part 1).mp4

09:44

002 Insert Relative, Absolute and Mixed References (Part 2).mp4

06:19

002 Insert-References.pdf

002 Insert-References.xlsx

003 Use Structured References in Formulas.mp4

04:52

15 - Calculate and Transform Data

001 Perform Calculations by using the AVER(), MAX(), MIN() and SUM() Functions.mp4

07:44

002 Calculate-Using-Functions.xlsx

002 Calculate-using-functions.pdf

002 Count Cells by using the COUNT(), COUNTA() and COUNTBLANK() Functions.mp4

01:33

003 IF-Functions.pdf

003 IF-Functions.xlsx

003 Perform Conditional Operations by using the IF() Function.mp4

08:04

004 Sort Data by using the SORT() Function.mp4

02:59

004 Sort-Function.xlsx

004 Sort-Functions.pdf

005 Get Unique Values by using the UNIQUE() Function.mp4

02:45

005 Unique.xlsx

005 Unique-Functions.pdf

16 - Format and Modify Text

001 Format Text by using Text Functions.mp4

03:43

002 Format Text using CONCAT & TEXTJOIN Functions.mp4

04:43

002 Text-Functions.xlsx

002 Text-functions.pdf

17 - Create Charts

001 Create Charts and Chart Sheets.mp4

04:23

18 - Modify Charts

001 Add Data Series to Charts and Switch Between Rows and Columns in Source Data.mp4

01:03

002 Add and Modify Chart Elements.mp4

05:19

002 Modify-Charts.xlsx

002 Modify-charts.pdf

19 - Format Charts

001 Apply Chart Layouts and Styles.mp4

01:03

002 Add Alternative Text to Charts for Accessibility.mp4

01:43

20 - Solutions to Course Exercises

002 Navigate Within Workbooks.mp4

05:08

003 Format Worksheets and Workbooks.mp4

03:28

004 Customize Options and Views.mp4

04:56

005 Configure Content for Collaboration.mp4

03:08

006 Manipulate Data in Worksheets.mp4

04:58

007 Format Cells and Ranges.mp4

06:05

008 Define and Reference Named Ranges.mp4

05:53

009 Create, Format and Modify Tables.mp4

03:59

010 Filter and Sort Table Data.mp4

03:36

011 Insert References and Calculate and Transform Data.mp4

08:32

012 Format and Modify Text.mp4

07:27

013 Create Charts.mp4

03:52

014 Modify and Format Charts.mp4

05:07

21 - Bonus Lectures

001 Bonus Lecture About MOS University.mp4

02:33

Description

70 lectures, practice exercises with all lectures, comprehensive Exercise Book with video solutions

What You'll Learn?

How to successfully pass the MO-210 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 Apps
Guarantee potential Employers of your competence in Microsoft Excel 365 Apps

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-210 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 Apps 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
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-210 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-210Â 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-210 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-210Â 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-210 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 skills measured by Microsoft for the MO-210 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 MO-210 exam, Microsoft issue you with the 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-210 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 skills measured 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 Apps.
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-210 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

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.