Past Event

Microsoft Office-Excel 2016 Advanced Pivot Tables

April 11, 2019
9:30 AM - 12:30 PM
Event time is displayed in your time zone.
Studebaker Building, 622 W. 132 St., New York, NY 10027 - Conference Room 160

Course description : Learn advanced formulas and work with various tools to analyze data in spreadsheets. Organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects. 

Category: Productivity & Software

Price: $130.00

Target audience: All Faculty, Managers and Staff who are interested in learning skills to create and modify Excel workbooks.  

By the end of the workshop participants will: 

Create and Work with Pivot Tables

  • Understanding PivotTables 
  • Working with Recommended PivotTables 
  • Creating a PivotTable using Worksheet Data 
  • Creating a PivotTable using an External Data Connections 
  • Laying out a PivotTable on a Worksheet 
  • Modifying PivotTable Fields 
  • Using a Report Filter 
  • Refreshing a PivotTable 
  • Formatting a PivotTable 

Enhancing PivotTables

  • Sorting Items in a PivotTable 
  • Creating a Slicer 
  • Grouping Data 
  • Using a Timeline 
  • Applying Label and Value Filters 
  • Creating a Calculated Field 
  • Creating a Calculated Item 
  • Creating Charts from PivotTables

Contact Information