This course will help you get out from all of that data. It will show you how to quickly organize and summarize your data so that you can analyze it. The course covers everything that you need to know about pivot tables. It starts with having you create a pivot table and then modify and format it. It discusses how to drill down as well as how to create multiple reports from one pivot table. It also discusses how to create and add other formulas and items to an existing pivot table. Finally, it shows you how to update your pivot table with new data without recreating it every time. This is one of, if not the best, feature in Excel. Pivot Tables are a huge time saver if you are working with lots of data. Tables of Content
Delivery Method: QAS Self Study
Version: This course is designed for users of Excel 2016. Participants with Excel 2010 and 2013 can complete the course and should experience little difficulty. This course is not intended for 2007 or earlier versions of Excel. It assumes a familiarity with Excel and is intended for an intermediate Excel user.
Advanced Preparation: None