Microsoft Excel: An Introduction:
Microsoft Excel is a versatile and widely adopted tool for managing, analyzing, and presenting data. Its extensive features, flexibility, and user-friendly interface make it a valuable asset for individuals, businesses, and organizations across various industries.
Related Articles
Versatility of Microsoft Excel:
Excel is known for its grid-based interface, where data is organized into rows and columns. This structure allows users to input and manipulate numerical or text-based data, perform calculations, and generate charts, graphs, and reports. It offers a wide array of tools and functionalities that make it a versatile tool for data analysis, financial modelling, project management, and much more.
Formulas/ Functions in Microsoft Excel:
Microsoft Excel offers a wide range of formulas that allow users to perform calculations, manipulate data, and automate tasks within spreadsheets. You can call these formulas as functions as well.
Steps involved in using Formulas/ Functions in MS Excel:
- Choose a cell.
- To enter an equal sign, click the cell and type =.
- Enter the address of a cell in the selected cell or select a cell from the list.
- You need to enter an operator.
- Enter the address of the next cell in the selected cell.
- Press Enter.
TOP 10 Formulas/ Functions Used in Microsoft Excel:
- SUM:
Add values of different cells and shows total result
Formula: =SUM(C1: C3) // you have to select cell range starting cell to ending value separated by colon :
- PRODUCT:
PRODUCT formula is used to multiply values. It will multiply values of two different numbers and display results accordingly.
Formula: =PRODUCT(A1,A2) //It will multiply values of cell A1 and cell A2.
For Multiplication one can also use hysteric * operator.
Example: A1*A2 // It will perform same operation as that of PRODUCT formula.
- AVERAGE:
This formula calculates average of the selected rage of cell values, results can be stored in desired cell.
Formula: =AVERAGE(C3,C4,C5) // you can select multiple cells separated by coma , .
- COUNT:
This formula is used to calculate number of cells with a number value leaving blank cells uncounted.
Formula: =COUNT(C3:C25) //This will count all the cells with value between cell number C3 and C25. Remember this formula counts cells with numeric value only.
3 (a). =COUNTA() : To calculate all cells with any kind of value.
3 (b). =COUNTBLANK() : To count blank cells between the selected range of cells.
- CONCATENATE:
This formula/ function joins strings from several cells into one single string.
Formula: =CONCATENATE(A5, “ “,A6) //This will merge texts of cell A5 and A6 in one single cell.
- LEN (LENGTH) :
This formula returns total number of characters in a cell. This count includes numbers, text, special characters and blanks as well.
Formula: =LEN(cell number)
- UPPER/ LOWER/ PROPER:
You can use these formulas to convert text case into uppercase (all capital), lower case (all small) or in a sentence format.
Formula: =UPPER(cell number)
=LOWER(cell Number)
=PROPER(cell number)
- NOW:
If you want to get current date and time of system you will use NOW() function.
Formula: =NOW()
- TODAY:
This function/ formula returns current date of system.
Formula: =TODAY()
9(a). DAY(): This function returns current day of the month from system date.
9(b). MONTH(): This formula/ function returns current month of the year.
9(c). YEAR(): As name suggests, it returns year value from the current system date.
- IF:
This formula checks the condition between selected values and responds in two ways, either TRUE or FALSE. To compare between selected cells/ values, use IF() function.
Formula: IF(A2>A3, “Hello”) //It will compare values of cell A2 and A3, if A2 is greater than A3 it will print Hello.
These few basic formulas of excel are actually going to help you with your daily routine work.
The post Top 10 Most frequently used Formulas in Microsoft Excel: appeared first on TECKTRIBE.
