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.
By:
Sue Nugus (Consultant and author with more than 15 years in the IT industry.) Imprint: CIMA Publishing Country of Publication: United Kingdom Edition: 2nd edition Dimensions:
Height: 229mm,
Width: 152mm,
Spine: 15mm
Weight: 400g ISBN:9781856175517 ISBN 10: 1856175510 Series:CIMA Professional Handbook Pages: 240 Publication Date:10 December 2008 Audience:
Professional and scholarly
,
Undergraduate
Format:Paperback Publisher's Status: Active
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.