How To Create Multi-level Pivot Table In Excel
Oct 25, 2020
It's perfectly ok to drag more than one field to an area in a pivot table.
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.