Thanks @rrrprogram8667 Yes. More is always good. Thanks. Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html 10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html Cheers. Doc
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.
Thanks. See Word gems as well: Fast and efficient Navigation in Microsoft Word - Go to Headings Tables Pictures - ua-cam.com/video/CfzxHK5lS8w/v-deo.html
Thanks Ankur Sharma for the feedback. Explore more Excel, Power BI and Analytics videos on this channel ua-cam.com/play/PL-UPeBWRvha2O2TF6vfVw4lfS4honS407.html 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.
Thanks @NuU-yb2ty Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html 10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html Cheers. Doc
Thanks @user-cr8mf7my6u Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html 10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html Cheers. Doc
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 - ua-cam.com/video/93h7rRsLF7Y/v-deo.html Create 3d Map with #excel l #Efficiency365 - ua-cam.com/video/dOX2ivNg2n8/v-deo.html Fast incremental Excel search using new array functions and VBA - ua-cam.com/video/zGnJa_koXKk/v-deo.html
Thanks @aaiyshaunnisa7454 for the feedback. Explore more Excel, Power BI and Analytics videos on this channel ua-cam.com/play/PL-UPeBWRvha2O2TF6vfVw4lfS4honS407.html 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.
Thanks @donnawittie2270 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html 10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html Cheers. Doc
Great job.... Surely ur videos are underrated.... U deserve more.... Keep up the good work
Thanks @rrrprogram8667
Yes. More is always good. Thanks.
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html
Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html
Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html
Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html
Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html
10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html
Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html
Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html
Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html
Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html
Cheers.
Doc
Thanks 😊. Selecting the precedents and data validation selection were new ^^.
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.
Dr. Thanks for showing us the hidden gems in excel
Thanks. See Word gems as well: Fast and efficient Navigation in Microsoft Word - Go to Headings Tables Pictures - ua-cam.com/video/CfzxHK5lS8w/v-deo.html
Sir,
I am at 13:56 . . already I have found this video very useful.
Thank You!
Thanks Ankur Sharma for the feedback.
Explore more Excel, Power BI and Analytics videos on this channel ua-cam.com/play/PL-UPeBWRvha2O2TF6vfVw4lfS4honS407.html
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.
Sir, can I get practice file,thank you
Thanks a lot, extremely useful!
Thanks @NuU-yb2ty
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html
Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html
Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html
Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html
Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html
10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html
Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html
Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html
Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html
Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html
Cheers.
Doc
Thanks for sharing this Go to things 🎉
Thanks @user-cr8mf7my6u
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html
Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html
Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html
Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html
Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html
10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html
Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html
Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html
Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html
Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html
Cheers.
Doc
Thanks for your big efforts
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 - ua-cam.com/video/93h7rRsLF7Y/v-deo.html
Create 3d Map with #excel l #Efficiency365 - ua-cam.com/video/dOX2ivNg2n8/v-deo.html
Fast incremental Excel search using new array functions and VBA - ua-cam.com/video/zGnJa_koXKk/v-deo.html
Eye opening Doc
Funda is simple. Every feature has a purpose. It should be our purpose to find it!
Excellent
Thanks @aaiyshaunnisa7454 for the feedback.
Explore more Excel, Power BI and Analytics videos on this channel ua-cam.com/play/PL-UPeBWRvha2O2TF6vfVw4lfS4honS407.html
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.
😂
Thanks @donnawittie2270
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html
Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html
Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html
Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html
Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html
10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html
Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html
Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html
Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html
Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html
Cheers.
Doc