Freelancer logo
Log In Sign Up
Post a Project
EXPLORE
Business Analysis
Excel
Excel Macros
Excel VBA
Visual Basic
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

Ihala D.

@TDRWork

monthly-level-three.svgverified-v2.svgpreferred-freelancer-v3.svg
5.0
13
4.1
4.1
100%

Microsoft excel and Power BI Expert

$18 USD / Hour
・
Flag of
Sri Lanka (4:09 PM)
・
Joined on December 25, 2019
$18 USD / Hour
・
As an Excel specialist boasting over 7 years of proficiency in both Microsoft Excel and Google Sheets. Holding a degree in Industrial Statistics and Mathematical Finance from the esteemed University of [login to view URL] expertise also lies in the design Excel template, design Google sheets template, creating excel formulas and excel automation by using VBA/Power query. Here's what I can do for you: Streamline your workflow by automating Excel reports with VBA/Power Query. Develop custom Excel macros to enhance productivity and efficiency. Design visually appealing and functional Excel templates for various purposes. Engineer complex formulas to extract meaningful insights from your data. Provide comprehensive data analysis and reporting services. Execute meticulous data entry tasks and conduct web scraping as needed. I'm here to make your life easier.Don't hesitate to reach out and entrust your project to me today.
Verifications
On time
100%
On budget
100%
Accept rate
100%
Repeat hire rate
44%
Freelancer Excel Experts Sri Lanka
See all Excel Experts in Sri Lanka

Portfolio

Portfolio

