Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

Excel 2013 Bible 1st Edition

4.5 out of 5 stars 127 customer reviews
ISBN-13: 978-1118490365
ISBN-10: 1118490363
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Trade in your item
Get a $5.22
Gift Card.
Have one to sell? Sell on Amazon
Rent On clicking this link, a new layer will be open
$14.97 On clicking this link, a new layer will be open
Buy used On clicking this link, a new layer will be open
$25.59 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$30.52 On clicking this link, a new layer will be open
More Buying Choices
90 New from $21.99 90 Used from $17.21
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Top 20 lists in Books
Top 20 lists in Books
View the top 20 best sellers of all time, the most reviewed books of all time and some of our editors' favorite picks. Learn more
$30.52 FREE Shipping. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.
click to open popover


Frequently Bought Together

  • Excel 2013 Bible
  • +
  • Microsoft Excel 2013 Functions & Formulas Quick Reference Card (4-page Cheat Sheet focusing on examples and context for intermediate-to-advanced functions and formulas- Laminated Guide)
  • +
  • Microsoft Excel 2013 Introduction Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card)
Total price: $38.28
Buy the selected items together

Editorial Reviews

Amazon.com Review

Q & A with John Walkenbach, author of Excel 2013 Bible

Seth Kahan
John Walkenbach
How long have you been using Excel?

My first spreadsheet experience was using VisiCalc, running on an Apple II computer owned by my employer. I eventually saved up and bought my own IBM-PC, and started using Lotus 1-2-3. At some point, probably around 1988, I tried out Excel, which included a run-time version of Windows. I thought the graphic user interface was just a gimmick, and I much preferred 1-2-3. But by Version 4 (released in 1992), I was hooked on Excel, and preferred it to the competitors. So, to answer your question . . . about 25 years.

How has Excel changed the way people do business?

Among other ways, it puts data in the hands of users, and makes it easy to slice and dice information. People can run their own ad-hoc reports, and not have to rely on others to provide information.

Any advice for new Excel users?

Be curious and don't be afraid to experiment. The Ribbon has hundreds of commands, and it's worth the time to dig around and see what they do. If you find something that seems useful, just work with it until you understand how it works. And, master the art of searching the web. There are countless Excel questions that have already been asked and answered.

What is your favorite Excel 2013 feature?

Well, my favorite Excel feature, by far, is pivot tables. But if you're asking about features new to Excel 2013, it would have to be Flash Fill. It uses pattern recognition to transform a column of data (no formulas required). For example, you can use Flash Fill to extract last names from a column of names. It also works in the opposite direction, so you can combine multiple columns using Flash Fill. It’s not perfect, and it sometimes fails to identify some patterns so you need to check the results carefully. But, I expect to see this feature improved in future versions.

What do you like most about writing about Excel?

It's when I first install the beta of a new version. It's always fun to see what's new and different. And, of course, I like the fact that I get very long vacations in between revisions.

What is your all-time best Excel tip?

It's impossible to come up with one, but if forced to reply, I'd have to say it's the multi-cell array formula that I developed. This formula is entered into a 6-row x 7-column range of cells and displays a monthly calendar. The formula uses a cell that contains a date and updates when that date cell is changed.

What can you do with Excel that might surprise people?

You can actually earn a living by writing about it!

But seriously, Excel is such a flexible product, there is almost no limit to what it can do. Even I'm surprised by some of the things I see. For example, I've seen some amazing games that run in Excel. And I've also seen some charts that I would have thought to be impossible. As the saying goes, it's limited only by your creativity--and there are some very creative Excel users out there.

From the Back Cover

Excel at Excel with this ultimate guide

Whether you want to create charts, import and clean data, automate tasks with VBA macros, or work in the cloud—however you want to use Excel, John Walkenbach can show you how. Fully updated for the latest features in Excel 2013, this perennial bestseller is packed with information, techniques, helpful notes, and tips to take your spreadsheet skills to the next level. Beginner, power user, or somewhere in between, this is the ultimate Excel resource you'll turn to again and again.

  • Get up to speed on everything new in Excel 2013
  • Review Excel basics—worksheets, formulas, functions, and charts
  • Learn to handle data in many ways, including importing, cleaning, and analyzing
  • Master useful Excel tools, such as Sparklines, Flash Fill, and Analysis ToolPak
  • Discover the power of Excel's ultimate analysis tool—pivot tables
  • Create VBA macros, add controls, and work with Excel events
  • Slice and dice your data to identify trends and patterns
  • Work your way through sample workbooks and take advantage of downloadable templates on the companion website

Use formulas and functions to create useful forms

Learn which chart is most suitable for your data

Pivot table slicers make it easy to filter data

NO_CONTENT_IN_FEATURE

