## 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.

• Your ethics course was the most interesting and clear course I have taken. I usually dread the years it is required but this year was a pleasant surprise.

- Terry

• 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.

• “The author did a good job of setting forth the ethical standards contained in the California State Board of Public Accountancy Rules and the AICPA Code of Conduct.”

- California Ethics Course