SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

Microsoft Excel Lesson 4

price-walters avatar
price-walters
24 diapositives · 433 Views · Nov 15, 2014

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.

#microsoft excel lesson 4 #microsoft excel lesson 4 ppt #powerpoint #presentation
Microsoft Excel Lesson 4 - slide 1
01 / 24Microsoft Excel Lesson 4
1 / 17

Télécharger la présentation

Microsoft Excel Lesson 4
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  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