What do you think?
Rate this book
Excel 2010 Bible
A comprehensive reference to the newest version of the world's most popular spreadsheet Excel 2010 John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of all the new features of Excel 2010.An authoritative reference, this perennial bestseller proves itself indispensable no matter your level of skill, from Excel beginners and intermediate users to power users and potential power users everywhere. Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques you won't find anywhere else.Excel guru and bestselling author John Walkenbach ("Mr. Spreadsheet") guides you through every aspect of Excel Delivers essential coverage of all the newest features of Excel 2010 Presents material in a clear, concise, logical format that is ideal for all levels of Excel experience Includes a CD that contains all the templates and worksheets used in the book plus John Walkenbach's award-winning Power Utility Pak Excel 2010 Bible serves as an excellent resource on all things Excel! CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
1056 pages, Kindle Edition
First published January 1, 2012
32 people are currently reading
207 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 - 15 of 15 reviews
August 10, 2014
This tome comes in at 1K+ pages, but it is actually more like 400+. I did not bother to read the appendix or the VBA section - I would prefer to start coding with a book that doesn't simply reference, but teaches me. So I may return to that section some day. The distribution of information per page is quite liberal. That's natural since we are dealing with a plethora of graphical examples and syntax-specific code. This book is a reference, and it is not really meant to teach. You will probably pick up the more fundamental and less rigorous concepts of Excel but you will probably get lost when it gets into more advanced portions of each topic. Like string manipulation, and concatenation with other forms like logic and other advanced formulas. Sometimes you'll be able to understand how the formula emerges, but that isn't taught here.
This book is perfect for those that are well-versed in Excel, and want something to reference when the task at hand requires more complicated methods; or you have that familiarity with the software but you would like to get some sort of introduction to something new. For those that have never used Excel, I would suggest something more hands on, or something that teaches you through video. I suggest the ExploreExposure website, or better, the Microsoft official training videos. I have always come back to them - you're allowed to download them; and they are categorized based on rigor level. From there I would look around the internet for template practices and use this book, and the other two sources of information to help along the way.
This book is perfect for those that are well-versed in Excel, and want something to reference when the task at hand requires more complicated methods; or you have that familiarity with the software but you would like to get some sort of introduction to something new. For those that have never used Excel, I would suggest something more hands on, or something that teaches you through video. I suggest the ExploreExposure website, or better, the Microsoft official training videos. I have always come back to them - you're allowed to download them; and they are categorized based on rigor level. From there I would look around the internet for template practices and use this book, and the other two sources of information to help along the way.
April 3, 2015
An emotional roller coaster.
March 1, 2021
While this is extremely outdated in some regards, this is still extremely helpful for referencing, especially with formulas. This has been in various offices at my job and I have frequently referenced it when I needed to until the pandemic hit, then of course you have google, but my coworker gave me hers just about week ago.
August 6, 2020
Good book with a lot of tips and procedures
July 13, 2015
Yes, I read the entire book--from coverth to coverth! :-) Go me!
This book has some wonderful examples, is organized in a concise manner and includes a CD Rom to work through some of the examples/lessons described.
Here's what is in the book:
Part I
Chapter 1 - Introducing Excel (basic stuff)
Chapter 2 - Entering and Editing Worksheet Data (basic stuff)
Chapter 3 - Essential Worksheet Operations (basic stuff)
Chapter 4 - Working with Cells and Rangers (basic stuff)
Chapter 5 - Introducing Tables (basic stuff for me)
Chapter 6 - Worksheet Formatting (basic stuff for me)
Chapter 7 - Understanding Excel Files (recovering, sharing, password protection...)
Chapter 8 - Using and Creating Templates
Chapter 9 - Printing
Part II
Chapter 10 - Introducing Formulas and Functions
Chapter 11 - Creating Formulas that Manipulate Text
Chapter 12 - Working with Dates and Times
Chapter 13 - Creating Formulas that Count and Sum
Chapter 14 - Creating Formulas that Look up Values
Chapter 15 - Creating Formulas for Financial Applications
Chapter 16 - Introducing Array Formulas
Chapter 17 - Performing Magic with Array Formulas
Part III
Chapter 18 - Getting Started Making Charts
Chapter 19 - Learning Advanced Charting
Chapter 20 - Visualizing Data Using Conditional Formatting
Chapter 21 - Creating Sparkline Graphics (neat feature!)
Chapter 22 - Enhancing Your Work with Pictures and Drawings
Part IV
Chapter 23 - Customizing the Excel user Interface (customizing the ribbon and I would have put this in part I)
Chapter 24 - Using Custom Number Formats (I would put this in part I, too)
Chapter 25 - Using Data Validation
Chapter 26 - Creating and Using Worksheet Outlines
Chapter 27 - Linking and Consolidating Worksheets
Chapter 28 - Excel and the Internet
Chapter 29 - Sharing Data with Other Office Applications
Chapter 30 - Using Excel in a Workgroup
Chapter 31 - Protecting your Work (I would have put this in part I)
Chapter 32 - Making your Worksheet Error-Free (I would have put this in part I)
Part V
Chapter 33 - Getting Data from External Database Files (importing access tables, et)
Chapter 34 - Introducing Pivot Tables
Chapter 35 - Analyzing Data with Pivot Tables (I use this often)
Chapter 36 - Performing Spreadsheet What-If Analysis (very cool)
Chapter 37 - Analyzing Data Using Goal Seeking and Solver (very cool)
Chapter 38 - Analyzing Data with Analysis ToolPak (statistics, exponents, covariance, histogram, moving average)
Part VI
Chapter 39 - Introducing Visual Basic for Applications
Chapter 40 - Creating Custom Worksheet Functions
Chapter 41 - Creating UserForms
Chapter 42 - Using UserForm Controls in a Worksheet
Chapter 43 - Working with Excel Events
Chapter 44 - VBA Examples (working with ranges, workbooks, charts)
Chapter 45 - Creating Custom Excel Add-Ins
It would be neat to have the book in color, but that would no doubt cause a significant jump in price. I enjoyed the examples and most were fairly easy to follow along; however, I do have a strong background with Excel. Some things made more sense to me and others I had to test out as soon as I read about it.
This book does not cover everything and there are other books that go into more details on macros, formulas, etc. This book is 1006 pages! It's a whopper!
This book has some wonderful examples, is organized in a concise manner and includes a CD Rom to work through some of the examples/lessons described.
Here's what is in the book:
Part I
Chapter 1 - Introducing Excel (basic stuff)
Chapter 2 - Entering and Editing Worksheet Data (basic stuff)
Chapter 3 - Essential Worksheet Operations (basic stuff)
Chapter 4 - Working with Cells and Rangers (basic stuff)
Chapter 5 - Introducing Tables (basic stuff for me)
Chapter 6 - Worksheet Formatting (basic stuff for me)
Chapter 7 - Understanding Excel Files (recovering, sharing, password protection...)
Chapter 8 - Using and Creating Templates
Chapter 9 - Printing
Part II
Chapter 10 - Introducing Formulas and Functions
Chapter 11 - Creating Formulas that Manipulate Text
Chapter 12 - Working with Dates and Times
Chapter 13 - Creating Formulas that Count and Sum
Chapter 14 - Creating Formulas that Look up Values
Chapter 15 - Creating Formulas for Financial Applications
Chapter 16 - Introducing Array Formulas
Chapter 17 - Performing Magic with Array Formulas
Part III
Chapter 18 - Getting Started Making Charts
Chapter 19 - Learning Advanced Charting
Chapter 20 - Visualizing Data Using Conditional Formatting
Chapter 21 - Creating Sparkline Graphics (neat feature!)
Chapter 22 - Enhancing Your Work with Pictures and Drawings
Part IV
Chapter 23 - Customizing the Excel user Interface (customizing the ribbon and I would have put this in part I)
Chapter 24 - Using Custom Number Formats (I would put this in part I, too)
Chapter 25 - Using Data Validation
Chapter 26 - Creating and Using Worksheet Outlines
Chapter 27 - Linking and Consolidating Worksheets
Chapter 28 - Excel and the Internet
Chapter 29 - Sharing Data with Other Office Applications
Chapter 30 - Using Excel in a Workgroup
Chapter 31 - Protecting your Work (I would have put this in part I)
Chapter 32 - Making your Worksheet Error-Free (I would have put this in part I)
Part V
Chapter 33 - Getting Data from External Database Files (importing access tables, et)
Chapter 34 - Introducing Pivot Tables
Chapter 35 - Analyzing Data with Pivot Tables (I use this often)
Chapter 36 - Performing Spreadsheet What-If Analysis (very cool)
Chapter 37 - Analyzing Data Using Goal Seeking and Solver (very cool)
Chapter 38 - Analyzing Data with Analysis ToolPak (statistics, exponents, covariance, histogram, moving average)
Part VI
Chapter 39 - Introducing Visual Basic for Applications
Chapter 40 - Creating Custom Worksheet Functions
Chapter 41 - Creating UserForms
Chapter 42 - Using UserForm Controls in a Worksheet
Chapter 43 - Working with Excel Events
Chapter 44 - VBA Examples (working with ranges, workbooks, charts)
Chapter 45 - Creating Custom Excel Add-Ins
It would be neat to have the book in color, but that would no doubt cause a significant jump in price. I enjoyed the examples and most were fairly easy to follow along; however, I do have a strong background with Excel. Some things made more sense to me and others I had to test out as soon as I read about it.
This book does not cover everything and there are other books that go into more details on macros, formulas, etc. This book is 1006 pages! It's a whopper!
January 3, 2020
I use Excel everyday so you understand if I say this book is an "aquired taste." Excel 2013 is out now, so this is outdated, but the features being added in Excel are easy to implement but sometimes hard to understand the meaning in the ribbon or in the options/menus.
December 21, 2007
I can't work without this one.
May 6, 2008
Excel is truly diverse in its functionality. This book shows the almost limitless possibilites that Microsoft delivers with this software.
August 27, 2010
This is an excellent reference. I'm going to recommend we actually buy a copy, since I have to return this one to the library.
June 16, 2012
Excellent book. Really helped me to improve my Excel skills a lot
July 25, 2013
This technical book starts from the basics of Excel, including some very useful tips for who's already knows Excel, and moves quickly to more advanced subjects, covering most of the options in Excel.
December 17, 2015
helpfull and excellent
August 28, 2011
I'm working on it.
March 7, 2014
Helpful. Lots of info. Library book so didn't have enough time to finish
January 23, 2018
Crédito de Informática
Displaying 1 - 15 of 15 reviews