About this document
Advanced Excel Training Manual by ScribdTranslations is a document available to read on EtoBox.
This document presents an introduction to the advanced use of pivot tables in Excel to summarize and analyze large amounts of data. It explains how to create pivot tables by dragging fields such as area, employee name, and month to calculate sums, count items, and show subtotals of salaries, days off, sales, and units sold grouped and filtered in different ways. It also shows how to create calculated fields to obtain new metrics such as amount per day off and applied discount.
- Author
- ScribdTranslations
- Language
- EN