3 Hidden Tips in Excel Power Pivot (You Probably Don’t Know About)

3 Hidden Tips in Excel Power Pivot (You Probably Don’t Know About)

Get Access to the Course: https://courses.xelplus.com/p/master-power-pivot-dax

In this video I share 3 hidden tips for Microsoft Excel Power Pivot that will make your data modeling life easier. We’ll cover how you can easily copy your data model (together with queries, measures and relationships) from one Excel file to another. I’ll also show you how you can setup a dedicated measures table that will be used by default. So every time you click to create a new measure, the separate measures table will be the default choice. Finally, you’ll learn the benefits of using Excel cube functions.

🌍 My Online Excel Courses β–Ί https://www.xelplus.com/courses/

00:00 3 Productivity Tips for Using Microsoft Excel Power Pivot
00:20 Easily Copy Your Data Model
02:49 Dedicated Measures Table
05:11 Use Cube Functions
08:31 Wrap Up

🎬 LINKS to related videos:
Excel Productivity for Lazy (but Smart) People: https://youtu.be/Gf4HmkR7_FE

πŸŽ’ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

πŸŽ“ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

πŸ“š Excel RESOURCES I Recommend: https://www.xelplus.com/resources/

πŸŽ₯ GEAR I use: https://www.xelplus.com/resources/#gear

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

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!

#MsExcel

Leave a Reply

Close Menu