Video excel pivot table tutorial. January 21 2011 by mynda treacy 19 comments. Jump to chapters below this pivot table excel tutorial shows you how to use and create pivot tables in excel 2010 2013 2016 2019 and office 365. But basically all you need to know is that something that would typically take a long time can be done quickly and painlessly when you build a pivot table. Ideally you can use an excel table like in our example above.
Check out this video to see all of the different capabilities of an excel pivot table. Your data should be organized in a tabular format and not have any blank rows or columns. Learn how to create pivot tables in excel and how to use them to draw out the information you want to see. Tables are a great pivottable data source because rows added to a table are automatically included in the pivottable when you refresh the data and any new columns will be included in the pivottable fields list.
Pivot tables are intimidating to many excel users. Thankfully these issues are easily fixed. Excel pivot table video tutorial.