Classroom Instructor Led Microsoft Excel Training 512-522-1265‬

Excel Intermediate Part 1

Overview

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.

Price

$425 per Student

CPE Credits

8 CPE Credits

Prerequisites

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.

Duration

1 Day

Class Outline
Tables
  • Tables Overview
  • Table Structured Cell References
  • Table Styles
  • Table Options
  • Table Slicers
  • Converting Tables to Ranges
  • Removing Duplicate Rows
Range Names
  • 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 Overview
  • Functions vs Formulas
  • Why use Functions?
Date and Time Functions
  • NOW Function
  • TODAY Function
  • YEAR Function
  • EOMONTH Function
  • DATE Function
  • NETWORKDAYS Function
Statistical Functions
  • SUM Function
  • AVERAGE Function
  • MIN Function
  • MAX Function
  • MEDIAN Function
  • COUNT Function
  • COUNTA Function
  • COUNTBLANK Function
Text Functions
  • 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
Logical Functions
  • 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
Lookup Functions
  • XLOOKUP Function
  • VLOOKUP Function
  • INDEX Function
  • MATCH Function
Flash Fill
  • 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.

    Contact Us

    Phone

    512-522-1265

    Office Address

    9600 Great Hills Trail
    Suite 150W
    Austin, TX 78759

    Mailing Address

    PO Box 712
    Aledo, TX 76008

    Communication Preference

    This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.