Training
Provided by Lorman Education Services
BenefitsEven 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.
Business owners and managers, supervisors, associates, administrative professionals, analysts, bookkeepers, human resource professionals, accountants and attorneys
| This is primarily teleseminar training |  | Contact Lorman Education Services for more information |
|
| Training Presented in: | English |
|
