Features of MS Excel
Features of MS Excel
Some of the most important features of Excel are:
Windows-based application: Microsoft Excel has an interface similar to Windows operating system. Like all Windows applications, Excel has toolbars, shortcut menus, AutoCorrect, Online help and Wizards. This makes Excel easier to learn for users of Windows.
Workbooks: Workbooks are containers that hold one or more worksheets. Keeping all sheets that are related to-a project in one file reduces the need to maintain different files.
Auditing: Worksheet auditing is a feature that checks a worksheet for errors. Auditing can be used to relate formulas in different cells and locate the source of a calculation error.
OLE support: Excel worksheets can contain any object, like a document, a picture or a video clip. This feature is known as Object Linking and Embedding (OLE). This capability can be used to integrate Excel with all other applications.
Data entry forms: You can create custom data entry forms within a worksheet. Validation rules and formatting can be included within a form.
Large data management capacity: Excel can maintain large volumes of data at a time. A worksheet can contain 65,536 rows and 256 columns. A single cell can contain a maximum of 255 characters. One workbook can contain a maximum of 255 worksheets. Such data management capacities make Excel a powerful spreadsheet application.
Data analysis features: Excel contains powerful tools that help in data analysis. Pivot tables, Microsoft Query and Data Map tools allow users to present data in different ways to facilitate analysis.
Starting Excel 2003
Excel can be loaded in one of the following ways:
• Select the Microsoft Excel button from the Programs group in the Start Menu.
• Click the short icon twice shortcut on the desktop.
Create a Workbook file
To get started, create a workbook file. You can produce a new, blank workbook; or to save time, open an existing workbook or a template and fill in your data.
What's the difference between a workbook and a worksheet?
A workbook is a Microsoft Excel file containing one or more sheets; each worksheet is a "page" in the workbook on which you enter and work with data. Workbooks start with three worksheets but you can add worksheets and other kinds of sheets.
Microsoft Excel 2013
Microsoft Office 2013 has upgraded their Excel program to handle considerably more data. Today an Excel 2013 worksheet is 1,048,576 rows by 16,384 columns. That is a huge increase since Microsoft Excel 2003. Of course today’s computers with there faster processors and speeds, and a minimum of 8 GB of RAM, can handle all of this data. Not to mention 1 TB at least of hard drive space to store all of this data.
Using both Access and Excel can be of great use. Using Access is great for a database management system, and then using Excel to store large amounts of data in workbooks that contain one or more worksheets. Unlike Access, Excel is optimized for data analysis and calculation.