Excel vba programming for dummies jobs

Looking for a freelancer experienced in Excel and VBA to develop a tool that automates the creation of Sorare teams based on data from three sheets: "Sorare Bot," "Classifications," and "GW." The tool should: Generate valid 5-player teams for competitions following specific rules (positions, exclusions, etc.). Organize teams into blocks categorized by competition. Create a list of unused players with exclusion reasons. Include a button to update the "GW" sheet whenever the other sheets are modified. Skills Required: Advanced Excel and VBA expertise. Data processing and automation. Attention to detail for applying prioritization and exclusion rules.

Project Overview We want to create a complete mechanical design for a mini tractor utilizing a 7 HP diesel engine. The project deliverables will include conceptual sketches, 3D CAD models, engineering drawings, bill of materials (BOM), and detailed instructions for fabrication. Key Objectives: Design a sturdy yet compact frame to house the 7 HP engine, transmission, and differential. Provide multiple forward gears, reverse gear, and PTO capabilities. Ensure maneuverability in small farmland or narrow pathways. Incorporate safety elements and easy maintenance features. Scope of Work & Deliverables Phase 1: Requirement Analysis & Conceptual Design Requirements Gathering Discuss and finalize key requirements: Overall dimensions, power transmission layout, PT...

I'm looking for a freelancer who can build a sophisticated, autonomous AI agent powered by O1 mini. This agent will be primarily focused on training and deploying machine learning models. Key Requirements: - Integration with Langchain for managing complex language tasks and maintaining conversational context. - Use of Autogpt for enabling autonomous goal setting and iterative task execution. - Incorporation of BabyAGI for advanced planning and long-term goal management. - incorporation of api integration Ideal Skills: - Deep understanding of AI programming and agent development. - Experience with O1 mini, Langchain, Autogpt, and BabyAGI. - Proficiency in enabling conversational capabilities in AI. - Ability to create an agent that can autonomousl...

...tailored software solution for my Chartered Accountants office. This software will primarily focus on reporting and analytics, while also automating various tasks. Key Features: - Master entry of Client including KYC, Inward-Outward Register, Task Assignment, Quotations, Appointment Letter, Acceptance Letter, Engagement Letter, Management Representation Letter, NOC of previous auditor, Staff KYC, Etc. - Robust reporting and analytics capabilities - Automation of email notifications, data entry, scheduling, and other statutory records Integration: - Seamless integration with Excel sheets for reporting and analytics Ideal Skills & Experience: - Proficient in software development with a focus on analytics - Experience with task automation software - Strong under...

Please Sign Up or Login to see details.

I'm in need of a proficient MS Excel professional who can assist me with complex formulas and functions, as well as creating charts and visuals. The primary goal of these tasks is to aid in financial modeling using sales data. Key Responsibilities: - Apply complex Excel formulas and functions for financial modeling. - Create detailed and informative charts and visuals based on sales data. Ideal Skills: - Advanced expertise in MS Excel. - Proficient in financial modeling and data interpretation. - Capable of creating professional charts and visuals.

I'm on the lookout for an experienced AI developer with a focus on Computer Vision. The project will primarily involve processing images, so a deep understanding and experience in handling image data is crucial. Key Responsibilities: - Develop an AI system capable of image classification and image segmentation. Ideal Skills: - Proficient in AI and machine learning, specifically in the domain of computer vision. - Hands-on experience with image processing and computer vision tasks. - Familiarity with developing AI for image classification and segmentation. - Proficient in using relevant programming languages and tools (Python, TensorFlow, etc.). - Develop, test, and maintain Python-based applications. - Collaborate with cross-functional teams to design and implem...

We are looking for an experienced JavaScript developer to collaborate with us in building a feature-rich coupon code website. The platform will leverage a Headless WordPress setup, where WordPress will serve as the backend and the frontend will be developed entirely in JavaScript. This is a high-priority project, and we require someone who can work in a pair programming mode with our team. We are looking to build a GrabOn-like coupon code website that utilizes Firebase as the primary backend (including notifications and all relevant Firebase modules), paired with a modern JavaScript frontend (e.g., , Node.js) for superior performance and scalability. Additionally, WordPress will serve as an admin panel purely for managing content, while the core business logic...

