Scribd
Upload
7 views13 pages

Essential Excel Functions Guide

The document provides an overview of various functions in Microsoft Excel, highlighting their advantages such as time-saving and simplification of complex calculations. It details specific functions like SUM, AVERAGE, MAX, MIN, COUNT, IF, and CONCATENATE, including their syntax and usage. Additionally, it explains concepts like arguments, syntax, and nested IF statements to enhance understanding of function implementation.

Uploaded by

amanolamey1221
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
7 views13 pages

Essential Excel Functions Guide

The document provides an overview of various functions in Microsoft Excel, highlighting their advantages such as time-saving and simplification of complex calculations. It details specific functions like SUM, AVERAGE, MAX, MIN, COUNT, IF, and CONCATENATE, including their syntax and usage. Additionally, it explains concepts like arguments, syntax, and nested IF statements to enhance understanding of function implementation.

Uploaded by

amanolamey1221
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd

MICROSOFT EXCEL

FUNCTIONS
FUNCTIONS
A function is a predefined formula in excel.

The advantage of using a function:


 Saves time writing
 Simplifies complex calculations
 Faster execution
 Less chance of typographical errors
 Fewer characters in the formula bar

Example: instead of =A1+A2+A3+A4 use =SUM(A1:A4)


FUNCTIONS (Cont.)
The general format of a function is
=Functionname(arguments)

Arguments – argument variables are used by the


function to calculate the result. Arguments appear in
a specific order.

Syntax – specific format required to use a function its


name and order of arguments

Result – the value calculated by the function


Algorithm – a step-by-step procedure for
accomplishing some end task.
THE SUM FUNCTION
Syntax: =SUM(range) or =SUM(num1, num2,
…)

Ways to AutoSUM
Can type into cell
Use AutoSum toolbar button
Function wizard

Example: In the formula =SUM(B2:B8) * 3 Excel will


add the values in cells B2 through B8 and then
multiple the result by 3.
AVERAGE FUNCTION
Syntax: =AVERAGE(range) or =AVERAGE
(num1, num2, …)

The average function finds the average of the


specified data. (Simplifies adding all of the indicated
cells together and dividing by the total number of
cells.)
MAX & MIN FUNCTIONS
Syntax: =MAX(range) or =MAX (num1,
num2, …)
=MIN(range) or =MIN (num1,
num2, …)

The MAX function will return the largest


(max) value in the selected range of
cells. The MIN function will display the
smallest value in a selected set of cells.
COUNT & COUNTA FUNCTION
Syntax: =COUNT(range) or =COUNT(num1,
num2, …)
=COUNTA(range) or =COUNTA(num1,
num2, …)

The COUNT function will return the number


of entries (actually counts each cell that
contains NUMBER DATA) in the selected
range of cells.
Remember: cell that are blank or contain
text will not be counted.
IF FUNCTION
Syntax: =IF(condition, value-if-true,
value-if-false)

The IF function will check the logical


condition of a statement and return one
value if true and a different value if false.
IF FUNCTION (CONT.)
IF Functions are
like programing -
they provide
multiple answers
based on certain
conditions.
IF FUNCTION (CONT.)
Comparison
operators in an IF
statement can be
used to compare
text values, dates,
numbers, and
more.
NESTED IF STATEMENT
Syntax: =IF(condition1, result1,
IF(condition2, result2, IF(condition3,
result3, result4)))

A Nested IF statement is defined as an


Excel formula with multiple IF conditions
CONCATENATE FUNCTION
Syntax: =CONCATENATE(text1,
[text2], ...)

The concatenate function join several


strings into one text string .

Note: The concatenate function does


not automatically leave a blank space
between words or other data.
THANK YOU!!!
Any Questions?

You might also like