1 / 24

Microsoft Excel Lesson 4

Microsoft Excel Lesson 4. Lexington Technology Center April 2007 Bob Herring. Excel Lesson 4. Review of the Previous Lesson. Copying cells using relative and absolute cell addresses Functions Printing Page Setup Excel Options Correcting Errors Clearing Cells or Worksheets.

price-walters
Download Presentation

Microsoft Excel Lesson 4

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. Microsoft ExcelLesson 4 Lexington Technology Center April 2007 Bob Herring

  2. Excel Lesson 4 Review of the Previous Lesson • Copying cells using relative and absolute cell addresses • Functions • Printing • Page Setup • Excel Options • Correcting Errors • Clearing Cells or Worksheets 2

  3. Excel Lesson 4 Charts • Highlight the area that contains the data for the chart • Select Insert, then Chart. This will launch the Chart Wizard 3

  4. Excel Lesson 4 Chart Wizard, Step 1 • The Chart Wizard guides the user through the creation process • The first dialog allows the user to select a type of chart 4

  5. Excel Lesson 4 Chart Wizard, Step 2 • Navigate through the dialogs using the < Back and Next > buttons • Note the difference between using rows and columns as the key 5

  6. Excel Lesson 4 Chart Wizard, Step 3 • This dialog controls the titles, labels, and appearance of the chart • The labels appear on the preview as you type 6

  7. Excel Lesson 4 Chart Wizard, Step 4 • The final dialog allows the user to place the chart, either on • its own worksheet or within one of the existing worksheets • When satisfied, click Finish to see the completed chart 7

  8. Excel Lesson 4 Charts • The completed chart can be placed to enhance presentation, yet • remains linked to its data. If the data changes, the chart will too 8

  9. Excel Lesson 4 Chart Types • Bar and Column Charts • Show variation over a • period of time or draw • comparisons between items • Area Charts • Show the relative importance • of values over time 9

  10. Excel Lesson 4 Chart Types • Line Charts • Show trends or changes in • data over a period in time • Pie Charts • Show the relationship or • proportions of parts to a • whole 10

  11. Excel Lesson 4 Chart Types • High-Low-Close Charts • Show a common presentation • of stock prices • XY (Scatter) Charts • Show the relationship or degree • of relationship between numeric • values of two data series 11

  12. Excel Lesson 4 Chart Types • Surface Charts • Find optimum combinations • between two sets of data • Radar Charts • Show changes or frequencies of • data relative to a center point • and to each other 12

  13. Excel Lesson 4 Design for Looks • Double click in between column headings to automatically • make the column fit its widest entry • Use borders and shading • Add and delete rows and columns • Use drawing tools and clip art (import company logos) • Create your own standard formats • Excel spreadsheets can be copied into Word or PowerPoint, • which may lessen the need for fancy formatting 13

  14. Excel Lesson 4 Design for Looks • Here is some (fictitious) data from an author’s book tour • Unformatted, it is hard to read and understand 14

  15. Excel Lesson 4 Design for Looks • The same data, with some formatting • Give this a try! 15

  16. Excel Lesson 4 Design for Looks • Excel has many tools to add formatting to the worksheet For Clip Art, Select Insert Format Painter Tool Font Size Tool Borders Tool Bold Tool Merge Tool Italic Tool Right Tool Center Tool Fill Tool 16

  17. Excel Lesson 4 Design for Looks • Select Insert, then Picture, then Clip Art ... • The Academic category has a book picture for the worksheet 17

  18. Excel Lesson 4 Design for Looks • The same data, with some formatting 18

  19. Excel Lesson 4 Excel Help • To get help, type a search string into the box at the top right corner • If help finds an article that contains the string, it brings it up in the • Search Results pane • Click on an article to see the help file Help Box Search Pane 19

  20. Excel Lesson 4 Sorting • Excel can quickly sort your data by column • Select Data, then Sort to bring up the Sort dialog box 20

  21. Excel Lesson 4 Sorting • Excel allows the user to sort on up to three columns, with the option • to sort ascending and descending • The “Options” button lets you sort by days or months (or any list) and • to sort lower case and upper case and left to right instead of top to • bottom Sort order for “Case sensitive”: Symbols, Numbers, Lower, Upper 21

  22. Excel Lesson 4 Freezing Panes • Column and row headers can be immobilized on the screen • Click in the cell whose upper left corner will be the intersection • of the frozen area • Select Window, and then Freeze Panes 22

  23. Excel Lesson 4 Panes Frozen • Excel displays vertical and horizontal lines to mark the boundary • of the frozen area Horizontal Pane Marker Vertical Pane Marker 23

  24. Excel Lesson 4 Review • Creating Charts • Custom Formats • Design for Looks • Excel Help • Sorting • Freezing Panes 24

More Related