Excel 2016 Tips, Tricks, Shortcuts, Functions & Formulas

Excel 2016 Tips, Tricks, Shortcuts, Functions & Formulas

The Organic Chemistry Tutor via YouTube Direct link

1. Excel AutoFill Tutorial

1 of 30

1 of 30

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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.