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
- Logical functions
- Mathematical and statistical functions
- Financial functions
Search and Data Management
- Search and matching techniques
- MATCH and INDEX functions
- Advanced management of value lists
- Data validation for cell entries
- Database functions
- Data summarization using histograms
- Circular references - Practical considerations
PivotTables and Pivot Charts
- Dynamic data description using PivotTables
- PivotTable elements and calculated fields
- Data visualization using Pivot Charts
Working with External Data
- Data export and import procedures
- Exporting and importing XML files
- Importing data from databases
- Establishing connections to databases or XML files
- Online data analysis using Web Queries
Analytical Tools
- Goal Seek functionality
- The Analysis ToolPak add-in
- Scenarios and Scenario Manager
- Solver and data optimization
- Macros and custom function creation
- Starting and recording macros
- Working with VBA code
Conditional Formatting
- Advanced conditional formatting using formulas and form controls (e.g., checkboxes)
Time Value of Money
- Present and future value of capital
- Capitalization and discounting
- Simple interest calculations
- Nominal and effective interest rates
- Cash flow analysis
- Depreciation methods
Trends and Financial Forecasts
- Trend types and trend functions
- Forecasting techniques
Securities Analysis
- Rate of return
- Profitability metrics
- Investment in securities and risk measures
Requirements
Requires strong proficiency in Microsoft Excel. Basic knowledge of finance 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