Introduction-to-Excel

Introduction-to-Excel - Intro to Excel 1 Table of Contents...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Intro to Excel 1 Table of Contents 1. Introduction to the Worksheet 2. Creating the Data Worksheet 2.1 Entering Data 2.2 Formatting Data 2.3 Selecting Cells 2.4 Filling Data 2.5 Entering Formulae 2.6 Entering a Sum
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Intro to Excel 2 1. Introduction to the Worksheet Microsoft Excel is a versatile program present on most computers at home and in computer clusters. It is a business tool for accounting and managing large sets of data. It can also simplify graphing and analyzing data from the labs. These instructions are intended as a guide to graphing lab data for those who are not familiar with Excel. As always with computer programs, there is more than one way to go about these things. The instructions here are intended to be an easy introduction to the use of Excel. These instructions were created with screen captures from Microsoft Excel 2000, but the methods detailed here are accurate for Excel 98 and 2000 and for Microsoft Office 98 for the Macintosh. A computer is a Macintosh if the mouse has only one button to click; otherwise it is a Windows computer. For a Windows computer, the primary mouse button is the one on the left. Some functions require the use of the right mouse button; if that is the case, the instructions will say so explicitly. If there are questions not answered by this guide, please read the help files built into the Excel program. There are two ways to get to the help files. The first way is to go the top menu bar and click Help, and from the menu that pops up select Microsoft Excel Help . The second way is to click the Microsoft Excel Help button in the area below the top menu bar. Figure 1: A workbook in Excel. Workspace Tabs for different worksheets Highlighted cell Name box Top menu bar Drawing toolbar Formula bar
Background image of page 2
Intro to Excel 3 If some of these features are not available or do not seem to work, please check that the Analysis ToolPak Add-In has been installed and activated in Excel. Go to the top menu bar, click Tools and select Add-Ins from the short menu which pops up. If Add-Ins is not listed in the short menu, click the double arrow at the bottom of the short menu to display the full menu; on the Macintosh use the vertical scroll arrows. In the Add-Ins window that pops up, make sure that the box next to Analysis ToolPak has been checked. Click Ok when done. For a hand-written lab, it is important that the data sheet be organized and easy to read. It is just as important when using Excel to have a well-organized data sheet. To do that, it helps to know how to work with data in Excel. Please refer to Figure 1 on the previous page for the different parts of the Excel window. The workspace is where the data will be entered and displayed. Information is organized in Excel in entry boxes called cells. Cells are organized into columns and rows. Each column is assigned a letter and each row is assigned a number. To find any cell just find the column with the appropriate letter and look down along the column to find the appropriate row. Each cell has
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/14/2009 for the course PHYS PHYS-102 taught by Professor Kikkawa during the Spring '09 term at UPenn.

Page1 / 7

Introduction-to-Excel - Intro to Excel 1 Table of Contents...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online