Excel – Part 2

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.

Course Details

Price:

$295.00

Days:

Location:

Virtual

Course Overview

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.

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

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

Class Dates & Times


06/11/2025 Virtual 09:00:00 to 17:00:00 EST Enroll Now $295.00
06/23/2025 Virtual 09:00:00 to 17:00:00 EST Enroll Now $295.00
06/30/2025 Virtual 09:00:00 to 17:00:00 EST Enroll Now $295.00
06/16/2025 Virtual 09:00:00 to 17:00:00 EST Enroll Now $295.00
06/18/2025 Virtual 09:00:00 to 17:00:00 EST Enroll Now $295.00
06/27/2025 Virtual 09:00:00 to 17:00:00 EST Enroll Now $295.00
07/21/2025 Virtual 09:00:00 to 17:00:00 EST Enroll Now $295.00
07/09/2025 Virtual 09:00:00 to 17:00:00 EST Enroll Now $295.00
07/02/2025 Virtual 09:00:00 to 17:00:00 EST Enroll Now $295.00
07/31/2025 Virtual 09:00:00 to 17:00:00 EST Enroll Now $295.00

12…4

— Questions?

Information Request

— Empower Change

Invest in Skills & Equality

Support Diversity, Equity, and Inclusion with Every Purchase.

Great Horizons is a North Carolina Certified HUB Vendor and WOSB. By becoming a patron of our organization, you are not only supporting a historically underutilized business, but a woman-owned small business as well.

Student? Switch to our Career Center Site →