From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Inserting a PivotTable

Inserting a PivotTable - Microsoft Excel Tutorial

From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Start my 1-month free trial Buy for my team

Inserting a PivotTable

“

- [Instructor] Now, let's go ahead and practice inserting a pivot table in Excel. Luckily, Excel makes it incredibly easy to do so. In the insert menu, you have two options. You can select pivot table to create a blank pivot where you determine what data you're analyzing and where the pivot table will live, or you can use the recommended pivot table options which will allow you to browse some pre-populated starting points. If I'm being honest, I don't find the recommendations very helpful. Personally, I prefer to just build my pivot tables from scratch, but it's important to know that those recommendations do exist if you choose to use them. Let's jump into Excel and actually practice this. Here I am in Excel. I've opened up the IMDB movie database file available in the course resources and there are a few different ways that I can insert a pivot from here. Excel is actually really smart and helpful when it comes to inserting pivots. The simplest way to do this is to simply select any…

Contents