SCM 101 (1D): Pivot Tables for Intermediate Users

Mary Ellis

SCM 101 (1D): Pivot Tables for Intermediate Users

A Pivot Table report can help you see the “big picture”, by summarizing and analyzing your data. Your worksheet has lots of data, but do you know what the numbers mean? Does your data answer all your business questions? PivotTable reports can help to analyze numerical data, and answer questions about it. In seconds you can see who sold the most, and where. See which quarters were the most profitable, and which product sold best. Ask questions, see the answers – without entering a single formula!

• Creating Pivot Tables
• Manipulate Pivot Tables
• Creating Pivot Charts
• Sorting the data
• Adding slicers
• Adding Calculated Fields
• And more…

NESCON 2018