Excel Intermediate Training

Price
$295.00 USD

Duration
1 Day

 

Delivery Methods
Virtual Instructor Led
Private Group

Excel Intermediate Training Overview

Ready to go beyond the basics? Our Intermediate Excel Training course is perfect for professionals who want to turn raw data into clear insights using Microsoft Excel. Whether you're managing projects, tracking budgets, or building reports, this course gives you the tools to work smarter—not harder. You’ll dive into features like advanced functions, data analysis tools, PivotTables, and charting—all designed to help you confidently modify spreadsheets and workbooks to support better decision-making. With over 60% of employers saying Excel skills are in high demand, this training is a smart step in growing your career.

This course builds on the foundational knowledge from Excel – Part 1 and takes your skills to the next level. It aligns with Microsoft Office Specialist exam objectives, helping you prepare for the Excel Associate (MO-200) and Excel Expert (MO-201) certifications. You'll learn how to build and modify advanced workbooks that streamline processes and enhance data insights in your organization.

What Is Included

  • Expert-Led Training – Learn from certified instructors with hands-on Microsoft Excel expertise.
  • 90-Day Access to Class Recordings – Revisit your virtual instructor-led sessions anytime for up to 90 days.
  • Guaranteed-to-Run Courses – We never cancel a scheduled class, so your training stays on track.
  • Flexible Rescheduling – Option to reschedule your course if needed (see conditions).
  • Free Course Retake Option – Retake the course at no additional cost (see conditions).

Course Objectives

By the end of this intermediate Excel training course, you’ll be able to work confidently within Microsoft Excel—applying logical, date/time, and text functions; managing lists of data using tables and filters; and using conditional formatting to highlight trends. You’ll also learn how to create, modify, and enhance workbooks with charts, PivotTables, and PivotCharts. These real-world skills will help you transform raw data into clear, actionable information and support smarter, data-driven decision-making.

Who Should Attend?

This course is ideal for professionals who already have a basic understanding of Microsoft Excel and want to deepen their capabilities. It’s a great fit for analysts, administrative staff, project leads, and anyone who regularly uses Excel to manage data, generate reports, or support business decisions.

  • Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
  • Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
  • Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
  • Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
  • Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
  • Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

What skills will I learn in intermediate Excel training?

You’ll learn to use advanced functions, modify and analyze workbooks, organize and filter large datasets, apply conditional formatting, and create dynamic charts and PivotTables—all in Microsoft Excel.

What version of Microsoft Excel does this course cover?

This course focuses on features that are consistent across most versions of Microsoft Excel, so the skills you learn will apply regardless of the version you use at work. If your team needs training aligned to a specific version, we’d be happy to help—just contact us.

Is this course suitable for beginners?

This is an intermediate-level course. If you're brand new to Microsoft Excel, we recommend starting with Excel – Part 1.

How can Excel skills impact my career?

Proficiency in Microsoft Excel can significantly increase your value at work. Data analysts, for example, earn an average salary of nearly $80K, and Excel is widely used across operations, finance, and administrative roles.

Where can I find your training policies?

Visit our FAQs & Policies page to review our rescheduling, cancellation, and retake policies.

Learning Credits: Learning Credits can be purchased well in advance of your training date to avoid having to commit to specific courses or dates. Learning Credits allow you to secure your training budget for an entire year while eliminating the administrative headache of paying for individual classes. They can also be redeemed for a full year from the date of purchase. If you have previously purchased a Learning Credit agreement with New Horizons, you may use a portion of your agreement to pay for this class.

If you have questions about Learning Credits, please contact your Account Manager.

Corporate Tech Pass: Our Corporate Tech Pass includes unlimited attendance for a single person, in the following Virtual Instructor Led course types: Microsoft Office, Microsoft Technical, CompTIA, Project Management, SharePoint, ITIL, Certified Ethical Hacker, Certified Hacking Forensics Investigator, Java, Professional Development Courses and more. The full list of eligible course titles can be found at https://www.newhorizons.com/eligible.

If you have questions about our Corporate Tech Pass, please contact your Account Manager.

Course Prerequisites

Participants should have completed Excel – Part 1 or have equivalent experience using Excel formulas, formatting, and workbook navigation.

Agenda

Working with Functions

  • Work with ranges
  • Use logical, date/time, and text functions
  • Apply specialized formulas

Working with Lists

  • Sort and filter data
  • Query data with database functions
  • Outline and subtotal lists within a workbook

Analyzing Data

  • Create and manage Excel tables
  • Apply intermediate and advanced conditional formatting

Visualizing Data with Charts

  • Build and modify charts for clarity
  • Apply formatting and advanced chart features

Using PivotTables and PivotCharts

  • Create and analyze PivotTables
  • Build dynamic PivotCharts
  • Use slicers and timelines for filtering
 

Upcoming Class Dates and Times

May 5
8:00 AM - 4:00 PM
ENROLL $295.00 USD
May 7
8:00 AM - 4:00 PM
ENROLL $295.00 USD
May 12
8:00 AM - 4:00 PM
ENROLL $295.00 USD
May 14
8:00 AM - 4:00 PM
ENROLL $295.00 USD
May 19
8:00 AM - 4:00 PM
ENROLL $295.00 USD
May 21
8:00 AM - 4:00 PM
ENROLL $295.00 USD
May 28
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Jun 2
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Jun 4
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Jun 6
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Jun 11
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Jun 16
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Jun 18
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Jun 23
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Jun 27
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Jun 30
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Jul 2
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Jul 9
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Jul 15
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Jul 21
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Jul 24
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Jul 31
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Aug 6
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Aug 12
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Aug 19
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Aug 25
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Aug 29
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Sep 8
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Sep 12
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Sep 18
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Sep 24
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Oct 1
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Oct 8
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Oct 15
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Oct 21
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Oct 28
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Nov 3
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Nov 10
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Nov 14
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Nov 20
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Nov 26
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Dec 5
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Dec 11
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Dec 18
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Dec 24
8:00 AM - 4:00 PM
ENROLL $295.00 USD
Dec 30
8:00 AM - 4:00 PM
ENROLL $295.00 USD
 



Do You Have Additional Questions? Please Contact Us Below.

contact us contact us 
Contact Us about Starting Your Business Training Strategy with New Horizons