Ihala D. Profile

4.4

(4 ulasan)

Anda kini mengikuti

Ralat mengikuti pengguna.

Pengguna ini tidak membenarkan pengguna untuk mengikuti mereka.

Anda telah mengikuti pengguna ini.

Pelan keahlian anda hanya membenarkan 0 mengikuti. Naik taraf di sini.

Berjaya menyahikut

Ralat tidak mengikuti pengguna.

Anda berjaya mengesyorkan

Ralat mengesyorkan pengguna.

Sesuatu telah berlaku. Sila segar semula halaman dan cuba lagi.

E-mel berjaya disahkan.

$6 USD / jam

kaduwela,

sri lanka

$6 USD / jam

Sekarang jam 9:12 PG di sini

Menyertai Disember 25, 2019

0 Cadangan

Ihala D.

@TDRWork

4.4

(4 ulasan)

1.1

100%

$6 USD / jam

kaduwela,

sri lanka

$6 USD / jam

100%

Pekerjaan Disiapkan

100%

Mengikut Bajet

100%

Tepat Pada Masa

25%

Kadar Upah Semula

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.

Lihat semua Excel Experts dalam Sri Lanka

Hubungi Ihala D. tentang pekerjaan anda

Log masuk untuk membincangkan sebarang butiran melalui sembang.

Portfolio

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

Excel Power Query Automation

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

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

Excel Project Management Template

Excel Power Query Automation

Advanced Excel formula creation

Inventory tracking Excel template using userform and VBA

Ulasan

Perubahan disimpan

Menunjukkan 1 - 4 daripada 4 ulasan

Tapis ulasan mengikut:

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.

+1 lagi

Shiran Y.

@ShiranFreelance

•

14 hari yang lalu

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.

Shiran Y.

@ShiranFreelance

•

2 bulan yang lalu

4.0

$20.00 USD

Optimize VBA Code Efficiency

Professional and reliable

Excel VBA

Excel Macros

Oriano B.

@krungthep

•

2 bulan yang lalu

5.0

$2.00 USD

spread sheet calculations

Extremely smart and polite - would highly recommend.

Steven U.

@property84

•

3 tahun yang lalu

Pengalaman

Freelancer

Okt 2017 - Hari ini

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.

Unilever Sri Lanka limited

Ogo 2016 - Jul 2017 (11 bulan, 1 hari)

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.

Pendidikan

BSc Honours in Industrial Statistics and Mathematical Finance

University of Colombo,

Sri Lanka

2013 - 2017

(4 tahun)

Kelayakan

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.

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.

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.