|
|
|
|
| |
Microsoft Excel for the Controlling |
|
| |
| | High demands are made on the controlling with regard to the calculation, preparation and analysis of company figures. These demands are especially dealt with by this training.
It will teach the participants special solutions for Microsoft Excel that are necessary for the field of controlling – among other things, the creation of complex calculations as well as the application of financially mathematical functions are counted among them. In the first instance, the effective analysis of data-base tables according to any criteria will be taught.
The examples used during this training are related to the controlling templates appliedby the Würth Group. That way, the participants have a direct reference to their tasks in the Würth companies.
target group
- Employees from the fields of controlling and finance
- Advanced knowledge of Microsoft Excel is necessary
contents
- Calculations that are necessary for the field of controlling
- Rules for an effective table structure, links, working with named regions, conditional formatting
- Data analysis via database and table functions
- Graphic representation of the results via dynamic charts
- Use of scenarios
Dates
upon request
Seminar language: German (English upon request)
Costs
EUR 300 plus accommodation costs.
>>seminar registration | |
|
|
|
|
