Welcome to ONLC Training Centers

Microsoft Excel Classes

Microsoft Excel was first released in 1985 and it is still one of the most widely used and comprehensive spreadsheet programs today. Thanks to its functionality, Excel provides a variety of organizations and users simplified data solutions including, basic calculations, advanced data analysis, and data visualization. Having any skill level in this program is truly beneficial because Excel proficiency is in high demand by employers. And now users can leverage business intelligence tools within Excel to easily manipulate and combine data from multiple touchpoints.

ONLC offers multiple Excel learning formats, course levels and focuses. With our training you'll learn to create spreadsheets, data, calculations and more. In addition to furthering your Excel skills, you can use our courses to prep for professional certification—one of the best ways to prove your Excel skills and knowledge.

For additional assistance contact an ONLC Advisor via our chat icon on this page or 1-800-288-8221 (weekdays).

Excel Training Options Tailored to Your Learning Style

With ONLC, you can pick the experience that's best for your learning style, schedule, education budget and desired outcome. For most people, live, hands-on training that's led and supported by an online instructor is the most effective and efficient way to learn.

Click for FAQs about remote instructor-led training

Instructor-led Training (ILT)

Instructor-led training (ILT) classes are live, hands-on training. Training is fully interactive and led via an online instructor. We offer all Excel titles on our public schedule which you may attend from any of ONLC's hundreds of training centers or from your own location . ONLC's training rooms are outfitted with equipment and provide an interruption-free space for you to concentrate on learning.

Self-study, self-paced training

On-Demand Training (self-study / eLearning)

On-Demand courses are self-study, self-paced you take using your own equipment. On-Demand courses may include video tutorials, live labs and assessments. You have 24/7 access to your course for a set duration. See On-Demand course titles.

Ways to save on ONLC's classes

Single Course or Bundled Savings

Just need one course? Pick a public course title from our full Excel class list. Need multiple courses or MOS certification prep? Our Excel bundles provide savings on training in the format you prefer plus offer bonus features.

Private Group Training from ONLC

Custom & Private Excel Group Training

ONLC has options for groups that can help training coordinators, HR managers and Team Leaders upskill their group's skill successfully while staying on budget.

  • Public Classes. Pre-purchase our public training to receive volume discounting! Those coordinating training find this option very effective and efficient. With the discount established upfront, there’s no need to negotiate pricing on every registration. Participants can register themselves by phone or web, and the coordinator can access reporting to track, monitor and confirm training.

  • Private Classes. When group training is private course content can be customized and we can use a variety of learning formats to meet learning objectives, schedules and budgets.

Complete our quick Group Training Request form so together we can explore best options for your needs and we can provide a group training price quote.

Excel Class Titles & Schedule

Click course title for outline & dates (when applicable)

Excel Instructor-led (live, online ILT) Click for FAQs about remote instructor-led training

Click the title of the classes marked with the green flag () to see specific locations and dates of Ready to Run classes.  Click the title of the classes marked with the yellow flag () to see specific locations and dates of Early Notice classes.

Class Information
Click Title for Dates & Outlines Days Fee
Excel Core Skills & Topic-Specific Classes
Excel Introduction 1 $295
Excel Charts, Formatting and Reporting 1 $295
Excel Database Features and PivotTables 1 $295
Excel Workbooks, Formulas and Functions 1 $295
Excel Mixed-Topic Classes for Intermediate Users
Excel Tips, Tricks and Timesavers 1 $295
Excel Power User 2 $795
Excel Special Topics
Excel PowerPivot and Interactive Visualizations 3 $1495
Power BI Introduction for Excel Users 2 $795
Excel Forecasting and What-If Analysis 1 $395
Excel Macros 1 $395
Excel Programming with VBA 3 $1195    
Microsoft Official: Excel Analytics & Business Intelligence

 

Excel On-Demand (self-study, eLearning) Self-study, self-paced training

Class Information
Click Title for Dates & Outlines Days Fee
Core Office Courses
Excel 2019 On-Demand: Comprehensive (Parts 1, 2, & 3) 3 $495
Excel 2016 On-Demand: Comprehensive (Basic, Intermediate & Advanced) 3 $495
Microsoft BI Tool Series
Microsoft On-Demand: Power BI for Excel Users 2 $495
Microsoft On Demand: Power BI Intermediate 2 $595
Microsoft On-Demand Bundle: Power BI for Excel Users & Power BI Intermediate 4 $795
Excel Special Topics
Excel On-Demand: Excel 2013/2016 Programming with VBA 3 $695
Related Topics
Office 2019 On-Demand: Comprehensive (Excel, Word, Outlook, PowerPoint, Access) 14 $995

 

Other Microsoft Office Classes

See all Microsoft Office training classes

 

EXCEL CLASSES & SKILLS YOU’LL LEARN

