Advanced Excel

Book the entire event before 5 April

2009 and SAVE US$ 500!

Advanced Excel: Spreadsheet Techniques And Financial Applications Improve Your Computing Efficiency And Financial Application Abilities And Get More Done In Less Time!

14 – 18 June 2009 JW Marriott Hotel, Dubai, UAE

Course I:

Course II:

Advanced Excel Spreadsheet Techniques

Innovative Excel Model Building

14 – 15 June 2009

16 – 18 June 2009

Attend to:

Attend to:

• Gain skills to perform the most complex calculations and functions • Work efficiently with related worksheets and workbooks • Increase your ability to forecast outcomes accurately • Analyse data accurately using pivot tables • Learn how to use spreadsheet skills effectively for advanced financial applications

• • • •

Understand how to design an effective spreadsheet Adopt logical methods to solve complex problems Benefit from new reporting and presentation techniques Save time and reduce frustration when working on Excel spreadsheets • Take your current Excel skills to the next level

Top 10 Reasons To Attend This Highly Beneficial Course! Who Should Attend? This course is designed for finance professionals who are required to work with spreadsheets and want insights on how to use them more effectively. Those responsible for accountancy, financial and credit controlling, as well as business and financial analysis will certainly benefit. This course will also benefit those working in areas of budgeting, treasury and risk management.

Organised By

Official Regional Recruitment Partner

www.iirme.com/excel

Meet Your Expert Course Leader Richard France is a Chartered Accountant (FCA) with an MBA from Henley Management College and has been in training and consultancy for 18 years. He works in his own company, Logic Consultants Ltd. and also for PMMS Consulting Group Ltd. which specialises in supply chain and negotiation skills consultancy. He supplies training in finance and risk management and works for companies such as RollsRoyce, Pirelli, AstraZeneca, Sanofi Aventis and Government Departments, both internationally and in the UK. He is also retained by a British University to deliver their accredited management development programmes. Richard has been a Financial Director of a manufacturing company with 300 staff and also worked for a management consultancy raising finance for companies and providing company ‘doctoring’ consultancy. In addition to his training services, he also handles strategic and business planning projects for smaller and medium sized companies and is often involved in their implementation. Spreadsheet modelling for decision support information is his particular strength.

Hear What Delegates Had To Say About The Previous Course: The course has immensely benefited me in developing my Excel skills and will greatly influence the quality of my work. Mahesh Kumar Narayan Principal Finance Real Capita BSC, Bahrain The course covered both insights of Excel and finance and business models. It has really enhanced my knowledge. Shafi Ahmed Information Analyst National Titanium Dioxide Co., KSA A perfect, useful and informative event. Syed Zubair Shah Senior Accountant Eli Lilly SA, KSA

www.iirme.com/excel

Dear Finance Professional, Imagine being able to create a report in 15 minutes instead of two hours, or fitting that monthly management presentation into 20 minutes rather than a whole day! Turning your data into valuable business information using Excel is the most powerful skill you could ever learn. It will save you time and make easy work of calculations. IIR’s two-part Advanced Excel: Spreadsheet Techniques And Financial Applications, taking place from 14 – 18 June 2009 in Dubai, is your opportunity to dramatically improve your computing efficiency and financial application ability. You will not only learn practical, advanced skills to increase productivity, you will also be able to enhance your value as a finance professional. These highly beneficial training courses will allow you to develop a full set of tools to implement directly in your organisation on your return. During five practical and beneficial days you will get a high-level education which will teach you the skills to dramatically improve your calculations, business modelling and manipulation of financial data. Please see the following pages for full programme details. Register now by completing the form on the back of the brochure. You can also register by e-mailing [email protected] or by visiting the website at www.iirme.com/excel Take your Excel skills to a higher level and get more done in less time. I look forward to welcoming you to this essential course in June 2009! Kind regards,

Keith Parker Conference Manager P.S. Register NOW and benefit from early bird discounts!

Due to the pragmatic nature of this programme, you will have access to a computer and therefore be able to practice and discuss the examples. Delegates who wish to bring their own laptop computers can do so.

www.iirme.com/excel

Course I : 14 – 15 June 2009

