CPE PACKAGES (Incl. Ethics) for Multiple States and Qualifications @ $4/credit. CLICK HERE to view.

Excel Accountant: Logic Functions

You need to register for the webinar to watch the video.

Click Here to Register

Before starting this self study program, please go through the instructional document.

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

Course Description

Using the IF Function is a common feature that most of us utilize in an Excel worksheet. But many of us do not realize about 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 includes various functions such as IFS, CHOOSE, VLOOKUP, SUMIF and several others. This presentation 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, firstly by means of 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 his presentation and detailed handouts. He also has shared an Excel workbook that includes most of the examples used during the webcast.

David explains the subscription-based product 'Office 365' providing 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 does not update and include latest features.

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 introduction to IS Function and how to use
  • To recognize the SUMIF Function and name what the SUMIF Function returns if a match cannot be found

Who Should Attend?

  • Accountant
  • Accounting Firm
  • CPA (Industry)
  • CPA - Large Firm
  • CPA - Mid Size Firm
  • CPA - Small Firm
  • CPA in Business
  • Entrepreneurial Accountant
  • Entrepreneurial CPA
  • Senior Accountant
  • Staff of Accounting Firm
  • Tax Accountant (Industry)
  • Young CPA

Testimonial

4

(2)
0%
100%
0%
0%
0%

JO

The Excel courses are a great way to learn or improve your skills. The visual examples allow me to perform the skills alongside the presenter which promotes learning.