Логотип Freelancer
Увійти Реєстрація
Опублікувати проект
ВІДКРИЙТЕ ДЛЯ СЕБЕ
Business Analysis
Excel
Excel Macros
Excel VBA
Visual Basic
Фото на обкладинці профілю
Тепер ви підписані на
Помилка підписки на користувача.
Цей користувач не дозволяє слідувати за ним.
Ви вже слідуєте за цим користувачем.
Ваш членський план дозволяє мати не більше 0 підписок. Покращити рівень членства можна тут.
Успішно відписалися від
Помилка під час скасування підписки на користувача.
Ви успішно рекомендували
Помилка рекомендування користувача.
Щось пішло не так. Будь ласка, оновіть сторінку та повторіть спробу.
Електронну адресу успішно верифіковано.
Аватарка користувача

Ihala D.

@TDRWork

monthly-level-three.svgverified-v2.svg
5,0
13
4,1
4,1
100%

Microsoft excel and Power BI Expert

$18 USD / год.
・
Прапор
Sri Lanka (3:41 пп)
・
На сайті з грудня 25, 2019
$18 USD / год.
・
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.
Верифікації
Вчасно
100%
В межах бюджету
100%
Рейтинг прийняття
100%
Рейтинг повторного найняття
44%
Freelancer Excel Experts Sri Lanka
Переглянути всіх Excel Experts в Sri Lanka

Портфоліо

Портфоліо

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
Зміни збережено
5.0 · 13 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
•
Прапор
Hilliard, United States
•
7 days ago
Поділитися
Аватарка користувача
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
•
Прапор
Colombo, Sri Lanka
•
9 days ago
Поділитися
A
Excel Financial Dashboard creating • $600 USD
Ihala is very professional and clever in his field of work.
Aran A.
@Aran2202
•
Прапор
Vancouver, Canada
•
3 months ago
Поділитися
A
Excel VBA automation project • $50 USD
Good job on the Excel Automation.
Aran A.
@Aran2202
•
Прапор
Vancouver, Canada
•
5 months ago
Поділитися
A
Data automation in Excel • $140 USD
Good job on the Data Automation
Aran A.
@Aran2202
•
Прапор
Vancouver, Canada
•
5 months ago
Поділитися
Досвід
Data Processing with Excel and Power BI
жовт., 2017 - Теперішній час
•
7 years, 2 months
Freelancer
жовт., 2017 - Теперішній час
•
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.
жовт., 2017 - Теперішній час
•
7 years, 2 months
Demand Planning Analyst
серп., 2016 - лип., 2017
•
11 months
Unilever Sri Lanka limited
серп., 2016 - лип., 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.
Прапор
Colombo, Sri Lanka
серп., 2016 - лип., 2017
•
11 months
Освіта
University of Colombo
2013 - 2017
•
4 years
BSc Honours in Industrial Statistics and Mathematical Finance
Прапор
Sri Lanka
2013 - 2017
•
4 years
Кваліфікації
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
Сертифікати
P
Preferred Freelancer Program SLA
US English - Level 1
US English
Freelancer Orientation
Freelancer Orientation
Data Entry
Data Entry
Запрошення успішно надіслане!
Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Логотип Freelancer Ukraine / Українська
Допомога та підтримка
 Фрілансер
Категорії Проекти Конкурси Фрілансери Enterprise Розробка на основі ШІ Членство Програма "Бажаний Фрілансер" Керування проектами Місцеві роботиPhoto Anywhere Вітрина API для розробників Верифікація Desktop App
 Про нас
Про нас Як це працює Безпека Інвестиції Мапа сайту Історії Новини Команда Нагороди Прес-релізи Вакансії
 Умови
Політика конфіденційності Умови користування Політика захисту авторських прав Правила поведінки Комісії і тарифи
 Партнери
Escrow.comLoadshiftWarrior Forum
 Застосунки
Логотип Apple App StoreЛоготип Google Play
Не вдалося скопіювати в буфер обміну. Будь ласка, налаштуйте дозволи та повторіть спробу.
Скопійовано в буфер обміну.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2025 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.