Skip to main content
SpringerLink
Log in
Apress
Book cover

Learn Excel 2016 for OS X

  • Book
  • © 2015

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 2016 for OS X.

  • 14k 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 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

Licence this eBook for your library

Institutional subscriptions

Table of contents (13 chapters)

  1. Front Matter

    Pages i-xxiv
    Download chapter PDF

  2. Becoming Proficient with Excel for Mac

    1. Front Matter

      Pages 1-1
      Download chapter PDF

    2. Learning the Secrets of the Excel for Mac Interface

      • Guy Hart-Davis
      Pages 3-47

    3. Configuring Excel to Suit the Way You Work

      • Guy Hart-Davis
      Pages 49-65

    4. Creating Effective Workbooks and Templates

      • Guy Hart-Davis
      Pages 67-99

    5. Formatting Your Worksheets Quickly and Efficiently

      • Guy Hart-Davis
      Pages 101-142

  3. Performing Calculations and Presenting Data

    1. Front Matter

      Pages 143-144
      Download chapter PDF

    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

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

      • Guy Hart-Davis
      Pages 245-260

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

      • Guy Hart-Davis
      Pages 261-281

  4. Analyzing Data and Sharing and Automating Workbooks

    1. Front Matter

      Pages 283-283
      Download chapter PDF

    2. Creating Databases Using Tables

      • Guy Hart-Davis
      Pages 285-304

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

      • Guy Hart-Davis
      Pages 305-327

    4. Analyzing Data with PivotTables

      • Guy Hart-Davis
      Pages 329-359

    5. Collaborating and Sharing with Macs and Windows PCs

      • Guy Hart-Davis
      Pages 361-389

  5. Back Matter

    Pages 391-399
    Download chapter PDF
Back to top

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

Publish with us

Policies and ethics

Back to top

Search

Navigation