Wiley.com
Print this page Share

Excel 2016 Bible

ISBN: 978-1-119-06751-1
1152 pages
October 2015
Excel 2016 Bible (1119067510) cover image

Description

The complete guide to Excel 2016, from Mr. Spreadsheet himself

Whether you are just starting out or an Excel novice, the Excel 2016 Bible is your comprehensive, go-to guide for all your Excel 2016 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities by expert author and Excel Guru John Walkenbach to take full advantage of what the updated version offers. Learn to incorporate templates, implement formulas, create pivot tables, analyze data, and much more.

Navigate this powerful tool for business, home management, technical work, and much more with the only resource you need, Excel 2016 Bible.

  • Create functional spreadsheets that work
  • Master formulas, formatting, pivot tables, and more
  • Get acquainted with Excel 2016's new features and tools
  • Customize downloadable templates and worksheets

Whether you need a walkthrough tutorial or an easy-to-navigate desk reference, the Excel 2016 Bible has you covered with complete coverage and clear expert guidance.

See More

Table of Contents

Acknowledgments ix

Introduction xli

Part I: Getting Started with Excel 1

Chapter 1: Introducing Excel 3

Chapter 2: Entering and Editing Worksheet Data 9

Chapter 3: Essential Worksheet Operations 51

Chapter 4: Working with Cells and Ranges 73

Chapter 5: Introducing Tables 109

Chapter 6: Worksheet Formatting 129

Chapter 7: Understanding Excel Files 157

Chapter 8: Using and Creating Templates 171

Chapter 9: Printing Your Work 181

Part II: Working with Formulas and Functions 205

Chapter 10: Introducing Formulas and Functions 207

Chapter 11: Creating Formulas That Manipulate Text 243

Chapter 12: Working with Dates and Times 263

Chapter 13: Creating Formulas That Count and Sum 297

Chapter 14: Creating Formulas That Look Up Values 327

Chapter 15: Creating Formulas for Financial Applications 349

Chapter 16: Miscellaneous Calculations 381

Chapter 17: Introducing Array Formulas 395

Chapter 18: Performing Magic with Array Formulas 421

Part III: Creating Charts and Graphics 445

Chapter 19: Getting Started Making Charts 447

Chapter 20: Learning Advanced Charting 491

Chapter 21: Visualizing Data Using Conditional Formatting 539

Chapter 22: Creating Sparkline Graphics 563

Chapter 23: Enhancing Your Work with Pictures and Drawings 579

Part IV: Using Advanced Excel Features 601

Chapter 24: Customizing the Excel User Interface 603

Chapter 25: Using Custom Number Formats 613

Chapter 26: Using Data Validation 633

Chapter 27: Creating and Using Worksheet Outlines 647

Chapter 28: Linking and Consolidating Worksheets 657

Chapter 29: Excel and the Internet 677

Chapter 30: Protecting Your Work 689

Chapter 31: Making Your Worksheets Error Free 701

Part V: Analyzing Data with Excel 731

Chapter 32: Importing and Cleaning Data 733

Chapter 33: Introducing Pivot Tables 763

Chapter 34: Analyzing Data with Pivot Tables 785

Chapter 35: Performing Spreadsheet What-If Analysis 823

Chapter 36: Analyzing Data Using Goal Seeking and Solver 841

Chapter 37: Analyzing Data with the Analysis ToolPak 863

Chapter 38: Working with Get & Transform 877

Part VI: Programming Excel with VBA 907

Chapter 39: Introducing Visual Basic for Applications 909

Chapter 40: Creating Custom Worksheet Functions 939

Chapter 41: Creating UserForms 955

Chapter 42: Using UserForm Controls in a Worksheet 977

Chapter 43: Working with Excel Events 993

Chapter 44: VBA Examples 1005

Chapter 45: Creating Custom Excel Add-Ins 1021

Part VII: Appendixes 1031

Appendix A: Worksheet Function Reference 1033

Appendix B: Excel Shortcut Keys 1053

Index 1061

See More

Author Information

John Walkenbach, principal of J-Walk and Associates, Inc., is a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak. He has written more than 50 books and 300 articles and reviews for publications including PC World, InfoWorld, and Windows.

See More

Downloads

Download TitleSizeDownload
Readme 308 bytes Click to Download
Code Download :: Appendix A 60.17 KB Click to Download
Code Download :: Chapter 1 11.93 KB Click to Download
Code Download :: Chapter 2 13.93 KB Click to Download
Code Download :: Chapter 4 12.21 KB Click to Download
Code Download :: Chapter 5 25.15 KB Click to Download
Code Download :: Chapter 6 88.01 KB Click to Download
Code Download :: Chapter 10 17.09 KB Click to Download
Code Download :: Chapter 11 55.58 KB Click to Download
Code Download :: Chapter 12 313.50 KB Click to Download
Code Download :: Chapter 13 85.72 KB Click to Download
Code Download :: Chapter 14 39.00 KB Click to Download
Code Download :: Chapter 15 159.58 KB Click to Download
Code Download :: Chapter 16 13.85 KB Click to Download
Code Download :: Chapter 17 19.34 KB Click to Download
Code Download :: Chapter 18 80.75 KB Click to Download
Code Download :: Chapter 19 328.08 KB Click to Download
Code Download :: Chapter 20 1.29 MB Click to Download
Code Download :: Chapter 21 343.76 KB Click to Download
Code Download :: Chapter 22 25.18 KB Click to Download
Code Download :: Chapter 23 261.78 KB Click to Download
Code Download :: Chapter 25 11.79 KB Click to Download
Code Download :: Chapter 26 15.23 KB Click to Download
Code Download :: Chapter 27 33.24 KB Click to Download
Code Download :: Chapter 28 36.33 KB Click to Download
Code Download :: Chapter 29 205.31 KB Click to Download
Code Download :: Chapter 32 380.49 KB Click to Download
Code Download :: Chapter 33 78.33 KB Click to Download
Code Download :: Chapter 34 2.35 MB Click to Download
Code Download :: Chapter 35 40.13 KB Click to Download
Code Download :: Chapter 36 55.82 KB Click to Download
Code Download :: Chapter 37 80.63 KB Click to Download
Code Download :: Chapter 38 4.78 MB Click to Download
Code Download :: Chapter 39 41.98 KB Click to Download
Code Download :: Chapter 40 19.62 KB Click to Download
Code Download :: Chapter 41 34.41 KB Click to Download
Code Download :: Chapter 42 1.53 MB Click to Download
Code Download :: Chapter 43 24.69 KB Click to Download
Code Download :: Chapter 44 139.91 KB Click to Download
Code Download :: Chapter 45 32.05 KB Click to Download
See More

Related Titles

Back to Top