02423cam a2200205Mi 4500020001800000020001500018050001700033100001600050245008800066250001200154260002800166300005600194500002000250505045200270520112500722650002201847650021501869856007302084856006002157 a9781856175517 a1856175510 aHG 179 bNUG1 aNugus, Sue.10aFinancial planning using Excel : bforecasting, planning and budgeting techniques / a2nd ed. aOxford :bCIMA,cc2009. a1 online resource (XIV, 224 pages.)bIllustrations. aIncludes index.0 aPreface; 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. aThis 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. 0aFinance, Personal 7aMicrosoft Excel (computer file).aFinance, personal - computer programs.aAccounting - data processing.aBusiness enterprises - finance.aCorporations - finance - data processing.aBusiness.aFinance, personal.40uhttp://0-www.sciencedirect.com.fama.us.es/science/book/978185617551740uhttp://www.sciencedirect.com/science/book/9781856175517