MOS EXCEL 2013 ESSENTIALS ONLINE COURSE
-
The support I received was amazing. I haven't had to wait a lot for a reply and they are always available for help.
← | →
Course
Distance
Description
-
Type
Course
-
Level
Intermediate
-
Methodology
Distance Learning
-
Class hours
100h
-
Duration
1 Year
-
Start date
Different dates available
-
Online campus
Yes
-
Delivery of study materials
Yes
-
Support service
Yes
-
Virtual classes
Yes
The MOS Microsoft Excel 2013 Course will help students to master Microsoft Excel 2013. The course is ideal for beginners and takes users to an advanced level of proficiency. The course will show students how to become proficient in using Microsoft Excel to perform simple to complex business calculations and to execute data organisation, presentation, and analysis functions. Designated as approved course materials for the Microsoft Office Specialist program, this course will help students prepare for the MOS Core Excel 2013 exam (77-420) or the MOS Expert Excel exams (77-427 / 77-428). This Microsoft certification credential demonstrates proficiency in the newest standard of the world's foremost desktop computing applications. MOS certifications are primarily for anyone who uses Microsoft Office programs as a vital part of their job functions. These certifications cover the entire Microsoft Office Suite.
Facilities
Location
Start date
Start date
About this course
The MOS Excel 2013 Essentials Online Course is designed for both students who are interested in gaining a broad knowledge of the Excel application and for experienced Excel users who wish to undertake a refresher course. The course follows the Microsoft Office Specialist (MOS) syllabus, and more, and is the ideal study guide for those wishing to gain the industry-recognised MOS certification.
There are no particular entry requirements as the course is set out for beginners although students will require their own version of Microsoft Excel 2013 to complete the course.
On successful completion of this course students will receive our Excel 2013 Essentials Certificate of Completion with feedback from your tutor, and students can also apply for the Microsoft Office Specialist (MOS) 77-420 exam.
Reviews
-
The support I received was amazing. I haven't had to wait a lot for a reply and they are always available for help.
← | →
Course rating
Recommended
Centre rating
Karen Woodford
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 15 years
Subjects
- Excel
- Presentation
- Computing
- IT
- Office IT
- Microsoft Excel
- Graphics
- Materials
- Web
- Ms Office
- Microsoft excel training
- MS Excel
- Microsoft Office
Course programme
The MOS Excel 2013 Essentials Online Course consists of the following modules:
Lesson 1 - Worksheets & Workbooks
- Introduction;
- The Excel 2013 Application;
- Managing Worksheets & Workbooks;
- Navigating Worksheets & Workbooks;
- Formatting Worksheets & Workbooks;
- Customisation Options;
- Configuration Options;
- Lesson Review & Quiz;
- Assignment 1 - Worksheet & Workbook Exercises.
Lesson 2 - Managing Cells & Ranges
- Introduction;
- Inserting Data;
- Formatting Data;
- Ordering & Grouping;
- Applying Formulas;
- Lesson Review & Quiz;
- Assignment 2 - Cell & Range Exercises.
Lesson 3 - Managing Tables
- Introduction;
- Creating Tables;
- Modifying A Table;
- Filter & Sort A Table;
- Pivot Tables & Charts;
- Lesson Review & Quiz;
- Assignment 3 - Table Exercises.
Lesson 4 - Excel Functions
- Introduction;
- Summarise Data With Functions;
- Use Conditional Logic In Functions;
- Format & Modify Text With Functions;
- Useful Maths Functions;
- Date & Time Functions;
- Lesson Review & Quiz;
- Assignment 4 - Function Exercises.
Lesson 5 - Inserting Charts and Objects
- Introduction;
- Creating A Chart;
- Formatting A Chart;
- Working With Objects;
- Lesson Review & Quiz;
- Assignment 5 - Charts & Object Exercises;
- The MOS Examination Explained.
Assessment:
You will be assessed on assignments which are detailed in the course materials. These assignments will require you to create work on, create and edit spreadsheet files. Your work can be sent back to your course tutor by email.
MOS EXCEL 2013 ESSENTIALS ONLINE COURSE