Course Outline
Advanced functions
- The logic functions
- Mathematical and statistical functions
- Financial functions
Search and data
- Search and matching
- Functions MATCH (MATCH) and INDEX (INDEX)
- Advanced management of lists of values
- Validate the value entered in the cell
- Database Functions
- Summary data by using the histogram
- Circular references - Practical Aspects
Tables and Pivot Charts
- The dynamic description of the data using PivotTables
- Elements and calculated fields
- Visualize data using pivot chart
Working with external data
- Exporting and importing data
- Exporting and importing XML file
- Importing data from databases
- Connections to a database or an XML file
- Analyzing data online - Web Query
Analytical issues
- Option Goal Seek
- The Analysis ToolPack addition
- Scenarios, Scenario Manager
- Solver and optimization data
- Macros and create your own functions
- Starting and recording macros
- Working with VBA code
Conditional Formatting
- Advanced conditional formatting using formulas and form elements (eg box - checkbox)
Time value of money
- The current and future value of capital
- Capitalization and discounting
- Interest made simple
- Nominal and effective interest procetowa
- Cash flows
- Depreciation
Trends and financial forecasts
- Types (functions) trend.
- Forecasts
Securities
- The rate of profit
- Profitability
- Investing in securities and risk measures
Requirements
Requires good knowledge of Microsoft Excel. Basic knowledge of finance is also indicated.
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from £3800 online delivery, based on a group of 2 delegates, £1200 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
Testimonials (4)
The trainer did not leave a single minute unexploited! He was up a storm throughout every lesson and provided much material for whatever he dealt with.
Elpida - Unemployed
Course - Anti-Money Laundering (AML) and Combating Terrorist Financing (CTF)
Personal service and orientated to my needs
ANN - New Vitality Clinic
Course - GnuCash for Business Accounting
I was benefit from the interesting and clear ideas and suggestions.
Vincent van Walt
Course - A Practical Guide to Successful Pricing Strategies
Trainer, Richard was very good.