Microsoft Excel

1) Getting Started with Excel 2019

 Navigate the Excel User Interface

 Use Excel Commands

 Create and Save a Basic Workbook

 Enter Cell Data

 Use Excel Help

2) Performing Calculations

 Create Worksheet Formulas

 Insert Functions

 Reuse Formulas and Functions

3) Modifying a Worksheet

 Insert, Delete, and Adjust Cells, Columns, and Rows

 Search for and Replace Data

 Use Proofing and Research Tools

4) Formatting a Worksheet

 Apply Text Formats

 Apply Number Formats

 Align Cell Contents

 Apply Styles and Themes

 Apply Basic Conditional Formatting

 Create and Use Templates

5) Printing Workbooks

 Preview and Print a Workbook

 Set Up the Page Layout

 Configure Headers and Footers

6) Managing Workbooks

 Manage Worksheets

 Manage Workbook and Worksheet Views

 Manage Workbook Properties

1) Working with Functions

 Work with Ranges

 Use Specialized Functions

 Work with Logical Functions

 Work with Date & Time Functions

 Work with Text Functions

2) Working with Lists

 Sort Data

 Filter Data

 Query Data with Database Functions

 Outline and Subtotal Data

3) Analyzing Data

 Create and Modify Tables

 Apply Intermediate Conditional Formatting

 Apply Advanced Conditional Formatting

4) Visualizing Data with Charts

 Create Charts

 Modify and Format Charts

 Use Advanced Chart Features

5) Using PivotTables and Pivot Charts

 Create a PivotTable

 Analyze PivotTable Data

 Present Data with Pivot Charts

 Filter Data by Using Timelines and Slicers

1) Working with Multiple Worksheets and Workbooks

 Use Links and External References

 Use 3-D References

 Consolidate Data

2) Sharing and Protecting Workbooks

 Collaborate on a Workbook

 Protect Worksheets and Workbooks

3) Automating Workbook Functionality

 Apply Data Validation

 Search for Invalid Data and Formulas with Errors

 Work with Macros

4) Using Lookup Functions and Formula Auditing

 Use Lookup Functions

 Trace Cells

 Watch and Evaluate Formulas

5) Forecasting Data

 Determine Potential Outcomes Using Data Tables

 Determine Potential Outcomes Using Scenarios

 Use the Goal Seek Feature

 Forecast Data Trends

6) Creating Sparklines and Mapping Data

 Create Sparklines

 Map Data