Find Jobs
Hire Freelancers

Update and Format my Excel Spreadsheet

$50-100 AUD

Completed
Posted over 4 years ago

$50-100 AUD

Paid on delivery
I am looking for someone to clean up the overall formatting and improve how my excel sheet runs, including: - The drop downs are hard to read - The recommendation are just one line, I want to be able to format or make paragraphs - The file crashes when going to print and is slow to respond - Make sure the file works in newer versions of excel Any other formatting fixes would be appreciated! Previous project was done in Excel 10 - there are formatting issues and it doesn’t work properly in newer versions of excel. Currently, csv data (without headings) is copied into the data sheet. The results sheet gets the analysis data from the data sheet, and then the comment (low, normal, high) is assigned based on the range. In the Comments Section, I can use a pull down in the first column to get the criteria, and then a pull down in the second column will let me select a related comment. If I want to add a comment, I type it in the third column. I them type up a recommendation in the Recommendations Section. I can then go to the Buttons sheet and click ‘Add’ for Add visual format to format the document. I’ve attached a practice csv file and the excel document so you can see if this is something you can help with.
Project ID: 21820134

About the project

34 proposals
Remote project
Active 5 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
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.
$100 AUD in 1 day
4.9 (465 reviews)
7.9
7.9
34 freelancers are bidding on average $85 AUD for this job
User Avatar
Dear Client, I am an experienced VBA and Excel professional and have served the clients throughout the globe. Please review my profile to get an insight into the quality of my services. I am the one who believes in long term relationships and thus works upto client satisfaction to have them as my clients forever after. I have reviewed your job and ready to proceed to it and will wait for your response to discuss the further details and start the project. Warm Regards Ali
$200 AUD in 3 days
4.9 (179 reviews)
8.0
8.0
User Avatar
Hi Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thank you, Asad Khan
$100 AUD in 7 days
5.0 (427 reviews)
7.5
7.5
User Avatar
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 Excel application reworked. I plan to use a combination of formulas and VBA code to accomplish this. The Excel file will run on PCs. I will charge you $100* and can deliver within a day (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Excel, and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 330 projects successfully in six years, and I feel confident in achieving your task as well.  I'm online from 7 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
$100 AUD in 1 day
4.9 (302 reviews)
7.8
7.8
User Avatar
Dear Hiring Manager, I have read through your project description. I am ready to do some free sample for you. Message me so we can discuss more. You may see my profile here: https://www.freelancer.com/u/motiur03.html I have completed successfully over 700 projects in freelancer.com. I have an Advanced level of knowledge and experience in a similar job, so I can handle this project accurately. Best Regards Motiur
$75 AUD in 3 days
4.9 (275 reviews)
7.7
7.7
User Avatar
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the projects, i do everything, that's why i only take what interests me and i can do it effectively. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards
$100 AUD in 5 days
4.9 (296 reviews)
7.3
7.3
User Avatar
Hi, I am financial experts and a guru in Excel with extensive knowledge and expertise in advanced formulas, Pivot Tables, Tables, and Visual Basic Application including preparation of available interfaces, dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts (by VBscript). Also, I deal with exporting databases to and vice versa (+ automation with VBA). My modules allow filling information on forms (with drop-down list ), manipulating and merging the info in structured tables and populating results in build-in reports and forms. There is a search engine with high search capability to find specific records. During the process, Excel validates the information and prepare graphical and visualisation reports and documents based on needed parameters and criteria. There is a report generator which enables you to develop templates independently, and the files secured by username login and password. Furthermore, I have experience in accounting, financial reports, consolidating, forecasting, budgeting, costing, cash flow, multi-currency, including collections, payments, inventory, bill of materials, taxation and bank reconciliation. With these skills, I prepare dynamic & designed reports and dashboards, for pitch decks, business plans, due diligence, financial modules, feasibility studies, and financial projections with scenarios and charts.
$100 AUD in 7 days
4.9 (94 reviews)
7.2
7.2
User Avatar
I am an excel expert and have completed many complicated excel related tasks. Can provide you sample if required of my past and current work. Read the project specs. Looks like this project is feasible. Just want to understand and make sure some of the requirements ..so kindly open PM to discuss work and budget..I am based in california and can talk over phone to understand the requirements and will provide support though out the project till you are satisfied with the work.. Regards,
$100 AUD in 7 days
5.0 (212 reviews)
7.2
7.2
User Avatar
Hi, My name is Janis and I have been here in freelancer since 2014. One of the preferred freelancer because of the good standing and have good feedback from previous employers. I was asked by the freelancer staff Gina to bid on your project. I believe we can help you with your Update and Format my Excel Spreadsheet because I do have a team and are mostly my cousins/close friends that is why we have been working as a good team with trust. My business is to make your business effective, profitable & efficient. We are able to have a sound understanding of our Clients’ operations and their corporate goals, and we continually bring knowledge and new ideas to them. I am a pioneer in the outsourcing/call center industry in the Philippines, and as such, have a deep understanding of world-class customer service, prompt delivery of jobs & the importance of client satisfaction of our work. The team is led by me–a forward-thinking, resourceful professional with more than 13 yrs of experience in Sales, Marketing & Customer Service; who understands the power of good relationships with customers/clients, and that this is the foundation of successful business & attracts repeat sales. We are highly-skilled, well-educated, English-speaking, smart professionals ready to deliver results for you. Been working on different projects since 2014, with most of my clients are from here (you can check the good reviews we garner on my profile). Willing to discuss.
$120 AUD in 1 day
4.9 (45 reviews)
6.7
6.7
User Avatar
I am a professional with a decade of experience working in a US based NASDAQ registered company with all the skills and knowledge required for your project. Please send me a message and we can move forward with your project.
$50 AUD in 1 day
4.9 (103 reviews)
6.1
6.1
User Avatar
Hello, I am Luis and I will be glad to assist you with your project. I have a lot of experience with Excel, formulas, macros and formatting and I can update your Excel project. Please contact me by chat then we could discuss further details about your project. Kind regards, Luis Romero
$100 AUD in 2 days
5.0 (167 reviews)
6.0
6.0
User Avatar
Hi there, I read your description and i see there is a mess on your file and is slow responding,and is having issues about excel versions. I have a better idea to fix the file and work perfectly. Send me a message so we discuss about solution
$150 AUD in 7 days
4.7 (76 reviews)
6.1
6.1
User Avatar
Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. An Expert Excel/VBA programmer on freelancer.com and I do not bid on projects which I am not sure. I will not disappoint you and I will do my best for give you a perfect solution. If I have an opportunity to work with you, That's my pleasure. No milestones required in advance, please pay me once the job is 100% complete. Also, before you consider awarding me the project, I can provide you with some sample files via your requirements. Please message me, so we can discuss here as I may have some questions. Thank you. Marko R.
$100 AUD in 1 day
4.8 (42 reviews)
5.3
5.3
User Avatar
Hi ! Greetings! I have gone through your project requirements and interested to do this job as my skills and work experience match your requirements. I am ready to do small sample so that we can share same understanding over the required results. I have 9 years experience dealing with various kinds of web search and data entry assignments, I can help you with this requirement as I've previously worked on the exact same project for another employer. I will look forward for your response. My skills:- # Manual Data Collection / Data Mining / Web Research. # Finding Email Address of CEO/Director - Top Level key executives. # PDF to Excel / PDF to Word - can be done with 100% accuracy. # Business card entry in Excel sheet. # Can do any urgent projects. # Long term Maintenance works. # Image Editing – Photoshop. # 24/7 available. Best Regards, Sanju Gupta
$75 AUD in 2 days
4.9 (26 reviews)
5.0
5.0
User Avatar
Hi, I am ready to start right away. I'm an expert in Data Entry. I have reviewed your job description as well and very confident to handle this project perfectly. I understood your all requirements. I have done many projects like this. Can you send me a message? Then we can discuss the details. Regards, Noor
$75 AUD in 1 day
4.7 (20 reviews)
4.1
4.1
User Avatar
Dear Client, I can do this Job. I have excellent experience of Excel (VBA/MACROS/FORMULA'S),Data entry, Web Scrapping (Python and Selenium) and Web Research for more than 4 Year’s. Never ends up until you are 100% satisfied with each and everything. I have worked on the similar projects before, so with my interpersonal skills and experience I would be happy to work for you. Best Wishes, Aishwarya Kumari
$90 AUD in 1 day
5.0 (25 reviews)
3.8
3.8
User Avatar
Hi, Thank you for clear target and give the material. I check inside excel file, existing macro is not complicated. Regarding to formatting issue, I can improve it until to be same as your requirement, that we can discuss. Please feel free to chat me if you interest to hire me. Thank you.
$50 AUD in 3 days
5.0 (8 reviews)
3.5
3.5
User Avatar
Dear sir, I have worked 5 years in water labs (Eurofins) and I have designed a new lab for asbestos as project leader. While I waited for the IT to install the Lims, I had to make Excel reports from data with respect to accreditation rules. I know and understand the problem you are facing, as well as the comments about chemical quality checks. We can even define a list of ore-defined rules they will show up comments. I can help you design your file in a few days. I will make it without a line of macro code, good formulas and a good Excel structure are enough. I’m very very specialized in excel formulas and teaching. I have made hard exercises for people that need advanced understanding of - Complex multi-condition Index/match formulas - Formulas in pivot tables, in number formats, in graph axis colors, in conditional formatting, and in dropdown menus. - Array-like formulas, that are equivalent to VBA loops. Like “sum of squares of values in a range”, or “min in column A for values when the text in column B is present in text column C”. - Size reduction for big data files - Time reduction for files with too many calculations - efficiency shortcuts (98% of times, I don’t even touch the mouse in Excel) I know VBA, Java, C++, Python, JavaScript. 2- Academics : I graduated a Master in computer science and mechanical engineering from the top French Engineering school and this can be publicly verified.
$110 AUD in 5 days
5.0 (6 reviews)
2.8
2.8
User Avatar
I have seen your both excel files and find them pretty understandable. However will chat with you for more details. - The drop downs are hard to read (WHERE ARE THE DROPDOWN) - The recommendation are just one line, I want to be able to format or make paragraphs (CAN BE DONE) - The file crashes when going to print and is slow to respond (TRIED PRINTING FROM EXCEL 365 BUT DID NOT CRASH OR GOT SLOW) - Make sure the file works in newer versions of excel (TRIED NAVIGATING IN EXCEL 365 WITHOUT ANY ISSUES) Any other formatting fixes would be appreciated! (I HAVE QUITE A FEW SUGGESTIONS FOR IMPROVIZATION ALONG WITH THE DESIGN AND LAYOUT) Previous project was done in Excel 10 - there are formatting issues and it doesn’t work properly in newer versions of excel. (IT WILL WORK GREAT WITH EXCEL 2016 / 365) "I have 10+ years of experience working with Microsoft Excel (+VBA Macros development), PowerPoint, Word. I also have proven experience of maintaining data privacy, business ethics, speed, and accuracy of parameters and English language. Data privacy, safety is one of my focus areas. I am willing to sign an NDA if required. Please see my creations in Excel workbooks. I deliver Excel, Reporting, dashboard, VBA Macros repairing, creating projects for Schools, University and Corporates. Most of my clients so far are from Denmark, Sweden, London & India. You can see my work on my Freelancer portfolio page."
$50 AUD in 2 days
5.0 (6 reviews)
2.8
2.8
User Avatar
Dear Sir, I have read and fully understood your requirement. I am highly skilled in data operating and typing. My typing speed is 60 words per minute and I I have completed all the duties mentioned in your job description during different projects. I am an expert of data entry typing MS word, Excel, Power point and PDF I am an affective problem solver and responsible person. I will deliver you Error free document Fast and Accurate work Typing speed of 60 words per min Timely Delivery I am always available on email and Skype for further discussion, I am open for any question or query. looking forward to your positive feedback. i am very responsible person and ready to take responsibility that you will assign me. Regards Zain ul Abeden Khan
$50 AUD in 1 day
4.8 (5 reviews)
2.5
2.5
User Avatar
Hello dear sir/madam I’m ready to do your project right now as fast / carefully as you want. My time is up to your project. I had got this experience and you should be relaxed to deliver me your project and enjoy it. Best regards
$50 AUD in 3 days
5.0 (3 reviews)
1.8
1.8

About the client

Flag of AUSTRALIA
Seymour, Australia
5.0
7
Payment method verified
Member since Mar 3, 2018

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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.