This is a continuation of my Top 25 Excel 2016 Tips & Tricks. It includes more advanced features and some additional tricks to help you become more productive using Excel and Office 365.
Check out the original Excel 2016 video at https://youtu.be/EdnAeqxqdzM.
Another 15 Excel 2016 Tips 7 Tricks: https://youtu.be/L9SKTj2gevA
Contents:
1. Advanced Transpose 0:39
2. Calendar Picker 1:38
3. Slicers 3:05
4. Scenario Manager 4:22
5. CONVERT Function 7:09
6. Convert Currency Live 8:03
7. Hide Cells 10:14
8. Remove Blanks 10:48
9. People Graph 11:17
10. Track Changes 12:40
11. Advanced Filter 15:10
12. Analysis Tools 17:52
13. NETWORKDAYS Function 18:51
14. Embedding 19:38
15. Advanced Select 20:50