FINANCIAL PLANNING USING EXCEL FORECASTING PLANNING AND BUDGETING NUGUS S. Księgarnia

This book covers all aspects of budget preparation, from designing and creating a budgetary control system, consolidating data and working with spreadsheets.

Now fully updated to include the latest version of Excel, Excel 2007 and for easy budgeting now with access to an online resource of worked examples and spreadsheet templates. The book shows how things are done in Excel 2003 and Excel 2007 to ease transition from the previous version to the new version. Now in full colour throughout to aid quick uderstanding through numerous colour screen shots.

For those who use Excel on a daily basis in budget planning, this book is a must. It contains a wealth of practical examples, tips, new techniques all designed to help quickly exploit and master Excel to its full advantage and therefore use spreadsheets for more effective management accounting in your firm.

* covers migration from Excel 2003 to Excel 2007 showing how to do it in both versions
* new edition now in full colour through out to aid quick understanding
* practical examples, tips and techniques - exploit Excel 2007 for effective management accounting

Using Excel 2007

1 Spreadsheet skills for all types of planning 3

2 Forecasting 27

3 Collecting and examining the data 33

4 Smoothing techniques 47

5 Regression analysis 59

6 Time series analysis 75

7 Expected values 85

8 Selecting and evaluating forecasting techniques 93

9 Business planning 103

10 Developing a financial plan 113

11 Business plans 129

12 What-if analysis 151

13 Pivot tables 167

14 Risk analysis 181

15 Budgeting 195

16 A spreadsheet budgeting system 203

17 Consolidating data 213

Index 221

240 pages , Paperback

Po otrzymaniu zamówienia poinformujemy,
czy wybrany tytuł polskojęzyczny lub anglojęzyczny jest aktualnie na półce księgarni.

FINANCIAL PLANNING USING EXCEL FORECASTING PLANNING AND BUDGETING

NUGUS S.

Table of Contents