Microsoft Excel

Microsoft Excel – Beginner to Advanced

Employers around the world cite Microsoft Excel as one of the most sought-after skills for any new hire. This learning path helps you become an Excel power user—covering everything from functions and formatting to PivotTables Master the powerful features and functions in Excel, learn how to use Excel’s robust built-in formulas.

Audience Profile:

This course is intended for students who wish to gain the understanding of Microsoft Office Excel 365, 2019, 2016, or 2013.

Students and professionals who want to learn Excel skills to create and work with electronic spreadsheets.

Prerequisites:

No Prior Excel Knowledge Required.

Microsoft Excel 2013, 2013, 2019 or Microsoft 365 Excel Loaded on Computer to Follow Along with Instructor Lectures is Recommended

Here are the learning paths in this series:

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