Excel Productivity for Lazy (but Smart) People (Power Pivot & Data Model explained)

This tutorial is all about mastering Power Pivot and DAX in Excel. Learn from real-life challenges and discover how these powerful tools can make your data reporting efficient and insightful.

✨ Key Highlights:
▪️ The Power of Power Pivot: Understand how Power Pivot can handle large data sets that traditional Excel can't, and how it simplifies complex data analysis.
▪️ DAX for Advanced Calculations: Explore the Dynamic Analysis Expressions (DAX) language for more sophisticated data manipulation and reporting.
▪️ Real-World Applications: See how these tools are applied in actual scenarios, like comparing sales data with new and old master data, and year-to-date reporting.
▪️ Efficient Data Modeling: Learn how to use Power Pivot for efficient data modeling, creating relationships between tables, and making your reports interactive and dynamic.
▪️ Easy Year-to-Date Reporting: Find out how to perform year-to-date calculations with simple DAX formulas, and adapt to different fiscal periods effortlessly.

The great thing is that data modelling and DAX is a skill you need to master for Power BI as well.

With my Master Excel Power Pivot & DAX course, you’ll be able to do it all! Improve your workflow, create impressive models and extraordinary dashboards!

🎓 What's Inside the Course:
- 14 hours of video content
- 2 complete business dashboards
- 60+ Practice Workbooks
- Challenges & Quizzes
- Course Notes
- Helpful Articles & Job Aids
- Your very own eBook with 300+ pages
- Lifetime access

00:00 Take Advantage of Power Pivot & DAX
01:28 The OLD & SLOW Way of Using Excel
03:35 Using Excel Data Model & DAX
08:20 Master Excel Power Pivot & DAX

🚩Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel

[soccernflying]

I found your channel a couple weeks ago and have been binging ever since. This is my first comment. I am so appreciative of all your help and content. Your communication and production skills are awesome. I actually stopped this video 20 seconds in and replayed the last few seconds. Love the modem sound in the background! Such nostalgic memories. What a delightful touch. I’m very grateful for all you do, thank you for elevating my excel skills.

[elactecnology]

I recommend Leila's course to anyone who wants to become an expert in both Excel, power query, power pivot and VBA. I looking forward to joining your latest course.

[steventhomas]

This video went from nothing new, to how in the world have I never known this, real fast! What you did is awesome and very well explained. Curious how did you learn this new technique? I think what you just did was as big of a deal as someone discovering pivot tables for the first time. I know I'm all over the place in this comment but I found this new-to-me method very exciting.

[sanaullahsiddiqi]

Leila Gharani, you are the best. I really love your way of teaching and simplifying things in terms of Excel, Word, Google Sheet, Google Doc and many more. I found them very useful and I look forward to learning more and more from you for the days to come.

[shaunwthompson]

I've been watching your videos for a long time and just loving and absorbing all the free content you make -- but today I decided I needed to dive a little deeper and make sure you were compensated for all of the amazing work you do. I signed up for both this course (Power Pivot & DAX) and the Power Query course (good marketing by the way, easy upsell)! I'm looking forward to upskilling even more.

[thedon]

I think you single handed are saving my job, many times, THANKS!!!! You

[RemyCW]

There is an Excel rule : If you feel it takes you too much time, it means it exist a simplest way to do it !

[garyzeune]

LOVE the clip rolling up your sleeves. What a GREAT idea.

[johntate]

Excellent video! This is also an illustration of things that are done in Excel, when they should have been done in Access. Access can link to your company's database and eliminate the need to import and format data. Your illustration here could have been done in just 2 data tables and a few queries. Once the simple database is set up, then simply link an Excel spreadsheet to the newly created database. If you also do all the data formatting in the Access data tables and queries, that will all carry over to your Excel spreadsheet. If you have the database setup to link the the company's database, you will never have to update your Excel spreadsheet again as it is updated with the most current data each time you open it. Where Excel really shines is in graphing and presentation of the data, so definitely set up all of that in your Excel front end. It is then just a matter of adding some drop down list boxes in VBE with a few logic columns, and each department or manager can change the date range at will for their own specific report. Access is also much better at goal seeking than the convoluted way that Excel handles such tasks. Another nice feature in Access is loosing that limitation on the number of rows. Just remember to link to the Access queries and not the data tables which could have millions of rows of data. I guess i never really paid that much attention to pivot tables, as I was forced to learn to use Access more than 20 years ago by my employer. I didn't realize how powerful the pivot table could be until now. Thanks!

[tomdoe]

Access has been around since the early 90's and can do this with ease

[stephenyipck]

Just signed up. I always felt that Leila explains things in an easy to understand manner so that you can apply the concepts to your own data

[noraberrios]

Girlfriend, I have learned so much with you, well actually, still improving my skills. So grateful for your knowledge and ability to teach in such a calm and intellectual manner. Very easy to understand and so happy I can repeat any lesson as much as i need to. Please keep up the great work!!! Oh and there is ABSOLUTELY NOTHING wrong with your voice, your accent your nose or anything else that others may have a problem with :) Most grateful, Nora <3

[wolfgangley]

I am a senior with an itch for data. I took a "detour" through Data Modelling. THANKS !

[wayneedmondson]

Hi Leila. I'm enrolled in the new course and already enjoying the great lectures, lessons, tips and tricks. Your engaging style makes learning fun. The pace is perfect and the examples are interesting and relevant. Looking forward to increasing my skills as I travel through the course. For those wondering, I highly recommend this and all of Leila's courses. Thumbs up!!

[DemetriPanici]

Getting the most out of excel for the least amount of work is exactly what I want at my job!

[niknoknak]

Nostalgic and fascinating at the same time!!!leila's every new video it's a new masterpiece lesson of excel, cant miss it!!

[annvonbelow]

This is awesome. I know a fair bit of power bi but have totally stayed with the old and comfortable when using excel. This will help me take the plunge!

[vidbox]

Excellent tutorial - from the 2014 method flashback (complete with sad movie music), to the steps for improving efficiency. Saved for regular future reference. TFS!

[elactecnology]

Who else joining the latest course of Leila put a like.
Leila Gharane and Mike McGarvine are my best Mentors in Power tools. No way.

[AMcCarthy]

One of my fav channels on YouTube. So helpful.