Features of MS-Excell

1. Microsoft Excel is a spreadsheet program that comes with Microsoft's Office software package. Excel is a commonly used program in finance due to its ability to provide digital data organization. Excel has a variety of basic features that make it useful, even for new users who do not know how to use its more advanced functions.
Storing Data
2. Perhaps the most useful basic feature of Excel is the ability to store and organize data. Organizing data in Excel is as simple as selecting a cell in a spreadsheet and typing in the value that you want to store. A single Excel spreadsheet can contain thousands of rows and columns, allowing you to store huge amounts of data in one place. A single Excel workbook can contain many worksheets; each worksheet is a separate spreadsheet. This allows you to store many different data tables within the same Excel file.
You can create simple data tables quickly, and you can move to different cells using the "Enter" and tab keys or the arrow keys on your keyboard, rather than using the mouse pointer. You can erase data by dragging a box around the desired cells and pressing on the "Delete" key, while you can copy data to different parts of a spreadsheet simply by selecting cells and using the copy and paste functions.
Charts and Graphs
3. Another basic feature of MS Excel is the ability to create customizable charts and graphs of data. Creating a basic chart or graph is relatively simple; you must select a range of cells in the table, choose to create a graph, and specify the graph type. Excel can produce many types of graphs, such as pie charts, bar charts and line charts. Graphs are especially useful for presentations, and you can copy your graphs into MS PowerPoint slides. Formatting
4. MS Excel allows for a wide range of formatting options similar to MS Word. You can alter font size, style and color, and you can highlight cells with different colors to differentiate data values. You can also increase or decrease the size and spacing of cells to fit the data.
Formulas
5. Excel offers you the ability to enter mathematical formulas into cells to carry out calculations on other cells. Formulas can be simple or complex, and one formula may even refer to a cell that contains a value calculated using a different formula, allowing for multiple levels of calculation. Excel also has several quick calculation tools, such as column averaging and totaling.