You are previewing Microsoft Excel X for Mac OS X: Visual QuickStart Guide.
O'Reilly logo
Microsoft Excel X for Mac OS X: Visual QuickStart Guide

Book Description

Excel X for Mac OS X is the model OS X app, from its Aqua interface to its complete support for OS X's modern architecture. In Excel X for Mac OS X: Visual QuickStart Guide, author Maria Langer, veteran Mac writer and consultant, walks you through all that's new and noteworthy in Microsoft's spreadsheet powerhouse, dispensing lots of expert tips along the way.

Maria knows you're a busy professional. That's why Excel X for Mac OS X: VQS was designed to let you learn as you work. Use it as a quick-reference guide: Just look up a topic in the index--or use the page tabs to thumb to it--then follow the simple, concise steps and check your results against the accompanying screenshots. Newcomers can treat the book as a step-by-step introduction to Excel, starting with the basics, then moving on to more advanced techniques, such as inserting objects and multimedia events, creating charts and graphs, and publishing spreadsheets to the Web.

Table of Contents

  1. Copyright
  2. Thanks!
  3. Introduction to Excel X
  4. The Excel Workplace
    1. Meet Microsoft Excel
    2. The Excel Screen
    3. The Mouse
    4. Menus
    5. Shortcut Keys
    6. Toolbars & Palettes
    7. Dialogs
    8. Scrolling Window Contents
    9. The Office Assistant
    10. Excel Help
  5. Worksheet Basics
    1. How Worksheets Work
    2. Launching Excel
    3. Quitting Excel
    4. Excel Workbooks, Templates, & Wizards
    5. The Project Gallery
    6. Creating Workbooks
    7. Activating & Selecting Cells
    8. Entering Values & Formulas
    9. Values
    10. Formula Basics
    11. The Calculator
    12. Natural Language Formulas
  6. Editing Worksheets
    1. Editing Worksheets
    2. Editing Cell Contents
    3. Inserting & Deleting Cells
    4. Copying Cells
    5. Copying with Copy & Paste
    6. The Fill Handle
    7. The Fill Command
    8. Series & AutoFill
    9. Copying Formulas
    10. Relative vs. Absolute Cell References
    11. Mixed References
    12. Moving Cells
    13. The Office Clipboard
    14. Undoing, Redoing, & Repeating Actions
  7. Working with Files
    1. Excel Files
    2. Workbook Sheets
    3. Workbook Windows
    4. Saving Files
    5. Opening Existing Files
  8. Using Functions in Formulas
    1. Functions
    2. Anatomy of a Function
    3. Arguments
    4. Entering Functions
    5. Math & Trig Functions
    6. Statistical Functions
    7. Financial Functions
    8. Logical Functions
    9. Lookup and Reference Functions
    10. The VLOOKUP & HLOOKUP functions
    11. Information Functions
    12. Date and Time Functions
    13. Text Functions
  9. Formatting Cells
    1. Formatting Basics
    2. Number Formatting
    3. Alignment
    4. Font Formatting
    5. Borders
    6. Cell Shading
    7. Styles
    8. Conditional Formatting
    9. The Format Painter
    10. Column Width & Row Height
    11. AutoFit
    12. AutoFormat
    13. Removing Formatting from Cells
  10. Working with Graphic Objects
    1. Graphic Objects
    2. The Drawing Toolbar
    3. Drawing Objects
    4. Inserting Pictures
    5. Working with Graphic Objects
    6. Stacking Order
  11. Creating Charts
    1. Charts
    2. The Chart Wizard
    3. Worksheet & Chart Links
    4. Data Series & Points
    5. Chart Elements
    6. Chart Type
    7. Chart Options
    8. Titles
    9. Axes
    10. Gridlines
    11. Legend
    12. Data Labels
    13. Data Table
    14. Formatting Chart Elements
    15. Other Formatting Options
  12. Printing
    1. Printing
    2. Print Center
    3. Page Setup
    4. Print Preview
    5. Printing
    6. Saving a Document as a PDF or PostScript File
  13. Working with Lists
    1. List Basics
    2. Using the Data Form
    3. The List Manager
    4. AutoFilter
    5. Advanced Filters
    6. Sorting
    7. Subtotals
    8. Database Functions
  14. Working with Others
    1. Collaboration Features
    2. Document Properties
    3. Comments
    4. Revision Tracking
    5. Document Protection
    6. Save Options & Password Protection
    7. Workbook Sharing
  15. Using Other Applications
    1. Using Excel with Other Applications
    2. OLE Objects
    3. Using Word with Excel
    4. Using Entourage with Excel
    5. Using FileMaker Pro with Excel
  16. Advanced Techniques
    1. Advanced Techniques
    2. Names
    3. 3-D References
    4. Opening Worksheets with Links
    5. Consolidations
    6. Custom Views
    7. Macros
  17. Web Pages & Hyperlinks
    1. Web Pages
    2. Hyperlinks
  18. Setting Excel Preferences
    1. The Preferences Dialog
    2. View Preferences
    3. Save Preferences
    4. Calculation Preferences
    5. Edit Preferences
    6. General Preferences
    7. Transition Preferences
    8. Custom Lists Preferences
    9. Chart Preferences
    10. Color Preferences
  19. Menus & Shortcut Keys
    1. Menus & Shortcut Keys
  20. Function Reference
    1. Functions
    2. Financial Functions
    3. Date & Time Functions
    4. Math & Trig Functions
    5. Statistical Functions
    6. Lookup & Reference Functions
    7. Database Functions
    8. Text Functions
    9. Logical Functions
    10. Information Functions
  21. Index