# Excel Functions

#### Functions are the core of Excel. Excel has hundreds of functions ranging from simple functions, like SUM, to more complex formulas like INDEX/MATCH. Excel will let you manipulate and model data in any way you can imagine, but the key is knowing the right functions to use and how to use them.

• Absolute References in Excel reference the same cell(s), no matter where the formula is copied in the worksheet.

• AVERAGE function returns the average (or arithmetic mean) of a group of numbers.

• CONCAT function joins together different pieces of text into one string of text.

• COUNT function counts the number of cells in a range that contain numerical values.

• COUNTIF function counts the number of cells in a range that meet one specified criteria.

• COUNTIFS function counts the number of rows or columns in a range that meet multiple specified criteria.

• Drop Down Lists let you specify a list of data that a user can pick from to populate a cell.

• FIND function searches for a case-specific substring within a string of text and returns the substring's position.

• HLOOKUP function returns a corresponding value beneath a specified lookup value in a table.

• The Format Painter lets you quickly and easily copy formatting from one cell to another.

• IF function lets you add logical decisions to your Excel spreadsheet, and return different values based on whether a condition is true or false.

• INDEX function returns the value from a cell in a list at a specified position.

• LARGE and SMALL functions returns the nth largest or smallest value from a group of numerical values, such as the 2nd largest, or the 3rd smallest values.

• LEFT function returns a specified number of the leftmost characters of a string of text.

• LEN function returns the length of a text string in number of characters.

• LEN, LEFT, RIGHT, and MID functions returns different sections of a string of text, such as the leftmost 5 characters, or other slices of text.

• Logical Functions (AND, OR, XOR, NOT) return true or false based on different combinations of conditions.

• MATCH function returns the position of a specified value in a list. MATCH is often paired with INDEX to create a lookup more flexible than VLOOKUP.

• MID function returns a substring of text from within the middle of a larger string of text.

• MIN and MAX functions return the minimum and maximum numerical values from a group of numbers.

• SUBSTITUTE function replaces a string of text with another string of text.

• SUM function adds together different numerical values into a total.

• SUMIF function adds together all the numerical values which meet a user-specified criterion.

• SUMIFS function adds together all the numerical values which meet multiple user-specified criteria.

• TEXTJOIN function joins different strings of text with a common delimiter or separator between each string.

• TODAY function returns the current date.

• UPPER, LOWER, & PROPER functions change the case of text to uppercase, lowercase, and proper case.

• VLOOKUP function returns a corresponding value to the right of a specified lookup value in a table.

#### Projects

• UFO Dashboard - Learn to create an interactive dashboard in Excel showing UFO sightings by shape of UFO.

• Wine Dashboard - Learn to create an interactive dashboard in Excel showing wine consumption by country.