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)

[@smashleighmarie]

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. kzbin.info/www/bejne/oYemkIyZgZqCmLc It shows which app to use when and how. Practical and authoritative guidance. Doc.

[@smashleighmarie]

@@efficiency365 thanks for the rec!

[@dianekmk]

Same here!

[@altruologist]

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.

[@charudattakulkarni9799]

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.

[@martymcdonald3316]

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 - kzbin.info/www/bejne/rH2poYqMm7qZh5o Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Word Tables Best Practices - The ultimate guide - kzbin.info/www/bejne/q5audHuug7qCoaM Cheers. Doc.

[@Wasaia]

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 - kzbin.info/www/bejne/rH2poYqMm7qZh5o Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Word Tables Best Practices - The ultimate guide - kzbin.info/www/bejne/q5audHuug7qCoaM Cheers. Doc.

[@suresh1957]

Another extremely useful video from the maestro ! Tusen takk !

[@efficiency365]

Thanks @suresh1957 I also create conceptual and thought provoking videos. Check these out: Is efficiency dangerous? kzbin.info/www/bejne/iqGWm2CLesirgqM The Efficient Mindset. NOT Basic or Advanced - kzbin.info/www/bejne/lZzThZqbd7CImc0 How to manage ignorance? Learn to learn - kzbin.info/www/bejne/iKS2e3eMg6hge9E Don't buy Microsoft Office 365 - unless Podcast - kzbin.info/www/bejne/sJPagoiBp6-Spsk Do let me know your feedback. Cheers Doc

[@MoTechConsulting]

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 - kzbin.info/www/bejne/rH2poYqMm7qZh5o Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Word Tables Best Practices - The ultimate guide - kzbin.info/www/bejne/q5audHuug7qCoaM Cheers. Doc.

[@canirmalchoudhary8173]

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.

[@maheshshandilya8215]

Love your videos. Thanks very much!

[@efficiency365]

Thanks @maheshshandilya8215 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzbin.info/www/bejne/qKWnnYKIgdKdoqc Excel Green Marks - Error Checking - Best Practices - kzbin.info/www/bejne/jpavpZ-wmZ6fiLs Excel Best Practices - Part 1 of 3 - Data Management - kzbin.info/www/bejne/qKPCYpuXa8xposU Excel Best Practices - Part 2 of 3 - Formulas - kzbin.info/www/bejne/oavCq3Ssgq6Bd80 Excel Best Practices - Part 3 of 3 - Analytics - kzbin.info/www/bejne/gH-1ZqyulLWaaqM 10 Excel Settings You Must CHANGE! - kzbin.info/www/bejne/rInVo4uagN59fM0 Automatic data clean up with Excel Flash Fill - kzbin.info/www/bejne/hGTTkKuVob2HlcU Instant Excel Audit, Comparison and Analysis - Inquire - kzbin.info/www/bejne/mXXHp4iQrbSIn9U Six powerful Excel Navigation Shortcuts - kzbin.info/www/bejne/mIOQqoCYfLWka5I Handle millions of rows in Excel - Slow to fast - kzbin.info/www/bejne/b2TLaKWIqLF5bbs Convert crosstab to tabular - Unpivot - Excel Power Query - kzbin.info/www/bejne/o4XXgKeQfZKhhK8 Cheers. Doc

[@luisevidal]

Great video. Never knew O365 had these features. Thanks!

[@efficiency365]

Thanks @luisevidal. Check out my other best practices videos as well. Efficient Tasks Management - kzbin.info/www/bejne/rH2poYqMm7qZh5o Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Word Tables Best Practices - The ultimate guide - kzbin.info/www/bejne/q5audHuug7qCoaM Cheers. Doc.

[@gymthecarpenter]

Great ideas! Thank you.

[@efficiency365]

Thanks David Gragg. Check out my other best practices videos as well. Efficient Tasks Management - kzbin.info/www/bejne/rH2poYqMm7qZh5o Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Word Tables Best Practices - The ultimate guide - kzbin.info/www/bejne/q5audHuug7qCoaM Cheers. Doc.

