Excel Formula and Function
Excel Formulas and Functions
Microsoft Office Excel is used to store data and crunch numbers in all types of businesses. The spreadhseet program's power lies in Excel functions and Excel formulas, which allow all sorts of data analysis, from simple sums to standard deviations. Consider this Cheat Sheet your quick and easy Excel tutorial.
Excel Functions You're Likely to Use
Some Excel functions apply to specific subject areas, but others are general and apply to all needs. The following list shows an array of Excel functions used by one and all. Check here for a quickie reference to the purpose of each Excel function. Excel Function | Description | SUM | Calculates the sum of a group of values | AVERAGE | Calculates the mean of a group of values | COUNT | Counts the number of cells in a range that contains numbers | INT | Removes the decimal portion of a number, leaving just the integer portion | ROUND | Rounds a number to a specified number of decimal places or digit positions | IF | Tests for a true or false condition and then returns one value or another | NOW | Returns the system date and time | TODAY | Returns the system date, without the time | SUMIF | Calculates a sum from a group of values, but just of values that are included because a condition is met | COUNTIF | Counts the number of cells in a range that match a criteria |
Excel Text Functions You'll Find Helpful
Excel's text functions are very helpful when you're working with names, addresses, customer lists, or any other text-based data. Here is list of Excel functions associated with text, along with a description of what each function does: Function | Description | LEFT | Extracts one or more characters from the left side of a text string | RIGHT | Extracts one or more characters from the right side of a text string | MID | Extracts characters from the middle of a text string; you specify which character position to start from and how many characters to include |
Microsoft Office Excel is used to store data and crunch numbers in all types of businesses. The spreadhseet program's power lies in Excel functions and Excel formulas, which allow all sorts of data analysis, from simple sums to standard deviations. Consider this Cheat Sheet your quick and easy Excel tutorial.
Excel Functions You're Likely to Use
Some Excel functions apply to specific subject areas, but others are general and apply to all needs. The following list shows an array of Excel functions used by one and all. Check here for a quickie reference to the purpose of each Excel function. Excel Function | Description | SUM | Calculates the sum of a group of values | AVERAGE | Calculates the mean of a group of values | COUNT | Counts the number of cells in a range that contains numbers | INT | Removes the decimal portion of a number, leaving just the integer portion | ROUND | Rounds a number to a specified number of decimal places or digit positions | IF | Tests for a true or false condition and then returns one value or another | NOW | Returns the system date and time | TODAY | Returns the system date, without the time | SUMIF | Calculates a sum from a group of values, but just of values that are included because a condition is met | COUNTIF | Counts the number of cells in a range that match a criteria |
Excel Text Functions You'll Find Helpful
Excel's text functions are very helpful when you're working with names, addresses, customer lists, or any other text-based data. Here is list of Excel functions associated with text, along with a description of what each function does: Function | Description | LEFT | Extracts one or more characters from the left side of a text string | RIGHT | Extracts one or more characters from the right side of a text string | MID | Extracts characters from the middle of a text string; you specify which character position to start from and how many characters to include |