Excel – Building Powerful Lookup & Reference Formulas (2 hours)

Overview

Integrating functions into your spreadsheets not only improves efficiency, it also makes your task easier to execute. Join us for this webcast to learn about Logical, Information and Lookup and Reference functions in Excel.

Highlights

•Advanced search and data retrieval with LOOKUP, INDEX and MATCH functions
•Speeding up worksheet creation with the INDIRECT function
•Conditions with the LOGICAL functions (IF, AND, OR, NOT)
•ERROR checking functions

Prerequisites

Basic Excel knowledge

Designed For

accounting and finance professionals<@br> Anyone who wants to become an expert in using Excel functions and formulas

Objectives

• Use complex lookup formulas
• Use the INDIRECT function to speed worksheet creation
• Use ERROR checking functions in calculations

Notice

“Adding to Calendar” does not register you for this event. Please either register online by clicking “Add to Cart” or contacting OSCPA at 503-641-7200 / 800-255-1470, ext. 3. Thank you!