No Links were listed yet. Go ahead and share!
Hey! Welcome back to the Mr. Excel netcast. I am Bill Jelen. Basically, we'll start out with massive amounts of data. So, how are we going to analyze this? Well, let us prior up the activity table and see if we can solve this problem.
Hey, welcome back to the MR. Excel netcast. I am Bill Jelen. Well, you know, over the last five weeks, I think I’ve taken about 14 episodes. And now looking at Excel 2010, time to move on and get back to your Excel questions.
One last trick here is in 2007, they changed the behavior of these buttons up here. It used to be that this button would close a current workbook and the X at the top would close Excel. But in 2007, they changed this. The one at the top doesn’t close Excel. It just closes the current workbook until you get down to the point where there’s only one workbook open. And what not many people knew or the people didn’t know or discovered it by mistake. In 2007, you would have to double click the Office icon instead to close Excel. And you can no longer do that. If you double click the Office icon, it just takes you to the backstage so we don’t have an X. They added this new menu up here. And I thought that the new menu would give us a way to close Excel. But instead it’s still just closes the current workbook. And I thought maybe I could right click here on Exit and say add to Quick Access toolbar but for some reason that’s not working. So, if you want to be able to close Excel, what we can do is go to the Quick Access toolbar, let’s say Customize Quick Access toolbar ask for all commands and then come down to the E’s to find Exit Excel and you can add that to your Quick Access toolbar. Kind of strange that it is really just this difficult to have one click access to close Excel.
There you have it, Excel2010, great new version of Excel. They took a lot of the features in Excel 2007, you know allows you to customize the ribbon which I think is a really good thing. That way, you can have every tables on to the data tab if that’s where you want it. Spark lines, some new conditional formatting, better Smart Art, great picture tools, lots of new statistical functions from Mike Gervin telling you about those slicers, all kinds of great, great features coming in either queue one or early queue two of 2010. So hopefully, you’ll look forward to that. I want to thank you for stopping by. We’ll see you next time for another netcast from Mr. Excel.
Transcription by:
Scribe4you Transcription Services