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®

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

2011 New England Supply Chain Conference and Exhibition - Pamela Conway Presentation

Business Intelligence in Excel – Using Pivot Tables & Other Tools to Make Your Data Work for You
(Simplified for Today’s Business Environment!)

Pamela Conway, Vice President, CompuWorks

This workshop is designed to show attendees how to use some of the business intelligence tools native to Excel manipulate and read the data stored in spreadsheets. First we will spend time looking at how to manage data. We will look at the proper method of setting up a table of data and then we will review how to sort, filter and perform simply queries of the data.

Next, we will spend an extend period reviewing the powerful feature known as Pivot Tables. A Pivot Table is a data summary tool that allows you to count, total, sort, average and much more, the data stored in a spreadsheet. The results are displayed in a table that can be dynamically manipulated by dragging and dropping fields to view the data from different angles. We will learn how to create and manipulate both Pivot Tables and Pivot Charts. We’ll also learn how to use slicers, new in Office 2010, to create a dashboard affect for a spreadsheet.

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