Ms excell is often used in data analysis for organizing data,calculations through in-built functions such as (SUM,AVERAGE),visualizing trends and insights using charts,summarizing data using pivot tables,applying conditional formatting and quick identification of issues that need to be solved or opportunities.
Uses of Ms excell in data analysis
1.Calculation
Built in functions such as SUM(),AVERAGE(),COUNT() and others are used for calculation.
Conditional formatting where functions such as COUNTIF,SUMIF are used to count or sum based on specific conditions.
Pivot tablesare used to summarize vast data by categories (rows/columns) and values (sum, count, average).
Steps to be involved here include:
i)Select any cell in your worksheet, go to the Home tab, and click on "Pivot Table
ii)Choose the Pivot Table Location
iii)Add Fields to the Pivot Table
For example drag the "Country" field to the Row area and the "Days" field to the Value area.
iv)The end result will look like this.
2.Data organization and cleaning
This involves sorting and filtering.Go to your table and select a column you want then choose the filter option on top of the ribbon then choose how you want your data filtered for example if it's greater than 10.
Removing duplicates is also another feature used to ensure data accuracy.
3.Charts and Visualization
Ms Excell uses bars such as in bar charts or lines such as in line chart to represent data. Examples of charts used are Line Chart,Bar Chart,Column Chart,Area Chart and Pie Chart.
To get here you have to:
Select your dataset and go to Insert > Charts.
Choose from bar charts, line charts, or pie charts.
Customize the chart for clarity and impact.
Top comments (0)