You are previewing Creating Spreadsheets and Charts in Excel: Visual QuickProject Guide.
O'Reilly logo
Creating Spreadsheets and Charts in Excel: Visual QuickProject Guide

Book Description

Excel can be daunting: that empty grid just stares you in the face when you start the program, challenging you to fill in the cells with thenumbers you need to crunch. How do you start? What do you do?

Creating Spreadsheets and Charts in Excel: Visual QuickProject Guide answers those questions and puts you on the straight track to getting the job done. This new addition to Peachpit's Visual QuickProject Guide series by Excel guru Maria Langer uses full color screen shots and numbered steps to walk you through the process of creating an Excel workbook file. You'll learn how to build a worksheet from the ground up, enter data, write formulas, and copy cell contents. You'll then see how to duplicate and modify worksheets to fine-tune them for your needs. The project's steps also include creating a consolidation worksheet, formatting all worksheets, creating a colorful pie chart, and setting options for printing your work. There's no time wasted in this book; Maria shows you the quickest and most efficient way to perform each task and doesn't waste paper with lengthy explanations or alternative methods. This slim book is all you'll need to get started creating spreadsheets and charts with Excel.

Table of Contents

  1. Copyright
    1. Dedication
    2. Special Thanks to...
  2. Introduction
    1. What You'll Create
    2. How this Book Works
    3. The Web Site
    4. The Next Step
  3. Meet Microsoft Excel
    1. Learn the Lingo
    2. Mouse Around
    3. Start or Open Excel
    4. Look at Excel (Windows)
    5. Look at Excel (Mac OS)
    6. Change the View
    7. Scroll a Window
    8. Choose from a Menu
    9. Use a Toolbar
    10. Have a Dialog
    11. Exit or Quit Excel
    12. Extra Bits
      1. Mouse Around p. 3
      2. Start or Open Excel p. 4
      3. Look At Excel (Mac OS) p. 6
      4. Scroll a Window p. 8
      5. Choose from a Menu p. 9
      6. Use a Toolbar p. 10
      7. Have a Dialog p. 11
  4. Create the Workbook File
    1. Create the Workbook
    2. Set View Options (Windows)
    3. Set View Prefs (Mac OS)
    4. Save the Workbook (Windows)
    5. Save the Workbook (Mac OS)
    6. Extra Bits
      1. Create the Workbook p. 16
      2. Save the Workbook pp. 19-20
      3. Save the Workbook (Mac OS) p. 20
  5. Build the Budget Worksheet
    1. Name the Sheet
    2. Understand References
    3. Enter Information
    4. Activate a Cell
    5. Enter Row Headings
    6. Enter Column Headings
    7. Make a Column Wider
    8. Enter Values
    9. Calculate a Difference
    10. Calculate a Percent Diff
    11. Sum Some Values
    12. Calculate Net Income
    13. Copy Formulas
    14. Copy and Paste
    15. Use the Fill Handle
    16. Change a Value
    17. Extra Bits
      1. Name the Sheet p. 24
      2. Activate a Cell p. 27
      3. Enter Row Headings p. 28
      4. Make a Column Wider p. 30
      5. Enter Values pp. 31–32
      6. Calculate a Difference p. 33
      7. Calculate a Percent Diff p. 34
      8. Sum Some Values pp. 35–36
      9. Copy and Paste p. 39
      10. Use the Fill Handle pp. 40–42
      11. Change a Value p. 43
  6. Duplicate the Worksheet
    1. Copy the Sheet
    2. Clear the Values
    3. Insert a Row
    4. Delete a Row
    5. Enter New Values
    6. Extra Bits
      1. Copy the Sheet p. 50
      2. Clear the Values pp. 51–52
      3. Insert a Row p. 53
      4. Delete a Row p. 54
  7. Consolidate the Results
    1. Prepare the Sheet
    2. Consolidate
    3. Check the Consolidation
    4. Calculate Percent Diff
    5. Extra Bits
      1. Consolidate pp.61–64
      2. Calculate Percent Diff p.66
  8. Format Worksheets
    1. Set Font Formatting
    2. Format Values
    3. Format Percentages
    4. Set Column Widths
    5. Set Alignment
    6. Indent Text
    7. Add Borders
    8. Apply Shading
    9. Change Text Color
    10. Format all Worksheets
    11. Extra Bits
      1. Set Font Formatting pp. 70–71
      2. Format Values pp. 72–73
      3. Set Column Widths pp. 76–77
      4. Set Alignment p. 78
      5. Add Borders p. 80
  9. Add a Chart
    1. Hide a Row
    2. Start the Chart Wizard
    3. Select a Chart Type
    4. Check the Source Data
    5. Set Chart Options
    6. Set the Chart Location
    7. Explode a Pie
    8. Add Data Labels
    9. Extra Bits
      1. Select a Chart Type p. 92
      2. Set Chart Options pp. 94-95
      3. Add Data Labels pps. 99-100
  10. Print Your Work
    1. Select the Sheets
    2. Open Page Setup
    3. Set Page Options (Windows)
    4. Set Page Options (Mac OS)
    5. Adjust Margins
    6. Add a Standard Footer
    7. Add a Custom Header
    8. Save Settings
    9. Preview the Sheets (Win)
    10. Preview the Sheets (Mac)
    11. Print Your Work (Windows)
    12. Print Your Work (Mac OS)
    13. Extra Bits
      1. Set Page Options pp. 106–107
      2. Add a Standard Footer p. 109
      3. Add a Custom Header pp. 110-112
      4. Save Settings p. 113
      5. Print Your Work pp. 116–117