Excel Training
Chicago

Excel 2013, 2016, 2019 & 365

Looking for a hands-on Microsoft Excel class in Chicago?

Our Excel classes are taught by instructors present in the classroom. They will teach you step-by-step how to master Microsoft Excel, with demonstrations, followed by hands-on exercises and one-on-one help if needed.

MS Excel 2019 box shot Satisfaction Guaranteed

What's Included

  • a printed Excel training manual
  • certificate of course completion
  • free refresher class valid for 6 months

Book an Excel training course today. All classes guaranteed to run!
Onsite Excel training available countrywide.

Microsoft Excel Course Outlines

Detailed Course Outline Hide outline

Excel Essentials
  • Starting Excel
  • The Excel Interface
  • Opening a Workbook
  • Navigating around a Workbook
  • Finding Data
  • Entering Data
  • Saving and Closing a Workbook
Creating Worksheets
  • Types of Data
  • Entering Text
  • Adjusting Column Width
  • Entering Numbers
  • Types of Formulas
  • Entering Formulas
  • About Functions
  • Inserting Functions
  • Copying and Moving Data
  • Copying Formulas
  • Absolute and Relative References
Formatting
  • Text Formatting
  • Number Formatting
  • Alignment
  • Text Wrapping
  • Merging Cell Data
  • Borders and Highlighting
  • Styles and Themes
Manipulating Data
  • Data Entry Shortcuts
  • Fill and Auto Fill
  • Replacing Data
  • Paste Options
  • Inserting and Deleting Rows and Columns
  • Hiding Rows and Columns
Charts
  • About Charts
  • Creating Charts
  • Chart Types and Elements
Output
  • Managing Worksheet Windows
  • Freezing Panes
  • Printing Worksheets
  • Print Setup Options
  • Print Areas and Titles
  • Headers and Footers
  • Sharing Workbooks
Settings and Templates
  • Workbooks Options and Properties
  • Working with Templates

"Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class."

MS Excel Level 2 - Intermediate

Excel Level 2 - Intermediate

On this course you will learn to manipulate data using sorting and filtering, conditional formating, PivotTables and advanced charting. You will share data across multiple workbooks, add graphics and learn to collaborate with others. Trainees should have completed our Introduction class or have the equivalent experience prior to attending this class.

1 Day $350

Detailed Course Outline Hide outline

Managing Workbooks
  • Inserting and Deleting Worksheets
  • Rearranging Worksheets
  • Adding Hyperlinks
  • Linking to other Workbooks
  • Customizing Excel
Named Ranges
  • Using Names in Formulas
  • Other ways to use Named Ranges
  • Naming Shortcuts
  • Managing Named Ranges
Filtering and Sorting Data Tables
  • Sorting Data
  • Custom Sorts
  • Filtering Tables
  • Using Auto-Filter
  • Removing Duplicate Rows
  • Working with Structured References
  • Data Validation
  • Transposing Rows and Columns
Summarizing Data
  • Consolidating Data
  • Using Sub-totals
PivotTables
  • About PivotTables
  • Creating PivotTables
  • Formatting PivotTables
  • Manipulating PivotTables
  • Viewing Subsets of PivotTable Data
  • Adding Slicers
  • Creating PivotCharts
Presentation Features
  • Conditional Formatting
  • Graphical Conditional Formatting
  • Custom Formats
  • Adding Graphics
  • Adding Smart Art
Advanced Charts
  • Special Chart Types
  • Inserting Trendlines
  • Combination Charts
  • Chart Templates
  • Inserting Sparklines
  • Quick Analysis Options
Collaboration
  • Controlling Access with Permissions
  • Protecting and Securing Workbooks
  • Shared Workbooks
  • Adding Comments
  • Tracking Changes
  • Merging Shared Workbooks

"Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class."

MS Excel Level 3 - Advanced

Excel Level 3 - Advanced

On this class you will learn advanced functions including LOOKUPS, Date and Time Functions, Text Functions, Statistical Functions, and Financial Functions. You will learn how to import and export data using the Power Pivot Data model and analyze data using What-If Analysis, Scenarios and Goal Seeker. Finally you will learn to automate tasks using Macros and capture user input using Forms.

1 Day $350

Detailed Course Outline Hide outline

Logical and Lookup Functions
  • The IF Function
  • Conditional Calculations
  • Using SUMIF
  • VLOOKUPS and HLOOKUPS
  • Range LOOKUPS
Advanced Formulas
  • Auditing and Error Trapping
  • Formula Options
  • Array Functions
  • Using TRANSPOSE
