Skip to main content
SpringerLink
Log in
Apress

Learn Excel 2011 for Mac

  • Book
  • © 2011

Overview

Authors:
  1. Guy Hart-Davis
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • A practical, hands-on approach to creating and editing spreadsheets, data charts, and more using Excel 2011 for Mac OS X.

  • 16k Accesses

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 29.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 39.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (14 chapters)

  1. Front Matter

    Pages i-xix
    Download chapter PDF

  2. Becoming Proficient with Excel:Mac

    1. Front Matter

      Pages 1-1
      Download chapter PDF

    2. Learning the Secrets of the Excel:Mac Interface

      • Guy Hart-Davis
      Pages 3-52

    3. Configuring Excel:Mac to Suit the Way You Work

      • Guy Hart-Davis
      Pages 53-81

    4. Creating Effective Workbooks and Templates

      • Guy Hart-Davis
      Pages 83-115

    5. Formatting Your Worksheets Quickly and Efficiently

      • Guy Hart-Davis
      Pages 117-160

  3. Performing Calculations and Presenting Data

    1. Front Matter

      Pages 161-162
      Download chapter PDF

    2. Performing Custom Calculations with Formulas

      • Guy Hart-Davis
      Pages 163-183

    3. Using Excel’s Built-In Functions

      • Guy Hart-Davis
      Pages 185-223

    4. Creating Clear and Persuasive Charts

      • Guy Hart-Davis
      Pages 225-259

    5. Using Data Bars, Color Scales, Icon Sets, and Sparklines

      • Guy Hart-Davis
      Pages 261-274

    6. Illustrating Your Worksheets with Pictures, SmartArt, and More

      • Guy Hart-Davis
      Pages 275-301

  4. Analyzing Data and Sharing and Automating Workbooks

    1. Front Matter

      Pages 303-304
      Download chapter PDF

    2. Creating Databases Using Tables

      • Guy Hart-Davis
      Pages 305-326

    3. Solving Business Questions with What-If Analysis, Goal Seek, and Solver

      • Guy Hart-Davis
      Pages 327-349

    4. Analyzing Data with PivotTables

      • Guy Hart-Davis
      Pages 351-379

    5. Collaborating and Sharing with Macs and Windows PCs

      • Guy Hart-Davis
      Pages 381-407

    6. Automating Tasks with Macros and VBA

      • Guy Hart-Davis
      Pages 409-428

  5. Back Matter

    Pages 429-465
    Download chapter PDF
Back to top

About this book

Microsoft Excel 2011 for Mac OS X is a powerful application, but many of its most impressive features can be difficult to find. Learn Excel 2011 for Mac by Guy Hart-Davis is a practical, hands-on approach to learning all of the details of Excel 2011 in order to get work done efficiently on Mac OS X. From using formulas and functions to creating databases, from analyzing data to automating tasks, you'll learn everything you need to know to put this powerful application to use for a variety of tasks.

About the author

Guy Hart-Davis is the author of more than 50 computer books, including How to Do Everything with Microsoft Excel 2007 and How to Do Everything with Microsoft Word 2007.

Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation