How to Refresh or Update a Pivot Table In Excel2020-10-28Data Analysis Pivot TablesAny changes you make to the data set are not automatically picked up by the pivot table.
How To Use t-Test In Excel2020-10-28Data Analysis Analysis ToolPakThis example teaches you how to perform a t-Test in Excel.
How To Add Trendline In Excel2020-10-27Data Analysis ChartsThis example teaches you how to add a trendline to a chart in Excel.
How To Create a Pareto Chart In Excel2020-10-27Data Analysis ChartsThis example teaches you how to create a Pareto Chart in Excel.
How To Create a Pivot Chart In Excel2020-10-27Data Analysis Pivot TablesA pivot chart is the visual representation of a pivot table in Excel.
How to Create Outlining Data In Excel2020-10-27Data Analysis FilterOutlining data makes your data easier to view. In this example we will total rows of related data and collapse a group of columns.
How to Create Scatter Chart In Excel2020-10-27Data AnalysisUse 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.
How to Create Thermometer Chart In Excel2020-10-27Data Analysis ChartsThis 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 Excel2020-10-27Data Analysis FilterThis example teaches you how to remove duplicates in Excel. Go here to only find duplicates.
How To Make Pie Chart In Excel2020-10-27Data Analysis ChartsPie charts are used to display the contribution of each value (slice) to a total (pie).
How To Use Number and Text Filters In Excel2020-10-27Data Analysis FilterThis example teaches you how to apply a number filter and a text filter to only display records that meet certain criteria.
How to Use Quadratic Equation In Excel2020-10-27Data Analysis What-If AnalysisA quadratic equation is of the form ax2 + bx + c = 0 where a ≠ 0.
How To Use Randomize List In Excel2020-10-27Data Analysis SortThis article teaches you how to randomize (shuffle) a list in Excel.
How To Use Regression Analysis in Excel2020-10-27Data Analysis Analysis ToolPakThis example teaches you how to run a linear regression analysis in Excel and how to interpret the Summary Output.
How To Use Reverse List In Excel2020-10-27Data Analysis SortThis article teaches you how to reverse a list in Excel. For example, we want to reverse the list in column A below.