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
Lookup and Data
- Lookup and matching
- MATCH and INDEX functions
- Advanced management of value lists
- Validating cell input
- Database functions
- Summarizing data using histograms
- Circular references - Practical Aspects
Tables and Pivot Charts
- Dynamic data analysis using PivotTables
- PivotTable fields and calculated fields
- Data visualization using PivotCharts
Working with External Data
- Data import and export
- Importing and exporting XML files
- Importing data from databases
- Connections to databases or XML files
- Online data analysis - Web Query
Analytical Tools
- Goal Seek feature
- Analysis ToolPak add-in
- Scenarios and Scenario Manager
- Solver and data optimization
- Macros and custom function creation
- Recording and starting 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
- Compounding and discounting
- Simple interest
- Nominal and effective interest rates
- Cash flows
- Depreciation
Trends and Financial Forecasts
- Trend types and functions
- Forecasting techniques
Securities
- Rate of return
- Profitability
- Investing in securities and risk assessment
Requirements
Proficiency in Microsoft Excel is required. A basic understanding 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