[@AndreasGruber-ge3mz]

Great stuff, thanks!

[@efficiency365]

Thanks Andreas - just reached 40k subscribers. Appreciate your support. Do share these within your network.

[@Gajula78]

your description and the way you explain , i liked and keep following your

[@efficiency365]

Thanks 🙏

[@TinaDerby01]

Love this! I need to get into the course :)

[@efficiency365]

Thanks @TinaDerby01. Check out my other best practices videos as well. Efficient Tasks Management - kzbin.info/www/bejne/rH2poYqMm7qZh5o Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Word Tables Best Practices - The ultimate guide - kzbin.info/www/bejne/q5audHuug7qCoaM Cheers. Doc.

[@cradleofrelaxation6473]

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. kzbin.info/www/bejne/oYemkIyZgZqCmLc It shows which app to use when and how. Practical and authoritative guidance. Doc.

[@vijayarjunwadkar]

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!

[@pheasantknoll]

you have the best office 365 content!

[@efficiency365]

Thanks pheasantknoll. Check out my other best practices videos as well. Efficient Tasks Management - kzbin.info/www/bejne/rH2poYqMm7qZh5o Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Word Tables Best Practices - The ultimate guide - kzbin.info/www/bejne/q5audHuug7qCoaM Cheers. Doc.

[@CARohanAgarwal]

Waao learnt something new in this. Thank you.

[@efficiency365]

Thanks @marwadiseth5299. Check out my other best practices videos as well. Efficient Tasks Management - kzbin.info/www/bejne/rH2poYqMm7qZh5o Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs OneDrive Best Practices kzbin.info/www/bejne/emi9o5mmnbxnrNE Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Word Tables Best Practices - The ultimate guide - kzbin.info/www/bejne/q5audHuug7qCoaM Cheers. Doc.

[@hastingsbnsfnscalemodeler8594]

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. kzbin.info/www/bejne/oYemkIyZgZqCmLc It shows which app to use when and how. Practical and authoritative guidance. Doc.

[@slide6shottie4]

thanks for sharing!

[@efficiency365]

Thanks Jeffy. Check out my other best practices videos as well. Efficient Tasks Management - kzbin.info/www/bejne/rH2poYqMm7qZh5o Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Word Tables Best Practices - The ultimate guide - kzbin.info/www/bejne/q5audHuug7qCoaM Cheers. Doc.

[@malchicken]

Thanks!

[@efficiency365]

Wow. Thanks for the Super Thanks. You may like my Office 365 Masterclass where I cover all of the 27 included apps. kzbin.info/www/bejne/oYemkIyZgZqCmLc It shows which app to use when and how. Practical and authoritative guidance. Doc.

[@cossack4930]

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. kzbin.info/www/bejne/oYemkIyZgZqCmLc It shows which app to use when and how. Practical and authoritative guidance. Doc.

[@brendamartinezgomez2297]

thanks

[@efficiency365]

Thanks Brenda Martinez Gomez. Check out my other best practices videos as well. Efficient Tasks Management - kzbin.info/www/bejne/rH2poYqMm7qZh5o Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Word Tables Best Practices - The ultimate guide - kzbin.info/www/bejne/q5audHuug7qCoaM Cheers. Doc.

[@jitendrachaturvedi8308]

Good

[@efficiency365]

Thanks @jitendrachaturvedi8308 Check out my other best practices videos as well. Efficient Tasks Management 2024 - kzbin.info/www/bejne/envGqYOqqpKlmck Microsoft Teams Meetings - 16 Best Practices - kzbin.info/www/bejne/omSlp6RjfpWbr5Y Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs OneDrive Best Practices Part 1 - kzbin.info/www/bejne/emi9o5mmnbxnrNE Part 2 - kzbin.info/www/bejne/pHfbZ4yHrchgmJY Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Cheers. Doc.

[@pulkitsharma9616]

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.

[@tumblingrosesstudio]

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 - kzbin.info/www/bejne/rH2poYqMm7qZh5o Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Word Tables Best Practices - The ultimate guide - kzbin.info/www/bejne/q5audHuug7qCoaM Cheers. Doc.