data analysis

Data Analysis (Spreadsheets)

Cell and Range References

 Using Formula

Using Functions

 SUM

AVERAGE

MIN

MAX

COUNT

NOTE: Any cells that contain text or a combination of text and numbers will be ignored.

COUNT A

NOTE:
-  In Excel there is not a function that can count text values while ignoring numeric values. 

- It will NOT count any empty cells.

COUNT IF

INT

ROUND

VLOOK

SUM IF

IF

Nested Formula and Function

       

Sorting

Filters