Learn How to Do-It-Yourself!
AUTO
BUSINESS
COMPUTERS
ELECTRONICS
ENTERTAINMENT
HEALTH
HOME
MONEY
TRAVEL
MORE »
  Search:       

Business Analysis with Microsoft Excel (3rd Edition) (Business Solutions)

by Conrad Carlberg

List Price:$34.99
Amazon Price:$25.54 & eligible for FREE Super Saver Shipping on orders over $25.
You Save:$9.45 (27%)
Average Rating:4 out of 5 stars
Lowest New Price:$19.50
Availablitiy:Usually ships in 24 hours

Buy Now!

Editorial Reviews
Product Description

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

 
All Customer Reviews
Average Customer Review:4 out of 5 stars
0 of 0 people found the following review helpful:

5 out of 5 starsgreat business book, 2008-12-01
i am a small business guy and am looking to better manage my business projects including calculation of project costs and prediction of revenues, sales forcasting, scenario analysis etc... i know that i can probably buy a ton of software to do this for me or hire consultants. However, i believe that any help that you get from external sources is basically a crutch when i am disabled by myself, so i like to learn the thing myself first and then maybe hire outsiders... and this book is GREAT for me... i wont talk about specific sections because honestly, i got it delivered only yesterday... but it appears to cover all the topics i wanted in a very clean business way... this is a business book with MS Excel as the tool that it uses to do what it does... so, it tells you how to calculate IRR and then does it in excel. how to calculate times-interest earned ration and shows tips, tricks and means in excel...


2 of 4 people found the following review helpful:

2 out of 5 starsBusiness Analysis with Microsoft Excel, 2008-03-25
Overall, I was not impressed with this book. I was hoping to get a book with examples of functions for use in financial analysis. Instead, the book focused more on financial analysis fundamentals.


20 of 22 people found the following review helpful:

2 out of 5 starsDissatisfaction rating, 2006-05-30
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.


4 of 8 people found the following review helpful:

5 out of 5 starsMust have analyst book!!!, 2005-01-10
This book was well written for anyone starting out in spreadsheet analysis work. Each chapter provides many examples to get you going and provides carefull desciption of analysis tools.


17 of 22 people found the following review helpful:

5 out of 5 starsA MBA student, 2004-10-19
Surprisingly, this is an incredible book. I take my MBA at University of Delaware. To apply how to use MS Excel effectively, this is the all-in-one book that can serve me for many classes such as Financial Reporting and Analysis, Data Analysis and Management Control, Financial Management, Marketing Management, Operation Management and Management Science, etc. The book is about intermediate level not too easy or too advance.

Before you buy other books in Excel, you should check the content first.
If the content focus on the function such as how to use date function, do not buy it. The content that you looking for should like this book. For example, the book should show you how you deal with balance sheet. Then, it explaints what Excel function can do for you.


Price is accurate as of the date/time indicated. Prices and product availability are subject to change. Any price displayed on the Amazon website at the time of purchase will govern the sale of this product.
Related Products