Microsoft Excel 2013 Introduction Tutorial

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.

Microsoft Excel 2013

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.

Objectives

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.

Target Audience

The target audience of the tutorial is anyone who is interested in learning Excel 2013.

Prerequisites for Microsoft Excel 2013 MOS Foundation

No prerequisite skills are required for this tutorial.

In the next section, we'll discuss how professionals benefit from using excel.

Benefits of Microsoft Excel 2013 MOS Foundation to Professionals

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.

Benefits of Microsoft Excel 2013 MOS Foundation to Organizations

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.

Let us understand the exam pattern of MOS Excel 2013 in the next section.

Exam Pattern

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.

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.

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

Conclusion

With this, we have come to an end of this introductory lesson on Overview of MOS Foundation.