Course Overview:

This series builds upon the foundational knowledge presented in the Microsoft Office Excel 2016 Basic training series. Students will start down the road to creating advanced workbooks and worksheets that can help deepen understanding of organizational intelligence. This series is meant for students who want to advance their skill set by learning to work with advanced formulas, lists, and illustrations. Students will also work with charts and advanced formatting including styles.

Career Path: In high-growth industries, entry-level employees who hold a Microsoft Office Specialist (MOS) certification can earn up to £16,000 more, annually, than their peers. Five times as many high-growth/high-salary positions require experience with Office than all non- Microsoft software skills combined. Twenty-nine percent of tomorrow’s high-growth/high-wage positions require Office or Office- related skills.

Series Taught By: Patrick Loner

Certification Details

Successful candidates for the Microsoft Office Specialist Excel 2016 certification exam will have a fundamental understanding of the Excel environment and the ability to complete tasks independently. They will know and demonstrate the correct application of the principle features of Excel 2016. Candidates will create and edit a workbook with multiple sheets, and use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.

Certification Exam Details:

Available CEUs for Course Series Completion: 8
Students can earn up to 8 CEUs for fully completing this course series. This information will be displayed on the certificate of completion.

Access Training Courses Below

Click any of the titles below to launch your videos:

Chapter 01 – Working with Functions —  1hr 11m

Chapter 02 – Working with Lists   —  36m

Chapter 03 – Analysing Data   —  26m

Chapter 04 – Visualizing Data with Charts   —  35m

Chapter 05 – Using PivotTables and Pivot Charts   —  40m

Training Final Exam

Reviews