Build a lookup and analysis report

Hello, Nice to see another UK Freelancer. I am a fully certified Official Microsoft Office Specialist who works as a data analyst, specialising in SQL, Excel and Access. I can create interactive dashboards, databases, and custom formulas / programs for within Microsoft Office products. I can offer a wide range of business solutions such as automatic emailing, KPI’s, database creation and workflow automation, along with other services such as adhoc reporting. I can automate the importing of the spreadsheets, and create the lookup table for you, along with other coding for automation, which we can discuss. I am always free for a chat after the project for any changes that you need. Feel free to ask me any questions! EDIT: I can have this project completed by Thursday night, but I would be unable to start work on it until 4PM today (10/01/2017). The price is negotiable, if there is less work than anticipated then it can come down. Kind regards, Arran Mercer

Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who 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, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working sample work before you consider awarding me the project. Thanks, Jay

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply

Hi, I am good at Excel and vba. Plz provide me the details further to get the scope of work. Looking forward to discuss in the chat.

Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporting. In fact, over the last MONTH , I have spent at least 225 HOURS on automation in Excel. . I can get your work completed to your fullest satisfaction. Looking forward to hearing a positive response from you. Thanks in advance! Have a Great Day! Srinivasan Krishnamoorthi

A proposal has not yet been provided

Hi, I am a highly skilled Excel freelancer and its a pretty simple task to do in Excel, using VB at the backend. Please invite for discussion and send the sheet via chat. I shall be able to complete the job within a day. On the click of a button, your required report shall be generated which will show the billing details. Thank you, Usman

Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Please send me more details so that I can estimate cost and time better. I have completed more than 300 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.

Hello, I am Excel and VBA expert. Can you give more details? Can I see the file? Please note that I have 100% completion rate and 5-star feedback on 50 projects.

Hi, Experienced Excel Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience Manipulating Data from Multiple Sheets, Advanced Formulas such as VLookup, Conditional Formatting, Validation, Critical Programming, Developing System for Management and Creating Reports. I have done mostly this type of job where data manipulation is required. Please check my portfolio to see my work. Ready to start please reply soon. Thanks, Virendra

Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and portfolio. With over 8 years of cross-functional experience, and helping clients world wide with diversify team, I provide genuine and innovative solutions as per your circumstances and requirements. I am MBA-Finance, M.A-Economics, and Qualified Chartered Accountant. If you feel to discuss more before you award me the project, you can send me the message. Kind regards, Rakesh

We have team who are expert in excel and have been involved extensive excel training and inolved in it for the past three years. Looking forward to your reply

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

- Can build the lookup table and have the billing generated on click of a button using macros. - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Excel macros - I have done complicated data processing using Excel macros for Exam sheet evaluation, (Recent)Circuit designing based on mulitple wire models, amps/voltages, calculations of taxes for Canadian citizen based on tax slabs per Fed and Provincial tax, based on the salary ranges etc. - Outlook macros - - Samples - Extracting mail contents parsing and sending to different customers, getting the task and calendar events from Outlook to Excel - Pl. review my portfolio on recent projects. My Skills: - I have good skills in Excel automation and used 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 - Outlook automation - Performing different actions - extracting, modifiying mails in Inbox, retrieving calendar, tasks or scheduling.

Hello, I can automate this task with VBA for Excel macros. My macros are always very flexible, detecting last row, column etc., letting user set some custom values for macro to process. Also incredibly efficient. I am always ready to make suggestions. I worked as an insurance company employee for over 5 years and used VBA macros to make my work easier. At this very moment, as a full-time freelancer, I have several macros for personal use, so I am very experienced in simplifying repetitive tasks. I look forward to hearing the details. Regards

Greetings, I am professionally qualified Accountant from Sri Lanka with A degree in Management & Finance. I am a full-time freelancer. I have 13 years of experience in Audit, Accountancy & Secretarial related in the corporate sector. My duties included Invoicing, Quotations, Purchas orders, Bookkeeping Including preparation of chart of accounts, Audits in branches, Unit costing, Cost departments, Selling price evaluation, Pricing for tenders, Audits, Budgeting, Variance Analysis, Financial Accounts up to year end Accounts, Management Accounts, Unit costing, Payroll, HR, cash flows, Project appraisals, Etc. I am familiar with web based accounting systems, Quick Books & MS office, especially with Excel. I have the experienced in handling logistics, Inventory, Etc. I have the experience in dealing with financial institutions, government processes by working with high profile managements in all sectors. Hopefully, my skills meet your requirements. Look forward to discussing with you the opportunity further. Kind regards, Dilip.

Hi, I am a native English speaking Finance professional with over 15 years experience using Excel. I can help with your project. I have built numerous Excel models for financial reporting and analysis. I have advanced Excel skills including using LOOKUP functions and pivot tables. I would propose to complete your project by firstly understanding the 2 spreadsheets you import, and then I would build the lookup table to bill people accurately. I could also include an invoice template in the spreadsheet, if you liked? I can then also prepare an automated report for month end reporting. (I could also provide a template for yearly reporting, if required? or a monthly report with year to date values?) I welcome the opportunity to discuss further and to work with you. Regards Melanie

A proposal has not yet been provided

Hi I am an Microsoft Excel Expert and can work on data analysis, cleaning and sorting. I can use macros, slicer, power pivots, dynamic drop downs, data validation and customized functions to create the sheets according to your needs. I can start right way. Please view my portfolio for my previous work. Regards Aditi L.

Hello I am a programmer. It is available both Visual Basic and delphi. I have some work, in an Excel spreadsheet. We aim to serve you with quality and commitment to accuracy. i will use formulas of excel and i will done your task on the time. Thank you,

Hello I am a programmer with 3 Years of experience in Excel/Access /google Sheets VBA and Web scraping with local companies, my projects vary from automating excel sheets "then sending results to Power point presentation or send via mail" to web scraping Amazon and EBay and to creating an Access Warehousing Database I have automated many excel sheets with extra complex equations and formula