Absolutely excellent. I have already subscribed and liked. This is one of the biggest needs in Excel, in my view: We are often stuck with disparate data from different locations that we must combine via "connectors" between the tables. THEN, we can attack one data table and do analytics. Of course, you were trying to make this presentation efficient, but often the data needs to be cleaned up a bit before any merging can occur. I will see if you have a video on how to clean up all sorts of formatting/data problems. Just great.
Thanks @JohnYoga Here is how you do data clean up - 11 rules for clean data - input data - for Excel , Power BI or any other analytical tool - ruclips.net/video/GuAROFcKqM0/видео.html Data Cleanup - Cross-tab and Multiple headers - Rules 1, 5, 6, 10 - ruclips.net/video/rX83Bp7mndE/видео.html Cleaning hierarchical data - Rules 6 and 8 - ruclips.net/video/h9nSoOl1jiY/видео.html Crosstab cleanup ruclips.net/video/mTtOtZH-nNM/видео.htmlsi=DTvp68hJ5qJuxwCx Multiple header crosstab data clean up - Excel - Power Query - ruclips.net/video/ObvXeuTen-o/видео.html Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html 10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html Cheers. Doc
Thanks @syedaneesdurez8766 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html 10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html Cheers. Doc
Thanks @meenasudhanshu Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html 10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html Cheers. Doc
Thanks @Sumanth1601 Yes. PBI and Excel should be taught, learnt and used together. They are adjuncts. Not separate compartments. Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html 10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html Cheers. Doc
Thanks @mcegirl4 Check out my other best practices videos as well. Efficient Tasks Management - ruclips.net/video/vLFpWVfUfQ8/видео.html Task Apps Comparison: ruclips.net/video/ViWJIzMPQZg/видео.html Teams Meeting - Agenda, Action Points, Notes - ruclips.net/video/k0t8_mNkMDw/видео.html Microsoft Teams - 15 Best Practices - ruclips.net/video/W8Ufx_znKxI/видео.html OneDrive Best Practices Part 1 - ruclips.net/video/D7ZrfphW4vo/видео.html Part 2 - ruclips.net/video/nFx6YQxc-b4/видео.html Smart and Effective Email - 5 powerful ways - ruclips.net/video/6NEFSMqHgQE/видео.html Outlook Calendar Best Practices : Part 1 - ruclips.net/video/GzsQnecjAQo/видео.html and Part 2 - ruclips.net/video/padKH8ys5Cs/видео.html OneNote - Best Practices - ruclips.net/video/m-4AY1cMi8s/видео.html Microsoft 365 Best Practices - ruclips.net/video/kVC_YcL5ObU/видео.html Cheers. Doc.
Absolutely amazing demonstration, I am in the middle of learning both and this video is really helpful for my understanding of both tools better. Many thanks.
Thanks @azwarmzafar Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html 10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html Cheers. Doc
Thanks @GauravGupta-tp6ve Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html 10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html Cheers. Doc
Thanks @ariewibowo4951 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html 10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html Cheers. Doc
If we use standard merge query, it results in nested join which is very slow, especially if both tables to be merged are large. It is better to switch to simple "Table.Join" than "Table.NestedJoin" if both tables are large sized.
Sure. Table.Join will get all fields. We need control over which fields are merged. Hence nested join is better. Secondly, in this type of scenario, one table - the master table - is usually small. Thirdly, to use Table.Join properly, you must choose the appropriate join algorithm. This is difficult to expect at a regular end user level. However, if both tables are very large, trying Table.Join is certainly a good idea.
Thanks @jaswinderbhatti3352 Check out my other best practices videos as well. Efficient Tasks Management - ruclips.net/video/vLFpWVfUfQ8/видео.html Task Apps Comparison: ruclips.net/video/ViWJIzMPQZg/видео.html Teams Meeting - Agenda, Action Points, Notes - ruclips.net/video/k0t8_mNkMDw/видео.html Microsoft Teams - 15 Best Practices - ruclips.net/video/W8Ufx_znKxI/видео.html OneDrive Best Practices Part 1 - ruclips.net/video/D7ZrfphW4vo/видео.html Part 2 - ruclips.net/video/nFx6YQxc-b4/видео.html Smart and Effective Email - 5 powerful ways - ruclips.net/video/6NEFSMqHgQE/видео.html Outlook Calendar Best Practices : Part 1 - ruclips.net/video/GzsQnecjAQo/видео.html and Part 2 - ruclips.net/video/padKH8ys5Cs/видео.html OneNote - Best Practices - ruclips.net/video/m-4AY1cMi8s/видео.html Microsoft 365 Best Practices - ruclips.net/video/kVC_YcL5ObU/видео.html Cheers. Doc.
Thanks @sachindotel6005 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html 10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html Cheers. Doc
Thanks @208935 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html 10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html Cheers. Doc
Thanks @mogarrett3045 Yes. Power Query is the solution to enormous amount of time wasted every day in data clean up. Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html 10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html Cheers. Doc
If tables are clean, then we can just create relationship which will add tables in Data model automatically. Coming thru Power Query keeps original files intact. 👍
Rights. Usually input data is never really clean. So Power Query needs to be used. But even input tables are clean, I always prefer to leave original data alone. If data is in Excel sheet and you add it to Data Model, it is occupying space twice. (Not exactly twice the amount of space. Data Model compresses it well. But still it is wasting space). Keep original files separate, do whatever you want in Power Query - a more modular and less error prone approach. In some cases, Excel itself encourages people to add local table to data model. That is not an optimal approach. Insert Pivot - From Range - It asks you to add to data model. Very bad idea. Learning Power Query is empowerment. Adding local data to data model is a disastrous bad habit. Of course in certain cases, there is justification for adding local data to Data Model. Small lookup tables which do not change often, for example. The key concept here is - Power Query gives you control over what goes inside Data Model. Add to Data Model does not give you any control at all. Therefore, always have PQ as a mediator.
Absolutely excellent. I have already subscribed and liked.
This is one of the biggest needs in Excel, in my view: We are often stuck with disparate data from different locations that we must combine via "connectors" between the tables. THEN, we can attack one data table and do analytics. Of course, you were trying to make this presentation efficient, but often the data needs to be cleaned up a bit before any merging can occur.
I will see if you have a video on how to clean up all sorts of formatting/data problems.
Just great.
Thanks @JohnYoga
Here is how you do data clean up -
11 rules for clean data - input data - for Excel , Power BI or any other analytical tool - ruclips.net/video/GuAROFcKqM0/видео.html
Data Cleanup - Cross-tab and Multiple headers - Rules 1, 5, 6, 10 - ruclips.net/video/rX83Bp7mndE/видео.html
Cleaning hierarchical data - Rules 6 and 8 - ruclips.net/video/h9nSoOl1jiY/видео.html
Crosstab cleanup ruclips.net/video/mTtOtZH-nNM/видео.htmlsi=DTvp68hJ5qJuxwCx
Multiple header crosstab data clean up - Excel - Power Query - ruclips.net/video/ObvXeuTen-o/видео.html
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html
Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html
Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html
Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html
Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html
10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html
Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html
Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html
Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html
Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html
Cheers.
Doc
Sir Explained in very gud manner and easy to understand.
Looking forward for more tips on excel to make work more easier and work efficiently.
Thanks @syedaneesdurez8766
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html
Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html
Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html
Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html
Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html
10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html
Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html
Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html
Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html
Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html
Cheers.
Doc
Very informative and precise to the point.
Thanks @meenasudhanshu
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html
Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html
Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html
Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html
Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html
10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html
Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html
Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html
Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html
Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html
Cheers.
Doc
Excellent content 👌 especially for beginner's..most of these concept are based on PBI, but Excel has this functionality too. Kudos ❤
Thanks @Sumanth1601
Yes. PBI and Excel should be taught, learnt and used together.
They are adjuncts. Not separate compartments.
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html
Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html
Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html
Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html
Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html
10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html
Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html
Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html
Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html
Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html
Cheers.
Doc
Thank you for your fabulous instruction on these concepts - tremendous help!
Thanks @mcegirl4
Check out my other best practices videos as well.
Efficient Tasks Management - ruclips.net/video/vLFpWVfUfQ8/видео.html
Task Apps Comparison: ruclips.net/video/ViWJIzMPQZg/видео.html
Teams Meeting - Agenda, Action Points, Notes - ruclips.net/video/k0t8_mNkMDw/видео.html
Microsoft Teams - 15 Best Practices - ruclips.net/video/W8Ufx_znKxI/видео.html
OneDrive Best Practices Part 1 - ruclips.net/video/D7ZrfphW4vo/видео.html Part 2 - ruclips.net/video/nFx6YQxc-b4/видео.html
Smart and Effective Email - 5 powerful ways - ruclips.net/video/6NEFSMqHgQE/видео.html
Outlook Calendar Best Practices : Part 1 - ruclips.net/video/GzsQnecjAQo/видео.html and Part 2 - ruclips.net/video/padKH8ys5Cs/видео.html
OneNote - Best Practices - ruclips.net/video/m-4AY1cMi8s/видео.html
Microsoft 365 Best Practices - ruclips.net/video/kVC_YcL5ObU/видео.html
Cheers. Doc.
Absolutely amazing demonstration, I am in the middle of learning both and this video is really helpful for my understanding of both tools better. Many thanks.
Thanks @azwarmzafar
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html
Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html
Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html
Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html
Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html
10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html
Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html
Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html
Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html
Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html
Cheers.
Doc
Explained very well!
Got more clarity on how to mange data in data model.
Thanks @GauravGupta-tp6ve
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html
Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html
Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html
Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html
Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html
10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html
Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html
Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html
Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html
Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html
Cheers.
Doc
THANKSS SIR !!
Thanks @ariewibowo4951
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html
Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html
Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html
Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html
Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html
10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html
Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html
Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html
Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html
Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html
Cheers.
Doc
If we use standard merge query, it results in nested join which is very slow, especially if both tables to be merged are large. It is better to switch to simple "Table.Join" than "Table.NestedJoin" if both tables are large sized.
Sure. Table.Join will get all fields. We need control over which fields are merged.
Hence nested join is better. Secondly, in this type of scenario, one table - the master table - is usually small.
Thirdly, to use Table.Join properly, you must choose the appropriate join algorithm. This is difficult to expect at a regular end user level.
However, if both tables are very large, trying Table.Join is certainly a good idea.
Thanks again …. sir
Thanks @jaswinderbhatti3352
Check out my other best practices videos as well.
Efficient Tasks Management - ruclips.net/video/vLFpWVfUfQ8/видео.html
Task Apps Comparison: ruclips.net/video/ViWJIzMPQZg/видео.html
Teams Meeting - Agenda, Action Points, Notes - ruclips.net/video/k0t8_mNkMDw/видео.html
Microsoft Teams - 15 Best Practices - ruclips.net/video/W8Ufx_znKxI/видео.html
OneDrive Best Practices Part 1 - ruclips.net/video/D7ZrfphW4vo/видео.html Part 2 - ruclips.net/video/nFx6YQxc-b4/видео.html
Smart and Effective Email - 5 powerful ways - ruclips.net/video/6NEFSMqHgQE/видео.html
Outlook Calendar Best Practices : Part 1 - ruclips.net/video/GzsQnecjAQo/видео.html and Part 2 - ruclips.net/video/padKH8ys5Cs/видео.html
OneNote - Best Practices - ruclips.net/video/m-4AY1cMi8s/видео.html
Microsoft 365 Best Practices - ruclips.net/video/kVC_YcL5ObU/видео.html
Cheers. Doc.
Loved the video, thank you for making 🙏
Thanks @sachindotel6005
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html
Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html
Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html
Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html
Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html
10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html
Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html
Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html
Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html
Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html
Cheers.
Doc
Best explained ,Thanks sir
Thanks @208935
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html
Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html
Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html
Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html
Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html
10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html
Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html
Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html
Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html
Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html
Cheers.
Doc
Power Query is the answer
Thanks @mogarrett3045
Yes. Power Query is the solution to enormous amount of time wasted every day in data clean up.
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html
Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html
Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html
Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html
Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html
10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html
Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html
Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html
Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html
Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html
Cheers.
Doc
If tables are clean, then we can just create relationship which will add tables in Data model automatically. Coming thru Power Query keeps original files intact. 👍
Rights. Usually input data is never really clean. So Power Query needs to be used.
But even input tables are clean, I always prefer to leave original data alone.
If data is in Excel sheet and you add it to Data Model, it is occupying space twice.
(Not exactly twice the amount of space. Data Model compresses it well. But still it is wasting space).
Keep original files separate, do whatever you want in Power Query - a more modular and less error prone approach.
In some cases, Excel itself encourages people to add local table to data model. That is not an optimal approach.
Insert Pivot - From Range - It asks you to add to data model. Very bad idea. Learning Power Query is empowerment.
Adding local data to data model is a disastrous bad habit.
Of course in certain cases, there is justification for adding local data to Data Model.
Small lookup tables which do not change often, for example.
The key concept here is - Power Query gives you control over what goes inside Data Model. Add to Data Model does not give you any control at all. Therefore, always have PQ as a mediator.