Grauer and Barber Series Microsoft Excel Chapter Four

1. Grauer and Barber Series Microsoft Excel Chapter Four Microsoft Excel

2. Chart Types Chart Wizard Button • A Chart is a graphical representation of data • Excel will allow you to create a variety of charts Chart Types Microsoft Excel

3. Creating Charts Chart Wizard Button • Use the Chart Wizard button on Standard toolbar to create charts Standard Toolbar Microsoft Excel

4. Chart Wizard Steps • Highlight data to chart • Click the Chart Wizard button from standard toolbar • Follow 4 easy steps: • Select Chart Type • Select Chart Source Data • Indicate Chart Options • Indicate Chart Location (embedded or as new sheet) Microsoft Excel

5. Creating a Chart • Highlight data to graph • Click the Chart Wizard Button Highlighted Data Microsoft Excel

6. The Chart Wizard – Step One • Indicate Chart Type Microsoft Excel

7. The Chart Wizard – Step Two • Review and/or Change Content Range Retype Changes Here Microsoft Excel

8. The Chart Wizard – Step Three Titles Tab • Enter various chart options Microsoft Excel

9. The Chart Wizard – Step Four • Enter chart location As new sheet Or As object in (sheet location) Microsoft Excel

10. Pie Charts • Two Areas of the spreadsheet are highlighted • Labels for slices • Numeric data or values • If highlighting noncontiguous areas • Point click and drag to highlight range • Press CTRL and Drag over other range Microsoft Excel

11. The Drawing Toolbar • The Drawing Toolbar has various buttons to include various shapes, textboxes, WordArt, Clipart, and other features • Open drawing toolbar by • Right-click any toolbar and click the drawing toolbar (checked means it will be displayed) WordArt TextBox Clipart Microsoft Excel

12. Hands-On Exercise One • Open a previously saved spreadsheet • Use File, Save to save the worksheet • Enter the AutoSum command to summarize amounts • Use the chart wizard to create a column chart • Move and size chart • Make changes to worksheet and review changes to spreadsheet Microsoft Excel

13. Hands-On Exercise One • Click the chart and use chart type button to change type of chart • Right-click chart area and make changes to the chart • Create a clustered chart with 3-D visual effect subtype • Right-click a toolbar and click the drawing toolbar (checkmark indicates on) Microsoft Excel

14. Hands-On Exercise One • Use the Drawing toolbar buttons and create a textbox • Use the Autoshapes button to insert other shapes from the drawing toolbar Microsoft Excel

15. Multiple Data Series • Spreadsheet data has multiple ranges of categorical data Multiple Data Ranges Title Legend Category Labels Microsoft Excel

16. Hands-On Exercise Two • Open a spreadsheet and change the name of the sheet by • Right-clicking on the sheet name, typing in another name, and pressing enter • Double-clicking on the sheet name will allow for renaming Microsoft Excel

17. Hands-On Exercise Two • Highlight data ranges by pointing and dragging over range to graph • Click the Chart Wizard button to create graph • Follow steps one through four to complete chart • Right-click sheet tab and choose create a copy to create duplicate sheet • Rename the duplicate sheet by double-clicking on it and typing in another name and press enter Microsoft Excel

18. Hands-On Exercise Two • Right-click the chart area and choose chart type and change the type of chart • Use File, Print entire workbook to print entire content of file Microsoft Excel

19. Object linking and Embedding (OLE) • Objects (like spreadsheets & graphs) can be embedded or linked into other areas or files • Embedding inserts the object but does create a pointer back to original location • One-way communication to source document • Linking inserts the object and creates a pointer (link) back to original location • Two-way communication to source document • (Changes are always shown in target document Microsoft Excel

20. Object Linking and Embedding Chart selected and copied to clipboard Microsoft Excel

21. Object Linking and Embedding Paste Special (Link Option) Microsoft Excel

22. Object Linking and Embedding Use to Embedd Paste Link to link Microsoft Excel

23. Object Linking and Embedding Word Letter Spreadsheet Embedded in Word with Edit Paste Special Command Excel Chart Linked in Word With Edit Paste Special (Link button clicked) Command Microsoft Excel

24. Hands-On Exercise Three • Enter Microsoft Word using Start, Programs, Microsoft Word • Use File, Open to open a Word document • Enter Microsoft Excel using Start, Programs, Microsoft Excel • Use File, Open to open an Excel spreadsheet • Highlight what you want to copy Microsoft Excel

25. Hands-On Exercise Three • Use the edit, copy command to copy object to clipboard • You can also right-click the object and choose copy • Switch to other product to copy to (click on application on taskbar) • Use Edit, Paste Special command to insert object • Options include embedding and linking (paste link radio button) • Use Edit, Links to show changes made to linked files • Use File, Save to reflect changes in files Microsoft Excel