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 - Intro to Tables and PivotTables

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

Schedule for this Course

 DateLengthLocation
Register 03/26/2019 8:30 am - 10:30 am
Instructor: Pamela Smith
0.25 Days Virtual Training: Online Courses

Course Description:

 

Learn Excel from the comfort of your office or home.
 
 
Learn the powerful aspects of working with a database in Excel by using the Tables and PivotTables features. Learn how to clean up your data by using the Text to Columns, Flash Fill, Remove Duplicates and Data validation features. Use the Tables feature to quickly organize data and the Pivot Tables feature to look at your data as the “big picture”. 

Prerequisites

 

Excel 2016 Beginning Tips & Tricks class or prior knowledge of the topics covered in that class.

Course Outline:

 

·         Separate text from one column into multiple columns by using Text to Columns feature
·         Remove duplicate data
·         Limit the information entered into cells by using Data Validation
·         Build, sort and filter lists of information using the table feature
·         Automatically summarize data using subtotals
·         Create a PivotTable report
·         reset the summary function in a PivotTable report
·         Separate the data in a PivotTable using the filters field
·         Create a PivotChart report

back to top