With real-world experience, our Excel instructors ensure that lessons and course materials are applicable for job responsibilities. We offer courses for all levels of Excel users. Learning Excel will let you increase productivity and speed up daily tasks. Our Excel curriculum includes courses in which you could learn:

  • Excel basics, formulas, charts and database features
  • Excel data visualizations for advanced data and trend analysis
  • Excel for business intelligence (BI) forecasting and reporting
  • Basic formulas
  • Pivot Tables Charts
  • VLOOKUP
  • HLOOKUP
  • INDEX
  • MATCH
  • Macros
  • Programming with VBA
  • Workbooks
  • Business Intelligence (BI) tools

 

Excel Courses for Core Skills

Having fundamental experience with Excel is almost a necessity as Excel skills are in high demand by employers. Having that skill set may also provide advancement opportunities. The following courses will give you the core skills Excel users need.

Excel Introduction 365, 2019, 2016

During this one-day, online instructor-led hands-on course you'll learn to create basic Excel spreadsheets.
View outline & dates

Excel Charts, Formatting & Reporting

Learn the essentials regarding visualizations in Excel. During this one-day, online instructor-led course you'll create charts, use styles and templates and manage advanced worksheet formatting.
View outline & dates

Excel Database Features & Pivot Tables

During this one-day, online instructor-led course you'll learn the essentials regarding managing data and creating PivotTables in Excel. Students will create tables; import, modify and analyze data; create and enhance PivotTables.
View outline & dates

Excel Workbooks, Formulas & Functions

This one-day class covers the essentials of managing large worksheets, creating models, and working financial, date, and logical functions.
View outline & dates

Excel Power User Courses

Many who use Excel don't really know how to take advantage of all its features. These courses leverage advanced features and provide time-saving Excel techniques.

Excel Tips, Tricks & Timesavers

One of our most popular Excel courses, this class provides an overview of Excel's most used features, teaching you timesaving options in Excel.
View course outline & dates

Excel Power User

This two-day online instructor-led, hands-on course provides a high-level Excel overview, covering chart formatting and reporting, database features, pivot tables, how to leverage workbooks, formulas and functions.
View course outline & dates

Excel Programming with VBA

This three-day instructor-led, hands-on course teaches advanced Excel techniques. Students will learn how to use the Visual Basics of Application (VBA) language and Excel objects, including Pivot Tables.
View course outline & dates

Excel Forecasting & What If Analysis

This online instructor-led, hands-on course teaches the many built-in features and add-ons that make it easier to develop complex models that incorporate What-If Analysis.
View course outline & dates

Excel Business Intelligence (BI) Courses

Business intelligence tools provide data analysis solutions for organizations with large quantities of data or multiple data touchpoints. With Excel Power BI, users are able to store and share data through cloud technology. This integration with Big Data makes collaboration among remote teams and clients seamless.

Microsoft BI Tools: PowerPivot & Interactive Visualizations

This three-day online instructor-led, hands-on course is perfect for individuals whose job responsibilities include complex Excel reports and advanced analytics. It covers how to utilize Excel's Power Query to retrieve data, Power View to create interactive dashboards that teams can leverage, and Power Map to create 3D data visualization charts.
View course outline & dates

Microsoft BI Tools: DAX Formulas for Dynamic Tables

This two-day online instructor-led, hands-on course is ideal for Excel power users who are responsible for turning data into powerful reports. Participants will learn how to leverage Data Analysis Expressions (DAX) to extend Excel's reporting capabilities.
View course outline & dates

Microsoft BI Tools: Get & Transform Data

This one-day online instructor-led, hands-on course teaches participants how to maximize Excel's Power Query technology to transform data. Ideal for data scientists who are non-programmers, this course will teach users how to create automated reports and work with multiple queries.
View course outline & dates

Microsoft BI Tools: Power BI for Excel Users

This two-day online instructor-led, hands-on course is one of our most popular Excel BI courses. Ideal for non-IT professionals, participants will learn how to easily create and publish reports using Excel's Power BI cloud service.
View course outline & dates

Save with an Excel Bundle

MULTIPLE OPTIONS

Bundles need to be purchased BEFORE registering for any training and must be purchased by phone: 1-800-288-8221 (weekdays).
To view a course outline and upcoming ILT class dates click on the course title. MOS / MOS Expert certification details follow the bundle table or click here.

You will need to specify exam version (2019 or 2016) at the time of Bundle purchase.

Excel Training Bundles
Complete
(ILT+On-Demand)
All ILT
(ILT only)
On-Demand
(Self-study only)
Live, Online Instructor-Led Training (ILT)      
On-Demand Training      
Excel Comprehensive (Basic, Intermediate & Advanced)
(Intro, Charts, Database & Workbooks titles - specify version)
Hard copy for On-Demand
Retail Total:
$1,675
$1,180
$495
Training Bundle:
$1,250
$945
$495
Optional MOS Certification Add-on (retail value over $200) *
     
