Thanks @aadeorukhkar 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 @jaswinderbhatti3352 Check out my other best practices videos as well. Efficient Tasks Management 2024 - ruclips.net/video/DJcxPtu-rcg/видео.html Microsoft Teams Meetings - 16 Best Practices - ruclips.net/video/l3Bvq-I0hy4/видео.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 David Savage. Check out my other best practices videos as well. Efficient Tasks Management - ruclips.net/video/vLFpWVfUfQ8/видео.html Microsoft Teams - 15 Best Practices - ruclips.net/video/W8Ufx_znKxI/видео.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 Word Tables Best Practices - The ultimate guide - ruclips.net/video/ueKCHxNUOkA/видео.html Cheers. Doc.
Thanks Dimitri Riesen for the feedback. Explore more Excel, Power BI and Analytics videos on this channel ruclips.net/p/PL-UPeBWRvha2O2TF6vfVw4lfS4honS407 Check out my My Udemy 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 @sassyme2100 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, this tutorial save me lot of time for my work. But for my case, i have numbers of characters in the text to be shown and when i want to put the defined mesure field into the Values area, excel gave me this error "This PivotTable field isn't available because it exceeds the total number of characters that a cell can contain." Trick is to just go to PivotTable Design > Grand Totals > Off for Rows and Colums. The error is gone, and you will get the table that you want.
Hi sir very useful tool but need to know can we use this tool for the big size data like for inventory reports I think this tool is suitable for small set of data like attendance sheet correct me if I am wrong.
When you say this "tool" are you talking about Pivot Table or conditional formatting? Conditional formatting will work fine with large data. If you are talking about handling large data in Pivot Table, then you must use Data Model for fast performance. Once your data is in the data model, you can use the DAX approach for creating custom measures as shown here. Watch this video to learn more about using the Data Model. Handle millions of rows in Excel - Fast Analysis - Data Model - ruclips.net/video/93h7rRsLF7Y/видео.html
Hi Niteesh... Yes. I know. It is taking longer. Working on it. I know it is important to start a Hindi channel. But I have some other workload which I need to finish first. Thanks for your patience. Doc.
Hi @chillfire00 Filter on text column - use Contains. Try it and let me know if that works for you. Check out my other best practices videos as well. Efficient Tasks Management - ruclips.net/video/vLFpWVfUfQ8/видео.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.
If you want to filter on the text field added to the Value area, then go to the row / column field dropdown and choose Value Filter and choose "Contains".
Beautifully explained, sir! I got stuck on the value part and not the text. This helped!
Thanks @aadeorukhkar
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 sir … you make my life easy ..
Thanks @jaswinderbhatti3352
Check out my other best practices videos as well.
Efficient Tasks Management 2024 - ruclips.net/video/DJcxPtu-rcg/видео.html
Microsoft Teams Meetings - 16 Best Practices - ruclips.net/video/l3Bvq-I0hy4/видео.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.
That was super useful, thanks a lot!
Thanks David Savage.
Check out my other best practices videos as well.
Efficient Tasks Management - ruclips.net/video/vLFpWVfUfQ8/видео.html
Microsoft Teams - 15 Best Practices - ruclips.net/video/W8Ufx_znKxI/видео.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
Word Tables Best Practices - The ultimate guide - ruclips.net/video/ueKCHxNUOkA/видео.html
Cheers. Doc.
Great 👍
Thanks Dimitri Riesen for the feedback.
Explore more Excel, Power BI and Analytics videos on this channel ruclips.net/p/PL-UPeBWRvha2O2TF6vfVw4lfS4honS407
Check out my My Udemy 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.
Super helpful! Thank yoi
Thanks @sassyme2100
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
It would be nice to see if pivot filter works with this value of text
There is Value Filter in Pivot. But it accepts only numbers.
Why not use conditional formatting to highlight based upon the filter condition?
Thank you, this tutorial save me lot of time for my work.
But for my case, i have numbers of characters in the text to be shown and when i want to put the defined mesure field into the Values area, excel gave me this error "This PivotTable field isn't available because it exceeds the total number of characters that a cell can contain."
Trick is to just go to PivotTable Design > Grand Totals > Off for Rows and Colums. The error is gone, and you will get the table that you want.
Excellent.
Hi sir very useful tool but need to know can we use this tool for the big size data like for inventory reports I think this tool is suitable for small set of data like attendance sheet correct me if I am wrong.
When you say this "tool" are you talking about Pivot Table or conditional formatting?
Conditional formatting will work fine with large data.
If you are talking about handling large data in Pivot Table, then you must use Data Model for fast performance.
Once your data is in the data model, you can use the DAX approach for creating custom measures as shown here.
Watch this video to learn more about using the Data Model.
Handle millions of rows in Excel - Fast Analysis - Data Model - ruclips.net/video/93h7rRsLF7Y/видео.html
I am still waiting for Hindi channel to come.🙏😊😊
Hi Niteesh...
Yes. I know. It is taking longer. Working on it.
I know it is important to start a Hindi channel.
But I have some other workload which I need to finish first.
Thanks for your patience.
Doc.
how use in excel pivot table calculated filed If text column CONTAINS specified value, give me what I want?
Hi @chillfire00
Filter on text column - use Contains.
Try it and let me know if that works for you.
Check out my other best practices videos as well.
Efficient Tasks Management - ruclips.net/video/vLFpWVfUfQ8/видео.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.
@@efficiency365 it doesnt work
If you want to filter on the text field added to the Value area, then go to the row / column field dropdown and choose Value Filter and choose "Contains".