Topics covered include:
Creating dynamic and interactive graphs with Excel's PivotChart feature;
Discovering the Recommended PivotTables feature;
Launching macros that clean up pivot tables with a single mouse click;
Learning the nuances associated with subtotaling data within a pivot table;
Learning how the Table feature can vastly improve the integrity of pivot tables in Excel;
Incorporating calculations within or alongside pivot tables;
Learning how to expand and collapse pivot table elements, thereby avoiding information overload;
Gaining control of unruly pivot table data by creating a macro that can automatically transform all count fields into sums and apply number formatting in one fell swoop;
Mitigating the side effects of converting a table back to a normal range of cells;
Compiling unwieldy data into the format required for pivot table analysis quickly and easily;
Staving off frustration by filling blank cells within any columns that contain numbers with zeros before you create pivot tables.
Upon completing this course, you should be able to:
Apply the Custom Lists feature to override the default sort order within pivot tables;
Describe how to create pivot tables from information you extract from databases;
Identify pivot table data in new ways by grouping based on dates or custom arrangements that you define;
Recognize how to import date from a Microsoft Access table
Identify how to disable custom list sorting;
Describe how to slice multiple tables;
Differentiate the steps to resolve duplicate value problems;
Recognize how to create a Macro icon and how it is used;
Identify which Excel version is used to summarize Microsoft Access data;
Describe hoe to set up automatic pivot table refresh in Excel;
Recognize how to automate pivot table refresh in Excel;
Identify likely reasons you have pivot table duplicate values;
Utilize a pivot table number format macro.
$ 30.00
Course is unavailable for purchase.
NASBA Field of Study
Computer Software & Applications
Level
Advanced
CPE Credits
2.0
Prerequisites
Intermediate-Level Experience with Excel Pivot Tables.
Last Updated
07/30/2018
13964
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.