Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
In Excel 2010 Essential Training, Bob Flisser demonstrates the core features and tools in Excel 2010. The course introduces key Excel skills, shows how to utilize these skills with in-depth tutorials on Excel functions and spreadsheet formatting. It also covers prepping documents for printing, working with large worksheets and workbooks, collaborating with others, using Excel as a database, analyzing data, charting, and automating and customizing Excel. Exercise files are included with the course.
As you use Excel you will probably find that there are some features you use more than others and maybe some features you don't use it all. To make it easy to get to the features you use most often, you can pin them to this little toolbar up here called the Quick Access toolbar or the QAT for short. The QAT works exactly the same way in all the office 2010 applications. So if know how to do it in Excel then you already know how to do it in Word, PowerPoint and the others. Now by default the Quick Access toolbar has three commands.
You have Save, Undo and Redo. So here are few ways that you can add commands to the QAT. Click this down arrow here and here are some pretty common commands that you might want to use. So I will just click this one, New. That will let you create a new workbook and let's click it again choose Open. That will let you open a workbook. So it's the same thing as pressing Ctrl+ N or in this one pressing Ctrl+O or same thing as going to File tab and choosing Open or New. But what if you want to put command up on the Quick Access toolbar that's not in that quick little pick list? Let me show you a couple ways of doing that.
Click that down arrow again and go down here and choose More Commands. Now this brings you to the Excel Options dialog box and we are in the Quick Access Toolbar section. It's the same things if you click the File tab and then gone down on the bottom to choose Options and choosen this. Well it's just a little faster way. So here you can see all the commands you have on the Quick Access toolbar and let's say drawing shapes is a task that you need to do frequently. What you see over here at this drop-down list is right now set to Popular Commands. Let's leave it the way it is for now and just scroll down to the bottom and just double-click Shapes and if we double- click Shapes you see it gets put over here.
Now, Shapes is at the bottom, which means it will be all the way on the right side of Quick Access toolbar. Let's say you decided you want Shapes to be the first item in the Quick Access toolbar. Make sure it's selected and then click the up arrow until it gets to the top and then down here and click OK. So now you can see Shapes command is there. Let's check it out. Click the down arrow, choose any of the shape you like, and drag and it works. Just as that you had taken shapes from the Insert tab. Well we don't need that shape right now so I am just going to delete it. Now, I have a rather large worksheet open here on the screen and one thing you might do with large worksheets is set the print area.
So let say for example, I wanted to print maybe just those few cells. Well you may know already you can go to the Page Layout tab choose Print Area and then click Print Area but if that's something you do often here's the easy way that we can put this up in the Quick Access toolbar. When you have the Set Print Area here visible, click the right mouse button on it and choose Add to Quick Access toolbar and you see here is on the right. So click it and now we can see the print area is set. We see the dotted line. Now let's say you decided that you wanted to display the QAT below the Ribbon.
Click the down arrow and over here choose Show Below the Ribbon and I have it below the Ribbon. I'll put it back click the down arrow, Show Above the Ribbon, and there it is. If you decide you want to remove something from Quick Access toolbar it's just a right-click. Let's say we don't need the Shapes anymore. So right-click it choose Remove from Quick Access toolbar and it's gone. So the ability to customize the Quick Access toolbar is another way that Excel puts almost everything you need within one or two clicks. If you ever tried customizing the toolbars in the 2003 or older versions, you will probably appreciate the way it's done in the 2010 version.
There are currently no FAQs about Excel 2010 Essential Training.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.