COVID-19 Update: We are currently shipping orders daily. However, due to transit disruptions in some geographies, deliveries may be delayed. To provide all customers with timely access to content, we are offering 50% off Science and Technology Print & eBook bundle options. Terms & conditions.
Financial Planning Using Excel - 2nd Edition - ISBN: 9781856175517, 9780080949833

Financial Planning Using Excel

2nd Edition

Forecasting, Planning and Budgeting Techniques

Author: Sue Nugus
eBook ISBN: 9780080949833
Paperback ISBN: 9781856175517
Imprint: CIMA Publishing
Published Date: 10th December 2008
Page Count: 240
Sales tax will be calculated at check-out Price includes VAT/GST
Price includes VAT/GST

Institutional Subscription

Secure Checkout

Personal information is secured with SSL technology.

Free Shipping

Free global shipping
No minimum order.

Table of Contents

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.


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. 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 understanding through numerous color 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.

Key Features

  • 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


Financial Controller; Business Planning Manager; Assistant Accountant; Management Accountant; Commercial Finance Manager. Head Office Accountant; Office Manager; Finance Director.


No. of pages:
© CIMA Publishing 2008
10th December 2008
CIMA Publishing
eBook ISBN:
Paperback ISBN:

Ratings and Reviews

About the Author

Sue Nugus

Affiliations and Expertise

Consultant and author with more than 15 years in the IT industry.