1 / 13

Mastering Excel 2007: Data Entry, Formulas, and Worksheet Management

This lesson covers essential Excel 2007 skills including data entry, basic arithmetic formulas, and formatting techniques. Learn how to select cells, format cell contents with bold and italics, and use number formatting like commas and decimals. Discover how to adjust column widths, insert and rename worksheets, and utilize the AutoSum function for quick calculations. This comprehensive guide will enhance your spreadsheet management skills and equip you with tips for efficient data handling in Excel.

prescott-ellison
Télécharger la présentation

Mastering Excel 2007: Data Entry, Formulas, and Worksheet Management

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. EXCEL 2007 Part 3

  2. What we know so far . . . • Enter Data • Enter Simple Formulas – Basic Arithmetic Symbols • Select Cells – Click/Drag, Ctrl-Click, Shift-Click • Format Cell Contents – Bold, Italic, Underline • Insert Cell Borders • Standard Error Values • Format Numbers – Comma Style, Decimals • Column Width • Insert Columns/Rows

  3. This Lesson • Centre Align Cell Contents • Format Decimals • Sum a Column of Data • Selecting and Renaming Worksheets • Moving and Copying Worksheets within a Workbook

  4. Ribbon Groups Used – Home TAB Centre Alignment Decimal Formatting AutoSum

  5. Open Spreadsheet • Save as Stats • Change Column Widths • Format Headings as Bold

  6. Open Spreadsheet • Format columns C and D to two (2) Decimal places • Centre Align Headings in Row 3

  7. Auto Sum • Click in Cell C11 • Click AutoSum • Press Enter AutoSum

  8. Functions – hints & tips

  9. Selecting & renaming worksheets Home Tab Cells Group Insert / Delete / Format Insert New Worksheet • Right-click Sheet 1 Tab • Rename • Type Birth Stats • Repeat for Sheet 2, renaming it Daily Weights • Delete • Right-click Sheet Tab • Select Delete from Short-cut Menu

  10. Moving a worksheet • Change the Worksheet Order • Click Sheet 4 tab drag to new position between Birth Stats and Daily Weights • Use the guide to help you determine placement

  11. copying a worksheet • Similar to Moving a Worksheet • Hold Ctrl Key as you drag to the new position • A small + will appear on the pointer to show that you are making a copy. • Right-Click Shortcut menu also gets you Worksheet Options to rename, copy or move worksheets

  12. Worksheet formating

  13. Open birthday2.xlsx • Ensure Column Widths are wide enough to hold contents and centre align cells A3 to D3. • Remove the formula in cell D10 and replace it with AutoSum button. • Rename the worksheet Home. • Make a copy of worksheet Home and rename it Park. • In the Park worksheet edit the formula in cell D11 (per child calculation) to divide by 10. • Edit the data in columns A, B and C on the Park worksheet so that it looks like this: • Save the spreadsheet as Birthday3.xlsx

More Related