Loading formats...
create sets based on column items - Pivot tables v's Power Pivot
E
E-learningEducators
359 views • Apr 04, 2014
Description
Hi, my name is Paula and I am the course writer and presenter of The Excel Club. In this video I will show you how to use power pivot to do something pivot tables can not do. Create sets based on column items.
Have you ever tried to remove columns or even rows from a pivot table but the filter option is just not working for you. If you run your data through Power Pivot, you can use the Create sets based on column items to select the columns shown in the Pivot tables.
Power Pivot is a FREE MS application available in Excel 2010.
Have you ever tried to remove columns or even rows from a pivot table but the filter option is just not working for you. If you run your data through Power Pivot, you can use the Create sets based on column items to select the columns shown in the Pivot tables.
Power Pivot is a FREE MS application available in Excel 2010.
Discover more
More from this user
11:25
youtube boolean logic and array formula
E-learningEducators
03:40
create sets based on column items - Pivot tables v's Power Pivot
E-learningEducators
Related videos
19:22
MS Excel _ Style as Table _ Pivot Tables _ Pivot Charts
U Knowledge Center
15:19
How to Create a Dashboard Using Pivot Tables and Charts in Excel - Part 3
Alaina Sharpe
00:39
Excel: Pivot Tables & Charts (Quick Study Computer) For Kindle
MariaMStewart
00:23
About for Book Power Excel With MrExcel 2017: Master Pivot Tables, Subtotals, Visualizations,
nekmev
00:04
READ ONLINE Power Excel with MrExcel 2017 Edition Master Pivot Tables Subtotals Visualizations
Emildeluxe 3e
00:46
Most useful trick in Microsoft excel specific,pivot tables and vlookup function in excel in excel for beginners No. 38
Amazing Tricks