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
Course is unavailable for purchase.
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
This Site uses cookies to store information on your device. Some are essential to make our Site work properly; others help us improve the visitor and user experience. By using the Site, you consent to the placement of these cookies. Read our privacy policy to learn more.