Hi Everyone. Assalamu Alaikum, Hope everybody are very fine. Today we will go share with some special Tutorials for you. For those people who want to learn MS word, this post is very important for those people. So let start MS Word Tutorial Free for Beginners 2021.
I am Hafizul Islam. I hope that everyone is well. Today I present to you a new tutorial on advanced Microsoft Excel. This series of tutorials is for those of you who are familiar with the Microsoft Excel program or who know Microsoft word fairly or have forgotten some of the functions of Microsoft excel due to lack of practice. Today I will talk about what Microsoft excel is, its window introduction and some basic formulas.
What is Microsoft Excel?
The literal meaning of the word Excel is to be superior. This program, developed and marketed by Microsoft Corporation in terms of quality, achievement, ease of use, etc., may be called Microsoft Excel or Ms-Excel for short as it is superior to many other programs in solving many problems at once. Many more complex tasks can be easily accomplished through this program besides performing mathematical calculations, data management, creating a database based on statistics, creating accurate charts or graphs in an interesting way.
Let’s get acquainted with the window that appears when we open Microsoft Excel 2007.
Basic formulas of Microsoft Excel
Formula: = SUM (first digit cell address: last digit cell address)
Suppose you add three numbers 35, 40, 50 which are in cells A1, B1 and C1 respectively. Then I have to place the cursor in the cell where I need the sum (hold D1) and type = SUM (A1: C1) in the formula bar and press Enter.
If the numbers 35, 40, 50 are in cell B2, B3, B4 respectively and I need the sum in cell F3 then I have to place the cursor in cell F3 and type = SUM (B2: B4) in the formula bar and press Enter.
Another method is to place the cursor in the cell next to the numbers that need to be added, click on Auto Sum and press Enter. In the image, we have placed the cursor in cell B6 and clicked on Auto Sum to add from B1 to B5 Then press Enter.
Formula: = Address of the cell of the first number – Address of the cell of the second number
If we want to subtract 870 from cell E3 to 820 from cell D3, then we need to place the cursor in the cell where I need the result (hold F3 cell) and type = D3-E3 in the formula bar and press Enter.
Formula: = Address of the cell of the first number * Address of the cell of the second number
If we want to multiply 80 in cell D3 and 60 in cell E3, then place the cursor in the cell where I need the result (hold F3 cell) and type = D3 * E3 and press Enter. One thing to keep in mind is that the next cell will always be, but not which cell may need our results.
Formula: = Address of the first digit cell / Address of the second digit cell
If we want to divide by 840 in cell A1 and 70 in cell B1, then we need to place the cursor in the cell where I need the result and type = A1 / B1 and press Enter
Formula: = AVERAGE (Address of the first digit cell: Address of the second digit cell)
If I want to find the average value of the numbers 30, 40, 55, 120, 65 in cells B3, C3, D3, E3, F3, respectively, then place the cursor in the cell where I need the result (cell G3) and move the formula bar to AVERAGE (B3: Type F3) and press Enter.
Again, as in the figure below, the average value of the number of cells to be determined by placing the cursor in the cell next to it and clicking on Average, the average value can be determined by pressing Enter.
Determine Percentage (%):
Formula: = (Percentage of the number you want to find Number * the percentage you want to find%)
If I want to find 40% of 2500 in cell B2, then I have to place the cursor in the cell where I need the result (hold C2 cell) and type = B2 * 40% in the formula bar and press Enter.
So far today. I hope to appear with the next episode very soon. God bless you.
Conclusion: Thanks for reading this article. we hope that you can Understand all the basic formulas of MS Word. Please like share this post & inspire me to share another Tutorial Article in the Future. Thanks.