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.

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.

• 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