Making Excel Formulas Work for You

Course Description:

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 all the basic and then more complex formula conventions. We then review the function library and discuss details on how they are best 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! 

Learning Objectives:

Once participants have completed this session they should be able to:

• Understand basic formula conventions such as identifying a formula and order of operation 
• Introduce functions from the Function Library
• List important concepts related to function use
• Show how to combine and nest multiple functions in a single formula

Course 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

Who Should Attend?

Accounting and other business professionals that work in Excel who want to utilize the 

power of formulas. 

Area of Study:

Information Technology 

Level:

Intermediate

Credit:

4 hours

Prerequisites:

An understanding of Excel formulas