Start project excel vba 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 seeking a skilled software developer to create a tailored software solution for my Chartered Accountants offi...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 understanding of Excel and data integration - Excellent communication skills for understanding office needs This project will significantly enhance our office efficiency and data management, making it a crucial invest...

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.

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.

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.

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

...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 willingness to find and watch instructional YouTube videos to enhance learning about e-commerce practices. Additional Notes: You will be granted access to my PC via TeamViewer to explore the seller portal and learn. We are looking for individuals wh...

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 - Integrity: Che...

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

A web-based Customer Record Lookup tool our staff to use, could be built on a CRM platform, but is very simple. The application consists of two main interfaces: Admin Interface: - User management functionality (add/edit/delete users) - CSV file upload for customer reco...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 this as a reference for front-end Column Names and Data View of e...

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.

...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 operations - Strong attention to detail and a commitment to accuracy I am ready to bring my expertise to your project, ensuring...

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 functionalities - Excellent UI/UX...

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 in-line editing ...

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.

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). Prov...

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 Re...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 mont...

I'm in need of an Administration Assistant with excellent document formatting skills. The primary task will be formatting policy documents to ensure they are consistent, 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 ...

- 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

...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 Google Sheets. Ability to work independently and meet deadlines. A positive attitude and willingness to learn new skills. What We Offer: Flexible working hours. Competitive pay structure. Weekly and monthly performance bonuses for meeting targets. Hands-on training and support to ensure your success. A straightforward workflow with no direct communication with suppliers or br...

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.

...need a professional to identify and correct any errors. Scope of Work: Review the entire Excel model for accuracy and logic in calculations. Verify key outputs (e.g., working capital changes, depreciation, FCF, OFCF and amortization schedules). Identify and fix formula errors, inconsistencies, or logical flaws. Provide a brief explanation of any changes made to help me understand the corrections. Expected Time Commitment: The work should take no more than 2-3 hours to complete for an experienced professional. Deadline: I need the edited version delivered within 6 hours of awarding the project. Please only bid if you can meet this deadline. Requirements: Expertise in financial modeling and Excel. Attention to detail and the ability to explain corrections clearly...

Hello, There is a website that has specific listings (around 1900) I need it extracted manually and then input in an Excel sheet (Number > price) I need the work to be finished in the next 2-3 hours max If you can start and finish it within the above time, type RED at the beginning of your proposal. A proposal without it will be ignored.

I'm seeking help with my introductory statistics homework, specifically focusing on data analysis and interpretation. The assignment has to have shown work in a word doc and excel sheet. I can show examples of this. Key Requirements: - Proficient in handling mixed data (both quantitative and qualitative) - Skilled in data analysis and interpretation - Strong understanding of introductory statistics principles Ideal Freelancers: - Have a solid background in statistics, particularly at the introductory level. - Experienced in analyzing mixed data sets. - Can provide clear explanations and guidance on data analysis techniques.

I'm seeking an expert to automate the process of extracting both text data and tabular data from a variety of PDF files into separate sheets in Excel corresponding to each PDF. The PDFs are inconsistent in their structure and layout, which adds a layer of complexity to the task. Key Requirements: - Can use excel, Adobe, Python Please provide examples of previous similar projects you have successfully completed.

...10 s steps. The second column is the number of spikes during each 10 s epoch. The third column is the condition. My brute force idea is to do a loop counting spikes until the next 10 s limit is reached, then zero the count and start counting again. Be sure if two spikes are separated by more than 10 s that you save a 0 in each row without a spike. I forgot to mention that the two columns of data in Excel (Condition and Time) were originally in another spreadsheet (ClampFit Events) and I copied and pasted them into Excel. So you don’t have to read them from and Excel file. Instead you can just copy and paste them into a MatLab data array and then write code in MatLab to detect how many spikes/events occur for every 10 s (10000 ms). It would be best if...

I need a script written for AutoCAD MEP that will automatically transfer data from my Excel spreadsheet to space properties. The data is in an XLSX file and includes room names, numbers, and HVAC specifications. Key requirements: - Proficiency in AutoCAD MEP - Scripting skills to automate data transfer - Experience in data integration from Excel - Ability to create a user-friendly script that can be run on AutoCAD MEP without extensive technical knowledge The ideal freelancer will have a strong understanding of AutoCAD MEP and its capabilities, as well as experience in scripting and data integration. They should be able to create a script that is easy to use and can be run on AutoCAD MEP without extensive technical knowledge.

I urgently need a skilled professional to create some bar charts for a business presentation. The charts need to be made using Excel and based on data from provided files. Ideal Skills: - Proficiency in Excel - Experience in creating professional-grade charts - Understanding of business presentation standards Key Requirements: - Ability to work on this task in the next 24 hours - Attention to detail - Ability to interpret data accurately from provided files