Generate Leads of driving Schools in USA Deliver in Excel Sheet

I need an Excel expert who can help me analyze our sales data and identify trends. The main objective is to leverage Excel formulas and tools for data analysis. I have a considerable amount of sales data that needs to be examined. The ideal candidate for this project should be proficient in Excel, with a strong background in data analysis. Experience with analyzing sales data specifically will be a plus. Key tasks will include: - Utilizing Excel's advanced features for data analysis - Identifying and interpreting trends within the sales data - Providing clear, concise insights based on the analysis Please bid if you can help me find trends in my sales data using Excel.

I'm looking for an Excel expert to create an energy dashboard for me. The dashboard will need to display: - Electricity consumption - Renewable energy production - Water consumption - BTU consumption The data will be sourced from CSV files, and I would like the visualizations to consist of line charts. Ideal skills and experience for this job include: - Proficiency in Excel, particularly with data visualization - Experience in creating dashboards - Ability to work with CSV files - Understanding of energy data would be advantageous

I'm looking for a professional to create a Gantt Chart in Excel for our project. The chart should include all project milestones, and be formatted using our company branding colors. Ideal Skills: - Proficiency in Excel - Experience with project management tools - Attention to detail Please note, the level of detail for task descriptions hasn't been specified yet, so some flexibility may be required.

...Shopify Store with a Premium Design Description: I am looking for an experienced Shopify developer to create a sleek, professional, and user-friendly online jewelry store inspired by a modern, premium design aesthetic. The store should reflect a high-end feel with intuitive navigation, elegant design, and robust e-commerce functionality. Key Requirements: - Create a clean and sophisticated design tailored for jewelry products. - Implement customizable product pages (e.g., build-your-own jewelry features). - Ensure a fully responsive design that works seamlessly on all devices. - Set up secure payment gateways and a smooth checkout process. - Optimize the site for SEO and fast loading speeds. - Integrate essential apps for marketing, analytics,...

I need a modern styled Excel spreadsheet quote template. The template should incorporate: - My company name - My company logo - My company stamp The design should be sleek and professional, in line with a contemporary business aesthetic. The ideal freelancer for this project will have strong skills in Excel and graphic design, with a keen understanding of modern design principles.

I'm seeking a professional with extensive experience in machine learning, specifically in building predictive analytics applications. The project will ...The project will primarily utilize structured data from databases and spreadsheets. Ideal Skills Include: - Proficiency in Machine Learning techniques and algorithms. - Proven experience in developing predictive analytics models. - Strong data handling skills, particularly with structured data. - Ability to interpret complex datasets and derive actionable insights. - Proficiency in relevant programming languages (.net core.) and tools (TensorFlow, Scikit-learn, etc.). The selected freelancer will be tasked with creating a machine learning application that can effectively analyze our structured data and provide accurate predi...

As a client, I am in search of a Senior Backend Developer with extensive experience in crafting web applications. This project will leverage various programming languages and database technologies. Key Skills Required: - Proficient in Java and Python - Mastery in Node.js, Ruby on Rails, C#, PHP/Laravel is a plus - Extensive experience with MySQL, MongoDB, and PostgreSQL Ideal candidates should have a proven track record of developing web applications. They should possess excellent problem-solving skills, be detail-oriented, and able to work independently. Strong communication skills are essential for effective collaboration. Please include examples of your previous work in your bid.

I'm looking for a programmer with expertise in 3D image processing, specifically for detecting dimensions and contours of mechanical parts. Ideal Skills and Experience: - Proficiency in 3D image processing techniques - Experience working with mechanical parts - Ability to program solutions for image processing tasks - Knowledge of detecting dimensions and contours - Familiarity with programming languages suitable for image processing (e.g. Python, C++ with OpenCV, etc.)

