How to write excel formula in vba code jobs

Looking for someone with advanced skills in Excel and PDF interactivity who can transform a multi-sheet excel document into an editable PDF, while maintaining its ability to be converted back into an excel document. The purpose of this conversion is to enhance collaboration, hence the PDF should feature: - Interactive input fields that can be edited. - Checkbox and/or radio button functionalities. Also looking to add our company logo in the header and company info (addresses, phone numbers etc) in the footer. The ideal freelancer would not only support this conversion, but also maintain the original formatting to protect the sanctity of the document. Previous experience in similar work would be advantageous. L...

I'm in need of a seasoned freelancer who can help design a professional and engaging newsletter targeted specifically at newby freelancers. This is a recurring project, and I require the newsletter to be sent out on a weekly basis. Key Requirements: - Design and Set-up: I need someone with a keen eye for design who can make the newsletter visually appealing and professional. - Audience Focused: The content of the newsletter should be tailored and engaging for experienced freelancers, providing them with valuable insights and tips that can help them excel in their freelance careers. Ideal Skills and Experience: - Proven experience in designing newsletters, specifically for experienced professionals. - Familiarity with email marketing tools for manag...

...converting Excel formulas to Google Sheets, particularly with the VLOOKUP function. The problematic formula in question is central to my data analysis processes. I need a professional who can troubleshoot and effectively convert these formulas to be compatible with Google Sheets. Key Tasks: - Identify the source of the "IFERROR" error in the VLOOKUP formula as it functions in Google Sheets. - Modify the formula for accurate results in Google Sheets, ensuring it retains its original functionality post-conversion. Ideal Skills and Experience: - Proficient in both Excel and Google Sheets formulas and functions. - Strong experience with VLOOKUP and IFERROR. - Ability to troubleshoot...

I need assistance in creating a specialized budgeting spreadsheet focusing on drivers license renewal costs. As someone who understands the intricacies of financial data, your task encompasses the following: - Developing a budgeting spreadsheet with an emphasis on renewal fees. - Including a feature for expense tracking and an income versus expenses comparison. - Incorporating a mechanism for budget forecasts to plan my finances better. The ideal freelancer for this task should excel in financial data management and have a comprehensive understanding of Excel or similar platforms. Previous experience in creating budget planning or financial management tools would be a significant advantage. Let's simplify my financial management together.

As the client, I need a website that can function offline, primarily aimed at assigning 3D components to various errors. These components should be simple structural designs. The basis for the assignment of these components is a manual input system. Integrating a feature for capturing photos of these errors is also crucial for this project. Ideal skills and Experience: • Proficient in 3D designs • Web Development Skills • Experience with Offline Application Development Key Features: • Assign 3D Components to Errors (manual input basis) • Capture Photos of Errors • Offline Functionality

As the client, I am search of a seasoned virtual assistant to support me during typical work hours, 9am to 5pm (UTC +1). The ideal candidate will possess the following expertise: CRM MANAGEMENT: Monitor and manage follow-ups and sales activities within the CRM. Update and maintain accurate records of customer interactions and sales leads. Assist in developing strategies to improve CRM processes and efficiency. Customer Service: Respond to customer inquiries and resolve issues promptly and professionally. Maintain a high level of customer satisfaction through effective communication and problem-solving skills. Liaise with other departments to ensure customer needs are met. Email Management: Monitor and manage the CEO's email inbox, prioritiz...

Hi Nima D., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

Hi Nima D., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I'm in need of an experienced web developer with strong shell scripting skills. While the main purpose of the website application is not specified, it's targeted at the general public. Ideal Skills and Experience: - Proven expertise in web application development - Experience in creating websites geared towards the general public - Robust skills in shell scripting - Ability to independently make decisions to enhance website functionalities Note: As the tasks for shell scripting are undefined, a flexible way of working is preferred for meeting emergent needs in the project.

I am interested in finding software or a website that produces flowcharts (for an example see attachment file ). It must allow me to upload a file containing the definition of a flowchart and it creates the flowchart (see attached files and ). It will probably also allow me to manually create the flowchart one step at a time. There are three possibilities below: A (write app), B (find app) and C (find website). For B and C I will: 1. Milestone $5 and immediately release it to pay your FL fee when I hire you. 2. Milestone $10 for you to provide B or C below. 3. Release the $10 when you produce B or C. 4. Repeat 2-3 for each additional B or C that I need. For B or C you might have to ask the vendor/website for an example of a flowchart a...

