How to use EXACT function Compare Text In Excel
Oct 28, 2020
This example shows two ways to compare text in Excel. One is case-sensitive and one is case-insensitive.
How To Use t-Test In Excel
Oct 28, 2020
This example teaches you how to perform a t-Test in Excel.
How to Use VLOOKUP function find Closest Match In Excel
Oct 28, 2020
To find the closest match to a target value in a data column, use the INDEX, MATCH, ABS and the MIN function in Excel.
How To Add Trendline In Excel
Oct 27, 2020
This example teaches you how to add a trendline to a chart in Excel.
How To Create a Pareto Chart In Excel
Oct 27, 2020
This example teaches you how to create a Pareto Chart in Excel.
How To Create a Pivot Chart In Excel
Oct 27, 2020
A pivot chart is the visual representation of a pivot table in Excel.
How to Create Outlining Data In Excel
Oct 27, 2020
Outlining 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 Excel
Oct 27, 2020
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.
How to Create Thermometer Chart In Excel
Oct 27, 2020
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
Oct 27, 2020
This example teaches you how to remove duplicates in Excel. Go here to only find duplicates.