Excel Data Modeling - Stop Using XLOOKUP | Learn PowerPivot
Ok, so the boss wants you to connect lists in excel and is going to ask questions about the data. Most people would use complicated XLOOKUP, or VLOOKUP formulas to solve this. But let's see if there is a better way...
⌚*TIMESTAMPS*
0:00 Boss says connect these lists
0:26 Intro to Data Modeling and PowerPivot
1:03 Sample Data Walkthrough
2:31 Importing Data into PowerPivot
3:32 Understanding Table Relationships
4:19 Connecting lists (tables) in PowerPivot
5:53 Building Pivot Tables using the Data Model
6:55 Editing the Data Model
7:21 Creating Simple Calculations in PowerPivot
8:28 Bonus -- Adding a Second Pivot Table Using the Data Model
9:08 Connecting Multiple Files in PowerPivot
💾*SAMPLE DATA DOWNLOAD*
https://1drv.ms/u/c/a6a54ea252cde109/...
📢* FREE RESOURCES*
Mega Excel Keyboard Shortcut List
https://view.flodesk.com/pages/63bf31...
Quick Reference Guide
https://view.flodesk.com/pages/63bf2f...
☕*BUY ME A COFFEE?*
https://www.buymeacoffee.com/professo...
Смотрите видео Excel Data Modeling - Stop Using XLOOKUP | Learn PowerPivot онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Professor Cubs 01 Март 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 82,548 раз и оно понравилось 2.2 тысяч людям.