Thanks 😊. Selecting the precedents and data validation selection were new ^^.
@efficiency365
Жыл бұрын
Yes. At least for Precedents and Dependents, there is a direct menu (button in ribbon) available. For finding similar Conditional Formatting ( even on the same sheet), there is no such facility. Go To Special - Conditional Formats - Same is the ONLY way.
@rrrprogram8667
Ай бұрын
Great job.... Surely ur videos are underrated.... U deserve more.... Keep up the good work
@efficiency365
Ай бұрын
Thanks @rrrprogram8667 Yes. More is always good. Thanks. Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzitem.info/news/bejne/06p60oOIhZ-bn3o Excel Green Marks - Error Checking - Best Practices - kzitem.info/news/bejne/uZuC2qCwnWudhY4 Excel Best Practices - Part 1 of 3 - Data Management - kzitem.info/news/bejne/06iVl5yXb5lnn5g Excel Best Practices - Part 2 of 3 - Formulas - kzitem.info/news/bejne/zLCV4HWshnt_dKA Excel Best Practices - Part 3 of 3 - Analytics - kzitem.info/news/bejne/q4SIm62umIKYZ3Y 10 Excel Settings You Must CHANGE! - kzitem.info/news/bejne/146o2IyahKt7eaA Automatic data clean up with Excel Flash Fill - kzitem.info/news/bejne/r2mmxayVpYqFkpg Instant Excel Audit, Comparison and Analysis - Inquire - kzitem.info/news/bejne/xHqa3ImQsYGGnKg Six powerful Excel Navigation Shortcuts - kzitem.info/news/bejne/w4hj34GYgIKiaGU Handle millions of rows in Excel - Slow to fast - kzitem.info/news/bejne/mmmenaaIrH53ao4 Convert crosstab to tabular - Unpivot - Excel Power Query - kzitem.info/news/bejne/zoqqtaiQgV-fgYI Cheers. Doc
@user-cr8mf7my6u
8 ай бұрын
Thanks for sharing this Go to things 🎉
@efficiency365
8 ай бұрын
Thanks @user-cr8mf7my6u Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzitem.info/news/bejne/06p60oOIhZ-bn3o Excel Green Marks - Error Checking - Best Practices - kzitem.info/news/bejne/uZuC2qCwnWudhY4 Excel Best Practices - Part 1 of 3 - Data Management - kzitem.info/news/bejne/06iVl5yXb5lnn5g Excel Best Practices - Part 2 of 3 - Formulas - kzitem.info/news/bejne/zLCV4HWshnt_dKA Excel Best Practices - Part 3 of 3 - Analytics - kzitem.info/news/bejne/q4SIm62umIKYZ3Y 10 Excel Settings You Must CHANGE! - kzitem.info/news/bejne/146o2IyahKt7eaA Automatic data clean up with Excel Flash Fill - kzitem.info/news/bejne/r2mmxayVpYqFkpg Instant Excel Audit, Comparison and Analysis - Inquire - kzitem.info/news/bejne/xHqa3ImQsYGGnKg Six powerful Excel Navigation Shortcuts - kzitem.info/news/bejne/w4hj34GYgIKiaGU Handle millions of rows in Excel - Slow to fast - kzitem.info/news/bejne/mmmenaaIrH53ao4 Convert crosstab to tabular - Unpivot - Excel Power Query - kzitem.info/news/bejne/zoqqtaiQgV-fgYI Cheers. Doc
@rkrajhan0
Жыл бұрын
Dr. Thanks for showing us the hidden gems in excel
@efficiency365
Жыл бұрын
Thanks. See Word gems as well: Fast and efficient Navigation in Microsoft Word - Go to Headings Tables Pictures - kzitem.info/news/bejne/pJyw3nyBbp6Ea6w
@jkumar8590
Жыл бұрын
Eye opening Doc
@efficiency365
Жыл бұрын
Funda is simple. Every feature has a purpose. It should be our purpose to find it!
@NuU-yb2ty
11 ай бұрын
Thanks a lot, extremely useful!
@efficiency365
11 ай бұрын
Thanks @NuU-yb2ty Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzitem.info/news/bejne/06p60oOIhZ-bn3o Excel Green Marks - Error Checking - Best Practices - kzitem.info/news/bejne/uZuC2qCwnWudhY4 Excel Best Practices - Part 1 of 3 - Data Management - kzitem.info/news/bejne/06iVl5yXb5lnn5g Excel Best Practices - Part 2 of 3 - Formulas - kzitem.info/news/bejne/zLCV4HWshnt_dKA Excel Best Practices - Part 3 of 3 - Analytics - kzitem.info/news/bejne/q4SIm62umIKYZ3Y 10 Excel Settings You Must CHANGE! - kzitem.info/news/bejne/146o2IyahKt7eaA Automatic data clean up with Excel Flash Fill - kzitem.info/news/bejne/r2mmxayVpYqFkpg Instant Excel Audit, Comparison and Analysis - Inquire - kzitem.info/news/bejne/xHqa3ImQsYGGnKg Six powerful Excel Navigation Shortcuts - kzitem.info/news/bejne/w4hj34GYgIKiaGU Handle millions of rows in Excel - Slow to fast - kzitem.info/news/bejne/mmmenaaIrH53ao4 Convert crosstab to tabular - Unpivot - Excel Power Query - kzitem.info/news/bejne/zoqqtaiQgV-fgYI Cheers. Doc
@LotfyKozman
Жыл бұрын
Thanks for your big efforts
@efficiency365
Жыл бұрын
Dear Lofty Kozman Thanks for the feedback. Check out other Excel deep dive videos as well: Handle millions of rows in Excel - Fast Analysis - Data Model - kzitem.info/news/bejne/mmmenaaIrH53ao4 Create 3d Map with #excel l #Efficiency365 - kzitem.info/news/bejne/xYWOmJ2sh5ljoW0 Fast incremental Excel search using new array functions and VBA - kzitem.info/news/bejne/232ksJWVpKGJfqA
@aaiyshaunnisa7454
Жыл бұрын
Excellent
@efficiency365
Жыл бұрын
Thanks @aaiyshaunnisa7454 for the feedback. Explore more Excel, Power BI and Analytics videos on this channel kzitem.info/door/PL-UPeBWRvha2O2TF6vfVw4lfS4honS407 Check out my online courses Excel to Power BI s.efficiency365.com/upbi Pivot Tables s.efficiency365.com/mtyt Learn 130 essential efficiency best practices - read my latest book - s.efficiency365.com/bk Let me know if you want me to cover any specific topics as well. Cheers. Dr Nitin (doc) Paranjape.
@ankursharma6157
Жыл бұрын
Sir, I am at 13:56 . . already I have found this video very useful. Thank You!
@efficiency365
Жыл бұрын
Thanks Ankur Sharma for the feedback. Explore more Excel, Power BI and Analytics videos on this channel kzitem.info/door/PL-UPeBWRvha2O2TF6vfVw4lfS4honS407 Check out my online courses Excel to Power BI s.efficiency365.com/upbi Pivot Tables s.efficiency365.com/mtyt Learn 130 essential efficiency best practices - read my latest book - s.efficiency365.com/bk Let me know if you want me to cover any specific topics as well. Cheers. Dr Nitin (doc) Paranjape.
@learnprogramming5587
Ай бұрын
Sir, can I get practice file,thank you
@donnawittie2270
13 күн бұрын
😂
@efficiency365
12 күн бұрын
Thanks @donnawittie2270 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzitem.info/news/bejne/06p60oOIhZ-bn3o Excel Green Marks - Error Checking - Best Practices - kzitem.info/news/bejne/uZuC2qCwnWudhY4 Excel Best Practices - Part 1 of 3 - Data Management - kzitem.info/news/bejne/06iVl5yXb5lnn5g Excel Best Practices - Part 2 of 3 - Formulas - kzitem.info/news/bejne/zLCV4HWshnt_dKA Excel Best Practices - Part 3 of 3 - Analytics - kzitem.info/news/bejne/q4SIm62umIKYZ3Y 10 Excel Settings You Must CHANGE! - kzitem.info/news/bejne/146o2IyahKt7eaA Automatic data clean up with Excel Flash Fill - kzitem.info/news/bejne/r2mmxayVpYqFkpg Instant Excel Audit, Comparison and Analysis - Inquire - kzitem.info/news/bejne/xHqa3ImQsYGGnKg Six powerful Excel Navigation Shortcuts - kzitem.info/news/bejne/w4hj34GYgIKiaGU Handle millions of rows in Excel - Slow to fast - kzitem.info/news/bejne/mmmenaaIrH53ao4 Convert crosstab to tabular - Unpivot - Excel Power Query - kzitem.info/news/bejne/zoqqtaiQgV-fgYI Cheers. Doc
Пікірлер: 21