I cannot give this video ENOUGH thumbs up!!! Thank you for explaining this the way you did. It made my life so much easier!
@sammypan3528
3 жыл бұрын
You are one smooth criminal on damn excels. So satisfying to watch. Thanks
@emaaah1396
Ай бұрын
Thank you so very much! Your explaination is super clear and easy to follow along.
@RocKet-g4u
Жыл бұрын
THANK YOU SO MUCH. NOW I KNOW HOW TO MAKE PIVOT TABLE RELATIONSHIPS
@orsomethingorno
4 ай бұрын
Really well explained -- so far I'd made use of the data model functionality for the efficiency of data storage (can process millions of rows of data effortlessly) but I hadn't understood how the relationships work -- it's going to simplify my queries significantly as I don't need to use clumsy conditionals to process data into a better form -- I can just effectively do a lookup by bringing other tables into my data model.
@loismathius8747
4 жыл бұрын
The third of your video I watch I must subscribe this channel the now, best explanation ever!
@samueladler9080
3 жыл бұрын
Very insightful, but I know it will be very instructive and inspirational if you share your data so we, your students may follow. Thank you boss.
@RAEN74
2 жыл бұрын
This was so good!! Excellent explanations!!!
@French_Connection
4 жыл бұрын
Loved it. Thanks.
@hilmanagung
2 жыл бұрын
Great video!!! Tons of useful information in just to 10 mins. Thanks
@ahmedsabry6489
24 күн бұрын
Thank you❤
@KEN_DEN
3 жыл бұрын
So far, T H E B E S T video tutorial!
@danjarupath
2 жыл бұрын
Awesome 👍😎😎😎😎👍👍👍 great job
@Lilian.Chidinma.Nwafor
3 жыл бұрын
This is so satisfying. Please in a case where one will have to select 2000 customers out of 4 or 5 datasets with each rows upto 20,000 and column 10. Do I do the selection during the data cleaning stage or during the model selection? Thank you
@KnackTraining
3 жыл бұрын
Sounds like the cleaning stage - query only what you need, and append if necessary.
@mmbcampus
2 жыл бұрын
Need one suggestion. In the raw data/source datasheet, I have one column for Birthday information in Date number format. Furthermore, Some data are missing and some cells are mentioned with non-number values (i.e "N/A", "Not update" etc.). Now the problem is when I add this Table into power pivot, Dates are stored as text. That's why I could not add any function. Can you please how to solve this?
@soxpuff
Жыл бұрын
Question, can you hold control and select each table, and then add them to the data module w/o having to select and add them individually? Thanks in advance!
@chandrabhanmishra1898
Жыл бұрын
Very useful power pivot we have facing problem filter wise sheet separated in Power Pivot data analyze tab in Pivot option Baton show report filter page not working in Power Pivot how to solve problem
@piyushchikara6945
6 ай бұрын
do you need microsoft office subscription for adding data in powerpivot table
@alessiocerci8386
2 жыл бұрын
Is there a way to do the same thing as a Vlookup function? So combine fields from different tables, e.g see what type of article each customer had ordered or these kind of info? Or is only possible to have aggregate measures like Total Sales per customers so measures like Sum, Count etc?
@crystalprado4978
Жыл бұрын
What do I do if there are duplicate values when trying to make relationships?
@exceltina
Жыл бұрын
I keep getting an error code when i try to make a relationship between my tables, says there duplicates. so annoying
@nattygains2955
7 ай бұрын
When I create a pivot table from power pivot it always shows up blank. How do I fix this?
Пікірлер: 25