Hi Guys;
Excel Tips and Tricks #Part -2 Video – https://www.youtube.com/watch?v=eoHEFk6xavc&t=24s
The Top 15 tips and tricks for Excel 2016. Use these tips and tricks to improve your efficiency using Excel. I am sure you will discover some that you have not seen before and others that you have been using incorrectly. My personal favourite is #13. Become more productive using Excel at work, school and home.

Contents explained

1. Text to columns
2.Flash fill
3.live transpose
4.if error function
5.drop down list
6.show all formulas
7.format painter
8.copy sheet in different ways
9.Filtering
10. Ctrl+ Arrow keys
11. Quick analysis tool
12. Remove duplicates
13. usage of ‘ key
14. Paste special options
15. conditional formatting

Please Support our channel.