Certificate in Advanced MS Excel
Coupon code: ADVANCEXL | Offer price: 3840/-
- 30 Hours of
Financial Modelling Using Excel Certification Training
CertificationGet an industry-wide recognised certificate in Financial Modelling using Excel from Manipal Prolearn
Enhanced Job OpportunitiesThe scope of financial modelling is on the rise across the world. CA’s/CFA’s can kick-start their career and join the corporate world as an Equity Valuation Associate immediately after completing the financial modelling course.
Who Should AttendMBAs, CFAs, CAs, FRMs, B-Tech and Commerce Graduates
Salary PackagesA fresh graduate having successfully completed the financial modelling course can expect to earn a salary in the range of 3-5 lakhs INR p.a.
Expert FacultyLearn from subject matter experts, course designers and developers who come with a vast experience in financial modelling using excel.
Stay ahead of the curve and jumpstart your career in the field of finance by equipping yourself with the knowledge of financial modelling – one of the most sought-after skills in today’s corporate world. Learn how to determine the financial health of a company and build financial projections using Microsoft Excel with Manipal ProLearn’s Financial Modelling course.
This course helps you to learn financial modelling in all aspects - starting from using basic and advanced Excel to value companies, as well as analysing the Merger & Acquisition (M&A). Designed to help students understand the essence of the subject, it simultaneously teaches you how to use real-world problems to construct consistent and realistic financial models using MS Excel as an analytical tool.
After completing the course in Financial Modelling using Excel, you’ll gain proficient knowledge in financial modelling through an experiential model that incorporates a rich set of examples and industry scenarios. This financial modelling course will help you:
- Perform Basic and Advanced Calculations in MS Excel
- Analyse Companies
- Build Financial Projections-Income Statement, Balance Sheet, Cash Flow Statement
- Perform a Discounted Cash Flow (DCF) & Relative Valuation
- Analyse Mergers & Acquisitions (M&A)
- Analyse and Build Projects Finance Models
- Build M&A models and analyse the transaction
Candidates looking to make a career in equity research, valuation, private equity funds, investment banking or commercial banking, project management etc.
Basic Shortcuts & formulas in Excel (sumif, sumifs, nested if, vlookup, hlookup and many more)
Advanced formulas -Named Ranges, Index Match, Array Functions, Building Scenarios using Offset Functions, Index functions, Usage of Indirect Functions, Usage of Goal Seek and Solver Function
Creating and formatting Basic Charts in Excel
Charting with two axes and chart type
Creating a Dynamic Range Chart
Creating Radar/Spider Charts
Creating Waterfall Charts
Creating a Football Field Chart
Creating Gantt Chart
Building a financial model template
Gathering and organising the historical data
Understanding the Income Statement, Balance Sheet and Cash Flow statement of a company
Calculating Financial ratios
Understanding the Business Model – Identifying key Revenue & Cost Drivers
Forecasting the drivers
Preparing Balance Sheet schedules
Forecasting Profit & Loss Statement
Forecasting Balance Sheet
Linking the Cash Flow Statement
Calculating Cost of Capital [Weighted Average Cost of Capital (WACC), Capital Asset Pricing Model (CAPM)]
Discounted Cash Flow (DCF) Model – Free Cash Flow to Firm (FCFF) v/s Free Cash Flow To Equity (FCFE) model
Performing Sensitivity / Scenario Analysis
Understanding Project Finance
Building the Project Finance Model
What are Mergers & Acquisitions (M&A) and why do companies need M&A
Payment Methods in M&A
Types of offer
Key Inputs into an M&A Analysis
Understanding & analysing accretion & dilution
Analysing the impact of different financing plans
Analysing the impact of different ownership structures
Analysing the impact of Transaction Price and Financing Structure through Sensitivity Analysis
Performing Contribution Analysis
Valuing a transaction
Valuation Analysis with different methods of valuation
Analysing a Company
Gathering Historical Data
Building Business Model and revenue drivers
Calculating WACC (Weighted Average Cost of Capital) Cost of Equity, Terminal Value
Arriving at the value of a Company using DCF and Relative valuation
Doing a sensitivity analysis of your assumptions
During this program, you will learn Financial Modelling techniques like forecasting financial statements, analysing M&A transactions among others.
Always Relevant: This course trains you on expert level of knowledge of MS Excel and creating finance models for many relevant situations that either can pertain to your job or personal life.
Build Projections: With the taught skills, you can build a cash projection for your personal income, a company valuation model to a project finance model.
Increase your Efficiency: You can create wonderful analysis using great visuals including charts and graphs, and give better business insights to your company. This will help you be more effective in your job.
Job Search: You can showcase your Financial Modelling skills on your resume and grab coveted job positions.
No, this course is available only through online mode of study. This mode of learning allows you to study anytime and from anywhere, based on your convenience. We also provide 365 days access to all course materials. You can download them and refresh what you learnt whenever you need it.
Currently, we provide one case study from each sector, viz retail, healthcare etc.
We provide 30 hours of video assistance to the learners. These recorded videos include every aspect of the course and cover them in minute details to ensure an in-depth understanding of the topics. You will also get contact details of faculty whom you can reach out in case of any confusion.
Yes, we do.
As soon you pay for the course, you will be provided with a login and password to access EDUNXT.MANIPALPROLEARN.COM. You can find all the information and study material related to your course on the EDUNXT.MANIPALPROLEARN.COM platform. You can access this platform 24x7, download PDF files of study material and chat with faculty, when in doubt.
You can pay through your debit card or net banking in one shot. You can also pay by Credit Card from all the leading banks. EMI Option can be availed when using a credit card (interest will have to be borne by you).
In case, there is something more that you want to know, then please do call us at our toll-free number 1800-103-5941 or drop us a mail at email@example.com