You may be comfortable using formulas and functions in Excel, but it's likely that you may have missed some of its powerful functions and capabilities. For instance, MATCH, INDEX, INDIRECT functions and the array formulas. Excel has a whopping 450+ functions giving you the power to handle a numerous statistical, mathematical and financial challenges, not to mention functions that extract valuable date information and let you manipulate text at the character level.
This webinar by expert speaker Dennis Taylor gives you an inside-look to some "hidden" function and new and powerful tools in Excel. You'll learn about array formulas and array functions (FREQUENCY, TREND, and GROWTH); quick formula copying methods, creative use of the Ctrl key to create formulas/function in multiple locations simultaneously; and a host of other mind-blowing tricks.
You'll learn using the following functions:
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
Dennis Taylor has taught thousands of Excel seminars and classes since the early 90's, is the author/presenter of over 250 Excel webinars, and authored the book Teach Yourself Microsoft Excel 2000. He has taught hundreds of public Excel seminars in the US and Canada since 2006 and has recorded over 100 Excel courses bo... More info