How to insert formula in excel for entire column jobs

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I am in need of a skilled photographer to capture professional headshots of 1-5 individuals on my team. These photos will be used across various platforms including our company website, our LinkedIn profiles, and other social media accounts. The photoshoot will take place outdoors, hence, I'm looking for someone who has experience and can masterfully utilize natural light for high-quality results. Ideal Skills and Experience: - Proven experience as a professional headshot photographer - Expertise in outdoor photography utilizing natural lighting - High quality portfolio demonstrating past work - Ability to guide subjects for best results in terms of posture and expressions. Your bid should include the total cost for the...

I'm seeking an experienced patent expert who is adept at filing in the United States to assist me with a process invention. Despite conducting a preliminary search suggesting it's a novel procedure, your expertise will be vital in cross-verifying this and guiding me through the entire patenting process. Key requirements: - Strong familiarity with US patent law - Experience with process-related patents - Proficiency in patent search to confirm the novelty of the invention - Timely and effective communication skills An ideal candidate will have previous experience in filing process-related patents, adept in patent search, and knowledgeable in US patent laws. Demonstrated capability to manage deadlines while m...

I am in need of an expert who can proficiently help me flatten specific curved surfaces of a 3D construction using Fusion. Key Requirements: - Experience in working with Fusion software is crucial. - The project involves simple curvature surfaces, so familiarity with 3D manipulation, specifically in flattening, is ideal. - Precision is a must as only specific sections of the 3D construction need to be flattened, not the entire construction. Looking forward to working with someone who is meticulous and skilled at navigating Fusion's model manipulation.

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

Objective: Our company aims to automate its logistics process to improve efficiency and reduce manual workload. We are looking for a freelancer with expertise in automation to develop a system that streamlines the process from transport request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook ...

I'm looking for a proficient front-end developer who is well versed in UX/UI layout and PHP Laravel. The main objective of this project is to transform an already well-advanced community platform into a visually attractive and easy-to-use website. I'm looking for a developer specialized in front-end, UX/UI layout to create the entire layout of a new platform idea (Preferably get in touch if you have already participated in creating the layout of a project with these characteristics). with 3d layout. Furthermore, the dev needs to have specialties such as PHP, Laravel, mainly to make some necessary corrections to the business rules of my current and online platform. Ideal skills and exper...

Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.

I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.

...specializing in helping businesses stand out on YouTube. We're currently on the lookout for a YouTube SEO specialist to boost the visibility and ranking of our high-quality content on the platform. Key Responsibilities: - Implement advanced SEO techniques to improve the ranking of our videos in search results. - Conduct comprehensive keyword research and optimize video content accordingly. - Enhance the appeal and engagement of our videos through creative thumbnail and title optimization. - Dive into analytics and user engagement data to constantly refine and improve our strategies. Ideal Candidate: - Proven experience in YouTube SEO, with a track record of improving video ranking and visibility. - In-depth knowledge of keyw...

...freealancer to create an mcq list for moodle quiz website in Aiken formatting. Aiken format I am following is Frusemide tablets 40mg tablets are in stock. How many would you give for a dose of 120mg? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: A Sulphasalazine tablets 500mg are on hand. The dosage required is 2g. How many tablets are required? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: C So can you create options like a teacher, you don't need to know a lot about the topics. If you are wondering, It is nursing mcq (multiple choice questions). I have the questions and answers ready in a pdf. The first 428 questions are ready. Once the Question and Answer pdf is given, In the format mentioned above, j...

I'm looking for a talented event photographer to capture moments at my daughter's upcoming birthday party. The ideal candidate should have experience in event photography and be able to deliver the final photos in digital format. Key Requirements: - Must be proficient in event photography - Able to cover the entire event, including the cake cutting ceremony - Good with capturing candid moments of guests and family It's important for the photographer to have a keen eye for detail and an ability to make everyone feel comfortable in front of the camera. This role would suit a friendly and professional individual who can blend into the event while capturing the most memorable moments.

I'm in need of a PHP page that helps our agents to send an order. This page should be intuitive and user-friendly while ensuring all necessary information is captured. The platform should be interactive and user-friendly, ensuring a smooth order submission process for our agents. Ideal Skills: - Proficient in PHP - Strong experience in web development - Knowledge in creating secure web forms - Experience in agent-based systems would be a plus Please bid for this project if you believe you have the skills and experience needed to deliver a high-quality, efficient, and secure PHP page for our agents. Our customer sells products (not online, but in shop). He wants to receive orders from agents. I ha...

