Program Overview
This 10-week Financial Modelling in Excel Short Course from City, University of London equips participants with practical skills to build robust financial models for business planning and evaluation. Through a blended format of online modules and live sessions, participants learn best practices, Excel functions, and advanced techniques. Assessment includes coursework assignments and a final project, preparing graduates for careers in financial analysis, investment banking, and more.
Program Outline
Financial Modelling in Excel Short Course - City, University of London
Degree Overview:
Participants will learn best practice design principles and apply a range of financial modelling techniques and functions to construct a detailed financial model case study from scratch.
Key Objectives:
- Understand the principles and techniques of financial modelling.
- Learn to use Microsoft Excel efficiently for financial modelling.
- Develop the ability to build and analyze complex financial models.
- Gain the confidence to apply financial modelling skills in a professional setting.
Outline:
Modules:
- Module 1: Introduction to Financial Modelling
- Introduction to financial modelling concepts and best practices.
- Understanding financial statements and their relationships.
- Introduction to Excel functions and features relevant to financial modelling.
- Module 2: Building Financial Models
- Building basic financial models for different business scenarios.
- Using Excel formulas and functions to perform calculations.
- Creating charts and graphs to visualize financial data.
- Module 3: Advanced Financial Modelling Techniques
- Implementing advanced Excel techniques for complex financial models.
- Performing sensitivity analysis and scenario planning.
- Creating dynamic and interactive models.
- Module 4: Case Study
- Applying the learned skills to build a comprehensive financial model for a real-world business case study.
- Analyzing and interpreting the results of the model.
- Presenting the model and its findings.
Assessment:
Participants will be expected to demonstrate their ability to apply the learned skills and knowledge to solve real-world financial modelling problems.
Teaching:
The teaching methods include lectures, interactive exercises, group discussions, and case studies. Participants will have access to online resources and support throughout the course.
Careers:
Graduates can also use their skills to start their own businesses or pursue further studies in finance.
Other:
Graduates of the course will receive an IFM certificate upon successful completion.
City University of London
Overview:
City, University of London is a public research university located in London, England. It is known for its focus on business, practice, and the professions, offering a wide range of undergraduate and postgraduate programs. The university is renowned for its strong academic reputation and its commitment to providing students with a high-quality learning experience.
Services Offered:
City University of London provides a comprehensive range of services to its students, including:
Library Services:
Access to extensive library resources, including books, journals, databases, and online resources.Moodle:
An online learning platform for accessing course materials, submitting assignments, and communicating with instructors.Email:
A university-provided email account for official communication.Staff Directory:
A searchable directory of staff members and their contact information.Term Dates:
Information on the academic year and term dates.Room Booking:
A system for booking rooms on campus for meetings, events, and other purposes.Schools and Departments:
Information on the various schools and departments within the university.Student Life and Campus Experience:
City University of London offers a vibrant and diverse student experience, with a strong emphasis on:
London Experience:
The university's location in London provides students with access to a wide range of cultural, social, and professional opportunities.Sports:
A variety of sports clubs and facilities are available for students to participate in, both competitively and non-competitively.Social Activities and Groups:
Numerous student societies and groups cater to diverse interests, providing opportunities for social interaction and personal development.Student Wellbeing:
The university offers a range of support services to ensure students' health and wellbeing, including learning support, personal tutoring, and counseling.Career Development:
The university provides career guidance and support services to help students prepare for their future careers.Key Reasons to Study There:
Strong Academic Reputation:
City University of London is consistently ranked highly in national and international rankings.Focus on Business, Practice, and the Professions:
The university's programs are designed to provide students with the skills and knowledge they need to succeed in their chosen careers.Location in London:
The university's location in the heart of London provides students with access to a wealth of opportunities.Vibrant Student Life:
City University of London offers a diverse and engaging student experience.Excellent Career Support:
The university provides comprehensive career guidance and support services.Academic Programs:
City University of London offers a wide range of academic programs across various disciplines, including:
