Logo-ul Freelancer Ce presupune Caută proiecte
Conectare Înregistrare
Postează un proiect
EXPLOREAZĂ
Data Entry
Data Processing
Database Administration
Excel
Visual Basic
Profile cover photo
Acum urmărești pe
A apărut o eroare la urmărirea utilizatorului.
Utilizatorul nu le permite altor utilizatori să-l urmărească.
Urmărești deja acest utilizator.
Planul tău de abonament permite doar 0 urmăriri. Alege un abonament superior apăsând aici.
Nu mai urmărești pe
A apărut o eroare la anularea urmăririi utilizatorului.
Ai recomandat pe
A apărut o eroare la recomandarea utilizatorului.
A apărut o eroare. Reîncarcă pagina și încearcă din nou.
Adresa de e-mail a fost confirmată.
Avatarul utilizatorului
$20 USD/oră
Steagul GEORGIA
tbilisi, georgia
$20 USD/oră
Momentan, aici e ora 8:59 p.m.
S-a înregistrat pe martie 10, 2019
2 Recomandări

Emilia S.

@EmiliaSimon

annual-level-three.svg
verified.svg
 5,0 (34 recenzii)
5,1
5,1
96%
96%
$20 USD/oră
Steagul GEORGIA
tbilisi, georgia
$20 USD/oră
100 %
Proiecte finalizate
100 %
Conform bugetului
100 %
La timp
19 %
Rata de angajare repetată

VBA Developer | Data Scientist | Data Analyst

✔ Expertise in Data Analysis & Visualization ✔ Expertise in Machine Learning ✔ Expertise in Excel Automation ✔ Advanced Power BI, Power Query, DAX, Excel, VBA, SQL, Python, R, C, JavaScript
Freelancer Excel Experts Georgia
Vezi toate opțiunile pentru Excel Experts din Georgia

Discută cu Emilia S. despre proiect

Conectează-te pentru a discuta pe chat despre detalii.

Portfoliu

Distribution Optimization with Python
The project included: - connection to MySQL database - data cleaning and transformation - modelling - analysis - visualization of key findings in a multi-page report
Power BI: Sales Report
The project included: - connection to MySQL database - data cleaning and transformation - modelling - analysis - visualization of key findings in a multi-page report
Power BI: Sales Report
The project included: - connection to MySQL database - data cleaning and transformation - modelling - analysis - visualization of key findings in a multi-page report
Power BI: Sales Report
The project included: - connection to MySQL database - data cleaning and transformation - modelling - analysis - visualization of key findings in a multi-page report
Power BI: Sales Report
Analysis of insurance claims that included creation of relevant measures, aggregations, data binning and grouping, finding outliers, etc.
Power BI: Insurance Claims Analysis
Analysis of insurance claims that included creation of relevant measures, aggregations, data binning and grouping, finding outliers, etc.
Power BI: Insurance Claims Analysis
Analysis of insurance claims that included creation of relevant measures, aggregations, data binning and grouping, finding outliers, etc.
Power BI: Insurance Claims Analysis
One of my recent projects in VBA includes populating Word documents from the data in Excel, using mail merge like techniques, signing the documents, naming them with a user-defined name and saving to a specific folder.
VBA: Document Generator
One of my recent projects in VBA includes populating Word documents from the data in Excel, using mail merge like techniques, signing the documents, naming them with a user-defined name and saving to a specific folder.
VBA: Document Generator
One of my recent projects in VBA includes populating Word documents from the data in Excel, using mail merge like techniques, signing the documents, naming them with a user-defined name and saving to a specific folder.
VBA: Document Generator
The algorithm I created in this project distributes the "Spread Amount" between the "Start" and "End" dates based on the delineated "Curve" (see the screenshot below). The code first finds the Min and Max dates, then determines the number of months between them and inserts the corresponding dates in the top row. Finally, it evaluates each of the rows in the spreadsheet, spreads the "Spread Amount" based on the "Curve" and the applicable "Start/End" dates and outputs the results in the corresponding cells. For example, if the curve is 5/95, it places 5% of the amount in the first half of the period of performance and 95% in the second half. The ranges are not hard-coded, so the program is dynamic and it will work with any number of rows/columns.
VBA: Spreading values between specified dates
The algorithm I created in this project distributes the "Spread Amount" between the "Start" and "End" dates based on the delineated "Curve" (see the screenshot below). The code first finds the Min and Max dates, then determines the number of months between them and inserts the corresponding dates in the top row. Finally, it evaluates each of the rows in the spreadsheet, spreads the "Spread Amount" based on the "Curve" and the applicable "Start/End" dates and outputs the results in the corresponding cells. For example, if the curve is 5/95, it places 5% of the amount in the first half of the period of performance and 95% in the second half. The ranges are not hard-coded, so the program is dynamic and it will work with any number of rows/columns.
VBA: Spreading values between specified dates
In this project, I created a tool for investigating uncertainty with the Monte Carlo simulation. It allows the user to simulate a profitability analysis based on Net Present Value (NPV) of a proposed capital project. I implemented it into a VBA user form, with five different typical distributions used in Monte Carlo simulations.
VBA: Monte Carlo Simulation
In this project, I created a tool for investigating uncertainty with the Monte Carlo simulation. It allows the user to simulate a profitability analysis based on Net Present Value (NPV) of a proposed capital project. I implemented it into a VBA user form, with five different typical distributions used in Monte Carlo simulations.
VBA: Monte Carlo Simulation
In this project, I created a tool for investigating uncertainty with the Monte Carlo simulation. It allows the user to simulate a profitability analysis based on Net Present Value (NPV) of a proposed capital project. I implemented it into a VBA user form, with five different typical distributions used in Monte Carlo simulations.
VBA: Monte Carlo Simulation

