Excel Data Analysis: Your Visual Blueprint for Analyzing Data, Charts, and PivotTables, 2nd Edition

by Jinjer L. Simon

Excel is a spreadsheet / data analysis tool attached to the Microsoft Office suite and is available in all Office offerings. Office holds 80-90% of the market share for productivity suites. Though many consumers know the basics of using Excel, they may not know the full power of the program. With Excel, you can harness the power of your data, manipulate it to suit your needs, and achieve more by doing less work. Charts are interactive, allowing the consumer to tweak results with the click of a mouse. Pivot tables allow you to fuse data from several sources into one document. Excel has an enhanced Find function, allowing users to easily search entire workbooks, and search worksheets by cell format. Excel supports XML as a file format for easy importing or exporting of XML data. Excel also includes enhancements for saving files as Web pages, and enhancements to Pivot Tables.

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.