
Intermediate Microsoft Excel Training
In this Intermediate Microsoft Excel class, you will use powerful tools and features to manage and analyze your data. Packed with tips and tricks, you will quickly gain Excel power-user skills to help you work effectively. The class starts with popular formulas and functions like IF
, SWITCH
, PMT
, and CONCAT
. Then, you will learn to manipulate data in lists by sorting, filtering, adding subtotals, and more. You will learn to create engaging and insightful reports by visualizing your data using charts and sparklines. The class wraps up with important lessons on tables and advanced formatting, including conditional formatting, styles, and custom templates.
Excel Version: This course primarily targets Excel 365 and Excel 2021; however, we draw attention to features that are not supported in earlier versions of Excel, and point out alternative options, when available.
- Use Excel database functions and logic functions to work with information in large datasets.
- Leverage Excel's statistical functions to analyze data.
- Visualize your data using charts to show trends, create comparisons, and demonstrate other meaningful insights.
- Convert, sort, filter, and manage lists to keep your data organized.
- Insert and modify illustrations, logos, or shapes to create professional reports.
- Manage and analyze data using tables.
- Emphasize interesting and unusual data with conditional formatting
- Save time by using styles to apply formatting instantly.
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Private classes are delivered for groups at your offices or a location of your choice.
Learn at your own pace with 24/7 access to an On-Demand course.
Webucator is a Microsoft Certified Partner for Learning Solutions (CPLS). Our curriculum has been tested and approved by ProCert Labs, the official tester of Microsoft courseware, and has been found to meet the highest industry standards of instructional quality.

- Common Functions
- Using Named Ranges in Formulas
- Using Named Ranges in Formulas (exercise)
- Using Formulas That Span Multiple Worksheets
- Entering a Formula Using Data in Multiple Worksheets (exercise)
- Functions:
IF
andIFS
- Using the
IF
Function (exercise) - Functions:
AND
andOR
- Functions:
NOT
- Functions:
SWITCH
- Functions:
COUNTIF
,AVERAGEIF
, andSUMIF
- Functions:
PMT
andNPER
- Using the
PMT
Function (exercise) - Functions:
TEXTJOIN
andCONCAT
- Using the
TEXTJOIN
Function (exercise) - Text Functions
- Creating Ordinal Numbers (exercise)
- Date and Time Functions
- Using Date Functions (exercise)
- Working with Lists
- What is a List of Data?
- Removing Duplicates from a List
- Removing Duplicates from a List (exercise)
- Sorting Data in a List
- Sorting Data in a List (exercise)
- Filtering Data in a List
- Filtering Data in a List (exercise)
- Adding Subtotals to a List
- Adding Subtotals to a List (exercise)
- Visualizing Your Data
- Chart Basics
- Tools for Editing Charts
- Using the Chart Design Tool Tab (exercise)
- The Format Tool Tab
- Using the Three Chart Buttons
- The Format Task Pane
- Useful Charts
- Line and Area Charts
- Hierarchy Charts
- Statistic Charts
- Other Charts
- Combo Charts
- Using Recommended Charts
- Sparklines
- Inserting and Customizing Sparklines (exercise)
- Add and Format Objects
- Working with Shapes
- Working with Icons
- Working with SmartArt
- Using the Quick Analysis Tool
- Working with Tables
- Format Data as a Table
- Table Design Tool Tab
- Formatting Individual Cells
- Selecting Table Rows and Columns
- Creating and Modifying a Table in Excel (exercise)
- Structured References
- Convert a Table to a Range
- Advanced Formatting
- Cell Styles
- Working with Cell Styles (exercise)
- Conditional Formatting
- Conditional Formatting: Highlight Cells Rules
- Conditional Formatting: Top/Bottom Rules
- Conditional Formatting: Data Bars, Color Scales, and Icon Sets
- Conditional Formatting: Create a New Rule
- Removing Conditional Formatting
- Using Conditional Formatting (exercise)
Each student will receive a comprehensive set of materials, including course notes and all the class examples.
Experience in the following is required for this Microsoft Excel class:
- Basic Excel skills
Courses that can help you meet these prerequisites:
Register for a Live Class
Request a Private Class
- Private Class for your Team
- Online or On-location
- Customizable
- Expert Instructors
Self-Paced Course
- On Demand 24/7
- Readings
- Presentations
- Exercises
- Quizzes
- Full Year of Access
- Learn more