MS Excel can be configured in such a way that the user can achieve his goal. It is widely used in financial organizations. MS Excel features are as follows:
Workbooks: a document in MS Excel is called a book. By default, each workbook contains 16 sheets. The user can change this number by resetting the default settings. Worksheets in books simplify the binding of related information files. When a user opens a book, he can use all worksheets to complete the task. To create a book, the user must select the "New" command in the "File" menu. To open an existing book, the user must select the option "Open" in the "File" menu. The user can insert a worksheet between two sheets by selecting the "Worksheet" option in the "Insert" menu.
Keyboard Usage: The following table lists the various key combinations for selecting a row, column, current cell, sheet, etc.
Selection of shortcut keys
Enter the current cell
Full CTRL + Spacebar
The rise of the entire line + space
Entire worksheet CTRL + SHIFT + Space
The user can perform various kinds of entries in the cell. It can enter text, number, data, and time in a cell. It can also enter some special characters, such as $% + - / (). It can also enter the date and time in the cell. He can choose different formats for date and time according to his own requirements.
Data entry in the series: the user can fill a range of cells with the same value or with a series of values. This can be done using the auto-complete knob (small square in the lower right corner of the active cell).
References to cells: MS Excel provides three types of references to cells: relative, absolute and mixed. Relative references refer to a cell relative to a given position. Absolute references refer to a specific cell, regardless of the position of the formula. & # 39; the mark is used to indicate an absolute reference. Mixed links are a combination of both relative and absolute links. It has one absolute coordinate and one relative coordinate. $ CI and C $ 1 are examples of mixed links.
MS Excel provides fast search and instant data replacement. To search or replace data entered by the user, he can use the "Find or replace" command in the "Edit" menu.
Insert or delete rows and columns:
MS Excel provides the ability to insert rows or columns into an existing worksheet. Inserting a data row shifts the remaining rows down and deletes the last row of the worksheet. Similarly, inserting a column shifts the remaining columns to the right and deletes the rightmost column. This is because the total number of rows and columns in any case remains the same.
MS Excel provides several formatting functions that improve the appearance of the data, which is presented in the worksheets. Some of them are described as follows: MS Excel allows you to customize the page before printing. To customize the page, the user needs to open the "File" menu and click "Page Setup." The Page Setup dialog box appears, which allows the user to set paper size, data orientation, area scaling, set left, right, bottom and top margins, set header and footer, etc.
MS Excel provides an autorun option that adjusts the width of a column according to the widest entry in this column. The user can hide or display certain rows or columns. It can also provide a standard default column width.
MS Excel allows the user to align characters in various ways using the Alignment tab of the Format Cells dialog box. The dialog box provides a number of alignment options.
Horizontal alignment options:
General: the text is aligned to the left and the numbers are aligned to the right. This is the default status.
Left: aligns the content to the left of the cell.
Center: aligns the contents of the cell in the center of the cell.
Right: aligns the content to the right of the cell.
Fill: Fills selected cells with one character.
Excuse: this option is selected with several lines of text, as it wraps the content from left to right.
Vertical alignment options:
Top: aligns the text at the top of the cell.
Center: puts the text in the center of the cell.
Bottom: aligns the text at the bottom of the cell.
Justification: wrapping text from top to bottom.
MS Excel provides the ability to view the same worksheet simultaneously in multiple windows. This is achieved by selecting the New Window command in the Windows menu. The user can also create multiple windows to organize the workspace for quick access to the necessary information. Using MS Excel, the window can be organized differently using the Arrange command from the Windows menu.
If the user wants to move between different windows, he can do this by pressing Ctrl + F6 to go to the next window or by pressing Ctrl + Shift + F6 to go to the previous window. It can temporarily hide or display windows by choosing the “Hide” command from the Window menu to hide the active window or by choosing the Show command from the Window menu to display the hidden window.
When a user is working on a very large sheet with row and column headings, the row headers are scrolled to the left as he moves to the right. Similarly, when it moves down to see data, the column headings scroll up. To overcome this problem, it can split the active window into two, with row or column headers in one window and data in another window.
Controls: Controls are special objects that improve the user interface and facilitate user input. MS Excel provides several custom controls, such as list boxes, checkboxes and dialog boxes, etc. In the "View" menu there are a large number of toolbars. Users can add a toolbar or multiple toolbars to a working document depending on the work being performed and use various controls in their documents.
Functions and formulas: embedded formulas are called functions. MS Excel provides data analysis and text management using various functions. Users can easily calculate percentage, percentage, average, etc., using built-in functions. This can be done either by entering functional formulas or using the function wizards. Formulas are widely used in simple calculations (such as addition, subtraction, multiplication, and division) and advanced calculations. They provide an opportunity for broad data analysis.
Autocomputation: MS Excel spreadsheet allows the user to automatically recalculate the entire worksheet each time a change is made in one cell. Basically there are two types of recalculations.
Automatic: with this type of calculation, the change in the cell value automatically recounts the entire worksheet.
Manual: With this calculation, recalculation of the full worksheet is performed by pressing the F9 key. This option can be selected on the Calculation tab of the Parameters dialog box that opens by choosing Parameters in the Tools menu.
Charts One of the most important functions of MS Excel is a chart. MS Excel allows users to view data entered in the form of tables in graphical form in the form of diagrams, which helps the user to easily understand, analyze and compare data. Excel allows its users to create either two-dimensional diagrams or three-dimensional diagrams. The user can enhance the chart by adding chart elements such as data labels, legend, headings, text, and grid lines. It can also format these elements using colors, alignment, fonts, and other formatting attributes. MS Excel also allows users to view charts with data using in-built charts. These diagrams are included in the worksheet and can be copied, moved and modified in the same way as any other graphic object.
Database: data represents the raw facts, data is processed, and the database is an organized collection of information. Each organization is heavily dependent on databases for storing, retrieving, and supporting various types of data. MS Excel provides all this in the form of its database function. In MS Excel, a database can be created in two ways:
Enter the data in a table on the sheet.
Use the "Data Form" command
Records can be inserted, deleted and sorted using the Data menu.
Thanks to the above MS Excel functions, users can perform almost all the operations they want in a very efficient and simple way. Its advanced functions made it the first choice for professionals working in a financial institution to perform their long-term tasks in an easy and fast way. Therefore, MS Excel has become the preferred choice for most users, as well as for professionals all over the world.
