Vba excel update jobs

I'm currently working on an Excel sheet for performance analysis and I need assistance with writing the SUMIF formula. Key Requirements: - Assist with writing the SUMIF formula for my Excel sheet (vlookup, countif, and other formulas are not needed for this project) - Ensure the formula fits within the context of performance analysis Ideal Freelancer: - Experienced in Excel and in particular, writing SUMIF functions - Knowledge of performance analysis or related fields is a plus

I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me resolve these issues promptly.

I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can help me streamline my data management processes and turn this data into comprehensib...

I'm looking for a skilled Excel professional to help me create a custom inventory dashboard. Key Requirements: - The dashboard should focus on inventory management, specifically, visualizing product stock levels. - The data should be arranged in an intuitive manner that allows for quick and easy inventory tracking. Ideal Skills & Experience: - Strong proficiency in Excel, particularly in creating visually appealing and user-friendly dashboards. - Experience in inventory management, with an understanding of product stock levels and their relevance. - Attention to detail as accuracy in data representation is crucial for this project. - Good communication skills and a proactive attitude to ensure the project's success. Please note that due to the nature of this...

...and I would like to retain this when it is migrated. Key requirements: - Preserve the design layout and content structure - Ensure that the website's navigation is intuitive and user-friendly - Install a contact form plugin to allow visitors to get in touch easily The primary goal of my website is to inform and educate visitors. Therefore, it's crucial that the new WordPress site is easy to update and manage so that I can continue to provide fresh, engaging content. Ideal skills and experience: - Proven experience in WordPress development - Strong understanding of web design and user interface principles - Ability to preserve and improve upon the existing design and content structure - Proficiency in installing and configuring WordPress plugins, specifically contact...

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 Mac compatibility issues - Strong un...

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.

I'm seeking a skilled 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 website's search engine ranking - A creative...

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: Logo: vector (AI, EPS) and ra...

I am looking for a skilled social media marketer with content creation experience on LinkedIn and Twitter. The selected professional will be tasked with managing and nurturing my accounts on LinkedIn, Twitter, and Instagram. Key Responsibilities: - Develop 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 develo...

I'm looking for a 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 basic analysis on it. This will involve running s...

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 practical, real-world setting.

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

My site is experiencing various issues with the 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 fixing Wo...

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 documents with mixed content to Excel while maintaining layout integr...

I have a 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 other parts of the document. - Familiarity wi...

...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 html file(hundreds to thousands), each html file contain multiple tables(vary from 15-35, depend on each html file). Python to extract specific table and vertically stack them together to create an Excel file.(first column add html filename.) inside html file is encoded in chinese, so must use chinese to view it. table name/string partially e.g. "現金流量表" or "被投資公司名稱" or "資金貸與他人"or "轉投資大陸地區" or other name(later can be change). extract table based on table names/string. the table may not be there(depend on the html). If so just skip or single row ...

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

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): 1080 x 1080 pixels Lands...

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 'Category A' should be displayed. -...

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.

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.

I'm looking for a skilled professional who can assist me with updating product information on two PDFs. Additionally, I need a one-page "specials" sheet created 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 believ...

...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 developing membership or payment applications - Demonstrated ...

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 Attache...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 d...

...the website for an immersive viewing experience. • Website Speed Optimization: Enhance website speed with a sleek loader for faster loading times. • Footer Design Update: Revise the footer design for improved aesthetics and functionality. • Technical Optimization: Implement cache management, Google Analytics, meta tags, and backlinks for enhanced website performance and visibility. • Homepage Enhancement: Update the design of the homepage to be more interactive, responsive, and fast-loading. • Content Optimization: Enhance text content with quotes, highlighted words, and captivating copywriting. • Calculator Update: Improve the functionality of the calorie calculator by removing the login requirement, allowing users to gener...

I'm looking for a skilled Power BI developer who can create detailed financial reports and dashboards, primarily based 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, fin...

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 ChatGP...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 ple...

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 oper...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 templat...

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!

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 oper...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 templat...

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 oper...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 templat...

My current website needs updating. It's an electrical, solar, battery, and EV charger 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 eng...

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 Word 2010 and will be working with Java/Spring/JavaFX for the programm...

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

...into an Excel file with separate sheets for doctors' information and disease descriptions. Requirements: Programming Language: Preferably Python. Libraries: Experience with web scraping libraries like BeautifulSoup, Selenium, and data processing libraries like Pandas. Output Format: Ability to export data into an Excel file using Pandas or similar libraries. Error Handling: Robust error handling to manage failed requests and parsing errors. Compliance: Adherence to the websites' terms of service and rate limits to avoid being blocked. Project Scope: Input: A list of CRM numbers and a list of CID numbers. Process: Automate the lookup and data extraction process. Output: An Excel file with the compiled data. Skills Required: Web Scraping Python Programming...

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, and other financial details. I'm look...

Dough one Sources is 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 Tec...

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 accurately represents the updated data informa...

I'm in search of an Excel expert who can assist me with complex tasks in Excel. Specifically, help is needed in two key areas: - Formulas & Functions: While basic arithmetic operations are simple for me, I need assistance with text and date functions. - VBA Macros: I'm looking for someone who can develop advanced user forms and interfaces. This requires a high level of VBA expertise. The ideal candidate would have a strong background in Excel, with a focus on formulas, functions, and VBA. Previous experience working on advanced macros and a deep understanding of text and date functions will be a huge plus. The ability to communicate effectively and understand my specific needs is essential.

...half-duplex. 6a) The RS485 command should trigger an RGB LED sequence and the speaker sound effect. The command contains a reader ID. The reader accepts commands only if the reader ID matches. 6b) When an RFID card is applied, the reader reads a password-protected memory block and sends it to RS485 with the reader's 4-byte ID. 6c) The RS485 command should be able to change the reader's 8-byte ID and update it in EEPROM. 7) One or two digital sourcing outputs that can send a pulse to a lock or an indicator lamp. Let's say 500mA. 8) One or two digital inputs, sinking, working in the full range of the power supply voltage. 9) Power voltage range 5-26VDC. A decent capacitor must compensate for possible voltage drop when an output is energized. 10) External connections:...

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 Word 2010 and will be working with Java/Spring/JavaFX for the programm...