Excel macro to run formula jobs

...developing and implementing brand marketing strategies to boost our brand visibility. Key Responsibilities: - Craft and execute brand marketing strategies - Conduct market research to gauge audience preferences and trends - Aid in the creation of proposals, presentations, and product demonstrations - Develop sales materials such as brochures and case studies - Monitor and assess the impact of marketing initiatives - Analyze competitors' operations and identify their strengths and weaknesses. Desired Skills: - Strong analytical capabilities - Excellent marketing knowledge - Superb communication skills - A touch of sales experience. Ideal candidates will possess a BCA, MCA, B.E. or a relevant degree. Experience with tools like Microsoft Excel, Google Analytics...

I need assistance in entering mixed data, which is currently stored in digital files, into MS Word. Requirements: - Proficient in MS Word and data entry - Able to work with mixed data (text and numeric) - Experience handling digital files, particularly text files The data is sourced from various digital files including Excel, PDF and text files. Your role would primarily involve transcribing this into MS Word, so attention to detail and accuracy is crucial.

I need a freelancer to help with data scraping and organizing the information into an Excel file. The data source will be various databases. - Scope of Work: - Scraping email addresses and names/contact information from databases. - Organizing the data into an Excel file with separate columns for each data type. Ideal Skills: - Proficient in data scraping techniques. - Excel expertise, specifically in organizing and formatting data into separate columns. - Attention to detail to ensure data accuracy. - Previous experience with data scraping from databases is a plus.

I need a multi-purpose chassis designed for a heavy-duty construction vehicle primarily intended for excavation in mountainous terrains. The vehicle will face challenging conditions, so the chassis must excel in durability and flexibility. Key Requirements: - Design a chassis that can withstand tough, mountainous terrains while being able to adapt to different conditions and tasks. - The design should not prioritize being lightweight, but rather focus on durability and flexibility. - Previous experience in designing vehicle chassis, particularly for construction or heavy-duty vehicles, is highly desirable. Ideal Skills: - Mechanical Engineering - CAD Design - Experience with heavy-duty vehicle design - Knowledge of materials for durability - Creativity for flexible ...

... Use Google Sheets and Excel for data entry and management. Ensure all data entries are accurate and error-free. Submit daily progress reports. Required Skills: Proven experience in data entry. Proficiency in Google Sheets and Microsoft Excel. Ability to complete tasks within deadlines and maintain accuracy. --- If your project is related to Sales & Marketing or Translation & Languages, you can modify it accordingly. Example: Project Title: Content Writing for Marketing Campaigns Project Description: Create engaging and customer-attractive content for a new product launch. Write short yet impactful copy for social media ads. Ensure content aligns with the brand's tone and audience. Required Skills: Strong writing and marketing...

Project Description: We require a robust and scalable Project Management System built on Microsoft Power Apps. The system should allow users to manage projects, tasks, risks, budgets, and reports efficiently. The application will integrate with Microsoft tools like SharePoint, Power Automate, and Teams for seamless collaboration and automation. Project Goals: Centralized management of projects, tasks, and related data. Improved collaboration among team members. Automation of workflows for task assignments, approvals, and notifications. Advanced reporting and analytics for project tracking and decision-making. Core Features: 1. Dashboard Overview of all projects. Visual status indicators (e.g., progress bars, charts). Quick filters (by priority, status, department). 2. Project Man...

I need assistance with data entry. The data is mixed (text and numbers) and is currently in Excel/CSV format. The primary purpose of this data entry task is to populate a database. Ideal candidate should be proficient with: - Excel/CSV - Data entry - Attention to detail Experience with database management and data handling is a plus.

...looking to automate sending birthday promotion messages to a list of contacts via WhatsApp. Here’s what I need: What I Have: • An Excel sheet with nearly 2,000 contacts. o Each entry has:  Name  Contact number (with country code)  Birthday date • I’ve also got 2 promotional images and a message I’d like to send. What I Need: 1. Send WhatsApp Messages (direct from excel) two images I provide. 2. Reusable for Future Months o For upcoming months, I want to just update the Excel sheet with new names, numbers, and birthdays, and then click something to send messages to the new list. 3. Extras I’d Like: o Skip duplicate numbers so no one gets spammed. o Log which messages were sent successf...

