YTD vs Plan Report

Hey there, I am an expert in Excel reporting as you would see in my work history here on freelancer and can certainly create a 'smarter' setup for your purpose. I would suggest an excel macro based setup that will allow you to import the data and generate the report on click of a button. I have done several similar projects with excellent ratings from my clients and can assure you of excellent quality work. Please send a chat message to me and I would be able to explain the working of the proposed setup. Look forward to hear from you. Best Regards, Shikha

Hello Sir Im excel VBA macro and formula Expert :) i can do make macro for your sample raw data Sir please disucss for make all clear first and im able to build macro for you Thank you Sincerely Galih

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an application in Excel. I plan to use a combination of formulas and VBA code to accomplish this. The code will pop up a dialog box to select the desired Raw data workbook. Once you do, the data will be inserted in the Raw data sheet and the data manipulation will take place. The formulas will be placed, and formatting will be applied no matter how many rows are there. It will be very simple and easy for you; all you have to do is select the source file. I'm among the most experienced, and skilled Excel, and VBA developers on this platform. I have completed over 280 projects successfully in six years, and I feel confident in achieving your task as well. You're welcome to visit my page (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I provide to my clients. I will charge you $250 and can deliver within a couple of days (a single milestone to release once you're satisfied with the final result). I'm online from 8 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas

I am a financial expert and guru in Excel/VBA/Macro. I have the skills to convert external accounting databases (like  SQL SAP QB Sage, POS)  into Excel and to generator financial reports, and charts. 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, 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 including depreciation schedule, long-term debt, business valuation methodology & ratios. The modules 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

Greetings! I am a Specialist in Accounting, and excel based modeling and automation. I am keen to help you with the requirements. Look forward to hear from you. Thanks, RRC

Hi there, I understand that you require an excel based dashboard to see key metrics vs goals, highlight where the location is missing goals, how many %age of branches are missing the goals, adjustable report, printable in one page, and highlight to goal fields having "zero". I am a professional having experience and expertise in the MS Excel and can create Dashboard for all your requirements. Please visit my portfolio page to see a sample of a dashboard. We can have a detailed discussion on various parameters over a chat. Thanks.

Hello, Sir I'm an advanced excel expert certified by Microsoft, I can give you the work in less than a day or two. Moreover our team has qualified chartered accountants and other excel experts, if you are interested in hiring me I'll start the work just now.

Hello, I reviewed the files and I am interested in doing this project. All of the tasks required could be done with VBA code including the data import/export which could replace copy/paste process. However, naming of files must be standardized to make this process work properly. in any case, I could give much more info and propose more precise solution after I review the files. In any case, feel free to contact me if you would like me to do the project. Thank you for the consideration. Best Regards, Neno

I am a professor of statistics and mathematics and I was a data scientist for the past 5 years, and I have read the description of your project and I can surely handle your data according to the given instructions. You can check sample work I have done in my portfolio and my profile reviews: https://www.freelancer.com/u/freelancerpr0?w=f Please come over chat and let's fix a deal. I can surely help you with this task. Looking forward to working with you.