20 Powerful Excel Functions || Top 20 Functions in Excel || Most Useful for Beginners || #excel

This video provides an introduction into the top 20 most important functions used in Excel. These include the SWITCH, IFERROR, DGET, AND, LEN, SUMSQ, AGGREGATE, EXACT, XLOOKUP, SUBSTITUTE, UNIQUE, SUMIF, EOMONTH, ROMAN, DAVERAGE, TRANSPOSE, ABS, SMALL, REPT, and CODE functions.

What is the SWITCH function in Microsoft Excel?
The SWITCH function evaluates a given expression (or a value) against a list of values.
Syntax:
=SWITCH(expression, value1, result1, [default or value2, result2],…[default or value3, result3])

What is the IFERROR function in Microsoft Excel?
The IFERROR function in Excel is designed to manage errors in formulas and calculations.
Syntax:
=IFERROR(value, value_if_error)

What is the DGET function in Microsoft Excel?
The DGET function extracts a single value from a column of a list or database.
Syntax:
=DGET(database, field, criteria)

What is the AND function in Microsoft Excel?
The AND function returns TRUE or FALSE based on your conditions.
Syntax:
=AND([logical1], [logical2], ...)

What is the LEN function in Microsoft Excel?
The LEN Function counts the length of a given text string. In financial analysis, the LEN function can be useful if we wish to get the length of a given text string as the number of characters.
Syntax:
=LEN(text)

What is the SUMSQ function in Microsoft Excel?
The SUMSQ function returns the sum of the squares of the values that you provided.
Syntax:
=SUMSQ(number1, [number2], ...)

What is the AGGREGATE function in Microsoft Excel?
The AGGREGATE function returns an aggregate calculation like SUM, AVERAGE, COUNT, etc., ignoring hidden rows and errors optionally.
Syntax:
=AGGREGATE(function_num, options, ref1, [ref2], ...)

What is the EXACT function in Microsoft Excel?
The EXACT function compares two text strings and returns TRUE if they are the same, and FALSE if they are not the same.
Syntax:
=EXACT(text1, text2)

What is the XLOOKUP function in Microsoft Excel?
The XLOOKUP function in Excel is a powerful search tool, allowing you to find particular values from a range of cells.
Syntax:
=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])

What is the SUBSTITUTE function in Microsoft Excel?
The Excel SUBSTITUTE function replaces text in a given string by matching.
Syntax:
=SUBSTITUTE(text, old_text, new_text, [instance_num])

What is the UNIQUE function in Microsoft Excel?
The UNIQUE Function removes duplicate values. The values can be text, numbers, dates, times, etc.
Syntax:
=UNIQUE(array, [by_col], [exactly_once])

What is the SUMIF function in Microsoft Excel?
The SUMIF function in Excel allows you to calculate the sum of values that meet a specific criteria or condition you define. Meaning that, calculate the sum with one condition.
Syntax:
=SUMIF(range, criteria, [sum_range])

What is the EOMONTH function in Microsoft Excel?
The EOMONTH function returns the serial number for the last day of the month that is the indicated number of months before or after start_date. We use the EOMONTH function to calculate maturity dates or due dates that fall on the last day of the month.
Syntax:
=EOMONTH(start_date, months)

What is the ROMAN function in Microsoft Excel?
The Excel ROMAN function converts a number to a Roman numeral as text.
Syntax:
=ROMAN(number, [form])

What is the DAVERAGE function in Microsoft Excel?
The DAVERAGE function in Excel returns the average values of all cells in a column or database that contain the criteria you set.
Syntax:
=DAVERAGE(database, field, criteria)

What is the TRANSPOSE function in Microsoft Excel?
The TRANSPOSE function returns a vertical range of cells as a horizontal range, or vice versa.
Syntax:
=TRANSPOSE(array)

What is the ABS function in Microsoft Excel?
The ABS Function in Excel returns the absolute value of a number. The function converts negative numbers to positive numbers while the positive numbers remain unaffected.
Syntax:
=ABS(number)

What is the SMALL function in Microsoft Excel?
The SMALL function returns the smallest value in a data set.
Syntax:
=SMALL(array, k)

What is the REPT function in Microsoft Excel?
The REPT function in Excel repeats text a given number of times.
Syntax:
=REPT(text, number_times)

What is the CODE function in Microsoft Excel?
The CODE function returns a code number for the first character in a text string.
=CODE(text)

Thank you for watching my video. I hope to see you again in my next video.
If you have any questions, please write in the comments below.
------------------------------------------------
#msexcel #office #advanceexcel #excelbasic #excelhindi #excelinterview #exceltips #exceltrick #exceltipsinhindi #exceltutorial #learnexcel #learnexcelfree #learnexcelonline #newexcel #excelfunction
@RachanaChiv
------------------------------------------------
Prepared by: Dr. Rachana Chiv