Any changes you make to the data set are not automatically picked up by the pivot table.
This example teaches you how to perform a t-Test in Excel.
This example teaches you how to add a trendline to a chart in Excel.
This example teaches you how to create a Pareto Chart in Excel.
A pivot chart is the visual representation of a pivot table 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.
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.
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.
This example teaches you how to remove duplicates in Excel. Go here to only find duplicates.
Pie charts are used to display the contribution of each value (slice) to a total (pie).
This example teaches you how to apply a number filter and a text filter to only display records that meet certain criteria.
A quadratic equation is of the form ax2 + bx + c = 0 where a ≠ 0.
This article teaches you how to randomize (shuffle) a list in Excel.
This example teaches you how to run a linear regression analysis in Excel and how to interpret the Summary Output.
This article teaches you how to reverse a list in Excel. For example, we want to reverse the list in column A below.