How to mass update formulas in excelJobb

I'm in need of a proficient Excel expert who has a solid understanding of Excel macros and compatibility issues with Excel for Mac 2018 or later. The project involves assessing and modifying an existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior experience with Excel for M...

I'm in need of an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projected in one place as a dashboard.

...SEO expert to enhance my Google profile. Here's the full scope of the project: - **Keyword Optimization**: My website currently has a moderate ranking on relevant keywords. I need you to optimize the keywords for better search engine visibility. - **Profile Updation**: I'm looking to update my Google profile to better cater to local customers. This may involve changes in the description, contact information, or other details to make it more appealing to my local audience. Ideal candidates for this project should have: - Proven experience in SEO and Google profile optimization - A strong understanding of keyword research and optimization - The ability to analyze and act on the current state of my web...

Entries without a cover image will not be considered! I want the entry image to be a screenshot of my profile with your work overlaid on the profile picture and cover image. Greetings talented designers! I am Catalin Tiriplic, a freelancer specializing in video editing and graphic design under the name DoofDesigne. We are looking to update our logo, profile image, and cover image for our online platforms. Requirements: Logo: Modern and professional, reflecting our creativity and professionalism in video editing. Clear, memorable, and representative of our services. Profile Image: Integration of the new logo. Abstract design or AI-generated artwork, without my photo. Cover Image: Design coherent with the logo and profile image. Format: L...

...engaging and relevant content for LinkedIn and Twitter - Regularly update and manage my LinkedIn, Twitter, and Instagram accounts - Implement strategies to increase brand awareness and generate leads Ideal skills and experience: - Demonstrable prior experience in creating content for LinkedIn and Twitter - Proven track record of managing and growing social media accounts - Understanding of social media analytics and ability to leverage data for campaign improvement - Excellent communication skills and creative thinking to develop compelling content This project requires someone who can not only create engaging content but also understands the various nuances of different social media platforms. The successful candidate will be able to help me ...

...skilled Excel professional to clean a text-based dataset for me. The dataset is not massive, but it's quite messy. The data cleaning task is relatively straightforward and basic. You'll have to perform operations such as removing duplicates and adjusting formats. Ideal Skills and Experience: - Proficiency in Excel: You should be comfortable working with large datasets in Excel, including applying formulas and functions. - Data Cleaning Expertise: Prior experience in cleaning text data is a major plus. - Attention to Detail: The devil is in the details; I need someone who won't overlook small nuances in the data set. Once the data is cleaned, I'll need you to carry out some...

I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Excel skills in a p...

Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.

Develop macro-enabled Excel file to handle CSV

...theme. I'm looking for someone to improve the site in the following areas: **Performance**: - The site has been loading slowly which is frustrating for users - I believe there are some broken links and pages that need fixing - Edit button is not working. - Need to update wordpress and PHP version **Design & User Experience**: - The current theme or layout is not working as intended and everytime click on edit button it show error. - I'd like help in adding more products and service. it to be more user-friendly and visually appealing. - Need to add products and service menu button and page - Add banner on front page - change wording. I need someone with: - Proven experience in optimizing and fixin...

I'm in need of a professional who can convert a PDF document to Excel format. The PDF contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience in converting PDF docume...

...scanned PDF document that needs some alterations. The primary tasks include changing the company name and updating contact information. Your expertise in both text editing and formatting is crucial for this project. Key Tasks: - Change company name: The new name should be seamlessly integrated into the document, replacing the existing one. - Update contact information: The current contact details in the document need to be replaced with the new information provided. Skills and Experience Required: - Proficiency in PDF editing: Experience with editing text in scanned PDFs is necessary, as the document is not in its original format. - Attention to detail: It's essential that the changes are made accurately without affecting ot...

...written a Python code to extract a table from an HTML file. I need an expert in Python, Pandas and BeautifulSoup4 to review and make minor adjustments as necessary. The purpose of the table extraction is for data analysis. The HTML file has multiple tables with some nested elements, not overly complex. Key Requirements: - Need an expert in Python programming - Familiarity with Pandas and Beautiful Soup - Experience in data analysis The job mainly involves reviewing the existing code, fixing any issues that may hinder the data extraction, and ensuring that the extracted table is ready for analysis. Please note that no additional data preprocessing is required, just fixing the current code. --- name "iXBRL" , inside folder contain multiple...

Ho bisogno di un programma che mi permetta di aggiornare disponibilità e prezzo di vendita dei prodotti presenti nello store shopify partendo da un file excel/csv che viene generato automaticamente ogni x ore e viene esportato dal getionale su cartella FTP

