Join Nate Makdad for an in-depth discussion in this video Learning the four dimensions of a pivot table, part of Creating Interactive Dashboards in Excel 2013.
- So now that we've connected to our data…we want to built the pivot tables…that will drive our template, and there are four…components of a pivot table.…We just want to walk through each of these sections.…Because we're going to be referencing…them later in visual basic.…So since we've clicked on the pivot table,…we can see our field list, and if for any reason…you weren't seeing a field list when you opened this…you can click off or click back on,…make sure you're highlighted on the pivot table…or if you're still on the pivot table…and still not showing, you need to make sure…show field list is on, so since it's hiding…I'm going to hide, you can right-click…and then do show field list.…
All of those bring up these values.…So now that we can see our field list,…we've got pivot table fields, which are all of the values…coming through from our data, and then our four sections:…filters, columns, rows, and values.…So let's start in the upper left, our filters,…obviously work on filtering down our data.…So this 3,022 positions is our total number of openings.…
- Recognize three dimensions of a PivotTable.
- Summarize four design tips.
- Identify the two default sections for values in Excel.
- Explain how to add slicers in a single column.
- Recall the shortcut used to insert a hyperlink.
- Determine the location to look when you have an error while pasting data.