In this 1/2 day course you will learn how to use the Excel tool to make a pivot table.
A pivot table is a table of statistics that summarizes the data of a more extensive table such as a database, spreadsheet, or business intelligence program. This summary might include sums, averages, or other statistics, which the pivot table groups together in a meaningful way.
Pivot tables are a technique in data processing. They enable a person to arrange and rearrange (or "pivot") statistics in order to draw attention to useful information.
With a pivot table, you can transform one million rows of transactional data into a summary report in seconds. If you can drag a mouse, you can create a pivot table. In addition to quickly summarizing and calculating data, pivot tables enable you to change your analysis on the fly by simply moving fields from one area of a report to another.
Students taking this course are experienced Excel users who are seeking to advance their data analysis capabilities by using Pivot Tables.
To ensure your success in this course, you should have experience with Excel 2016 or Excel 2019 and Pivot Tables. You should already understand spreadsheet concepts and be comfortable creating basic Pivot Tables.
Course cost listed does not include the cost of the courseware. The course to run is subject to a minimum enrollment. This course may run as a live on line instructor led course if the minimum enrollment is not met. For more information, please contact: firstname.lastname@example.org or call: 207-775-0244.