Dennis Taylor Training for Peninsula Insurance - Formulas and Functions HD

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