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
Matthew MacDonald is a science and technology writer with well over a dozen books to his name. Web novices can tiptoe out onto the Internet with him in Creating a Website: The Missing Manual. HTML fans can learn about the cutting edge of web design in HTML5: The Missing Manual. And human beings of all description can discover just how strange they really are in the quirky handbooks Your Brain: The Missing Manual and Your Body: The Missing Manual.
The Missing Credits;About the Author;About the Creative Team;Acknowledgements;The Missing Manual Series;Introduction;What You Can Do with Excel;The Modern Face of Excel;Excel's New Features;About This Book;Part One: Worksheet Basics;Chapter 1: Creating Your First Spreadsheet;1.1 Creating a Basic Worksheet;1.2 Moving Around the Grid;1.3 A Tour of the Excel Window;1.4 Saving Files;1.5 Opening Files;Chal“!