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.
Duration 14 hours
Course Outline
Advanced Capabilities
- Logical operations and functions
- Mathematical and statistical analysis tools
- Financial calculation functions
Search and Data Management
- Data retrieval and matching techniques
- Utilization of MATCH and INDEX functions
- Sophisticated management of value lists
- Cell input validation protocols
- Database-specific functions
- Data summarization via histograms
- Practical considerations regarding circular references
Tables and Pivot Charts
- Dynamic data description using PivotTables
- Configuration of elements and calculated fields
- Data visualization through pivot charts
Working with External Data
- Data export and import procedures
- Handling of XML file exports and imports
- Importing data from database sources
- Establishing connections to databases or XML files
- Online data analysis via Web Query
Analytical Methodologies
- Application of the Goal Seek option
- Integration of the Analysis ToolPak
- Scenario creation and management
- Data optimization using Solver
- Macro creation and custom function development
- Initiation and recording of macros
- Utilization of VBA code
Conditional Formatting
- Advanced conditional formatting utilizing formulas and form controls (e.g., checkboxes)
Time Value of Money
- Calculation of current and future capital values
- Processes of capitalization and discounting
- Simple interest calculations
- Comparison of nominal and effective interest rates
- Analysis of cash flows
- Depreciation methods
Trends and Financial Forecasts
- Identification and application of trend functions
- Financial forecasting techniques
Securities Analysis
- Determination of profit rates
- Assessment of profitability
- Investment analysis and risk measurement for securities
Requirements
Proficiency in Microsoft Excel is required. Foundational knowledge of finance is also recommended.
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