Start reading Analyzing Business Data with Excel on the free Kindle Reading App or on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here.

Deliver to your Kindle or other device

Enter a promotion code
or gift card
 
 
 

Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Sorry, this item is not available in
Image not available for
Color:
Image not available

To view this video download Flash Player

 

Analyzing Business Data with Excel [Kindle Edition]

Gerald Knight
4.3 out of 5 stars  See all reviews (6 customer reviews)

Digital List Price: $31.99 What's this?
Print List Price: $39.99
Kindle Price: $17.27
You Save: $22.72 (57%)

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your email address or mobile phone number.

Formats

Amazon Price New from Used from
Kindle Edition $17.27  
Paperback $29.14  
Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Book Description

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.



Editorial Reviews

Book Description

Forecasting, Statistics, and Data Management

About the Author

Gerald Knight has nearly 30 years experience in the computer industry as a developer, teacher, and consultant. During an over twenty-year career at FedEx, he was a project leader and system architect working on imaging and revenue control systems. He has specialized in Excel development for the last ten years. Now retired, he consults and occasionally writes in Memphis, Tennessee.


Product Details

  • File Size: 5388 KB
  • Print Length: 266 pages
  • Simultaneous Device Usage: Unlimited
  • Publisher: O'Reilly Media; 1 edition (February 9, 2009)
  • Sold by: Amazon Digital Services, Inc.
  • Language: English
  • ASIN: B0026OR2UE
  • Text-to-Speech: Enabled
  • X-Ray:
  • Lending: Not Enabled
  • Amazon Best Sellers Rank: #824,302 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?.


Customer Reviews

4.3 out of 5 stars
(6)
4.3 out of 5 stars
Share your thoughts with other customers
Most Helpful Customer Reviews
19 of 19 people found the following review helpful
5.0 out of 5 stars Excel as taught from the business perspective January 25, 2006
Format:Paperback
I like the viewpoint of this book; I have a business problem, now how do I attack that in Excel? So many books come at business problems from the perspective of a specific feature in the product. This book teaches the solution to a complex business data analysis problem through use of the features in Excel. Excellent!

It's a small book. The text is a little terse, but that's ok. Screenshots are used sparingly.

If what you want is a feature by feature breakdown of Excel then this book isn't for you. But if what you have is some data that you need to crunch and you don't know much about Excel then check this book out.
Comment | 
Was this review helpful to you?
10 of 10 people found the following review helpful
5.0 out of 5 stars Exactly what I was looking for!! March 29, 2006
Format:Paperback
As a strategy analyst I'm always looking for concise ways to present data and make it automated and professional-looking without lots of code that none of my clients can use.

I agree with the previous reviewer, other books come at Excel and similar applications with a feature by feature breakdown so that in usage YOU have to work backwards to figure out how to apply software features to your problem.

This book is organized by business problem and then proceeds to breakdown how your problem applies to the software solution. There is very useful code in some of the models, but nothing horribly difficult to implement.

Excellent addition to my reference library. I've truly never seen a business data analysis book as well put together as this and I've been searching for years. You will not be disappointed.
Comment | 
Was this review helpful to you?
8 of 9 people found the following review helpful
4.0 out of 5 stars Great Book, but where's the data? August 4, 2006
Format:Paperback|Verified Purchase
Overall this is a good book, but it would be much nicer if they provided Excel worksheets with the data used in the book's examples. Some sample code is provided for dowload on Oreilly's website, but this does not include example data. Nonetheless, the book is worth looking at.
Comment | 
Was this review helpful to you?

More About the Author

Discover books, learn about writers, read author blogs, and more.

Forums

There are no discussions about this product yet.
Be the first to discuss this product with the community.
Start a new discussion
Topic:
First post:
Prompts for sign-in
 


Look for Similar Items by Category