DISCOVER
×

Video transcription

Hi, my name is Dave Andrews. Today I'm going to show you some parts of the standard toolbar in Microsoft Excel. Let's open up Excel by clicking on the Start button, let's go to all programs, let's find Microsoft Office and just open up Excel. Now this area at the top is called the ribbon and it is basically the toolbar that you're going to use for all of your operations down the line in Excel. Now the very first one as you can see is laid out in tabs is the Home tab. And this tab allows you to format the text that's typed into Excel. Like if I type a name, I can then select that cell and make it bold using this and change the color and basically do text editing on my cells within Excel. Now the Insert tab up here allows me to drop in tables which allow me to organize the data in Excel and to sort and create filters. I can drop pictures in, I can build charts based upon the data that I've typed into Excel. I can link to web pages and I can also add some interesting text features. Page Layout basically controls the way that the page will appear if I were to print it on my printer, like the orientation either portrait or landscape. You have features such as that and that controls how to print. Formulas allows you to drop little tiny programs into cells that calculate sums of data or averages, things like that and you'll use formulas quite a bit as you get to the sort of advanced uses of Excel. The Data tab is another advanced use of Excel that allows you to pull data from a database in your organization through this get external data button. Review allows you to track changes in Excel and also insert comments such as David here, you can say new comment, I don't like the red, boom. There's now a comment on that cell that if somebody we're to look at it, it would say I don't like the red and you can decide what to do from that in your organization. So those are a lot of the more basic uses of the toolbar in Excel just sort of going down the line and explaining to you what they are. My name is Dave Andrews and I've just explained to you the standard parts of the toolbar in Excel.