Book Description
Provides the most extensive coverage of Microsoft Excel's financial capabilities for those individuals running a small business or controlling the bottom line of a major corporation.
Individuals will find reference to many Excel functions and capabilities that they may already be using in their business activities on a daily basis. But they will also find discussion tools that they've never used, or that they might never have considered using in the context of business analysis.
No one can be completely familiar with every option in an application like Excel. The purpose here is to help fill in some of the gaps that may have penetrated one's knowledge base since one's last course in business or since one first learned how to use a spreadsheet.
Companion CD contains VBA Code to automate the creation of forecasts, process control charts, and sales and marketing analysis as well as fully developed Excel worksheets readers can incorporate into their own business analysis challenges. Business Analysis with Microsoft Excel 2002 is divided into four parts- financial statements and statement analysis which discusses fundamental financial concepts and tools; financial planning and control that covers budgeting methods and quality control procedures; investment decisions in which you'll find business case-analysis and profit planning; strategies for structuring and testing business cases as well as ways to quantify the degree of risk involved in entering a new line of business; and sales and marketing analysis, costing and pricing, and margin analysis
Conrad Carlberg is president of Network Control Systems, Inc., a software and consulting firm that specializes in the development of quality control and forecasting tools for the health industry. He holds a Ph.D. in statistics from the University of Colorado, and is a multiple recipient of Microsoft's Excel's Most Valuable Professional award.
Synopsis
Business Analysis with Microsoft Excel 2002 is divided into four parts: financial statements and statement analysis which discusses fundamental financial concepts and tools; financial planning and control that covers budgeting methods and quality control procedures; investment decisions in which you'll find business case-analysis and profit planning; strategies for structuring and testing business cases as well as ways to quantify the degree of risk involved in entering a new line of business; and sales and marketing analysis, costing and pricing, and margin analysis
See all Product Description