Excel – Part 3

Ready to take your spreadsheet skills to the next level? This Advanced Excel Training course is designed for professionals who want to work smarter—not harder—with Microsoft Excel. You’ll build upon the foundational and intermediate knowledge from Microsoft Excel – Part 1 and Microsoft Excel – Part 2, helping you get the most out of your Excel experience. Learn to collaborate more effectively with colleagues, automate complex or repetitive tasks, and use conditional logic to create powerful formulas and functions. The more you master Excel’s advanced tools, the more you can shift your focus from manual work to extracting the insights your organization needs from its vast amounts of data. From building dynamic dashboards to forecasting trends, this course unlocks the full potential of Excel at your fingertips.

Course Details

Price:

$295.00

Days:

Location:

Virtual

Course Overview

In Advanced Excel Training, you’ll build the expertise needed to perform sophisticated data analysis, collaborate seamlessly on workbooks, and automate tedious tasks—boosting your efficiency and impact. Upon successful completion of this course, you will be able to: Work with multiple worksheets and workbooks. Share and protect workbooks to ensure secure collaboration. Automate workbook functionality with macros and advanced tools. Use Lookup functions and perform formula auditing to troubleshoot and enhance spreadsheets. Forecast and analyze data trends. Create Sparklines and map data for dynamic, visual reporting.

Students should have completed Microsoft Excel – Part 1 (Introduction) and Microsoft Excel – Part 2 (Intermediate), or have equivalent knowledge and experience. You should be comfortable entering and formatting data, creating basic formulas, using functions like SUM and IF, and working with simple PivotTables and charts.

1 – ANALYZING DATA

Tables
Conditional Formatting

2 – CREATE A PIVOTTABLE

Pivot Tables
Pivot Charts

3 – PREPARING DATA AND CREATING PIVOTTABLES

Summarize PivotTable Data
Organize PivotTable Data
Filter PivotTable Data
Format a PivotTable
Refresh and Change a PivotTable

Class Dates & Times


01/19/2026 Virtual 11:00:00 to 19:00:00 PST Enroll Now $295.00
01/26/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $295.00
01/09/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $295.00
02/04/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $295.00
02/25/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $295.00
02/17/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $295.00
03/05/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $295.00
03/13/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $295.00
03/23/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $295.00
03/31/2026 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 →