Log On/Register  

855.838.5028

Excel

Duration: 3 Days, 6 Modules
Module Price: $130

Microsoft Excel Training Courses

Learn iT! offers training courses for various versions of Microsoft Excel including 2016, 2013, 2010 and earlier. Our Excel training classes are delivered by our world-class trainers ready to help you or your employees get the most out of Microsoft Excel.  Excel students currently have the options of taking excel courses in a variety of formats, Instructor-Led, live online, private, and E-learning.

Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organized with checklists. Browse our various Microsoft Excel training courses today, and register online!

Excel: Day 1

Module 1

Lesson 1: Using Excel

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

 

Lesson 2: Performing Calculations

Topic A: Create Worksheet Formulas

Topic B: Insert Functions

Topic C: Reuse Formulas and Functions

 

Lesson 3: 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

 

Module 2

Lesson 4: 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

 

Lesson 5: Printing Workbooks

Topic A: Preview and Print a Workbook

Topic B: Set Up the Page Layout

Topic C: Configure Headers and Footers

 

Lesson 6: Managing Workbooks

Topic A: Manage Worksheets

Topic B: Manage Workbook and Worksheet Views

Topic C: Manage Workbook Properties

 

Excel: Day 2

 

Module 3

Lesson 1: Working with Functions

Topic A: Work with Named Ranges

Topic B: Work with Logical Functions

Topic C: Work with Date & Time Functions

Topic D: Work with Text Functions

 

Lesson 2: Working with Lists

 

Topic A: Sort Data

Topic B: Filter Data

Topic C: Query Data with Database Functions

Topic D: Outline and Subtotal Data

 

Lesson 3: Analyzing Data

Topic A: Create and Modify Tables

Topic B: Apply Intermediate Conditional Formatting

Topic C: Apply Advanced Conditional Formatting

 

Module 4

Lesson 4: Visualizing Data with Charts

Topic A: Create Charts

Topic B: Modify and Format Charts

Topic C: Use Advanced Chart Features

 

Lesson 5: 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

 

Excel: Day 3

 

Module 5

Lesson 1: Working with Multiple Worksheets and Workbooks

Topic A: Use Links and External References

Topic B: Use 3-D References

Topic C: Consolidate Data

 

Lesson 2: Using Lookup Functions and Formula Auditing

Topic A: Use VLookup Functions

Topic B: Trace Precedents

Topic C: Watch and Evaluate Formulas

 

Lesson 3: Sharing and Protecting Workbooks

Topic A: Collaborate on a Workbook*

Topic B: Protect Worksheets and Workbooks

 

Module 6

Lesson 4: Automating Workbook Functionality

Topic A: Apply Data Validation

Topic B: Search for Invalid Data and Formulas with Errors

Topic C: Work with Macros

 

Lesson 5: Creating Sparklines and Mapping Data

Topic A: Create Sparklines

Topic B: Map Data*

 

Lesson 6: 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: Forecasting Data Trends*

 

*2016 Exclusive

Microsoft Excel Training Courses

Learn iT! offers training courses for various versions of Microsoft Excel including 2016, 2013, 2010 and earlier. Our Excel training classes are delivered by our world-class trainers ready to help you or your employees get the most out of Microsoft Excel.  Excel students currently have the options of taking excel courses in a variety of formats, Instructor-Led, live online, private, and E-learning.

Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organized with checklists. Browse our various Microsoft Excel training courses today, and register online!

Excel: Day 1

Module 1

Lesson 1: Using Excel

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

 

Lesson 2: Performing Calculations

Topic A: Create Worksheet Formulas

Topic B: Insert Functions

Topic C: Reuse Formulas and Functions

 

Lesson 3: 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

 

Module 2

Lesson 4: 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

 

Lesson 5: Printing Workbooks

Topic A: Preview and Print a Workbook

Topic B: Set Up the Page Layout

Topic C: Configure Headers and Footers

 

Lesson 6: Managing Workbooks

Topic A: Manage Worksheets

Topic B: Manage Workbook and Worksheet Views

Topic C: Manage Workbook Properties

 

Excel: Day 2

 

Module 3

Lesson 1: Working with Functions

Topic A: Work with Named Ranges

Topic B: Work with Logical Functions

Topic C: Work with Date & Time Functions

Topic D: Work with Text Functions

 

Lesson 2: Working with Lists

 

Topic A: Sort Data

Topic B: Filter Data

Topic C: Query Data with Database Functions

Topic D: Outline and Subtotal Data

 

Lesson 3: Analyzing Data

Topic A: Create and Modify Tables

Topic B: Apply Intermediate Conditional Formatting

Topic C: Apply Advanced Conditional Formatting

 

Module 4

Lesson 4: Visualizing Data with Charts

Topic A: Create Charts

Topic B: Modify and Format Charts

Topic C: Use Advanced Chart Features

 

Lesson 5: 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

 

Excel: Day 3

 

Module 5

Lesson 1: Working with Multiple Worksheets and Workbooks

Topic A: Use Links and External References

Topic B: Use 3-D References

Topic C: Consolidate Data

 

Lesson 2: Using Lookup Functions and Formula Auditing

Topic A: Use VLookup Functions

Topic B: Trace Precedents

Topic C: Watch and Evaluate Formulas

 

Lesson 3: Sharing and Protecting Workbooks

Topic A: Collaborate on a Workbook*

Topic B: Protect Worksheets and Workbooks

 

Module 6

Lesson 4: Automating Workbook Functionality

Topic A: Apply Data Validation

Topic B: Search for Invalid Data and Formulas with Errors

Topic C: Work with Macros

 

Lesson 5: Creating Sparklines and Mapping Data

Topic A: Create Sparklines

Topic B: Map Data*

 

Lesson 6: 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: Forecasting Data Trends*

 

*2016 Exclusive

Learn More
Please type the letters below so we know you are not a robot (upper or lower case):

The PMI logo is a registered mark of the Project Management Institute, Inc.