Course Outline
Advanced Functions
- Logical functions
- Mathematical and statistical functions
- Financial functions
Search and Data
- Search and matching techniques
- MATCH and INDEX functions
- Advanced management of value lists
- Validating values entered in cells
- Database functions
- Summarizing data using histograms
- Circular references: practical considerations
Tables and Pivot Charts
- Dynamic data analysis using PivotTables
- Elements and calculated fields
- Visualizing data with pivot charts
Working with External Data
- Exporting and importing data
- Exporting and importing XML files
- Importing data from databases
- Connecting 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 optimization
- Macros and creating custom functions
- Starting and recording macros
- Working with VBA code
Conditional Formatting
- Advanced conditional formatting using formulas and form elements (e.g., checkboxes)
Time Value of Money
- Present and future value of capital
- Capitalization 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 metrics
- Investing in securities and risk measurement
Requirements
A solid working knowledge of Microsoft Excel is required, and basic familiarity with financial concepts is recommended.
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 3200 € + VAT*
Contact us for an exact quote and to hear our latest promotions
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