m
mbilalashiq37

Mohammad Bilal

@mbilalashiq37

Excel VBA Automation and Reporting Specialist

Pakistan
Inglese, Urdu
Alcune informazioni sono riportate in lingua inglese.
Chi sono
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.... Continua a leggere

Competenze

m
mbilalashiq37
Mohammad Bilal
offline • 

Consulta i miei servizi

Pulizia dei dati
I will clean and merge excel CSV data using power query
Formule e macro
I will fix excel formulas, xlookup, vlookup and pivot table errors

Portfolio

Esperienza lavorativa

Excel Inventory, Sales and Distribution Coordinator

Private Site • Full time

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.