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

Training Series Overview

This course will teach students about working with multiple worksheets and workbooks, sharing and protecting workbooks, automating workbook functionality, using Lookup functions and formula auditing, forecasting data, creating sparklines and mapping data, importing and exporting data, internationalizing workbooks, working with Power Pivot, advanced customization options, and working with formsand controls.

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 Multiple Worksheets and Workbooks 30m

Chapter 2 - Sharing and Protecting Workbooks 27m

Chapter 3 - Automating Workbook Functionality 32m

Chapter 4 - Using Lookup Functions and Formula Auditing 37m

Chapter 5 - Forecasting Data 31m

Chapter 6 - Creating Sparklines and Mapping Data 17m

Chapter 7 - Importing and Exporting Data 6m

Chapter 8 - Internationalizing Workbooks 3m

Chapter 9 - Working with Power Pivot 7m

Chapter 10 - Advanced Customization Options 9m

Chapter 11 - Working with Forms and Controls 15m