Excel 2016 All-in-One For Dummies

  • 14h 6m
  • Greg Harvey
  • John Wiley & Sons (US)
  • 2016

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.

Written by expert Greg Harvey, who has sold more than 4.5 million copies of his previous books combined and has taught and trained extensively in Microsoft Excel, this all-encompassing guide offers everything you need to get started with Excel. From generating pivot tables and performing financial functions to performing error trapping and building and running macros—and everything in between—this hands-on, friendly guide makes working with Excel easier than ever before.

  • Serves as the ideal reference for solving common questions and Excel pain points quickly and easily
  • Helps to increase productivity and efficiency when working in Excel
  • Fully updated for the new version of Excel
  • Covers basic and more advanced Excel topics

If working in Excel occasionally makes you want to scream, this will be the dog-eared, dust-free reference you'll turn to again and again.

About the Author

Greg Harvey, PhD, is the president of Mind Over Media, LLC., and a bestselling author of books on Excel, including all editions of Excel For Dummies and Excel Workbook For Dummies. He began teaching business users about computers back in the 1980s, and has been a dedicated educator ever since.

In this Book

  • Introduction
  • The Excel 2016 User Experience
  • Customizing Excel 2016
  • Building Worksheets
  • Formatting Worksheets
  • Editing and Proofing Worksheets
  • Managing Worksheets
  • Printing Worksheets
  • Building Basic Formulas
  • Logical Functions and Error Trapping
  • Date and Time Formulas
  • Financial Formulas
  • Math and Statistical Formulas
  • Lookup, Information, and Text Formulas
  • Protecting Workbooks and Worksheet Data
  • Using Hyperlinks
  • Sending Workbooks Out for Review
  • Sharing Workbooks and Worksheet Data
  • Charting Worksheet Data
  • Adding Graphic Objects
  • Building and Maintaining Data Lists
  • Filtering and Querying a Data List
  • Performing What-If Scenarios
  • Performing Large-Scale Data Analysis
  • Recording and Running Macros
  • VBA Programming