Find Jobs
Hire Freelancers

Data Analysis Through Excel Macros or MS Access

$30-250 USD

Completed
Posted about 6 years ago

$30-250 USD

Paid on delivery
I have weekly data files which come to me that I need to run analysis against. I need help with automating the process of organizing and analyzing this data through Excel Macros or SQL in MS Access. Basically, I would like to be able to feed this data into the script that is written and have it provide me with a couple of outputs. One being the organized data for archiving, the other being an analysis of the data.
Project ID: 15998636

About the project

40 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Expert Excel Programmer on freelancer.com and have been featured by the freelancer community https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) Relevant Skills and Experience I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you. Proposed Milestones $250 USD - Please pay me once job is 100% done.
$250 USD in 3 days
5.0 (760 reviews)
8.5
8.5
40 freelancers are bidding on average $165 USD for this job
User Avatar
Greeting, I have understood your Data Analysis Through Excel Macros or MS Access task and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I have more than 5 years of experience in Data Processing, Excel, Microsoft Access, SQL, Visual Basic Proposed Milestones $200 USD - Data Analysis Through Excel Macros or MS Access
$200 USD in 3 days
4.9 (354 reviews)
8.0
8.0
User Avatar
Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm still working on this proposal.
$200 USD in 3 days
4.9 (372 reviews)
7.5
7.5
User Avatar
I love excel automation, and have written several macros to analyse, summarize, clean, merge, remove unwanted data, etc. I can write a macro to do the analysis and create an archive sheet for you. Relevant Skills and Experience Please read my 290+ reviews. I am here to impress you with my work. ZERO ERROR GUARANTEED!! Proposed Milestones $200 USD - Macro
$200 USD in 3 days
4.9 (300 reviews)
7.6
7.6
User Avatar
I will do the data analysis via sql and VBA in Microsoft Access Relevant Skills and Experience I have experience of 500 + projects and 12 + years in Microsoft Access Proposed Milestones $155 USD - Final version I will do both analysis and archiving in Microsoft access
$155 USD in 3 days
5.0 (485 reviews)
7.2
7.2
User Avatar
I am a guru in Excel, and I have experience in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's, charts and more. Relevant Skills and Experience I served as CFO, Controller, and Chief Accountant at global parent companies. I have extensive experience in accounting, consolidating, forecasting, budgeting, and costing, reports. Proposed Milestones $250 USD - initial milestone
$250 USD in 3 days
4.9 (90 reviews)
7.1
7.1
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards Relevant Skills and Experience VBA/Models/Databases Proposed Milestones $150 USD - final delivery
$150 USD in 4 days
5.0 (245 reviews)
7.0
7.0
User Avatar
Hi, I'm a senior databases developer. I have read you project description and I'd suggest building an access database where you have the ability to import your data and run your queries as required. Relevant Skills and Experience Ms Access, VBA, SQL Proposed Milestones $155 USD - default I'd like to discuss this further with you. Check my profile for similar previous projects.
$155 USD in 3 days
4.9 (72 reviews)
5.9
5.9
User Avatar
Hi, I can build Ms Access software with Exce/sql automation. Relevant Skills and Experience I'm programming in VB/SQL/Access since 1997 Proposed Milestones $222 USD - default
$222 USD in 5 days
4.7 (55 reviews)
6.1
6.1
User Avatar
I am interested in this project. If interested in hiring me then please let me know so that we can finalize the scope, timelines and budget accordingly. Relevant Skills and Experience I am an experienced MS Access applications developer. I can do this job for you. Proposed Milestones $122 USD - to be discussed
$122 USD in 3 days
5.0 (86 reviews)
5.8
5.8
User Avatar
I have excellent knowledge on MS Access, SQL database and Excel automation using VBA. I have good experience as data analyst for 3 year. Relevant Skills and Experience Data Analyst, MS Access developer, SQL Database, Excel, VBA automation. Proposed Milestones $222 USD - I will complete entire work withing 2 days. Additional Services Offered $20 USD - If Access database then Excellent design with user specific login screen. I would love to automate all of your manual functionalities.
$222 USD in 3 days
4.8 (25 reviews)
5.3
5.3
User Avatar
Hi, I can work on your file. Kindly review my profile to know more about my skills and experience required for this work. Regards Awaisjehangir
$150 USD in 2 days
4.6 (37 reviews)
5.2
5.2
User Avatar
Hello from across the pond! generally speaking, MS Access is a good way to set up the SQL queries. this can then be paired with an excel book with some macros if required to analyse the data further. Relevant Skills and Experience Work full time as a data analyst specialising in SQL, Excel & Access. Proposed Milestones $150 USD - Project completion it really depends on the type of incoming data, and how you want it analysed. Please pop up to have a chat and I can discuss this in further detail with you!
$150 USD in 3 days
5.0 (14 reviews)
4.1
4.1
User Avatar
I am 9+ Years of Experienced Software Developer, successfully completed many projects (please see my reviews), like to work on your project. Relevant Skills and Experience ASP.Net, C#, VB.Net, MVC, WPF, Visual Basic, Excel VBA, MS SQL Server, MYSQL, Oracle, MS Access, Crystal Report, Telerik, Bootstrap, HTML 5, CSS,Java Script is my working domain. Proposed Milestones $150 USD - Final
$150 USD in 3 days
5.0 (12 reviews)
4.1
4.1
User Avatar
Create MS Excel or Access application for organizing and analyzing data Relevant Skills and Experience Certified expert MS Excel and Access developer.. I can create an application using VBA (Visual Basic for Applications) that will import the data file and automate organization/analysis. Proposed Milestones $50 USD - Project Kick-off $100 USD - Initial turnover $200 USD - Final turnover I am currently available full-time to work on your project.
$250 USD in 3 days
5.0 (4 reviews)
3.4
3.4
User Avatar
I offer you high dedication, quality and speed. I can work full time 24/7. I already have code for this project. Relevant Skills and Experience I am Software Engineer; +10 years in: - Model relational database (MsAccess:Forms, Reports, Query) / Syntax SQL - Excel a (Macros, VBA, Functions, Pivot tables) Proposed Milestones $130 USD - You will only pay after you test and feel 100% satisfied.
$130 USD in 3 days
5.0 (5 reviews)
3.6
3.6
User Avatar
I will modify my existing MS Excel VBA scripts to automate the process of organizing and analyzing your data and provide you with a couple of outputs (organized data for archiving & analysis of data) Relevant Skills and Experience I have been coding in basic & MS Office (Word, Excel, PowerPoint etc...) VBA script since 2000. Proposed Milestones $200 USD - Project Successfully Completion In what format do you want your outputs?
$200 USD in 3 days
5.0 (1 review)
3.4
3.4
User Avatar
Provide an application that analyses the input file and post it to an Access database, and provide a report with the required output. However, a sample of input and expected output is required. Relevant Skills and Experience C# coding experience. Database design. Proposed Milestones $150 USD - Script development and database design Please provide the sample (Data file and required analysis).
$150 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello. I can help you managing your data and do some analysis. Peter. Relevant Skills and Experience I can write VBA macros (for Excel or Access) and also, what is often very useful, switch to R or Python, especially for making more advanced analysis or parsing harshly formatted data. Proposed Milestones $160 USD - project Please contact me for more details.
$160 USD in 6 days
0.0 (0 reviews)
0.0
0.0
User Avatar
There are too many ways we can handle the project. If the amount of data is big we can use Access and then Excel to get the output. It is up to you. I am a Data Analyst. I can help you with the output Relevant Skills and Experience Excel, VBA, mySQL, Access
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
In my historical career i have created excel files similar to the ones you wan Relevant Skills and Experience More than twenty years dealing with excel in my work Stay tuned, I'm still working on this proposal.
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Charlotte, United States
5.0
2
Payment method verified
Member since Nov 21, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 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.