Exam Prep Software & Study Guide
Exam Voucher with Exam Pass Guarantee
Training Bundle with MOS Add-on:
$1,425
$1,120
$670

* Certification Add-on not sold separately. Retail value varies with Bundle type. See Bundle Terms & Conditions

 

Purchase Your Excel Bundle Today!

Bundles are available for purchase via our toll free number. We accept all major credit cards. To purchase contact an ONLC Advisor...

1.800.288.8221
(weekdays)

Excel Certification

Earning a Microsoft Office Specialist (MOS) certification proves to clients and perspective employers that you have the professional skills to work confidently in a specific Office application and can maximize its features to complete tasks. ONLC's classes can help you prep for MOS and MOS Expert certifications.

EXCEL MOS

MOS Excel certification

Earning MOS Excel confirms you have core Excel skills and maximize its features to complete tasks.

The below courses are recommended along with hands-on experience with the software to earn MOS certification.

Recommended Training

 

Certification Exam

MO-200: Excel Associate (Excel 365 / 2019) —OR— 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation

MOS authorized exams are performance-based and available from Certiport. Exam candidates schedule directly with Certiport. When you pass the authorized exam, you will receive a digital badge for that credential. Microsoft changes their exams frequently to maintain integrity, as such, training alone may not cover all skills on the exam.

EXCEL MOS EXPERT

MOS Expert Excel certificaiton

Earning MOS Expert certification proves you have advanced-level skills and understanding in a specific Office application and can assist others with proper use of the program's features.

The below courses, which are the same as those for the MOS credential above, can help you get started. You should also have extensive hands-on experience with Excel before attempting the MOS-Expert exam as it goes into much greater depth and breadth than the entry-level MOS exam.

Recommended Training

 

Certification Exam

MO-201: Excel Expert (Office 365 / 2019) —OR— 77-728: Excel Expert 2016: Interpreting Data for Insights.

MOS Expert authorized exams are performance-based and available from Certiport. Exam candidates schedule directly with Certiport. When you pass the authorized exam, you will receive a digital badge for that credential. Microsoft changes their exams frequently to maintain integrity, as such, training alone may not cover all skills on the exam.

Other Information & Options

Microsoft Excel Versions 365 / 2019 / 2016
These software versions are very similar. The difference is mostly a matter of how you're accessing the software. Microsoft Excel 365 is accessed via the cloud. You pay a monthly subscription to use the software. Since it's not static on your device, you'll get updates to the software when they happen. On the otherhand, 2019 / 2016 and earlier PC versions are purchased outright and installed directly onto your computer (aka "on-premise"). Excel features and functions are the same no matter which of these versions you're using and as such students with those versions can attend the same classes.

Call an ONLC Education Advisor for certification and course selection assistance

Education Advisors for Assistance
Our advisors can answer questions you may have about our training options as well as Microsoft certification. They can help you determine a training path that is right for your background and your goals. Advisors are available weekdays at our toll free number or via the CHAT feature.

 

Find an ONLC center near you

Hundreds of ONLC Training Centers Coast to Coast
We schedule every online instructor-led (ILT) class for each of our ONLC Training Centers locations. Our training rooms are outfitted with the equipment needed for training and provide an interruption-free space so you can concentrate fully on learning. See ONLC locations.

 

Train at Home

Live Excel Classes from Home
You can attend our same live, instructor-led classes from the comfort and convenience of your own home. The setup is really easy and you don't have to have the class software on your device. Follow our easy setup video. If you're still not sure about the setup after contact an ONLC Advisor toll free for assistance.

 

Bundle your training to save!

Save a Bundle!
We have discounted bundles for those who need more than one Excel course. You get to select your preferred class format and can opt for a MOS Certification Add-on—all at a discount. See Excel Bundles

 

Group training available from ONLC

Excel Group Training
ONLC has training solutions specifically for large groups and companies. Options can include hands-on, lecture, eLearning and more. Training can be delivered virtually or in-person at your site. With private training content can be customized to meet a client's specific configurations and technologies. To explore ways we can reduce your training costs and employee downtime while maximizing learning and retention, complete our Group Training Request form so we can provide a price quote.

 

Microsoft Office Training: Get 5 days for Price of 4

Train on Multiple Topics in Microsoft Office / Office 365 at a Savings!
Our 5/4 Office Saver gives you 5 training days on programs within Office for the price of 4. Your choice of topics (Excel, Word, PowerPoint and more), plus upgrade options. Find out more

 

For More Information

To learn more about Microsoft Excel classes and certifications, please contact our Education Advisors at:

1.800.288.8221

(weekdays)

 

Top of page Top of page

Locations

ONLC Locations

District of Columbia

ONLC TRAINING CENTERS
800-288-8221
www.onlc.com