Microsoft Excel Bible series all in one

This article along with all titles and tags are the original content of AppNee. All rights reserved. To repost or reproduce, you must add an explicit footnote along with the URL to this article!
Any manual or automated whole-website collecting/crawling behaviors are strictly prohibited.
Any resources shared on AppNee are limited to personal study and research only, any form of commercial behaviors are strictly prohibited. Otherwise, you may receive a variety of copyright complaints and have to deal with them by yourself.
Before using (especially downloading) any resources shared by AppNee, please first go to read our F.A.Q. page more or less. Otherwise, please bear all the consequences by yourself.
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.

Microsoft Excel is the powerful, widely used and most popular spreadsheet software. Almost every computer user should use it sometime, meanwhile it is also a relatively complex software to use.

Excel Bible (AKA: Microsoft Excel Bible) covers almost all functions of Microsoft Excel 2003, 2007, 2010, 2013, 2016, 2019, 365 informative and focused. It has both the introduction to basic knowledge and detail, expansion to key functions, a lot of knowledge introduced of which does not exist in other similar books. So, for each Excel software users (either primary or advanced users), this book has great reference value, and could be a real sense of bible class library.

In short, under the direction of the world’s top Excel authoritative expert John Walkenbach, this ultimate guide for fully grasping Excel can definitely upgrade your spreadsheet skills to a brand new level.

// Table Of Contents //

  • 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

// Book Example Codes //

// Download URLs //

Format Download Size
Excel 2003 Bible
PDF reserved MB
Excel 2007 Bible
PDF reserved MB
Excel 2010 Bible
PDF AppNee.com 16.2 MB
Excel 2013 Bible
PDF AppNee.com 13.6 MB
Excel 2016 Bible
PDF AppNee.com 23.8 MB
Excel 2019 Bible
PDF AppNee.com 17.7 MB
Excel 365 Bible
PDF AppNee.com MB

(Homepage)

If some download link is missing, and you do need it, just please send an email (along with post link and missing link) to remind us to reupload the missing file for you. And, give us some time to respond.
If there is a password for an archive, it should be "appnee.com".
Most of the reserved downloads (including the 32-bit version) can be requested to reupload via email.