Description: We are currently seeking a dynamic and motivated freelance cold caller to join our team and assist in prequalifying low-income prospects for our revolutionary no-cost health benefits program. This is an excellent opportunity for individuals who are skilled in high-volume cold calling and have a passion for helping others access essential healthcare services. Responsibilities: -Make outbound cold calls to potential prospects to prequalify them for our no-cost health benefits program. -Conduct approximately 100-200 calls per day with a focus on efficiency and effectiveness. -Engage prospects in a professional and empathetic manner to gather necessary information. -Use qualifying questions to determine eligibility based o...

I am seeking an RPA Developer to automate tasks relating to a list of codes (stored in a txt file, excel file, etc) and Web interaction, for a demostration of micro RPA possibilities Basically you will take 1 data from 1 excel cell (example cell d5) with that data you will create an hyperlink the link will be a fixed text + the code taken from excel you will open a broswer tab with that link IF one text is present in the resulting html response, you will close the tab, and repeat the process with the next data from the file If another text is present, you will "click" 3 or 4 following buttons Iterate with the next data from the excel file Until Excel's data EOF Everything configurable via external TXT file ...

I'm in need of a PHP developer to assist with resolving a specific issue within my code, and also adjust some functionality related to user balances and payment processing. - The issue is isolated to a certain part of the codebase. I have a video that comprehensively explains the problem, saving you time on debugging and troubleshooting. - The main issue at hand involves the necessity of adjusting user balances and funds for payments. This requires a high level of precision and understanding of PHP functionality. Ideal candidates should have: - Proficient in PHP and associated technologies. - Strong problem-solving skills to address the issue quickly. - Experience in user balance management and payment systems is highly desirab...

This is a juke box musical, i have a loose storyline. See the website with the same name.

We are an Ecommerce company ...dealing with variety products and we are looking for a Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain Write text for the posts Edit Pictures and videos in Canva or Capcut The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications and sales skills Can work on Excel Ha...

Hello there, We will translate your Excel file (Magic Jackpot Ads (Slots)) into Hungarian. Thank you!

...user-friendly Google Form and Excel template system. This system will be geared towards the hotel management sector and will be used for recording bookings, sales, expenses, and other business-related data. Key Requirements: - Design and Implementation of Google Form: The form should be intuitive and easy to use. It should have fields for recording bookings, sales, expenses, and other relevant business information. - Excel Templates: The gathered data from the form should be integrated into a set of Excel templates. These templates should be professionally designed and easy for hotel management to use. Your Role: - Your role will be to create a system that can manage multiple businesses. The system should serve as a plug and play solution that...

I'm in need of an experienced graphic designer to create a captivating, illustrative logo that stands out and reflects the essence of my brand. This design is crucial for my upcoming product launch, and I'm working on a tight deadline. **Ideal Skills and Experience:** - Strong portfolio in illustrative logo design - Ability to translate concepts into visual designs - Proficiency in Adobe Illustrator and Photoshop - Great communication skills and ability to work under tight deadlines **Requirements:** - Design a unique, illustrative logo that embodies my brand's values and essence. - The final logo must be scalable, as its primary use has not been defined yet; it could range from web applications to print materials or product...

I am in search of a competent female operations support assistant to aid me in daily tasks. Key Responsibilities: - Spreadsheet Management: You will be tasked with keeping our Excel sheets organized and updated to ensure seamless operations. - Report Generation: You will also be responsible for generating reports for our activities. These reports must be clear, concise, and error-free. - Daily Calls: You will make regular teams calls within the operations team. - Research & Analysis: The role will also require you to conduct research and analysis on various topics as needed. Your Excel Skills: I need a candidate who is proficient in Excel. An intermediate level of understanding and experience in Excel is a...

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.

We are an Ecommerce company ...dealing with variety products and we are looking for a Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain Write text for the posts Edit Pictures and videos in Canva or Capcut The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications and sales skills Can work on Excel Ha...

More details: Which version of Excel are you using? Excel 2016 What type of data processing do you need? Data sorting, Data filtering What specific criteria will you use for sorting the data? Numerical order It is required to set up a script that will process an Excel file every day, filter the file according to an algorithm and leave the necessary data in the file.

