Excel 2016 for Dummies

Description

The book covers everything you need to know to perform the task at hand. Includes information on creating and editing worksheets, formatting cells, entering formulas, creating and editing charts, inserting graphs, designing database forms, adding database records, using seek-and-find options, printing, adding hyperlinks to worksheets, saving worksheets as web pages, adding existing worksheet data to an existing webpage and sending worksheets via e-mail.

About the Author

Greg Harvey is the president of Mind Over Media

Table of Contents

Introduction

Part I: Getting Started with Excel 2016

Chapter 1: The Excel 2016 User Experience

Chapter 2: Creating a Spreadsheet from Scratch

Part II: Editing without Tears

Chapter 3: Making It All Look Pretty

Chapter 4: Going Through Changes

Chapter 5: Printing the Masterpiece

Part III: Getting Organized and Staying That Way

Chapter 6: Maintaining the Worksheet

Chapter 7: Maintaining Multiple Worksheets

Part IV: Digging Data Analysis

Chapter 8: Doing What If Analysis

Chapter 9: Playing with Pivot Tables

Part V: Life beyond the Spreadsheet

Chapter 10: Charming Charts and Gorgeous Graphics

Chapter 11: Getting on the Data List

Chapter 12: Linking, Automating and Sharing Spreadsheets

Part VI: The Part of Tens

Chapter 13: Top Ten Beginner Basics

Chapter 14: The Ten Commandments of Excel 2016

Chapter 15: Top Ten Ways to Manage Your Data

Chapter 16: Top Ten Ways to Analyze Your Data

Index