Excel Formulas | Most commonly used Excel functions Part -1
Hello I Am Balram Singh Welcome To Our YouTube Channel.
Aio Digital Institute Provides Computer Education To The Students Through Live And Tutorials Videos.
Excel most commonly used Excel functions:
SUM: Adds all the numbers in a range of cells.
=SUM(number1, [number2], ...)
AVERAGE: Calculates the average of a group of numbers.
=AVERAGE(number1, [number2], ...)
COUNT: Counts the number of cells that contain numbers.
=COUNT(value1, [value2], ...)
IF: Checks whether a condition is met, and returns one value if true, and another value if false.
=IF(logical_test, value_if_true, value_if_false)
VLOOKUP: Looks for a value in the first column of a table and returns a value in the same row from a specified column.
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
INDEX: Returns the value of a cell in a table based on the row and column number.
=INDEX(array, row_num, [column_num])
MATCH: Searches for a specified item in a range of cells and returns the relative position of that item.
=MATCH(lookup_value, lookup_array, [match_type])
CONCATENATE: Joins several text strings into one text string.
=CONCATENATE(text1, [text2], ...)
LEFT: Returns the specified number of characters from the start of a text string.
=LEFT(text, [num_chars])
RIGHT: Returns the specified number of characters from the end of a text string.
=RIGHT(text, [num_chars])
Download Practice File
https://docs.google.com/spreadsheets/...
https://docs.google.com/spreadsheets/...
excel
excel formula
excel formulas
microsoft excel
excel tutorial
ms excel
excel tips and tricks
excel formulas and functions
excel formula for job interview
excel tutoring
excel formulas and functions tutorial
excel tips
excel shorts
excel functions
excel formula hacks
excel interview questions
excel 2016
vlookup formula in excel
percentage formula in excel
advanced excel
excel 2019
ms excel tutorial
excel if formula
excel interview
#msexcel #excel #balramexcel #excelformula
Contact
Email - [email protected]