Excel Functions

Explore the fundamentals of Excel functions, including what a function is, how to write its syntax with inputs and arguments, and how ranges, columns, and rows define cell addresses.

Explore how to use sum and average functions in Excel to add numbers within a range or array and compute their average.

Learn how to use sumif and sumifs in Excel to add values based on one or multiple conditions. See syntax, range, criteria, and practical class totals and brand reports.

Learn how to use Excel functions count, countif, and countifs to tally numbers in a range, count blanks, and count cells that meet specific conditions across multiple ranges.

Use COUNTIF to compare two lists, determine which items from the child list exist in the mother list, and identify the missing entries.

Learn to use vlookup to find a lookup value in a table and return its price in dollars or egyptian pounds with exact match, plus handle errors with iferror.

Learn how to use the row, column, and int functions in Excel to return a cell's row and column numbers and the integer part of values.

This lecture explains the Excel if function, a logical test that returns a value if true or false. It covers the syntax—condition, value_if_true, value_if_false—and an example labeling numbers with yes or no.

Explore how the index function retrieves a value from a range by row and column location, with an optional final argument, illustrated by copying a list between sheets in Excel.

Explore the Excel min, max, small, and large functions to identify extrema and order statistics in a range, including the first or third smallest values, with ascending or descending sorts.

Learn how the excel function match locates the position of a value within a range using exact, less than or equal, or greater than or equal rules, with practical circuit breaker examples.

Explore how the offset function uses a starting address, moves rows and columns, and defines height and width to return a dynamic range, which you can use in sums.

Learn how the subtotal function aggregates ranges by selecting a function number and a range, enabling totals on filtered data and explaining how it can ignore certain classes.

Learn how to use the excel transpose function to switch rows and columns by applying =transpose to a selected range, using the correct syntax and ctrl+shift+enter.

Learn how to use the Excel convert function to transform a number from one unit to another, using number, from, and to arguments with practical inch-to-meter and horsepower examples.

Learn how to use the ceiling and floor functions in Excel to round numbers to the nearest multiple of a given significance, with practical examples.

Explore the Excel cell function and its two arguments: information type and an optional reference. Learn how omitting the second argument retrieves information about the current cell.

Use find, search, and len functions in Excel to locate text and measure length. Understand that find is case sensitive, while search is not, and how wildcards work.

Learn how to extract text with left, right, and mid functions in Excel. Use left for left part, right for right part, and mid for start and length extractions.

Learn how the Excel substitute function replaces text using three arguments: text, old_text, and new_text, with an example replacing dash g endings with dash one.

Explore Excel's trim, lower, and upper functions to normalize text. Trim removes extra spaces, and lower and upper convert to lowercase and uppercase respectively, each taking a single text argument.

Explore the Excel text function, which formats a value using a specified format with two arguments: value and format, showing how 22 becomes a four-digit number using 0000.

Explore Excel date and time functions, including now, day, month, year, and text to format dates and compute tomorrow’s date.