See how live online training works in this brief video.

See how live online training works in this brief video.

All Excel classes include

free retakes of courses Free retake

Curriculum provided Detailed curriculum

Live instructor Live instructor

flexible rescheduling Flexible rescheduling

flexible rescheduling Certificate of Completion

small class Small class sizes

course recording Course recording

Microsoft Excel Course Online March 19, 2025 Intermediate - Evenings

Excel class - Intermediate

-
6:00 pm to 9:00 pm
Online Training

$249.00

Register

This intermediate Excel class will deepen your knowledge with hands-on training. Learn to quickly find data with XLOOKUP and VLOOKUP as well as build Pivot Tables to summarize and analyze. Create advanced charts, and work with text using text functions. Learn to use statistical formulas including COUNTIFS and SUMIFS for understanding data. Expand your skills and improve your efficiency with this intermediate Excel course.

Download Course Description (PDF)

Review of foundational Excel tasks

Excel workbook navigational tips and tricks
Review of formulas
Cell ranges
Formatting review
Review of cell styles
Review conditional formatting
Review of themes
Chart review

Working with lists

You can create your custom lists and use them to sort or fill. Creating a list
Database terms
Sorting a list by one column or multiple columns
Searching records
Filtering records in a list
Extracting records
Grouping records

Using data validation for entering data

Apply data validation to restrict the data type or value others can enter into the cell.
Working with text
Splitting Text 
Joining Text 
Removing Dups 

LOOKUP, Data Tables, Data Filtering and Sorting 

Named Ranges 
VLOOKUP, HLOOKUP, and XLOOKUP

Using custom Excel templates

Keep branding colors, type styles, and other styles consistent using a template.
Saving a workbook as a template
Opening a custom template
Accessing templates
Using a template
Saving a workbook as a template
Deleting templates

Protecting workbooks

Workbook protection levels
Using worksheet and workbook protection
Unlocking cells in a protected worksheet
Hiding and Protecting formulas

If Functions 

Subtotals 
Paste special 
Data validation 

See all Excel classes, See all Microsoft Office classes
Register

Why Excel classes at AGI are the best option for you

  • Hands-on learning: Learn Excel quickly with our proven teaching methods.
  • Exceptional curriculum: AGI has delivered Excel training to thousands over 25 years.
  • Expert instructors: Our instructors are Excel experts and skilled educators.
  • Small class sizes: Receive personalized attention with 10 or fewer participants per class.
  • Repeat for Free: If you need a refresher or miss a class day, retake the Excel class at no cost.