Excel Macro - Data Analysis

Hi, in general this is not complicated, and its actually common request, but i would like to see an actual sample. If you are interested in working with me, feel free to provide a sample key sheet, and few input sheets, and i would be happy to take a look. Thanks, Milan

Hi, Greetings! ✅checked your project details: Excel Macro - Data Analysis ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion.. Thank you Sandeep Digital screencast

Greetings! Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. Please share the files - I would come up with a macro that generates a consolidated output as required. I have 20 years experience in using Excel as part of my daily work life. Over the last 30 MONTHS , I have spent at least 200 HOURS on automation in Excel every month. Have a Great Day! Srinivasan Krishnamoorthi

------------------I CAN START RIGHT AWAY WITH 100% ACCURACY------------------- Hello sir, I can build a VBA macro program to consolidate your data from 10 spreadsheets to a single master file using VLOOKUP and Advanced Formulas by maintaining 100% accuracy of your data absolutely as you want. ------- VBA Macro Coding, Formula Generation and Automation process expert with 5* ratting. I can start right now, please message me to discuss more. Regards, MA Hossain

Hi, As I understand you are looking for Excel macro to take into consideration key spreadsheet and 10 other spread sheets and give the output as consolidated sheet. Please share more details on the requirement. Sample spreadsheets will be of great help. I am well versed with writing macros in Excel, Word etc.. I have used written macros extensively for Excel, MS Word, PowerPoint etc. for automation of various tasks. I have done good amount of work in Excel macro handling. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, sending email through Outlook, Image handling, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc.I have also handled various Excel tasks. It includes creation of formulas using arrays, Pivot table creation, Creation of graphs, Filtering, Removing duplicates, Data analysis, Data entry works, etc. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks

More than 10 years of experience doing this. Just send me a message and we start with your requirement.

Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within 1 day

Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour and compare the variables in the data. I can do advanced level analysis in SPSS, R, PYTHON, WEKA, TABLEAU, POWER BI, and EXCEL tools like machine learning, deep learning, AI, NLP, hypothesis testing, forecasting, T-test, ANOVA etc. Looking forward to discussion, Best Regards, Suyash

NOTE : I HAVE EXPERTISE IN EXCEL AND VBA. I CAN COMPLETE THIS TASK IN QUICK TIME With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT experience. I have successfully completed projects which involved Programming, scripting, excel macros. Key features of my work are as follows: 1) Always within schedule 2) Always within scope 3) Best tools and techniques used for the completion of tasks Looking forward to hear from you. Regards

Hi, I am farrukh. I am working with excel for over last 2 years including vba macro. As you said you need a macro to create a consolidated workbook from a key worksheet and other 10 worksheets. I have done many vba projects in past including sending emails from excel file via gmail. or creating html file with vba feeding body text of html from the excel file. I am also a Microsoft office specialist Master and i will provide you a genunie and 100% satisfactory work. Can you please share more details with me. I am looking forward to your positive response. Regards Farrukh

Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files (or the folders containing them, as required by the job) and hosting command buttons and other controls if necessary (e.g. your values to lookup). In my approach you'll have an opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I am a full-time freelancer, I can start working on the project immediately and complete the job within one, maybe two days. If you send me a sample file and a job specification, I'm ready to create a free draft pilot for you. Regards

hello! I can help you with your project. Just share with me the spreadsheets and I will take care of the rest. You can be assured of a high quality and accurate output. I hope you will consider me, thanks!

Hi there, Looking for a macro/VBA that will get, count, or consolidate each value in the key spreadsheet from multiple workbooks and/or worksheets? Please message me if this is any of what you need. I’ll be standing by to help. -Reggie

Hi there, I have good experience creating tools in VBA that will give the results you want to consolidate data from 10 different sheets. Can you give a sample of the key sheet and the search sheet. What are the data you want extracted? Best regards Reuben

Hi, can you please send me your excel file? Let me try it. And if I have any question, I'll ask you a question. I'm waiting for your reply. Thanks

Hi there, Yes sure. Expert in data processing. Have strong command over excel in Python. I write Python codes where excel macros fails. Will deliver standalone tiny tool for your task. Less than one day work. I could be the best candidate! Best regards, Ishaq

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. I will start immediately and complete it within a day. If interested, we can discuss this further on chat.

Hello. I'm a specialist in Excel and macros programming. I can handle a project like this, with several different sheets.

Hello, I understand that you want a list of 'key' values in a spreadsheet matched against certain amount of data distributed on another 10 spreadsheets and have relevant information from the matched rows collected. I believe that I can perform the task using VBA to complete the job according to your requirement. Would appreciate the opportunity to know the job in detail and work with you on the project. Sincerely, JM

Hi, I have gone through your project placement & it matches my expertise, I understand that you are looking for an expert in excel. My Profile: https://www.freelancer.com/u/muhammadumar84 EXPERIENCE: 13 Years EXCEL: I can automate processes, make Fully dynamic, Real time updating Financial Reports, Models & Dash boards through formulas, Pivot tables, pivot charts, Power query, Power BI and Macros. I can easily apply complex formulas including Lookups, summarizing and conditional functions. Compiling Data from different sources, cleaning and transforming it to a standard form in most efficient way for optimal integration with advanced excel features, analyzing and then Reporting in a presentable way is a routine. You can expect a very professional outcome. FIELD: Financial & Management Reporting, Financial Analysis, Forecasting & Budgeting TOOLS: MS Excel, Word & PPT. PPT: I can shape ideas into a perfect presentation. From designing of themes, adding transitions to slides, animating the objects and finally putting up a convincing slide show. WORD: I can Write & Edit professional documents & communications, Create designs or mock-ups for printed materials, Format documents, Proofread with Microsoft tools, Incorporate graphs or charts into reports or other documents & build templates. Looking forward to your Response Regards

Hi, We have worked on several excel data and macro projects. We have worked on several projects wherein there were interactions with many excel files was required for fetching the data and comparing and creating dashboards. We would be happy to help you with your work. Kindly share the file and project details so that we can discuss further and start the work. Thank you.