Freelancer profile translated to English.
Back to original languageAbout Yohann
Hello,
Are you looking for a Microsoft Excel automation or training service.
I am here for you and will respond to all your projects!
Excel VBA Macro Creation Service (to be fast 🚀 and efficient 👌):
After several years of experience in accounting and management in various head offices of large groups (La Fnac, Coopervision, EA Pharma...), I create custom Excel macros for you using the VBA - Visual Basic tool, allowing you to save time, streamline your procedures, and avoid human errors.
This automation can, for example, allow you to combine your Excel sheets between a business software and an ERP, perform statistical calculations, or automatically format your pivot tables or PowerQuery.
I also create custom dashboards and management tools.
Some elements of your procedures may be automated without you even knowing it🙃
Excel Training Service (for the pleasure of learning 🎓 and being autonomous ✊):
Through various Excel support levels (novice, intermediate, and expert), I offer professional and unique Excel training with specializations on your tasks and your profession.
I adapt to you, your work, and your objectives beforehand, to offer you specific, personalized, and therefore more effective training.
Excel service of 14 hours of lessons for approximately €500.
Upon completion of the training, you will gain daily confidence and improve your productivity.
You will also have all the tools to be operational in your current role or for a career change.
I will be there to provide the right explanation and answer your questions on a wide variety of exercises, ranging from simple 5-minute exercises to multi-hour projects.
Exercise solutions will be provided at the end of the courses (Easier to recall your learning 😊)
French
Native or bilingual
Spanish
Conversational
Can work on-site
Villefranche-sur-Mer (up to 50km)
Experience
- LABORATOIRE NHCO NUTRITIONAuxiliary AccountantHEALTH AND WELLNESSMarch 2024 - March 2025 (1 year)Nice, France• Drafting and updating all SAP Finance NHCO procedures• Tax declaration (VAT, Statistical survey, VAT summary ...)• Accounting management, monitoring of company orders by department.• Customer accounting management• Transfer of SAP ECC data to SAP S4/Hana
- EA PHARMAGeneral and Auxiliary AccountantHEALTH AND WELLNESSMarch 2023 - March 2024 (1 year)Mougins, France• Complete management of supplier accounting on SAP for the group's 10 companies• French and Monegasque tax declaration (VAT, DEB, DES, Pharmaceutical Tax...)• Creation of new cost centers and order numbers• Implementation and writing of procedures for new joiners• Complete accounting of inter-company flows (suppliers/customers/current accounts/internal transfers...)• Opaque commission accounting• Balance sheet account review• Review and commissioning of fixed assets• Analysis and allocation of expenses
- CoopervisionAccounting ManagerCONSULTING AND AUDITSMarch 2022 - March 2023 (1 year)Valbonne, France- Automation of closing tasks on Excel- Supplier category comparison- Complete supplier accounting management- Preparation and analysis of closing figures- Comparison of figures with previous periods and static data- Work according to American accounting principles USGAAP
Reviews
K
Kévin
AOCDTF
Reviewed on 4/10/2024
Our first experience with the MALT platform, Yohan's profile perfectly met our expectations.
The result is up to our expectations. He quickly understood and adapted to the problem and delivered quality work on time.
His availability and responsiveness in making modifications as the project progressed were real advantages.
I recommend without reservation.
Thibaud
Thibaud MORTHELIER EI
Reviewed on 2/23/2024
Yohann quickly understood the objective of the mission and proposed solutions while always considering the scalability and ease of use of the file. This point was important to me, thank you very much and see you again for new missions!
Recommendations
Be the first to recommend Yohann
Help this freelancer shine by sharing your experience working together.
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
- Baccalauréat, Finance and Financial Management Serviceslycee Jean-Baptiste Darnet, Saint-Yrieix la Perche (87)2016Baccalauréat, Finance et services de gestion financière
- Higher Technician Certificate (BTS), Accounting and FinanceGroupe IGF2018Brevet de technicien supérieur (BTS), Comptabilité et finance