Software : Microsoft : Excel

Microsoft Excel

(as of 9/22/2015)

Software Overview

Main Features

  • Industry-standard, widely used spreadsheet program
  • Basic and advanced data manipulation
  • Support for large data sets
  • Can import and export data in many different formats
  • Complex mathematical formula support
  • Advanced support for VBScript scripting

Microsoft Excel is a widely used spreadsheet program that is part of the Microsoft Office suite. It provides a powerful feature set for organizing, manipulating, and visualizing data.

Excel workbooks are divided by tabbed worksheets, each of which can be edited independently. Each worksheet contains a two-dimensional grid of cells, which can be formatted in various ways. Excel includes basic features, such as data sorting and simple formula creation, as well as advanced capabilities, such as pivot table reports and VBScript macro scripting. It also provides document security and password protection for data within a workbook. Newer versions of Excel save workbooks in the Office Open XML (OOXML) .XLSX format, while older versions use the proprietary .XLS format.

Excel has many tools that help quickly analyze data. From data import features to automatic sorting, filtering, and pivot tables, users can take large external data sets and gather analyses quickly. The extensive set of mathematical functions also gives the ability to manipulate data and compute results. Excel provides thousands of online templates available for download within the user interface. This gives users many different options for out-of-the-box styling, formatting, and mathematical computation, allowing them to focus on the data rather than extensive amounts of time on presentation. For example, financial templates can be downloaded by home or business users for tracking income, expenses, and transactions, as well as for automatically generating summary graphs. Microsoft Excel also provides rich tools for visualizing data. Excel supports simple chart types such as bar charts, line graphs, pie charts, and scatter plots, as well as more complex ones for more in-depth analysis. These charts can be styled with a variety of visual options.

Microsoft Excel is a great program for your data management needs. Whether you are using it for personal, academic, or professional purposes, you will appreciate Excel’s ability to quickly organize and manipulate data to perform statistical analyses and create visualizations. These reasons among others are what make Excel an industry standard application.

▶ Primary file extension

.XLSX – Microsoft Excel Open XML Spreadsheet

▶ Other file extensions used by Microsoft Excel 2016

Supported File Types
.CRTXOffice 2007 Chart Template File
.CSVComma Separated Values File
.EFTXOffice 2007 Theme Effect File
.MHTMHTML Web Archive
.ODCOffice Data Connection File
.ODSOpenDocument Spreadsheet
.PRNLotus 1-2-3 Formatted Text File
.SLKSymbolic Link File
.THMXOffice 2007 Theme File
.TSVTab Separated Values File
.UDCXUniversal Data Connection File
.XLExcel Spreadsheet
.XLAExcel Add-In File
.XLAMExcel Open XML Macro-Enabled Add-In
.XLBExcel Toolbars File
.XLCExcel Chart
.XLKExcel Backup File
.XLLExcel Add-In File
.XLMExcel Macro
.XLRWorks Spreadsheet
.XLSExcel Spreadsheet
.XLSBExcel Binary Spreadsheet
.XLSHTMLMicrosoft Excel HTML Spreadsheet
.XLSMExcel Open XML Macro-Enabled Spreadsheet
.XLSMHTMLMicrosoft Excel MIME HTML Spreadsheet
.XLSXMicrosoft Excel Open XML Spreadsheet
.XLTExcel Template
.XLTHTMLMicrosoft Excel HTML Spreadsheet Template
.XLTMExcel Open XML Macro-Enabled Spreadsheet Template
.XLTXExcel Open XML Spreadsheet Template
.XLVExcel Visual Basic Module
.XLWExcel Workspace File
Additional Related File Formats
.AWAnswer Wizard File
.BMPBitmap Image File
.DATAAnalysis Studio Offline Data File
.DBFDatabase File
.DEXExcel Spreadsheet
.DIBDevice Independent Bitmap File
.DICPROOFMicrosoft Dictionary Proofing File
.DIFData Interchange Format
.DOCMicrosoft Word Document
.DQYExcel Query File
.EMFEnhanced Windows Metafile
.EXDControl Information Cache File
.GIFGraphical Interchange Format File
.GRAMicrosoft Graph File
.HTMHypertext Markup Language File
.IIFIntuit Interchange Format File
.IQYInternet Query
.OLBOLE Object Library
.RDFReport Definition File
.RELSOpen Office XML Relationships File
.RLERun Length Encoded Bitmap
.SHSMicrosoft Scrap File
.SKVSemicolon Separated Values File
.TABTab Separated Data File
.TDLTab Delineated Format File
.TSVTab Separated Values File
.TXTPlain Text File
.UDFExcel User Defined Function
.WB1Corel Quattro Pro File
.WB2Corel Quattro Pro File
.WB3Corel Quattro Pro 7 and 8 File
.WK1Lotus Worksheet
.WK2Lotus 2 Worksheet
.WK3Lotus 3 Worksheet
.WK4Lotus 4 Worksheet
.WK5Lotus 5 Worksheet
.WKSWorks Spreadsheet
.WKSLotus 1-2-3 Spreadsheet
.WMFWindows Metafile
.WPGWordPerfect Graphic File
.WQ1Quattro Pro for DOS Spreadsheet File
.XLWExcel Workbook

Updated: September 22, 2015