NCSL Webinars allow attendees to participate in meetings taking place around the world from the comfort of their desk. They are collaborative, interactive and easy to use.
Most webinars will be recorded for those who are unable to attend the live meeting.
This is a hands-on course in constructing and modifying pivot tables. Participants should be at a computer to get the most benefit from the session.
Concepts will be introduced one at a time, accompanied by an exercise. A pivot table report is a surprisingly easy, interactive way to quickly explore large amounts of data in many different ways. Use a pivot table report to analyze numerical data in detail and to answer unanticipated questions about your data.
A pivot table report is especially designed for:
- Subtotaling and aggregating numeric data, summarizing data by categories and subcategories, and creating custom calculations and formulas.
- Expanding and collapsing levels of data to focus your results, and drilling down to details from the summary data for areas of interest to you.
- Moving rows to columns or columns to rows—or pivoting—to see different summaries of the source data.
- Filtering, sorting, grouping, and conditionally formatting the most useful and interesting subset of data to enable you to focus on the information that you want. These features can help you increase the ease and power of your data analyses.
- Katrin Osterhaus, principal auditor, Legislative Division of Post Audit, Kansas
- Bob Cox, senior legislative analyst, Office of Program Policy Analysis and Government Accountability, Florida | Pivot Table Tutorial
PC-based attendees required: Windows® 8, 7, Vista, XP or 2003 Server
Mac®-based attendees required: Mac OS® X 10.6 or newer<
Mobile attendees required: iPhone®, iPad®, Android™ phone or Android tablet