See how live online training works in this brief video.

8 Cabot Rd
Woburn, MA
01801
US
(781) 376-6044

Graphic Design Courses, Web Design Classes, Adobe Training, Photoshop Classes, InDesign Courses, HTML Classes, UX Classes, Creative Cloud Classes, Illustrator Classes, and Apple Training in Boston.

Instructor and student working at a computer at the American Graphics Institute Boston location in Woburn

View Larger Map

All Excel classes include

Free retakes

Detailed curriculum

Live instructor

Flexible rescheduling

Certificate of Completion

Microsoft Excel Course in Boston on May 16, 2025 Intermediate

Excel class - Intermediate

Fri, May 16 2025 - Fri, May 16 2025

AGI Training Boston

$249.00

This intermediate Excel class will deepen your knowledge with hands-on training. Learn to quickly find data with 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)

Microsoft Excel intermediate - complete topics covered:

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

Data Tables and data filtering and sorting

Named Ranges
VLookup 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

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.