You’ve got data -- boy, do you ever. You’ve got a recent copy of Excel. You know Excel can help you make sense of your data, but you don’t know how. Get Excel Data Analysis For Dummies®. It’s the easiest way we’ve seen to master Excel data analysis -- everything from simple lists to slick optimization modeling.
Longtime Excel author Stephen L. Nelson starts with basic sorting, filtering, and analysis functions (sum, average, count, min/max functions, and so forth). If your data “lives” elsewhere -- say, in a database or in QuickBooks -- you’ll learn to import or query it. There’s a full chapter on cleaning data for easier analysis -- including coverage of several cleaning functions you may never have noticed.
Get this book if you’ve ever been befuddled by PivotTables (or their sister PivotCharts). Or if you’d like a painless introduction to Excel’s powerful statistical tools for describing your data, explaining its implications, and testing new hypotheses that go “beyond” the data. Or if you’d like to make the most of Solver, Excel’s powerful tool for “what-if” analysis.
By the time you’re finished, you’d be forgiven for believing you could actually make sense of life. Bill Camarda
Bill Camarda is a consultant, writer, and web/multimedia content developer. His 15 books include Special Edition Using Word 2000 and Upgrading & Fixing Networks For Dummies®, Second Edition.