Excel 2010 Tutorial - Table, Ribbons, Navigation

This is the first video of the Excel 2010 Tutorial series. School of Technology Program Coordinator, Justin Denton, outlines the basics behind Microsoft Excel, and shows how to create tables, ribbons, and navigate within Microsoft Excel 2010. This tutorial video is a great beginning step to your courses in the School of Technology and Design program at Rasmussen College.


To start off with Excel tips and tricks, we're going to have a wide variety of topics that we're going to cover. So if you're not a beginner there's going to be some beginner topics that are covered. If you are a beginner, you're going to get those as well. I'm going to go into the advanced topics.

The topics I'm going to technically cover. I'm going to spend about five minutes on just a quick refresher on how Excel works, on the layout of Excel. There's going to be comments-- how to answer comments, update comments. How to use the find and replace. How to work with graphs and charts and build custom graphs. We're also going to get into creating formulas within Excel and go over some of the various types of formulas.

Some of the information-- We'll keep it concise. The handout has a lot of additional information in it. So if you have questions later on there's a lot of information in the handout that I built in.

We'll also cover or how to link between spreadsheets. So if you have two spreadsheets and you want to keep one up-to-date with the other's information, we'll show how to build that link in between the two. How to work with pivot tables. Do some general formatting, move around cells and so forth as well as do some conditional formatting and build out some conditional formatting and some sample tables. We'll also put together how to connect to databases. So if you work with external databases-- an Access database, an SQL database-- how to bring that information into Microsoft Excel and start working with it.

And lastly work with macros. We'll lightly touch macros because you can teach an entire class just on macro programming. So I'll show you how to do some really basic macro-- gets the job done. And then I'll go into if you wanted to modify the macro a little bit more, I'll show you how to get in there and do that. There's additional commands and stuff listed into the packet that I handed out or that was handed out. I didn't hand it out.

So if we get into our five-minute refresher. Typical Excel worksheet. Everything's going to be based off Excel 2010. Typically what's called a workbook is the file that you bring up. So I opened up an Excel file. It's going to call a workbook. Underneath here there's multiple sheets. You'll see by default Sheet1, Sheet2, Sheet3. Those are going to be your worksheets that you'll work with.

You've got the area to the left, which will be your row heading. And then you've got your column heading. You're going to technically not need those right off the bat. And you may never have used them. What they come into play is when we start actually building macros and putting formulas together. That's when you're going to need those cell references to actually create some functioning macros and formulas.

When you're working with your workbook, your active cell's always highlighted in a black outline. That's going to be where you're going to be working. You also have cell references. And pretty much just what we've covered in the worksheet spreadsheet layout.

If you also want to zoom in and out. Maybe you're a little too small. You want to zoom in a little further so you can see it on your screen. You've got what's in most Office applications, the zoom slider, plus and minus. It'll zoom in and out on the screen.

If we go into it, we've got some data in an actual spreadsheet. You've got your Undo/Redo buttons, typically up here in the top left. You'll have your Save, your Undo, and your Redo. So if you typo something and you want to undo it, that's where you're going to be looking at to work with.

When you have an active cell selected, an expression when you're working with formulas, the area that you're going to want to work with is the Formula Bar. In the Formula Bar, that's going to give you a more lengthy layout of actually working with what's in the underlying cell. Sometimes like in this instance, this cell's trumped by the next cell. So to find out actually what's in that cell, you'll just highlight it and just keep an eye on the Formula Bar. Other than that, when you-- and it'll come more into play when you're building charts and everything else-- is you'll need to worry about the cell range. If I select a range of cells, just keep in mind it starts with A1, ends with G1. That'll allow you to determine what range of cells you're working with. So when you build out a chart, you build out formulas-- a little bit of anything-- you'll need to know this reference so it'll actually put those all together correctly.

Kendall Bird

Kendall is a Social Media Strategist at Collegis Education who is focused on bringing awareness and engagement to Rasmussen College's social media properties. She is passionate about helping others, the power of education and building strategies that put the needs of students first. 


Related Content

This piece of ad content was created by Rasmussen College to support its educational programs. Rasmussen College may not prepare students for all positions featured within this content. Please visit www.rasmussen.edu/degrees for a list of programs offered. External links provided on rasmussen.edu are for reference only. Rasmussen College does not guarantee, approve, control, or specifically endorse the information or products available on websites linked to, and is not endorsed by website owners, authors and/or organizations referenced. Rasmussen College is a regionally accredited private college.

Add your comment


Please enter your name.


Please enter your email.


Please enter your comment.


Take the Next Step—Talk to Us!

There are some errors in the form. Please correct the errors and submit again.

Request More Information

Talk with a program manager today.

Fill out the form to receive information about:
  • Program Details and Applying for Classes 
  • Financial Aid and FAFSA (for those who qualify)
  • Customized Support Services
  • Detailed Program Plan

Step 1 of 3

What's Your Name?

Please enter your first name.

Please enter your last name.

Step 2 of 3

Contact Information

Please enter your email address.

Please enter your phone number.

Please enter your five digit zip code.

Step 3 of 3

Program Preferences

Please choose a school of study.

Please choose a program.

Please choose a degree.

The program you have selected is not available in your area. Please select another program of interest.

By requesting information, I authorize Rasmussen College to contact me by email, phone or text message at the number provided. There is no obligation to enroll.

icon-colored-advance icon-colored-build icon-colored-certificate icon-colored-continual-developement icon-colored-growth icon-colored-national icon-colored-prep icon-colored-regional icon-colored-state icon-colored-student-centered icon-colored-support icon-colored-world-experience icon-general-connect icon-general-degree icon-general-discuss icon-general-email icon-general-find icon-general-laptop icon-general-leader icon-general-map icon-general-paperwork icon-general-phone icon-general-speak-out icon-camera icon-filter icon-info-circle icon-mail-forward icon-play-solid icon-share-square-o icon-spinner icon-tag logo-accreditation-acen logo-accreditation-ccne ras-logo-flame ras-logo-horizontal ras-logo-stacked icon-simple-chat icon-simple-desktop icon-simple-find icon-simple-hamburger icon-simple-phone icon-testimonial-quotes icon-social-facebook-square-colored icon-social-facebook-square icon-social-facebook icon-social-google-plus-square icon-social-google-plus icon-social-instagram icon-social-linkedin-square-colored icon-social-linkedin-square icon-social-linkedin icon-social-pinterest-p icon-social-twitter-square icon-social-twitter icon-social-youtube-play-colored icon-social-youtube-play icon-util-checkbox-white icon-util-checkbox icon-util-checked-white icon-util-checked icon-util-chevron-down icon-util-chevron-left icon-util-chevron-right icon-util-chevron-up icon-util-loading icon-util-open-window-button icon-util-open-window-link icon-util-pdf-button icon-util-pdf-link icon-util-refresh icon-util-x