Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Microsoft Office Specialist (MOS) - Excel

Name: Microsoft Office Specialist (MOS) - Excel
Rating: 4.6 (149 reviews)

Be a proficient Excel Specialist!

Created byStanley Wong

Last updated 5/2024

English

English [Auto],

What you'll learn

Complete knowledge and study of Microsoft Office Specialist (MOS) Excel 2013, 2016, 2019, 2021
Course development is based on 100% Microsoft official syllabus.
130 intensive tutorials and 17 practice tasks, covering 5 CORE scopes of Excel:
- Create and manage WORKSHEETS and WORKBOOKS
- Manage data CELLS and RANGES
- Create and manage TABLES
- Perform operations with FORMULAS and FUNCTIONS
- Create and manage CHARTS and OBJECTS
You can have thorough understanding of Excel, and full capability for MOS exam.
You'll be a proficient and confident Excel Specialist step-by-step!

Course content

61 sections • 149 lectures • 4h 24m total length

Course Overview2:12
Course structure, features & table of contents
Welcome2:51

1.1.1A Create a new blank workbook1:26
Create a new blank workbook by clicking the home screen blank thumbnail, selecting new workbook from the menu, or using the keyboard shortcut.
1.1.1B Create a new workbook based on an installed template0:54
Learn how to create a new Excel workbook from an installed template on the home screen, select a template, and click create to auto-generate the workbook.
1.1.1C Create a new workbook based on an online template1:25
Learn to create a new workbook from an online template in Excel, using the home screen, file menu, and search to find and preview templates.
1.1.1D Create a new document based on a local template file0:52
Learn how to create a new Excel workbook from a local template by navigating to the file explorer, selecting the template on the templates tab, and opening it.

1.1.3A Move a worksheet within a workbook1:19
Learn how to move a worksheet within a workbook to reorder sheets, either by dragging to a position or using move or copy, then select the destination and click ok.
1.1.3B Move worksheets to another workbook1:49
Learn how to move a worksheet from one workbook to another in Excel, choosing move or copy, selecting the destination file and location, and using Ctrl to copy.
1.1.3C Copy worksheets within a workbook1:14
1.1.3D Copy worksheets to another workbook1:20

1.2.3A Create a hyperlink to a webpage2:20
Learn to create a hyperlink to a web page in Excel using the insert hyperlink dialog, linking to an existing file or web page and opening the site.
1.2.3B Link to an existing file or folder1:37
Link to an existing file or folder by selecting the file, inserting a hyperlink, and confirming with the OK button so clicking it opens the linked file or folder automatically.
1.2.3C Link to a cell, worksheet or named object in the workbook2:05
Learn to create hyperlinks to cells, objects, and named references in an Excel workbook by using the insert hyperlink dialog, typing references, and navigating to the linked location.
1.2.3D Create & link to an Excel workbook or another file type2:53
Learn to create and link to an Excel workbook or other file type using hyperlinks and insert a new document, then save and verify the linked document.
1.2.3E Create a hyperlink that creates a pre-addressed email message1:43
Create a hyperlink in Excel that opens a pre-addressed email message by linking to an email address with a subject, then test and remove the hyperlink as needed.

Requirements

Course content is demonstrated with Office 365 (Windows version)
You may use Microsoft Excel 2013-2021 or Office 365 (ideally Windows version)

Description

Complete knowledge and study of Microsoft Office Specialist (MOS) Excel

Course development is based on 100% Microsoft official syllabus.

It provides preparation for Microsoft Certification, daily study and quick reference.

You can go to Specialist Level step-by-step!

It covers 5 CORE scopes of Excel:

- Create and manage WORKSHEETS and WORKBOOKS

- Manage data CELLS and RANGES

- Create and manage TABLES

- Perform operations with FORMULAS and FUNCTIONS

- Create and manage CHARTS and OBJECTS

It includes 130 comprehensive tutorials, which cover all the fundamental knowledge of Excel

All the videos are high-quality & mobile-phone-friendly, and you can watch them at anytime and anywhere.

This course is in a simple, easy, fast way to the key points, so you can easily and quickly learn all the most fundamental and important things about Excel, without wasting your time on irrelevant contents.

113 Try-It-Out files (do along with course videos), 17 post-section Practice tasks (test your understanding) and Q&A supports are included, to make sure you can achieve the goal of this course.

It starts from a beginner but fundamental level, and finally brings you to Specialist Level. So, this course is really for you!

Plus, this course is Life-Time Access and 30-Day Money-Back Guarantee.

What are you waiting for? Let's get started!

Who this course is for:

Users who want to be proficient and confident in Excel, and go to Specialist Level.

Microsoft Office Specialist (MOS) - Excel

What you'll learn

Explore related topics

Course content

Welcome to the course2 lectures • 5min

1.1.1 Create blank and prepopulated workbooks4 lectures • 5min

1.1.2 Add worksheets to workbooks1 lecture • 1min

1.1.3 Move or copy worksheets4 lectures • 6min

1.1.4 Import data from delimited text files1 lecture • 2min

Practice 1.1 Create worksheets and workbooks1 lecture • 1min

1.2.1 Search for data within a workbook1 lecture • 3min

1.2.2 Navigate to a named cell, range, or workbook element1 lecture • 2min

1.2.3 Link to internal and external locations and files5 lectures • 11min

Practice 1.2 Navigate in worksheets and workbooks1 lecture • 1min

Requirements

Description

Who this course is for: