Excel vba code optimis jobs

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.

...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 making compelling inferences about wages in our company, ultimately guiding us in our compensation strategies for different de...

I have a small scale data entry job that involves less than 100 entries. The data will be provided in a digital file format such as Excel or Word. Key Requirements: - Accurately input the provided data into the specified format - Ensure precision and attention to detail - Timely delivery of the completed data entry task Ideal Skills and Experience: - Proficiency in data entry - Strong command of Microsoft Excel or Word - Attention to detail and accuracy - Ability to complete the task in a timely manner

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.

I 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 to create a cohesive design. - Strong commu...

I'm seeking a skilled data 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, graphs, an...

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. Skills and Experience: - Proficie...

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 accuracy in data entry - Strong or...

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 atte...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 versatili...

I’m 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 understand and improve current systems...

...looking for a 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 data entry. - Efficient and r...

I need a freelancer to google search email addresses (also few addresses which are missing) & copy paste in to an Excel sheet. Need approximately 800-950 records done in 1 day. Will go with the lowest bid.

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 atte...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 versatili...

Excel sheet pahun tuze Mark chukale asle tar por pathvin hai na ki tu khana kha liya ky

I'm in urgent need of an experienced thumbnail creator to generate striking, ...experienced thumbnail creator to generate striking, vibrant thumbnails for various platforms such as YouTube, websites, and social media. *Style and Theme* Your designs should exude a colorful theme that's enticing and eye-catching. *Thumbnail Content* Each thumbnail should have captions incorporated in the design. The text should be readable without distracting from the overall appeal. To excel in this project, you need to be a skilled designer with a knack for creating visually stunning and colorful thumbnails. You should also have practical knowledge of designing for different platforms, and understand how to incorporate text seamlessly into your work. Past experience in a similar role w...

...implementing a QR Code system. The system will involve each paint tin being assigned a unique QR code, which will be printed onto a sticker. This QR code will have the product name and product code printed underneath it. Key Tasks: - Generating a unique QR code for each paint tin - Printing the QR code and product details on a sticker in color - Ensuring the QR code can be scanned by mobile devices - Ensuring the product name and code are prominently displayed - Ensuring the stickers are durable and able to withstand the paintshop environment This system will serve a few purposes: - Tracking Consumption: Our staff can scan the QR code when they use up a tin, allowing us to track consumption in real-time. - Faci...

I'm seeking an Excel expert to help with a data analysis project. The spreadsheet is set to a high level of complexity, requiring a mix of data analysis and data cleaning tasks. Key Tasks: - Data Analysis: I need someone who can set up the spreadsheet as a dashboard, and perform data analysis tasks. - Data Cleaning: You need to handle the data cleaning part of the project. This involves removing duplicates, handling missing values, and standardizing data formats. The ideal professional for this job will be experienced in: - Advanced Excel functions, including data analysis and building dashboards. - Proficient in data cleaning techniques. - Able to work with complex data sets. The project will require attention to detail and a high level of accuracy. If you have the r...

I need someone to help with offline data entry. The task involves entering less than 1000 entries into an Excel spreadsheet. Accuracy is key as the data will be used for business analysis. Ideal Skills and Experience: - Proficiency in offline data entry - Advanced Excel skills - Ability to maintain high level of accuracy - Previous experience with similar tasks is a plus

I have a data entry task that involves inputting text data into a digital format (e.g., Excel, Word). The primary goal of this task is record keeping. Key Points: - Data Type: The task involves handling text data only. - Data Source: The data will be provided in a digital format. - Task Goal: The primary objective is to maintain records in a systematic way. Ideal Freelancer: - Proficient in Text Data Entry: The ideal freelancer should have experience with accurately and efficiently entering text data. - Familiarity with Excel/Word: Proficiency in using Excel and Word is necessary for the task. - Attention to Detail: Given that the task involves record keeping, the freelancer should have good attention to detail to ensure the accuracy of the entries.

I'm in need of a professional who can build a tool that scrapes product data from Walmart and exports it into an Excel spreadsheet. Key Requirements: - Develop a web scraping tool specifically for Walmart website - Extract essentials (price, upc, title) Skills and Experience: - Proficiency in web scraping using Python, Scrapy, or similar tools Please let me know your availability and estimated time for completion. This is an urgent project, so a quick turnaround would be highly appreciated.

...we will share our final scope with) Description: VeriCO2 is seeking a skilled developer to assist in completing the development of Phase 1 of our automated quantification of scope 3 emissions project. The selected developer will be responsible for conducting a thorough code review and integrating an emissions factor database into the existing codebase. Responsibilities: 1. Code Review and Functionality Check - Review the existing code to ensure there are no backdoors from the previous developer. - Verify that the code is functional and all equations for each method within the 15 scope 3 categories under the GHG protocol are correct. 2. Emissions Factor Database Integration - Finish coding the scraping mechanism to extract emissions factors from th...

Hey there, I would like to give you a tiny project, just adding code into shopify site you built previously. $25 for 5 minutes of work. These two codes, with instructions to follow: * Add to Cart Snippet: * This guide will walk you and/or the developer through adding the code snippet to the new product pages.  * * Back in Stock Snippet: * This guide will walk you through adding the code snippet to the button. 

I have a real estate development company, and I'm looking for a dedicated Excel expert to help me streamline my expense tracking process. Key Requirements: - I already have a template set up and in one of the tabs I have a CSV statement import. Your primary task will be to create a formula that can automatically pull data from a statement import into the relevant property tab. - The data should be ordered by date to ensure clarity and easy reference. - I have created a macro to change the debit figures to negative amounts in the spreadsheet. - I am open to changes/ideas on if it requires a different setup. Ideal Skills and Experience: - Advanced Excel skills are a must. You need to be comfortable working with complex formulas to manipulate data. - Experience with r...

I'm looking for a professional Android developer to create a simple yet efficient document scanning app for me. The primary goal of the proposed app is to be able to scan various types of documents, including ID cards, receipts, invoices, paper, and passport photos, and saving them in JPEG format. As such, the app should be able to: - Recognize and accurately scan ID cards, receipts, invoices, paper, and passport photos - Provide a seamless and user-friendly experience for scanning documents - Showing Auto or Manual Edge Cropping, Image Rotation - Using OpenCV - Native Android (Android Studio), Java I would like the app to be specifically tailored for Android, ensuring a smooth user experience and a clean, intuitive interface. Ideal Skills and Experience: - Proficiency in Andr...

I'm seeking help with creating line charts in Excel. My dataset is small but involving multiple data series. Requirements: - Generate line charts from provided multi-series data - Ensure the charts are clear and visually engaging - Basic understanding of trendlines and data labels would be a plus, though not mandatory Ideal Skills: - Proficiency in Excel, with a focus on charting - Prior experience working with complex, multi-series datasets - Strong attention to detail and an eye for creating visually appealing charts

Please Sign Up or Login to see details.

I'm in search of a robotics expert with advanced experience in working with Vex V5 parts. The goal of this project is to build a robot that strikes the right balance between speed and strength, specifically for a high school robotics competition. Key Responsibilities: - Building a competitive robot that can excel in a high school robotics competition - Optimizing the robot for a balance between speed and strength Ideal Skills: - Proficiency in working with Vex V5 parts - Previous experience in high school robotics competitions - Strong understanding of robot design principles Communication for this project is crucial, and I would prefer to have in-person meetings to discuss progress and updates. Please consider that you must be able to meet in person in Connecticut west ha...

...bank transactions from PDF format into a spreadsheet. My accountant needs this data to be organized and easily accessible. Tasks for the freelancer include: • Extracting transaction information from my downloaded PDF bank statements • Compiling this data into an Excel spreadsheet • The project will need to include the date, transaction description, transaction amount, resulting account balance, and transaction category The ideal candidate needs: • Strong attention to detail • Proven experience working with both PDF and Excel files • Fluent in English for effective communication Expectations: • Maintain rigorous data accuracy • Finished product will closely replicate the information found in the original bank statements using...

