Excel Power Pivot Tables | CSU Pro Dev


Excel Pivot Tables

Course Description

Today's world is driven by data and data-based decisions. Excel pivot tables are useful and powerful tool in MS Excel that can help you  summarize, analyze, explore and present your data. For example you can take sales data with columns like salesman, region and product-wise revenues and use pivot tables to quickly find out how products are performing in each region. This course will give you the skills, tips and tricks required to master Excel Pivot tables.

Who Should Attend

This class is intended for Excel users looking to master Excel Pivot Tables for data analysis.


* Excel Formulas and Functions or equivalent knowledge

Course Objectives

Upon successful completion of this course, participants will be able to:

  • Apply PivotTable shortcuts to automate difficult analyses
  • Demonstrate presenting data in different formats quickly and easily
  • Create summary totals quickly
  • Modify PivotTables settings


November 1, 2016
1:00 p.m.-5:00 p.m.
Location: CSU's Monte Ahuja College of Business, 1860 E. 18th St., Cleveland, OH 44115 (map)

May 30, 2017
5:30 p.m.-9:30 p.m.
Location: CSU's West Center, 26202 Detroit Road, Westlake, Ohio 44145 (map)

CEUs: 0.4

Fee: $219

Corporate, CSU Student, Alumni and Organization membership discounts available!

Course Benefits

Competency-Based Professional Development: Our programs increase learner retention through application, which results in a more productive workforce.  Students demonstrate their competence by successfully completing a course assessment.

All Inclusive: Each course delivered at CSU includes materials, pre-test and post-test, coffee, snacks, lunch and convenient, on-site parking.

Educated and Experienced Instructors: Our instructors bring years of real-world, classroom and CPA, CFA, SHRM, PhD and MBA experience. Many hold leadership positions in northeast Ohio organizations and have taught at the graduate and undergraduate levels.

Cost-Effective: The course is designed to minimize travel expenses and time away from work.

Convenient: Flexible schedules are not only an attractive option, but a necessary for busy professionals.

Networking Opportunities: Learn from instructors and colleagues who have a variety of industry experiences to share.

Audit option: Students have the option to audit a course they have already attended at no charge within one academic year. Interested students must notify the ProDev office requesting to audit a course a minimum of 10 business days prior to the course start date to ensure there is enough seating. Audit students are responsible for their own parking and lunches. New materials will not be provided.

Corporate, Custom Availability: Can be custom-tailored to the needs of your organization to provide skills your workforce can apply immediately as a corporate training if requested.

Refund Policy

No refunds will be issued if notification is not received seven business days prior to the first day of class. Registrants who cancel will receive a refund, less a $50 processing fee, if we receive written notification a minimum of seven business days prior to the first day of class.