Viewers should also watch his video - 11 commandments on good data. This is extraordinary. His master class on pivot table @ ₹299 is master piece. No parallel course to this course on earth. Repeat watching of his videos will result in new and newer things and deeper insights. All his videos are magical.

I follow lot of youtubers on Excel. This is my first video from your channel. Without a doubt, you are awesome. It's pretty cleaster and clear. Well narrated. Crispy. Worth watching.

@efficiency365

10 ай бұрын

Thanks @santoshkamala2750 Check out my other best practices videos as well. Efficient Tasks Management - kzread.info/dash/bejne/qIB60rmPlrjMgZs.html Task Apps Comparison: kzread.info/dash/bejne/iJ2LrKuzfbO3iso.html Teams Meeting - Agenda, Action Points, Notes - kzread.info/dash/bejne/nWSomsGmfs6zdNo.html Microsoft Teams - 15 Best Practices - kzread.info/dash/bejne/iWyJyNqYqtGxqKw.html OneDrive Best Practices Part 1 - kzread.info/dash/bejne/dmuO1MipmLqaptI.html Part 2 - kzread.info/dash/bejne/oHqsmLuKqMaTkpc.html Smart and Effective Email - 5 powerful ways - kzread.info/dash/bejne/aIJ5qLWGoavNgag.html Outlook Calendar Best Practices : Part 1 - kzread.info/dash/bejne/ea6ns9Cek82ngdI.html and Part 2 - kzread.info/dash/bejne/opWYrapxqdabc9Y.html OneNote - Best Practices - kzread.info/dash/bejne/n2Foo7tqk7DPaNY.html Microsoft 365 Best Practices - kzread.info/dash/bejne/nYp3wbucfJi1krg.html Cheers. Doc.

Thanks a lot... I even didn't know table has so many benefits I will use these techniques in my daily work

@efficiency365

10 ай бұрын

Yes. Tables are amazing. These should be the Standard Operating Procedure for the world.

It's too easy to do it.. I appreciate it.

@efficiency365

10 ай бұрын

Thanks @harjitthakur2519 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzread.info/dash/bejne/pKh4zrGLfNDQnKg.html Excel Green Marks - Error Checking - Best Practices - kzread.info/dash/bejne/ipmA1s6zlJzSgrw.html Excel Best Practices - Part 1 of 3 - Data Management - kzread.info/dash/bejne/pKaTk8qaZsqcnMY.html Excel Best Practices - Part 2 of 3 - Formulas - kzread.info/dash/bejne/na6T3KOvfay0cc4.html Excel Best Practices - Part 3 of 3 - Analytics - kzread.info/dash/bejne/fIKGl9uxj7PNZKQ.html 10 Excel Settings You Must CHANGE! - kzread.info/dash/bejne/qIym1Lqde9ywds4.html Automatic data clean up with Excel Flash Fill - kzread.info/dash/bejne/gGekwdqYnLu6j8Y.html Instant Excel Audit, Comparison and Analysis - Inquire - kzread.info/dash/bejne/lXiY2LeTqLK7mdY.html Six powerful Excel Navigation Shortcuts - kzread.info/dash/bejne/lIZh26-bd7PXZZM.html Handle millions of rows in Excel - Slow to fast - kzread.info/dash/bejne/a2ecmdSLo6-sZ7w.html Convert crosstab to tabular - Unpivot - Excel Power Query - kzread.info/dash/bejne/n4iosdaTeJDUfrA.html Cheers. Doc

One of the best and most informative video about Excel Tables. Subscribed. Can't wait to see more tips and tricks. Thank you.

@efficiency365

8 ай бұрын

Thanks @jeevanmarg Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzread.info/dash/bejne/pKh4zrGLfNDQnKg.html Excel Green Marks - Error Checking - Best Practices - kzread.info/dash/bejne/ipmA1s6zlJzSgrw.html Excel Best Practices - Part 1 of 3 - Data Management - kzread.info/dash/bejne/pKaTk8qaZsqcnMY.html Excel Best Practices - Part 2 of 3 - Formulas - kzread.info/dash/bejne/na6T3KOvfay0cc4.html Excel Best Practices - Part 3 of 3 - Analytics - kzread.info/dash/bejne/fIKGl9uxj7PNZKQ.html 10 Excel Settings You Must CHANGE! - kzread.info/dash/bejne/qIym1Lqde9ywds4.html Automatic data clean up with Excel Flash Fill - kzread.info/dash/bejne/gGekwdqYnLu6j8Y.html Instant Excel Audit, Comparison and Analysis - Inquire - kzread.info/dash/bejne/lXiY2LeTqLK7mdY.html Six powerful Excel Navigation Shortcuts - kzread.info/dash/bejne/lIZh26-bd7PXZZM.html Handle millions of rows in Excel - Slow to fast - kzread.info/dash/bejne/a2ecmdSLo6-sZ7w.html Convert crosstab to tabular - Unpivot - Excel Power Query - kzread.info/dash/bejne/n4iosdaTeJDUfrA.html Cheers. Doc

Another fantastic video, many thanks!

@efficiency365

10 ай бұрын

Thanks. More coming soon.

Super explained SIR

@efficiency365

10 ай бұрын

Thanks. Wanted to make this for a long time. I did have an old video for this. But it is outdated. I started with 8 benefits. While creating the video, discovered more!

Awesome, I need to do that slicer video very soon. Thanks

@efficiency365

10 ай бұрын

