Dennis Taylor Training for Peninsula Insurance - Formulas and Functions
Formulas and Functions – Part 2
This course focuses on functions that every power user of Excel needs, as well as formula-building and trouble-shooting techniques. Learn the powerful VLOOKUP and HLOOKUP functions and the companion MATCH, and INDEX functions - indispensable for matching up data across different worksheets. Analyze data with the family of COUNTIF functions, use special Date/Time functions for chronological data, extract data from text strings with Text functions and use a variety of functions from the many Math and Statistical functions. Attack more complex analyses with Array formulas and functions.