Wow...well we all know that Bill's favorite bit in Microsoft Excel is the Pivot Table. Today, in Episode #1590, Bill highlights the changes and increased utility of Pivot Tables in Microsoft Excel 2013! Bill Looks at 'Data Models' Power Pivot, Creating Relationships in your Pivot Table, Power View and many other time saving, efficient functions in Excel 2013.
...This is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! Power Excel With MrExcel - 2017 Edition
"The Learn Excel from MrExcel Podcast Series"
Visit us: MrExcel.com for all of your Microsoft Excel Needs!
...This is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! Power Excel With MrExcel - 2017 Edition
"The Learn Excel from MrExcel Podcast Series"
Visit us: MrExcel.com for all of your Microsoft Excel Needs!
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Learn Excel From MrExcel Podcast, Excel 2013 Preview Pivot Tables.
Hey. Welcome back to the MrExcel netcast. I'm Bill Jelen.
Well, yesterday, we took a look at some of the things for people who are new to Excel.
You're going to love this if you're a pivot table fan.
So, INSERT, PIVOT TABLE, ADD THIS DATA TO THE DATA MODEL. DATA MODEL?
What’s a data model?
A data model is a really cool thing, lets us do Excel 2010 PowerPivot right inside of Excel 2013.
So, here is my data, right?
REGION, PRODUCT, DATE, CUSTOMER, and then I had a second dataset with sectors, and normally, yeah, do a VLOOKUP.
So, INSERT, PIVOT TABLE, ADD THIS DATA TO THE DATA MODEL, click OK, and now what we've done is we put 2 different worksheets in the pivot table.
I can come here and do a RELATIONSHIP, say we're going to create a new relationship that that first RANGE, CUSTOMER is tied to the second range, CUSTOMER, click OK, and now I can ask for not just the ACTIVE FIELDS but ALL FIELDS.
Check this out.
I have fields from both sets.
So, if I want to see total revenue by sector, I choose SECTOR, that's on worksheet two, and revenue from worksheet one, and it jams it all together.
That’s beautiful.
Another feature that they gave us in Excel 2010, we had [ unintelligible – 01:20 ] slicers in 2010, timelines in 2013.
So, this is like a slicer that is really good for date periods.
So, here it starts out by months.
I can see just the last 6 months of 2011, for example, or I can switch it over to quarters and choose which quarter I want to see, and it updates very, very quickly.
I like the timeline.
Very cool way to go.
Now, later in the year, we'll take a look at another feature that they gave us a called POWER VIEW.
POWER VIEW is going to let us take several pivot tables and pivot charts, and animate them all together, but that's going to be a feature for another day.
Well, hey.
I want to thank you for stopping by.
We’ll see you next time for another nectast from MrExcel.
Learn Excel From MrExcel Podcast, Excel 2013 Preview Pivot Tables.
Hey. Welcome back to the MrExcel netcast. I'm Bill Jelen.
Well, yesterday, we took a look at some of the things for people who are new to Excel.
You're going to love this if you're a pivot table fan.
So, INSERT, PIVOT TABLE, ADD THIS DATA TO THE DATA MODEL. DATA MODEL?
What’s a data model?
A data model is a really cool thing, lets us do Excel 2010 PowerPivot right inside of Excel 2013.
So, here is my data, right?
REGION, PRODUCT, DATE, CUSTOMER, and then I had a second dataset with sectors, and normally, yeah, do a VLOOKUP.
So, INSERT, PIVOT TABLE, ADD THIS DATA TO THE DATA MODEL, click OK, and now what we've done is we put 2 different worksheets in the pivot table.
I can come here and do a RELATIONSHIP, say we're going to create a new relationship that that first RANGE, CUSTOMER is tied to the second range, CUSTOMER, click OK, and now I can ask for not just the ACTIVE FIELDS but ALL FIELDS.
Check this out.
I have fields from both sets.
So, if I want to see total revenue by sector, I choose SECTOR, that's on worksheet two, and revenue from worksheet one, and it jams it all together.
That’s beautiful.
Another feature that they gave us in Excel 2010, we had [ unintelligible – 01:20 ] slicers in 2010, timelines in 2013.
So, this is like a slicer that is really good for date periods.
So, here it starts out by months.
I can see just the last 6 months of 2011, for example, or I can switch it over to quarters and choose which quarter I want to see, and it updates very, very quickly.
I like the timeline.
Very cool way to go.
Now, later in the year, we'll take a look at another feature that they gave us a called POWER VIEW.
POWER VIEW is going to let us take several pivot tables and pivot charts, and animate them all together, but that's going to be a feature for another day.
Well, hey.
I want to thank you for stopping by.
We’ll see you next time for another nectast from MrExcel.
