News

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.

Five Benefits of Live Instructor Led Training

Five Benefits of Live Instructor Led Training

Experts still agree that there are no viable replacements for having a live professional in the room during training sessions.

Spindustry Training Offers SharePoint Governance Consulting

Avoid costly, time consuming mistakes with your SharePoint installation.


CONTACT US
Training partners

Spindustry Training

spindustrytraining.com - (515) 334-9556

Bookmark and Share

Online Excel 2016 Advanced Data Analysis using PivotTables

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

Schedule for this Course

 DateLengthLocation
Register 03/26/2019 10:45 am - 12:45 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. 

Prerequisites

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