Completed
1. Excel AutoFill Tutorial
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel 2016 Tips, Tricks, Shortcuts, Functions & Formulas
Automatically move to the next video in the Classroom when playback concludes
- 1 1. Excel AutoFill Tutorial
- 2 2. Flash Fill
- 3 3. Quick Save Shortcut
- 4 4. Quick Print Shortcut
- 5 5. New Workbook Shortcut
- 6 6. Concatenate & TextJoin Functions
- 7 7. Text To Column
- 8 8. Transpose Columns to Rows
- 9 9. Sorting Data
- 10 10. Filtering Data
- 11 11. Freeze Rows and Columns With Freezepanes
- 12 12. Extract Text From Cells Using The Left, Mid, and Right Functions
- 13 13. AutoSum Function
- 14 14. The Average Function
- 15 15. Count, CountA, & CountBlank Functions
- 16 16. Basic Math Operations - Addition, Subtraction, Multiplication, Division, Exponents, & Square Roots
- 17 17. Basic Statistics - Max, Min, Median, Mode, & Standard Deviation Functions -
- 18 18. Show Formulas -
- 19 19. Excel VLookUp Function -
- 20 20. Drop Down List With VlookUp -
- 21 21. Shortcut Keys - Bold, Italicize, Underline & Strike through
- 22 22. Insert Line Break Shortcut
- 23 23. Autofit Column Width
- 24 24. Insert Rows and Columns
- 25 25. Moving Rows and Columns
- 26 26. Find and Replace Tutorial With Shortcut Key
- 27 27. Lowercase, Uppercase, & Proper Functions
- 28 28. Excel Calendars
- 29 29. Conditional Formatting
- 30 30. Line Graphs & X Y Scatter Charts With Trendlines and Slope-Intercept Equations Plus The Forecast Function