- Paperback: 1056 pages
- Publisher: Wiley; 1 edition (May 10, 2010)
- Language: English
- ISBN-10: 0470474874
- ISBN-13: 978-0470474877
- Product Dimensions: 7.1 x 1.7 x 9.2 inches
- Shipping Weight: 2.8 pounds (View shipping rates and policies)
- Average Customer Review: 255 customer reviews
- Amazon Best Sellers Rank: #191,323 in Books (See Top 100 in Books)
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.
To get the free app, enter your mobile phone number.
Excel 2010 Bible 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
Fulfillment by Amazon (FBA) is a service we offer sellers that lets them store their products in Amazon's fulfillment centers, and we directly pack, ship, and provide customer service for these products. Something we hope you'll especially enjoy: FBA items qualify for FREE Shipping and Amazon Prime.
If you're a seller, Fulfillment by Amazon can help you increase your sales. We invite you to learn more about Fulfillment by Amazon .
"Neverworld Wake" by Marisha Pessl
Read the absorbing new psychological suspense thriller from acclaimed New York Times bestselling author Marisha Pessl. Learn more
Frequently bought together
Customers who bought this item also bought
5/5 stars. comprehensive and authoritative gives a user at any level the confidence to self-teach Excel 2010 thorough and genuinely helpful. (Software Latest.com, December 2010).
From the Back Cover
"John Walkenbach's writing style makes the difficult seem easy in this book that can be used as a reference or read cover to cover. You won't find a more comprehensive book on Excel 2010 than this!"
—Dick Kusleika, Microsoft MVP, DailyDoseOfExcel.com
If Excel can do it, John Walkenbach can show you how
What better way to learn Excel 2010 than from "Mr. Spreadsheet" himself? Excel guru, Microsoft MVP, and author of all the previous top-selling editions of Excel Bible, John Walkenbach provides more than 1,000 pages packed with techniques, tips, and tricks for beginners as well as Excel power users. Discover what's new in Excel 2010, learn shortcuts you didn't know, make the Ribbon interface work for you, and master all the latest ins-and-outs with this must-have guide.
Get up to speed on everything new in Excel 2010
Understand functions, charts, worksheets, and workbooks
Perform magic with array formulas—and even more with Sparklines
Master "what-if" analysis, Goal Seeking, external database files, and pivot tables
Develop custom functions, program with VBA, and create UserForms
Try new slice-and-dice tools to dynamically filter your data
What's on the CD-ROM?
Follow the examples in the book, chapter by chapter, using the bonus materials on the CD-ROM:
All the examples and workbook files used in the book
Searchable PDF of the book
System Requirements: See the CD Appendix in the book for details and complete system requirements.
- Preview how your copied text will look
- Spot trends in your data with Sparklines
- Chart your data using Excel's different chart types
- Master Excel formulas for useful worksheets
- Create effective charts suitable for the boardroom
- Analyze and present data with pivot tables
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
I have been using Excel for more than 15 years and consider myself a competent intermediate level user (though many in the office think I'm an "advanced user"); however I felt that my knowledge of Excel had become stagnant and I knew that I wasn't really taking advantage of many of the newer analytical functions of Excel. I searched through other books offered on Amazon, and found that they were just too basic to allow me to move to the next level.
The book is well organized into the following Parts, each with many chapters included:
Part I: Getting Started with Excel
Part II: Working with Formulas and Functions
Part III: Creating Charts and Graphics
Part IV: Using Advanced Excel Features
Part V: Analyzing Data with Excel
Part VI: Programming Excel with VBA
For now, I am concentrating my efforts in Part IV and Part V - not sure I'll work long enough (or have need for) Part VI !
I use the book in 2 ways:
1) browse through a section to discover features and functions that I didn't know existed, and
2) go to the index to find sections on a specific topic
I always find what I'm looking for in this "Bible". For instance, I just learned that Excel has a very useful "track changes" feature (which has been available in Word forever...) The book works well for my style of learning, since I am almost entirely self-taught in Microsoft applications. For me, it's easier to learn about applications in smaller bites that I can digest and work into my workflow than to dedicate the time to take a course that might last several days - 50% of which would be forgotten before I got back to the office.
The page layout is very readable, with crisp text, bold subheadings, plenty of included graphics and figures, and helpful notes and tips throughout. Many casual users of Excel will never need a tome of this depth, but it has become indispensable to me, and just having it on my desk makes me look smart !
Everything from Pivot Tables to the foundation behind extremely difficult formulaic equations is listed within this book and the accompanying CD allows for a structured application process. Were it not for the CD, then this book would become very overwhelming, requiring one to read ahead then make an outline and then attempt to stick to it as they progressed through the chapter.
In order to get the most out of this book, I recommend that you Google every concept that you do not know how/when to apply. That's what I have done and then I just made notes in the Table of Contents section ahead of reaching that point, so I'll know the potential of each section as I get there.
What I have learned to do, so far, is to create a spreadsheet that itemizes my paychecks to the point where I have a pivot table that maps out the money coming in, the bills to pay, the percentage intended for savings, and the amount left over for discretionary spending. I also have a list of my gas receipts and can calculate how many miles I have driven per fillup and have been able to project a distance/dollar amount for trips.
I don't remember learning Excel like this the first time around but I am glad for this book's instruction style. Everything is right to the point without having to filter through a bunch of filler. If you want to relearn Excel, then this is the book to get.
So - kind of a 50/50 - buy it and have it around for the lesson specific sample spreadsheets, and have the book for reference.
Or, go without and use online searches for what you need.