Excel, the world's most popular spreadsheet program, has the muscle to analyze heaps of data. Beyond basic number-crunching, Excel 2010 has many impressive features that are hard to find, much less master -- especially from online help pages. This Missing Manual clearly explains how everything works with a unique and witty style to help you learn quickly.
Navigate with ease. Master Excel's tabbed toolbar and its new backstage view
Perform a variety of calculations. Write formulas for rounding numbers, calculating mortgage payments, and more
Organize your data. Search, sort, and filter huge amounts of information
Illustrate trends. Bring your data to life with charts and graphics -- including miniature charts called Sparklines
Examine your data. Summarize information and find hidden patterns with pivot tables and slicers
Share your spreadsheets. Use the Excel Web App to collaborate with colleagues online
Rescue lost data. Restore old versions of data and find spreadsheets you forgot to save
Worksheet Basics
Chapter 1 Creating Your First Spreadsheet
Creating a Basic Worksheet
Moving Around the Grid
A Tour of the Excel Window
Saving Files
Opening Files
Chapter 2 Adding Information to Worksheets
Adding Different Types of Data
Handy Timesavers
Dealing with Change: Undo, Redo, and AutoRecover
Spell Check
Adding Hyperlinks
Chapter 3 Moving Data
Selecting Cells
Making Continuous Range Selections
Making Noncontiguous Selections
Automatically Selecting Your Data
Making Selections with the Keyboard
Moving Cells Around
A Simple Cut-and-Paste or Copy-and-Paste
A Quicker Cut-and-Paste or Copy-and-Paste
Fancy Pasting Tricks
Paste Special
Copying Multiple Items with the Clipboard
Adding and Moving Columns or Rows
Inserting Columns and Rows
Inserting Rows
Inserting Copied or Cut Cells
Deleting Columns and Rows
Chapter 4 Managing Worksheets
Worksheets and Workbooks
Find and Replace
Chapter 5 Formatting Cells
Formatting Cell Values
Formatting Cell Appearance
Chapter 6 Smart Formatting Tricks
The Format Painter
Styles and Themes
Conditional Formatting
Chapter 7 Viewing and Printing Worksheets
Controlling Your View
Printing
Controlling Pagination
Formulas and Functions
Chapter 8 Building Basic Formulas
Creating a Basic Formula
Functions
Formula Errors
Logical Operators
Formula Shortcuts
Copying Formulas
Chapter 9 Math and Statistical Functions
Rounding Numbers
Groups of Numbers
General Math Functions
Trigonometry and Advanced Math
Advanced Statistics
Chapter 10 Financial Functions
The World of Finance
Financial Functions
Depreciation
Other Financial Functions
Chapter 11 Manipulating Dates, Times, and Text
Manipulating Text
Manipulating Dates and Times
Math with Dates and Times
Date and Time Functions
Chapter 12 Lookup, Reference, and Information Functions
The Basic Lookup
Advanced Lookups
Information Functions
Tutorial: Generating Invoices from a Product Catalog
Chapter 13 Advanced Formula Writing and Troubleshooting
Conditions in Formulas
Descriptive Names for Cell References
Variable Data Tables
Controlling Recalculation
Solving Formula Errors
Organizing Worksheets
Chapter 14 Tables: List Management Made Easy
The Basics of Tables
Sorting and Filtering a Table
Dealing with Duplicate Rows
Performing Table Calculations
Chapter 15 Grouping and Outlining Data
Basic Data Grouping
Grouping Timesavers
Chapter 16 Templates
Understanding Templates
Creating a New Workbook from a Template
Creating Templates
Charts and Graphics
Chapter 17 Creating Basic Charts
Charting 101
Basic Tasks with Charts
Practical Charting
Chart Types
Chapter 18 Formatting and Perfecting Charts
Chart Styles and Layouts
Adding Chart Elements
Selecting Chart Elements
Formatting Chart Elements
Improving Your Charts
Advanced Charting
Chapter 19 Inserting Graphics
Adding Pictures to a Worksheet
Excel's Clip Art Library
Drawing Shapes
Advanced Data Analysis
Chapter 20 Visualizing Your Data
Data Bars
Color Scales
Icon Sets
Sparklines
Chapter 21 Scenarios and Goal Seeking
Using Scenarios
Using Goal Seek
Solver
Chapter 22 Pivot Tables
Summary Tables Revisited
Building Pivot Tables
Multi-Layered Pivot Tables
Fine-Tuning Pivot Table Calculations
Filtering a Pivot Table
Pivot Charts
Chapter 23 Analyzing Databases, XML, and Web Pages
Matthew MacDonald is a developer, author, and educator in all things Visual Basic and .NET. He's worked with Visual Basic and ASP since their initial versions, and written over a dozen books on the subject, including The Book of VB .NET (No Starch Press) and Visual Basic 2005: A Developer's Notebook (O'Reilly). He has also written Excel 2007:The Missing Manual, Excel 2007 for Starters: The Missing Manual, Access 2007:The Missing Manual, and Access 2007 for Starters: The Missing Manual, all from O'Reilly. His web site is http://www.prosetech.com.
Comments about O'Reilly Media Excel 2010: The Missing Manual:
When I first bought the book I read it cover to cover to get a sense of what it had that I did not know. It provides excellent detailed information on functions and general operations. Its examples are by in large well thought out and useful. One of the problems, as with all such reference books is that you need to ask the right question and know the excel lingo to find your answers. I have specifically benefited from a better understanding of formatting cells and some combination of math functions.