+612 9045 4394
Excel 2016 All-in-One For Dummies : For Dummies (Computer/Tech) - Greg Harvey

Excel 2016 All-in-One For Dummies

For Dummies (Computer/Tech)


Published: 6th November 2015
Ships: 15 business days
15 business days
RRP $56.95

eBook View Product

Published: 30th October 2015
Format: ePUB

Your one-stop guide to all things Excel 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.



by PowerReviews

(based on 1 review)

Ratings Distribution

  • 5 Stars



  • 4 Stars



  • 3 Stars



  • 2 Stars



  • 1 Stars



Reviewed by 1 customer

Displaying review 1

Back to top


Worth while read


from Australia

About Me Everyday Reader

Verified Buyer


  • Easy To Read
  • Informative
  • Well Written


    Best Uses

      Great book if you use excel on a daily basis. Will definitely make worklife mre efficient.

      Displaying review 1

      Back to top

      Introduction 1

      Book I: Excel Basics 11

      Chapter 1: The Excel 2016 User Experience 13

      Chapter 2: Customizing Excel 2016 43

      Book II: Worksheet Design 75

      Chapter 1: Building Worksheets 77

      Chapter 2: Formatting Worksheets 127

      Chapter 3: Editing and Proofing Worksheets 185

      Chapter 4: Managing Worksheets 233

      Chapter 5: Printing Worksheets 269

      Book III: Formulas and Functions 297

      Chapter 1: Building Basic Formulas 299

      Chapter 2: Logical Functions and Error Trapping 341

      Chapter 3: Date and Time Formulas 363

      Chapter 4: Financial Formulas 379

      Chapter 5: Math and Statistical Formulas 393

      Chapter 6: Lookup, Information, and Text Formulas 413

      Book IV: Worksheet Collaboration and Review 435

      Chapter 1: Protecting Workbooks and Worksheet Data 437

      Chapter 2: Using Hyperlinks 459

      Chapter 3: Sending Workbooks Out for Review 467

      Chapter 4: Sharing Workbooks and Worksheet Data 495

      Book V: Charts and Graphics 519

      Chapter 1: Charting Worksheet Data 521

      Chapter 2: Adding Graphic Objects 553

      Book VI: Data Management 581

      Chapter 1: Building and Maintaining Data Lists 583

      Chapter 2: Filtering and Querying a Data List 607

      Book VII: Data Analysis 649

      Chapter 1: Performing What-If Scenarios 651

      Chapter 2: Performing Large-Scale Data Analysis 675

      Book VIII: Macros and VBA 721

      Chapter 1: Recording and Running Macros 723

      Chapter 2: VBA Programming 735

      Index 759

      ISBN: 9781119077152
      ISBN-10: 111907715X
      Series: For Dummies (Computer/Tech)
      Audience: General
      Format: Paperback
      Language: English
      Number Of Pages: 816
      Published: 6th November 2015
      Publisher: John Wiley & Sons Inc
      Country of Publication: US
      Dimensions (cm): 23.5 x 18.5  x 4.0
      Weight (kg): 1.04
      Edition Number: 1