...web I terface for data entry We want to have multiple users to view and edit information for subscribers (names) in a database. Those users must be able to login on a web page, with a username and password. All users will see same information. But certain fields, those they will be able to edit, will be visible only to that specific user (and admin). Multiple users must be able to enter data (different) for each subscriber. User must be able to filter certain columns, search in all fields, hide/show columns. Online (on web) visible to users, will be only the fields mentioned in table visible) MS Access (local file) Administrator must be able to see and edit all after importing with...

...Scraping specialist to write code in Python (preferably) that scrapes a specific table from a website for me (Website: ). The table contains WNBA player statistics, The goal is to extract all columns of this table, which is approximately 7 columns and write it to a CSV file (in the same column format). I'm a beginner level coder, and noticed that the table was created with that looks like a Shiny App in R. (I'm not even sure if extracting the table is possible). If it was only possible to use R, then I could potentially work with that. Website: I would like the data to go from the year 2020 to current. Regular Season data. Key Requirements: - Scraping Tables on websites If you're confident ...

I'm in search of a diligent and detail-oriented individual to assist me on a part-time basis with data entry tasks mainly in the finance sector. Key Responsibilities: - Data Entry: You will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry is advantageous but not mandatory. - Stro...

I am looking for help to create two databases of potential clients for an e-mail marketing campaign, the first database should be exclusively of potential clients in Mexico from the entire country and the other, I don't know if it can be from Mexico City. . I am looking to obtain, if possible, name, emails, telephone number, and address

I am in need of an adept content writer who can craft compelling, informative content that not only engages but also promotes a product/service to a diverse audience. The ideal candidate should be able to transition seamlessly between the following: - Informative: The content should be detailed, well-researched, and clearly explain complex concepts to a general audience. - Promotional: The writer should be able to insert persuasive language and calls to action that encourage readers to engage with our product/service. - Industry-specific: An understanding of the industry is crucial. The content should be tailored to professionals in the field, providing them with valuable insights and information. - Academic: Additional...

We are in search of a skilled software integrator to help me integrate my personal deployment system with an IA/Chatgpt API. This project involves building and implementing a chatbot that's capable of: - Natural language processing: The chatbot should be able to understand and interpret human language, not just in a literal sense, but also in context. - Chatbot functionality: The chatbot should have the capacity to engage in meaningful conversations with users, along with the ability to learn and adapt over time. - Question and Answers: The chatbot should be able to provide answers to frequently asked questions and find relevant answers from PDF files content. Experience and Skills: - Strong understanding of natur...

...looking for professional photographers to capture the essence of the Levitt AMP Sheboygan Music Series held in Sheboygan, Wisconsin during the 2024 summer season. Every concert will last for approximately three hours, and it's expected that you'll be available for the entire duration. Your shooting style should incorporate: • Candid crowd shots that capture the excitement and the energy of the crowd • Artist performance shots that focus on the artists and their performances and craft • Behind-the-scenes shots that provide an inside look into what goes on off-stage See Shot List and Levitt AMP Photography Guide for further requirements. Requirements: • Seeking only local photographers within 60 miles of She...

...a freelancer to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent ...

I am in need of an interactive affiliates page for my website that showcases sister radio stations globally. This page should have a map with icon markers pinpointing station locations, a search feature to find stations by name or zip code, and a list of station names accompanied by location information. Map should allow zoom and going to country specific. So users can see entire map of their country with locations. Ideally we want world map to show first. I want tabs where users can switch between USA or world map. This page will go onto and can be with html 5 and css and js. Key Features: - Display of Sister Radio Stations: - An interactive map should be the centerpiece of the affiliates page, showing all sister radio station locations gl...

We are developing a spreadsheet-based database of the most popular English quotations (or English translations), and are looking for a researcher with native English language skills who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the use of...

...engineer with expertise in using Cisco Packet Tracer for a small-scale ISP network project. - Tasks: The main responsibilities of the project will involve configuring and setting up the entire network structure including routers, switches, and other necessary network components. Additionally, I will require assistance in ensuring the network is secure and troubleshooting any issues that may arise during the process. - Goal: The main aim of this project is to successfully build and simulate a small-scale ISP network using Cisco Packet Tracer. - Experience: The ideal candidate for this project should possess: - Proficiency in using Cisco Packet Tracer for network design and simulation. - Strong understanding of network configurati...

I'm in need of a proficient Java developer to help me with a desktop application. I'm in a position to provide the entire code base, which will serve as a significant guide for the project. The ideal candidate for this job should have: - Solid experience in Java programming, preferably with desktop applications - Excellent problem-solving skills - Ability to work with an existing code base Having these skills will enhance your ability to deliver this project successfully. Your understanding of Java as it pertains to desktop application development is key to making this project a success.

I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.

As discussed, this includes the following - 1. Automated trading functionality in excel using the TWS API 2. Customization of entry and any other rules post discussion 3. Python codes 4. Deployment support and 2-weeks support for smooth operation

I am in need of someone adept in Excel and knowledgeable in medicine, especially in dosages and weight-based calculations. The challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication ...

...looking for a skilled copyrighter to create blog articles for our website. Here I'm interested in three articles 800-1000 words each - feel free to make more engaging titles: 1. "Technologies and Frameworks Used in Online Banking Software" 2. "Benefits of building custom virtual wallet solutions into your product" - here to speak about features of virtual wallets, flexibility to convert credits in exchange for additional services, etc. 3. "Compliances and certifications that might be needed for a financial services startup" - explore main compliances for the US and European countries a fintech software startup should know about. The main goal of these articles is ...

I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.

I am seeking a skilled Amazon product listing specialist to assist in the creation and optimization of listings for my cosmetic products. The ideal candidate will possess extensive experience in working directly on the Amazon platform, with a proven track record of success in creating cosmetic listings. Expertise in managing the entire listing creation process, including product images, descriptions, and pricing, is essential. Additionally, experience in optimizing listings for sales and visibility is highly desirable, as I already have an established seller account. If you possess the requisite experience and expertise, I encourage you to contact me to discuss this opportunity further.

I am looking for a skilled freelancer to help convert 12 simple floor plans into editable layouts suitable for creating evacuation maps. The goal is to clearly illustrate the evacuation routes within the building's layout. Requirements: - The present pdf copy of the floor plans should be converted into an editable format. The preferable formats are Word, Excel, or Editable PDF. - Use color-coding to differentiate the evacuation routes for better clarity. The color to be used for the evacuation routes is Red. Ideal Freelancer: - Proficient in creating and editing floor plans. - Skilled in using software that can create and edit floor plans, such as Adobe Acrobat for PDFs, Microsoft Word and Excel...

...engineer with expertise in using Cisco Packet Tracer for a small-scale ISP network project. - Tasks: The main responsibilities of the project will involve configuring and setting up the entire network structure including routers, switches, and other necessary network components. Additionally, I will require assistance in ensuring the network is secure and troubleshooting any issues that may arise during the process. - Goal: The main aim of this project is to successfully build and simulate a small-scale ISP network using Cisco Packet Tracer. - Experience: The ideal candidate for this project should possess: - Proficiency in using Cisco Packet Tracer for network design and simulation. - Strong understanding of network config...

...your offer with the word in the attachment, otherwise we dropp you out. We are looking for a database with websites, HAVING EMBEDDED YOUTUBE Videos on their sites. Prepare a list with : Name of the company, youtube Channel, Link to the first youtube video you find on the site, PLZ, City, State, Phone, Mail, Website Niches: Construction Systems in Austria, Germany and Switzerland Phsiotherapeuts in Austria, Germany and Switzerland I would like to have at least 2000 websites with top-quality data. Delivered in 1 day. Delivery in one Excel file. Time of delivery is a key element in our decision. Offer a price for 2.000 data entries. We extend our partners for this kind of task´s. With all of them...

We are looking for a reliable, dedicated and knowledgeable VA on a long term basis. Our company operates within cryptocurrency and finance, making it highly beneficial that the selected VA has a strong understanding of this field. As a VA, you will play a pivotal role in managing various tasks associated with our crypto-related platforms, including a YouTube channel, social media accounts, a blog, and a Telegram community. Key Responsibilities: Research and Summarization: Conduct research on new crypto products, trading companies, and product features. Summarize findings in visually appealing Excel sheets or Designs or reports for easy comprehension. Partnership Outreach: Reseacrch & Contact potential partner programs to explore collabora...

I'm in need of a skilled freelancer to assist with some data entry work. While the specifics of the work have not been defined yet, it will likely involve entering data into a database, transcribing written documents into digital format, and/or filling out online forms. The task can involve different formats such as Excel spreadsheets, Word documents, or online platforms.

Objective To enhance the existing PowerPoint presentation draft/template by designing each slide to look visually appealing using the provided color palette. The project involves refining the visual elements, particularly the maps, while maintaining their proportions. Key Deliverables Enhanced Slide Design: Improve the overall aesthetics of each slide. Apply the provided color palette consistently across all slides. Ensure text and visual elements are balanced for clarity and impact. Map Refinement: Enhance the visual appeal of all maps without altering their proportions. Use consistent and clear labeling for better readability. Apply thematic elements from the color palette to the maps. Consistency and Professionalism: Ensure a cohesive and professio...

