Portfolio of projects developed in Microsoft Excel throughout my career. The tools presented have solved real problems in many fields, such as logistics, sales and education.
The tools displayed on this website do not contain any sensitive information from clients.
Sales Dasboard: constructed from daily revenue records, provides a comprehensive visualization of the company’s sales performance. It generates insightful charts that not only track revenue trends over time but also spotlight the annual performance of each salesperson.
Process Automation (Filter and Extract): Developed to automate tasks by locating the desired file and table, filtering attributes according to column names and returning the product ID. This tool facilitates repetitive tasks, especially when applying multiple filters and performing numerous copy-paste operations.
Email Automation with VBA: to automate the creation of invoices using in Excel. Extracting data, generating formatted PDFs, and sending emails with a single click. Perfect for streamlining your invoicing process and saving time.
Fueling Control: is a system developed with macros and a dashboard to facilitate data entry and editing, as well as data visualization for fuel management of a generic logistics and transportation company.
Units Extraction: from a custom VBA function leveraging advanced regex principles to streamline the extraction of measurement units from text in Excel. In the example, we have the product description and we can extract the desired product attributes, distributing them to the correct columns.
Verbs Battleship Game: La Bataille Navale des Verbes is a game that combines the fun of traditional battleship with the learning of French verb conjugation. Each player must try to find and attack the opponent's ship by correctly conjugating French verbs.
