Excel Formula & Shortcut Finder

SUM

Math & Trigonometry

Adds all the numbers in a range of cells.

Pro Tip: SUM ignores text and logical values in ranges, but evaluates them if typed directly as arguments. Use SUMPRODUCT for conditional sums without helper columns.

SUMIF

Math & Trigonometry

Adds cells that meet a single condition.

Pro Tip: If sum_range is omitted, the criteria range is summed. Wildcards * and ? work in text criteria.

SUMIFS

Math & Trigonometry

Adds cells that meet multiple conditions.

Pro Tip: Unlike SUMIF, the sum_range comes FIRST in SUMIFS. All criteria ranges must be the same size as the sum range.

SUMPRODUCT

Math & Trigonometry

Multiplies corresponding elements in arrays and returns the sum of those products.

Pro Tip: SUMPRODUCT is one of the most versatile functions in Excel. It can replicate SUMIFS, COUNTIFS, and weighted averages all in one formula. Before XLOOKUP, it was the go-to for complex lookups.

ROUND

Math & Trigonometry

Rounds a number to a specified number of digits.

Pro Tip: Use negative num_digits to round to the left of the decimal (tens, hundreds, etc.). ROUND uses standard rounding (0.5 rounds up).

ROUNDUP

Math & Trigonometry

Rounds a number up, away from zero.

Pro Tip: ROUNDUP always rounds away from zero, so negative numbers become more negative. Use CEILING if you want to round up toward positive infinity instead.

ROUNDDOWN

Math & Trigonometry

Rounds a number down, toward zero.

Pro Tip: ROUNDDOWN is equivalent to TRUNC for positive numbers. For financial calculations where you must truncate, ROUNDDOWN is preferred over INT because INT always rounds toward negative infinity.

INT

Math & Trigonometry

Rounds a number down to the nearest integer.

Pro Tip: INT rounds toward negative infinity, not toward zero. For -5.7, INT returns -6 while TRUNC returns -5. Use TRUNC if you want to simply remove decimals.

MOD

Math & Trigonometry

Returns the remainder after division.

Pro Tip: MOD is perfect for alternating patterns (even/odd rows), creating repeating sequences, or checking divisibility. Combine with ROW() for banded formatting logic.

ABS

Math & Trigonometry

Returns the absolute value of a number (removes the sign).

Pro Tip: Use ABS to calculate the magnitude of differences regardless of direction, such as variance analysis or distance calculations.

POWER

Math & Trigonometry

Returns a number raised to a power.

Pro Tip: You can also use the caret operator: 2^10 is equivalent to POWER(2,10). Use fractional powers for roots (1/2 for square root, 1/3 for cube root).

SQRT

Math & Trigonometry

Returns the positive square root of a number.

Pro Tip: SQRT returns #NUM! for negative numbers. Use SQRT(ABS(number)) if the input might be negative, or POWER(number, 1/2) for the same result.

CEILING

Math & Trigonometry

Rounds a number up to the nearest multiple of significance.

Pro Tip: Use CEILING for pricing (round up to nearest $0.99), time rounding (nearest 15 minutes), or inventory (round up to nearest case quantity).

FLOOR

Math & Trigonometry

Rounds a number down to the nearest multiple of significance.

Pro Tip: FLOOR is great for time-rounding (billing in 15-minute increments) and binning data into groups (age ranges, price brackets).

RAND

Math & Trigonometry

Returns a random decimal number between 0 (inclusive) and 1 (exclusive). Recalculates on every worksheet change.

Pro Tip: RAND recalculates every time the sheet changes. To freeze random values, copy the cells and Paste Special > Values. For reproducible results, consider RANDARRAY in Excel 365.

RANDBETWEEN

Math & Trigonometry

Returns a random integer between two specified numbers.

Pro Tip: Both bottom and top are inclusive. For random dates, use RANDBETWEEN with DATE functions: =RANDBETWEEN(DATE(2024,1,1), DATE(2024,12,31)).

AVERAGE

Statistical

Returns the arithmetic mean of its arguments.

Pro Tip: AVERAGE ignores empty cells but treats a cell containing 0 as a value. If you need to exclude zeros, use AVERAGEIF(range,"<>0").

AVERAGEIF

Statistical

Returns the average of cells that meet a single condition.

Pro Tip: If average_range is omitted, the criteria range is averaged. Wildcards (* and ?) are supported in text criteria.

AVERAGEIFS

Statistical

Returns the average of cells that meet multiple conditions.

Pro Tip: Like SUMIFS, the target range comes first. All criteria ranges must be the same size as the average range.

MEDIAN

Statistical

Returns the middle number in a sorted set of values.

Pro Tip: Median is less affected by outliers than AVERAGE. For salary data or house prices, median is usually more representative than mean.

MODE

Statistical

Returns the most frequently occurring value in a dataset.

Pro Tip: MODE returns only the first mode found. For datasets with multiple modes, use MODE.MULT as an array formula to return all modal values.

COUNT

Statistical

Counts the number of cells that contain numbers.

Pro Tip: COUNT only counts numbers. Use COUNTA for non-blank cells, COUNTBLANK for empty cells, or COUNTIF for cells matching criteria.

COUNTA

Statistical

Counts the number of non-empty cells in a range.

Pro Tip: COUNTA counts cells with formulas that return empty strings ("") as non-blank. To avoid this, use SUMPRODUCT((A1:A100<>"")*1).

COUNTBLANK

Statistical

Counts the number of empty cells in a range.

Pro Tip: COUNTBLANK treats cells with formulas returning "" (empty string) as blank. This differs from COUNTA which counts them as non-blank.

COUNTIF

Statistical

Counts the number of cells that meet a single condition.

Pro Tip: Use COUNTIF to find duplicates: =COUNTIF(A:A, A1)>1 returns TRUE if A1 is duplicated. Wildcards * (any characters) and ? (single character) work in criteria.

COUNTIFS

Statistical

Counts cells that meet multiple conditions across ranges.

Pro Tip: Use the same range for multiple criteria to create between conditions (e.g., dates between two values, numbers in a range).

MAX

Statistical

Returns the largest value in a set of numbers.

Pro Tip: MAX ignores text and logical values in ranges. Use MAXA if you need TRUE=1 and FALSE=0 to be included.

MAXIFS

Statistical

Returns the maximum value among cells that meet one or more conditions.

Pro Tip: MAXIFS was introduced in Excel 2019/365. For older versions, use MAX(IF(criteria, range)) entered as an array formula with Ctrl+Shift+Enter.

MIN

Statistical

Returns the smallest value in a set of numbers.

Pro Tip: MIN ignores empty cells and text. To find the smallest positive number, use MIN(IF(A1:A100>0, A1:A100)) as a Ctrl+Shift+Enter array formula.

MINIFS

Statistical

Returns the minimum value among cells that meet one or more conditions.

Pro Tip: Like MAXIFS, this is an Excel 2019+ function. For older versions, use MIN(IF()) entered with Ctrl+Shift+Enter.

LARGE

Statistical

Returns the k-th largest value in a dataset.

Pro Tip: Combine LARGE with INDEX/MATCH to return data associated with the top N values. LARGE(range,1) = MAX(range), LARGE(range,2) = second highest, etc.

SMALL

Statistical

Returns the k-th smallest value in a dataset.

Pro Tip: Use SMALL with ROWS for a sorted ascending list. Combine with IF for conditional smallest: =SMALL(IF(B:B="Sales",C:C),1) in an array formula.

RANK

Statistical

Returns the rank of a number in a list (1 = highest by default).

Pro Tip: RANK gives duplicate values the same rank and skips subsequent ranks. For unique ranks with tiebreakers, use RANK(A1,$A:$A)+COUNTIF($A$1:A1,A1)-1.

STDEV

Statistical

Estimates standard deviation based on a sample (ignores text and logical values).

Pro Tip: STDEV is for samples (uses n-1 denominator). Use STDEVP for entire populations (uses n denominator). In most real-world cases, STDEV is correct since you're working with a sample.

VAR

Statistical

Estimates variance based on a sample.

Pro Tip: Variance is the square of standard deviation. Use VAR.S (sample) or VAR.P (population) for the modern versions of this function.

FREQUENCY

Statistical

Returns a frequency distribution as a vertical array, showing how often values fall within specified ranges.

Pro Tip: FREQUENCY returns one more value than the number of bins (the last element counts values above the highest bin). In Excel 365, it spills automatically; in older versions, select the output range and press Ctrl+Shift+Enter.

LEFT

Text

Extracts a specified number of characters from the start of a text string.

Pro Tip: If num_chars is omitted, it defaults to 1. Combine with FIND or SEARCH to dynamically extract text before a delimiter.

RIGHT

Text

Extracts a specified number of characters from the end of a text string.

Pro Tip: To extract text after the last delimiter, use: =RIGHT(A1, LEN(A1)-FIND("@",SUBSTITUTE(A1,"@","@",LEN(A1)-LEN(SUBSTITUTE(A1,"@",""))))).

MID

Text

Extracts characters from the middle of a text string, given a starting position and length.

Pro Tip: Combine with FIND to extract text between delimiters dynamically. MID starts counting at 1 (not 0).

LEN

Text

Returns the number of characters in a text string.

Pro Tip: Use LEN to validate data entry (e.g., phone numbers must be 10 digits). Combine with SUBSTITUTE to count occurrences: =LEN(A1)-LEN(SUBSTITUTE(A1,",","")) counts commas.

FIND

Text

Finds the position of a substring within text (case-sensitive).

Pro Tip: FIND is case-sensitive; use SEARCH for case-insensitive matching. FIND returns #VALUE! if the text is not found -- wrap in IFERROR to handle missing matches.

SEARCH

Text

Finds the position of a substring within text (case-insensitive, supports wildcards).

Pro Tip: SEARCH supports wildcards (* and ?), while FIND does not. Use SEARCH when you do not care about case or need pattern matching.

SUBSTITUTE

Text

Replaces occurrences of a specified substring with new text.

Pro Tip: Use SUBSTITUTE to count character occurrences: =LEN(A1)-LEN(SUBSTITUTE(A1,char,"")). Unlike REPLACE, SUBSTITUTE works with specific text rather than character positions.

REPLACE

Text

Replaces part of a text string with a different string, based on position.

Pro Tip: REPLACE works by character position; SUBSTITUTE works by matching text. Use REPLACE when you know the exact position, SUBSTITUTE when you know the text to replace.

TRIM

Text

Removes extra spaces from text, leaving only single spaces between words.

Pro Tip: TRIM only removes ASCII space (char 32). Data from the web often contains non-breaking spaces (char 160). Use SUBSTITUTE(A1,CHAR(160)," ") before TRIM, or =TRIM(CLEAN(SUBSTITUTE(A1,CHAR(160)," "))) for a thorough clean.

CLEAN

Text

Removes all non-printable characters (ASCII 0-31) from text.

Pro Tip: CLEAN only removes ASCII control characters (0-31). For Unicode non-printable characters, you may need additional SUBSTITUTE functions.

LOWER

Text

Converts all characters in a text string to lowercase.

Pro Tip: Combine with TRIM for consistent data: =LOWER(TRIM(A1)). Useful for normalizing email addresses and creating case-insensitive comparisons.

UPPER

Text

Converts all characters in a text string to uppercase.

Pro Tip: Use UPPER for standardizing product codes, state abbreviations, or any field that should be all caps.

PROPER

Text

Capitalizes the first letter of each word in a text string.

Pro Tip: PROPER capitalizes after every non-letter character, so "o'brien" becomes "O'Brien" (correct) but "McDonald" stays "Mcdonald" (incorrect). Review results for proper nouns.

CONCATENATE

Text

Joins two or more text strings into one string.

Pro Tip: CONCATENATE is being replaced by CONCAT and TEXTJOIN in modern Excel. The ampersand (&) operator also concatenates: =A1&" "&B1 is equivalent.

CONCAT

Text

Joins text from multiple ranges and/or strings. Replaces CONCATENATE with range support.

Pro Tip: CONCAT can accept ranges (unlike CONCATENATE) but cannot insert delimiters. For joining with a separator, use TEXTJOIN instead.

TEXTJOIN

Text

Joins text from multiple ranges with a delimiter, with an option to ignore empty cells.

Pro Tip: TEXTJOIN is the modern way to combine text. Set ignore_empty to TRUE to skip blanks. It accepts ranges, making it far more convenient than CONCATENATE for large datasets.

TEXT

Text

Converts a number to text with a specified format.

Pro Tip: TEXT is essential when combining formatted numbers with text. Without it, dates become serial numbers and percentages become decimals in concatenated strings.

VALUE

Text

Converts a text string that looks like a number into an actual number.

Pro Tip: VALUE is often needed after text manipulation (LEFT, RIGHT, MID) to convert extracted text back to numbers for calculations. In many cases, multiplying by 1 or adding 0 also works.

VLOOKUP

Lookup & Reference

Searches for a value in the first column of a table and returns a value in the same row from another column.

Pro Tip: Always use FALSE for the last argument unless you need approximate matching with sorted data. VLOOKUP can only look right -- use INDEX/MATCH or XLOOKUP to look left. Consider switching to XLOOKUP for new formulas.

HLOOKUP

Lookup & Reference

Searches for a value in the first row of a table and returns a value in the same column from another row.

Pro Tip: HLOOKUP works like VLOOKUP but horizontally. It is rarely used compared to VLOOKUP. Consider INDEX/MATCH or XLOOKUP for more flexible lookups.

XLOOKUP

Lookup & Reference

Searches a range or array and returns a matching item. The modern replacement for VLOOKUP, HLOOKUP, and INDEX/MATCH.

Pro Tip: XLOOKUP defaults to exact match (unlike VLOOKUP which defaults to approximate). It can look in any direction, return multiple columns, and has a built-in not-found handler. This should be your go-to lookup function.

INDEX

Lookup & Reference

Returns the value at a given position in a range or array.

Pro Tip: INDEX/MATCH is more flexible than VLOOKUP: it can look left, is not affected by column insertions, and works with two-way lookups. Pair with MATCH for powerful dynamic lookups.

MATCH

Lookup & Reference

Returns the relative position of a value in a range.

Pro Tip: Use match_type 0 for exact match, 1 for largest value less than or equal (sorted ascending), -1 for smallest value greater than or equal (sorted descending). MATCH is most commonly paired with INDEX.

XMATCH

Lookup & Reference

Returns the relative position of a value in an array. Modern replacement for MATCH with more features.

Pro Tip: XMATCH defaults to exact match (unlike MATCH). It supports wildcard matching (mode 2) and binary search (mode 1 or -1) for faster lookups in sorted data.

CHOOSE

Lookup & Reference

Returns a value from a list based on an index number.

Pro Tip: CHOOSE can return ranges for use in other functions like SUM or VLOOKUP. This allows dynamic range selection based on a condition.

INDIRECT

Lookup & Reference

Converts a text string into a cell reference.

Pro Tip: INDIRECT is powerful for creating references to other sheets dynamically or building data validation lists from named ranges. However, it is volatile (recalculates every time) and can slow down large workbooks.

OFFSET

Lookup & Reference

Returns a reference offset from a starting cell by a given number of rows and columns.

Pro Tip: OFFSET is volatile and recalculates every time the sheet changes, which can impact performance. For dynamic ranges in modern Excel, prefer structured tables or the dynamic array functions (FILTER, SORT).

ROW

Lookup & Reference

Returns the row number of a cell reference.

Pro Tip: ROW() with no arguments returns the current row number. Useful for creating sequential numbering that adjusts when rows are inserted or deleted.

COLUMN

Lookup & Reference

Returns the column number of a cell reference.

Pro Tip: Use COLUMN() to create dynamic column references in INDEX formulas or to auto-number columns in headers.

TRANSPOSE

Lookup & Reference

Converts a vertical range to horizontal or vice versa (swaps rows and columns).

Pro Tip: In Excel 365, TRANSPOSE spills automatically. In older versions, select the output range, type the formula, and press Ctrl+Shift+Enter. You can also Paste Special > Transpose for a one-time conversion.

IF

Logical

Returns one value if a condition is TRUE and another if it is FALSE.

Pro Tip: Avoid deeply nested IFs (more than 3-4 levels). Use IFS, SWITCH, or XLOOKUP for cleaner alternatives. The value_if_false defaults to FALSE if omitted.

IFS

Logical

Evaluates multiple conditions and returns the value corresponding to the first TRUE condition.

Pro Tip: Use TRUE as the final condition to create a default/else value. IFS evaluates conditions in order and returns the first match, so put the most specific conditions first.

AND

Logical

Returns TRUE if all arguments are TRUE.

Pro Tip: AND is most useful inside IF functions to check multiple conditions simultaneously. It short-circuits internally but all arguments are evaluated.

OR

Logical

Returns TRUE if any argument is TRUE.

Pro Tip: OR returns TRUE if at least one condition is met. Combine with IF for either/or logic. For checking if a value is one of many options, consider MATCH or XLOOKUP instead of long OR chains.

NOT

Logical

Reverses the logic of its argument: TRUE becomes FALSE and vice versa.

Pro Tip: NOT is handy for flipping conditions in FILTER or conditional formatting. Instead of =IF(NOT(A1=""),...), you can often just write =IF(A1<>"",...).

XOR

Logical

Returns TRUE if an odd number of arguments are TRUE (exclusive OR).

Pro Tip: XOR is useful for toggle logic or validation rules where exactly one of two options should be selected (but not both and not neither).

IFERROR

Logical

Returns the value if no error, otherwise returns the specified fallback value. Catches all error types.

