2015
New England Supply Chain Conference & Exhibition

APICS - The Association for Operations Management North Shore Chapter 20 and Boston Chapter 10    --   The Council of Supply Chain Management Professionals (CSCMP) New England Roundtable    --    The Northeast Supply Management Group, A Special Interest Group of ISM®

2015 Program Author Index Presentation Index
New England Supply Chain Conference & Exhibition


2015 New England Supply Chain Conference and Exhibition - Mary Ellis Presentation

Using Excel Pivot Tables & Other Tools to Make Your Data Work for You (Simplified for Today's Business Environment!)
Mary Ellis, Sr. Trainer, New Horizons Computer Learning Centers

A PivotTable 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...


Web: www.newenglandsupplychainconference.org
General Information: info@newenglandsupplychainconference.org
Exhibitor Services: exhibitors@newenglandsupplychainconference.org