Functions of MS Excel 2003.

MS Excel can be tailored in a way that matches a user to attain his goal. It is thoroughly utilized in monetary companies. The features of MS Excel are as follows:

Workbooks: A file in MS Excel is called a workbook. Each workbook consists of sixteen worksheets by default. A user can alter this number by resetting the default choices. Worksheets within workbooks make it simple to bind files of related information. When a user opens a workbook, he can utilize all the worksheets to carry out a task. To create a workbook, a user will need to select the New command from the File menu. To open an existing workbook, a user will need to choose the Open option from the File menu. A user can insert a worksheet between 2 worksheets by choosing the Worksheet alternative from the Insert menu.

Utilizing keyboard: The following table offers various keyboard shortcuts for picking a row, column, current cell, worksheet, and so on

Entire ColumnCTRL+S pacebar

. To Select Keyboard Shortcuts
Current Cell Enter
Whole Row shift+ Spacebar
Whole Worksheet CTRL+SHIFT+S pacebar

A user can carry out various type of entries in a cell. He can enter text, number, information, and time in a cell. He can also go into some unique characters such as $ % + -/ (). He can likewise get in date and time in a cell. He can select various formats for date and time according to his own requirements.

Entering Data in Series: A user can fill a variety of cells either with the very same worth or with the series of values. This can be done utilizing the Autofill handle (little square on the bottom-right corner of the active cell).

Cell References: MS Excel supplies three kinds of cell recommendations: relative, absolute, and blended. Relative referrals refer to the cell relative to the provided position. Outright referrals describe the particular cell irrespective of the position of the formula. The ‘$’ sign is used to represent an outright recommendation. Mixed recommendations are a mix of both relative and absolute referrals. It has one outright co-ordinate and one relative co-ordinate. $CI and C$ 1 are both examples of blended recommendations.

MS Excel allows quick searching and immediate replacing of information. To search or replace the data gotten in by a user, he can utilize the Find or Replace command from the Edit menu.

Inserting or Deleting Rows and Columns:

MS Excel provides the facility to insert rows or columns into the existing worksheet. Inserting a row of data moves the rest of the rows down and eliminates the last row of the worksheet. Similarly, placing a column shifts the remainder of the columns to the right and erases the rightmost column. This takes place due to the fact that the total number of rows and columns remain the very same in any case.

MS Excel supplies numerous formatting features that enhance the appearance of the information, which exists in the worksheets. Some of them are described as follows: MS Excel enables setting up a page before printing. To establish a page, a user will have to open the File menu and click on the Page Setup. The Page Setup dialog box will appear that will permit the user to set the paper size, orientation of the data, scaling of the location, set the left, right, bottom, and top margin, set the header and the footer, etc.

. MS Excel offers the autofit selection that adjusts the width of the column according to the widest entry because column. A user can hide or unhide particular rows or columns. He can likewise offer the default column standard width.

MS Excel permits a user to align the characters in different methods by using the Alignment tab page of the Format Cells dialog box. The dialog box offers a variety of alignment options.

Horizontal Alignment options:

General: The text is left lined up and the numbers are right aligned. This is the default status.
Left: Aligns the contents to the left of the cell.
Center: Aligns the cell contents to the center of the cell.
Right: Aligns the contents to the right of the cell.
Fill: Fills the chosen cells with the single character.
Justify: This alternative is chosen with multiple lines of text as it wraps the contents from delegated right.

Vertical Alignment choices:

Top: Aligns the text at the top of the cell.
Center: Places the text in the center of the cell.
Bottom: Aligns the text on the bottom of the cell.
Validate: Wraps the text from top to bottom.

MS Excel offers a facility of seeing the very same worksheet concurrently in more than one window. This is achieved by picking the New Window command in the Windows menu. A user can also create more than one window to set up the work area to promptly access the info required. Utilizing MS Excel, a window can be organized in various methods by using the Arrange command from the Windows menu.

If a user wants to move between various windows, he can do so by pushing Ctrl+ F6 to go to the next window or by pushing Ctrl+ Shift+ F6 to go to the previous window. He can briefly hide or unhide windows by picking the Hide command in Window menu to conceal the active window or by selecting the Unhide command in the Window menu to unhide the hidden window.

When a user deals with a very large worksheet with row and column headings, the row headings scroll off to the left when he moves towards the right. Likewise, when he moves down to see the information, the column headings scroll up. To overcome this problem, he can divide the active window into 2, with row or column headings in one window and the data on the other window.

Controls: The controls are the unique items, which enhance interface and facilitate user input. MS Excel provides a number of customized controls such as list boxes, check boxes, and dialog boxes, and so on. A large number of toolbars are discovered in the View menu. Users can add a toolbar or a number of toolbars into the working file depending upon the work involved and use different controls in their files.

Functions and formulas: The built-in solutions are called functions. MS Excel supplies analyzing data and controling text by using various functions. Users can quickly calculate portion, interest, average, etc. by utilizing integrated functions. This can be done either by typing in the function-based formulas or by utilizing function wizards. Solutions are commonly used in basic computing (such as addition, subtraction, reproduction and division) and advanced computing. They supply the power to analyze information extensively.

Auto-calculation: MS Excel spreadsheet allows a user to automatically recalculate the entire worksheet every time a change is made in a single cell. There are generally two kinds of recalculations.

Automatic: In this kind of computation, the modification in the value of the cell automatically recalculates the whole worksheet.

Manual: In this kind of computation, the recalculation of the total worksheet is carried out by pushing the F9 secret. This choice can be chosen on the Calculation tab page of the Options dialog box, which is opened by choosing Options from the Tools menu.

Charts: One of the most important features of MS Excel is a chart. MS Excel enables users to view information gone into as tables in a graphical kind as charts, which assists a user to quickly understand, examine, and compare information. Excel allows its users to develop either two-dimensional charts or three-dimensional charts. A user can improve the chart by including chart products, such as information labels, a legend, titles, text, and gridlines. He can likewise do formatting on these items by utilizing colors, positioning, typefaces, and other format attributes. MS Excel also permits users to see charts in addition to the data by utilizing embedded charts. These charts are consisted of in the worksheet and can be copied, moved, and resized in the same way as can be made with any other visual item.

Database: Data are raw facts, info is processed data, and a database is an organized collection of details. Every company greatly relies on databases to keep, recover, and keep different kinds of information. MS Excel provides all this in the form of its database feature. In MS Excel, database can be produced in 2 ways:
Go into the data in the form of table in the worksheet.

Utilize the Data Form command
Records can be inserted, deleted, and sorted by utilizing the Data menu.

With the above-described features of MS Excel, users can carry out almost all the operations they desire in a very efficient and simple method. Its sophisticated functions have actually made it the first choice for professionals operating in a monetary company to perform their lengthy tasks in a simple way and in a quick manner. Therefore, MS Excel has actually become the most preferred choice for most of the users in addition to experts throughout the world.