...company is seeking to expand its market by targeting hospital gift shops and independent pharmacies across North America. We are seeking a consultant to generate a comprehensive list of potential leads. This list will be used primarily for email and calling campaigns to promote and sell Nurse Yard's compression socks. Target Details: Independent Pharmacies 1. Type of Pharmacies: • Privately owned pharmacies that operate independently. • Small chains or groups of pharmacies under a single ownership. 2. Location Criteria: • Urban and suburban areas with high foot traffic. • Pharmacies located near medical centers or hospitals. 3. Service Offerings: • Pharmacies that provide a range of medical supplies, over-the-counter medications, and h...

...Data Engineer to join our dynamic team on a full-time or part-time basis. This role offers remote flexibility, allowing you to leverage your talent, skills, and extensive experience to drive our growth and surpass current limitations. The ideal candidate will thrive in a collaborative environment, inspire innovation, and demonstrate a self-motivated attitude toward excellence. Why Join Us: Joining our team presents an exciting opportunity to advance your career in the IT industry amid the remarkable growth of the US job market. As part of our prominent company, you'll contribute to cutting-edge projects that shape the future, positioning yourself at the forefront of innovation. With comprehensive support programs, we ensure a seamle...

Hi I will share the details with the shortlisted candidates. Thanks

I'm in urgent need of an expert in revenue summary analysis for my accounts assignment, to be completed ASAP. Areas of focus include: - Deciphering and analyzing an Excel file, which contains base financial data. - Providing a thorough understanding of the balance sheets, income statements, and cash flow statements in relation to the given data. Ideal qualifications: - Strong accounting background. - Proficiency in financial analysis and interpretation. - Familiarity with balance sheets, income statements, and cash flow statements. - Proficient in Excel data manipulation and interpretation. - Must be able to work fast as this task has a high-priority deadline.

I need a proficient Excel expert who can create an organized spreadsheet to track our monthly sales data. Key Requirements: - The spreadsheet should be organized by month. This means that the sales data for each month should be clearly separated. - The primary function required is to sum up the sales totals for each month. This will help us in tracking our sales performance over time. Ideal Skills/Experience: - Proficiency in Excel, with a good understanding of formulas and functions. - Prior experience in creating sales data spreadsheets would be a plus. - Attention to detail is crucial to ensure the data is accurately presented and calculated. Deliverables: - An error-free, well-organized spreadsheet that clearly present...

I need help with data entry. The task involves typing data from online sources into an Excel spreadsheet. Key Requirements: - Data Entry: The primary task is to accurately enter data from online sources into Excel. Prior experience in data entry is preferred. - Typing Skills: A good typing speed and accuracy are necessary for this task. - Familiarity with Excel: Basic knowledge of Excel is required to ensure the data is entered appropriately into the spreadsheet. - Attention to Detail: The data must be entered without errors or omissions, so attention to detail is crucial. The final deliverable should be an Excel spreadsheet with the data inputted neatly and accurately.

...and other recurring tasks. I am a fast, reliable, and trustworthy online worker. I helped many startups, entrepreneurs, and business owners achieve their business goals in the past. I am an excellent communicator with sublime linguistic skills, and attention to detail is my key skill. Ill follow your instruction for the letter and get back to you with fantastic results. Here are the services I offer: Data Entry Data Mining Excel Data Entry CRM Data Entry Data Scraping Copy Paste Work Data Conversion Shopify Product Listing WordPress Data Entry PDF to Excel or Word JPEG to Excel or Word Typing in Excel or Word E-commerce Products Listing Web Research and Web Scraping Please read the reviews from...

I'm in search of a professional Python developer with deep understanding in machine learning to assist with a project. Here's what you should know: - Unfortunately, I did not specify which machine learning tasks I needed support with, but your extensive knowledge in the field should enable you to adapt and adjust as necessary. - I'll require a machine learning source code that can be readily integrated into a project. The final outcome would be a robust, versatile source code that is free of bugs and scalability issues. - The entire source code base should be scripted in Python. If you are proficient in Python and have comprehensive experience in coding machine learning algorithms, you could be a p...

...materials. Currently, we're managing our inventory through Excel spreadsheets. It's getting increasingly cumbersome and we're looking to streamline the process with a dedicated inventory management software. Key Features: - I'm interested in a system that will have robust reporting and analytics capabilities. This will help us keep a close eye on our stock levels, sales trends, and overall inventory health. Ideal Skills and Experience: - Experience with developing inventory management software, particularly for food and maintenance materials - Proficiency in building systems with strong reporting and analytics features - Ability to create user-friendly interfaces for easy data input and retrieval - Experience working with Excel...

I need a mathematician to solve a number sequence and provide a formula so I can generate the next iteration of numbers as high as I can go.

I'm in need of a talented developer with experience in using Silvaco TCAD on Windows for an AlGaN/GaN HEMT device. The primary objective is to optimize device performance by refining three key parameters: - Power output - Efficiency - Frequency response Key Responsibilities: - Develop Silvaco TCAD code on Windows. - Simulate AlGaN/GaN HEMT device. - Optimize the device's power output, efficiency, and frequency response. - Provide a detailed report of the simulation results including the changes made in the code and the impact on the parameters. Ideal Candidate: - Proficient in Silvaco TCAD, particularly on Windows. - Strong background in semiconductor device modeling, especially in III-V compound semiconductors. - ...

I'm looking for a Virtual Assistant to grab leads, I’ll send material on how. It’s pretty simple. We'll specifically be targeting those who work in the nightlife industry and going down the research rabbit hole on Instagram. Ultimately I'm trying to sell high end social media services and night life people have access to a wealthy Rolodex so my goal is to gain a bunch of affiliates from this. Key Responsibilities: - Find mini partners (affiliates) in nightlife: vip hosts, promoters, club managers club partner companies, etc. - Inputing the above prospects info (names and emails) on a google excel sheet Skills and Experience: - Fast - Critical Thinker - Proficiency in using Instagram for business re...

I'm in need of a precise and efficient data entry operator to assist in entering numeric data into Microsoft Excel. The data will be provided in printed format. Key Responsibilities: - Accurately inputting numeric data into Microsoft Excel. - Ensuring data quality and consistency. - Meeting delivery deadlines. Ideal Skills and Experience: - Proficient in data entry. - Experience working with numeric data. - Advanced knowledge of Microsoft Excel. - Excellent attention to detail. - Strong time management and organizational skills. The successful candidate will be able to demonstrate a proven track record in data entry and will ensure the highest levels of accuracy and efficiency.

...that can find emails from LinkedIn Sales Navigator URLs. The emails need to be in Excel format. What I Need in Excel: - Name of the person - Email - Location - Designation Procedure: - I shall enter sales navigator ulr where multiple leads in pagination format displayes. - Software will pick each person url and find out his email (personal/professional) - Add that record along with above fields in excel sheet. Make sure software must not stuck, and i shall clear the payment after testing couple of days. Ideal Skills: - Proficiency in Python. - Experience in web scraping, particularly with LinkedIn URLs. - Familiarity with data manipulation in Excel files. This project is ideal for someone with a str...

I am in need of a data analyst who can dissect reports and extract necessary data daily. The task involves delving into data reports and accurately churn out meaningful information in required format. Your responsibilities include: * Analyzing various reports. * Precisely capturing key information based on pre-decided format. This project requires someone with Eye for Details, Working knowledge of MSOffice especially Ms Excel. Good English communication acumen, to understand and interpret data and derive meaningful information. Understands general market & business terminologies, Able to invest atleast 4-5 hours daily. Ideal time between 2pm to 7pm IST. Proficiency in interpreting data and a keen eye for details are highly recommende...

I need assistance with performing formulas, calculations and descriptive analysis in Ms Excel. I am specifically focused on analyzing data using measures of central tendency - mean, median and mode. - **Tasks** - Insert and calculate formulas regarding the mean, median, and mode in the data. - Conduct descriptive analysis on the dataset. Ideal freelancers for this project should have strong analytical skills and extensive experience with Excel's formula and calculation functionalities as well as knowledge of statistical analysis. An understanding of central tendency measures (mean, median, mode) is crucial.

Seeking a proficient individual who is knowledgeable in Excel for data entry and calculation formula tasks. The project involves: - Manual data entry - Creating complex formulas - Maintaining a spreadsheet with 10-50 columns and rows Ideal skills and qualifications: - A high degree of precision and accuracy in data entry - Strong knowledge of, and experience with, Excel and its formulas. I would like my 24 month forecast converted to an excel spreadsheet so i can adjust inputs and project further.

...ability to select which data sets to compare. Your task will be to: - Determine the average salaries over the course of these years. - Identify notable trends in wage changes over the specified time period. - Make in-depth comparisons between the various organisations in terms of wage dispersion. Ideal candidates will have significant experience working with large datasets, particularly those concerning wages and salaries. Proficiency with Excel or a similar tool is essential. Strong attention to detail is also a must as you will need to interpret complex wage data. Furthermore, previous exposure to HR analysis would be a plus, as it adds context to the data. Your analysis will greatly help us in mak...

