Mastering Excel 2013 Formulas and Functions

Boost Your Competency and Accuracy with Excel 2013 Formulas and Functions

To use Excel effectively and efficiently, you need to know how to apply correct structure and syntax to your formulas and functions—you can’t afford to guess!

Working with formulas and functions in Excel is absolutely critical to building powerful financial and analytical worksheets and is probably the most important skill set for many Excel users. Excel, with its 450 built-in functions, is a potent power-tool set which simplifies certain types of formulas, giving you a large chunk of computational possibilities. Extended analytical capabilities can be achieved by various Excel functions, and they are known to open doors to more efficient Excel use, but with so many functions, it's not easy to know which functions are available and which ones you might have overlooked.

Join this webinar presented by our expert speaker who gives you perspective on what functions are available and explains (with extensive examples) how to use many of these functions and formulas, such as  The IF function (with AND and OR), the powerful VLOOKUP function, selected Statistical, Date, Financial, and Mathematical functions, the Text functions which are frequently overlooked but are critical if you need to clean up problems with downloaded data; and the powerful COUNTIF/SUMIF family of functions and newer functions that were introduced in Excel 2010 and 2013.

This session will cover specific functions and formulas, and provide you with the perspective you require to understand the depth and scope of these Excel features. The speaker will cover all these with examples within the context of Excel worksheets, coupling them both with real-life examples that he has encountered in his vast consulting experience. After attending the webinar, you will be able to use a lot of productivity tips, accelerator tools and shortcuts that you understand from our expert speaker. 
 

Webinar Agenda

• Understand the shortcuts to formula-building and using formula-auditing tools
• How to use the powerful IF functions and also the related OR & AND functions required for programming-like capability.
• Finding out information in tables and conjoin different lists using VLOOKUP function to cater to specific lookup needs.
• Understanding the use of MATCH and INDEX functions
• How to use selected text functions for extracting and manipulating numeric and character data for various analytical and sorting needs.
• How to build 3-D formulas that will help in tabulating data totals from various different worksheets
• Harnessing the power gained from various functions in nested fashion
• 'How' and 'when' to use COUNTIF family of function's extended capabilities and also the newer functions such as FORMULATEXT, ARABIC, AGGREGATE and ISFORMULA.
   

Who Should Attend

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