EXPLORE

Automation Data Analysis Data Analytics Data Entry Excel
Profile cover photo
User Avatar

Muhammad Abdullah L.

@AbdullahLasharii

monthly-level-two.svgverified-v2.svgpreferred-freelancer-v3.svg
5.0
7

3.3

3.3

100%

MS Excel | Automation Expert | Data Analyst | CA |

$5 USD / Hour

Flag of

Pakistan (1:01 AM)

Joined on November 22, 2024

$5 USD / Hour

✍ CHARTERED ACCOUNTANCY (ICAP): As a sophomore at the Institute of Chartered Accountancy of Pakistan (ICAP), I specialize in financial analysis, tax strategy, and compliance solutions, tailored to enhance business performance and ensure regulatory compliance. ✍ ADS (PUNJAB UNIVERSITY): Pursuing a degree with subjects like Computer Science, Statistics, and Economics, focusing on integrating analytical skills and computational expertise to provide data-driven insights and solutions for technology and business analytics. ✅EXCEL EXPERTISE ➤Formulas: - Expert in advanced formulas: SUMIFS, COUNTIFS, VLOOKUP, INDEX-MATCH, ARRAY FORMULAS, etc. - Skilled in dynamic, nested formulas and robust error handling. ➤Conditional Formatting: - Create custom rules to highlight trends with color scales, data bars, and icons. - Develop dynamic criteria-based rules and integrate formatting with charts. ➤Data Validation: -Ensure data integrity with custom rules and dynamic drop-down lists. -Design error prompts for guided, accurate entries. ➤Dynamic Charts: -Build auto-updating charts and advanced types like Ternary and combo charts. -Create interactive dashboards with slicers and buttons. ➤Excel VBA: -Automate workflows, create advanced solutions, and design interactive VBA forms. ✅ DATA ANALYSIS EXPERTISE: As an adept data analyst, I specialize in transforming complex data into actionable insights for informed decision-making. My expertise spans a range of powerful tools:  PYTHON: Proficient in using libraries such as Pandas, NumPy, and Matplotlib for data manipulation, statistical analysis, and visualization.  POWER BI: Skilled in creating interactive dashboards and real-time business intelligence reports.  TABLEAU: Experienced in developing dynamic visualizations to effectively communicate data trends.  SQL: Expert in extracting, manipulating, and analyzing data from relational databases.  EXCEL: Advanced capabilities in data handling, including PivotTables, conditional formatting, and data validation.  R: Competent in conducting statistical analysis and visualization with extensive package support. ✅ AUTOMATION EXPERTISE: As an experienced automation expert, I specialize in streamlining processes and enhancing efficiency through cutting-edge automation tools. My expertise encompasses: ▶️ POWER AUTOMATE: Expert in designing and implementing workflows that seamlessly integrate Microsoft services and external applications, automating tasks to enhance productivity. ✴️ ZAPIER: Proficient in creating automated workflows that connect various apps and services without the need for coding, efficiently managing complex multi-step processes. ♾️ [login to view URL]: Experienced in building detailed automation scenarios using a visual interface, improving workflow efficiency and operational performance. By leveraging these tools, I deliver tailored automation solutions that transform business processes, enhance productivity, and drive growth.

Verifications

On time

100%

On budget

100%

Accept rate

100%

Repeat hire rate

23%

Portfolio

Portfolio

12370517
13039980
13040402
13036477
13038979
13036044
12370517
13039980
13040402
13036477
13038979
13036044
5.0 · 7 Reviews
7 Reviews
User Avatar
Flag of

Yasen K.

5.0

€30 EUR

5 hours ago

Call center Kpi dash board template Excel needed

Muhammad has very good communication skills. He was very professional during the whole journey and delivered according to my needs. I would definitely work with him again.

Share

User Avatar
Flag of

Jared K.

5.0

$253.71 CAD

10 months ago

Make.com Automation Specialist Required

Muhammad was excellent to work with. He understands what to do with minimal input required and can figure out many of the detailed and nuanced tasks on his own. I'm looking forward to our next project together.

Share

User Avatar
Flag of

Lukas L.

5.0

€80 EUR

1 year ago

Excel Optimization and Chart Integration

Excellent job, happy to continue work with also on other project! :)

Share

User Avatar
Flag of

Dayaparan P.

5.0

$50 USD

1 year ago

Excel Dashboard Creation

good communication, fast response.

Share

Experience

Automation Expert

Oct, 2024 - Present

1 year, 7 months

Upwork

Oct, 2024 - Present

1 year, 7 months

✅ Excel to Outlook Calendar Sync(Power Automate): Automated event transfers from Excel to Outlook Calendar, reducing manual entry. ✅ YouTube Data Extraction (Make.com): Automated email and social media handle extraction from YouTube descriptions. ✅ Airtable Logo Integration (Zapier): Integrated real-time company logos into Airtable based on company names. ✅ Dropbox File Notification (Make.com): Notified admins when files were added to Dropbox, ensuring privacy.

Oct, 2024 - Present

1 year, 7 months

Data Analyst

Jan, 2021 - Present

5 years, 4 months

Self-Employed

Jan, 2021 - Present

5 years, 4 months

✅ Conducted comprehensive data analysis to extract actionable insights and support strategic decision-making. ✅ Developed and maintained advanced dashboards and reports using Excel, and Tableau. ✅ Ensured data integrity through meticulous data cleaning and preprocessing. ✅ Collaborated with clients to understand their requirements and deliver tailored data solutions. ✅ Managed multiple projects concurrently, ensuring timely and accurate delivery.

Jan, 2021 - Present

5 years, 4 months

Education

University of the Punjab, Lahore

2023 - 2024

1 year

ADS (Computer Science, Statistics, Economy )

Flag of

Pakistan

2023 - 2024

1 year

SKANS School of Accountancy

2021 - 2024

3 years

Chartered Accountancy ( CA )

Flag of

Pakistan

2021 - 2024

3 years

Qualifications

Certificate in Accounting and Finance (CAF)

2025

Institute of Chartered Accountants of Pakistan ( ICAP )

Certified in Accounting and Finance (CAF) – March 2025. Expertise in bookkeeping, financial accounting, tax practices, and audit. Completed Financial Accounting & Reporting (I & II), Cost & Management Accounting, Audit & Assurance, and Business & Company Law. Skilled in financial reporting, analysis, and compliance, delivering accurate, reliable results for clients.

2025

Certifications

Freelancer Orientation

Freelancer Orientation

P

Preferred Freelancer Program SLA

Registered Users

Total Jobs Posted

Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)

Copyright © 2026 Freelancer Technology Pty Limited (ACN 142 189 759)