Freelancer profile translated to English.

Description

My name is Nicolas Anselmetto, a freelancer specializing in Excel automation, VBA, Power BI, and financial reporting.

I help companies, VSEs/SMEs, freelancers, and financial teams who want to save time, make their files reliable, and better leverage their data.

I primarily work on:

Creating custom VBA macros;
Automating repetitive Excel files;
Transforming raw exports into clean, usable files;
Preparing files for accounting or financial import;
Creating Power BI dashboards;
Implementing financial, commercial, or operational reporting;
Cleaning, structuring, and analyzing data.

My experience has allowed me to work on concrete cases: sales export automation, creation of ready-to-import files, cleaning of accounting data, analysis of general ledgers, monitoring of revenue, monthly income statements, and Power BI dashboards.

My goal is simple: to transform complex, time-consuming, or error-prone files into clear, automated, and easy-to-use tools for daily use.

Would you like to automate your files, structure your data, or create a clear dashboard to manage your business? Let's talk.

Languages

French
Native or bilingual
English
Conversational

Workplace preferences

Remote only

Primarily works remotely

Groupe Conseils
Consultant VBA & Power BI - Accounting Automation and Financial Reporting
April 2026 - July 2026 (3 months)
Paris, France
Excel / VBA Automation:
Creation of custom macros to automate repetitive tasks: data cleaning, reformatting, export reprocessing, final file generation, action buttons, reset macros, and export macros.

Data Cleaning and Structuring
Transformation of raw files into clean, reliable, and usable files: error removal, format harmonization, creation of useful columns, preparation for analysis or import.

Preparation of Accounting Imports
Creation of structured files to facilitate import into accounting tools like Pennylane: sales exports, entries, import formats, consistency checks.

Financial Reporting and Power BI
Creation of dashboards to track key indicators: revenue, expenses, profit, profitability, monthly trends, analysis by period or by client.

Accounting and Financial Analysis
Analysis of accounting files, general ledgers, income statements, journals, unposted entries, and analytical data to identify points of attention and produce a clear summary.
Microsoft Power BI Power Query VBA Excel VBA Macro Automation
ESSCA JUNIOR CONSEIL,
Business Development Project Manager
October 2024 - Today (1 year and 10 months)
Paris, France
In-depth analysis of client needs to propose high-value recommendations.
Design and management of market, satisfaction, and strategic positioning studies.
Implementation, monitoring, and interpretation of KPIs to evaluate the performance of commercial and operational actions.
Active contribution to prospecting strategy: targeting new segments, developing outreach messages.
Client relationship management: developing sustainable partnerships through personalized support and proactive communication.
Prospecting Performance-oriented analytical mindset Sales proposal Response to tenders
NICOLAS,
Oenology Sales Representative
WINE AND SPIRITS
October 2024 - November 2024 (1 month)
Paris, France
Organization and hosting of tastings in 18 points of sale to enhance the visibility of 7 selected references.
Collection and analysis of field feedback through the administration of targeted questionnaires to wine merchants.
Gathering qualitative insights through structured active listening.
Sales pitch Rigor and organization