Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables

by Jinjer L. Simon

* Essential for those who know basic Excel and want to explore the full potential of the program
* Teaches how to manipulate data to suit specific needs and achieve more by doing less work
* Self-contained two-page lessons, featuring high-resolution screen shots and minimal text, show how to create custom functions, retrieve data from databases, use value chains, and slice and pivot information from the Web with Excel's PivotTable utility
* Covers data analyzing techniques for statistical functions, financial functions, data sharing, PivotTables and PivotCharts, Solver, and BackSolver

Genres: Computers, Nonfiction

304 pages, Paperback

First published March 3, 2003

Reviews

[Michael Finocchiaro · Rating 5 out of 5]

This is a highly practical hands-on book for the Excel-illiterate such as me. Hell, I still mourn the death of Quattro Pro (c'mon someone out there remembers that, right?). Numbers from Apple is crap so Microsoft has the monopoly on spreadsheets so some years back, I sucked it in and dove into this book. As for a book that I could immediately use in my working life, this is probably the A Number One (other than the epic and life-changing Getting Things Done). Suddenly, I could understand pivot tables (well sort of) and debug macros (well, sometimes). In all seriousness, this book is the best crash course in Excel I have ever browsed and subsequently used (all the others I browsed were either feature by feature slit your wrists boring or so basic it was like remedial Excel for Dummies). So,, to your spreadsheets - you too can be a manager! ;)

[Molly · Rating 3 out of 5]

Geeky, sure, but this book (2nd edition) gives lots of great little tips that make life soooo much easier (if you use Excel), just had to add it to the list.