A highly practical, hands-on course designed to allow participants to expand the functionality of spreadsheets and learn how to build financial models in Excel.
The ‘Financial Modeling using Excel’ seminar will take concepts and issues introduced in the core finance and financial accounting courses and introduce participants to the practical application of financial modeling using Excel. Seminar participants will be required to build robust and reliable model for a particular decisions while they will refresh basic and more advanced finance topics like time value of money, capital budgeting (discount cash flows analysis, weighted average cost of capital – WACC etc) and portfolio management topics.
Seminar Objectives
As a result of taking this seminar, you should be able to:
1. Learn important Excel functions and understand which formulas are needed in different cases.
2. Overview financial models and document model assumptions
3. Learn to use Excel for sensitivity analysis and scenarios
4. Get familiar with key features of good model design
5. Master several excel shortcuts to speed up data analysis
6. Create dynamic charts and present data effectively.
Contact us today to learn about the schedule and available offers for this seminar.
Prerequisites
The seminar is designed for users who use Excel from time to time and want to take their skills to the next level. It is assumed that participants have a basic knowledge of the core functionalities of Excel and are in position to easily navigate within the spreadsheet, create and use simple formulas and link between workbooks.
Seminar Instructor: Mr. Dimitris Leimonis
Application – Software Used
Participants are required to bring their own laptops and have installed Excel 2010 or later (ideally 2013 or 2016), Word, Adobe Acrobat Reader and PowerPoint. Mac users need Excel 2011 for the spreadsheet part and can use the respective applications for opening word documents, presentations and pdf files, although we would suggest them to work with the Windows version of Excel (via Parallels Desktop, Boot Camp, VMware Fusion or other similar applications).
Who Should Attend
Financial Analysts, Accountants, Finance Managers, Consultants, Valuation & Budgeting Professionals, Investors, Business Students wishing to develop modeling skills.
Locations / Venues
Our courses are held in centrally located hotels. Registration fees include morning cofee/tea and refreshments and a lunch break . Detailed venue descriptions, times and logistics are included in the material we send after your register for the course.
Contact us today to learn more about the next “Financial Modeling” (seminar schedule, detailed brochure and available offers for this seminar)
Leave a Reply