Learn Excel 2016 for OS X 2nd Edition + code

Купить бумажную книгу и читать

Название:Learn Excel 2016 for OS X

Автор:Guy Hart-Davis

Издательство: APRESS

Год: 2015

Страниц: 426

Язык: English

Формат: epub+code

Размер: 8 Mb

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

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.

What you’ll learn

How to create effective workbooks and templates

How to quickly format worksheets

How to perform custom calculations and formulas

What kind of creative and persuasive charts

How to illustrate your worksheets with SmartArt, pictures, and more

What business problem solving can be done with Excel

How to analyze data with pivot tables

How to automate tasks with Visual Basic for Applications (VBA)

Who this book is for

Beginning and intermediate users looking to get up to speed quickly with the Excel 2016 application and use it productively, both online and offline

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

epub+code