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

Excel on Steroids: Advanced Excel Formulas- Work with Data like A Pro (IMEN50W)

Presented By : Dennis Taylor
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Webinar
60 minutes
  •  Thu, November 5, 2015
Event Description
See the sneak peek before you buy!
1.0 CPE

Expand Your Ability to Analyze Data in Excel with Some "Hidden" Functions and New & Powerful Tools

You may be comfortable using formulas and functions in Excel, but it's likely that you may have missed some of its powerful functions and capabilities. For instance, MATCH, INDEX, INDIRECT functions and the array formulas. Excel has a whopping 450+ functions giving you the power to handle a numerous statistical, mathematical and financial challenges, not to mention functions that extract valuable date information and let you manipulate text at the character level.

This webinar by expert speaker Dennis Taylor gives you an inside-look to some "hidden" function and new and powerful tools in Excel. You'll learn about array formulas and array functions (FREQUENCY, TREND, and GROWTH); quick formula copying methods, creative use of the Ctrl key to create formulas/function in multiple locations simultaneously; and a host of other mind-blowing tricks.

You'll learn using the following functions:

  • LEN
  • MOD
  • Extended uses of the IF and VLOOKUP functions

Session Highlights:

  • Learn how to update values without formulas, build formulas faster, and use formula-auditing tools.
  • Overcome the limitations of the VLOOKUP function - use the frequently combined MATCH and INDEX functions.
  • Learn to use the CONVERT function when you're working with alternate distances, weights and measures.
  • Know how to use the INDIRECT function when copying data from multiple locations.
  • Identify how to harness the power of the expanded COUNTIF family of functions - SUMIFS, AVERAGEIFS, and COUNTIFS for multi-field data analysis.
  • Learn to set up and use array formulas; learn specific array power functions - FREQUENCY, TREND, GROWTH, and TRANSPOSE.
  • Auditing and formulas productivity tips.
  • Array formulas and array functions (TREND, GROWTH, and FREQUENCY).
  • Specialized text functions - LEN, REPLACE, SUBSTITUTE.
  • Powerful uses of unusual functions like INDIRECT, OFFSET, and MOD.
  • Extended uses of the IF and VLOOKUP functions - in combination with array formula.

Who should attend?

Any Excel user who needs to go beyond the basics of using formulas or simply wants to become more comfortable and productive in using Excel formulas and functions

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: Excel on Steroids: Advanced Excel Formulas- Work with Data like A Pro
    Presenter(s): Dennis Taylor Protection Status