Introduction

Excel 2013 All-in-One For Dummies brings together plain and simple information on using all aspects of the latest-and-greatest version of Microsoft Excel. It’s designed to be of help no matter how much or how little experience you have with the program. As the preeminent spreadsheet and data analysis software for all sorts of computing devices running Windows 7 or 8 (desktops, laptops, tablet PCs and even smartphones), Excel 2013 offers its users seemingly unlimited capabilities too often masked in technical jargon and obscured by explanations only a software engineer could love. On top of that, many of the publications that purport to give you the lowdown on using Excel are quite clear on how to use particular features without giving you a clue as to why you would want to go to all the trouble.

The truth is that understanding how to use the abundance of features offered by Excel 2013 is only half the battle, at best. The other half of the battle is to understand how these features can benefit you in your work; in other words, “what’s in it for you.” I have endeavored to cover both the “how to” and “so what” aspects in all my discussions of Excel features, being as clear as possible and using as little tech-speak as possible.

Fortunately, Excel 2013 is well worth the effort to get to know because it’s definitely one of the best data-processing and analysis tools that has ever come along. Its new Quick Analysis tool, Apps for Office, Flash Fill, and Recommended Charts ...

Get Excel 2013 All-in-One For Dummies now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.