Find Jobs
Hire Freelancers

Excel Specialist required for accounting and sales KPI Sheets

£10-20 GBP

Completed
Posted over 6 years ago

£10-20 GBP

Paid on delivery
I have an existing excel workbook that needs various amendments. Also needed are some line graphs to show comparisons based on the figures Please show me examples of work please. needs to be completed within 1 day.
Project ID: 16146786

About the project

39 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Dear client I have previously carried out a number of projects in excel using macros and formulas. I can help you in this project. Kindly contact me for further details. Roy
£20 GBP in 1 day
4.9 (457 reviews)
7.3
7.3
39 freelancers are bidding on average £22 GBP for this job
User Avatar
Dear Sir/Madam, As one of the expert in advanced excel, I'm happy to help you on this task. Please refer my profile to see my reliability, qualifications and previous works, and if you are comfortable, lets discuss the project. Thanks Priyal
£70 GBP in 1 day
5.0 (245 reviews)
6.9
6.9
User Avatar
Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Power BI & Microstrategy Dashboards, MS & Google Office Suites, WordPress, Social Media Marketing and Touch Typing 60wpm Skills.
£20 GBP in 1 day
5.0 (38 reviews)
6.7
6.7
User Avatar
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
£18 GBP in 1 day
4.7 (73 reviews)
6.6
6.6
User Avatar
I have excellent command on MS Excel and I can complete the project within 24 hours of awarding the project Few of my past projects - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API - Built a complex shift allowance calendar and calculator You can see the reviews of the same in my profile
£25 GBP in 1 day
4.8 (85 reviews)
6.0
6.0
User Avatar
Technical Business Analyst with 15 years professional experience delivering deceptively simple solutions to complex business reporting and automation solutions utilising Excel and VBA. I am degree qualified in finance and have utilised Excel to build numerous financial reporting and forecasting solutions for my previous employer. These have included: 1. Automated balanced scorecard reports - linked data from back-end of accounting, POS, and payroll solutions to create complex financial metrics (e.g. HR spend / FTE) 2. Financial reporting suite - linking data from back end accounting package to create a dynamic financial reporting suite. Looking at the sheet you provided I can easily populate the actual forecast as required. What I did: Created a sheet called "setup" cell B3 = JL, B4 = RL, C3 = Johnson, C4 = Reemiah On the sales forecast actual tab I added I set cell P2 to be Actual Margin Defined a number of names as follows: dates ='Core Data TARGETS'!$A$2:$A$53 headings ='Core Data TARGETS'!$A$1:$K$1 pMap =Settings!$B$2:$C$4 Formula for sales forecast actual cell B7 =IFERROR(INDEX('Core Data TARGETS'!$A$2:$K$53,MATCH(D$5,dates,FALSE),MATCH(VLOOKUP(RIGHT($A11, LEN($A11) - SEARCH(" ",$A11)),pMap,2,FALSE)&$P$2,headings,FALSE)),"") This formula will also work for the Forecast Budget tab if you simply change the P2 value on that sheet to Margin Target I would love that chance to help you out - please let me know if you would like to chat further!
£20 GBP in 1 day
5.0 (32 reviews)
5.4
5.4
User Avatar
Hello, how are you? I hope you have a bright day/evening from your side. I have read the details provided, but please contact me so that we can discuss more on the project. I believe I have the required skills in this case. I will work on your requirements personally since I do not outsource to third parties, this guarantees you high-quality work that is delivered on time. You can also request for revisions till you’re fully satisfied with the work. I believe research is a passion and not a money making business where people will deliver low-quality work just to get paid. Try my services, and you will never regret. Waiting for your kind response
£22 GBP in 1 day
4.8 (18 reviews)
5.2
5.2
User Avatar
Hello, I propose that first we have a Skype call where we can freely discuss the KPIs and graphs that should be created using your data. What do you say? FYI my last VBA work includes: - tool that automatically prepares PDF invoices using complex calculations - tool that sends emails automatically for each team leader containing only his team members+custom attachment - import of one excel file within another in order to be processed following some configurable parameters - vba tools with multiple forms, transfer data between windows forms - data processing and reconciliation Don’t hesitate to contact me on chat to discuss the solutions for your project. Regards, Marius
£65 GBP in 1 day
5.0 (27 reviews)
4.4
4.4
User Avatar
1. Excel expert with extensive vba programming experience. I can help you with your charts and amendments. I can show you examples if you are interested. 2. I have worked for several years in excel and perform daily work using vba, user forms, pivot tables, formulas, etc. 3. I would start by committing to 1 day but this depends on the scope and could change 4. I have an extensive background in Excel. I would love to know more about your project.
£28 GBP in 1 day
5.0 (1 review)
3.8
3.8
User Avatar
I'm a Chartered Accountant and a CFA Level-1 Pass out based from India. I have around 4 years of experience in the field of Accounting, Financial Planning, and Audit. I have worked with Excel for around 4 years now. I have looked at the Excel spreadsheet uploaded by you.I understand the "Core Data target" is the basis for all the further calculation. I have changed the way data goes to Sales budget sheet and Actual sheet. I have used a Simple formula "sumifs", to take data from Input sheet to the next sheets instead of manual linking. This saves time as well as energy. I Cannot attach the document as Freelancer doesn't allow me to. I Consider my Client's satisfaction as the ultimate. I know you will get many low-cost bids but please consider the quality of the work as well. Feel free to message me in case you need something. Thanks and regards Akshay Rajan
£18 GBP in 1 day
5.0 (7 reviews)
3.0
3.0
User Avatar
EXCEL EXPERT TO CREATE KPI SHEETS AND ACCOUNTING SHEETS HAVE KNOWLEDGE OF ACCOUNTING TO DO THE WORK WILL ENSURE THE QUALITY IS ASSURED
£13 GBP in 1 day
5.0 (6 reviews)
1.6
1.6
User Avatar
I am good with numbers & Excel. Being a Business Analyst myself, I have worked on KPIs and reports extensively, experience which would come handy in this project.
£18 GBP in 1 day
4.8 (1 review)
1.5
1.5
User Avatar
HI MY NAME IS PRATAHM PANDEY I AM INTERESTED IN YOUR PROJECT AND I WOULD LIKE TO WORK WITH YOU . I WOULD LIKE TO TELL YOU I AM PRETTY MUCH GOOD AT TYPING .
£18 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have gone through your job details and I am interested in working on it. I can help in analyzing data in a meaningful way that will provide great insight to you. I myself is CFA charter holder and I have more than 8 years of work experience in financial modeling and analysis. As a freelancer for the last 2 years on another platform, I have completed many tasks of financial modeling, project finance, and investment and data analysis (Regression, T-tests), fully dynamic financial modeling projects for UK based property developer and Hotel build and lease project in Dubai and Poland based property developers - both residential and commercial projects, 3 statement financial model, valuation of fixed income products such as convertible bonds, preparing amortization schedule and Cap table and quantitative data analysis (analysis and valuation and backtesting of derivatives portfolio) etc.. I consider my skills in financial modeling and analysis at an excellent level. Thanks Hemal
£28 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there, I read the job requirement and understand the project. I have an experience in this work over 3 years. More details on chat. Have a good day. Thanks.
£18 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am expert in Ms Excel. I worked several years in management control of many banks with this tool and i know how to master it. In addition, I have an economic backround.
£13 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a Qualified Chartered Accountant. My articles are from Pwc (PricewaterhouseCoopers). I am currently working in Real Estate company. I have 5 year experience of working in Finance department and I have advanced excel skills. I have hands-on experience of preparing reports for management use.
£17 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Iam Shankar Tatode From Nasik India. Iam Marketing Professional. I have work experience of 8 years. By education MBA Marketing & Bsc chemistry. Iam ready for work with passion & enthusiasm.
£20 GBP in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I HAVE A EXTRA ORDINARY KNOWLEDGE IN EXCEL. I LOVE TO WORK IN MS EXCEL VERY MUCH.I ALWAYS TRY TO MAKE EXCEL ATTRACTIVE PAGES FOR ANY SPECIFIC WORK
£18 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am very dedicated towards my work. I can perform my task as per time constraints. My objective is to be a Finance or Audit Professional in a reputed, dynamic, ethical and socially responsible organization, growing individually and professionally with and within the organization through Professional Development, Career progression and a continued dedication & attitude towards excellence.
£20 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
£18 GBP in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
South Woodford, United Kingdom
5.0
33
Payment method verified
Member since Nov 15, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.