- Computer Ms Excel
- Computer Ms Excel Knowledge In Hindi
- Computer Ms Excel Notes
- Computer Ms Excel Information
- Computer Ms Excel Questions And Answers
Excel is a spreadsheet application developed and published by Microsoft. It is part of the Microsoft Office suite of productivity software.
Unlike a word processor, such as Microsoft Word, Excel organizes data in columns and rows. Rows and columns intersect at a space called a cell. Each cell can contain a single of data, such as text, a numerical value, or a formula.
Entering Data Into Your Worksheet. Entering data into worksheet cells is always a three-step.
- Microsoft Excel is the industry standard spreadsheet program used for data calculations, analysis, visualization, and much more. It can be programmed to access external databases and is an excellent tool for data modeling, statistics, and financial calculations.
- Download latest version of Microsoft Excel for Windows. Safe and Virus Free.
Excel was originally code-namedOdyssey during development. It was first released on September 30, 1985.
- Microsoft Excel help and support.
Excel overview
Excel is a tool for organizing and performing calculations on data. It can analyze data, calculate statistics, generate pivot tables, and represent data as a chart or graph.
For example, you could create an Excel spreadsheet that calculates a monthly budget, tracks associated expenses, and interactively sorts the data by criteria.
Below is an example of Microsoft Excel with each of its major sections highlighted. See the formula bar, cell, column, row, or sheet tab links for further information about each of these sections.
Where do you find or start Excel?
If you have Excel or the entire Microsoft Office package installed on Microsoft Windows, you can find Excel in your Start menu.
Keep in mind that new computers do not include Excel. It must be purchased and installed before running it on your computer. If you do not want (or cannot afford) to purchase Excel, you can use a limited version for free at the Microsoft Office website.
If Excel is installed on your computer, but you can't find it in your Start menu, use the following steps to launch Excel manually.
- Open My Computer.
- Click or select the C: drive. If Microsoft Office is installed on a drive other than the C: drive, select that drive instead.
- Navigate to the Program Files (x86) folder, then the Microsoft Office folder.
- In the Microsoft Office folder, if there is a root folder, open that folder. Then open the OfficeXX folder, where XX is the version of Office (e.g., Office16 for Microsoft Office 2016) installed on your computer. If there is no root folder, look for and open a folder having 'Office' in the name.
- Look for a file named EXCEL.EXE and click or double-click that file to start the Excel program.
How can Excel be formatted?
Each of the rows, columns, and cells can be modified in many ways, including the background color, number or date format, size, text font, layout, etc. In our example above, you can see that the first row (row 1) has a blue background, bold text, and each cell has its text centered.
Download an example of a spreadsheet file
We've created a Microsoft Excel spreadsheet that can be downloaded and opened in any spreadsheet program including Microsoft Excel. This spreadsheet illustrate some of the capabilities of a spreadsheet, formulas, and functions and allows you to experiment more with a spreadsheet.
Why do people use Excel?
There are many reasons people may use Excel (a spreadsheet program). For example, someone might use Excel to keep track of their expenses. For a full list of reason and examples of how people use a spreadsheet, see our spreadsheet definition.
Why would someone use Excel over a different spreadsheet program?
Today, there are many different free spreadsheet options that someone could use instead of Excel. However, even with the available free options, Excel remains the most-used spreadsheet because of all its available options, features, and because many businesses still use the program.
TipEven with all Excel's options, a free spreadsheet program like Google Sheets is often all most users need.
NoteIf you want to get Excel because it's a job requirement, it's still okay to learn all the basics in a free spreadsheet program. However, there are still many differences between Excel and a free spreadsheet program.
Excel file extensions
The following file extensions are supported by Microsoft Excel. The default format for saving a Microsoft Excel workbook is .xlsx.
Extension | Name | Description |
---|---|---|
.csv | CSV (Comma-separated values) | A minimal format compatible with many spreadsheet applications. Rows of data are represented as lines in the text file, with columnar breaks delimited by a single character, usually a comma. |
.dbf | DBF 3, DBF 4 | The native database file format of DBASE III and IV. |
.dif | Data interchange format | A feature-limited, widely-supported file format. Supports saving a single-page spreadsheet only. |
.htm, .html | HTML | Contains data formatted in HTML. When exported by Excel, supporting files such as images and sounds are stored in a folder. |
.mht, .mhtml | Single-page HTML | HTML-formatted single page data. |
.ods | OpenDocument Spreadsheet | An open-source file format supported by word processors including OpenOffice and LibreOffice. |
PDF (Portable Data Format) | An industry-standard document format created by Adobe. | |
.prn | Space-delimited formatted text | A format similar to CSV that supports text formatting, created by Lotus. Supports only a single sheet. |
.slk | SYLK Symbolic Link Format. | Supports only a single sheet. |
.txt | Tab-delimited text | A text file format similar to CSV, using tab as the delimiter character. Also, stores Unicode-encoded single-page spreadsheets. |
.xla | Excel Add-in | Supporting file for Visual Basic VBA projects, compatible with Excel 95-2003. |
.xlam | Excel Add-in with Macros | XML-based format compatible with Excel 2007 and 2013-2019, supporting VBA projects and Excel 4.0 macros. |
.xls | Excel Workbook (deprecated) | The native Excel file format for Excel versions 97-2003. |
.xlsb | Excel Binary Workbook | A fast load-and-save format compatible with Excel 2007-2019. Supports VBA projects and Excel 4.0 macros. |
.xlsm | Excel Workbook with Macros | XML-based format compatible with Excel 2007-2019, supporting VBA and Excel 4.0 macros. |
.xlsx | Excel Workbook | The native Excel file format for Excel versions 2007-2019. Supports 'ISO Strict' formatting. Does not support macros. |
.xlt | Excel Template (deprecated) | Excel template file format, Excel 97-2003. |
.xltx | Excel Template | Excel template file format, Excel 2007-2019. |
.xlw | Excel Workbook Only | Saves only worksheets, chart sheets, and macro sheets, but does not save spreadsheets. Compatible with Excel 2013-2019. |
.xml | XML Data | Spreadsheet data exported as XML. |
.xps | OpenXML Paper Specification | An open-source document format similar to PDF. |
What are the different versions of Microsoft Excel?
Microsoft Excel has had several versions throughout its history. The different releases with their release dates, are listed below.
Windows versions
- Excel 2019, released in 2018
- Office 365 and Excel 2016, released in 2016
- Excel 2013, released in 2013
- Excel 2010, released in 2010
- Excel 2007, released in 2007
- Excel 2003, released in 2003
- Excel 2002, released in 2002
- Excel 2000, released in 2000
- Excel 97, released in 1997
- Excel 95, released in 1995
- Excel 5.0, released in 1993
- Excel 4.0, released in 1992
- Excel 3.0, released in 1990
- Excel 2.0, released in 1987
Mac versions
- Excel 2019, released in 2018
- Excel 2016, released in 2016
- Excel 2011, released in 2011
- Excel 2008, released in 2008
- Excel 2004, released in 2004
- Excel 2001, released in 2001
- Excel 2000, released in 2000
- Excel 98, released in 1998
- Excel 5.0, released in 1993
- Excel 4.0, released in 1992
- Excel 3.0, released in 1990
- Excel 2.2, released in 1989
- Excel 1.5, released in 1988
- Excel 1, released in 1985
What came before Excel?
Microsoft Excel was not the first spreadsheet program, Lotus 1-2-3 and VisiCalc were popular spreadsheet programs released before Excel.
Related Excel pages
- Microsoft Excel help and support.
Conditional formatting, Formula, Function, Google Docs, Lookup, Multiplan, Office, Office 365, Office Online, Spreadsheet, Spreadsheet terms
Ms Excel is used very widely nowadays by everyone because it is very helpful and it helps in saving a lot of time. It is being used for so many years and it gets upgraded every year with new features. The most impressive thing about MS Excel is that it can be used anywhere for any kind of work. For example, it is used for billing, data management, analysis, inventory, finance, business tasks, complex calculations, etc. One can even do mathematical calculations using this and can also store important data in it in the form of charts or spreadsheets.
MS Excel provides security to your files so that no one else can see your files or ruin them. With the help of MS Excel, you can keep your files password protected. MS Excel can be accessed from anywhere and everywhere. You can even work on MS Excel using mobile if you don't have laptops. There are so many benefits of using MS Excel that it has become an inevitable part of lives of millions of people. MS Excel has numerous tools and features that make one's work easy and saves one's time also.
To use MS Excel to the best of its ability one must know its benefits and advantages. Following are the ten best uses of MS Excel:
Uses of Microsoft Excel: Analyzing and storing data
One of the best uses of MS Excel is that you can analyze larger amounts of data to discover trends. With the help of graphs and charts, you can summarize the data and store it in an organized way so that whenever you want to see that data then you can easily see it. It becomes easier for you to store data and it will definitely save a lot of time for you.
Once the data is stored in a systematic way, it can be used easily for multiple purposes. MS Excel makes it easier to implement various operations on the data through various tools that it possesses.
Uses of Microsoft Excel: Excel tools make your work easier
There are so many tools of MS Excel that make your work extremely easy and save your time as well. There are wonderful tools for sorting, filtering and searching which all the more make you work easy. If you will combine these tools with tables, pivot tables etc. then you will be able to finish your work in much less time. Multiple elements can be searched easily from large amounts of data to help solve a lot of problems and questions.
Uses of Microsoft Excel: Data recovery and spreadsheets
Another best use of MS Excel is that if your data gets lost then you can recover it without much inconvenience. Suppose, there is a businessman who has stored his important data in MS Excel and somehow it gets lost or the file gets damaged then he must not worry as with the new MS Excel XML format one can restore the lost or damaged file data.
The next important use is that there are spreadsheets in MS Excel which also makes your work easy and with the help of new Microsoft MS Excel XML format you can reduce the size of the spreadsheet and make things compact easily.
Uses of Microsoft Excel: Mathematical formulas of MS Excel make things easier
Next best use of MS Excel is that it makes easy for you to solve complex mathematical problems in a much simpler way without much manual effort. There are so many formulas in MS Excel and by using these formulas you can implement lots of operations like finding sum, average, etc. on a large amount of data all at once. Therefore, people use MS Excel whenever they have to solve complex mathematical problems or they need to apply simple mathematical functions on tables containing larger data.
Uses of Microsoft Excel: Security
The chief use of MS Excel is that it provides security for excel files so people can keep their files safe. All the files of MS Excel can be kept password-protected through visual basic programming or directly within the excel file. People store their important data in the MS Excel so that they can keep their data in an organized way and save their time as well. Almost every person wants his files to be password protected so that no one is able to see them or ruin them so here MS Excel solves this problem very efficiently.
Computer Ms Excel
Uses of Microsoft Excel: Add sophistication to data presentations
Next use of MS Excel is that it helps you in adding more sophistication to your data presentations which means that you can improve the data bars, you can highlight any specific items that you want to highlight and make your data much more presentable easily.
Suppose you have stored data in MS Excel and you want to highlight something that is important so then you can do that through the various features of data presentations available in MS Excel. You can even make the spreadsheets more attractive on which you have stored data.
Uses of Microsoft Excel: Online access
Another use of MS Excel is that it can be accessed online from anywhere and everywhere which means that you can access it from any device and from any location whenever you want. It provides the facility of working conveniently which means that if you don't have laptops then you can use mobile and do your work easily without any problem. Therefore, due to the large amount of flexibility that MS Excel provides, people like to work on MS Excel so that they can comfortably work without worrying about their device or location.
Uses of Microsoft Excel: Keeps data combined at one location
Another interesting use of MS Excel is that you can keep all your data at one location. This will help you in saving your data from getting lost. It will keep all your data in one place and then you will not have to waste your time in searching for the files. So it will save your time and whenever need be, you can look up the categorized and sorted data easily.
Uses of Microsoft Excel: Helps businessmen in developing future strategy
Computer Ms Excel Knowledge In Hindi
You can represent data in the form of charts and graphs so it can help in identifying different trends. With the help of MS Excel, trend lines can be extended beyond graph and therefore, it helps one in analyzing the trends and patterns much easier. In business, it is very important to analyze the popularity of goods or the selling pattern that they follow to maximize sales. MS Excel simplifies this task and helps businessmen grow and maximize profits through the same.
Computer Ms Excel Notes
Uses of Microsoft Excel: Manage expenses
MS Excel helps in managing expenses. Suppose if a doctor is earning around 50,000 per month then he will make some expenses as well and if he wants to know how much he is exactly spending per month then he can do it with the help of MS Excel easily. He can write his monthly income as well as expenses in the excel tables and then he can get to know that how much he is spending and he can thus, control his expenses accordingly.
There are a lot of benefits of using MS Excel, which is why it is used worldwide by people for performing so many tasks. It not only saves time but also it makes the work easier. It can almost perform every type of task. For example, you can do mathematical calculations and you can also make graphs as well as charts for storing the data. It becomes easy for the businessman to calculate things and store data in it.
Computer Ms Excel Information
Computer Ms Excel Questions And Answers
You can store a large amount of data in the MS Excel and analyze it as well. It helps in keeping the data combined in one place so that data does not get lost and one does not waste time in finding a particular data. Due to these factors, it has become such a popular software and we have become habitual of using it.