SPREED SHEET 1

SPREED SHEET:

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.

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.

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.

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.

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.

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.

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.

 HOME TAB SECTION:

In these Microsoft Excel 2007 tutorials home tab addition you will find most of your basic features. These are the tools you will find yourself using the most when creating the look and feel of an Excel spreadsheet. With this tab you are able to change the style, size and color of your font, align test, create bullets and numbers, and cut and paste text.
Open Excel 2007. We are going to create a monthly budget sheet just for practice using the features. We will start at the Far left and move through each section. Click the Microsoft Logo and click Save As. Type a name for your spreadsheet and click Save. Now Type Personal Monthly Budget in the cell A1

The first section is the Clipboard. The Clipboard is a very useful tool to move text, pictures, and charts from one place to another on a page or from one document to another.  Let’s practice using the clipboard with the text we just typed. Highlight “Personal Monthly Budget” by double clicking in the A1 cell to allow editing in the cell then click in front of the text and holding the left mouse button down in front of the text and dragging the cursor to the end and let go.  Once you have done that notice that the scissor icon and the two pieces of paper icon are no longer grayed out. (when an icon is grayed out it you are not able to use it)
Now that the icons are functioning, click on the scissors to cut the text. The text will disappear and go into what is called the clipboard. You can also do this on the keyboard by pressing the ctrl button holding it down and pressing x. You can place the mouse over the icon without clicking and get an explanation and the keyboard command for each icon. Try placing the mouse over the clipboard icon and wait about 2 seconds and see what happens.
Notice that the scissors and papers have been grayed out again because there is no text selected for them to cut or copy. Now let’s get our text back. Click on the A1 cell in Excel 2007 then click on the clipboard icon. Your Personal Monthly Budget text will be pasted back into your Excel document.  This feature will work the same if you switch documents or click in a different location of the same spreadsheet. The icon with the two pieces of paper is the copy icon. If you don’t want the text to be removed from the location it is in currently you can click the paper icon or press ctrl c to copy the text. Then it works the same as the cut feature you click where you would like the text placed and click on the clipboard icon.
If you have copied or cut several objects from a document you can view and select them by viewing your entire clipboard. Click on the little arrow icon in the bottom right corner of the Clipboard section.

This will open the Office Clipboard Task Pane. You will see a list of everything that had been copied or cut during your session in Microsoft Excel 2007. If you click on any of the items in the list it will paste them into the spreadsheet.
Click the x in the upper right corner of the Clipboard Task pane to close it.
If you have a good understanding of the Clipboard we will move on to the Font section. Again if you have any questions about what a button is place your mouse over it without clicking and it will give you a brief description to refresh your memory.