Analyzing Business Data with Excel
Forecasting, Statistics, and Data Management
Publisher: O'Reilly Media
Released: January 2006
Pages: 266

As one of the most widely used desktop applications ever created, Excel is familiar to just about everyone with a computer and a keyboard. Yet most of us don't know the full extent of what Excel can do, mostly because of its recent growth in power, versatility, and complexity. The truth is that there are many ways Excel can help make your job easier-beyond calculating sums and averages in a standard spreadsheet.

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.

Table of Contents
Product Details
About the Author
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyAnalyzing Business Data with Excel
 
1.7

(based on 3 reviews)

Ratings Distribution

  • 5 Stars

     

    (0)

  • 4 Stars

     

    (0)

  • 3 Stars

     

    (1)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (2)

Reviewed by 3 customers

Sort by

Displaying reviews 1-3

Back to top

(5 of 5 customers found this review helpful)

 
3.0

Analysing Business Data with Excel

By ExcelNerd

from Undisclosed

Comments about oreilly Analyzing Business Data with Excel:

I thought the book had some very valuable information but it missed some of the user friendly points like the lack of the files appearing in the book.

I would have liked all those files with example data to be available in soft copy from the O'Reillys website so I didn't have to write them out manually.

I also found a lot of errors with references to formulae & tables, I don't think it was proof read very thoroughly.

I really liked the reports that the book contained as they quickly demonstrated what was possible when using the techniques described.

No-one's perfect when writing or proof reading a book, but it would be great if we could have the corrections published in the errata so readers can correct the existing errors, thanks

(3 of 3 customers found this review helpful)

 
1.0

Good- detail but lacking all Excel files

By ByeGray

from Undisclosed

Comments about oreilly Analyzing Business Data with Excel:

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.

(3 of 3 customers found this review helpful)

 
1.0

It's been a year since the publish date on January 1, 2006, where are ALL the EXCEL data?

By GrandFX

from Undisclosed

Comments about oreilly Analyzing Business Data with Excel:

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.

Displaying reviews 1-3

Back to top

 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook: $31.99
Formats:  DAISY, ePub, Mobi, PDF
Print & Ebook: $43.99
Print: $39.99