Office 365
Training
Welcome!    Login | Checkout 0 Items | Checkout
ETI Performance Improvement

Software Training

Showing that application who's boss since 1984


Excel

Please Select Your Version: 2010 2013 2016

Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. It allows sectioning of data to view its dependencies on various factors for different perspectives



Choose Session Level

Level 1
Level 2
What Level Is Right For Me?
Contact Our Sales Team!
Level 1
Level 2
What Level Is Right For Me?
Contact Our Sales Team!
Level 1
Level 2
What Level Is Right For Me?
Contact Our Sales Team!

Topics
Dates & Registration

Excel 2010

Level 1

Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering, financial, and other needs. In addition, it can display data as charts, pivot tables, and pivot charts.

This Level one course covers all the essentials of Microsoft Excel. Topics covered including interacting with and formatting spreadsheets, as well as, using basic formulas. Material is also included to educate on how to insert art and objects; and chart data.


Excel

1 Day

List Price: $265


Register!

Topic 1: Starting Out

  • Opening Excel
  • Interacting with Excel
  • Closing Excel
  • Creating a New Workbook
  • Opening a Workbook
  • Saving a Workbook
  • Closing a Workbook
  • Using Worksheets
  • The Active Cell
  • Selecting Cells
  • Exploring a Worksheet
  • Using Zoom
  • Help Features

Topic 2: Working with Excel

  • Columns, Rows, Cells, and Ranges
  • Creating Worksheet Labels
  • Entering and Deleting Data
  • How to Cut, Copy, and Paste Cells
  • How to Cut, Copy, and Paste Multiple Cells and Items
  • Using the Clipboard
  • Using Paste Special
  • Using Undo and Redo
  • AutoFill
  • What is an AutoFill List?
  • Creating a Custom AutoFill List
  • Using a Custom AutoFill List
  • Modifying and Deleting a Custom AutoFill List
  • Basic Formulas
  • AutoSum

Topic 3: Editing your Workbook

  • Changing the Size of Rows or Columns
  • Inserting and Deleting Cells, Rows, and Columns
  • Adjusting Cell Alignment
  • Rotating Text
  • Creating Custom Number and Date Formats
  • Conditional Formatting
  • The Format Painter
  • Cell Merging and AutoFit
  • Adding Patterns and Colors
  • Adding Borders

Topic 4: Charts

  • Creating a Chart
  • Formatting a Chart
  • Modifying Charts with the Layout Ribbon
  • Manipulating a Chart
  • Changing the Chart Type
  • Changing the Source Data
  • Working with the Chart Axis and Data Series
  • What are Sparklines
  • Adding Sparklines
  • About the Sparkline Tools Tab
  • Editing Sparkline Data
  • Removing Sparklines
  • Editing Sparklines
  • Showing and Hiding Data
  • Changing the Style
  • Changing the Sparkline and Marker Color
  • Setting Sparkline Options

Topic 5: Enhancing Your Workbook

  • Insert a Symbol or Special Character
  • Adding and Editing Shapes
  • Working with Text Boxes
  • Adding a Text Box
  • Manipulating a Text Box
  • Formatting a Text Box
  • Inserting Pictures and Online Pictures

Topic 6: Printing and Viewing your Workbook

  • Using the View Ribbon
  • Using Normal View
  • Using Full Screen View
  • Using Page Layout View
  • Page Break Preview
  • Managing a Single Window
  • Creating a New Window
  • Freezing a Pane
  • Splitting a Worksheet
  • Managing Multiple Windows
  • Switching Between Open Workbooks
  • Arranging Workbooks
  • Comparing Workbooks Side by Side
  • Synchronous Scrolling and Resetting a Window
  • Checking Spelling
  • Printing your Workbook
  • Print Options

Topic 7: Introduction to Excel 365 Web App

  • Exploring Excel Online
  • Saving Documents in Excel Online
  • Collaborating with Multiple Users in Excel Online

Excel 2010

Level 1

1 Day

List Price: $265

Date Time Classroom or Online Select Session
08/13/2019 9:00 AM Classroom Add To Cart Add To Cart
09/18/2019 9:00 AM Classroom Add To Cart Add To Cart
10/18/2019 9:00 AM Classroom Add To Cart Add To Cart
11/13/2019 9:00 AM Classroom Add To Cart Add To Cart
12/06/2019 9:00 AM Classroom Add To Cart Add To Cart

Excel 2010

Level 2

Microsoft Excel Level 2 is intended to help everyday users become more proficient by expanding their knowledge of functions, formulas, managing tables, pivot tables and charts, hyperlinks, and securing your Excel files.

Excel

1 Day

List Price: $265


Register!

Topic 1: Working with Formulas and Functions

  • Understanding Relative and Absolute Cell References
  • Understanding Basic Mathematical Operators
  • What are Functions?
  • Inserting Functions
  • Some Useful and Simple Functions
  • Using the PMT Function
  • Using the If Function
  • Working with Nested Functions
  • Understanding Logical Functions
  • What are Range Names?
  • Defining and Using Range Names
  • Understanding VLOOKUP and HLOOKUP Functions
  • Using VLOOKUP to Find Data
  • How to Find an Exact Match with VLOOKUP
  • How to Find an Approximate Match with VLOOKUP

Topic 2: Managing Tables

  • What is a Table?
  • Creating Tables
  • Modifying Tables
  • Using the Table Tools - Design Ribbon
  • Adding a Total Row
  • What are Records and Fields?
  • Inserting Columns (Fields) and Rows (Records)
  • Deleting Columns (Fields) and Rows (Records)
  • Cleaning up Duplicate Records
  • Sorting Data in a Table
  • Filtering Data
  • Creating a Custom AutoFilter
  • Copying Filtered Records
  • Filtering with Wildcard Characters
  • Validating Your Data
  • Using Database Functions

Topic 3 - Get the Most from Your Data with PivotTables

  • Creating a PivotTable
  • Using the PivotTable Tools Ribbon
  • Adding and Removing Data with the Field List
  • Filtering Data
  • Sorting Data
  • Refreshing Data
  • Editing the Data Source
  • Modifying Fields and Labels
  • Modifying Values
  • Creating a Slicer
  • Using the Slicer Tools Ribbon

Topic 4: Everything you Need to Know About Hyperlinks

  • What is a Hyperlink?
  • Inserting Hyperlinks
  • Editing Hyperlinks
  • Formatting Hyperlinks
  • Using Hyperlinks in Excel

Topic 5: Securing your Excel Files

  • Marking a File Read Only
  • Protecting the Entire Workbook
  • Protecting the Current Sheet
  • Locking and Unlocking Cells

Topic 6: Using Excel with Cloud Storage

  • Introduction to Cloud Storage
  • Uploading Files to One Drive
  • Uploading Files to a SharePoint Team Site

Excel 2010

Level 2

1 Day

List Price: $265

Date Time Classroom or Online Select Session
07/30/2019 9:00 AM Classroom Add To Cart Add To Cart
08/28/2019 9:00 AM Classroom Add To Cart Add To Cart
09/27/2019 9:00 AM Classroom Add To Cart Add To Cart
10/30/2019 9:00 AM Classroom Add To Cart Add To Cart
11/25/2019 9:00 AM Classroom Add To Cart Add To Cart
12/17/2019 9:00 AM Classroom Add To Cart Add To Cart

Excel 2013

Level 1

Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering, financial, and other needs. In addition, it can display data as charts, pivot tables, and pivot charts.

This Level one course covers all the essentials of Microsoft Excel. Topics covered including interacting with and formatting spreadsheets, as well as, using basic formulas. Material is also included to educate on how to insert art and objects; and chart data.

1 Day

List Price: $265


Register!

Topic 1: Starting Out

  • Opening Excel
  • Interacting with Excel
  • Closing Excel
  • Creating a New Workbook
  • Opening a Workbook
  • Saving a Workbook
  • Closing a Workbook
  • Using Worksheets
  • The Active Cell
  • Selecting Cells
  • Exploring a Worksheet
  • Using Zoom
  • Help Features

Topic 2: Working with Excel

  • Columns, Rows, Cells, and Ranges
  • Creating Worksheet Labels
  • Entering and Deleting Data
  • How to Cut, Copy, and Paste Cells
  • How to Cut, Copy, and Paste Multiple Cells and Items
  • Using the Clipboard
  • Using Paste Special
  • Using Undo and Redo
  • AutoFill
  • What is an AutoFill List?
  • Creating a Custom AutoFill List
  • Using a Custom AutoFill List
  • Modifying and Deleting a Custom AutoFill List
  • Basic Formulas
  • AutoSum

Topic 3: Editing your Workbook

  • Changing the Size of Rows or Columns
  • Inserting and Deleting Cells, Rows, and Columns
  • Adjusting Cell Alignment
  • Rotating Text
  • Creating Custom Number and Date Formats
  • Conditional Formatting
  • The Format Painter
  • Cell Merging and AutoFit
  • Adding Patterns and Colors
  • Adding Borders

Topic 4: Charts

  • Creating a Chart
  • Formatting a Chart
  • Modifying Charts with the Layout Ribbon
  • Manipulating a Chart
  • Changing the Chart Type
  • Changing the Source Data
  • Working with the Chart Axis and Data Series
  • What are Sparklines
  • Adding Sparklines
  • About the Sparkline Tools Tab
  • Editing Sparkline Data
  • Removing Sparklines
  • Editing Sparklines
  • Showing and Hiding Data
  • Changing the Style
  • Changing the Sparkline and Marker Color
  • Setting Sparkline Options

Topic 5: Enhancing Your Workbook

  • Insert a Symbol or Special Character
  • Adding and Editing Shapes
  • Working with Text Boxes
  • Adding a Text Box
  • Manipulating a Text Box
  • Formatting a Text Box
  • Inserting Pictures and Online Pictures

Topic 6: Printing and Viewing your Workbook

  • Using the View Ribbon
  • Using Normal View
  • Using Full Screen View
  • Using Page Layout View
  • Page Break Preview
  • Managing a Single Window
  • Creating a New Window
  • Freezing a Pane
  • Splitting a Worksheet
  • Managing Multiple Windows
  • Switching Between Open Workbooks
  • Arranging Workbooks
  • Comparing Workbooks Side by Side
  • Synchronous Scrolling and Resetting a Window
  • Checking Spelling
  • Printing your Workbook
  • Print Options

Topic 7: Introduction to Excel 365 Web App

  • Exploring Excel Online
  • Saving Documents in Excel Online
  • Collaborating with Multiple Users in Excel Online

Excel 2013

Level 1

1 Day

List Price: $265

Date Time Classroom or Online Select Session
08/13/2019 9:00 AM Classroom Add To Cart Add To Cart
09/18/2019 9:00 AM Classroom Add To Cart Add To Cart
10/18/2019 9:00 AM Classroom Add To Cart Add To Cart
11/13/2019 9:00 AM Classroom Add To Cart Add To Cart
12/06/2019 9:00 AM Classroom Add To Cart Add To Cart

Excel 2013

Level 2

Microsoft Excel Level 2 is intended to help everyday users become more proficient by expanding their knowledge of functions, formulas, managing tables, pivot tables and charts, hyperlinks, and securing your Excel files.

1 Day

List Price: $265


Register!

Topic 1: Working with Formulas and Functions

  • Understanding Relative and Absolute Cell References
  • Understanding Basic Mathematical Operators
  • What are Functions?
  • Inserting Functions
  • Some Useful and Simple Functions
  • Using the PMT Function
  • Using the If Function
  • Working with Nested Functions
  • Understanding Logical Functions
  • What are Range Names?
  • Defining and Using Range Names
  • Understanding VLOOKUP and HLOOKUP Functions
  • Using VLOOKUP to Find Data
  • How to Find an Exact Match with VLOOKUP
  • How to Find an Approximate Match with VLOOKUP

Topic 2: Managing Tables

  • What is a Table?
  • Creating Tables
  • Modifying Tables
  • Using the Table Tools - Design Ribbon
  • Adding a Total Row
  • What are Records and Fields?
  • Inserting Columns (Fields) and Rows (Records)
  • Deleting Columns (Fields) and Rows (Records)
  • Cleaning up Duplicate Records
  • Sorting Data in a Table
  • Filtering Data
  • Creating a Custom AutoFilter
  • Copying Filtered Records
  • Filtering with Wildcard Characters
  • Validating Your Data
  • Using Database Functions

Topic 3 - Get the Most from Your Data with PivotTables

  • Creating a PivotTable
  • Using the PivotTable Tools Ribbon
  • Adding and Removing Data with the Field List
  • Filtering Data
  • Sorting Data
  • Refreshing Data
  • Editing the Data Source
  • Modifying Fields and Labels
  • Modifying Values
  • Creating a Slicer
  • Using the Slicer Tools Ribbon

Topic 4: Everything you Need to Know About Hyperlinks

  • What is a Hyperlink?
  • Inserting Hyperlinks
  • Editing Hyperlinks
  • Formatting Hyperlinks
  • Using Hyperlinks in Excel

Topic 5: Securing your Excel Files

  • Marking a File Read Only
  • Protecting the Entire Workbook
  • Protecting the Current Sheet
  • Locking and Unlocking Cells

Topic 6: Using Excel with Cloud Storage

  • Introduction to Cloud Storage
  • Uploading Files to One Drive
  • Uploading Files to a SharePoint Team Site

Excel 2013

Level 2

1 Day

List Price: $265

