I cannot give this video ENOUGH thumbs up!!! Thank you for explaining this the way you did. It made my life so much easier!
@emaaah13966 күн бұрын
Thank you so very much! Your explaination is super clear and easy to follow along.
@sammypan35283 жыл бұрын
You are one smooth criminal on damn excels. So satisfying to watch. Thanks
@loismathius87473 жыл бұрын
The third of your video I watch I must subscribe this channel the now, best explanation ever!
@user-uk9np8ez1b Жыл бұрын
THANK YOU SO MUCH. NOW I KNOW HOW TO MAKE PIVOT TABLE RELATIONSHIPS
@samueladler90802 жыл бұрын
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.
@orsomethingorno3 ай бұрын
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.
@RAEN742 жыл бұрын
This was so good!! Excellent explanations!!!
@French_Connection4 жыл бұрын
Loved it. Thanks.
@KEN_DEN3 жыл бұрын
So far, T H E B E S T video tutorial!
@hilmanagung2 жыл бұрын
Great video!!! Tons of useful information in just to 10 mins. Thanks
@danjarupath2 жыл бұрын
Awesome 👍😎😎😎😎👍👍👍 great job
@exceltina Жыл бұрын
I keep getting an error code when i try to make a relationship between my tables, says there duplicates. so annoying
@Lilian.Chidinma.Nwafor3 жыл бұрын
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
@KnackTraining3 жыл бұрын
Sounds like the cleaning stage - query only what you need, and append if necessary.
@crystalprado4978 Жыл бұрын
What do I do if there are duplicate values when trying to make relationships?
@mmbcampus2 жыл бұрын
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?
@piyushchikara69455 ай бұрын
do you need microsoft office subscription for adding data in powerpivot table
@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!
@nattygains29556 ай бұрын
When I create a pivot table from power pivot it always shows up blank. How do I fix this?
@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
@tahirakhan45493 жыл бұрын
it would be a better training if you have tables in different sheets
@alessiocerci83862 жыл бұрын
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?