Excel2000_handout - Introduction to Spreadsheets: Using...

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

View Full Document Right Arrow Icon
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.
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
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! Have a Question?
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 02/02/2008 for the course CEE 3040 taught by Professor Stedinger during the Fall '08 term at Cornell University (Engineering School).

Page1 / 21

Excel2000_handout - Introduction to Spreadsheets: Using...

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