Computer and Business Skills training

Sign Up
Home / Excel / Level 3

Microsoft Excel Level 3 Training Course

Course Description

This hands-on class is suitable for Excel 2010, 2013 and 2016 users.

On this class you will learn advanced functions including LOOKUPS, Date and Time Functions, Text Functions, Statistical Functions, and Financial Functions. You will learn how to import and export data using the Power Pivot Data model and analysis data using What-If Analysis, Scenarios and Goal Seeker. Finally you will learn to automate tasks using Macros and capture user input using Forms.


Live face-to-face instructor. No minimum class size - all classes guaranteed to run!


You should have completed our intermediate class or have the equivalent experience prior to attending this course.

View our full range of Excel training courses, or see below for the detailed outline for Excel Level 3.

1 Day | $350.00


Register button

Detailed course outline

  • Logical and Lookup Functions
    • The IF Function
    • Conditional Calculations
    • Using SUMIF
    • VLOOKUPS and HLOOKUPS
    • Range LOOKUPS
  • Advanced Formulas
    • Auditing and Error Trapping
    • Formula Options
    • Array Functions
    • Using TRANSPOSE
  • Special Functions
    • Date and Time Functions
      • TODAY
      • NOW
      • DATE
    • Date Calculations
    • Text Functions
      • Using CONCATENATE and TRIM
      • Using UPPER, LOWER and PROPER
      • Extracting Text
    • Statistical Functions
      • Using MIN and MAX
      • Using COUNT, COUNTA and COUNTBLANK
    • Financial Functions
      • Using FV
      • Using PMT
  • Importing and Exporting
    • The Power Pivot Data Model
    • Importing Data
    • Using Power Pivot
    • Exporting Data
  • Data Analysis
    • What-if Analysis
    • Scenarios
    • Using Goal Seek
    • The Analysis Toolpak
  • Macros and Forms
    • Recording Macros
    • Running Macros
    • Running Macros when Workbook is Open or Closed
    • Using Forms to Record Input

Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.

Timetable

Chicago

230 W Monroe St
#610
Chicago
IL 60606View Map

Guaranteed to Run Limited Seats Left

Class times: 9.00am to 4.30pm

Servicing Arlington Heights, Aurora, Bollingbrook, Chicago Loop,
Deerfield, Des Plaines, Evanston, Highland Park, Joliet, Naperville,
Schaumburg, Skokie, South Chicago and surrounding areas.

Other Cities

Request onsite training quote

Los Angeles

915 Wilshire Blvd
#1800
Los Angeles
CA 90017View Map

Guaranteed to Run Limited Seats Left

Class times: 9.00am to 4.30pm

Servicing Anaheim, Burbank, Covina, Downtown, Fullerton,
Irvine, Long Beach, Northridge, Pasadena, San Bernardino,
Santa Monica, Van Nuys, Ventura and surrounding areas.

Related courses

Why train with us?Need Group training quotation?Fresh Starbucks brewed every dayBook two levels of Excel training and save $100FREE Class Repeat with each courseBook 3 Level of Excel Training and save $150