Excel 2013: The Missing Manual

by Matthew MacDonald

The world’s most popular spreadsheet program is now more powerful than ever, but it’s also more complex. That’s where this Missing Manual comes in. With crystal-clear explanations and hands-on examples, Excel 2013: The Missing Manual shows you how to master Excel so you can easily track, analyze, and chart your data. You’ll be using new features like PowerPivot and Flash Fill in no time.

The important stuff you need to

Go from novice to ace. Learn how to analyze your data, from writing your first formula to charting your results.Illustrate trends. Discover the clearest way to present your data using Excel’s new Quick Analysis feature.Broaden your analysis. Use pivot tables, slicers, and timelines to examine your data from different perspectives.Import data. Pull data from a variety of sources, including website data feeds and corporate databases.Work from the Web. Launch and manage your workbooks on the road, using the new Excel Web App.Share your worksheets. Store Excel files on SkyDrive and collaborate with colleagues on Facebook, Twitter, and LinkedIn.Master the new data model. Use PowerPivot to work with millions of rows of data.Make calculations. Review financial data, use math and scientific formulas, and perform statistical analyses.

Genres: Computers, Reference, Nonfiction

1022 pages, Kindle Edition

First published December 29, 2013

About the author

Matthew MacDonald is a science and technology writer with well over a dozen books to his name. He's particularly known for his books about building websites, which include a do-it-from-scratch tutorial (Creating a Website: The Missing Manual), a look at cutting-edge HTML5 (HTML5: The Missing Manual), and a WordPress primer (WordPress: The Missing Manual). He's also written a series of books about programming on and off the Web with .NET, teaches programming at Ryerson University, and is a three-time Microsoft MVP.

Reviews

[Terri Lynn · Rating 5 out of 5]

This book is just what you need if you need a manual for Excel 2013 as I certainly did. What a wonderful resource! Author Matthew McDonald has written a guide in the form of this thick book that covers absolutely all you need to know about the newest Excel and in plain, simple language that is clear and understandable. I like the cover too- a naughty dog showing up with the "missing manual." I know it might not be easy to get all hot and bothered over a definitely non-sexy book about Excel of all things but if you are ever in a position where you need to know all about this software right away so to start using it daily, you'll understand!

[Mike S · Rating 4 out of 5]

This is a very well put together book, if you work with Excel this is definitely worth a look. Excel is so powerful and full of features now that it's hard for me to keep up with them, so I leafed through this and read the sections I needed. It is a real pleasure reading a thorough book that is clear, direct, easy to understand, and comprehensive. O'Reilly/Macdonald have done a great job with this volume. I would have liked a little more VBA, but with this book and web searches you can almost assuredly find everything you need to make Excel work the way you want.