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 - 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