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: EXCEL 2007 Statistical Functions CONTENTS I. Getting Started with MS Excel II. Statistical Functions I. Getting Started with MS Excel Introduction: Microsoft Excel is a spreadsheet application and is a powerful computation and presentation tool used extensively in just about any desk job. The format is so easy to use and flexible, that everyone uses it daily from administrators to fluid dynamic engineers and yes, even by those who do data analysis and statistics. Below are instructions for one possible way to do things. In Excel there are many ways to do any one thing. Over time, you will become familiar with more and more ways. Use the Help Menu (click the white question mark in the blue circle on the top right of the screen or hit F1) if you need any additional information as this document only covers the very basic functions of Excel. Follow directions labeled Tutorial for a simple example. Open a File/Workbook: To open an Excel file in Excel, either double click on the file icon itself. Alternatively, you can start Excel then open the file. There are several ways to do this. There are two ways to open Excel: 1. Double click on the Excel 2007 icon 2. Go to the Start menu -> Programs-> Microsoft Office 2007 -> Excel Once Excel is open, you need to open the file. This can be done by one of several ways: 1. Click the Office Button (top left corner of the screen) -> Open to browse folders 2. Use the keystrokes Control+O 3. Select the open folder icon from the tool bar to the right of the office button (Warning: this may not be displayed on your copy). Tutorial : Start Excel. Create and Save a New File/Workbook: There are several ways to create a new file in Excel: 1. Click the Office Button-> New -> Blank Workbook . 2. Use the keystrokes Control+N 3. Select the new file icon from the tool bar to the right of the office button (Warning: this may not be displayed on your copy) You can save the new spreadsheet by: 1. Click the Office Button-> New 1 2. Use keystroke Control+S 3. Select the save file icon from the tool bar to the right of the office button. Tutorial : Create a new file (known as a spreadsheet) in Excel. Save the new file on your desktop as x tutorial . Selecting Cells: To select a cell in Excel, use the mouse to click on one. By holding the left mouse button down as you move your mouse, one can select many cells at once. For complicated non-connected cell selection, experiment with holding down the Shift key and the Control key as you select your cells. Cell selection can also be done without the mouse using the Shift key in concert with the arrow keys. Notice if you select the very first cell (in upper left hand corner of spreadsheet) the address of the cell is displayed in the name box (box on left on line above cells). The address of the very first cell is A1. Notice the labels for rows are numbered and the labels for the columns are lettered. These addresses are very important....
View Full Document
This note was uploaded on 04/17/2011 for the course STATISTICS 2103 taught by Professor Zhao during the Spring '11 term at Temple.
- Spring '11