Intermediate Excel Pivot Table Techniques

Authored by David Ringstrom
About this Course
Topics covered include: Adding fields to pivot tables; Filtering pivot table data based on date ranges by way of the Timeline feature in Excel 2013 and later; Drilling down into numbers with a double-clickor preventing other users from being able to do so; Getting past the 'PivotTable field name already exists' prompt once and for all; Identifying the requirements of ideal data sets to be analyzed within your pivot tables; Embedding frequently used lists, such as employees, departments, or key customers, into Excel's interface for use with any spreadsheet; Learning the basics of creating pivot tables; Learning how to expand and collapse pivot table elements, thereby avoiding information overload; Creating a macro in Excel that will set any pivot table to automatically format number fields that you add; Seeing multiple ways to remove fields from a pivot table; Creating self-updating titles for charts and pivot charts. Upon completing this course, you should be able to: Recall how to quickly transform lists of raw data into usable reports in just a few simple steps; Recognize and apply the macro that will automatically format number fields that you've added; Define how to create self-updating titles for pivot table charts; Identify calculation methods to use within pivot tables; Recognize how features may appear differently in other Excel versions.
$ 64.00
Add To Cart
NASBA Field of Study
Computer Software & Applications
Level
Intermediate
CPE Credits
2.0
Prerequisites
Experience with Pivot Tables or Completion of Excel 101: Pivot Tables.
Last Updated
07/30/2018
13898