Master Excel Training Course

Getting Started With Microsoft Office Excel

Navigate the Excel User Interface

Use Excel Commands

Create and Save a Basic Workbook

Enter Cell Data Topic E: Use Excel Help

Performing Calculations

Create Worksheet Formulas

Insert Functions

Reuse Formulas and Functions

Modifying A Worksheet

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

Search for and Replace Data

Use Proofing and Research Tools

Formatting A Worksheet

Apply Text Formats

Apply Number Formats

Align Cell Contents

Apply Styles and Themes

Apply Basic Conditional Formatting

Create and Use Templates

Printing Workbooks

Preview and Print a Workbook

Set Up the Page Layout

Configure Headers and Footers

Managing Workbooks

Manage Worksheets

Manage Workbook and Worksheet Views

Manage Workbook Properties

microsoft excel master certification  2nd Day: Intermediate Excel Course Outline

For people with basic knowledge of Excel want to learn more about advanced formulas (text, math, date and time, logical, etc) and advanced tools like chart, sorting, filtering, conditional format, pivot table

 Working With Functions

Work with Ranges name

Use Specialized Functions

Work with Logical Functions

Work with Date & Time Functions

Work with Text Functions

 Working With Lists

Sort Data

Filter Data

Query Data with Database Functions

Outline and Subtotal Data

Analyzing Data

Create and Modify Tables

Apply Intermediate Conditional Formatting

Apply Advanced Conditional Formatting

Visualizing Data With Charts

Create Charts

Modify and Format Charts

Use Advanced Chart Features

Using PivotTables And Pivot Charts

Create a PivotTable

Analyze PivotTable Data

Present Data with Pivot Charts

Filter Data by Using Timelines and Slicers

microsoft excel master certification   3rd Day: Advanced Excel Course Outline

For people who have a need to consolidate, collaborate with others when working with Excel and want to automate their simple repetitive tasks in Excel with Macro

Working With Multiple Worksheets And Workbooks

Use Links and External References

Use 3-D References

Consolidate Data

Using Lookup Functions And Formula Auditing

Use Lookup Functions

Trace Cells

Watch and Evaluate Formulas

Sharing And Protecting Workbooks

Collaborate on a Workbook

Protect Worksheets and Workbooks

Automating Workbook Functionality

Apply Data Validation

Search for Invalid Data and Formulas with Errors

Work with Macros

Creating Sparklines And Mapping Data

Create Sparklines

Map Data

Forecasting Data

Determine Potential Outcomes using Data Tables

Determine Potential Outcomes using Scenarios

Use the Goal Seek Feature

Forecasting Data Trends