Microsoft Excel
Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organized with checklists.
Because most businesses use Excel, learning how to use the application efficiently opens up more opportunities for employment and career advancement.
24 Hrs.
Excel 2019 - Part 1
[Introduction]
8 Hrs.
About this course
In this Introduction to Microsoft Excel 2019 training class, students will create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel 2019 worksheets.
Audience Profile
This course is intended for students who have little or no familiarity with Microsoft Excel 2019 or more experienced Excel users who want to learn the topics covered in this course in the 2019 interface.
At Course Completion
After completing this course, students will be able to:
Create basic worksheets using Microsoft Excel 2019.
Perform calculations in an Excel worksheet.
Modify an Excel worksheet.
Modify the appearance of data within a worksheet.
Manage Excel workbooks.
Print the content of an Excel worksheet.
Learn how to use handy features new in 2019.
Prerequisites
Familiarity with using a personal computer, mouse, and keyboard.
Comfortable in the Windows environment.
Ability to launch and close programs; navigate to information stored on the computer; and manage files and folders.
Excel 2019 - Part 2
[Intermediate]
8 Hrs.
About this course
This Intermediate Microsoft Excel 2019 training class 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.
Audience Profile
This course is intended for students who have basic skills with Microsoft Excel 2019 who want to learn intermediate-level skills or students who want to learn the topics covered in this course in the 2019 interface.
At Course Completion
After completing this course, students will be able to:
Use formulas and functions.
Create and modify charts.
Convert, sort, filter, and manage lists.
Insert and modify illustrations in a worksheet.
Work with tables.
Use conditional formatting and styles.
Prerequisites
Before attending this course, students must have basic experience with Excel
Certification Exam
Exam 77-727: Excel 2016
Core Data Analysis, Manipulation, and Presentation
Excel 2019 - Part 3
[Advanced]
8 Hrs.
About this course
This Advanced Microsoft Excel 2019 training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.
Audience Profile
Students who have intermediate skills with Microsoft Excel 2019 who want to learn more advanced skills or students who want to learn the topics covered in this course in the 2019 interface.
At Course Completion
After completing this course, students will be able to:
Create pivot tables and charts.
Learn to trace precedents and dependents.
Convert text and validate and consolidate data.
Collaborate with others by protecting worksheets and workbooks.
Create, use, edit, and manage macros.
Import and export data.
Prerequisites
Before attending this course, students must have basic and Intermediate Excel experience
Certification Exam
Exam 77-728: Excel 2016 Expert
Interpreting Data for Insights