Overview
-
What is an Excel function?
1 mins
-
What does sum function do?
5 mins
-
Applying Autosum function in Excel
9 mins
-
How to apply function finding the maximum value in the data set?
14 mins
-
Applying COUNT Function in Excel
18 mins
-
How to find out status bar short cut functions in Excel
21 mins
Course Description
Excel is a spreadsheet program, which contains a number of columns and rows, where each intersection of a column and a row is a “cell.” Each cell contains one point of data or one piece of information.
In a Microsoft Excel spreadsheet, values can refer to text, dates, numbers, or Boolean data. The type of the value depends on the data to which it's referring.
A function in Excel is a preset formula that helps perform mathematical, statistical, and logical operations. Once you are familiar with the function you want to use, all you have to do is enter an equal sign (=) in the cell, followed by the name of the function and the cell range it applies to.
Excel includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells. To use functions correctly, you'll need to understand the different parts of a function and how to create arguments to calculate values and cell references.
A Formula is an equation designed by a user in Excel, while a Function is a predefined calculation in the spreadsheet application.
This CPE webinar helps you to understand Excel Functions.
Learning Objectives
- To discuss values in Excel.
- To analyze Excel referencing.
- To inspect Excel functions.
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
- Accounts Payable Manager
- 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