Freelancer-logo Hvordan det virkerGennemse jobs Log Ind Tilmeld dig Slå et projekt op
UDFORSK
Data Entry Data Processing Database Administration Excel Visual Basic
Profile cover photoundefined
Du følger nu .
Fejl under følg af bruger.
Denne bruger har ikke tilladt andre bruger at følge dem.
Du følger allerede denne bruger.
Din medlemsskabsplan tillader kun at følge 0. Opgrader her.
Holdt op med at følge bruger.
Kunne ikke stoppe med at følge bruger.
Du har nu anbefalet
Kunne ikke anbefale bruger.
Noget gik galt. Forny venligst siden og prøv igen.
Email verificeret.
Brug Avatar.
$20 USD / time
Flag for GEORGIA
tbilisi, georgia
$20 USD / time
Klokken er nu 11:31 PM her
Tilmeldt marts 10, 2019
1 Anbefaling

Emilia S.

@EmiliaSimon

annual-level-two.svg
5,0 (25 anmeldelser)
5,0
5,0
$20 USD / time
Flag for GEORGIA
tbilisi, georgia
$20 USD / time
100 %
Jobs færdiggjort
100 %
Indenfor budgettet
100 %
Til tiden
25 %
Genansættelsesrate

VBA Developer | Data Analyst

✔ Expertise in Data Analysis & Visualization ✔ Expertise in Excel Automation ✔ Advanced Power BI, Power Query, DAX, Excel, VBA, SQL, Python
Freelancer Excel Experts Georgia

Kontakt Emilia S. angående dit job

Log ind for at diskutere detaljer over chat.

Portefølje indlæg

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
The project included:
- connection to MySQL database
- data cleaning and transformation
- modelling
- analysis
- visualization of key findings in a report with multiple pages
Power BI: Sales Report
The project included:
- connection to MySQL database
- data cleaning and transformation
- modelling
- analysis
- visualization of key findings in a report with multiple pages
Power BI: Sales Report
The project included:
- connection to MySQL database
- data cleaning and transformation
- modelling
- analysis
- visualization of key findings in a report with multiple pages
Power BI: Sales Report
The project included:
- connection to MySQL database
- data cleaning and transformation
- modelling
- analysis
- visualization of key findings in a report with multiple pages
Power BI: Sales Report
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
Sample Excel Dashboards
Excel Dashboards
Sample Excel Dashboards
Excel Dashboards
Sample Excel Dashboards
Excel Dashboards

Anmeldelser

Ændringer gemt
Viser 1 - 5 ud af 25 anmeldelser
Filtrer anbefalinger ud fra: 5,0
$300,00 USD
Terrific solution and problem solving for complex Excel macro for us.
Visual Basic Data Processing Data Entry Excel
+1 mere
Brug Avatar.
Flag for Monty M. @WebDesign27
19 dage siden
5,0
$125,00 USD
Great job on this Macro for us!
Visual Basic Data Processing Data Entry Excel
+1 mere
Brug Avatar.
Flag for Monty M. @WebDesign27
2 måneder siden
5,0
$50,00 USD
Nice job on some excel macro work for us!
Visual Basic Excel Word Microsoft Office Excel Macros
Brug Avatar.
Flag for Monty M. @WebDesign27
2 måneder siden
5,0
$350,00 AUD
Emilia really listened to what I wanted and delivered a project better than I could have imagined, it had every feature I asked for. Will definitely use Emilia’s service again
Visual Basic Data Processing Excel C# Programming Software Architecture
B
Flag for Brandi J. @brandij
2 måneder siden
5,0
$75,00 USD
Volveré a trbajar con Emilia,muy buenos tiempos y entregó el proyecto según lo solicitado, muy buen trabajo.
PHP Visual Basic Data Processing Data Entry Excel
L
Flag for Leo C. @Leocogr
3 måneder siden

Kvalifikationer

Google Data Analytics Professional Certificate

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

Microsoft Certified Power BI Data Analyst Associate

Microsoft
2022
Skills: Power BI, Power Platform, Data Storage, Azure

Kontakt Emilia S. angående dit job

Log ind for at diskutere detaljer over chat.

Verifikationer

Foretrukken freelancer
Identitet verificeret
Betaling verificeret
Telefon verificeret
E-mail verificeret
Facebook forbundet

Bedste færdigheder

Excel 24 Data Processing 19 Visual Basic 13 Data Entry 10 Database Administration 7

Gennemse lignende freelancere

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

Gennemse lignende fremvisninger

Excel
Data Processing
Visual Basic
Data Entry
Tidligere Bruger
Næste bruger
Invitationen blev sendt!
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2022 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.