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