Excel Formulas & Functions with Online Practice Files

Discover free videos and tutorials to master Excel formulas and functions. Practice directly in our Online Excel Practice Files without downloading anything. Have questions? Drop them in the comments. Let’s begin!

Basic Excel Formulas and Functions - Online Practice Worksheets

Excel Function
Description
Video Tutorial

Practice File

Excel SUM Function

The SUM function adds numbers, cell ranges, or a combination of both.

Watch Video
Excel Average Function

The AVERAGE function in Excel calculates the arithmetic mean of a group of numbers.

Watch Video
Excel MAX Function

The MAX function in Excel returns the largest value in a set of numbers or range.

Excel MIN Function

The MIN function in Excel returns the smallest value in a set of numbers or range.

Excel ROUND Function

The ROUND function in Excel rounds a number to a specified number of decimal places.

Watch Video
Excel ROUNDUP Function
The ROUNDUP function in Excel rounds a number up, away from zero, to a specified number of decimal places.
Watch Video
Excel ROUNDDOWN Function
The ROUNDDOWN function in Excel rounds a number down, towards zero, to a specified number of decimal places
Watch Video
Excel SUBTOTAL Function
The SUBTOTAL function in Excel calculates a subtotal for a range, allowing different types of calculations while ignoring hidden rows.

Excel Date Formulas and Functions - Online Practice Excel Files

Excel Function
Description
Video Tutorial

Practice File

Excel Today Function

The TODAY function returns the current date based on your system’s clock, updating automatically each day.

Watch Video
Excel NOW Function

The NOW function in Excel is used to display the current date and time based on your system clock. It updates automatically whenever the worksheet is recalculated.

Watch Video
Excel DATE Function

The DATE function in Excel creates a date using year, month, and day values.

Watch Video
Excel WEEKDAY Function

The WEEKDAY function in Excel returns the day of the week as a number, given a date. It helps in identifying which day corresponds to a specific date.

Watch Video
Excel WEEKNUM Function

The WEEKNUM function in Excel returns the week number of a given date within a year. You can specify whether the week starts on Sunday or Monday using the optional return_type argument.

Watch Video
Excel WORKDAY Function

The WORKDAY function returns a date that is a specified number of workdays before or after a start date, excluding weekends and holidays.

Watch Video
Excel WORKDAY.INTL Function

WORKDAY.INTL returns a date after adding or subtracting workdays from a start date, considering custom weekends and holidays.

Watch Video
Excel DATEVALUE Function

DATEVALUE converts a date in text format to a serial number that Excel recognizes as a date.

Excel DAY,MONTH,YEAR Function

DAY, MONTH, and YEAR functions extract the day, month, and year from a given date, respectively.

Excel HOUR, MINUTE, SECOND Function
The HOUR, MINUTE, and SECOND functions in Excel extract the hour, minute, and second from a given time, respectively.
Excel NETWORKDAYS Function
The NETWORKDAYS function in Excel calculates the number of working days (excluding weekends and optionally holidays) between two dates.

Excel Mathematical Functions - Free Practice Assigments

Excel Function
Description
Video Tutorial

Practice File

Excel SUMIF Function

The SUMIF function in Excel adds the values in a range that meet a specific condition (criteria)

Watch Video
Excel SUMIFS Function

The SUMIFS function in Excel sums values based on multiple criteria.

Watch Video
Excel COUNTIF Function

The COUNTIF function in Excel counts the number of cells that meet a specified condition.

Watch Video
Excel COUNTIFS Function

The COUNTIFS function in Excel counts the number of cells that meet multiple criteria across different ranges.

Watch Video
Excel RAND Function

The RAND function in Excel generates a random decimal number between 0 and 1.

Watch Video
Excel ROMAN Function

The ROMAN function in Excel converts a number to its Roman numeral representation.

Excel COUNT Function

The COUNT function in Excel counts the number of cells that contain numbers in a given range.

Watch Video
Excel COUNTA Function

The COUNTA function counts all non-blank cells in a range, including text, numbers, and errors, but ignores blanks.

Watch Video
Excel COUNTBLANK Function

The COUNTBLANK function in Excel counts the number of completely blank cells in a range.

Excel AVERAGEIF Function

The AVERAGEIF function in Excel calculates the average of cells that meet a specific condition or criteria.

Watch Video
Excel AVERAGEIFS Function

The AVERAGEIFS function in Excel calculates the average of cells that meet multiple criteria.

Watch Video
Excel RAND AND RANDBETWEEN Function
The RAND function generates a random decimal between 0 and 1, while the RANDBETWEEN function generates a random integer between specified numbers.
Watch Video
Excel SUMPRODUCT Function

SUMPRODUCT function performs multiplication of numbers within arrays and then sum the values

Excel Statistical Functions - Online Practice Excel Files

