Decision Making Functions in Excel -Video

Price: $19.99

CPE Credits: 1.5

Category: ,

Course Number: VCXDECMC

logic functions

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.

Advanced Preparation: None

Author: Patricia McCarthy

Publication: June 2015

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

Passing Grade: 70%

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

CPE Sponsor Info : NASBA/QAS #109234. Click here to view specific state approvals.

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.

Advanced Preparation: None

Author: Patricia McCarthy

Publication: June 2015

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

Passing Grade: 70%

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

CPE Sponsor Info : NASBA/QAS #109234. Click here to view specific state approvals.

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

  • Thank you for providing very informative CPEs. I have enjoyed your courses for years now. Yours is truly my go-to CPE sources.

    - Lily

  • Thank you Patricia. I really love your courses. I learned so much about excel this weekend!”

    - Connie K.