Find Jobs
Hire Freelancers

Build Excel Macro

$30-250 CAD

Cerrado
Publicado hace más de 5 años

$30-250 CAD

Pagado a la entrega
Process daily store sale summary report from text file format into excel database. Based on the excel database stored data, able to search data to analyze sales data by each category by day, by week, by month and generate report and charts. Report need to be intelligent to show where the sales are good and weak. Need report for ordering item based on sales.
ID del proyecto: 17560610

Información sobre el proyecto

49 propuestas
Proyecto remoto
Activo hace 6 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
49 freelancers están ofertando un promedio de $188 CAD por este trabajo
Avatar del usuario
HI, I am good at Excel and vba. I have referred the requirements. Please share the excel file with the sales data to analyze it further produce into useful reports. Looking forward to work on the project. -Chandra
$200 CAD en 3 días
5,0 (945 comentarios)
8,1
8,1
Avatar del usuario
Hello, I can help with you in your project Build Excel Macro. I can assure you the quality job as per your expections. I have more than 5 years of experience in Data Processing, Excel, Microsoft Access, Visual Basic, Visual Basic for Apps. We have worked on several similar projects before! We have worked on 380+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$200 CAD en 3 días
4,9 (376 comentarios)
8,1
8,1
Avatar del usuario
Hi, I am an Excel macro expert with more than 10 years of experience. Kindly share further details and we can discuss. Regards, Arul
$250 CAD en 3 días
5,0 (223 comentarios)
7,4
7,4
Avatar del usuario
Hello! My name is Paris Pallas and just had the chance to read your project's brief. I was very excited that you mention Microsoft Excel because this is my favorite field and MS Excel projects are among the tasks I work with regularly and know exactly how to handle them. You mention that you need somebody to enter data from a text file into an Excel workbook and analyze sales on a daily, weekly and so on a basis. This can be achieved by using Excel charts of several types. I'm a very experienced and skilled MS Excel developer as you can easily check for yourself. You're welcome to visit my personal page on this platform and get an idea of who I am and what services I deliver to my clients. I never ask for any payment in front. I claim the milestone release once the project is completed and my client is happy with the result. I'm looking forward to hearing from you. Sincerely, Paris Pallas
$200 CAD en 7 días
4,9 (313 comentarios)
7,7
7,7
Avatar del usuario
Dear Client, I can build the macro for you. Also the dashboard you are looking for. I have vast experience in excel and have already done lots of projects. Please contact me. Roy
$200 CAD en 3 días
4,9 (411 comentarios)
7,1
7,1
Avatar del usuario
Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your MS-Access program. Please give me more details about your project. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
$35 CAD en 3 días
4,7 (92 comentarios)
7,3
7,3
Avatar del usuario
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
$200 CAD en 5 días
5,0 (272 comentarios)
7,1
7,1
Avatar del usuario
I have excellent command on MS Excel and can create a report as per your requirements. I have completed complex projects in Excel before . For instance - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API You can see the reviews of the same in my profile Thanks, Archana
$180 CAD en 3 días
4,9 (93 comentarios)
6,0
6,0
Avatar del usuario
Hi I understood your task. I placed here my bid to make it for 750 cad and it will be a proper price if you really want to have a very useful and simply for using software - I can code that via Excel or via Access , which of ways you will prefer. Do revert back to me if you interested with my bid to discuss details of your task. Regards , Zura
$833 CAD en 7 días
4,6 (57 comentarios)
6,1
6,1
Avatar del usuario
- Based on the daily sales volume details the data can be imported into Excel databse. - Reports can be generated based on the grouping Store, Category, Item across stores giving the visual representation using chart to show the performance trends over a period. - Could be made as easy to use button clicks. - Have done similar sales reporting, complex charting like scatter, surface and the normal line, bar charts. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables
$160 CAD en 4 días
4,6 (55 comentarios)
6,0
6,0
Avatar del usuario
Hi, I am a chemical engineer and I have over five years experience in using Excel at an advanced level (complex formulas, array formulas, pivot table and charts, macros and VBA scripts, automatic calculation sheets, automatic simulators and charts drawing) as an Industrial Engineer at Michelin Romania. I am always keen to improve my work quality and productivity and, to achieve these goals, I made complex Excel sheets to automate my tasks and eliminate errors. I will be glad to help you with your project and I am sure you will be satisfied with my professionalism and the quality of my work. Best regards, Florin Enache.
$230 CAD en 5 días
5,0 (22 comentarios)
5,3
5,3
Avatar del usuario
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes etc. in excel VBA. I also have expertise in Manipulating Data of Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start please reply soon. Thanks, Virendra
$250 CAD en 3 días
4,8 (95 comentarios)
5,7
5,7
Avatar del usuario
Hi, After having a look on your requirements I would like suggest you to a MS Access database. Why MS Access: 2gb of data storage with smooth and fast functionalities. Multiple user enabled keep your backend in a network shared location which only admin can access. User authentication login screen to login with various authorization. In future you can move your backend to SQL server to make it as a love database.
$444 CAD en 5 días
4,8 (26 comentarios)
5,3
5,3
Avatar del usuario
Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing and analyzing any company variables. Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards.
$250 CAD en 7 días
4,9 (31 comentarios)
4,8
4,8
Avatar del usuario
Hi, I have excellent knowledge on advanced Excel and VBA which you require most. I have 10+ years of experience doing various kind of Excel data model, reporting and analysis. Please give me a chance to showcase my skills. Thanks
$200 CAD en 4 días
5,0 (22 comentarios)
4,9
4,9
Avatar del usuario
Hi, Good Day! I am a PMO Analyst and my primary task is the creation of Financial Reports. I am exposed on different excel formulas and functions. I am also a VBA Macro developer which I think a big plus to complete this project. You can check my reviews to help you decide. Feel free to message me anytime to discuss this project. Thank you
$100 CAD en 2 días
4,9 (44 comentarios)
4,7
4,7
Avatar del usuario
I'm an experience MS Excel and vba developer, have been in this field for almost 10 years and working many MS Excelor MS Access related project. I'm also Brainbench MS Access certified. I'm confidence I can finish this project for you as requested.
$166 CAD en 3 días
4,9 (37 comentarios)
4,8
4,8
Avatar del usuario
Hi, I have completed a very similar project for an Australian company at the past. They did have weekly data for the products sold in the stores. My macro creates graphs using the data to compare a date range with the previous years data. For the given period create reports showing the products decreased comparing with the previous year. The reports are created using parameters. Please provide more details and share the files. Best Regards,
$250 CAD en 10 días
5,0 (21 comentarios)
4,4
4,4
Avatar del usuario
Hi, This is Gopal. I am a book-keeper and accountant. I have gone through your project description and understood. Kindly note that I have been working in Accounting, Tax, Audit and Finance function for more than 5 years. Hence, I have expertise on SAP, Tally ERP9, Quick Books, MYOB, ZOHOBOOKS, XERO, MS Access, MS Word, PowerPoint and MS Excel. Recording daily transaction or Book-keeping, Maintaining Books of Accounts, Reconciliation and finalisation of accounts are major areas of my job profile. I would like to draw your kind attention on few of my excel skills:- Maintaining and organizing data, Data Management, Data Entry. Formula development, VLOOKUP, HLOOKUP, LOOKUP, IF, INDEX, SUM. Pivot Table Development and Management Process Improvement Develop and implemented standard operating procedures to bridge data gaps and resolve related issues. Imported and exported data from text files, saved queries, or databases; used automatic outlining, inserted subtotals, created advanced filters, and used database functions. Designed, recorded, and executed macros to automate data entry inputs. Formatted spreadsheets and workbooks for print, document reproduction, and presentations. Hence, I request you to grant me an opportunity to serve you by executing and finishing the project giving my level best and so that I could establish myself on this platform though I am new at freelancer. Looking forward for your positive response. Thanks
$155 CAD en 3 días
5,0 (15 comentarios)
4,6
4,6
Avatar del usuario
Hi, I'm IT Engineer with over 10 years professional experience, specialised in Microsoft technologies - Office, .NET and T-SQL. Skills: VB .NET ASP .NET VBA for Excel and Access VBS Microsoft SQL (T-SQL) HTML5 JavaScript ASP .NET JSON XML Very good knowledge of Excel and Access SAP MM and SD modules
$111 CAD en 1 día
5,0 (1 comentario)
2,4
2,4

Sobre este cliente

Bandera de CANADA
Canada
0,0
0
Miembro desde ago 12, 2018

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.