+612 9045 4394
Excel 2013 Bible : Excel Bible - John Walkenbach

Excel 2013 Bible

Excel Bible


Published: 22nd February 2013
Ships: 15 business days
15 business days
RRP $71.95

eBook View Product

Published: 5th February 2013
Format: ePUB

Excel at Excel with the help of this bestselling spreadsheet guide.

John Walkenbach's name is synonymous with excellence in computer books that decipher the complexities of Microsoft Excel. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of Excel 2013 while bringing you up to speed on the latest features. This perennial bestseller is fully updated to cover all the new features of Excel 2013, including how to navigate the user interface, take advantage of various file formats, master formulas, analyze data with PivotTables, and more.

Whether you're an Excel beginner who is looking to get more savvy or an advanced user looking to become a power user, this latest edition provides you with comprehensive coverage as well as helpful tips, tricks, and techniques that you won't find anywhere else.

  • Shares the invaluable insight of Excel guru and bestselling author "Mr. Spreadsheet" John Walkenbach as he guides you through every aspect of Excel 2013
  • Provides essential coverage of all the newest features of Excel 2013
  • Presents material in a clear, concise, logical format that is ideal for all levels of Excel experience
  • Features a website that includes downloadable templates and worksheets from the book
Chart your path to fantastic formulas and stellar spreadsheets with Excel 2013 Bible!

About the Author

John Walkenbach (aka "Mr. Spreadsheet") is a leading authority on spreadsheet software, creator of the award-winning Power Utility Pak, and principal of J-Walk and Associates, Inc. He is a bestselling Excel author who has published more than 50 books about spreadsheets.



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


A great general resource


from Sydney, AU

About Me Rarely Read

Verified Buyer


  • Easy To Read
  • Informative
  • Well Written


    Best Uses

    • Education
    • Reference

    This book is very easy to read, and well structured so even if you already use a lot of functions in Excel it is easy to find things you're unsure of or want to learn more about. I use Excel daily with my job and have an intermediate knowledge of macros but I have still found this book useful for gaining some more shortcuts and ideas.

    Displaying review 1

    Back to top

    Acknowledgments ix

    Introduction xxxvii

    Is This Book for You? xxxvii

    Software Versions xxxvii

    Conventions Used in This Book xxxviii

    Excel commands xxxviii

    Filenames, named ranges, and your input xxxviii

    Key names xxxviii

    Functions xxxviii

    Mouse conventions xxxix

    How This Book Is Organized xl

    How to Use This Book  xl

    What?s on the Website xli

    Part I: Getting Started with Excel 1

    Chapter 1: Introducing Excel 3

    Chapter 2: Entering and Editing Worksheet Data 29

    Chapter 3: Essential Worksheet Operations 49

    Chapter 4: Working with Cells and Ranges 69

    Chapter 5: Introducing Tables 101

    Chapter 6: Worksheet Formatting 119

    Chapter 7: Understanding Excel Files 145

    Chapter 8: Using and Creating Templates 161

    Chapter 9: Printing Your Work 171

    Part II: Working with Formulas and Functions 193

    Chapter 10: Introducing Formulas and Functions 195

    Chapter 11: Creating Formulas That Manipulate Text 231

    Chapter 12: Working with Dates and Times 251

    Chapter 13: Creating Formulas That Count and Sum 285

    Chapter 14: Creating Formulas That Look Up Values 313

    Chapter 15: Creating Formulas for Financial Applications 333

    Chapter 16: Miscellaneous Calculations 359

    Chapter 17: Introducing Array Formulas 373

    Chapter 18: Performing Magic with Array Formulas 397

    Part III: Creating Charts and Graphics 419

    Chapter 19: Getting Started Making Charts 421

    Chapter 20: Learning Advanced Charting 457

    Chapter 21: Visualizing Data Using Conditional Formatting 503

    Chapter 22: Creating Sparkline Graphics 525

    Chapter 23: Enhancing Your Work with Pictures and Drawings 539

    Part IV: Using Advanced Excel Features 561

    Chapter 24: Customizing the Excel User Interface 563

    Chapter 25: Using Custom Number Formats 573

    Chapter 26: Using Data Validation 591

    Chapter 27: Creating and Using Worksheet Outlines 603

    Chapter 28: Linking and Consolidating Worksheets 613

    Chapter 29: Excel and the Internet 631

    Chapter 30: Protecting Your Work 643

    Chapter 31: Making Your Worksheets Error Free 655

    Part V: Analyzing Data with Excel 683

    Chapter 32: Importing and Cleaning Data 685

    Chapter 33: Introducing Pivot Tables 715

    Chapter 34: Analyzing Data with Pivot Tables 739

    Chapter 35: Performing Spreadsheet What-If Analysis 777

    Chapter 36: Analyzing Data Using Goal Seeking and Solver 793

    Chapter 37: Analyzing Data with the Analysis ToolPak 813

    Part VI: Programming Excel with VBA 825

    Chapter 38: Introducing Visual Basic for Applications 827

    Chapter 39: Creating Custom Worksheet Functions 855

    Chapter 40: Creating UserForms 869

    Chapter 41: Using UserForm Controls in a Worksheet 889

    Chapter 42: Working with Excel Events 903

    Chapter 44: Creating Custom Excel Add-Ins 931

    Part VII: Appendixes 941

    Appendix A: Worksheet Function Reference 943

    Appendix B: Excel Shortcut Keys 961

    Index 967

    ISBN: 9781118490365
    ISBN-10: 1118490363
    Series: Excel Bible
    Audience: General
    Format: Paperback
    Language: English
    Number Of Pages: 1056
    Published: 22nd February 2013
    Publisher: John Wiley & Sons Inc
    Country of Publication: US
    Dimensions (cm): 23.4 x 18.8  x 5.2
    Weight (kg): 1.38
    Edition Number: 1