Microsoft Excel Level 3

This hands-on class is suitable for Excel 2013, 2016, 2019 and 365 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. 

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.