MSPTDA 13: Power Pivot Introduction #1: Relationships rather than VLOOKUP for PivotTable Report
Download Excel START File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/013-MSPTDA-RelationshipsRatherThanVLOOKUPStart.xlsx
Download Excel FINISHED File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/013-MSPTDA-RelationshipsRatherThanVLOOKUPFinished.xlsx
Download Example of Large File Size using VLOOKUP: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/013-PivotTablesVLOOKUPFinished.xlsm
Download pdf Notes: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/013-MSPTDA-RelationshipsRatherThanVLOOKUP.pdf
Assigned Homework:
Download Excel file and complete the homework:
https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/013-HomeworkStart.xlsx
Examples of Finished Homework:
https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/013-HomeworkFinished.xlsx
This video introduces Excel Power Pivot and shows how to use the Relationship feature rather than VLOOKUP Function to reduce file size and allow user to pull fields for a PivotTable Report from Multiple Tables.
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.
Topics:
1. (00:15) Introduction
2. (01:43) Look at VLOOKUP solution
3. (02:49) Introduction to What Is Power Pivot? Discuss what a Data Model is.
4. (05:46) Relationship feature
5. (09:16) Create PivotTable Report
6. (11:45) First Look at Implicit Measures
7. (13:02) Enable the Power Pivot Ribbon Tab
8. (13:37) First Look at Power Pivot Window and Data Model
9. (20:30) Summary
Видео MSPTDA 13: Power Pivot Introduction #1: Relationships rather than VLOOKUP for PivotTable Report канала excelisfun
Download Excel FINISHED File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/013-MSPTDA-RelationshipsRatherThanVLOOKUPFinished.xlsx
Download Example of Large File Size using VLOOKUP: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/013-PivotTablesVLOOKUPFinished.xlsm
Download pdf Notes: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/013-MSPTDA-RelationshipsRatherThanVLOOKUP.pdf
Assigned Homework:
Download Excel file and complete the homework:
https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/013-HomeworkStart.xlsx
Examples of Finished Homework:
https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/013-HomeworkFinished.xlsx
This video introduces Excel Power Pivot and shows how to use the Relationship feature rather than VLOOKUP Function to reduce file size and allow user to pull fields for a PivotTable Report from Multiple Tables.
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.
Topics:
1. (00:15) Introduction
2. (01:43) Look at VLOOKUP solution
3. (02:49) Introduction to What Is Power Pivot? Discuss what a Data Model is.
4. (05:46) Relationship feature
5. (09:16) Create PivotTable Report
6. (11:45) First Look at Implicit Measures
7. (13:02) Enable the Power Pivot Ribbon Tab
8. (13:37) First Look at Power Pivot Window and Data Model
9. (20:30) Summary
Видео MSPTDA 13: Power Pivot Introduction #1: Relationships rather than VLOOKUP for PivotTable Report канала excelisfun
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Highline College Busn 218 Advanced Excel Fall, 2024 IntroductionHighline College Busn 210 Excel Statistical Analysis Fall, 2024 IntroductionYTL Excel #130: Income Statement from Excel Table: Array ForExcel Finance Class 74: IRR and Non-conventional Cash Flows, Plot Chart To See Multiple IRRCtrl + Shift + Enter: Excel Array Formulas #05: Function Argument Array OperationsFree Data Analysis Class: Intro to PivotTable, Power Query, Power Pivot, Power BI & Big DataIntroduction to the excelisfun Channel @ YouTube: Excel & Power BI Videos & Free Classes_Store Full Table to One Column? Excel Power Query Puts Records in One Cell! Excel Magic Trick1734.Power Query Running Count with Grouping & Add Index - Excel Magic Trick 1589Power Query to Import Excel File From OneDrive SharePoint into PivotTable, Refresh New Data EMT 1756Excel 2013 Statistical Analysis #5 Data Categorical, Quantitative, Nominal, Ordinal, Interval, RatioMSPTDA #02: Data Analysis Business Intelligence Terms: Microsoft Power Tools for Data Analysis Classexcelisfun’s new book The Only App That Matters Book is Released!!! Microsoft 365 Excel = The Best!MSPTDA 12: Using Locale in Power Query Power BI: Import & Append Text Files from Different CountriesSpilled Array Formulas Make Excel Life Easy. Compare Two Lists Extract Items Excel Magic Trick 1750MSPTDA 14: Power Pivot Intro #2: Amazing Columnar Database Importing Millions of Rows Data to ExcelMSPTDA 21: Power Query: Reduce Data Model Size, Transformations to Columnar Database SizeOffice 2013 Class #37: Excel Basics 19: SUMIFS, COUNTIFS: Add & Count with Criteria/ConditionsHighline Excel 2013 Class Video 05: Cell References: Relative, Absolute & Mixed (8 Examples)INDEX & MATCH or XLOOKUP for Lookup Formula in SUMIFS Criteria Argument. Excel Magic Trick 1668.E-DAB 09: Power BI Desktop: Data Modeling & Interactive Visualizations