9780470474877

Excel 2010 Bible

by
  • ISBN13:

    9780470474877

  • ISBN10:

    0470474874

  • Edition: 1st
  • Format: Paperback
  • Copyright: 5/10/2010
  • Publisher: Wiley

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

  • Get Rewarded for Ordering Your Textbooks! Enroll Now
  • Complimentary 7-Day eTextbook Access - Read more
    When you rent or buy this book, you will receive complimentary 7-day online access to the eTextbook version from your PC, Mac, tablet, or smartphone. Feature not included on Marketplace Items.

Supplemental Materials

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 access cards, study guides, lab manuals, CDs, etc.
  • The Used and Rental copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

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.

Rewards Program

Customer Reviews

Very important book May 14, 2011
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.
Flag Review
Please provide a brief explanation for why you are flagging this review:
Submit
Your submission has been received. We will inspect this review as soon as possible. Thank you for your input!
Excel 2010 Bible: 5 out of 5 stars based on 1 user reviews.

Write a Review