Become a Member   |   Contact Us   |   Marketplace   |   Sign In
Microsoft Office 2019 Excel - Part 2

Training Series Overview

This course will teach students about working with functions, working with lists, analyzing data, visualizing data with charts, using PivotTables and PivotCharts, working with graphical objects, and using array formulas.

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 2019 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 2019. 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.

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

Launch Your Course Here

Start Course Now

In order to access this course, you must be logged in as a member.

Review Course Outline

Click on titles below to view topics:


Chapter 1 - Working with Functions 1h 6m

Chapter 2 - Working with Lists 33m

Chapter 3 - Analyzing Data 32m

Chapter 4 - Visualizing Data with Charts 37m

Chapter 5 - Using PivotTables and PivotCharts 39m

Chapter 6 - Working with Graphical Objects 15m

Chapter 7 - Using Array Formulas 17m



Legal