Freelancer profile translated to English.
Back to original languageAbout Yohan
Excel & Google Sheets Automation | Power Query | Reporting & Dashboards
I help professionals, freelancers, and small businesses tomaketheirExceland GoogleSheetsfilesreliableand **automated**: **data cleaning**, consolidation of multiple sources, implementation of dashboards and recurring reporting.
I mainly work with Excel (Power Query, formulas, PivotTables) and use VBA when relevant (automations, controls, data entry simplification). My approach is pragmatic: I start with your business needs, I quickly propose a first usable version, then I improve it iteratively until I obtain a **stable**, clear, and easy-to-maintain tool.
I have acquired a rigorous work method in companies and consulting contexts, and I apply it today as a freelancer: short framing, clean deliverables, documentation, and handover so that you are **autonomous**. I also offer Excel/Power Query **training**, focused on concrete cases and the participants' actual level.
Examples of deliverables:
- Automated monthly reporting file (1-click update)
- Consolidation of several exports + quality checks
- KPI Dashboard (sales, finance, activity tracking)
- Cleanup of an existing file (structure, performance, reliability)
- Excel/Power Query training on your data
French
Native or bilingual
English
Fluent
Spanish
Basic
Can work on-site
Biarritz (up to 50km), Paris (up to 50km), Bordeaux (up to 20km), Niort (up to 20km)
Experience
- Paulerena
On Malt
Development of an advanced Excel tool for optimizing sports performance trackingSPORTSMarch 2025 - March 2025Bayonne, FranceDesign and implementation of a tailor-made Excel solution for high-level athlete tracking:- Creation of an intuitive tab for entering individual athlete data, ensuring smooth and organized collection.- Development of an innovative summary tab, automatically consolidating athlete data for quick and strategic analysis.- Creation of a sophisticated pivot table, offering dynamic and personalized performance visualization, facilitating coaches' decisions.- Automation via a powerful macro, allowing centralized and efficient management of all athletes in one click.This solution has improved tracking accuracy, saved valuable time, and strengthened decision-making through a professional and impactful interface. - ART DU YOGA NCExcel ExpertSPORTSJanuary 2025 - February 2025Anglet, FranceAnalysis of the existing file and data reorganization: Optimization of data entry and structuring to facilitate analysis.Automation of calculations: Implementation of appropriate formulas to ensure reliable results.Improvement of visualization: Addition of dashboards and dynamic charts for clear performance tracking.
- Yohan PhilibertExcel Expert ConsultantCONSULTING AND AUDITSSeptember 2024 - Today (1 year and 9 months)Anglet, FranceExcel Expert Consultant, I assist companies in automating and analyzing their data. I optimize files and processes to save you time and improve your decision-making.Thanks to advanced mastery of Excel (complex formulas, VBA macros, Power Query), I structure your databases, automate your calculations, and design user-friendly tools tailored to your needs.
Reviews
D
Donuts
Tableau de rentabilité - C'est mon Donuts
Reviewed on 4/5/2026
Great work by Yohan
Allan
KAIYO MEDIA
Reviewed on 7/23/2025
Yohan was very responsive and provided me with a ready-to-use Excel file, exactly what I needed. I highly recommend working with Yohan to anyone looking for a professional freelancer.
Recommendations
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Master of Actuarial ScienceEURIA20153 années de licence en Maths appliquées suivies de 2 années de Master en actuariat. Principales matières : statistiques, programmation, comptabilité, économie et droit, mathématiques financières et actuarielles, finance, gestion des risques... Formation reconnue par l’Institut des Actuaires.