Pro Tip: IFERROR catches ALL errors (#N/A, #VALUE!, #REF!, #DIV/0!, #NAME?, #NULL!, #NUM!). If you only want to catch #N/A (common with lookups), use IFNA instead for more precise error handling.

IFNA

Logical

Returns the value if it is not #N/A, otherwise returns the specified fallback. Only catches #N/A errors.

Pro Tip: Prefer IFNA over IFERROR for lookups. IFERROR masks all errors, which can hide real problems like #REF! from deleted columns. IFNA only catches the expected #N/A from failed lookups.

SWITCH

Logical

Evaluates an expression against a list of values and returns the result for the first match.

Pro Tip: SWITCH is cleaner than nested IFs when comparing one expression against multiple exact values. The last argument (with no matching value) serves as the default. For range-based conditions, use IFS instead.

LET

Logical

Assigns names to calculation results within a formula, improving readability and performance.

Pro Tip: LET improves formula performance by calculating a sub-expression once and reusing it. It also makes complex formulas much more readable. The last argument is always the final calculation.

LAMBDA

Logical

Creates custom reusable functions that can be called by name or passed to other functions.

Pro Tip: Name your LAMBDA in the Name Manager to create a custom function you can call like =HYPOTENUSE(3,4). LAMBDA functions can also be passed to MAP, REDUCE, and SCAN for powerful array operations.

TRUE

Logical

Returns the logical value TRUE.

Pro Tip: You can usually type TRUE directly without the function. TRUE() is mainly useful in contexts requiring a function rather than a constant.

FALSE

Logical

Returns the logical value FALSE.

Pro Tip: Like TRUE(), you can usually type FALSE directly. These functions exist mainly for compatibility and programmatic use.

TODAY

Date & Time

Returns the current date (updates each time the worksheet recalculates).

Pro Tip: TODAY() is volatile and updates on every recalculation. For a static date that does not change, press Ctrl+; (semicolon) to insert today's date as a value.

NOW

Date & Time

Returns the current date and time (updates each time the worksheet recalculates).

Pro Tip: NOW() includes the time component. Use TODAY() if you only need the date. For a static timestamp, press Ctrl+; for date or Ctrl+Shift+; for time.

DATE

Date & Time

Creates a date from individual year, month, and day components.

Pro Tip: DATE handles overflow gracefully: DATE(2024,13,1) returns January 1, 2025. This makes month and date arithmetic easy without worrying about boundaries.

DATEVALUE

Date & Time

Converts a date stored as text into an Excel date serial number.

Pro Tip: DATEVALUE is useful when dates imported from external sources are stored as text. The recognized date formats depend on your system's regional settings.

DAY

Date & Time

Returns the day of the month from a date (1-31).

Pro Tip: Combine DAY, MONTH, and YEAR to decompose dates for custom formatting or calculations. DAY(DATE(year,month+1,0)) gives the last day of any month.

MONTH

Date & Time

Returns the month from a date (1-12).

Pro Tip: Use TEXT(A1,"MMMM") for the full month name or TEXT(A1,"MMM") for the abbreviation instead of a CHOOSE/SWITCH with MONTH.

YEAR

Date & Time

Returns the year from a date.

Pro Tip: For accurate age or year difference calculations, use DATEDIF instead of subtracting YEAR values, since YEAR subtraction does not account for month and day.

HOUR

Date & Time

Returns the hour component from a time value (0-23).

Pro Tip: Excel stores times as decimal fractions of a day. 0.5 = 12:00 PM. Use HOUR, MINUTE, SECOND to extract components from time values.

MINUTE

Date & Time

Returns the minute component from a time value (0-59).

Pro Tip: To round a time to the nearest 15 minutes, use MROUND or FLOOR/CEILING with TIME(0,15,0) as the significance.

SECOND

Date & Time

Returns the second component from a time value (0-59).

Pro Tip: For sub-second precision, Excel times are limited to about 3 decimal places of precision (milliseconds). For higher precision, store values as numbers rather than times.

EDATE

Date & Time

Returns a date that is a specified number of months before or after a start date.

Pro Tip: EDATE handles month-end dates intelligently: EDATE(Jan 31, 1) returns Feb 28/29. Use negative months to go backward. Essential for loan schedules and contract dates.

EOMONTH

Date & Time

Returns the last day of the month, a specified number of months before or after a date.

Pro Tip: EOMONTH(date,0) gives the last day of the date's month. EOMONTH(date,-1)+1 gives the first day of the date's month. These are extremely useful for monthly reporting.

NETWORKDAYS

Date & Time

Returns the number of working days (excluding weekends and optional holidays) between two dates.

Pro Tip: NETWORKDAYS counts both the start and end dates. For custom weekends (e.g., Friday-Saturday), use NETWORKDAYS.INTL and specify the weekend pattern.

WORKDAY

Date & Time

Returns a date that is a specified number of working days before or after a start date.

Pro Tip: Use WORKDAY for calculating delivery dates, SLA deadlines, or project milestones. For custom weekends, use WORKDAY.INTL.

DATEDIF

Date & Time

Calculates the difference between two dates in years, months, or days. A hidden function not in the function wizard.

Pro Tip: DATEDIF is undocumented in modern Excel but still works. Units: Y (years), M (months), D (days), YM (months ignoring years), MD (days ignoring months/years), YD (days ignoring years). It is the best way to calculate age.

WEEKDAY

Date & Time

Returns the day of the week as a number.

Pro Tip: The return_type argument changes which day is 1: use 1 for Sunday=1, 2 for Monday=1, 3 for Monday=0. Combine with CHOOSE or SWITCH for day names.

WEEKNUM

Date & Time

Returns the week number of a date within the year.

Pro Tip: Use return_type 21 for ISO 8601 week numbering (used in Europe and most international contexts). Alternatively, use ISOWEEKNUM for the same result.

PMT

Financial

Calculates the periodic payment for a loan or investment based on constant payments and a constant interest rate.

Pro Tip: The rate must match the payment period (monthly rate for monthly payments = annual rate / 12). PV is typically negative (money you borrow). PMT returns a negative number for payments you make.

FV

Financial

Calculates the future value of an investment based on periodic, constant payments and a constant interest rate.

Pro Tip: Use negative values for cash outflows (payments you make). Set pmt to 0 for lump-sum investments. The result shows what your investment will be worth at the end.

PV

Financial

Calculates the present value of a series of future payments or a lump sum.

Pro Tip: PV answers: how much is a future income stream worth today? It is the core function behind discounted cash flow (DCF) analysis and bond pricing.

NPV

Financial

Calculates the net present value of an investment based on a discount rate and a series of future cash flows.

Pro Tip: NPV assumes cash flows occur at the END of each period, starting from period 1. If you have an initial investment at time 0, add it separately: =NPV(rate, future_flows) + initial_investment.

IRR

Financial

Calculates the internal rate of return for a series of cash flows.

Pro Tip: The values must contain at least one negative and one positive number. If IRR does not converge, try providing a guess close to the expected rate. For irregular cash flow dates, use XIRR.

RATE

Financial

Calculates the interest rate per period for a loan or investment.

Pro Tip: RATE returns the per-period rate. Multiply by 12 for the annual rate on monthly loans. Provide a guess (default 10%) if the function does not converge.

NPER

Financial

Calculates the number of payment periods for a loan or investment.

Pro Tip: Divide the result by 12 to convert monthly periods to years. NPER helps answer questions like: how long until my loan is paid off? or how long until I reach my savings goal?

SLN

Financial

Calculates the straight-line depreciation of an asset for one period.

Pro Tip: SLN is the simplest depreciation method: (cost - salvage) / life. For accelerated depreciation, use DDB (double declining balance) or SYD (sum of years digits).

EFFECT

Financial

Converts a nominal annual interest rate to an effective annual rate, given the number of compounding periods per year.

Pro Tip: Use EFFECT to compare loans or investments with different compounding frequencies. A 6% rate compounded monthly is actually higher than 6% compounded annually.

NOMINAL

Financial

Converts an effective annual interest rate to a nominal rate, given the number of compounding periods per year.

Pro Tip: NOMINAL is the inverse of EFFECT. Use it when you know the effective rate (APY) and need to find the stated/nominal rate (APR).

ISBLANK

Information

Returns TRUE if the cell is empty.

Pro Tip: ISBLANK returns FALSE for cells containing formulas that return empty strings (""). To check for both blank and empty strings, use A1="" instead.

ISERROR

Information

Returns TRUE if the value is any error (#N/A, #VALUE!, #REF!, #DIV/0!, #NAME?, #NULL!, #NUM!).

Pro Tip: In modern Excel, use IFERROR instead of IF(ISERROR(),...). IFERROR is more concise and only evaluates the formula once. Use ISERROR mainly in conditional formatting rules.

ISNUMBER

Information

Returns TRUE if the value is a number.

Pro Tip: ISNUMBER combined with SEARCH is a classic pattern for case-insensitive text containment checks: =ISNUMBER(SEARCH("text",A1)). Works great in conditional formatting.

ISTEXT

Information

Returns TRUE if the value is text.

Pro Tip: ISTEXT returns TRUE for cells containing text, including numbers stored as text (which can cause calculation issues). Use it to identify problematic data.

TYPE

Information

Returns a number indicating the data type of a value (1=number, 2=text, 4=logical, 16=error, 64=array).

Pro Tip: TYPE is useful for debugging formulas and understanding what type of data a cell actually contains, especially with imported data that may have unexpected types.

CELL

Information

Returns information about the formatting, location, or contents of a cell.

Pro Tip: Common info_type values: address, col, row, filename, format, width, type, protect. CELL("filename") is a classic way to get the current workbook path in a formula.

ISFORMULA

Information

Returns TRUE if the referenced cell contains a formula.

Pro Tip: ISFORMULA is useful for auditing spreadsheets to find which cells contain formulas vs. hardcoded values. Combine with conditional formatting to highlight all formula cells.

ISNA

Information

Returns TRUE if the value is the #N/A error.

Pro Tip: Use IFNA instead of IF(ISNA(),...) for cleaner syntax. ISNA is best used in conditional formatting or when you specifically need to detect only #N/A errors and not other error types.

FILTER

Dynamic Array

Filters an array based on a Boolean array (criteria) and returns the matching rows/columns.

Pro Tip: Use * for AND conditions and + for OR conditions between Boolean arrays. Always include an if_empty value to avoid #CALC! errors when no rows match. FILTER replaces many complex INDEX/MATCH patterns.

SORT

Dynamic Array

Sorts the contents of a range or array in ascending or descending order.

Pro Tip: SORT returns a dynamic spill array that updates automatically. Nest FILTER inside SORT to filter and sort in one formula. Use sort_order 1 for ascending, -1 for descending.

SORTBY

Dynamic Array

Sorts an array based on the values in one or more corresponding arrays.

Pro Tip: SORTBY is more flexible than SORT because you can sort by columns not in the output array, and easily do multi-level sorts. It is the formula equivalent of clicking multiple sort levels in the Sort dialog.

UNIQUE

Dynamic Array

Returns unique values from a range or array.

Pro Tip: Set exactly_once to TRUE to return values that appear only once (not just distinct values). Combine with SORT for a sorted unique list: =SORT(UNIQUE(A1:A100)).

SEQUENCE

Dynamic Array

Generates a sequence of numbers in an array.

Pro Tip: SEQUENCE replaces helper columns of sequential numbers. Use it with INDEX for dynamic row references, or as a dates sequence for timelines. Start and step can be decimals or dates.

RANDARRAY

Dynamic Array

Returns an array of random numbers with specified dimensions and range.

Pro Tip: Set whole_number to TRUE for integers. RANDARRAY is volatile and recalculates on every change. For reproducible random data, generate once and paste as values.

TOCOL

Dynamic Array

Converts a 2D array into a single column.

Pro Tip: Use ignore parameter: 0 = keep all, 1 = ignore blanks, 2 = ignore errors, 3 = ignore blanks and errors. TOCOL is the inverse of WRAPROWS/WRAPCOLS.

TOROW

Dynamic Array

Converts a 2D array into a single row.

Pro Tip: TOROW and TOCOL are extremely useful for combining with TEXTJOIN to create comma-separated lists from 2D ranges, or for feeding reshaped data into other array functions.

AGGREGATE

Math & Trigonometry

Performs one of 19 aggregate calculations (SUM, AVERAGE, COUNT, etc.) with options to ignore errors, hidden rows, or nested functions.

Pro Tip: AGGREGATE is the Swiss Army knife of calculation functions. It can replicate SUM, AVERAGE, COUNT, MIN, MAX, LARGE, SMALL, and more while ignoring errors or hidden rows. Option 5 ignores hidden rows, option 6 ignores errors.

SUBTOTAL

Math & Trigonometry

Performs a specified calculation (SUM, AVERAGE, COUNT, etc.) and can ignore manually hidden rows.

Pro Tip: Function numbers 1-11 ignore rows hidden by filter but include manually hidden rows. Add 100 (101-111) to also ignore manually hidden rows. SUBTOTAL ignores other SUBTOTAL values in the range, preventing double-counting.

PERCENTILE

Statistical

Returns the k-th percentile of values in a range (k is between 0 and 1).

Pro Tip: Use PERCENTILE for performance thresholds (e.g., 95th percentile response time). PERCENTILE(range, 0.25) and PERCENTILE(range, 0.75) give you the interquartile range boundaries.

MROUND

Math & Trigonometry

Rounds a number to the nearest specified multiple.

Pro Tip: MROUND rounds to the nearest multiple (up or down). Use CEILING for always up, FLOOR for always down. It is perfect for pricing to the nearest $0.50 or time to the nearest quarter hour.

TRUNC

Math & Trigonometry

Truncates a number to a specified number of decimal places without rounding.

Pro Tip: TRUNC simply chops off digits without rounding. For positive numbers, TRUNC and INT give the same result. For negative numbers, TRUNC rounds toward zero while INT rounds toward negative infinity.

ADDRESS

Lookup & Reference

Creates a cell address as text, given row and column numbers.

Pro Tip: ADDRESS creates text, not an actual reference. Wrap it in INDIRECT to use it as a reference: =INDIRECT(ADDRESS(row,col)). The abs_num parameter controls mixed/absolute references.

ROWS

Lookup & Reference

Returns the number of rows in a reference or array.

Pro Tip: ROWS is useful in formulas that need to know the size of a dynamic range. Combine with SEQUENCE or INDEX for dynamic range calculations.

COLUMNS

Lookup & Reference

Returns the number of columns in a reference or array.

Pro Tip: Use COLUMNS to make formulas adapt automatically to table width changes, especially in summary formulas that span entire tables.

FORMULATEXT

Lookup & Reference

Returns the formula in a cell as a text string.

Pro Tip: FORMULATEXT is excellent for documentation, training sheets, or auditing. It returns #N/A if the referenced cell does not contain a formula.

EXACT

Text

Checks whether two text strings are exactly the same (case-sensitive).

Pro Tip: Normal Excel comparisons (A1=B1) are case-insensitive. Use EXACT when case matters, such as validating passwords, product codes, or case-sensitive IDs.

CHAR

Text

Returns the character specified by a code number (ASCII/ANSI).

Pro Tip: CHAR(10) is a line break -- essential for multi-line cell content in formulas. CHAR(9) is a tab. Combine with CODE to encode/decode characters.

CODE

Text

Returns the numeric code for the first character in a text string.

Pro Tip: CODE is the inverse of CHAR. Use it to identify hidden/special characters in imported data or to create custom sorting logic based on character codes.

REPT

Text

Repeats text a given number of times.

Pro Tip: REPT is great for creating simple in-cell bar charts (sparklines made of text characters), padding strings, or generating visual indicators based on values.

NUMBERVALUE

Text

Converts text to a number, with control over decimal and thousands separators.

Pro Tip: NUMBERVALUE is essential when working with international data where decimal and thousands separators differ from your system settings. It handles %, which VALUE does not.

TIME

Date & Time

Creates a time value from individual hour, minute, and second components.

Pro Tip: TIME handles overflow: TIME(25,0,0) wraps to 1:00 AM. Excel stores time as a decimal fraction of a day (0.5 = 12:00 PM). Use TIME values in FLOOR/CEILING for rounding times to intervals.

TIMEVALUE

Date & Time

Converts a time stored as text into a decimal number that Excel recognizes as a time.

Pro Tip: TIMEVALUE is useful when times are imported as text strings. The result is a decimal between 0 (midnight) and 0.99999 (11:59:59 PM). Format the cell as Time to display correctly.

DAYS

Date & Time

Returns the number of days between two dates.

Pro Tip: DAYS is simply end_date - start_date. You can also subtract dates directly: =B1-A1. DAYS exists mainly for clarity and readability in formulas.

QUOTIENT

Math & Trigonometry

Returns the integer portion of a division (discards the remainder).

Pro Tip: QUOTIENT is equivalent to INT(A/B) for positive numbers. Use it with MOD for clean division: QUOTIENT gives the whole part, MOD gives the remainder.

LOG

Math & Trigonometry

Returns the logarithm of a number to a specified base (default is 10).

Pro Tip: Use LOG for base-10, LOG(n,2) for binary logarithms, and LN for natural logarithms (base e). Logarithms are essential for growth rate analysis and data normalization.

EXP

Math & Trigonometry

Returns e raised to the power of a given number.

Pro Tip: EXP is the inverse of LN. It is used in exponential growth models, continuous compounding calculations, and probability distributions.

LN

Math & Trigonometry

Returns the natural logarithm (base e) of a number.

Pro Tip: LN is used in continuous compounding, growth rate calculations, and statistics. To convert between log bases: LOG_b(x) = LN(x) / LN(b).

WRAPROWS

Dynamic Array

Wraps a one-dimensional array into a 2D array with a specified number of columns.

Pro Tip: WRAPROWS is the inverse of TOCOL when scanned by row. Use it to reshape flat data into a structured table format with a specific number of columns.

MAP

Dynamic Array

Applies a LAMBDA function to each element of one or more arrays and returns the results as an array.

Pro Tip: MAP replaces many array formula patterns. It applies a custom function element-by-element and is cleaner than Ctrl+Shift+Enter array formulas. Pair with named LAMBDA functions for reusable transformations.

REDUCE

Dynamic Array

Reduces an array to a single accumulated value by applying a LAMBDA function to each element.

Pro Tip: REDUCE processes elements left-to-right, carrying an accumulator. It can compute running totals, products, or any custom aggregation that existing functions do not support natively.

BYROW

Dynamic Array

Applies a LAMBDA function to each row of an array and returns a single-column result.

Pro Tip: BYROW is like a formula-based version of applying a function across columns for each row. The LAMBDA receives the entire row as an array. Use BYCOL for column-wise operations.

ISOWEEKNUM

Date & Time

Returns the ISO 8601 week number of the year for a given date.

Pro Tip: ISO weeks always start on Monday and week 1 is the week containing the first Thursday of the year. This is the international standard used in most countries outside the US.

IPMT

Financial

Returns the interest payment for a specific period of a loan or investment.

Pro Tip: IPMT + PPMT = PMT for any given period. Use these to build amortization schedules showing exactly how much of each payment goes to interest vs. principal.

PPMT

Financial

Returns the principal payment for a specific period of a loan or investment.

Pro Tip: Early in a loan, most of the payment is interest (IPMT). As the loan matures, more goes to principal (PPMT). Build an amortization table to visualize this shift.

DOLLAR

Text

Converts a number to text formatted as currency using the $ symbol.

Pro Tip: DOLLAR returns text, not a number. Use it when you need currency-formatted text for labels or concatenation. For number formatting, use the cell format or TEXT function instead.

FIXED

Text

Rounds a number to the specified number of decimals and returns it as formatted text.

Pro Tip: FIXED returns text, not a number. It is similar to TEXT but with simpler syntax for basic number formatting. Set no_commas to TRUE to omit thousands separators.

TEXTSPLIT

Text

Splits a text string into an array of substrings using specified column and row delimiters.

Pro Tip: TEXTSPLIT is the modern replacement for complex LEFT/MID/RIGHT parsing. It can produce both 1D and 2D arrays. Use match_mode 1 for case-insensitive delimiter matching.

TEXTBEFORE

Text

Returns text that occurs before a specified delimiter.

Pro Tip: Use negative instance_num to search from the end. TEXTBEFORE replaces complex FIND/LEFT combinations. Set match_mode to 1 for case-insensitive matching.

TEXTAFTER

Text

Returns text that occurs after a specified delimiter.

Pro Tip: Use negative instance_num to search from the end. TEXTAFTER replaces complex MID/FIND/LEN combinations. Set match_mode to 1 for case-insensitive matching.

ARRAYTOTEXT

Text

Returns an array of values as a text string. Format 0 gives concise output; format 1 gives strict output with delimiters.

Pro Tip: Format 0 (default) returns a comma-separated string. Format 1 returns Excel array literal syntax with curly braces, semicolons for rows, and quotes around text. Useful for debugging array formulas.

VALUETOTEXT

Text

Returns a single value as text. Format 0 gives concise output; format 1 gives strict output preserving format characters.

Pro Tip: VALUETOTEXT is similar to TEXT but does not require a format string. Format 1 wraps text values in quotes, which is useful for generating formula strings or code.

UNICHAR

Text

Returns the Unicode character referenced by the given numeric value.

Pro Tip: UNICHAR supports the full Unicode range, unlike CHAR which is limited to ASCII/ANSI (0-255). Use it to insert special symbols, emojis, and international characters into cells.

UNICODE

Text

Returns the Unicode code point for the first character of a text string.

Pro Tip: UNICODE is the extended version of CODE that supports the full Unicode character set. Use it to identify special characters in imported text or to create custom sorting logic.

BAHTTEXT

Text

Converts a number to Thai text and adds the Thai currency suffix (Baht).

Pro Tip: BAHTTEXT is a specialized function for Thai locale financial documents. It converts numbers to the Thai script representation of Baht currency, similar to how checks spell out amounts in words.

ASC

Text

Converts full-width (double-byte) characters to half-width (single-byte) characters in a text string. Primarily for East Asian languages.

Pro Tip: ASC is essential when working with Japanese, Chinese, or Korean text where full-width characters may need to be converted to half-width for data consistency or formatting purposes.

JIS

Text

Converts half-width (single-byte) characters to full-width (double-byte) characters in a text string. Primarily for East Asian languages.

Pro Tip: JIS is the inverse of ASC. Use it when you need to standardize text to full-width characters for Japanese or other East Asian language documents.

PHONETIC

Text

Extracts the phonetic (furigana) characters from a text string. Primarily used with Japanese text in Excel.

Pro Tip: PHONETIC reads the phonetic guide (furigana) that is stored with Japanese text when entered via IME. It only works in the Windows version of Excel with Japanese text that has furigana attached.

T

Text

Returns the text referred to by value if it is text, or an empty string if it is not text.

Pro Tip: T is rarely needed in modern Excel but can be useful for ensuring a value is treated as text in formulas, or for stripping non-text values to empty strings in data cleaning workflows.

WIDECHAR

Text

Converts half-width (single-byte) ASCII and katakana characters to full-width (double-byte) characters.

Pro Tip: WIDECHAR is similar to JIS and is used for East Asian language support. It converts standard ASCII characters to their full-width Unicode equivalents for display consistency in CJK documents.

SIGN

Math & Trigonometry

Returns the sign of a number: 1 for positive, -1 for negative, 0 for zero.

Pro Tip: SIGN is useful for conditional formatting logic, determining the direction of change, or normalizing values to their direction (multiply by SIGN to keep direction while changing magnitude).

PI

Math & Trigonometry

Returns the value of pi (3.14159265358979...).

Pro Tip: PI() returns pi to 15 decimal places. Use it for circle calculations, trigonometry, and angle conversions (radians = degrees * PI()/180).

RADIANS

Math & Trigonometry

Converts degrees to radians.

Pro Tip: Excel's trig functions (SIN, COS, TAN) expect radians, not degrees. Always wrap degree values in RADIANS() before passing to trig functions.

DEGREES

Math & Trigonometry

Converts radians to degrees.

Pro Tip: Use DEGREES to convert the output of inverse trig functions (ASIN, ACOS, ATAN) back to degrees for human-readable results.

SIN

Math & Trigonometry

Returns the sine of an angle specified in radians.

Pro Tip: SIN expects the angle in radians. Wrap degree values in RADIANS() first. SIN is fundamental for wave calculations, circular motion, and trigonometric modeling.

COS

Math & Trigonometry

Returns the cosine of an angle specified in radians.

Pro Tip: COS expects radians. Use RADIANS() to convert degrees. Cosine is used in physics, engineering, and signal processing for phase-shifted wave calculations.

TAN

Math & Trigonometry

Returns the tangent of an angle specified in radians.

Pro Tip: TAN is undefined at 90 degrees (PI/2 radians) and its odd multiples. Use TAN for slope calculations: the tangent of an angle equals rise over run.

ASIN

Math & Trigonometry

Returns the arcsine (inverse sine) of a number, in radians. The input must be between -1 and 1.

Pro Tip: ASIN returns a value between -PI/2 and PI/2. Wrap in DEGREES() to get the result in degrees. Input values outside -1 to 1 return #NUM! error.

ACOS

Math & Trigonometry

Returns the arccosine (inverse cosine) of a number, in radians. The input must be between -1 and 1.

Pro Tip: ACOS returns a value between 0 and PI. Use DEGREES(ACOS(value)) to get the angle in degrees. Useful for calculating angles in geometry and navigation.

ATAN

Math & Trigonometry

Returns the arctangent (inverse tangent) of a number, in radians.

Pro Tip: ATAN returns a value between -PI/2 and PI/2. For a full-range angle (all four quadrants), use ATAN2 which accepts both x and y coordinates.

ATAN2

Math & Trigonometry

Returns the arctangent of the specified x and y coordinates, in radians. Returns an angle between -PI and PI.

Pro Tip: Unlike ATAN, ATAN2 distinguishes between all four quadrants and handles the case where x is 0. Note that Excel uses (x, y) order, not (y, x) like some programming languages.

SINH

Math & Trigonometry

Returns the hyperbolic sine of a number.

Pro Tip: Hyperbolic functions are used in engineering for catenary curves (hanging cables), heat transfer, and special relativity calculations.

COSH

Math & Trigonometry

Returns the hyperbolic cosine of a number.

Pro Tip: COSH describes the shape of a hanging cable or chain (catenary curve). It is always greater than or equal to 1 for real inputs.

TANH

Math & Trigonometry

Returns the hyperbolic tangent of a number.

Pro Tip: TANH output is always between -1 and 1, making it useful as a sigmoid-like activation function in machine learning models and neural networks.

PRODUCT

Math & Trigonometry

Multiplies all the numbers given as arguments and returns the product.

Pro Tip: PRODUCT ignores text and logical values in ranges. It is the multiplication equivalent of SUM. For conditional products, use SUMPRODUCT with logarithms or a helper column.

FACT

Math & Trigonometry

Returns the factorial of a number (n! = n x (n-1) x ... x 2 x 1).

Pro Tip: Factorials grow extremely fast. FACT(170) is the largest factorial Excel can calculate before returning #NUM!. Factorials are used in permutations, combinations, and probability.

FACTDOUBLE

Math & Trigonometry

Returns the double factorial of a number (n!! = product of all integers from 1 to n that have the same parity as n).

Pro Tip: Double factorial is not the same as factorial applied twice. It multiplies every other integer: odd!! = 1*3*5*...*n and even!! = 2*4*6*...*n. Used in advanced statistics and physics.

GCD

Math & Trigonometry

Returns the greatest common divisor of two or more integers.

Pro Tip: GCD is useful for simplifying fractions: divide both numerator and denominator by GCD. For example, 12/18 simplifies to 2/3 since GCD(12,18)=6.

LCM

Math & Trigonometry

Returns the least common multiple of two or more integers.

Pro Tip: LCM is helpful for finding common denominators in fractions and scheduling problems (e.g., when will two recurring events coincide?).

COMBIN

Math & Trigonometry

Returns the number of combinations for a given number of items (order does not matter).

Pro Tip: COMBIN calculates n! / (k! * (n-k)!). Use COMBIN for lottery odds, team selection problems, or any scenario where order does not matter. Use PERMUT when order matters.

PERMUT

Math & Trigonometry

Returns the number of permutations for a given number of items (order matters).

Pro Tip: PERMUT calculates n! / (n-k)!. It returns more results than COMBIN because order matters. Use PERMUT for PIN codes, race finishing orders, or password combinations.

ROMAN

Math & Trigonometry

Converts an Arabic numeral to Roman numeral as text.

Pro Tip: The form parameter (0-4) controls how concise the Roman numeral is. Form 0 (default) is classic, higher forms are more concise. Maximum input is 3999.

ARABIC

Math & Trigonometry

Converts a Roman numeral text string to an Arabic numeral.

Pro Tip: ARABIC is the inverse of ROMAN. It accepts both uppercase and lowercase Roman numerals. Returns #VALUE! for invalid Roman numeral strings.

EVEN

Math & Trigonometry

Rounds a number up to the nearest even integer, away from zero.

Pro Tip: EVEN always rounds away from zero to the next even number. Use it for packaging calculations where items come in pairs or for rounding to even increments.

ODD

Math & Trigonometry

Rounds a number up to the nearest odd integer, away from zero.

Pro Tip: ODD always rounds away from zero to the next odd number. Combined with EVEN, it is useful for alternating patterns or ensuring specific parity in results.

MULTINOMIAL

Math & Trigonometry

Returns the multinomial of a set of numbers, calculated as the factorial of the sum divided by the product of factorials.

Pro Tip: The multinomial coefficient counts the number of ways to divide a set into groups of specified sizes. It generalizes COMBIN to more than two groups.

SERIESSUM

Math & Trigonometry

Returns the sum of a power series: SUM(coefficients[i] * x^(n + i*m)).

Pro Tip: SERIESSUM is useful for evaluating polynomial approximations, Taylor series, and Fourier series. The coefficients array defines the terms of the power series.

MDETERM

Math & Trigonometry

Returns the matrix determinant of a square array.

Pro Tip: A determinant of 0 means the matrix is singular (no inverse). Determinants are used in solving systems of linear equations and calculating area/volume in geometry.

MINVERSE

Math & Trigonometry

Returns the inverse matrix for a square matrix stored in an array.

Pro Tip: A matrix multiplied by its inverse gives the identity matrix. MINVERSE is used to solve systems of linear equations: X = MINVERSE(A) * B. The matrix must be square and non-singular.

MMULT

Math & Trigonometry

Returns the matrix product of two arrays. The number of columns in array1 must equal the number of rows in array2.

Pro Tip: MMULT is essential for linear algebra in Excel. Use it with MINVERSE to solve linear equations, or with TRANSPOSE for advanced array calculations like weighted scoring models.

CEILING.MATH

Math & Trigonometry

Rounds a number up to the nearest integer or to the nearest multiple of significance. Handles negative numbers based on mode.

Pro Tip: CEILING.MATH is the modern replacement for CEILING. It handles negative numbers more intuitively and does not require number and significance to have the same sign.

FLOOR.MATH

Math & Trigonometry

Rounds a number down to the nearest integer or to the nearest multiple of significance. Handles negative numbers based on mode.

Pro Tip: FLOOR.MATH is the modern replacement for FLOOR. It handles negative numbers more intuitively and does not require number and significance to have the same sign.

CEILING.PRECISE

Math & Trigonometry

Rounds a number up to the nearest integer or to the nearest multiple of significance, regardless of sign.

Pro Tip: CEILING.PRECISE always rounds toward positive infinity, making it predictable for both positive and negative numbers. The significance is always treated as positive.

FLOOR.PRECISE

Math & Trigonometry

Rounds a number down to the nearest integer or to the nearest multiple of significance, regardless of sign.

Pro Tip: FLOOR.PRECISE always rounds toward negative infinity, making it predictable for both positive and negative numbers. The significance is always treated as positive.

CSC

Math & Trigonometry

Returns the cosecant of an angle specified in radians (reciprocal of sine).

Pro Tip: CSC(x) = 1/SIN(x). It is undefined when SIN(x) = 0 (at multiples of PI). Primarily used in advanced mathematics and engineering calculations.

SEC

Math & Trigonometry

Returns the secant of an angle specified in radians (reciprocal of cosine).

Pro Tip: SEC(x) = 1/COS(x). It is undefined when COS(x) = 0 (at odd multiples of PI/2). Used in calculus, physics, and certain engineering applications.

COT

Math & Trigonometry

Returns the cotangent of an angle specified in radians (reciprocal of tangent).

Pro Tip: COT(x) = 1/TAN(x) = COS(x)/SIN(x). It is undefined when SIN(x) = 0 (at multiples of PI). Used in certain geometric and trigonometric calculations.

ACOT

Math & Trigonometry

Returns the arccotangent (inverse cotangent) of a number, in radians.

Pro Tip: ACOT returns a value between 0 and PI. It is the inverse of COT. Wrap the result in DEGREES() for a human-readable angle.

QUARTILE

Statistical

Returns the quartile of a dataset (0 = min, 1 = 25th percentile, 2 = median, 3 = 75th percentile, 4 = max).

Pro Tip: The interquartile range (Q3-Q1) is a robust measure of spread. Values below Q1-1.5*IQR or above Q3+1.5*IQR are commonly considered outliers.

CORREL

Statistical

Returns the Pearson correlation coefficient between two datasets (-1 to 1).

Pro Tip: Values near 1 indicate strong positive correlation, near -1 indicate strong negative correlation, and near 0 indicate no linear relationship. CORREL measures linear relationships only.

FORECAST

Statistical

Predicts a future value using linear regression based on existing data.

Pro Tip: FORECAST uses simple linear regression (y = mx + b). For more advanced forecasting, use FORECAST.ETS which handles seasonality and trends. FORECAST.LINEAR is the modern replacement.

SLOPE

Statistical

Returns the slope of the linear regression line through the given data points.

Pro Tip: The slope tells you the rate of change: for every 1-unit increase in x, y changes by the slope value. Combine with INTERCEPT for the full equation: y = SLOPE*x + INTERCEPT.

INTERCEPT

Statistical

Returns the y-intercept of the linear regression line through the given data points.

Pro Tip: The intercept is the predicted y value when x is 0. Together, SLOPE and INTERCEPT define the regression equation: y = SLOPE*x + INTERCEPT.

AVERAGEA

Statistical

Returns the average of its arguments, including text and logical values. TRUE counts as 1, FALSE and text as 0.

Pro Tip: Unlike AVERAGE which ignores text and logical values in ranges, AVERAGEA includes them. TRUE=1, FALSE=0, text=0. Use AVERAGEA when you want non-numeric cells to count as zero.

MINA

Statistical

Returns the smallest value in a set of values, including text and logical values. TRUE counts as 1, FALSE and text as 0.

Pro Tip: MINA is useful when your data contains logical values or text that should be included in the minimum calculation. Text strings evaluate to 0, which may become the minimum.

MAXA

Statistical

Returns the largest value in a set of values, including text and logical values. TRUE counts as 1, FALSE and text as 0.

Pro Tip: MAXA includes logical values and text in the evaluation, unlike MAX which ignores them. This can be useful for datasets where TRUE/FALSE values should factor into the result.

MODE.SNGL

Statistical

Returns the most frequently occurring (single mode) value in a dataset. Replacement for the legacy MODE function.

Pro Tip: MODE.SNGL returns only one mode even if multiple values have the same highest frequency. For all modes, use MODE.MULT. Returns #N/A if no value appears more than once.

MODE.MULT

Statistical

Returns a vertical array of the most frequently occurring values in a dataset (handles multiple modes).

Pro Tip: MODE.MULT spills in Excel 365. In older versions, select multiple cells, enter the formula, and press Ctrl+Shift+Enter. Returns #N/A if no value repeats.

RANK.AVG

Statistical

Returns the rank of a number in a list. Tied values receive an average rank.

Pro Tip: RANK.AVG averages the ranks for tied values. For example, two values tied for 3rd place both get rank 3.5. This is preferred in statistical analysis to avoid rank gaps.

RANK.EQ

Statistical

Returns the rank of a number in a list. Tied values receive the same (top) rank.

Pro Tip: RANK.EQ is the modern replacement for RANK. Tied values get the same rank and subsequent ranks are skipped. For example, two 3rd-place ties mean there is no 4th place.

PERCENTILE.INC

Statistical

Returns the k-th percentile of values in a range, inclusive (k is between 0 and 1 inclusive).

Pro Tip: PERCENTILE.INC is the modern replacement for PERCENTILE. It includes the 0th and 100th percentiles (k can be 0 or 1). Use PERCENTILE.EXC for exclusive percentiles.

PERCENTILE.EXC

Statistical

Returns the k-th percentile of values in a range, exclusive (k must be between 0 and 1 exclusive).

Pro Tip: PERCENTILE.EXC uses interpolation and excludes the 0th and 100th percentiles. It requires k to be between 1/(n+1) and n/(n+1). More commonly used in academic statistics.

QUARTILE.INC

Statistical

Returns the quartile of a dataset using the inclusive method (0 = min, 1 = Q1, 2 = median, 3 = Q3, 4 = max).

Pro Tip: QUARTILE.INC is the modern replacement for QUARTILE. It is equivalent to PERCENTILE.INC at 0, 0.25, 0.5, 0.75, and 1. Use IQR to detect outliers.

QUARTILE.EXC

Statistical

Returns the quartile of a dataset using the exclusive method (1 = Q1, 2 = median, 3 = Q3).

Pro Tip: QUARTILE.EXC does not accept quart values of 0 or 4 (unlike INC). It uses the exclusive interpolation method preferred in some statistical applications.

STDEV.S

Statistical

Estimates standard deviation based on a sample (uses n-1 denominator). Modern replacement for STDEV.

Pro Tip: STDEV.S is the modern name for STDEV. Use it for sample data (most real-world scenarios). For an entire population, use STDEV.P. The S stands for Sample.

STDEV.P

Statistical

Calculates standard deviation based on the entire population (uses n denominator).

Pro Tip: Use STDEV.P only when your data represents the entire population (e.g., test scores for all students in a class). For samples from a larger population, use STDEV.S.

VAR.S

Statistical

Estimates variance based on a sample (uses n-1 denominator). Modern replacement for VAR.

Pro Tip: VAR.S is the square of STDEV.S. It uses the n-1 denominator (Bessel's correction) for unbiased estimation from sample data. The S stands for Sample.

VAR.P

Statistical

Calculates variance based on the entire population (uses n denominator).

Pro Tip: Use VAR.P only when your data represents the entire population. It uses n as the denominator, giving a smaller result than VAR.S for the same data.

NORM.DIST

Statistical

Returns the normal distribution for the specified mean and standard deviation. Set cumulative to TRUE for CDF, FALSE for PDF.

Pro Tip: Set cumulative to TRUE for the probability that a random variable is less than or equal to x. Set to FALSE for the probability density at exactly x. Essential for quality control and statistics.

NORM.INV

Statistical

Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.

Pro Tip: NORM.INV answers: what value has a given probability of being below it? Use it for confidence intervals, setting thresholds, and statistical testing.

NORM.S.DIST

Statistical

Returns the standard normal distribution (mean 0, standard deviation 1).

Pro Tip: The standard normal is NORM.DIST with mean=0 and stdev=1. Z-scores let you compare values from different normal distributions. 95% of values fall within z = +/- 1.96.

NORM.S.INV

Statistical

Returns the inverse of the standard normal cumulative distribution (mean 0, standard deviation 1).

Pro Tip: NORM.S.INV is commonly used to find critical z-values for hypothesis testing. For a 95% two-tailed test, use NORM.S.INV(0.975) to get 1.96.

T.DIST

Statistical

Returns the Student's t-distribution for the specified degrees of freedom.

Pro Tip: The t-distribution is used instead of the normal distribution when sample sizes are small. As degrees of freedom increase, it approaches the normal distribution.

T.INV

Statistical

Returns the left-tailed inverse of the Student's t-distribution.

Pro Tip: For two-tailed tests, use T.INV(1-alpha/2, df). For example, for a 95% confidence interval with 10 df, use T.INV(0.975, 10). Use T.INV.2T for the two-tailed version directly.

T.TEST

Statistical

Returns the probability associated with a Student's t-test to determine if two samples are likely from the same population.

Pro Tip: Type 1 = paired, Type 2 = two-sample equal variance, Type 3 = two-sample unequal variance (Welch's). A p-value below 0.05 typically indicates a statistically significant difference.

F.DIST

Statistical

Returns the F probability distribution, used in analysis of variance (ANOVA) and comparing variances.

Pro Tip: The F-distribution is always positive and right-skewed. It is used in ANOVA, regression analysis, and comparing variances between two populations.

F.INV

Statistical

Returns the inverse of the F probability distribution.

Pro Tip: Use F.INV to find critical F-values for ANOVA and regression significance tests. Compare your calculated F-statistic to F.INV to determine statistical significance.

F.TEST

Statistical

Returns the result of an F-test, which compares the variances of two datasets and returns the two-tailed probability.

Pro Tip: Use F.TEST before a t-test to determine if you should use equal or unequal variance assumptions. A p-value below 0.05 suggests the variances are significantly different.

CHISQ.DIST

Statistical

Returns the chi-squared distribution, used for goodness-of-fit tests and independence tests.

Pro Tip: The chi-squared distribution is used for categorical data analysis: goodness-of-fit tests, tests of independence, and confidence intervals for variance.

CHISQ.INV

Statistical

Returns the inverse of the left-tailed chi-squared distribution.

Pro Tip: Use CHISQ.INV to find critical values for chi-squared tests. Common use: CHISQ.INV(0.95, df) gives the 5% significance level critical value.

CHISQ.TEST

Statistical

Returns the p-value from the chi-squared test for independence, comparing observed and expected frequencies.

Pro Tip: A p-value below 0.05 typically indicates the observed frequencies differ significantly from expected. The expected range must have the same dimensions as the actual range.

BINOM.DIST

Statistical

Returns the individual or cumulative binomial distribution probability.

Pro Tip: Use BINOM.DIST for binary outcome experiments (pass/fail, heads/tails). Set cumulative to TRUE for at most k successes, FALSE for exactly k successes.

POISSON.DIST

Statistical

Returns the Poisson distribution, used for predicting the number of events occurring in a fixed interval.

Pro Tip: Use Poisson for count data: customer arrivals per hour, defects per unit, calls per day. The mean equals both the expected value and variance of the distribution.

EXPON.DIST

Statistical

Returns the exponential distribution, used to model the time between events in a Poisson process.

Pro Tip: Lambda is the rate parameter (1/mean). The exponential distribution models waiting times between Poisson events. It has the memoryless property.

WEIBULL.DIST

Statistical

Returns the Weibull distribution, commonly used in reliability analysis and survival analysis.

Pro Tip: Alpha (shape) controls the failure rate pattern: <1 = decreasing failure rate, =1 = constant (exponential), >1 = increasing failure rate (wear-out). Beta is the scale parameter.

GAMMA.DIST

Statistical

Returns the gamma distribution, a generalization of the exponential and chi-squared distributions.

Pro Tip: The gamma distribution generalizes the exponential (alpha=1) and chi-squared (alpha=df/2, beta=2) distributions. Used in queuing theory and insurance claims modeling.

GAMMA.INV

Statistical

Returns the inverse of the gamma cumulative distribution.

Pro Tip: GAMMA.INV answers: what value has a given cumulative probability under the gamma distribution? Useful for setting thresholds in reliability and queuing models.

CONFIDENCE.NORM

Statistical

Returns the confidence interval margin of error for a population mean using the normal distribution.

Pro Tip: Alpha is the significance level (0.05 for 95% confidence). The result is the margin of error; add/subtract it from the mean to get the confidence interval bounds.

CONFIDENCE.T

Statistical

Returns the confidence interval margin of error for a population mean using the Student's t-distribution.

Pro Tip: Use CONFIDENCE.T instead of CONFIDENCE.NORM for small samples (n < 30) or when the population standard deviation is unknown. It produces wider intervals to account for uncertainty.

LINEST

Statistical

Returns statistics for a linear regression model using the least squares method. Returns an array of coefficients and optionally additional statistics.

Pro Tip: With stats=TRUE, LINEST returns a 5-row array: row 1 = coefficients, row 2 = standard errors, row 3 = R-squared and standard error of y, row 4 = F-statistic and df, row 5 = regression SS and residual SS.

LOGEST

Statistical

Returns statistics for an exponential regression model (y = b*m^x). Returns an array of coefficients.

Pro Tip: LOGEST fits y = b * m^x (or y = b * m1^x1 * m2^x2 for multiple x variables). Use it when your data follows exponential growth rather than linear growth.

GROWTH

Statistical

Predicts exponential growth by fitting an exponential curve to existing data and returning predicted y-values.

Pro Tip: GROWTH assumes y = b * m^x. It is the exponential equivalent of TREND (which assumes linear). Use GROWTH for population growth, compound returns, or any exponentially increasing data.

TREND

Statistical

Returns values along a linear trend by fitting a straight line to known data points using least squares.

Pro Tip: TREND is the array version of FORECAST. It can predict multiple values at once and handles multiple regression (multiple x columns). Use GROWTH for exponential trends.

SKEW

Statistical

Returns the skewness of a distribution, indicating asymmetry of the data around its mean.

Pro Tip: Positive skew means the tail extends right (e.g., income data). Negative skew means the tail extends left. A skewness near 0 indicates a roughly symmetric distribution.

KURT

Statistical

Returns the kurtosis of a dataset, indicating the heaviness of the tails relative to a normal distribution.

Pro Tip: Excel returns excess kurtosis (normal distribution = 0). Positive kurtosis means heavier tails (more outliers). Negative kurtosis means lighter tails. Requires at least 4 data points.

PROB

Statistical

Returns the probability that values in a range are between two limits, given associated probabilities.

Pro Tip: The probabilities in prob_range must sum to 1 (or less). If upper_limit is omitted, PROB returns the probability for exactly the lower_limit value.

TRIMMEAN

Statistical

Returns the mean of a dataset after removing a percentage of data points from the top and bottom.

Pro Tip: TRIMMEAN is a robust measure of central tendency that reduces the effect of outliers. The percent is split equally between top and bottom (10% removes 5% from each end).

GEOMEAN

Statistical

Returns the geometric mean of a set of positive numbers.

Pro Tip: GEOMEAN is the correct average for rates of return, growth rates, and ratios. It is always less than or equal to the arithmetic mean. All values must be positive.

HARMEAN

Statistical

Returns the harmonic mean of a set of positive numbers.

Pro Tip: The harmonic mean is the correct average for rates when the quantity in the denominator is constant (e.g., average speed for equal distances, average price-earnings ratio). All values must be positive.

DEVSQ

Statistical

Returns the sum of squares of deviations of data points from their sample mean.

Pro Tip: DEVSQ is the numerator used to calculate variance: VAR.S = DEVSQ/(n-1). It measures the total variability in a dataset and is used in ANOVA and regression calculations.

AVEDEV

Statistical

Returns the average of the absolute deviations of data points from their mean.

Pro Tip: AVEDEV is an alternative measure of spread that is more intuitive than standard deviation. It represents the average distance of each data point from the mean.

Z.TEST

Statistical

Returns the one-tailed p-value of a z-test, determining whether a sample mean differs significantly from a hypothesized mean.

Pro Tip: Z.TEST returns the one-tailed p-value. For a two-tailed test, multiply by 2. If sigma is omitted, the sample standard deviation is used. A small p-value suggests the sample mean differs from x.

LOOKUP

Lookup & Reference

Looks up a value in a one-row or one-column range and returns a value from the same position in a second one-row or one-column range.

Pro Tip: LOOKUP always does an approximate match on sorted data (like VLOOKUP with TRUE). The classic trick LOOKUP(2,1/(criteria),result_range) finds the last matching value. XLOOKUP is the modern replacement.

AREAS

Lookup & Reference

Returns the number of areas in a reference. An area is a contiguous range of cells or a single cell.

Pro Tip: AREAS is useful for validating multi-area references and in advanced formulas that handle discontinuous ranges. Note the double parentheses required when listing multiple areas.

HYPERLINK

Lookup & Reference

Creates a clickable hyperlink to a URL, file path, or cell reference within the workbook.

Pro Tip: Use # prefix for internal workbook links. HYPERLINK is dynamic -- the URL can be built from cell values, enabling auto-generated links to documents, websites, or other sheets.

CHOOSECOLS

Lookup & Reference

Returns the specified columns from an array or range.

Pro Tip: Use negative numbers to count from the right: -1 is the last column. CHOOSECOLS can reorder columns, not just select them. Pair with CHOOSEROWS for full row-and-column selection.

CHOOSEROWS

Lookup & Reference

Returns the specified rows from an array or range.

Pro Tip: Use negative numbers to count from the bottom: -1 is the last row. CHOOSEROWS is ideal for extracting specific rows from sorted or filtered results without helper columns.

DROP

Lookup & Reference

Removes a specified number of rows and/or columns from the start or end of an array.

Pro Tip: Positive numbers drop from the top/left, negative from the bottom/right. Use 0 to keep all rows or columns. DROP is the complement of TAKE -- together they slice arrays flexibly.

TAKE

Lookup & Reference

Returns a specified number of contiguous rows and/or columns from the start or end of an array.

Pro Tip: Positive numbers take from the top/left, negative from the bottom/right. TAKE is the complement of DROP. Combine them: TAKE gets a subset, DROP removes unwanted parts.

WRAPCOLS

Lookup & Reference

Wraps a one-dimensional array into a 2D array by filling columns first, with a specified number of rows per column.

Pro Tip: WRAPCOLS fills down columns first (column-major order), while WRAPROWS fills across rows first (row-major order). Use the pad_with argument to handle remainders cleanly.

VSTACK

Lookup & Reference

Vertically stacks (appends) arrays on top of each other into a single array.

Pro Tip: VSTACK is perfect for combining data from multiple tables vertically (like SQL UNION ALL). If arrays have different column counts, narrower arrays are padded with #N/A. Use IFNA to handle padding.

HSTACK

Lookup & Reference

Horizontally stacks (appends) arrays side by side into a single array.

Pro Tip: HSTACK is like placing arrays side by side. If arrays have different row counts, shorter arrays are padded with #N/A. Combine with VSTACK for full 2D array assembly.

EXPAND

Lookup & Reference

Expands or pads an array to specified row and column dimensions.

Pro Tip: EXPAND only adds rows/columns -- it cannot shrink an array. Use it to normalize different-sized arrays to the same dimensions before combining them, or to add padding around data.

SCAN

Logical

Scans an array by applying a LAMBDA function to each element and returns an array of intermediate accumulated values.

Pro Tip: SCAN is like REDUCE but returns all intermediate results instead of just the final value. It is ideal for cumulative sums, running averages, and sequential calculations without helper columns.

MAKEARRAY

Logical

Creates an array of specified dimensions by applying a LAMBDA function to each row and column index.

Pro Tip: MAKEARRAY is the most flexible array generator. The LAMBDA receives the row index and column index (both 1-based). Use it to create custom matrices, lookup tables, or pattern-based arrays.

BYCOL

Logical

Applies a LAMBDA function to each column of an array and returns a single-row result.

Pro Tip: BYCOL is the column-wise counterpart to BYROW. The LAMBDA receives each column as a one-column array. Use it for column-level aggregations that return a summary row.

ISOMITTED

Logical

Checks whether an argument in a LAMBDA function was omitted (not provided by the caller).

Pro Tip: ISOMITTED only works inside LAMBDA functions with optional parameters (marked with square brackets). Use it to create flexible reusable functions with sensible defaults.

NETWORKDAYS.INTL

Date & Time

Returns the number of working days between two dates, with custom weekend parameters for international use.

Pro Tip: The weekend argument accepts codes (1-17) or a 7-character binary string where each digit represents Mon-Sun (1=weekend, 0=workday). This handles any international work-week pattern.

WORKDAY.INTL

Date & Time

Returns a date that is a specified number of working days before or after a start date, with custom weekend parameters.

Pro Tip: Like NETWORKDAYS.INTL, use weekend codes or a 7-character string for flexibility. Negative days count backward. Essential for project scheduling in regions with non-standard work weeks.

YEARFRAC

Date & Time

Returns the fraction of the year represented by the number of whole days between two dates.

Pro Tip: The basis argument controls the day count convention: 0=US 30/360, 1=actual/actual, 2=actual/360, 3=actual/365, 4=European 30/360. Critical for financial calculations like bond pricing.

DAYS360

Date & Time

Returns the number of days between two dates based on a 360-day year (twelve 30-day months), used in financial calculations.

Pro Tip: The 360-day year simplifies interest calculations. US method (FALSE/default) and European method (TRUE) differ in how they handle month-end dates. Used in bond pricing and loan calculations.

XNPV

Financial

Returns the net present value for a schedule of cash flows that are not necessarily periodic.

Pro Tip: Unlike NPV which assumes equal periods, XNPV uses actual dates for precise discounting. The first value is typically the initial investment (negative) and its date is the basis for discounting.

XIRR

Financial

Returns the internal rate of return for a schedule of cash flows that are not necessarily periodic.

Pro Tip: XIRR uses an iterative algorithm. If it does not converge, provide a guess closer to the expected rate. Values must contain at least one positive and one negative number. The result is annualized.

MIRR

Financial

Returns the modified internal rate of return, accounting for different borrowing and reinvestment rates.

Pro Tip: MIRR is more realistic than IRR because it does not assume cash flows are reinvested at the IRR itself. It uses the finance_rate for negative flows and reinvest_rate for positive flows.

DDB

Financial

Returns the depreciation of an asset using the double-declining balance method or another specified factor.

Pro Tip: The default factor is 2 (double-declining). Change the factor for other accelerated methods (1.5 for 150% declining balance). DDB never depreciates below salvage value.

DB

Financial

Returns the depreciation of an asset using the fixed-declining balance method.

Pro Tip: DB calculates a fixed depreciation rate based on cost, salvage, and life. The optional month argument handles partial first years. Use SLN for straight-line or DDB for double-declining.

CUMIPMT

Financial

Returns the cumulative interest paid on a loan between two periods.

Pro Tip: Type 0 means payments at end of period, 1 means beginning. The result is negative (outgoing cash). CUMIPMT is essential for analyzing total interest cost over specific loan periods.

CUMPRINC

Financial

Returns the cumulative principal paid on a loan between two periods.

Pro Tip: Compare CUMPRINC across periods to see how principal repayment accelerates over time. Add CUMIPMT + CUMPRINC for any period range to verify it equals the sum of PMT payments.

PRICE

Financial

Returns the price per $100 face value of a bond that pays periodic interest.

Pro Tip: Settlement is the purchase date, maturity is the end date. Rate is the annual coupon rate, yld is the market yield. Frequency: 1=annual, 2=semi-annual, 4=quarterly. Basis controls day count convention.

YIELD

Financial

Returns the yield on a bond that pays periodic interest.

Pro Tip: YIELD calculates the yield-to-maturity (YTM) -- the total return if held to maturity. When price < 100, yield > coupon rate (discount bond). When price > 100, yield < coupon rate (premium bond).

ACCRINT

Financial

Returns the accrued interest for a bond that pays periodic interest.

Pro Tip: Accrued interest is what the buyer pays the seller for interest earned but not yet paid. It is added to the clean price to get the dirty (full) price the buyer actually pays.

DISC

Financial

Returns the discount rate for a security.

Pro Tip: DISC calculates the bank discount rate, which is different from yield. It is commonly used for Treasury bills and commercial paper. Use YIELDDISC for the equivalent yield.

DOLLARDE

Financial

Converts a dollar price expressed as a fraction into a decimal number.

Pro Tip: Bond prices are often quoted in fractions (32nds for Treasury bonds, 8ths for stocks). DOLLARDE converts these fractional quotes to decimals for calculations.

DOLLARFR

Financial

Converts a dollar price expressed as a decimal into a fractional representation.

Pro Tip: DOLLARFR is the inverse of DOLLARDE. Use it to convert calculated decimal bond prices back to the fractional format used in bond trading.

DURATION

Financial

Returns the Macaulay duration of a bond, measuring the weighted average time to receive cash flows.

Pro Tip: Duration measures interest rate sensitivity: a duration of 7 means the bond price changes about 7% for each 1% change in yield. Higher duration means more interest rate risk. See MDURATION for modified duration.

MDURATION

Financial

Returns the modified Macaulay duration of a bond, a more direct measure of price sensitivity to yield changes.

Pro Tip: Modified duration = Macaulay duration / (1 + yield/frequency). It directly estimates the percentage price change for a 1% yield change: Price change % is approximately -MDURATION * yield change.

RECEIVED

Financial

Returns the amount received at maturity for a fully invested security (zero-coupon or discount instrument).

Pro Tip: RECEIVED calculates the maturity value based on the discount rate and holding period. It is used for discount securities like Treasury bills and commercial paper.

INTRATE

Financial

Returns the interest rate for a fully invested security.

Pro Tip: INTRATE calculates the simple interest rate, not the compound rate. It is the inverse of RECEIVED. Use it for money market instruments, Treasury bills, and short-term discount securities.

TBILLEQ

Financial

Returns the bond-equivalent yield for a Treasury bill.

Pro Tip: T-bills are quoted on a discount basis, but bond-equivalent yield allows comparison with coupon bonds. The bond-equivalent yield is always higher than the discount rate.

TBILLPRICE

Financial

Returns the price per $100 face value for a Treasury bill.

Pro Tip: T-bill price = 100 - (discount * days_to_maturity / 360). The difference between price and 100 is the investor's return. Use TBILLYIELD to convert back to yield.

TBILLYIELD

Financial

Returns the yield for a Treasury bill based on its price.

Pro Tip: TBILLYIELD returns the bank discount yield (not bond-equivalent yield). For comparison with bonds, use TBILLEQ instead. The yield increases as the price decreases.

FVSCHEDULE

Financial

Returns the future value of an initial principal after applying a series of compound interest rates.

Pro Tip: FVSCHEDULE handles variable interest rates that change each period, unlike FV which assumes a constant rate. Useful for projected returns with changing market conditions or stepped rate loans.

ODDFPRICE

Financial

Returns the price per $100 face value of a bond with an odd (irregular) first period.

Pro Tip: Bonds sometimes have a first coupon period that is shorter or longer than normal. ODDFPRICE adjusts the pricing calculation for this irregularity. Use when settlement falls between issue and first coupon.

ODDLPRICE

Financial

Returns the price per $100 face value of a bond with an odd (irregular) last period.

Pro Tip: Bonds may have a final coupon period that differs from the standard interval. ODDLPRICE adjusts for this. It is the counterpart to ODDFPRICE for the last period irregularity.

ISERR

Information

Returns TRUE if the value is any error except #N/A.

Pro Tip: ISERR catches all errors except #N/A. This is useful when you want #N/A to propagate (e.g., indicating missing data from a VLOOKUP) while handling other errors separately.

ISLOGICAL

Information

Returns TRUE if the value is a logical value (TRUE or FALSE).

Pro Tip: ISLOGICAL distinguishes between actual Boolean TRUE/FALSE and the text strings "TRUE"/"FALSE". Use it to validate data types in cells that should contain checkboxes or Boolean flags.

ISEVEN

Information

Returns TRUE if the number is even.

Pro Tip: ISEVEN truncates decimals before checking: ISEVEN(4.7) returns TRUE. Use it in conditional formatting for alternating row colors or to validate even-numbered inputs.

ISODD

Information

Returns TRUE if the number is odd.

Pro Tip: Like ISEVEN, ISODD truncates decimals first. Combine with ROW() for alternating row logic, or use in data validation to ensure odd-numbered entries.

ISREF

Information

Returns TRUE if the value is a cell reference.

Pro Tip: ISREF is useful for validating that INDIRECT or other reference-building functions return valid references before using them. It helps prevent #REF! errors in dynamic formulas.

N

Information

Converts a value to a number. TRUE becomes 1, FALSE becomes 0, dates become serial numbers, errors remain errors, text becomes 0.

Pro Tip: N is rarely needed in modern Excel since most functions convert automatically. Its main modern use is adding invisible comments to formulas: =SUM(A1:A10)+N("This sums the revenue column") -- the N() part evaluates to 0.

NA

Information

Returns the #N/A error value, indicating that a value is not available.

Pro Tip: Use NA() to explicitly mark cells as missing data. Charts will show gaps for #N/A values instead of plotting zero. This is preferred over leaving cells blank or entering 0 for missing data.

ERROR.TYPE

Information

Returns a number corresponding to the type of error: 1=#NULL!, 2=#DIV/0!, 3=#VALUE!, 4=#REF!, 5=#NAME?, 6=#NUM!, 7=#N/A, 8=#GETTING_DATA.

Pro Tip: ERROR.TYPE returns #N/A if the value is not an error. Use it with SWITCH or CHOOSE to display custom error messages based on the specific error type encountered.

INFO

Information

Returns information about the current operating environment.

Pro Tip: Valid type_text values include: directory, numfile, origin, osversion, recalc, release, system. INFO is useful for documenting the environment in which a workbook was created or last saved.

SHEET

Information

Returns the sheet number of a referenced sheet or the current sheet.

Pro Tip: SHEET returns the position of the sheet in the workbook tab order. If a sheet is moved, its number changes. Use it for dynamic formulas that need to know which sheet they are on.

SHEETS

Information

Returns the number of sheets in a reference or the total number of sheets in the workbook.

Pro Tip: Without arguments, SHEETS counts all sheets including hidden ones. Use it to create dynamic formulas that adapt when sheets are added or removed from the workbook.

DSUM

Database

Adds the numbers in a field (column) of records in a database that match conditions you specify.

Pro Tip: The criteria range must include column headers that exactly match the database headers. Use a separate area of your worksheet for the criteria range to avoid confusion.

DAVERAGE

Database

Averages the values in a field (column) of records in a database that match conditions you specify.

Pro Tip: DAVERAGE ignores blank cells in the field column. If no records match the criteria, it returns a #DIV/0! error.

DCOUNT

Database

Counts the cells that contain numbers in a field (column) of records in a database that match conditions you specify.

Pro Tip: DCOUNT only counts cells containing numbers. Use DCOUNTA to count non-blank cells including text. Leave the field argument blank to count all matching records.

DCOUNTA

Database

Counts the non-blank cells in a field (column) of records in a database that match conditions you specify.

Pro Tip: Unlike DCOUNT, DCOUNTA counts cells with text, numbers, errors, and logical values — everything except blank cells.

DMAX

Database

Returns the largest number in a field (column) of records in a database that match conditions you specify.

Pro Tip: Combine DMAX and DMIN to quickly find the range of values within a filtered subset of your data.

DMIN

Database

Returns the smallest number in a field (column) of records in a database that match conditions you specify.

Pro Tip: DMIN only considers numeric values. Text and blank cells are ignored when determining the minimum.

DGET

Database

Extracts a single value from a field (column) of a record in a database that matches conditions you specify.

Pro Tip: DGET returns #VALUE! if no records match and #NUM! if more than one record matches. Make sure your criteria uniquely identify one record.

DPRODUCT

Database

Multiplies the values in a field (column) of records in a database that match conditions you specify.

Pro Tip: DPRODUCT is useful for compound growth calculations or combining multiplicative factors across filtered records.

DSTDEV

Database

Estimates the standard deviation of a population based on a sample, using the numbers in a field of records that match criteria.

Pro Tip: DSTDEV uses n-1 in the denominator (sample). Use DSTDEVP if your data represents the entire population.

DSTDEVP

Database

Calculates the standard deviation of a population based on the entire population, using numbers in a field of records that match criteria.

Pro Tip: DSTDEVP uses n in the denominator (population). Use DSTDEV if your data is a sample from a larger population.

DVAR

Database

Estimates the variance of a population based on a sample, using the numbers in a field of records that match criteria.

Pro Tip: Variance is the square of standard deviation. DVAR uses n-1 (sample); use DVARP for the entire population.

DVARP

Database

Calculates the variance of a population based on the entire population, using numbers in a field of records that match criteria.

Pro Tip: DVARP uses n in the denominator. If your matching records are just a sample, use DVAR instead for an unbiased estimate.

CONVERT

Engineering

Converts a number from one measurement system to another (e.g., inches to centimeters, pounds to kilograms).

Pro Tip: CONVERT supports over 100 unit strings across weight, distance, time, pressure, force, energy, temperature, and more. Unit strings are case-sensitive.

DELTA

Engineering

Tests whether two values are equal. Returns 1 if they are equal, 0 otherwise. Also known as the Kronecker delta function.

Pro Tip: If number2 is omitted, it defaults to 0. DELTA is useful with SUMPRODUCT to count exact matches in engineering calculations.

GESTEP

Engineering

Tests whether a number is greater than or equal to a threshold (step) value. Returns 1 if number >= step, 0 otherwise.

Pro Tip: If step is omitted, it defaults to 0, effectively testing whether the number is non-negative. Useful for step functions in engineering models.

BIN2DEC

Engineering

Converts a binary (base-2) number to decimal (base-10).

Pro Tip: The binary number can be up to 10 characters (bits). The most significant bit is the sign bit, so 1111111111 = -1 in two's complement.

BIN2HEX

Engineering

Converts a binary (base-2) number to hexadecimal (base-16).

Pro Tip: The places argument specifies the minimum number of characters. Leading zeros are added if needed. The binary input can be up to 10 bits.

BIN2OCT

Engineering

Converts a binary (base-2) number to octal (base-8).

Pro Tip: The octal result can be padded with leading zeros using the places argument. Useful for Unix file permission conversions.

DEC2BIN

Engineering

Converts a decimal (base-10) number to binary (base-2).

Pro Tip: DEC2BIN handles values from -512 to 511. For larger numbers, use a combination of DEC2HEX and manual conversion.

DEC2HEX

Engineering

Converts a decimal (base-10) number to hexadecimal (base-16).

Pro Tip: DEC2HEX handles values from -549,755,813,888 to 549,755,813,887. Combine with UPPER/LOWER for consistent casing.

DEC2OCT

Engineering

Converts a decimal (base-10) number to octal (base-8).

Pro Tip: DEC2OCT handles values from -536,870,912 to 536,870,911. Useful for computing Unix file permissions.

HEX2BIN

Engineering

Converts a hexadecimal (base-16) number to binary (base-2).

Pro Tip: HEX2BIN only handles hex values up to 1FF (511 decimal) or negative values from FFFFFFFE00. For larger values, convert through decimal first.

HEX2DEC

Engineering

Converts a hexadecimal (base-16) number to decimal (base-10).

Pro Tip: HEX2DEC handles up to 10 hex characters. Hex strings are case-insensitive: FF and ff both return 255.

HEX2OCT

Engineering

Converts a hexadecimal (base-16) number to octal (base-8).

Pro Tip: HEX2OCT handles hex values up to 1FFFFFFF (positive) or from FFE0000000 (negative). Use places to control leading zeros.

OCT2BIN

Engineering

Converts an octal (base-8) number to binary (base-2).

Pro Tip: OCT2BIN only handles octal values from 7777777000 to 777 (i.e., -512 to 511 decimal). For larger values, convert through decimal.

OCT2DEC

Engineering

Converts an octal (base-8) number to decimal (base-10).

Pro Tip: OCT2DEC handles up to 10 octal characters. The most significant bit is the sign bit for two's complement representation.

OCT2HEX

Engineering

Converts an octal (base-8) number to hexadecimal (base-16).

Pro Tip: OCT2HEX handles up to 10-digit octal numbers. The result can be padded with leading zeros using the places argument.

COMPLEX

Engineering

Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.

Pro Tip: Use the optional suffix argument to switch between 'i' (default, math convention) and 'j' (electrical engineering convention).

IMABS

Engineering

Returns the absolute value (modulus) of a complex number in x + yi text format.

Pro Tip: IMABS calculates sqrt(x^2 + y^2). It is the distance from the origin to the point (x, y) in the complex plane.

IMAGINARY

Engineering

Returns the imaginary coefficient of a complex number in x + yi text format.

Pro Tip: If you pass a real number with no imaginary part, IMAGINARY returns 0. The input must be a text string in complex number format.

IMREAL

Engineering

Returns the real coefficient of a complex number in x + yi text format.

Pro Tip: IMREAL extracts the x from x+yi. If the complex number has no real part (e.g., '4i'), it returns 0.

BITAND

Engineering

Returns the bitwise AND of two integers.

Pro Tip: Both arguments must be non-negative integers and the result cannot exceed 2^48 - 1. Useful for masking specific bits in flag fields.

BITOR

Engineering

Returns the bitwise OR of two integers.

Pro Tip: Use BITOR to combine flags or set specific bits. Both arguments must be non-negative integers up to 2^48 - 1.

BITXOR

Engineering

Returns the bitwise XOR (exclusive OR) of two integers.

Pro Tip: XOR returns 1 for each bit position where the two inputs differ. Useful for toggling flags and simple checksums.

BITLSHIFT

Engineering

Returns the number shifted left by the specified number of bits, equivalent to multiplying by 2^shift_amount.

Pro Tip: Left-shifting by n bits is equivalent to multiplying by 2^n. The number must be non-negative and the result cannot exceed 2^48 - 1.

BITRSHIFT

Engineering

Returns the number shifted right by the specified number of bits, equivalent to integer division by 2^shift_amount.

Pro Tip: Right-shifting by n bits is equivalent to integer division by 2^n. Bits shifted out on the right are discarded.

ERF

Engineering

Returns the error function integrated between lower_limit and upper_limit.

Pro Tip: If upper_limit is omitted, ERF integrates from 0 to lower_limit. ERF is widely used in probability, statistics, and heat-transfer calculations.

ERFC

Engineering

Returns the complementary error function integrated between x and infinity (i.e., 1 - ERF(x)).

Pro Tip: ERFC(x) = 1 - ERF(x). For large x values, ERFC is more numerically accurate than computing 1 - ERF(x) directly.

BESSELI

Engineering

Returns the modified Bessel function of the first kind, In(x).

Pro Tip: Modified Bessel functions arise in problems with cylindrical symmetry where the equation has a different sign, such as heat conduction in a cylinder.

BESSELJ

Engineering

Returns the Bessel function of the first kind, Jn(x).

Pro Tip: Bessel functions of the first kind appear in vibration analysis, electromagnetic wave propagation, and signal processing applications.

BESSELK

Engineering

Returns the modified Bessel function of the second kind, Kn(x).

Pro Tip: Kn(x) decays exponentially for large x and is singular at x = 0. It often appears in radial heat flow and potential problems.

BESSELY

Engineering

Returns the Bessel function of the second kind, Yn(x).

Pro Tip: Yn(x) is also called the Neumann function. It is singular at x = 0 and is used alongside Jn(x) to form general solutions to Bessel's equation.

ENCODEURL

Web

Returns a URL-encoded string, replacing special characters with their percent-encoded equivalents.

Pro Tip: Use ENCODEURL to safely build query strings for WEBSERVICE calls. It encodes spaces, ampersands, equals signs, and other special URL characters.

FILTERXML

Web

Returns specific data from XML content by using the specified XPath expression.

Pro Tip: Combine with WEBSERVICE to fetch XML data from a URL and then extract specific values. XPath expressions are case-sensitive.

WEBSERVICE

Web

Returns data from a web service on the internet or intranet. The URL must return text-based data (XML, JSON, HTML, or plain text).

Pro Tip: WEBSERVICE only works with GET requests and returns a maximum of 32,767 characters. Combine with FILTERXML to parse XML responses or use MID/FIND for JSON.

CUBEMEMBER

Cube

Returns a member or tuple from an OLAP cube. Use to validate that the member or tuple exists in the cube.

Pro Tip: Use CUBEMEMBER as the foundation for other CUBE functions. The connection must be an existing OLAP data connection in the workbook.

CUBEVALUE

Cube

Returns an aggregated value from an OLAP cube.

Pro Tip: Pass multiple member expressions to slice the cube across different dimensions. You can reference CUBEMEMBER or CUBESET cells as arguments.

CUBESET

Cube

Defines a calculated set of members or tuples from an OLAP cube by sending a set expression to the server.

Pro Tip: Use CUBESET with CUBERANKEDMEMBER to create dynamic top-N reports from OLAP cubes without pivot tables.

CUBESETCOUNT

Cube

Returns the number of items in a set defined by CUBESET.

Pro Tip: Use CUBESETCOUNT to dynamically determine how many CUBERANKEDMEMBER formulas to use, or to validate that a set contains the expected number of items.

CUBERANKEDMEMBER

Cube

Returns the nth (ranked) member from a set. Use to return one or more elements from a set, such as the top sales performer.

Pro Tip: Combine with CUBESET (sorted by a measure) and CUBESETCOUNT to build dynamic top-N lists. Change the rank to pull different positions.

CUBEMEMBERPROPERTY

Cube

Returns the value of a member property from an OLAP cube. Confirms that a member name exists and returns the specified property.

Pro Tip: Member properties provide metadata like descriptions, keys, or custom attributes defined in the cube without needing a separate measure.

CUBEKPIMEMBER

Cube

Returns a Key Performance Indicator (KPI) name, property, and measure, and displays the name and property in the cell.

Pro Tip: KPI properties: 1 = Value, 2 = Goal, 3 = Status, 4 = Trend, 5 = Weight, 6 = Current Time Member. Use with CUBEVALUE to display the actual KPI number.

BETADIST

Compatibility

Returns the cumulative beta probability density function. Replaced by BETA.DIST in Excel 2010+.

Pro Tip: BETADIST is kept for backward compatibility. In new workbooks, use BETA.DIST with the cumulative argument set to TRUE for the same result.

BETAINV

Compatibility

Returns the inverse of the cumulative beta probability density function. Replaced by BETA.INV in Excel 2010+.

Pro Tip: Use BETA.INV in new workbooks. BETAINV remains available for compatibility with older spreadsheets.

BINOMDIST

Compatibility

Returns the individual term binomial distribution probability. Replaced by BINOM.DIST in Excel 2010+.

Pro Tip: Use BINOM.DIST in new workbooks. Set cumulative to TRUE for the probability of at most number_s successes.

CHIDIST

Compatibility

Returns the right-tailed probability of the chi-squared distribution. Replaced by CHISQ.DIST.RT in Excel 2010+.

Pro Tip: CHIDIST returns the right-tail probability. Use CHISQ.DIST.RT in new workbooks, or CHISQ.DIST with cumulative=TRUE for the left-tail.

CHIINV

Compatibility

Returns the inverse of the right-tailed probability of the chi-squared distribution. Replaced by CHISQ.INV.RT in Excel 2010+.

Pro Tip: Use CHISQ.INV.RT in new workbooks. CHIINV finds the x value where the right-tail area equals the given probability.

CONFIDENCE

Compatibility

Returns the confidence interval for a population mean using a normal distribution. Replaced by CONFIDENCE.NORM in Excel 2010+.

Pro Tip: Use CONFIDENCE.NORM in new workbooks. For T-distribution confidence intervals (small samples), use CONFIDENCE.T instead.

COVAR

Compatibility

Returns the population covariance of two data sets. Replaced by COVARIANCE.P in Excel 2010+.

Pro Tip: COVAR divides by n (population). Use COVARIANCE.S for the sample covariance (divides by n-1). In new workbooks use COVARIANCE.P.

CRITBINOM

Compatibility

Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. Replaced by BINOM.INV in Excel 2010+.

Pro Tip: Use BINOM.INV in new workbooks. CRITBINOM is the inverse of the cumulative binomial and is useful for determining pass/fail thresholds.

EXPONDIST

Compatibility

Returns the exponential distribution. Replaced by EXPON.DIST in Excel 2010+.

Pro Tip: Use EXPON.DIST in new workbooks. Set cumulative to FALSE for the probability density function.

FDIST

Compatibility

Returns the right-tailed F probability distribution. Replaced by F.DIST.RT in Excel 2010+.

Pro Tip: FDIST returns the right-tail probability, used in ANOVA F-tests. Use F.DIST.RT in new workbooks.

FINV

Compatibility

Returns the inverse of the right-tailed F probability distribution. Replaced by F.INV.RT in Excel 2010+.

Pro Tip: Use F.INV.RT in new workbooks. FINV finds the F value where the right-tail area equals the given probability.

FTEST

Compatibility

Returns the result of an F-test for two data sets (the two-tailed probability that the variances are not significantly different). Replaced by F.TEST in Excel 2010+.

Pro Tip: Use F.TEST in new workbooks. A small p-value (e.g. < 0.05) suggests the variances are significantly different.

GAMMADIST

Compatibility

Returns the gamma distribution. Replaced by GAMMA.DIST in Excel 2010+.

Pro Tip: Use GAMMA.DIST in new workbooks. The gamma distribution generalizes the exponential and chi-squared distributions.

GAMMAINV

Compatibility

Returns the inverse of the gamma cumulative distribution. Replaced by GAMMA.INV in Excel 2010+.

Pro Tip: Use GAMMA.INV in new workbooks. GAMMAINV solves for the x such that GAMMADIST(x, alpha, beta, TRUE) = probability.

HYPGEOMDIST

Compatibility

Returns the hypergeometric distribution probability. Replaced by HYPGEOM.DIST in Excel 2010+.

Pro Tip: Use HYPGEOM.DIST in new workbooks. Hypergeometric distribution models sampling without replacement, unlike the binomial.

LOGINV

Compatibility

Returns the inverse of the lognormal cumulative distribution function. Replaced by LOGNORM.INV in Excel 2010+.

Pro Tip: Use LOGNORM.INV in new workbooks. LOGINV and LOGNORMDIST use the mean and standard deviation of ln(x), not of x itself.

LOGNORMDIST

Compatibility

Returns the cumulative lognormal distribution. Replaced by LOGNORM.DIST in Excel 2010+.

Pro Tip: Use LOGNORM.DIST in new workbooks. Lognormal distributions model data that is the product of many random variables, like stock prices.

NEGBINOMDIST

Compatibility

Returns the negative binomial distribution. Replaced by NEGBINOM.DIST in Excel 2010+.

Pro Tip: Use NEGBINOM.DIST in new workbooks. The negative binomial models the number of failures before a specified number of successes.

NORMDIST

Compatibility

Returns the normal distribution for the specified mean and standard deviation. Replaced by NORM.DIST in Excel 2010+.

Pro Tip: Use NORM.DIST in new workbooks. Set cumulative to FALSE for the PDF (bell curve height) or TRUE for the CDF (area under the curve).

NORMINV

Compatibility

Returns the inverse of the normal cumulative distribution. Replaced by NORM.INV in Excel 2010+.

Pro Tip: Use NORM.INV in new workbooks. NORMINV is useful for calculating percentile-based thresholds.

NORMSDIST

Compatibility

Returns the standard normal cumulative distribution function (mean 0, standard deviation 1). Replaced by NORM.S.DIST in Excel 2010+.

Pro Tip: Use NORM.S.DIST in new workbooks. NORMSDIST is equivalent to NORMDIST(z, 0, 1, TRUE).

NORMSINV

Compatibility

Returns the inverse of the standard normal cumulative distribution (mean 0, standard deviation 1). Replaced by NORM.S.INV in Excel 2010+.

Pro Tip: Use NORM.S.INV in new workbooks. NORMSINV is commonly used to find z-scores for confidence levels.

PERCENTRANK

Compatibility

Returns the rank of a value in a data set as a percentage. Replaced by PERCENTRANK.INC in Excel 2010+.

Pro Tip: Use PERCENTRANK.INC (inclusive) or PERCENTRANK.EXC (exclusive) in new workbooks. The significance argument controls decimal places in the result.

POISSON

Compatibility

Returns the Poisson distribution. Replaced by POISSON.DIST in Excel 2010+.

Pro Tip: Use POISSON.DIST in new workbooks. The Poisson distribution models the number of events in a fixed interval when events occur independently at a constant rate.

TDIST

Compatibility

Returns the probability for the Student t-distribution. Replaced by T.DIST, T.DIST.RT, and T.DIST.2T in Excel 2010+.

Pro Tip: Use T.DIST.2T (two-tailed) or T.DIST.RT (right-tailed) in new workbooks. The tails argument must be 1 (one-tailed) or 2 (two-tailed).

TINV

Compatibility

Returns the inverse of the two-tailed Student t-distribution. Replaced by T.INV.2T in Excel 2010+.

Pro Tip: TINV always returns the two-tailed inverse. Use T.INV for one-tailed or T.INV.2T for two-tailed in new workbooks.

TTEST

Compatibility

Returns the probability associated with a Student t-test. Replaced by T.TEST in Excel 2010+.

Pro Tip: Use T.TEST in new workbooks. Type: 1 = paired, 2 = two-sample equal variance, 3 = two-sample unequal variance (Welch's test).

WEIBULL

Compatibility

Returns the Weibull distribution. Replaced by WEIBULL.DIST in Excel 2010+.

Pro Tip: Use WEIBULL.DIST in new workbooks. The Weibull distribution is widely used in reliability engineering and failure analysis.

ZTEST

Compatibility

Returns the one-tailed p-value of a z-test. Replaced by Z.TEST in Excel 2010+.

Pro Tip: Use Z.TEST in new workbooks. If sigma is omitted, the sample standard deviation is used. For a two-tailed test, multiply the result by 2.

GROUPBY

New / 365 Latest

Groups data by row fields and aggregates values using a specified function, returning a dynamic summary table.

Pro Tip: GROUPBY replaces many pivot table scenarios with a formula. You can pass built-in functions like SUM, AVERAGE, COUNT, or custom LAMBDA functions as the aggregation function.

PIVOTBY

New / 365 Latest

Creates a pivot-table-like summary with both row and column groupings, aggregating values using a specified function.

Pro Tip: PIVOTBY is the formula equivalent of a pivot table. It dynamically spills and updates. Use LAMBDA functions for custom aggregations like weighted averages.

PERCENTOF

New / 365 Latest

Calculates the percentage that a subset of data represents of a total data set.

Pro Tip: PERCENTOF is designed to work inside GROUPBY and PIVOTBY as the aggregation function, making percentage-of-total calculations effortless.

TRANSLATE

New / 365 Latest

Translates text from one language to another using Microsoft's cloud translation service.

Pro Tip: Omit the source_language to auto-detect. Language codes follow BCP 47 format (e.g., en, es, fr, de, ja, zh-Hans). Requires an internet connection.

DETECTLANGUAGE

New / 365 Latest

Detects the language of the given text and returns the language code using Microsoft's cloud language detection service.

Pro Tip: Use DETECTLANGUAGE to dynamically set the source_language argument in TRANSLATE, or to categorize multilingual data by language.

SUMX2MY2

Math & Trigonometry

Returns the sum of the difference of squares of corresponding values in two arrays. Calculates Σ(x²−y²).

Pro Tip: Useful in statistical regression analysis and hypothesis testing. Both arrays must have the same number of data points.

SUMX2PY2

Math & Trigonometry

Returns the sum of the sum of squares of corresponding values in two arrays. Calculates Σ(x²+y²).

Pro Tip: Often used in distance calculations and multivariate analysis. Both arrays must be the same length.

SUMXMY2

Math & Trigonometry

Returns the sum of squares of differences of corresponding values in two arrays. Calculates Σ(x−y)².

Pro Tip: This is the sum of squared residuals, a key component in least-squares regression. Useful for measuring the distance between two data sets.

BASE

Math & Trigonometry

Converts a decimal number into a text representation in another base (radix).

Pro Tip: Radix must be between 2 and 36. Use min_length to pad the result with leading zeros. For common bases, you can also use DEC2BIN, DEC2HEX, or DEC2OCT.

DECIMAL

Math & Trigonometry

Converts a text representation of a number in a given base into a decimal number.

Pro Tip: Radix must be between 2 and 36. This is the inverse of BASE. For common bases, you can also use BIN2DEC, HEX2DEC, or OCT2DEC.

SUMSQ

Math & Trigonometry

Returns the sum of the squares of the arguments.

Pro Tip: Useful in statistical calculations like variance and standard deviation. Equivalent to SUMPRODUCT(range, range) for a single range.

LOG10

Math & Trigonometry

Returns the base-10 logarithm of a number.

Pro Tip: Equivalent to LOG(number, 10). Use LN for natural logarithm (base e) and LOG for any arbitrary base.

SQRTPI

Math & Trigonometry

Returns the square root of (number × π).

Pro Tip: Commonly used in statistical formulas involving the normal distribution. Equivalent to SQRT(number*PI()).

ASINH

Math & Trigonometry

Returns the inverse hyperbolic sine of a number.

Pro Tip: The inverse hyperbolic sine is defined for all real numbers. It equals LN(number + SQRT(number² + 1)).

ACOSH

Math & Trigonometry

Returns the inverse hyperbolic cosine of a number. Number must be greater than or equal to 1.

Pro Tip: The input must be ≥ 1, otherwise the function returns a #NUM! error. Equals LN(number + SQRT(number² − 1)).

ATANH

Math & Trigonometry

Returns the inverse hyperbolic tangent of a number. Number must be between -1 and 1 (exclusive).

Pro Tip: Used in the Fisher transformation for correlation coefficients. Input must satisfy -1 < number < 1.

CSCH

Math & Trigonometry

Returns the hyperbolic cosecant of an angle specified in radians.

Pro Tip: CSCH is the reciprocal of SINH: CSCH(x) = 1/SINH(x). The input cannot be 0.

SECH

Math & Trigonometry

Returns the hyperbolic secant of an angle specified in radians.

Pro Tip: SECH is the reciprocal of COSH: SECH(x) = 1/COSH(x). Always returns a value between 0 and 1.

ACOTH

Math & Trigonometry

Returns the inverse hyperbolic cotangent of a number. The absolute value must be greater than 1.

Pro Tip: Returns #NUM! if the absolute value of the input is less than or equal to 1. Equals 0.5 * LN((number+1)/(number-1)).

COMBINA

Math & Trigonometry

Returns the number of combinations with repetitions for a given number of items.

Pro Tip: COMBINA allows items to be repeated, unlike COMBIN. Equals COMBIN(number + number_chosen - 1, number_chosen).

PERMUTATIONA

Math & Trigonometry

Returns the number of permutations for a given number of objects that can be selected from the total, with repetitions allowed.

Pro Tip: Equals number^number_chosen. Unlike PERMUT, items can be reused in each position.

FORECAST.ETS

Statistical

Returns a forecasted value for a specific target date using exponential triple smoothing (ETS), which captures seasonality patterns.

Pro Tip: Set seasonality to 0 for automatic detection, or 1 to disable seasonality. This function handles missing data points and irregular timelines better than FORECAST.

FORECAST.ETS.CONFINT

Statistical

Returns a confidence interval for the forecast value at the specified target date using exponential triple smoothing.

Pro Tip: The default confidence level is 0.95 (95%). Subtract/add this value from/to FORECAST.ETS to get the lower and upper bounds.

FORECAST.ETS.SEASONALITY

Statistical

Returns the length of the repetitive seasonal pattern that Excel detects in the specified time series.

Pro Tip: Use this to verify the seasonality FORECAST.ETS detects automatically. If the result seems wrong, override it manually in FORECAST.ETS.

FORECAST.ETS.STAT

Statistical

Returns a statistical value related to the ETS forecast model, such as alpha, beta, gamma, MASE, SMAPE, MAE, or RMSE.

Pro Tip: Statistic types: 1=Alpha, 2=Beta, 3=Gamma, 4=MASE, 5=SMAPE, 6=MAE, 7=RMSE, 8=Step size detected. Use MASE or SMAPE to evaluate forecast accuracy.

FORECAST.LINEAR

Statistical

Calculates a future value along a linear trend using existing values. This is the modern replacement for FORECAST.

Pro Tip: Identical to the legacy FORECAST function. Uses the equation y = a + bx where b = SLOPE and a = INTERCEPT. For non-linear or seasonal data, use FORECAST.ETS.

RSQ

Statistical

Returns the R-squared (coefficient of determination) of the linear regression line through the given data points.

Pro Tip: R² of 1 means a perfect fit, 0 means no linear relationship. RSQ equals PEARSON(known_ys, known_xs)². Use it to evaluate how well a linear model explains your data.

STEYX

Statistical

Returns the standard error of the predicted y-value for each x in a linear regression.

Pro Tip: A smaller STEYX indicates a tighter fit. Use it to build confidence intervals around FORECAST predictions: forecast ± t-value × STEYX.

FISHER

Statistical

Returns the Fisher transformation at x. This transforms the correlation coefficient so it is approximately normally distributed.

Pro Tip: x must be between -1 and 1 (exclusive). The Fisher transformation is 0.5 × LN((1+x)/(1−x)), equivalent to ATANH(x). Used to test the significance of correlation coefficients.

FISHERINV

Statistical

Returns the inverse of the Fisher transformation. Converts a Fisher-transformed value back to a correlation coefficient.

Pro Tip: The inverse Fisher transformation is (EXP(2y)−1)/(EXP(2y)+1), equivalent to TANH(y). Use after performing hypothesis tests on Fisher-transformed correlations.

PHI

Statistical

Returns the value of the density function for a standard normal distribution at x.

Pro Tip: PHI returns the probability density (height of the bell curve), not the cumulative probability. For cumulative probability use NORM.S.DIST(x, TRUE).

GAUSS

Statistical

Returns the probability that a member of a standard normal population will fall between the mean and z standard deviations from the mean.

Pro Tip: GAUSS(z) = NORM.S.DIST(z, TRUE) − 0.5. It gives the area under the curve between 0 and z. For negative z, the result is negative.

COVARIANCE.P

Statistical

Returns population covariance — the average of the products of deviations for each data point pair across two data sets.

Pro Tip: Population covariance divides by N. If your data is a sample, use COVARIANCE.S (divides by N−1). Covariance measures how two variables move together.

COVARIANCE.S

Statistical

Returns the sample covariance — the average of the products of deviations for each data point pair, using N−1 in the denominator.

Pro Tip: Use COVARIANCE.S for sample data (most real-world scenarios). It applies Bessel's correction (N−1) for an unbiased estimate.

PEARSON

Statistical

Returns the Pearson product-moment correlation coefficient r, a measure of the linear relationship between two data sets.

Pro Tip: PEARSON returns the same result as CORREL. A value near 1 indicates strong positive correlation, near -1 strong negative, and near 0 no linear relationship. Square it to get RSQ.

BETA.DIST

Statistical

Returns the beta distribution, commonly used to study percentage or proportion variation across samples.

Pro Tip: A and B define the lower and upper bounds of the interval (default 0 and 1). Set cumulative to TRUE for CDF, FALSE for PDF.

BETA.INV

Statistical

Returns the inverse of the cumulative beta distribution function for a specified probability.

Pro Tip: This is the quantile function of the beta distribution. Useful for finding critical values in Bayesian analysis.

HYPGEOM.DIST

Statistical

Returns the hypergeometric distribution — the probability of a given number of sample successes from a finite population.

Pro Tip: Use instead of BINOM.DIST when sampling without replacement. Common in quality control and card-drawing probability problems.

LOGNORM.DIST

Statistical

Returns the lognormal distribution of x, where the natural logarithm of x is normally distributed.

Pro Tip: The lognormal distribution is used to model positive-valued data that is right-skewed, like stock prices, income, and city sizes.

LOGNORM.INV

Statistical

Returns the inverse of the lognormal cumulative distribution function.

Pro Tip: Useful for finding threshold values. For example, if income follows a lognormal distribution, use this to find the income at a given percentile.

NEGBINOM.DIST

Statistical

Returns the negative binomial distribution — the probability of a specified number of failures before a given number of successes.

Pro Tip: Used in modeling count data with overdispersion (variance exceeds the mean), which the Poisson distribution cannot handle.

GAMMA

Statistical

Returns the Gamma function value. For positive integers, GAMMA(n) = (n-1)! (factorial).

Pro Tip: The Gamma function extends the factorial to non-integer and complex numbers. It returns #NUM! for zero and negative integers.

GAMMALN

Statistical

Returns the natural logarithm of the Gamma function, Γ(x). Useful for very large factorials where GAMMA would overflow.

Pro Tip: Use GAMMALN when working with large numbers to avoid overflow. You can compute the Gamma function as EXP(GAMMALN(x)).

GAMMALN.PRECISE

Statistical

Returns the natural logarithm of the Gamma function with higher precision than GAMMALN.

Pro Tip: Functionally equivalent to GAMMALN in most cases but provides better accuracy for edge cases. x must be positive.

DBCS

Text

Converts half-width (single-byte) characters to full-width (double-byte) characters in a text string. Used primarily for East Asian languages.

Pro Tip: This is the opposite of ASC. Only affects characters that have double-byte equivalents. Most useful when working with Japanese, Chinese, or Korean text formatting.

GETPIVOTDATA

Lookup & Reference

Extracts data stored in a PivotTable report. Returns summarized data from a PivotTable based on specified field/item pairs.

Pro Tip: Click on a PivotTable cell while typing a formula to auto-generate GETPIVOTDATA. To disable this, go to PivotTable Options > Generate GetPivotData.

FIELDVALUE

Lookup & Reference

Retrieves field data from linked data types such as Stocks, Geography, or Organization data types in Excel.

Pro Tip: You can also use the dot notation A2.Price instead of FIELDVALUE. This function works only with cells containing linked data types from Microsoft's cloud services.

DATESTRING

Date & Time

Converts a date serial number into a text string in the Japanese date format (Imperial era calendar).

Pro Tip: This function is specific to the Japanese version of Excel and uses the Japanese Emperor era calendar. It may not be available in all Excel versions.

AMORLINC

Financial

Returns the depreciation for each accounting period using linear depreciation prorated to the period of purchase (French accounting system).

Pro Tip: Used in the French accounting system. Unlike SLN, AMORLINC prorates the first and last period's depreciation based on the purchase date.

AMORDEGRC

Financial

Returns the depreciation for each accounting period using a degressive (accelerated) depreciation coefficient (French accounting system).

Pro Tip: The degressive coefficient depends on the asset's useful life: 1.0 for 3-4 years, 1.5 for 5-6 years, 2.0 for 6+ years. Specific to French tax depreciation rules.

COUPDAYBS

Financial

Returns the number of days from the beginning of a coupon period to the settlement date.

Pro Tip: Frequency: 1=Annual, 2=Semiannual, 4=Quarterly. Basis: 0=US 30/360, 1=Actual/actual, 2=Actual/360, 3=Actual/365, 4=European 30/360.

COUPDAYS

Financial

Returns the total number of days in the coupon period that contains the settlement date.

Pro Tip: Use COUPDAYBS/COUPDAYS to calculate accrued interest on bonds. The result depends on the day-count basis convention.

COUPDAYSNC

Financial

Returns the number of days from the settlement date to the next coupon date.

Pro Tip: Equals COUPDAYS minus COUPDAYBS. Useful for calculating clean vs. dirty bond prices.

COUPNCD

Financial

Returns the next coupon date after the settlement date as a serial date number.

Pro Tip: Format the result as a date to see the actual date. Use with COUPDAYSNC to determine how far away the next coupon payment is.

COUPNUM

Financial

Returns the number of coupon payments remaining between the settlement date and maturity date.

Pro Tip: The result is always rounded up to the nearest whole coupon. Multiply by coupon payment amount to estimate total remaining cash flows.

COUPPCD

Financial

Returns the previous coupon date before the settlement date as a serial date number.

Pro Tip: Format the result as a date. The difference between settlement and COUPPCD represents accrued interest days.

SYD

Financial

Returns the sum-of-years' digits depreciation of an asset for a specified period.

Pro Tip: SYD provides higher depreciation in early years. The formula is: (cost - salvage) × (life - per + 1) / (life × (life + 1) / 2).

VDB

Financial

Returns the depreciation of an asset for any period you specify using the variable declining balance method.

Pro Tip: VDB is the most flexible depreciation function. Set no_switch to TRUE to prevent switching to straight-line when declining balance depreciation is less than SLN.

ISPMT

Financial

Calculates the interest paid during a specific period of an investment with even principal payments.

Pro Tip: Unlike IPMT, ISPMT assumes even principal payments (not even total payments). The result is always negative for loans. Formula: pv × rate × (per/nper − 1).

PDURATION

Financial

Returns the number of periods required for an investment to reach a specified future value at a given interest rate.

Pro Tip: Uses the formula: (LOG(fv) − LOG(pv)) / LOG(1 + rate). Works with any consistent rate and period combination (annual, monthly, etc.).

RRI

Financial

Returns an equivalent interest rate for the growth of an investment over a given number of periods.

Pro Tip: RRI calculates the CAGR (Compound Annual Growth Rate): (fv/pv)^(1/nper) − 1. It assumes compound growth with no intermediate cash flows.

PRICEMAT

Financial

Returns the price per $100 face value of a security that pays interest at maturity.

Pro Tip: Unlike PRICE which is for periodic-coupon bonds, PRICEMAT handles securities where all interest is paid at maturity (e.g., certificates of deposit, zero-coupon bonds with accrued interest).

YIELDMAT

Financial

Returns the annual yield of a security that pays interest at maturity.

Pro Tip: This is the inverse of PRICEMAT. Use it to determine the yield when you know the market price of an interest-at-maturity security.

YIELDDISC

Financial

Returns the annual yield for a discounted security (e.g., Treasury bills).

Pro Tip: Discounted securities are bought below face value and redeemed at face value. The yield represents the annualized return from that discount.

PRICEDISC

Financial

Returns the price per $100 face value of a discounted security.

Pro Tip: Price = redemption − discount × redemption × (days to maturity / days in year). Common for Treasury bills and commercial paper.

ACCRINTM

Financial

Returns the accrued interest for a security that pays interest at maturity.

Pro Tip: Unlike ACCRINT which handles periodic coupon bonds, ACCRINTM is for securities where interest accrues until maturity (like CDs or zero-coupon notes).

ISNONTEXT

Information

Returns TRUE if the value is not text (numbers, dates, logicals, errors, blanks all return TRUE). Returns FALSE only for text strings.

Pro Tip: ISNONTEXT is the opposite of ISTEXT. Note that blank cells return TRUE for ISNONTEXT. Use it in data validation to ensure cells do not contain text.

IMSUM

Engineering

Returns the sum of two or more complex numbers in x+yi text format.

Pro Tip: All complex number arguments must be in text format like "a+bi". You can also use cell references containing complex number strings.

IMSUB

Engineering

Returns the difference of two complex numbers in x+yi text format.

Pro Tip: Order matters: IMSUB(a, b) returns a − b. For subtraction of multiple complex numbers, nest IMSUB calls or use IMSUM with negated values.

IMPRODUCT

Engineering

Returns the product of two or more complex numbers in x+yi text format.

Pro Tip: Complex multiplication uses (a+bi)(c+di) = (ac−bd) + (ad+bc)i. IMPRODUCT can take multiple arguments and multiplies them sequentially.

IMDIV

Engineering

Returns the quotient of two complex numbers in x+yi text format.

Pro Tip: Division is (a+bi)/(c+di) = ((ac+bd)/(c²+d²)) + ((bc−ad)/(c²+d²))i. Returns #NUM! if the divisor is zero.

IMPOWER

Engineering

Returns a complex number raised to a power.

Pro Tip: Uses De Moivre's theorem: (r×e^(iθ))^n = r^n × e^(i×n×θ). The exponent can be any real number, including negative and fractional values.

IMSQRT

Engineering

Returns the square root of a complex number in x+yi text format.

Pro Tip: Returns the principal square root. For real negative numbers, this gives you the imaginary result that SQRT cannot provide.

IMLN

Engineering

Returns the natural logarithm of a complex number in x+yi text format.

Pro Tip: The complex natural log is LN(|z|) + i×arg(z). For negative real numbers, this returns a result with π as the imaginary part.

IMLOG2

Engineering

Returns the base-2 logarithm of a complex number in x+yi text format.

Pro Tip: Computed as IMLN(inumber) / LN(2). Useful in signal processing and information theory involving complex signals.

IMLOG10

Engineering

Returns the base-10 logarithm of a complex number in x+yi text format.

Pro Tip: Computed as IMLN(inumber) / LN(10). Useful for decibel calculations in electrical engineering.

IMARGUMENT

Engineering

Returns the argument θ (theta) of a complex number, i.e., the angle in radians from the positive real axis.

Pro Tip: The argument is the angle in polar form: z = r × e^(iθ). Use with IMABS to convert between rectangular and polar representation.

IMCONJUGATE

Engineering

Returns the complex conjugate of a complex number (negates the imaginary part).

Pro Tip: The conjugate of a+bi is a−bi. Multiplying a complex number by its conjugate gives a real number: (a+bi)(a−bi) = a² + b².

IMCOS

Engineering

Returns the cosine of a complex number in x+yi text format.

Pro Tip: Complex cosine is defined as cos(a+bi) = cos(a)cosh(b) − i×sin(a)sinh(b). Essential in AC circuit analysis and wave propagation.

IMSIN

Engineering

Returns the sine of a complex number in x+yi text format.

Pro Tip: Complex sine is defined as sin(a+bi) = sin(a)cosh(b) + i×cos(a)sinh(b). Used in Fourier analysis and signal processing.

IMTAN

Engineering

Returns the tangent of a complex number in x+yi text format.

Pro Tip: Complex tangent equals IMSIN/IMCOS. Can return very large values near singularities of the tangent function.

IMEXP

Engineering

Returns the exponential of a complex number (e raised to the power of a complex number) in x+yi text format.

Pro Tip: By Euler's formula: e^(a+bi) = e^a × (cos(b) + i×sin(b)). This is fundamental to representing sinusoidal signals in engineering.

CHITEST

Compatibility

Returns the p-value from the chi-squared test for independence. Replaced by CHISQ.TEST in Excel 2010+.

Pro Tip: Use CHISQ.TEST in new workbooks. A small p-value (e.g., < 0.05) suggests the row and column variables are not independent.

STDEVP

Compatibility

Calculates the standard deviation based on the entire population. Replaced by STDEV.P in Excel 2010+.

Pro Tip: Use STDEV.P in new workbooks. STDEVP divides by N (population), while STDEV divides by N−1 (sample). Use STDEVP only when you have data for the entire population.

VARP

Compatibility

Calculates variance based on the entire population. Replaced by VAR.P in Excel 2010+.

Pro Tip: Use VAR.P in new workbooks. VARP divides the sum of squared deviations by N. For sample data, use VAR (which divides by N−1).

PERCENTRANK.INC

Statistical

Returns the rank of a value in a data set as a percentage (0 to 1, inclusive). This is the modern replacement for PERCENTRANK.

Pro Tip: PERCENTRANK.INC includes the endpoints 0 and 1. Use PERCENTRANK.EXC to exclude them (values range from 1/(n+1) to n/(n+1)).

PERCENTRANK.EXC

Statistical

Returns the rank of a value in a data set as a percentage, excluding 0 and 1 from the range.

Pro Tip: Values range from 1/(n+1) to n/(n+1). This avoids giving any value a rank of exactly 0% or 100%, which is statistically more rigorous for small samples.

T.DIST.2T

Statistical

Returns the two-tailed Student's t-distribution — the probability that a value falls outside ±x standard deviations.

Pro Tip: For hypothesis testing, compare the result to your significance level (e.g., 0.05). T.DIST.2T(x, df) = 2 × T.DIST.RT(x, df) when x > 0.

T.DIST.RT

Statistical

Returns the right-tailed Student's t-distribution — the probability that a value exceeds x.

Pro Tip: T.DIST.RT(x, df) = 1 − T.DIST(x, df, TRUE). Use for one-sided hypothesis tests where you only care about values greater than x.

T.INV.2T

Statistical

Returns the two-tailed inverse of the Student's t-distribution — the t-value for a given two-tailed probability.

Pro Tip: Use this for confidence interval calculations: mean ± T.INV.2T(alpha, df) × (stdev/SQRT(n)). Always returns a positive value.

F.DIST.RT

Statistical

Returns the right-tailed F probability distribution — the probability that an F-statistic exceeds x.

Pro Tip: Commonly used in ANOVA. F.DIST.RT(x, df1, df2) = 1 − F.DIST(x, df1, df2, TRUE). A small result suggests significant differences between groups.

F.INV.RT

Statistical

Returns the inverse of the right-tailed F probability distribution — the critical F-value for a given probability.

Pro Tip: Use to find the critical F-value in ANOVA. If your calculated F-statistic exceeds this value, reject the null hypothesis.

CHISQ.DIST.RT

Statistical

Returns the right-tailed probability of the chi-squared distribution.

Pro Tip: Chi-squared is always right-tailed in practice. CHISQ.DIST.RT(x, df) = 1 − CHISQ.DIST(x, df, TRUE).

CHISQ.INV.RT

Statistical

Returns the inverse of the right-tailed chi-squared distribution — the critical value for a given right-tail probability.

Pro Tip: Use to find chi-squared critical values for hypothesis testing. If your chi-squared statistic exceeds this value, reject the null hypothesis.

BINOM.DIST.RANGE

Statistical

Returns the probability of a trial result using a binomial distribution, optionally between two values.

Pro Tip: When number_s2 is provided, returns the cumulative probability from number_s to number_s2. Without it, returns the probability of exactly number_s successes.

BINOM.INV

Statistical

Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.

Pro Tip: This is the inverse of BINOM.DIST (cumulative). Use it to determine the minimum number of successes needed to exceed a given cumulative probability.

VARA

Compatibility

Estimates variance based on a sample, including text and logical values. Text and FALSE = 0, TRUE = 1.

Pro Tip: Use VAR.S if you want to ignore text and logical values. VARA is useful when TRUE/FALSE values are meaningful data points in your analysis.

VARPA

Compatibility

Calculates variance based on the entire population, including text and logical values. Text and FALSE = 0, TRUE = 1.

Pro Tip: Use VAR.P if you want to ignore text and logical values. VARPA divides by N (population count), unlike VARA which divides by N−1.

STDEVA

Compatibility

Estimates standard deviation based on a sample, including text and logical values. Text and FALSE = 0, TRUE = 1.

Pro Tip: Use STDEV.S if you want to ignore text and logical values. STDEVA is the square root of VARA.

STDEVPA

Compatibility

Calculates standard deviation based on the entire population, including text and logical values. Text and FALSE = 0, TRUE = 1.

Pro Tip: Use STDEV.P if you want to ignore text and logical values. STDEVPA is the square root of VARPA.

ERF.PRECISE

Engineering

Returns the error function integrated between 0 and x with higher precision.

Pro Tip: ERF.PRECISE always integrates from 0 to x, unlike ERF which can take a lower bound. Provides better numerical accuracy for edge cases.

ERFC.PRECISE

Engineering

Returns the complementary error function integrated between x and infinity with higher precision.

Pro Tip: ERFC.PRECISE(x) = 1 − ERF.PRECISE(x). More accurate than computing 1 − ERF(x) directly, especially for large x values.

ODDLYIELD

Financial

Returns the yield of a security with an odd (short or long) last coupon period.

Pro Tip: Use when the final coupon period is not a standard length. Pair with ODDLPRICE to value securities with irregular last periods.

ODDFYIELD

Financial

Returns the yield of a security with an odd (short or long) first coupon period.

Pro Tip: Use when the first coupon period after issue is not a standard length (e.g., a bond issued between regular coupon dates).

SKEW.P

Statistical

Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry around its mean.

Pro Tip: Positive skewness means a longer right tail, negative means longer left tail, zero means symmetric. Unlike SKEW, SKEW.P uses N (not N−1) and is for the full population.

New Workbook

File & Workbook

Windows: Ctrl + N | Mac: ⌘ + N

Create a new blank workbook.

Pro Tip: This opens a fresh workbook instantly without going through the File menu templates screen.

Open Workbook

File & Workbook

Windows: Ctrl + O | Mac: ⌘ + O

Open an existing workbook from your computer or recent files.

Pro Tip: Press Ctrl+O twice quickly to jump straight to the Browse dialog, bypassing the Backstage view.

Save Workbook

File & Workbook

Windows: Ctrl + S | Mac: ⌘ + S

Save the current workbook. Prompts Save As if the file has never been saved.

Pro Tip: Build a habit of pressing Ctrl+S after every significant change. AutoSave in Microsoft 365 does not replace intentional saving for non-cloud files.

Save As

File & Workbook

Windows: F12 | Mac: ⌘ + ⇧ + S

Save the workbook with a new name, location, or file format.

Pro Tip: Use Save As to quickly create a backup copy before making destructive changes to your data.

Print

File & Workbook

Windows: Ctrl + P | Mac: ⌘ + P

Open the Print dialog to preview and print the current worksheet.

Pro Tip: Set your print area first with Page Layout > Print Area to avoid printing blank pages.

Print Preview

File & Workbook

Windows: Ctrl + F2 | Mac: ⌘ + F2

Open Print Preview to see how the worksheet will look when printed.

Pro Tip: Always check Print Preview before printing to catch layout issues like cut-off columns.

Close Workbook

File & Workbook

Windows: Ctrl + W | Mac: ⌘ + W

Close the current workbook without closing Excel.

Pro Tip: If you have multiple workbooks open, this closes only the active one. Use Alt+F4 to close Excel entirely.

Close Excel

File & Workbook

Windows: Alt + F4 | Mac: ⌘ + Q

Close the Excel application entirely.

Pro Tip: Excel will prompt you to save any unsaved workbooks before closing.

Open Backstage / File Menu

File & Workbook

Windows: Alt + F | Mac: ⌘ + F

Open the File tab (Backstage view) for file operations.

Pro Tip: From Backstage, press I for Info, N for New, O for Open, and other letters for quick navigation.

Save as PDF

File & Workbook

Windows: F12, then choose PDF | Mac: ⌘ + ⇧ + S, then choose PDF

Save the current workbook as a PDF file via Save As dialog.

Pro Tip: Before saving as PDF, define the print area and check Page Break Preview to control which cells are exported.

Share Workbook

File & Workbook

Windows: Alt + F, H | Mac: ⌘ + ⇧ + E

Open the Share pane to share the workbook with others.

Pro Tip: The workbook must be saved to OneDrive or SharePoint before you can share it with real-time collaboration.

Open Recent

File & Workbook

Windows: Alt + F, R | Mac: ⌘ + O, then Recent

View the list of recently opened workbooks.

Pro Tip: Pin frequently used workbooks to the Recent list so they stay accessible even after opening many other files.

Close Workbook Window

File & Workbook

Windows: Ctrl + F4 | Mac: ⌘ + W

Close the active workbook window without closing other open workbooks.

Pro Tip: Ctrl+F4 closes only the active document window, which is useful when you have multiple workbooks open and want to close one at a time.

Save As Dialog (Alternative)

File & Workbook

Windows: Ctrl + Shift + S | Mac: ⌘ + ⇧ + S

Open the Save As dialog to save the workbook with a new name, location, or format.

Pro Tip: In Microsoft 365 with AutoSave enabled, Ctrl+Shift+S opens Save a Copy instead of Save As, preserving the original cloud file.

Move One Cell Up

Navigation

Windows: Up Arrow | Mac: Up Arrow

Move the active cell one row up.

Pro Tip: Combine with Shift to select while moving.

Move One Cell Down

Navigation

Windows: Down Arrow | Mac: Down Arrow

Move the active cell one row down.

Pro Tip: Press Enter to move down and confirm the current cell entry at the same time.

Move One Cell Left

Navigation

Windows: Left Arrow | Mac: Left Arrow

Move the active cell one column to the left.

Pro Tip: Press Shift+Tab to move left while in data entry mode.

Move One Cell Right

Navigation

Windows: Right Arrow | Mac: Right Arrow

Move the active cell one column to the right.

Pro Tip: Press Tab to move right and confirm the current cell entry simultaneously.

Jump to Edge of Data Region

Navigation

Windows: Ctrl + Arrow Key | Mac: ⌘ + Arrow Key

Jump to the last non-empty cell in the direction of the arrow, or to the next non-empty cell if currently on a blank.

Pro Tip: This is the fastest way to navigate large datasets. Ctrl+Down jumps to the last row of contiguous data in that column.

Go to Beginning of Worksheet

Navigation

Windows: Ctrl + Home | Mac: ⌃ + Home / ⌘ + Fn + Left Arrow

Move the active cell to cell A1.

Pro Tip: Great for quickly returning to the top-left corner after scrolling deep into a large spreadsheet.

Go to Last Used Cell

Navigation

Windows: Ctrl + End | Mac: ⌃ + End / ⌘ + Fn + Right Arrow

Move to the last cell that contains data or formatting in the worksheet.

Pro Tip: If this goes further than expected, there may be hidden formatting. Delete unused rows/columns to reset the used range.

Move to Beginning of Row

Navigation

Windows: Home | Mac: Home / Fn + Left Arrow

Move the active cell to column A of the current row.

Pro Tip: Combine with Shift+Home to select from the current cell to the start of the row.

Page Down

Navigation

Windows: Page Down | Mac: Page Down / Fn + Down Arrow

Scroll down one screen and move the active cell accordingly.

Pro Tip: The number of rows scrolled depends on how many rows are visible on your screen.

Page Up

Navigation

Windows: Page Up | Mac: Page Up / Fn + Up Arrow

Scroll up one screen and move the active cell accordingly.

Pro Tip: Use Alt+Page Down and Alt+Page Up to scroll one screen right or left.

Scroll One Screen Right

Navigation

Windows: Alt + Page Down | Mac: ⌥ + Page Down / Fn + ⌥ + Down Arrow

Scroll the view one screen to the right.

Pro Tip: Useful for wide datasets with many columns where horizontal scrolling is needed.

Scroll One Screen Left

Navigation

Windows: Alt + Page Up | Mac: ⌥ + Page Up / Fn + ⌥ + Up Arrow

Scroll the view one screen to the left.

Pro Tip: Combine with the right-scroll shortcut to quickly pan across wide spreadsheets.

Go To Cell (Name Box)

Navigation

Windows: Ctrl + G / F5 | Mac: ⌃ + G / F5

Open the Go To dialog to jump to a specific cell reference or named range.

Pro Tip: Type a cell address like Z1000 directly in the Name Box (left of the formula bar) and press Enter for even faster navigation.

Switch to Next Worksheet Tab

Navigation

Windows: Ctrl + Page Down | Mac: ⌃ + Page Down / ⌥ + Right Arrow

Move to the next worksheet tab in the workbook.

Pro Tip: Hold Ctrl and press Page Down repeatedly to cycle through multiple sheets quickly.

Switch to Previous Worksheet Tab

Navigation

Windows: Ctrl + Page Up | Mac: ⌃ + Page Up / ⌥ + Left Arrow

Move to the previous worksheet tab in the workbook.

Pro Tip: Combine with Shift to select multiple sheets: Ctrl+Shift+Page Up/Down.

Move Between Unlocked Cells

Navigation

Windows: Tab | Mac: Tab

Move to the next unlocked cell on a protected sheet.

Pro Tip: On unprotected sheets, Tab moves one cell to the right. On protected sheets, it skips locked cells.

Scroll Without Moving Active Cell

Navigation

Windows: Scroll Lock + Arrow Keys | Mac: Scroll Lock + Arrow Keys

Scroll the worksheet without changing the active cell position.

Pro Tip: Check if Scroll Lock is active by looking at the status bar at the bottom of Excel.

Move to Next Pane

Navigation

Windows: F6 | Mac: F6

Move to the next pane in a split worksheet or between Ribbon, worksheet, and status bar.

Pro Tip: Use Shift+F6 to move to the previous pane. Useful when you have split the window into multiple views.

Switch Between Open Workbooks

Navigation

Windows: Ctrl + Tab | Mac: ⌘ + ` (backtick)

Cycle through open Excel workbook windows.

Pro Tip: Use Ctrl+Shift+Tab to cycle in reverse order through open workbooks.

Navigate to Name Box

Navigation

Windows: Ctrl + F5 (click Name Box) | Mac: Click Name Box

Activate the Name Box to type a cell address or named range directly.

Pro Tip: Type a range like A1:D10 in the Name Box and press Enter to select that entire range instantly.

Move Within a Selection

Navigation

Windows: Enter / Shift + Enter | Mac: Return / ⇧ + Return

Move down (Enter) or up (Shift+Enter) within a selected range without leaving the selection.

Pro Tip: After selecting a range, use Tab and Enter to fill in data cell by cell within that range only.

Scroll to Active Cell

Navigation

Windows: Ctrl + Backspace | Mac: ⌘ + Delete

Scroll the worksheet to bring the active cell back into view without changing the selection.

Pro Tip: If you have scrolled far away from the active cell, this instantly brings the view back to it without losing your place in the data.

Next Workbook Window

Navigation

Windows: Ctrl + F6 | Mac: ⌘ + ` (backtick)

Switch to the next open workbook window.

Pro Tip: This is especially useful when working with multiple Excel files side by side for data comparison or cross-referencing.

Previous Workbook Window

Navigation

Windows: Ctrl + Shift + F6 | Mac: ⌘ + ⇧ + ` (backtick)

Switch to the previous open workbook window.

Pro Tip: Use this to quickly toggle back to the workbook you were just working in, like Alt+Tab but within Excel only.

Move Clockwise in Selection Corners

Navigation

Windows: Ctrl + . (period) | Mac: ⌃ + . (period)

Move the active cell clockwise to the next corner of the selected range.

Pro Tip: When you have a large range selected, use this to jump between the four corners to verify the selection boundaries without deselecting.

Select Multiple Sheets Left

Navigation

Windows: Ctrl + Shift + Page Up | Mac: ⌃ + ⇧ + Page Up

Add the previous worksheet tab to the selection of grouped sheets.

Pro Tip: This lets you group-select multiple adjacent sheets for batch operations like formatting or printing without using the mouse.

Select Multiple Sheets Right

Navigation

Windows: Ctrl + Shift + Page Down | Mac: ⌃ + ⇧ + Page Down

Add the next worksheet tab to the selection of grouped sheets.

Pro Tip: After grouping sheets, any edits such as typing data or applying formatting will apply to all grouped sheets simultaneously.

Select Entire Row

Selection

Windows: Shift + Space | Mac: ⇧ + Space

Select the entire row of the active cell.

Pro Tip: After selecting a row, press Ctrl+Minus to delete it or Ctrl+Plus to insert a new row above.

Select Entire Column

Selection

Windows: Ctrl + Space | Mac: ⌃ + Space

Select the entire column of the active cell.

Pro Tip: If you are in edit mode, Ctrl+Space may trigger autocomplete. Press Escape first to exit edit mode.

Select All Cells

Selection

Windows: Ctrl + A | Mac: ⌘ + A

Select all cells in the worksheet. If inside a data region, first press selects the region, second press selects the entire sheet.

Pro Tip: Click the Select All button at the intersection of row and column headers for the same effect.

Extend Selection One Cell

Selection

Windows: Shift + Arrow Key | Mac: ⇧ + Arrow Key

Extend the current selection by one cell in the arrow direction.

Pro Tip: This is the fundamental building block for keyboard-based range selection.

Extend Selection to Edge of Data

Selection

Windows: Ctrl + Shift + Arrow Key | Mac: ⌘ + ⇧ + Arrow Key

Extend the selection to the last non-empty cell in the arrow direction.

Pro Tip: Use Ctrl+Shift+End to select from the current cell to the last used cell in the worksheet.

Select to Beginning of Worksheet

Selection

Windows: Ctrl + Shift + Home | Mac: ⌃ + ⇧ + Home

Extend the selection from the current cell to cell A1.

Pro Tip: Useful for selecting all data from the current position back to the top-left corner.

Select to Last Used Cell

Selection

Windows: Ctrl + Shift + End | Mac: ⌃ + ⇧ + End

Extend the selection from the current cell to the last used cell.

Pro Tip: If the selection extends beyond your actual data, clear formatting from unused cells to shrink the used range.

Select to Beginning of Row

Selection

Windows: Shift + Home | Mac: ⇧ + Home / ⇧ + Fn + Left Arrow

Extend the selection from the current cell to the beginning of the row.

Pro Tip: Combine with Ctrl+Shift+Home to select from current cell to A1.

Select Visible Cells Only

Selection

Windows: Alt + ; (semicolon) | Mac: ⌘ + ⇧ + Z

Select only the visible cells in the current selection, excluding hidden rows and columns.

Pro Tip: Essential when copying filtered data. Without this, pasting may include hidden rows, causing data errors.

Add Non-Adjacent Cells to Selection

Selection

Windows: Ctrl + Click | Mac: ⌘ + Click

Add individual cells or ranges to the current selection without deselecting.

Pro Tip: You can also hold Ctrl and drag to add multiple non-contiguous ranges to your selection.

Select Current Region

Selection

Windows: Ctrl + Shift + * (asterisk) | Mac: ⌃ + ⇧ + * (asterisk)

Select the current data region around the active cell, bounded by empty rows and columns.

Pro Tip: This is the same region that Ctrl+T uses to detect table boundaries. Great for quickly selecting a data block.

Select Array Formula Range

Selection

Windows: Ctrl + / | Mac: ⌃ + /

Select the array that contains the active cell.

Pro Tip: Helpful for identifying the full extent of a legacy CSE (Ctrl+Shift+Enter) array formula.

Select Cells with Comments

Selection

Windows: Ctrl + Shift + O | Mac: ⌃ + ⇧ + O

Select all cells that contain comments or notes.

Pro Tip: Use this to quickly audit which cells have annotations before sharing a workbook.

Select Row Differences

Selection

Windows: Ctrl + \ | Mac: ⌃ + \

In a selected range, select cells in each row that differ from the comparison cell.

Pro Tip: The comparison cell is the active cell in the selection. Use this to spot inconsistencies across rows.

Select Column Differences

Selection

Windows: Ctrl + Shift + | | Mac: ⌃ + ⇧ + |

In a selected range, select cells in each column that differ from the comparison cell.

Pro Tip: Useful for QA checks on columnar data where values should be consistent.

Select Direct Dependents

Selection

Windows: Ctrl + ] | Mac: ⌃ + ]

Select cells that directly depend on (reference) the active cell.

Pro Tip: Use Ctrl+Shift+] to select all dependents, including indirect ones.

Select Direct Precedents

Selection

Windows: Ctrl + [ | Mac: ⌃ + [

Select cells that are directly referenced by the formula in the active cell.

Pro Tip: Use Ctrl+Shift+[ to select all precedents, including indirect ones. Great for formula auditing.

Collapse Selection to Active Cell

Selection

Windows: Shift + Backspace | Mac: ⇧ + Delete

Reduce the current selection to only the active cell.

Pro Tip: When you have a large range selected and want to keep only the active cell selected without clicking, this shortcut collapses the selection instantly.

Copy

Editing & Data Entry

Windows: Ctrl + C | Mac: ⌘ + C

Copy the selected cells to the clipboard.

Pro Tip: The marching ants border around copied cells disappears after you press Escape or perform another action. Paste before that happens for Paste Special options.

Cut

Editing & Data Entry

Windows: Ctrl + X | Mac: ⌘ + X

Cut the selected cells to the clipboard for moving.

Pro Tip: Cut and Paste in Excel updates all formula references automatically, unlike Copy and Paste which copies formulas as-is.

Paste

Editing & Data Entry

Windows: Ctrl + V | Mac: ⌘ + V

Paste the clipboard contents into the selected cell(s).

Pro Tip: If you get unexpected results, use Ctrl+Z to undo and then try Paste Special for more control.

Paste Special

Editing & Data Entry

Windows: Ctrl + Alt + V | Mac: ⌘ + ⌃ + V

Open the Paste Special dialog for pasting only values, formulas, formats, or other attributes.

Pro Tip: Paste Special > Values is the most common choice. It strips formulas and pastes only the calculated results.

Paste Values Only

Editing & Data Entry

Windows: Ctrl + Alt + V, then V, Enter | Mac: ⌘ + ⌃ + V, then V, Return

Paste only the values (no formulas or formatting) from the clipboard.

Pro Tip: An even faster method: after copying, press Alt+H, V, V to paste values via the Ribbon in one sequence.

Undo

Editing & Data Entry

Windows: Ctrl + Z | Mac: ⌘ + Z

Undo the last action. Can be pressed multiple times to undo several steps.

Pro Tip: Excel keeps up to 100 undo levels. However, some actions like deleting a sheet cannot be undone.

Redo

Editing & Data Entry

Windows: Ctrl + Y | Mac: ⌘ + Y

Redo the last undone action.

Pro Tip: Ctrl+Y also repeats the last action. For example, if you just inserted a row, Ctrl+Y inserts another row.

Fill Down

Editing & Data Entry

Windows: Ctrl + D | Mac: ⌘ + D

Fill the selected cells downward with the content of the topmost cell.

Pro Tip: Select a range where the top cell has your formula, then Ctrl+D fills it into all selected cells below.

Fill Right

Editing & Data Entry

Windows: Ctrl + R | Mac: ⌘ + R

Fill the selected cells to the right with the content of the leftmost cell.

Pro Tip: Works like Fill Down but horizontally. Select from the source cell rightward, then press Ctrl+R.

Edit Active Cell (Enter Edit Mode)

Editing & Data Entry

Windows: F2 | Mac: F2 / ⌃ + U

Enter edit mode for the active cell, placing the cursor at the end of the cell content.

Pro Tip: Press F2 to toggle between Edit mode and Point mode when building formulas. In Point mode, arrow keys select cell references instead of moving the cursor.

Delete Cell Content

Editing & Data Entry

Windows: Delete | Mac: Delete / Fn + Backspace

Clear the contents of the selected cells without removing formatting.

Pro Tip: Use Ctrl+Minus to delete entire cells/rows/columns. The Delete key only clears content, not the cells themselves.

Clear All (Content, Format, Comments)

Editing & Data Entry

Windows: Alt + H, E, A | Mac: ⌘ + ⇧ + Delete (or Menu)

Clear everything from the selected cells: contents, formatting, and comments.

Pro Tip: Use the Clear menu (Alt+H, E) to choose what to clear: All, Formats, Contents, Comments, or Hyperlinks.

Enter Data and Move Down

Editing & Data Entry

Windows: Enter | Mac: Return

Confirm the cell entry and move to the cell below.

Pro Tip: You can change the direction Enter moves in File > Options > Advanced > 'After pressing Enter, move selection.'

Enter Data and Stay in Cell

Editing & Data Entry

Windows: Ctrl + Enter | Mac: ⌃ + Return

Confirm the cell entry and keep the active cell in the same position.

Pro Tip: If you have multiple cells selected, Ctrl+Enter fills the same value into all selected cells simultaneously.

Enter Data and Move Up

Editing & Data Entry

Windows: Shift + Enter | Mac: ⇧ + Return

Confirm the cell entry and move to the cell above.

Pro Tip: Useful when entering data in a column from bottom to top.

Cancel Cell Entry

Editing & Data Entry

Windows: Escape | Mac: Escape

Cancel the current cell entry or operation and revert to the previous value.

Pro Tip: Press Escape to dismiss dialog boxes, cancel drag operations, or exit edit mode without changes.

Insert Current Date

Editing & Data Entry

Windows: Ctrl + ; (semicolon) | Mac: ⌃ + ; (semicolon)

Insert today's date as a static value in the active cell.

Pro Tip: Unlike the TODAY() function, this inserts a fixed date that will not change when the workbook recalculates.

Insert Current Time

Editing & Data Entry

Windows: Ctrl + Shift + ; (semicolon) | Mac: ⌘ + ; (semicolon)

Insert the current time as a static value in the active cell.

Pro Tip: Combine date and time by pressing Ctrl+; then Space then Ctrl+Shift+; to get a full timestamp.

Insert Line Break in Cell

Editing & Data Entry

Windows: Alt + Enter | Mac: ⌥ + Return

Start a new line within the same cell.

Pro Tip: The cell must have Wrap Text enabled for the line break to be visible. Excel enables it automatically when you use this shortcut.

Delete Cells / Rows / Columns

Editing & Data Entry

Windows: Ctrl + - (minus) | Mac: ⌘ + - (minus)

Delete the selected cells, rows, or columns, with options to shift remaining cells.

Pro Tip: Select entire rows or columns first (Shift+Space or Ctrl+Space) before pressing Ctrl+Minus for cleaner deletions.

Insert Cells / Rows / Columns

Editing & Data Entry

Windows: Ctrl + Shift + + (plus) | Mac: ⌘ + ⇧ + + (plus)

Insert new cells, rows, or columns at the selection.

Pro Tip: Select multiple rows or columns first to insert that many at once. Formulas referencing the area adjust automatically.

Open Spell Check

Editing & Data Entry

Windows: F7 | Mac: F7

Start the spell checker for the current worksheet.

Pro Tip: Spell check starts from the active cell and works through the sheet. Select a range first to check only that area.

Flash Fill

Editing & Data Entry

Windows: Ctrl + E | Mac: ⌘ + E

Automatically fill values based on a detected pattern from adjacent data.

Pro Tip: Type one or two examples in the column next to your data, then press Ctrl+E. Excel detects the pattern and fills the rest.

Copy Formula from Cell Above

Editing & Data Entry

Windows: Ctrl + ' (apostrophe) | Mac: ⌃ + ' (apostrophe)

Copy the formula from the cell directly above into the active cell and enter edit mode.

Pro Tip: Unlike Ctrl+D which copies and confirms, Ctrl+' copies the formula and lets you edit it before pressing Enter. Great for tweaking a formula from the row above.

Copy Value from Cell Above

Editing & Data Entry

Windows: Ctrl + Shift + " (double quote) | Mac: ⌃ + ⇧ + " (double quote)

Copy the displayed value (not the formula) from the cell directly above into the active cell.

Pro Tip: This pastes the static value, not the formula. Useful when you want to hard-code a result from the cell above without inheriting its formula.

Bold

Formatting

Windows: Ctrl + B | Mac: ⌘ + B

Toggle bold formatting on the selected cells.

Pro Tip: Bold works as a toggle. Press Ctrl+B again to remove bold from already-bolded text.

Italic

Formatting

Windows: Ctrl + I | Mac: ⌘ + I

Toggle italic formatting on the selected cells.

Pro Tip: Italic text can be harder to read in smaller font sizes. Consider using bold or color instead for emphasis in data cells.

Underline

Formatting

Windows: Ctrl + U | Mac: ⌘ + U

Toggle underline formatting on the selected cells.

Pro Tip: For double underline (common in accounting), use the Format Cells dialog: Ctrl+1, then Font tab.

Strikethrough

Formatting

Windows: Ctrl + 5 | Mac: ⌘ + ⇧ + X

Toggle strikethrough formatting on the selected cells.

Pro Tip: Strikethrough is great for marking completed items in task lists without deleting the text.

Open Format Cells Dialog

Formatting

Windows: Ctrl + 1 | Mac: ⌘ + 1

Open the Format Cells dialog box for detailed formatting options.

Pro Tip: This is the most powerful formatting dialog in Excel. It gives you access to Number, Alignment, Font, Border, Fill, and Protection tabs.

Increase Font Size

Formatting

Windows: Alt + H, F, G | Mac: ⌘ + ⇧ + > (period)

Increase the font size of the selected cells.

Pro Tip: Each press increases to the next standard font size (e.g., 10 to 11 to 12 to 14).

Decrease Font Size

Formatting

Windows: Alt + H, F, K | Mac: ⌘ + ⇧ + < (comma)

Decrease the font size of the selected cells.

Pro Tip: Each press decreases to the next smaller standard font size.

Apply Outline Border

Formatting

Windows: Ctrl + Shift + & | Mac: ⌘ + ⌥ + 0 (zero)

Apply an outline border around the selected cells.

Pro Tip: This applies a thin border around the outer edges of the selection only, not between individual cells.

Remove All Borders

Formatting

Windows: Ctrl + Shift + _ (underscore) | Mac: ⌘ + ⌥ + - (minus)

Remove all borders from the selected cells.

Pro Tip: This removes only borders, not gridlines. Gridlines are controlled separately in the View tab.

Align Left

Formatting

Windows: Ctrl + L | Mac: ⌘ + L

Left-align the contents of the selected cells.

Pro Tip: Text is left-aligned by default in Excel, while numbers are right-aligned. Changing alignment can indicate that data types may be incorrect.

Align Center

Formatting

Windows: Ctrl + E | Mac: ⌘ + E

Center-align the contents of the selected cells.

Pro Tip: Note: Ctrl+E may trigger Flash Fill in newer Excel versions if you are in a data column. Use the Ribbon or Format Cells dialog as an alternative.

Align Right

Formatting

Windows: Ctrl + R | Mac: ⌘ + R

Right-align the contents of the selected cells.

Pro Tip: Note: Ctrl+R is also Fill Right. The behavior depends on context. Use the Home tab alignment buttons if ambiguous.

Indent Cell Content

Formatting

Windows: Alt + H, 6 | Mac: ⌃ + ⌥ + Tab

Increase the indent level of cell contents.

Pro Tip: Indenting is useful for creating visual hierarchy in text-heavy columns like category breakdowns.

Decrease Indent

Formatting

Windows: Alt + H, 5 | Mac: ⌃ + ⌥ + ⇧ + Tab

Decrease the indent level of cell contents.

Pro Tip: Indent level cannot go below zero. Remove indents to restore the default alignment.

Merge and Center Cells

Formatting

Windows: Alt + H, M, C | Mac: ⌃ + ⌥ + Return (or Menu)

Merge the selected cells into one and center the content.

Pro Tip: Avoid merging cells in data tables as it breaks sorting, filtering, and many formulas. Use 'Center Across Selection' from Format Cells > Alignment instead.

Wrap Text

Formatting

Windows: Alt + H, W | Mac: ⌘ + 1, then Alignment tab

Toggle text wrapping in the selected cells so content displays on multiple lines.

Pro Tip: Wrap Text automatically adjusts row height to show all content. Double-click the row border to auto-fit height after enabling.

Apply Comma Style (Thousands Separator)

Formatting

Windows: Ctrl + Shift + 1 | Mac: ⌃ + ⇧ + 1

Apply the Number format with thousands separator and two decimal places.

Pro Tip: This applies the format #,##0.00 which shows negative numbers with a minus sign.

Toggle Cell Gridlines View

Formatting

Windows: Alt + W, V, G | Mac: View menu > Gridlines

Show or hide cell gridlines in the worksheet.

Pro Tip: Hiding gridlines gives a cleaner presentation look. Add borders manually where needed for visual structure.

Copy Formatting (Format Painter)

Formatting

Windows: Alt + H, F, P (then click target) | Mac: ⌘ + ⌥ + C (copy format)

Copy the formatting from the selected cell and apply it to another cell or range.

Pro Tip: Double-click the Format Painter button to lock it on. Then click multiple cells to apply the same format. Press Escape to turn it off.

Paste Formatting Only

Formatting

Windows: Ctrl + Alt + V, T, Enter | Mac: ⌘ + ⌥ + V, then Formats

Paste only the formatting (no values or formulas) from the clipboard.

Pro Tip: First copy a formatted cell with Ctrl+C, then use this to apply its formatting to other cells.

Style Dialog

Formatting

Windows: Alt + ' (apostrophe) | Mac: ⌘ + ⌥ + ' (apostrophe)

Open the Style dialog to apply or modify cell styles.

Pro Tip: Cell styles let you apply consistent formatting across your workbook. Modify a style once and all cells using that style update automatically.

Open Font Dialog

Formatting

Windows: Ctrl + Shift + F | Mac: ⌘ + ⇧ + F

Open the Font tab of the Format Cells dialog for detailed font settings.

Pro Tip: The Font dialog gives access to advanced options like superscript, subscript, strikethrough, and special underline styles not available on the Ribbon.

Select Font Size Box

Formatting

Windows: Ctrl + Shift + P | Mac: ⌘ + ⇧ + P

Activate the Font Size box on the Ribbon to type a custom font size.

Pro Tip: After pressing this shortcut, type any font size (even non-standard values like 13 or 15) and press Enter to apply it.

Fill Color (Background)

Formatting

Windows: Alt + H, H | Mac: Via Home tab > Fill Color

Open the Fill Color dropdown to apply a background color to selected cells.

Pro Tip: Click the dropdown arrow for the full color palette. The button itself applies the last used color, so click it directly for quick repeat coloring.

Font Color

Formatting

Windows: Alt + H, F, C | Mac: Via Home tab > Font Color

Open the Font Color dropdown to change the text color of selected cells.

Pro Tip: Use dark colors on light backgrounds for readability. The button applies the last used color; click the dropdown arrow for more options.

Borders Menu

Formatting

Windows: Alt + H, B | Mac: Via Home tab > Borders

Open the Borders dropdown menu to apply various border styles to selected cells.

Pro Tip: The borders menu includes options for top, bottom, left, right, all borders, thick borders, and even drawing custom borders with the mouse.

Apply Thin Outline Border

Formatting

Windows: Ctrl + Shift + 7 | Mac: ⌘ + ⌥ + 0 (zero)

Apply a thin outline border around the selected cells.

Pro Tip: This is equivalent to Ctrl+Shift+& on most keyboard layouts. It applies only the outer border of the selection, not internal cell borders.

Center Align (Ribbon)

Formatting

Windows: Alt + H, A, C | Mac: ⌘ + E

Center-align the contents of the selected cells using the Ribbon command.

Pro Tip: This Ribbon path avoids the Flash Fill conflict that Ctrl+E can cause in data columns. Use it when you specifically want center alignment.

Apply General Number Format

Number Formatting

Windows: Ctrl + Shift + ~ (tilde) | Mac: ⌃ + ⇧ + ~ (tilde)

Apply the General number format, removing any special formatting.

Pro Tip: General format displays numbers as-is with no fixed decimal places, thousands separators, or currency symbols.

Apply Currency Format

Number Formatting

Windows: Ctrl + Shift + $ (dollar) | Mac: ⌃ + ⇧ + $ (dollar)

Apply the Currency format with two decimal places and a dollar sign.

Pro Tip: This applies the locale-specific currency symbol. For a different currency, use Format Cells > Number > Currency and choose the symbol.

Apply Percentage Format

Number Formatting

Windows: Ctrl + Shift + % (percent) | Mac: ⌃ + ⇧ + % (percent)

Apply the Percentage format with zero decimal places.

Pro Tip: Excel multiplies the cell value by 100 when displaying as a percentage. A cell with 0.25 displays as 25%. Enter the decimal value, not the percentage.

Apply Scientific Notation Format

Number Formatting

Windows: Ctrl + Shift + ^ (caret) | Mac: ⌃ + ⇧ + ^ (caret)

Apply the Scientific (exponential) number format with two decimal places.

Pro Tip: Scientific notation is useful for very large or very small numbers like 1.23E+08 instead of 123,000,000.

Apply Date Format

Number Formatting

Windows: Ctrl + Shift + # (hash) | Mac: ⌃ + ⇧ + # (hash)

Apply the Date format (DD-MMM-YY, e.g., 15-Mar-26).

Pro Tip: Excel stores dates as serial numbers internally. Applying date format makes the serial number display as a human-readable date.

Apply Time Format

Number Formatting

Windows: Ctrl + Shift + @ (at) | Mac: ⌃ + ⇧ + @ (at)

Apply the Time format (h:mm AM/PM).

Pro Tip: Excel stores times as decimal fractions of a day. 0.5 equals 12:00 PM, 0.75 equals 6:00 PM.

Increase Decimal Places

Number Formatting

Windows: Alt + H, 0 | Mac: ⌃ + ⇧ + ! (on some Mac layouts)

Add one decimal place to the displayed number format.

Pro Tip: This changes only the display, not the stored value. The full precision value is always used in calculations.

Decrease Decimal Places

Number Formatting

Windows: Alt + H, 9 | Mac: Via Ribbon or Format Cells

Remove one decimal place from the displayed number format.

Pro Tip: Be careful: hiding decimals can create apparent rounding errors in totals (e.g., 33 + 33 + 33 = 100 when values are 33.33).

Apply Number Format with Commas

Number Formatting

Windows: Ctrl + Shift + ! (exclamation) | Mac: ⌃ + ⇧ + ! (exclamation)

Apply the Number format with two decimal places, thousands separator, and minus sign for negatives.

Pro Tip: This is the same as the comma style but without a currency symbol. Good for general-purpose numeric formatting.

Start a Formula

Formulas

Windows: = (equals sign) | Mac: = (equals sign)

Begin entering a formula in the active cell.

Pro Tip: You can also start a formula with + or - but the equals sign is the standard and most reliable approach.

AutoSum

Formulas

Windows: Alt + = | Mac: ⌘ + ⇧ + T

Automatically insert a SUM formula for the adjacent range of numbers.

Pro Tip: AutoSum is smart about detecting the range. Place your cursor below a column of numbers or to the right of a row, then press Alt+=.

Toggle Absolute / Relative Reference

Formulas

Windows: F4 | Mac: F4 / ⌘ + T

Cycle through absolute and relative cell references in a formula ($A$1, A$1, $A1, A1).

Pro Tip: Place the cursor on a cell reference within the formula bar and press F4 to cycle. $A$1 locks both, A$1 locks row, $A1 locks column, A1 locks neither.

Show All Formulas

Formulas

Windows: Ctrl + ` (grave accent) | Mac: ⌃ + ` (grave accent)

Toggle between displaying cell values and displaying formulas in the worksheet.

Pro Tip: This is invaluable for auditing. Columns auto-widen to show full formulas. Press the shortcut again to return to normal view.

Insert Function Dialog

Formulas

Windows: Shift + F3 | Mac: ⇧ + F3

Open the Insert Function dialog to browse and search for functions.

Pro Tip: Use the search box in the dialog to find functions by description, e.g., 'count if' will suggest COUNTIF and COUNTIFS.

Enter Array Formula (Legacy)

Formulas

Windows: Ctrl + Shift + Enter | Mac: ⌃ + ⇧ + Return

Enter a formula as a legacy array formula (CSE formula) with curly braces.

Pro Tip: In Microsoft 365, regular Enter creates dynamic arrays automatically. CSE arrays are only needed for backward compatibility.

Evaluate Formula Step by Step

Formulas

Windows: Alt + M, V | Mac: Via Formulas tab > Evaluate Formula

Open the Evaluate Formula dialog to step through a formula calculation.

Pro Tip: Click Evaluate repeatedly to see each part of the formula calculated in sequence. Essential for debugging complex nested formulas.

Define a Name

Formulas

Windows: Ctrl + F3 | Mac: ⌃ + F3

Open the Name Manager to create, edit, or delete named ranges.

Pro Tip: Named ranges make formulas more readable: =SUM(Revenue) is clearer than =SUM(B2:B100). They also auto-update when you add data to a Table.

Create Names from Selection

Formulas

Windows: Ctrl + Shift + F3 | Mac: ⌃ + ⇧ + F3

Automatically create named ranges from row or column headers in the selection.

Pro Tip: Select your data with headers, then use this shortcut. Excel creates a named range for each column using the header text.

Trace Precedents

Formulas

Windows: Alt + M, P | Mac: Via Formulas tab > Trace Precedents

Draw arrows showing which cells are referenced by the active cell's formula.

Pro Tip: Each press adds another level of precedent arrows. Use Alt+M, A, A to remove all trace arrows.

Trace Dependents

Formulas

Windows: Alt + M, D | Mac: Via Formulas tab > Trace Dependents

Draw arrows showing which cells depend on (reference) the active cell.

Pro Tip: Use this to understand the downstream impact before changing or deleting a cell's value.

Calculate All Workbooks

Formulas

Windows: F9 | Mac: F9

Recalculate all formulas in all open workbooks.

Pro Tip: Only needed when calculation mode is set to Manual. In Automatic mode, formulas recalculate on every change.

Calculate Active Worksheet

Formulas

Windows: Shift + F9 | Mac: ⇧ + F9

Recalculate formulas only on the active worksheet.

Pro Tip: Faster than F9 when you have multiple large workbooks open and only need to refresh the current sheet.

Insert Function Arguments

Formulas

Windows: Ctrl + Shift + A | Mac: ⌃ + ⇧ + A

After typing a function name, insert the argument placeholders for that function.

Pro Tip: Type =VLOOKUP then press Ctrl+Shift+A to instantly see =VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) with all argument names filled in.

Trace Precedents - Go To

Formulas

Windows: Ctrl + [ | Mac: ⌃ + [

Navigate directly to the cells referenced by the formula in the active cell.

Pro Tip: Unlike the Trace Precedents arrows (Alt+M, P), this shortcut jumps you directly to the precedent cells, selecting them for immediate inspection.

Trace Dependents - Go To

Formulas

Windows: Ctrl + ] | Mac: ⌃ + ]

Navigate directly to cells that depend on the active cell.

Pro Tip: Use this to quickly find which formulas reference the current cell, jumping directly to them rather than just drawing trace arrows.

Force Recalculate All

Formulas

Windows: Ctrl + Alt + F9 | Mac: ⌃ + ⌥ + F9

Recalculate all formulas in all open workbooks, regardless of whether they have changed.

Pro Tip: Use this when you suspect formulas are not updating correctly. It forces a full recalculation even for cells that Excel thinks have not changed.

Insert Row

Rows & Columns

Windows: Select row, then Ctrl + Shift + + | Mac: Select row, then ⌘ + ⇧ + +

Insert a new row above the selected row.

Pro Tip: Select multiple rows first to insert that many rows at once. Existing formulas and references adjust automatically.

Insert Column

Rows & Columns

Windows: Select column, then Ctrl + Shift + + | Mac: Select column, then ⌘ + ⇧ + +

Insert a new column to the left of the selected column.

Pro Tip: Select multiple columns first to insert that many columns at once.

Delete Row

Rows & Columns

Windows: Select row, then Ctrl + - | Mac: Select row, then ⌘ + -

Delete the selected row(s) and shift remaining rows up.

Pro Tip: Ctrl+Z can undo row deletion. But be careful: deleting rows in shared workbooks can cause conflicts.

Delete Column

Rows & Columns

Windows: Select column, then Ctrl + - | Mac: Select column, then ⌘ + -

Delete the selected column(s) and shift remaining columns left.

Pro Tip: Check for formulas referencing the column before deleting. Deletion causes #REF! errors in dependent formulas.

Hide Selected Rows

Rows & Columns

Windows: Ctrl + 9 | Mac: ⌃ + 9

Hide the selected rows from view.

Pro Tip: Hidden rows are still included in formulas. Use SUBTOTAL or AGGREGATE functions if you want to exclude hidden rows from calculations.

Unhide Selected Rows

Rows & Columns

Windows: Ctrl + Shift + 9 | Mac: ⌃ + ⇧ + 9

Unhide hidden rows within the selection.

Pro Tip: Select the rows above and below the hidden rows first, then use this shortcut. If row 1 is hidden, select all with Ctrl+A first.

Hide Selected Columns

Rows & Columns

Windows: Ctrl + 0 (zero) | Mac: ⌃ + 0 (zero)

Hide the selected columns from view.

Pro Tip: Hidden columns are still included in formula references and calculations.

Unhide Selected Columns

Rows & Columns

Windows: Ctrl + Shift + 0 | Mac: ⌃ + ⇧ + 0

Unhide hidden columns within the selection.

Pro Tip: Select the columns on both sides of the hidden columns first. This shortcut may not work on some systems; use the right-click context menu as a fallback.

AutoFit Column Width

Rows & Columns

Windows: Alt + H, O, I | Mac: Via Format menu > Column > AutoFit

Automatically adjust the column width to fit the widest content.

Pro Tip: Select all columns (Ctrl+A) first, then AutoFit to resize all columns at once. You can also double-click the column border in the header.

AutoFit Row Height

Rows & Columns

Windows: Alt + H, O, A | Mac: Via Format menu > Row > AutoFit

Automatically adjust the row height to fit the tallest content.

Pro Tip: Useful after enabling Wrap Text to make sure all multiline content is fully visible.

Group Rows or Columns

Rows & Columns

Windows: Alt + Shift + Right Arrow | Mac: ⌘ + ⇧ + K

Group the selected rows or columns for collapsible outlining.

Pro Tip: Grouping creates expandable/collapsible sections. Use it for detail rows under summary rows to create a structured report.

Ungroup Rows or Columns

Rows & Columns

Windows: Alt + Shift + Left Arrow | Mac: ⌘ + ⇧ + J

Ungroup the selected rows or columns, removing the outline level.

Pro Tip: Select the exact same range that was grouped before ungrouping.

Insert New Worksheet

Worksheets

Windows: Shift + F11 | Mac: ⇧ + F11

Insert a new blank worksheet before the active sheet.

Pro Tip: You can also press Alt+H, I, S or click the + icon next to sheet tabs.

Go to Next Worksheet

Worksheets

Windows: Ctrl + Page Down | Mac: ⌃ + Page Down / ⌥ + Right Arrow

Switch to the next worksheet tab.

Pro Tip: Works cyclically: from the last sheet it wraps around to the first sheet.

Go to Previous Worksheet

Worksheets

Windows: Ctrl + Page Up | Mac: ⌃ + Page Up / ⌥ + Left Arrow

Switch to the previous worksheet tab.

Pro Tip: Combine with Shift to group-select multiple sheets: Ctrl+Shift+Page Up.

Rename Worksheet

Worksheets

Windows: Double-click tab / Alt + H, O, R | Mac: Double-click tab

Rename the active worksheet tab.

Pro Tip: Use short, descriptive names without special characters. Sheet names appear in formulas referencing other sheets.

Delete Worksheet

Worksheets

Windows: Alt + H, D, S | Mac: Via Edit menu or right-click tab

Delete the active worksheet permanently.

Pro Tip: This action cannot be undone with Ctrl+Z. Excel will warn you if the sheet contains data.

Move or Copy Worksheet

Worksheets

Windows: Alt + H, O, M (or right-click tab) | Mac: Right-click tab > Move or Copy

Open the Move or Copy dialog to reorder or duplicate a worksheet.

Pro Tip: Check 'Create a copy' to duplicate the sheet. You can also move sheets between open workbooks using this dialog.

Select Multiple Worksheets

Worksheets

Windows: Ctrl + Click tabs | Mac: ⌘ + Click tabs

Select multiple non-adjacent worksheet tabs for group editing.

Pro Tip: Any changes you make (formatting, data entry) while sheets are grouped apply to all selected sheets simultaneously.

Select All Worksheets

Worksheets

Windows: Right-click tab > Select All Sheets | Mac: Right-click tab > Select All Sheets

Select all worksheet tabs in the workbook for group operations.

Pro Tip: Be very careful: any edits or deletions while all sheets are selected affect every single sheet. Ungroup by clicking any single tab.

Protect Worksheet

Worksheets

Windows: Alt + R, P, S | Mac: Via Review tab > Protect Sheet

Toggle worksheet protection to prevent changes to locked cells.

Pro Tip: Unlock specific cells first (Format Cells > Protection > uncheck Locked) before protecting the sheet so users can still edit those cells.

Tab Color

Worksheets

Windows: Right-click tab > Tab Color | Mac: Right-click tab > Tab Color

Change the color of a worksheet tab for visual organization.

Pro Tip: Use a consistent color-coding system: green for final data, yellow for work-in-progress, red for do-not-edit.

Hide Worksheet

Worksheets

Windows: Right-click tab > Hide | Mac: Right-click tab > Hide

Hide the active worksheet from the tab bar.

Pro Tip: For stronger protection, use VBA to set a sheet as 'xlSheetVeryHidden' which cannot be unhidden from the right-click menu.

Delete Worksheet (Alternative)

Worksheets

Windows: Alt + E, L | Mac: Via Edit menu > Delete Sheet

Delete the active worksheet using the legacy Edit menu shortcut.

Pro Tip: This is a legacy shortcut from older Excel versions that still works. Excel will warn you before deleting a sheet that contains data.

Find

Find & Replace

Windows: Ctrl + F | Mac: ⌘ + F

Open the Find dialog to search for text, numbers, or formulas.

Pro Tip: Click Options in the Find dialog to search within formulas, values, or comments, and to choose whether to search the current sheet or entire workbook.

Find Next

Find & Replace

Windows: Ctrl + G / F3 (after Find) | Mac: ⌘ + G

Find the next occurrence of the search term.

Pro Tip: After opening Find with Ctrl+F, press Enter or click Find Next to cycle through matches.

Find Previous

Find & Replace

Windows: Ctrl + Shift + F4 | Mac: ⌘ + ⇧ + G

Find the previous occurrence of the search term.

Pro Tip: In the Find dialog, Shift+Enter also searches backwards.

Replace

Find & Replace

Windows: Ctrl + H | Mac: ⌃ + H

Open the Find and Replace dialog to find and substitute values.

Pro Tip: Use Replace All carefully. Always check with Find All first to preview all matches. Ctrl+Z can undo a Replace All operation.

Go To Dialog

Find & Replace

Windows: Ctrl + G / F5 | Mac: ⌃ + G / F5

Open the Go To dialog for navigating to specific cells or named ranges.

Pro Tip: The Go To dialog remembers your previous destinations, making it quick to jump back to previously visited locations.

Go To Special

Find & Replace

Windows: Ctrl + G, then Special (or Alt + S) | Mac: ⌃ + G, then Special

Open Go To Special to select cells by type: blanks, formulas, constants, errors, etc.

Pro Tip: Go To Special > Blanks is incredibly useful. Select your range, Go To Special > Blanks, then type a formula and press Ctrl+Enter to fill all blanks at once.

Find All (List All Matches)

Find & Replace

Windows: Ctrl + F, then Alt + A (Find All button) | Mac: ⌘ + F, then Find All

List all cells matching the search criteria in a scrollable results list.

Pro Tip: Click any result to jump to that cell. Click column headers in the results list to sort matches. Press Ctrl+A in the results to select all matching cells.

Replace All

Find & Replace

Windows: Ctrl + H, then Alt + A | Mac: ⌃ + H, then Replace All

Replace all occurrences of the search term at once.

Pro Tip: Excel reports how many replacements were made. If the number is unexpected, immediately Ctrl+Z to undo and refine your search criteria.

Toggle AutoFilter

Data Tools

Windows: Ctrl + Shift + L | Mac: ⌘ + ⇧ + L

Toggle AutoFilter dropdown arrows on the header row.

Pro Tip: Click inside your data table first. Excel auto-detects the header row. If it gets it wrong, select the correct header row before applying.

Sort Ascending (A-Z)

Data Tools

Windows: Alt + A, S, A | Mac: Via Data tab > Sort A to Z

Sort the selected column in ascending order (A-Z or smallest to largest).

Pro Tip: Click a single cell in the column you want to sort. Excel will sort the entire data range. Sorting a partial selection can misalign your data.

Sort Descending (Z-A)

Data Tools

Windows: Alt + A, S, D | Mac: Via Data tab > Sort Z to A

Sort the selected column in descending order (Z-A or largest to smallest).

Pro Tip: To sort by multiple columns, use the Sort dialog (Alt+A, S, S) to add multiple sort levels.

Custom Sort Dialog

Data Tools

Windows: Alt + A, S, S | Mac: Via Data tab > Sort

Open the Sort dialog for multi-level sorting with advanced options.

Pro Tip: You can sort by cell color, font color, or cell icon in addition to values. Add multiple levels to break ties.

Data Validation

Data Tools

Windows: Alt + A, V, V | Mac: Via Data tab > Data Validation

Open the Data Validation dialog to set rules for cell input.

Pro Tip: Use data validation to create dropdown lists (Allow: List), restrict numbers to a range, or enforce date boundaries. Add input messages to guide users.

Remove Duplicates

Data Tools

Windows: Alt + A, M | Mac: Via Data tab > Remove Duplicates

Open the Remove Duplicates dialog to delete duplicate rows.

Pro Tip: Always make a backup before removing duplicates. You can choose which columns to compare, so partial duplicates can be detected.

Text to Columns

Data Tools

Windows: Alt + A, E | Mac: Via Data tab > Text to Columns

Split text in one column into multiple columns based on a delimiter.

Pro Tip: Text to Columns can also fix data format issues. If dates are imported as text, running Text to Columns (Finish immediately) can convert them to real dates.

Create Table

Data Tools

Windows: Ctrl + T | Mac: ⌘ + T

Convert a data range into a formatted Excel Table with filter headers.

Pro Tip: Tables auto-expand when you add data below or beside them. Formulas in Tables use structured references that are more readable and maintainable.

Insert PivotTable

Data Tools

Windows: Alt + N, V | Mac: Via Insert tab > PivotTable

Create a PivotTable from the selected data for summarization and analysis.

Pro Tip: Select any cell in your data range before inserting. Using an Excel Table as the source ensures the PivotTable auto-includes new rows.

Refresh Data Connection

Data Tools

Windows: Ctrl + Alt + F5 | Mac: ⌘ + ⌥ + F5

Refresh all external data connections in the workbook.

Pro Tip: Use this to update PivotTables, Power Query results, and linked data from external sources.

Refresh Active Data Source

Data Tools

Windows: Alt + F5 | Mac: ⌥ + F5

Refresh the data connection for the active PivotTable or query.

Pro Tip: Faster than refreshing all connections when you only need to update one data source.

Group Data (PivotTable)

Data Tools

Windows: Alt + Shift + Right Arrow | Mac: ⌘ + ⇧ + K

Group selected items in a PivotTable or group rows/columns in the worksheet.

Pro Tip: In PivotTables, grouping dates lets you summarize by month, quarter, or year. Select date cells and group for automatic date grouping.

Toggle AutoFilter (Data Tab)

Data Tools

Windows: Alt + A, T | Mac: Via Data tab > Filter

Toggle AutoFilter on or off using the Data tab Ribbon shortcut.

Pro Tip: This is the Data tab alternative to Ctrl+Shift+L. Both shortcuts toggle the same filter dropdowns on the header row.

Sort Dialog (Data Tab)

Data Tools

Windows: Alt + A, S, S | Mac: Via Data tab > Sort

Open the full Sort dialog from the Data tab for multi-level sorting.

Pro Tip: The Sort dialog lets you add multiple sort levels, sort by cell color or icon, and choose custom sort orders for specialized sorting needs.

Open Filter Dropdown

Data Tools

Windows: Alt + Down Arrow | Mac: ⌥ + Down Arrow

Open the AutoFilter dropdown menu for the active column header.

Pro Tip: When the active cell is in a filtered header row, this opens the filter dropdown without needing to click the small arrow button with the mouse.

Open Help

Function Keys

Windows: F1 | Mac: F1

Open the Excel Help pane.

Pro Tip: Type your question directly in the Help search box. You can also press F1 while in a dialog box to get help specific to that dialog.

Edit Active Cell

Function Keys

Windows: F2 | Mac: F2

Enter edit mode for the active cell with the cursor at the end.

Pro Tip: In edit mode, arrow keys move the cursor within the cell text. Press F2 again to switch to Point mode where arrow keys select cell references.

Paste Name / Insert Function

Function Keys

Windows: F3 | Mac: F3

Paste a defined name into a formula, or open the Paste Name dialog.

Pro Tip: When in a formula, F3 shows a list of all named ranges you can insert at the cursor position.

Repeat Last Action

Function Keys

Windows: F4 | Mac: F4

Repeat the last action performed (outside of formula editing).

Pro Tip: F4 has dual behavior: in a formula it toggles absolute references; outside a formula it repeats the last action like formatting or inserting.

Move to Next Pane / UI Element

Function Keys

Windows: F6 | Mac: F6

Cycle between the worksheet, Ribbon, task pane, and status bar.

Pro Tip: Useful for keyboard-only navigation. Shift+F6 cycles in the reverse direction.

Spell Check

Function Keys