Microsoft Excel Training Videos - CPE Coalition

Microsoft Excel Functions and Formulas Training

By Dennis Taylor of Excel and Access, LLC, for the CPE Coaltion

Working with Microsoft Excel 2013 formulas and functions is absolutely critical to building powerful financial and analytical worksheets and is probably the most important skill set for many Excel users. This session gives you perspective on what functions are available and explains (with extensive examples) how to use many of them, including: the IF function (with AND and OR), the powerful VLOOKUP function, selected Date, Statistical, Financial, and Mathematical functions, and the frequently overlooked Text functions.

Part One

Microsoft Excel Functions and Formulas Training

By Dennis Taylor at Excel and Access, LLC for the CPE Coaltion

Part-two of the four-hour series on working with Microsoft Excel 2013 formulas and functionsby Dennis Taylor: Index, Match and other the frequently overlooked functions.

Part Two