I'm looking for a talented WordPress developer to help me with some fixes and updates on my website. The project includes: - Updating existing content: I need to refresh the existing content on my website. This involves tweaking language, adding new information, and ensuring a consistent tone across all pages. - Improving site speed: It's essential that my website loads quickly and efficiently. I need someone who can assess the current speed of my site and implement the necessary changes to improve it. Ideal candidates should have: - Proven experience in WordPress website management - Proficiency in content creation and editing - Strong understanding of website optimization and speed enhancement

I have made an extension which likes posts of fb one by one and after 5 seconds, page refreshes and then likes new post again one by one. The post which is already liked remains as it is. I am facing an issue that after 1 hour my I'd gets logged out. Mujhe bas yeh chaiye ki vo Waps se login ho jaye I can pay max : 600 rupees

I have a project that requires purely text data entry. I have a set of handwritten notes which need to be entered into a spreadsheet. Key Requirements: - The data is text-based, and it's crucial that the freelancer can transcribe this accurately and efficiently. - Proficiency in using spreadsheet software like Excel or Google Sheets is a must. Ideal Skills: - Fast and accurate typing skills - Proficient in using spreadsheet software - Experience with data entry, especially from handwritten sources

Updating firebase implementation and app side implementation for new functionality

...detail-oriented and web-savvy freelancer/contractor to build a comprehensive database of sign manufacturers/companies in France. Project Scope: • Research and identify qualified sign manufacturers/companies/suppliers/sellers/stores across France. • Utilize various online resources, including: o Search engines (Google, Bing, etc.) o Social media platforms (Facebook, Instagram, LinkedIn) o Industry directories and publications (list specific resources if known) o Business databases (mention specific databases if known) • Gather and verify contact information (name, email, phone number) for each lead. • Compile lead data into a Excel format . Qualifications: • French reading and understanding - ONLY • Excellent research and data collecti...

Objective: To create three different format Facebook ad graphics based on the provided base image. The ad will promote job openings for truck drivers at D'Agostino, incorporating specific text and map location changes. Scope of Work: Text Modifications: Update the offer details as specified. Change "Tilbury, UK" to "Purfleet, UK". Add a new map location: "Verona, IT". Change the footer address from "DN1, Gilău" to "Floresti, Cluj". Map Updates: Replace the map location for the UK. Add a new location for Verona, IT. Format Variations: Create three different ad formats: Square (1:1), Landscape (16:9), and Portrait (4:5). Deliverables: Three different format images for the Facebook ad: Square (1:1): 108...

I need an Excel tool that can sort data by category and provide users with an interactive experience. I'm looking for an experienced Excel developer who can create a user-friendly, yet advanced, Excel tool. The tool should have the following features: - **Filtering**: The tool should allow users to filter data by category. This is a crucial aspect of the tool's functionality, as the data will be organized by this field. - **Interactive Buttons**: I would like the tool to have buttons that allow users to sort data. When a button is clicked, the data should rearrange itself based on the selected category. For example, when a user clicks on the button related to 'Category A', all data entries related to 'Categ...

From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.

I'm in search of a proficient writer with a strong grasp of mass transfer operations, specifically in the context of humidity measurements and cooling towers. The reports I need should cover both these subjects and offer an overview with basic principles. Key Responsibilities: - Crafting comprehensive reports on humidity measurements and cooling towers - Ensuring that the content is structured, informative, and provides an overview of the topics - Incorporating fundamental principles of mass transfer operations in the reports Ideal Skills & Experience: - Proven experience in mass transfer operations, distillation, absorption, and extraction - Strong research skills and the ability to present complex concepts in a cle...

Update for the app only. Submit new update of the app only

I'm looking for a professional who can help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple format for my tables, in line with a minimalist style. Ideal Freelancer: - Proficient in Excel, with a deep understanding of formula creation. - Experienced in table formatting and design, with a flair for minimalism. - Able to deliver high-quality, error-free work in a timely manner.

...with a professional and corporate style. This sheet should be in line with our company's branding guidelines. Key Tasks: - Update product information in two PDFs - Design a one-page "specials" sheet - Ensure the design is professional and corporate, adhering to our branding guidelines Ideal skills and experience: - Proficient in Adobe Acrobat for PDF editing - Strong graphic design skills and experience in creating corporate designs - Ability to follow existing branding guidelines while designing new assets - Attention to detail to ensure all changes are implemented accurately If you believe you have the right skills and experience for this project, I'd love to hear from you. Please provide ex...

I am looking for someone with experience in Comsol simulation to help with piezoelectric energy harvester design at the earliest, ideally within a week. - Beyond the simulation work, I need someone with strong documentation skills. - Required: 1) Generated voltage and power for applied strain% (like in cantileve) 2) Device capacitance, resonance frequency & impedance 3) Piezo strain coefficients for device geometry 4) Displacement (actuation) for different voltage 5) Sensitivity (output) for different level of stimuli (added mass in grams and pressure)

I need a dedicated Android developer to create an intuitive and secure membership application. The app is expected to include the following core features: - User Registration: A seamless and user-friendly registration process that captures necessary details. - Login: A secure login system that ensures data protection. - Profile Management: An easy-to-navigate profile section that allows users to update and manage their information. Additionally, the application must integrate a payment processing system. In this regard, the app should support credit card payments. Ideal skills and experience for this project include: - Proficiency in Android development - Expertise in UI/UX design and user flow - Prior experience in develo...

I have an Illustrator file that needs some text changes. All the new text content is ready, so the task mainly involves swapping out the existing text with the updated content. Ideal skills and experience for this project: - Proficiency in Adobe Illustrator - Strong attention to detail - Ability to follow instructions accurately Attached is a sample. Required modifications. 1. Change bar code. 2. Tidy up the text. 3. Duplicate the file and update some text. 4. Resend me with the right dimensions.

...looking for seasoned freelancers to enhance my Epic Fitness Coach website. The improvements should focus on user-friendliness, interactivity, responsiveness, and aesthetics. Project Requirements: • Forms and Thank You Pages: Implement forms, thank you pages, and email responses for seamless user interaction and lead generation. • Contact Options: Replace the contact button with a simple white band featuring options to schedule a call or contact via WhatsApp. • SEO-Optimized Blogs: Develop engaging blog content focusing on relevant keywords and SEO best practices. • About Us Section: Revamp the About Us section to be concise, interactive, and visually appealing. • Live Chat Support: Integrate a live chat feature for real-time ass...

More details: *What specific type of claims do you expect the expert consultant to identify? Delays, Cost overruns, Scope changes *How many projects do you need the expert consultant to review? 4 *Project documents will be supplied. *Reference Contract: FIDIC Red Book *How soon do you need your project completed? ASAP

...on data from Excel spreadsheets. Key Responsibilities: - Develop compelling, visually appealing reports and dashboards that are easy to interpret and navigate. - Tailor the reports and dashboards specifically to financial analysis, ensuring they provide the insights necessary for informed decision-making. Ideal Candidate: - Proven experience creating financial analysis reports and dashboards in Power BI. - Proficiency in integrating data from Excel spreadsheets. - Strong attention to detail and the ability to translate complex financial information into clear, concise visual elements. This project requires a high level of expertise in Power BI, financial analysis, and data visualization. If you're a Power BI exper...

I have 20 pages that need some content generated from ChatGPT and entering on to the page. This includes a short bit of text (150 words) for the main content and YOAST meta descriptions. I'll provide full instructions and the correct prompts to use with ChatGPT. This is a super simple copy and paste job and should only take a couple minutes per page. Please be familiar with WordPress and ChatGPT so you can get this done quickly. Also you will need to update the DNS in your local hosts file to be able to access the site (I can show how) This is 1hrs work at most so please bid accordingly.

Python Script Developer for Photoshop Automation & WordPress/WooCommerce Integration We are seeking a freelance Python developer to create a script that automates Photoshop tasks and integrates with WordPress/WooCommerce for product customization. The script will: Develop a Python script to automate Photoshop operations. Integrate the script with WordPress/WooCommerce to retrieve order details. Automatically open Photoshop and modify PSD files based on customer orders. Update text layers with customer input and save customized templates as JPG/PDF.

Hello, I am currently looking for an experienced graphic designer to refresh my company's logo. It's a modern styled logo and I'd love to retain the current color scheme. However, the key to this update is that I want the refreshed version to be much more dynamic. Ideal skills and experience: - Proven graphic design experience - Strong creativity and design skills - Ability to understand and incorporate company color schemes - Good understanding and previous experience in branding - Experience in creating dynamic logo designs Looking forward to receiving your exciting proposals!

I'm seeking a seasoned back-end engineer with expertise in Node.js and MongoDB. Your primary responsibility will be developing APIs that integrate seamlessly with external services. Key tasks include: - API development: You should have a proven track record of creating robust, efficient APIs. - Integrating with third-party services: The APIs you develop need to be able to communicate effectively with a range of external platforms. - Database design and optimization: While not the core focus, a strong understanding of MongoDB and how to optimize it for performance and scaling is beneficial. The project is centered around building a backend system that can handle a variety of tasks and interactions. While the exact scale of the project isn't cur...

Python Script Developer for Photoshop Automation & WordPress/WooCommerce Integration We are seeking a freelance Python developer to create a script that automates Photoshop tasks and integrates with WordPress/WooCommerce for product customization. The script will: Develop a Python script to automate Photoshop operations. Integrate the script with WordPress/WooCommerce to retrieve order details. Automatically open Photoshop and modify PSD files based on customer orders. Update text layers with customer input and save customized templates as JPG/PDF.

Python Script Developer for Photoshop Automation & WordPress/WooCommerce Integration We are seeking a freelance Python developer to create a script that automates Photoshop tasks and integrates with WordPress/WooCommerce for product customization. The script will: Develop a Python script to automate Photoshop operations. Integrate the script with WordPress/WooCommerce to retrieve order details. Automatically open Photoshop and modify PSD files based on customer orders. Update text layers with customer input and save customized templates as JPG/PDF.

We are seeking experienced lead generation professionals to assist in identifying companies raising equity capital for a growing company over the next 3-6 months. Ideal candidates will have a strong background in financial services and a proven track record of successfully raising equity capital for companies and funds in the growth stage. SKILLS AND EXPERIENCE REQUIRED: 1. Proven experience in lead generation within the financial services sector. 2. Successful track record in raising equity capital for growth-stage companies. 3. This project requires a proactive and results-oriented approach. 4. The successful freelancer will work closely with our executive team to develop and execute a comprehensive capital-raising strategy to su...

...business site, and I'm looking for an experienced web developer to update the site using Bluehost and WordPress. The job will involve the following: - Updating Content & Photos: The site's content and images need to be refreshed to reflect my business's current offerings. - Redesigning Layout: I want the website to have a fresh, modern look that aligns with the services I provide. - Adding New Features: I'm open to suggestions here. A few ideas could be online appointment booking system, product catalog, or live chat support. Additionally, there are a few key areas where I'm seeking recommendations: - SEO Enhancements: The site should be optimized for search engines to attract more visitors. - Performance I...

I'm looking for a skilled and detail-oriented professional to assist me with entering handwritten data into a digital format. - The data is simple text-based, so no complex calculations or formulas are involved. - The main task will be to accurately transcribe data from scanned or handwritten documents into a spreadsheet. - Attention to detail is paramount, as even small errors could cause significant issues down the line. Ideal candidates should have a proven track record of accuracy and efficiency in data entry tasks. Prior experience handling handwritten or scanned documents is a definite plus. A keen eye for detail and the ability to maintain focus over extended periods of time will be essential for this project.

I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently using ...

I want a script that reads me some JSON files and enters the data in each of the custom WordPress fields, and creates new articles if they are not created and if they are, I update them.

I have a list of 50000 urls, I would like to scape the pages to see if they contain references to scripts - I will provide a list of the urls and the scripts. Deliverable should be an excel with the 50000 urls and whether they contain the link for each script. Looking for fast turnaround

...are looking for an experienced developer to automate the process of retrieving data from specific websites using CRM and CID numbers. The goal is to develop a script or tool that will: Look up Doctor's Specialization: Use CRM numbers to search on the website: CFM Doctors Search Extract doctor's information including their specialization. Look up Disease Descriptions: Use CID numbers to search on the website: MedicinaNet CID10 Search Extract the disease description. Deliverables: ( ) A script or tool that can take a list of CRM and CID numbers as input. Automate the search process on the specified websites. Extract the required data and compile it into an Excel file with separate sheets for doctors' information

I'm looking for a skilled developer who can link our existing Google Sheet with Tranferz API. We need the API to retrieve and update data on our sheet based on the following specifications: - Fetching and updating Driver Information: The API will need to fetch and update data related to drivers. This includes their availability, current location, and other relevant details. - Displaying Ride Details: The API should be able to fetch and display ride details for each driver. This information is crucial for the drivers to efficiently manage their schedule and assignments. - Updating Payment Information: It is essential that the API updates payment information in our Google Sheet. This includes payments received, pending payments, a...

...looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 300 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge o...

Hello, I need convert a PDF invoice to Excel to import to our invoices software

I'm looking for an experienced Power BI developer to create bespoke reports and dashboards, which will be integrated into Microsoft Teams. Tasks: - Handling data from Excel spreadsheets and converting it into insightful reports and dashboards. Skills and Experience: - Strong command of Power BI for report and dashboard creation. - Proven experience with Excel spreadsheets. - Good knowledge of integrating Power BI into Microsoft Teams. The goal is to make complex data easy to understand, facilitating better decision-making within our team. Your work will directly impact our day-to-day operations and strategies.

I am in need of a specialized WordPress developer with experience in Excel operations and data showcasing. Key tasks: - Create a WordPress page that extracts numeric and text data from an Excel sheet. - Implement highlights and color-coded information on the webpage for better readability and understanding. - The data on the Excel sheet will be updated on a monthly basis, hence the website should be able to fetch the data automatically upon any modifications. Ideal skills: - Proficiency in WordPress and Excel integration - Experience in creating visually appealing data showcases or infographics - Strong understanding of data extraction and display technologies The aim is to have a user-friendly webpage that accu...