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

Mastering Excel Formulas and Functions (IME1302)

Presented By : Dennis Taylor
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Audio Conference
60 minutes
  •  Tue, January 29, 2013
Event Description

Nearly every Excel user either needs to create formulas, edit formulas, locate them, or understand their usage within worksheets. Excel's companion functions – they're like built-in formulas – provide a variety of creative and problem-solving tools that no Excel user can do without; with over 400 functions, however, how does one know where to look for these functions and figure out which ones are most important?

This presentation will, in short order, explain formula-building techniques (with indispensable shortcut tips), expose formula-auditing tools (how to locate worksheet formulas, display them all, locate dependent cells, and more) and present in-depth examples of some of the most important functions. Particular emphasis is placed on the IF function, which has dynamic programming-like capabilities, and the VLOOKUP function - a powerful table-lookup tool that simplifies pulling together data from separate locations. Anyone needing to restructure downloaded data needs to know about some of the powerful Text functions (widely overlooked by the casual Excel user), as well as selected Statistical and Mathematical functions that will be presented as well. Other functions covered include selected Date/Time functions, the COUNTIF/SUMIF family of functions, and specialized Array functions, all designed to give users expanded analytical tools.

Event Highlights:

  • Formula essentials – understanding rules of precedence; copying formulas; using the Auto-Sum tool; using row and column references in formulas; understanding relative/absolute/mixed cell references
  • Shortcuts, power tips, auditing tools – displaying all worksheet formulas in an instant; highlighting all worksheet formula cells; de-bugging formulas; locating dependent cells
  • The IF function – understanding the programming-like power of the function; using the frequently allied AND and OR function; creating nested IF functions
  • The VLOOKUP function – looking up table data in other worksheet and workbooks; matching up data exactly, or approximately, as the situation demands; using the related HLOOKUP function; using the INDEX and MATCH functions where VLOOKUP will not suffice
  • Important Date/Time functions – using WEEKDAY, NETWORKDAYS, and DATEDIF functions to analyze date-based worksheets
  • Cleaning up your data quickly with Text functions like PROPER, UPPER, LEFT, FIND, MID, and TRIM
  • Analyzing data with selected Math and Statistical functions like RANK, LARGE, STDEV, MEDIAN, ROUND and more
  • Creating quick summaries with the COUNTIF/SUMIF family of functions and powerful and specialized Array formulas and functions
  • And much more!!!

This presentation is for all Excel users who have at least a working knowledge of the software and who want to expand their proficiency and productivity in working with 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 Formulas and Functions
    Presenter(s): Dennis Taylor Protection Status