Classroom Instructor Led Microsoft Excel Training 817-841-9560 excel@dfwexcel.com

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

$395 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
  • MONTH Function
  • DATE Function
  • DAYS Function
Statistical Functions
  • SUM Function
  • AVERAGE Function
  • MIN Function
  • MAX Function
  • MEDIAN Function
  • COUNT Function
  • COUNTA Function
  • COUNTBLANK Function
Text Functions
  • CONCAT Function
  • PROPER Function
  • UPPER Function
  • LOWER Function
  • LEFT Function
  • RIGHT Function
  • MID Function
  • TRIM Function
  • LEN Function
  • FIND Function
  • SUBSTITUTE
Logical Functions
  • IF Function
  • IFS Function
  • Nested IFs Function
  • AND Function
  • OR Function
  • COUNTIF Function
  • COUNTIFS Function
  • SUMIF Function
  • SUMIFS Function
  • AVERAGEIF Function
  • AVERAGEIFS Function
Lookup Functions
  • XLOOKUP Function
  • VLOOKUP Function
  • HLOOKUP 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/Time Event Registration
    October 14, 2021
    9:00 am - 5:00 pm
    Excel Intermediate Part 1
    Bedford Training Facility S8, Bedford TX
    Class is Full. Add Your Name to the Waiting List
    November 11, 2021
    9:00 am - 5:00 pm
    Excel Intermediate Part 1
    Bedford Training Facility S8, Bedford TX
    Class is Full. Add Your Name to the Waiting List
    December 9, 2021
    9:00 am - 5:00 pm
    Excel Intermediate Part 1
    Bedford Training Facility S8, Bedford TX
    Class is Full. Add Your Name to the Waiting List

    Date Location Price Registration
    #_EVENTDATES#_12HSTARTTIME to #_12HENDTIME {has_location}#_LOCATIONTOWN, #_LOCATIONSTATE{/has_location}{no_location}Live Online{/no_location} #_EVENTPRICEMAXALL {bookings_open}Register{/bookings_open}{bookings_closed}Class is Full. Waiting List{/bookings_closed}
    Live Online Classes Schedule

    Date Location Price Registration
    #_EVENTDATES
    #_12HSTARTTIME to #_12HENDTIME
    {has_location}#_LOCATIONTOWN, #_LOCATIONSTATE{/has_location}{no_location}Live Online{/no_location} #_EVENTPRICEMAXALL {bookings_open}Register{/bookings_open}{bookings_closed}Class is Full. Waiting List{/bookings_closed}

    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

    Need to Pay via an Invoice?

    No problem. If you need to pay with an invoice, please use our contact form and let us know what class you would like to attend and we will email you an invoice you can pay via your Accounts Payable department.

    Contact Us

    Phone

    817-841-9560

    Email

    excel@dfwexcel.com

    Office Address

    5608 Malvey Ave,
    Suite 14620,
    Fort Worth, TX 76107

    Mailing Address

    PO Box 712
    Aledo, TX 76008

    Communication Preference