Advanced Excel Spreadsheet Techniques Course Timings Registration and refreshments will be at 08.00 on the first day. Each day will commence at 08.30 and conclude at 14.30 with lunch. There will be two refreshments breaks at appropriate times. Course Objectives You will gain the practical skills to: • Discover hidden short-cuts to dramatically reduce the time you spend on spreadsheets • Learn how to format quickly and accurately • Develop practical solutions to your business problems through superior spreadsheet design • Upgrade your spreadsheet skills with advanced data management techniques • Use macros more efficiently • Consolidate worksheets from different sources into one workbook • Develop efficient techniques for using charts and maps • Use spreadsheet skills for advanced financial applications • Create, format and trouble shoot pivot tables • Analyse data accurately using pivot tables Course Pre-Requisite It is imperative for you to have good Excel knowledge prior to attending this course to maximise your learning experience. The course material will include extensive use of Excel and it is essential that you are at ease with using spreadsheets. This is not a basic Excel programme. During the course you will work through a series of hands-on practical exercises. Similarly, the financial applications require a sound knowledge of financial techniques. This course provides a comprehensive guide to the latest tools and skills for all finance professionals.

Day One – Sunday, 14 June 2009 Session 1 – Intro To Programme – Auditing, Hiding And Protecting, Formatting And Conditional Formatting Session 2 – Account Interpretation, Trends And Case Study Session 3 – Importing, Sorting, Filtering, Pasting, Linking, Absolute References, Naming And Comments

Importing Data Into A Spreadsheet • Querying a database from Excel • Using filter and sort in database query Using Paste Special • Why use paste special? • Pasting different types of information • The operations area • Special options Linking Data In Spreadsheets • Linking to a cell on the same spreadsheet • Linking to cells in other worksheets • Linking to cells in other workbooks • Cell references in formulae • Linking to cells in Excel workbooks from Word • Linking charts Naming Cells And Adding Comments • Cell names • Comments Formatting Your Spreadsheets • Freezing row and column titles • Using AutoFormat • Custom number formats • Conditional formatting Auditing Your Spreadsheet • Formulae and locations • Tracing precedent cells • Tracing dependent cells Sharing And Protecting Your Spreadsheets • Hiding columns and rows • Hiding worksheets • Protecting cells • Protecting worksheets • Protecting workbooks Sorting Data In A Spreadsheet • Sorting data in Excel • Custom sort orders • Defining a custom list Financial Analysis • Financial statements • Financial ratio analysis • Financial forecasting

Day Two – Monday, 15 June 2009 Session 1 – Validating Data, Pivot Tables Session 2 – Macros, Functions, Look Up Session 3 – Charting, IF, Data Tables Data Validation Summarising Data Using Pivot Tables • What are pivot tables? • Creating pivot tables • Grouping data in pivot tables • Refreshing pivot tables • Formatting a pivot table • Selecting elements of a pivot table • Making use of multiple data fields • Using grand totals and subtotals • Changing a pivot table’s calculations Using Excel Macros • What are macros? • Recording macros • Running macros • Adding macros to a toolbar • Using macro buttons Using Reference And Mathematical Functions • Reference functions • Subtotalling • 3D sum • SUMIF • ROUND • Nesting Customising Charts • Deleting a data series from a chart • Modifying the chart type for a data series • Formatting chart axis • Widening the gaps between columns in a chart • Inserting a picture in a chart • Changing the angle of slices in a pie chart • Exploring all the slices in a pie chart • Repositioning chart elements Using Data Tables And Scenarios • Data tables • 1-input data tables • 2-input data tables • Named scenarios • Scenario summaries Using Logical Functions • IF • AND • OR • ISERROR

Tel: 971-4-3352437 • Fax: 971-4-3352438 • Email: [email protected] • Web: www.iirme.com/excel

Course II : 16 – 18 June 2009

Innovative Excel Model Building Course Timings Registration and refreshments will be at 08.00 on the first day. Each day will commence at 08.30 and conclude at 14.30 with lunch. There will be two refreshments breaks at appropriate times.

Day One – Tuesday, 16 June 2009 Session 1 – Decision Tools – Goal Seek, Scenarios, Solver And Spinners Session 2 – Operational Gearing, Marginal Costing, Cash Flow Session 3 – Building A Financial Model

Practical Exercises Explore the following: • Future value and present value • Annuities, both equal cash flows and unequal cash flows • Continuous compounding • Cost-volume-profit analysis

Forthcoming Related Events: BC2931 Advanced Financial Statement Analysis 29 March – 2 April 2009 www.iirme.com/advfinance

Look Up Tables Using Statistical And Database Functions • Statistical functions • Database functions Gearing And Capital Structure • Operating gearing • Financial gearing • Combined gearing • Capital structure Practical Exercises Explore the following: • Degree of operating leverage • Break-even point • Calculation of business risk • Degree of financial risk • Decision tools – goal seek, solver, scenarios, spinners • Marginal costing • Cash flow Model Building Exercise

