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

Mastering Excel 2013 Formulas and Functions (IME650J)

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

The Nuts and Bolts of Mastering Excel 2013 Formulas and Functions

Working with formulas and functions in Excel is absolutely critical to building powerful financial and analytical worksheets and is probably the most important skill set for many Excel users. Excel, with its 450 built-in functions, is a potent power-tool set which simplifies certain types of formulas, giving you a large chunk of computational possibilities. Extended analytical capabilities can be achieved by various Excel functions, and they are known to open doors to more efficient Excel use, but with so many functions, it's no easy task to know which functions are available and which ones you might have overlooked.

This session by expert speaker Dennis Taylor gives you perspective on what functions are available and explains (with extensive examples) how to use many of them, including:

  • The IF function (with AND and OR)
  • The powerful VLOOKUP function
  • Selected Statistical, Date, Financial, and Mathematical functions
  • The Text functions which are frequently overlooked but are critical if you need to clean up problems with downloaded data.
  • The powerful COUNTIF/SUMIF family of functions and newer functions that were introduced in Excel 2010 and 2013.

The webinar will also cover specific functions and formulas, and provide you with the perspective you require to understand the depth and scope of these Excel features. Dennis will provide all these examples within the context of Excel worksheets, coupling them both with real-life examples that he has encountered in his vast consulting experience. Going further, you will receive a lot of productivity tips, accelerator tools and shortcuts. Plus, you will receive the Excel workbook file that contains various worksheets and which will serve as a stage to demonstrate various formulas and functions.

Session Highlights:

  • Shortcuts to formula-building and using formula-auditing tools
  • Using the powerful IF functions and also the related OR & AND functions required for programming-like capability.
  • Finding out information in tables and conjoin different lists using VLOOKUP function to cater to specific lookup needs.
  • Using MATCH and INDEX functions
  • Using selected text functions for extracting and manipulating numeric and character data for various analytical and sorting needs.
  • Building 3-D formulas that will help in tabulating data totals from various different worksheets
  • Harnessing the power gained from various functions in nested fashion
  • 'How' and 'when' to use COUNTIF family of function's extended capabilities and also the newer functions such as FORMULATEXT, ARABIC, AGGREGATE and ISFORMULA.

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: Mastering Excel 2013 Formulas and Functions
    Presenter(s): Dennis Taylor Protection Status