Overview

4.0 Credits
ONLINE

A great many Excel users do not realize how powerful and versatile formulas can be. Additionally, some are intimidated by formulas that do not behave as expected. In this session, we step through the basic and then the more complex formula conventions. We then review the function library and discuss details on how they (functions) can best be used. Finally, we spend time reviewing some of the ways formulas can be helpful and time saving. Users that want to learn how to “program” Excel should take this session!

Objectives

  • Recognize basic formula conventions such as identifying a formula and order of operation.
  • Recall newly introduced functions in the Excel Function Library.
  • Recall important concepts related to function use, and Indicate how to combine and nest multiple functions in a single formula.

Major Topics

  • Understanding formula conventions.
  • Working with functions.
  • Examples of powerful Excel formulas.

Designed For

Accounting and other business professionals that work in Excel who want to utilize the power of formulas.

Prerequisite

An understanding of Excel formulas.

Add to Cart