Find Jobs
Hire Freelancers

I need an Excel expert

£20-250 GBP

Suoritettu
Julkaistu lähes 5 vuotta sitten

£20-250 GBP

Maksettu toimituksen yhteydessä
Accounting Excel Project - transferring figures from raw data sheet (new figures and combinations every month) into a monthly Overheads MM/YY file in order to get away from manual checking and "Edit links" as this process does not pick up new data. Full Excel task project written up on Word file is attached!! The below is taken from the full Word file. """ The aim of the project: At the moment, this process is done through “Edit Links” function on the Data tab for the Actual figures which is picking up from the raw Essbase data sheet. But it can only edits links for the GL and Cost Centre lines that I already know about. The current sheet doesn’t know of any new GL/Cost Centre combinations that can come into play in a new month. The new aim is to create some sort of automated process so every new month in a relevant month’s Overheads MM/YY sheet, I should be able to pick up the numbers from the “Overheads ESSBASE” Raw data file by doing some sort of Drop down list function, Macros/VBA code, etc. so I don’t have to look for new G/L code AND Cost Centre combinations manually. Tip: You may not need to work with all the columns back on the “Copy of Overheads ESSBASE unsuppressed” sheet because if you look at the SUM of some the cells along Row 27, it comes to ZERO. So maybe hide or delete those columns so you have less columns in the way of the task. The ultimate aim is to match the total of the figures in the “Copy of Overheads ESSBASE unsuppressed” sheet just against Order number 582Z1MAOVH11 which comes to £2,910,368.69 (total sum of cells E29 to IT1572) The total of Column X back on the Copy of Overheads Jun-19 sheet (Cell X168) comes to the amount of £2,791,953 and as you can see it is lower than the Unsuppressed sheet total (by £118,415.69) which is where the problem is…. I want to capture everything from the raw sheet into the main monthly Overheads sheet (which I will perform monthly) so that the totals match exactly. It could be as simple as V-Lookup or INDEX/MATCH formula or drop down list button but it could also involve MACROS/VBA Code. I’m not sure what the best solution is so this is why I need your help. """
Projektin tunnus (ID): 20010661

Tietoa projektista

26 ehdotukset
Etäprojekti
Aktiivinen 5 vuotta sitten

