Interactive Excel Spreadsheets | CPE QAS by learnformula
Interactive Excel Spreadsheets
Making your Excel Spreadsheets more interactive with Sorts, Filters, Slicers, Timelines, and Form Controls.
schedule1h
4.6(49)
Tom Fragale
•
Microsoft Certified Trainer with over 20 Years of Training Experience, and over 35 years in IT overall
59 Courses
• 5397 Reviews
Tom Fragale is a computer professional with over 30 years of professional experience. He is a Microsoft Certified Trainer, a Microsoft Certified Office Master, and a Microsoft Certified Expert in Word...
About this course
This course will show you how to bring your data to life and make them more interactive and user-friendly by adding sorts, filters, slicers, timelines, and form controls. It will show you step-by-step how to add these features to any Excel workbook.
Topics include:
Sorts
Filters
Formatted Tables
Total row in formatted tables
Slicers in formatted tables
Filters and Sorts in Pivot Tables
Slicers in Pivot Tables
Timelines in Pivot Tables
Pivot Charts
The Developer Tab
Form Controls
Spin Button
Scroll Bar
Checkbox
ComboBoxes
Group Boxes
Option Buttons