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.

Learn how to create interactive Excel dashboards that transform raw data into actionable insights with this step-by-step guide.

A dedicated Power Pivot option should appear on the Excel menu bar. Now, let's go over some of the top tips to master Power Pivot for your workflow.