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