I need an expert to create a comprehensive Excel report and sheet using the 7QC Tool. The main purpose of this project is to analyse process data, identify quality problems, and improve process efficiency. Key Project Details: - The Excel report and sheet should incorporate data analysis, financial calculations, and performance metrics. - The type of data to be stored in the Excel sheet will be sales data, employee information, and inventory records. The ideal freelancer for this job will have a solid understanding of the 7QC tool, advanced Excel skills and knowledge in data analysis. Experience with managing sales data, employee information, and inventory records within Excel is highly beneficial.

Looking for someone to engineer a shared to-do spreadsheet in Microsoft Excel that supports real-time collaborative editing for our team. The successful candidate should have: * Advanced Excel skills; * Experience creating custom spreadsheets for project management; * Understanding of user permissions in Excel with the aim to allow full control access to every team member; With your help, we'll revolutionize how we tackle tasks as a team. The ideal freelancer for this project should be prepared to propose and implement a solution promptly. Familiarity with Microsoft Teams is a plus.

I need a skilled Arabic typist to enter data from PDF, into a single excel table .

I'm seeking a reliable freelancer to import vendor pricing data into Sage. The data is currently stored in a CSV formatted Excel spreadsheet, with data cleaning required prior to import. The project will entail: - Cleaning the vendor pricing data as required - Successfully importing clean data into Sage Ideal Skills: - Proficient in Excel and its functionalities, especially CSV format - Experience in data cleaning - Demonstrated proficiency in Sage, particularly in data import functions - Attention to detail is crucial for this task This task requires a freelancer with the right blend of skills in Microsoft Excel and Sage software to ensure smooth, error-free integration of vendor pricing data.

I'm seeking a skilled Excel developer to help me create a tracking system. Key Requirements: - The system should monitor the month over month membership growth for our community PCPs. - The PCP targets should be identified by name and location. Please note that this needs to be completed as soon as possible. Ideal skills for this project: - Strong proficiency in Excel and data tracking - Experience with creating dynamic systems in Excel - Attention to detail to ensure accurate tracking This will be a key tool for our organization moving forward, so I'm looking for a freelancer who can deliver high-quality work efficiently.

I'm seeking a seasoned web developer with an expertise in improving website navigation and site mapping to make my website more user-friendly and streamlined. Specifically, your tasks will include: -Minifying JavaScript and CSS -Compressing JavaScript and CSS -Optomizing SEO Ideally, you should have: - A proven track record in designing and implementing intuitive website navigation - A keen understanding of SEO optimization and its influence on site mapping - Experience in making websites more accessible and user-friendly, particularly in terms of navigation.

I'm looking for a freelancer to create a line graph in Excel. This graph will be utilized for report analysis, showcasing the trend for a single data set. Key Responsibilities: - Develop a line graph in Excel - Present the data trend effectively - Ensure the graph is tailored for report analysis Ideal Skills and Experience: - Proficiency in Excel, particularly in creating graphs - Prior experience in crafting visuals for reports - Ability to convey data clearly and effectively This project specifically does not entail comparing different data sets, as it solely focuses on illustrating the trend of a single set. The ideal candidate will deliver a polished graph that can be seamlessly integrated into a report.

Need an Excel expert to create a complex forumula to get desired results from big set of data. Budget is placeholder/estimate. final amount will be discussed during work.

Overview: We are looking for an experienced Java developer to refactor an existing code base to incorporate several design patterns and improve overall code quality. This project involves enhancing the structure and maintainability of the code by integrating various design patterns, such as Dependency Injection (DI) using Google Guice, Listener, Builder, Singleton, and, optionally, Factory design patterns. The ideal candidate should understand these patterns strongly and have experience refactoring legacy code. Key Responsibilities: 1. Refactor Service Classes with DI Pattern: - Utilize Google Guice API to implement Dependency Injection across all service classes. - Ensure that all dependencies are injected and managed by the Guice framework. 2. Apply Li...

...professional to develop a Solidworks macro for specific tasks. Mainly, it's intended to import data from Excel to Solidworks, and automate several repetitive processes. Data to be incorporated from Excel will be primarily: - Dimensions and measurements - Material properties - Configuration properties part number convention The successful candidate should have prior experience working with Solidworks and Excel VBA, understanding how to adeptly make these two platforms talk to each other in an efficient and error-free manner. This project is required within a month. If you're able to work within this timeframe, and have the necessary skills, I would love to hear from you. I have an Excel sheet to automate PN and description creation already...

I have multiple Excel spreadsheets containing contact information, and I need them consolidated based on a unique index number. The task involves the following: - Data consolidation: Retrieve name and email information from several Excel sheets using a base index number from a primary data file. - Automation: I need this consolidation to be automated instead of manual intervention. - Performance Optimization: Currently using Xlookup for the merging process, but it's slow due to the file size. I'm open to suggestions for more efficient alternatives. Skills and Experience: - Advanced Excel skills: The freelancer should be proficient in Excel and have experience working with large data sets. - VBA Scripting: Ability to write and implement V...

We are currently looking to add several Virtual Assistants (VA) to our team who can assist us with various tasks, including social media posts, research, data entry, and more. We are seeking individuals with a strong background in data entry, Google Drive/Sheets, and similar responsibilities, as outlined in our LinkedIn ...Key qualifications and requirements for the role: - Proficient in data entry and experienced with Google Drive/Sheets. - Demonstrated reliability and consistency in previous roles or projects. - Strong attention to detail and organizational skills. - Ability to meet deadlines and perform consistently in an ongoing work environment. If you believe you possess the necessary skills and qualities to excel as a Virtual Assistant with our company, we would love to hear...

As discussed I have delivered the excel workbook. Thanks!

I'm in need of a professional who can build a tool that can extract data from LinkedIn. The data I'm interested in includes: - Contact information (email address, phone number, etc.) - Profile information (name, job title, etc.) - Connection network (connections, mutual connections, etc.) I'd like the extracted data to be conveniently structured in a CSV (Excel spreadsheet) format. The primary use of the extracted LinkedIn data will be for lead generation. The ideal candidate for this project should have: - Expertise in web scraping and data mining, particularly with LinkedIn - Proficiency in data handling and structural organization - Proven experience with developing tools for lead generation - Strong communication skills and a good understanding of client nee...

I am seeking a skilled professional to assist me in integrating a Visanet QR code and payment link into my US dollars foreign account system. The primary purpose of this is to accept payments online in US dollars from business clients in US dollars in my foreign business account in Australia The project would include: - Setting up a Visanet QR code and payment link for US dollar transactions - Ensuring the system is seamless and secure for online payments - Ensuring the system is user-friendly and accessible for my business clients The ideal candidate will have: - Proven experience in Visanet QR code and payment link integration - Proficiency in online payment systems - A strong understanding of the requirements for online business transactions - A track ...

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 Have sufficient experience in Social Media Ads and ...

Data entry work from home part Tim e

...can efficiently write code that retrieves both the public and local IP addresses and provides source code for the same. Key Task: - Code successfully retrieves the public and local IP addresses from Angular code Primary Objective: - The ultimate goal for retrieving the IP addresses is for user tracking purposes. Additional Task: - It is also essential for the code to enable the determination of the user's geographical location, specifically their city, based on the IP address found. Ideal Skills and Experience: - Strong Angular coding skills - Experience with location tracking - Proven experience on IP address retrieval from code - Understanding of user tracking methodologies. I'm looking forward to work with someone who will...

CODE IS DONE, JUST NEED SOME ADJUSTMENTS ON CODE + APP MADE ON ANDROID STUDIO I'm looking for an experienced ESP32 device programmer. The main functionalities include: - Control: The app should enable users to interact with the ESP32 device through buttons and switches displayed on the app's interface. This means that the app should be able to send commands to the ESP32 device based on the user's actions. - Data Display: The app should be able to read and display data from the ESP32 device. This data should be stored on an SD card, and include GNSS data from the u-blox module. The ideal candidate for this project should have experience in: - Android Studio: Proficiency in Android app development is crucial for this project. You should be able to create a...