Struggling to manage your data? Learn Pivot Tables and save hours every week! 👉 link.xelplus.com/yt-g-merge-tables-pivottable Grab the file I used in the video from here: pages.xelplus.com/merge-multiple-tables-file
Hi. Thanks for your awesome and helpful tutorials ! Can you please confirm that I'm not mad, and Data Model is not available on a MAC version of Excel ??? Cheers
The data model I'm using at work to monitor OPEX is built exactly on that type of pivot table. Now I understand much better what my colleague hasn't explained me. Thank you so much Leila :D
I’ve been working for 6 yrs now in a finance company dealing with data and Excel on a daily basis and I thought I ‘knew’ Excel. Wow your channel is amazing and I am now even more motivated. Anyways may I ask for a tutorial about Slicer tables in Excel, this is something I have been always struggling to understand. I would really appreciate that! Thanks in advance :) Keep up inspiring us Leila :)
You are a life saver!!! Previously, I enrolled to ur VBA course and saved my life too. Once again, this save my life again! Thank you very much for being such a great teacher!!!
Thanks Leila you are brilliant. I just came across your video while preparing for an interview where I will need to have knowledge of Power Query, Power Pivot and Power BI.
Following your channel and watching your videos have upgraded my Excel knowledge to new heights. Thank you for enlightening us and keep bringing new concepts like this.
Wow thanks again! You are empowering so many people in the roles they already occupied. How powerful, thanks Leila! Anyone can lead and anyone can make the difference!
Your knowledge of Spreadsheet is stunning,Ms Gharani. I not only like but love your videos. They have been extremely helpful to me. Since I am learning programming, I wish you could come up with some such videos in days to come. All the best !
Hi Leila. Excellent! Thanks for the reminder of how to make connections in Power Pivot. Picked up a few good tips and tricks from your presentation. Always a pleasure to watch your videos :)) Thanks for sharing and Thumbs up!!
Thanks Leila...Another great time saver in the PowerPivot Data Model is the ability to set the data type (ie Sales Field - Number format as Currency) in the Data Model on the source field therefore eliminating the need to fix the number formatting in every subsequent Pivot Table. Thanks for sharing...
Hi Leila, I am a Qlik Engineer but always wanted to learn excel to do things faster like Quality Checks. Your videos are of great help. Really appreciate your time making these informative videos. I am trying to excel in Excel by watching & practicing.
Really nice and clearly explained how to use the data model with nice music on the background. Thanks nice job and looking forward for many such videos
As Usual, Excellent. (The relationships has been lifted off by excel from filemaker), and since i use office 365 business premium (insider fast) for MAC, I dont think microsoft is providing relationships for the mac version. I have used the knowledge that i have gained from your tutorials on excel to great extent, i have just purchased tutorials for google sheets as well, I used to always leave comments in this regard, google sheets, even the free version is generations ahead and super easy, intuitive as compared to excel. I always find your videos just perfect in everyway. Have a great day, and thanks for sharing. I much appreciate the knowledge you impart, it has helped me reach to great levels, thanks to you.
@@PaulGagnonDouglas Cant find it myself, but, excel relationships is once again a complete liftoff from Apple FILEMAKER's Relationships(been using it since 15 years). And, once again a very bad liftoff, which will have multiple problems too, as is inherent with excel. Sadly, Excel is used by everyone, even though excel is in stone ages compared to google sheets and FILEMAKER.
I have enjoyed all of your great videos. I have learned much on so many topics from you. I have not found a video from you covering Microsoft Project. I think this software product is of the same quality as Excel. It seems like this product would be natural for you to present, especially with your background in project management. I hope you add this to your products to teach. Thank you for all your tremendous videos.
thank you! 9:00 for my reference..also how to click on a field on a pre built pivot field, and know where in the model it is coming from? like tracing the pivots origin fields easily (from what query/table), rather than searching for them in the side bar.
I am trying to work through your tutorial using your file. The column "Article Code" is not available as an option for me to select like you do at 3:29 in the video, even though I see that column in the "TableSales" table. Not sure what I am doing wrong here.
Thank you Leila. This video helps me a lot in my works on originazing assets components. Highly appreciating. Like to see many to many relation + nested tables hierarchy Respectively and best regards
![Seungmin "그렇게, 천천히, 우리(As we are)" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/kAzmhLHePqU/mqdefault.jpg)
Struggling to manage your data? Learn Pivot Tables and save hours every week! 👉 link.xelplus.com/yt-g-merge-tables-pivottable
Grab the file I used in the video from here: pages.xelplus.com/merge-multiple-tables-file
Hi. Thanks for your awesome and helpful tutorials ! Can you please confirm that I'm not mad, and Data Model is not available on a MAC version of Excel ???
Cheers
I am addicted to watch your all videos. You are such a brilliant and you don't know how much you are helping me.
The data model I'm using at work to monitor OPEX is built exactly on that type of pivot table. Now I understand much better what my colleague hasn't explained me. Thank you so much Leila :D
Glad it helped!
i've found your channel has been 3 days, and however we say in my country, "i've been looking for copper, but i've found gold". T h a n k y o u!
Welcome aboard!
Wow thanks again! You are empowering so many people in the roles they already occupied.
I’ve been working for 6 yrs now in a finance company dealing with data and Excel on a daily basis and I thought I ‘knew’ Excel. Wow your channel is amazing and I am now even more motivated. Anyways may I ask for a tutorial about Slicer tables in Excel, this is something I have been always struggling to understand. I would really appreciate that! Thanks in advance :) Keep up inspiring us Leila :)
Glad I could inspire you. I have a video on Pivot Tables on the channel in case you want to check it out.
Leila you are simply the best on RUclips as your lessons are very captivating and easy to understand.
Wow, thank you!
Whenever i find u uploaded a video
Step1: Click on the youtube video.
Step 2: Like it first
Step3: Then watch it..
Thank you Leila. Lots of Love...:)
Thank you for your support!
You are a life saver!!! Previously, I enrolled to ur VBA course and saved my life too. Once again, this save my life again! Thank you very much for being such a great teacher!!!
Leila! I'm just gonna call you the Rock Star maker. You're helping us all to be Rocks Stars at this. Thanks so much for the knowledge transfer!🙌🏾
You rock! 😊
Awesome Data Model video, Teammate!!
Appreciate it, teammate!
Thank you, your courses are the best source for selflearning.
I love your teaching and coaching style. Thanks a lot.
Happy to hear that!
Thanks for your work, I have been watching your videos for weeks to be better at my work. I send you a big hug from CDMX
Thanks Leila you are brilliant. I just came across your video while preparing for an interview where I will need to have knowledge of Power Query, Power Pivot and Power BI.
Following your channel and watching your videos have upgraded my Excel knowledge to new heights. Thank you for enlightening us and keep bringing new concepts like this.
You're very welcome! Thank you for watching.
Wonderful, Leila - no more helper columns! Thank you!
Wonderful Gino!
Thanks. I am just a beginner . These give a better of how a pivot table is created.
Outstanding work as always. I now hope to find a video from Leila whenever I have anything challenging to do in excel.
Wow thanks again! You are empowering so many people in the roles they already occupied. How powerful, thanks Leila! Anyone can lead and anyone can make the difference!
This is just perfect ... simple and easy explanation ... thanks Leila
Glad you like it!
خانم قرانی خیلی ممنون بابت آموزش های مفید شما
Your knowledge of Spreadsheet is stunning,Ms Gharani. I not only like but love your videos. They have been extremely helpful to me. Since I am learning programming, I wish you could come up with some such videos in days to come. All the best !
Thanks!
Thank you, Farshad!
You just rocked my Excel world.
Another fantastic time saving video! Thanks!
Nice and Crisp video Leila! As usual, I learnt a trick or two here as well! Take a bow Lady! You really are "Excel Queen"! 😊👍
Thank you! 😃
thank you for the excellent explanation. Now I understand the Data Model
Great to hear!
I come to your video to refresh my excel skills. Thank you for clear explanation. Please keep up your good work.
Thank you, I will
Hi Leila. Excellent! Thanks for the reminder of how to make connections in Power Pivot. Picked up a few good tips and tricks from your presentation. Always a pleasure to watch your videos :)) Thanks for sharing and Thumbs up!!
Always a pleasure seeing your comments, Wayne :)
your tutorials are really fascinating. Thanks a lot🙏
Glad you like them!
Exactly what I need to do today. Thank you so much! ❤
Excellent tutorial Leila. Thank you very much for sharing your knowledge!
Thanks Leila...Another great time saver in the PowerPivot Data Model is the ability to set the data type (ie Sales Field - Number format as Currency) in the Data Model on the source field therefore eliminating the need to fix the number formatting in every subsequent Pivot Table. Thanks for sharing...
Thanks Laila, Excellent post, your video are awsome and helpful. time saving!!!!!!! wishing you the best
Excellent Trick as always. I wonder how come some people dislike this video! No matter how good a video is, there are always some stupid haters!!
Hi Leila, I am a Qlik Engineer but always wanted to learn excel to do things faster like Quality Checks. Your videos are of great help. Really appreciate your time making these informative videos. I am trying to excel in Excel by watching & practicing.
I definitely struggled with this for a while, so I appreciate this tutorial. Thanks Leila :)
Marvelous video. Clear and easy to follow example. Thank you for sharing.
very good
i'm following you from egypt 🇪🇬
Excellent, thank you Leila. I thought I knew data models and just discovered from this there is still a lot to learn.
Glad it was helpful, Mike!
Really nice and clearly explained how to use the data model with nice music on the background.
Thanks nice job and looking forward for many such videos
This was an excellent tutorial and exactly what I needed. You elevated my excel skills to then new highs. Thank you so much!
Wow. Very explicit video tutorial, thanks for sharing this Leila. You're simply amazing
You’re welcome Nono 😊
Explanation top class.
Highly professional
Awesome as always 👍
I sure will come back to this tutorial many times when I need to use this function in the future
Thanks for simple and clear explanation
Love your tutorials! You've really helped me step up my game at work.
As Usual, Excellent. (The relationships has been lifted off by excel from filemaker), and since i use office 365 business premium (insider fast) for MAC, I dont think microsoft is providing relationships for the mac version.
I have used the knowledge that i have gained from your tutorials on excel to great extent, i have just purchased tutorials for google sheets as well, I used to always leave comments in this regard, google sheets, even the free version is generations ahead and super easy, intuitive as compared to excel.
I always find your videos just perfect in everyway. Have a great day, and thanks for sharing. I much appreciate the knowledge you impart, it has helped me reach to great levels, thanks to you.
Is there an add on for Mac’s office 365...?
@@PaulGagnonDouglas Cant find it myself, but, excel relationships is once again a complete liftoff from Apple FILEMAKER's Relationships(been using it since 15 years). And, once again a very bad liftoff, which will have multiple problems too, as is inherent with excel. Sadly, Excel is used by everyone, even though excel is in stone ages compared to google sheets and FILEMAKER.
Thanks agian Leila! you are the best!
Hey Leila, thanks for sharing this. I am sure this is going to be useful to lot of people.
I hope so!
Thanks Leila, I'll apply this at work
Our pleasure, Felipe.
Superb !! Thanks a lot for the knowledge shared !!
My pleasure!
Thank you! I've actually looking to merge two different data types. Now I found one.
Brilliant presentation!
The data model was a wonderful addition to Excel, no more lookup formulas!
Wonderful presentation mam. I will follow these steps and try to do accounts using excel. Currently I am doing it manually in excel
Great lesson. thank You Leila.
My pleasure!
Thanks. I have been doing this in MS Access. This is much more practical. 👍
I am really thankful to you because this will be help me a lot.
Thank you 😊 💓
My pleasure 😊
I have enjoyed all of your great videos. I have learned much on so many topics from you. I have not found a video from you covering Microsoft Project. I think this software product is of the same quality as Excel. It seems like this product would be natural for you to present, especially with your background in project management. I hope you add this to your products to teach. Thank you for all your tremendous videos.
finally learned a lot more new things in excel.......👍👍👍
Thanks for the thumbs up, Mark.
@@LeilaGharani yeah 👍👍means that you've explained a lot and i understood a lot leila
As always Leila does the best
Thank you 😊
Wow! What a wonderful video. Thank you so much. This is very helpful!
Glad it was helpful! Thank you for watching.
I like relationship. Thanks Leila!
You are just fantastic! It's soooo good and you explained it very good. Thank you very much!
nice music in the video. i watch atleast one video of leila everyday
As always, you are amazing.
Thank you for enlightening us in Excel,
Excellent video, thanks for knowledge sharing.. this was new thing to me..
I was waiting for this :) Excellent!!
Glad you liked it!
Fantastic! Super helpful, thanks Leila
And yet another uploaded video that I will be sharing with my team. Leila Gharani IS #MsExcel!
Hope they'll find it useful Corbin.
thank you! 9:00 for my reference..also how to click on a field on a pre built pivot field, and know where in the model it is coming from? like tracing the pivots origin fields easily (from what query/table), rather than searching for them in the side bar.
Another great video; thanks for sharing 👍👍
Thanks for watching!
Nice explanation very informative.
The first comment I will get love.❤
Thank God Leila Gharani exist
First thank you for your effort,
Second I don’t know how to organize my time to watch all these valuable videos.
Haha same
Thanks for sharing your knowledge.
Thanks looks soo easy!!
Great video ... simple and effective
I am trying to work through your tutorial using your file. The column "Article Code" is not available as an option for me to select like you do at 3:29 in the video, even though I see that column in the "TableSales" table. Not sure what I am doing wrong here.
Ma'am, you're the best lots of love.
Thank you so much 😀
❤️❤️ Enlightening
Presentation is excellent 🙂
Thanks a lot 😊
My favourite teacher
Awesome tutorial.... thanks
It's funtastic video.. love it ❤️👍
Thank you for this video😊
Thank you for your wonderful work. It helps a lot. I obviously still have much to learn about excel :)
This is perfect~ Thank you
Great trick. Thank you for making it so easy!
Nice explanation very informative. Thanks
Thanks a lot Leila
Great video! really useful and easy to understand.
Awesome as always! Making these things very easy to understand.
Thank you Leila. This video helps me a lot in my works on originazing assets components. Highly appreciating.
Like to see many to many relation + nested tables hierarchy
Respectively and best regards
liela ji u rocks really😊
This is amazing, you're saving me hours and hours in the future from having to index-match!!
Happy to help :)
Thank you for sharing!