Find Jobs
Hire Freelancers

Excel Function Creation & Data Organization

$30-250 USD

Imekamilika
Imechapishwa 4 months ago

$30-250 USD

Kulipwa wakati wa kufikishwa
Dear Freelancers! Looking for Excel specialists. The file I have uploaded. I use Excel newest version for MAC! 1. Income tab / column A and K and expenses tab, column A and K, there will be invoice and credit note numbers, e. g. GP2024-001. I want a function that if you click the number automatically opens the file. The file name is the same as the name in the cell with .pdf, .jpg or .png. The paths you can find in the tab Stats and Links. It should be adaptable so that one can change the "path". There is a different path for invoices, credit notes and for expenses. 2. Add three diagrams under Stats tab - under monthly view I want to see a bar diagram as to months Jan, Feb etc. with all income and all expenses as for this month. - below it please two pie chards. first with all gross income total and all gross total not paid yet (this info is in tab Income column H if there is a date) - same for expenses tab expenses, column H It should be a very quick job for excel specialists. Please indicate if you have time to start the job right now.
Kitambulisho cha mradi: 37695506

Kuhusu mradi

23 mapendekezo
Mradi wa mbali
Inatumika 4 mos ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
Imetolewa kwa:
Picha ya Mtumiaji
I am an expert in python, c programming, excel and matlab as I am mechanical engineer by profession. I also have experience in report and research writing and have recently written two submitted master dissertations in English language. I have experience in latex writing as well. Also I have Presentation making and article writing experience, biology writing, Video editing and videography are also my add up skills.
$50 USD ndani ya siku 7
4.1 (4 hakiki)
1.7
1.7
23 wafanyakazi huru wana zabuni kwa wastani $100 USD kwa kazi hii
Picha ya Mtumiaji
"""""""""""""""""""ADVANCE EXCEL EXPERT/EXCEL FUNCTION CREATION & DATA ORGANIZATION"""""""""""""""""""""""" ""Sir, EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA and CODING, AUTOMATION, TEMPLATE, REPORTS, FORMULA'S, DASHBOARD in EXCEL Advanced Level Expert. This is my field and I can complete this project with added quality. About me I am a Chartered Accountant with more than 7 years of experience including 4 years from the worlds leading Accountancy and auditing firm ""PWC"" and 1 year working at managerial level in Multination company and 2 years as freelancer. I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. I have been working as a freelancer from the last 2 years and I have 330+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar "
$99 USD ndani ya siku 1
4.9 (278 hakiki)
7.3
7.3
Picha ya Mtumiaji
Hello, Greetings of the day! I have a vast experience of working in Advanced Excel and I have completed many projects based on Advanced Excel. I have read your requirements and I can complete your project within time frame with proper and efficient work. I am a full time Freelancer and available to start your project immediately. I have an experience of below skills • Changing Raw Data into Presentable Data which can be easily under stood. • Use of Advanced Excel Formula • Data, Power Query, Tables & Formatting • Conditional Formatting • Advanced Charting • Pivot Tables & Pivot Reporting • VBA & Macros • Data Analysis • Anova analysis in Excel • Statistic & Modeling using Excel • Forecasting & Trend Analysis & many more …. I am ready to work on a Sample file also if required. Please initiate the chat so that we can discuss more about project and start the project. Thanks & Regards Sneh
$120 USD ndani ya siku 2
4.7 (49 hakiki)
5.8
5.8
Picha ya Mtumiaji
✅ Excel Expert ✅ Microsoft Office Certifier ✅ Surely Delivery in Time ✅ Immediate Start ✅ Offering you Professional IT Experience in Excel, data mining, web searching, Web scrapping and lead generation with over 5+ years experience working in all domains. What do we offer? ✅ Will update you in excel as you need. ✅ Daily work updates. ✅ Quality Work with 99.99% Accuracy ✅ Always on time ✅ Excellent Support. ⭐ Previous work available on request. I would be glad to bring my skill-set and expertise to work with you on your project. Feel free to send me a message to discuss your project with me, and I will respond right away!!! ? Hard work always appreciated ? Thanks & Regards, Pooja G.
$250 USD ndani ya siku 6
5.0 (15 hakiki)
4.4
4.4
Picha ya Mtumiaji
I CANSTART WORK RIGHT NoW As an Excel specialist with extensive experience, I am confident in my ability to deliver exactly what you need. Specifically, I am highly skilled in creating functions, organizing data and handling files. Your project of creating a function that opens the relevant file on clicking the invoice numbers aligns perfectly with my competencies. Having worked extensively with Excel on MAC, I understand the nuances of this specific version very well and can assure you of a smooth execution. In addition to creating the desired function, I am also adept at generating insightful visualizations from complex data sets using various chart types like bars and pies - a skill that will be valuable for completing your second requirement. Furthermore, my past work as a designer has endowed me with an eye for detail and a commitment to quality which are crucial aspects in managing Excel data. Lastly, if time is of the essence for your project, rest assured that I can start right away and deliver on time without compromising on quality. Let's collaborate and bring elegance and efficiency to your Excel spreadsheets!
$188 USD ndani ya siku 1
4.9 (3 hakiki)
3.7
3.7
Picha ya Mtumiaji
Hello I read your project and I am ready to start working NOW I am expert in data entry, excel and google sheets I am expert in formulas, functions, pivot, data visualization, dashboard, charts and graphs. Also, I have original version of MS office Programs I will provide a sample, Unlimited revisions and 100% Satisfaction. Let’s discuss the details on chat
$30 USD ndani ya siku 1
5.0 (3 hakiki)
2.8
2.8
Picha ya Mtumiaji
Having had over a decade of experience as a Full-Stack developer, I'm well-versed in utilizing Excel to its fullest potential. My specialized skills in data organization and creation of macros can assist in your task seamlessly. For the first job, my proficiency in Excel VBA Macros will be of great use. I can create functions that not only open the required file associated with the invoice/credit note number but also provide you with the flexibility to change the path for invoices, credit notes, and expenses. This means that you can easily adapt your system as and when needed. In addition to these tasks, creating the requested graphs is also within my expertise. Whether it be a bar diagram representing income and expense data, or pie charts showing gross income details and unpaid sums, I can deliver them all efficiently. My quick-turnaround time and my ability to start on projects right away means your time would not be wasted waiting for me to begin. Looking forward to working with you on this exciting project!
$50 USD ndani ya siku 1
5.0 (1 hakiki)
1.4
1.4
Picha ya Mtumiaji
Dedicated Freelancer Ready to Elevate Your Project for Excel Function Creation & Data Organization. I have a solid background in Excel VBA and Excel, I bring valuable expertise to your project. I have successfully completed many projects with 100% client satisfaction. Clear and timely communication is my priority. I believe in keeping you informed throughout the project lifecycle. I am available for a discussion at your earliest convenience. Please feel free to contact me to further discuss your project details. Thank you for considering my bid. I am excited about the opportunity to contribute to the success of your project. Please visit my portfolio to check my previous work samples, here - https://www.freelancer.com/u/GraphicsHub2k24?page=portfolio&w=f&ngsw-bypass= Best regards, Muhammad Asim Khan
$30 USD ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Hello, I have seen and read it for your needs. I understand what I have to do. That's why we can come to the chat and talk about it in more details. I am waiting for your reply. Thank you Sourab ali
$30 USD ndani ya siku 2
5.0 (1 hakiki)
0.2
0.2
Picha ya Mtumiaji
As an analytical and statistical professional with 3 years of experience, I am proficient in utilizing Excel functions and VBA to streamline data organization and automation. Your project aligns exceptionally well with my skill set and I can confidently assure you of timely, efficient results. For the first request, I plan to create a function that enables you to open files simply by clicking on reference numbers, ensuring easier access to pertinent information. Let's make data retrieval effortless! In addition, I have extensive experience working with data visualization using Excel, which will greatly benefit your need for three diagrams under the "Stats" tab. Specifically, for the monthly view, I propose creating a bar diagram that showcases all income and expenses for each month in a visually-pleasing way. Furthermore, I will design two pie charts providing essential insights into gross income total and unpaid totals (information sourced from tab Income column H). By executing these tasks masterfully, we will equip your project with data-driven comprehension. Lastly, what sets me apart is my commitment to promptness without sacrificing quality. Seeing as your project calls for immediacy, be assured that I can start right away. My goal is not just to deliver on time but also exceed expectations along the way. So let's collaborate on this project to transform your Excel file into an intuitive hub of easy-to-access information!
$140 USD ndani ya siku 7
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
I am a good writer and good typer for these types of work I can do fast as much as other can do I will accurately done my work
$140 USD ndani ya siku 7
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Hello there! I am available to start working straight away on this, and create the required reporting for income and expenses. I have proficient experience with excel and would be eager to help as soon as possible for you. Kind Regards, Dylan
$100 USD ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
I am working as an actuary. in an insurance company in Hong Kong now. I also undertake some Excel-related automation work. I specialize in VBA and Excel functions. My program has helped a lot of colleagues in other departments like investment, finance, and underwriting. My undergraduate major is Financial Engineering. I have a relatively strong foundation in mathematics and programming. I am good at solving problems using multiple programming languages. I have applied Java in building data structures and implementing algorithms in course projects. I have applied the R language for empirical financial research. I have also applied Python for data analysis and used it as a basis for achieving results in college modeling competitions. The database language SQL has also been used to support the running of programs.
$60 USD ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Dear Hiring Manager, I am writing to express my sincere interest in the data entry position at your company. Having come across the job posting, I was immediately drawn to the opportunity to utilize my skills as an Excel data entry specialist. With a strong attention to detail and excellent organizational abilities, I have successfully completed numerous data entry projects throughout my career. My proficiency in Excel allows me to efficiently handle large volumes of data with accuracy and precision. I take pride in my ability to maintain a high level of accuracy while working within tight deadlines. Furthermore, my strong problem-solving skills enable me to identify and resolve any discrepancies or errors that may arise during the data entry process. I understand the importance of maintaining confidentiality and ensuring data security, which is why I always adhere to strict privacy guidelines. I am confident that my expertise in Excel and dedication to delivering high-quality work would make me a valuable addition to your team. Thank you for considering my application. I look forward to discussing how my skills can contribute to your organization's success. Yours sincerely FATIMA AMIR .
$120 USD ndani ya siku 5
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya UNITED ARAB EMIRATES
Dubai, United Arab Emirates
4.9
28
Njia ya malipo imethibitishwa
Mwanachama tangu Apr 15, 2018

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.