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.