logo for free-computer-tutorials.net
leftimage for free-computer-tutorials.net

Excel 2007 Tutorial

Any of you that have used Microsoft Excel before and are now trying to use Excel 2007 it is quite different from the old versions. Sure, the newer version can still perform the same functions, ranging from basic pie charts to computing complex financial figures so the your online tax return. However, it is the newer features that distinguish it from its outdated counterparts. In these Microsoft Excel 2007 tutorials I will take you step by step through the basic features and the entire new tab format of the program.

We are going to start with the basics and then move step by step through each tab at the top to include the Home tab, Insert, Page Layout, Formulas, Data, Review, and end with View. Let’s get started.

Even with my extensive computer background it took me some time to get use to Microsoft Office 2007.

Most seniors and beginner computer users will use Excel for creating basic spreadsheets for contact lists, calendars, budgets, or even track blood pressure. We will go over creating some of these spreadsheets to learn about each tab.

When you open Excel 2007 it starts you with a new document. All of your basic commands that you will use on most documents are located at the top of the screen by clicking on the Microsoft office logo. Click the upper left corner on the Microsoft Office logo to see the list of options.

Excel 2007 Main menu

Even though you already have a new document open click on the New icon. The New Document window will open and give you template options to choose from.

Excel 2007 Templates

Click on Installed Templates. This will give you a list of templates you can uses that are already installed on your computer and you do not have to download from the internet. These can be time savers if you are in a hurry to create a professional looking spreadsheet with the formulas already in place.

Below the Installed Templates in a list of other templates you can download off the internet. These are also great time savers. It just takes a few extra clicks to download the document online.

Now click cancel. We are going to finish the basics of Excel 2007 before we start a document.

We are going to do this tutorial in the order of the tabs at the top. So now that we have a blank document open click on the Microsoft Office logo at the top left and place your mouse over Save As.

Excel Save As

The Excel 2007 Save As is a little different than past versions. If you are planning to send the document via email or save it to a disk and use another computer to open it click the Excel 97-2003 Document. If the other computer does not have Excel 2007 but has an older version this selection lets you open the document in an older version of Excel.

If you plan on using Excel 2007 to open the document each time click the top Excel spreadsheet selection.

Excel 2007 Save As browser

Select the file location you would like to save your spreadsheet. Usually the file location defaults to My Documents. Type the in the File name: box and click save.

You can also change the spreadsheet type to open in an older version of Excel in the Save As Window by clicking the drop Save as type: down menu and selecting Excel 97-2003 spreadsheet.

Once you have the spreadsheet saved let’s learn to close and reopen the document.

Click on the Microsoft Office icon in the upper left corner and at the very bottom click Close.

There are 3 ways to reopen a document.

1. Double click on the My Documents folder from your desktop and then browse to where you saved your spreadsheet and double click on the file. This will automatically open Excel 2007 and your saved document.

Excel 2007 Open

2. Open Excel 2007 and click on the Microsoft Office icon in the upper left corner. The dropdown menu will appear and you can either click on the Open Icon and it will take you to your My Document folder where you can browse to your spreadsheet then double click on the file and open it, or

3. In the right hand column of the dropdown menu you will see Recent Documents. Scan down the list of documents until you find greeting card.docx file and click.

Excel 2007 Open spreadsheet

I know we have not got to the heart of Excel 2007 yet but we have found the basics we need to know for every Excel spreadsheet we create. Click the Next arrow to move onto the Home tab.



ADD TO YOUR SOCIAL BOOKMARKS: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb