Cart
Free Shipping in Australia
Proud to be B-Corp

Excel 2016 All-in-One For Dummies Greg Harvey

Excel 2016 All-in-One For Dummies By Greg Harvey

Excel 2016 All-in-One For Dummies by Greg Harvey


$37.99
Condition - Very Good
7 in stock

Summary

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.

Excel 2016 All-in-One For Dummies Summary

Excel 2016 All-in-One For Dummies by Greg Harvey

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

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.

Table of Contents

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

Additional information

GOR007757327
9781119077152
111907715X
Excel 2016 All-in-One For Dummies by Greg Harvey
Used - Very Good
Paperback
John Wiley & Sons Inc
2015-11-06
816
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in very good condition, but if you are not entirely satisfied please get in touch with us

Customer Reviews - Excel 2016 All-in-One For Dummies