Date Time Classroom or Online Select Session
07/30/2019 9:00 AM Classroom Add To Cart Add To Cart
08/28/2019 9:00 AM Classroom Add To Cart Add To Cart
09/27/2019 9:00 AM Classroom Add To Cart Add To Cart
10/30/2019 9:00 AM Classroom Add To Cart Add To Cart
11/25/2019 9:00 AM Classroom Add To Cart Add To Cart
12/17/2019 9:00 AM Classroom Add To Cart Add To Cart

Excel 2016

Level 1

Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering, financial, and other needs. In addition, it can display data as charts, pivot tables, and pivot charts.

This Level one course covers all the essentials of Microsoft Excel. Topics covered including interacting with and formatting spreadsheets, as well as, using basic formulas. Material is also included to educate on how to insert art and objects; and chart data.

1 Day

List Price: $265


Register!

Topic 1: Starting Out

  • Opening Excel
  • Interacting with Excel
  • Closing Excel
  • Creating a New Workbook
  • Opening a Workbook
  • Saving a Workbook
  • Closing a Workbook
  • Using Worksheets
  • The Active Cell
  • Selecting Cells
  • Exploring a Worksheet
  • Using Zoom
  • Help Features

Topic 2: Working with Excel

  • Columns, Rows, Cells, and Ranges
  • Creating Worksheet Labels
  • Entering and Deleting Data
  • How to Cut, Copy, and Paste Cells
  • How to Cut, Copy, and Paste Multiple Cells and Items
  • Using the Clipboard
  • Using Paste Special
  • Using Undo and Redo
  • AutoFill
  • What is an AutoFill List?
  • Creating a Custom AutoFill List
  • Using a Custom AutoFill List
  • Modifying and Deleting a Custom AutoFill List
  • Basic Formulas
  • AutoSum

Topic 3: Editing your Workbook

  • Changing the Size of Rows or Columns
  • Inserting and Deleting Cells, Rows, and Columns
  • Adjusting Cell Alignment
  • Rotating Text
  • Creating Custom Number and Date Formats
  • Conditional Formatting
  • The Format Painter
  • Cell Merging and AutoFit
  • Adding Patterns and Colors
  • Adding Borders

Topic 4: Charts

  • Creating a Chart
  • Formatting a Chart
  • Modifying Charts with the Layout Ribbon
  • Manipulating a Chart
  • Changing the Chart Type
  • Changing the Source Data
  • Working with the Chart Axis and Data Series
  • What are Sparklines
  • Adding Sparklines
  • About the Sparkline Tools Tab
  • Editing Sparkline Data
  • Removing Sparklines
  • Editing Sparklines
  • Showing and Hiding Data
  • Changing the Style
  • Changing the Sparkline and Marker Color
  • Setting Sparkline Options

Topic 5: Enhancing Your Workbook

  • Insert a Symbol or Special Character
  • Adding and Editing Shapes
  • Working with Text Boxes
  • Adding a Text Box
  • Manipulating a Text Box
  • Formatting a Text Box
  • Inserting Pictures and Online Pictures

Topic 6: Printing and Viewing your Workbook

  • Using the View Ribbon
  • Using Normal View
  • Using Full Screen View
  • Using Page Layout View
  • Page Break Preview
  • Managing a Single Window
  • Creating a New Window
  • Freezing a Pane
  • Splitting a Worksheet
  • Managing Multiple Windows
  • Switching Between Open Workbooks
  • Arranging Workbooks
  • Comparing Workbooks Side by Side
  • Synchronous Scrolling and Resetting a Window
  • Checking Spelling
  • Printing your Workbook
  • Print Options

Topic 7: Introduction to Excel 365 Web App

  • Exploring Excel Online
  • Saving Documents in Excel Online
  • Collaborating with Multiple Users in Excel Online

Excel 2016

Level 1

1 Day

List Price: $265

Date Time Classroom or Online Select Session
08/13/2019 9:00 AM Online Add To Cart Add To Cart
08/13/2019 9:00 AM Classroom Add To Cart Add To Cart
09/18/2019 9:00 AM Online Add To Cart Add To Cart
09/18/2019 9:00 AM Classroom Add To Cart Add To Cart
10/18/2019 9:00 AM Online Add To Cart Add To Cart
10/18/2019 9:00 AM Classroom Add To Cart Add To Cart
11/13/2019 9:00 AM Online Add To Cart Add To Cart
11/13/2019 9:00 AM Classroom Add To Cart Add To Cart
12/06/2019 9:00 AM Online Add To Cart Add To Cart
12/06/2019 9:00 AM Classroom Add To Cart Add To Cart

Excel 2016

Level 2

