Excel Formulas and 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.
Excel Average Function
The AVERAGE function in Excel calculates the arithmetic mean of a group of numbers.
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.
Excel ROUNDUP Function
Excel ROUNDDOWN Function
Excel SUBTOTAL Function
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.
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.
Excel DATE Function
The DATE function in Excel creates a date using year, month, and day values.
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.
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.
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.
Excel WORKDAY.INTL Function
WORKDAY.INTL returns a date after adding or subtracting workdays from a start date, considering custom weekends and holidays.
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
Excel NETWORKDAYS Function
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)
Excel SUMIFS Function
The SUMIFS function in Excel sums values based on multiple criteria.
Excel COUNTIF Function
The COUNTIF function in Excel counts the number of cells that meet a specified condition.
Excel COUNTIFS Function
The COUNTIFS function in Excel counts the number of cells that meet multiple criteria across different ranges.
Excel RAND Function
The RAND function in Excel generates a random decimal number between 0 and 1.
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.
Excel COUNTA Function
The COUNTA function counts all non-blank cells in a range, including text, numbers, and errors, but ignores blanks.
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.
Excel AVERAGEIFS Function
The AVERAGEIFS function in Excel calculates the average of cells that meet multiple criteria.
Excel RAND AND RANDBETWEEN Function
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
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
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
Excel LEN Function
The LEN function in Excel returns the total number of characters in a text string, including spaces.
Excel PROPER Function
Excel TRIM Function
The TRIM function in Excel removes extra spaces from text, leaving only single spaces between words.
Excel LEFT Function
Excel MID Function
Excel RIGHT Function
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
Excel REPT Function
Excel REPLACE Function
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
Excel COLUMNS Function
The COLUMNS function in Excel returns the number of columns in a specified range.
Excel INDEX Function
Excel MATCH Function
The MATCH function in Excel returns the position of a value within a range, rather than the value itself.
Excel INDIRECT Function
Excel XLOOKUP Function
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.
Excel OFFSET Function
Excel CHOOSE Function
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
Excel IFS Function
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
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.
