Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Advanced Functions of Excel Formulas

These two webinars will cover how to build and troubleshoot formulas and master advanced Excel functions. Sign up for just one or both. Whether you are a beginner or an experienced user looking for some new or extra tips, you don’t want to miss either session!

Part 1 - January 25

This 1-hour session to be held on January 25 will cover the following functions:

  • Understand Mathematical Operators
  • Use AutoFunctions
  • Use Relative and Absolute References
  • Explore the Function Ribbon
  • Use the Insert Function Wizard & Dialog Box
  • Use Basic Text, Financial, Date, & Logical Functions
  • Name and Use Ranges of Cells in Formulas
  • Trace and Remove Trace Arrows
  • Use a Watch Window
  • Bonus! Three new v2016 functions that make it worth the upgrade!

Select your preferred time below to register:

9:00 a.m. EST 2:00 p.m. EST

 

 

 

 

Part 2 - February 7

This second session to be held on February 7 will cover the following functions:

  • Array Formulas
  • Subtotal Formulas
  • More date and time functions
  • Concatenate vs. Flash Fill
  • Index and Match vs. VLookup
  • Variations of the Round Function
  • Using Table References in Formulas
  • Bonus! Three more new v2016 functions!

Select your preferred time below to register: 

 

9:00 a.m. EST   2:00 p.m. EST