10 Excel Settings You Must CHANGE!

10 Excel Settings You Must CHANGE! | Efficiency 365

Рет қаралды 3,985

Күн бұрын

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
Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - s.efficiency365.com/ptyt
Excel to Power BI - swiy.io/uxlpbi
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)

Пікірлер: 34

@charudattakulkarni9799 6 ай бұрын

Extremely useful Video.

@ambkumar 3 ай бұрын

!! Appreciate the wisdom share Nitin !! 💫👏

@efficiency365 2 ай бұрын

Thanks @ambkumar Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzfaq.info/get/bejne/qNp0n7KDsdPOnHk.html Excel Green Marks - Error Checking - Best Practices - kzfaq.info/get/bejne/jst8p8-ryZ_Qgo0.html Excel Best Practices - Part 1 of 3 - Data Management - kzfaq.info/get/bejne/qNiPZMuSm82anJc.html Excel Best Practices - Part 2 of 3 - Formulas - kzfaq.info/get/bejne/oeCPraSnsq-ycZ8.html Excel Best Practices - Part 3 of 3 - Analytics - kzfaq.info/get/bejne/gLSCaNypxLbLZHU.html 10 Excel Settings You Must CHANGE! - kzfaq.info/get/bejne/rL6ipbuVsN-udp8.html Automatic data clean up with Excel Flash Fill - kzfaq.info/get/bejne/hJmgktuQ0b64j5c.html Instant Excel Audit, Comparison and Analysis - Inquire - kzfaq.info/get/bejne/maqUqbiL3bW5mac.html Six powerful Excel Navigation Shortcuts - kzfaq.info/get/bejne/mLhdrLCTrLbVZWQ.html Handle millions of rows in Excel - Slow to fast - kzfaq.info/get/bejne/b5mYatWD2LKqZ40.html Convert crosstab to tabular - Unpivot - Excel Power Query - kzfaq.info/get/bejne/o7qkgteLrZPSfoE.html Cheers. Doc

@Sisira_wijesinghe Жыл бұрын

Thank you Doc. you made my carrier! thanks for sharing knowledge.

@efficiency365 Жыл бұрын

Thanks Sisira Wijesinghe. Check out my other best practices videos as well. Efficient Tasks Management - kzfaq.info/get/bejne/rLJ2o7qHy7vKgWw.html Microsoft Teams - 15 Best Practices - kzfaq.info/get/bejne/jZ6FmduQ39SvqH0.html Smart and Effective Email - 5 powerful ways - kzfaq.info/get/bejne/bLR1ebZ-1q7LgXk.html Outlook Calendar Best Practices : Part 1 - kzfaq.info/get/bejne/feCjhNGWyNClgaM.html and Part 2 - kzfaq.info/get/bejne/pseUfqtp3tmZc6c.html OneNote - Best Practices - kzfaq.info/get/bejne/o5NkdLxiyLPNaKc.html Microsoft 365 Best Practices - kzfaq.info/get/bejne/obxzkryUsZuzkok.html Word Tables Best Practices - The ultimate guide - kzfaq.info/get/bejne/q8t7dqups7uzm3U.html Cheers. Doc.

@cbaide100 Жыл бұрын

Great video.! Thanks for sharing your knowledge

@efficiency365 Жыл бұрын

Thanks Carlos Baide. Check out my other best practices videos as well. Efficient Tasks Management - kzfaq.info/get/bejne/rLJ2o7qHy7vKgWw.html Microsoft Teams - 15 Best Practices - kzfaq.info/get/bejne/jZ6FmduQ39SvqH0.html Smart and Effective Email - 5 powerful ways - kzfaq.info/get/bejne/bLR1ebZ-1q7LgXk.html Outlook Calendar Best Practices : Part 1 - kzfaq.info/get/bejne/feCjhNGWyNClgaM.html and Part 2 - kzfaq.info/get/bejne/pseUfqtp3tmZc6c.html OneNote - Best Practices - kzfaq.info/get/bejne/o5NkdLxiyLPNaKc.html Microsoft 365 Best Practices - kzfaq.info/get/bejne/obxzkryUsZuzkok.html Word Tables Best Practices - The ultimate guide - kzfaq.info/get/bejne/q8t7dqups7uzm3U.html Cheers. Doc.

@brendamg7298 8 ай бұрын

Great video! Thanks for sharing your knowledge

@efficiency365 8 ай бұрын

