If you wish to create a a Pivot Table and Pivot Chart in Excel, then this detailed article will guide you through the entire process.

A pivot table is a useful tool in data analysis that can give you an overview of your data. We'll show you how to create one in Excel and Google Sheets.

The pivot table in Excel We’ll need a pivot table before we can start filtering, so to that end, we’ll build the pivot table shown in Figure A, based on the data shown in the same sheet.

Preliminary Setup As I mentioned in my post on how to format tables in Excel, before I do anything with raw data, I format it as a table.

How do I create and populate tables? And, once a table is created, how do we custom filter, format, and design those tables so they look professional in a report? We’ll show you how it’s done.

This column shows how to use the Data Table option in Excel’s What-If Analysis tool.

Learn how to add a highlight to expose groups in your Microsoft Excel data using a helper column and Excel’s conditional formatting feature.