## Decision Making Functions in Excel -Video

Price: \$19.99

CPE Credits: 1.5

Category: ,

Course Number: VCXDECMC

Description:  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.

Delivery Method: Online QAS Self Study.

Level: Overview.

Version: Excel 2007 and higher

Prerequisites: This course is considered a basic to intermediate level course. It is expected that participants know basic file management skills such as opening and closing files as well as how to do simple calculations in a spreadsheet.

Author: Patricia McCarthy

Publication: June 2015

Format: Video with an accompanying Excel workbook
Run-Time: 58:52

Exam Policies: Exam may be retaken. Course must be completed within one year of purchase.

By the end of the course participants 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.

Description:  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.

Delivery Method: Online QAS Self Study.

Level: Overview.

Version: Excel 2007 and higher

Prerequisites: This course is considered a basic to intermediate level course. It is expected that participants know basic file management skills such as opening and closing files as well as how to do simple calculations in a spreadsheet.

Author: Patricia McCarthy

Publication: June 2015

Format: Video with an accompanying Excel workbook
Run-Time: 58:52

Exam Policies: Exam may be retaken. Course must be completed within one year of purchase.

By the end of the course participants 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.

• I wanted to compliment you on the Accounting Fraud – Recent Case Studies (AUCASEMC) course I just took. The ebook was fantastic! Concise, easy to understand, very well structured, and very interesting. Exactly the way I like it. Thank you for putting it together. I feel it took me enough time to be worth 2 CPEs, but it was fantastic nonetheless. Thank you.

- Mark R.

• You guys do a great job!  As a person in industry it can be really expensive to stay current and you have great options that are actually useful as well as cost effective!

- Sue

• Your website was easy to navigate and informative.” “This was my first use of your resources but I’m sure it won’t be my last. Thank you for your excellent course material and succinctly stated instructions which expedited order and payment of course selection, completion of exam, and immediate availability of Certificate of Completion. A great experience. Thanks.

- Draper