Making Excel Formulas Work for You

Overview

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!

Highlights

This session is taught using a Hands-On methodology. We provide practice files that tie to the examples in the course materials so participants can undertake all the steps in unison with the instructor for a greatly improved learning experience. The Excel topics discussed in this session include: Understanding formula conventions. Working with Functions. Examples of Powerful Excel formulas.

Prerequisites

An understanding of Excel formulas

Designed For

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

Objectives

Once participants have completed this session, they should be able to: 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.