The Preview is Ending! Free Stuff! And Something New that you may not have seen in Excel 2013!
This is Bill's First Podcast about "Power View" - a New Feature in Excel 2013! This is very powerful dashboarding tool that is new to Excel for 2013. Note that Today's podcast stretches to 9 minutes because of the cool stuff we have to talk about today!
Also, The free preview download of Office365 is about to end. This is your 'Last' chance to try for FREE. Bill said early this morning that he is seeing the news stories on the Network news showing Office 2013, so it is here.
Finally, a Giveaway! Download your FREE Trial Version of Office365 today or tomorrow and send Bill a screenshot of the download.
First Prizes: $99 one-year subscription to Office 2013. There will be four first prizes, or 18 first prizes if I have the most downloads. These will be awarded by =RAND() on Feb 2 from all entries received by midnight Jan 31
Watch today's Podcast, Episode #1634, get all of the details and go to it!
*Special Note - Bill Says: "Because the First prize is 'so squirrelly'... is it 4 or is it 18?, I will also offer that the first 100 people to send in a download image will receive a FREE copy of Chris 'Smitty' Smith's book, 'Excel 2010 Business Basics & Beyond'. If you are in the USA, you will receive the print book; Outside the USA, the PDF Version."
This is a Win-Win!! Enter now...the Free Trial ends Midnight, January 31st, 2013!!
Microsoft marketing managed to get Office 2013 on the network news this morning, but all they could manage to show of Excel was the SkyDrive. Here is one of the amazing features in Excel 2013: Power View. In Episode 1634, I will show you how you can create dashboards with Power View. Also: today and tomorrow are the last day to download the 2013 free preview, so I am running a two-day contest where you can win a $99 annual subscription for Office 2013 on 5 computers, or Smitty's new Excel Business Basics Book.
This is Bill's First Podcast about "Power View" - a New Feature in Excel 2013! This is very powerful dashboarding tool that is new to Excel for 2013. Note that Today's podcast stretches to 9 minutes because of the cool stuff we have to talk about today!
Also, The free preview download of Office365 is about to end. This is your 'Last' chance to try for FREE. Bill said early this morning that he is seeing the news stories on the Network news showing Office 2013, so it is here.
Finally, a Giveaway! Download your FREE Trial Version of Office365 today or tomorrow and send Bill a screenshot of the download.
First Prizes: $99 one-year subscription to Office 2013. There will be four first prizes, or 18 first prizes if I have the most downloads. These will be awarded by =RAND() on Feb 2 from all entries received by midnight Jan 31
Watch today's Podcast, Episode #1634, get all of the details and go to it!
*Special Note - Bill Says: "Because the First prize is 'so squirrelly'... is it 4 or is it 18?, I will also offer that the first 100 people to send in a download image will receive a FREE copy of Chris 'Smitty' Smith's book, 'Excel 2010 Business Basics & Beyond'. If you are in the USA, you will receive the print book; Outside the USA, the PDF Version."
This is a Win-Win!! Enter now...the Free Trial ends Midnight, January 31st, 2013!!
Microsoft marketing managed to get Office 2013 on the network news this morning, but all they could manage to show of Excel was the SkyDrive. Here is one of the amazing features in Excel 2013: Power View. In Episode 1634, I will show you how you can create dashboards with Power View. Also: today and tomorrow are the last day to download the 2013 free preview, so I am running a two-day contest where you can win a $99 annual subscription for Office 2013 on 5 computers, or Smitty's new Excel Business Basics Book.
Transcript of the video:
Learn Excel from MrExcel podcast episode 1634: Power View.
Did you see the news this morning?
It's all over the news. Office 2013 coming out.
That means that very soon your chance to try Excel 2013 the preview ends.
So I know that it goes through at least through midnight January 31st 2013.
You got to try this out.
tinyurl.com/xl13preview.
It gives you a chance to try it before you can buy it.
Now, I've been negligent.
Microsoft a long time ago offered me some free annual subscriptions.
I'm guaranteed to get four if I have the most downloads from my site.
If MrExcel generates more downloads than the others, then I get 18 one-year licenses to give away.
All right, so how are we going to give these away?
They can't tell me who downloads it so go to tinyurl.com/xl13preview, download the Office 2013 trial and then shoot a screenshot.
Just use print screen or Snagit or whatever.
Send that to bill@MrExcel.com.
You have to send it before midnight January 31st 2013.
Then what we're going to do is we're going to do an =RAND() drawing from all the entries and I'm going to take those 4 or 18 one-year subscriptions.
That's a $99 value.
It’s good for 5 PCs and we’ll award those let's say February 1st, 2nd.
Let's do it Groundhog's Day, February 2nd, all right?
And then, you know-- so this is kind of-- I realized this is squirrely, right?
Am I doing 4, 18?
I really don't know.
So if you take the time to go ahead and download this, I will send you Chris Smith’s new Excel 2010 Business Basics and Beyond.
If you're in the USA, I'll send you a physical copy of the book.
If you’re outside of the USA, I'll send you an e-book and let's say we'll do that for the first hundred people which conceivably is everybody who tries this.
So there we go again.
Download it from tinyurl.com/xl13preview.
Screenshot to bill@MrExcel.com before January 31st 2013.
All right, today's episode is Power View.
I've done a lot about Excel 2013 but I haven't talked about Power View.
Why is that?
I was afraid, right?
I thought it was really complicated.
When you get right down to it, it's incredibly powerful and amazing to use.
It's a add-in that comes with Excel 2013 the Pro Plus version so if you have PowerPivot, you'll get Power View.
It allows us to create a dashboard.
So you see here we have sheets for fact, geography, products, dates and Power View it's just-- it's like another sheet in the workbook and we have the dashboard view over here, the field list over here and then optionally we have a filter pane that can come and go.
We can have these tiny little tiles.
We can click this icon to pop the tile out.
Pop out.
So here is an XY chart with lots of information going on.
Down the left-hand side is the list price of the book, across the bottom is the page count of the book.
The color of the dot tells us what version it's written-- written about and then the size is revenue in this hypothetical data set.
Across the bottom we have a play axis that is based on year.
So now watch this.
This is so wild.
I'm going to click Play and we'll actually get to see this data change over time.
So here's 2008.
The 2007 books are coming on strong.
Let it go, let it go, there's the first 2010 books showing up and then again hypothetical data set going out into the future showing in the 2013 books.
Isn't that cool?
I can take the slider and look at any individual year and this is just one of the things that Power View can do.
Let me minimize this again or just pop in.
They call it pop in pop out.
What a strange word.
So I'm going to go to the Geography and let's choose perhaps State and I'll drag State.
This creates a brand new tile here and initially all of the tiles are going to show up as just a regular old table.
That's the way that every new tile shows up in Power View but that's okay.
Now let's go to the fact table and find revenue.
Seeing because that was the active tile, I just check mark it.
There it goes.
Beautiful, right?
Now, this is a boring old table.
I could just scroll through it yes, yes, yes, but let's change it to a map.
So these are the things we can take it from: a table matrix or card view, bar chart, column chart, other chart or a map.
All right now, one really frustrating thing, the table started out small and so then the map starts out small but you can always resize or you can always pop out.
All right, so there they took all of my data and put it on a map.
If I had chosen City instead of State, let's try that.
So we'll take State out and in my Geography table find City.
Put that there.
All right, see it takes a little bit of time for geocode to find all the cities and so big sales in New York, LA.
There we go.
It’s still geocoding, geocoding, geocoding.
Isn’t that cool?
Even some places up in Canada are popping out and that's crazy.
Now it's getting some spots in Europe.
So it's not just a US-centric thing and again we can pop in.
So we can have all of these different little tiles here on the Power View sheet and you know-- very clever now.
How is this data getting into Excel?
Well, Power View which by the way has a space, Power space View, uses PowerPivot without a space.
So I had here a large data set.
This was 400,000 records, 411,000 records of you know, my fact table and it had ProductID, GeoID, and so on.
So I have my little lookup tables here and I put all of this into PowerPivot and created relationships between them but the most important thing if you're going to use Power View is that we need to go and specify certain columns as being-- let's call them special.
All right, so here under State on the Advanced tab there's a Data Category and I went through very carefully all of my columns and declared things to be-- well, actually anything that's in this list, all right, so State or Province for City, I call it a city.
Anything you have that matches one of these go ahead and use this and this is used by Power View to know if it can be mapped or not mapped.
There's even-- let's see on Products, there we go, yes.
So there was an image path, all right, and unfortunately this is pointing to images on another computer but you put the image path in there and then you can actually show product pictures right in your Power View table.
Now again this comes with Excel 2013 Pro Plus.
It was out if you had SharePoint you know back in the 2010 timeframe but it now becomes a tool for Excel 2013.
You know and as I said at the beginning, I shied away from showing this on the podcast because it seemed very intimidating but I've written a chapter in three books now about Power View and it just-- it works.
I mean this is a huge data set.
411,000 records with three links to other tables and maps and pictures and the thing has just been so easy to work with.
Absolutely amazing great little feature.
Might-- hang on, one more-- one more complaint I guess that I have with Power View is when you're in various elements here in Power View the tabs to the right of Power View, so Design and Layout, those are Power View tabs and they're not labeled as such.
It doesn't say Power View Design and Power View Layout.
I don't know why.
These tabs come and go depending on what's selected and so you just have to look for the Power View tab and then anything to the right of it up to either Inquire or PowerPivot is actually a Power View tab.
A little bit confusing but beyond that, just an amazing feature.
There's more than we can talk about.
There's tiles, vertical model boards, horizontal model boards.
We'll have to get back to that but I wanted to show you this.
You know as I was watching the news this morning, you know they're clicking around showing the Sky Drive and they're not getting to any of the good features at all.
You know this is the place you can come to get those good, good, features.
Wow, this has gone on way too long.
I'm going to quit talking.
Remember there's two more days; January 30th, January 31st.
You can try Excel 2013 for free.
tinyurl.com/xl13preview.
Send me a screenshot that shows you downloaded it and I'll share the love.
All of this either 4 or 18 one-year subscription.
That's $99 value.
We'll do that using =RAND() and then anyone else who tries it I'll send you a copy of Excel 2010 Business Basics and Beyond by Smitty.
If you use the MrExcel message board, you'll recognize Smitty is one of our most valuable posters there at MrExcel.
All right. Hey, I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
Did you see the news this morning?
It's all over the news. Office 2013 coming out.
That means that very soon your chance to try Excel 2013 the preview ends.
So I know that it goes through at least through midnight January 31st 2013.
You got to try this out.
tinyurl.com/xl13preview.
It gives you a chance to try it before you can buy it.
Now, I've been negligent.
Microsoft a long time ago offered me some free annual subscriptions.
I'm guaranteed to get four if I have the most downloads from my site.
If MrExcel generates more downloads than the others, then I get 18 one-year licenses to give away.
All right, so how are we going to give these away?
They can't tell me who downloads it so go to tinyurl.com/xl13preview, download the Office 2013 trial and then shoot a screenshot.
Just use print screen or Snagit or whatever.
Send that to bill@MrExcel.com.
You have to send it before midnight January 31st 2013.
Then what we're going to do is we're going to do an =RAND() drawing from all the entries and I'm going to take those 4 or 18 one-year subscriptions.
That's a $99 value.
It’s good for 5 PCs and we’ll award those let's say February 1st, 2nd.
Let's do it Groundhog's Day, February 2nd, all right?
And then, you know-- so this is kind of-- I realized this is squirrely, right?
Am I doing 4, 18?
I really don't know.
So if you take the time to go ahead and download this, I will send you Chris Smith’s new Excel 2010 Business Basics and Beyond.
If you're in the USA, I'll send you a physical copy of the book.
If you’re outside of the USA, I'll send you an e-book and let's say we'll do that for the first hundred people which conceivably is everybody who tries this.
So there we go again.
Download it from tinyurl.com/xl13preview.
Screenshot to bill@MrExcel.com before January 31st 2013.
All right, today's episode is Power View.
I've done a lot about Excel 2013 but I haven't talked about Power View.
Why is that?
I was afraid, right?
I thought it was really complicated.
When you get right down to it, it's incredibly powerful and amazing to use.
It's a add-in that comes with Excel 2013 the Pro Plus version so if you have PowerPivot, you'll get Power View.
It allows us to create a dashboard.
So you see here we have sheets for fact, geography, products, dates and Power View it's just-- it's like another sheet in the workbook and we have the dashboard view over here, the field list over here and then optionally we have a filter pane that can come and go.
We can have these tiny little tiles.
We can click this icon to pop the tile out.
Pop out.
So here is an XY chart with lots of information going on.
Down the left-hand side is the list price of the book, across the bottom is the page count of the book.
The color of the dot tells us what version it's written-- written about and then the size is revenue in this hypothetical data set.
Across the bottom we have a play axis that is based on year.
So now watch this.
This is so wild.
I'm going to click Play and we'll actually get to see this data change over time.
So here's 2008.
The 2007 books are coming on strong.
Let it go, let it go, there's the first 2010 books showing up and then again hypothetical data set going out into the future showing in the 2013 books.
Isn't that cool?
I can take the slider and look at any individual year and this is just one of the things that Power View can do.
Let me minimize this again or just pop in.
They call it pop in pop out.
What a strange word.
So I'm going to go to the Geography and let's choose perhaps State and I'll drag State.
This creates a brand new tile here and initially all of the tiles are going to show up as just a regular old table.
That's the way that every new tile shows up in Power View but that's okay.
Now let's go to the fact table and find revenue.
Seeing because that was the active tile, I just check mark it.
There it goes.
Beautiful, right?
Now, this is a boring old table.
I could just scroll through it yes, yes, yes, but let's change it to a map.
So these are the things we can take it from: a table matrix or card view, bar chart, column chart, other chart or a map.
All right now, one really frustrating thing, the table started out small and so then the map starts out small but you can always resize or you can always pop out.
All right, so there they took all of my data and put it on a map.
If I had chosen City instead of State, let's try that.
So we'll take State out and in my Geography table find City.
Put that there.
All right, see it takes a little bit of time for geocode to find all the cities and so big sales in New York, LA.
There we go.
It’s still geocoding, geocoding, geocoding.
Isn’t that cool?
Even some places up in Canada are popping out and that's crazy.
Now it's getting some spots in Europe.
So it's not just a US-centric thing and again we can pop in.
So we can have all of these different little tiles here on the Power View sheet and you know-- very clever now.
How is this data getting into Excel?
Well, Power View which by the way has a space, Power space View, uses PowerPivot without a space.
So I had here a large data set.
This was 400,000 records, 411,000 records of you know, my fact table and it had ProductID, GeoID, and so on.
So I have my little lookup tables here and I put all of this into PowerPivot and created relationships between them but the most important thing if you're going to use Power View is that we need to go and specify certain columns as being-- let's call them special.
All right, so here under State on the Advanced tab there's a Data Category and I went through very carefully all of my columns and declared things to be-- well, actually anything that's in this list, all right, so State or Province for City, I call it a city.
Anything you have that matches one of these go ahead and use this and this is used by Power View to know if it can be mapped or not mapped.
There's even-- let's see on Products, there we go, yes.
So there was an image path, all right, and unfortunately this is pointing to images on another computer but you put the image path in there and then you can actually show product pictures right in your Power View table.
Now again this comes with Excel 2013 Pro Plus.
It was out if you had SharePoint you know back in the 2010 timeframe but it now becomes a tool for Excel 2013.
You know and as I said at the beginning, I shied away from showing this on the podcast because it seemed very intimidating but I've written a chapter in three books now about Power View and it just-- it works.
I mean this is a huge data set.
411,000 records with three links to other tables and maps and pictures and the thing has just been so easy to work with.
Absolutely amazing great little feature.
Might-- hang on, one more-- one more complaint I guess that I have with Power View is when you're in various elements here in Power View the tabs to the right of Power View, so Design and Layout, those are Power View tabs and they're not labeled as such.
It doesn't say Power View Design and Power View Layout.
I don't know why.
These tabs come and go depending on what's selected and so you just have to look for the Power View tab and then anything to the right of it up to either Inquire or PowerPivot is actually a Power View tab.
A little bit confusing but beyond that, just an amazing feature.
There's more than we can talk about.
There's tiles, vertical model boards, horizontal model boards.
We'll have to get back to that but I wanted to show you this.
You know as I was watching the news this morning, you know they're clicking around showing the Sky Drive and they're not getting to any of the good features at all.
You know this is the place you can come to get those good, good, features.
Wow, this has gone on way too long.
I'm going to quit talking.
Remember there's two more days; January 30th, January 31st.
You can try Excel 2013 for free.
tinyurl.com/xl13preview.
Send me a screenshot that shows you downloaded it and I'll share the love.
All of this either 4 or 18 one-year subscription.
That's $99 value.
We'll do that using =RAND() and then anyone else who tries it I'll send you a copy of Excel 2010 Business Basics and Beyond by Smitty.
If you use the MrExcel message board, you'll recognize Smitty is one of our most valuable posters there at MrExcel.
All right. Hey, I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