Thanks @billblanchette3604 Check out my other best practices videos as well. Efficient Tasks Management - kzread.info/dash/bejne/qIB60rmPlrjMgZs.html Teams Meeting - Agenda, Action Points, Notes - kzread.info/dash/bejne/nWSomsGmfs6zdNo.html Microsoft Teams - 15 Best Practices - kzread.info/dash/bejne/iWyJyNqYqtGxqKw.html OneDrive Best Practices Part 1 - kzread.info/dash/bejne/dmuO1MipmLqaptI.html Part 2 - kzread.info/dash/bejne/oHqsmLuKqMaTkpc.html Smart and Effective Email - 5 powerful ways - kzread.info/dash/bejne/aIJ5qLWGoavNgag.html Outlook Calendar Best Practices : Part 1 - kzread.info/dash/bejne/ea6ns9Cek82ngdI.html and Part 2 - kzread.info/dash/bejne/opWYrapxqdabc9Y.html OneNote - Best Practices - kzread.info/dash/bejne/n2Foo7tqk7DPaNY.html Microsoft 365 Best Practices - kzread.info/dash/bejne/nYp3wbucfJi1krg.html Cheers. Doc.

Very good video as usual, thank you! I noticed you used a vlookup formula in one of your examples, have you tried using the new xlookup? It's much more powerful and solves the problem of column numbers changing and only being able to search values in the first column of the array.

@efficiency365

10 ай бұрын

Of course XLOOKUP is better. Will post a video on XLOOKUP soon. There are other ways to eliminate VLOOKUP - Using Power Query kzread.info/dash/bejne/oYd_w5lxitnaddI.html Using Relationships in Data Model: kzread.info/dash/bejne/e4FhmKOyYri5pJs.html

This was a fantastic and contentful delivery. Sir, I need to collect data physically for a research questionnaire, including qualitative and quantitative data. Please suggest the proper application and features.

@efficiency365

10 ай бұрын

Do you want to convert paper data to Excel? Try Data from Picture. However, it will not work with handwritten data. Let me know more details, then I can provide a more specific answer.

@dr.haneevinchu182

9 ай бұрын

No, I mean to collect qualitative and quantitative data one-to-one from the respondent and enter it in the application for statistical analysis. Sometimes it can be that respondent will find it easier to post the responses.@@efficiency365

@efficiency365

9 ай бұрын

Use MS Forms if it is ONE response per respondent. Use Lists if it is multiple.

Amazing, how comeall mylife using Excell without knowing that info 😢

@efficiency365

8 ай бұрын

😎 @anonymouswikileaks2451 No problem. Retrofit tables in existing files. All good then. Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzread.info/dash/bejne/pKh4zrGLfNDQnKg.html Excel Green Marks - Error Checking - Best Practices - kzread.info/dash/bejne/ipmA1s6zlJzSgrw.html Excel Best Practices - Part 1 of 3 - Data Management - kzread.info/dash/bejne/pKaTk8qaZsqcnMY.html Excel Best Practices - Part 2 of 3 - Formulas - kzread.info/dash/bejne/na6T3KOvfay0cc4.html Excel Best Practices - Part 3 of 3 - Analytics - kzread.info/dash/bejne/fIKGl9uxj7PNZKQ.html 10 Excel Settings You Must CHANGE! - kzread.info/dash/bejne/qIym1Lqde9ywds4.html Automatic data clean up with Excel Flash Fill - kzread.info/dash/bejne/gGekwdqYnLu6j8Y.html Instant Excel Audit, Comparison and Analysis - Inquire - kzread.info/dash/bejne/lXiY2LeTqLK7mdY.html Six powerful Excel Navigation Shortcuts - kzread.info/dash/bejne/lIZh26-bd7PXZZM.html Handle millions of rows in Excel - Slow to fast - kzread.info/dash/bejne/a2ecmdSLo6-sZ7w.html Convert crosstab to tabular - Unpivot - Excel Power Query - kzread.info/dash/bejne/n4iosdaTeJDUfrA.html Cheers. Doc

Hi, excellent content.. I tried the list validation auto expand, did not work. What did I miss?

@aditidabhadkar8181

10 ай бұрын

It does not work for different sheets. The source of the list validation needs to be in the same sheet as the table.

@efficiency365

10 ай бұрын

Thanks @aditidabhadkar8181 You are right. This will not work across sheets. If you want more structured data entry with comprehensive validations, use Lists. Here is the video - kzread.info/dash/bejne/ZZeT2MiMY5rJnrA.html Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzread.info/dash/bejne/pKh4zrGLfNDQnKg.html Excel Green Marks - Error Checking - Best Practices - kzread.info/dash/bejne/ipmA1s6zlJzSgrw.html Excel Best Practices - Part 1 of 3 - Data Management - kzread.info/dash/bejne/pKaTk8qaZsqcnMY.html Excel Best Practices - Part 2 of 3 - Formulas - kzread.info/dash/bejne/na6T3KOvfay0cc4.html Excel Best Practices - Part 3 of 3 - Analytics - kzread.info/dash/bejne/fIKGl9uxj7PNZKQ.html 10 Excel Settings You Must CHANGE! - kzread.info/dash/bejne/qIym1Lqde9ywds4.html Automatic data clean up with Excel Flash Fill - kzread.info/dash/bejne/gGekwdqYnLu6j8Y.html Instant Excel Audit, Comparison and Analysis - Inquire - kzread.info/dash/bejne/lXiY2LeTqLK7mdY.html Six powerful Excel Navigation Shortcuts - kzread.info/dash/bejne/lIZh26-bd7PXZZM.html Handle millions of rows in Excel - Slow to fast - kzread.info/dash/bejne/a2ecmdSLo6-sZ7w.html Convert crosstab to tabular - Unpivot - Excel Power Query - kzread.info/dash/bejne/n4iosdaTeJDUfrA.html Cheers. Doc