• Microsoft Excel
Excel is one of the powerful tools which is used to organize, calculate and format a data.
Excel provides many commands and we are using excel as a tool for data analysis. It makes data analysis task easy.
• Features
Excel comes up with plenty of features. Some basic and important features are discussing in this topic such as Sorting, Filtering, What-If Analysis, Sparklines, Pivot Tables, Pivot Charts, Color Coding and Conditional Formatting.
1.1 Objectives
Excel provides commands and tools that make our data analysis tasks easy. we can avoid much time consuming and complex calculations using Excel.
Sorting vs Filtering:
Sorting Filtering
Same search results, different order. Filtering reduces the number of results
Sorting takes a set of data and sorts it by a chosen metric or letter Filtering removes data that’s irrelevant to your analysis
