Excel data tool

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep

I would like to suggest to you a Microsoft Excel application which enables you to manage databases of records in a spreadsheet. The app allows you to import records from external files and conduct a central database with the records. Also, I can add a search engine with high search capability to find specific records. During the reporting process, Excel validates the information and prepares reports and documents (by Pivot Tables)based on the needed parameters and criteria. There is a report generator which enables to develop templates independently. I am a financial expert and guru in Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. Furthermore, I have experience in dashboards, financial reports, accounting, consolidating, forecasting, budgeting and cost acquisition based on inventory, bill of materials, collections, payments, and bank reconciliation. With these skills, I develop financial modules with incorporate complex components of business in a simplified and logical manner.

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, they speak for themselves. Best regards

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Ok. Sure. I will employ VBA to do the vlookup and result creation. Willing to take up your project. Thank you, Regards.

Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you for further discussion. Kind regards Rina

Hello, I am Excel and VBA expert. Could you give more details and send the sample files? If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback on over 80 projects. Jan

I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance - Built a POS and inventory management system - Built a delivery schedule for pick-up and drop of raw-material under given constraints optimizing the utilization of available resources - 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 hotel price comparison that pulls data using the website's API - Scrape various websites like tennisinsight, pubmed You can see the reviews of the same in my profile Thanks, Archana

Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I suggest you to use VBA Programming that will give you extensive and flexible functionality and more accurate and specific results. I can create vba program to achieve your goal. 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 message me to discuss your project in more details. Thanks, Virendra

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction

Hi, I can successfully finish your project either with pivot tables and formulas or with VBA scripts. 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) as an Industrial Engineer at Michelin Romania . 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.

Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.

Hi, I am an excel vba expert and i went through your project description. I have worked on many similar projects like these where a single database is created by extracting data from multiple locations. Going through your problem, we would first want to create a setup where the data automatically gets stored in the database by a click of a button. Even when new data is updated in the 6-7 sheets, the database will continue adding data from the last update. Then we would need a search bar where you can search for any client from the database based on different conditions. Thanks Sajid

MS Excel advanced expert. 30 years experience in MS Excel. VBA programming. Data mining and analysis, stochastic simulation, discrete event simulation, Excel Solver, genetic algorithms, neural networks and other advanced models. I have a high performance desktop computer with which I can deal with extremely large and complex worksheets.

Hi Nice to meet you. I have enough experience in python script. Below the libraries are I used in past project. pandas, matplotlib, lxml, beautifulsoup, scipy, and other useful libraries. I have written some automation and scraping, scientific scripts. I can help you to automate excel file. So I think I can help you in your project. Just let me know if you want start job. Regards. Lian

Hello. I have recently completed very similar project using VBA with 100% positive feedback : https://www.freelancer.com.ru/projects/project-18646362/ Your task can be completted during 1 day.

Hi Good Day! A serious freelancer here! I can help you to complete this project in 3-4 days. I have a lots of available time for this work, but need to know the full requirements to assess how long would it take to complete every project. Please accept my bid and I promise to show you my expertise. I am a VBA macro developer for over 8 years now and has strong knowledge with Ms Excel Formulas and Functions. I created different template and tools for financial reports. I am also a Project Management Analyst that focused in Financial and Metrics report and analyzation. Feel free to message me to discuss more about this project. Hope you will consider me to this project, I'll promise to give you the high quality of work. You can check my portfolio for some of my previous project in Ms Excel Macro Thank you!

Hi, I would to offer my services for your project Excel data tool. I am an India based accountant having more than five years experience and also expert in Microsoft Excel including complex formulas and VBA or Macros programming & development. I am having experience in Global Accounting and Taxation as well. Most of jobs which I have performed so far are for the clients/employers based in India, US, UK, UAE, Australia,New Zealand. I perform variety of job including following:- *Bookkeeping *Accounting *Taxation *Payroll *Financial statements *Financial modelling/Projections/Forecasting *Business Plan/Business writing *Process Development *Dashboard Development *VBA or Macros development *Data Processing/Data Extraction/Data Entry I am having working exposure and experience in numerous accounting software such as:- *Xero *MYOB *QuickBooks *ZohoBooks *Tally *Banana *SAP *Odoo I am also having good experience in Accounting Software implementation and integrations job. Looking forward to a successful cooperation with you. Kind Regards Gopal

I can do the job. I would use mostly VBA unless pivot table or standar formula are more suited. What file format do input data come in, excel? I'm an engineer with advanced working knowledge and experience in Excel and VBA including interaction between different software (Word, Excel, Powerpoint, Access, MS Project, Autocad etc.), web scraping, Access DB design, management Dashboards, stock and financial worksheets, KPI's, proficient coder in VB.Net, C#, Python, JavaScript (google sheets), VB6.

Hi, Any updates from you regarding this project? Kindly send me the details Thanks regards Thushara

This is what I propose to you: * You can enter as many client IDs as you want to check. * You can configure the tool to look in any number of files. * Once you have input the IDs, you can click on the "CheckIDs" button to have a report of whether the ID is found or not and in which file. Question: * What is the format of the files? Assumption: * The files have the same format and in text format. Schedule: * The tool can be built over the weekend using Excel and VBA. Looking forward to hear back from you as I would like to share a screenshot with you on how the tool will look like. --- My experience and past works: * 12+ years in IT as a developer, technical lead and business analyst * Please check my freelancer.com profile for more positive referrals.