I'm seeking to secure funding for a multi-industry workers' accommodation project. The accommodation caters to construction, seasonal farm, wind farm, abattoir, and gold mine workers. For this, I need a professionally crafted project proposal and a corresponding financial model in Excel. Ideal freelancers for this project should possess: - Proven experience in drafting project proposals related to housing or accommodation - In-depth knowledge in the creation of financial models using Excel - A strong understanding of multi-industry accommodations - Great analytical and strategic thinking skills - Familiarity in the Construction, Agriculture, Energy, Food Processing, and Mining Industries ...

Innovation Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling...

Hello; I need to generate a new set of websites (.EUs), integrated/generated them with an already active set with a lot of basic content (basic analysis, from set .ITs); Objective: digital sale of GREEN RIGHTS, starting in the EU and BRICS area; with option to generate some apps to upload NFT/DeFi (Solidity/ERC721) to specifics cryptocurrency markets; I think of a good system and its subsequent easy management; a lot of material needs to be reorganized, offered in English, with a sober and professional style, similar on every website, with the option of being available in every language (Wordpress); the basic contents and plan in matrix at the bottom in (first column general info, each others column basi...

I'm looking for assistance with online data entry to Excel. The task is not overly complex but will involve working with reference numbers and ensuring accurate data entry and cross-referencing. Full training will be given and I will explain all. Budget is hourly and $3 max need to have good understanding of English

...Power BI professional to assist with creating interactive dashboards and generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced knowledge of data modeli...

...is an Amazon marketing agency based in Reading, UK and Athens, Greece. We are bunch of Amazon sellers ourselves that got frustrated with the process of selling on Amazon, decided to provide our services so others will not face the same problems. Our team constitutes of marketing specialists, designers, photographers & consultants that are here to alleviate the complexities of selling on Amazon. Some of the world’s most popular consumer brands and innovative start-ups are our clients. About the role We are looking for a focused, driven Amazon Account Manager. The ideal candidate stays on top of Amazon’s marketing trends, has experience with Amazon listings (including flat file expertise), product research and Amazon software tools. You will be...

I have a 1-page Excel spreadsheet with 9 text columns that need to be merged. I'm looking for someone who can start this job immediately and has experience in Excel data manipulation and formatting. Please only bid if you can do this job immediately and I will award and give you the file.

I'm seeking an expert in Excel analytics. This project involves working with existing but undisclosed business data to help me understand and optimize the business's performance through indicators like KPIs. The freelancer's task encompasses: - The creation of robust dashboards that effectively communicate KPI outcomes. - The execution of classification analysis to differentiate key data points. - Clustering the data into discernable patterns to aid business decision making. Ideal skills for this job include Excel proficiency, data analytics experience, and an understanding of key business metrics such as KPIs, dashboards, classification, and clustering. A background in business data analysis and the ability to...

I'm in need of a professional who is highly skilled in Excel for a project involving 4-color conditional formatting. The project will focus predominantly on numerical data. Here are the essentials: - Proficiency in Excel is crucial - Deep understanding of 4 color conditional formatting, specifically with numerical data - Experience with setting color-coding based on specific values I'm looking for an expert who can swiftly and accurately apply this formatting to a substantial amount of data. Thanks for considering bidding on this project.

I'm looking for a video editor to enhance 5 educational videos (around 2-4 minutes per video). You can quote me per minute of adding in the text + the cost to add in the branding on each video. The primary goal is to insert key branding elements throughout the videos. These include: - My company's logo - A watermark - A small banner featuring the company branding at the bottom throughout the videos In addition, I would like the editor to incorporate subtitles at the bottom of the videos. The subtitles should be clear, easy to read, and complement the educational content. We will have the videos transcribed, will need you to match it up to the sound. The videos are in Spanish and Englis...

I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).

I find myself in need of a skilled freelancer to restore my suspended Google Business account. My account was suspended due to exceeding the storage limit, and I have been unable to fix this issue myself. The professional perfect for this job should excel in: - Google Business account restoration - Dealing with suspension issues, specifically exceeding storage limit - Providing tips and guidelines on how to avoid future suspensions due to storage issues The task includes confirming the suspension reason, working towards resolving it, and ensuring resumption of the account. Knowledge on dealing with Google's support system would be highly advantageous. Looking forward to working with you.

...expert to design a comprehensive report template that contains all the requisite sections for a detailed report. The ideal freelancer for this project should have: - A solid understanding of Microsoft Word. - Previous experience in creating professional templates or reports. The key sections that the report template should include are: - Title page - Table of contents - Introduction - Body - Conclusion - References Each section should be clearly defined and easy to navigate. For the title page, it should encompass the following elements: - Project title - Client's name - Date - Project logo - Project description - Title block I require standard formatting and styling for the title page and the entire document. It's ...