Special Functions
  • Date and Time Functions
    • TODAY
    • NOW
    • DATE
  • Date Calculations
  • Text Functions
    • Using CONCATENATE and TRIM
    • Using UPPER, LOWER and PROPER
    • Extracting Text
  • Statistical Functions
    • Using MIN and MAX
    • Using COUNT, COUNTA and COUNTBLANK
  • Financial Functions
    • Using FV
    • Using PMT
Importing and Exporting
  • The Power Pivot Data Model
  • Importing Data
  • Using Power Pivot
  • Exporting Data
Data Analysis
  • What-if Analysis
  • Scenarios
  • Using Goal Seek
  • The Analysis Toolpak
Macros and Forms
  • Recording Macros
  • Running Macros
  • Running Macros when Workbook is Open or Closed
  • Using Forms to Record Input

"Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class."

MS Excel Level 4 - Macros & VBA

Excel Level 4 - Macros & VBA

This course will help advanced Excel users develop the skills required to write and debug powerful VBA code to automate Excel operations such as inserting and formatting text, sorting and duplicating data, generating reports and more. You will also learn how to create interactive forms, insert calculations and handle run-time errors.

1 Day $450

Detailed Course Outline Hide outline

VBA Concepts
  • The Object Model Hierarchy
  • Understanding Object Properties, Methods and Events
  • VBA Module and Procedure Types
Accessing VBA Functionality
  • Macro Security Options
  • Using the Macro Recorder
  • Writing and Editing Macros
  • Essential VB Editor Components
  • Exploring the Object Browser
  • Using VBA Comments and Formatting to Write Solid Code
Debugging and Error Handling
  • Types of Programming Errors
  • VBE Debugging Tools
  • Error Handling Code
Using Variables to Store Data
  • VBA Data Types and Naming Rules
  • Declaring Variables
VBA Looping and Decision Structures
  • For...and Do...Loops for Repetitive Actions
  • If..then Statements
  • Select Case Statements
User-Interactive Worksheets
  • Capturing User Input
  • Dialog Box Types
Performing Calculations with VBA
  • Using VBA’s Built-in Functions
  • Writing User-Defined Functions for Custom Calculations
  • Code to Automate Inserting SUM Functions

"Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class."

Package deals

Excel 2-Level Package

$600

Book any two levels of Excel Levels 1, 2, or 3 and save $100!

Excel Levels 3 and 4 Package

$700

Book Excel Level 3 and Excel VBA and save $100!

Excel 3-Level Package

$900

Book Levels 1-3 of Excel training and save $150!

Excel Levels 2, 3, and 4 Package

$1000

Book Excel Levels 2, 3, and VBA and save $150.

Call us

(888) 815-0604

STILL NEED APPROVAL?

Want to reserve a seat but you still need to obtain approval?

No problem, simply call us or reach us using the chat feature, and we will provisionally hold a seat for you.
There is zero risk, if you don't get approval, we simply cancel the reservation.

Start Chat

Excel training reviews

Class rating

Excel classes rating: 4.8 stars from 6,617 reviewers

Excel training reviews

Microsoft Excel classes - 5 rating

Excel classes rating: 4.8 stars from 6,617 reviewers

Free Repeat

We recognize that Microsoft Excel is a complex program, and that trainees may benefit from repeating the class. Included in your course price is a FREE Repeat valid for 6 months. Often the repeat class can be with a different trainer too.

Money back guarantee

Our Walk Away, No Hard FeelingsTotally Outrageous Guarantee

Microsoft Excel is not for everyone. If you decide that after half a day in class that the software is not for you, we will give you a complete refund. We will even let you keep the hard-copy training manual in case you want to give it another go in the future.

Group Excel Training

We offer group training in Excel. This can be delivered onsite at your premises, at our training center in the LOOP or via online webinar.
Fill out the form below to receive pricing.

Step 1: Choose your Training Format

Step 2: Choose your Course/s

Step 3: Enter Details

Excel Training FAQ

Training Connection is dedicated to providing the best Excel classes in Chicago. Please find answers to some of our most frequently asked Excel training related questions below, or contact us should you require any further assistance.

Resources

Microsoft Excel Tutorials

In this section you will find step-by-step how to tutorials on Microsoft Excel.

Read more
Cheatseet & Shortcuts

Useful Excel cheatseets, and shortcuts PDFs you can download free of charge.

Read more
Specialist

The complete guide on Microsoft Excel certification in Chicago.

Read more
Microsoft Excel Class

Not sure which Excel class to join? The following guide will help you choose the right class.

Read more