The Ultimate Guide To Do DATA ENTRY In Excel - Best Practices - 2023 | Efficiency 365

[@jkumar8590]

Doc. Very great content. Highly enlightening. Path unexplored. Hidden gems.

[@efficiency365]

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.

[@pierrefournier8100]

Hello Dr. Thanks for you providing so interesting content. And for the PowerApp video : YES, please.

[@efficiency365]

Thanks @pierrefournier8100 Power Apps coming soon. Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzbin.info/www/bejne/qKWnnYKIgdKdoqc Excel Green Marks - Error Checking - Best Practices - kzbin.info/www/bejne/jpavpZ-wmZ6fiLs Excel Best Practices - Part 1 of 3 - Data Management - kzbin.info/www/bejne/qKPCYpuXa8xposU Excel Best Practices - Part 2 of 3 - Formulas - kzbin.info/www/bejne/oavCq3Ssgq6Bd80 Excel Best Practices - Part 3 of 3 - Analytics - kzbin.info/www/bejne/gH-1ZqyulLWaaqM 10 Excel Settings You Must CHANGE! - kzbin.info/www/bejne/rInVo4uagN59fM0 Automatic data clean up with Excel Flash Fill - kzbin.info/www/bejne/hGTTkKuVob2HlcU Instant Excel Audit, Comparison and Analysis - Inquire - kzbin.info/www/bejne/mXXHp4iQrbSIn9U Six powerful Excel Navigation Shortcuts - kzbin.info/www/bejne/mIOQqoCYfLWka5I Handle millions of rows in Excel - Slow to fast - kzbin.info/www/bejne/b2TLaKWIqLF5bbs Convert crosstab to tabular - Unpivot - Excel Power Query - kzbin.info/www/bejne/o4XXgKeQfZKhhK8 Cheers. Doc

[@rkrajhan0]

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...❤

[@efficiency365]

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 - kzbin.info/www/bejne/rH2poYqMm7qZh5o Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Word Tables Best Practices - The ultimate guide - kzbin.info/www/bejne/q5audHuug7qCoaM Cheers. Doc.

[@bentamahichem9211]

Thanks

[@efficiency365]

Thanks @bentamahichem9211 for the feedback. Explore more Excel, Power BI and Analytics videos on this channel kzbin.info/aero/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.

[@kaviarasua]

Please create power app videos

[@efficiency365]

Sure. Working on it.

[@eileenlee1187]

Please do the detail video on Excel in Power App. Thank you.

[@efficiency365]

Thanks @eileenlee1187 - I have added Excel - Power Apps to my topic list. Check out my other best practices videos as well. Efficient Tasks Management - kzbin.info/www/bejne/rH2poYqMm7qZh5o Teams Meeting - Agenda, Action Points, Notes - kzbin.info/www/bejne/oWHXaZKjg9CAetk Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs OneDrive Best Practices Part 1 - kzbin.info/www/bejne/emi9o5mmnbxnrNE Part 2 - kzbin.info/www/bejne/pHfbZ4yHrchgmJY Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Cheers. Doc.

[@mamalik1088]

Nice explain SIR NP

[@efficiency365]

Thanks @mamalik1088. Check out my other best practices videos as well. Efficient Tasks Management - kzbin.info/www/bejne/rH2poYqMm7qZh5o Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Word Tables Best Practices - The ultimate guide - kzbin.info/www/bejne/q5audHuug7qCoaM Cheers. Doc.

[@seansingh7692]

Could you explain vlookup in detail

[@MKRangelo]

Please create a power app video Dr!

[@efficiency365]

Thanks @VtdarklinkMS for the request. Working on it. Check out my other best practices videos as well. Efficient Tasks Management - kzbin.info/www/bejne/rH2poYqMm7qZh5o Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Word Tables Best Practices - The ultimate guide - kzbin.info/www/bejne/q5audHuug7qCoaM Cheers. Doc.

[@ASI15236]

Power Apps - not sure what it is but looks like data gathering with my cell phone - YES PLEASE

[@efficiency365]

Thanks @ASI15236 Understand all Office 365 apps - kzbin.info/www/bejne/oYemkIyZgZqCmLc Check out my other best practices videos as well. Efficient Tasks Management - kzbin.info/www/bejne/rH2poYqMm7qZh5o Teams Meeting - Agenda, Action Points, Notes - kzbin.info/www/bejne/oWHXaZKjg9CAetk Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs OneDrive Best Practices Part 1 - kzbin.info/www/bejne/emi9o5mmnbxnrNE Part 2 - kzbin.info/www/bejne/pHfbZ4yHrchgmJY Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Cheers. Doc.

[@akborchowdhury1592]

power app video please

[@efficiency365]

Thanks @akborchowdhury1592. Working on Power Apps content. Check out my other best practices videos as well. Efficient Tasks Management - kzbin.info/www/bejne/rH2poYqMm7qZh5o Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Word Tables Best Practices - The ultimate guide - kzbin.info/www/bejne/q5audHuug7qCoaM Cheers. Doc.

[@tehsarr0w]

[@efficiency365]

Thanks @tehsarr0w. Check out my other best practices videos as well. Efficient Tasks Management - kzbin.info/www/bejne/rH2poYqMm7qZh5o Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs OneDrive Best Practices kzbin.info/www/bejne/emi9o5mmnbxnrNE Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Word Tables Best Practices - The ultimate guide - kzbin.info/www/bejne/q5audHuug7qCoaM Cheers. Doc.