Excel Formula & Functions Part 1 | SUM, COUNT, COUNTA & AVERAGE (with examples)
Excel Formula & Functions Part 1 | SUM, COUNT, COUNTA & AVERAGE (with examples). Formulas as in Mathematics, are expressions that operate on operand to give desired results. In this video 4 formulas/functions are elaborated.
SUM: This function is used to sum up 2 or more arguments.
COUNT: This function counts all the values in the defined range.
COUNTA: This function count all the text values in the defined range.
AVERAGE: This function calculates average of all the numbers in the defined range
These functions will help in enhancing the productivity in day today data analysis tasks. This lecture will be beneficial for both beginners and professionals who use Excel. It is part of the excel course having series of lectures on various concepts of Excel.These functions are available in all the versions of Excel..
This is the first part of this video. Link for the Second part is given below:
Most Useful Excel Formula & Functions (with examples) Part 2:
• Most Useful Excel Formula & Functions (wit...
I will also include any topic you will ask for in comments related or unrelated to the video.
Visit & Subscribe channel: / @techreflections
Welcome to Tech Reflections (#techreflections) & I am Vikram.
Checkout Other Playlists on this channel:
Excel formula and functions:
• Excel - Formulae & Functions
Conditional Formatting:
• Excel - Conditional Formatting
Pivot Tables:
• Pivot Tables & its features
#techreflections #excelformulas #excelfunctions