Webinars from Spindustry on SharePoint, MS Teams, and Power BI

Spindustry offers a variety of ways to learn more about solutions to benefit your business. Below is a list of upcoming webinars or pre-recorded sessions that we hope you find helpful.

Spindustry Training Offers SharePoint Governance Consulting

Avoid costly, time consuming mistakes with your SharePoint installation.

Live Instructor-Led Training

The Power to Boost Productivity!

Training partners

Spindustry Training - (515) 334-9556

Bookmark and Share

Online Excel Advanced Data Analysis using PivotTables

Course Code: OLEX6
Length: 0.25 Days
Tuition: $49.00

Schedule for this Course

Register 02/26/2021 1:30 pm - 3:30 pm
Instructor: Pamela Smith
0.25 Days Virtual Training: Online Courses

Course Description:


Now that you know how to create PivotTables to analyze your data, this class will increase your knowledge of PivotTables and teach you more advanced skills. Learn how to use the recommendations command to easily and quickly create PivotTables, use multiple data sources, and work with table relationships. 


Excel 2016 Intro to Tables & PivotTables class or prior knowledge of the topics covered in that class.

Course Outline:

·         Create a PivotTable using Recommended PivotTables command
·         Set number formats
·         Create a PivotTable from multiple local data sources
·         Create relationships between tables
·         Create a PivotTable from an external data source
·         Work with Slicers and Timelines to filter data
·         Group and ungroup items
·         Create formulas and use functions with a PivotTable

back to top