Freelancer标志它是如何运作的 浏览工作
登录 注册
发布项目
个人资料封面照片
您正在关注
关注用户错误。
该用户不允许他人关注他们。
您已经关注了这个用户。
您的会员计划仅允许0个关注。升级在此。
成功取消关注
取消关注用户错误
您已成功推荐
推荐用户错误。
出问题了，请刷新页面并重新尝试。
电子邮箱已成功验证。
用户头像
$6 USD / 小时
SRI LANKA的国旗
kaduwela, sri lanka
$6 USD / 小时
目前这里是11:10 上午
十二月 25, 2019已加入
0 推荐

Ihala D.

@TDRWork

monthly-level-three.svg
verified-v2.svg
 4.4 (4条评论)
1.1
1.1
100%
100%
$6 USD / 小时
SRI LANKA的国旗
kaduwela, sri lanka
$6 USD / 小时
100%
工作已完成
100%
在预算内
100%
按时
20%
重复雇用率

Microsoft excel macros and formulas expert

As a 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.
Freelancer Excel Experts Sri Lanka
查看所有Excel Experts在Sri Lanka

联系Ihala D.询问您的工作详情

登录并通过聊天讨论所有细节。

文件夹

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
11705594
This project focuses on creating a robust image inventory management template using Excel VBA and UserForm, aimed at enhancing efficiency and user experience. The template incorporates barcode scanning functionality to expedite and ensure accurate data entry, simplifying the management of image inventory. Through a user-friendly interface facilitated by the UserForm, users can seamlessly input inventory details, leading to real-time updates of the inventory database. This streamlined process supports smooth inventory in and out processing, enabling effective tracking of stock levels and movements. Highly customizable and adaptable, the template caters to various inventory management requirements, offering improved efficiency, accuracy, and control over image inventory management tasks.
Inventory tracking Excel template using userform and VBA
This project focuses on creating a robust image inventory management template using Excel VBA and UserForm, aimed at enhancing efficiency and user experience. The template incorporates barcode scanning functionality to expedite and ensure accurate data entry, simplifying the management of image inventory. Through a user-friendly interface facilitated by the UserForm, users can seamlessly input inventory details, leading to real-time updates of the inventory database. This streamlined process supports smooth inventory in and out processing, enabling effective tracking of stock levels and movements. Highly customizable and adaptable, the template caters to various inventory management requirements, offering improved efficiency, accuracy, and control over image inventory management tasks.
Inventory tracking Excel template using userform and VBA
This project focuses on creating a robust image inventory management template using Excel VBA and UserForm, aimed at enhancing efficiency and user experience. The template incorporates barcode scanning functionality to expedite and ensure accurate data entry, simplifying the management of image inventory. Through a user-friendly interface facilitated by the UserForm, users can seamlessly input inventory details, leading to real-time updates of the inventory database. This streamlined process supports smooth inventory in and out processing, enabling effective tracking of stock levels and movements. Highly customizable and adaptable, the template caters to various inventory management requirements, offering improved efficiency, accuracy, and control over image inventory management tasks.
Inventory tracking Excel template using userform and VBA
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
11705594
This project focuses on creating a robust image inventory management template using Excel VBA and UserForm, aimed at enhancing efficiency and user experience. The template incorporates barcode scanning functionality to expedite and ensure accurate data entry, simplifying the management of image inventory. Through a user-friendly interface facilitated by the UserForm, users can seamlessly input inventory details, leading to real-time updates of the inventory database. This streamlined process supports smooth inventory in and out processing, enabling effective tracking of stock levels and movements. Highly customizable and adaptable, the template caters to various inventory management requirements, offering improved efficiency, accuracy, and control over image inventory management tasks.
Inventory tracking Excel template using userform and VBA
This project focuses on creating a robust image inventory management template using Excel VBA and UserForm, aimed at enhancing efficiency and user experience. The template incorporates barcode scanning functionality to expedite and ensure accurate data entry, simplifying the management of image inventory. Through a user-friendly interface facilitated by the UserForm, users can seamlessly input inventory details, leading to real-time updates of the inventory database. This streamlined process supports smooth inventory in and out processing, enabling effective tracking of stock levels and movements. Highly customizable and adaptable, the template caters to various inventory management requirements, offering improved efficiency, accuracy, and control over image inventory management tasks.
Inventory tracking Excel template using userform and VBA
This project focuses on creating a robust image inventory management template using Excel VBA and UserForm, aimed at enhancing efficiency and user experience. The template incorporates barcode scanning functionality to expedite and ensure accurate data entry, simplifying the management of image inventory. Through a user-friendly interface facilitated by the UserForm, users can seamlessly input inventory details, leading to real-time updates of the inventory database. This streamlined process supports smooth inventory in and out processing, enabling effective tracking of stock levels and movements. Highly customizable and adaptable, the template caters to various inventory management requirements, offering improved efficiency, accuracy, and control over image inventory management tasks.
Inventory tracking Excel template using userform and VBA

