Uses Of Ms Excel

Uses Of Ms Excel

General
Common Uses For Excel
Uses Of Ms Excel In Our Daily Life
Introduction to Computer
What Are the Uses of Excel & MS Word in Companies? Spreadsheets, files and memos are necessary documents in most businesses. Until computers became part of the typical business office, these. In Excel, when we separate any two numbers using slash ('/') sign then it converts that number into decimal format. To keep fractions for such kinds of numbers we have the Fractions option, first, select the cell whose value we need to convert in fractions and select the Format Cells option from the right-click menu list. Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS.It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets.
Classification of Computer
Computer System
Operating System
Programming Concept
Application Package
REMAINING / EXTRAS:

MS Excel allows us to keep the header and footer in our spreadsheet document.
2. 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.
Common Uses For Excel3. Password Protection
It allows the user to protect their workbooks by using a password from unauthorized access to their information.
Uses Of Ms Excel In Our Daily Life4. 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

MS Excel allows us to keep the header and footer in our spreadsheet document.
2. 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.
Common Uses For Excel3. Password Protection
It allows the user to protect their workbooks by using a password from unauthorized access to their information.
Uses Of Ms Excel In Our Daily Life4. 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
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.
6. 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.
7. 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.
8. Automatically edits the result
MS Excel automatically edits the result if any changes are made in any of the cells.
9. 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).
People Also Read