CART
Other versions by this Author
More New and Used
from Private Sellers
Excel 2010 Bible
by Walkenbach, JohnEdition:
1st
ISBN13:
9780470474877
ISBN10:
0470474874
Format:
Paperback
Pub. Date:
5/10/2010
Publisher(s):
Wiley
List Price: $44.99
Rent Book
(Recommended)Term
Due
Price
Short Term
Aug 2
$12.87
Semester
Sep 25
$16.65
Quarter
Aug 16
$14.40
$12.87
Buy Used Book
In Stock Usually Ships in 24 Hours.
$30.14
Buy New Book
Currently Available, Usually Ships in 24-48 Hours
$38.24
eBook
We're Sorry
Not Available
Starting at $25.71
Questions About This Book?
Why should I rent this book?
Renting is easy, fast, and cheap! Renting from eCampus.com can save you hundreds of dollars compared to the cost of new or used books each semester. At the end of the semester, simply ship the book back to us with a free UPS shipping label! No need to worry about selling it back.
How do rental returns work?
Returning books is as easy as possible. As your rental due date approaches, we will email you several courtesy reminders. When you are ready to return, you can print a free UPS shipping label from our website at any time. Then, just return the book to your UPS driver or any staffed UPS location. You can even use the same box we shipped it in!
What version or edition is this?
This is the 1st edition with a publication date of 5/10/2010.
What is included with this book?
- The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any CDs, lab manuals, study guides, etc.
- The Used copy of this book is not guaranteed to inclue any supplemental materials. Typically, only the book itself is included.
- The Rental copy of this book is not guaranteed to include any supplemental materials. You may receive a brand new copy, but typically, only the book itself.
Customer Reviews
Very important book May 14, 2011
by
by
This textbook is the one you need. It contains just about everything you will ever want to know, from beginner to advanced user. It is invaluable in helping me to discover and use some of the more obscure functions in Excel. If you are a beginner or advanced user, you will find this textbook a treasure of information. It should be the first textbook you buy about Excel 2010.
Excel 2010 Bible:
stars based on
1 user reviews.
Summary
A comprehensive reference to the newest version of the world’s most popular spreadsheet application: 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!
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
Author Biography
John Walkenbach aka "Mr. Spreadsheet" is the principal of J-Walk and Associates, Inc. and a Microsoft Excel MVP. He is a leading authority on spreadsheet software and the creator of the award-winning Power Utility Pak. John has written more than 50 books, as well as articles and reviews for publications including PC World, InfoWorld, and Windows. He also maintains the popular Spreadsheet Page at spreadsheetpage.com.
Table of Contents
| Acknowledgments | |
| Introduction | |
| Getting Started with Excel 1 | |
| Introducing Excel | |
| Entering and Editing Worksheet Data | |
| Essential Worksheet Operations | |
| Working with Cells and Ranges | |
| Introducing Tables | |
| Worksheet Formatting | |
| Understanding Excel Files | |
| Using and Creating Templates | |
| Printing Your Work | |
| Working with Formulas and Functions | |
| Introducing Formulas and Functions | |
| Creating Formulas That Manipulate Text | |
| Working with Dates and Times | |
| Creating Formulas That Count and Sum | |
| Creating Formulas That Look Up Values | |
| Creating Formulas for Financial Applications | |
| Introducing Array Formulas | |
| Performing Magic with Array Formulas | |
| Creating Charts and Graphics | |
| Getting Started Making Charts | |
| Learning Advanced Charting | |
| Visualizing Data Using Conditional Formatting | |
| Creating Sparkline Graphics | |
| Enhancing Your Work with Pictures and Drawings | |
| Using Advanced Excel Features | |
| Customizing the Excel User Interface | |
| Using Custom Number Formats | |
| Using Data Validation | |
| Creating and Using Worksheet Outlines | |
| Linking and Consolidating Worksheets | |
| Excel and the Internet | |
| Sharing Data with Other Office Applications | |
| Using Excel in a Workgroup | |
| Protecting Your Work | |
| Making Your Worksheets Error-Free | |
| Analyzing Data with Excel | |
| Getting Data from External Database Files | |
| Introducing Pivot Tables | |
| Analyzing Data with Pivot Tables | |
| Performing Spreadsheet What-If Analysis | |
| Analyzing Data Using Goal Seeking and Solver | |
| Analyzing Data with the Analysis ToolPak | |
| Programming Excel with VBA | |
| Introducing Visual Basic for Applications | |
| Creating Custom Worksheet Functions | |
| Creating UserForms | |
| Using UserForm Controls in a Worksheet | |
| Working with Excel Events | |
| VBA Examples | |
| Creating Custom Excel Add-Ins | |
| Appendixes | |
| Worksheet Function Reference | |
| What's on the CD-ROM | |
| Additional Excel Resources | |
| Excel Shortcut Keys | |
| Index | |
| End-User License Agreement | |
| Table of Contents provided by Publisher. All Rights Reserved. |
