Superb as usual! Thank you Dr. Nitin! What I like most about your videos, is the reasoning behind everything that you explain so well, and demonstrate practically which really helps!
I learned it recently while trying to create the Gantt chart for my project .. even MS gives template and example in you tube how to create the Gantt chart … Conditional formatting is the base and important aspect in GANTT charts …
Thanks @jaswinderbhatti3352 Oh... Don't use Excel for Gantt Charts. Use Draw.IO. It is free. Check out my other best practices videos as well. Efficient Tasks Management - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vLFpWVfUfQ8.html Task Apps Comparison: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ViWJIzMPQZg.html Teams Meeting - Agenda, Action Points, Notes - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-k0t8_mNkMDw.html Microsoft Teams - 15 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-W8Ufx_znKxI.html OneDrive Best Practices Part 1 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-D7ZrfphW4vo.html Part 2 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-nFx6YQxc-b4.html Smart and Effective Email - 5 powerful ways - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6NEFSMqHgQE.html Outlook Calendar Best Practices : Part 1 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-GzsQnecjAQo.html and Part 2 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-padKH8ys5Cs.html OneNote - Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-m-4AY1cMi8s.html Microsoft 365 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kVC_YcL5ObU.html Cheers. Doc.
Hi Dr I love all your videos. It was only yesterday where I found out if your excel spreadsheet contains tables with filters applied, if you try and do a ctrl f and search for a word but that word is filtered out, excel will not be able to find that word and say it doesn’t exist. Is there a way to perform a search which would bring back those results in that circumstance? Imagine the spreadsheet is very large with many sheets so going into every sheet manually and unfiltering is not an option?
Thanks @ademb NO solution for this. It is by design. With programming it is possible to build a REAL FIND feature. I have not searched for them, but there must be tools / utilities that do this already. The more interesting part is - since 40 years, billions of users seem to be ok with this apparent shortcoming 😎 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-rtDlORLmjlE.html Excel Green Marks - Error Checking - Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-XeLtlzd9lRY.html Excel Best Practices - Part 1 of 3 - Data Management - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-rr_1ha6g6lc.html Excel Best Practices - Part 2 of 3 - Formulas - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kz_zAvMINAk.html Excel Best Practices - Part 3 of 3 - Analytics - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-JNR5yx_Pg4A.html 10 Excel Settings You Must CHANGE! - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vXrrXdKyJFk.html Automatic data clean up with Excel Flash Fill - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-N3p_x_lXT_c.html Instant Excel Audit, Comparison and Analysis - Inquire - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cDdvUZxOUis.html Six powerful Excel Navigation Shortcuts - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bR-yMbGPq50.html Handle millions of rows in Excel - Slow to fast - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-93h7rRsLF7Y.html Convert crosstab to tabular - Unpivot - Excel Power Query - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-mTtOtZH-nNM.html Cheers. Doc
Thanks @eeettt8701 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-rtDlORLmjlE.html Excel Green Marks - Error Checking - Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-XeLtlzd9lRY.html Excel Best Practices - Part 1 of 3 - Data Management - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-rr_1ha6g6lc.html Excel Best Practices - Part 2 of 3 - Formulas - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kz_zAvMINAk.html Excel Best Practices - Part 3 of 3 - Analytics - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-JNR5yx_Pg4A.html 10 Excel Settings You Must CHANGE! - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vXrrXdKyJFk.html Automatic data clean up with Excel Flash Fill - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-N3p_x_lXT_c.html Instant Excel Audit, Comparison and Analysis - Inquire - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cDdvUZxOUis.html Six powerful Excel Navigation Shortcuts - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bR-yMbGPq50.html Handle millions of rows in Excel - Slow to fast - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-93h7rRsLF7Y.html Convert crosstab to tabular - Unpivot - Excel Power Query - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-mTtOtZH-nNM.html Cheers. Doc
