Excel 2013? Yes - it's different! Really different. You will start out by signing in; but there is so much more to see once you are logged in. Follow along with Bill "MrExcel" Jelen in Episode #1588 as he begins a tour and review of the newest version of Microsoft 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:
Hey, everyone It’s Bill Jelen from MrExcel.
I have got Excel 2013 and I am sure you would like to see some of the cool things that are there.
So, this week, we're going to take a look at some cool features.
This episode is called Excel 2013, sign in.
Okay, well, the first thing that's different about Excel 2013 is that we actually sign in, right?
So, I've signed in.
I've connected all of my various services.
I've connected Flickr and YouTube and the SkyDrive, and, for Windows 8, Twitter and LinkedIn and all of that.
So, here's the amazing thing.
I'm down here on my laptop and this is not where I've been updating the books.
I've been updating the books up on the desktop with the big screens and the comfortable chair and everything, and so I'm down here in the studio, and what's amazing is it shows me some recent files and these are some files I just opened here a few minutes ago, but these files up here on the SkyDrive, these are files I've never opened in this computer.
They were opened up on the other computer, alright?
So, I'm signed in up there, I'm signed in up here, and if I'm saving things to the SkyDrive, I can work on it up there, come down here and work, and I can, you know, go somewhere else and work on it, and it's pretty wild that I can just walk from PC to PC and pick up right where I left off opening the same recent file.
So, it goes out and pulls it down from the SkyDrive.
Okay.
The first thing you're going to notice here is just the abundance of white.
It's white all over the place, right?
Big upper case tab names here which don't bother me at all but a lot of people were complaining about that, and just white, white, white.
What's up with the white?
Okay.
First off, there's going to be a version of this for tablet PCs [ that surface – 01:50 ] is going to have version of Excel and trying to touch this with the touch screen, they had to get rid of what they call the chrome.
The chrome is all the decoration that was back there in Excel 2010.
So, the chrome is gone.
This is a horrible, horrible theory but it's my theory.
When you're using a touchscreen, you get fingerprints on the screen.
The fingerprints don't show up on the white background like they do on the old thing, and, think about it, you're going to be touching these tabs over and over and over again.
I think the white’s there just for a better look.
Some people think I'm crazy but that's my theory and I'm sticking to it.
So, what have they added?
Well, all this week, we'll be looking at some things that they added.
Tomorrow, we'll take a look at the things that they added that are new for people who are new to Excel, the Don't Fear The Spreadsheet crowd, but, today, I [ have here – 02:44 ] opened up a list here of 66 functions that have been added to Excel, and a lot of these were added because of the [ open document standard – 02:54 ].
PDURATION and RRI.
Those are cool.
Just, you know, you have a rollover IRA, you left one job and you want to know what the actual equivalent interest rate is, you know.
So, 10 years ago it was this, now it's this.
What's the actual rate?
RRI does that.
Formula text is one that I love.
Arabic I think is absolutely hilarious.
All these trig functions.
I'm sure that Mike Girvin is going to love the fact that we now have the ability to do cosecant and secant, and…or is it secant?
It's been so long since I've been in math.
A few new statistical calculations.
You know, if you're a real geek, if you deal with binary at all, they've given us some BIT applications here in engineering.
A new one down here that you can barely see.
ISFORMULA.
ISFORMULA.
This is going to be cool for highlighting all of the formula cells, and then we could spend an entire week talking about the web category.
Those are absolutely amazing.
So, let's just run through a few of these real quick.
It is 2012 right now.
So, =ROMAN of this, 2012.
Has been around for a long, long time.
Well, now, they finally added a way to go back.
I think it's absolutely a hilarious.
=ARABIC will take Roman numbers and convert them back to Arabic.
I’ve been making fun of Roman for so long, right, and now the people at the [ open document spreadsheet consortium – 04:28 ] actually made them put Arabic in to go back.
Absolutely hilarious but the one that I love.
So, right now, you know, I'm updating Excel 2010 in depth which is 1100 pages all about Excel, and there's 300 pages there of going through every single function, and so I'm adding these 66, but I have 400 worksheets that demonstrate every single function, and in those worksheets, there's lots of formulas, and I would traditionally go in, edit the function, I would copy all the characters, CONTROL+C, go next to it, type an ‘, CONTROL+V, and then put that in italics so that way people could see what formulas I was using, alright, because I need to be able to see the results and the formulas at the same time.
This formula text, =FORMULATEXT, I'm not going to say it was made just for me but, oh man, it just made my life so much easier, and now, if this formula changes or if I insert a row or something like that, the formula text updates, right?
So, you know, right there, it changed.
It's a beautiful thing, the FORMULATEXT.
We’ll take some time and go through some of these other ones, but that, right now, is the one that is just making my life so much easier.
Now, stop back tomorrow and we're going to go through some of the new features that you probably have heard about, the ones that are there for people new to Excel, but then we'll go beyond that as well.
Well, hey.
I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
I have got Excel 2013 and I am sure you would like to see some of the cool things that are there.
So, this week, we're going to take a look at some cool features.
This episode is called Excel 2013, sign in.
Okay, well, the first thing that's different about Excel 2013 is that we actually sign in, right?
So, I've signed in.
I've connected all of my various services.
I've connected Flickr and YouTube and the SkyDrive, and, for Windows 8, Twitter and LinkedIn and all of that.
So, here's the amazing thing.
I'm down here on my laptop and this is not where I've been updating the books.
I've been updating the books up on the desktop with the big screens and the comfortable chair and everything, and so I'm down here in the studio, and what's amazing is it shows me some recent files and these are some files I just opened here a few minutes ago, but these files up here on the SkyDrive, these are files I've never opened in this computer.
They were opened up on the other computer, alright?
So, I'm signed in up there, I'm signed in up here, and if I'm saving things to the SkyDrive, I can work on it up there, come down here and work, and I can, you know, go somewhere else and work on it, and it's pretty wild that I can just walk from PC to PC and pick up right where I left off opening the same recent file.
So, it goes out and pulls it down from the SkyDrive.
Okay.
The first thing you're going to notice here is just the abundance of white.
It's white all over the place, right?
Big upper case tab names here which don't bother me at all but a lot of people were complaining about that, and just white, white, white.
What's up with the white?
Okay.
First off, there's going to be a version of this for tablet PCs [ that surface – 01:50 ] is going to have version of Excel and trying to touch this with the touch screen, they had to get rid of what they call the chrome.
The chrome is all the decoration that was back there in Excel 2010.
So, the chrome is gone.
This is a horrible, horrible theory but it's my theory.
When you're using a touchscreen, you get fingerprints on the screen.
The fingerprints don't show up on the white background like they do on the old thing, and, think about it, you're going to be touching these tabs over and over and over again.
I think the white’s there just for a better look.
Some people think I'm crazy but that's my theory and I'm sticking to it.
So, what have they added?
Well, all this week, we'll be looking at some things that they added.
Tomorrow, we'll take a look at the things that they added that are new for people who are new to Excel, the Don't Fear The Spreadsheet crowd, but, today, I [ have here – 02:44 ] opened up a list here of 66 functions that have been added to Excel, and a lot of these were added because of the [ open document standard – 02:54 ].
PDURATION and RRI.
Those are cool.
Just, you know, you have a rollover IRA, you left one job and you want to know what the actual equivalent interest rate is, you know.
So, 10 years ago it was this, now it's this.
What's the actual rate?
RRI does that.
Formula text is one that I love.
Arabic I think is absolutely hilarious.
All these trig functions.
I'm sure that Mike Girvin is going to love the fact that we now have the ability to do cosecant and secant, and…or is it secant?
It's been so long since I've been in math.
A few new statistical calculations.
You know, if you're a real geek, if you deal with binary at all, they've given us some BIT applications here in engineering.
A new one down here that you can barely see.
ISFORMULA.
ISFORMULA.
This is going to be cool for highlighting all of the formula cells, and then we could spend an entire week talking about the web category.
Those are absolutely amazing.
So, let's just run through a few of these real quick.
It is 2012 right now.
So, =ROMAN of this, 2012.
Has been around for a long, long time.
Well, now, they finally added a way to go back.
I think it's absolutely a hilarious.
=ARABIC will take Roman numbers and convert them back to Arabic.
I’ve been making fun of Roman for so long, right, and now the people at the [ open document spreadsheet consortium – 04:28 ] actually made them put Arabic in to go back.
Absolutely hilarious but the one that I love.
So, right now, you know, I'm updating Excel 2010 in depth which is 1100 pages all about Excel, and there's 300 pages there of going through every single function, and so I'm adding these 66, but I have 400 worksheets that demonstrate every single function, and in those worksheets, there's lots of formulas, and I would traditionally go in, edit the function, I would copy all the characters, CONTROL+C, go next to it, type an ‘, CONTROL+V, and then put that in italics so that way people could see what formulas I was using, alright, because I need to be able to see the results and the formulas at the same time.
This formula text, =FORMULATEXT, I'm not going to say it was made just for me but, oh man, it just made my life so much easier, and now, if this formula changes or if I insert a row or something like that, the formula text updates, right?
So, you know, right there, it changed.
It's a beautiful thing, the FORMULATEXT.
We’ll take some time and go through some of these other ones, but that, right now, is the one that is just making my life so much easier.
Now, stop back tomorrow and we're going to go through some of the new features that you probably have heard about, the ones that are there for people new to Excel, but then we'll go beyond that as well.
Well, hey.
I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
