Completed
Start 0:00
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel for Administrative Assistants Tutorial
Automatically move to the next video in the Classroom when playback concludes
- 1 Start 0:00
- 2 Introduction 0:09
- 3 Inserting a Table 2:00
- 4 Converting a Table 8:51
- 5 Removing Duplicates 13:13
- 6 Conditional Formattingg 17:23
- 7 Charts Part 1 23:29
- 8 Charts Part 2 30:50
- 9 Sparklines for Trend Analysis 34:57
- 10 Inserting SmartArt 38:07
- 11 Freezing Rows and Columns 44:55
- 12 Inserting Images 48:44
- 13 Prep Document and Convert to PDF 53:38
- 14 Creating an Outline with Button Links 1:00:54
- 15 Naming a Range and Linking to It 1:08:42
- 16 Text To Columns Tool 1:12:08
- 17 Consolidation Tool 1:17:17
- 18 Quick Pivot Table and Pivot Chart 1:23:47
- 19 Showing Correlation with a Pivot Table and Chart 1:32:11
- 20 Discovering Insights with Pivot Tables 1:37:04
- 21 In Cell Dropdowns with Data Validation 1:44:41
- 22 Cell Protection 1:52:13
- 23 Sharing Files via the Cloud 1:57:15
- 24 Conclusion 2:01:34
