Top 10 Office Features which I use daily! | Efficiency 365
Ғылым және технология
In this video we are discussing 10 of my personal favourite Microsoft office 365 features which I use on a daily basis. This video does not focus on any particular software.
#efficiency365 #office365 #top10
Contents
00:00 - Introduction (the problem)
00:12 - Convert text to tables in word
01:23 - Link meeting audio to notes in OneNote
02:43 - Generate random data in Excel
05:22 - Layout reset in Powerpoint
06:43 - Delay delivery in Outlook
07:45 - Checklist in OneNote
08:57 - Compare formatting in Word
10:07 - Convert to formulas in Excel
13:36 - Cameo in Powerpoint
15:30 - Insert images inside a cell in Excel
18:42 - Outro
Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster
s.efficiency365.com/bk
Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
hi.switchy.io/mms
Udemy Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - hi.switchy.io/22B1
Excel to Power BI - swiy.io/pivotsh
Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: efficiency365.com/blog
LinkedIn : / nitinparanjape
Twitter : / drnitinp
Production
--------------------
Music and Effects: elements.envato.com/
Created using Adobe Premiere: www.adobe.com/in/creativeclou...
AI based captions: videoindexer.ai (Microsoft service)
Пікірлер: 59
Love your content and have been sharing it with coworkers! Thanks for your hard work!
@efficiency365
Жыл бұрын
Thanks amd. You may like my Office 365 Masterclass where I cover all of the 27 included apps. kzread.info/dash/bejne/nYp3wbucfJi1krg.html It shows which app to use when and how. Practical and authoritative guidance. Doc.
@smashleighmarie
Жыл бұрын
@@efficiency365 thanks for the rec!
@dianekmk
Жыл бұрын
Same here!
Another extremely useful video from the maestro ! Tusen takk !
@efficiency365
7 ай бұрын
Thanks @suresh1957 I also create conceptual and thought provoking videos. Check these out: Is efficiency dangerous? kzread.info/dash/bejne/hqRnzI-OdcbefKQ.html The Efficient Mindset. NOT Basic or Advanced - kzread.info/dash/bejne/kZ-ktsmecq67k84.html How to manage ignorance? Learn to learn - kzread.info/dash/bejne/hKeHrKaPfqaTddI.html Don't buy Microsoft Office 365 - unless Podcast - kzread.info/dash/bejne/rJars7eEoq3FoMo.html Do let me know your feedback. Cheers Doc
Great video. Never knew O365 had these features. Thanks!
@efficiency365
Жыл бұрын
Thanks @luisevidal. Check out my other best practices videos as well. Efficient Tasks Management - kzread.info/dash/bejne/qIB60rmPlrjMgZs.html Microsoft Teams - 15 Best Practices - kzread.info/dash/bejne/iWyJyNqYqtGxqKw.html Smart and Effective Email - 5 powerful ways - kzread.info/dash/bejne/aIJ5qLWGoavNgag.html Outlook Calendar Best Practices : Part 1 - kzread.info/dash/bejne/ea6ns9Cek82ngdI.html and Part 2 - kzread.info/dash/bejne/opWYrapxqdabc9Y.html OneNote - Best Practices - kzread.info/dash/bejne/n2Foo7tqk7DPaNY.html Microsoft 365 Best Practices - kzread.info/dash/bejne/nYp3wbucfJi1krg.html Word Tables Best Practices - The ultimate guide - kzread.info/dash/bejne/p5l_paqxfri1m6Q.html Cheers. Doc.
I'm learning so much from you. You are my favorite Office-teacher ;-) Thank you!
@efficiency365
Жыл бұрын
Thanks Giorgo De Groof. Check out my other best practices videos as well. Efficient Tasks Management - kzread.info/dash/bejne/qIB60rmPlrjMgZs.html Microsoft Teams - 15 Best Practices - kzread.info/dash/bejne/iWyJyNqYqtGxqKw.html Smart and Effective Email - 5 powerful ways - kzread.info/dash/bejne/aIJ5qLWGoavNgag.html Outlook Calendar Best Practices : Part 1 - kzread.info/dash/bejne/ea6ns9Cek82ngdI.html and Part 2 - kzread.info/dash/bejne/opWYrapxqdabc9Y.html OneNote - Best Practices - kzread.info/dash/bejne/n2Foo7tqk7DPaNY.html Microsoft 365 Best Practices - kzread.info/dash/bejne/nYp3wbucfJi1krg.html Word Tables Best Practices - The ultimate guide - kzread.info/dash/bejne/p5l_paqxfri1m6Q.html Cheers. Doc.
Wow! Another brilliant boost of productivity. Thanks so much Dr. Nitin
@efficiency365
Жыл бұрын
Thanks Brian. I was reluctant to create this video because I thought, the features that I like may not be relevant to others. But it looks like everyone is able to relate and appreciate. Do suggest topics / features that can improve efficiency for majority of users. Cheers. Doc.
Thank you Dr Nitin. Very helpful. The =Image was something new for me. Almost made my jaw drop. Thank you for putting this content together.
@efficiency365
Жыл бұрын
Thanks @MoTechConsulting. Check out my other best practices videos as well. Efficient Tasks Management - kzread.info/dash/bejne/qIB60rmPlrjMgZs.html Microsoft Teams - 15 Best Practices - kzread.info/dash/bejne/iWyJyNqYqtGxqKw.html Smart and Effective Email - 5 powerful ways - kzread.info/dash/bejne/aIJ5qLWGoavNgag.html Outlook Calendar Best Practices : Part 1 - kzread.info/dash/bejne/ea6ns9Cek82ngdI.html and Part 2 - kzread.info/dash/bejne/opWYrapxqdabc9Y.html OneNote - Best Practices - kzread.info/dash/bejne/n2Foo7tqk7DPaNY.html Microsoft 365 Best Practices - kzread.info/dash/bejne/nYp3wbucfJi1krg.html Word Tables Best Practices - The ultimate guide - kzread.info/dash/bejne/p5l_paqxfri1m6Q.html Cheers. Doc.
Excellent Video. We are fond of your direct delivery, concise contents, extraordinary examples , DIY Demos.... Salute to and your contribution.
@efficiency365
Жыл бұрын
Just trying to make people realize the power of using things the right way. Still a long way to go.
Great ideas and tips! I’m learning more from you each time I watch.
@efficiency365
Жыл бұрын
Thanks Marty McDonald. Check out my other best practices videos as well. Efficient Tasks Management - kzread.info/dash/bejne/qIB60rmPlrjMgZs.html Microsoft Teams - 15 Best Practices - kzread.info/dash/bejne/iWyJyNqYqtGxqKw.html Smart and Effective Email - 5 powerful ways - kzread.info/dash/bejne/aIJ5qLWGoavNgag.html Outlook Calendar Best Practices : Part 1 - kzread.info/dash/bejne/ea6ns9Cek82ngdI.html and Part 2 - kzread.info/dash/bejne/opWYrapxqdabc9Y.html OneNote - Best Practices - kzread.info/dash/bejne/n2Foo7tqk7DPaNY.html Microsoft 365 Best Practices - kzread.info/dash/bejne/nYp3wbucfJi1krg.html Word Tables Best Practices - The ultimate guide - kzread.info/dash/bejne/p5l_paqxfri1m6Q.html Cheers. Doc.
Great ideas! Thank you.
@efficiency365
Жыл бұрын
Thanks David Gragg. Check out my other best practices videos as well. Efficient Tasks Management - kzread.info/dash/bejne/qIB60rmPlrjMgZs.html Microsoft Teams - 15 Best Practices - kzread.info/dash/bejne/iWyJyNqYqtGxqKw.html Smart and Effective Email - 5 powerful ways - kzread.info/dash/bejne/aIJ5qLWGoavNgag.html Outlook Calendar Best Practices : Part 1 - kzread.info/dash/bejne/ea6ns9Cek82ngdI.html and Part 2 - kzread.info/dash/bejne/opWYrapxqdabc9Y.html OneNote - Best Practices - kzread.info/dash/bejne/n2Foo7tqk7DPaNY.html Microsoft 365 Best Practices - kzread.info/dash/bejne/nYp3wbucfJi1krg.html Word Tables Best Practices - The ultimate guide - kzread.info/dash/bejne/p5l_paqxfri1m6Q.html Cheers. Doc.
Love this! I need to get into the course :)
@efficiency365
Жыл бұрын
Thanks @TinaDerby01. Check out my other best practices videos as well. Efficient Tasks Management - kzread.info/dash/bejne/qIB60rmPlrjMgZs.html Microsoft Teams - 15 Best Practices - kzread.info/dash/bejne/iWyJyNqYqtGxqKw.html Smart and Effective Email - 5 powerful ways - kzread.info/dash/bejne/aIJ5qLWGoavNgag.html Outlook Calendar Best Practices : Part 1 - kzread.info/dash/bejne/ea6ns9Cek82ngdI.html and Part 2 - kzread.info/dash/bejne/opWYrapxqdabc9Y.html OneNote - Best Practices - kzread.info/dash/bejne/n2Foo7tqk7DPaNY.html Microsoft 365 Best Practices - kzread.info/dash/bejne/nYp3wbucfJi1krg.html Word Tables Best Practices - The ultimate guide - kzread.info/dash/bejne/p5l_paqxfri1m6Q.html Cheers. Doc.
Love your videos. Thanks very much!
@efficiency365
10 ай бұрын
Thanks @maheshshandilya8215 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzread.info/dash/bejne/pKh4zrGLfNDQnKg.html Excel Green Marks - Error Checking - Best Practices - kzread.info/dash/bejne/ipmA1s6zlJzSgrw.html Excel Best Practices - Part 1 of 3 - Data Management - kzread.info/dash/bejne/pKaTk8qaZsqcnMY.html Excel Best Practices - Part 2 of 3 - Formulas - kzread.info/dash/bejne/na6T3KOvfay0cc4.html Excel Best Practices - Part 3 of 3 - Analytics - kzread.info/dash/bejne/fIKGl9uxj7PNZKQ.html 10 Excel Settings You Must CHANGE! - kzread.info/dash/bejne/qIym1Lqde9ywds4.html Automatic data clean up with Excel Flash Fill - kzread.info/dash/bejne/gGekwdqYnLu6j8Y.html Instant Excel Audit, Comparison and Analysis - Inquire - kzread.info/dash/bejne/lXiY2LeTqLK7mdY.html Six powerful Excel Navigation Shortcuts - kzread.info/dash/bejne/lIZh26-bd7PXZZM.html Handle millions of rows in Excel - Slow to fast - kzread.info/dash/bejne/a2ecmdSLo6-sZ7w.html Convert crosstab to tabular - Unpivot - Excel Power Query - kzread.info/dash/bejne/n4iosdaTeJDUfrA.html Cheers. Doc
This video is amazing, so many thing learned. I liked the data model pivot and converting to formula. Very few know this feature.
@efficiency365
Жыл бұрын
Yes. It is a great feature. It uses the OLAP cube which is anyway created as a part of Power Pivot. It is also a good idea to learn the CUBE... functions.
You’ve covered a lot in less than 20 min. Well done Sir.
@efficiency365
Жыл бұрын
Thanks. You may like my Office 365 Masterclass where I cover all of the 27 included apps. kzread.info/dash/bejne/nYp3wbucfJi1krg.html It shows which app to use when and how. Practical and authoritative guidance. Doc.
Great stuff, thanks!
@efficiency365
Жыл бұрын
Thanks Andreas - just reached 40k subscribers. Appreciate your support. Do share these within your network.
your description and the way you explain , i liked and keep following your
@efficiency365
Жыл бұрын
Thanks 🙏
Waao learnt something new in this. Thank you.
@efficiency365
11 ай бұрын
Thanks @marwadiseth5299. Check out my other best practices videos as well. Efficient Tasks Management - kzread.info/dash/bejne/qIB60rmPlrjMgZs.html Microsoft Teams - 15 Best Practices - kzread.info/dash/bejne/iWyJyNqYqtGxqKw.html OneDrive Best Practices kzread.info/dash/bejne/dmuO1MipmLqaptI.html Smart and Effective Email - 5 powerful ways - kzread.info/dash/bejne/aIJ5qLWGoavNgag.html Outlook Calendar Best Practices : Part 1 - kzread.info/dash/bejne/ea6ns9Cek82ngdI.html and Part 2 - kzread.info/dash/bejne/opWYrapxqdabc9Y.html OneNote - Best Practices - kzread.info/dash/bejne/n2Foo7tqk7DPaNY.html Microsoft 365 Best Practices - kzread.info/dash/bejne/nYp3wbucfJi1krg.html Word Tables Best Practices - The ultimate guide - kzread.info/dash/bejne/p5l_paqxfri1m6Q.html Cheers. Doc.
you have the best office 365 content!
@efficiency365
Жыл бұрын
Thanks pheasantknoll. Check out my other best practices videos as well. Efficient Tasks Management - kzread.info/dash/bejne/qIB60rmPlrjMgZs.html Microsoft Teams - 15 Best Practices - kzread.info/dash/bejne/iWyJyNqYqtGxqKw.html Smart and Effective Email - 5 powerful ways - kzread.info/dash/bejne/aIJ5qLWGoavNgag.html Outlook Calendar Best Practices : Part 1 - kzread.info/dash/bejne/ea6ns9Cek82ngdI.html and Part 2 - kzread.info/dash/bejne/opWYrapxqdabc9Y.html OneNote - Best Practices - kzread.info/dash/bejne/n2Foo7tqk7DPaNY.html Microsoft 365 Best Practices - kzread.info/dash/bejne/nYp3wbucfJi1krg.html Word Tables Best Practices - The ultimate guide - kzread.info/dash/bejne/p5l_paqxfri1m6Q.html Cheers. Doc.
Excellent Tips Dr. Nitin! Thank you! 🙂 Many were unknown to me!
@efficiency365
Жыл бұрын
Thanks Vijay. Lot more coming soon. Should I cover more complex topics? For example, Data Tables, Scenarios, Solver...
@vijayarjunwadkar
Жыл бұрын
@@efficiency365 Yes sir, please cover mentioned topics with real life examples. Thanks in Advance!
Just found you and subscribed. Great content, thanks.
@efficiency365
Жыл бұрын
Thanks Hastings BNSF N Scale Modeler. Check out my "Office 365 Masterclass" where I cover all of the 27 included apps. kzread.info/dash/bejne/nYp3wbucfJi1krg.html It shows which app to use when and how. Practical and authoritative guidance. Doc.
thanks for sharing!
@efficiency365
Жыл бұрын
Thanks Jeffy. Check out my other best practices videos as well. Efficient Tasks Management - kzread.info/dash/bejne/qIB60rmPlrjMgZs.html Microsoft Teams - 15 Best Practices - kzread.info/dash/bejne/iWyJyNqYqtGxqKw.html Smart and Effective Email - 5 powerful ways - kzread.info/dash/bejne/aIJ5qLWGoavNgag.html Outlook Calendar Best Practices : Part 1 - kzread.info/dash/bejne/ea6ns9Cek82ngdI.html and Part 2 - kzread.info/dash/bejne/opWYrapxqdabc9Y.html OneNote - Best Practices - kzread.info/dash/bejne/n2Foo7tqk7DPaNY.html Microsoft 365 Best Practices - kzread.info/dash/bejne/nYp3wbucfJi1krg.html Word Tables Best Practices - The ultimate guide - kzread.info/dash/bejne/p5l_paqxfri1m6Q.html Cheers. Doc.
Thank you for improving my 365 life
@efficiency365
Жыл бұрын
Thanks Cossack. You may like my Office 365 Masterclass where I cover all of the 27 included apps. kzread.info/dash/bejne/nYp3wbucfJi1krg.html It shows which app to use when and how. Practical and authoritative guidance. Doc.
Thanks!
@efficiency365
Жыл бұрын
Wow. Thanks for the Super Thanks. You may like my Office 365 Masterclass where I cover all of the 27 included apps. kzread.info/dash/bejne/nYp3wbucfJi1krg.html It shows which app to use when and how. Practical and authoritative guidance. Doc.
thanks
@efficiency365
Жыл бұрын
Thanks Brenda Martinez Gomez. Check out my other best practices videos as well. Efficient Tasks Management - kzread.info/dash/bejne/qIB60rmPlrjMgZs.html Microsoft Teams - 15 Best Practices - kzread.info/dash/bejne/iWyJyNqYqtGxqKw.html Smart and Effective Email - 5 powerful ways - kzread.info/dash/bejne/aIJ5qLWGoavNgag.html Outlook Calendar Best Practices : Part 1 - kzread.info/dash/bejne/ea6ns9Cek82ngdI.html and Part 2 - kzread.info/dash/bejne/opWYrapxqdabc9Y.html OneNote - Best Practices - kzread.info/dash/bejne/n2Foo7tqk7DPaNY.html Microsoft 365 Best Practices - kzread.info/dash/bejne/nYp3wbucfJi1krg.html Word Tables Best Practices - The ultimate guide - kzread.info/dash/bejne/p5l_paqxfri1m6Q.html Cheers. Doc.
Good
@efficiency365
2 ай бұрын
Thanks @jitendrachaturvedi8308 Check out my other best practices videos as well. Efficient Tasks Management 2024 - kzread.info/dash/bejne/dn6X2rKtpZDYk8o.html Microsoft Teams Meetings - 16 Best Practices - kzread.info/dash/bejne/nmd22NNmeZPOqZc.html Microsoft Teams - 15 Best Practices - kzread.info/dash/bejne/iWyJyNqYqtGxqKw.html OneDrive Best Practices Part 1 - kzread.info/dash/bejne/dmuO1MipmLqaptI.html Part 2 - kzread.info/dash/bejne/oHqsmLuKqMaTkpc.html Smart and Effective Email - 5 powerful ways - kzread.info/dash/bejne/aIJ5qLWGoavNgag.html Outlook Calendar Best Practices : Part 1 - kzread.info/dash/bejne/ea6ns9Cek82ngdI.html and Part 2 - kzread.info/dash/bejne/opWYrapxqdabc9Y.html OneNote - Best Practices - kzread.info/dash/bejne/n2Foo7tqk7DPaNY.html Microsoft 365 Best Practices - kzread.info/dash/bejne/nYp3wbucfJi1krg.html Cheers. Doc.
We need gentle Excel training for all levels, we'll pay!!
@efficiency365
Жыл бұрын
Thanks @newknowledgeomni. "Gentle" means simple and easy-to-follow pace with low information density per module? Check out my other best practices videos as well. Efficient Tasks Management - kzread.info/dash/bejne/qIB60rmPlrjMgZs.html Microsoft Teams - 15 Best Practices - kzread.info/dash/bejne/iWyJyNqYqtGxqKw.html Smart and Effective Email - 5 powerful ways - kzread.info/dash/bejne/aIJ5qLWGoavNgag.html Outlook Calendar Best Practices : Part 1 - kzread.info/dash/bejne/ea6ns9Cek82ngdI.html and Part 2 - kzread.info/dash/bejne/opWYrapxqdabc9Y.html OneNote - Best Practices - kzread.info/dash/bejne/n2Foo7tqk7DPaNY.html Microsoft 365 Best Practices - kzread.info/dash/bejne/nYp3wbucfJi1krg.html Word Tables Best Practices - The ultimate guide - kzread.info/dash/bejne/p5l_paqxfri1m6Q.html Cheers. Doc.
When I try to record the audio in the One note it does not record other person voice.
@efficiency365
Жыл бұрын
Are you trying to record a meeting?
@pulkitsharma9616
Жыл бұрын
@@efficiency365 Yes Sir , I am a new Joiner and being given training by Onshore team over Teams . I want to record that meeting so that I can see it afterwards also for reference. Thanks for your reply 🙂
@efficiency365
Жыл бұрын
Meeting app? Teams, Zoom, Google?
@pulkitsharma9616
Жыл бұрын
@@efficiency365 Microsoft Teams App .
@efficiency365
Жыл бұрын
Oh. Then it is easy. Just record the meetings. The recording goes to Stream automatically. Transcript is created automatically. If you don't see these options, talk to your IT team.