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-800-223-8720
Pre Recorded Webinar
  •  N/A
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 Training ExpertDennis 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:
    Subject: You might be interested in this event from AudioSolutionz
    Event Title: Microsoft Excel: Advanced Excel Formulas & Functions (Power Packed 3 DVDs)
    Presenter(s): Dennis Taylor Protection Status