The Top 30 Excel 2016 Tips and Tricks. This video contains plenty of shortcuts, functions, and formulas that you’ll encounter when working with excel.
Excel Video Playlist: https://www.youtube.com/watch?v=R5gbj0oTnjU&list=PL0o_zxa4K1BWYhjLZRtBWRTghtPGQwEfe
1. Excel AutoFill Tutorial 1:53
2. Flash Fill 6:00
3. Quick Save Shortcut 7:09
4. Quick Print Shortcut 7:31
5. New Workbook Shortcut 7:54
6. Concatenate & TextJoin Functions 9:00
7. Text To Column 12:05
8. Transpose Columns to Rows 14:08
9. Sorting Data 16:30
10. Filtering Data 18:40
11. Freeze Rows and Columns With Freezepanes 20:15
12. Extract Text From Cells Using The Left, Mid, and Right Functions 22:36
13. AutoSum Function 25:06
14. The Average Function 26:26
15. Count, CountA, & CountBlank Functions 27:33
16. Basic Math Operations – Addition, Subtraction, Multiplication, Division, Exponents, & Square Roots 29:55
17. Basic Statistics – Max, Min, Median, Mode, & Standard Deviation Functions – 33:32
18. Show Formulas – 37:09
19. Excel VLookUp Function – 38:32
20. Drop Down List With VlookUp – 42:46
21. Shortcut Keys – Bold, Italicize, Underline & Strike through 44:17
22. Insert Line Break Shortcut 45:23
23. Autofit Column Width 46:34
24. Insert Rows and Columns 47:12
25. Moving Rows and Columns 47:48
26. Find and Replace Tutorial With Shortcut Key 49:00
27. Lowercase, Uppercase, & Proper Functions 50:27
28. Excel Calendars 52:01
29. Conditional Formatting 54:05
30. Line Graphs & X Y Scatter Charts With Trendlines and Slope-Intercept Equations Plus The Forecast Function 55:40
Subscribe:
https://www.youtube.com/channel/UCEWpbFLzoYGPfuWUMFPSaoA?sub_confirmation=1
Access to Premium Videos:
https://www.patreon.com/MathScienceTutor
Music Track Link:
https://audiojungle.net/item/heroic-orchestral-hip-hop/20511656?ref=Life2024