m
mbilalashiq37

Mohammad Bilal

@mbilalashiq37

Excel VBA Automation and Reporting Specialist

Pakistán
Inglés, Urdu
Parte de la información aparece en idioma inglés.
Sobre mí
I help businesses turn repetitive spreadsheet work into clear, reusable Excel workflows. With 8+ years in data operations and 3 years in accounts and distribution support, I work with VBA macros, Power Query, Power Pivot, data cleaning, reconciliation and automated reports. I can build practical expense and inventory trackers, consolidate multiple sheets and generate Excel, Word or PDF reports. Expect a clearly defined scope, careful testing and simple instructions. Tell me what you do manually and what you want the finished workbook to do.... Lee más

Habilidades

m
mbilalashiq37
Mohammad Bilal
desconectado • 

Revisa mis servicios

Limpieza de datos
I will clean and merge excel CSV data using power query
DeUSD 15 / proyectoMás información
Fórmulas y macros
I will fix excel formulas, xlookup, vlookup and pivot table errors
DeUSD 5 / proyectoMás información

Porfolio

Experiencia laboral

Excel Inventory, Sales and Distribution Coordinator

Private Site • Tiempo completo

Mar 2015 - Feb 2018 • 2 yrs 11 mos

Managed day-to-day inventory, sales and distribution operations through an Excel-based reporting system. My responsibilities included entering incoming stock, recording orders received from order bookers, preparing printed order sheets for salesmen, issuing stock, recording returned stock and updating completed sales. I also received and reconciled cash collected by salesmen, maintained stock and sales records, monitored returns and prepared daily and periodic reports for management. This role developed my practical experience in inventory tracking, sales reporting, cash reconciliation, data entry, record management and automated Excel-based business reporting.