My Shopping Cart
There are no items in your shopping cart.

Microsoft Excel: Advanced Excel Formulas & Functions (Power Packed 3 DVDs) (PKGIMEA20D)

Presented by: Dennis Taylor
(*) Single User Price. For multiple users please call 1-844-384-4744
Pre Recorded Webinar
Event Description

Get insider information on advanced excel formulas and functions and turbo-charge your excel productivity with powerful professional tips offered by our excel experts. Expand your proficiency and master functions like VLOOKUP, INDEX, MATCH and a gamut of other advanced formulas and functions.


  1. Advanced Excel Formulas and Functions at Your Fingertips
  2. Mastering Excel Formulas and Functions
  3. Macro Magic: Unleash the Power of Excel

This power pack will arm you with effective techniques to:

  • Conditionally react to dynamically changing data with the IF, AND, OR, and CHOOSE functions
  • Use Text functions to quickly clean up and restructure downloaded data
  • Use a function to look up data from a list in another workbook
  • Use the special-purpose array functions and formulas
  • Creating quick summaries with the COUNTIF/SUMIF family of functions and powerful and specialized Array formulas and functions
  • Get up-to-date information on rounding and statistical functions
  • Extend the power of macros to perform tasks you cannot achieve with standard Excel features.
About Our Speaker(s)

Dennis Taylor | Microsoft Excel SpeakerDennis Taylor
Dennis Taylor has taught thousands of Excel seminars and classes since the early 90's, is the author/presenter of over 250 Excel webinars, and authored the book Teach Yourself Microsoft Excel 2000. He has taught hundreds of public Excel seminars in the US and Canada since 2006 and has recorded over 100 Excel courses bo... More info

Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
    Event Title: Microsoft Excel: Advanced Excel Formulas & Functions (Power Packed 3 DVDs)
    Presenter(s): Dennis Taylor

Our Accreditation Partners Protection Status

Dear Valued Customers,

We regret to announce that ProEdTech LLC and all its affiliate brands will cease operations on April 1, 2019.

We are no longer able to fulfill online orders. We will fullfill all DVD and book orders already placed.

Customers of canceled webinars and subscription products may request a refund at (800) 223-8720 or You must do so by April 1, 2019.

Thank you for your business and loyalty over the years. We sincerely apologize for any inconvenience caused.

Best regards,
The ProEdTech Team