All Excel classes include
Free retakes
Detailed curriculum
Live instructor
Flexible rescheduling
Certificate of Completion
Microsoft Excel Course Online February 4, 2025 Intermediate
Excel class - Intermediate
$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.
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
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.