What Is The Use Of Excel In Computer

broken image


Use Excel on Office.com Jumpstart your spreadsheets. Show your professionalism with Excel templates in over 40 categories, plus save time. Get free templates Connect with experts. See what's new and get tips and tricks to help you create, edit, and polish spreadsheets like a pro. Read the Office blog. Microsoft Excel is a software program produced by Microsoft that allows users to organize, format and calculate data with formulas using a spreadsheet system. This software is part of the Microsoft Office suite and is compatible with other applications in the Office suite.

Today, Excel is still a ubiquitous program, found on just about every personal and business computer on the planet. Launch our free Excel crash course. The best way to learn is by doing, which is why our FREE step by step tutorial on how to use Excel is the most efficient way to learn with your own spreadsheet. Why do we use Excel? Excel is an electronic spreadsheet program that is used for storing, organizing, and manipulating data. The information we've prepared refers to Microsoft Excel in general and is not limited to any specific version of the program. What Excel Is Used For.

Sheet

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.

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.

  1. Open My Computer.
  2. Click or select the C: drive. If Microsoft Office is installed on a drive other than the C: drive, select that drive instead.
  3. Navigate to the Program Files (x86) folder, then the Microsoft Office folder.
  4. 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.
  5. 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. Call of duty big red one weapons. 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?

Common Uses For 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.

Tip

Even with all Excel's options, a free spreadsheet program like Google Sheets is often all most users need.

Note

If 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.

What Is Excel Used For

Excel file extensions

The following file extensions are supported by Microsoft Excel. The default format for saving a Microsoft Excel workbook is .xlsx.

ExtensionNameDescription
.csvCSV (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.
.dbfDBF 3, DBF 4The native database file format of DBASE III and IV.
.difData interchange formatA feature-limited, widely-supported file format. Supports saving a single-page spreadsheet only.
.htm, .htmlHTMLContains data formatted in HTML. When exported by Excel, supporting files such as images and sounds are stored in a folder.
.mht, .mhtmlSingle-page HTMLHTML-formatted single page data.
.odsOpenDocument SpreadsheetAn open-source file format supported by word processors including OpenOffice and LibreOffice.
.pdfPDF (Portable Data Format)An industry-standard document format created by Adobe.
.prnSpace-delimited formatted textA format similar to CSV that supports text formatting, created by Lotus. Supports only a single sheet.
.slkSYLK Symbolic Link Format.Supports only a single sheet.
.txtTab-delimited textA text file format similar to CSV, using tab as the delimiter character. Also, stores Unicode-encoded single-page spreadsheets.
.xlaExcel Add-inSupporting file for Visual Basic VBA projects, compatible with Excel 95-2003.
.xlamExcel Add-in with MacrosXML-based format compatible with Excel 2007 and 2013-2019, supporting VBA projects and Excel 4.0 macros.
.xlsExcel Workbook (deprecated)The native Excel file format for Excel versions 97-2003.
.xlsbExcel Binary WorkbookA fast load-and-save format compatible with Excel 2007-2019. Supports VBA projects and Excel 4.0 macros.
.xlsmExcel Workbook with MacrosXML-based format compatible with Excel 2007-2019, supporting VBA and Excel 4.0 macros.
.xlsxExcel WorkbookThe native Excel file format for Excel versions 2007-2019. Supports 'ISO Strict' formatting. Does not support macros.
.xltExcel Template (deprecated)Excel template file format, Excel 97-2003.
.xltxExcel TemplateExcel template file format, Excel 2007-2019.
.xlwExcel Workbook OnlySaves only worksheets, chart sheets, and macro sheets, but does not save spreadsheets. Compatible with Excel 2013-2019.
.xmlXML DataSpreadsheet data exported as XML.
.xpsOpenXML Paper SpecificationAn open-source document format similar to PDF.

What are the different versions of Microsoft Excel?

What

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.

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.

  1. Open My Computer.
  2. Click or select the C: drive. If Microsoft Office is installed on a drive other than the C: drive, select that drive instead.
  3. Navigate to the Program Files (x86) folder, then the Microsoft Office folder.
  4. 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.
  5. 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. Call of duty big red one weapons. 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?

Common Uses For 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.

Tip

Even with all Excel's options, a free spreadsheet program like Google Sheets is often all most users need.

Note

If 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.

What Is Excel Used For

Excel file extensions

The following file extensions are supported by Microsoft Excel. The default format for saving a Microsoft Excel workbook is .xlsx.

ExtensionNameDescription
.csvCSV (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.
.dbfDBF 3, DBF 4The native database file format of DBASE III and IV.
.difData interchange formatA feature-limited, widely-supported file format. Supports saving a single-page spreadsheet only.
.htm, .htmlHTMLContains data formatted in HTML. When exported by Excel, supporting files such as images and sounds are stored in a folder.
.mht, .mhtmlSingle-page HTMLHTML-formatted single page data.
.odsOpenDocument SpreadsheetAn open-source file format supported by word processors including OpenOffice and LibreOffice.
.pdfPDF (Portable Data Format)An industry-standard document format created by Adobe.
.prnSpace-delimited formatted textA format similar to CSV that supports text formatting, created by Lotus. Supports only a single sheet.
.slkSYLK Symbolic Link Format.Supports only a single sheet.
.txtTab-delimited textA text file format similar to CSV, using tab as the delimiter character. Also, stores Unicode-encoded single-page spreadsheets.
.xlaExcel Add-inSupporting file for Visual Basic VBA projects, compatible with Excel 95-2003.
.xlamExcel Add-in with MacrosXML-based format compatible with Excel 2007 and 2013-2019, supporting VBA projects and Excel 4.0 macros.
.xlsExcel Workbook (deprecated)The native Excel file format for Excel versions 97-2003.
.xlsbExcel Binary WorkbookA fast load-and-save format compatible with Excel 2007-2019. Supports VBA projects and Excel 4.0 macros.
.xlsmExcel Workbook with MacrosXML-based format compatible with Excel 2007-2019, supporting VBA and Excel 4.0 macros.
.xlsxExcel WorkbookThe native Excel file format for Excel versions 2007-2019. Supports 'ISO Strict' formatting. Does not support macros.
.xltExcel Template (deprecated)Excel template file format, Excel 97-2003.
.xltxExcel TemplateExcel template file format, Excel 2007-2019.
.xlwExcel Workbook OnlySaves only worksheets, chart sheets, and macro sheets, but does not save spreadsheets. Compatible with Excel 2013-2019.
.xmlXML DataSpreadsheet data exported as XML.
.xpsOpenXML Paper SpecificationAn 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

What Is Microsoft Excel? - Definition From Techopedia

  • 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. Foxit pdf creator.

Related Excel pages

  • Microsoft Excel help and support.

Conditional formatting, Formula, Function, Google Docs, Lookup, Multiplan, Office, Office 365, Office Online, Spreadsheet, Spreadsheet terms





broken image