SCORE - Live Webinar - Excel Functions — Power Tools for Your Formulas

Much of Excel’s power lies in the functions you can use in formulas. But there’s a catch, if you use them incorrectly, you get the wrong answer.

This live, one-hour program will explain how functions work and how to discover the best one for your formula, and introduce Excel features that help you build your functions with confidence that they will produce the correct result every time.

Demonstrations and explanations will cover:

• What Excel functions are and how they work in formulas;
• What functions can and can’t do;
• How to research functions to find the ones best suited to your needs;
• Benefits of using the Insert Function dialogue box to enter functions into formulas;
• Key function concepts, including syntax, and optional and required arguments;
• What absolute cell references are, and when you want to use them;
• Using the IF and other logical functions to write formulas with conditional results;
• Working with VLOOKUP and other Lookup and Reference Functions;
• What Date and Time Functions can do; and
• Using Text functions to manipulate character strings.

There will be plenty of time for questions, so come prepared.

Presenter: Gerald Rosenthal - ComputerImages.com