Business Analysis with Microsoft Excel (3rd Edition) [Paperback]

Conrad Carlberg (Author)

Book Description

ISBN-10: 0789736640 | ISBN-13: 978-0789736642 | Publication Date: June 29, 2007 | Edition: 3

Whether you own a small business or work for a large corporation–whether you are looking for help making financial and business decisions–this book is for you.  Business Analysis with Microsoft® Excel, Third Edition, provides in-depth information that will streamline your use of the tools within Excel. Professional advice and guidance from an experienced author provide the answers to your most pressing questions:

 

     •    What’s the relationship between my cost of goods sold and my inventory?

     •    How do I get Excel to keep these values up-to-date on my income statement and my balance sheet?

     •    I have to track service quality over time. How can I automate that using Excel charts?

     •    How can I forecast future demand for my products, based on prior sales results?

     •    What’s the difference between financial leverage and operating leverage? How do I calculate them using my financial records?

     •    I need to project my financials for next year. Does Excel have a tool for that? What do I need to know to use it effectively?

     •    How do I do all these things using the new Ribbon in Excel 2007?

     •    What are the best ways to automate a connection between Excel and an external database?

 

Category  Spreadsheets

Covers    Applicable for versions of Microsoft Excel 97 to 2007

User Level    Intermediate–Advanced

 

More great stuff… is just a click away!

     •    Sample journals and ledgers; examples of trial balances, income statements, and balance sheets

     •    Custom functions, such as FIFO and LIFO, for inventory management

     •    VBA routines that automate the creation of forecasts, quality control charts, and sales and marketing analysis

     •    Statistical process control charts: P charts, X-and-S charts, X-and-MR charts

     •    Forecasting tools: Seasonal smoothing and ARIMA model identification

 

quote from the front cover

“Conrad takes the time to give the readers an easy-to-follow step-by-step understanding of the material, accompanied by clear illustrations, making this an excellent book to learn the material. I recommend this book to anyone wanting to gain more expertise in using and manipulating business data from within Excel.”

–Bob Umlas, Excel MVP

 

Editorial Reviews

Review

Carlberg develops each concept within the context of a realistic business case, using Excel spreadsheets as examples. -- PC World, May, 1997 --This text refers to an out of print or unavailable edition of this title.

From the Author

Excel files for all chapters and figures have always been available for download, in compressed format, from the publisher's Web site. The URL is displayed in a bright red circle on the book's back cover. --This text refers to an out of print or unavailable edition of this title.

See all Editorial Reviews

Product Details

• Paperback: 504 pages
• Publisher: Que; 3 edition (June 29, 2007)
• Language: English
• ISBN-10: 0789736640
• ISBN-13: 978-0789736642
• Product Dimensions: 7 x 1.1 x 9.2 inches
• Shipping Weight: 1.6 pounds (View shipping rates and policies)
• Average Customer Review: 3.9 out of 5 stars  See all reviews (11 customer reviews)
• Amazon Best Sellers Rank: #753,247 in Books (See Top 100 in Books)

More About the Author

Conrad Carlberg is a nationally recognized expert on quantitative analysis, and on data analysis and management applications such as Microsoft Excel, SAS and Oracle. He holds a Ph.D. in statistics from the University of Colorado and is a many-time recipient of Microsoft's Excel MVP designation.

Carlberg is a Southern California native. After college he moved to Colorado, where he worked for a succession of startups and attended graduate school. He spent two years in the Middle East, teaching computer science and dodging surly camels. After finishing graduate school, Carlberg worked at US West (a Baby Bell) in product management and at Motorola.

In 1995 he started a small consulting business which provides design and analysis services to companies that want to guide their business decisions by means of quantitative analysis - approaches that today we group under the term "analytics." He enjoys writing about those techniques and, in particular, how to carry them out using the world's most popular numeric analysis application, Microsoft Excel.

Carlberg and his wife live near San Diego with their two cats.

Customer Reviews

Most Helpful Customer Reviews

32 of 36 people found the following review helpful:

2.0 out of 5 stars Dissatisfaction rating, May 29, 2006

By 

Mizuno (CA, USA) - See all my reviews

This review is from: Business Analysis with Microsoft Excel (2nd Edition) (Que-Consumer-Other) (Paperback)

I'm generally disappointed at what the book seems to promise and what it delivers. My take on the book is that it is not thorough enough, and topped with a number of typos and reference errors. I find that several examples and references are hard to follow. Perhaps expanding on the explanation on the examples would help. I would also recommend adding a CD for examples. I wouldn't mind paying more to be able to follow the concepts and fully understand them. Afterall, this is business analysis with "Microsoft Excel." There's just no "Excel", just text. Trying to go through this book is more like reading a cliff note version of a "real" book (again, hard to follow leading to discouragement and disappointment. If you're patient, you can find some values, no doubt, just be prepared to spend some time more than you would expect, and to reference a couple more books for validation/clarification of concepts discussed in this book.

26 of 33 people found the following review helpful:

5.0 out of 5 stars Well-rounded Book for Aspiring Business Analysts, May 25, 2002

By 

Robert DeLaMartre (San Diego, CA USA) - See all my reviews

Amazon Verified Purchase

This review is from: Business Analysis with Microsoft Excel (2nd Edition) (Que-Consumer-Other) (Paperback)

Carlberg puts together a very enlightening book with both high level and detailed information. Starting with an introduction to each topic, he then gets into progressively detailed explanations and examples. The beauty of this approach, of course, is that the reader can pursue however much he or she wants to learn about a particular subject.

For the "old hands at BA", beware, this is not an all-encompassing tome on the subject. It is, however, a very good introduction into basic and intermediate analysis of business statistics.

14 of 18 people found the following review helpful:

5.0 out of 5 stars Perfect for beginer in accountancy, January 31, 2003

By 

siourock "siourock" - See all my reviews

Amazon Verified Purchase

This review is from: Business Analysis with Microsoft Excel (2nd Edition) (Que-Consumer-Other) (Paperback)

I have BA in Busines administration and now i start a course in accountancy.
I bought this book to refresh my knowledge in accountancy and because i use Excel almost for everything.
I think that this book is ideal for everyone who want to get an idea of what is accountancy and general business economics. Is very analytical and interpretive so it is understood for everyone who has not any previous experience in Business economics.
Although is very interpretive in acoounting - economic theory, I belive that substantial prior experience in Excel is required.

I'm not sure but I think that the examples of excel applications sometimes have some wrongs. i.e. The example on text refers to B4 cell, but indeed the information that refer to, are in C4 cell if you look better in a picture.