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.
How to protect and share your workbook? Creating beautiful and professional dashboards, projects always lead you to success however there are places when you wanted to protect your dashboards, sheets, cells to prevent users to…
Learn to reduce excel file size. Tips include removing unnecessary formatting, compressing images, using formulas instead of hardcoded data, and optimizing pivot tables. Clearing unused cells and minimizing data ranges also help. Lastly, consider saving as binary or using third-party add-ins for further compression.
How to count words in Excel using the LEN function along with other Excel functions. It also gives formulas for counting words or text, whether case-sensitive or not, in a cell or range.
This quick tutorial explains the basics of external references in Excel and shows how to reference another sheet or workbook in your formulas.
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.
This guide explains the basics of Excel’s Advanced Filter and shows you how to use it to find records that match one or more complicated conditions.
If you’ve read our previous guide, you know that Excel’s regular filter offers different options for filtering text, numbers, and dates. These options work well for many situations, but not all. When the regular filter isn’t enough, you can use the Advanced Filter to set up custom criteria that fit your exact needs.
Excel’s Advanced Filter is especially useful for finding data based on two or more complex conditions. For example, you can use it to find matches and differences between two columns, filter rows that match another list, or find exact matches with the same uppercase and lowercase letters.
Advanced Filter is available in all Excel versions from 365 to 2003. Click the links below to learn more.