Product Description

Excel for Financial Planning 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 and includes a useful CD-ROM containing worked examples and spreadsheet templates, for easy budgeting.

For all qualified and part qualified management accountants 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 you quickly exploit and master Excel to its full advantage and therefore use spreadsheets for more effective management accounting in your firm.

* Provides quick, useful guidance on how to use Excel in management accounting
* Covers basic principles of budgetary control
* Explains the latest techniques for the design and creation of budgets

Product Details

• Amazon Sales Rank: #837167 in Books
• Published on: 2005-12-22
• Original language: English
• Number of items: 1
• Binding: Paperback
• 192 pages

From the Back Cover
Financial Planning using Excel is a must for anyone who uses this product for financial planning. It will be useful to all management accountants - both qualified and still in training. The book contains a wealth of practical examples, tips and new techniques all designed to help you quickly exploit and master Excel to its full advantage and therefore use spreadsheets for more effective management accounting in your organisation.

Financial Planning using Excel covers all aspects of financial management, from forecasting to preparing financial plans through to the preparation and management of budgetary control systems.

Topics include:
* financial forecasting using smoothing techniques, regression analysis, time series analysis etc
* designing and creating a series of financial plans
* different types of business plans including traditional projections as well as advanced techniques including statistical planning and optimising models
* a range of what-if tools including data tables, sensitivity analysis and goal seeking features
* managing a budgetary control system featuring the summary and aggregation of data from multiple sources.

Customer Reviews

excel for standard planning
I bought this book hoping to learn something new and advanced but found myself redaing things that are simple to impliment in excel.
There examples are on a very basic level , the templates that are supplied are for understandning the basics and no more then that.

Over all, I was very dissapointed. This book is for for beginers in excel who want to upgrade their thinking and planning to beginner plus level.