Grab the file I used in the video from here 👉 pages.xelplus.com/merge-multiple-tables-file

@klimro71

2 ай бұрын

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

Love your tutorials! You've really helped me step up my game at work.

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!

Excellent tutorial Leila. Thank you very much for sharing your knowledge!

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!

@LeilaGharani

2 жыл бұрын

Welcome aboard!

Awesome as always 👍 I sure will come back to this tutorial many times when I need to use this function in the future

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!!!

Awesome as always! Making these things very easy to understand.

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 !

This was an excellent tutorial and exactly what I needed. You elevated my excel skills to then new highs. Thank you so much!

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

Fantastic! Super helpful, thanks Leila

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

Another fantastic time saving video! Thanks!

Another amazing video! Thank you!😊

Great trick. Thank you for making it so easy!

Thank you for enlightening us in Excel,

Thank you, your courses are the best source for selflearning.

I am addicted to watch your all videos. You are such a brilliant and you don't know how much you are helping me.

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!🙌🏾

@LeilaGharani

3 жыл бұрын

You rock! 😊

Wow thanks again! You are empowering so many people in the roles they already occupied.

Marvelous video. Clear and easy to follow example. Thank you for sharing.

Thank you! I've actually looking to merge two different data types. Now I found one.

Exactly what I need to do today. Thank you so much! ❤

Awesome Data Model video, Teammate!!

@LeilaGharani

3 жыл бұрын

Appreciate it, teammate!

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.

@LeilaGharani

3 жыл бұрын

You're very welcome! Thank you for watching.

I like relationship. Thanks Leila!

Great video! really useful and easy to understand.

You are just fantastic! It's soooo good and you explained it very good. Thank you very much!

Outstanding work as always. I now hope to find a video from Leila whenever I have anything challenging to do in excel.

Thanks for sharing your knowledge.

Thanks for simple and clear explanation

Wonderful, Leila - no more helper columns! Thank you!

@LeilaGharani

3 жыл бұрын

Wonderful Gino!

Thanks agian Leila! you are the best!

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

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

@LeilaGharani

3 жыл бұрын

Glad it helped!

Excellent, thank you Leila. I thought I knew data models and just discovered from this there is still a lot to learn.

@LeilaGharani

3 жыл бұрын

Glad it was helpful, Mike!

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.

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!!

@LeilaGharani

3 жыл бұрын

Always a pleasure seeing your comments, Wayne :)

Thank you for sharing!

You just rocked my Excel world.

Great video ... simple and effective

Wow. Very explicit video tutorial, thanks for sharing this Leila. You're simply amazing

@LeilaGharani

3 жыл бұрын

You’re welcome Nono 😊

This is perfect~ Thank you

Brilliant presentation!

Thanks looks soo easy!!

As always, you are amazing.

This is just perfect ... simple and easy explanation ... thanks Leila

@LeilaGharani

3 жыл бұрын

Glad you like it!

Grateful for your sharing.

I love your teaching and coaching style. Thanks a lot.

@LeilaGharani

Жыл бұрын

Happy to hear that!

Thanks. I have been doing this in MS Access. This is much more practical. 👍

Thanks Laila, Excellent post, your video are awsome and helpful. time saving!!!!!!! wishing you the best

Awesome tutorial.... thanks

Excellent. Thanks

Thanks a lot Leila

Explanation top class. Highly professional

I was waiting for this :) Excellent!!

@LeilaGharani

3 жыл бұрын

Glad you liked it!

Leila you are simply the best on KZread as your lessons are very captivating and easy to understand.

@LeilaGharani

3 жыл бұрын

Wow, thank you!

Thank you for your wonderful work. It helps a lot. I obviously still have much to learn about excel :)

Thank you for this video😊

Nice explanation very informative. Thanks

excellent video. thanks a lot

your tutorials are really fascinating. Thanks a lot🙏

@LeilaGharani

Жыл бұрын

Glad you like them!

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"! 😊👍

@LeilaGharani

3 жыл бұрын

Thank you! 😃

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.

Hey Leila, thanks for sharing this. I am sure this is going to be useful to lot of people.

@LeilaGharani

3 жыл бұрын

I hope so!

awesome!! you're soooo amazing!

Thanks. I am just a beginner . These give a better of how a pivot table is created.

Wow! What a wonderful video. Thank you so much. This is very helpful!

@LeilaGharani

3 жыл бұрын

Glad it was helpful! Thank you for watching.

Thank you for enlightening me. Enoy all

Great lesson. thank You Leila.

@LeilaGharani

3 жыл бұрын

My pleasure!

nice music in the video. i watch atleast one video of leila everyday

You are just great!

I definitely struggled with this for a while, so I appreciate this tutorial. Thanks Leila :)

Very slick!

thank you for the excellent explanation. Now I understand the Data Model

@LeilaGharani

3 жыл бұрын

Great to hear!

خانم قرانی خیلی ممنون بابت آموزش های مفید شما

❤️❤️ Enlightening

Ultra Amazing!!!

Thank you 😀

Thanks Leila, I'll apply this at work

@LeilaGharani

3 жыл бұрын

Our pleasure, Felipe.

I come to your video to refresh my excel skills. Thank you for clear explanation. Please keep up your good work.

@LeilaGharani

3 жыл бұрын

Thank you, I will

Another great video; thanks for sharing 👍👍

@LeilaGharani

3 жыл бұрын

Thanks for watching!

Excellent video, thanks for knowledge sharing.. this was new thing to me..

thank you its greaaaaaat

Excellent as always. I'm trying to create a pivot from data generated by other two pivot tables from different files. May you explain the way to do it?

Superb !! Thanks a lot for the knowledge shared !!

@LeilaGharani

3 жыл бұрын

My pleasure!

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 :)

@LeilaGharani

3 жыл бұрын

Glad I could inspire you. I have a video on Pivot Tables on the channel in case you want to check it out.

I love ittttt!!!

liela ji u rocks really😊

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...

Wow, super useful for me. Thanks

@LeilaGharani

3 жыл бұрын

Glad to hear that

very good i'm following you from egypt 🇪🇬

It's funtastic video.. love it ❤️👍

Great amazing creative and perfect as usual , thanks you

@LeilaGharani

3 жыл бұрын

Thank you! Cheers!

I love your channel

Wow thanks so much

The data model was a wonderful addition to Excel, no more lookup formulas!

As always Leila does the best

@LeilaGharani

3 жыл бұрын

Thank you 😊

This is amazing, you're saving me hours and hours in the future from having to index-match!!

@LeilaGharani

3 жыл бұрын

Happy to help :)