Overview
-
How to use SUMIF function in Microsoft excel
4 mins
-
Usage of SUMIFS function in Microsoft excel
6 mins
-
How to use DSUM function in Microsoft excel
17 mins
-
Arguments used in a SUBTOTAL function
26 mins
-
How to use the SUBTOTAL function in Microsoft excel
29 mins
Course Description
Excel is one of the most widely used spreadsheet programs in the world. People have been using it for the last 30 years and throughout these years, it has been upgraded with more and more features.
Have you ever been feeling difficulty in dealing with huge data? Dealing with huge data is a tedious process.Â
You can always find better ways to deal with your data by Excel database functions.Â
The Excel Database functions work with an Excel Database. This typically takes the form of a large table of Data, where each row in the table stores an individual record. Each column in the Worksheet table stores a different field for each record.
But how to use them to the best of your benefit?
Come be a part of this CPE Online course and increase your data management skills!Â
Excel database functions allow you to sum and count data in spreadsheets based on AND and OR conditions that join together multiple sets of criteria, such as dates, amounts, geographies, industries, and product identifiers.
Join this excel CPE webinar to learn how to query and aggregate data tables more effectively with Database Functions.
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 query and aggregate data DSUM and DCOUNT
- To analyze how to enter complex sets of AND and OR conditions.
- To extract a single row from a table that matches specific conditions by using the DGET function.
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 functions to better assist their clients.
Who Should Attend?
- Accountant
- Accounting Firm
- Accounting Managers
- Bookkeepers & Accountants & Tax Preparers
- Certified Management Accountant (CMA)
- Certified Public Accountant (CPA)
- Chartered Accountant
- Chief Accounting Officer
- Cloud Accountants
- CPA (Industry)
- CPA - Mid Size Firm
- CPA - Small Firm
- CPA in Business
- Entrepreneurial CPA
- Senior Accountant
- Staff of Accounting Firm
- Young CPA