I'm seeking a Python developer experienced with M5Stick C Plus 2 programming and the Telegram Bot API. The project involves creating a solution that records audio from the built-in mic, encodes it into MP3 format, and sends voice messages over WiFi via Telegram. Key Requirements: - Program the M5Stick C Plus 2 to record audio and send it through a Telegram bot. - Use the built-in microphone. - Implement MP3 encoding of the audio. - The Telegram bot should be able to send the recorded messages. - Deliverables should include the source code, comprehensive setup instructions, and optional support for testing. Ideal candidates should have: - Proven experience in Python programming. - Familiarity with M5Stick C Plus 2 and its capabilities. - Prior work with the Teleg...

...spreadsheet-like format. • Includes filtering and search functionality. • Editable Cells: • Customer data and analysis results can be edited in real-time. • Edit Logs: • Automatically save all modification history. • Logs include data before and after modification, along with timestamps. 4. Excel/CSV Export • Download grid-based data as Excel or CSV files. 5. Compressed File Processing • Automatically extract files when compressed files are uploaded to the server. 6. Selective Export • Export visible data on the grid as Excel or CSV. • Options to export only selected data. Automated Process Workflow 1. Data Upload and Email Attachment Saving • Store data through email attachments and file uploads. 2. Analysis...

We are looking for a motivated and eager-to-learn freelancer to assist with our Takealot seller account for 6 hours a day. The position offers a monthly payment of PKR 50,000. Newcomers are welcome, and we value a strong desire to learn! Responsibilities: Upload new products to the seller account. Create replenishment shipments as needed. Analyze return reasons and determine necessary actions to prevent future returns. Dispute returns with Takealot if they are a result of a Takealot error. Compare shipment sent items with purchase invoices to ensure accuracy. Requirements: Basic proficiency in English and Urdu is mandatory. Familiarity with Excel is important. Previous experience with e-commerce platforms such as , Amazon, or similar is a plus but not required. A w...

I'm looking for an experienced Excel user to assist with creating a formula that sums a range of cells based on text matching criteria. Key Requirements: - Proficient in Excel with a strong understanding of creating and modifying formulas - Experience with conditional summing based on specific criteria - Ability to interpret and implement text matching criteria for the sum If you have the exemplary skills and experience for this task, please place your bid.

I'm looking for a skilled Excel expert to create formulas for data analysis. The focus will be on descriptive statistics, specifically calculating the mean and median from my dataset. Ideal skills for the project: - Advanced Excel knowledge - Data analysis expertise - Familiarity with descriptive statistics

I'm seeking brilliant minds for a thrilling task that tests intelligence and problem-solving abilities to the max! If you are an analytical thinker with exceptional cognitive skills and a strong desire to succeed, this is your chance. Your task will be to excel in Cognitive Aptitude Analysis, demonstrating your reasoning and critical thinking abilities; proving your Mathematics Mastery through complex numerical challenges; showcasing your English Proficiency with advanced comprehension and communication skills; and leveraging AI & Machine Learning in Education to transform contemporary learning strategies. - Task: Completing a trial exam + five challenging online exams in Mathematics and English - Difficulty: Questions rated 10/10 - Time: Extremely limited - Integri...

I'm looking for a freelancer who can assist me with my sales data. The tasks primarily involve data entry, data cleaning, and data analysis. The dataset is relatively small, with less than 1,000 rows. Ideal skills for this project: - Proficient in Microsoft Excel - Experience in data entry - Strong data cleaning skills - Capable of performing data analysis Please bid if you have the required skills and experience. Thank you!

1). I have a trading backtesting software, wherein I need to change n number of parameters for different instruments and different trade times and run the backtest. 2). Any parameter if I need to change, I spend lot of time in changing those parameters for all; quite a repetitive task. 3). It would have been great if the whole portfolio could be exported in excel format, so that changes could be done via batch edit much faster and imported back. 4). Unfortunately presently export import is via some port file, which is encoded/encrypted and can't be read or batch edited. Requesting any developer to help with this and also some additional features later. Thank you

I'm looking for a simple, yet effective crypto trading website that will automatically execute trades on my behalf. The trading strategy is focused on arbitrage, taking advantage of price differences across various exchanges. Key Requirements: - The site should be able to trade on Binance, Coinbase, Kraken, and potentially others. - It should be able to implement an arbitrage trading strategy. - The user interface needs to be simple and minimalistic. You will be provided with a picture that illustrates how to execute the trades via API programming. Ideal candidates for this project should have a strong background in cryptocurrency trading platforms and API programming, with previous experience in developing similar trading websites. Please get back to me...

