Excel Functions Guide
43 function guides with examples, explanations, and interactive practice.
Absolute Reference
An absolute reference, such as $A$1 is a reference to a cell that does not change no matter where the formula is pasted.
AVERAGE Function Examples and Practice
Learn how to use the AVERAGE function in Excel with real example formulas and practice exercises.
CONCAT Function
The CONCAT function in Excel joins separate values together into a single text string. Learn about this formula and practice some exercises.
COUNT Function Examples and Practice
Learn how to use the COUNT function in Excel with real example formulas and practice exercises.
COUNTIF Function
The COUNTIF function in Excel counts the number of cells that meet a certain criteria. Learn about this function and practice some exercises.
COUNTIFS Function
The COUNTIFS function in Excel counts the number of cells that meet multiple criteria. Learn about this function and practice some exercises.
Create a Drop Down List in Excel
Learn how to create a drop down list in Excel for data entry.
How to Extract the First Word From Text in Excel
Learn how to extract the first word from text in Excel, including examples and a simple formula you can copy and paste!
How to Extract the Last Word From Text in Excel
Learn how to extract the last word from text in Excel, including examples and a simple formula you can copy and paste!
FIND Function
The FIND function in Excel returns a number corresponding to the position of a substring of text within a larger string of text.
HLOOKUP Function
The HLOOKUP function in Excel stands for horizontal lookup. The function HLOOKUP searches for a value you specify in the top row of a table and returns a value from the same column.
Format Painter to Copy Formats
Learn how to use the Format Painter and copy formats from one cell to another.
Excel Exercises: IF Function Examples and Practice Exercises
The IF function in Excel returns one value if a condition is true, and another if the condition is false. Learn about this formula and practice some exercises.
IFS Function Examples and Practice
Learn how to use the IFS function in Excel with real example formulas and practice exercises.
Indeed Excel Assessment Practice
Learn how to ace Indeed's Excel Assessment to increase your chances of finding a job!
INDEX Function Examples and Practice
Learn how to use the INDEX function in Excel with real example formulas and practice exercises.
LARGE and SMALL Function
The LARGE and SMALL functions in Excel help you quickly find the 2nd largest or 3rd smallest numbers in a list. Learn about these functions and practice some exercises.
LEFT Function
The LEFT function in Excel returns a number of the leftmost characters from a larger string of text. Learn and try some Excel Exercises with this function.
LEN Function
The LEN function in Excel returns the length of a string of text. Learn and try some Excel Exercises with this function.
Len, Left, Right, Mid Functions
The LEN, LEFT, RIGHT, and MID functions in Excel let you work with strings of text. Learn and try some Excel Exercises with these functions.
Logical Functions: AND, OR, XOR, NOT
Logical functions in Excel let you add logic to your spreadsheet. Learn about these formulas and try some Excel Exercises.
Excel Logical Operators: Greater Than or Equal, Not Equal, etc.
Logical operators in Excel (<, >, =, <>, <=, >=) compare values. Greater than, greater than or equal, not equal, less than, less than or equal.
MATCH Function
The MATCH function in Excel provides the position of a cell with specified contents. Learn about this function and practice some exercises.
MID Function
The MID function in Excel returns a section of text from within a larger string of text. Learn and try some Excel Exercises with this function.
MIN and MAX Function
The MIN and MAX function in Excel help you quickly find the minimum and maximum. Learn about these functions and practice some exercises.
MO-200 Excel Exam Practice
Learn how to prepare for and pass Microsoft's MO-200 Excel certification exam.
MO-201 Excel Exam Practice
Learn how to prepare for Microsoft's MO-201 Excel certification exam.
SUBSTITUTE Function
The SUBSTITUTE function in Excel replaces a set of characters for a set of new characters within a string of text. Learn about this function and practice some exercises.
SUM Function Examples and Practice
Learn how to use the SUM function in Excel with real example formulas and practice exercises.
SUMIF Function
The SUMIF function in Excel sums the contents of cells that meet a certain criteria. Learn about this function and practice some exercises.
SUMIFS Function
The SUMIFS function in Excel finds the sum of cells that meet multiple criteria. Learn about this function and practice some exercises.
SWITCH Function Examples and Practice
Learn how to use the SWITCH function in Excel with real example formulas and practice exercises.
TEXTJOIN Function
The TEXTJOIN function in Excel joins separate values together separated by a common delimiter. Learn about this formula and practice some exercises.
TODAY Function
The TODAY function in Excel returns the current date. Learn and try some Excel Exercises with this function.
Change Case of Text to Upper, Lower, & Proper
Learn how to change the case of text in Excel to uppercase, lowercase, and proper case.
VLOOKUP Function Examples and Practice
Learn how to use the VLOOKUP function in Excel with real example formulas and practice exercises.
Wildcard Examples and Practice
Learn how to use the wildcard characters in Excel with real example formulas and practice exercises.
XLOOKUP Function
Learn how to use the XLOOKUP Function in Excel.
INDEX MATCH: The Most Powerful Lookup in Excel
Learn INDEX MATCH step by step — the most powerful Excel lookup. Covers left lookup, two-criteria, INDEX MATCH MATCH, and why it beats VLOOKUP.
Excel Text Functions: Complete Guide to LEFT, MID, RIGHT, LEN, TRIM, SUBSTITUTE and More
Master Excel text functions: LEFT, MID, RIGHT, LEN, TRIM, UPPER, LOWER, SUBSTITUTE, REPLACE, FIND, SEARCH, CONCAT, TEXTJOIN, and TEXT with examples.
Excel Lookup Functions: LOOKUP, INDIRECT, OFFSET Explained
Learn Excel's LOOKUP, INDIRECT, and OFFSET functions with clear examples. Know when to use each versus VLOOKUP or XLOOKUP for dynamic references.
Excel Math Functions: MIN, MAX, ROUND, MOD, ABS, LARGE, SMALL
Learn Excel math functions: MIN, MAX, ROUND, ROUNDUP, ROUNDDOWN, INT, MOD, ABS, LARGE, SMALL, RANK, CEILING, and FLOOR with examples.
Excel Date Functions: TODAY, NOW, DATE, DATEDIF, DAYS, EOMONTH and More
Master Excel date functions: TODAY, NOW, DATE, DATEDIF, DAYS, EOMONTH, EDATE, WEEKDAY, WORKDAY, and TEXT for date formatting with examples.