Excel2000_handout

# Excel2000_handout - Introduction to Spreadsheets Using...

• Notes
• 21

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

Introduction to Spreadsheets: Using Microsoft Excel Jery R. Stedinger School of Civil and Envir. Engineering, Cornell University January, 2000, updated for EXCEL 2000 CONTENTS Introduction Absolute & Relative Addressing Tool Bar Cell Naming Have a Question? Copying and Moving Cells Workbooks and Worksheets Saving and Printing Files Entering Information Creating Charts Moving Around Creating Macros Selecting Blocks of Cells Other Useful Macro Information Formatting Goal Seeking Formulas Solver Functions Numerical Precision Other Features Introduction This introduction to Microsoft Excel is designed to be read while you sit in front of a Macintosh or PC running the program. Excel runs on both PCs and Macintoshes. The Windows 97, Windows 98 for Macs, and 2000 versions are very similar. This tutorial should get you started, and give you the sense of its power. This tutorial is pertinent for Excel 2000, Excel 97, and Excel 98. Spreadsheet programs (Lotus 1-2-3, Quattro, Excel) are software that present users with a worksheet or matrix of rows and columns in which text, data, and formulas are stored. Excel's worksheet, scroll bars, formula bar, and menus are shown below. They look slightly different with different machines and versions of Excel. An Excel worksheet can have thousands of rows and hundreds of columns. An intersection of a row and column is called a cell . Just as elements of an array are described by their row i and column location j, cells are referred to by their row number and column letter: A1, B2, C7, G55, AA256, etc. When selected , a cell becomes the active cell. In the figure below, cell A1 has been selected, as can be seen because that cell is highlighted. The cell's name, A1, appears in the formula bar (immediately below the menu and above the worksheet). If the cell contained text, data, or formulas, they would appear in the formula bar. Try typing something and editing what you typed by using the cursor in the formula bar to insert or to select different letters or words. When you have what you want in the cell, press Enter, Tab, Return , or click on the "check" next to the formula bar.

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

Introduction to Spreadsheets Page 2 Tool Bar Excel allows the user to display and use several tool bars. (See Toolbars under the View Menu.) The Window above shows the Standard and Formatting Tool Bars. They contain a set of powerful buttons that include: To open a spreadsheet, open a file, save a file, and print Formatting commands specify font, font size, and style: bold, italic, and underline Modifies cell format so that more or less digits are displayed Justification: left, center, right, center across columns
Introduction to Spreadsheets Page 3 Border/underline - click on arrow for a matrix of choices Insert a command to sum several rows; insert a function ChartWizard for generating charts easily HELP!

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

This is the end of the preview. Sign up to access the rest of the document.
• Fall '08
• Stedinger
• cells

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern