Excel vba query spreadsheet jobs
I am looking for a Hindi-speaking individual to visit our warehouse in Port Klang, Malaysia. The purpose of this visit is to teach a small group of our Indian staff (1-5 members) basic computer skills. Skills to be taught include: - Using a web browser - Using Google Sheets - Using Microsoft Excel The level of proficiency we aim for is basic. Your role will be crucial in helping our staff become more computer literate and improving their productivity. Ideal candidates will have: - Proficiency in Hindi and Malay - Strong knowledge of basic computer skills - Experience in teaching or training - Patience and good communication skills
I'm looking for a skilled freelancer with expertise in Power Automate and Excel coding. I need assistance with automating data entry and updates in my Excel worksheets. Key Requirements: - Automate importing data from an email and CSV/Excel files into my Excel sheets. - Streamline the process of updating existing records. Ideal Skills: - Proficiency in Excel and Power Automate. - Experience with data handling and automation. - Strong attention to detail and ability to validate data. The goal is to save time and enhance efficiency with data management. Please share your relevant experience and examples of previous projects.
I'm in need of an Excel expert who can help automate some of my book-keeping tasks. The main focus will be on reconciling accounts. Your responsibilities: - Utilise experience with excel formulas and macros to refresh existing reconciliation process for the book-keeping and management reporting of a small UK charity. - Ensuring accuracy and efficiency in the automation. Ideal skills and experience: - Proficiency in Excel, particularly in using formulas and creating macros. - Background in book-keeping and accounting. - Experience in automating tasks in Excel.
I'm in need of a data cleaning professional to help me with a spreadsheet containing 50,000 rows of company details. The data is currently organized in a single column and includes company names in mixed formats. Key Responsibilities: - Extract company names from the data strings - Clean the data manually to ensure accuracy Ideal Candidate: - Proficient in Excel or similar data management software - Exceptional attention to detail - Previous experience with data cleaning or data entry - Able to work independently and meet deadlines Please note that the company names are in mixed formats, so the ability to recognize and standardize these is crucial.
I'm looking for a proficient data entry specialist who can help me record mixed data (text and numerical) from Excel files. Key Responsibilities: - Accurately inputting mixed data (text and numerical) from provided Excel files. - Ensuring data integrity and accuracy during the entry process. Ideal Skills: - Proficiency in Excel and data entry. - Attention to detail to ensure data accuracy. - Experience in handling mixed data types. Please provide your experience with similar projects in your bid. Thank you.
...telecalling, sales, or customer interaction is a plus. What We Offer Remuneration: INR 20,000 per month (fixed) + attractive sales commission. Growth Opportunity: Potential to transition into a full-time role based on performance. Flexible Work Hours: Ideal for individuals looking to balance other commitments with a rewarding part-time role. How to Apply If you believe you have the skills and drive to excel in this role, please send your updated resume and a short voice recording introducing yourself....
Want to recreate this spreadsheet to add another section, a sixth one called Operations Also want to add our company logo
I'm in need of a comprehensive Excel workbook that can assist in managing and scheduling both staff and volunteers. The workbook should be capable of: - Scheduling staff and tracking days off - Computing hours and calculating salaries Additionally, the workbook should enable viewing the schedule in Gantt charts. Ideal candidates for this project should have a strong background in Excel, particularly in creating complex workbooks with various functions. Experience in HR or volunteer management is a plus. Please note, I will be providing the data necessary for hours computation and salary calculation.
I'm seeking assistance with reviewing 150 photos of retail stores each week. Based on a provided photo guide, you'll complete a simple report on each photo. This is an ongoing project. Key Responsibilities: - Assess photos primarily for product placement and store signage - Document observations in a spreadsheet - Include notes on promotional materials display - must have incredible eye for detail Ideal Candidate: - Detail-oriented with a keen eye for retail specifics - Proficient in spreadsheet software - Able to commit to weekly reviews and reports
...Email ID (if available) Key Guidelines: 1. Accuracy: Ensure the data matches the right company and individuals. 2. Relevance: Only collect details from the specified departments or leadership levels. 3. Uniqueness: No duplicate entries; only one set of data per company. 4. Professionalism: Emails should be valid, active, and professional in format. Delivery: - Compile the data into a structured Excel or CSV file using the above format. - Ensure the file is easy to navigate and filter for quality assurance. Let me know if any clarification is needed! If you going to start chat with me come with your pricing....
I need a freelancer who can assist me with data extraction from PDF files. The task involves: - Extracting text content from PDF files. - Accurately entering the extracted data into an Excel file. Ideal skills and experience for the job: - Proficiency in data entry with high attention to detail. - Prior experience with PDF data extraction and Excel. - Ability to maintain confidentiality and handle sensitive information with discretion.
...for a skilled developer to build a solution that identifies arbitrage opportunities using the sqrtPriceX96 value of token pairs across multiple decentralized exchanges (DEXs). The goal is to automate the process of finding and executing arbitrage opportunities by monitoring token pair prices on DEXs like Uniswap v3, Sushiswap, and others. The solution should follow a step-by-step process: 1. Query the liquidity pools of various DEXs for the sqrtPriceX96 values of token pairs. 2. Convert the sqrtPriceX96 values to actual token prices. 3. Identify price differences between DEXs to spot potential arbitrage opportunities. 4. Account for transaction fees (gas and conversion) when calculating potential profits. 5. Continuously monitor and automatically execute arbitrage strategie...
I'm looking for a skilled data analyst and Python programmer to create a code in Jupyter Notebook for analyzing data from Excel files. The project involves: - Primarily focusing on data analysis - Utilizing Pandas and NumPy libraries Ideal candidates should have: - Extensive experience with data analysis and Python programming - Proficiency in using Pandas and NumPy - Ability to work with Excel files - Familiarity with Jupyter Notebook Please include in your bid examples of similar projects you've completed. You are required to write the necessary program and create an effective presentation describing: The military spending of at least the top 10 nations (in military spending) Compare the data to that country’s GDP, Compare the data to the overall mili...
I'm in need of an Excel expert who can help automate some of my book-keeping tasks. The main focus will be on reconciling accounts. Your responsibilities: - Utilise experience with excel formulas and macros to refresh existing reconciliation process for the book-keeping and management reporting of a small UK charity. - Ensuring accuracy and efficiency in the automation. Ideal skills and experience: - Proficiency in Excel, particularly in using formulas and creating macros. - Background in book-keeping and accounting. - Experience in automating tasks in Excel.
I'm looking for an Excel expert who can create a dynamic data visualization tab for analyzing financial data specifically for ROI metrics. The main focus will be on cost savings and investment returns. Key Requirements: - Use of Charts and Graphs: I need clear and engaging visual representations of the data. - Pivot Tables: Help in summarizing the data and making the analysis more manageable. - Conditional Formatting: To highlight key trends and important information in the data. Ideal Skills: - Advanced Excel: Proficiency in using Excel's more complex features. - Financial Analysis: Understanding of financial data and metrics. - Data Visualization: Ability to present data in a clear and engaging way. Please only bid if you can deliver a high-quality, profession...
I need someone reliable to input data from PDF copies of timesheets from our construction crews into Excel for weekly costing purposes. - Data: Approximately 80 sheets per day, each covering 5–20 personnel - Delivery: I will send these sheets in a couple of batches on Friday / Monday. I need the completed task back first thing Tuesday. - Duration: This will be a weekly task for the next three months. - Resources: I can provide the employee names in Excel format, which will help improve data validation and accuracy. Skills and experience: - Proficiency in any spreadsheet software (Microsoft Excel, Google Sheets, etc.) - Experience in data entry - Attention to detail - Good communication skills Communication: My preferred method is email. I need someone...
I am looking for someone to copy and paste ALL the titles from my website into an Excel sheet You must copy and paste everything, EVERYTHING, EEEEEVERYTHING I will check only once and, if I find anything missing, the job will be rejected I have three websites. the budget is CAD$30
I have a corrupted Excel file that I'm unable to recover myself. The file contains complex formulas, and I'm unsure how it was corrupted - it could have been from a software crash, a virus attack, or an unexpected shutdown. - Any experience with data recovery from Excel files would be a plus
I'm in need of a professional who can create a product sales invoice in Excel for my business. The ideal freelancer for this project should have extensive experience with Excel and be able to incorporate specific features into the invoice. Key features include: - Automatic tax calculation - Discount options - Customizable logo and branding Each invoice needs to detail each product with: - Product description - Quantity and unit price - Product code or SKU It's crucial that the freelancer understands how to design an invoice that is both functional and visually appealing, reflecting my brand identity.
I have a 30-page PDF spreadsheet that is currently a scanned image. I need this data transcribed into Excel. The data is consistent across the pages, but primarily consists of text and some numbers. Key requirements: - PDF is a scanned image - Data is text-based - Needs to be converted into Excel Ideal skills: - Proficient in data entry and transcription - Familiar with Excel - Attention to detail to ensure accurate data transfer
I need an Excel spreadsheet to monitor the billed hours of each of our automotive technicians, as well as their total team hours each day. This tracking should be in relation to the daily goals we've set for them. This website gives some example of what I'm after Key Features: - A bar chart graphic display to visualize the data (along with actual numbers) - Tracking for individual technician hours and combined team hours - Comparison of hours worked against daily goals for individual as well as team -The graphic should represent how close to the set goal they are. Below 80% is red, 80-99.9% is yellow and 100% and up is green. Our automotive technicians are paid a bonus based their actual billed hours vs their target goal for billed hours. Also as a
I'm looking for a comprehensive three statement model to assist with investment analysis on the company ASML. This model should enc...encompass the following financial statements: - Income Statement - Balance Sheet - Cash Flow Statement In addition to the standard financial statements, the model should also include: - Discounted Cash Flow (DCF) analysis - Comparable company analysis (Comps) - Sensitivity analysis Ideal candidates should have extensive experience in financial modeling and investment analysis. Proficiency in using Excel for complex calculations is crucial, as is a solid understanding of DCF and Comps methodologies. A background in finance or a related field would be beneficial. Your expertise will help guide investment decisions based on the insights provided...
Cypress Hospital YOUNG, CCC Happy PharmD, Thanh 6 Cypress Hospital ...have two names that are the same), reference column C for that patient and sum column D for that Team. For example, column C contains a Team that worked on a patient, first patient Diaz, GGG, with a team of Taylor, Hong & Baby RPH, Mary and the second patient is Hoffman, FFF, with team of Taylor, Hong & Bold RPhT, Jeany. I need the total number of lines (column D) for each Team throughout the spreadsheet and the number of patients the Team worked on (column C). Sometimes there will be 1 pharmacist managing two techs. I have use the IF and IFSUMS function but I cannot get it to work, just too complicated for me. Please let me know what you think and what quest...
...similarly to , offering seamless web proxy functionality with integration of a Service Worker on the frontend for advanced request handling. Requirements: Backend (Proxy Server): Build a reverse proxy using and http-proxy-middleware. Support dynamic target selection, routing requests to different backends based on specific rules (e.g., request paths, query parameters, or custom headers). Forward headers, cookies, and other request/response metadata correctly to emulate CroxyProxy's behavior. Implement custom middleware to modify or log requests and responses as required. Frontend (Service Worker): Implement a Service Worker capable of: Intercepting all fetch requests from the browser. Routing requests
I need a skilled Excel professional to update my spreadsheet. The updates involve enhancing the existing formulas and functions, as well as improving the design and formatting. The base document just needs minor updates and needs to extend monthly from 2025-2035 Key Requirements: - Expertise with Excel functions and formulas - Strong skills in design and formatting Please note, the specific functions and formulas that need to be implemented have not yet been determined. However, you should be comfortable using lookup functions (like VLOOKUP, HLOOKUP), statistical functions (like AVERAGE, MEDIAN), and logical functions (like IF, AND, OR). Your ability to understand and manipulate data will be crucial to the success of this project. Ideal Skills: - Advanced Excel...
I'm in need of an Excel specialist. The main task involves creating an advanced Excel formula to assist with financial calculations, specifically focusing on data lookup. Key Tasks: - Design and implement an advanced Excel formula to perform financial calculations - Focus on data lookup aspects - Potential use of VLOOKUP, INDEX and MATCH, XLOOKUP or other relevant functions Ideal Skills: - Strong proficiency in Excel, especially with advanced formulas - Experience with financial calculations - Ability to translate complex data into understandable results - Familiarity with data lookup functions If you can help me navigate this task, please make a bid.
I'm seeking an Excel expert to assist with my financial data. The primary task will be to combine data and formulas to generate comprehensive reports. Ideal Skills and Experience: - Advanced Excel skills with extensive experience in handling financial data - Proficient in combining various types of formulas - Strong report generation skills - Previous experience with financial data analysis highly preferred.
I'm in need of an Excel course aimed at beginners. Key Course Topics: - Basic formulas and functions: Teach how to use simple formulas and functions in Excel. - Data entry and formatting: Focus on how to input data and format it correctly. - Charts and graphs: Introduce the basics of creating and interpreting charts and graphs. - Pivot Tables Content Delivery: The course should be delivered through engaging video tutorials. Ideal Skills: The freelancer should have a strong proficiency in Excel, experience in course development, and skills in video production. Experience in teaching or creating educational content is a plus.
...Loading: Loading large datasets causes significant delays, with processing times exceeding 30 seconds. Query execution slows further during bulk operations. Index and Query Optimization: Some queries are slower than expected, likely due to missing or inefficient indexes. Sequential scans are observed in large tables, which might indicate the absence of proper indexing. What I Need: Memory Utilization: Adjust PostgreSQL settings to ensure full utilization of 32GB memory while reducing CPU usage. Performance Optimization: Fine-tune data loading processes to reduce delays and ensure consistent performance, even under heavy loads. Suggest and implement optimal indexing strategies to improve query performance. Minimize the use of sequential scans on large datas...
I'm looking for an Indian freelancer to help me source local wood suppliers, specifically general wood suppliers, and obtain price quotations for Birch wood and wooden beams. Key Tasks: - Conduct an online search for prices and provide URLs in an Excel sheet. - Call companies for pricing and stock availability. Only consider companies that can deliver directly from stock. - Delivery must be to Mumbai. Products: - Birch wood: 12 mm thick, water resistant limed, in two sizes (2.40x1.20 meter - 30 pieces and 3.00x1.50 meter - 30 pieces). - Wooden beams: 4cm x 14cm and 6 meters long (most economical option) - 100 pieces. Requirements: - At least 3 accurate prices from different companies for both products. - Task needs to be completed by 19:30 India time on Friday 10 January. ...
I have an Excel billing sheet and need a new Excel document that connects with it. The purpose of this document is to pull a few fields from the billing sheet and present them in a form layout. Key requirements: - The new Excel should pull the following fields from the billing sheet: - Invoice Number - Client Name - Total Amount Due - Date of Service - Service Code Ideal skills for the job include: - Proficient in Excel - Experience with designing forms in Excel - Knowledge of linking data between Excel sheets.
We are looking for an eBay Listing Assistant to help me create new listings for Japanese goods. The candidate will be provided the spreadsheet that contains listing product information and will be asked to enter into our tool for listing (the manual and lecture will be given before commencement). This role requires effective communication skills and working independently to meet deadlines. If you have experience with eBay and are passionate about online sales, we would love to hear from you! 【Payment】 500 items listing ... 50 USD Note: At 1st time, 50 items 5 USD as Trial Note: Ideal person who could continue long-term for the job with us. Ideal Skills: - Proficiency in English; Basic Japanese skills are preferable - Prior experience with Data Entry / eBay listings * If the offero...
As discussed basically want it to look like an excel sheet, all the scanner names lined up at the top and have the stocks come down under each. and scanner in this order Multi Scanner, Breakout High, Daily High, Volume Inc. , % to change gainer, Intra Day Rise, Hug 9 EMA, HODspike, 2minSpike2. Have scanners update every 2-3 min.
I'm seeking a data analyst skilled in TTR (Turnaround Time) evaluation, specifically focusing on trends over time. Key Requirements: - Analyze historical TTR data to identify trends over time. - Utilize provided Excel/CSV files for the analysis. - Present findings in a clear and understandable manner. Ideal Skills: - Proficient in data analysis and statistics. - Experience with TTR analysis. - Able to work with Excel/CSV data files.
I need a data analyst to evaluate an Excel spreadsheet containing project data. The analysis should cover run rates, forecast dates, and schedule adherence on a weekly basis. Ideal Skills: - Proficient in Excel - Experienced in data analysis - Able to interpret project metrics No set rules for this analysis; it is simply a test to assess your ability to perform basic data analysis.
I need a data analyst to evaluate an Excel spreadsheet containing project data. The analysis should cover run rates, forecast dates, and schedule adherence on a weekly basis. Ideal Skills: - Proficient in Excel - Experienced in data analysis - Able to interpret project metrics No set rules for this analysis; it is simply a test to assess your ability to perform basic data analysis.
I'm Mandeep Kaur, a 25-year-old seeking help with data entry tasks. You will be primarily tasked with: - Excel data entry - Assisting with filling out application forms Skills & Experience: - Proficient in Excel - Detail-oriented and able to accurately fill out forms - Previous experience with data entry preferred Looking forward to your bids!
CREATE DATA BASE AND PROJECT WITH POWER BI ANALYSIS PROJECT WILL BE 1 DASHBOARD + 1 VBA CODE TO COLLECT DATA + ANALYSIS REPORT
I'm looking for a web-based script for managing a domain portfolio. The script should enable me to: - Track domain renewal dates - Add and remove domains in bulk - Move domains between different portfolios - Name portfolios (e....files per portfolio, as well as a global export - Backup daily and send via email The script should use a simple Username & Password authentication method. The ideal freelancer for this project should have prior experience in domain management and web script development. Knowledge of domain valuation and renewal processes is a plus. The script should allow for import/export in CSV and Excel formats. I'm open to additional features you may suggest based on your expertise. Please only apply if you are serious and able to delive...
...vocabulary-building board game for kids (same as Scrabble game - image attached). The logo should reflect the educational and fun nature of the game, appealing to both children and their parents. Requirements: Game Name: The logo must prominently feature Vocabble. Slogan: Include a slogan like below: "Play, Learn, Master English" "Building Brighter Minds!" "Unlock the Power of Words!" "Play, Learn, Excel!" ..... or you can suggest one. Design Style: Clean, modern, and colorful, appealing to families. Avoid overly complex elements. Format: Deliver in vector format (illustrator/corel draw format )and high-resolution PNG/JPEG for print and digital use. Need source file with all the fonts and elements. If you have any questions, pls dm ...
I'm in need of a seasoned full stack developer specialized in Laravel and Vue for creating a custom web application with a primary focus on data analytics and reporting. Key Responsibilities: - Develop a robust custom web application - Imple...data sources Ideal Skills: - Proficiency in Laravel and Vue - Extensive experience in REST API development - Strong background in data analytics and reporting - Skilled in working with databases (e.g., MySQL, MongoDB) and APIs (e.g., REST, GraphQL) The project will involve integrating with multiple data sources, including databases and APIs. Experience with external data sources such as CSV and Excel will also be beneficial. Your ability to handle complex data sets and create intuitive user interfaces will be crucial for the success o...
I'm seeking a skilled Power BI and Power Apps professional to transform multiple Excel sheets into an interactive Power Apps platform for various users. The project also includes the creation of a comprehensive dashboard. Key Requirements: - Transforming Excel sheets into a user-friendly Power Apps - Developing a dashboard tracking performance metrics, operational statistics, and assisting with actions and decisions Dashboard Visualizations: - Bar charts and line graphs - Pie charts and donut charts - Tables and matrices - Conditional formatted tables Additional Considerations: - Power App must support multiple clients in an Active Directory format Ideal Skills and Experience: - Proficiency in Power BI and Power Apps - Experience in creating interactive dashboards -...
...Financial Analysis: Calculate inventory turnover, carrying costs (including space and obsolescence costs), and aged SKU value losses. Visual Dashboard: Present data through Power BI or Excel dashboards with graphs highlighting key metrics. Insights and Actions: Recommend strategies like markdowns for aged SKUs, JIT replenishment, or phasing out low-performing SKUs. Deliverable: A professional report presenting cost reduction opportunities and ROI on inventory adjustments. Timeline Expectation: Starting with the month of January 2025 ETC: February 1 2025 3. Develop Forecasting/Planning Spreadsheet/Dashboard for 2025 Objective: Enhance decision-making through precise demand forecasting tied to financial metrics. Steps to Complete: Historical Data Analysis: Revi...
I'm in need of a Python script that can extract numerical data from an Excel/CSV file. The ideal freelancer for this project should: - Have extensive experience with Python, particularly in data extraction. - Be proficient with handling Excel and CSV files. - Be able to write clean, efficient code. Please note, the data will be purely numerical. The script will need to be able to handle large datasets with ease.
Build quote template as below - 1. Polish quote template 2. Macro to create new tab 3. Macro to add new slot in existing quote 4. PDF generation with Inclusion and Exclusion List 5. Push quote info to CRM (if API exists)
...Financial Analysis: Calculate inventory turnover, carrying costs (including space and obsolescence costs), and aged SKU value losses. Visual Dashboard: Present data through Power BI or Excel dashboards with graphs highlighting key metrics. Insights and Actions: Recommend strategies like markdowns for aged SKUs, JIT replenishment, or phasing out low-performing SKUs. Deliverable: A professional report presenting cost reduction opportunities and ROI on inventory adjustments. Timeline Expectation: Starting with the month of January 2025 ETC: February 1 2025 3. Develop Forecasting/Planning Spreadsheet/Dashboard for 2025 Objective: Enhance decision-making through precise demand forecasting tied to financial metrics. Steps to Complete: Historical Data Analysis: Revi...
I need to create 1 or 2 shortcut keys with macros in Excel for automating the formatting and reporting of my data. Ideal skills for this job: - Proficiency in Excel - Experience in creating and implementing macros - Ability to automate tasks efficiently
Hi, we need the attached PDF document to be translated from Italian to German, destination: Switzerland. We don't have the OCR for this, but I send you both the Word editable document of the first part, and the Excel that contains the following part (table). Please, use the Word and the Excel documents to create one only final document, like the PDF. I kindly ask you to add [unleserliche Unterschrift] wherever a signature appears. We don't have any specific deadline for that.
