EXCEL - 10

PIVOT TABLE :-

Without this Data Analysis is a Laborious task.

Step 1:-

Excel :-

Convert data into table.So, when it is converting to pivot table it will not take range, it will take as a table. In future if you are adding data it can be directly added to the pivot without any hindrance.

Google Sheets :-

In Google sheets you have to do the below steps first and then if you want to add new data
Go to the DATA tab → Named Range → edit the previous data set and increase it to latest dataset range.

Step 2:-

Make sure that all the data you have must be in their correct data type, so that after loading you don’t need to change it.
If you want to find the num ber is in the integer type use “ ISNUMBER “ it will help you to find numerical value.

Step 3:-

Excel :- Go to Insert Tab → Pivot table

Google Sheets :- Go to Insert Tab → Pivot table

Step 4 :-

There is a technique which I follow that says whatever you want to find from a dataset try to create a funnel method so that you can get an answer without any anger.

Let's take an example :-

DATA SET :- Video_games_sales

If you want to top 1 game of 2010 with the most global sales.

First select year filter to 2010 → global_sales sort → Game_names

Benefits of Pivot Tables:

1. Data Summarization
2. Flexibility in Analysis
3. Simplified Reporting
4. Data Comparison
5. Aggregation and Calculation
6. Interactive Exploration
7. Error Identification: - Data Quality Checks
8. Time Efficiency
9. Enhanced Visualisations
10. Streamlined Decision-Making

In summary, pivot tables in Excel offer a range of benefits, including efficient data summarization, flexible analysis, simplified reporting, and enhanced decision-making capabilities. They are a powerful tool for anyone working with large datasets, enabling users to derive meaningful insights and present data in a comprehensible manner.

EXTRA :-
We can use slicers ( FLOATING FILTER OPTION SLIDER ) .
We can use AVG

Adding Slicer :-

SLICER is a slider option which helps us to filter information in the table.
When we add a slicer it is particularly for the specific part of the table. So, to get command for a slicer to control over more than two charts we need to do “ Report connection “. So, with a single slicer we can control all the charts for our report.

Excel ::- Go to Table Design Tab → insert Slicer

Google Sheets :- Go to DATA tab → Add new slicer

In summary, data validation is a powerful tool in Excel that enhances data accuracy and efficiency.

Follow me on this where every day will be added if i learn something new about it :- https://dev.to/nitinbhatt46

Thank you for your time.