1 / 23

Managing Multiple Worksheets in MS Excel 2010: Best Practices and Techniques

This guide offers practical strategies for managing multiple worksheets in MS Excel 2010. Learn how to reference data across sheets using tab names, understand formula navigation, and create effective charts tailored to your data. The content emphasizes the importance of testing your worksheets for accuracy, setting proper margins, and utilizing headers and footers for organization. Additionally, discover tips for creating clean, functional worksheets that enhance data readability and usability through consistent formatting and clear documentation.

theola
Download Presentation

Managing Multiple Worksheets in MS Excel 2010: Best Practices and 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. Creating a Worksheet in MS Excel 2010 Spreadsheets: Part 2

  2. How do I manage multiple worksheets? • To reference data from other worksheets, include tab name before row letter and column number • Example: • Sheet3!A1 indicates Column A, Row 1 on Sheet 3 • Also reference data on other worksheets by: • Navigating to worksheet • Click desired cell • Enter formula or function Practical Computer Literacy, 3rd edition Chapter 13

  3. How do I manage multiple worksheets? Practical Computer Literacy, 3rd edition Chapter 13

  4. Can I sort data in a worksheet? Practical Computer Literacy, 3rd edition Chapter 14

  5. How do I create a chart? • Pick chart type that suits data: • Line charts are used to show data that changes over time • Pie charts illustrate proportion of parts to whole • Bar charts (“column charts”) are used to show comparisons Practical Computer Literacy, 3rd edition Chapter 14

  6. How do I create a chart? Practical Computer Literacy, 3rd edition Chapter 14

  7. How do I modify a chart? Practical Computer Literacy, 2nd edition Chapter 14

  8. How do I modify a chart? Practical Computer Literacy, 3rd edition Chapter 14

  9. Can I add graphics to a worksheet? Practical Computer Literacy, 3rd edition Chapter 14

  10. How do I check spelling in a worksheet? Practical Computer Literacy, 3rd edition Chapter 14

  11. How do I test my worksheet? • Always test worksheet before relying on results • Possible to enter wrong value in cell, use wrong cell reference in formula, or other error • Good idea to use the Save As option to rename and save extra copy of worksheet before testing • One test is to enter series of consistent, easily verified values, such as 1 or 10, into data cells • Another test is to enter real-world values for which you already know results • Compare calculated results with real-world results • This testing also helps identify formatting problems • Good idea to enter largest and smallest values that would reasonably be expected in normal use of worksheet • Small values, including zero, can lead to errors such as division by zero • Large values can lead to results not fitting in cell where answer to be displayed • In this case, make those columns wider Practical Computer Literacy, 3rd edition Chapter 14

  12. How do I test my worksheet? Practical Computer Literacy, 3rd edition Chapter 14

  13. How do I control the page layout for a worksheet? Practical Computer Literacy, 3rd edition Chapter 14

  14. How do I set margins? • Easiest way is to drag directly in the margins in Page Layout view • If your worksheet contains multiple pages, margin settings apply to all pages • Use the Margins button if you want to select preset margins • Click Margins button • Select Custom Margins • Change space allocated for headers and footers Practical Computer Literacy, 3rd edition Chapter 14

  15. How do I set margins? Practical Computer Literacy, 3rd edition Chapter 14

  16. How do I add headers and footers to a worksheet? • Excel worksheets can contain headers and footers • Header is text that appears at top of every page • Footer is text that appears at bottom of every page • Excel includes predefined headers and footers: • Worksheet Title • Date • Page number Practical Computer Literacy, 3rd edition Chapter 14

  17. How do I add headers and footers to a worksheet? Practical Computer Literacy, 3rd edition Chapter 14

  18. How do I set up a multipage worksheet? • Large worksheets may need additional setup to print correctly on multiple pages • Use Page Layout View to preview the information that each page will contain • Use a manual page break if a page ends with a row that should be grouped with data on the next page • It’s good practice to include row and column labels on every printed page to assist with data identification Practical Computer Literacy, 3rd edition Chapter 14

  19. How do I set up a multipage worksheet? Practical Computer Literacy, 3rd edition Chapter 14

  20. How do I print a worksheet? Practical Computer Literacy, 3rd edition Chapter 14

  21. How do I save a worksheet as a Web page? Practical Computer Literacy, 3rd edition Chapter 14

  22. What makes a good worksheet? • Longest data sets should go down the screen • Information should read from left to right and top to bottom • Provide meaningful labels • Enter data accurately • Enter formulas and functions carefully • Avoid including labels in mathematical formulas • Avoid circular references • Understand mathematical precedence Practical Computer Literacy, 3rd edition Chapter 14

  23. What makes a good worksheet? • Use absolute and relative references appropriately • Avoid using too many fonts, font sizes, and colors • Format numbers for easy reading • Use consistent formats for similar data • Format cells so that data fits in them • Add documentation as necessary Practical Computer Literacy, 3rd edition Chapter 14

More Related