Welcome to ONLC Training Centers


Excel 2019 On-Demand: Comprehensive (Parts 1, 2, & 3) Course Outline

 (3 days)
Version 2019
Special Note to New Hampshire Residents
This course has not yet been approved by the New Hampshire Department of Education. Please contact us for an update on when the class will be available in New Hampshire.

**Note: This is an On-Demand Self-Study Course, 3 days of content, 6-months unlimited access, $495**
(Applicable State and Local taxes may be added for On-Demand purchases, depending on your location.)
You may take this course at any time; there are no set dates. The course covers Microsoft Excel 2019 Parts 1, 2 & 3.

About This Course
This Online On-Demand (self-study) training course includes expert lectures, PowerPoint visuals, and demonstrations. You will be able to follow along and successfully complete the course by completing the quizzes and exams. You do not need to own the software for the course and will be able to access the course from any device, provided you have internet access. Note: The 6-month course access will begin at time of purchase.

When you purchase this Excel On-Demand course from ONLC you will receive the printed courseware at no charge. (Note: printed materials are not provided when you purchase the Office On-Demand Comprehensive bundle or when Office On-Demand is included with the All You Can Learn offer.)

Duration
This course takes 3 days to complete and includes 12h 04m of video presentation.

Course Outline

Microsoft Office Excel 2019: Part 1

Chapter 01 - Getting Started with Microsoft Office Excel 2019
Topic A: Navigate the Excel User Interface
Topic B: Use Excel Commands
Topic C: Create and Save a Basic Workbook
Topic D: Enter Cell Data
Topic E: Use Excel Help

Chapter 02 - Performing Calculations
Topic A: Create Worksheet Formulas
Topic B: Insert Functions
Topic C: Reuse Formulas and Functions

Chapter 03 - Modifying a Worksheet
Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
Topic B: Search for and Replace Data
Topic C: Use Proofing and Research Tools

Chapter 04 - Formatting a Worksheet
Topic A: Apply Text Formats
Topic B: Apply Number Formats
Topic C: Align Cell Contents
Topic D: Apply Styles and Themes
Topic E: Apply Basic Conditional Formatting
Topic F: Create and Use Templates

Chapter 05 - Printing Workbooks
Topic A: Preview and Print a Workbook
Topic B: Set Up the Page Layout
Topic C: Configure Headers and Footers

Chapter 06 - Managing Workbooks
Topic A: Manage Worksheets
Topic B: Manage Workbook and Worksheet Views
Topic C: Manage Workbook Properties

Chapter 07 - Adding Borders and Colors to Worksheets
Topic A: Add Borders and Colors to Worksheets

Chapter 08 - Basic Excel Customization
Topic A: Customize General Options and the Excel UI

Microsoft Office Excel 2019: Part 2

Chapter 01 - Working with Functions
Topic A: Work with Ranges
Topic B: Use Specialized Functions
Topic C: Work with Logical Functions
Topic D: Work with Date and Time Functions
Topic E: Work with Text Functions

Chapter 02 - Working with Lists
Topic A: Sort Data
Topic B: Filter Data
Topic C: Query Data with Database Functions
Topic D: Outline and Subtotal Data

Chapter 03 - Analyzing Data
Topic A: Create and Modify Tables
Topic B: Apply Intermediate Conditional Formatting
Topic C: Apply Advanced Conditional Formatting

Chapter 04 - Visualizing Data with Charts
Topic A: Create Charts
Topic B: Modify and Format Charts
Topic C: Use Advanced Chart Features
Chapter 05 - Using PivotTables and PivotCharts
Topic A: Create a PivotTable
Topic B: Analyze PivotTable Data
Topic C: Present Data with PivotCharts
Topic D: Filter Data by Using Timelines and Slicers

Chapter 06 - Working with Graphical Objects
Topic A: Insert Graphical Objects
Topic B: Modify Graphical Objects
Topic C: Work with SmartArt

Chapter 07 - Using Array Formulas
Topic A: Use Array Formulas

Microsoft Office Excel 2019: Part 3

Chapter 01 - Working with Multiple Worksheets and Workbooks
Topic A: Use Links and External References
Topic B: Use 3-D References
Topic C: Consolidate Data

Chapter 02 - Sharing and Protecting Workbooks
Topic A: Collaborate on a Workbook
Topic B: Protect Worksheets and Workbooks

Chapter 03 - Automating Workbook Functionality
Topic A: Apply Data Validation
Topic B: Search for Invalid Data and Formulas with Errors
Topic C: Work with Macros

Chapter 04 - Using Lookup Functions and Formula Auditing
Topic A: Use Lookup Functions
Topic B: Trace Cells
Topic C: Watch and Evaluate Formulas

Chapter 05 - Forecasting Data
Topic A: Determine Potential Outcomes Using Data Tables
Topic B: Determine Potential Outcomes Using Scenarios
Topic C: Use the Goal Seek Feature
Topic D: Forecast Data Trends

Chapter 06 - Creating Sparklines and Mapping Data
Topic A: Create Sparklines
Topic B: Map Data

Chapter 07 - Importing and Exporting Data
Topic A: Import and Export Data

Chapter 08 - Internationalizing Workbooks
Topic A: Internationalize Workbooks

Chapter 09 - Working with Power Pivot
Topic A: Work with Power Pivot

Chapter 10 - Advanced Customization Options
Topic A: Customize Advanced Options

Chapter 11 - Working with Forms and Controls
Topic A: Work with Forms and Controls

View outline in Word

GEXZ19

Attend hands-on, instructor-led Excel 2019 On-Demand: Comprehensive (Parts 1, 2, & 3) training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Courses and select the one that's right for you.

Microsoft Gold Partner

Price:$495

Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Attend computer classes from ONLC Training Centers Request a copy via mail

GENERAL INFO

Class Format
Class Policies
Student Reviews

Bookmark and Share


HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment



ONLC TRAINING CENTERS
800-288-8221
www.onlc.com