评论

变更已保存
展示4中的1-4条评论
 筛选评论规则：
5.0
$10.00 AUD
Project for Ihala D.
Very prompt responses and great customer service. Ihala D, understood exactly what I was looking for and was able to deliver great quality work with fast delivery. This was the second time I used his services, and have been great to work with.
Excel
Business Analysis
Microsoft Office
Excel VBA
+1更多
S
的国旗 Shiran Y.
@ShiranFreelance
•
17 天前
5.0
$10.00 AUD
High-Volume Excel Project Management Template
Ihala D. delivered the project before the agreed time and he went beyond to add some extra features using his expertise. I am very happy with his work and will definitely contact him for future projects.
Visual Basic
Project Management
Excel
Business Analysis
Microsoft Office
S
的国旗 Shiran Y.
@ShiranFreelance
•
2 个月前
4.0
$20.00 USD
Optimize VBA Code Efficiency
Professional and reliable
Excel VBA
Excel Macros
K
的国旗 Oriano B.
@krungthep
•
3 个月前
5.0
$2.00 USD
spread sheet calculations
Extremely smart and polite - would highly recommend.
Data Processing
Data Entry
Excel
Mathematics
P
的国旗 Steven U.
@property84
•
3 年前

经验

Data Processing with Excel and Power BI

Freelancer
10月 2017 - 现在
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.

Demand Planning Analyst

Unilever Sri Lanka limited
8月 2016 - 7月 2017 (11 个月, 1 天)
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.

教育

BSc Honours in Industrial Statistics and Mathematical Finance

University of Colombo, Sri Lanka 2013 - 2017
(4 年)

资质

Data Skills for Excel Professionals

Corporate Finance Institute
2024
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.

Data Science Foundations - Level 1

IBM
2022
This Professional Certificate provides comprehensive insight into the transformative potential of data science, analytics and big data bring to new applications in any industry.

Excel for Sales Professionals

LinkedIn Learning
2021
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.

联系Ihala D.询问您的工作详情

登录并通过聊天讨论所有细节。

认证

优选威客
身份已验证
支付已验证
电话已验证
邮箱已验证
Facebook已关联

资质

preferredfreelancer-1.png Preferred Freelancer Program SLA 1 93%
us_eng_1.png US English 1 82%
freelancer_orientation.png Freelancer Orientation 1 80%
data_entry_1.png Data Entry 1 80%

顶级技能

Excel 3
Business Analysis 2
Microsoft Office 2
Excel VBA 2
Excel Macros 2

浏览相似威客

Excel Experts in Sri Lanka
Excel Experts
Business Analysts
Microsoft Office Experts

浏览相似作品

Excel
Business Analysis
Microsoft Office
Excel VBA
之前的用户 下一个用户
邀请已发送成功！
谢谢！我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
Freelancer标志 P.R. China / 中文(简体) 帮助和支持 威客分类项目竞赛威客企业会员优选威客计划项目管理本地工作Photo Anywhere 作品展示开发人员API获得认证桌面APP 关于关于我们如何运作安全投资方网站地图故事消息团队奖励新闻发布职业 条款隐私政策条款和条件版权政策行为准则费用及收费合伙人Escrow.comLoadshiftWarrior Forum 应用程序苹果APP商城图标Google Play标志
复制到剪切板失败，请修改权限后重试。
复制到剪贴板。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出，请再次登录。