
MOS Excel 2016 Course
UK Online, United Kingdom
DURATION
100 Hours
LANGUAGES
English
PACE
Part time
APPLICATION DEADLINE
Request application deadline
EARLIEST START DATE
Request earliest startdate
TUITION FEES
GBP 175 / per course
STUDY FORMAT
Distance Learning
Scholarships
Explore scholarship opportunities to help fund your studies
Introduction
The MOS Excel 2016 Course (Desktop / Office 365) covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 77-727 Core Data Analysis, Manipulation, and Presentation Exam and the Excel 2016 Expert 77-728 Interpreting Data for Insights Exam.
Microsoft Excel is the industry standard for Spreadsheets and helps companies and individuals to calculate, analyse, revise, update, and present your data in a professional way and this course will show students how to accomplish their tasks in much less time, than if you used traditional pen-and-paper methods or non-specialised software. This course aims to provide you with a foundation for Excel knowledge and skills, which you will build upon this to eventually become an expert in data manipulation.
The course Includes:
Microsoft Excel 2016 - Course Book 1
Upon successful completion of this book, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation.
Students will learn to:
- Get started with Microsoft Office Excel 2016.
- Perform calculations.
- Modify a worksheet.
- Format a worksheet.
- Print workbooks.
- Manage workbooks.
Microsoft Excel 2016 - Course Book 2
Upon successful completion of this book, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organisational decisions.
Students will learn to:
- Work with functions.
- Work with lists.
- Analyse data.
- Visualize data with charts.
- Use PivotTables and PivotCharts.
Microsoft Excel 2016 - Course Book 3
Upon successful completion of this book, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.
Students will learn to:
- Work with multiple worksheets and workbooks.
- Use Lookup functions and formula auditing.
- Share and protect workbooks.
- Automate workbook functionality.
- Create sparklines and map data.
- Forecast data.
Student Files
Associated course files are emailed to students. These files are to be used as you work through the course books putting into practice what you are studying.
Gmetrix Test Prep Software
The course also comes with GMetrix exam preparation software. The GMetrix Skills Management System provides everything you need to prepare for the Microsoft Office Specialist (MOS) Certification.
MOS Exams
On completion of this course, students can apply for the Microsoft Office Specialist Excel 2016 77-727 Exam and the Microsoft Office Specialist Excel 2016 Expert 77-728 Exam.
About the School
Questions
Similar Courses
Advanced Diploma in Software Engineering Technology - Artificial Intelligence (Optional Co-op) (Online)
- Online Canada
- Toronto, Canada
Advanced Diploma in Software Engineering Technology (Optional Co-op) (Online)
- Online Canada
- Toronto, Canada
Graduate Certificate in Mobile Applications Development (Online)
- Online Canada
- Toronto, Canada