Microsoft Excel Formulas Macros Dynamic Charts Visual Basic Pivot Tables

Hi, I am good at Excel and vba. I have reviewed the file, which contains similar data with sevaral tabs. Looking forward to discuss in the chat.

 A qualified accountant and finance professional possessing ‘can do’ attitude and passion to work thus yielding results for company in volatile & dynamic environment  A motivated self-starter, able to quickly grasp issues and attend to details while maintaining a view of the big picture. Expert in juggling multi-tasking and achieving on-time completion within budget.  Last but not least, having about experience of 2.5 years, starting as a trainee and then gradually moving up to the ladder to Accountant, I definitely have the right blend of skills to add value to an organization & developed my expertise in  SAP (FICO)-1 years 9 months  Proficient in MS Excel,Word,PPT & Outlook  Financial Modelling using MS Excel 2010  Profound knowledge of Accounts & Reporting  Profound knowledge in IAS,IFRS,ISA’s  XERO,Clearbooks,Quickbooks,Peachtree  SAGE 50, Profile(Self assessment & Annual return )

Hello, I am proficient with Excel and VBA and I would love to help you with this project. In fact, I recently did a very similar project with automatic creation of charts. With my experience, I believe this could be done very quick and accurate. Please contact me for more information.

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 Chartered Accountancy student and I provide a range of services majorly focusing on excel, data entry, word, accountancy and other allied services. I have been working on this platform for two years now and have got good reviews for my work. Looking at the project description and the attached file I can assure you that I can execute this efficiently and can start working immediately. I am extremely flexible with time and can dedicate more than 12 hours a day on this project. I believe in making long term relationship and client satisfaction is my top priority. Looking forward to hear from you and discus in details. Regards Jitin Goyal

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

My talent is taking large amounts of data and creating an interface that can be manipulated by the end user. I set files up so the user can run multiple "What-if" scenarios. The project as you defined it is very doable within your budget. One of my key advantages is I am a native English speaker and create Excel charts and presentations for a large Fortune 100 company, so I understand what you are trying to accomplish from a business standpoint. My plan is to provide versions of the file as I go along so you can provide corrections as needed. Here is how I would approach the project. #1 Link the worksheets to the Quickbooks report, so the file will update every time you paste new data. This could be done within a day of project award. #2 Creating historical record of the data. I will add a button (with VBA macro) to go through each tab and copy the data from column B to the next available column. We will need to add a table for each contract so you can add/delete contractors without rewriting the VBA code. #3 Creating reports. Several options here. Bar charts for net income or expenses and income. Line chart. I imagine there will be some back and forth at this stage to get you what you want. I have some other ideas that might work for a follow-up project. What version of Excel are you using? Is your plan to just copy paste the Quickbooks report on top of the existing data?

I am a professional with over 6 years of secretarial experience. 2 years of Real Estate Research and Leads. Total of 8 yrs data entry administrative experience. I thrive on organization and am incredibly detail oriented. My time management is impeccable. I’m able to multitask, efficient in Microsoft Office, Keen Typing Skills of 60-65 WPM..

Good day! I've read your project description and I would be glad to help you with this work. I have an enormous amount of experience in Excel and have received excellent ratings for my previous work (As you can see in my profile/work history). I am also happy to let you know that my schedule is clear right now to start working on your projet as soon as you've awarded it to me. You can rest assured I would get this work done for you on time covering all your requirements, if you let me handle this work for you. Thank you and I look forward to working with you. Best regards, Alex

Hello there. I have checked your attached file. First question is: how do you input your raw data? Is it an ERP export or something like .csv? I can create a very professional dashboard at which you can make your selections with dropdowns and VBA buttons. We will automatize the process. (please look at my dashboard works in my profile) Let me know if you are interested. Thanks.

Hi, I am a native English speaking Finance professional with over 15 years experience using Excel. I can set up your spreadsheet and build your reporting for you. I would propose to complete your spreadsheet by: - Setting up VLOOKUP formulas in each of your sales staff sheets to read from your Quick Books export - this would be able to be copied to any new sales staff with just a change in name. (I would enable this by including a cell at the top to enter the contractors name and initials). - Setting up a Macro to copy the data from row B to whichever row is relevant. There may need to be additional data entry somewhere in the file if names and sheets of contractors change (if you want this completely set up automatically); - Building a report that allows you to select the contractor and the weeks that you want analysed. I would propose to do this by either having hidden cells that pick up the data to analyze, or by creating a new sheet that the reports would run off. I would welcome the opportunity to discuss further and to work with you in the future. Regards Melanie

I can help you

Hello, This project sounds very familiar to what I have done for my current employer. I think the best way to approach this project is to create pivot tables around the data and create the reports and charts from those pivot tables. We can further enhance the look and feel of the report by adding slicers, graphs and conditional formatting to the reports. Please let me know exactly what kind of deliverables you are expecting and I will get to work ASAP. I am also available to talk in person about the project so we can discuss the details. Sincerely, mark

I am expert in excel and will create simplier and user friendly excel. I will do my best and fast delivery

hi, I am an excel spreadsheet expert and I can complete your task effectively and efficiently in a timely manner. Please check my portfolio to know the dashboard I have created for my clients.

Hello, thank you for reading my proposal. I am an experienced accountant and familiar with automating using VBA. I am willing to do this job at low budget. Hire me!

A proposal has not yet been provided

Hi I am 10 years experience in Microsoft Exel Formulas and VB Macro's . . .

I am interested in this project and possess the required skills.

Hi, Let handle your works to professionals. I am an engineer and expert in the field. I can guarantee 100% accuracy and quick completion of the task. You can view my reviews to assure quality of my works. Hope to hear you from soon. Thanks...