Day Two – Wednesday, 17 June 2009 Session 1 – Continue Building Financial Model Session 2 – Payback And DCF Session 3 – Weighted Average Cost Of Capital (WACC) Model Building Exercise (Continue) Using Financial Functions • Net Present Value (NPV) • Present Value (PV) • Future Value (FV) Mathematics For Finance • The time value of money • Calculation of future value and present value • Continuous compounding • The discounted cash flow

BC2961 Cost Of Capital • Cost of debt • Cost of equity • Weighted average cost of capital (WACC)

Financial Modelling Using Excel

Practical Exercises Explore the following: • Cost of debt • Opportunity cost of capital • Weighted Average Cost of Capital

BC2999

26 – 30 April 2009 www.iirme.com/excelmodelling

Aligning Budgeting With Strategy 31 May – 4 June 2009 www.iirme.com/alignbudget

Capital Budgeting Techniques • Definitions • Payback method • Internal Rate of Return (IRR) • Net Present Value (NPV) • Cash flows and capital budgeting

Day Three – Thursday, 18 June 2009 Session 1 – Company Valuations Session 2 – Company Valuations (Continued) Session 3 – Free Cash Flow And Valuing Bonds Valuations • Asset based valuations • Earnings based valuations • Cash flow methods of valuation • Free cash flow • Valuing bonds Risk Analysis • Techniques for measuring risk • Sensitivity analysis • Scenario analysis Practical Exercises Examine the tools and techniques developed throughout the course

Tel: 971-4-3352437 • Fax: 971-4-3352438 • Email: [email protected] • Web: www.iirme.com/excel

Advanced Excel: Spreadsheet Techniques And Financial Application 14 – 18 June 2009 • JW Marriott Hotel, Dubai, UAE

FIVE EASY WAYS TO REGISTER

www.iirme.com/excel For further information and Group Discounts* contact 971-4-3352483 or email: [email protected]

BC2984

* Group discounts are only applicable on the full event price Yes, I want to register for: Event

Dates

Price before 5 April 2009

Price between 5 April and 3 May 2009

Price after 3 May 2009

Book the entire event

14 – 18 June 2009

Course I: Advanced Excel Spreadsheet Techniques (2 days) Course II: Innovative Excel Model Building (3 days)

14 – 15 June 2009

US$ 4,250 (Save US$ 2,140) US$ 2,695 (Save US$ 200) US$ 3,195 (Save US$ 300)

US$ 4,550 (Save US$ 1,840) US$ 2,795 (Save US$ 100) US$ 3,395 (Save US$ 100)

US$ 4,750 (Save US$ 1,640) US$ 2,895

16 – 18 June 2009

US$ 3,495

If you have eight or more delegates who need this training, contact IIR In-House on 971-4-3352439 or [email protected] Course fees include documentation, luncheon and refreshments, Delegates who attend all sessions will receive a Certificate of Attendance.

PERSONAL DETAILS: Title

First Name

Surname

Job Title

Department

Email

Mobile

st

1 Delegate 2nd Delegate 3rd Delegate 4th Delegate To assist us with future correspondence, please supply the following details:

Head of Department Training Manager Booking Contact Company Address (if different from label above): Postcode: Tel: No. of employees on your site: 0-49

50-249

Country:

Fax:

250-499

500-999

Yes! I would like to receive information about future events & services via email. My email address is:

1000+

Nature of your company’s business:

Payments

Cancellation

A confirmation letter and invoice will be sent upon receipt of your registration. Please note that full payment must be received prior to the event. Only those delegates whose fees have been paid in full will be admitted to the event. You can pay by company cheques or bankers draft in Dirhams or US$. Please note that all US$ cheques and drafts should be drawn on a New York Bank and an extra amount of US$ 6 per payment should be added to cover bank clearing charges. All payments should be made in favour of IIR Holdings Ltd.

If you are unable to attend, a substiture delegate will be welcome in your place. If this is not suitable, a US$ 200 service charge will be payable. Registrations cancelled less than seven days before the event must be paid in full.

Avoid Visa Delays - Book Now Card Payment Please charge me my credit card:

Visa

Mastercard

American Express

Name on Card: Card Number:

Signature:

Exp. Date:

Delegates requiring visas should contact the hotel they wish to stay at directly, as soon as possible. Visas for non-GCC nationals my take several weeks to process. Due to unforeseen circumstances, the programme may change and IIR reserves the right to alter the venue and/or speakers. SY

Event Venue JW Marriott Hotel, Dubai, UAE Tel.

971-4-2624444

Accommodation Details We highly recommend you secure your room reservation at the earliest to avoid last minute inconvenience. You can contact the IIR Hospitality Desk for assistance on: Tel:

971-4-4072693

Fax:

971-4-4072517

Email: [email protected]

©COPYRIGHT I.I.R. HOLDINGS B.V.