Ihala D. Profile

4,3

(3 commentaires)

Vous suivez désormais

Erreur de suivi de l'utilisateur.

Cet utilisateur n'utilise pas les utilisateurs à le suivre.

Vous suivez déjà cet utilisateur.

Votre plan d'adhésion ne permet que 0 suivis. Améliorez ici.

Ne suit désormais plus

Erreur lors de l'arrêt du suivi de l'utilisateur.

Vous avez désormais recommandé

Erreur lors de la recommendation de l'utilisateur.

Une erreur a eu lieu. Veuillez rafraîchir la page et réessayer.

E-mail désormais vérifié.

$6 USD / heure

kaduwela,

sri lanka

$6 USD / heure

Il est actuellement 1:19 PM ici

Rejoint le décembre 25, 2019

0 Recommandations

Ihala D.

@TDRWork

4,3

(3 commentaires)

0,9

100%

$6 USD / heure

kaduwela,

sri lanka

$6 USD / heure

100 %

Travaux complétés

100 %

Suivant le budget

100 %

Dans les temps

N/A

Taux de réembauche

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.

Voir tous les Excel Experts en Sri Lanka

Contactez Ihala D. concernant votre travail

Connectez-vous pour discuter de tous les détails via la messagerie.

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

Commentaires

Modifications enregistrées

Montre1 - 3 sur 3 commentaires

Filtrer les commentaires par :

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

•

il y a 1 mois

4,0

$20,00 USD

Optimize VBA Code Efficiency

Professional and reliable

Excel VBA

Excel Macros

Oriano B.

@krungthep

•

il y a 1 mois

5,0

$2,00 USD

spread sheet calculations

Extremely smart and polite - would highly recommend.

Steven U.

@property84

•

il y a 3 ans

Expérience

Freelancer

oct. 2017 - Jusqu'à présent

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.

Éducation

Industrial Statistics and Mathematical Finance

University of Colombo,

Sri Lanka

2013 - 2017

(4 ans)

Qualifications

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.