Advanced Microsoft® Excel® Formulas and Functions

• Overview
• Agenda
• Faculty
• Credits

Benefits

Even if you are fairly comfortable with building formulas and functions in Excel®, you might still be missing out by having overlooked some powerful functions or just not be aware of special capabilities, like array formulas. There's no question that Excel's® 300+ functions give you tremendous capabilities 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. But who has the time to explore all of them (and of course you don't need to know them all)? This teleconference gives you exposure to those 'hidden' functions and gives you new and powerful tools, such as array formulas, that will make your usage of Excel® even more powerful and efficient. Also included are some of those valuable tips that you may have picked up in the previous teleconference, 'Mastering Excel® Formulas and Functions,' such as quick formula copying methods, creative use of the Ctrl to create formulas/Function in multiple locations simultaneously and a host of others. Specific functions that will be covered include MATCH, INDEX, CONVERT, TRANSPOSE, FREQUENCY, DATEDIF, INDIRECT, LEN, MOD, TREND, GROWTH, REPLACE, SUBSTITUTE, and extended uses of the IF and VLOOKUP functions.

MICROSOFT is a registered trademark of Microsoft Corporation and this event is not sponsored by or affiliated with Mircosoft Corporation.

EXCEL is a registered trademark of Microsoft Corporation and this event is not sponsored by or affiliated with Microsoft Corporation.