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 2007Excel 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 Tabsto 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 Guidefor 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
has intentionally blurred sections.
Sign up to view the full version.