Pivot Tables allow you to generate new views of your (sometimes overwhelming) data so you can generate reports that help you summarize, analyze, explore and present your data it in a more flexible manner.
This class is intended for users who have Intermediate or advanced Excel skills. Please be sure to review the topics covered to better assess if this class is for you. However, feel free to call us if there is any question about whether you should register for this class.
Although this course is designed for Excel 2010 2013, many participants find the content transferrable to Office 2007 through Office 2013. Please check with the Instructor or BTC office before registering if you have any questions, since it easier to answer your concerns before the class begins than finding out later the class content is not what you are looking for. Designed for PC based computers (sorry not for Mac/Apple).
- Simplicity – PivotTables use a graphical approach to create summaries.
- Multiple dimensions – You can summarize data using both row and column headings, including using multiple fields in each area, and you can also use a series of criteria fields that filter all the data in the table.
- Excel 2010 introduced ‘Slicers’: interactive criteria controls that are linked to each other and can be linked to multiple PivotTables.
- Interactive analysis – Once you’ve arranged your data in the PivotTable, if you think of other useful information the data could provide, you can rearrange the data simply by dragging fields to different areas.
- Data can easily be displayed graphically – a PivotChart can be created from a PivotTable with a single click.
- When linked directly to external data, PivotTables can be automatically refreshed to include new and amended data.
Prerequisite: MS Excel Functions 3.1
Business & Industry Training
31 College Drive
Concord, NH 03301-7412
Fax: (603) 230-9304
Office of Workforce Development
What our Students Say . . .
MS Excel Pivot Tables,
Fall 2016 Participant
“I found the Business Training Center programs focused on the standard business practice(s). They provided me a hands on approach to learning while further expanding and developing my skills to succeed in my position and putting our company ahead in the current market.”