EXCEL Manufacturing Product scheduler/run time tracker We are developing a means to schedule components in an integrated excel spreadsheet that includes various production steps: (Functions) Laser, shear, punch, bend, paint, assembly, weld, assembly 2, shipping. To be save on a network-share point so all can access same document. The idea is to have a laptop at each station (listed above) 1a,1st step: Manual enter/copy paste-from engineering Initial step-Enter data (component part number(description)) into the first sequence, list all items from the project that needs to be produced. once entered, you can filter material gauges, material types in order to consolidate production run on the LASER. When running the selected items (check box) we track time to produce ...

I have an Excel sheet filled with survey data that I need analyzed and visualized with graphs. Key Requirements: - Analyze various aspects of the data including demographics, responses to multiple-choice questions, and open-ended responses. - Create visual representations of the data to illustrate different fields or columns. - Utilize both descriptive and comparative analysis techniques. Ideal Skills and Experience: - Proficiency in Excel and data analysis. - Experience with creating graphs and visual data representations. - Ability to interpret survey data and draw meaningful conclusions.

I'm looking for an individu...questions regarding their bread/buns supply - Compiling the information into an Excel spreadsheet Ideal Skills: - Proficient in cold calling - Sales experience - Telemarketing expertise - Strong data entry skills Experience in the food/foodservice industry, especially with restaurant chains, would be a plus. You will have a list of restaurant brands to call, and the data will focus primarily on the burger segment and any establishments using burger-type buns or rolls. Questions to be answered: - Supplier information - If buns are delivered fresh or frozen - Who delivers the buns (supplier, transportation company or centralized logistics) The Freelancer MUST speak local languages! The goal of this project is purely data collection, the...

I need some Excel spreadsheets and Word documents converted into editable PDFs. These PDFs are intended for client distribution and need to allow users to interact with them in specific ways. Key Requirements: - Conversion of Excel and Word files into editable PDFs - PDFs should allow users to fill out forms and edit text and data - Inclusion of specific form features such as drop-down menus, checkboxes, and fields for entering data - One form needs to have the capability to calculate totals Ideal Skills: - Proficiency in PDF creation and editing software - Experience with Excel and Word - Attention to detail to ensure all forms are accurately converted and functional - Ability to create interactive elements within PDFs

An excel file that will import images from a folder. According to a specified layout, and having a filter and sorting feature.

I'm seeking assistance that involves understanding consumer's eating habits, predicting demand for ready-to-eat or cooked food items, and creating a dataset fro...sample predictive machine learning models already trained on such data (possibly on Kaggle). 2. Designing a Survey: Develop a survey questionnaire aimed at collecting data about consumer food demand. 3. Creating a Dataset: Build an Excel dataset from the survey responses that can be utilized to train ML models. Ideal candidates for this project should have: - Proficiency in machine learning, particularly in regression and classification models. - Experience in designing surveys and analysing consumer behaviour. - Ability to create and manipulate datasets in Excel. Please share your previous work ...

I have 20 pages of mixed data (both numeric and textual) handwritten in t tables need of being transcribed into organized tables in Excel. Key Requirements: - Proficient in Excel with experience in data entry - Able to accurately transcribe handwritten data - Attention to detail to ensure data is accurately organized into tables Please note, no data validation or error-checking is necessary, I simply need the data typed up and organized.

Job Description: We are seeking expert developers with a proven track record in the e-commerce and on-demand delivery industry to fix a list of bugs outlined in the attached Excel document. The website is live, but no transactions are currently being processed by clients. Our platform focuses on alcohol on-demand delivery, similar to services like UberEats, DoorDash, or SkipTheDishes, but specifically tailored for alcohol delivery. Requirements: • Mandatory Experience: Applicants must have prior experience working on platforms similar to UberEats, DoorDash, or SkipTheDishes. • Portfolio Required: Only freelancers who can provide links to similar projects they have worked on will be considered. • Expertise in relevant technologies ([e.g., PHP, Python, Node.js, Reac...

We are looking for a designer to assist with our PDF tariff document. This PDF includes company deta...contact details and a website link. We do not require a redesign of the PDF; rather, we need to link the PDF to an Excel spreadsheet, so that when we update vehicle details, prices, or other information in Excel, the changes will automatically reflect in the PDF. The final deliverables should include the existing PDF document, a linked Excel file, and clear instructions on how to update the file efficiently. The goal is to streamline the updating process without requiring manual edits in Adobe, making it easier for all team members to manage the content. If you’re able to provide this service, we can supply any additional information, images, or branding asset...

I'm seeking a Power App expert to enhance my app's workflow automation capabilities. Key Responsibilities: - Implement and...expert to enhance my app's workflow automation capabilities. Key Responsibilities: - Implement and optimize workflow automation processes within the app - Design and integrate user interface elements such as forms, dashboards, and navigation menus - Ensure seamless connectivity with Excel workbooks as the primary data source Ideal Skills: - Extensive experience in Power App, specifically in workflow automation - Proficiency in user interface design within Power App - Strong knowledge in data integration with Excel workbooks - Skills in creating and implementing forms and input fields, as well as dashboards and data visualizations Lo...