Excel Part 2 - Excel Intermediate Training

Name: Excel - Part 2
Price: 295.00 USD
Availability: InStock
Rating: 4.5 (1200 reviews)

Price
$295.00 USD

Duration
1 Day

Delivery Methods
Virtual Instructor Led
Private Group

Request More Information

Download Course Details

Course Details Only
Course Details & Schedule

Skip to Class Dates

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