Excel Intermediate Part 1
Our 3 Excel Intermediate Classes are our most popular classes. This class is typically ideal for someone that has taken the Excel Introduction class or someone that has used Excel for a long-time without any formal training. Students who have used Excel for years are quite often surprised after taking this class on how much Excel they did not actually know and/or how there are much more efficient ways to accomplish their business tasks in Excel. After taking this class, we highly recommend you take the second part of this class which is Excel Intermediate Part 2.
$425 per Student
8 CPE Credits
Participants must have basic knowledge of entering data, formatting and simple formulas. Participants should be familiar with the topics covered in the Excel Introduction class.
1 Day
- Tables Overview
- Table Structured Cell References
- Table Styles
- Table Options
- Table Slicers
- Converting Tables to Ranges
- Removing Duplicate Rows
- Range Names Overview
- Navigating Range Names
- Creating Range Names
- Creating Range Names in Bulk
- Assigning Range Names
- Using Range Names in Formulas
- Managing Range Names
- Functions Overview
- Functions vs Formulas
- Why use Functions?
- NOW Function
- TODAY Function
- YEAR Function
- EOMONTH Function
- DATE Function
- NETWORKDAYS Function
- SUM Function
- AVERAGE Function
- MIN Function
- MAX Function
- MEDIAN Function
- COUNT Function
- COUNTA Function
- COUNTBLANK Function
- PROPER Function
- UPPER Function
- LOWER Function
- LEFT Function
- RIGHT Function
- MID Function
- TRIM Function
- LEN Function
- FIND Function
- SUBSTITUTE Function
- TEXTBEFORE Function
- TEXTAFTER Function
- TEXTJOIN Function
- TEXTSPLIT Function
- IF Function
- IFS Function
- Nested IFs Function
- AND Function
- OR Function
- SWITCH Function
- COUNTIF Function
- COUNTIFS Function
- SUMIF Function
- SUMIFS Function
- AVERAGEIF Function
- AVERAGEIFS Function
- XLOOKUP Function
- VLOOKUP Function
- INDEX Function
- MATCH Function
- Using Flash Fill
- Troubleshooting Flash Fill
- Limitations of Flash Fill
Excel Intermediate Part 1 Schedule
In-Person Classes Schedule
Date | Location | Price | Registration |
January 15, 2025 9:15 AM to 5:00 PM |
Austin, TX | $425.00 | Class is Full. Waiting List |
February 12, 2025 9:15 AM to 5:00 PM |
Austin, TX | $425.00 | Class is Full. Waiting List |
March 12, 2025 9:15 AM to 5:00 PM |
Austin, TX | $425.00 | Register |
April 9, 2025 9:15 AM to 5:00 PM |
Austin, TX | $425.00 | Register |
May 7, 2025 9:15 AM to 5:00 PM |
Austin, TX | $425.00 | Register |
June 4, 2025 9:15 AM to 5:00 PM |
Austin, TX | $425.00 | Register |
July 2, 2025 9:15 AM to 5:00 PM |
Austin, TX | $425.00 | Register |
July 30, 2025 9:15 AM to 5:00 PM |
Austin, TX | $425.00 | Register |
August 27, 2025 9:15 AM to 5:00 PM |
Austin, TX | $425.00 | Register |
September 24, 2025 9:15 AM to 5:00 PM |
Austin, TX | $425.00 | Register |
October 22, 2025 9:15 AM to 5:00 PM |
Austin, TX | $425.00 | Register |
November 19, 2025 9:15 AM to 5:00 PM |
Austin, TX | $425.00 | Register |
December 17, 2025 9:15 AM to 5:00 PM |
Austin, TX | $425.00 | Register |
Live Online Classes Schedule
Date | Location | Price | Registration |
January 7, 2025 9:00 AM to 5:00 PM |
Live Online | $425.00 | Class is Full. Waiting List |
January 22, 2025 9:00 AM to 5:00 PM |
Live Online | $425.00 | Class is Full. Waiting List |
February 4, 2025 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
February 19, 2025 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
March 4, 2025 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
March 19, 2025 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
April 1, 2025 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
April 16, 2025 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
April 29, 2025 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
May 14, 2025 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
May 27, 2025 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
June 11, 2025 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
June 24, 2025 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
July 9, 2025 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
July 22, 2025 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
August 6, 2025 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
August 19, 2025 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
September 3, 2025 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
September 16, 2025 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
October 1, 2025 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
October 14, 2025 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
October 29, 2025 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
November 11, 2025 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
November 26, 2025 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
December 9, 2025 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
December 24, 2025 9:00 AM to 5:00 PM |
Live Online | $425.00 | Class is Full. Waiting List |
Don't see a Class Date that works for you?
Let us know when you would like to take the class and we will see if we can add a new class date to our schedule.
Public Classes
Contact Us
Phone
512-522-1265
Office Address
9600 Great Hills Trail
Suite 150W
Austin, TX 78759
Mailing Address
Aledo, TX 76008