Anyone using Excel® invariably needs to create and understand how to use formulas and functions. For some Excel® users, it is the centerpiece of what they do on a daily basis. Many Excel® formulas involve simple mathematical constructions using addition, subtraction, multiplication and division, but sometimes you need more complex formulas to reach an answer. Excel® has more than 300 built-in functions that simplify what could be more cumbersome and lengthy formulas. Whether it's calculating the monthly payment on a car loan or quickly tabulating a total or average for a column of numbers, Excel®'s functions give you a tremendous capability to tackle a myriad of statistical, mathematical and financial challenges, not to mention functions that extract valuable date information and let you manipulate text at the character level.
Learn valuable tools to save you time and make you a master at creating formulas.
Gain real insight and depth into highlighted functions, such as IF, VLOOKUP, COUNTIF (and its related functions)
Learn powerful array formulas and the potent (but overlooked) text functions.
-More than 20 years of experience working with Excel®
-Taught thousands of classes and seminars throughout the U.S. and Canada
-Presented more than 500 Excel® webinars and is the author or co-author of six books on spreadsheet software
Lorman Education Services is an online continuing education company and compliance resource. Our extensive library of Live Webinars, OnDemand Webinars, and educational resources are designed to help you improve your profession and your business.