Top 15 Advanced Excel 2016 Tips and Tricks
Vložit
- čas přidán 8. 07. 2024
- 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 • Top 25 Excel 2016 Tips... .
Another 15 Excel 2016 Tips 7 Tricks: • Another 15 Excel 2016 ...
Support me with your Amazon purchases, click here: amzn.to/2Kxp533
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 - Věda a technologie
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!!!
By far the best instructor. Concise, articulate and easy to follow.
Wow , my respects!! In the first three min you explained more than I can handle. THANKS YOUR AWESOME
Such an amazing tutorial to learn various useful tools that help you save your time while working with Excel. Thank you for your efforts.
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
Such a calm and relaxed style of talking, makes learning very theraputic 🙌👌
Haha sometimes it's hard to pay attention with relaxed tone of voice + not the most exciting content. It's only a special group of people that like watching excel videos :)
I've been working in Excel for years and learned lots of new stuff here. Well done!
Very impressive, easy to understand and blows me away to know there is so much more you can do with excel. Great work!
That calendar picker is a great tip. Excellent for spreadsheets being issued to less technical users 👍
Very helpful video! Thank you!
Awesome! Very informative and well explained. Thank you.
Mind blown! I only thought I knew Excel. Great video, sir!
Great stuff
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.
That was truly a comprehensive tutorial. Nice job !
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.
This was a great video. Great job. Thank you.
This tutorial video really gets me " wow", thank you so much!!!!!!
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!!
Thanks
These, and the initial Tips & Tricks, make our assignment work much quicker. Thank you!
Very well done! Learning valuable Excel skills and ASMR, all in one.
*One Of The Best Video Of Excel I Have Ever Seen Sir Great Value Addition!!!!* THANK YOU SO MUCH FOR SHARING!!!
They’re really useful, thanks so much for the teaching!
Thanks for some few new tricks. Keep them coming, so we'll keep on enjoying
This is great! Thank you!
Jeepers Creepers! This is a gold mind of Excel Tips and Tricks! I teach Excel at a local College, and this has opened a whole new world of instruction. Well worth exploring and adding to my teaching repertoire. Thank you!
This is excellent! Thank you so much. Keep the videos coming. These are the best I have seen on CZcams.
Thank you for your video sir, I feel so much more confident now! :)
This was one of the best videos, I love this guy.
Jip! I think everyone learned atleast something from this list!
nice.. really amazing feature. I truly enjoy this video... Thank you so much
Everyone of your teaching is professionally done! THANKS!!!!!
One of the best excel videos. Important for any user. Thank you.
You are welcome!
These are so informative. Thank you for the video. **Sobs looking at the advance select feature and realizing how many hours were wasted manually editing**
Very informative and well explained. Thanks for sharing your expertise.
Very nice job of explaining these tools! Thanks! I hope this reference will continue to be available as I am sure I will watch it over and over and over....
Thank you, again! Hope to have more select advanced excel tops&tricks very soon.
Great video. Crisp n clear. 💐
Thanks for your great video.
Thankful for giving complete insight of few excel shortcuts, tools and functions can be used.
Thank you so much and I learned a Lot today in Excel . Amazing Keep them coming .
The narrator is most informative with the step by step displays and tone of voice. Made me want to stay and re-watch video to absorb his brilliant presented processes. I am definitely a follower. Thanks for the education.
Thanks
Wow. Absolutely brilliant. Great pace and clear instructions, excellent video presentation, and genuinely useful stuff. Superb. Subscribed and shared
Many thanks sir for the great knowledge. Very informative. Keep doing good!!!!
Hey man...thank you a ton for posting this video... It was awesome..
Very practical for everyday and business use. Thanks!
I remember using the *Shift+Ctrl+Enter* that was covered in the first tip with some other function as well. Can't seem to quite remember what the function was but it's definitely something I'll brush up on more. Thanks for sharing your wisdom :)
Thank you Sele for this video. Thoroughly enjoyed it!
Awesome! Very specific and easy understanding. Thanks
I was surprised by how good this video was. Often, the tips are pretty obvious but these were very helpful. Many thanks!
I made sure this was helpful tips. It is annoying when people repeat the common sense stuff just to make a video. I purposely choose topics that add value. Thanks
٣ ا ت
Thank you. I came across this by wondering typing in a question in my browser and it is exactly what I was looking for.
Zug egg very day FCC
Play Group a
Thorough and clearly explained. Thanks, Sir!
Brilliant teacher! Thank you so much! Subscribed.
Learned a few good trick, thanks :)
The tips were very good.
Thanks for all of your videos sir!Very well explained and easy to understand..
Thanks so much. You explained it so well. I'm gonna try this out.
this one is direct to the point
Wow this is very advanced omg I am not ready for this
They're all extremely helpful! Thank you
Easy To understand. Clear directions & speaking! THX
Very good explained Thumps up
Thought I knew all about Excel, this just proved me wrong, really worth watching.
Thank you for sharing your tips with us ! Appreciated
Excellent!
Cakeep
You are really amazing sir... Keep going.... Very useful... Love ur videos😍😍😍
Thank you so much, yi did so well am so exited to learn ..please keep the tutorial going on and helping the community ..thank you God Bless You
One of the most useful and well explained videos I have ever seen
This guy is a life and money saver.
A very good way to explain tips and tricks of excel😇😇😇
Two thumbs up!
Thank you! Advanced filters was super.
Some great tips here! Thanks for sharing
Helps me alot. Thank you so very much..God bless you
Cheers for the video content! Sorry for the intrusion, I am interested in your initial thoughts. Have you considered - Weydaniel Organized Dominator (just google it)? It is a smashing one off guide for getting 7000 plus project management and business templates without the hard work. Ive heard some unbelievable things about it and my cousin at last got astronomical success with it.
Excellent professional method of teaching , Your Message was so clear. Respect!
Thanks so much. This information is very helpful and presented in a way that I can follow, learn, and utilize everyday at work.
Thanks so much. You explained it so well. I'm gonna try this out. Many thanks for the easy explanation.
it changed my life!
I have not finished the video yet but I can already tell that this is an awesome and very easy to follow tutorial. Very simple, informative and straight forward. Thank you so much for sharing.
Thank for sharing! This really helps.
You are simply amazing.
🌟 🌟 🌟 🌟 🌟
Thank you so much.
Awesome Video. Learned many things. Thanks a lot.
Great video, just one extra little trick I like to employ when using the Transpose array formula- as you mentioned- you need to select the size of the area to fill. I copy the original data, paste special using values and transpose. This gives me the area to select, so I highlight all of my pasted values and then type the formula as you outlined. Saves you a lot of trouble when you’ve got a lot of data to transpose.
Great tip. Thanks!
Awesome. Thanks Mr. Sele!!!
awesome!!! well done, concrete, fast and easy to understand.
Even though I have been using Excel for a *long* time and on an advanced level, you still managed to provide some neat tricks that I wish I had known years ago. Great job.
You had me at Live Transpose
Fantastic. Thank you!
Awsome video with some very useful tips for everyday use. Thank you so much. Keep up the good work.
Thanks you
Wow have been using a lot of Excel features, still most of those features are new to me
Yeah - definitely going to be using slicers more often!
I rarely use excel yet I am impressed by this video
Wow, love the tricks. Awesome video.
thanks you.
hi
Great video ! One little remark : On the scenario manager, you divide the year rate by 12%. Considering interest rate nature, you should not divide it by 12 but rather 6%^(1/12).
it's not arithmetic but geometric !
Good point!
Amazing Work! very helpful.
You Sir have just won a subscriber and his respect!
Great work, hope that you could make this series for Power BI.
Very well presentation, easy to grab up, thanks you so much for your generosity.
I can't find Microsoft Date & time picker in list? By the way I have Microsoft 365 Personal. Could you help?
The Date and Time picker does not work for 64bit versions of Excel. Here is some info on how to download if you have the 32bit and it is missing from the menus: www.ablebits.com/office-addins-blog/2016/10/12/insert-calendar-excel-datepicker-template/#Register-date-picker
In the video, it displayed this formula, while he pasted: @2:26 -----=EMBED("MsComCtl2.DTPicker.2","")
Date & Time picker is only available from Office 365 Excel and for the 32bit not the 64bit. It is not in all versions.
Excellent you have to see it looking forward to watch another videos
I really appreciate your work in bringing our excellence out in excel..thanks a lot