Office 2010 finally allows you to customize the ribbon. Episode 1077 shows you how.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
Hey, welcome back to the MrExcel netcast. I'm Bill Jelen.
Basically, we start out with massive amounts of data.
So, how we're going to analyze it. Well let's fire up a pivot table.
Let's see if you can solve this problem.
Hey, welcome back to the MrExcel netcast. I'm Bill Jelen, taking a look at Excel 2010, you know.
And actually, Microsoft is calling it 2010. I can't get used to that, Excel 2010.
You know one of the big problems with excel 2007, was the ribbon, and people couldn't figure out where things were on the ribbon.
A lot of companies just didn't upgrade, because they didn't want to have to retrain everybody, going from the old menu and toolbars to the new ribbon.
And some things on the ribbon make sense, but there's some things, that I still just don't understand like, why is Pivot Table on the Insert tab, when clearly it belongs on the Data tab.
Well finally, now we have the ability that we can customize the ribbon very easily without doing any programming at all.
So I take a look at the Data tab here.
I think that Pivot Table really goes between Sort and Filter and Data Tools.
So we'll come up, right click, "Customize the Ribbon" and I'm going to expand Data here.
I'm going to add a new group, and I'll rename that group. I'll call it pivot.
Click OK, and then over here on the left hand side, find "All Commands" And we'll go down alphabetically, down to the Ps and find Pivot Table, and we will add that to our group and finally, I'll take my group, and move it up between Sort and Filter and Data Tools, all right.
Click OK.
And now finally, we have Pivot Table exactly where it belongs.
I could go back to the Insert tab and remove it from here.
Infact, you know, as you can see, you can turn off entire ribbon tabs, just by checking them or unchecking them. So, you know there's our Developer tab.
You know, it would be pretty cool.
Now, it's going to be tedious, but what I imagine is going to happen, is one guy in the company the excel go-to guy, is going to go through and figure out the right way for it to be.
And then he can use import export to save the file, and pass it out to everyone in the accounting department, or the finance department or something like that and ofcourse, by the time excel 2010 comes out, I'm going to have the MrExcel customizations.
The most common ones for data analysts out there, and I'll make that freely available.
And I'm sure plenty of people will even come out with the customization, that puts things back in the order of the original excel 2003 menu.
So that way just doing the transition, it will be very easy to find things.
This is a great improvement Microsoft.
Frankly, I'm going to say, they were a little bit arrogant, and forcing everyone to live with the way they wanted things on the ribbon.
Caused a lot of frustration and the end result was, not a large number of people went to 2007. Now that this feature's here, you know, really we can customize the ribbon.
And there won't be the learning curve, plus a lot of great new features.
So hopefully, more of us will be upgrading for excel 2010.
Well hey, I want to thank you for stopping by.
See you next time for another netcast from MrExcel.
Basically, we start out with massive amounts of data.
So, how we're going to analyze it. Well let's fire up a pivot table.
Let's see if you can solve this problem.
Hey, welcome back to the MrExcel netcast. I'm Bill Jelen, taking a look at Excel 2010, you know.
And actually, Microsoft is calling it 2010. I can't get used to that, Excel 2010.
You know one of the big problems with excel 2007, was the ribbon, and people couldn't figure out where things were on the ribbon.
A lot of companies just didn't upgrade, because they didn't want to have to retrain everybody, going from the old menu and toolbars to the new ribbon.
And some things on the ribbon make sense, but there's some things, that I still just don't understand like, why is Pivot Table on the Insert tab, when clearly it belongs on the Data tab.
Well finally, now we have the ability that we can customize the ribbon very easily without doing any programming at all.
So I take a look at the Data tab here.
I think that Pivot Table really goes between Sort and Filter and Data Tools.
So we'll come up, right click, "Customize the Ribbon" and I'm going to expand Data here.
I'm going to add a new group, and I'll rename that group. I'll call it pivot.
Click OK, and then over here on the left hand side, find "All Commands" And we'll go down alphabetically, down to the Ps and find Pivot Table, and we will add that to our group and finally, I'll take my group, and move it up between Sort and Filter and Data Tools, all right.
Click OK.
And now finally, we have Pivot Table exactly where it belongs.
I could go back to the Insert tab and remove it from here.
Infact, you know, as you can see, you can turn off entire ribbon tabs, just by checking them or unchecking them. So, you know there's our Developer tab.
You know, it would be pretty cool.
Now, it's going to be tedious, but what I imagine is going to happen, is one guy in the company the excel go-to guy, is going to go through and figure out the right way for it to be.
And then he can use import export to save the file, and pass it out to everyone in the accounting department, or the finance department or something like that and ofcourse, by the time excel 2010 comes out, I'm going to have the MrExcel customizations.
The most common ones for data analysts out there, and I'll make that freely available.
And I'm sure plenty of people will even come out with the customization, that puts things back in the order of the original excel 2003 menu.
So that way just doing the transition, it will be very easy to find things.
This is a great improvement Microsoft.
Frankly, I'm going to say, they were a little bit arrogant, and forcing everyone to live with the way they wanted things on the ribbon.
Caused a lot of frustration and the end result was, not a large number of people went to 2007. Now that this feature's here, you know, really we can customize the ribbon.
And there won't be the learning curve, plus a lot of great new features.
So hopefully, more of us will be upgrading for excel 2010.
Well hey, I want to thank you for stopping by.
See you next time for another netcast from MrExcel.
