Business Analysis: Microsoft Excel 2010 (MrExcel Library) Review

Average Reviews:

(More customer reviews)Are you looking to buy Business Analysis: Microsoft Excel 2010 (MrExcel Library)? Here is the right place to find the great deals. we can offer discounts of up to 90% on Business Analysis: Microsoft Excel 2010 (MrExcel Library). Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Business Analysis: Microsoft Excel 2010 (MrExcel Library) ReviewThis book is different from other Excel books I've read. The usual approach is to explain what Excel can do and how to do it. This unusual approach reverses the process, identifying business problem and processes, then showing how Excel can help to do the job.
There are four sections: Analyzing Financial Statements, Financial Planning and Control, Investment Decisions and Sales and Marketing. Each section takes a business process, explaining it for those not familiar with it, then showing how Excel can help to eliminate work or illustrate information that might not have been evident.
For example, the first section deals with Income Statements, Balance Sheets, Inventories, Cash Flow and Ratios. In each case, the author shows what Excel can do to make your life easier.
The book uses Excel 2010 as its basis, but mentions how a process might be different when using an earlier version of Excel. Actually, very little reference is made to the tabs present in both Excel 2007 and 2010. Rather, the method of preparing the object at hand is the focus.
The Financial Planning and Control section covers Budgeting and Planning in some depth. The Forecasting chapter explains how the various estimation methods available in Excel differ and the situations in which might be used. The author discusses moving average forecasts, regression and smoothing with Excel's functions. He even covers the concept of Box-Jenkins methods, although the subject is too extensive to cover in this book.
Another interesting chapter is Measuring Quality, which delves into the subject of sampling using various statistical methods.
Statistics comes up again in the Making Investment Decision Under Uncertain Conditions. Here the author covers using standard deviation, confidence intervals and regression analysis.
The book is filled with screen shots of Excel applying the ideas in the text. This gives you a good idea of how to apply the ideas to your own work.
The book includes a helpful glossary and a useful index.
This is a great book for one in business who is familiar with Excel and wants to use it to improve the company's analysis and operations.Business Analysis: Microsoft Excel 2010 (MrExcel Library) OverviewANSWER KEY BUSINESS QUESTIONSCONTROL COMPANY FINANCESFORECAST SALESPREPARE BUSINESS CASESMAKE BETTER INVESTMENT DECISIONSIMPROVE QUALITYUSE EXCEL 2010 TO GAIN DEEPER INSIGHTS, MAKE SMARTER DECISIONS, AND EARN MORE PROFITSUsing real-world examples, Carlberg helps you put Excel's features and functions to work and get the power of quantitative analysis behind your management decisions.Excel expert Conrad Carlberg shows how to use Excel 2010 to perform the core financial tasks every manager and entrepreneur must master: analyzing statements, planning and controlling company finances, making investment decisions, and managing sales and marketing. Using real-world examples, Carlberg helps you get the absolute most out of Excel 2010's newest features and functions. Along the way, you'll discover the fastest, best ways to handle essential tasks ranging from importing business data to analyzing profitability ratios.Becoming an Excel expert has never been easier! You'll find crystal-clear instructions, insider insights, complete step-by-step projects, and more. It's all complemented by an extraordinary set of web-based resources, from sample journals and ledgers to business forecasting tools. • Use Excel analysis tools to solve problems throughout the business• Build and work with income statements and balance sheets• Value inventories and current assets, and summarize transactions• Calculate working capital and analyze cash flows• Move from pro formas to operating budgets that help guide your management decisions•Prepare business cases incorporating everything from discount rates to margin and contribution analysisAbout MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel skills, and presents focused tasks and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will:• Dramatically increase your productivity–saving you 50 hours a year, or more• Present proven, creative strategies for solving real-world problems • Show you how to get great results, no matter how much data you have•Help you avoid critical mistakes that even experienced users make

Want to learn more information about Business Analysis: Microsoft Excel 2010 (MrExcel Library)?

>> Click Here to See All Customer Reviews & Ratings Now