Excel® Advanced Formulas

Excel® Advanced Formulas






Product Description

This one-hour e-workshop provides advanced training for functions in Excel®. It also raises the skill level of self-taught Excel© users by filling gaps in their working knowledge.

-Get a firm understanding of formulas and functions
- Be able to select correct function or formula to analyze data
- Be able to correctly configure functions to calculate the correct answer

:00 to :05 – Introduction and optimizing learning
:05 to :10 – Scenario 1: SUBTOTAL Function
:10 to :20 – Scenario 2: TODAY, YEARFRAC, COUNTIFS, & SUMIF/SUMIFS Functions
:20 to :35 – Scenario 3: VLOOKUP Function & INDEX & MATCH Functions
:35 to :45 – Scenario 4: SUM & IF Functions
:45 to :55 – SUM & IF Functions
:55 to :00 – Q&A

Live webinar times are based on US Pacific Time (PST or PDT).
Webinar time conversions:
9am PST or PDT / 10am MST or MDT / 11am CST or CDT / 12pm EST or EDT
10am PST or PDT / 11am MST or MDT / 12pm CST or CDT / 1pm EST or EDT
11am PST or PDT / 12pm MST or MDT / 1pm CST or CDT / 2pm EST or EDT

For more information click on the link to view or download the flyer for Excel® Advanced Formulas.


  • Model: EW-023
  • 10 Units in Stock
  • Manufactured by: eTechnology Consultants


Be the first to write a review. Write a Review

This product was added to our catalog on Sunday 02 April, 2017.