Writing the formula in Google Sheet

Project Description: Hello, we are looking for a detail-oriented freelancer with a systematic approach to work who is not afraid of routine tasks. You will be working on a Telegram Outreach project to expand the client base of Nexus Digital Agency. Your main task is to find target Telegram groups. There is no need to invent anything: we will provide a small but detailed manual with clearly defined procedures and standards for searching and verifying. You are only required to follow this instruction carefully and meet deadlines. What needs to be done:Search for relevant Telegram groups and chats based on specified criteria.Filter them according to the standards of Nexus Digital Agency (description in the manual).Structurally enter the found groups into a reporting table (Google Sheets).Our requirements for the candidate:Attention to detail and the ability to work strictly according to instructions is a key factor.Confident user of Telegram (understanding how search works, types of groups, limitations, etc.).Perseverance, systematic approach, and responsible attitude towards work.Experience in research (Lead Generation, Data Entry) will be an advantage, but we are ready to consider beginners who can learn quickly.What we offer:A fully prepared base to start (clear manual and specific selection criteria).Quick feedback from our side.Guaranteed and timely payment.The possibility of long-term cooperation on a regular basis for those who show good results. How to respond: Briefly describe your experience in searching and gathering information (if any), and also indicate your preferred payment format (rate per hour of work or fixed price for a certain number of valid groups).

A freelancer is needed for the prompt collection of data from the Scopus database and its entry into Excel files.What needs to be done: open journal cards in Scopus; check the journal status (active/discontinued); find and enter CiteScore; collect Subject Areas and Percentile; determine Quartile (Q1-Q4) according to the provided table; carefully fill in Excel files according to the specifications.Requirements: attention to detail; confident work with Excel; willingness to quickly engage in work; experience working with Scopus or other scientific databases will be an advantage.Scope of work: The database contains about 1500 journals. The work can be divided between two performers.Payment: 3500 UAH for the entire volume or 1750 UAH for half of the volume.Deadline: Work needs to start immediately. The deadline is in the next few days.In your response, please indicate: Have you worked with Scopus or other scientific databases before? Do you have experience working with large Excel spreadsheets? What is Quartile (Q1-Q4) in Scopus? When are you ready to start working? A detailed technical task will be provided to selected candidates.

There is a table with a database (company name, full name of the manager, mobile phone). A total of 750 entries. You need to conduct phone calls with a brief proposal for recruitment services for the specialists they need. A script (or even 2) will be provided to the selected person. Next, update the statuses in the table for each call, and in case of any positive responses, simply inform them that our manager will contact them and explain everything in detail. Please use your own regular Ukrainian mobile number; online telephony is not provided. Call recordings are not needed at this time.

Hello I need to gather contacts of companies in 5 French-speaking regions of Switzerland (Geneva, Vaud, Neuchâtel, Jura, Valais Details - - manufacturing companies and service providers - focus on local companies or international companies that have business in the country - large and medium enterprises or small businesses that have several offices-stores-garages-etc. (any chains) Details 1. manufacturing - any enterprises in the 5 regions of the country (including food products (chocolate, cheese, dairy, and others) 2. services - - transport companies, - cleaning companies (for cleaning - transport (buses, trams, metro), airports, business centers, stores, universities, and other educational places (schools, kindergartens), customs, police - medical institutions (excluding hospitals), - car dealership chains, - sports clubs, - restaurant chains (individual restaurants are not needed), - distributors of cleaning products for businesses or local municipalities, - car wash chains, - hotel chains in this country (one hotel is not needed), - companies that conduct cleaning-washing of yachts on Lake Geneva, The result of the work will be - a table with contacts of the above-mentioned companies (region name, industry, company name, company website, email, phone number, address, company LinkedIn link, 2-3 contacts from the purchasing department (for large and medium companies) and management for small enterprises (including chains) with name, position, email, phone, and LinkedIn links (if available) Evaluation - a minimum of 300 companies for which there is a budget of 3,000 UAH or 10 UAH for each contact I am ready to answer all questions Thank you

1. Choose a service 2. Configure the service 3. Create a template 4. Upload the database 5. Check functionality and deliverability (and avoid going to SPAM) 6. Send a one-time mailing to 1000+ subscribers please write your financial proposals and deadlines