Refine Your Search
...
...
3 Reviews
Learn advanced Excel techniques to boost your efficiency at work!
3 Reviews
This program aims to enhance advanced skills in using Microsoft Excel to meet the demands of the financial sector. The program provides advanced tools to design and analyze financial models effectively, and applied exercises that help participants utilize Excel equations and functions for data analysis and financial modeling. It also allows participants to apply multiple scenarios for improved financial decision-making.
Banking
Capital Market
Insurance
Financing
Artificial Intelligence and Data Management
Not Exist
Lecture
Practical Implementation +1
Lecture
Practical Implementation
Exercises and assignments
Pre Exam
Post Exam
Purchase Program
( 0)Available
To preview individual and groups discount policy, Click Here
This provides you with the opportunity to select the available times that suit you best for participation in our program. These times represent slots during which we are ready to welcome you and provide assistance and guidance.
In Class Training-Online Training
Cell styles
Pasting values, formulas, and formats with Paste Special
Formatting Cells
Highlight key data with Excel Conditional Formatting
Filter by color
Recording Macros - The perfect way to avoid repetitions
In Class Training-Online Training
The secret of fast scrolling: navigation and keyboard shortcuts
Fix the top row of your Excel tables
Split Screens - Use multiple screens simultaneously
Excel formulas
Creating drop-down menus in Excel
F keys (F1 to F12) - Using Excel's function keys
How to select visible cells only
In Class Training-Online Training
Fixing cell references properly
Grouping Excel rows and columns
Working on multiple sheets at the same time
Find
Create easily printable documents by using Set Print Area
What Are Circular References in Excel?
Trace precedents - Display the relationship between formulas and cells
In Class Training-Online Training
Nested function
Sum; Sumif; Sumifs
Round functions
Iferror
Vlookup
Index; Match; Index
Offset; Offset
Financial functions: FV and PV
Discounting Cash flows and calculating Net Present Value (NPV)
Financial functions: IRR
Financial functions: PMT and building a complete loan schedule
Date functions
In Class Training-Online Training
Excel tips
In Class Training-Online Training
Financial modeling Don'ts - Worst practices we should avoid
Financial modeling Do's - This is what solid modelers do
The different types of models
What is the right level of detail in a financial model?
In Class Training-Online Training
Forecasting guidelines: apply these principles when forecasting financials
How to build a complete model?
Forecasting Income statement financials
Forecasting Balance sheet financials
In Class Training-Online Training
Create a mapping of financials
Building an output P
Filling in the output P
Calculating percentage variances and applying conditional formatting
Building an output Balance sheet
Adding the forecast period
In Class Training-Online Training
Calculating historical percentage ratios and use Index and Match for scenarios
Building a flexible model with Vlookup
Calculating historical DSO, DPO, DIO, Other assets %, and Other liabilities %
Building a Fixed asset roll forward
Building a Financial liabilities schedule
Building an Equity schedule
Preparing a Cash flow structure
Calculating Cash flows and completing the model
Basic knowledge of Microsoft Excel.
r finance (for those without a financial or accounting background).
Access to a computer for practical application.
