Ms Excel Introduction
Ms Excel Introduction A spreadsheet is essentially a matrix of rows and columns. Consider a sheet of paper on which horizontal and vertical lines are drawn to yield a rectangular grid.
The grid namely a cell, is the result of the intersection of a row with a column. Such a structure is called a Spreadsheet. A spreadsheet package contains electronic equivalent of a pen, an eraser and large sheet of paper with vertical and horizontal lines to give rows and columns. Ms Excel Introduction
The cursor position uniquely shown in dark mode indicates where the pen is currently pointing. We can enter text or numbers at any position on the worksheet.
We can enter a formula in a cell where we want to perform a calculation and results are to be displayed.
A powerful recalculation facility jumps into action each time we update the cell contents with new data. MS-Excel is the most powerful spreadsheet package brought by Microsoft. The three main components of this package are
Generation of Charts.
Each workbook provides 3 worksheets with facility to increase the number of sheets. Each sheet provides 16384 columns and 1048576 rows to work with.
Though the spreadsheet packages were originally designed for accountants, they have become popular with almost everyone working with figures. Sales executives, book-keepers, officers, students, research scholars, investors bankers etc, almost any
one find some form of application for it.
Microsoft Excel 2007, along with the other products in the Microsoft Office 2007 suite, introduced new file formats. The first of these (.xlsx) is defined in the Office Open XML (OOXML) specification.
|Excel Workbook||.xlsx||The default Excel 2007 and later workbook format. In reality a Zip compressed archive with a directory structure of XML text documents. Functions as the primary replacement for the former binary .xls format, although it does not support Excel macros for security reasons.|
|Excel Macro-enabled Workbook||.xlsm||As Excel Workbook, but with macro support.|
|Excel Binary Workbook||.xlsb||As Excel Macro-enabled Workbook, but storing information in binary form rather than XML documents for opening and saving documents more quickly and efficiently. Intended especially for very large documents with tens of thousands of rows, and/or several hundreds of columns.|
|Excel Macro-enabled Template||.xltm||A template document that forms a basis for actual workbooks, with macro support. The replacement for the old .xlt format.|
|Excel Add-in||.xlam||Excel add-in to add extra functionality and tools. Inherent macro support because of the file purpose.|
Ms Excel Introduction Old file extensions
|Spreadsheet||.xls||Main spreadsheet format which holds data in worksheets, charts, and macros|
|Add-in (VBA)||.xla||Adds custom functionality; written in VBA|
|Toolbar||.xlb||The file extension where Microsoft Excel custom toolbar settings are stored.|
|Chart||.xlc||A chart created with data from a Microsoft Excel spreadsheet that only saves the chart. To save the chart and spreadsheet save as .XLS. XLC is not supported in Excel 2007 or in any newer versions of Excel.|
|Dialog||.xld||Used in older versions of Excel.|
|Archive||.xlk||A backup of an Excel Spreadsheet|
|Add-in (DLL)||.xll||Adds custom functionality; written in C++/C, Visual Basic, Fortran, etc. and compiled in to a special dynamic-link library|
|Macro||.xlm||A macro is created by the user or pre-installed with Excel.|
|Template||.xlt||A pre-formatted spreadsheet created by the user or by Microsoft Excel.|
|Module||.xlv||A module is written in VBA (Visual Basic for Applications) for Microsoft Excel|
|Library||.DLL||Code written in VBA may access functions in a DLL, typically this is used to access the Windows API|
|Workspace||.xlw||Arrangement of the windows of multiple Workbooks|
Ms Excel Introduction Office versions
|November 19, 1990||Office 1.0||Word 1.1, Excel 2.0, PowerPoint 2.0|
|March 4, 1991||Office 1.5||Word 1.1, Excel 3.0, PowerPoint 2.0|
|July 8, 1991||Office 1.6||Word 1.1, Excel 3.0, PowerPoint 2.0, Mail 2.1||Last version to support Windows 3.0|
|August 30, 1993||Office 3.0||Word 2.0c, Excel 4.0, PowerPoint 3.0, Mail 3.0||Later rebranded as Office 92|
|January 17, 1994||Office 4.0||Word 6.0, Excel 4.0, PowerPoint 3.0, Mail 3.1|
|June 2, 1994||Office 4.3||Word 6.0, Excel 5.0, PowerPoint 4.0, Mail 3.2, Access 2.0||This is the last 16-bit version. This means that it is also the last version to support Windows 3.x, Windows NT 3.1|
|July 3, 1994||Office for NT 4.2||Word 6.0, Excel 5.0, PowerPoint 4.0, Office Manager||Runs on Windows NT 3.5|
|August 24, 1995||Office 95(7.0)||Word, Excel, PowerPoint, Schedule+, Binder, Access, Bookshelf||Coincided with the Windows 95 operating system release. Works only on Windows 95 as well asWindows NT 3.51 and later. This is the first Office version to have the same version number (7.0, inherited from Word 6.0) for all major component products (Word, Excel and so on).|
|November 19, 1996||Office 97(8.0)||Word 97, Word 98, Excel, Outlook, PowerPoint, Access, BookShelf Basics, Publisher 97, Publisher 98, Small Business Financial Manager 97, Small Business Financial Manager 98, Automap Street Plus, Direct Mail Manager, Expedia Streets 98||Was published on CD-ROM as well as on a set of 45 3½-inch floppy disks, became Y2K-safe with Service Release 2, and was the last version to support Windows NT 3.51.|
|June 20, 1997||Office 97 Powered by Word 98 (8.5)||Was released only in Japanese and Korean editions. First version to contain Outlook 98 in all editions and Publisher 98 in the Small Business Edition, as well as the first version of Office 97 to support Windows 98 Second Edition.|
|June 7, 1999||Office 2000(9.0)||Word, Excel, Outlook, PowerPoint, Publisher, Small Business Tools, Access, FrontPage, PhotoDraw||First Version to Support Windows XP, Windows Server 2003 and last version to support Windows 95. Office 2000 is also the last version not to include Product Activation and not covered by Office Genuine Advantage, although on individual installs, the Office Update website still required the presence of original install media for updates to install.|
|May 31, 2001||Office XP(10.0)||Word, Excel, Outlook, PowerPoint, Access, Publisher, FrontPage, Small Business Tools||Last version to support Windows 98, Windows ME and Windows NT 4.0. Improved support for working in user accounts without administrative privileges on Windows 2000 and Windows XP.|
|October 21, 2003||Office 2003(11.0)||Word, Excel, Outlook, PowerPoint, Publisher, Access, InfoPath||First version to introduce Windows XP style icons. Last version to support Windows 2000. Last version to have legacy menus.|
|January 30, 2007||Office 2007(12.0)||Word, Excel, PowerPoint, Outlook, Publisher, Access, InfoPath, Communicator, Groove, OneNote, Visio Viewer, OCT||Broadly released alongside Windows Vista. First version to use the new Ribbon user interface with tabbed menus.|
|June 15, 2010||Office 2010(14.0)||Word, Excel, PowerPoint, OneNote, Outlook, Publisher, Access, InfoPath, SharePoint Workspace, Visio Viewer, OCT, Lync||This is the first version to ship in 32-bit and 64-bit. Last version to support Windows XP, Windows Server 2003 and Windows Vista. Version 13.0 was skipped because of the fear of the number 13.|
|January 29, 2013||Office 2013(15.0)||Word, Excel, PowerPoint, OneNote, Outlook, Publisher, Access, Lync, Skype for Business, Visio Viewer||Lync is replaced with Skype for Business after an update.|
|September 22, 2015||Office 2016(16.0)||Word, Excel, PowerPoint, OneNote, Outlook, Publisher, Access, Skype for Business, Visio Viewer||Last version to support Windows 7, Windows 8, Windows 8.1, Windows Server 2008 and Windows Server 2012.|
|September 24, 2018||Office 2019(16.0)||Word, Excel, PowerPoint, OneNote, Outlook, Publisher, Access, Skype for Business, Visio Viewer||Runs on Windows 10, Windows Server 2016, Windows Server 2019. Not a new product as such, but a roll-up of updates already released in the Office 365 version of Office 2016.|