Excel 2013 Bible

( 2 )

Overview

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 ...

See more details below
Paperback
$29.73
BN.com price
(Save 40%)$49.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (21) from $24.99   
  • New (13) from $24.99   
  • Used (8) from $27.87   
Excel 2013 Bible

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$28.49
BN.com price
(Save 43%)$49.99 List Price

Overview

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!

Read More Show Less

Product Details

  • ISBN-13: 9781118490365
  • Publisher: Wiley
  • Publication date: 3/4/2013
  • Series: Bible Series
  • Edition number: 1
  • Pages: 1056
  • Sales rank: 71,375
  • Product dimensions: 7.30 (w) x 9.20 (h) x 2.40 (d)

Meet 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. He maintains the popular Spreadsheet Page at www.spreadsheetpage.com.

Read More Show Less

Table of Contents

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

Read More Show Less

Customer Reviews

Average Rating 3
( 2 )
Rating Distribution

5 Star

(1)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(1)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 2 Customer Reviews
  • Anonymous

    Posted March 8, 2014

    No text was provided for this review.

  • Anonymous

    Posted March 15, 2014

    No text was provided for this review.

Sort by: Showing all of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)