Рет қаралды 79,246
★ Want to automate Excel? Check out our training academy ★
exceloffthegrid.com/academy
★ Download the example file:★
exceloffthegrid.com/combining...
★ About this video ★
When most people use PivotTables, they copy the source data into a worksheet, then carry out a lot of VLOOKUPs to get the categorization columns into the data set. After that, the data is ready, we can create a PivotTable, and the analysis can start.
But we don’t need to do all those VLOOKUPs anymore. Instead, we can build relationships that combine multiple tables and automatically create the lookups for us.
In this video, I will show you how :-)
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: exceloffthegrid.com
Twitter: / exceloffthegrid
#MsExcel #PivotTables #PowerPivot