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.
How To Use Subtotal function in Excel
Oct 27, 2020
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.
How To Use Transportation Problem In Excel
Oct 27, 2020
Use the solver in Excel to find the number of units to ship from each factory to each customer that minimizes the total cost.
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.
How To Create a Geographic Heat Map In Excel
Oct 25, 2020
To create a heat map in Excel, simply use conditional formatting.
How To Create A Histogram In Excel
Oct 25, 2020
This example teaches you how to create a histogram in Excel.
How To Create A Line Chart In Excel
Oct 25, 2020
Line charts are used to display trends over time.
How To Create Frequency Distribution In Excel
Oct 25, 2020
Did you know that you can use pivot tables to easily create a frequency distribution in Excel?
How To Create Gantt Chart In Excel
Oct 25, 2020
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
Oct 25, 2020
It's perfectly ok to drag more than one field to an area in a pivot table.