m
mbilalashiq37

Mohammad Bilal

@mbilalashiq37

Microsoft Excel Specialist for Dashboards, Automation and Data Analysis

Pakistan
English, Urdu
About me
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. ... Read more

Skills

m
mbilalashiq37
Mohammad Bilal
Offline • 
Average response time: 1 hour

See my services

Data Cleaning
I will clean, format, merge and organize your excel or CSV data
From$15 / projectMore details
Formulas & Macros
I will fix excel formulas, xlookup, vlookup and pivot table errors
From$15 / projectMore details

Portfolio

Work experience

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.