Profile cover photo
You're now following
Error following user.
This user does not allow users to follow them.
You are already following this user.
Your membership plan only allows 0 follows. Upgrade here.
Successfully unfollowed
Error unfollowing user.
You have successfully recommended
Error recommending user.
Something went wrong. Please refresh the page and try again.
Email successfully verified.
User Avatar

Abdullah L.

@AbdullahLasharii

monthly-level-two.svg
0.0
0
0.0
0.0
0%

MS Excel | Automation Expert | Data Analyst | CA |

$5 USD / Hour
Flag of
Pakistan (1:20 PM)
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
Accept rate
100%

Portfolio

Portfolio

12370528
12370517
12370528
12370517
Changes saved
0.0 · 0 Reviews
Reviews
No reviews to see here!
Experience
Automation Expert
Oct, 2024 - Present
2 months, 6 days
Upwork
Oct, 2024 - Present
2 months, 6 days
✅ 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
2 months, 6 days
Data Analyst
Jan, 2021 - Present
3 years, 11 months
Self-Employed
Jan, 2021 - Present
3 years, 11 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
3 years, 11 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
Invite sent successfully!
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2025 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.