Freelancer logo
Log In Sign Up
Post a Project
EXPLORE
Data Entry
Data Processing
Database Administration
Excel
Visual Basic
Profile cover photo
You're now following
Error following user.
This user does not allow users to follow them.
You are already following this user.
Your membership plan only allows 0 follows. Upgrade here.
Successfully unfollowed
Error unfollowing user.
You have successfully recommended
Error recommending user.
Something went wrong. Please refresh the page and try again.
Email successfully verified.
User Avatar

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 / Hour
・
Flag of
Georgia (12:46 PM)
・
Joined on March 10, 2019
$20 USD / Hour
・
✔ 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
Verifications
On time
100%
On budget
100%
Accept rate
97%
Repeat hire rate
20%
Freelancer Excel Experts Georgia
See all Excel Experts in Georgia

Portfolio

Portfolio

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
Changes saved
5.0 · 40 Reviews
Reviews
User Avatar
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
•
Flag of
Los Angeles, United States
•
7 months ago
Share
User Avatar
Project for Emilia S. - Index • $50 USD
Another quick and great project with Emilia. she is an Excel genius!
Monty M.
@WebDesign27
•
Flag of
DOBBS FERRY, United States
•
9 months ago
Share
User Avatar
Project for Emilia S. - Contacts/Timeline XLS • $30 USD
Great work once again!
Monty M.
@WebDesign27
•
Flag of
DOBBS FERRY, United States
•
9 months ago
Share
User Avatar
Project for Emilia S. -- 5 • $35 USD
Good job on this macro - thank you
Monty M.
@WebDesign27
•
Flag of
DOBBS FERRY, United States
•
1 year ago
Share
User Avatar
Project for Emilia S. - Sales • $35 USD
Excel wizard - nice work!
Monty M.
@WebDesign27
•
Flag of
DOBBS FERRY, United States
•
1 year ago
Share
Qualifications
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
Certifications
US English - Level 1
US English
Spanish - Level 3
Spanish
Invite sent successfully!
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Freelancer logo US (International) / English
Help & Support
Freelancer
Categories Projects Contests Freelancers Enterprise AI Development Membership Preferred Freelancer Program Project Management Local Jobs Photo Anywhere Showcase API for Developers Get Verified Desktop App
About
About us How it Works Security Investor Sitemap Stories News Team Awards Press Releases Careers
Terms
Privacy Policy Terms and Conditions Copyright Policy Code of Conduct Fees and Charges
Partners
Escrow.com Loadshift Warrior Forum
Apps
Apple App Store logoGoogle Play logo
Copy to clipboard failed, please try again after adjusting your permissions.
Copied to clipboard.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2025 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.