Skip to main content
  • Book
  • © 2015

Learn Excel 2016 for OS X

Apress

Authors:

  • A practical, hands-on approach to creating and editing spreadsheets, data charts, and more using Excel 2016 for OS X.
  • 14k Accesses

Buy it now

Buying options

eBook USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 49.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

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

Table of contents (13 chapters)

  1. Front Matter

    Pages i-xxiv
  2. Becoming Proficient with Excel for Mac

    1. Front Matter

      Pages 1-1
    2. Configuring Excel to Suit the Way You Work

      • Guy Hart-Davis
      Pages 49-65
    3. Creating Effective Workbooks and Templates

      • Guy Hart-Davis
      Pages 67-99
  3. Performing Calculations and Presenting Data

    1. Front Matter

      Pages 143-144
    2. Performing Custom Calculations with Formulas

      • Guy Hart-Davis
      Pages 145-165
    3. Using Excel’s Built-In Functions

      • Guy Hart-Davis
      Pages 167-205
    4. Creating Clear and Persuasive Charts

      • Guy Hart-Davis
      Pages 207-243
  4. Analyzing Data and Sharing and Automating Workbooks

    1. Front Matter

      Pages 283-283
    2. Creating Databases Using Tables

      • Guy Hart-Davis
      Pages 285-304
    3. Analyzing Data with PivotTables

      • Guy Hart-Davis
      Pages 329-359
  5. Back Matter

    Pages 391-399

About this book

Microsoft Excel 2016 for Mac OS X is a powerful application, but many of its most impressive features can be difficult to find. Learn Excel 2016 for OS X by Guy Hart-Davis is a practical, hands-on approach to learning all of the details of Excel 2016 in order to get work done efficiently on 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.

Reviews

“If your aim is to tinker with some of Excel’s not-so-common features, then this book is ideal for you and you won’t be disappointed. It follows a step-by-step, handheld approach to coach you into using the software; at the end of your study and practice, you should feel confident in handling the software with some expertise. … the book follows an easy-to-comprehend style. It is written from the perspective of a learner … .” (Amit Rudra, Computing Reviews, computingreviews.com, June, 2016)

About the author

strongGuy Hart-Davis/strong is the author of more than 50 computer books, including emHow to Do Everything with Microsoft Excel 2007/em and emHow to Do Everything with Microsoft Word 2007./em

Bibliographic Information

Buy it now

Buying options

eBook USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 49.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