PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
WHAT IS MICROSOFT EXCEL? HOW TO USE FORMULA IN EXCEL?
EXCEL-INTRODUCTION
“MICROSOFT EXCEL OR EXCEL IS THE NAME GIVEN TO THE SPREADSHEET SOFTWARE PROVIDED BY MICROSOFT” which comes bundled with the MICROSOFT OFFICE SUITE. Excel is one of the most important component of the OFFICE SUITE.
SPREADSHEET OR EXCEL IS A SOFTWARE WHICH PROVIDES CALCULATION TOOLS TO MAKE OUR REPORT MAKING EASIER. IT PROVIDES MANY FUNCTIONS, FORMULAS, TABLES, CHARTS ETC. TO ANALYZE THE DATA WITHIN MINUTES.
IMPORTANCE OF MICROSOFT EXCEL IN BUSINESS
MICROSOFT EXCEL have set the GOLD STANDARD in the market of spreadsheet softwares.
In these times, EXCEL is no more a specialization but an application which is considered to be a basic requirement for many jobs and businesses to grow. No business can do well if it doesn’t take care of its finances well. Excel helps the businesses in this area as it has got plenty of functions already built for financial services. In addition to this, statistical, engineering, maths, text and so many other formulas are there. For the matter of fact, EXCEL 2016 has more than 480 built in functions for the user to get the advantage of this resource.
Excel works on the principle of
” CREATE ONCE AND REPEAT FOREVER”
MICROSOFT EXCEL asks you to strive only once to get the result for one of the samples and it takes just seconds to replicate the formula to thousands of cells without any fail or problem.
This is how EXCEL has become so important to keep records of business.
In addition to this, data analytical jobs can’t be done without a good knowledge of Excel. There are tools to analyze the data within minutes.
Not only this, you can plan household expenses too in the Excel.So we can say that now EXCEL is not a profession specific application but a day to day need which makes our work easier.
HISTORY OF MICROSOFT EXCEL
It all started in 1982 when MICROSOFT launched a program called Multiplan which became very popular. It was launched to compete against VISICALC and LOTUS 1-2-3 which were very popular at that time. It was launched for various available platforms at those times but couldn’t be very popular.
So , in 1985 MICROSOFT again launched the EXCEL 1.0 for MAC. Later in 1987, the first version of EXCEL was launched for PC/windows as EXCEL 2.0. Its worth looking at how the first Excel was.
That was the start and Excel has kept itself at the top by introducing very innovative and great GUI for the users. Every 2 to 3 years MICROSOFT releases a new version. Let us have a list of versions and release year.
| Year | Name | Version |
| 1987 | Excel 2.0 | 2 |
| 1990 | Excel 3.0 | 3 |
| 1992 | Excel 4.0 | 4 |
| 1993 | Excel 5.0 | 5 |
| 1995 | Excel 95 | 7 |
| 1997 | Excel 97 | 8 |
| 2000 | Excel 2000 | 9 |
| 2002 | Excel 2002 | 10 |
| 2003 | Excel 2003 | 11 |
| 2007 | Excel 2007 | 12 |
| 2010 | Excel 2010 | 14 |
| 2013 | Excel 2013 | 15 |
| 2016 2019 | Excel 2016 OFFICE 365(2019) | 16
|
HOW TO USE FORMULA IN EXCEL?
Let us become familiar with the layout of the Excel first.
Any spreadsheet based program (Excel or Open Excel) comprises of cells (where values are put) and have address location of row and columns, from which we recognize them.
Look at the pic for better understanding.
DIFFERENT AREAS OF MICROSOFT EXCEL SCREEN
STEPS TO USE A FORMULA IN EXCEL
For the reference, look at the animated picture below to help you understand better.
1.Move the cursor (The active cell location) to the cell in which you want the result.
2. Start the formula with “=” and put the formula statement after that.
3. If you want to put any value, just type the digits or if you want to change the value later on for different cases, just put the location in the formula.
ANIMATED EXAMPLE OF USING FORMULA
EXPLANATION:
Two numbers are put in cell D5 and E5.
We intend to sum the numbers and ( ” is not part of the formula).
PUT IN F5 THE FOLLLOWING FORMULA
=D5+E5
Press ENTER and the result will be shown.
The process is shown in the animated picture just above this post.
GENERALIZING THE PROCESS OF USING FORMULA IN EXCEL
Using the formula in excel is just like ALGEBRA. In algebra, we have different variables like X OR Y.
Similarly, here we use the CELL ADDRESS as the variables and any mathematical operation can be applied on the cell addresses.
Absolute values(The value itself like 12, 45, 3234 etc.) can also be put for the calculations but it is not an advisable way of using Excel as every single time the values need to be changed.
The following example shows the use of explicitly declared value usage in the formulas.
ANIMATED EXAMPLE
