MOS Excel 2016 Course

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.

Distance Learning Courses Limited (t/a Distance Learning Centre) is a leading provider of distance learning/home study/Open Learning courses and a respected course developer. As well as developing our own course materials we are also agents for many other top distance learning providers and currently offer over 250 distance learning courses through the Distance Learning Centre website and we are also an authorised partner for distributing the official CIW Self Study Kits.

I am Michael Verinder, the managing director of Distance Learning Courses Limited and I have been developing and delivering distance learning courses for over 20 years. Distance Learning Courses Limited is a family based business and my involvement in this area started after my Dad developed our first Webmaster Course back in 1993 I soon ended up doing the course myself and this eventually led to me tutoring the course.

Since then we have gone from strength to strength and we continue to develop innovative course materials and the Distance Learning Centre website was created as a platform to offer a wide range of distance learning courses. The Web Design courses remain a popular course choice but equally we offer a range of courses that can lead directly to specific job roles such as teaching assistant and child care courses that lead to full QCF qualifications or GCSE, IGCSE and A Level Courses which are still massively important for many job roles and further education applications.

Through our Distance Learning Centre website, e have supplied direct to companies and company employees from many leading international organisations such as:

• The NHS
• The Department for Work & Pensions (DWP)
• The Armed Forces
• Job Centre Plus
• Jaguar Land Rover
• Ford Motor Company
• Barclays Bank
• St Loye's Foundation
• Bank of Tokyo-Mitsubishi
• The United Nations
• European Union (EU)
• BT
• Royal Mail
• HM Revenue & Customs
• Siemens
• The Prison Service
• The Prisoners Education Trust
• The Environment Agency

Distance Learning Centre is recognised as a centre to deliver accredited courses and qualifications through Open Awards and is a member of ABCC (Association of British Correspondence Colleges), BILD (British Institute for Learning & Development), the Federation of Small Businesses and we are also listed on the UK register of learning providers (UK PRN: 10055548).