Basic Excel Formulas For Your Daily Workflow

Microsoft Excel is considered as the industry standard in data analysis world and it’s used for data processing, data modeling, and reporting. I will give an overview of basic Excel functions.

Formula: A formula is an expression that operates on values in a range of cells or a cell. For example, we have three cells B1,B2,B3, and B4 if want to sum these cell we use ‘=B1+B2+B3+B4’, which finds the sum of the range of values from cell B1 to B4.

Functions: The functions are pre-defined formulas in Excel. For example, if we consider above, we do sum using a pre-defined function called SUM. ‘=SUM(A1:A3)’, this function sums all the values from B1 to B4.

Some Basic Excel Formulas For Your Daily Workflow:

AVERAGE: Get the average of a group of numbers
COUNT: Count numbers
COUNTA: Count the number of non-blank cells
COUNTBLANK: Count cells that are blank
IF: Test for a specific condition
LEN: Get the length of text
TRIM: Remove extra spaces from text
CONCATENATE: Join text values without delimiter
EXACT: Compare two text strings
DATE: Create a valid date from year, month, and day
DATEDIF: Get days, months, or years between two dates
MATCH: Get the position of an item in an array
TRANSPOSE: Flip the orientation of a range of cells
LOOKUP: Look up a value in a one-column range
VLOOKUP: Look up a value in a table by matching on the first column
ROUND: Round a number to a given number of digits

CHISQ.TEST: Get the chi-square distribution of two provided datasets
BINOM.DIST: Get the chi-square distribution
CORREL: Calculate the correlation co-efficient between two variables

Happy Learning !!! :)

My_website | Facebook | Twitter | Instagram | Youtube