Print Book $39.99
Print Book £28.50
By Gerald Knight
First Edition
January 2006
Pages: 262
ISBN 10: 0-596-10073-6 |
ISBN 13: 9780596100735
(Average of 2 Customer Reviews)
Learn how to apply Excel's advanced data analysis features to solve real-world business problems. This hands-on reference targets specific business situations, then demonstrates how to create spreadsheets for these problem areas. Topics include statistics, pivot tables, workload forecasting, modeling, queuing, data importing, and more. Perfect for professional Excel users working in an office environment.
Full Description
Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel's data analysis features to the max. Rather than focusing on individual Excel functions and features, the book keys directly on the needs of business users. Most of the chapters start with a business problem or question, and then show you how to create pointed spreadsheets that address common data analysis issues.
Aimed primarily at experienced Excel users, the book doesn't spend much time on the basics. After introducing some necessary general tools, it quickly moves into more specific problem areas, such as the following:
- Statistics
- Pivot tables
- Workload forecasting
- Modeling
- Measuring quality
- Monitoring complex systems
- Queuing
- Optimizing
- Importing data
If you feel as though you're getting shortchanged by your overall application of Excel, Analyzing Business Data with Excel is just the antidote. It addresses the growing Excel data analysis market head on. Accountants, managers, analysts, engineers, and supervisors-one and all-will learn how to turn Excel functionality into actual solutions for the business problems that confront them.
Featured customer reviews
Good- detail but lacking all Excel files, March 15 2007
I purchased this book at B&N 3/14/07 because of the multi-regression examples but also wanted to see ALL Excel files (esp since it appeared important in the book). The other reviewer is correct - only Chapters 3-8 provided in download - and as examples only. Also - this book is over a yr old (1/2006 first printing) - no errata or updates shown on website-guess all info is correct. I do get a 30% discount apparently on buying the next book version - whenever that is (no indication). Oreilly makes it difficult to obtain the examples and in order to try Safari (its online bookstore) you have to provide all details including CCard billing info and read a long EULA. (Interestingly the EULA wants reference to using code in all your files, but the book says only if selling or publishing - confusing). When I buy a $40 book - good support means all Excel files and any text/files UPDATES on the website and easily obtainable without charge. You can ask for info to make sure I bought the book, but not so much personal info. I will update after I've used the book a while (since I've got to type in the other examples) but so far not too impressed.
It's been a year since the publish date on January 1, 2006, where are ALL the EXCEL data?, December 28 2006
It's been a year since the published date on
January 1, 2006, where are ALL the EXCEL data?
The XL_Applications.zip posted on 28-Aug-2006
consists of about 1/3 of ALL the data/examples
in the book.
The book has 12 chapters; however, not a single
chapter is provided with complete EXCEL data/
examples. What XL_Applications.zip contains
are some selected data/examples from chapter 3
to 8. Again, NOT a single chapter is provided
with ALL the EXCEL data/examples used in that
chapter.
I won't recommend this book until O'Reilly takes
"actions" to provide the readers with ALL the
EXCEL data/examples used in this book at:
http://examples.oreilly.com/analyzingbdwe/
For reading a data analysis book w/o ALL the
data/examples to run it ourselves in EXCEL is
NOT useful at all.
Media reviews
"...the book is for those involved with forecasting and statistics, for those with piles of data to analyze and who are desperate for tools to use to take control of this information. Knight's book provides some very powerful and very useful applications and methods which will be of great benefit to the appropriate audience."
-- Robert Boardman, KickStartNews.com
"This most excellent book keys directly on the needs of business users. More importantly, this book addresses the growing Excel data analysis market head-on."
-- John Vacca, Amazon.com
"Where most books on enhancing or extending Excel take a feature-led approach, Knight turns things around and starts with the problems to be solved. And frankly it's this problem-oriented approach that really sets the book apart from most of its peers. Instead of saying 'here's this really cool bit of code that does x', this book says 'I've got some forecasting to do, how do I do it?'. And if the solution needs features x, y and z, then they get introduced along the way...For the data analyst who wants to really get the most out of Excel then there are few books that compare in depth and quality to this one. This is one title that we can recommend very highly indeed."
-- Pan Pantziarka, TechBookReport.com
Read all reviews
"Knight's book provides some very powerful and very useful applications and methods which will be of great benefit to the appropriate audience."
--
About O'Reilly | Contact | Jobs | Press Room | How to Advertise | Privacy Policy
|
© 2008, O'Reilly Media, Inc. | (707) 827-7000 / (800) 998-9938
All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners.