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
- MONTH Function
- DATE Function
- DAYS Function
- SUM Function
- AVERAGE Function
- MIN Function
- MAX Function
- MEDIAN Function
- COUNT Function
- COUNTA Function
- COUNTBLANK Function
- CONCAT 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 |
April 23, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
May 7, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Class is Full. Waiting List |
May 16, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
May 21, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
May 30, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
June 4, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
June 13, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
June 18, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
June 27, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
July 2, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
July 11, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
July 16, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
July 25, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
July 30, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
August 8, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
August 13, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
August 22, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
August 27, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
September 5, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
September 10, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
September 19, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
September 24, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
October 3, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
October 8, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
October 17, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
October 22, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
October 31, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
November 5, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
November 14, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
November 19, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
November 28, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Class is Full. Waiting List |
December 3, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
December 12, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
December 17, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
Live Online Classes Schedule
Date | Location | Price | Registration |
April 23, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Class is Full. Waiting List |
May 7, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Class is Full. Waiting List |
May 16, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Class is Full. Waiting List |
May 21, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
May 30, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
June 4, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
June 13, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
June 18, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
June 27, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
July 2, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
July 11, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
July 16, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
July 25, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
July 30, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
August 8, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
August 13, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
August 22, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
August 27, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
September 5, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
September 10, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
September 19, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
September 24, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
October 3, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
October 8, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
October 17, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
October 22, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
October 31, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
November 5, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
November 14, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
November 19, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
November 28, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Class is Full. Waiting List |
December 3, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
December 12, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
December 17, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
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
817-841-9560
Office Address
2601 Scott Avenue
Suite 107
Fort Worth, TX 76103
Mailing Address
Aledo, TX 76008