Analyzing Business Data with Excel Review

Average Reviews:

(More customer reviews)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.

Click Here to see more reviews about: Analyzing Business Data with Excel


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.

Get 35% OFF

Click here for more information about Analyzing Business Data with Excel

Read More...

Management Science: The Art of Modeling with Spreadsheets, Excel 2007 Update Review

Average Reviews:

(More customer reviews)I bought this book because it is mandatory reading material for a course which I am taking. So far, I like the book and I find it easy to follow. The book provides good practical examples and the publisher's companion site provides a download of all major spreadsheets which are used as examples in the text. The one problem which I have had so far is that I have not been able to download Oracle's Crystal Ball trial software which is supposed to be provided as a companion to the book. The user name and password combination provided with the book does not match what is requested on the download website.

Click Here to see more reviews about: Management Science: The Art of Modeling with Spreadsheets, Excel 2007 Update

The update to the second edition of Management Science: The Art of Modeling with Spreadsheets by Steve Powell and Ken Baker is revised to be compatible with Microsoft Excel 2007. Like the original second edition, the text expands upon the essential skills needed to develop real expertise in business modeling. In principle, two students could work side by side in a course, one using the Second Edition and relying on Excel 2003, the other using the Update Edition and relying on Excel 2007. They will be able to learn the same skills, as both versions of the book are self-contained.

Click here for more information about Management Science: The Art of Modeling with Spreadsheets, Excel 2007 Update

Read More...

Excel Data Analysis: Your visual blueprint for creating and analyzing data, charts and PivotTables Review

Average Reviews:

(More customer reviews)The third updated edition of Microsoft Excel Data Analysis offers an excellent visual approach to professional-level computer instruction in Excel, and uses web-based applications as keys to creating formulas, working with functions, performing predictions, automating Excel with macros, and adding color and customizing results. No Excel collection should be without this!


Click Here to see more reviews about: Excel Data Analysis: Your visual blueprint for creating and analyzing data, charts and PivotTables

Advanced techniques for Excel power users
Crunch and analyze Excel data the way the professionals do with this clean, uncluttered, visual guide to advanced Excel techniques. Using numerous screenshots and easy-to-follow numbered steps, this book clearly shows you how to perform professional-level modeling, charting, data access, data slicing, and other functions. You'll find super techniques for getting the most out of Excel's statistical and financial functions, Excel PivotTables and PivotCharts, Excel Solver, and more.
Provides a clear look at power-using Excel, the world's leading spreadsheet application from Microsoft, and part of the new Microsoft Office 2010 suite
Expands your Excel knowledge and helps you use Excel data more efficiently
Demonstrates how to retrieve data from databases;; cut, slice, and pivot data using PivotTables; model data and chart data; and use advanced formulas
Explores all features and functions in friendly, two-color pages packed with screenshots, numbered steps, and other visual graphics that clearly show you how to accomplish tasks
Includes practical examples, tips, and advice to help you get the most out of Excel's features and functions

Learn Excel at the highest levels with this practical guide.

Get 34% OFF

Click here for more information about Excel Data Analysis: Your visual blueprint for creating and analyzing data, charts and PivotTables

Read More...

The Art of Modeling with Spreadsheets: Management Science, Spreadsheet Engineering, and Modeling Craft Review

Average Reviews:

(More customer reviews)A once useful entree to the spreadsheet modeling literature, this book is now obsolete. The version listed here is copyrighted 2004 but comes with a CD containing release 2000.2 of Crystal Ball which Decisioneering is no longer event supporting. This old version of the software as well as the Advanced Solver add-in has compatibility problems with Windows XP -not to mention Vista, and Wiley does not stand behind the product. Once I loaded the advanced solver, the solver feature no longer produced optimal solutions.
Extremely disappointing to buy a $90 textbook with obsolete software that causes Excel to malfunction and cannot be updated. Impossible to consider this as a class text book. If the publishers will not keep the product current it should be withdrawn from the market, and reputable vendors should at least WARN buyers, if they choose to continue to market and sell this once useful product.

Click Here to see more reviews about: The Art of Modeling with Spreadsheets: Management Science, Spreadsheet Engineering, and Modeling Craft

Successful business modeling is much more than a technical discipline; it's an art. And as in most professional disciplines, you can tell the experts apart from the novices by the creativity they bring to the craft. That's why Steve Powell and Ken Baker's THE ART OF MODELING WITH SPREADSHEETS covers spreadsheet engineering, management science techniques, and those essential craft skills needed to develop real expertise in business modeling. Features: * Balanced and streamlined coverage of spreadsheet engineering, management science techniques, and modeling craft. * The CD-ROM packaged with this text features all of the spreadsheets referred to in the text, as well as three software tools of special importance to business analysts: Premium Solver, Crystal Ball, and Sensitivity Toolkit (featuring four sensitivity tools)

Click here for more information about The Art of Modeling with Spreadsheets: Management Science, Spreadsheet Engineering, and Modeling Craft

Read More...