Creating a PivotTable report

- Pivot tables are a powerful and flexible…Excel Analysis tools.…A pivot table lets you rearrange,…sort and filter data set on the fly.…So, you can analyze it from several different perspectives…with a minimum of effort.…In this movie, I will show you how to…create a pivot table from an Excel table…that is stored in a workbook.…My data is stored in an Excel table…and you can see it here.…It goes from cell A1…with a header row and all the way down to…row 49.…

And I have room data broken up by month…for the Cambridge and Picadilly room types.…To create a pivot table, I will open the…Insert tab in the ribbon…and then I will click the pivot table button.…I could click recommended pivot tables,…but what that does is create a pivot table…that Excel thinks, based on its own internal logic,…fits your data.…Rather than create one automatically,…instead, I will create a pivot table by hand…so you get a more thorough view of the process.…

Author

Updated

2/18/2016

Released

8/7/2015

Learn everything you need to master the Mac 2016 version of the world's most popular spreadsheet program. Curt Frye provides a comprehensive overview of Excel for Mac 2016, including manipulating workbook and cell data, using functions, printing worksheets, and collaborating with others. In the last half of the course, he covers more complex techniques, such as summarizing data with charts, working with external data, adding images and shapes, and automating routine tasks.