Microsoft Excel
Training

Instructor-led Excel classes in Los Angeles

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

  • A printed Excel training manual
  • Certificate of course completion
  • Small class sizes
  • FREE repeat valid for 6 months
  • Class times are 9.00am to 4.00pm.

Looking for an online class?
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
  • 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.

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!

Excel 3-Level Package

$1035

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

Excel Levels 3 and 4 Package

$790

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

Excel Levels 2, 3, and 4 Package

$1135

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

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.

Latest blog articles

The Salary Boosting Secret You Didn’t Know: Mastering Excel

The Salary Boosting Secret You Didn’t Know: Mastering Excel
Did you know that Microsoft Excel is the world’s most popular Office productivity tool and that learning Excel can really boost your income-earning potential? It's quite obvious really, but did you know by 'how much' it can boost your potential? We did a deep dive into the subject of Excel-based salaries to find out just how much...

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

Excel Training FAQ

Training Connection is dedicated to providing the best in-person and online Excel training classes in Los Angeles. 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 in Los Angeles.

Read more
Microsoft Excel Class

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

Read more

 

10 Unbeatable Benefits of Classroom-Based Microsoft Excel Courses in LA


Microsoft Excel is probably one of mankind’s most popular and useful software achievements, which is also why it’s far and away the most sought-after training course here at Training Connection. But which to choose, Classroom Based or Online Tuition? Whilst online tutorials are widely available (and we do offer them!), we have to say that nothing beats the hands-on experience and expert support of in-person classroom-based training… especially when it’s based here in the wonderful City of Angels, Los Angeles. 

Here are 10 utterly compelling reasons why choosing classroom learning can dramatically improve your Excel skills and turbo charge your career growth. Don’t believe us? We wrote an article on the Different Salary Levels with Excel Progression - available here. 

1. Access to Expert Instructors.

With Excel Training, you have direct access to highly experienced and skilled Excel Instructors who can answer your questions immediately (if not sooner…). Whether it's mastering PivotTables or troubleshooting formulas, they are there on hand and in the flesh to guide you along your path and ensure you fully understand even the trickiest of Excel functions.

2. A Clear and Structured Learning Path.

Yes, it’s a headache and a time sink trying to piece together scattered Youtube tutorials or locate the right online forums. Our Excel classroom courses are carefully designed to teach you the essentials first, followed by advanced techniques when you’re ready. You’ll receive a complete, cohesive understanding of MS Excel, from basic data entry to powerful data analysis tools like Power Query and VBA.

3. Practice Now with Real-World Scenarios.

Classroom training focuses on applying what you learn while an instructor is on hand. You’ll work on practical exercises, such as creating financial models or automating workflows, the goal is to mimic real-world tasks and get that sense of achievement when the outcome is clear and correct. By the end of the course, you’ll feel confident handling the most complex Excel challenges in your day-to-day work.

4. Top Quality Learning Materials and Resources.

You’ll also gain access to exclusive business Excel course materials, including templates, reference guides, and practice files. While some of these might be included in online courses, in-person training makes them a central part of your experience, ensuring you’re fully equipped to get back to your work station and succeed.

5. Building a Professional Network.

Classroom sessions bring together an eclectic mix of professionals from various industries and roles. Whether you’re a financial analyst, project manager, or business owner, this is a chance to exchange phone numbers, ideas, share insights, and even discover new career opportunities.

6. Instant Solutions to Your Problems.

Is that nested IF statement or Excel error like #VALUE!? driving you nuts? Your instructor is right there to troubleshoot and guide you. This real-time problem-solving philosophy ensures you don’t turn positive energy into frustration and waste hours figuring and fighting it out on your own.

7. Learning without Distractions.

Classroom environments are designed for ‘me time only focus’. Unlike online learning at home, you’re free from the usual procrastination and interruptions. And the fridge could do with a break from being constantly opened! This allows you to really dive deep into all of Excel’s capabilities and retain what you’ve learned more effectively.

8. Learn all the Latest Excel Features and Tools.

MS Excel is constantly improving and evolving and so do our training courses. All our classroom courses stay true and current with Microsoft’s latest updates. Whether it’s dynamic arrays, XLOOKUP, or the newest Power BI integrations, you’ll be learning features that keep you constantly ahead of the curve.

9. Immersive Learning actually Boosts Retention.

In-person Excel Class training offers you a far more immersive experience which enhances knowledge retention through active engagement. When you’re fully immersed in a supportive, distraction-free environment, it’s been proven that you’ll learn faster and remember more.

