How to Refresh or Update a Pivot Table In Excel

Oct 28, 2020

Any changes you make to the data set are not automatically picked up by the pivot table.

#Tutorial#How To#Data Analysis#Pivot Tables

How To Use t-Test In Excel

This example teaches you how to perform a t-Test in Excel.

#Tutorial#How To#Data Analysis#Analysis ToolPak

How To Add Trendline In Excel

Oct 27, 2020

This example teaches you how to add a trendline to a chart in Excel.

#Tutorial#How To#Data Analysis#Charts

How To Create a Pareto Chart In Excel

This example teaches you how to create a Pareto Chart in Excel.

How To Create a Pivot Chart In Excel

A pivot chart is the visual representation of a pivot table in Excel.

How to Create Outlining Data In Excel

Outlining data makes your data easier to view. In this example we will total rows of related data and collapse a group of columns.

#Tutorial#How To#Data Analysis#Filter

How to Create Scatter Chart In Excel

Use a scatter chart (XY chart) to show scientific XY data. Scatter charts are often used to find out if there's a relationship between variable X and Y.

#Tutorial#How To#Data Analysis

How to Create Thermometer Chart In Excel

This example teaches you how to create a thermometer chart in Excel. A thermometer chart shows you how much of a goal has been achieved.

How to Delete Duplicates in Excel

This example teaches you how to remove duplicates in Excel. Go here to only find duplicates.

How To Make Pie Chart In Excel

Pie charts are used to display the contribution of each value (slice) to a total (pie).