Mastering Formulas and Functions: Take Your MS Excel Skills to the Next Level

WHY ATTEND

Category by category, Dennis Taylor will take you through a library of powerful Excel functions—Power, Rounding, Statistical, Text, COUNTIF, Date/Time—and teach you how and when to use each one. You’ll learn how to use functions Microsoft has recently added to the software. Plus, Dennis will give you dozens of time-saving tips and tricks to help you get more done faster.

LEARNING OBJECTIVES

Join us for this powerful Excel training to learn how to:

• Simplify searching for data in tables with the lookup functions VLOOKUP, INDEX, and MATCH.
• Debug formulas that are giving you incorrect answers
• Use “array functions” that will help you tackle difficult formulas that deal with massive amounts of data
• Master the frequently overlooked ways to extract data from within cells and combine data from different cells
• Use cleanup tools for dealing with problems such as:
• leading or trailing spaces
• upper/lowercase changes
• trailing minus signs, and
• text/value conversions
• Gain programming-like capability by mastering the IF, AND, OR, and CHOOSE
• Deploy the power functions SUMIF and COUNTIF to help you tabulate database totals with ease

This session will be presented in Excel 2016 with comparison information available for Excel 2013.

ABOUT THE SPEAKER

Dennis Taylor is an author and highly respected computer trainer and facilitator, specializing in Excel. His focus is on those spreadsheet and database techniques that improve business efficiency and productivity. Dennis has over 25 years of training and consulting experience. He has taught well over 4,000 seminars and classes for over 100 companies, organizations, and government agencies.

Dennis is the author of “Teach Yourself Microsoft Excel 2000” and co-author of four other books on spreadsheet software. He has developed and presented specialized Excel courses (Tips and Tricks, Database Features, Advanced Formulas and Functions) to many clients over the past 25 years. In addition, Mr. Taylor has authored and presented more than 50 different training courses on Excel topics and has presented over 300 webinars to thousands of attendees.