?? Work at Pickup Points � Flexible schedule

The Excel Tool That Does What PivotTables Can’t (File Included)

MyOnlineTrainingHub 291 views

Download Video

Comments

❓What’s the biggest dataset you’ve tried to manage in Excel?brbrDownload the example file here and follow along: bitly/powerpivot24filebrLearn more about the Power Pivot and DAX course: bitly/powerpivot24course
Comment from : @MyOnlineTrainingHub

You video is great
Comment from : @sadeklab

Dear teacher, amazing video May you please let me know what software do you use for comment your videos and add shapes?
Comment from : @Oldan-Enuar

great
Comment from : @omarfarid9292

Not available on the Mac version?
Comment from : @NeilMitchell-c9u

Just outstanding brThanks again ♥️
Comment from : @mostafahamdy4303

Many thanks It's very useful
Comment from : @Ijiljili

The title should include the name "Power Pivot," otherwise this will almost act as a click-bait
Comment from : @dinethprabash1001

But not available on Microsoft 365?
Comment from : @jimstanborough825

😎😎😎
Comment from : @irafofficial

13:45 - you can update your reports with 1 click well, except for those manual numbers you entered for your KPI Surely would be better to use a linked value
Comment from : @bermchasin

You can link several tables in regular Pivot Just need a common column
Comment from : @supanova4126

Love the video - but I’m being thick How do you add ‘Table design’ to the headings … I’m just trying to get familiar with all this good stuff and want to replicate the training video on my laptop Don’t even know what it’s called Toolbar / ribbon etc lol Hope someone can shove me in the right direction!
Comment from : @laro1002

Not conviced at all, you introduce database theory to people who just expect simple and clear Excelbr14 min of explanations confuse me, and you sound as Microsoft personnel, sorry
Comment from : @makerofstartup7902

Ok, but why mimic database functionality in a datasheet? brI think it would be much simpler just convert your Excel file to an MS Access database
Comment from : @pgsss6354

Great ! Awesome explanations as alwaysbrThanks Mynda and happy new year !brGod bless you
Comment from : @angekouakou7753

Really no different than building a crosstab query in Access Excel has essentially replaced Access because most folks don't understand Access
Comment from : @timhughes2809

Why does the ribbon interface display the generic “Data Model” if it really means “PowerPivot” ???
Comment from : @dmccalldds

Nice video, feels like a proper lesson I did not know about the KPI tool, thanks!
Comment from : @justinwduff

My favorite AI teacher She speaks without even taking a breath
Comment from : @TrevorGopaul-le4zt

What’s the difference between Power Pivot and Access?
Comment from : @VeteranofthePsychicWars

Great video, very helpful thanks :)
Comment from : @ricpue

Joke
Comment from : @jasonsmith1273

When I am trying to Create KPI, I got an unhandled exception error, JIT error How to solve this issue?
Comment from : @QhYau

This is great, and what timing! I do almost all of my daily data analysis using Power BI, so I questioned if I should take the time to watch this video But just 2 days later I was asked to do a quick analysis using an Excel extract as a data source, so I quickly did in Excel, using Power Pivot, what I'd normally do in Power BI I wouldn't have been sure how to do that so quickly if I hadn't just seen this video And if I discover that I'll need to repeat that analysis often, I could copy the queries I created in the Excel file's Power Query to a Power BI report or Dataflow and not have to redo anything Brilliant!
Comment from : @julliettecarignan8563

Thank you for this example! I use vlookup monthly and spend about a day cleaning and organizing the data This will allow me to finish in a couple of hours rather than a full day of working at this Thanks times 10000!
Comment from : @bdwoods08

Thank you! This is great!
Comment from : @turbalejo4999

How did you calculate the average adjusted profit when creating KPI? Do we have to manually calculate and enter the value?
Comment from : @Rajk-z3k

Outstanding!
Comment from : @tommypain

Reminds me of my days programming in MS Access Great to see this function is integrated in excel now
Comment from : @helvisea

"nowadays we need//"? You and I do not know the actual needs of others I suppose this is a great functionality if you work in Excel a lot A powerful tool does not equal a need
Comment from : @perkristoffersson4153

People still use Excel?
Comment from : @VPutin-y7j

why not use vba and use SQL queries to fetch the data?
Comment from : @DJ-pn9te

What is the best way to handle a sheet that has lots of rows and data In my case, the formula and calculations are not done and not updated So I had to increase iterations to make excel do the formulas Can you give us the best ways to handle big files? Like which excel file format to use, etc
Comment from : @mohamedalmusalam

Very similar to Power BI Except the power of the relationships it seems
Comment from : @gino0612

Too bad this is not available in Excel for Mac
Comment from : @maxhuber4924

What is the maximum data volume (rows x columns) and file size Excel can handle efficiently with Pivot Table?
Comment from : @kisho2679

7:50 Hi Mynda IMHO we should always use Fully Qualified Column Names when referring to a table column It's about readability when using references w/o table names are used for measures It's a kind of best practice I would say On the other hand, I would prefer iterator functions before calculated columns It's performing better if I'm not wrong
Comment from : @RogerStocker

10:00 Wait, I’m confused… So, first you start by creating a calculated column, but now you have a measure (?) Why not just create a measure to begin with?
Comment from : @JJ_TheGreat

7:19 Why calculated columns and not measures??
Comment from : @JJ_TheGreat

2:06 OR - You would have to use Power Query to merge the data into the other table…
Comment from : @JJ_TheGreat

Hi Mynda Thank you for this tutorial I can tell you all "Power" features of Excel are so addictive that sometines I forget to use ol'good formulas 😉 And some tasks are easier to solve with Power tools than classic methods
Comment from : @pavolcernak

