Advanced Microsoft® Excel® Formulas and Functions

• Overview
• Credits

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)? These reference materials give 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 program, “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.

These reference materials will be presented in version 2007, but covering all recent versions – 2003, 2002, 2000, 97, etc.

Authors

Dennis Taylor, Taylor Associates

Additional Formats