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.
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
|Apr 01, 2021||A Gift from Mrs Timm||Mins||$299.00|
|Apr 01, 2021||Vince Lombardi's Second Effort||Mins||$299.00|
|Mar 01, 2021||Increase Productivity using Microsoft Excel pivot tables, pivot charts, slicers, and timelines||60 Mins||$199.00|
|Feb 01, 2021||Advanced Microsoft Excel Pivot Tables: Data Analytics Made Simple||60 Mins||$199.00|