Options of MS Excel 2003

 MS Excel will be personalized in a approach that fits a consumer to realize his aim. It's extensively utilized in monetary organizations. The options of MS Excel are as follows:

Workbooks: A doc in MS Excel is known as a workbook. Every workbook comprises sixteen worksheets by default. A consumer can change this quantity by resetting the default choices. Worksheets inside workbooks make it simple to bind information of associated info. When a consumer opens a workbook, he can use all of the worksheets to carry out a job. To create a workbook, a consumer should choose the New command from the File menu. To open an present workbook, a consumer should choose the Open choice from the File menu. A consumer can insert a worksheet between two worksheets by selecting the Worksheet choice from the Insert menu.

Utilizing keyboard: The next desk supplies completely different keyboard shortcuts for choosing a row, column, present cell, worksheet, and so forth.

To Choose Keyboard Shortcuts

Present Cell Enter

Total Column CTRL+Spacebar

Total Row hift+Spacebar

Total Worksheet CTRL+SHIFT+Spacebar

A consumer can carry out numerous sorts of entries in a cell. He can enter textual content, quantity, information, and time in a cell. He can even enter some particular characters corresponding to $ % + - / ( ). He can even enter date and time in a cell. He can choose completely different codecs for date and time based on his personal necessities.

Getting into Information in Collection: A consumer can fill a variety of cells both with the identical worth or with the collection of values. This may be finished utilizing the Autofill deal with (small sq. on the bottom-right nook of the energetic cell).

Cell References: MS Excel supplies three kinds of cell references: relative, absolute, and combined. Relative references discuss with the cell relative to the given place. Absolute references discuss with the particular cell regardless of the place of the components. The '$' signal is used to indicate an absolute reference. Blended references are a mix of each relative and absolute references. It has one absolute co-ordinate and one relative co-ordinate. $CI and C$1 are each examples of combined references.

MS Excel permits quick looking out and instantaneous changing of information. To go looking or exchange the information entered by a consumer, he can use the Discover or Exchange command from the Edit menu.

Inserting or Deleting Rows and Columns:

MS Excel supplies the ability to insert rows or columns into the prevailing worksheet. Inserting a row of information shifts the remainder of the rows down and removes the final row of the worksheet. Equally, inserting a column shifts the remainder of the columns to the correct and deletes the rightmost column. This happens as a result of the entire variety of rows and columns stay the identical in any case.

MS Excel supplies a number of formatting options that improve the looks of the information, which is introduced within the worksheets. A few of them are described as follows: MS Excel permits organising a web page earlier than printing. To arrange a web page, a consumer should open the File menu and click on on the Web page Setup. The Web page Setup dialog field will seem that can permit the consumer to set the paper dimension, orientation of the information, scaling of the world, set the left, proper, backside, and high margin, set the header and the footer, and so forth.

MS Excel supplies the autofit choice that adjusts the width of the column based on the widest entry in that column. A consumer can conceal or unhide sure rows or columns. He can even present the default column customary width.

MS Excel permits a consumer to align the characters in numerous methods by utilizing the Alignment tab web page of the Format Cells dialog field. The dialog field supplies a variety of alignment choices.

Horizontal Alignment choices:

Basic: The textual content is left aligned and the numbers are proper aligned. That is the default standing.

Left: Aligns the contents to the left of the cell.

Middle: Aligns the cell contents to the middle of the cell.

Proper: Aligns the contents to the correct of the cell.

Fill: Fills the chosen cells with the only character.

Justify: This selection is chosen with a number of strains of textual content because it wraps the contents from left to proper.

Vertical Alignment choices:

Prime: Aligns the textual content on the high of the cell.

Middle: Locations the textual content within the heart of the cell.

Backside: Aligns the textual content on the underside of the cell.

Justify: Wraps the textual content from high to backside.

MS Excel supplies a facility of viewing the identical worksheet concurrently in a couple of window. That is completed by choosing the New Window command within the Home windows menu. A consumer can even create a couple of window to rearrange the workspace to promptly entry the knowledge wanted. Utilizing MS Excel, a window will be organized in numerous methods by utilizing the Prepare command from the Home windows menu.

If a consumer desires to maneuver between completely different home windows, he can achieve this by urgent Ctrl+F6 to go to the subsequent window or by urgent Ctrl+Shift+F6 to go to the earlier window. He can briefly conceal or unhide home windows by selecting the Disguise command in Window menu to cover the energetic window or by selecting the Unhide command within the Window menu to unhide the hidden window.

When a consumer works on a really massive worksheet with row and column headings, the row headings scroll off to the left when he strikes in the direction of the correct. Equally, when he strikes right down to see the information, the column headings scroll up. To beat this downside, he can break up the energetic window into two, with row or column headings in a single window and the information on the opposite window.

Controls: The controls are the particular objects, which improve consumer interface and facilitate consumer enter. MS Excel supplies a number of customized controls corresponding to record containers, examine containers, and dialog containers, and so forth. A lot of toolbars are discovered within the View menu. Customers can add a toolbar or a variety of toolbars into the working doc relying upon the work concerned and use completely different controls of their paperwork.

Features and formulation: The built-in formulation are known as capabilities. MS Excel supplies analyzing information and manipulating textual content by utilizing completely different capabilities. Customers can simply calculate share, curiosity, common, and so forth. by utilizing built-in capabilities. This may be finished both by typing within the function-based formulation or by utilizing perform wizards. Formulation are broadly utilized in easy computing (corresponding to addition, subtraction, multiplication and division) and superior computing. They supply the ability to investigate information extensively.

Auto-calculation: MS Excel spreadsheet permits a consumer to routinely recalculate the entire worksheet each time a change is made in a single cell. There are mainly two sorts of recalculations.

Computerized: In such a calculation, the change within the worth of the cell routinely recalculates the entire worksheet.

Guide: In such a calculation, the recalculation of the entire worksheet is carried out by urgent the F9 key. This selection will be chosen on the Calculation tab web page of the Choices dialog field, which is opened by selecting Choices from the Instruments menu.

Charts: One of the vital essential options of MS Excel is a chart. MS Excel permits customers to view information entered as tables in a graphical kind as charts, which helps a consumer to simply perceive, analyze, and examine information. Excel permits its customers to create both two-dimensional charts or three-dimensional charts. A consumer can improve the chart by including chart gadgets, corresponding to information labels, a legend, titles, textual content, and gridlines. He can even do formatting on this stuff by utilizing colours, alignment, fonts, and different formatting attributes. MS Excel additionally permits customers to view charts together with the information by utilizing embedded charts. These charts are included within the worksheet and will be copied, moved, and resized in the identical approach as will be finished with another graphical object.

Database: Information are uncooked details, info is processed information, and a database is an organized assortment of data. Each group closely relies upon upon databases to retailer, retrieve, and keep completely different varieties of information. MS Excel supplies all this within the type of its database function. In MS Excel, database will be created in two methods:

Enter the information within the type of desk within the worksheet.

Use the Information Kind command

Data will be inserted, deleted, and sorted by utilizing the Information menu.

With the above-described options of MS Excel, customers can carry out nearly all of the operations they need in a really environment friendly and straightforward approach. Its superior options have made it the primary alternative for professionals working in a monetary group to carry out their prolonged duties in a straightforward approach and in a fast method. Due to this fact, MS Excel has turn out to be essentially the most most popular alternative for many of the customers in addition to professionals all through the world.