12405858
Developed a highly interactive and customized Power BI dashboard designed to provide a comprehensive overview of sales performance. The dashboard offers detailed insights into sales data categorized by country, payment method, sales type, sales amount, sales quantity, and yearly and monthly performance trends. To ensure accurate and consistent reporting, I used Power Query to clean, transform, and standardize the raw data from multiple sources, preparing it for seamless integration into the Power BI model. Leveraging advanced DAX, I created dynamic measures to calculate critical metrics such as total sales, total quantity, sales growth, and year-over-year comparisons. These measures enabled the dashboard to generate real-time and actionable insights into sales trends and performance metrics. Additionally, calculated columns were implemented to derive additional data points required for detailed analysis, ensuring all business requirements were met. The dashboard features a user-frien
Sales Overview Power BI dashboard
12404714
Developed a tailored Power BI dashboard for a retail client, using advanced data modeling and DAX to transform complex sales data into valuable insights. Utilized Power Query to clean and standardize the data, ensuring accuracy across multiple sources. Designed dynamic measures, calculated columns, and interactive visuals, including slicers and drill-through features, for detailed, real-time data exploration. This custom solution enabled the client to efficiently track sales performance by payment method, order states and Product category, supporting data-driven decision-making and business growth.
Profitability Analysis Dashboard
12404651
I worked with a retail client who needed a Power BI dashboard to track and analyze sales data across various categories, including country, payment method, sales type, and yearly performance. Their main goal was to gain actionable insights to drive growth and optimize sales strategies. One of the challenges faced was the inconsistency in data formats from different sources, which made it difficult to analyze effectively. To overcome this, I used Power Query for data cleaning and standardization. I then built a comprehensive data model using DAX to create key metrics like revenue growth and sales performance. The final solution provided interactive visuals with filters and drill-through options, allowing the client to explore data by specific regions or payment methods, making it easier to identify trends and inform business decisions.
Sales Analysis Dashboard in Power BI
11709499
This project showcases the creation of an Excel-based project management template with a focus on timeline visualization using Gantt charts. It incorporates features such as conditional formatting and advanced Excel functions to provide a comprehensive solution for project planning and tracking. Users can efficiently manage tasks, allocate resources, and monitor project progress. By leveraging advanced Excel functionalities like conditional formatting and complex formulas for data analysis, the template enhances project visibility and facilitates informed decision-making throughout the project lifecycle.
Excel Project Management Template
11709543
In my recent project, I utilized Excel Power Query automation to streamline data management processes. Starting with a CSV file, I efficiently cleaned and formatted the data, ensuring its accuracy and consistency. Leveraging the capabilities of DAX (Data Analysis Expressions), I implemented complex calculations to derive valuable insights. This comprehensive approach not only enhanced efficiency but also facilitated informed decision-making. By integrating Excel Power Query automation into my workflow, I have successfully optimized data manipulation and analysis, paving the way for more effective project outcomes.
Excel Power Query Automation
11709585
In my recent project, I focused on creating advanced Excel formulas to enhance data analysis and decision-making processes. One such formula I developed is a complex nested IF statement: =IF(IF(B96*C76<=C73,"yes", "No")="No",IF(C$71>0,IF(C90>0,C$71/(C90*12),0),0)) This formula evaluates multiple conditions and returns a calculated result based on the specified criteria. Additionally, I designed a new Excel template to complement these formulas, ensuring an intuitive and user-friendly interface for efficient data input and analysis. Through this project, I aimed to improve productivity and accuracy in data-driven tasks, empowering users to make informed decisions with confidence.
Advanced Excel formula creation
12405858
Developed a highly interactive and customized Power BI dashboard designed to provide a comprehensive overview of sales performance. The dashboard offers detailed insights into sales data categorized by country, payment method, sales type, sales amount, sales quantity, and yearly and monthly performance trends. To ensure accurate and consistent reporting, I used Power Query to clean, transform, and standardize the raw data from multiple sources, preparing it for seamless integration into the Power BI model. Leveraging advanced DAX, I created dynamic measures to calculate critical metrics such as total sales, total quantity, sales growth, and year-over-year comparisons. These measures enabled the dashboard to generate real-time and actionable insights into sales trends and performance metrics. Additionally, calculated columns were implemented to derive additional data points required for detailed analysis, ensuring all business requirements were met. The dashboard features a user-frien
Sales Overview Power BI dashboard
12404714
Developed a tailored Power BI dashboard for a retail client, using advanced data modeling and DAX to transform complex sales data into valuable insights. Utilized Power Query to clean and standardize the data, ensuring accuracy across multiple sources. Designed dynamic measures, calculated columns, and interactive visuals, including slicers and drill-through features, for detailed, real-time data exploration. This custom solution enabled the client to efficiently track sales performance by payment method, order states and Product category, supporting data-driven decision-making and business growth.
Profitability Analysis Dashboard
12404651
I worked with a retail client who needed a Power BI dashboard to track and analyze sales data across various categories, including country, payment method, sales type, and yearly performance. Their main goal was to gain actionable insights to drive growth and optimize sales strategies. One of the challenges faced was the inconsistency in data formats from different sources, which made it difficult to analyze effectively. To overcome this, I used Power Query for data cleaning and standardization. I then built a comprehensive data model using DAX to create key metrics like revenue growth and sales performance. The final solution provided interactive visuals with filters and drill-through options, allowing the client to explore data by specific regions or payment methods, making it easier to identify trends and inform business decisions.
Sales Analysis Dashboard in Power BI
11709499
This project showcases the creation of an Excel-based project management template with a focus on timeline visualization using Gantt charts. It incorporates features such as conditional formatting and advanced Excel functions to provide a comprehensive solution for project planning and tracking. Users can efficiently manage tasks, allocate resources, and monitor project progress. By leveraging advanced Excel functionalities like conditional formatting and complex formulas for data analysis, the template enhances project visibility and facilitates informed decision-making throughout the project lifecycle.
Excel Project Management Template
11709543
In my recent project, I utilized Excel Power Query automation to streamline data management processes. Starting with a CSV file, I efficiently cleaned and formatted the data, ensuring its accuracy and consistency. Leveraging the capabilities of DAX (Data Analysis Expressions), I implemented complex calculations to derive valuable insights. This comprehensive approach not only enhanced efficiency but also facilitated informed decision-making. By integrating Excel Power Query automation into my workflow, I have successfully optimized data manipulation and analysis, paving the way for more effective project outcomes.
Excel Power Query Automation
11709585
In my recent project, I focused on creating advanced Excel formulas to enhance data analysis and decision-making processes. One such formula I developed is a complex nested IF statement: =IF(IF(B96*C76<=C73,"yes", "No")="No",IF(C$71>0,IF(C90>0,C$71/(C90*12),0),0)) This formula evaluates multiple conditions and returns a calculated result based on the specified criteria. Additionally, I designed a new Excel template to complement these formulas, ensuring an intuitive and user-friendly interface for efficient data input and analysis. Through this project, I aimed to improve productivity and accuracy in data-driven tasks, empowering users to make informed decisions with confidence.
Advanced Excel formula creation
Changes saved
5.0 · 13 Reviews
Reviews
M
Macro creating project • $110 USD
He was very prompt and great with communication. He understood my concerns and worked with me step by step to get the best results.
May .
@mayh2
•
Flag of
Hilliard, United States
•
16 days ago
Share
User Avatar
Excel Data Cleanup - Email Filtering • $10 USD
The data sheet rearranged as requested and job was done ontime. Excellent communication and service since the job was done right in first attempt. Great Job.Thanks!
Lakshan M.
@lmadhuwantha91
•
Flag of
Colombo, Sri Lanka
•
18 days ago
Share
A
Excel Financial Dashboard creating • $600 USD
Ihala is very professional and clever in his field of work.
Aran A.
@Aran2202
•
Flag of
Vancouver, Canada
•
3 months ago
Share
A
Excel VBA automation project • $50 USD
Good job on the Excel Automation.
Aran A.
@Aran2202
•
Flag of
Vancouver, Canada
•
5 months ago
Share
A
Data automation in Excel • $140 USD
Good job on the Data Automation
Aran A.
@Aran2202
•
Flag of
Vancouver, Canada
•
6 months ago
Share
Experience
Data Processing with Excel and Power BI
Oct, 2017 - Present
•
7 years, 2 months
Freelancer
Oct, 2017 - Present
•
7 years, 2 months
I’ve been helping other business owners to develop their reports in a way that turns fast and simple. I’ve created excel reports, Excel macros and other types of analysis report to numerous clients. I will automate excel reports. create Excel Macros. develop Excel template. make excel formulas. Provide other data analysis and report. do data entry work and scraping.
Oct, 2017 - Present
•
7 years, 2 months
Demand Planning Analyst
Aug, 2016 - Jul, 2017
•
11 months
Unilever Sri Lanka limited
Aug, 2016 - Jul, 2017
•
11 months
As a Demand Planning Analyst focused on MIS, I specialized in data analysis and reporting to support the demand planning team. My role included preparing accuracy reports, conducting stock analyses, generating sales reports and other analysis reports. Effective communication and a proactive approach were key to fulfilling my responsibilities and contributing to the team's success.
Flag of
Colombo, Sri Lanka
Aug, 2016 - Jul, 2017
•
11 months
Education
University of Colombo
2013 - 2017
•
4 years
BSc Honours in Industrial Statistics and Mathematical Finance
Flag of
Sri Lanka
2013 - 2017
•
4 years
Qualifications
Data Skills for Excel Professionals
2024
Corporate Finance Institute
The courses cover fundamental aspects, including Data Analysis in Excel, Power Query Fundamentals, and Power Pivot Fundamentals. The recommended pre-work for participants is to have a basic familiarity with Excel. The specialization aims to enhance professionals' proficiency in leveraging Excel for data driven decision-making and is a valuable resource for individuals seeking to sharpen their data skills in a corporate finance context.
2024
Data Science Foundations - Level 1
2022
IBM
This Professional Certificate provides comprehensive insight into the transformative potential of data science, analytics and big data bring to new applications in any industry.
2022
Excel for Sales Professionals
2021
LinkedIn Learning
Track, analyze, and then forecast sales efficiently and accurately using Microsoft Excel. Learn how to import your sales data into Excel. Then, see how to clean up that data by removing redundancies, fixing incorrect information, and applying formatting. Next, step through the various methods of analyzing sales data in Excel, from filtering and sorting to using Quick Analysis and slicers. Additionally, explore how to create a leaderboard, spot trends, forecast sales, create dashboards, and more.
2021
Certifications
P
Preferred Freelancer Program SLA
US English - Level 1
US English
Freelancer Orientation
Freelancer Orientation
Data Entry
Data Entry
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.
Freelancer logo South Africa / English
Help & Support
Freelancer
Categories Projects Contests Freelancers Enterprise AI Development Membership Preferred Freelancer Program Project Management Local Jobs Photo Anywhere Showcase API for Developers Get Verified Desktop App
About
About us How it Works Security Investor Sitemap Stories News Team Awards Press Releases Careers
Terms
Privacy Policy Terms and Conditions Copyright Policy Code of Conduct Fees and Charges
Partners
Escrow.com Loadshift Warrior Forum
Apps
Apple App Store logoGoogle Play logo
Copy to clipboard failed, please try again after adjusting your permissions.
Copied to clipboard.
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.