Find Jobs
Hire Freelancers

Advanced Excel user to build an excel database from multiple sources, update, then analyse variances within Excel f

$30-250 AUD

En curso
Publicado hace alrededor de 3 años

$30-250 AUD

Pagado a la entrega
Task requires to pick up data from multiple source files (CSV format & Excel) into one database. The number of columns and rows to be populated adds the task to be tedious including data to be collated against their unique reference and category hierarchy. Expertise required with advance excel formulas / power query / macro with multiple index match formula which can pick data sets from multiple source files in a way that every time the source file is updated with new data the database is linked and setup to pick the updated dataset. Once all data is in one database, simple variance analysis is required as output along with few bridge chart to show in a presentation tab within the database.
ID del proyecto: 29501349

Información sobre el proyecto

21 propuestas
Proyecto remoto
Activo hace 3 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hi I would love to help you to automate the Excel database template. I'm well versed with Excel VBA/Macro, complex formulas, documents automation, data analysis, data processing, etc. I have good experience working on several large VBA projects. Recently I have created an Excel ERP system for a small company, accomplished several sales, forecasting models. I can assure you of quality work. I'll create a user form for an easy input system in the template, analyze data, and show a summary in a visually appealing dashboard. Ready to send some samples of my previous work. It will be a great pleasure working with you. Thanks
$220 AUD en 3 días
5,0 (42 comentarios)
6,4
6,4
21 freelancers están ofertando un promedio de $140 AUD por este trabajo
Avatar del usuario
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me.
$140 AUD en 1 día
4,9 (151 comentarios)
6,4
6,4
Avatar del usuario
I can perfectly help you with that. I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Financial Analysis, Financial Modeling and various types of Analysis, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project.
$70 AUD en 1 día
4,9 (49 comentarios)
5,9
5,9
Avatar del usuario
Hello I'm an excel professional and will create your needed file to pull data from multiple sources and rearrange/calculate/ present it as needed. Can we discuss your requirements and file? John
$120 AUD en 5 días
5,0 (58 comentarios)
5,4
5,4
Avatar del usuario
Hi, Gone through the job details and happy to help you. I am an expert in excel formulas, dashboards, macros. I will be able to finish before the deadline. Thanks Ruma
$160 AUD en 1 día
5,0 (34 comentarios)
5,1
5,1
Avatar del usuario
Expert in excel with over 15+ years of experience and over 4.9 user rating on this platform. Completed over 61 projects on FL. Expertise in - ○ Macros ○ Formulae ○ VBA ○ User forms Willing to share a sample of my work done on various excel applications on this platform. Looking forward to hearing from you. Thank you BAVarun PS: Please have a look at the reviews given to me on this platform. PPS: The price indicated in the bid is generic in nature. It may change basis on the scope of work post our discussion
$120 AUD en 7 días
4,9 (25 comentarios)
4,8
4,8
Avatar del usuario
Hi there, I have a basic understanding of what is needed fron your description, we need to pick data from various CSV and Excel files prepare an input data sheet then use formulas and macros to get you desired output and further make it presentable using Pivots Graphs and power Bi. This we can definitely get done as per your satisfaction. We are a team of trained professionals with years of experience in Ms Excel VBA and Power BI. Hit us up and we can talk in detail. Regards, Nikita And her team at Affiliazion
$194 AUD en 3 días
5,0 (25 comentarios)
4,5
4,5
Avatar del usuario
Hello. From your job description I have learned that the requirements you have asked for are possessed by me very well. I am a graduate of computer science. Also, I have several good records in this field as I have been working in this field for about 6+ long years. I have Great experience in Data visualizations, building dashboards using Excel, i am proficient in VBA, Gscript e.t.c I have great expertise on Data entry and excel and Analysis. also have proficiency in MS office, Google analytics and QuickBooks and 10-Key KPH typing speed with zero errors. Working with me will surely bring you many good as I am very creative and persuasive in nature. Also, I can handle things diplomatically with full professionalism. With full guarantee, I can assure you the deliverables you have asked for in the job description. Regards Atemenu .D
$60 AUD en 1 día
4,9 (12 comentarios)
4,1
4,1
Avatar del usuario
As an expert i can help you. Hi i am an Excel VBA , Macros Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platfrom give me a chance to show you the best i can do at your service.
$225 AUD en 2 días
4,9 (32 comentarios)
4,2
4,2
Avatar del usuario
Hi, I have 10+ years of experience in VBA programming , Database management (SQL Server) and data visualization (Tableau, Birst and power BI). As per requirement I can provide you the end to end solution that will take raw file from multiple sources as input and provide you the final result . I have expertise in power query and all the ETL process to be done in that. If interested , we can connect via chat and get started. Thanks Shivani
$90 AUD en 5 días
4,6 (29 comentarios)
4,1
4,1
Avatar del usuario
Hi, I have read the project requirements and ready to work. I am Certified MS-Excel professional with 7 years of experience in this field. My Expertise include: Data Analysis Financial Dashboards Financial Modeling Report building Conditional formatting Pivot tables Complex Formula building Referrencing I am Also Certified Cost and Management Accountant have Associate membership of ICMAP Thanks
$50 AUD en 1 día
5,0 (6 comentarios)
3,0
3,0
Avatar del usuario
Hi, I have been working with power query and power pivot for 5 years now. the task you require is my daily task at my office work. I am a professional data analyst since 2016. I hold both data analysis and machine learning degrees
$90 AUD en 7 días
5,0 (5 comentarios)
2,4
2,4
Avatar del usuario
Hi there. I'm a senior Excel VBA expert. I have rich experience in Excel VBA and have developed a lot of Excel VBA projects before. If you want see my past Excel VBA projects, I can show you its. Please message me. Best regards
$150 AUD en 2 días
4,4 (2 comentarios)
2,0
2,0
Avatar del usuario
Hello, I am a data science engineer andI have 4+ years of experience. Looking forward to work with you. Regards,
$45 AUD en 2 días
5,0 (1 comentario)
1,2
1,2
Avatar del usuario
Hi, I will perform an accurate web search to collect the required information according to your requirements. Let's start with a few examples for a quality check and fix the best budget for this project. I am a professional web researcher and data entry expert. I worked on many similar projects. I will deliver 100% accurate results according to your requirements. I've over 7 years of experience in working on different projects on this platform. Let's discuss further to get started with the project, awaiting your prompt response :) Thanks & Regards nazmul
$200 AUD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, I'm interested in your project. I have 3+ years of experience in data analysis with Python, SQL and Excel. So I'm familiar with Excel formulas. Hope for more details and good cooporation.
$220 AUD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
We can make it done with our expertise and work experience of the past. The result would be outstanding and you will not be facing any kind of error.
$210 AUD en 7 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Beaumont Hills, Australia
0,0
0
Forma de pago verificada
Miembro desde abr 17, 2020

Verificación del cliente

¡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.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 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.