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
- Searching and matching data
- MATCH and INDEX functions
- Advanced management of value lists
- Validating cell input values
- Database functions
- Summarising data using histograms
- Circular references – practical aspects
Tables and Pivot Charts
- Dynamic data representation using PivotTables
- Items and calculated fields
- Visualising data with PivotCharts
Working with external data
- Importing and exporting data
- Importing and exporting XML files
- Importing data from databases
- Establishing connections to databases or XML files
- Analysing online data – Web Query
Analytical tools
- Goal Seek option
- Analysis ToolPak add-in
- Scenarios and the Scenario Manager
- Solver and data optimisation
- Macros and creating custom functions
- Recording and running macros
- Working with VBA code
Conditional formatting
- Advanced conditional formatting using formulas and form controls (e.g., check boxes)
Time value of money
- Present and future value of capital
- Capitalisation and discounting
- Simple interest calculations
- Nominal and effective interest rates
- Cash flows
- Depreciation
Trends and financial forecasts
- Trend types (functions)
- Forecasting
Securities
- Rate of return
- Profitability
- Investing in securities and risk measurement
Requirements
A solid understanding of Microsoft Excel is required. Basic knowledge of finance is also recommended.
14 Hours
Testimonials (1)
active interaction between trainer and participants