Decision-making Functions in Excel (1 hr)

Course Description

Decision-making Functions in Excel

VIDEO COURSE – Become a decision-maker using Excel. Excel has many logic functions that can help you automate decision-making whether it is determining if sales quotas have been met, compensation plans met, discounts achieved based on quantity or simply selecting a sample. This course is a video and covers the Excel logic functions of IF, AND and OR. It then discusses other decision-making functions such as SumIF, SUMIFs, COUNTIF, AVERAGEIFs, as well as IFERROR and IFNA. This course is based upon Excel 2007 through 2013 and includes an Excel worksheet file.

Course Information


Price: $18
Course No. 6005
Format: Video with Excel worksheet practice file
Prerequisites: Basic file management skills such as opening and closing files as well as how to do simple calculations in a spreadsheet.
Advance Preparation:None
Level: Basic to Intermediate
CPE Credit: 1 hr.
Field of Study: Computer Software & Applications
Course expiration:  You have one year from date of purchase to complete the course.
Course Revision Date: January 2016

Objectives

Upon completion of this course you should be able to:

1. Identify different decision-making functions and their purpose and which to select
2. Recognize the components of the decision-making functions and how to create them.

Purchase