Logo de Freelancer
Iniciar sesión Registrarse
Publica un proyecto
EXPLORAR
Data Entry
Data Processing
Database Administration
Excel
Visual Basic
Foto de portada de perfil
Ahora estás siguiendo a
Error al seguir a usuario.
Este usuario no permite que los usuarios lo sigan.
Ya estás siguiendo a este usuario.
Tu plan de membresía solo permite 0 seguimientos. Mejora tu membresía aquí.
Dejaste de seguir correctamente a
Error al dejar de seguir al usuario.
Has recomendado exitosamente a
Error al recomendar al usuario.
Algo salió mal. Por favor, actualiza la página e intenta de nuevo.
Email verificado correctamente.
Avatar del usuario

Emilia S.

@EmiliaSimon

annual-level-three.svgverified-v2.svg
5,0
40
5,3
5,3
100%

VBA Developer | Data Scientist | Data Analyst

$20 USD / hora
・
Bandera de
Georgia (5:32 p. m.)
・
Se unió el marzo 10, 2019
$20 USD / hora
・
✔ 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
Verificaciones
A tiempo
100 %
Dentro del presupuesto
100 %
Aceptar tarifa
97 %
Tasa de recontratación
20 %
Freelancer Excel Experts Georgia
Ver todo Excel Experts en Georgia

Portafolio

Portafolio

9659843
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
9444684
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
9340115
Sample Excel Dashboards
Excel Dashboards
Sample Excel Dashboards
Excel Dashboards
Sample Excel Dashboards
Excel Dashboards
10033235
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
10033216
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
10033188
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
9659843
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
9444684
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
9340115
Sample Excel Dashboards
Excel Dashboards
Sample Excel Dashboards
Excel Dashboards
Sample Excel Dashboards
Excel Dashboards
10033235
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
10033216
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
10033188
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
Cambios guardados
5.0 · 40 Reviews
Opiniones
Avatar del usuario
Excel Formula Creation | 060124 • $100 USD
Emilia is brilliant! She is an Excel expert, and handled our script project professionally throughout the process. She understood our complex (to us) automation requirements, and got multiple issues resolved. I’ll definitely reach out to her with future projects. Highly recommended! A recent reviewer said it best. “Emilia is an Excel genius!”
Robert D.
@logictree
•
Bandera de
Los Angeles, United States
•
hace 7 meses
Compartir
Avatar del usuario
Project for Emilia S. - Index • $50 USD
Another quick and great project with Emilia. she is an Excel genius!
Monty M.
@WebDesign27
•
Bandera de
DOBBS FERRY, United States
•
hace 9 meses
Compartir
Avatar del usuario
Project for Emilia S. - Contacts/Timeline XLS • $30 USD
Great work once again!
Monty M.
@WebDesign27
•
Bandera de
DOBBS FERRY, United States
•
hace 9 meses
Compartir
Avatar del usuario
Project for Emilia S. -- 5 • $35 USD
Good job on this macro - thank you
Monty M.
@WebDesign27
•
Bandera de
DOBBS FERRY, United States
•
hace 1 año
Compartir
Avatar del usuario
Project for Emilia S. - Sales • $35 USD
Excel wizard - nice work!
Monty M.
@WebDesign27
•
Bandera de
DOBBS FERRY, United States
•
hace 1 año
Compartir
Calificaciones
Applied Data Science with Python
2022
IBM
Pandas, Numpy, Matplotlib, Seaborn, Scikit-learn
2022
Microsoft Certified Azure Data Scientist Associate
2022
Microsoft
Skills: Azure, Azure Machine Learning, Data Scientist, Machine Learning, ML Ops
2022
Google Data Analytics Professional Certificate
2022
Google
Tools: Spreadsheets, SQL, Tableau, and R
2022
Certificaciones
US English - Level 1
US English
Spanish - Level 3
Spanish
¡Invitación enviada correctamente!
¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Logo de Freelancer Ecuador / Español
Ayuda y soporte
Freelancer
CategoríasProyectos Concursos Freelancers Empresarial Desarrollo de IA MembresíaPrograma de Freelancers Preferentes Gestión del proyecto Trabajos localesPhoto Anywhere GaleríaAPI para desarrolladoresVerifícate Software de escritorio
 Información
Quiénes somos Cómo funciona Seguridad Inversionista Mapa del sitio Historias NoticiasEquipoPremiosComunicados de prensaEmpleos
 Términos
Política de privacidadTérminos y condicionesPolítica de derechos de autorCódigo de conductaCargos y Tarifas
Socios
Escrow.comLoadshiftWarrior Forum
 Apps
Logo de "App Store" de AppleLogo de Google Play
Falló el copiado al portapapeles. Intenta de nuevo después de ajustar tus permisos.
Copiado al portapapeles.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2025 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.