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!
The SUM function adds numbers, cell ranges, or a combination of both.
The AVERAGE function in Excel calculates the arithmetic mean of a group of numbers.
The MAX function in Excel returns the largest value in a set of numbers or range.
The MIN function in Excel returns the smallest value in a set of numbers or range.
The ROUND function in Excel rounds a number to a specified number of decimal places.
Practice File
The TODAY function returns the current date based on your system’s clock, updating automatically each day.
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.
The DATE function in Excel creates a date using year, month, and day values.
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.
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.
The WORKDAY function returns a date that is a specified number of workdays before or after a start date, excluding weekends and holidays.
WORKDAY.INTL returns a date after adding or subtracting workdays from a start date, considering custom weekends and holidays.
DATEVALUE converts a date in text format to a serial number that Excel recognizes as a date.
DAY, MONTH, and YEAR functions extract the day, month, and year from a given date, respectively.
Practice File
The SUMIF function in Excel adds the values in a range that meet a specific condition (criteria)
The SUMIFS function in Excel sums values based on multiple criteria.
The COUNTIF function in Excel counts the number of cells that meet a specified condition.
The COUNTIFS function in Excel counts the number of cells that meet multiple criteria across different ranges.
The RAND function in Excel generates a random decimal number between 0 and 1.
The ROMAN function in Excel converts a number to its Roman numeral representation.
The COUNT function in Excel counts the number of cells that contain numbers in a given range.
The COUNTA function counts all non-blank cells in a range, including text, numbers, and errors, but ignores blanks.
The COUNTBLANK function in Excel counts the number of completely blank cells in a range.
The AVERAGEIF function in Excel calculates the average of cells that meet a specific condition or criteria.
The AVERAGEIFS function in Excel calculates the average of cells that meet multiple criteria.
SUMPRODUCT function performs multiplication of numbers within arrays and then sum the values
Practice File
The LOWER function in Excel converts all letters in a text string to lowercase.
The RANK function in Excel returns the position of a number in a sorted list.
The SMALL function in Excel returns the k-th smallest value in a data set.
Practice File
The LEN function in Excel returns the total number of characters in a text string, including spaces.
The TRIM function in Excel removes extra spaces from text, leaving only single spaces between words.
The TEXT function in Excel formats a number or date as text, according to a specified format.
The FIND function in Excel returns the position of the first occurrence of a substring within a text string (case-sensitive)
The SEARCH function in Excel returns the position of the first occurrence of a substring within a text string, ignoring case.
Practice File
The ROW function in Excel returns the row number of a reference or the current row if no reference is provided.
The COLUMNS function in Excel returns the number of columns in a specified range.
The MATCH function in Excel returns the position of a value within a range, rather than the value itself.
The INDEX MATCH combination retrieves a value using INDEX with a position found by MATCH, offering a powerful alternative to VLOOKUP.
Practice File
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.
The ISERROR function checks if a value is an error and returns TRUE if it is, otherwise FALSE.
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.
Practice File
The INT function in Excel rounds a number down to the nearest integer, always toward zero
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..
The TRANSPOSE function in Excel changes the orientation of a range, converting rows to columns and vice versa.
The ROMAN function in Excel converts numbers into Roman numerals. It’s useful when you need to display numbers in the Roman numeral format, such as for dates, titles, or other specific purposes. The function allows you to choose how “traditional” or simplified the Roman numeral should be. To use the ROMAN function, you just need to enter the number you want to convert, and Excel will do the rest
WORKDAY Function in Excel Are you working today? or Do you have Work Off or holiday today? I am asking this question because I am gonna tell you the most commonly used function in Excel…
WEEKDAY function applies to a Date and returns the output for Day of the week. The output of the function varies from 0 to 7
Excel Function DATE When you work with dates in Excel, the DATE function is crucial to understand. The reason is that some other Excel functions may not always recognize dates when they are entered as…
To subtract numbers in Excel, follow these steps:
Start by typing an equal sign (=) in the cell where you want the result.
Enter the first number or cell reference you want to subtract from.
Type a minus sign (-).
Enter the second number or cell reference you want to subtract.
AVERAGEIFS function is used to get the “average” of values for matching criteria across range. Average = Sum of all values / number of items.