...Persuasive Writing: I excel in writing compelling content that connects with readers and enhances brand engagement. Client Communication: I understand client needs and can craft clear, persuasive copy tailored to their target audience. Portfolio Examples: I have a portfolio showcasing my work, including blog posts, website copy, and product descriptions. Full Description: I am a skilled copywriter with a passion for creating content that not only informs but also engages and motivates readers. With a strong background in SEO and an understanding of client requirements, I produce copy that resonates with audiences and drives action. Whether it's writing persuasive product descriptions, creating blog content, or optimizing web pages for search engines, I am committed ...

... We are looking for a Python developer to help automate the extraction of data from screenshots. The project involves two key tasks: Screenshot Cropping Script: Develop a script to crop screenshots and isolate the relevant data sections, focusing on the area below the column headers. The cropping areas may vary slightly between different screenshots. OCR Data Extraction and Excel Conversion: Use OCR tools (like Tesseract) to extract text from the cropped images. Convert the extracted data into a structured format, and save it into an Excel file, with each piece of data placed into corresponding columns. Requirements: Proficiency in Python (Pillow, OpenCV, pytesseract). Experience with OCR for text extraction from images. Ability to work with...

I’m looking for someone to help integrate an instant quote calculator on my website, , which is on the Shopify platform. Key Features: The calculator should give price estimates based on the pickup and delivery locations. It should calculate pricing based on the distance between the locations. Price Quote Calculation Formula: Price Quote Parameters: Base Delivery Fee: $40 (This is the starting cost for the delivery, no matter how far it is). Base Miles: 5 miles (These are the miles included in the Base Fee with no extra charge). Additional Fee per Mile: $1.95 (For any distance beyond the base miles, there’s an extra charge per mile). Price Calculation Formula: If the distance is less than or equal to the base miles (5 miles), the price stays at ...

We need an experienced data researcher with the following skills: 1) Experience in Internet Research 2) Good English skills 3) Knowledge of google sheets & excel 4) Attention to detail This is a long term project.

Excel Data Cleaning: Removing duplicates, errors, and inconsistencies for accurate analysis. Excel Data Formatting: Organizing data into a clear and professional layout. Excel Dashboards: Creating interactive and visually appealing dashboards for data visualization. Excel VBA: Automating repetitive tasks and creating custom macros to save time. Pivot Tables and Charts: Summarizing and visualizing large datasets effectively. Data Analysis: Performing advanced calculations and trend analysis for insights. Conditional Formatting: Highlighting important data with rules and color coding. Formulas and Functions: Using advanced formulas (e.g., VLOOKUP, INDEX-MATCH) for dynamic calculations. Data Validation: Ensuring data accuracy with dropdown lists and validati...

...experienced Power BI developer to create a comprehensive report for our sales and marketing data. The ideal candidate should have a strong background in data visualization and analysis, with a proven track record of delivering high-quality Power BI reports. **Project Requirements:** 1. **Data Integration:** - Integrate sales and marketing data from various sources (e.g., CRM, ERP, Excel files). - Ensure data accuracy and consistency. 2. **Report Design:** - Create visually appealing and interactive dashboards. - Include key metrics such as sales performance, marketing campaign effectiveness, customer segmentation, and ROI analysis. - Design reports that are easy to navigate and understand. 3. **Data Analysis:** - Perform in-depth analysis to...

I need a Word document transposed into an Excel file. Key Points: - The original document contains text only. - Text organization within the Excel file is not uniform. It varies and will need to be explained. Ideal Skills: - Proficient in Microsoft Excel and Word. - Good understanding of data transposition. - Detail-oriented to ensure accurate transfer of content.

I need a comprehensive Excel spreadsheet containing the top 5,000 accounts. The data should include: - Number of followers - Social handle - URL link The accounts should be ranked by the number of followers. The ideal freelancer for this project should have experience in api data collection and Excel, with a proven track record of working with social media data. Attention to detail is crucial, as is the ability to source information from reliable platforms. Please do not submit junk data, or data you have not reviewed yourself. Send an excel file or google sheet document link. Thanks

I am seeking a talented freelancer who can help supercharge my Mighty Network dedicated to young professionals thriving in health and wealth. Here’s what I’m looking for: - Technical Assessment: Ensure the network, including the lead magnet (PDF via Kit) and 5-day challenge, is running smoothly. - Marketing Strategy: Develop and manage high-conversion ads with a focus on high ROAS, tailored to my target audience. - Outreach and Engagement: Craft and send direct text messages to my contacts, informing and engaging them about my Mighty Network. - Administrative Support: Handle ongoing admin tasks to maintain the network's efficiency. The perfect candidate will have: - Proven experience with Mighty Networks or similar platforms - Expertise in di...

I need a freelancer to help me gather real estate property addresses from public companies' websites. I will provide the list with 25 public companies with the URL to their properties. Save the list of properties for each public company in a separate Excel to avoid confusion. Please compile the data in a Microsoft Excel spreadsheet, and ensure to include the following fields for each property address: - Street Address - Address 2 (optional) - City - ZIP/Postal Code - Name (if applicable) - State - Country I will provide a sample template to help. Ideal skills and experience for this job include: - Proficiency in web research - Familiarity with Microsoft Excel - Attention to detail - Understanding of real es...

We are looking for a WooCommerce expert to customize the checkout process of a production store hosted on AWS VPS. The required changes are as follows: 1. Modify the billing form fields: • Change the field “Nombre de la empresa (opcional)” to “DNI/RUC” and make it mandatory. • Reorder the address-related fields to follow this sequence: Departamento (Department), Provincia (Province), Distrito (District), Dirección completa (Full Address, with an example as a placeholder). A detailed Excel file with the list of departments, provinces, and districts in Peru will be provided. 2. Shipping configuration: • Adjust shipping rates based on the provided list of Peruvian locations in Excel. • For destinations...

...report should be in Excel format. - Total earnings is calculated as: Gross Benefit + Worker Compensation + Net Salary. Gross Benefit is the total of all benefits in the salary master file from columns R to AV, excluding Federal Income tax, California Amount, and California SDI. Option to add inclusion or exclusion without changing formula. - The bi-monthly payroll needs to be consolidated from two lines per employee to one line summary report. - Class allocation percentages should be sourced from the class columns E to VU in the class allocation sheet, and must total 100%. Ideal skills and experience for this job include: - Proficiency in Excel, especially in data analysis and manipulation. - Experience with payroll data and unde...

I need some expert guidance with Excel formulas for a cap table. The focus will be on equity allocation. I have created the excel file and entered the different rounds but I need help with some of the formulas. Key Requirements: - Formulas to effectively distribute equity among stakeholders - Representative display of shareholder names, number of shares held and percentage ownership Ideal Skills and Experience: - Strong proficiency in Excel, particularly with complex formulas - Experience with cap tables and understanding of equity allocation - Ability to present data in a clear and comprehensible manner

I need a methodical and detail-oriented freelancer to assist with data entry from supplied aerial site images. Specific Tasks: - Using Google Maps to obtain GPS coordinates for 96 marked building locations on the aerial images. - Pasting these coordinates into a provided Excel spreadsheet template. - Manually verifying each entry to ensure accuracy. Automation is not an option for this task. Example provided for the Excel spreadsheet. Please note, only the GPS coordinates are required from Google Maps, with the building locations indicated by outlines on the aerial images. Ideal Skills: - Proficiency in using Google Maps - Excellent attention to detail - Ability to work methodically and systematically - Competency in Excel - Prev...

I'm seeking a dedicated freelancer to help gather data ( or share already researched data) on international students currently attending U.S. universities. The data should be comprehensive and cover a range of details about each student. Key Data Points Needed: - Student First Name - Student Last Name - Current U.S. City - Student University Email - Student Personal Email - Student Home Country - U.S. University Name - Degree Pursuing (Bachelor's, Master's) The ideal candidate will have: - Experience in data collection and research - Access to verified data - Ability to deliver in a clear and organized way Important Note: The home country of the student must not be the USA. I am open to data from any other region, and I will need this data reg...

...businesses, including content websites, SaaS companies, social media accounts, and mobile apps. They are committed to innovation, data-driven decision-making, and fostering entrepreneurship. I have been tasked to hire a PART TIME, motivated and analytical Venture Capital Intern to join our dynamic team. This paid internship offers hands-on experience in sourcing, analyzing, and evaluating potential business acquisitions. The role is ideal for individuals passionate about online businesses, financial and market analysis. As an intern, you will play a key role in the acquisition process by identifying opportunities, conducting in-depth research, and providing actionable insights to help drive strategic investment decisions. Key Responsibilities: • Dea...

create this data into a simple and engaging format to send to customers Cyberattacks are happening more frequently and causing greater damage, which is pushing organizations to improve their cybersecurity. These attacks are usually carefully planned and financially motivated. Cybercriminals specialize in different types of attacks like phishing, scams, malware, ransomware, and hacking, each using their own methods. To protect against these growing threats, companies need to strengthen their cybersecurity. In June 2017, the Australian Cyber Security Centre (ACSC) introduced the "Essential Eight" strategies to help businesses improve their security. However, companies should not rely only on these strategies and should add extra layers o...

I have a project that involves transferring data from PDF documents into an Excel spreadsheet. The documents are about 100 pages long and contain a mix of text and numbers. The successful freelancer will need to: - Accurately input this information into Excel in both alphabetical and numerical order. - Use a pre-existing template, with potential for adding or deleting columns based on predefined rules or guidelines. Ideal candidates will have strong attention to detail, experience with data entry and proficiency in Excel. Prior experience dealing with PDF to Excel data transfer will be highly regarded.

I need an Excel spreadsheet that can perform specific calculations with my numeric data. - The spreadsheet should be able to multiply specific columns together: Column B with Column E to get G, Column C with Column F to get H. - It should then add these two results together to fill Column I. - Next, Column I should be multiplied by Column J to fill Column K. - This sequence should repeat with Columns L through P and a few additional columns. Ideal skills for this job include advanced knowledge of Excel, particularly in using formulas for multiplication and addition across various columns. Experience with data management and numerical data analysis would also be beneficial. Please ensure you have a strong understanding of Excel's c...

I'm looking for an Office Administrator/Virtual Assistant to help with a variety of tasks. Key Responsibilities: - Email Management: Overseeing incoming and outgoing emails, prioritizing messages, and drafting responses when necessary. - Scheduling Appointments: Coordinating meetings, managing calendars, and ensuring no scheduling conflicts arise. - Data Entry: Accurately inputting information into databases and maintaining records. Virtual Assistant Duties: - Customer Support: Responding to customer inquiries, resolving issues, and ensuring a positive customer experience. - Research Tasks: Conducting online research for various projects and compiling findings in a clear and concise manner. - Social Media Management: Overseeing company social media accounts, posting u...

...experience delivering customized digital marketing solutions to clients across diverse industries. Skilled in developing strategies that drive traffic, increase brand visibility, and boost conversions. Dedicated to helping businesses grow their online presence and achieve measurable success. in-depth market research and competitive analysis to identify trends and optimize campaigns. , execute, and monitored multi-channel campaigns, including SEO, PPC, social media, and email marketing, resulting in 20% increase in lead generation. advanced Excel skills to analyze campaign performance, creating insightful reports for clients. visually appealing and professional presentations using PowerPoint to communicate marketing strategies and results effe...

i have the excel file you need to analyse the data and I want to you create advanced PowerPoint presentation presentation it need to be present to the big forums, primarily aimed to the top management. The presentation should reflect a professional and corporate style, with clear, concise content and well-structured slides. Ideal Skills and Experience: - Proficiency in PowerPoint - Experience in designing corporate presentations - Excellent understanding of corporate language and presentation etiquette - Ability to condense complex information into clear, digestible content - Creative approach to maintaining viewer engagement within a professional context.

...care industry and need a comprehensive Excel calculator to help me evaluate labor costs against revenue. Specifics: - The calculator should focus on tasks related to daycare and boarding. - It needs to track labor hours, the number of animals cared for, and the cost per employee. Ideal Skills: - Proficiency in Excel with advanced formula knowledge. - Experience in the animal care industry is a plus. - Ability to create user-friendly, intuitive spreadsheets. The goal is to have a tool that helps me make informed decisions about staffing and pricing based on labor costs and revenue from these services. It needs to be easy to use. Daycare pricing is set at $42/day and 35/half day and boarding at 65/night and labor ...

I need assistance with my business bookkeeping, with under 400 bank transactions across two accounts. All data is available in Excel sheets exported from my bank accounts. - Clean up and categorize the transactions. - Prepare a Profit and Loss (P+L) statement for the year 2024. The P+L statement will help me assess the financial performance of the business in 2024. I prefer using Excel for this task. Ideal candidates should have: - Proven experience in bookkeeping and financial analysis. - Proficiency in Excel. - Ability to categorize transactions at a basic level (e.g., income, expenses). - Capability to prepare a P+L statement without specific formatting requirements.

I need an existing Excel document converted into an updated fillable PDF. I have an original fillable PDF available for comparison. The project requires: - Updating form fields and layout - Adding new sections or fields The design elements from the original fillable PDF should be retained. The original fillable PDF is in Adobe Acrobat PDF format. Ideal skills for this project include: - Proficiency in Adobe Acrobat - Experience creating fillable PDFs - Strong attention to detail - Ability to work with Excel data

...profound understanding of options, stocks, and or etf trading to create a program aimed at trading on Alpaca. The program can implement "Straddle/Strangle", "Long call or puts" strategies, long or short stocks/etfs. Requirements: - An impressive success rate of 80%+ with a minimum of 40 trades each month. - A proven track record of achieving over 20% returns in the past month. - Profound knowledge and experience in options trading, specifically with the mentioned strategies. - Python programming expertise, with prior experience in developing trading programs. -Program must be continuously running and historic and live data should be from free api sources. (Or cost of service is considered against the month returns). -Daily dated excel file outputs of ...

...racing franchises. Key Aspects: - **Game Design**: The core design will be reminiscent of Mario Kart, but with creativity to incorporate elements from Formula 1, Need for Speed, Grand Theft Auto, and F-Zero. - **Track Development**: You'll help me design and create various tracks based on iconic designs from the aforementioned games. - **Modeling**: We'll need to develop and implement character models and kart designs inspired by Mario Kart. - **C++ Guidance**: As a beginner in C++, I'll need your expertise and mentorship to help me improve my skills while we work together. Goals: - **1 Week Timeline**: I'd like to see what we can accomplish in one week. Your ability to manage time and set achievable goals will be crucial. ...

... We are looking for a Python developer to help automate the extraction of data from screenshots. The project involves two key tasks: Screenshot Cropping Script: Develop a script to crop screenshots and isolate the relevant data sections, focusing on the area below the column headers. The cropping areas may vary slightly between different screenshots. OCR Data Extraction and Excel Conversion: Use OCR tools (like Tesseract) to extract text from the cropped images. Convert the extracted data into a structured format, and save it into an Excel file, with each piece of data placed into corresponding columns. Requirements: Proficiency in Python (Pillow, OpenCV, pytesseract). Experience with OCR for text extraction from images. Ability to work with...

I'm in need of a Java programmer who can create a small program for me. The program's purpose is to convert a PDF file into an Excel file in a tabular format. Key Requirements: - The program should be able to extract all data from the PDF and convert it into Excel. - The conversion should be straightforward, without any data processing or formatting applied to the Excel file. Ideal Skills: - Proficiency in Java - Experience with PDF to Excel conversion - Familiarity with data extraction from PDFs This is a simple project, but it requires attention to detail to ensure all data is accurately converted.

Hello. It's supposed to generate teams based on data from multiple sheets, but it doesn't work like I need. When I run the script it gives me an error and I can't solve it, can you help me?

I'm looking for an Excel expert to optimize my spreadsheet for data analysis. The primary purpose of the Excel sheet is to optimize sales price calculations. The project requires the optimization of the sheet to facilitate specific analyses and reports, including sales price calculations. Skills and Experience: - Advanced Excel skills - Experience with data analysis - Ability to create and optimize complex spreadsheets Please provide examples of previous similar projects you have worked on.

Objective: I want to create a professional online profile that showcases my skills, experience, and achievements as a Data Entry Specialist. The profile should be engaging, easy to read, and showcase my expertise in data entry, data management, and administrative support. Target Audience: My target audience is potential employers, recruiters, and clients who are looking for a skilled and experienced Data Entry Specialist. I want to attract opportunities in industries such as finance, healthcare, and technology. Key Skills and Experience: - Data entry and management - Attention to detail and accuracy - Organizational and time management skills - Proficient in Microsoft Office, particularly Excel, Word, and Access - Experience with data entry software an...

I'm working on my final year engineering project and I need to implement an offline feature. The project should be able to make certain content available without internet access, specifically Excel sheets and reports. Key Requirements: - The system should allow for editing and saving changes to these offline Excel sheets and reports locally. - Once back online, the system should ensure data synchronization. Ideal Skills: - Experience in software development with offline capabilities. - Proficiency in working with Excel and data synchronization techniques. - Understanding of engineering project requirements.

I need someone to match data between two Excel files and integrate relevant information into File A. Key Requirements: - Compare product names in File A and File B - Fill File A with corresponding data from File B (specifically UNIT SIZE, GST RATE, HSN CODE as per their product names ) Ideal Skills: - Proficiency in Excel - Attention to detail - Experience with data matching and integration. I look forward to your proposals.

I'm look...looking for an Excel spreadsheet that can help me track my daily sales, inventory, exports, imports, and expenses. Key Requirements: - Daily input fields for sales, inventory, export, import, and expenses - Monthly summary calculations for total sales, expenses, inventory balance, profit and loss, and exports/imports across multiple outlets - Detailed tracking capabilities for each product and product categories The ideal freelancer for this project would be well-versed in Excel, particularly in creating spreadsheets with complex formulas and functions. You should also have experience in designing user-friendly interfaces within Excel to make data entry straightforward and intuitive. Since the number of outlets is uncertain, the spreadsheet sh...

Do assigned excel tasks, design and support my freelance gigs on fiverr

...Project Using SQL, Excel, and Power BI Dashboard Description: I am looking for a skilled data analyst to assist with a project that involves data processing, analysis, and visualization using SQL, Excel, and Power BI. The project will require: Data Extraction & Cleaning: Extract and clean data from multiple sources using SQL. Ensure the data is accurate, complete, and properly formatted for analysis. Data Analysis in Excel: Perform statistical and trend analysis. Create pivot tables, charts, and perform calculations to uncover insights. Power BI Dashboard: Build an interactive and visually appealing Power BI dashboard. Include key performance indicators (KPIs), filters, and drill-down capabilities for detailed insights. Deliverables: Clean and ...

I have PDF files containing text data that needs to be transferred into an Excel spreadsheet. The final output will require the application of custom styles in the formatting. Ideal skills for the job include: - Proficiency in Excel - Excellent data entry skills - Attention to detail - Experience with custom formatting in Excel

I'm looking for a corporate strategy expert to develop an action plan for my collection department focusing on expediting dispute resolution. The primary goal of this plan is to enhance the efficiency of our dispute resolution process. Note - i have the excel file i can show you the data but not shareable you need to analysis the data and provide me the strategy and action plan. Key Requirements: - Analyze current collection & dispute resolution processes - Identify potential bottlenecks causing delays - Propose actionable strategies to streamline these processes Skills & Experience: - Proven track record in corporate strategy development - Experience within a collection department is a plus - Strong problem-solving skills - Excellent comm...

I'm seeking a VBA macro expert who can help optimize my code for faster execution. The macro is currently used for generating reports from data stored in Excel sheets. The main goal is to reduce the runtime of the macro to improve efficiency. Ideal Skills and Experience: - Proficiency in VBA programming - Experience with Excel-based data manipulation - Skills in code optimization and performance improvement - Ability to enhance code readability for future use Freelancers who can deliver a fast, efficient solution will be prioritized.

I need a comprehensive list of Defence canteen dealer contact numbers from specific cities in Madhya Pradesh - namely Bhopal, Indore, Gwalior, and Bhind. The information needs to be meticulously compiled into an Excel sheet. Ideal Skills and Experience: - Proficient in internet research and data extraction - Excel spreadsheet skills - Ability to work independently and self-motivate - Previous experience in similar data collection tasks is a plus.

I'm seeking assistance with specific small tasks in Excel that may require the use of VBA coding and formulas. Key Requirements: - Creating macros to streamline processes - Using the macros for data validation and cleanup Ideal Skills: - Proficient in Excel with extensive knowledge of VBA - Experience in creating macros - Capable of performing data validation and cleanup tasks