Excel Function
Description
Video Tutorial

Practice File

Excel LARGE Function
The LARGE function in Excel returns the k-th largest value in a data set, based on the specified position (k) in the sorted range
Excel LOWER Function

The LOWER function in Excel converts all letters in a text string to lowercase.

Excel RANK Function

The RANK function in Excel returns the position of a number in a sorted list.

Excel MOD Function
The MOD function in Excel returns the remainder after dividing one number by another.
Excel SMALL Function

The SMALL function in Excel returns the k-th smallest value in a data set.

Excel Text Functions - Online Practice Excel Files

Excel Function
Description
Video Tutorial

Practice File

Excel CONCATENATE Function
The CONCATENATE function in Excel joins two or more text strings into one string.
Excel LEN Function

The LEN function in Excel returns the total number of characters in a text string, including spaces.

Excel PROPER Function
The PROPER function in Excel capitalizes the first letter of each word and converts the rest to lowercase.
Excel TRIM Function

The TRIM function in Excel removes extra spaces from text, leaving only single spaces between words.

Excel LEFT Function
The LEFT function in Excel extracts a specified number of characters from the beginning (left side) of a text string.
Excel MID Function
The MID function in Excel extracts a specific number of characters from a text string, starting at a given position.
Excel RIGHT Function
The RIGHT function in Excel extracts a specified number of characters from the end (right side) of a text string.
Excel TEXT Function

The TEXT function in Excel formats a number or date as text, according to a specified format.

Excel FIND Function

The FIND function in Excel returns the position of the first occurrence of a substring within a text string (case-sensitive)

Excel SEARCH Function

The SEARCH function in Excel returns the position of the first occurrence of a substring within a text string, ignoring case.

Excel SUBSTITUTE Function
The SUBSTITUTE function in Excel replaces occurrences of a specific substring with another substring within a text string.
Excel REPT Function
The REPT function in Excel repeats a text string a specified number of times.
Excel REPLACE Function
The REPLACE function in Excel replaces part of a text string with another, based on position and length.

Excel Functions for Lookup and References - Download Free Practice Files

Excel Function
Description
Video Tutorial

Practice File

Excel ROWS Function

The ROW function in Excel returns the row number of a reference or the current row if no reference is provided.

Excel COLUMN Function
The COLUMN function in Excel returns the column number of a reference or the current column if no reference is provided.
Excel COLUMNS Function

The COLUMNS function in Excel returns the number of columns in a specified range.

Excel INDEX Function
The INDEX function in Excel returns the value of a cell based on its position in a specified range or array.
Watch Video
Excel MATCH Function

The MATCH function in Excel returns the position of a value within a range, rather than the value itself.

Watch Video
Excel INDIRECT Function
The INDIRECT function in Excel returns the reference specified by a text string, allowing dynamic cell or range references
Watch Video
Excel XLOOKUP Function
The XLOOKUP function finds a value in one range and returns a match from another range, with flexible options
Watch Video
Excel INDEX AND MATCH Function

The INDEX MATCH combination retrieves a value using INDEX with a position found by MATCH, offering a powerful alternative to VLOOKUP.

Watch Video
Excel OFFSET Function
The OFFSET function in Excel returns a reference to a range that is a specified number of rows and columns away from a starting cell or range.
Watch Video
Excel CHOOSE Function
The CHOOSE function in Excel returns a value from a list of values based on a given index number.

Excel Logical Functions - Online Practice Excel Files

Excel Function
Description
Video Tutorial

Practice File

Excel AND, OR, NOT Function

The AND function returns TRUE if all conditions are true, the OR function returns TRUE if any condition is true, and the NOT function reverses the logical value of a condition.

Excel IF Function
The IF function in Excel performs a logical test and returns one value if the test is true and another if it’s false.
Watch Video
Excel IFS Function
The IFS function in Excel checks multiple conditions and returns a value corresponding to the first TRUE condition.
Watch Video
Excel ISERROR Function

The ISERROR function checks if a value is an error and returns TRUE if it is, otherwise FALSE.

Excel IFERROR Function

The IFERROR function in Excel returns a specified value if a formula results in an error, and the original result if there is no error.

Excel ISBLANK Function
The ISBLANK function in Excel checks if a cell is empty and returns TRUE if it is blank, otherwise FALSE.

Excel Financial Functions -Learn with Examples and Download Data for Practice

Excel Function
Description
Video Tutorial

Practice File

Excel INT Function

The INT function in Excel rounds a number down to the nearest integer, always toward zero

New Excel Functions - Introduced in Office 365

Excel ARRAY Function

An ARRAY function in Excel performs calculations on multiple values in an array or range and returns a result, either a single value or multiple values..

Excel TRANSPOSE Function

The TRANSPOSE function in Excel changes the orientation of a range, converting rows to columns and vice versa.

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *