Today Bill moves along with his Excel 2013 Preview by addressing Users New to Excel and Excel 2013. Starting in the Microsoft Excel Preview Pane, Highlighting the availability of features now accessible via Excel. For instance, the New Feature 'Flash Fill' allows you to bypass =PROPER! There are more 'preview' panes, so that you can see what your Chart would look like in a given configuration! Too much to list so... Even if you're an Excel Veteran, you will really appreciate this week's series on Microsoft Excel 2013. So following along with Bill in Episode #1589 let's see what's New in Excel 2013! This is Part II of V.
Also, for New Excel Users, MrExcel Offers "Don't Fear The Spreadsheet" by Tyler Nash, Kevin Jones, Tom Urtis and Bill Jelen. Many 'Beginner Oriented' Excel How-To books say they can bring you from zero to familiar with the important features of Microsoft Excel -- 'Don't Fear The Spreadsheet' actually will. Why are we so confident? Because the questions in this book were asked by an absolute Excel Beginner -- Tyler Nash -- with the answers provided by three (3) Microsoft MVPs specializing in and dedicated to teaching others Microsoft Excel, from the ground up -- Kevin Jones, Tom Urtis and Bill Jelen
"The Learn Excel from MrExcel Podcast Series"
Visit us: MrExcel.com for all of your Microsoft Excel Needs!
Also, for New Excel Users, MrExcel Offers "Don't Fear The Spreadsheet" by Tyler Nash, Kevin Jones, Tom Urtis and Bill Jelen. Many 'Beginner Oriented' Excel How-To books say they can bring you from zero to familiar with the important features of Microsoft Excel -- 'Don't Fear The Spreadsheet' actually will. Why are we so confident? Because the questions in this book were asked by an absolute Excel Beginner -- Tyler Nash -- with the answers provided by three (3) Microsoft MVPs specializing in and dedicated to teaching others Microsoft Excel, from the ground up -- Kevin Jones, Tom Urtis and Bill Jelen
"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, Office Excel 2013 Preview Excel 2013 For Rookies.
Hey. Welcome back. It's Bill Jelen from MrExcel.
I said, all week we’d be taking a look at some of the new features in Excel 2013, and so first I’m going to come here and go to recent files.
Alright.
Hey, big difference now.
We have a list of RECENT WORKBOOKS, we have a COMPUTER which gets me to my recent folders, but we have the SkyDrive now, so, remember, when you sign in, so it's very easy to open things from all 3.
Now, it irritates me just a tiny bit, just a tiny bit, that I have to click COMPUTER and then ZIP102 or AAA to get to my folder.
I used to be able to click the folder right away.
I loved that feature in 2010 and they made it one click further away, but, hey, I'm not going to complain about that.
Well, I am, I just did, but I can live with it, alright?
Alright, so, features for people who are completely new to Excel.
This is an example I use all the time.
We want to join first name and last name over in column D and I always make fun of the people who start to type, right, rather than use =PROPER(A2&“space”&B2).
You know, I make fun of those people.
Oh my gosh.
This is absolutely amazing.
Watch.
When someone sits down and starts doing something really, really bad, it lets you do the first one.
As soon as I type the P in Paul, can you see it?
Can you see it?
They say, hey, we think this is what you want to do.
I just press ENTER.
The whole thing is done.
Is that amazing or what?
It's called flash fill.
It's called flash fill and they don't put formulas there.
They actually just…they put the actual text, and so…let's…if I would just come through here and do THOMAS S, like that, alright, they get the first one.
PAUL M. They figured it out.
Bam, right down the line.
[ =PROPER(A2&“ ”&B2) ] It's pretty wild, and, also, if you're splitting text apart, the example that they gave is movies and genre all in one cell, and you start typing the movie, and it has amazing heuristics here that will get it right, and if there's a few that it doesn't get right, like, down here, CONRAD, if I retype L., it'll go through and look for others that had a similar problem and fix those as well, alright?
So, a great feature for people who are new to Excel.
Here's another one.
Here's a big model.
There's a bunch of formulas in this model.
When I change this RENT number, a lot of other things in the worksheet will change, but, before, it happened so fast, you couldn't really tell.
Now, they do something called slot machining.
So, I'm going to type 3600 here and don't watch the 3600.
Watch the other sales and you're going to see them actually animate in.
They only do this on the first screen full of data, they don't do all million rows, but just the things you can see so that way we can say, hey, oh, there's things changing when I change that number, alright?
I’m going to click in 3, 2, 1.
Now.
Did you see it?
Boy, I hope the frame rate caught that.
I saw a whole bunch of cells change down here and so on.
Really, really cool that is there.
That is a visual clue for people who are new to Excel.
Another thing they added for us, for people who are new to Excel, is people don't know how to do any data analysis.
You know, when you say to someone, oh, hey, do a pivot table, they're like, oh no, no, no, no.
I don't want to do a pivot table.
That sounds too scary to me, alright?
So, the quick analysis lens down here is offering FORMATTING, CHARTS, TOTALS, TABLES, AND SPARKLINES, alright?
So, it pops up.
You know, let's do a COLOR SCALE.
Oh wow, that looks good, or maybe an ICON SET.
Look how cool that is, or highlight the top 10%.
TOTALS.
We want to add a SUM total at the bottom, or you scroll over here, the good ones are over here, the SUM total at the right hand side, and you can see what it’s going to look like before you do it.
CHARTS.
They have some recommended charts.
So, here's a clustered column chart.
Do you want that or do you want that or do you want that or do you want that?
What's that?
Alright?
TABLES.
What's up here?
It's not…it's only offering me a BLANK PIVOTTABLE.
I guess it doesn't have enough data.
Let me come out and try this again here.
We'll select all this data, CONTROL+*, and try the data analysis, go to TABLES.
There we go.
Okay.
So, here, there are going to be selected pivot tables and you can see a little picture of each one before you do it.
Is that wild?
So, there, summary of revenue by product, summary of profit, revenue, and quantity by product, summary of profit by region.
Is this wild?
You don't have to know anything.
Just open the drop-down and choose it, and, bam, you get a pivot table.
These features are fabulous for people who are new to Excel.
Again, the Don't Fear The Spreadsheet crowd, Tyler, and all of her friends are going to love these new features in Excel.
Hey, but don't despair.
There's plenty of good stuff for the Excel pros and we’ll take a look at that tomorrow.
Well, hey.
I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
[ Oh, they’re not doing it for us – 05:32 ].
Alright.
Back here to INSERT, RECOMMENDED PIVOT TABLES.
Awesome.
Learn Excel From MrExcel Podcast, Office Excel 2013 Preview Excel 2013 For Rookies.
Hey. Welcome back. It's Bill Jelen from MrExcel.
I said, all week we’d be taking a look at some of the new features in Excel 2013, and so first I’m going to come here and go to recent files.
Alright.
Hey, big difference now.
We have a list of RECENT WORKBOOKS, we have a COMPUTER which gets me to my recent folders, but we have the SkyDrive now, so, remember, when you sign in, so it's very easy to open things from all 3.
Now, it irritates me just a tiny bit, just a tiny bit, that I have to click COMPUTER and then ZIP102 or AAA to get to my folder.
I used to be able to click the folder right away.
I loved that feature in 2010 and they made it one click further away, but, hey, I'm not going to complain about that.
Well, I am, I just did, but I can live with it, alright?
Alright, so, features for people who are completely new to Excel.
This is an example I use all the time.
We want to join first name and last name over in column D and I always make fun of the people who start to type, right, rather than use =PROPER(A2&“space”&B2).
You know, I make fun of those people.
Oh my gosh.
This is absolutely amazing.
Watch.
When someone sits down and starts doing something really, really bad, it lets you do the first one.
As soon as I type the P in Paul, can you see it?
Can you see it?
They say, hey, we think this is what you want to do.
I just press ENTER.
The whole thing is done.
Is that amazing or what?
It's called flash fill.
It's called flash fill and they don't put formulas there.
They actually just…they put the actual text, and so…let's…if I would just come through here and do THOMAS S, like that, alright, they get the first one.
PAUL M. They figured it out.
Bam, right down the line.
[ =PROPER(A2&“ ”&B2) ] It's pretty wild, and, also, if you're splitting text apart, the example that they gave is movies and genre all in one cell, and you start typing the movie, and it has amazing heuristics here that will get it right, and if there's a few that it doesn't get right, like, down here, CONRAD, if I retype L., it'll go through and look for others that had a similar problem and fix those as well, alright?
So, a great feature for people who are new to Excel.
Here's another one.
Here's a big model.
There's a bunch of formulas in this model.
When I change this RENT number, a lot of other things in the worksheet will change, but, before, it happened so fast, you couldn't really tell.
Now, they do something called slot machining.
So, I'm going to type 3600 here and don't watch the 3600.
Watch the other sales and you're going to see them actually animate in.
They only do this on the first screen full of data, they don't do all million rows, but just the things you can see so that way we can say, hey, oh, there's things changing when I change that number, alright?
I’m going to click in 3, 2, 1.
Now.
Did you see it?
Boy, I hope the frame rate caught that.
I saw a whole bunch of cells change down here and so on.
Really, really cool that is there.
That is a visual clue for people who are new to Excel.
Another thing they added for us, for people who are new to Excel, is people don't know how to do any data analysis.
You know, when you say to someone, oh, hey, do a pivot table, they're like, oh no, no, no, no.
I don't want to do a pivot table.
That sounds too scary to me, alright?
So, the quick analysis lens down here is offering FORMATTING, CHARTS, TOTALS, TABLES, AND SPARKLINES, alright?
So, it pops up.
You know, let's do a COLOR SCALE.
Oh wow, that looks good, or maybe an ICON SET.
Look how cool that is, or highlight the top 10%.
TOTALS.
We want to add a SUM total at the bottom, or you scroll over here, the good ones are over here, the SUM total at the right hand side, and you can see what it’s going to look like before you do it.
CHARTS.
They have some recommended charts.
So, here's a clustered column chart.
Do you want that or do you want that or do you want that or do you want that?
What's that?
Alright?
TABLES.
What's up here?
It's not…it's only offering me a BLANK PIVOTTABLE.
I guess it doesn't have enough data.
Let me come out and try this again here.
We'll select all this data, CONTROL+*, and try the data analysis, go to TABLES.
There we go.
Okay.
So, here, there are going to be selected pivot tables and you can see a little picture of each one before you do it.
Is that wild?
So, there, summary of revenue by product, summary of profit, revenue, and quantity by product, summary of profit by region.
Is this wild?
You don't have to know anything.
Just open the drop-down and choose it, and, bam, you get a pivot table.
These features are fabulous for people who are new to Excel.
Again, the Don't Fear The Spreadsheet crowd, Tyler, and all of her friends are going to love these new features in Excel.
Hey, but don't despair.
There's plenty of good stuff for the Excel pros and we’ll take a look at that tomorrow.
Well, hey.
I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
[ Oh, they’re not doing it for us – 05:32 ].
Alright.
Back here to INSERT, RECOMMENDED PIVOT TABLES.
Awesome.
