Freelancer profile translated to English.
Back to original languageAbout Maxime
I offer my experience to help you create or improve your work tools based on Excel.
You can save time and increase efficiency by using advanced functions that you may not know, optimizing your formulas, automating certain tasks, etc...
Every problem has a solution, contact me to find it.
English
Fluent
French
Native or bilingual
Can work on-site
Sens (up to 50km), Troyes (up to 75km), Paris (up to 75km)
Experience
- WIPPLE
On Malt
File for the creation and quick formatting of quotesApril 2022 - July 2022 (4 months)Sens, FranceConsolidation of supplier catalogs into a single harmonized catalog.
Saving source files in one or more folders.Possibility to automatically modify information from the catalog.Creation of a quote entry sheet with, in particular:
Reference search assistance (filters for dropdown lists by reference and/or supplier and/or description).Add a reference or a kit by double-clicking. If an item in the Kit is modified, the reference and description of the kit disappear.Possibility to modify quantities, references, descriptions, line order, line status.Possibility to duplicate a room.Calculation of maintenance and service costs according to different packages.
Possibility to modify the default rate.Generation of a global summary and by quoted room.
In a new file or in a separate tab depending on the chosen export.Presence of hyperlinks to access room details.Possibility to modify quantities in the export to simulate modifications.Creation of a settings tab
for catalog maintenance, setting up export save foldersto manage items to be included by default when creating a room - GROUPE CHALLANCINCreation and editing of schedulesMarch 2022 - March 2022Sens, FranceUse of Power Query (free Excel add-in available in Excel 2016 or later versions)Creation of a settings tab (data related to rooms, times, start times per staff)Creation of a Staff/Room allocation tab: in a table by date, assignment of staff to rooms, dropdown lists and conditional formatting to facilitate data entry.Calculation of hours in the same tab.Update of individual staff sheets and the summary schedule with a simple right-click (or Data\Refresh All)Display of staff sheets via a pivot table.Export of all staff sheets to PDF in a folder (defined in the settings tab)
- TRACIFY SASImprovement of an existing Excel file using Power QueryJanuary 2022 - February 2022Sens, FranceExisting data:- 1 existing table reading clients / date of first deal / number of potential deals.New data:- 1 table detailing the % of deals obtained per month (example: 1st month 5%, 2nd month: 10%, 3rd month: 12% etc...)Based on this data:>> generation of a new table listing by date and by client the number of forecast deals.>> insertion of this table into the file without modifying the structure despite the large number of formulas and tables.>> adaptation of several tables and formulas to take into account the newly calculated data.>> simple refresh (Data\Refresh All)
Reviews
Vincent
Tamiade
Reviewed on 12/20/2022
Very professional, fast, and good communication. The result is there.
Nastassia
WIPPLE
Reviewed on 8/3/2022
We highly recommend Maxime.
We worked with him to create a custom quote generator. With a large, regularly updated database.
We also asked Maxime to work on custom PDF exports with specific layouts.
In short, he is good, friendly, and has very good ideas.
He always adapted to our ideas.
Thank you Maxime!
Recommendations
Be the first to recommend Maxime
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
- Industrial Systems EngineerTroyes University of Technology2012Filière : Logistique Interne et Production Matières étudiées : Planification et ordonnancement, Gestion des stocks, Amélioration continue, Management de la Qualité, Recherche opérationnelle. (autant de matières où l'utilisation de l'informatique, notamment Excel, est vitale !)