News

Azure For IT Professionals

Learn more about implementing Azure as part of your infrastructure.

Staying Sharp on Microsoft Office Can Save Time & Money

Learning the latest Microsoft Office tips and tricks can benefit you greatly.

"How do I determine if this new technology is for real?"

Michael Bird explains how to navigate new technology waters.

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