Excel Accountant: Logic Functions

Learning Objectives

• To recall the basics of IF Function and beyond
• To choose VLOOKUP as an alternative to IF Function
• To define the purpose of Excel's IFERROR worksheet function
• To discuss the introduction to IS Function and how to use it.
• To recognize the SUMIF Function and name what the SUMIF Function returns if a match cannot be found

Course Description

Using the IF Function is a common feature that most of us utilize in an Excel worksheet. However many of us do not realize what can go awry in some cases with using this feature. Well, here is the answer to it. Our eminent EXCEL Expert brings here step-wise details on this IF Function right from its basics and beyond. Also, he shares the alternatives to this Function which include various functions such as IFS, CHOOSE, VLOOKUP, SUMIF, and several others. This Online Webinar also explores techniques useful in verifying that formulas such as nested IF statements are working properly.

Every technique is demonstrated at least twice by David in this continuing education Excel course, firstly using a PowerPoint slide with numbered steps and secondly in a subscription-based MS Office 365 version of Excel. David also draws your attention to differences in the older versions of Excel (i.e. 2019, 2016, 2013, etc.) in this online CPE webinar through his presentation and detailed handouts. He also has shared an Excel workbook that includes most of the examples used during the webcast.

David Ringstorm explains the subscription-based product 'Office 365' provides new feature updates as often as monthly as against the perpetual licensed versions of Excel such as Excel 2019, Excel 2016, and so on, which do not update and include the latest features.

The following are the Key Topics included in this Course:

• Introduction to IF Function
• Comparing Cells Without Using IF
• Two Levels of Nested IF Statements
• IFS Function (Excel 2019+)
• Introduction to IFERROR Function
• IFERROR/VLOOKUP Alternative to IF
• MINIFS Function (Excel 2019+)

If you want to specialize in Excel then click here: Certified Excel Specialists | CPE Excel webinars.

Overview

• IF Introduction

  3 mins
• Multiple Levels of Nested IF Statements

  19 mins
• Use F9 to Calculate Part of a Formula

  20 mins
• Evaluate Formulas

  26 mins
• IFS Function (Excel 2019+)

  33 mins
• XOR Introduction

  71 mins
• NOT Introduction

  72 mins
• SUMIFS Introduction

  75 mins
• COUNTIF/COUNTIFS Introduction

  93 mins
• MIN/MAX and SMALL/LARGE

  94 mins
• MINIFS Function (Excel 2019+)

  97 mins