www.informa-mea.com/excelmodelling
an
event
18 - 22 January 2015
Sheraton Dubai Mall of the Emirates Hotel,
Dubai, UAE
10 - 14 May 2015
Dusit Thani Hotel, Dubai, UAE
4 - 8 October 2015
Venue TBC, Dubai, UAE
Top 5 Learning Objectives
1. Understand the essence of financial models and analyse their
applications
2. Discover how to construct reliable and realistic financial
models that work and are easy to review
3. Learn to measure, interpret and predict company performance
using Excel modelling
4. Improve your decision making processes and save time on
financial analysis
5. Proficiently use Excel as an analytical tool and enhance your
financial abilities
Includes one full day on Essential Excel
For Finance
Book and pay NOW
and bring your colleague for FREE
on this course
See last page for details*Certificate In Financial
Modelling Using Excel
Led by
Danielle Stein Fairhurst
Sign up for this course and
receive a complimentary copy of
Using Excel for Business Analysis
written by your Course Director
Danielle Stein Fairhurst is the
Principal of Plum Solutions, a Sydney-based consultancy specialising in Excel modelling and analysis. With over 14 years’ experience as an analyst, she helps her clients create meaningful models in the form of business cases, pricing models and management reports. She has hands-on experience in a number of industry sectors, including telecoms, information systems, manufacturing and financial services.
Danielle is the author of “Using Excel for Business Analysis” which is part of the Wiley finance series. She has regular engagements around Australia and globally as a speaker, course facilitator, consultant and analyst. She holds a Master of Business Administration (MBA) from Macquarie Graduate School of Management (MGSM), and has taught management accounting subjects at Sydney University.
Course Materials
Delegates will receive a complimentary copy of Using Excel for Business Analysis: a Guide to Financial Modelling Fundamentals, by your trainer, Danielle Stein Fairhurst which contains instructions in Excel 2007 and 2010, and Excel for Mac.
Software
Bring your own laptop to the session installed with any version of Microsoft Excel. Although the course includes an overview of the new features in later versions of Excel, delegates should bring their laptops loaded with whichever version they are comfortable using in their everyday work.
Course Prerequisites
The course material includes extensive use of Excel and delegates will gain the maximum benefit from this course if they are already competent spreadsheets users. It is designed for users who do use (or will use) Excel on a regular basis, and are comfortable with using its tools and functions.
About Your Expert Course Director
www.informa-mea.com/excelmodelling
E: [email protected]
The George Washington University School of Business, Informa Middle East’s Academic Partner, is dedicated
to excellence: in its teaching and research about management, in the public and private sectors, within the
United States and internationally.
The school has a 75 year history of preparing men and women for leadership in both the public and private
sectors. Known internationally for its dedication to academic excellence, the school draws students from all
parts of the United States and around the world. Beyond first class teaching and scholarship, the school’s
faculty offers practical experience in the issues and challenges confronting business and government. Its research centres link faculty and students with US and international business and government organisations. Recent distance learning initiatives have expanded the
school’s global reach.
Course Requirements And Certificates
Delegates must meet two criteria to be eligible for an Informa/GW Certificate of Completion for a course: 1. Satisfactory attendance – delegates must attend all sessions of the course. Delegates who miss more than 2 hours of the course sessions will not be eligible to sit the course assessment.2. Successful completion of the course assessment Delegates who do not meet these criteria will receive an Informa Certificate of Attendance. If delegates have not attended all sessions, the Certificate will clearly state the number of hours attended.
Course Assessment
Delegates are required to submit one of the models built during the course for assessment and to sit for a short exam at the completion of the course.
Would you like to run this
course in-house?
Our in-house training division
Tel: +971 4 4072624
Email: [email protected]
www.informa-mea.com/cts
This is what delegates have said
about Danielle Stein Fairhurst’s
previous Certificate In Financial
Modelling courses
“Danielle has vast experience in financial
modelling building, she shared practical
experiences with us. I would like to attend
another course with her.”
Muhammed Arif Masood, Aldar Properties, UAE
“Danielle is an expert in financial modelling.”
Dr. Ram Behin, Team Leader Projects Universal Hospital, UAE
T: +971 4 335 2437
www.informa-mea.com/excelmodelling
E: [email protected]
Day One
Essential Excel For Finance
Specifically designed for business professionals who need to take their Excel skills to the next level, this intensive full day course focusses on the technical Excel skills that will be required for the Financial Modelling course. This very practical day covers everything you need to perform your job.
For those who don’t have time to sit through extensive Excel “how to” training, this day will arm you with a range of tools, techniques and formulas essential for finance. Guaranteed to contain “no fluff”, this day will equip you with the skills to produce more efficient and accurate Excel models and increase productivity.
Must-Know Tools And Techniques
• Key points on upgrading from prior versions of Excel to the latest, 2013
• Absolute referencing • Named ranges • Time saving shortcuts
New Features In Excel 2010 And 2013
• An overview of power pivot
• Using sparklines to display trends on dashboards • Applying a slicer to pivot tables
Formulas You Simply Can’t Live Without
• LOOKUP, VLOOKUP, HLOOKUP • Logical functions eg. IF, AND
• Aggregation functions eg. SUMIF, COUNTIF • Financial functions eg. NPV, IRR, PMT • Formula nesting
Bullet-Proofing Your Model
• Protect data by locking cells • Password protection
• Restricting incorrect data entry with data validations • Using worksheet protection to prevent entry • Protecting your file using “Read Only” and password protection
Charting
• Creating and modifying a chart • Making your charts look fabulous • Charting tips, tricks and shortcuts • New charting features of Excel 2013
Essential Advanced Tools
• Autofilters • Goal seek • Macros • Pivot tables • Array formulas
Other Useful Tools
• Spin buttons and drop-down menus • Hiding
• Working with dates • Hyperlinking
• Conditional formatting
Day Two
Introduction To Financial Modelling
• What is financial modelling?
- Typical examples and purposes of financial models
• Software selection
- Tool selection and advantages and disadvantages of Excel
and other software for the purpose of financial modelling • Model design
- Model planning and steps in building your model
• Skills needed for financial modelling
- The technical, design, business and industry knowledge
required for financial modelling • Model tools and functions
- Which formula or tool is most appropriate in which
modelling situation?
• Building the business case: issues and logic surrounding the calculation of customer acquisition
- Creating the pool of potential customers - Narrowing down the pool
- Expected customer acquisition - Lost customers/customer defection - Market penetration
Practical exercises: Modelling exercises using a range of
financial functions and tools. Building a business case utilising financial modelling techniques
Course Outline
18 - 22 January 2015, Sheraton Dubai Mall of the Emirates Hotel, Dubai, UAE
10 - 14 May 2015, Dusit Thani Hotel, Dubai, UAE
4 - 8 October 2015, Venue TBC, Dubai, UAE
Course Timings
Registration will be from 7:30 on Day One. Each day the course will commence promptly at 8:00 and conclude at 14:30 followed by lunch. Refreshments will be served at approximately 10:30 and 12:30.
Day Three
Financial Modelling Theory And Best Practice
• Modelling techniques
- What makes a good model? Attributes of a good model
such as user-friendly and structural features
- Avoiding Excel errors – A wrong calculation in a model can
have disastrous consequences! Strategies to reduce errors in financial modelling
- Rebuilding an inherited model - Building error checks
- Correcting errors
- Create a more efficient model with links
- Dealing with links and the potential errors they cause
• Bullet-proofing your model
Retain model integrity and prevent misuse of your model by learning to restrict incorrect inputs
- Protection - Locking cells
- Restriction of incorrect data entry with data validations
• Making a model user-friendly
- Formatting - Navigation
• Dealing with uncertainty and risk
- Economic inputs to model, and modelling fluctuations in
external factors
- Use of stress testing to validate a model - What-if analysis
- Importance of assumptions when assessing risk
• Create a best, base and worst case scenario on your model Technical tools for creating scenarios:
- Manual sensitivity analysis; drop-down scenarios - Scenario manager
- Data tables
• Displaying final model results and findings
Communicate the results of your model clearly and concisely whilst getting the key message across to the audience
- Documentation and source referencing - Writing assumptions
- Writing operation instructions
Practical exercise: Building scenarios and perform sensitivity
analysis on financial models. Build a property development scenario model. Build a cash flow funding model, including a P&L, cash flow and balance sheet including scenario analysis.
Day Four
Financial Modelling For Budgeting And Forecasting
• Practical application of modelling in Excel for the purpose of budgeting for organisations
- Advanced forecasting functions; time series, exponential
smoothing and regression analysis
- Modelling for “stepped” costs when forecasts include both
fixed and variable costs
- Sales forecasting – predication of likely sales revenue
based on drivers
- Seasonality – simply and easily spread revenue or expenses
throughout the budget period based on season variations
- Building an expense budget – based on given assumptions,
you will build a budget for 12 months
- Contingency planning – calculating a contingency based on
assumptions about probability and impact of unexpected events
- Budgeting for capital expenditure – capital expenditure is
budgeted for cashflow and then depreciated
- Cash flow budgeting – translating your profit and loss
statement into a cashflow forecast
- Reporting against budget; variance analysis – creating a
template into which actual and budget can be compared and analysed
Practical Exercise: Create a model in Excel which will
calculate volume-dependent costs
Day Five
Practical Financial Modelling
• Charting and graphing fundamentals – how to build charts • When to use a table or charts; combining tables and charts using chart data table and data bars
• Choosing the correct chart to display your findings
• Visual design – dos, don’ts and common mistakes in graphical presentation of data and reports
• How to present easy to follow information concisely and clearly
• Pivot Tables and their role in financial modelling
Practical exercise: Build your own flexible report including a
dynamic chart
Case Studies
Demonstration and overview of the following: 1. Tiering tables
One of the more complex and widely used calculations in financial modelling. Discussion of two different methods of calculation; a simple and progressive table
2. Pricing models
Calculating profitability and break-even points at various prices
3. Dynamic charting
Create a user-friendly report with a dynamic chart based on drop-down selections
4. Modelling for risk assessment
Assess project risk with a risk assessment model using conditional formatting
Practical Exercise: Forecast a sales cycle based on historical
data by calculating the seasonality index and adjusting the forecast accordingly
Who Should Attend
This hands-on course is designed for middle and senior business and finance professionals as well as general managers who need to use financial models to measure business performance, including:
• Finance Managers and Controllers • Strategy Directors and Managers
• Budget, Corporate, Business and Financial Analysts • Project Managers and Risk Analysts
• Investment and Management Accountants • Heads of Business Units and Business Planners • Financial Advisors and Corporate Analysts
T: +971 4 335 2437
www.informa-mea.com/excelmodelling
© Copyright Informa Middle East Ltd
FN
SN/ST FINANCE
FIVE WAYS TO REGISTER
Informa Middle East P.O Box 9428, Dubai, UAE +971 4 335 2438 +971 4 335 2437
DISCOUNTS AVAILABLE
FOR 2 OR MORE PEOPLE
CALL:
+971 4 335 2483
E-MAIL:
[email protected]
Would you like to run this course in-house?
Save training $$ and create learning experiences relevant to your business. To customise this course and increase value and impact, contact Leigh Kendall on +971 4 407 2624 or email the team at [email protected]
Course fees include documentation, luncheon and refreshments. Delegates who attend all sessions and successfully complete the course assessment will receive an Informa/GW Certificate of Completion.
* The 2 for 1 offer is valid on full price registrations for this course only
* The offer is only valid on January course dates * Not applicable in conjunction with corporate discounts * Payment to be settled before start of the course
All registrations are subject to our terms and conditions which are available at www.informa-mea.com/terms. Please read them as they include important information. By submitting your registration you agree to be bound by the terms and conditions in full.
PAYMENTS
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.
AVOID VISA DELAYS – BOOK NOW
Delegates requiring visas should contact the hotel they wish to stay at directly, as soon as possible. Visas for non-GCC nationals may take several weeks to process.
CANCELLATION
If you are unable to attend, a substitute delegate will be welcomed in your place. Registrations cancelled more than 7 days before the Event are subject to a $200 administration charge. Registration fees for registrations cancelled 7 days or less before the Event must be paid in full. Substitutions are welcome at any time.
All registrations are subject to acceptance by Informa which will be confirmed to you in writing.
Due to unforeseen circumstances, the programme may change and Informa reserves the right to alter the venue and/or speakers or topics.
DELEGATE DETAILS
First Name: Surname: Job Title: Company: Address: Postal Code: Country: City: Tel: Mobile: Fax: Email:
EVENT VENUE:
Sheraton Dubai Mall of the Emirates Hotel, Dubai, UAE Tel: +971 4 377 2000 Dusit Thani Hotel, Dubai, UAE Tel: +971 4 343 3333
ACCOMMODATION DETAILS:
We highly recommend you secure your room reservation at the earliest to avoid last minute inconvenience. You can contact the Informa Hospitality Desk for assistance on: Tel: +971 4 407 2693 Fax: +971 4 407 2517
Email: [email protected]
WEB BC5784/ BC5785/ BC5786
Certificate In Financial Modelling
Using Excel
Course Course Fee Before 2 November 2014
Final Fee Course Fee Before
23 November 2014 Certificate In Financial Modelling
Using Excel (BC5784)
18 - 22 January 2015
US$ 4,495 US$ 4,995 US$ 5,195
Our in-house training division
18 - 22 January 2015, Sheraton Dubai Mall of the Emirates Hotel, Dubai, UAE
10 - 14 May 2015, Dusit Thani Hotel, Dubai, UAE
4 - 8 October 2015, Venue TBC, Dubai, UAE
Course Course Fee Before
22 February 2015 Course Fee Before 15 March 2015 Final Fee Certificate In Financial Modelling
Using Excel (BC5785)
10 - 14 May 2015
US$ 4,495 US$ 4,995 US$ 5,195
Course Course Fee Before 19 July 2015
Final Fee Course Fee Before
9 August 2015 Certificate In Financial Modelling
Using Excel (BC5786)
4 - 8 October 2015