10. A Certificate of Completion with your Microsoft Excel Training Workshops. 

When you complete any Office Excel Training Course here at Training Connection you'll receive a professional and recognized certificate that confirms and validates your new Excel skills. Whether you’re applying for a job, asking for a promotion or a raise (see tips on asking for a raise here) or pitching yourself as a professional bona fide freelancer, this credential gives you a real competitive edge. 

 

The History of Training Connection and Our Partnership with MS Excel

 

20 years ago we had a simple idea and a mission - born out of Founder Billy Gee's family history in teaching - to take personal and professional tuition and wrap them up together in exceptional learning experiences that would empower individuals and professionals to survive and thrive in their lives and careers. Since our very first class welcomed students in 2006, we have been at the very forefront of delivering high-quality, instructor-led courses that are both practical and impactful. Among the many programs we offer, our Excel Training Classes have become one of the most popular courses and the cornerstone of our longevity and ongoing success. Yes, of course it’s also about our amazing students but we’ll get to you guys later…

Our Early Days.

A small classroom with a big dream – our vision was to bridge the gap between theoretical learning and real-world application, so we set out to create a learning environment that would prioritize what we called our ‘hands up, hand holding, hands-on experience’ – where students would not be afraid to ask questions (no matter how ‘silly’ they thought they were). From the very beginning, we recognized the importance of calm, conversational style tutoring – especially with complex tools like Microsoft Excel that are designed to shape critical touch points in a business. Workplace efficiency and decision-making being just two of the most important ones. This led to the launch of our first Excel Course in Los Angeles and since then we are more than humbled to say that we’ve helped equip thousands of individuals and professionals with the skills to reach their career and income potential using this brilliant and powerful piece of software.

Did you know: The very first version of MS Excel was released in 1985! A very smart chap by the name of Doug Klunder created the key figures that made the application what it is today. Until he did this, other spreadsheet programs like Lotus 1-2-3 and VisiCalc were the dominant and pioneering forces in integrated and expansive spreadsheets in the early 80’s (we wonder if any of our students remember or have even heard of these?). But like all good copycats, MS simply took what worked and made it better – ‘Excel’ was packed full of technological wonders like intuitive interfaces, drop down menus and in-cell editing which led to the Windows version launching in 1987 and the rest… is his story (and now ours!).

Building a Partnership with MS Excel.

As businesses became more and more reliant on data analysis and reporting, Excel became a must have tool in workplaces worldwide. We recognized this trend and we deepened our focus on offering more focused and specialized MS Excel Training Courses. From foundational skills like creating spreadsheets to advanced techniques in data visualization and macro creation, we have made sure that our Excel Classes have evolved alongside the software itself.

Because of our close alignment with Microsoft Excel's updates and features we ensure our students receive training that is not only relevant but also and always future-proof. Each course is carefully designed for all skill levels, allowing beginners and advanced users to find the training they need to excel in their careers (pun intended).

Why Excel Training Matters.

In today’s highly competitive, data-driven world, mastering Excel is more than just a workplace requirement, it’s a highly revered and competitive advantage. Through our Excel Training Classes, we have helped and will continue to help individuals and teams unlock the full potential of Excel, because students who enrol in our Excel Courses don’t just learn the basics; they gain the confidence to tackle complex data challenges, streamline workflows - and importantly - are able to present insights to their peers, managers, directors and shareholders that can drive impactful decision making.

Our Unique Approach to Excel Classes.

What sets us apart from the many training schools that have opened over the years is our continued commitment to hands-on learning. We believe the best way to master a tool like Excel is by using it in real-world scenarios. That’s why our courses are packed full of practical exercises and case studies that mirror the challenges we all face on a daily basis. Whatever industry you’re in, chances are you need Excel and you need someone with the skills to use the software the way it was designed to be used.

All our instructors are fully vetted, seasoned industry experts who all bring a wealth of experience to the classroom. Many have been with us for over 5 years. They go beyond the textbook to provide insights, tips, and tricks that simply can’t be found in online tutorials and they take great pleasure in letting us know about it too! This ensures that every participant leaves our Excel Training Classes with actionable knowledge they can apply immediately.

The Future of Training Connection.

As we continue to grow, our commitment to outstanding tuition and excellence in after class support remains unwavering and is as important today as it was 20 years ago. In fact, it’s our students who have inspired us to continue to reach for the stars and constantly innovate our course offerings, integrate the latest features of Excel into our Los Angeles Excel Training Programs and expand into new areas of professional and personal development. Perhaps it's only apt that the story about us ends with a thank you (told you we wouldn't forget about you :).