1 / 21

PowerPoint Presentation to Accompany GO! with Microsoft ® Office 2007 Introductory Excel 2007 -

PowerPoint Presentation to Accompany GO! with Microsoft ® Office 2007 Introductory Excel 2007 - Creating a Worksheet, Formulas, and Charting Data. Parts of an Excel Workbook. Cell Identification. Enter and Edit Data in a Worksheet. Enter and Edit Data in a Worksheet. Design a Worksheet.

alain
Download Presentation

PowerPoint Presentation to Accompany GO! with Microsoft ® Office 2007 Introductory Excel 2007 -

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. PowerPoint Presentation to Accompany GO! with Microsoft® Office 2007 Introductory Excel 2007 - Creating a Worksheet, Formulas, and Charting Data

  2. Parts of an Excel Workbook

  3. Cell Identification

  4. Enter and Edit Data in a Worksheet

  5. Enter and Edit Data in a Worksheet

  6. Design a Worksheet • Good design techniques can be instrumental in making your worksheet useful. • To be most effective: • Use rows rather than columns for the most abundant data. • Consider how it will appear on flat paper. • Arrange the data so that it is easily charted.

  7. Format Data, Cells, and Worksheets

  8. Format Data, Cells, and Worksheets

  9. Format Data, Cells, and Worksheets

  10. Use Page Layout View to Prepare a Worksheet for Printing • Page Layout View prepares your data for printing. • Rulers measure data, set margins, hide or display row and column headings, and change the page orientation. • Headers or footersprint at the top (header) or bottom (footer) of every page of a worksheet. • Page Layout View shows you how the data and/or chart will appear when printed.

  11. Use Page Layout View to Prepare a Worksheet for Printing

  12. Printing in Excel

  13. Formulas • Excel automatically recalculates formulas, when changes are made. • Excel provides prewritten formulas called functions, which perform calculations.

  14. Viewing Formulas

  15. Construct Formulas for Mathematical Operations

  16. Construct Formulas for Mathematical Operations • Relative cell references: • refer to cells by their position in relation to the cell containing the formula • adjust when a formula is copied • Absolute cell references: • refer to cells by their fixed position in the worksheet • make no adjustments

  17. Format Percentages and Move Formulas

  18. Chart Data • A chart creates a visual representation of the data. • Common chart types include: • Column • Pie • Line

  19. Chart Data • Each cell is a data point. • Each data point is shown in the chart by a data marker: A data marker can be a column, bar, area, dot, pie slice, or other symbol. • Related data points form a data series. For example, a data series for January, February, and March.

  20. Chart Data

  21. Chart Data

More Related