Closed

Formula Expert Required To Redesign & Improve My Google/Excel Spreadsheet

Hi, I am looking for someone who is experienced in Google spreadsheets and Excel spreadsheets.

• I have a basic excel worksheet containing food product information (shortlisted candidates will get a copy).

• I need to improve data input, extraction, and the design. IT NEEDS TO BE USER-FRIENDLY!

• You need to have amazing design skills, so you can redesign my spreadsheet which has:

Product name, website link, image link, email address, allergens, and nutritional information categories.

• The following things need to be added and/or changed:

1. Include formulas: formulas needed to find matches and return values for -

a. products which do not contain certain allergens

b. products which have certain nutritional values, i.e. Low salt, low sugar, low fat etc

c. save and name multiple filter views for quick access and sorting later.

(Ideally, the values returned should auto-populate to a separate spreadsheet or report, so that I do not have to make a note of the values manually).

2. Add a column to include the names of different vendors/retailers, that sell each product (up to 7 vendors for each product) and include the link to the website for each of those vendors.

(Not sure if a dropdown menu can be used for this column, or if there needs to be a separate column for each vendor’s information?)

3. Protect the Sheet with Password

4. Unprotect the Sheet (Forgot Editing Password)

• I will also need to be able to make a copy of this master sheet with the same rules.

• I require a total of 2 spreadsheets: 1x Google spreadsheet & 1x Excel spreadsheet (so you can design it using a Google spreadsheet, but it will need to be able to be converted into an Excel spreadsheet),

• I will also need you to make a short video that demonstrates how to use the spreadsheets.

Thanks, and I look forward to receiving your reply!

Skills: Excel, Excel Macros, Google Sheets

See more: google adwords expert required, google base google shopping results expert required, i want to redesign my restaurant menu, i want to redesign my school website i have details in my website budget is 20 usd i want to complete within 2 or 4 hours first , oracle expert required to optimize the queries, google excel spreadsheet, want to redesign our my website, python expert required to, how to send group email from excel spreadsheet, how to send multiple emails from excel spreadsheet, how to print dymo labels from excel spreadsheet, how to print name labels from excel spreadsheet, how to take a picture of excel spreadsheet, how to copy and paste an excel spreadsheet with formulas into word, how to copy and paste an excel spreadsheet into an email, how to improve my google business listing, when might you want to sort data in an excel spreadsheet when would you want to filter data, how to merge data from one excel spreadsheet to another, authorization is required to perform that action. google apps script, how to put a picture behind excel spreadsheet

About the Employer:
( 0 reviews ) LONDON, United Kingdom

Project ID: #29410302

14 freelancers are bidding on average £66 for this job

schoudhary1553

Hi, Greetings! ✅ I have checked and gone through the project details and I am very skilled in it. ✅Completed Time: In project deadline We have worked on 640 + Projects. I have 6 + years of the experience in sam More

£100 GBP in 2 days
(393 Reviews)
8.2
sourabhg98

Hey there! This is Sourabh Gupta from New Delhi. I am an advanced spreadsheet developer currently at the post of Forum Expert at www.excelforum.com. I would like to offer my services for this project. I can design a More

£64 GBP in 2 days
(150 Reviews)
6.2
aimefx

Hi I am an expert in Excel and Power bi, I am ready to start your project, please send a message to discuss further. Thanks

£60 GBP in 1 day
(96 Reviews)
6.3
JohnRikz

Hello, I'm an excel expert i will format the sheet to be user friendly, create formulas to get the needed result. We can unlock your file even if you forgot the password. can you please discuss? i am available at the More

£66 GBP in 2 days
(51 Reviews)
5.1
(6 Reviews)
4.4
hiteshchavadaa

PRO FOMRULA EXPERT IN GOOGLE SHEET Hello ! I have checked the project details; NEED FORMULA EXPERT I am pro expert in Excel. Contact me so we can discuss about it before you award the job. Looking forward to work More

£50 GBP in 2 days
(26 Reviews)
3.3
AnuradhaVM

Hi, Greetings! ✅checked your project details. I can redesign your excel sheet. I have completed the M.SC. (Statistics) . I Have 4 years’ experience with Data entry, Data analysis, and MIS Management. I have strong anal More

£50 GBP in 7 days
(11 Reviews)
3.2
(1 Review)
1.0
neomarekovic

Hi, here to help, contact me to discuss more :) Best regards, Neo.

£72 GBP in 2 days
(0 Reviews)
0.0
surajmishra1410

Hello, Mr. This project is very difficult, but someone of u then improvement this project. Then sumit of your project work.

£80 GBP in 6 days
(0 Reviews)
0.0
mahmoudmezo

Hello, I am interested in this project because it matches with my skills, please send me a message so that we can discuss it more, I am a professional in Microsoft Office, Data Entry, Word, Excel, PDF , reaserch , writ More

£80 GBP in 7 days
(0 Reviews)
0.6
alikhan234591

I am a excel spreadsheet expert and very much interested in the project. Looking forward to work with you. Regards, Muhammad Ali Khan

£74 GBP in 2 days
(0 Reviews)
0.0
deepibindal

I am good at excel formulas and analysis of data. I am ready to work as per requirement of the client. I can work with Vlookups that map data from different excel sheets , create reports and charts. I have developed so More

£50 GBP in 7 days
(0 Reviews)
0.0
Jaanusugaabaabu

Hallo Sir I am very Tailentade excal export and ma excal power point Exsaited Complete this your project so Short time in complete the your. Project

£60 GBP in 5 days
(0 Reviews)
0.0