Excel Formulas and Functions De-Mystified: Manage Your Excel Worksheets With Power and Confidence as You Master Formulas and Fun

Training Provided by Lorman Education Services BenefitsAnyone 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 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. This teleconference will give you a ton of valuable tools to make you a master at creating formulas, auditing worksheet formulas, mastering the way to understanding many of those 300+ functions, and some real insight and depth into highlighted functions, such as IF, VLOOKUP, COUNTIF (and its related functions), ROUND (and its companions), powerful array formulas and the potent (but overlooked) text functions. This teleconference will utilize gotowebinar, an internet active tool which allows the speaker to walk through examples in real time. This will be the best way to follow along with the program and a link will be provided for you prior to the program date. This teleconference will be presented in version 2007, but covering all recent versions - 2003, 2002, 2000, 97, etc. Business owners and managers, supervisors, associates, administrative professionals, analysts, bookkeepers, human resource professionals, accountants and attorneys

About The Training Provider: Lorman Education Services