1 / 24

Mastering Spreadsheets and Graphs: Design, Formatting, and Presentation Techniques

In this comprehensive unit, you'll learn to enhance your spreadsheets' readability and professionalism through effective formatting techniques. Explore the application of graphic design principles to create impactful charts and graphs, and gain insights into matching data with the right graph type. Additionally, we'll investigate the historical launch of the Space Shuttle Challenger as a case study. This unit also includes quizzes and practical Excel exercises to solidify your understanding of spreadsheet design and graph creation, ensuring you can effectively present information.

oswald
Télécharger la présentation

Mastering Spreadsheets and Graphs: Design, Formatting, and Presentation Techniques

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. MIS 201B Unit # 7 MIS 201BUnit 7 Spreadsheets and Graphs By: Nancy Matolak

  2. Please close laptops!

  3. Design and Presentation of Information +

  4. Design and Presentation of Information + • Learn to format a spreadsheet to make it more readable and professional • Learn to apply graphic design principles to spreadsheets and graphs • Match your data to the appropriate Graph Type • Investigate the Launch of the Space Shuttle Challenger • Quiz – Unit 6

  5. L1_L2 (part 1) Design Spreadsheets and Create Formulas in Excel L1_L2 (part 2) Design Graphs in Excel L3 Launch Space Shuttle Challenger?

  6. Excel Workbook Layout

  7. A Picture is Worth a Thousand Words

  8. Spreadsheet Design Principles Before

  9. Graph Design Principles Before

  10. Matching Data to Graph Type Bar Graph Line Graph Scatterplot

  11. Launch the Space Shuttle Challenger?

  12. Slide from the Original Presentation

  13. Excel Techniques • Format Number • Move Decimal Point • Insert Row • Insert Column • Line Break Within Cell • Create A Formula • Copy Formula • Switch to Formula Mode • Fit to One Page • Create Single Series Bar Graph • Create Multi Series Bar Graph • Create Single Series Scatterplot • Create Multi Series Scatterplot • Move Chart

More Related