All Excel classes include
Free retakes
Detailed curriculum
Live instructor
Flexible rescheduling
Certificate of Completion
Excel Class - Intermediate
Excel Class - Intermediate
This intermediate Excel course moves into more advanced functionality to locate, calculate, summarize and format data. Learn to summarize and organize data in Excel with Pivot Tables, write advanced functions using VLOOKUP, and create advanced charts. Discover statistical formulas like COUNTIFS and SUMIFS to better understand data, and learn Excel techniques to work more efficiently. Attend this intermediate Excel training and learn to use tools and techniques that will make you efficient in summarizing, calculating and validating data.
What you learn in this intermediate Excel course
- Data validation: Learn to restrict what can be entered into a cell or create drop-down menus to select pre-populated data.
- Sort & filter: Find out how to sort data either alphabetically or by the size of the number
- VLOOKUP: Learn how to retrieve the value from a table depending upon another value in a column, such as a city name associtaed with a ZIP code.
- IF statements: Discover how to create formulas that produce different results depending upon conditions.
- SUMIFs: Create conditional sum values that total values from cells that meet a specific condition you define.
- COUNTIFs: Count the number of items that meet a certain criteria.
- Split and Join Text: Split text to multiple columns with Text to Columns.
- Navigation shortcuts: Learn to more quickly navigate around worksheets.
- Using templates: Keep branding colors, styles, and fonts consistent.
Options for attending this intermediate Excel course
- Live online from your office or home as a regularly scheduled class.
- Live in-person regularly scheduled Excel classes at AGI’s Boston or Philadelphia classroom with a live instructor in the same room.
- Private class, online or in-person, at your location or AGI's classrooms: call 781 376-6044 or contact us to schedule.
This course is available individually or as part of these certificate programs:
Excel Class - Intermediate - Course Dates
All classes are led by a live instructor. Class times listed are Eastern time.
Microsoft Excel Intermediate 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, and other styles consistent by 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
Intermediate Excel Course prerequisites
This course requires knowledge of Excel equivalent to the topics in our Introductory Excel Course, including knowledge of basic formulas and functions, charts, formatting, and absolute cell references. If attending online have Excel installed on your computer. If attending in-person at one of our classrooms, a computer with Excel is provided for use during the course.
Course materials
You will receive a comprehensive Excel course manual for this class.