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.

Spindustry Training Offers SharePoint Governance Consulting

Avoid costly, time consuming mistakes with your SharePoint installation.

Live Instructor-Led Training

The Power to Boost Productivity!


CONTACT US
Training partners

Spindustry Training

spindustrytraining.com - (515) 334-9556

Bookmark and Share

Online Excel - Intro to Tables and PivotTables

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

Schedule for this Course

 DateLengthLocation
Register 02/26/2021 10:45 am - 12:45 pm
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