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.

Managing Multiple Worksheets and Workbooks

Create links between workbooks and use external references
Work with 3-D references across worksheets
Combine and consolidate data from multiple sources

Collaborating and Securing Your Workbooks

Co-author workbooks and manage collaboration features
Protect worksheet content and control access permissions

Streamlining Tasks with Automation

Set up data validation rules to control user input
Find and fix invalid data and formula errors
Automate repetitive actions with recorded macros

Mastering Lookup Functions and Formula Auditing

Use advanced Lookup functions to retrieve data
Trace cell relationships and troubleshoot formulas
Monitor calculations with the Watch Window and Evaluate Formulas

Predicting and Forecasting Data Trends

Analyze possible outcomes using data tables
Explore scenarios for strategic decision-making
Apply the Goal Seek tool to backtrack solutions
Build simple forecasts based on historical data

Visualizing Data with Sparklines and Maps

Summarize trends with Sparklines inside cells
Create basic geographic maps to display data visually

Class Dates & Times


01/20/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $295.00
01/23/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $295.00
01/28/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $295.00
01/15/2026 Virtual 11:00:00 to 19:00:00 PST Enroll Now $295.00
01/12/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $295.00
01/07/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $295.00
02/13/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $295.00
02/10/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $295.00
02/05/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $295.00
02/02/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $295.00

12…6

— 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 →