Book description
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!
Table of contents
- Copyright
- About the Author
- About the Technical Editor
- Credits
- Acknowledgments
- Introduction
- Getting Started with Excel
- Working with Formulas and Functions
- Creating Charts and Graphics
-
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
- Working with Non-Numeric Data
- Grouping Pivot Table Items
- Creating a Frequency Distribution
- Creating a Calculated Field or Calculated Item
- Filtering Pivot Tables with Slicers
- Referencing Cells within a Pivot Table
- Creating Pivot Charts
- Another Pivot Table Example
- Producing a Report with a Pivot Table
- Performing Spreadsheet What-If Analysis
- Analyzing Data Using Goal Seeking and Solver
- Analyzing Data with the Analysis ToolPak
- Programming Excel with VBA
- Appendixes
- Wiley Publishing, Inc. End-User License Agreement
Product information
- Title: Excel® 2010 Bible
- Author(s):
- Release date: June 2010
- Publisher(s): Wiley
- ISBN: 9780470474877
You might also like
book
Using Microsoft® Excel® 2010
Get comfortable with the latest versions of Microsoft Excel, Microsoft Excel Starter, and the Excel Web …
book
Easy Microsoft® Excel® 2010
This year, millions of beginner-to-intermediate-level users will be searching for the easiest possible way to master …
book
Excel® 2007 Bible
This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and …
book
Master VISUALLY® Excel® 2010
The complete visual reference on Excel basics Aimed at visual learners who are seeking an all-in-one …