Microsoft Excel Intermediate Training
In this Microsoft Excel Intermediate Training class, students will learn how to build on their Excel skills by using named ranges in Excel, inserting Excel Functions such as IF and SUMIF, using comparison operators such as AND, OR and NOT and using Date Functions such as DATE and NOW. In addition, students will see how to manipulate text using Text Functions like UPPER, LOWER and CONCATENATE. Students will also learn about using Lists in Excel and sorting and filtering data in lists. Students will be exposed to Database functions such as DSUM and how to work with and format tables in Excel. Modifying and formatting Charts in Excel will also be explored in this course. And, finally, students will learn how to analyze date using PivotTables, PivotCharts, Timelines and Slicers.
Duration
1 Day
Versions
Live, Instructor-Led Training
Up to One Year Access to Recorded Course
Hands-On Exercises
Certificate of Completion
Six Months of Post-Class Instructor Support
This course is designed for students who already are already familiar with completing basic tasks in Excel expand their knowledge using functions, PivotTables, Slicers and Timelines.
Upon successful completion of this course, students will be able to:
- Use Logical, Date and Text functions.
- Use Lists to Sort, Filter and Query Data.
- Analyze data using Tables.
- Visualize data with charts.
- Use PivotTables and PivotCharts.
- Filter data using Timelines and Slicers.
- Using Excel Functions
- Understanding Ranges
- Using Logical Functions: IF(), SUMIF(), COUNTIF(), AVERAGEIF(), AND, OR, NOT
- Using Date & Time Functions: TODAY(), NOW(), DATE(), WEEKDAY()
- Using Text Functions: LEFT(), RIGHT(), MID(), FIND()
- Using Lists to Analyze Data
- Sorting Data
- Filtering Data
- Querying Data with Database Functions
- Outlining and Subtotaling Data
- Using Tables to Analyze Data
- How to Create and Modify Tables
- Using Intermediate Conditional Formatting
- Using Advanced Conditional Formatting
- Using Charts to Visualize Data
- Creating Charts in Excel
- Modify and Format Charts in Excel
- Using Advanced Chart Features
- Using PivotTables and PivotCharts
- Creating a PivotTable in Excel
- Analyzing PivotTable Data
- Visualize Data with PivotCharts
- Filtering Data Using Timelines and Slicers
Students should have familiarity with the topics covered in (or have already attended) the Microsoft Excel Introduction Training course.
This course does not align to a specific exam or certification.
Thu, Jul 2, 2026
Thu, Jul 30, 2026
Wed, Aug 12, 2026
Fri, Aug 14, 2026
Thu, Aug 27, 2026
Thu, Sep 24, 2026
Training a team?
Get custom pricing for groups of 5 or more.