Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
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.
Excel screens can look kind of intimidating, especially if you're a new user. So I want to give you little tour of what's happening here, make things a little easier for you. Let's start near the top. First thing, most obvious thing is this giant toolbar and that's called the Ribbon bar. And instead of having drop-down menus and multiple rows of toolbars, like a typical program or like Excel had a couple versions ago, we have these tabs, kind of like a tabbed dialog box. And you can click any of these and see different sections of the Ribbon bar. Now this tab over here on the left labeled File, that's kind of special.
Click the File tab, and this is what's called backstage view. Backstage view doesn't deal with the content of your workbook. This deals with the files themselves, the workbook as a whole, things like saving, opening, closing, printing, and so on. Now the keyboard shortcuts are the same as in other versions of Excel and just about every other program. So for example, you can press Ctrl+S to Save, you can press Ctrl+Open, you can press Ctrl+P to print. So if you know what some of these keyboard shortcuts are, they can reduce some of your mouse clicks.
Now because we are in the Home tab, before we click the File tab, if you press the Escape key on your keyboards, it's on the upper left probably, that brings you out of backstage view and back to the Home tab. So it kind of remembers where you were. Now above the Ribbon bar, you have this little mini toolbar and that's called Quick Access toolbar. And the Quick Access toolbar is where you could put commonly used commands, things that you use a lot, rather than having to go and find them on the Ribbon bar. Now you also have here this little box it's called the Name box. Right now it says A3, because the currently selected cell is A3, where column A meets row 3.
To the right of that we have this empty box, it's called the Formula bar. When you're typing in text or editing formulas, that's where the magic happens. Now across here, we have our columns, and columns are always letters and there are over 60,000 columns available going across. Now the rows, you can see here are numbered. You have over a million rows going down. They are about or a little bit more than 16.7 million cells in this worksheet. Now this is one worksheet. Take a look down here. We have Sheet 1, 2 and 3.
By default a new Excel workbook will have three sheets. Now you can click them, see there's nothing in these. You can add worksheets, you can remove worksheets, you have to have at least one worksheet in a workbook. It kind of makes sense. You can have as many as you want. There's no limit. If you have a lot of worksheets, you can use these little VCR type of buttons to navigate back and forth through them. In the lower left corner, this Ready command simply means Excel is ready and waiting for you to do something. So for example, you can select stuff. Now over here in the lower right corner, we have these three little buttons here, are just different ways of viewing the worksheet.
We'll talk about those. And you have this little Zoom assembly and you click this little minus to zoom out and you can click this plus to zoom in, or you could use this little handle on the middle and drag that left and right to zoom in and out. I really don't use that for using very often, because I find there's a better way. If you hold the Ctrl key down and then use the rolling wheel of your mouse and roll backwards, you can zoom out. If you hold the Ctrl key down and roll forwards, you can zoom inwards. If you are using a laptop, many laptops have like a little side panel on the right that you can move your finger back and forth and that works the same way as the rolling wheel on the mouse.
So my advice is get yourself kind of familiar with what's happening on the screen and you'll find that your life in Excel is going to be a lot easier.
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.