Overview
-
Applying conditional functions to a dataset
1 mins
-
How to use IF function in Excel
3 mins
-
Usage of AND function in Excel
7 mins
-
Usage of OR function in Excel
12 mins
-
How to use COUNTIF function in Excel
26 mins
-
Defining the name of the range used in formula
29 mins
Course Description
There are several spreadsheet programs but from all of them, Excel is most widely used.Â
People have been using it for the last 30 years and throughout these years, it has been upgraded with more and more features. The best part about Excel is, it can apply to many business tasks, including statistics, finance, data management, forecasting, analysis, inventory, billing, and business intelligence.
Working with data, you must have come across situations where you need to select a few cells and perform calculations on them. Generally, filtering the data according to conditions is difficult and time-consuming.
If you want to perform a calculation when a cell contains a specific value you can create a conditional formula using conditional function.
Conditional functions perform calculations on a cell or range of cells only if those cells meet a certain condition. These functions test a given range and determine if the condition is true or false before continuing. A condition can be any relational comparison.
Join this excel CPE webinar to learn how to use conditional functions in Excel to attain the best possible results.
It doesn’t matter what version of the PC or Mac operating system you’re using. The techniques we will cover in this CPE webinar will work similarly in Excel for PC and Mac
Learning Objectives
- To discuss the conditional functions in Excel
- To analyze how to add formulas in Excel
- To investigate how to enter complex sets of AND and OR conditions.
- To discuss how to use COUNT and related functions in Excel
Recommended For
- This CPE webinar is recommended for CPAs, CVAs, CMAs, and other individuals who want to understand the most powerful spreadsheet program Microsoft Excel its Conditional functions to better assist their clients.
Who Should Attend?
- Accountant
- Accounting Firm
- Accounting Managers
- Accounts Payable Manager
- Bookkeepers & Accountants & Tax Preparers
- Certified Management Accountant (CMA)
- Certified Public Accountant (CPA)
- Chartered Accountant
- Chief Accounting Officer
- CPA (Industry)
- CPA - Mid Size Firm
- CPA - Small Firm
- CPA in Business
- Entrepreneurial CPA
- Senior Accountant
- Staff of Accounting Firm
- Young CPA