I'm looking for someone proficient in Python to convert a PDF file into a JSON format. 4 PDF and 2 excel. Ideal skills and expertise to complete this project include: - Proficiency in Python programming - Experience with PDF parsing - Knowledge of JSON formatting and structuring The project involves extracting and transforming data from a PDF file into a structured JSON format. If you're confident in your Python abilities and have experience working with PDFs and JSON, I'd love to hear from you.

...need a skilled graphic designer to embed my logo into a custom-colored QR code for promotional purposes. Key project aspects: - Incorporating Logo: The task involves embedding my logo into a QR code seamlessly, making it appear as an integral part of the code. - Custom Color Scheme: I require the QR code to be designed in colors that match my brand's color palette. The color scheme should be eye-catching while maintaining the functionality of the QR code. The ideal candidate for this job should have: - Proficiency in graphic design, with a keen eye for aesthetics and branding. - Experience in creating QR codes and understanding their functionality. - Ability to understand and work with brand guidelines ...

...entry analyst with the ability to create comprehensive data visualizations on Excel. The successful candidate will be tasked with: - Creating a variety of visualizations including charts, graphs, and dashboards from our data sets. - Visualizing key data elements like sales data, customer demographics, website traffic, and financial performance. - Updating the visualizations on a weekly basis to maintain relevance and accuracy. Ideal candidates should have a strong background in data entry and analysis, as well as exceptional proficiency in Excel and data visualization tools. Skills: - Data entry and analysis - Proficiency in Excel - Experience with data visualization tools Additional Skills: - Good understanding of charts, grap...

I need an experienced PHP developer to fix some issues in our existing code. The main problems are with the Search functionality and the Database Connection. Key responsibilities: - Fixing the broken search functionality - Resolving the database connection issues Your application should demonstrate: - Proven experience in PHP - Understanding of database connections and search functionalities - Good problem-solving skills Please include relevant experience in PHP in your proposal.

I need to create an Excel dashboard to visualize our inventory data. It's not a complex task and should take around 20 to 30 minutes. What I need: - Display of inventory data on the dashboard using charts and tables - The table should contain: Ideal skills for this project: - Proficiency in Excel and creating visually appealing dashboards - Understanding of inventory data and its representation in tables

I'm in need of a skilled professional who can create a WiFi controller with a QR Code generator for my Aruna 9012 default captive portal. Key Project Requirements: - WiFi Access Control: This system should allow me to control access to my network based on both time and specific user permissions. - QR Code Generation: The project will require the generation of various QR code types: - Static QR codes: These QR codes will be unchangeable and ideal for permanent access of the network. - Dynamic QR codes: These QR codes must be generated on the fly and will allow immediate, temporary access to the network. - Customized QR codes: I would also like the ability to customize the QR codes with my branding or other information....

I'm in need of someone who can assist with data validation and verification tasks in Microsoft Excel and help with managing payroll. Key Responsibilities: - Data Validation and Verification: This involves assessing the data's accuracy, completeness, timeliness, and consistency. Proper validation ensures that our records are reliable and correct. - Payroll Management: This task involves ensuring that all employees are paid correctly and on time, calculating wages, tracking work hours, and making necessary deductions. Experience in payroll systems or software is a plus. Ideal Skills: - Proficiency in Microsoft Excel - Experience with data validation and verification - Previous payroll processing experience - Attention to detail and...

I require a freelancer skilled in data entry. Unfortunately, I was unable to determine the specific type of data entry needed, total entries required, and the format of the data. However, I am seeking a dependable professional who can adapt to different tasks. Ideal skills include: - Strong attention to detail - Data categorization - Data verification - Data conversion The applicant should be proficient in Excel, CSV, and PDF. This role is likely to involve handling various types of data, so versatility is key.

...seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to und...

...detail-oriented individual to assist with a data entry project. The task involves entering a variety of data types including numeric, text, and alphanumeric, into an Excel file. Key Details: - You will be working with a spreadsheet that has more than 10 columns. - I require the data to be formatted in a specific way: - Color coding: Certain cells should be filled with specific colors. - Conditional formatting: Cells should be formatted based on specific criteria. - Data validation rules: Certain cells should only accept specific types of data. Skills required: - Proficiency in Excel, including experience with conditional formatting, data validation, and color coding. - Strong attention to detail to ensure accurate d...