Financial Planning Using Excel

Covers the various aspects of budget preparation, from designing and creating a budgetary control system, consolidating data and working with spreadsheets. This book covers migration from Excel 2003 to Excel 2007. It contains examples, tips and techniques that exploit Excel 2007 for effective management accounting.

Klappentext

With practical examples, tips and techniques, covering Excel 2003 and 2007.

Inhalt

Preface; Excel 2003 to Excel 2007; Part One: Forecasting; Collecting Data; Smoothing Techniques; Regression Analysis; Time Series Analysis; Expected Values; Selecting and Evaluating Forecasting Techniques; Part Two: Business Planning; Spreadsheet Skills for all Types of Planning; Developing a Financial Plan; Business Plans; What if Analysis; Pivot Tables; Risk Analysis; Part Three: Budgeting; A Spreadsheet Budgeting System; Consolidating Data.