The problem I have is that when importing data from folder, it does not put it in a link but puts it into the file making it a really large file The data spans 5 years so files are large the pivot file comes in at 125mb It is easy when linking single files as power pivot saves it as a link
Comment from : @kenstav1

Thanks How can i add a remarks column near pivot row? I want it to remain even after pivot refresh?
Comment from : @stanTrX

Does it work in excel 2019?
Comment from : @margaretmicherda6136

In Power Query I have a data model of 30000 rows or more, by combining multiple excel files In power Query it take up to 15 minutes just to load the preview for every step I add, and when I try to load it in my data model (whithout saving it in excel, but as a connection only), it take over 2h and a half to load in the data model How can I work in these conditions?
Comment from : @alterchannel2501

6:33 - What!?!?!?!? No one in the history of ever has had this problem????? ;)
Comment from : @rob4433

excellent tutorial as always
Comment from : @mogarrett3045

Yes But, If there is no unique values ( or in unique contains duplicates) it is better to go with pivot table
Comment from : @EduTaxTuber

Good info thanks
Comment from : @bbqworld2103

I learned something new today! Great video
Comment from : @thebesttechnical3608

This is great and I will explore and use It seem like MSFT keeps adding and content creators are emphasizing database functions in Excel - is there any hope for the Access database program?
Comment from : @michaelkuhn6328

Does Power Pivot work in Excel for Mac? If so, how do I install it?
Comment from : @stephenargent5582

Is it better to add calculated columns in Power Pivot or Power Query, or doesn't it matter?
Comment from : @GaryMillerUK

,,,,,
Comment from : @ericssontest2332

Thanks, turning on the options is something I have done
Comment from : @PaulEBrownbill

Excellent video, tried and got successful Need a video on P&L template in Power bi with Gross profit, operating profit and net profit shown just like in excel
Comment from : @chandrakantha648

Your teaching is great, but I will appreciate if you use highlighted pointer & focus on viewers who watch your lessons on mobile phones (Tiny screen)Your subscribers will increase considerably if you take that initiative As of now, I may or may not view your presentations as an option I hope you understand what I mean, & take this feedback in the right spirit
Comment from : @ignatiussilveira4257

Hi MyndabrImpressive, and I would even allow myself to say that I am quite well versed in Power Pivot, but there is always something good to be gained from your review brThe formula with Adjusted profit is great, I hadn't come up with it myself, thanks
Comment from : @ivanbork4175

As a plant controller, I used Power Pivot calculated measures to generate a gross profit margin based on the revenue, material, labor and overhead and helped the company improved top line revenue from the making price increase decisions on specific product models It has modeling functionality that eliminates the need to do vlookups This is a great tool for anyone doing data wrangling!
Comment from : @FareyFraction

Pivot tables can already be linked to multiple data sets in the same way without using power pivot 🤷
Comment from : @hagenfieberkorn5111

This really changes how I'm thinking about creative options for displaying KPIs Thank you!
Comment from : @jennysheets3763

❤
Comment from : @reyt7349

peace be upon you from me and zamzam water
Comment from : @DimasFajar-ns4vb

5:25 “PivotTable … we know and love…” What a sense of humour 😂 I never get PTs to look how I want them
Comment from : @nickhalden4759

You are so kind and a great teacher showing alternate methods for same goals THANKS SO MUCH You are always great!
Comment from : @merrillmchenry1450

Why in KPI you needed to add absolute value (of the average value)? Is it possible to make KPI dynamic (because value of average will change when you add new data to your table)?
Comment from : @zuzanasmekalova4632

Can u do most used functions - calculate - related - filter - concatenation- time ?
Comment from : @sajadabdulcader5337

Pls get me a Formula to count meals (breakfasts, lunches & Diners) between 2 dates in different columns briebr20/11/2024 Diner to 24/11/24 BreakfastbrbrBF (Column) br4nosbrLunch (Column) br3nosbrDiner (Column) br4nosbrbrIf you give me a solution i will be very greatful
Comment from : @johank4361

Your videos are so helpful!
Comment from : @PaulElmont-fd1xc

Recent subscriber, big fan
Comment from : @brettburton1477

Wondering is there a preference of Calculated Columns vs Measures Or would there be different use cases for both It seems to me that their uses kinda overlap
Comment from : @TheJoshtheboss

Yes, Power Pivot Ready to devour this video Love your Pivot tables and Data Model content
Comment from : @TheJoshtheboss

Can I use power pivot and query on Mac Pro ?
Comment from : @UdaiKs

Hi, I have added a new measure, but I dont know why the filters can’t work
Comment from : @karwaisung2420

I took your Power Pivot and Power Query course a couple of years ago and it changed everything! I saved so much time at work for myself and my coworkers I get excited when someone brings me data from multiple sources that needs major cleaning, especially when they think it's going to be so tedious to sift through, because I have so many more tools now that make it much easier
Comment from : @OhReallySnap

Wonderful Mynda I am using Data model for reporting, but this technique never used till now Really great technique and how simply explained Two thumps up!!
Comment from : @loganathannainar4804

This was great now I understand kpi
Comment from : @ddp2049

This is huge I have so many users who need to watch this
Comment from : @FrontLineNerd

Dearest,brHow to compare data in pivot table?brEx: sale in Jan 2023 vs sale in Jan 2024? Calculate to see variance amount and percentage Appreciate for your teaching 🙏
Comment from : @chakrath9149

Would love to use this, but unfortunately, none of the data I use have unique values 🥲
Comment from : @__Esther__

I don't think anyone explains this better than you Always learning!
Comment from : @EliotPowell

Mind Blown There is sooo much to learn from in this video, and I've been hoovering up your insights for a few months now This ties several key tools together - I'm confident I can pull out superior information from our datasets than the native system interfaces now Thank you, Mynda!
Comment from : @DanRoddy