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.
How To Use Conditional Formatting for Icon Sets In Excel
Oct 25, 2020
Icon Sets in Excel make it very easy to visualize values in a range of cells.
How To Use Data Tables In Excel
Oct 25, 2020
Instead of creating different scenarios, you can create a data table to quickly try out different values for formulas.
How To Use Date Filters In Excel
Oct 25, 2020
This example teaches you how to apply a date filter to only display records that meet certain criteria.
How To Use Descriptive Statistics In Excel
Oct 25, 2020
You can use the Analysis Toolpak add-in to generate descriptive statistics.
How To Use Error Bars In Excel
Oct 25, 2020
This example teaches you how to add error bars to a chart in Excel.
How To Use Exponential Smoothing In Excel
Oct 25, 2020
This example teaches you how to apply exponential smoothing to a time series in Excel.
How To Use F-Test In Excel
Oct 25, 2020
This example teaches you how to perform an F-Test in Excel.
How To Use Find Duplicates In Excel
Oct 25, 2020
This example teaches you how to find and highlight duplicates (or triplicates) in Excel.
How To Use GetPivotData Function In Excel
Oct 25, 2020
To quickly enter a GETPIVOTDATA function in Excel, type an equal sign (=) and click a cell in a pivot table.