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.
Website: http://www.excelconsultant.net/
Linkedin: https://www.linkedin.com/in/excelandaccess/
Twitter: https://twitter.com/excelandaccess
Instagram: https://www.instagram.com/excelandaccess/
Facebook: https://www.facebook.com/excelandaccess