Excel_256x256.png

Choose your timezone

Register Below or Call (888) 804-1132
and Talk to a Training Specialist Today

$50 off each course when you book more than one course or more than one person per course. Discount will be applied at checkout.
Class sizes are kept small for a better learning experience. Limited to 15 people per class.
  • October 11
    1 day, 8:00 AM PDT - 3:30 PM PDT
    Presented by Michel Wakim
    Online via Zoom
    $350.00 per person
    Register6 places remaining
    Limited places
  • November 3
    1 day, 8:00 AM PDT - 3:30 PM PDT
    Presented by Carol Spear
    Online via Zoom
    $350.00 per person
None of these dates work for you? Suggest another date & time

Want to run this as a private class for your team? Enquire about running this event as a private class

Description

This course builds on the concepts and skills of our Level 1 and Level 2 courses to provide advanced tools for solving real-world problems in Microsoft Excel: lookup and decision-making functions, auditing and error-handling, array functions, date and text functions, importing and exporting, and macros.

Advanced Functions

  • Creating and Using Named Ranges
  • Creating Named Constants
  • Linking Data Between Worksheets
  • Creating and Using Functions

Logical and Reference Functions

  • Using Nested Functions
  • IF, AND, OR Functions
  • SUMIF, COUNTIF
  • VLOOKUP, HLOOKUP, and XLOOKUP
  • MATCH and INDEX

Date, Time and Text Functions

  • TODAY, NOW, DATE
  • Using Dates in Calculations
  • CONCAT, TRIM, TEXTJOIN, LEFT, RIGHT, MID,
  • UPPER, LOWER, PROPER

Advanced Formatting

  • Using Styles, Themes, and Effects
  • Working with Styles
  • Applying a Style
  • Modifying Existing Styles
  • Using Format Painter
  • Creating Custom Number Formats
  • Applying an AutoFormat (Table Format)

External Data and Protecting Data

  • Importing and Exporting Files
  • Protecting Data
  • Using Worksheet Protection
  • Password Protecting a Workbook

Automate Tasks with Macros

  • Recording and Running Macros
  • Introduction to Editing Macros
 

Prerequisites

The course assumes you know how to use a computer, that you're familiar with Microsoft Windows, and that you've taken the Level 1 and Level 2 courses or have equivalent introductory experience with Excel. The exercises are more detailed and complex than those in the previous levels. 

Who should attend?

Those who want to use Excel to perform real-world tasks such as getting information from large amounts of data from sources inside and outside of Excel, creating output that varies according to conditions, manipulating dates and text, and automating repetitive tasks.