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


Advanced Excel Formulas and Functions (IME830M)

Presented By : Dennis Taylor
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Webinar
60 minutes
  •  Mon, August 26, 2013
Event Description
See the sneak peek before you buy!
 

Lighten Your Workload with Numerous Productivity Tips, Shortcuts, And Tools In Excel

Even if you are comfortable with building formulas and functions in Excel, you might have overlooked some powerful functions or special capabilities, like array formulas and the MATCH and INDEX functions. There’s no question that Excel’s 450+ functions give you tremendous capabilities to tackle a myriad of statistical, mathematical, and financial challenges, not to mention functions that extract valuable date information and let you manipulate text at the character level.

Join Dennis Taylor for this power-packed session and expose yourself to those “hidden” functions and some new and powerful tools, such as array formulas and array functions (FREQUENCY, TREND, and GROWTH). You’ll also learn quick formula copying methods, creative use of the Ctrl key to create formulas/function in multiple locations simultaneously, and a host of others. Dennis will also cover specific functions that will include: MATCH, INDEX, CONVERT, TRANSPOSE, FREQUENCY, DATEDIF, INDIRECT, LEN, MOD, TREND, GROWTH, REPLACE, SUBSTITUTE, and extended uses of the IF and VLOOKUP functions.

This session will presents in-depth coverage of specific formulas and functions, as well as the scope and depth of these critical Excel features. Get some great examples within the context of Excel worksheets based on real-life examples encountered over the past 20 years of Excel consulting and teaching experience of our expert.

Session Highlights

  • Know how to update values without formulas, build formulas faster, and how to use formula-auditing tools
  • Find out how to overcome the limitations of the VLOOKUP function with the frequently combined MATCH and INDEX functions.
  • Use the CONVERT function when dealing with alternate weight, measure and distance systems
  • 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
  • Know how to set up and use array formulas; learn specific array power functions – FREQUENCY, TREND, GROWTH, and TRANSPOSE.

Plus, get numerous productivity tips, shortcuts, and accelerator tools, along with the Excel workbook file, containing numerous worksheets that serve as the staging area for the demonstrated formulas and functions.

Who should attend?

Those Excel users who need to expand their ability to analyze data with Excel’s many functions. This webinar goes beyond using the IF and VLOOKUP functions into more complex array formulas and functions and obscure, but powerful functions such as OFFSET, INDIRECT, and MOD.

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: Advanced Excel Formulas and Functions
    Presenter(s): Dennis Taylor

 
 
DMCA.com Protection Status