1 / 13

Exploring Microsoft Excel

Exploring Microsoft Excel. Chapter 2 Gaining Proficiency: Copying, Formatting, and Isolating Assumptions. Objectives. Explain importance of isolating assumptions Define, select and deselect cell ranges Copy and move cells; differentiate between relative, absolute and mixed addresses

jonese
Download Presentation

Exploring Microsoft Excel

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. ExploringMicrosoftExcel Chapter 2 Gaining Proficiency: Copying, Formatting, and Isolating Assumptions

  2. Objectives • Explain importance of isolating assumptions • Define, select and deselect cell ranges • Copy and move cells; differentiate between relative, absolute and mixed addresses • Format a worksheet • Change column widths • Describe steps to create a financial forecast worksheet Chapter 2

  3. Overview • Basic commands to create a worksheet • Use cell ranges and commands to build a worksheet • Isolate assumptions to easily evaluate alternatives • Improve appearance of worksheets • Accuracy is critical for spreadsheets Chapter 2

  4. Getting around the Worksheet • A rectangular group of cells is a range • Copy duplicates contents of a cell from a source range to a destination range • Three types of addresses: absolute, relative and mixed • Move transfer contents of a cell Chapter 2

  5. Creating a Workbook Hands-On Exercise 1 • Create a New Workbook • Save the Workbook • Enter Student Data and Literal Information • Enter Exam Weights • Compute the Semester Average • Copy the Semester Average • Compute Class Averages • What If? Change Exam Weights Chapter 2

  6. Formatting • Column widths • Row Heights • Numeric Format • Alignment • Fonts • Borders, Patterns, and Shading Chapter 2

  7. General Number Currency Accounting Date Time Percentage Fraction Scientific Text Special Custom Numeric Formats Chapter 2

  8. Formatting a Worksheet Hands-On Exercise 2 • Center Across Columns • Increase the Width of Column A • Format the Exam Weights • Noncontiguous Ranges • Borders • Color • Enter Your Name and Social Security Number • The Page Setup Command • Print the Cell Formulas Chapter 2

  9. A Financial Forecast • Always isolate assumptions and initial conditions • Creating a financial forecast is a common task • Be aware that by isolating that is separating initial conditions you spreadsheet will be more valuable when changes occur Chapter 2

  10. A Financial Forecast Hands-On Exercise 3 • Enter the Formulas for Year One • Enter the Formulas for Year Two • Copy the Formulas to the Remaining Years • Format the Spreadsheet • Print the Completed Spreadsheet Chapter 2

  11. Chapter 2 Summary • All commands operate on a cell or cell range • Formulas may be copied or moved • Absolute reference remains constant • Relative address is adjusted for new locations • Format by select-then-do • Tool for Decision Making Chapter 2

  12. Practice with Excel 1. Coaches Realty 2. Sales Invoice 3. Birthday Probability Problem 4. Multiplication Table 5. Payroll for Employees Chapter 2

  13. Case Studies • Establishing a Budget • The Entrepreneur • Break-even Analysis • The Corporate Balance Sheet • The Office Assistant • The Spreadsheet Audit Chapter 2

More Related