Completed
12. Extract Text From Cells Using The Left, Mid, and Right Functions
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
