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