François Bonnin, High-level Excel-VBA Trainer

Freelancer profile translated to English.

Back to original language

Description

IT engineer career, project manager ... (18 years at Capgemini, Senior Consultant)

Specialized in operational reporting with EXcel, and the construction of Excel-VBA applications

I offer VBA training and tools for:

- Introduction to event-driven programming and VBA Classes

- Mapping a Sheet with a Class independently of column additions

- Building a robust Consolidation application from multiple Excel files

- Automating repetitive tasks

- Directly creating PowerPoint slides

- Automatic reception/sending via Outlook

- etc ...

Development of Excel-VBA applications, fixed-price or on-site missions:

- Simulations

- Complex consolidations

- Interactive data entry

- Linking with Outlook or PowerPoint

Also "classic" Excel upgrades:

- Complex functions: OFFSET, SUMPRODUCT, Goal Seek

- Use of SOLVER (Simplex Method)

- Other functions (on request)

Languages

French
Native or bilingual
English
Fluent

Workplace preferences

Can work on-site

Paris (up to 50km)

Eurocontrol
Consulting in reporting/consolidation processes
AVIATION AND AEROSPACE
October 2019 - January 2022 (2 years and 3 months)
Brétigny-sur-Orge, France

Case study
Advice on data and methods organization
Complex VBA development for
- updating project tracking Excel files (approx. 120), from Database extracts and other data files
- consolidating the same files
Organization VBA Classes Methods Pivots Tables
Capgemini Technical Services
Senior Consultant
DIGITAL AND IT
December 1997 - March 2016 (18 years and 2 months)
Paris, France
Multiple missions internally and with clients: project management, support for project ownership and technical implementation, building reporting systems under Excel-VBA ... etc...
Interpersonal skills management tool creation

Be the first to recommend François

Help this freelancer shine by sharing your experience working together.

A

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

B

Baptiste Duhen

Fullstack developer

4.6

(4)

5

A

Amed Hamou

Senior Lead Developer

4

(2)

7

A

Audrey Champion

Web developer

4.3

(3)

4

Signup to reveal

Other