Completed
- Flash Fill -
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
The Ultimate MS Excel Crash Course - Microsoft Excel 2016 Tutorial for Beginners
Automatically move to the next video in the Classroom when playback concludes
- 1 - Introduction to the Excel Course and Exercise Files -
- 2 - Basics of Using the Ribbon -
- 3 - Quick Access Toolbar -
- 4 - Mini Toolbars and Contextual Menus -
- 5 - Status Bar -
- 6 - Basics of Entering and Editing Data in a Workbook -
- 7 - Exercise 01 -
- 8 - Formatting Dates -
- 9 - Formatting Numbers -
- 10 - Exercise 02 -
- 11 - Working with Fill and Series -
- 12 - Flash Fill -
- 13 - Workbook Views, Zoom, and Freeze -
- 14 - Printing -
- 15 - Exercise 03 -
- 16 - Methods of Cutting, Copying, and Pasting -
- 17 - Delete and Clear -
- 18 - Insert, Hide, Column Width and Row Height, and Merge -
- 19 - Alignment -
- 20 - Themes and Styles -
- 21 - Exercise 04 -
- 22 - Basics of Formulas and Functions -
- 23 - Complex Examples of Formulas -
- 24 - Exercise 05 -
- 25 - Managing Worksheets -
- 26 - Working with Multiple Workbooks -
- 27 - Saving in Different File Types -
- 28 - The Spell Checker -
- 29 - Inserting Comments -
- 30 - Exercise 06 -
- 31 - The VLOOKUP Function -
- 32 - Text Functions -
- 33 - Date and Time Functions -
- 34 - Logical Functions -
- 35 - Creating Graphs and Charts -
- 36 - Customizing a Cluster Column Chart -
- 37 - Customizing a Pie Chart -
- 38 - New Chart Types in Excel 2016 -
- 39 - Exercise 7 -
