|
|
Overview
Many companies have made a major investment in Excel spreadsheets to support their business. However, few organisations realise the potential for improved efficiency and effectiveness that can be realised by programming with Excel and Visual Basic for Applications (VBA). This combination allows for the development of custom spreadsheet applications, which can extend the functionality o... |
| Course type: |
Full Time delivered as classroom based |
| Guide price: |
£1650.00 |
|
|
|
|
Overview
In this course, you will work with the new and enhanced features in Microsoft Office Excel 2007, improving the management, presentation, and distribution of your spreadsheets.
This training may be available onsite; please contact us if you are interested.... |
| Course type: |
Full Time delivered as classroom based |
| Guide price: |
£235.00 |
|
|
|
|
Overview
Improve your valuation modelling skills in project financing, international corporate structuring and M&A, and achieve an optimal decision-making process
Course Highlights
How to design a model to suit your purpose
Valuation modelling using conventional and new approaches
Accurate forecasting corporate cash flows for projec... |
| Course type: |
Full Time delivered as classroom based |
| Guide price: |
£799.00 |
|
|
|
|
Overview
The practical aspect of the course revolves around the building of a cashflow and financial statement forecast of a company, ensuring that all the drivers are appropriate, that the modelling logic and the accounting treatments are sound and that modelling best practice is applied. This first stage of the course also deals with the issues of multiple currencies, high inflation, tax and ... |
| Course type: |
Full Time delivered as classroom based |
| Guide price: |
£2299.00 |
|
|
|
|
Overview
The widespread availability of computer spreadsheets has revolutionised budgeting, forecasting and planning. In the past, financial modelling was something done exclusively by accountants and as a result they had almost total control of financial information. Nowadays, many managers are expected to have a much closer control and understanding of the financial performance of their team.... |
| Course type: |
Full Time delivered as classroom based |
| Guide price: |
£900.00 |
|
|
|
|
Overview
This class is designed for delegates who want to become acquainted with VBA concepts, record, edit and assign procedures to menus and objects, use function procedures, objects, properties, methods and interactive procedures, control and automate procedures, customise menus and command bars and create user forms.
This training may be available onsite; please contact us if you are... |
| Course type: |
Full Time delivered as classroom based |
| Guide price: |
£445.00 |
|
|
|
|
Overview
This class is designed to help delegates describe the concepts in and uses of Visual Basic for Applications, record and edit procedures, debug visual basic code, assign procedures to menus, objects, and keyboard shortcuts, use function procedures and objects properties and methods. In addition, delegates will learn to use interactive procedures, control procedures, automate procedures,... |
| Course type: |
Full Time delivered as classroom based |
| Guide price: |
£445.00 |
|
|
|
|
Overview
In the previous Excel courses, you used Excel to simplify business tasks, including the creation of spreadsheets, graphs, charts, and formulas that were difficult to create and nearly impossible to maintain using pencil and paper. You now want to simplify your work in the Excel environment by automating many of the repetitive tasks that are part of spreadsheet development.
In Ex... |
| Course type: |
Full Time delivered as classroom based |
| Guide price: |
£550.00 |
|
|
|
|
Overview
You are a relatively proficient user of Microsoft Office Excel 2007, and you now wish to take advantage of the advanced features and techniques used in Microsoft Office Excel 2007. Excel has many tools and functions that help you in analyzing varied data to make decisions having large scale implications on profitability, be it in the domain of sales, project management, credit, equitie... |
| Course type: |
Full Time delivered as classroom based |
| Guide price: |
£235.00 |
|
|
|
|
Overview
Our Excel VBA course help you create automated spreadheets for all those repetitive tasks. VBA can also help to simply complex tasks that needs to be performed on a reqular basis. At the end of the course, users will be able to record and run macros, edit the VBA code, build in loopings structures and create custom forms.
This training may be available onsite; please contact us ... |
| Course type: |
Full Time delivered as classroom based |
| Guide price: |
£550.00 |
|
|