...file upload for customer record updates, replacing existing data User Interface: - Secure login system - Spreadsheet (table) style display of customer data - Search functionality by: account number, last name, or service address (partial or full matches) Style: - Professional, streamlined interface with a focus on readability - Color-coded search results for quick identification - Design with optimized layouts for desktop / laptop use Files Provided 'Customer ' - This is the export from our ERP. - File will be uploaded to the app you develop weekly by our staff. - New data will replace old data (removing any data not overwritten by new file). 'THCSD Customer Account ' - This is an excel based solution that we created internally. - Use...

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.

...educational game maps. For example, the game "Linear Programming Adventure" is designed to train students' critical thinking skills in mathematics. Implementation of Learning: Educational games often incorporate various learning styles such as Visual, Auditory, Kinesthetic (VAK) to enhance student engagement. This helps children not only understand the material but also enjoy the learning process. Feasibility Testing: Results from feasibility tests indicate that educational games can improve student understanding. For instance, the game "Math Bear" demonstrated an effectiveness rate of 88% in helping students grasp spatial concepts. Results and Effectiveness Research shows that educational games are not only practical but also effective in e...

I'm looking for a seasoned developer to create an MLM Binary System for both web and mobile platforms. The system should include features for: - Commission Calculation: The system should be able to accurately calculate commissions based on the MLM binary structure. - Genealogy Tree: A visual representation of the network should be incorporated, showing the hierarchy and relationships within the structure. Ideal candidates should have extensive experience in MLM software development and be proficient in both web and mobile development. Knowledge of user-friendly UI/UX design principles would be beneficial, as the system should be intuitive and easy to navigate for all users. Please note, I have not specified a preferred programming language or fra...

...press environment, I offer the following services: - Typing and document formatting using Microsoft Word - Data organization and spreadsheet creation in Microsoft Excel - Desktop publishing with Adobe PageMaker - Image editing and design with Adobe Photoshop I am dedicated, detail-oriented, and committed to delivering high-quality work that meets your specific needs. Ideal projects would involve typing, document creation and formatting, spreadsheet management, desktop publishing, or image editing. Skills and Experience: - Fluent in English with excellent typing speed (40 WPM) - Profound knowledge of Microsoft Office Suite (Word, Excel) - Proficient with Adobe PageMaker and Photoshop - A proven track record of 10 years in computer work related to printing press operation...

The project involves creating a mobile application for both Android and iOS platforms. The primary function of this app is to enable users to capture multiple photos in a single session, tag them with product SKU and quantity, and subsequently export this data into Excel and PDF formats. The app should also support date-wise search functionality to track the captured data over time. Key features include: - A user-friendly interface for capturing and tagging photos - Seamless integration with Excel and PDF for data export - Date-wise search capability Ideal candidates for this project should have: - Previous experience in mobile application development, particularly for Android and iOS - A strong understanding of data export functionalit...

...players can take on roles such as pilots, flight attendants, security personnel, and ground crew. The game will require a skilled developer to incorporate AI elements to enhance gameplay and realism. Key Responsibilities: - Implement AI for boarding procedures: The AI should manage the boarding process to simulate a real-life flight scenario. - Security Challenges: While specific tasks have not been defined, the AI should create dynamic and unexpected security challenges to keep players on their toes. Ideal Skills: - Extensive experience in AI programming. - Proficiency in Roblox game development. - Creative thinking to design engaging and unpredictable scenarios. Please note that this is a comprehensive project and the successful freelancer will be expected to deliver ...

I need a master Excel spreadsheet designed and populated with data from financial documents I will provide. This will include a master page produced from all the data on the separate tabs. - Data Types: The project primarily involves working with financial data, specifically tracking revenue and expenses. - Update Frequency: The data will need to be updated monthly. Ideal skills for this job include advanced Excel proficiency, experience with financial data, and the ability to create clear and comprehensive master spreadsheets. Please provide examples of similar projects you've completed in the past. Each sheet will total and feed into the master page. I would like reports ideally that can be run on total expenses or revenue in a time period as well as ratios...