Thanks @brendamg7298 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzfaq.info/get/bejne/qNp0n7KDsdPOnHk.html Excel Green Marks - Error Checking - Best Practices - kzfaq.info/get/bejne/jst8p8-ryZ_Qgo0.html Excel Best Practices - Part 1 of 3 - Data Management - kzfaq.info/get/bejne/qNiPZMuSm82anJc.html Excel Best Practices - Part 2 of 3 - Formulas - kzfaq.info/get/bejne/oeCPraSnsq-ycZ8.html Excel Best Practices - Part 3 of 3 - Analytics - kzfaq.info/get/bejne/gLSCaNypxLbLZHU.html 10 Excel Settings You Must CHANGE! - kzfaq.info/get/bejne/rL6ipbuVsN-udp8.html Automatic data clean up with Excel Flash Fill - kzfaq.info/get/bejne/hJmgktuQ0b64j5c.html Instant Excel Audit, Comparison and Analysis - Inquire - kzfaq.info/get/bejne/maqUqbiL3bW5mac.html Six powerful Excel Navigation Shortcuts - kzfaq.info/get/bejne/mLhdrLCTrLbVZWQ.html Handle millions of rows in Excel - Slow to fast - kzfaq.info/get/bejne/b5mYatWD2LKqZ40.html Convert crosstab to tabular - Unpivot - Excel Power Query - kzfaq.info/get/bejne/o7qkgteLrZPSfoE.html Cheers. Doc

@dr.shwetabairagi2892 6 ай бұрын

Thanks for sharing your knowledge

@efficiency365 6 ай бұрын

Thanks @dr.shwetabairagi2892 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzfaq.info/get/bejne/qNp0n7KDsdPOnHk.html Excel Green Marks - Error Checking - Best Practices - kzfaq.info/get/bejne/jst8p8-ryZ_Qgo0.html Excel Best Practices - Part 1 of 3 - Data Management - kzfaq.info/get/bejne/qNiPZMuSm82anJc.html Excel Best Practices - Part 2 of 3 - Formulas - kzfaq.info/get/bejne/oeCPraSnsq-ycZ8.html Excel Best Practices - Part 3 of 3 - Analytics - kzfaq.info/get/bejne/gLSCaNypxLbLZHU.html 10 Excel Settings You Must CHANGE! - kzfaq.info/get/bejne/rL6ipbuVsN-udp8.html Automatic data clean up with Excel Flash Fill - kzfaq.info/get/bejne/hJmgktuQ0b64j5c.html Instant Excel Audit, Comparison and Analysis - Inquire - kzfaq.info/get/bejne/maqUqbiL3bW5mac.html Six powerful Excel Navigation Shortcuts - kzfaq.info/get/bejne/mLhdrLCTrLbVZWQ.html Handle millions of rows in Excel - Slow to fast - kzfaq.info/get/bejne/b5mYatWD2LKqZ40.html Convert crosstab to tabular - Unpivot - Excel Power Query - kzfaq.info/get/bejne/o7qkgteLrZPSfoE.html Cheers. Doc

@INDERJEET4321 Жыл бұрын

As always great video

@efficiency365 Жыл бұрын

Thanks INDERJEET4321 for the feedback. You may also like these Word related videos: Word top 10 settings - kzfaq.info/get/bejne/lZ6iatl_19fMY2g.html Word Tables - 8 ways to create: kzfaq.info/get/bejne/jpN3a8WLu6mrcp8.html Word Tables - 13 problems solved: kzfaq.info/get/bejne/r5t5lc-h27TDeps.html Word Styles - kzfaq.info/get/bejne/bcyPlLKY2NyvcWQ.html Handing long, complex word documents - kzfaq.info/get/bejne/b9CijK15tp29nYU.html Thanks.

@gowrisankarrao6529 Жыл бұрын

Loved it. You are rock star sir

@efficiency365 Жыл бұрын

Thanks gowri sankar rao. Watch Word Top 10 settings as well: kzfaq.info/get/bejne/lZ6iatl_19fMY2g.html Check out my other best practices videos as well. Efficient Tasks Management - kzfaq.info/get/bejne/rLJ2o7qHy7vKgWw.html Microsoft Teams - 15 Best Practices - kzfaq.info/get/bejne/jZ6FmduQ39SvqH0.html Smart and Effective Email - 5 powerful ways - kzfaq.info/get/bejne/bLR1ebZ-1q7LgXk.html Outlook Calendar Best Practices : Part 1 - kzfaq.info/get/bejne/feCjhNGWyNClgaM.html and Part 2 - kzfaq.info/get/bejne/pseUfqtp3tmZc6c.html OneNote - Best Practices - kzfaq.info/get/bejne/o5NkdLxiyLPNaKc.html Microsoft 365 Best Practices - kzfaq.info/get/bejne/obxzkryUsZuzkok.html Word Tables Best Practices - The ultimate guide - kzfaq.info/get/bejne/q8t7dqups7uzm3U.html Cheers. Doc.

@Muzammil-689 11 күн бұрын

Very Useful ThANK YOU

@efficiency365 11 күн бұрын

