1 / 15

Office Excel 2010 Lab 3

Learn to use Excel efficiently - from absolute references to printing selected sheets. Discover essential tools like AutoFill and What-If Analysis, and create Sparklines for dynamic data visualization.

mathewr
Download Presentation

Office Excel 2010 Lab 3

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. Office Excel 2010Lab 3 Managing and Analyzing a Workbook

  2. Objectives • Use absolute references • Copy, move, name, and delete sheets • Use AutoFill • Reference multiple sheets • Use Find and Replace • Zoom the worksheet

  3. Objectives • Split windows and freeze panes • Use what-if analysis and Goal Seek • Create Sparklines • Control page breaks • Add custom headers and footers • Print selected sheets and areas

  4. Concept Preview • Absolute Reference • Sheet Name • AutoFill • Sheet and 3-D References • Find and Replace

  5. Concept Preview • Split Window • Freeze Panes • What-If Analysis • Goal Seek • Conditional Formatting

  6. 1 Concept : Absolute Reference Dollar sign symbols change references to absolute

  7. Concept : Sheet Name 2 Each sheet in a workbook can be assigned a descriptive sheet name

  8. Concept : AutoFill 3 AutoFill handle Examples of how AutoFill extends a series

  9. 4 Concept : Sheet and 3-D References • Formulas can reference cells in other sheets of a workbook • Sheet Reference • 3-D References

  10. 5 Concept : Find and Replace

  11. Concept : Split Windows 6 • Allows you to divide a worksheet into sections, called panes • Each pane can be scrolled independently

  12. Concept : Freeze Panes 7

  13. Concept : What-If-Analysis 8 Values in linked cells of Year sheet updated Reducing Payroll expenses increases Profit Margin Chart shows change in profit margin

  14. Concept : Goal Seek 9 Enter location of cell containing formula to be solved Enter desired result Specify cell that can be adjusted Goal Seek found solution to achieve 15% profit margin

  15. 10 Concept :Conditional Formatting Sets or clears conditional formatting rules

More Related