Excel 2016 All-in-One For Dummies, 1st Edition

  • Greg Harvey
  • Published By:
  • ISBN-10: 1119077273
  • ISBN-13: 9781119077275
  • DDC: 005.54
  • Grade Level Range: College Freshman - College Senior
  • 816 Pages | eBook
  • Original Copyright 2016 | Published/Released August 2017
  • This publication's content originally published in print form: 2016

  • Price:  Sign in for price

About

Overview

Excel 2016 All-in-One For Dummies, the most comprehensive Excel reference on the market, is completely updated to reflect Microsoft's changes in the popular spreadsheet tool. It offers you everything you need to grasp basic Excel functions, such as creating and editing worksheets, setting up formulas, importing data, performing statistical functions, editing macros with Visual Basic—and beyond. In no time, your Excel skills will go from 'meh' to excellent.

Table of Contents

Front Cover.
Title Page.
Copyright Page.
Contents at a Glance.
Table of Contents.
Introduction.
Excel Basics.
1: The Excel 2016 User Experience.
2: Customizing Excel 2016.
Worksheet Design.
3: Building Worksheets.
4: Formatting Worksheets.
5: Editing and Proofing Worksheets.
6: Managing Worksheets.
7: Printing Worksheets.
Formulas and Functions.
8: Building Basic Formulas.
9: Logical Functions and Error Trapping.
10: Date and Time Formulas.
11: Financial Formulas.
12: Math and Statistical Formulas.
13: Lookup, Information, and Text Formulas.
Worksheet Collaboration and Review.
14: Protecting Workbooks and Worksheet Data.
15: Using Hyperlinks.
16: Sending Workbooks Out for Review.
17: Sharing Workbooks and Worksheet Data.
Charts and Graphics.
18: Charting Worksheet Data.
19: Adding Graphic Objects.
Data Management.
20: Building and Maintaining Data Lists.
21: Filtering and Querying a Data List.
Data Analysis.
22: Performing What-If Scenarios.
23: Performing Large-Scale Data Analysis.
Macros and VBA.
24: Recording and Running Macros.
25: VBA Programming.
Index.
About the Author.
Dedication.
Author's Acknowledgments.