2001XLGettingStarted

2001XLGettingStarted - Excel Spreadsheets: Getting Started...

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

View Full Document Right Arrow Icon
Excel Spreadsheets: Getting Started E XCEL R EVIEW 2003-2004
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background image of page 2
Excel Spreadsheets: Getting Started Review this guide for tips on some of the basic skills you need to get started building and using spreadsheets. Specific how-to instructions reference Excel 2000. Excel 2002 (XP) is quite similar. If you're new to spreadsheets you might skim through the entire guide for an overview. Then return to particular sections as you need them while you work on your own spreadsheets. For additional information on designing and troubleshooting spreadsheets, see the handout . To find this and other documents that describe advanced features of Excel and provide practice exercises, see this website: http://faculty.fuqua.duke.edu/~pecklund/excelreview/ExcelReview.htm
Background image of page 3

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

View Full DocumentRight Arrow Icon
Contents Page I. Overview of the Excel Work Space. .............................................. 1 Titles, Windows and Worksheets Menus Formula Bar Toolbars Status Bar Worksheet Referencing Scheme For More Information II. Basic Data Entry. ........................................................................... 6 Entering Text and Numbers Editing an Entry Deleting an Entry Adding or Deleting a Row or Column III. Selection. ....................................................................................... 8 Selecting More Than One (Contiguous) Cell Selecting Non-contiguous Cells IV. Key Mouse Operations. ............................................................... 10 Move a Cell or Range Copy Data Filling & Extending
Background image of page 4
V. Moving and Selecting . ................................................................. 12 Moving Around the Worksheet Specifying a Range Selecting a Range for Data Entry For More Information VI. Formulas. ..................................................................................... 14 Format Naming Cells & Ranges Tips for Avoiding Errors Using Built-in Functions Copying Formulas (Relative Referencing) Absolute Addressing For More Information VII. Charting. ........................................................................................ 18 Chart Basics Using the Chart Wizard VIII. File Management Essentials . ...................................................... 20 Saving a File Retrieving a File For More Information IX. Printing. ....................................................................................... 21 Printing Basics For More Information
Background image of page 5

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

View Full DocumentRight Arrow Icon
Background image of page 6
1 I. Overview of the Excel Work Space Titles, Windows, and Worksheets The title bar at the very top of your Excel screen reminds you that you're in Excel. If your workbook is expanded to take up the maximum amount of screen space, its title bar is merged with Excel's title bar to look like this: Microsoft Excel - Book1 . If your workbook is taking up less than the maximum amount of screen space it's displayed in its own window with its own separate title: Book1 . Book1 is the default name for an Excel workbook until you assign it another name.
Background image of page 7

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

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

Page1 / 35

2001XLGettingStarted - Excel Spreadsheets: Getting Started...

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

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