You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Mathis P.MP

Mathis P.

Expert Excel & VBA Developer

€275/day
4 projects
Besançon, FR
3-7 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Mathis

This marks the end of your hours lost on repetitive tasks with no real added value.

It's time to update those dusty files that have been passed down through your departments since the dawn of time.

Today, your Excel files can do so much more than you can imagine. Let's explore what we can improve together:

🔼Automation of your repetitive tasks:These dozens of hours spent manually retrieving information from your 1782 prospects could perhaps be better used elsewhere...

🔼Creation of new high-performance management tools:If only these quotes could be calculated, generated, named, and filed correctly with a single click... 🤔

🔼Complete audit of your tools and their operation:The possibilities for optimizing your internal processes are endless. Let me identify the areas for improvement that would give you the greatest time savings.

🔼Optimization of your existing files and tools:This convoluted system you inherited when you arrived at your position could be much simpler to use. And yes, that little detail you manually handle every time will be corrected. 😌

🔼Implementation of dashboards grouping your KPIs:Charts, tables, and important information from all your files on a single dashboard. Why spend 3 hours preparing for your meeting?

Your needs are not the same as they were yesterday. Ensure you always have the right tools.

How will our collaboration unfold?

⬅️ Before:
  • Let's define your needs together and the project timeline.
☑️ During:
  • Continuous contact and feedback.
  • Suggestions for improvements as the project progresses.
➡️ After:
  • Delivery of a complete user guide.
  • Free corrective maintenance for 3 months.
  • A guaranteed future-proof result!
  • French

    Native or bilingual

  • English

    Fluent

Can work on-site
Besançon (up to 50km), Dijon (up to 50km), Pontarlier (up to 50km)

Experience

  • Numerica
    Excel, VBA, Python and Office Suite Training
    EDUCATION AND E-LEARNING
    November 2024 - Today (1 year and 7 months)
    Montbéliard, France
    Intervention as a trainer in various fields:
    • Excel, beginner to advanced.
    VBA, beginner to advanced.
    Python, beginner to advanced.
    Office Suite, beginner to advanced.
    On-site training, in-company or at the Montbéliard premises.
    Microsoft Excel Microsoft Office Python Programming VBA Programming Training
  • GMS Decisionnel
    Data Visualization, Task Automation, New Tool Development, Excel Expertise
    DIGITAL AND IT
    June 2024 - April 2025 (10 months)
    General Context
    • Execution of VBA development and Excel automation projects, with end clients being large companies (members of major national and international groups).
    • Diverse projects ranging from small one-off interventions to complex developments requiring several months of work.
    • Work performed exclusively remotely, with respect for deadlines and consistent client satisfaction.

    Types of Interventions Performed

    Maintenance and evolution of existing tools :
    • Bug fixing and VBA code optimization.
    • Addition of new functionalities according to business needs.
    • Integration of new data sources and updating tools to meet evolving client processes.
    Creation of new custom tools :
    • Development of automated reporting tools enabling the generation of dynamic dashboards and summaries from large volumes of data.
    • Design of decision-support solutions for sales teams.
    • Automation of manual tasks in Excel to improve productivity and reduce error risks.

    Application Areas
    • Data visualization: dynamic dashboards, key performance indicators (KPIs), interactive reports.
    • Process automation: elimination of repetitive manual tasks, acceleration of workflows.
    • Data processing and presentation: summarizing and presenting source data in a usable and understandable format.

    Point of Importance
    • Respect for deadlines, regardless of the project's size or complexity.
    • Availability and adaptability to the specific needs of projects and clients.
    • Contributions providing significant gains in terms of time, data reliability, and decision-making.
    • Developments carried out in compliance with confidentiality and the expectations of end clients.
    VBA VBA Programming Microsoft Excel Power Query Adaptability and Flexibility
  • Tony Electricité
    Data retrieval from a private API, processing, data visualization, and automatic summary generation
    ENERGY AND UTILITIES
    April 2024 - April 2024 (1 month)
    Creation of a program to import data from the API of an intervention management software.
    Data processing, summarization, and display.
    Automatic calculation of amounts related to different services.
    Automatic creation of summaries.
    Comparison of summaries and employer data to detect anomalies.
    Excel VBA Macro Data Visualization Web API Data Processing Microsoft Excel

Reviews

5.0

Out of 2 ratings

C

Camille

GINTO Hotel

Reviewed on 3/18/2024

Mathis perfectly fulfilled the mission entrusted to him. Communication was fluid and efficient, and the timeline was respected. He took the time at the beginning of the mission to analyze and understand the need to build the best solution. I recommend Mathis 100% and would use him again if needed!
A

Arnaud

Lovatech NV

Reviewed on 2/19/2024

We needed help reformatting an export we had done in Excel. I had spent hours on it without finding a solution, so I decided to call on the Malt platform. Mathis offered to take on this task. We had a first call to meet and discuss our expectations. The call went very well, Mathis is polite and very kind. He then completed the task within the day. We are very satisfied with Mathis's approach and will not hesitate to use his services again.

Recommendations

Be the first to recommend Mathis

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • DU SNEE
    Pepite BFC
    2022
  • Master Marketing and International Management
    IAE
    2021

Skill set

Categories