I'm seeking an expert excel/vba programmer. I'm using an existing vba macro excel program that needs to be upgraded. It was created to automate the process of building a single inventory list from multiple vendors feeds. The website is now using the Shopify platform and requires data to be imported into different column names and for more columns added. Summary of work required: 1. Need to change the import process to a single form, where feed can be added, vendor profile selected, map file column names to names in the program, save profile and import feed. 2. Adjust Export functionality to use similar template with different columns for different export options. 3. Data in compiled list needs to be read only unless enabled for...

I'm looking for a freelancer who can assist me with my sales data. The tasks primarily involve data entry, data cleaning, and data analysis. The dataset is relatively small, with less than 1,000 rows. Ideal skills for this project: - Proficient in Microsoft Excel - Experience in data entry - Strong data cleaning skills - Capable of performing data analysis Please bid if you have the required skills and experience. Thank you!

Budget $25 I'm looking for a Python expert who can write a script for me. The script will open a list of URLs from an Excel spreadsheet and check for specific content. Requirements: - The script needs to check for text on the URLs. - If the content exists, it should create a new column in the spreadsheet with the status of each URL. Skills required: - Proficiency in Python programming. - Experience with working on Excel files. - Knowledge in web scraping techniques. - Ability to understand and implement URL content checking. Please only apply if you can demonstrate your ability to complete this task successfully -

I'm seeking assistance in extracting numerical data from individual stock pages on a website and storing it in an Excel file in a specific format for multiple stocks. This needs to be done monthly. - Data Points: The data points to be extracted include various metrics like annual sales, operating profit margin (OPM), net profit, and others. - Excel Formatting: The extracted data needs to be stored in a particular format in Excel. Ideal Skills: - Proficiency in Excel - Experience with web data extraction - Attention to detail to ensure data is accurately captured and formatted. Please note, I need this to be set up for monthly updates.

We are looking for an experienced JavaScript developer to collaborate with us in building a feature-rich coupon code website. The platform will leverage a Headless WordPress setup, where WordPress will serve as the backend and the frontend will be developed entirely in JavaScript. This is a high-priority project, and we require someone who can work in a pair programming mode with our team. We are looking to build a GrabOn-like coupon code website that utilizes Firebase as the primary backend (including notifications and all relevant Firebase modules), paired with a modern JavaScript frontend (e.g., , Node.js) for superior performance and scalability. Additionally, WordPress will serve as an admin panel purely for managing content, while the core business logic...

