MS Excel 2003 is often a Windows-based application package that could be used to automate tasks which include calculation and analysis of information, automate economic statements, business forecasting, transaction registers, inventory handle, etc. It offers various facilities, for instance making graphs and charts, analyzing conditions, and assists users at the managerial level in taking choices. The attributes offered by Excel are quite helpful for managers together with the supervisors in any variety of organization and support them to execute their complicated tasks having a minimum work.
MS Excel 2003, Windows, Windows 2003
MS Excel is usually customized in a way that suits a user to achieve his target. It is extensively used in economic organizations. The functions of MS Excel are as follows:
Workbooks: A document in MS Excel is known as a workbook. Each workbook contains sixteen worksheets by default. A user can modify this number by resetting the default possibilities. Worksheets within workbooks make it simple to bind files of related data. When a user opens a workbook, he can use all of the worksheets to carry out a activity. To make a workbook, a user will have to select the New command from the File menu. To open an current workbook, a user will have to select the Open choice from the File menu. A user can insert a worksheet among two worksheets by picking the Worksheet choice from the Insert menu.
Using keyboard: The following table provides different keyboard shortcuts for deciding on a row, column, current cell, worksheet, and so forth.
A user can perform a variety of kinds of entries in a cell. He can enter text, quantity, data, and time within a cell. He can also enter some unique characters for example $ % + – / ( ). He may also enter date and time inside a cell. He can select distinct formats for date and time according to his personal needs.
Entering Data in Series: A user can fill a range of cells either with the same worth or with the series of values. This is usually performed making use of the Autofill deal with (tiny square on the bottom-right corner of your active cell).
Cell References: MS Excel offers three forms of cell references: relative, absolute, and mixed. Relative references refer towards the cell relative to the provided position. Absolute references refer to the distinct cell irrespective on the position from the formula. The ‘$’ sign is used to denote an absolute reference. Mixed references are a combination of both relative and absolute references. It has one absolute co-ordinate and 1 relative co-ordinate. $CI and C$1 are each examples of mixed references.
MS Excel permits rapid searching and instant replacing of information. To search or replace the data entered by a user, he can use the Locate or Replace command from the Edit menu.
Inserting or Deleting Rows and Columns:
MS Excel supplies the facility to insert rows or columns in to the current worksheet. Inserting a row of information shifts the rest of the rows down and removes the final row of your worksheet. Similarly, inserting a column shifts the rest of the columns towards the ideal and deletes the rightmost column. This occurs because the total quantity of rows and columns stay exactly the same in any case.
MS Excel offers many formatting functions that enhance the look of the data, which can be presented inside the worksheets. Some of them are described as follows: MS Excel makes it possible for setting up a page ahead of printing. To set up a page, a user will need to open the File menu and click on the Page Setup. The Page Setup dialog box will seem which will permit the user to set the paper size, orientation with the information, scaling of your area, set the left, suitable, bottom, and top margin, set the header along with the footer, etc.
MS Excel provides the autofit choice that adjusts the width with the column according to the widest entry in that column. A user can hide or unhide particular rows or columns. He can also supply the default column regular width.
MS Excel allows a user to align the characters in distinct approaches by employing the Alignment tab page of your Format Cells dialog box. The dialog box delivers quite a few alignment possibilities.
Horizontal Alignment alternatives:
General: The text is left aligned plus the numbers are correct aligned. This is the default status.
Left: Aligns the contents towards the left of your cell.
Center: Aligns the cell contents to the center with the cell.
Appropriate: Aligns the contents towards the ideal from the cell.
Fill: Fills the selected cells using the single character.
Justify: This option is chosen with multiple lines of text as it wraps the contents from left to correct.
Vertical Alignment alternatives:
Top: Aligns the text at the best in the cell.
Center: Locations the text in the center of the cell.
Bottom: Aligns the text on the bottom on the cell.
Justify: Wraps the text from best to bottom.
MS Excel supplies a facility of viewing the identical worksheet simultaneously in much more than one window. This can be achieved by choosing the New Window command within the Windows menu. A user can also make extra than a single window to arrange the workspace to promptly access the data necessary. Working with MS Excel, a window could be arranged in different strategies by using the Arrange command from the Windows menu.
If a user desires to move among unique windows, he can do so by pressing Ctrl+F6 to visit the next window or by pressing Ctrl+Shift+F6 to go to the previous window. He can temporarily hide or unhide windows by deciding upon the Hide command in Window menu to hide the active window or by choosing the Unhide command inside the Window menu to unhide the hidden window.
When a user operates on a really substantial worksheet with row and column headings, the row headings scroll off to the left when he moves towards the ideal. Similarly, when he moves down to determine the information, the column headings scroll up. To overcome this dilemma, he can split the active window into two, with row or column headings in one window as well as the information on the other window.
Controls: The controls are the particular objects, which improve user interface and facilitate user input. MS Excel delivers numerous custom controls like list boxes, examine boxes, and dialog boxes, and so on. A sizable number of toolbars are found within the View menu. Users can add a toolbar or a number of toolbars into the working document based upon the operate involved and use different controls in their documents.
Functions and formulas: The built-in formulas are named functions. MS Excel supplies analyzing information and manipulating text by using unique functions. Users can simply calculate percentage, interest, average, etc. by utilizing built-in functions. This is often performed either by typing in the function-based formulas or by working with function wizards. Formulas are widely used in straightforward computing (like addition, subtraction, multiplication and division) and advanced computing. They present the power to analyze data extensively.
Auto-calculation: MS Excel spreadsheet makes it possible for a user to automatically recalculate the entire worksheet every time a alter is produced in a single cell. There are fundamentally two kinds of recalculations.
Automatic: In this form of calculation, the transform inside the value on the cell automatically recalculates the entire worksheet.
Manual: In this form of calculation, the recalculation of your total worksheet is performed by pressing the F9 essential. This alternative can be chosen on the Calculation tab page with the Solutions dialog box, which can be opened by choosing Alternatives from the Tools menu.
Charts: Among the most significant capabilities of MS Excel can be a chart. MS Excel will allow users to view data entered as tables in a graphical form as charts, which assists a user to very easily comprehend, analyze, and evaluate data. Excel allows its users to create either two-dimensional charts or three-dimensional charts. A user can boost the chart by adding chart products, for example information labels, a legend, titles, text, and gridlines. He may also do formatting on these items by using colors, alignment, fonts, and other formatting attributes. MS Excel also will allow users to view charts in addition to the data by utilizing embedded charts. These charts are included in the worksheet and can be copied, moved, and resized in the very same way as might be completed with any other graphical object.
Database: Information are raw facts, facts is processed information, and also a database is an organized collection of details. Just about every organization heavily depends upon databases to retailer, retrieve, and retain unique sorts of data. MS Excel provides all this within the kind of its database feature. In MS Excel, database may be produced in two ways:
Enter the information inside the kind of table within the worksheet.
Use the Data Form command
Records is usually inserted, deleted, and sorted by utilizing the Data menu.
With all the above-described options of MS Excel, users can execute just about all of the operations they want within a extremely efficient and uncomplicated way. Its advanced attributes have made it the initial decision for professionals operating inside a financial organization to execute their lengthy tasks in an easy way and inside a rapid manner. For that reason, MS Excel has develop into the most preferred decision for many with the users together with professionals all through the globe.