Features of Excel

---

---

Features of Excel

MS Excel is widely used for various purposes because the data is easy to save, and information can be added and removed without any discomfort and less hard work.

Most Importaint Features of Excel

• Add Header and Footer: MS Excel allows us to keep the header and footer in our spreadsheet document.
• Find and Replace Command: MS Excel allows us to find the needed data (text and numbers) in the workbook and also replace the existing data with a new one.
• Password Protection: It allows the user to protect their workbooks by using a password from unauthorized access to their information.

• Data Filtering: Filtering is a quick and easy way to find and work with a subset of data in a range. A filtered range displays only the rows that meet the criteria you specify for a column. MS Excel provides two commands for filtering ranges: AutoFilter; which includes filter by selection, for simple criteria. Advanced Filter; for more complex criteria
• Data Sorting: Data sorting is the process of arranging data in some logical order. MS Excel allows us to sort data either in ascending or descending order.
• Built-in formulae: MS Excel has got many built-in formulae for sum, average, minimum, etc. We can use those formulae as per our needs.
• Create different charts (Pivot Table Report): MS Excel allows us to create different charts such as bar graph, pie- charts, line graphs, etc. This helps us to analyze and compare data very easily.
• Automatically edits the result: MS Excel automatically edits the result if any changes are made in any of the cells.
• Formula Auditing: Using formula auditing we can graphically display or trace the relationships between cells and formulas with blue arrows. We can trace the precedents (the cells that provide data to a specific cell) or the dependents (the cells that depend on the value in a specific cell).
• Easy To Store Data: Since there is no limit to the amount of information that can be saved in a spreadsheet, MS Excel is widely used to save data or to analyse data. Filtering information in Excel is easy and convenient.
• Easy To Recover Data: If the information is written on a piece of paper, finding it may take longer, however, this is not the case with excel spreadsheets. Finding and recovering data is easy.
• Application of Mathematical Formulas: Doing calculations has become easier and less time-taking with the formulas option in MS excel
• More Secure: These spreadsheets can be password secured in a laptop or personal computer and the probability of losing them is way lesser in comparison to data written in registers or piece of paper.
• Data at One Place: Earlier, data was to be kept in different files and registers when the paperwork was done. Now, this has become convenient as more than one worksheet can be added in a single MS Excel file.
• Neater and Clearer Visibility of Information: When the data is saved in the form of a table, analysing it becomes easier. Thus, information is a spreadsheet that is more readable and understandable.

---

---

---