21 EUR /h
The objectives of the training
- Acquire an efficient and judicious use of Excel,
- Save time in the construction and presentation of his paintings,
- Use and analyze a list of data,
- Reliable calculations and analyzes.
The training program
- Most commonly used advanced Excel formulas (if - sum - searchv - sum.si.ens - Indirect ...)
- Processing of a database
- Set up pivot tables
- Implementation of reporting and dashboard
- Budget monitoring
- Charts on Excel,
- Excel macro
- Power Query
- Vba Excel
The program can be adapted according to the level of the apprentice and his requirements.
- Acquire an efficient and judicious use of Excel,
- Save time in the construction and presentation of his paintings,
- Use and analyze a list of data,
- Reliable calculations and analyzes.
The training program
- Most commonly used advanced Excel formulas (if - sum - searchv - sum.si.ens - Indirect ...)
- Processing of a database
- Set up pivot tables
- Implementation of reporting and dashboard
- Budget monitoring
- Charts on Excel,
- Excel macro
- Power Query
- Vba Excel
The program can be adapted according to the level of the apprentice and his requirements.