| Overview
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: 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 ReviewsProduct DescriptionAs 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. |
Other Readers Also Read | Top Sellers in This Category | Browse Similar Topics | | | Top Level Categories:Sub-Categories: | | | | |
Reader Reviews From Amazon (Ranked by 'Helpfulness') Average Customer Rating: based on 6 reviews. Very Disappointed., 2006-12-29 Reviewer rating: We bought this book back in mid January 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
on O'Reilly website 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.
For reading a data analysis book w/o ALL the
data/examples to run it ourselves in EXCEL is
NOT useful at all.
You may wonder, how about type those data in?
No way, because most (if not all) of the data/
examples are very long and can only be shown
"partially" in the figures/screen shots! | Great Book, but where's the data?, 2006-08-04 Reviewer rating: 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. | VERY VERY HIGHLY RECOMMENDED!!, 2006-06-18 Reviewer rating: Are you an experienced Excel user? If you are, then this book is for you! Author Gerald Knight, has done an outstanding job of writing a practical guide that shows you how to solve real-world business problems by taking Excel's data analysis features to the max.
Knight, begins by covering averages, trends, correlation, distributions and array formulas. Then, the author examines pivot table basics and ways to modify data to make it work better with pivot tables. Next, he covers the application development process, worksheet organization, and forecasting techniques. The author continues by exploring regression, problem definition, analysis, model construction, and interpretation of results. He also works with statistical process control, X and Y charts, and application design. Knight, then examines data requirements, statistical techniques and logic, application design, and organization. Then, he shows you how to apply formatting, VBA, and logic in an application that measures worker performance in a queuing operation. The author continues the discussion of queuing with another application by focusing on the status of the queue. He also explains how to use Goal Seek and Solver for various kinds of problems. Knight next covers importing from text files, databases, and XML. Then, he examines common problems with dates, numeric information, dealing with data in report form, and equivalence problems. Finally, he covers display design, color combination, dealing with complexity, and visual consideration.
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.
| An outstanding set of connections between Excel and standard business use, 2006-05-02 Reviewer rating: Gerald Knight's Analyzing Business Data With Excel provides an outstanding set of connections between Excel and standard business use. Plenty of 'how to' computer books focus on the fundamentals of learning Excel without applying these lessons to basic business data analysis: Analyzing Business Data With Excel solves this in using real- world business problems as examples. From pivot tables and charts to statistical analysis choices and applications which can be easily updated, no business user should be without Analyzing Business Data With Excel. | Exactly what I was looking for!!, 2006-03-30 Reviewer rating: 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. |
Some information above was provided using data from Amazon.com. View at Amazon > |
| |
|
|