Python Developer: Screenshot Cropping & OCR to Excel Description: Seeking a Python developer to automate data extraction from screenshots with two key tasks: Screenshot Cropping: Crop images to isolate data below column headers. Handle minor variations across screenshots. OCR & Excel Conversion: Use OCR (e.g., Tesseract) to extract text from cropped areas. Save data to Excel in structured columns. Requirements: Proficient in Python (Pillow, OpenCV, pytesseract). Experience with OCR and Excel handling (openpyxl, pandas). Strong problem-solving skills and attention to detail. Deliverables: Scripts for cropping and OCR-to-Excel conversion, reusable and future-proof. Notes: Focused on screenshots only—no web scraping (e.g., Selenium...

I need a comprehensive, user-friendly sales report spreadsheet designed for monthly data tracking. Key Data: - Revenue: The primary focus of the report - Sales Rep Tracking: This includes new business, contract renewals, and lost business Required Functionalities: - Automated Calculations: To reduce manual input and errors - Data Visualization: Charts and graphs to provide visual insights into the data - Summary Sheet: A separate sheet that auto-populates with a summary of all data Ideal Skills: - Proficiency in Excel or Google Sheets - Experience with sales reporting - Skills in data visualization and analytics I plan to update this spreadsheet on a monthly basis.

...aligned, and visually appealing. Key Requirements: - Proven experience with Microsoft Word and Excel. - Ability to work quickly without sacrificing quality. - Previous experience formatting policy documents is a plus. - Must provide government-issued photo ID and sign a Non-Disclosure Agreement (NDA). - Long-term work opportunity available for the right candidate. - No pay for work that is of poor quality Important Aspects of Formatting: - Consistent font styles and sizes - Use of headers and footers - Optimal spacing and alignment - Creation of 'beautiful' documents Aesthetic Elements Considered Critical: - Use of elegant templates and layouts. Please note: - There will be no payment for poor quality work or mistakes. - Document aesthetics ...

I'm looking for a Python developer who can create a script for monitoring industrial equipment using the Modbus protocol via TCP/IP. Key Responsibilities: - Develop a Python script for system monitoring of industrial equipment. - Use Modbus protocol for communication. - Implement TCP/IP for interfacing with the equipment. Ideal Skills and Experience: - Proficient in Python programming. - Experience with Modbus protocol. - Familiarity with TCP/IP communication. - Previous work involving monitoring industrial equipment. Very simple project looking for someone to write a srcipt that will connect over tcpip to a device called a mate 3, the modbus registers are attached in the document then all data needs to be sent via post in the follo...

I'm looking for an experienced AI developer to create software that will automate financial analysis. The AI will focus on three key aspects: data collection and preprocessing, generating investment recommendations, and performance evaluation. Key Requirements: - Expertise in AI and machine learning - Experience in software development, particularly in the finance sector - Ability to work with various data sources, particularly financial statements Skills and Experience: - Proficiency in programming languages such as Python, R, or Java - Strong understanding of financial concepts and analysis - Previous experience in developing AI software for finance will be a plus.

I'm looking for a talented Roblox game developer who can create a highly realistic airport and flight simulation game for me. This project requires a deep understanding of both game development on the Roblox platform and the intricacies of flight simulation. Key Requirements: - Expertise in Roblox game development - Strong understanding of flight mechanics and airport operations - Ability to create highly realistic simulation experiences - Creativity to design engaging game elements Ideal Skills: - Experience with adventure and simulation games - Strong programming skills - Knowledge of 3D modeling and design - Familiarity with flight simulation software

- The data is easily selectable and copyable. - I want the final data saved to an Excel spreadsheet. - If possible, I would like the use of a VBA macro for ease of us

...in identifying profitable products and brands for resale. We’re looking for a motivated and detail-oriented Brand Sourcing Specialist to support our team. This role requires no direct communication with brands—just the ability to research and document brand data using provided tools. Responsibilities: Identify profitable brands on Amazon using tools such as SmartScout and Keepa (training provided if needed). Enter brand and product data into a basic spreadsheet with accuracy and consistency. Follow clear guidelines to meet weekly and monthly sourcing targets. Requirements: Familiarity with SmartScout and Keepa is a plus but not required; training will be provided. Strong attention to detail and accuracy in data entry. Basic knowledge of Excel or Googl...

1. Please fix the Stock Performance tab with Top 20 & Bottom 20. 2. Commodities & Chart_All_Commodities, I changed the commodity on a few of them including Antimony, Germanium, Gallium, Platinum & Niobium. This seems to work on the Commodities tab, but I have to manually update the Chart_All_Commodites Tab + others mentioned in Skype too, thanks

I'm looking for an expert who can transform my Excel sheet into a web-based calculator. The calculator needs to handle basic arithmetic operations like addition, subtraction, multiplication, and division. Key Features: - Data Input Options: The calculator should incorporate user-friendly data input options such as dropdowns and checkboxes. - Graphical Representation: A vital part of the project is the ability to visually represent results graphically. Ideal Skills: - Proficient in Excel and web development - Experience creating interactive web-based calculators - Ability to integrate graphical representations into a web platform Please provide examples of similar projects you have completed.

UPDATE: I am looking for a skilled individual. Extensive knowledge with Azure, Virtual Servers, Domain Controllers, VPN's etc. is required. I am not looking for a DEV/OPS person. I need a Level 3 individual who can figure anything out, implement any IT project given and fix any system issue (without being careless and messing stuff up). If this is you, let me know! Also - read this whole post carefully and follow the directions provided. If you can't follow directions with a project/job post then I probably can't trust you with servers ;) We are looking for an experienced Sr. IT Engineer to join our team. We are seeking an individual located in North America with a Senior-level of experience and a specialty in Microsoft Azure and 365 cloud solut...