|  Register|  Log In

Event Detail

Details
Name: Excel Pivot Tables
Date: 03/15/2019, 1 day(s)
Time: 9am-4pm
Place: Sacramento, 180 Promenade Circle
Price: Member - $210
Non-Member - $350


The pivot table in Excel is arguably the most powerful tool in the entire Microsoft Office suite. When the success of your company relies on the ability of its employees to analyze complex data efficiently and quickly, it is essential that you master pivot tables.

A pivot table is a data summarization tool that can automatically sort, group, count, filter, report, and summate data with simple dragging and dropping. This course will enhance your ability to manipulate, analyze, and interpret large quantities of data and empower you to make effective, data-driven solutions.

Through hands-on lessons with an in-person instructor, accompanied by our pivot tables training curriculum, you will learn to:


  • Import and prepare large datasets into Excel
  • Setup data and create a pivot table
  • Understand source data considerations
  • Respond to changes in source data
  • Work with Report Layout options
  • Group PivotTable data and create Calculated Fields
  • Sort and filter data
  • Create data subsets and extract detail from a pivot table
  • Create a Pivot Chart
  • and much more


DateDurationMember(Non)Location 
4/21 day$210 ($350)180 Promenade CircleRegister >
Date Duration Member/
Non-Member
Location
03/15 1 day(s) $210/ $350 Sacramento, 180 Promenade Circle Register >
VMA Sponsors
VMA Partners