Thanks @Muzammil-689 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzfaq.info/get/bejne/qNp0n7KDsdPOnHk.html Excel Green Marks - Error Checking - Best Practices - kzfaq.info/get/bejne/jst8p8-ryZ_Qgo0.html Excel Best Practices - Part 1 of 3 - Data Management - kzfaq.info/get/bejne/qNiPZMuSm82anJc.html Excel Best Practices - Part 2 of 3 - Formulas - kzfaq.info/get/bejne/oeCPraSnsq-ycZ8.html Excel Best Practices - Part 3 of 3 - Analytics - kzfaq.info/get/bejne/gLSCaNypxLbLZHU.html 10 Excel Settings You Must CHANGE! - kzfaq.info/get/bejne/rL6ipbuVsN-udp8.html Automatic data clean up with Excel Flash Fill - kzfaq.info/get/bejne/hJmgktuQ0b64j5c.html Instant Excel Audit, Comparison and Analysis - Inquire - kzfaq.info/get/bejne/maqUqbiL3bW5mac.html Six powerful Excel Navigation Shortcuts - kzfaq.info/get/bejne/mLhdrLCTrLbVZWQ.html Handle millions of rows in Excel - Slow to fast - kzfaq.info/get/bejne/b5mYatWD2LKqZ40.html Convert crosstab to tabular - Unpivot - Excel Power Query - kzfaq.info/get/bejne/o7qkgteLrZPSfoE.html Cheers. Doc

@maneeshpanditrao2555 Жыл бұрын

Very useful tip...will use in my day-to-day😀 work

@efficiency365 Жыл бұрын

Thanks. Have you seen the Word Top 10 Settings video? kzfaq.info/get/bejne/lZ6iatl_19fMY2g.html

@Vijay.Agarwal.1234 Жыл бұрын

V. Good tips Dear Dr.

@efficiency365 Жыл бұрын

Thanks Vijay.. Let me know any items I missed but you find them as important settings.

@canirmalchoudhary8173 Жыл бұрын

Formula error with different color and blank cell formula error are useful feature.

@efficiency365 Жыл бұрын

Critical thing - that is often ignored.

@studypremium7656 Жыл бұрын

Hello sir,,how are you Sir,, pls make a video for note taking ,,i am using office 365

@efficiency365 Жыл бұрын

Hi Already have the video - OneNote best practices: kzfaq.info/get/bejne/o5NkdLxiyLPNaKc.html

@homey.channel 8 ай бұрын

Sir I don't have analyse data😢in mine what to do! How to get it

@efficiency365 8 ай бұрын

Thanks @homey.channel Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzfaq.info/get/bejne/qNp0n7KDsdPOnHk.html Excel Green Marks - Error Checking - Best Practices - kzfaq.info/get/bejne/jst8p8-ryZ_Qgo0.html Excel Best Practices - Part 1 of 3 - Data Management - kzfaq.info/get/bejne/qNiPZMuSm82anJc.html Excel Best Practices - Part 2 of 3 - Formulas - kzfaq.info/get/bejne/oeCPraSnsq-ycZ8.html Excel Best Practices - Part 3 of 3 - Analytics - kzfaq.info/get/bejne/gLSCaNypxLbLZHU.html 10 Excel Settings You Must CHANGE! - kzfaq.info/get/bejne/rL6ipbuVsN-udp8.html Automatic data clean up with Excel Flash Fill - kzfaq.info/get/bejne/hJmgktuQ0b64j5c.html Instant Excel Audit, Comparison and Analysis - Inquire - kzfaq.info/get/bejne/maqUqbiL3bW5mac.html Six powerful Excel Navigation Shortcuts - kzfaq.info/get/bejne/mLhdrLCTrLbVZWQ.html Handle millions of rows in Excel - Slow to fast - kzfaq.info/get/bejne/b5mYatWD2LKqZ40.html Convert crosstab to tabular - Unpivot - Excel Power Query - kzfaq.info/get/bejne/o7qkgteLrZPSfoE.html Cheers. Doc

@CARohanAgarwal 9 ай бұрын

I don't have option of opening files in office desktop apps. I am using MS 2019 which is installed on my laptop by default and also has O365 subscription. But I chose to use MS 2019 as it is lifetime free. Is this option available anywhere in MS 2019.?

@efficiency365 9 ай бұрын

You need Office 365 version of Office. Go to Office.com and check if you have the option of Installing Office from there. If not you have O365 which only gives you browser versions of Office.

@CARohanAgarwal 9 ай бұрын

@@efficiency365 I have O365 in my office, there i changed it but still it's not opening on desktop. Also sir, is there anyway where we can use ctrl+[ in online sheet for going to dependent?. In the desktop version it works smoothly but when working online can't go to a dependent cell,

@efficiency365 9 ай бұрын

O365 comes in various editions. Yours will be Business Basic - If you have Business Premium, you will get the latest desktop version. Some features will not come to the 2019, 2021 versions. Excel on web does not have Trace Dependents / Precedents. So the shortcut will not work.

@safwanchaklasiya 10 ай бұрын

Wonderful video, in one of my excel facing proflem of formula bar value different from cell value, can you please share your email id to send that excel sheet. Thanks in advance.

@efficiency365 10 ай бұрын

Sure. asknitin@maxoffice.co

@safwanchaklasiya 10 ай бұрын

@@efficiency365 Given email ID not working, please share working email ID