Online Microsoft
Excel Training

Online Instructor-led classes

You will be learning Microsoft Excel from a live instructor.

They will teach you step-by-step how to master Excel, using
demonstrations, hands-on exercises and one-on-one help.

Suitable for Excel 2016, 2019 & 365 users.

MS Excel Software Satisfaction Guaranteed

What's Included

  • An Excel training manual
  • Certificate of course completion
  • Small class sizes
  • FREE repeat valid for 6 months


Onsite Excel training available countrywide.

View Outlines Package deals Private Group Training In-person classes

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
  • Create Simple Charts
  • Changing a Chart's Type
  • Adding Elements to Charts
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."

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."

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 analysis data using What-If Analysis, Scenarios and Goal Seeker. Finally you will learn to automate tasks using Macros and capture user input using Forms.

Book this course Download PDF TimeTable
1 Day $395

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."

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

$690

Book any two levels of Excel training and save $100!

Book Package

Excel 3-Level Package

$1035

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

Book Package

Excel Levels 3 and 4 Package

$790

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

Book Package

Excel Levels 2, 3, and 4 Package

$1135

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

Book Package
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 and we will provisionally hold a seat for you.
There is zero risk, if you don't get approval, we simply cancel the reservation.

Excel training reviews

Excel classes - 5 rating

Excel classes rating: 4.9 stars from 7150 reviewers

"Top-notch in every respect, bar none. Friendly staff, modern facilities, and a fine environment, all make the education experience one that is conducive for learning on a high level."

"This course was incredible. I expected it to go too slow, but it remained entertaining and informative on the topics I would have said I already knew prior. The instructor made people feel welcome and he was excellent at feeling out the room for pace and energy levels."

"Outstanding course. This was my third of all three excel courses and I highly recommend all three. Carol is an outstanding teacher. I could not imagine learning from anyone else. Thanks. "

"I've had experiences with various Excel training courses and Chris is by far and away the best instructor. He was clear, concise and to the point. He provided us with exactly what we needed. I will definitely be back."

"This is my third course with Training Connection. I have taken several other courses with other companies but the facilities and instructors at The Training Connection are the best I've seen"

View all student reviews

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.

Class 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 Los Angeles, or via 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

Online Excel Training FAQs

Training Connection is dedicated to providing the best online Excel training classes. Please find answers to some of our most frequently asked Excel training related questions below, or contact us should you require 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.

Read more
Microsoft Excel Class

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

Read more

 

Is Excel Online Training the Right Excel Training for Me?

 

Yep, it’s the million-dollar question (actually… we wrote a Blog post about just how many $’s you could earn with Excel Skills). But should it be In-Class or Online? Which one is right for you? Well, we can say straight up, that the best tuition would always be MS Excel Classroom Based Training (take a look at the page for more reasons why), just think about it, if online teaching was indeed better then why did the nation go back to class after Covid? It’s just more productive with less distractions, and being the gregarious species that we are, its simply more collaborative and rewarding. That’s not to say that Online Classes are the wrong fit for you. If you cannot afford to drive or fly to a classroom somewhere around our huge beautiful US of A (in our case it’s LA) or you only have limited time, and if you’re the reasonably disciplined type with great work ethic… and you can leave your mobile phone on silent (sorry, what did we just say?!) then our Online Classes would absolutely be right for you. Over the past 20 years we’ve picked up a thing or two about teaching and tuition so regardless of which one you select, you’ll be looked after and skilled up! Here’s everything you need to know about our Excel Online Courses to help you make the right decision…

What are the best Online Excel Courses on offer?

Firstly, all our Online Courses are live, instructor-led courses tailored to suit every skill level, so you’ll be well covered whichever one you choose:

 

How much do Online Excel Training Programs cost?

Most courses including ours are priced at:

We also price match and we offer package deals and private group training options – this is a great way to save if you’re planning on taking multiple courses! And you can spread them out over the year using your discount allowance for multiple courses.

How long is a typical Excel Online Class?

One day, that’s it. Running from morning to late afternoon or early evening depending on your time zone, with a 30-45-minute lunch break. Whether you’re on Pacific, Central, or Eastern time, we’ve got you covered.

Will I receive a nice shiny Certificate?

Absolutely! At the end of your Online Excel Course, you’ll receive a professional certificate of completion to showcase your new skills to your boss or recruitment agency.

Are there free online Excel Training Resources?

Sure there are, YouTube is great like that. But we specialize in paid, live instructor-led training to ensure you receive top-quality, personalized attention. While there are no free resources (other than what our generous trainer Kristian has added to our Blog), our one stop, hands-on learning with our fully vetted, professional trainers, and real-time interaction make our courses well worth the investment.

How do Online Excel Classes compare to In-Person Training?

Our online classes are designed to feel as much like in-person classroom training as possible. You’ll enjoy real-time interaction with expert instructors, live demonstrations, hands-on exercises, and one-on-one assistance - all from the comfort of your home or office.

What prior skills do I need before I sign up for my Excel Online Course?

For Level 1, no prior experience is needed - it’s totally beginner-friendly (in other words, if you can work a calculator your good to go). For intermediate and advanced levels, having basic Excel knowledge will help you to really hit the ground running.

Can I get course material after completing the Online Excel Training?

Yes, we’re giving them away! Not because we’ve got too many, but because they’re really helpful to you and included in the cost. You’ll receive an up-to-date training manual that serves as a handy reference you can access at any time, especially great to revisit after the course ends.

Do employers value Online Excel Certifications?

Yes, anything that states that you've taken the time to skill up is a valuable asset to show off and be proud of. And employers certainly value certifications from reputable training providers like Training Connection (that’s us btw).

If you’re ready to take your Excel skills to the next level, or if you have more questions, visit us at Training Connection. We’d love add you to our happy, successful family!