Ms Excel Introduction 2015

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.

Ms Excel Introduction

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

 Electronic spreadsheet.
 Database management.
 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.

Extensions

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.

Ms Excel Introduction Excel 2007 formats

Format Extension Description
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

Format Extension Description
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

Release date Title Components Notes
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.[7]
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.

2D DRAWING, AUTOCAD 2D DRAWING

How to crack windows XP/7/8/8.1/10 password

Struct C++, Program Structure

Generation of Computer, What is Computer

Photoshop shortcut keys pdf, Photoshop shortcut keys cs6

Network Devices, Hub, switch, Router, Full Form Of NIC, Online Study

Follow for Health and Beauty Tips

Leave a Reply

Your email address will not be published. Required fields are marked *