Channel: Leila Gharani

Category: Education

Tags: excel tips and trickspivot table excelcube formulas exceldata modellingmeasures tablemicrosoft excel tutorialscopy data model excelexcel for analystsconvert pivot table to formulasmicrosoft excelpowerpivotpower pivotxelplusvisleila gharaniadvanced excel tricksexcel 2016excel 2019xelplusmicrosoft 365excel 2013excel online courseexcel measuresexcel 365cube functions

Description: Get Access to the Course: 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 ► 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 Blog post: xelplus.com/3-hidden-tips-for-power-pivot 🎬 LINKS to related videos: Excel Productivity for Lazy (but Smart) People: youtu.be/Gf4HmkR7_FE 🎒 Get the Official XelPlus MERCH: xelplus.creator-spring.com 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz 📚 Excel RESOURCES I Recommend: xelplus.com/resources 🎥 GEAR I use: xelplus.com/resources/#gear More resources on my Amazon page: amazon.com/shop/leilagharani Let’s connect on social: Instagram: instagram.com/lgharani Twitter: twitter.com/leilagharani LinkedIn: 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