BLOG
CATALOG
Menu
An individual analyzing data from an ipad while working on the laptop
a stack of orange and white books with text overlay of different training topics related to the professional workforce.
Browse hundreds of training topics to elevate team performance.
a laptop and phone with course training text on the screen.

Learn about PTR’s interactive course workbook for different learning styles.

Professional African-American woman training instructor smiling with overlay text.

PTR instructors are experts at delivering engaging, professional training.

Microsoft Office Excel Intermediate Training Course

Formats ⟩  Live Virtual: 4 hrs./1 Day  |  In-Person: 6 hrs./1 Day

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.

Learning Objectives »

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

Course Prerequisite: Microsoft Excel Basic

Recommended Follow-Up: Microsoft Excel Advanced

Course Agenda

Working with Excel Functions

  1. Work with Ranges 
  2. Use Specialized Functions
  3. Work with Logical Functions 
  4. Work with Date & Time Functions 
  5. Work with Text Functions 

Working with Excel Lists

  1. Sort Data 
  2. Filter Data 
  3. Query Data with Database Functions 
  4. Outline and Subtotal Data

Analyzing Data

  1. Create and Modify Tables 
  2. Intermediate Conditional Formatting 
  3. Apply Advanced Conditional Formatting 

Visualizing Data with Charts

  1. Create Charts
  2. Modify and Format Charts
  3. Used Advanced Chart Features

Pivot Tables and Pivot Charts

  1. Create a PivotTable
  2. Analyze PivotTable Data
  3. Present Data with PivotCharts
  4. Filter Data Using Timelines and Slicers
An individual analyzing data from an ipad while working on the laptop

Microsoft Office Excel Intermediate Training Course

Formats ⟩  Live Virtual: 4 hrs./1 Day  |  In-Person: 6 hrs./1 Day

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.

Learning Objectives »

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

Course Prerequisite: Microsoft Excel Basic

Recommended Follow-Up: Microsoft Excel Advanced

Course Agenda

Working with Excel Functions

  1. Work with Ranges 
  2. Use Specialized Functions
  3. Work with Logical Functions 
  4. Work with Date & Time Functions 
  5. Work with Text Functions 

Working with Excel Lists

  1. Sort Data 
  2. Filter Data 
  3. Query Data with Database Functions 
  4. Outline and Subtotal Data

Analyzing Data

  1. Create and Modify Tables 
  2. Intermediate Conditional Formatting 
  3. Apply Advanced Conditional Formatting 

Visualizing Data with Charts

  1. Create Charts
  2. Modify and Format Charts
  3. Used Advanced Chart Features

Pivot Tables and Pivot Charts

  1. Create a PivotTable
  2. Analyze PivotTable Data
  3. Present Data with PivotCharts
  4. Filter Data Using Timelines and Slicers
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.