Contenuto del volume:
This is the most practical, wide-ranging, and useful guide to using
Microsoft Excel 2010 for business analysis. Long-time
Excel MVP Conrad Carlberg shows how to use
Excel 2010 to gain insight and solve problems in virtually every area of business, from finance and marketing to quality management. Utilizing real-world examples, he demonstrates how to make the most of powerful new
Excel 2010 features, including Sparklines,
Excel Web App, Slicer, and
Excel's new Solver and calculation engine.
Writing for managers and professionals in businesses of all sizes, Carlberg covers these and many other topics: Analyzing revenues, profits, cash flow, fixed assets, inventories, growth, working capital, and more. Forecasting sales through regression and smoothing approaches. Preparing business cases and pro formas that reflect market size/share, opportunity costs, discount rates, profitability, payback times, and contribution and margin analysis. Using
Excel's built-in functions to measure product quality, uncover problems, and identify solutions. This book will be indispensable for all
Excel user who wants to gain a deeper understanding of where their businesses stand financially, and make better decisions about investments and business priorities.
This book is part of the new MrExcel Library series, edited by Bill Jelen, world-renowned
Excel expert and host of the enormously popular
Excel help site, MrExcel.com. * Shows how to use
Excel to take total control over company finances * Covers everything from financial statements and marketing to investment decision-making and quality management, using real-world examples * Demonstrates powerful new features, including Sparklines, Slicer, and the new Solver * Part of the new MrExcel's Library series, edited by
Excel legend Bill Jelen