No Links were listed yet. Go ahead and share!
Hey, welcome back to the MrExcel netcast. I'm Bill Jelen. Basically, you start out with massive amounts of data and say how we’re going to analyze this. Well, let's fire up the pivot table and see if we can solve this problem.
Hey, welcome back to the MrExcel netcast. I'm Bill Jelen taking a look at Excel 2010. You know what actually Microsoft just 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 where on the ribbon and a lot of companies just didn’t upgrade because they didn’t want to have retrain everybody going from the old menu and toolbars to the new ribbon and something’s on the ribbon makes sense but there is something that I still just don’t understand like why is pivot table on the insert tab when clearly it belong 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 the pivot table really goes between sort and filter and data tools. So we’ll come up or right click, customized 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 okay, and then over here on the left hand side find all commands and we’ll go down alphabetically down to the P’s and find pivot table and we will add that to our group and finally I will take my group and move it up between sort and filter and data tools. All right, click okay and now finally we have pivot table exactly where it belongs.
I could go back to the insert tab and remove it from here. In fact you know as you can see you can turn off the entire ribbon tabs just by checking them or un-checking them, so you know those are developed or tab. You know it will 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 and export to save the file and pass it out to everyone in the accounting department or the finance department or something like that. And of course, by the time Excel 2010 comes out I'm going to have the MrExcel customizations, the most common ones for the data LS out there. I’ll make that really 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 there were just throwing the transition and it will be very easy to find things. This is a great improvement Microsoft frankly I want to say they were a little bit arrogant in forcing everyone to live with the way they wanted things on the ribbon. It caused a lot of frustration and the end result was a large number of people went to 2007. And now with that these features here, you know, really we can customized 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.
Transcription by:
Scribe4you Transcription Services