Microsoft Excel Level 2 is intended to help everyday users become more proficient by expanding their knowledge of functions, formulas, managing tables, pivot tables and charts, hyperlinks, and securing your Excel files.

1 Day

List Price: $265


Register!

Topic 1: Working with Formulas and Functions

  • Understanding Relative and Absolute Cell References
  • Understanding Basic Mathematical Operators
  • What are Functions?
  • Inserting Functions
  • Some Useful and Simple Functions
  • Using the PMT Function
  • Using the If Function
  • Working with Nested Functions
  • Understanding Logical Functions
  • What are Range Names?
  • Defining and Using Range Names
  • Understanding VLOOKUP and HLOOKUP Functions
  • Using VLOOKUP to Find Data
  • How to Find an Exact Match with VLOOKUP
  • How to Find an Approximate Match with VLOOKUP

Topic 2: Managing Tables

  • What is a Table?
  • Creating Tables
  • Modifying Tables
  • Using the Table Tools - Design Ribbon
  • Adding a Total Row
  • What are Records and Fields?
  • Inserting Columns (Fields) and Rows (Records)
  • Deleting Columns (Fields) and Rows (Records)
  • Cleaning up Duplicate Records
  • Sorting Data in a Table
  • Filtering Data
  • Creating a Custom AutoFilter
  • Copying Filtered Records
  • Filtering with Wildcard Characters
  • Validating Your Data
  • Using Database Functions

Topic 3 - Get the Most from Your Data with PivotTables

  • Creating a PivotTable
  • Using the PivotTable Tools Ribbon
  • Adding and Removing Data with the Field List
  • Filtering Data
  • Sorting Data
  • Refreshing Data
  • Editing the Data Source
  • Modifying Fields and Labels
  • Modifying Values
  • Creating a Slicer
  • Using the Slicer Tools Ribbon

Topic 4: Everything you Need to Know About Hyperlinks

  • What is a Hyperlink?
  • Inserting Hyperlinks
  • Editing Hyperlinks
  • Formatting Hyperlinks
  • Using Hyperlinks in Excel

Topic 5: Securing your Excel Files

  • Marking a File Read Only
  • Protecting the Entire Workbook
  • Protecting the Current Sheet
  • Locking and Unlocking Cells

Topic 6: Using Excel with Cloud Storage

  • Introduction to Cloud Storage
  • Uploading Files to One Drive
  • Uploading Files to a SharePoint Team Site

Excel 2016

Level 2

1 Day

List Price: $265

Date Time Classroom or Online Select Session
07/30/2019 9:00 AM Classroom Add To Cart Add To Cart
07/30/2019 9:00 AM Online Add To Cart Add To Cart
08/28/2019 9:00 AM Classroom Add To Cart Add To Cart
08/28/2019 9:00 AM Online Add To Cart Add To Cart
09/27/2019 9:00 AM Classroom Add To Cart Add To Cart
09/27/2019 9:00 AM Online Add To Cart Add To Cart
10/30/2019 9:00 AM Classroom Add To Cart Add To Cart
10/30/2019 9:00 AM Online Add To Cart Add To Cart
11/25/2019 9:00 AM Classroom Add To Cart Add To Cart
11/25/2019 9:00 AM Online Add To Cart Add To Cart
12/17/2019 9:00 AM Classroom Add To Cart Add To Cart
12/17/2019 9:00 AM Online Add To Cart Add To Cart

back to top

Customize Sessions

Need a customized session?


Did you know that all of our sessions can be customized?
Let us help create a private session your team will love!

Selected Sessions

No Sessions Selected

Add a session to begin registration.
  • Chat with a Coach

    Have a more immediate need? Book a
    one-on-one virtual session with one of our coaches. Why spend the next hour searching online for answers? Spend just 15 minutes with one of our experts and get accurate and personalized answers to all of your questions. We're standing by ready to level up your knowledge of the apps you use every day.

    $9.99  |  15 minutes

      Book Now

  • Personalize This Session

    All of our sessions can be customized to meet your team's specific need. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team's valuable time!

    Let us help customize your next:

    Lunch-n-Learn

    30-90 Minute Webinar

    Half or Full Day Training

    On-Demand Learning

    Team Learning Paths



    Contact us today!



Contact

ETI Performance Improvement
8500 Keystone Crossing Suite 550
Indianapolis, Indiana 46240

p. 317.475.6555
e. [email protected]

Hours:
8:00 am - 5:00 pm M-F EST

Educate. Equip. Empower.
ETI Performance Improvement

© 2019 ETI Performance Improvement        Illustrations ©2012 Nathaniel Charles