Excel 2010: The Missing Manuel

Few people know where to find xcel's most impressive features or why they’d want to use them in the first place. Excel 2010: The Missing Manual fills that void, explaining everything from basic Excel concepts to the fancy tricks of the trade.This book not only teaches you how Excel works, but also shows you how to use Excel’s tools to answer real-world questions like “How many workdays are there between today and my vacation?”, “How much money do I need in the bank right now to retire a millionaire?”, and “Statistically speaking, who’s smarter—Democrats or Republicans?” Best of all, you’ll steer clear of obscure options that aren’t worth the trouble to learn, while homing in on the hidden gems that will win you the undying adoration of your coworkers, your family, and your friends—or at least your accountant.

This text clearly explains how everything works with a unique and witty style to help you learn quickly. The features of this book are: 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 and Rescue lost data - Restore old versions of data and find spreadsheets you forgot to save.