This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: 04/05/2007 3:02:00 PM Z:\SCF\SFG ClearCF Only\Handouts and Howtos\tutorials\excel-tutorial\Excel-2007\excel-handout-2007.doc TM 1 Microsoft Excel 2007 Excel is Microsoft’s Spreadsheet program. Spreadsheets are often used as a method of displaying and manipulating groups of data in an effective manner. It was originally created for accounting. Excel is useful when you have a very large set of data and need to perform the same operation on each Series / Set of it. It is well suited to tasks such as sorting, alphabetizing, adding 2 columns together, and performing more complex mathematical functions on data. Things to Note - Data types and Formula syntax General Tip- Do not worry about having to start from Cell A1. You can start wherever you like as long as your data is in a solid block of adjacent cells. When you print, you can select a specific set of cells so that empty cells are not printed. Data Types- There are four different types of data that can be entered into a cell; they are: text, numbers, formulas and functions. These data are entered using the Formula Bar at the top of the screen but you’ll notice that what you enter into the Formula Bar and what shows up in the Cell may be two different things - especially when it comes to formulas and functions. ** If the Formula Bar is not visible, turn it on by going under View >> Formula Bar Formula Syntax- It is very important to make sure that, when working with formulas, you have the correct syntax. Excel has its own mathematical syntax and, if this is used improperly, you will not get the correct results from you functions and formulas. Excel will only check for logic errors. Different versions of Excel and different installations on computers may have all kinds of shortcuts added, or even removed. For consistency’s sake, we’ll use the Ribbon Tabs to explain how to complete various tasks. Microsoft Interactive Online Demos Microsoft has developed a series of online demo programs to assist people with the transition to Office 2007. Start the Guide for a program by clicking on that phrase on the webpage listed below A new window will open in your web browser showing Office 2003 Use the familiar Toolbar from Office 2003 to find a Tool A second window will appear to show you how to use the same Tool in Office 2007 The web address for the Excel Guide is: http://office.microsoft.com/en-us/excel/HA101491511033.aspx 04/05/2007 3:02:00 PM Z:\SCF\SFG ClearCF Only\Handouts and Howtos\tutorials\excel-tutorial\Excel-2007\excel-handout-2007.doc TM 2 MS EXCEL 2007 - New Interface When you open Excel 2007, you will notice that it looks quite different from Excel 2000 and Excel 2003. The same tools are all there, but they are arranged very differently and new features have been added....
View Full Document
This note was uploaded on 10/22/2011 for the course COMM G310 taught by Professor Sandwina during the Spring '09 term at IUPUI.
- Spring '09