Here’s Another 15 Excel 2016 Tips and Tricks. This is a compilation of 15 additional Excel 2016 tips and tricks that didn’t make it in my previous Top 25 Excel Tips and Tricks video. I’m going to show you some powerful tips and tricks to help you become more proficient with Excel 2016. To watch the other videos in the series click on a link below.
Top 25 Excel 2016 Tips & Tricks: https://youtu.be/EdnAeqxqdzM
Top 15 Advanced Excel 2016 Tips & Tricks: https://youtu.be/PU8ACyYxJBk
Full Office Tips & Tricks Playlist: https://www.youtube.com/watch?v=EdnAeqxqdzM&list=PLLXmgYx8DeQxn3NIuwBGkLuuJsIGSr0Cw
Contents:
1. Move Columns/Rows 0:44
2. Name a Range 1:16
3. Status Bar Totals 2:15
4. Insert Multiple Lines 2:54
5. F4 Absolut Reference 3:35
6. Difference Between Lists 4:20
7. Data Entry Limits 5:13
8. Trend Line in Charts 6:16
9. Ctrl-Tab 7:02
10. Split/Combine Names 7:21
11. PROPER() Function 9:27
12. Mean, Median, Mode 9:52
13. PMT() Function 10:49
14. COUNTBLANK() Function 12:23
15. Date/Time Shortcut 12:47