Excel2000_handout - Introduction to Spreadsheets Using...

Info icon This 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.
Image of page 1

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

View Full Document Right 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
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!
Image of page 3

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

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

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    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.

    Student Picture

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

  • Left Quote Icon

    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.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    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.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern