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.
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.
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