Data Analyst | Excel VBA Specialist | Freelancing
Shirin Meggendorfer
0
Financial Analyst
Data Analyst
Excel VBA
Microsoft Excel
🚀 Optimization of data processing in Supply Chain Management by integrating multiple Excel sheets into an automated master sheet.
🚀 Analysis and identification of relevant data points from existing Excel sheets, including inventory management, supplier data, and sales forecasts.
🚀 Utilization of Power Query to merge and transform this data into a central master sheet.
🚀Automation: Development of a macro for automatic data updates to ensure all information is current and accurate.
🚀 Conducting tests to ensure data integrity and adjusting the solution based on test results.
Like this project
0
Posted Sep 7, 2024
🚀 Optimized Supply Chain Management by automating data integration from Excel sheets into a master sheet using Power Query and macros for real-time updates.
Likes
0
Views
3
Tags
Financial Analyst
Data Analyst
Excel VBA
Microsoft Excel
Shirin Meggendorfer
Empowering finance through data mastery 🚀
Finance Specialist | Excel VBA Specialist
Data Analyst | Excel VBA Specialist |
Accountant | Freelancing