You are previewing Teach Yourself VISUALLY™: Excel® 2007.
O'Reilly logo
Teach Yourself VISUALLY™: Excel® 2007

Book Description

Are you a visual learner? Do you prefer instructions that show you how to do something - and skip the long-winded explanations? If so, then this book is for you. Open it up and you'll find clear, step-by-step screen shots that show you how to tackle more than 150 Excel 2007 tasks. Each task-based spread includes easy, visual directions for performing necessary operations, including:

* Using the Ribbon and galleries

* Entering data and resizing columns

* Applying formulas and functions

* Formatting worksheets

* Adding clip art and 3D effects

* Interpreting data with charts

* Helpful sidebars offer practical tips and tricks

* Succinct explanations walk you through step by step

* Full-color screen shots demonstrate each task

* Two-page lessons break big topics into bite-sized modules

Note: The ebook version does not provide access to the companion files.

Table of Contents

  1. Copyright
  2. Praise for Visual Books
  3. Credits
  4. About the Author
  5. Author's Acknowledgments
  6. 1. Excel Basics
    1. 1.1. An Introduction to Excel
    2. 1.2. Start and Close Excel
    3. 1.3. Navigate the Excel Program Window
    4. 1.4. Understanding the Ribbon, Galleries, and Contextual Tools
    5. 1.5. Change Views
    6. 1.6. Customize the Quick Access Toolbar
    7. 1.7. Display Task Panes
    8. 1.8. Find Help
  7. 2. Workbook Fundamentals
    1. 2.1. Start a New Workbook File
    2. 2.2. Save a Workbook
    3. 2.3. Publish a Workbook as an Excel Binary Workbook File
    4. 2.4. Open an Existing Workbook
    5. 2.5. Close a Workbook
    6. 2.6. Delete a Workbook
    7. 2.7. Arrange Workbook Windows
    8. 2.8. Protect a Workbook
    9. 2.9. Hide or Show a Worksheet
  8. 3. Entering Data
    1. 3.1. Enter Data
    2. 3.2. Turn On Text Wrapping
    3. 3.3. Resize Columns and Rows
    4. 3.4. Select Cells
    5. 3.5. Enter Data with AutoFill
    6. 3.6. Work with AutoCorrect
    7. 3.7. Edit Data
    8. 3.8. Work with Smart Tags
    9. 3.9. Check Spelling in a Worksheet
  9. 4. Working with Worksheets
    1. 4.1. Understanding Worksheet Structure
    2. 4.2. Navigate Worksheets
    3. 4.3. Name a Worksheet
    4. 4.4. Add a Worksheet
    5. 4.5. Delete a Worksheet
    6. 4.6. Move a Worksheet
    7. 4.7. Copy a Worksheet
    8. 4.8. Format Worksheet Tab Color
    9. 4.9. Protect Worksheet Data
  10. 5. Calculating Data with Formulas and Functions
    1. 5.1. Understanding Formulas
    2. 5.2. Create Formulas
    3. 5.3. Reference Absolute and Relative Cells
    4. 5.4. Copy Formulas
    5. 5.5. Name Cells and Ranges
    6. 5.6. Reference Ranges in Formulas
    7. 5.7. Reference Cells from Other Worksheets
    8. 5.8. Understanding Functions
    9. 5.9. Apply a Function
    10. 5.10. Total Cells with AutoSum
    11. 5.11. Check for Formula Errors
    12. 5.12. Audit a Worksheet for Errors
  11. 6. Rearranging Worksheet Data
    1. 6.1. Move and Copy Data
    2. 6.2. Delete Data or Cells
    3. 6.3. Add Columns and Rows
    4. 6.4. Delete Columns and Rows
    5. 6.5. Center Data across Columns
    6. 6.6. Transpose Columns and Rows
    7. 6.7. Set Column Width and Row Height
    8. 6.8. Hide Columns and Rows
    9. 6.9. Freeze a Column or Row
    10. 6.10. Split a Worksheet into Panes
    11. 6.11. Find and Replace Data
  12. 7. Formatting Worksheets
    1. 7.1. Apply Bold, Italics, and Underlining
    2. 7.2. Change the Font and Size
    3. 7.3. Change Number Formats
    4. 7.4. Increase or Decrease Decimals
    5. 7.5. Change Data Color
    6. 7.6. Apply Workbook Themes
    7. 7.7. Align Cell Data
    8. 7.8. Rotate Cell Data
    9. 7.9. Control Text Wrap
    10. 7.10. Add Borders
    11. 7.11. Add Background Color to Cells
    12. 7.12. Assign a Background to a Worksheet
    13. 7.13. Copy Cell Formatting
    14. 7.14. Apply a Style
    15. 7.15. Assign Conditional Formatting
  13. 8. Enhancing Worksheets with Graphics
    1. 8.1. Insert Image Files
    2. 8.2. Insert Clip Art
    3. 8.3. View Clip Art with the Clip Organizer
    4. 8.4. Download Clip Art from the Web
    5. 8.5. Draw Shapes
    6. 8.6. Add a WordArt Object
    7. 8.7. Move and Resize Objects
    8. 8.8. Rotate and Flip Objects
    9. 8.9. Crop a Picture
    10. 8.10. Add Shadow and 3-D Effects
    11. 8.11. Format an Object
    12. 8.12. Group and Ungroup Objects
  14. 9. Previewing and Printing
    1. 9.1. Add Headers and Footers
    2. 9.2. Insert Page Breaks
    3. 9.3. Preview a Worksheet
    4. 9.4. Set Up Printing Options
    5. 9.5. Print a Worksheet
    6. 9.6. Define a Print Area
  15. 10. Communicating Information with Charts
    1. 10.1. Understanding Excel Charts
    2. 10.2. Create a Chart with Galleries
    3. 10.3. Move and Resize Charts
    4. 10.4. Change the Chart Type
    5. 10.5. Change the Axes Titles
    6. 10.6. Manipulate 3-D Charts
    7. 10.7. Format Chart Objects
    8. 10.8. Add Chart Objects
    9. 10.9. Change the Chart Data
    10. 10.10. Format Charts with Layouts and Styles
    11. 10.11. Insert SmartArt Charts
  16. 11. Analyzing Worksheet Data
    1. 11.1. Understanding Database Lists
    2. 11.2. Create a Database Table
    3. 11.3. Add Records Using a Data Form
    4. 11.4. Edit Records
    5. 11.5. Search for Records
    6. 11.6. Identify Duplicate Values in a Table
    7. 11.7. Set Data Validation Rules
    8. 11.8. Sort Records
    9. 11.9. Filter Data with AutoFilter
    10. 11.10. Analyze Data with a PivotTable
  17. 12. Using Excel Tools
    1. 12.1. Add a Watch Window
    2. 12.2. Load Add-Ins
    3. 12.3. Analyze Data with Add-In Tools
    4. 12.4. Examine Alternatives with Goal Seek
    5. 12.5. Create Scenarios
    6. 12.6. Optimize Formulas with Solver
  18. 13. Sharing Excel Data
    1. 13.1. Link Data
    2. 13.2. Edit Linked Data
    3. 13.3. Link Between Worksheets
    4. 13.4. Embed Objects
    5. 13.5. Enable Workbook Sharing
    6. 13.6. Add a Comment
    7. 13.7. Track and Review Workbook Changes
    8. 13.8. Merge Workbooks
    9. 13.9. E-mail a Workbook
    10. 13.10. Import Data
    11. 13.11. Export Data
  19. 14. Using Excel on the Web
    1. 14.1. Add Web Tools to the Quick Access Toolbar
    2. 14.2. Publish a Workbook as a Web Page
    3. 14.3. Insert a Hyperlink
    4. 14.4. Download a Stock Quote
    5. 14.5. Copy Web Data to a Worksheet
    6. 14.6. Run a Web Query
  20. 15. Improving Excel Efficiency
    1. 15.1. Personalize the Excel Program Window
    2. 15.2. Change the Default Font
    3. 15.3. Change the Default File Location
    4. 15.4. Open Files in a Specified Folder Automatically
    5. 15.5. Set Macro Security
    6. 15.6. Record a Macro
    7. 15.7. Create an Excel Template
    8. 15.8. Apply an Excel Template