Excel 2010 Bible

by Walkenbach, John

• ISBN13: 9780470474877
• ISBN10: 0470474874
• Edition: 1st
• Format: Paperback
• Copyright: 2010-05-10
• Publisher: Wiley

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.