DEV Community

Cover image for "Day 17: Excel Essentials Unveiled - Sharing Today's Insights on My Learning Adventure! 📊🚀 #ExcelSkills #LearningJourney"
Nitin-bhatt46
Nitin-bhatt46

Posted on

"Day 17: Excel Essentials Unveiled - Sharing Today's Insights on My Learning Adventure! 📊🚀 #ExcelSkills #LearningJourney"

EXCEL - 16

INTRODUCTION TO VISUALISATION IN EXCEL & GOOGLE SHEETS. - 2

SCATTER PLOT :-

Type of correlation :-

CORELL() - Helps us to find the correlation.

Positive
Neutral
Negative.

BOX-PLOT :-

Min
Max
IQR
MEDIAN
Q1
Q2
Q3
Q4
AND OTHER VALUE ARE CALLED ( Outliers )

Treemap :-

It shows best for hierarchical representation of data.
It shows different areas with different arrangements to show the value of data in a visual form.

WATERFALL CHART :-

It shows the running total, it helps us to know how finance works in a company, ups and down.
We can create charts with and without the insert tab.
Old excel we cannot use directly so, we have to make it from scrap.
Stack chart to Waterfall chart.

FUNNEL CHART :-

We can create charts with and without the insert tab.
Old excel we cannot use directly so, we have to make it from scrap.
We use stack funnel charts to create a funnel chart.

COMBO CHART :-

It is a combination of charts in which we use multiple charts like bar plots with trend lines.

MAP CHART :-

Once we give input we get a country or a world chart according to the dataset of the chart map.

SUNBURST CHART :-

Also Known as RADIAL TREE MAP OR RING CHART, IT HELP us to show hierarchical charts in a circular way.

We must sort the data first and then construct the chart.

RADAR CHART :-

Multi variant char also known spider , web, coweb, polar , star, kiviat diagram chart.

STOCK CHART :-

While making this chart data must be arranged in a particular way so that we can get the perfect change in the chart according to the data set.

These functions are fundamental for various tasks in Excel, including text manipulation, logical operations, conditional formatting, and data analysis.

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.

Top comments (0)