More to Explore
Check out some of the new worksheet functions (PDF) and get a quick intro (PDF) to Data Explorer in Excel 2013.

Product Details

  • Series: Bible (Book 1)
  • Paperback: 1056 pages
  • Publisher: Wiley; 1 edition (March 4, 2013)
  • Language: English
  • ISBN-10: 1118490363
  • ISBN-13: 978-1118490365
  • Product Dimensions: 7.4 x 2 x 9.3 inches
  • Shipping Weight: 3.6 pounds (View shipping rates and policies)
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (127 customer reviews)
  • Amazon Best Sellers Rank: #8,628 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

Format: Paperback Verified Purchase
I have become a very accomplished Excel office guru due mostly in part to John Walkenbach's Excel Books. I started off With Excel 95 and moved on to Excel Formulas, Excel VBA, Excel Bible etc. As a matter of fact I have been able to use my Excel knowledge that I learned from Reading Walkenbach books to make around 5K in the last 10 years, and that's not even trying. When people see my Excel work they asked me where I went to school, and I tell them I didn't. Then they ask how did you learn this, and I tell them I read a book. They then look at me and ask "What book? I want to get that one." That's when I tell them about John's books.

Looking at my library I have 10 Walkenbach books (Even a Chinese one). Though I no longer need the book I ordered it for my son's whom are just now learning Excel, and what better way to learn from the best. Looking over the book it's clearly written with many valuable examples. What I find is when you are learning it's not enough to just explain how to do something, but to show you a picture and an example give you 10x the learning experience. This book doesn't disappoint in this area for it has many examples.

Earlier I said I had become the Office guru and didn't need this book, and bought it for my Son's. Well guess what? I learned something! Yes even a person who has been using Excel for years should find something in this book that they didn't know, or a better way to do something.

The one thing that I miss in this book is there is no attached CD with example files. These files are invaluable in saving time when learning, but the examples are in the book, one would just need to type them in, and it's certainly not a deal breaker.

So bottom line if you want to learn Excel this book is for you.
Read more ›
4 Comments 65 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
As I've mentioned in reviews of other works by Walkenback, his work is outstanding. This is indeed a reference book. If you sit down and read this at one setting, cover to cover, you may need medical attention.

As far as a complete, well organized book on Excel? There is no other compared to this book. Get it, keep it handy, you will really enjoy the speed with which you can find material of immediate value to your work.
3 Comments 26 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
When I bought this Excel "Bible", I expected to find all Excel features exhaustively discussed. In particular, I hoped to find something about the "Advanced Filter" which I had been having trouble using. However it's not even listed in the index and as far as I know never mentioned in the text. Apparently the author either doesn't think it's important or for some other reason. He omitted it, not only from this book but also his "Power Programming with VBA" as well. (I did find an excellent extensive discussion of the Advanced Filter feature in Jelen and Syrstad's "VBA and Macros"). I was also frustrated by Walkenbach's extensive list of VBA functions that only list function names and terse descriptions, but nothing about the arguments of these functions. Lacking further details, just the function names by themselves seems worthless. The material that the author does cover, he does go into in great detail in a very clear and authoritative manner. Maybe I just expected too much from a big book with "Bible" in the title
Comment 29 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
Intense and comprehensive resource; complete with formulas, syntax and "On the Web" illustrations. "Notes" are provided on what and what-not-to expect to see in various applications; as well as, performance "Tips ". There are valuable Appendixes on Worksheet Function References and great navigational Excel Shortcut Keys. Love the tables throughtout the book.
Comment 19 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
The Excel 2013 Bible is an excellent resource for the latest version of Excel. All aspects of the software are covered including the new features of the 2013 version. I recommned it to all beggining and intermediate users of MS Excel.
Comment 11 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Kindle Edition Verified Purchase
This is a huge book, but it is well organized and has a good index. So far, I've been able to find the answers to all my questions about using Excel 2013. Finding the answers takes careful reading and trying the examples, but I do find them. I think it's a good book for one who wants to get the most out of Excel 2013.
Comment 6 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
I like to have a book in-hand while I'm working on the computer. Keeps you from having to switch back and forth between screens.
Comment 8 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
This book is excellent. It is written for a beginner or an advanced user in easy to understand language! I am an advanced user and bought this to sharpen my skills and it is well worth the purchase. I am skimming through the basics and learning some new techniques that will save me time at my job as well reading about more complicated features that will greatly reduce my workload. Everything that I want to know is included in the book. I have several Excel books from different authors and this is the book that I will keep handy for quick reference as well as reading in detail. I highly recommend this book!
Comment 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Set up an Amazon Giveaway

Excel 2013 Bible
Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
This item: Excel 2013 Bible