Yes. Initially, I thought there are hundreds (possibly thousands) of videos about Excel data entry. Why should I create another one. But when I looked at the videos, I realized that most of the content is about operational skills... key concepts are not even known. Hence this video.
much awaited & highly useful topic... how many hours can be saved avoiding data cleaning, if it is prepared right from the beginning...as they say " prevention is better than Cure" omg.. so many hidden gems.. Excellent content Sir...❤
Thanks @rkrajhan0. You are right. Unclean data wastes lot of precious time - which could otherwise be spent on analysis. 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 Microsoft Teams - 15 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-W8Ufx_znKxI.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 Word Tables Best Practices - The ultimate guide - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ueKCHxNUOkA.html Cheers. Doc.
Thanks @pierrefournier8100 Power Apps coming soon. 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 @eileenlee1187 - I have added Excel - Power Apps to my topic list. 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 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.
Thanks @VtdarklinkMS for the request. Working on it. 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 Microsoft Teams - 15 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-W8Ufx_znKxI.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 Word Tables Best Practices - The ultimate guide - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ueKCHxNUOkA.html Cheers. Doc.
Thanks @mamalik1088. 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 Microsoft Teams - 15 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-W8Ufx_znKxI.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 Word Tables Best Practices - The ultimate guide - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ueKCHxNUOkA.html Cheers. Doc.
Thanks @bentamahichem9211 for the feedback. Explore more Excel, Power BI and Analytics videos on this channel ru-vid.com/group/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.
Thanks @ASI15236 Understand all Office 365 apps - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kVC_YcL5ObU.html 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 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 Cheers. Doc.
Thanks @akborchowdhury1592. Working on Power Apps content. 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 Microsoft Teams - 15 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-W8Ufx_znKxI.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 Word Tables Best Practices - The ultimate guide - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ueKCHxNUOkA.html Cheers. Doc.
Thanks @tehsarr0w. 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 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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-D7ZrfphW4vo.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 Word Tables Best Practices - The ultimate guide - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ueKCHxNUOkA.html Cheers. Doc.