Microsoft Office Excel Intermediate: Leverage Advanced Formulas
Intended Organizations
Intended Organizations
Organizational type shows which workplace or sector each group training program best aligns with. Most courses adapt across settings to support unique goals and outcomes.
Corporate & Business GroupsProfessional development for small groups, large business teams, and enterprises across industries focused on building valuable skills.
Federal GovernmentCreated for federal agencies and employees, with practical training that helps build job-relevant skills for the federal workplace.Course pricing is available for federal agencies through the GSA Schedule.
State & Local GovernmentTraining for state, county, municipal, and other public-sector teams, focused on building skills that support government and public service work.
Intended Organizations
Organizational type shows which workplace or sector each group training program best aligns with. Most courses adapt across settings to support unique goals and outcomes.
Federal GovernmentCreated for federal agencies and employees, with practical training that helps build job-relevant skills for the federal workplace.Course pricing is available for federal agencies through the GSA Schedule.
State & Local GovernmentTraining for state, county, municipal, and other public-sector teams, focused on building skills that support government and public service work.
Corporate & Business GroupsProfessional development for small groups, large business teams, and enterprises across industries focused on building valuable skills.
Intended Organizations
Organizational type shows which workplace or sector each group training program best aligns with. Most courses adapt across settings to support unique goals and outcomes.
State & Local GovernmentTraining for state, county, municipal, and other public-sector teams, focused on building skills that support government and public service work.
Federal GovernmentCreated for federal agencies and employees, with practical training that helps build job-relevant skills for the federal workplace.Course pricing is available for federal agencies through the GSA Schedule.
Corporate & Business GroupsProfessional development for small groups, large business teams, and enterprises across industries focused on building valuable skills.
Skill LevelIntermediate
Virtual | Live Trainer4 hours/day, 1 Day
In-Person | Onsite6 hours/day, 1 Day
Skill Level & Progression
Skill level reflects the recommended course experience and helps match training to your team's needs. Most training courses support all learning levels.
General WorkforceDevelops team-ready capabilities across business roles and experience levels while strengthening skills and organizational results.
FundamentalsBuilds introductory proficiency in essential terminology, core concepts, and workplace best practices for real-world application.
Intermediate(this course)Strengthens existing knowledge through advanced functions, skill strategies, and deeper exploration of core concepts.
AdvancedDeepens expertise through complex subject matter, specialized skills, advanced analysis, and higher-level instruction.
Course Formats
Train on your terms. Choose virtual or onsite delivery, schedule sessions around your team’s availability, and align course content with your objectives and real-world challenges.
Virtual Training4 hours/day, 1 DayLive, interactive, instructor-led training delivered through a secure videoconferencing platform.
Onsite Training6 hours/day, 1 DayEngaging, instructor-led training delivered in person at the location of your choice.
Course Duration
Course duration varies by training format and time needed to effectively cover the material, with hours per day and total days listed.
Generates a branded PDF — downloads directly to your device
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.
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
Work with Ranges
Use Specialized Functions
Work with Logical Functions
Work with Date & Time Functions
Work with Text Functions
2Working with Excel ListsTopics 6–9
Sort Data
Filter Data
Query Data with Database Functions
Outline and Subtotal Data
3Analyzing DataTopics 10–12
Create and Modify Tables
Intermediate Conditional Formatting
Apply Advanced Conditional Formatting
4Visualizing Data with ChartsTopics 13–15
Create Charts
Modify and Format Charts
Used Advanced Chart Features
5Pivot Tables and Pivot ChartsTopics 16–19
Create a PivotTable
Analyze PivotTable Data
Present Data with PivotCharts
Filter Data Using Timelines and Slicers
About our Trainers
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.
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.
Microsoft Office Excel Intermediate: Leverage Advanced Formulas
Request a Training Quote
Share your team’s goals, and we’ll recommend the right skills training.
PTR Training uses 'cookies' to improve your website experience. View our Privacy Policy for details. By continuing, you agree to accept and adhere to our Terms of Use.