Recenzii

Modificările au fost salvate
Se afișează 1 – 5 din 34 recenzii
Filtrează recenziile în funcție de:
5,0
$35,00 USD
Project for Emilia S. - Sales
Excel wizard - nice work!
Visual Basic
Data Processing
Data Entry
Excel
+ încă 1
Avatarul utilizatorului
Steagul Monty M.
@WebDesign27
•
18 zile în urmă
5,0
$50,00 USD
Project for Emilia S. - sum ship
Nice work on another Excel macro for us.
Visual Basic
Data Processing
Data Entry
Excel
+ încă 1
Avatarul utilizatorului
Steagul Monty M.
@WebDesign27
•
2 luni în urmă
5,0
$100,00 USD
Project for Emilia S. -- 4
Excel mastermind - great work once again!
Visual Basic
Data Processing
Data Entry
Excel
+ încă 1
Avatarul utilizatorului
Steagul Monty M.
@WebDesign27
•
3 luni în urmă
5,0
$75,00 USD
Project for Emilia S. - XLS Program
Nice job on another Excel project for us.
Visual Basic
Data Processing
Data Entry
Excel
+ încă 1
Avatarul utilizatorului
Steagul Monty M.
@WebDesign27
•
3 luni în urmă
4,2
$50,00 USD
Project for Emilia S.
Emilia is fast and with easy communication.
Visual Basic
Data Processing
Data Entry
Excel
+ încă 1
Avatarul utilizatorului
Steagul Ernest G.
@Taaroa1945
•
5 luni în urmă

Calificări

Applied Data Science with Python

IBM
2022
Pandas, Numpy, Matplotlib, Seaborn, Scikit-learn

Microsoft Certified Azure Data Scientist Associate

Microsoft
2022
Skills: Azure, Azure Machine Learning, Data Scientist, Machine Learning, ML Ops

Google Data Analytics Professional Certificate

Google
2022
Tools: Spreadsheets, SQL, Tableau, and R

Discută cu Emilia S. despre proiect

Conectează-te pentru a discuta pe chat despre detalii.

Verificări

Programul Freelancer preferat
Identitate confirmată
Metodă de plată confirmată
Număr de telefon confirmat
Adresă de e-mail confirmată
Conectat(ă) prin Facebook

Certificări

us_eng_1.png US English 1 95%

Cele mai bune aptitudini

Excel 32
Data Processing 27
Visual Basic 20
Data Entry 18
Database Administration 14

Caută freelanceri similari

Excel Experts in Georgia
Excel Experts
Data Processing Executives
Visual Basic Developers

Caută prezentări similare

Excel
Data Processing
Visual Basic
Data Entry
Utilizatorul anterior Utilizatorul următor
Invitația a fost trimisă!
Logo-ul Freelancer Romania / Română Ajutor și asistență Freelancer Categorii Proiecte Concursuri Freelanceri Programul Enterprise Abonament Programul Freelancer preferat Gestionarea proiectului Proiecte locale Photo Anywhere Galeria de prezentare API-uri pentru dezvoltatori Solicită efectuarea unei verificări Aplicația pentru desktop Despre Despre noi Ce presupune Securitate Investori Harta site-ului Relatări Știri Echipă Premii Comunicate de presă Cariere Termeni Politica de confidențialitate Termeni și condiții Politica privind drepturile de autor Cod de conduită Taxe și comisioane Parteneri Escrow.com LoadshiftWarrior Forum Aplicații Sigla Apple App StoreLogo-ul Google Play
Nu s-a putut efectua copierea în clipboard. Încearcă din nou după ce-ți ajustezi permisiunile.
S-a copiat în clipboard.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2023 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.