Thanks @harjitthakur2519 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
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.
Thanks @santoshkamala2750 Check out my other best practices videos as well. Efficient Tasks Management - th-cam.com/video/vLFpWVfUfQ8/w-d-xo.html Task Apps Comparison: th-cam.com/video/ViWJIzMPQZg/w-d-xo.html Teams Meeting - Agenda, Action Points, Notes - th-cam.com/video/k0t8_mNkMDw/w-d-xo.html Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html Cheers. Doc.
Thanks @jeevanmarg 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
Thanks @billblanchette3604 Check out my other best practices videos as well. Efficient Tasks Management - th-cam.com/video/vLFpWVfUfQ8/w-d-xo.html Teams Meeting - Agenda, Action Points, Notes - th-cam.com/video/k0t8_mNkMDw/w-d-xo.html Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html Cheers. Doc.
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.
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!
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.
Of course XLOOKUP is better. Will post a video on XLOOKUP soon. There are other ways to eliminate VLOOKUP - Using Power Query th-cam.com/video/oSKa78ZvtEo/w-d-xo.html Using Relationships in Data Model: th-cam.com/video/IM-6Ay2USt8/w-d-xo.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.
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.
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
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 - th-cam.com/video/3c_vfS37cnM/w-d-xo.html 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
😎 @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 - 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
It's too easy to do it.. I appreciate it.
Thanks @harjitthakur2519
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
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.
Thanks @santoshkamala2750
Check out my other best practices videos as well.
Efficient Tasks Management - th-cam.com/video/vLFpWVfUfQ8/w-d-xo.html
Task Apps Comparison: th-cam.com/video/ViWJIzMPQZg/w-d-xo.html
Teams Meeting - Agenda, Action Points, Notes - th-cam.com/video/k0t8_mNkMDw/w-d-xo.html
Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html
OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html
Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html
Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html
OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html
Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.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.
Thanks @jeevanmarg
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
Awesome, I need to do that slicer video very soon. Thanks
Thanks @billblanchette3604
Check out my other best practices videos as well.
Efficient Tasks Management - th-cam.com/video/vLFpWVfUfQ8/w-d-xo.html
Teams Meeting - Agenda, Action Points, Notes - th-cam.com/video/k0t8_mNkMDw/w-d-xo.html
Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html
OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html
Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html
Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html
OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html
Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html
Cheers. Doc.
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.
Another fantastic video, many thanks!
Thanks. More coming soon.
Thanks a lot... I even didn't know table has so many benefits
I will use these techniques in my daily work
Yes. Tables are amazing. These should be the Standard Operating Procedure for the world.
Super explained SIR
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!
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.
Of course XLOOKUP is better. Will post a video on XLOOKUP soon.
There are other ways to eliminate VLOOKUP -
Using Power Query th-cam.com/video/oSKa78ZvtEo/w-d-xo.html
Using Relationships in Data Model: th-cam.com/video/IM-6Ay2USt8/w-d-xo.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.
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.
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
Use MS Forms if it is ONE response per respondent. Use Lists if it is multiple.
Hi, excellent content..
I tried the list validation auto expand, did not work. What did I miss?
It does not work for different sheets. The source of the list validation needs to be in the same sheet as the table.
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 - th-cam.com/video/3c_vfS37cnM/w-d-xo.html
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
Amazing, how comeall mylife using Excell without knowing that info 😢
😎 @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 - 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