Insert data and create a pivot table (or several!) First, generate the raw data set that you plan to use to create an interactive dashboard in Excel.

This article explains how to create a report in Microsoft Excel using key skills like creating basic charts and tables, creating pivot tables, and printing the report.

Open an Excel sheet with relevant data. Select Analyze Data at the top and Excel automatically selects the table on your sheet. You can check suggested pivot tables and charts from the side menu.

An curved arrow pointing right. Here's how to create pivot charts in Excel to quickly and easily analyze large data sets. Produced by Sara Silverstein Follow BI Video: On Facebook More from Tech ...

How to create a pivot table and pivot chart in Excel While pivot tables seem intimidating, they're actually easy to create and give you the ability to gain deep insights into the data in your ...