How To Use Group Pivot Table Items In Excel

Oct 25, 2020

This example teaches you how to group pivot table items.

#Tutorial#How To#Data Analysis#Pivot Tables

How To Use Manage Rules In Excel

To view all conditional formatting rules in a workbook, use the Conditional Formatting Rules Manager.

#Tutorial#How To#Data Analysis#Conditional Formatting

How To Use Maximum Flow Problem In Excel

Use the solver in Excel to find the maximum flow from node S to node T in a directed network.

#Tutorial#How To#Data Analysis#Solver

How To Use Moving Average In Excel

This example teaches you how to calculate the moving average of a time series in Excel.

#Tutorial#How To#Data Analysis#Analysis ToolPak

How To use the Advanced Filter to create more powerful filters In Excel

Oct 24, 2020

This example teaches you how to apply an advanced filter in Excel to only display records that meet complex criteria.

#Tutorial#How To#Data Analysis#Filter

How To Change Table Styles In Excel

Quickly format a range of cells by choosing a table style. You can also create your own table style.

#Tutorial#How To#Data Analysis#Tables

How to Create a Checklist In Excel

This example teaches you how to create a checklist in Excel.

How to Create a Column Chart In Excel

Column charts are used to compare values across categories by using vertical bars.

#Tutorial#How To#Data Analysis#Charts

How to Create Area Chart In Excel

An area chart is a line chart with the areas below the lines filled with colors.

How To Create Chart Sheet In Excel

So far we have only seen charts on the same worksheet as the source data (embedded charts).