Excel Formulas and Functions

Microsoft Excel is a wonderfully versatile program which can be used across a vast number of business domains such as management, accounting, finance, and so on. The stunning fact about MS Excel is that it has a whopping 450+ functions! When put to full use in the respective departments or areas of work in which it can be used, MS Excel offers unimaginable possibilities.

Many of its functions are also deeply analytical. Knowing how to use its formulas and functions is truly essential for creating very effective financial and analytical worksheets. Many organizations expect their employees who handle Excel to have full knowledge of how to use its functions. This is why it makes enormous sense to have a thorough and complete understanding of all of its functions for Excel users.

A highly valuable learning session from Traininng.com, a leading provider of professional training for all the areas of regulatory compliance, is offering just this, at a webinar that it is hosting on May 6. Who else but Dennis Taylor, who is the acknowledged master of MS Excel, and who has authored and presented nearly 700 webinars on various Excel topics in the past 11 years, could be a better suited expert for this webinar?

This is an opportunity that cannot be missed by anyone who wants to unravel all the complexities of this program. Dennis is the ideally suited expert to help participants unleash the power of this software. This is the must-go to session for anyone who wants to learn more about Excel functions, formula concepts, and invaluable shortcuts.

Please visit https://www.traininng.com/webinar/Excel-formulas-and-functions-200883live to enroll for this 60-minute session, at which you will hear from the master of Excel, who has produced numerous Excel courses on video, CD, and DVD and has taught more than 500 seminars and over 5,000 classes on the subject.

This session will not only explain how perfectly to can use Excel without ever creating a formula or using a function and let them automate your calculations and save you inestimable time without the need for carrying out mental arithmetic; it will also offer participants a thorough perspective on what functions are available. Dennis will explain, with extensive examples, how to use many of them. Some of these include: the IF function (with AND and OR), the powerful VLOOKUP function, selected Date, Statistical, Financial, and Mathematical functions, and the frequently overlooked Text functions. In addition, he will also cover the powerful COUNTIF/SUMIF family of functions, as well as more recently introduced functions.

Dennis will offer in-depth coverage of specific formulas and functions. Participants will also gain the solid perspective needed for getting a grasp of the scope and depth of these critical Excel features. He will offer very relatable examples, which will be presented within the context of Excel worksheets based on real-life examples that he has encountered over the past 20 years of Excel consulting and teaching experience.

Numerous productivity tips, shortcuts, and accelerator tools, which are often easy to overlook, will be presented throughout the session, which is aimed at any Excel user who needs to go beyond the basics of using formulas or simply wants to become more comfortable and productive in using Excel formulas and functions. In all, this is a learning no one who wants to master Excel can afford to miss.

These are the areas that Dennis will cover at this webinar:

• Learn how to look up information in tables and reconcile different lists using the VLOOKUP function; for specialized lookup needs, learn to use the MATCH and INDEX functions
• Learn how to use selected Text functions to extract and manipulate character and numerical data for sorting and analytical purposes
• Learn how to build 3-D formulas to tabulate data totals from multiple worksheets
• Learn how to harness the power gained from using multiple functions in a nested fashion
• Learn how and when to use the expanded capabilities of the COUNTF family of functions and newer functions -AGGREGATE, ARABIC, ISFORMULA, and FORMULATEXT
• Learn how to use the powerful IF function and the related AND and OR functions for programming-like capability.
• p>

About the expert: Dennis is the author/presenter of over 200 hours of online Excel courses available at LinkedIn Learning. Dennis also authored Teach Yourself Microsoft Office 2000 and coauthored five other titles in this field. He has taught for numerous corporations, government agencies and colleges and universities.

Traininng.com is a provider of world class online professional training in the areas of regulatory compliance and healthcare.