How To Use Structured References In Excel

Oct 27, 2020

When working with tables in Excel, you can use structured references to make your formulas easier to understand.

#Tutorial#How To#Data Analysis#Tables

How To Use Subtotal function in Excel

Use the SUBTOTAL function in Excel instead of SUM, COUNT, MAX, etc. to ignore rows hidden by a filter or to ignore manually hidden rows.

#Tutorial#How To#Data Analysis#Filter

How To Use Transportation Problem In Excel

Use the solver in Excel to find the number of units to ship from each factory to each customer that minimizes the total cost.

#Tutorial#How To#Data Analysis#Solver

How To Create A Gauge Chart(Speedometer Chart) In Excel

Oct 25, 2020

A gauge chart (or speedometer chart) combines a Doughnut chart and a Pie chart in a single chart.

#Tutorial#How To#Data Analysis#Charts

How To Create a Geographic Heat Map In Excel

To create a heat map in Excel, simply use conditional formatting.

#Tutorial#How To#Data Analysis#Conditional Formatting

How To Create A Histogram In Excel

This example teaches you how to create a histogram in Excel.

#Tutorial#How To#Data Analysis#Analysis ToolPak

How To Create A Line Chart In Excel

Line charts are used to display trends over time.

How To Create Frequency Distribution In Excel

Did you know that you can use pivot tables to easily create a frequency distribution in Excel?

#Tutorial#How To#Data Analysis#Pivot Tables

How To Create Gantt Chart In Excel

Excel does not offer Gantt as chart type, but it's easy to create a Gantt chart by customizing the stacked bar chart type.

How To Create Multi-level Pivot Table In Excel

It's perfectly ok to drag more than one field to an area in a pivot table.