m
mbilalashiq37

Mohammad Bilal

@mbilalashiq37

Microsoft Excel Specialist for Dashboards, Automation and Data Analysis

Pakistan
Anglais, Ourdou
Certaines informations sont présentées en anglais.
À propos de moi
Hi, I’m Mohammad Bilal, a Microsoft Excel specialist with over 10 years of practical experience in data analysis, reporting, automation and spreadsheet management. I help businesses clean and organize data, fix formulas and lookup errors, create PivotTables, charts, KPI dashboards, custom trackers and professional reports. I also use Power Query and VBA to automate repetitive tasks and improve accuracy. Every workbook is carefully structured, user-friendly and tested before delivery. Send me your Excel file and requirements, and I will recommend the right solution. ... Plus d’infos

Compétences

m
mbilalashiq37
Mohammad Bilal
hors ligne • 
Temps de réponse moyen de 1 heure

Voir mes services

Nettoyage des données
I will clean, format, merge and organize your excel or CSV data
Formules & Macros
I will fix excel formulas, xlookup, vlookup and pivot table errors

Portfolio

Expérience professionnelle

Excel Inventory, Sales and Distribution Coordinator

Private Site • Temps plein

Mar 2015 - Feb 20182 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.