Top 15 Advanced Excel 2016 Tips and Tricks

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.

Contents 0:00
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

#seletraining #excel #tipsandtricks

[ashishtaparia]

One of the best videos I have come across. Many thanks. No high pitch... No extra tones... Just a very calm, relaxed and professional way of explaining... Kudos!!!

[blabla-rgky]

I've always said to myself over the last decade that Excel is too powerful for what's needed on the market. Without exaggeration I can say that even if Excel will not be updated 100 years from now it will still be as powerful as today for most users.

Great clip. I'm gonna use some of these newly acquired tricks in my future work for sure

[joelyoffe]

By far the best instructor. Concise, articulate and easy to follow.

[CK]

Such a calm and relaxed style of talking, makes learning very theraputic 🙌👌

[lilityepranosyan]

Such an amazing tutorial to learn various useful tools that help you save your time while working with Excel. Thank you for your efforts.

[joetorres]

Wow, my respects!! In the first three min you explained more than I can handle. THANKS YOUR AWESOME

[UpExcel]

That calendar picker is a great tip. Excellent for spreadsheets being issued to less technical users 👍

[marleneruss]

Very impressive, easy to understand and blows me away to know there is so much more you can do with excel. Great work!

[philipcroome]

I've been working in Excel for years and learned lots of new stuff here. Well done!

[tabasco]

Very impressive list of truly advanced features. I have been using Excel for over 10 years. I only knew two of those tricks! Thanks for the very valuable and organized information.

[miawang]

This tutorial video really gets me " wow", thank you so

[decom]

Mind blown! I only thought I knew Excel. Great video, sir!

[pkoxbim]

Awesome! Very informative and well explained. Thank you.

[miamzd]

Very informative and well explained. Thanks for sharing your expertise.

[oedhelsetren]

Great video. Just proving you never know everything with Excel. A few of these tricks I already knew, but some of them just blew my mind. The Date picker was my favorite, just because I use dates a lot and most of the time it's about the day of the week rather than the date. So much easier to use a picker.

[Noelito]

You have made a lot of bosses a whole lot happier!!...because you have taught their teams how to provide better presented and analysed spreadsheets! Kudos to you sir!!

[nicwan]

They’re really useful, thanks so much for the teaching!

[neynav]

This was a great video. Great job. Thank you.

[justinsolberg]

Very practical for everyday and business use. Thanks!

[itazuranakissooo]

Thank you for your video sir, I feel so much more confident now! :)