Excel now debuts a new Home screen in the File menu - it is a combination of the existing New and Open screens. Also - the icons on the Ribbon are changing for those using Office 365.
To download this workbook: https://www.mrexcel.com/download-center/2018/08/new-ribbon-and-help-screen.xlsx
List of upcoming seminars: Excel Seminar Schedule
To download this workbook: https://www.mrexcel.com/download-center/2018/08/new-ribbon-and-help-screen.xlsx
List of upcoming seminars: Excel Seminar Schedule
Transcript of the video:
Learn Excel from MrExcel Podcast, Episodes 2238: New Ribbon and New Home Screen.
If you like what you see in this video, please subscribe and ring that bell.
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Two things have changed here in the summer of 2018.
First off, when you open Excel or go to the File menu, we get this new thing called the Home Screen.
It's early now, it's before 6 A.M. so it's wishing me a good morning.
I'm sure that changes, you know.
I wish if you were here like at 1:30 in the morning it’d say, like, What the heck are you doing awake at this time?
But good morning.
And then Home-- and what Home seems to be, is it seems to be a weird combination of both New and Open.
So, here at the top above the line, is what I call New-- so, Blank Workbook, and then some of the templates that they have.
And if you wanted to get to all of the templates you can either click New or go to More Templates.
And I'll take you to the New screen, and then below that, some sort of weird version of the Open screen that shows you the recent files-- the pin files shared with me, but not, you know, recent folders.
And if you would scroll all the way down beneath these, then you get two more workbooks, which is essentially the open screen so, you know, that's the old New screen with lots of templates.
That's the old Open screen with a chance to get the folders and choose places.
Home just seems to be a weird combination of those.
And again, it's going to open to here when you open Excel.
It's going to open to here when you go to the file menu.
Alright?
So that's one new thing.
The other thing that's new-- let me just create a new workbook here so it's less, it's less jarring-- is they have redrawn the icons and, I have to tell you, I've seen these for a while.
I can't say that I hate them and I can't say that I love them.
It frankly looks like we're de-evolving-- we're regressing backwards, you know.
So just to see a combination here-- here's the Insert tab in Excel-- From the new icons to what we had in Excel 2016, right?
And, like, let's just take a look at this Pictures icon here-- the mountain used to be filled in in blue and now it's just an outline, the Sun used to be yellow and now our Sun just turned black.
It just looks like some definition has been lost.
And it really seems like it's we're going in that direction.
If we go back to Office 2013 or even back to Office 2010, in office 2010 it looked like a little Polaroid photo, two mountains, a Sun, the Sun had an outline; SmartArt here had a glow, and then we lose the glow and it's just getting less.
Although, I guess... you know, we used to have a 3D Pie chart and now it's just a flat Pie chart.
So, hey, let me know what you think down in the YouTube comments.
What do you think of these new icons?
Do you like the old icons or the new icons or you just don't care?
And if you like the old icons, give me some words to describe what they did here.
What happened?
How did we lose definition?
Like, even, you know, the table doesn't look as much like a table, and the recommended pivot tables used to have data in the values area and now its blank.
Another big change here is, it used to be that when you selected various tabs in the ribbon the tab changed colors and you had a line out of three sides, and that when we change tabs in the ribbon, it's just the line at the bottom of the tab.
I mean, you can barely, barely make out there that it's a different color, but it's, you know, like gray and just a tiny bit lighter gray, but I preferred when it actually looked like a tab.
You know, I noticed that this new tab designator here, the underline has been around for a while.
If you have a data model pivot table, the Active and All, I've been using that even longer than the ribbon has, so, you know, they had this in the works, I guess, when they planned it.
Leave a note out in the YouTube comments, let me know what you think about this.
Between us, if you buy Excel 2019, you're going to get the old version.
The big news today is the new Home category of the File menu, or when you open Excel.
Well, hey, all of this is of course in my new book, "Microsoft Excel 2019 Inside Out." Today, a new Home screen and the File menu, accommodation of New and Open, and then the new ribbon illustrations-- just, really either hate them or love them.
Download the workbook from today's video so you can compare those, visit the URL in the YouTube description.
I want to thank you for stopping by, I'll see you next time for another netcast from MrExcel.
If you like what you see in this video, please subscribe and ring that bell.
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Two things have changed here in the summer of 2018.
First off, when you open Excel or go to the File menu, we get this new thing called the Home Screen.
It's early now, it's before 6 A.M. so it's wishing me a good morning.
I'm sure that changes, you know.
I wish if you were here like at 1:30 in the morning it’d say, like, What the heck are you doing awake at this time?
But good morning.
And then Home-- and what Home seems to be, is it seems to be a weird combination of both New and Open.
So, here at the top above the line, is what I call New-- so, Blank Workbook, and then some of the templates that they have.
And if you wanted to get to all of the templates you can either click New or go to More Templates.
And I'll take you to the New screen, and then below that, some sort of weird version of the Open screen that shows you the recent files-- the pin files shared with me, but not, you know, recent folders.
And if you would scroll all the way down beneath these, then you get two more workbooks, which is essentially the open screen so, you know, that's the old New screen with lots of templates.
That's the old Open screen with a chance to get the folders and choose places.
Home just seems to be a weird combination of those.
And again, it's going to open to here when you open Excel.
It's going to open to here when you go to the file menu.
Alright?
So that's one new thing.
The other thing that's new-- let me just create a new workbook here so it's less, it's less jarring-- is they have redrawn the icons and, I have to tell you, I've seen these for a while.
I can't say that I hate them and I can't say that I love them.
It frankly looks like we're de-evolving-- we're regressing backwards, you know.
So just to see a combination here-- here's the Insert tab in Excel-- From the new icons to what we had in Excel 2016, right?
And, like, let's just take a look at this Pictures icon here-- the mountain used to be filled in in blue and now it's just an outline, the Sun used to be yellow and now our Sun just turned black.
It just looks like some definition has been lost.
And it really seems like it's we're going in that direction.
If we go back to Office 2013 or even back to Office 2010, in office 2010 it looked like a little Polaroid photo, two mountains, a Sun, the Sun had an outline; SmartArt here had a glow, and then we lose the glow and it's just getting less.
Although, I guess... you know, we used to have a 3D Pie chart and now it's just a flat Pie chart.
So, hey, let me know what you think down in the YouTube comments.
What do you think of these new icons?
Do you like the old icons or the new icons or you just don't care?
And if you like the old icons, give me some words to describe what they did here.
What happened?
How did we lose definition?
Like, even, you know, the table doesn't look as much like a table, and the recommended pivot tables used to have data in the values area and now its blank.
Another big change here is, it used to be that when you selected various tabs in the ribbon the tab changed colors and you had a line out of three sides, and that when we change tabs in the ribbon, it's just the line at the bottom of the tab.
I mean, you can barely, barely make out there that it's a different color, but it's, you know, like gray and just a tiny bit lighter gray, but I preferred when it actually looked like a tab.
You know, I noticed that this new tab designator here, the underline has been around for a while.
If you have a data model pivot table, the Active and All, I've been using that even longer than the ribbon has, so, you know, they had this in the works, I guess, when they planned it.
Leave a note out in the YouTube comments, let me know what you think about this.
Between us, if you buy Excel 2019, you're going to get the old version.
The big news today is the new Home category of the File menu, or when you open Excel.
Well, hey, all of this is of course in my new book, "Microsoft Excel 2019 Inside Out." Today, a new Home screen and the File menu, accommodation of New and Open, and then the new ribbon illustrations-- just, really either hate them or love them.
Download the workbook from today's video so you can compare those, visit the URL in the YouTube description.
I want to thank you for stopping by, I'll see you next time for another netcast from MrExcel.
