How To Use Calculated Field/Item In Excel

Oct 25, 2020

This example teaches you how to insert a calculated field or calculated item in a pivot table.

#Tutorial#How To#Data Analysis#Pivot Tables

How To Use Conditional Formatting for Icon Sets In Excel

Icon Sets in Excel make it very easy to visualize values in a range of cells.

#Tutorial#How To#Data Analysis#Conditional Formatting

How To Use Data Tables In Excel

Instead of creating different scenarios, you can create a data table to quickly try out different values for formulas.

#Tutorial#How To#Data Analysis#What-If Analysis

How To Use Date Filters In Excel

This example teaches you how to apply a date filter to only display records that meet certain criteria.

#Tutorial#How To#Data Analysis#Filter

How To Use Descriptive Statistics In Excel

You can use the Analysis Toolpak add-in to generate descriptive statistics.

#Tutorial#How To#Data Analysis#Analysis ToolPak

How To Use Error Bars In Excel

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

#Tutorial#How To#Data Analysis#Charts

How To Use Exponential Smoothing In Excel

This example teaches you how to apply exponential smoothing to a time series in Excel.

How To Use F-Test In Excel

This example teaches you how to perform an F-Test in Excel.

How To Use Find Duplicates In Excel

This example teaches you how to find and highlight duplicates (or triplicates) in Excel.

How To Use GetPivotData Function In Excel

To quickly enter a GETPIVOTDATA function in Excel, type an equal sign (=) and click a cell in a pivot table.