Microsoft Office Excel Intermediate: Leverage Advanced Formulas

Intended Organizations
Skill LevelIntermediate
Virtual | Live Trainer4 hours/day, 1 Day
In-Person | Onsite6 hours/day, 1 Day
Hands working on a tablet chart and laptop to analyze spreadsheet data

Course Overview

The course covers the latest version of Microsoft Excel (2021–2024);
earlier versions are available upon request.

You know how to use Microsoft Excel to perform simple calculations and modify your workbooks and worksheets to make them easier to read, interpret, and present to others. However, Microsoft Excel is capable of doing so much more. With this course, you can extract actionable organizational intelligence from your raw data to crunch the numbers when needed.

Course Prerequisite: Microsoft Excel Basic

Recommended Follow-Up: Microsoft Excel Advanced

Learning Objectives

  • Work with functions.
  • Work with lists.
  • Analyze data.
  • Visualize data with charts.
  • Use PivotTables and Pivot Charts.

Who It's For

  • Excel users who want to move beyond basic spreadsheet calculations.
  • Professionals who need to analyze and interpret business data.
  • Employees who want to use advanced formulas and functions efficiently.
  • Analysts who need to organize, sort, filter, and summarize large datasets.
  • Professionals who want to create charts, PivotTables, and PivotCharts.

Course Agenda

Five modules · 19 topics
1Working with Excel FunctionsTopics 1–5
  1. Work with Ranges 
  2. Use Specialized Functions
  3. Work with Logical Functions 
  4. Work with Date & Time Functions 
  5. Work with Text Functions
2Working with Excel ListsTopics 6–9
  1. Sort Data 
  2. Filter Data 
  3. Query Data with Database Functions 
  4. Outline and Subtotal Data
3Analyzing DataTopics 10–12
  1. Create and Modify Tables 
  2. Intermediate Conditional Formatting 
  3. Apply Advanced Conditional Formatting 
4Visualizing Data with ChartsTopics 13–15
  1. Create Charts
  2. Modify and Format Charts
  3. Used Advanced Chart Features
5Pivot Tables and Pivot ChartsTopics 16–19
  1. Create a PivotTable
  2. Analyze PivotTable Data
  3. Present Data with PivotCharts
  4. Filter Data Using Timelines and Slicers

About our Trainers

PTR training instructor headshot
PTR training instructor headshot
PTR training instructor headshot

Our Mission

Our facilitators are committed to delivering the latest industry trends, job-specific best practices, and the essential soft and hard skills needed in today’s workforce. PTR offers small and large organizations the choice between onsite and virtual training. Collaborate with our specialists to address challenges, bridge skill gaps, and tailor the learning experience to meet your company’s goals.

Frequently Asked Questions

What is the Microsoft Excel Intermediate course about?

This course builds on basic Excel knowledge and teaches participants to use advanced formulas, manage lists, analyze data, create charts, and summarize information using PivotTables and PivotCharts.

What is the prerequisite for this course?

Participants should complete Microsoft Excel Basic or have equivalent knowledge of basic Excel operations, formulas, and workbook management.

What Excel formulas and functions will I learn?

You will learn to work with ranges, specialized functions, logical functions, date and time functions, and text functions to perform calculations and extract useful information from data.

Will I learn how to sort and filter data in Excel?

Yes. The course covers sorting and filtering data, using database functions to query information, and applying outlines and subtotals to organize and summarize lists.

Does the course cover conditional formatting?

Yes. You will learn to apply intermediate and advanced conditional formatting to highlight important values, identify patterns, and make spreadsheet data easier to interpret.

Can I learn how to create and format charts in Excel?

Yes. The course teaches you to create, modify, and format charts, as well as use advanced chart features to communicate data insights clearly.

What are PivotTables and PivotCharts used for?

PivotTables help summarize and analyze large datasets, while PivotCharts present summarized information visually. You will learn to create them, analyze data, and use timelines and slicers to filter results.

Discover More Ways to Build Your Skills

Microsoft Office Excel Intermediate: Leverage Advanced Formulas

Request a Training Quote

Share your team’s goals, and we’ll recommend the right skills training.