Learn Excel 2016 for OS X

by Guy Hart-Davis

Overview

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.

Product Details

ISBN-13:	9781484210208
Publisher:	Apress
Publication date:	10/29/2015
Edition description:	1st ed.
Pages:	399
Product dimensions:	7.01(w) x 10.00(h) x (d)

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

Table of Contents

Part 1: Becoming Proficient with Excel for Mac

Chapter 1: Learning the Secrets of the Excel for Mac Interface

Chapter 2: Configuring Excel to Suit the Way You Work

Chapter 3: Creating Effective Workbooks and Templates

Chapter 4: Formatting Your Worksheets Quickly and Efficiently

Part 2: Perforating Calculations and Presenting Data

Chapter 5: Performing Custom Calculations with Formulas

Chapter 6: Using Excel’s Built-In Functions

Chapter 7: Creating Clear and Persuasive Charts

Chapter 8: Using Data Bars, Color Scales, Icon Sets, and Sparklines

Chapter 9: Illustrating Your Worksheets with Pictures, SmartArt, and More

Part 3: Analyzing Data and Sharing and Automating Workbooks

Chapter 10: Creating Databases Using Tables

Chapter 11: Solving Business Questions with What-It Analysis, Goal Seek, and Solver

Chapter 12: Analyzing Data with PivotTables

Chapter 13: Collaborating and Sharing with Macs and Windows PCs

Editorial 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)

From the Publisher