Haluatko ansaita rahaa?

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
Myönnetty käyttäjälle:
Käyttäjän avatar
hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myself for this project. please contact with me. Thanks.
£60 GBP 1 päivässä
4,8 (33 arvostelua)
5,1
5,1
26 freelancers are bidding on average £107 GBP for this job
Käyttäjän avatar
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
£220 GBP 4 päivässä
4,9 (362 arvostelua)
8,0
8,0
Käyttäjän avatar
Hi, I am an Excel expert. Please refer my portfolio for Excel projects here: https://www.freelancer.com/u/best4best?w=f I am good with using INDEX/MATCH/VLOOKUP functions and macro to match the data. I believe I can match the total of the figures in the “Copy of Overheads ESSBASE unsuppressed” sheet just against Order number 582Z1MAOVH11, and also create an automated template for this. Please share the files. Regards MS
£100 GBP 2 päivässä
5,0 (208 arvostelua)
6,6
6,6
Käyttäjän avatar
Hello there, I am an Excel expert with over 300+ project 5* in excel VBA. I read your docx and you do not attach the file so I can not see it but I can do it for you. Base on your document, I think with my Finance experience and SAP too I can do it for you. Please contact me and share material. I can start right now. The price can be reduced no problem. Thank you.
£250 GBP 5 päivässä
5,0 (198 arvostelua)
6,3
6,3
Käyttäjän avatar
Hi, You won’t make the right candidate selection without knowing what your project on transferring data from raw data sheet to monthly overhead files for the purpose of automation will look like. Fortunately, I can show you how your job will look like before you award the project. I have vast experience working on similar projects and I am confident I can exceed your expectations. I am passionate about flawless results and I can assure you of a job well done. I am ready to start working on the sample right away. Will you be available for a quick chat? Thanks for your time.
£150 GBP 4 päivässä
4,9 (62 arvostelua)
6,5
6,5
Käyttäjän avatar
Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes etc. in excel VBA. I also have expertise in Manipulating and Exchanging Data in Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I have done mostly Excel VBA Programming jobs. 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
£120 GBP 5 päivässä
4,8 (77 arvostelua)
5,4
5,4
Käyttäjän avatar
Hi Your Excel Specialist here. Graduated recently from California, USA; I have been doing numerous marketing and research projects. I feel I will be comfortable to work with you and perform tasks as per the quality standards with revisions as per the demand. I have done my internships in Canada Australia and United States. As having experience, I can provide you the best content as per demand. I am strategic, goal oriented, and always work with an end goal in mind. I have been creating unique, interactive, and beautiful content for over 2 years and have worked for clients and companies around the world--And sometimes I do designs just for myself :) I have command over different academic referencing styles including Harvard, APA, MLA , Oxford and Chicago. I am able to write and carry out extensive research in different areas and provide quality work as per client’s requirements. My clients range from undergraduate to PHD. I have covered different academic fields including business management, HRM, organizational and business strategy, Marketing, Medical, Nursing and International relation. I am also specialized in social media content, website content, blog, advertising material, and sales pages. Providing unique content consistently is not an easy task, especially on a variety of niches. Feel free to inbox for more details and budget. Regards
£100 GBP 3 päivässä
4,9 (13 arvostelua)
4,8
4,8
Käyttäjän avatar
Hi. Great app writer for your projects. I have writen excel app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile
£60 GBP 2 päivässä
4,8 (35 arvostelua)
5,1
5,1
Käyttäjän avatar
You do have a task at hand, I do have skills in data processing, entry, accounting, excel and analysis that drew my attention to your project. I am more than ready to help you with the task at hand. Thanks as I look forward to help with the tasks you have. I am more than willing to help and begin with the project as soon as you chat and share more details of the project. Thanks
£230 GBP 7 päivässä
5,0 (2 arvostelua)
3,3
3,3
Käyttäjän avatar
I am experienced in excel, data entry, ms office, PPT, data entry and ensure that tasks are done efficiently and effectively. I want to use my skills in ensuring that this problem is resolved. Relevant Skills and Experience This project will be resolved and i want to further discuss through this platform.
£111 GBP 3 päivässä
3,2 (12 arvostelua)
4,2
4,2
Käyttäjän avatar
Dear Sir or Madam, I am South African based Accountant with more than 20 years of experience in Excel. I am comfortable with the use of Charts, PivotTables, converting documents from PDF etc. Can you possibly provide the Excel sheets so that I can get a better understanding? Regards Phillip
£150 GBP 7 päivässä
5,0 (6 arvostelua)
2,9
2,9
Käyttäjän avatar
I'm new data entry freelancer but I've 19 years experience in dealing with MS Office and web searching, I can provide free sample and I've the ability to get job done at time , willing to cooperate with you Shaimaa Ali Best Regards
£20 GBP 1 päivässä
5,0 (3 arvostelua)
1,3
1,3
Käyttäjän avatar
Hello, have a lot of relevant experience, looking forward to work with you. Expert in: ☆ VBA ☆ (Excel, access) ☆ C# ☆ SQL ☆ Google script ☆ Python Quality and problem oriented solutions guaranteed. Experienced with different kinds of databases and languages. ☆ Professional approach ☆ Attention to details ☆ Customer friendly ☆
£100 GBP 1 päivässä
5,0 (2 arvostelua)
1,4
1,4
Käyttäjän avatar
Hello, I am a Data entry expert with excellent keyboard typing skills and proficiency in using MS Word, Powerpoint and MS Excel. I am keenly interested in this project, I will do this accurately and efficiently. I will be looking forward to hearing from you.
£20 GBP 3 päivässä
5,0 (3 arvostelua)
1,0
1,0
Käyttäjän avatar
Hello Dear !!! I have gone threw your project description . After understanding all things and situation i can help you easily because I am currently working as Business analyst in MNC company. My work is to maintain reports, leader ,making business analysis reports and compiling reports with the help of Excel and VBA. May be I am new at freelancer but I have a great experience of 5 years in MS excel and Visual Basic Application. Your Trust is my earning !!!!!!!!! Regards Prateek Mishra
£90 GBP 2 päivässä
5,0 (1 arvostelu)
0,7
0,7
Käyttäjän avatar
Dear Sir I have seen your doc file and i understand the working. I am proficient in Excel and can do your work with in time line. Give me one chance to attached with you. i will give you good result. Thanks Pankaj
£83 GBP 3 päivässä
1,1 (2 arvostelua)
1,1
1,1
Käyttäjän avatar
Hello I have gone through your project description. I will fulfill your requirements according to your project. I am a very good and helpful assistant, very fluent in languages and especially available all the time. I would be glad to take up the project. I will make sure the work is done in stipulated time. Looking forward to start a chat with you. Kind regards
£30 GBP 2 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
£150 GBP 3 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
yours expert is here, I'm graduate in ACCOUNTABILITY AND ESPECIALLY IN TAX ,let's do it I can do that
£33 GBP 4 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
Hi,. This is Rachendra Gunjal. I am from India. My location is Vashi, Navi Mumbai. I have great e experience into accounting, finance and advance Excel also. I will cover project in stipates time.
£150 GBP 4 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
I'm a public accountant and data scientist with experience in recommendation systems, deep learning and machine learning algorithms.
£33 GBP 5 päivässä
0,0 (0 arvostelua)
0,0
0,0

Tietoja asiakkaasta

Maan UNITED KINGDOM lippu
Ilford, United Kingdom
5,0
1
Maksutapa vahvistettu
Liittynyt kesäk. 16, 2019

Asiakkaan vahvistus

Kiitos! Olemme lähettäneet sinulle sähköpostitse linkin, jolla voit lunastaa ilmaisen krediittisi.
Jotain meni pieleen lähetettäessä sähköpostiasi. Yritä uudelleen.
Rekisteröitynyttä käyttäjää Ilmoitettua työtä yhteensä
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ladataan esikatselua
Lupa myönnetty Geolocation.
Kirjautumisistuntosi on vanhentunut ja sinut on kirjattu ulos. Kirjaudu uudelleen sisään.