Register Online - Add to Cart

Credits

Only registered attendee will receive continuing education credit.
Product ID: 401263
 

Advanced Microsoft® Excel® Formulas and Functions

Live Webinar
December 1, 2017
1:00 pm ET (12 pm CT, 11 am MT, 10 am PT)
1 hour 30 minutes
Live Webinar$199Register Now
Can't Attend?   Audio & Reference Manual$199Add to Cart

Even if you are comfortable with building formulas and functions in Excel®, you may be missing out on some often overlooked powerful functions and special capabilities.

There's no question that Excel's® 450+ 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 few of us have the time to explore functions (and of course you don't need to know them all). This topic gives you exposure to those overlooked functions and gives you new and powerful tools, such as array formulas, that will make your usage of Excel® even more powerful and efficient. Receive 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, AGGREGATE, FREQUENCY, DATEDIF, INDIRECT, LEN, MOD, TREND, GROWTH, REPLACE, SUBSTITUTE, and extended uses of the IF and VLOOKUP functions.

Learning Objectives

  • You will be able to review powerful Date and Text functions.
  • You will be able to discuss the power of Array Formulas.
  • You will be able to identify nested uses of VLOOKUP, MATCH, and Array formula techniques.
  • You will be able to explain how to readjust formula references with the INDIRECT function.

Registration

Live Webinar$199Register Now
Can't Attend?   Audio & Reference Manual$199Add to Cart