AND
Returns TRUE if all of its arguments are TRUE.
LogicalBeginner EssentialsLogic & ConditionsMost Used
Most Used
Most Used functions are the everyday tools of Excel. Master these first to solve the majority of common spreadsheet tasks quickly and confidently.
This collection groups Excel functions that are commonly used for most used workflows. Instead of browsing hundreds of formulas, you can focus on the exact tools that solve this type of task.
Each function page includes a short explanation and practical usage context. Use these functions as standalone tools or combine them to build more advanced, maintainable formulas.
If you frequently work with reports, dashboards, or recurring templates, bookmarking the key functions from this collection will speed up your day-to-day work.
Tips
- Learn the core syntax first, then practice by combining two functions at a time.
- When in doubt, start with a clear goal (e.g., sum, match, clean text) and pick the simplest function that gets you there.
Excel functions in this collection (43)
AVERAGE
Returns the average of its arguments.
StatisticalBeginner EssentialsMost UsedStatistics & Analysis
CLEAN
Removes all nonprintable characters from text.
TextBeginner EssentialsMost UsedText Cleaning
CONCAT
Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.
TextModern Excel FunctionsMost UsedText Processing
CONCATENATE
Joins several text items into one text item.
TextMost UsedText Processing
COUNT
Counts how many numbers are in the list of arguments.
StatisticalBeginner EssentialsMost UsedStatistics & Analysis
COUNTA
Counts how many values are in the list of arguments.
StatisticalBeginner EssentialsMost UsedStatistics & Analysis
COUNTIF
Counts the number of cells within a range that meet the given criteria.
StatisticalBeginner EssentialsMost UsedStatistics & Analysis
COUNTIFS
Counts the number of cells within a range that meet multiple criteria.
StatisticalMost UsedStatistics & Analysis
DATE
Returns the serial number of a particular date.
Date & TimeBeginner EssentialsDates & Time CalculationsMost Used
DAY
Converts a serial number to a day of the month.
Date & TimeDates & Time CalculationsMost Used
IF
Specifies a logical test to perform.
LogicalBeginner EssentialsLogic & ConditionsMost Used
IFERROR
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula.
LogicalBeginner EssentialsError Handling & ChecksLogic & Conditions
IFNA
Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression.
LogicalError Handling & ChecksLogic & ConditionsMost Used
IFS
Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.
LogicalLogic & ConditionsModern Excel FunctionsMost Used
INDEX
Uses an index to choose a value from a reference or array.
Lookup & ReferenceBeginner EssentialsLookup & Matching EssentialsMost Used
LEFT
Returns the leftmost characters from a text value.
TextBeginner EssentialsMost UsedText Processing
LEN
Returns the number of characters in a text string.
TextBeginner EssentialsMost UsedText Processing
MATCH
Looks up values in a reference or array.
Lookup & ReferenceBeginner EssentialsLookup & Matching EssentialsMost Used
MAX
Returns the maximum value in a list of arguments.
StatisticalBeginner EssentialsMost UsedStatistics & Analysis
MID
Returns a specific number of characters from a text string starting at the position you specify.
TextBeginner EssentialsMost UsedText Processing
MIN
Returns the minimum value in a list of arguments.
StatisticalBeginner EssentialsMost UsedStatistics & Analysis
MONTH
Converts a serial number to a month.
Date & TimeDates & Time CalculationsMost Used
NOT
Reverses the logic of its argument.
LogicalLogic & ConditionsMost Used
NOW
Returns the serial number of the current date and time.
Date & TimeBeginner EssentialsDates & Time CalculationsMost Used
OR
Returns TRUE if any argument is TRUE.
LogicalBeginner EssentialsLogic & ConditionsMost Used
RIGHT
Returns the rightmost characters from a text value.
TextBeginner EssentialsMost UsedText Processing
ROUND
Rounds a number to a specified number of digits.
Math & TrigonometryBeginner EssentialsMath BasicsMost Used
ROUNDDOWN
Rounds a number down, toward zero.
Math & TrigonometryMath BasicsMost Used
ROUNDUP
Rounds a number up, away from zero.
Math & TrigonometryMath BasicsMost Used
SUBSTITUTE
Substitutes new text for old text in a text string.
TextMost UsedText CleaningText Processing
SUM
Adds its arguments.
Math & TrigonometryBeginner EssentialsMath BasicsMost Used
SUMIF
Adds the cells specified by a given criteria.
Math & TrigonometryBeginner EssentialsMath BasicsMost Used
SUMIFS
Adds the cells in a range that meet multiple criteria.
Math & TrigonometryMath BasicsMost Used
TEXTJOIN
Combines the text from multiple ranges and/or strings.
TextModern Excel FunctionsMost UsedText Cleaning
TODAY
Returns the serial number of today's date.
Date & TimeBeginner EssentialsDates & Time CalculationsMost Used
TRIM
Removes spaces from text.
TextBeginner EssentialsMost UsedText Cleaning
VLOOKUP
Looks in the first column of an array and moves across the row to return the value of a cell.
Lookup & ReferenceBeginner EssentialsLookup & Matching EssentialsMost Used
WEEKDAY
Converts a serial number to a day of the week.
Date & TimeDates & Time CalculationsMost Used
WEEKNUM
Converts a serial number to a number representing where the week falls numerically with a year.
Date & TimeDates & Time CalculationsMost Used
XLOOKUP
Searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match.
Lookup & ReferenceBeginner EssentialsLookup & Matching EssentialsModern Excel Functions
XMATCH
Returns the relative position of an item in an array or range of cells.
Lookup & ReferenceLookup & Matching EssentialsModern Excel FunctionsMost Used
YEAR
Converts a serial number to a year.
Date & TimeDates & Time CalculationsMost Used