Microsoft Excel
Microsoft Excel provides an automated way of displaying any statistical data. It can be used to automatically compute for several factors that are not easy to notice especially when faced by a large
data. Microsoft Excel includes several arithmetic and basic functions that help you compute faster.
Basic Excel Formulas
How to use IF functions in MS Excel
ADVANCED SPREADSHEET SKILLS
Addition (+)
Subtraction (-)
Multiplication (*)
Division (/)
​
*type <=> before the formula, thus:
=a1+a2 <then, hit the ENTER key>
• Average – a function used to compute for the
average of the number of a range.
​
• COUNTIF – a function used to count the cells with a
specified content within a range.
• SUMIF – a function used to compute for the
summation of a range if a certain condition is met
• AVERAGEIF – a function used to compute for the
average of a range if a certain condition is met