All Functions
=AVERAGE()
The AVERAGE function finds the average of a group of numbers.
=COUNTIFS()
The COUNTIFS function counts the number of cells in a range that meet a single condition or multiple conditions.
=FILTER()
The Excel FILTER function shows only the rows of your data that match one or more conditions, and hides everything else.
=IF()
The IF function in Excel is used to run a logical test and show one result if the test is true, and a different result if the test is false.
=MATCH()
The Excel MATCH function searches for a specific item in a list and tells you exactly what position it is in.
=SUMIFS()
The Excel SUMIFS function adds numbers together only if they meet one or more specific conditions that you set.
=TEXT()
The Excel TEXT function converts a numerical value into a text string and applies a specific display format (like a date, currency, or percentage) to…
=TODAY()
The Excel TODAY function automatically shows the current date in your spreadsheet.
=VLOOKUP()
The Excel VLOOKUP function searches for a specific value in the first column of a table and returns data from the same row in another column.
=XLOOKUP()
The XLOOKUP function searches for a specific item in one column or row and returns related information from another column or row.