7 Advanced PivotTable Techniques That Feel Like Cheating

  Рет қаралды 77,647

MyOnlineTrainingHub

MyOnlineTrainingHub

Күн бұрын

Пікірлер: 123
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
❓Which one of these techniques do you like the most? Learn more about the Excel Dashboard course: bit.ly/advancedpt24course
@vidyabhushankumar5361
@vidyabhushankumar5361 Ай бұрын
16 minutes well invested. Thank you so much for these EXCELlent tricks. Text in values was something which had kept me away from pivots, but now I am again a happy Pivot user :)
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Awesome to hear 🙏😁
@chrism9037
@chrism9037 Ай бұрын
I always look forward to Tuesday mornings because I know a new video is coming out. Thanks Mynda this is great!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Thanks for your support, Chris 😁
@DCCConsults
@DCCConsults 7 күн бұрын
I wonder that the way you share your knowledge including the workbook. Thanks Mynda, this helped me a lot.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 7 күн бұрын
You're welcome! I'm glad it helped.
@jon99long
@jon99long Ай бұрын
Using DAX to add labels is amazing. I’m working on a project that requires that. Now I can stop scratching my head on how to do it. Thanks from Sydney!!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
So pleased to hear that! 😁
@56Nine
@56Nine Ай бұрын
NO!!! You can't make me choose the "best" one. What an amazing set of tips...I've been missing out of so many features, just by not seeing an application. Thank you for putting this together!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
😁so glad you liked them 🙏
@mcwahaab
@mcwahaab Ай бұрын
These tips are both helpful and insightful. Thank you, Mynda.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
That's wonderful to hear!
@olakunleoriyomi
@olakunleoriyomi Ай бұрын
You are a blessing to my smartness in Excel usage in ffice. Once I'm lost, I'll just go to your page and reconnect myself 😊. Many thanks for your teachings 🙏
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
That's wonderful to hear 🙏
@ExcelWithChris
@ExcelWithChris Ай бұрын
Great tips again, especially using the DAX formulas. Thanks from South Africa.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Cheers, Chris!
@hanshoogland7452
@hanshoogland7452 Ай бұрын
You show me new stuff (I didn't know) every single week Mynda, 🎉 thank you so much!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
I'm so glad to hear that!
@MsSilver2000
@MsSilver2000 Ай бұрын
Point no6 is amazing, as usual your videos are stunning, Clear teaching with sample data. Thanks for sharing the tricks and tools
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Thanks so much! Glad you liked number 6. 😁
@leerv.
@leerv. Ай бұрын
Holy moly, Mynda, where has tip 1 (grouping pivot table rows) been all my life?! I always added a bucket column to the data or more recently, a column in the data model. This is so much better!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Glad you can make use of that technique 😁
@leerv.
@leerv. Ай бұрын
@@MyOnlineTrainingHub the trick with having all data in the pivot and using the filter to split it out is also really clever. I never ever would have thought of that!
@yertletheturtle5843
@yertletheturtle5843 Ай бұрын
I always learn something new in your videos!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Glad to hear it!
@JamesBond-qg5gx
@JamesBond-qg5gx 13 күн бұрын
Great, very informative and helpful
@MyOnlineTrainingHub
@MyOnlineTrainingHub 13 күн бұрын
I'm glad you found it helpful!
@NAWAZSHAIKH-t6m
@NAWAZSHAIKH-t6m 4 күн бұрын
Last two was awesome 🎉❤
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 күн бұрын
So pleased you liked them!
@JB-nv9fn
@JB-nv9fn Ай бұрын
Absolutely brilliant. Thanks for sharing. 😊
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Glad you enjoyed it 😊
@adelgonalves7839
@adelgonalves7839 Ай бұрын
Mynda you're so EXCEllent at what you do, you always provide us with best content. I really wish I could take one of your courses unfortunately I can't pay for it because of the country I'm in. 😢. Thanks a lot for all these high quality content
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Thanks for your kind words!
@brighttriangle
@brighttriangle Ай бұрын
Great video, as always. Tip number 6 was new to me. Your use of the CONCATENATEX DAX function is amazing. Thank you for sharing.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Glad you enjoyed it! 🙏
@madlarch
@madlarch Ай бұрын
Well, I'm going to have to do a bit of playing around, but I think that technique #6 might well solve a problem that I've been stuck on for quite a while now. Some of the others look like they might help solve some other problems. So thank you VERY much for this !!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Wonderful to hear!
@BookwormFUT
@BookwormFUT Ай бұрын
Glad I found this channel. I basically live in Excel, so these tips are extremely useful. Also, off-topic comment, but that's a great haircut.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
😁thanks so much x 2!
@martinargimon730
@martinargimon730 Ай бұрын
Excellent tips. You are a ⭐️. Rgds. Martin
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Thanks so much, Martin! Glad you liked them 😁
@vikaasb2016
@vikaasb2016 11 күн бұрын
Earlier I thought other videos which were the best but this stands out
@MyOnlineTrainingHub
@MyOnlineTrainingHub 9 күн бұрын
Thanks so much!
@regme4life191
@regme4life191 Ай бұрын
Thank you Mam for this most useful and informative video.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
So nice of you 😊
@rakeshsaraf5139
@rakeshsaraf5139 Ай бұрын
Thanks for these wonderful tricks
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Most welcome 😊
@karolinab9749
@karolinab9749 Ай бұрын
I did not know the trick to count unique values in a pivot table - thank you!!!😊
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Glad you discovered something new 😊
@Vlog88999
@Vlog88999 Ай бұрын
Thank you for your efforts 🎉🎉
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
It's my pleasure 😊
@moonilyas
@moonilyas Ай бұрын
Yeah, great 7 Advanced Pivot table techniques, Thanks!!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Glad you liked them 🙏
@rokaskrisciunas6015
@rokaskrisciunas6015 Ай бұрын
Thanks for great tips! I didn't even know DAX is used in excel!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Yes, DAX was in Excel before Power BI even existed 😁 The data model/Power Pivot in Excel is the same as the one found in Power BI, so those skills are transferrable. Note: not all functions in Power BI are available in Excel.
@ahmedameenkhalaf
@ahmedameenkhalaf Ай бұрын
Text in Values is an amazing add
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Glad you like it 🙏
@shoppersdream
@shoppersdream Ай бұрын
Very Nice, thanks! I was planning to give my report to my supervisor tomorrow but now I think I will add those Data Bars before sending my report.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
So pleased you can make use of the data bars 😊
@shoppersdream
@shoppersdream Ай бұрын
@@MyOnlineTrainingHub I tried it today but Data Bars didn't show on my Show Filter Pages. My numbers were not very big so Data Bars didn't look nice. Many numbers were like 1 to 10 and it didn't give any noticeable bars for these small numbers. It definitely looks nice if you have bigger numbers. Thanks
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Yes, if you have large disparities in values, then the small bars will get lost. Unfortunately, no formatting comes across when you create report filter pages, but once set up, you can refresh those PivotTables and the formatting sticks.
@salilgangal5913
@salilgangal5913 Ай бұрын
Excellent !!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Thank you! Cheers!
@brianwied3702
@brianwied3702 Ай бұрын
Very helpful, hoping they come out with power pivot for the Mac version of excel
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Thank you! Not much chance of Power Pivot for Mac anytime soon, sorry.
@georgewilliams6139
@georgewilliams6139 Ай бұрын
Thanks lovely data lady
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Glad it was helpful!
@georgewilliams6139
@georgewilliams6139 Ай бұрын
@@MyOnlineTrainingHub I should say Excel Data Lady
@tomhaase1386
@tomhaase1386 Ай бұрын
Rhis was for me 16 minutes worth spend. Text in values was new to me , as well as adding to data model to get distinct values. Very well done 😅
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Thanks so much, Tom!
@KimzCraftz
@KimzCraftz Ай бұрын
Text in values and number formatting - both great, but number formatting will be used a lot!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Awesome to hear!
@mipe5227
@mipe5227 Ай бұрын
Hi Mynda, I've been looking for something like in tip no. 4 for a long time... Is there a way to lock the filter as the different recipients of the filtered tables should not be able to see the rest of the data? And by the way: I absolutely ❤your videos! Please keep going! Thank you so much!!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Thank you! You can protect the sheets (Review tab > Protect sheet) to stop recipients from editing the PivotTables. Make sure you disable "Select Locked cells".
@ashishshiriskar123
@ashishshiriskar123 Ай бұрын
Superb Video😊
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Thanks 🤗
@joshuaholland3705
@joshuaholland3705 Ай бұрын
It's like magic! Straight fire!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
😁🙏
@zachcross8868
@zachcross8868 Ай бұрын
I love these tips, especially the text labels. I'm trying to use Technique No. 4 and have a problem. I have a pivot table and want to generate a worksheet for each filter. However the "Show Report Filter Pages" is greyed out. I'm using a pivot table from data model with relationships. Could that be why it's not available?
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Yes, the show report filter pages feature is not available when you load the data to the data model.
@tanveerabbas3271
@tanveerabbas3271 Ай бұрын
great as always😅
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Thank you so much 😀
@felixdelarosa9266
@felixdelarosa9266 Ай бұрын
excellent video. You are the best. in the Dashboard you made once you used the honeycomb. What is the hexadecimal code for that color of honey? I await your response please
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Glad you liked it! I'm not sure what colour you're referring to. Best to download the file and then you can inspect the colours yourself.
@mohammeddapwan6226
@mohammeddapwan6226 Ай бұрын
thank so much for amazing vedio
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
So pleased you liked it 🙏
@mogarrett3045
@mogarrett3045 Ай бұрын
excellent
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Many thanks!
@JamesBond-qg5gx
@JamesBond-qg5gx 13 күн бұрын
Struggling to sort the values in my pivot table but no success. I have item codes, item descriptions and sales value. Appreciate your support. Thanks
@MyOnlineTrainingHub
@MyOnlineTrainingHub 12 күн бұрын
PivotTables sort from left to right, therefore you need to put the column you want to sort by first in the row labels. If you're still stuck, post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@druzicka2010
@druzicka2010 Ай бұрын
Omg these technics ! 🤩 i think i gonna suffer because i don't enough know pivot table functions and practice... but i like challenge so... thanks.🌹
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Great to hear! 😁
@KevinLongUSA
@KevinLongUSA Ай бұрын
That number formatting trick!
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
😁
@nazarkamal8831
@nazarkamal8831 Ай бұрын
❤❤❤❤❤ great 👍👍👍
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
🙏😁
@arkai59
@arkai59 Ай бұрын
I am curious of how you would handle comments updates per row with updated data everyday in an automatic way (example: status per open order, until the order is closed and doesn't show anymore in source data)
@jgs343
@jgs343 Ай бұрын
Probably using a macro that detects what is in the data column and then a movement. I think you can have macros run every x amount of time. I use ai for help building mine
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
There's not enough information here for a specific answer, but you could have a status column that says 'open/closed' and then filter the PivotTable to exclude 'closed' items. If you get stuck, you're welcome to post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@bestoptimate
@bestoptimate Ай бұрын
Hi, My problem is different from the topic of this video, but I have to connect with you for the solution of a small problem that I am facing. When I define a named range and deselect and select the range-address, the marching-ants around the defined range are not displayed. Also, when I select an already defined named-range from the list, the cursor does not follow and go to that range. This problem is only in one file that contains VBA code. I don't know whether I have mistakenly disabled that feature. I am using Excel 365. Please do reply, it is a pain for me.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@Vlog88999
@Vlog88999 Ай бұрын
Can you provide this excel file please
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
The link for my file downloads is always in the video description. Here it is again for your convenience: bit.ly/advancedpt24file
@Vlog88999
@Vlog88999 Ай бұрын
@@MyOnlineTrainingHub thank you for your help
@cornereye842
@cornereye842 Ай бұрын
I recently got me a desktop and am trying to learn Excel to freelance and to help me in near future jobs (if God blesses me with one). But for now I thought of freelancing and don't know much how to start. I don't know any Excel freelancers to seek guidance from. I don't know how to I evaluate my skills in Excel. May I ask for some suggestions? *English is not my first language, so I'm sorry if it's hard to read.*
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
You can get up to speed with the basics with our free Excel course: www.myonlinetraininghub.com/free-registration I hope that gets you started and from there you can build up your skills until they're more comprehensive. There are various online tests you can do to evaluate your skill level that you can find with a Google/Bing search.
@DavidKing-wk1ws
@DavidKing-wk1ws Ай бұрын
In reality excel could be considered a formulaic decision tree :)
@Tomg2525
@Tomg2525 Ай бұрын
#7 Number Formats as it will save a lot of time versus constantly updating.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Glad you can make use of it, Tom!
@abidurrahmanabir7745
@abidurrahmanabir7745 27 күн бұрын
Oh my god 😱😱😱 i m looking for this video... Btw m still trying to analyze your video😢😢😢😢
@MyOnlineTrainingHub
@MyOnlineTrainingHub 27 күн бұрын
Hope you can make use of these techniques.
@TrainWrecks-b5p
@TrainWrecks-b5p 14 күн бұрын
why doesnt excel let you set default number formats?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
You can with Power Pivot PivotTables aka the data model, but not with the original/regular PivotTables.
@stanTrX
@stanTrX Ай бұрын
Conditional formatting in my pivot doesnt work at all
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Conditional formatting in a PivotTable only works on the value fields. You cannot apply it to row or column labels, unless you do so manually, i.e. not using the PivotTable regions.
@stanTrX
@stanTrX Ай бұрын
@@MyOnlineTrainingHub thank you now it worked. But i think its not possible to apply it for the whole row based on the value field cond. Formatting rule
@ChandBabu-xz5kd
@ChandBabu-xz5kd Ай бұрын
Is it worthy because google recommended me
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Hope you enjoyed it!
@cscarpulla1
@cscarpulla1 Ай бұрын
0:03 That iMac with no power cord.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
😂
The Excel Trick I Use EVERY DAY (and you should too!)
11:21
MyOnlineTrainingHub
Рет қаралды 203 М.
Ice Cream or Surprise Trip Around the World?
00:31
Hungry FAM
Рет қаралды 9 МЛН
Random Emoji Beatbox Challenge #beatbox #tiktok
00:47
BeatboxJCOP
Рет қаралды 61 МЛН
Hoodie gets wicked makeover! 😲
00:47
Justin Flom
Рет қаралды 112 МЛН
amazing#devil #lilith #funny #shorts
00:15
Devil Lilith
Рет қаралды 18 МЛН
Try The DGET Function Instead of INDEXMATCH & XLOOKUP
12:29
Kenji Explains
Рет қаралды 75 М.
5 Excel Tools Most Users Never Think to Use (Files Included)
12:34
MyOnlineTrainingHub
Рет қаралды 250 М.
You Won't Believe These Crazy PIVOT TABLE Hacks!
11:30
Leila Gharani
Рет қаралды 718 М.
12 Pro PivotTable Formatting Tricks = No more UGLY PivotTables!
12:12
MyOnlineTrainingHub
Рет қаралды 355 М.
PivotTable Tricks That Will Change the Way You Excel (Free File)
17:47
MyOnlineTrainingHub
Рет қаралды 147 М.
The Excel Functions Almost Everyone Overlooks (Better Than SUMIFS)
10:29
MyOnlineTrainingHub
Рет қаралды 83 М.
Make Excel Formulas Dynamic with the This Trick
10:54
Kenji Explains
Рет қаралды 183 М.
The Underrated Excel Tool You’re Missing Out On (Saves Time)
13:40
MyOnlineTrainingHub
Рет қаралды 1,4 М.
Say Goodbye to IF Statements in Excel with SWITCH
7:45
Teacher's Tech
Рет қаралды 569 М.
Ice Cream or Surprise Trip Around the World?
00:31
Hungry FAM
Рет қаралды 9 МЛН