Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Advanced Functions
- Logic functions
- Mathematical and statistical functions
- Financial functions
Search and Data
- Search and matching techniques
- Using MATCH and INDEX functions
- Advanced management of value lists
- Validating cell input values
- Database functions
- Summarising data using histograms
- Circular references – practical considerations
Tables and Pivot Charts
- Dynamically describing data with PivotTables
- PivotTable elements and calculated fields
- Visualising data with pivot charts
Working with External Data
- Exporting and importing data
- Handling XML file imports and exports
- Importing data from databases
- Establishing connections to databases or XML files
- Online data analysis via Web Query
Analytical Tools
- Goal Seek option
- The Analysis ToolPak add-in
- Scenarios and the Scenario Manager
- Solver and data optimisation
- Macros and creating custom functions
- Initiating and recording macros
- Working with VBA code
Conditional Formatting
- Advanced conditional formatting using formulas and form controls (e.g., checkboxes)
Time Value of Money
- Current and future value of capital
- Capitalisation and discounting
- Simple interest
- Nominal and effective interest rates
- Cash flows
- Depreciation
Trends and Financial Forecasts
- Types of trend functions
- Forecasting techniques
Securities
- Profit rates
- Profitability metrics
- Securities investment and risk measurement
Requirements
A solid command of Microsoft Excel is required. A foundational understanding of finance principles is also recommended.
14 Hours
Testimonials (3)
Flexibility in the course delivery and the interactive approach. The trainer was open to questions, clarified doubts clearly and also considered participants suggestions during the sessions. The training was well structured and informative.
Soundarya Mohan - Mizuho Bank Europe N.V.
Course - Financial Analysis in Excel
It's flexible to discuss about what is helpful for our actual work.
Viet Tran Quang - Mizuho Bank Europe N.V.
Course - Financial Analysis in Excel
active interaction between trainer and participants