Microsoft Excel - Functions

Learn how to subtract values in Microsoft Excel using cell references, minus signs, and nested operations, and practice adding and subtracting in one formula with brackets and complex numbers.

Explore multiplying and dividing values in Excel using formulas, the star symbol, and cell references like C3 and D3, with absolute references and drag down techniques.

Learn how to use the average function in Microsoft Excel, selecting ranges or noncontiguous cells, entering =average(...), and verify results with sum and count checks.

Learn how to use the count function in Microsoft Excel to count numeric values in a range, with examples using C2:C6 and dynamic results when data changes.

Learn to use the trim function in Microsoft Excel to convert uneven spacing into equal spacing by applying =TRIM to a cell.

Learn how the mod function in Excel returns the remainder of a division, with examples such as 10 divided by 3 and 12 divisible by 3 or 4.

Excel's floor function rounds down a number to the nearest multiple of a specified divisor, unlike the ceiling function, revealing the greatest value divisible by that divisor.

Learn how to use the date function in Microsoft Excel to assemble a date from year, month, and day, and apply different date formats including the United Kingdom style.

Learn to build times in microsoft excel using the time function by combining hours, minutes, and seconds, converting decimals to time, and formatting for am/pm display.

Learn to use the if function to test whether a player's status equals not out and return yes or no, then drag to apply to the rest.

Use the if function in Microsoft Excel to compare values to 500, returning yes for greater than 500 and, by swapping the operator, yes for less than 500.

Discover how to use the match function in Microsoft Excel to locate a value's position in a range, with examples like 38 at position 6 and 89 at position 9.

Explore how the choose function in Microsoft Excel selects a value from a list by position, with practical examples and guidance on typing cell references.

Master the concatenate function in Excel to merge separated data into a full name or date format, adding spaces or slashes as separators.

Explore how to use the replace function in Microsoft Excel to swap old text for new data using the start number, number of characters, and practical examples.

Master the substitute function in Microsoft Excel to replace text within cells, see its case sensitivity with examples like lime to time, ball to hole, and bat to hat.

Learn how to use Excel's left and right functions to extract characters from text, with examples using Sam, Tom, and Jerry to return the first or last letters.

Learn how to apply the upper and lower functions in Excel to convert names like Tom, Sam, and Jerry into uppercase or lowercase, and automatically fill results across rows.

Learn to extract day, month, and year from a date time value in Excel using day, month, and year functions, and use the now function for the date and time.

Extract hour, minute, and second from a current date-time in Excel using the HOUR, MINUTE, and SECOND functions, demonstrated with a B2 time value and the now function.

Learn how the proper function formats names by capitalizing the first letter and lowering the rest in Microsoft Excel. The video shows applying proper function to sample data.

Learn how to use the COUNTA function in Microsoft Excel to count non-empty cells in a range with =COUNTA(range); it does not count empty cells.

Learn how to use the count blank function in Excel to count blank cells in a range, including multiple columns, and sum the results.

Master the countif function in Microsoft Excel by counting values based on criteria such as greater than, less than, and equal to 21 within a data range.

Use the row function in Microsoft Excel to retrieve a cell's row number, as row(d5) returns 5 and updates when you drag across rows.