Topic: Professional business Microsoft Excel training
Embedded Files
The subtopics: Commonly used functions
Objectives:
i. To list out the commonly used functions in Excel
ii. To know the differences of each functions
iii. To be able to use suitable functions based on needs
Introduction
Introduction
Start everything from beginning
SUM Fuction
SUM Fuction
As one of the most common used function, SUM function helps in creating simpler addition.
MOD Function
MOD Function
The main purpose of MOD function is to find the remainder.
COUNT, COUNTA, COUNTBLANK Function
COUNT, COUNTA, COUNTBLANK Function
We have set of data as following.
MAX and MIN Functions
MAX and MIN Functions
To find the maximum (largest) and minimum (smallest) value out of the set of data.
AVERAGE, MODE and MEDIAN Functions
AVERAGE, MODE and MEDIAN Functions
Mean sets the average value of all data and as for mode, it is to count the most frequent data shown. Median is the center of the data.
Exercise
Exercise
Practice makes perfect
Page updated
Google Sites
Report abuse