Welcome to the introductory lesson ‘Overview of Microsoft Excel 2013’ introduction tutorial, which is a part of the Microsoft Excel 2013 MOS Foundation Course. This introductory lesson will give a brief overview of the MOS foundation and its objectives.
Excel is a powerful spreadsheet application created by Microsoft, which helps you to understand and analyze business functions. This application is mainly used for business heads for taking decisions about their business.
Microsoft introduced a number of new features in Excel 2013, such as saving files in remote locations, new chart types, slicers and timeline feature to work with pivot tables, flash file, etc. All these features allow the user to work with data more efficiently and effectively.
Let us begin by looking into the objectives of this lesson.
By the end of this tutorial on Microsoft Excel 2013, you’ll be able to:
A comprehensive introduction to the basics of Excel 2013 application and customize excel options.
Create and manage worksheet and workbooks
Create cells and ranges in Excel 2013
Create tables in Excel 2013
Apply formulas and functions in Excel 2013.
Create charts and objects in Excel 2013.
The target audience of the tutorial is anyone who is interested in learning Excel 2013.
No prerequisite skills are required for this tutorial.
In the next section, we'll discuss how professionals benefit from using excel.
Professionals can benefit from excel in different ways. In Excel 2013:
Professionals can use the new FlashFill feature to easily work with data.
They can create interactive charts with filters, using new chart elements and chart types.
They can change data to a table with different in-built table styles
Use new formulas and functions for easy calculations
They can work with dual monitors as each workbook works in its own window.
Organizations have several benefits of working with excel. They are:
Excel 2013 has a powerful pre-made template to create workbooks,
It has different types of quick analysis tools, which help organizations to make decisions about their businesses.
In addition, it has an option to save files in remote locations, which helps in accessing online files from anywhere.
Using the Excel application, organizations can store huge data to automate various tasks.
Let us now look into the lessons covered in the course.
There are six lessons covered in this course. Take a look at the lesson names that are listed in the table below.
Lesson No |
Chapter Name |
What You’ll Learn |
Lesson 1 |
Introduction to Excel 2013 |
This chapter covers the following topics:
|
Lesson 2 |
Create and Manage Worksheets and Workbooks |
This chapter covers the following topics:
|
Lesson 3 |
Create Cells and Ranges in Excel 2013 |
This chapter covers the following topics:
|
Lesson 4 |
Create Tables in Excel 2013 |
This chapter covers the following topics:
|
Lesson 5 |
Apply Formulas and Function in Excel 2013 |
This chapter covers the following topics:
|
Lesson 6 |
Create Charts and Objects in Excel 2013 |
This chapter covers the following topics:
|
Let us understand the exam pattern of MOS Excel 2013 in the next section.
MOS Excel 2013 certification exam is purely skill based and measures the candidate’s technical ability in Excel. In this exam, you have to complete scenarios in the provided workbooks. Additional information on the exam pattern is explained below.
Possible Question Types |
Explanation |
Scenarios |
Perform onscreen tasks, for example: 1.Apply conditional format to A2:A10 cells 2.Create a new worksheet with name Sales Report 3.Utilize the SUMIF function and display person-wise sales |
Let us look into the certification details of Microsoft Excel 2013 MOS foundation in the next section.
Microsoft Excel 2013 MOS foundation certification proves that the certified professional can work with Excel 2013 application efficiently. This certification also proves the certified professional skills in Excel 2013.
The software component used in this certification exam is the Microsoft Excel 2013 desktop application.
Mentioned below are the details about the exam.
Software component |
Microsoft Excel 2013 desktop application |
MS Certification ID (booking code) |
77-420 |
Duration of exam |
50 minutes |
Number of scenarios |
4–6 |
Focus area |
Excel 2013 features |
Prerequisite certificates for participating in this Certification Test |
None |
Courses for preparing for the Certification Test |
MOS 2013 study guide for Microsoft Excel (77-420) book by Joan Lombert |
Critical information on Microsoft exam can be found here:
https://www.microsoft.com/learning/en-us/exam-77-420.aspx
This provides required skills and preparation materials for this exam. You can explore Microsoft office tutorials link to get some practice with free excel tutorials
http://office.microsoft.com/en-us/excel-help/ free tutorials
With this, we have come to an end of this introductory lesson on Overview of MOS Foundation.
To learn more, take the Course
Microsoft® Excel 2013 Foundation Certification Training"Simplilearn’s course was extremely informative covering all the important and much needed topics t..."
Destiny Webb
"This excellent course will transform you into an Excel expert. You will be the go-to person in your organ..."
Amy Tucker
"Simplilearn’s Excel Foundation is a great course with carefully planned and reviewed course materi..."
Rachel Washington
100% Money Back Gaurantee
A Simplilearn representative will get back to you in one business day.