top of page

How to Utilize Data Analysis in Excel

You will never use most of the functions in Excel. They are only there for side problems you may encounter. That's the beauty of Excel. It is a very flexible, powerful system for data analysis needs.


You just need to learn the usage scenarios and seek guidance when you need it.

Here's what you need to know to get started with data analysis:


Getting Started with Data Analysis Techniques in Excel 2024

Although easy to learn, this is a useful data analysis technique for data analysts of all levels. As a data scientist, I still use it myself.


Pivot Tables

Pivot Tables are very useful in all types of data analysis, from sales/marketing to HR.

So what kind of center is it? In short, if you have questions about your data set, such as 'which products are the most productive' and 'who are my loyal customers', a pivot table can help you answer these questions quickly.


Pivot table example:

Let's say we have a data set like this:

With the pivot table, we can summarize that there are 2 red, 2 blue, 2 gray and 1 green cars without counting manually.



To create a PivotTable:


Select all the data you want to analyze (CTRL + A to select all)

Go to the tab and add the PivotTable.

Drag your changes between rows, columns, and values.


Microsoft Excel is one of the most popular data analysis programs. Equipped with a built-in pivot table, this is undoubtedly the most sought-after post-analysis tool available. It is an all-in-one data management software that allows you to easily import, search, clean, analyze and view your videos. In this article we discuss different ways to analyze data in Excel.


Chart

Another great technique for presenting stories and visuals. They summarize information to make it easier to understand and analyze. Excel is known for its ability to manipulate and calculate numbers. A table is a picture that shows all the facts. A chart is a visual representation of data that uses symbols to represent the data, such as bars in a bar chart or lines in a line chart. Excel offers several chart types to choose from, or you can use Excel's recommended


Chart feature to view charts that fit your data and select one.

Step 1: Select a data level.

Step 2: Select Insert > option (select the table type you want from the screenshot).

Step 3: Adjust the installed table if necessary.



Conditional Formatting

Conditional Formatting allow you to show patterns and trends in your data. To use this, create a rule that defines the cell structure by its values. Standard formatting can be applied to a variety of cells (selections or named ranges), Excel tables, and even PivotTable reports in Excel for Windows. Follow the steps below to create the format.


Step 1: Click the General tab. Do one of the following:

Do this if you want to change values ​​in different cells Select Highlight Cells or Rows Up/Down and choose the option that suits your needs. Select the Show Cells row to show dates after this week, numbers between 50 and 100, or less than 10% of the score.


The color scale shows the intensity of the cell color corresponding to the value placed above or below the range and highlights the relationship between values ​​in the range of cells. The distribution of turnover between regions is an example of this. Highlight Color Scale and click the scale you want.  To verify the relationship between values ​​in a range of cells, highlight the data bars and click fill. This causes discoloration on the cell surface. Comparing prices or population density in major cities are two examples.

To display a range of cells containing three to five sets of values, each with its own number, point to the set of images and click the line. For example, you can use a set of three charts to highlight cells sold for under $80,000, $60,000, and $40,000. Alternatively, you can assign a 5-point system to cars and use a list of five images.




1 view0 comments

Comentarios


bottom of page