Excel Go To Special - secrets and best practices

[@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 - th-cam.com/video/rtDlORLmjlE/w-d-xo.html
Excel Green Marks - Error Checking - Best Practices - th-cam.com/video/XeLtlzd9lRY/w-d-xo.html
Excel Best Practices - Part 1 of 3 - Data Management - th-cam.com/video/rr_1ha6g6lc/w-d-xo.html
Excel Best Practices - Part 2 of 3 - Formulas - th-cam.com/video/kz_zAvMINAk/w-d-xo.html
Excel Best Practices - Part 3 of 3 - Analytics - th-cam.com/video/JNR5yx_Pg4A/w-d-xo.html
10 Excel Settings You Must CHANGE! - th-cam.com/video/vXrrXdKyJFk/w-d-xo.html
Automatic data clean up with Excel Flash Fill - th-cam.com/video/N3p_x_lXT_c/w-d-xo.html
Instant Excel Audit, Comparison and Analysis - Inquire - th-cam.com/video/cDdvUZxOUis/w-d-xo.html
Six powerful Excel Navigation Shortcuts - th-cam.com/video/bR-yMbGPq50/w-d-xo.html
Handle millions of rows in Excel - Slow to fast - th-cam.com/video/93h7rRsLF7Y/w-d-xo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - th-cam.com/video/mTtOtZH-nNM/w-d-xo.html
Cheers.
Doc

[@malchicken]

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.

[@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 - th-cam.com/video/CfzxHK5lS8w/w-d-xo.html

[@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 th-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.

[@learnprogramming5587]

Sir, can I get practice file,thank you

[@NuU-yb2ty]

Thanks a lot, extremely useful!

[@efficiency365]

Thanks @NuU-yb2ty
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - th-cam.com/video/rtDlORLmjlE/w-d-xo.html
Excel Green Marks - Error Checking - Best Practices - th-cam.com/video/XeLtlzd9lRY/w-d-xo.html
Excel Best Practices - Part 1 of 3 - Data Management - th-cam.com/video/rr_1ha6g6lc/w-d-xo.html
Excel Best Practices - Part 2 of 3 - Formulas - th-cam.com/video/kz_zAvMINAk/w-d-xo.html
Excel Best Practices - Part 3 of 3 - Analytics - th-cam.com/video/JNR5yx_Pg4A/w-d-xo.html
10 Excel Settings You Must CHANGE! - th-cam.com/video/vXrrXdKyJFk/w-d-xo.html
Automatic data clean up with Excel Flash Fill - th-cam.com/video/N3p_x_lXT_c/w-d-xo.html
Instant Excel Audit, Comparison and Analysis - Inquire - th-cam.com/video/cDdvUZxOUis/w-d-xo.html
Six powerful Excel Navigation Shortcuts - th-cam.com/video/bR-yMbGPq50/w-d-xo.html
Handle millions of rows in Excel - Slow to fast - th-cam.com/video/93h7rRsLF7Y/w-d-xo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - th-cam.com/video/mTtOtZH-nNM/w-d-xo.html
Cheers.
Doc

[@EnerVinluan]

Thanks for sharing this Go to things 🎉

[@efficiency365]

Thanks @user-cr8mf7my6u
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - th-cam.com/video/rtDlORLmjlE/w-d-xo.html
Excel Green Marks - Error Checking - Best Practices - th-cam.com/video/XeLtlzd9lRY/w-d-xo.html
Excel Best Practices - Part 1 of 3 - Data Management - th-cam.com/video/rr_1ha6g6lc/w-d-xo.html
Excel Best Practices - Part 2 of 3 - Formulas - th-cam.com/video/kz_zAvMINAk/w-d-xo.html
Excel Best Practices - Part 3 of 3 - Analytics - th-cam.com/video/JNR5yx_Pg4A/w-d-xo.html
10 Excel Settings You Must CHANGE! - th-cam.com/video/vXrrXdKyJFk/w-d-xo.html
Automatic data clean up with Excel Flash Fill - th-cam.com/video/N3p_x_lXT_c/w-d-xo.html
Instant Excel Audit, Comparison and Analysis - Inquire - th-cam.com/video/cDdvUZxOUis/w-d-xo.html
Six powerful Excel Navigation Shortcuts - th-cam.com/video/bR-yMbGPq50/w-d-xo.html
Handle millions of rows in Excel - Slow to fast - th-cam.com/video/93h7rRsLF7Y/w-d-xo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - th-cam.com/video/mTtOtZH-nNM/w-d-xo.html
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 - th-cam.com/video/93h7rRsLF7Y/w-d-xo.html
Create 3d Map with #excel l #Efficiency365 - th-cam.com/video/dOX2ivNg2n8/w-d-xo.html
Fast incremental Excel search using new array functions and VBA - th-cam.com/video/zGnJa_koXKk/w-d-xo.html

[@jkumar8590]

Eye opening Doc

[@efficiency365]

Funda is simple. Every feature has a purpose. It should be our purpose to find it!

[@aaiyshaunnisa7454]

Excellent

[@efficiency365]

Thanks @aaiyshaunnisa7454 for the feedback.
Explore more Excel, Power BI and Analytics videos on this channel th-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.

[@donnawittie2270]

😂

[@efficiency365]

Thanks @donnawittie2270
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - th-cam.com/video/rtDlORLmjlE/w-d-xo.html
Excel Green Marks - Error Checking - Best Practices - th-cam.com/video/XeLtlzd9lRY/w-d-xo.html
Excel Best Practices - Part 1 of 3 - Data Management - th-cam.com/video/rr_1ha6g6lc/w-d-xo.html
Excel Best Practices - Part 2 of 3 - Formulas - th-cam.com/video/kz_zAvMINAk/w-d-xo.html
Excel Best Practices - Part 3 of 3 - Analytics - th-cam.com/video/JNR5yx_Pg4A/w-d-xo.html
10 Excel Settings You Must CHANGE! - th-cam.com/video/vXrrXdKyJFk/w-d-xo.html
Automatic data clean up with Excel Flash Fill - th-cam.com/video/N3p_x_lXT_c/w-d-xo.html
Instant Excel Audit, Comparison and Analysis - Inquire - th-cam.com/video/cDdvUZxOUis/w-d-xo.html
Six powerful Excel Navigation Shortcuts - th-cam.com/video/bR-yMbGPq50/w-d-xo.html
Handle millions of rows in Excel - Slow to fast - th-cam.com/video/93h7rRsLF7Y/w-d-xo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - th-cam.com/video/mTtOtZH-nNM/w-d-xo.html
Cheers.
Doc