Vba add ins excel仕事
I'm looking for a skilled VBA expert to assist with Excel automation. Key Responsibilities: - Automate data entry processes - Implement custom data validation rules Ideal Candidate: - Proficient in Excel and VBA - Experienced with creating and implementing custom validation rules - Able to deliver efficient, streamlined automation solutions
Doing a database search for the selected databases and sending an excel sheet containing the search results
I'm seeking a Virtual Assistant to help organise our Agile Development Backlog for a Software Develop...grooming. - Positive attitude and willingness to learn. The VA will need to use Slack for team communication. The expected weekly workload is less than 10 hours. Experience with Trello is a nice to have also. No specific technical knowledge is required, just good organizational skills and a willingness to learn. The Virtual Assistant can have flexible working hours. The VA should have weekly check-ins with developers to ensure stories and tasks are understood and prioritized correctly. The VA should participate in developer meetings as needed to assist with priorities and task understanding. The VA can be in any time zone. VA will be expected to sign an NDA upon acceptan...
Hi my dear the logo of the sigar lounge shoud be added wizh the name of the city. My client is really complicated and Im so sorry!!! it should be: Karo's Lounge Klingnau Klingnau please in the same Font like Karo's.
...should be compatible with both Android and Windows, and the primary purpose of this service is for backup and restoration of my files. Key Requirements: - Cloud Storage: The main function of the software will be to backup and restore my files securely. - Automatic Backups: The software should come with a feature that allows for automatic backups at set intervals. - Data Management: I have an Excel sheet filled with data that I want to manage through this app or software. The data should be converted and organized into a database that I can easily navigate and manipulate. Ideal Skills and Experience: - Proficiency in software development for both Android and Windows. - Experience with creating cloud storage solutions. - Ability to design user-friendly interfaces for data manage...
...- Assist in preparing consulting reports and presentations for healthcare clients. - Analyze data to identify business growth opportunities. - Support client projects with detailed research and strategic recommendations. **Requirements:** - Pursuing/completed a degree in Healthcare Management, Business, or Analytics. - Strong analytical and problem-solving skills. - Proficiency in Excel, PowerPoint, and data visualization tools. **What You’ll Gain:** - First-hand experience in healthcare consulting with AI integration. - Training on business scaling strategies using data-driven insights. - Internship certificate and performance-based reference letters. --- ### **Whiz Tech Internship Policy (Key Highlights)** 1. **Unpaid Internship:** All roles a...
...intake with calories , exercise, weight etc 2) Booking tickets and cancellation 3) Arranging parties etc. I would like to start with Tracking nutrition. In this task, Myself and Wife will share audio notes of the food we took , screenshot of exercise app , etc and this needs to be tracked on an excel sheet ( along with calorie input etc) on a daily basis. We can keep sharing this on a whatsapp group and at the end of a day (or every 2-3 days) the excel sheet needs to be updated. I will share a sample excel sheet we use for calorie tracking , calorie value will be there for the usual foods we take in that sheet. For new ones you need to use websites like nutritionix or apps like healthifyme to get the information. For Body weight tracking - We will share photos of...
We need an excel fully automated document for the insurance industry that can carry out the following system functions: 1) Excel to receive a word presentation from admin staff for 1 products called Rural Combined which will will contain a lot of data e.g. policyholder details, risk information e.g. names, dates of birth, property information, (risk addresses, sums insured), claims. 2) the risk information is extrapolated from the word (presumably into a CSV file and automatically driven into an excel rating calculator where it will undergo a number of functions to calculate a premium based on a set underwriting criteria where there will be rates built into the system The document will then produce a premium. 3) The information can then be merged back into a word ...
tôi cần lập trình file nhập liệu ex cho tổ chức, chủ yếu là sổ sách thu chi của tổ chức, và xuất báo cáo trực qua bằng đồ thị để dẽ dàng quản lý hơn
...personal assistant/accountant for my engineering company. This role involves a blend of administrative and financial responsibilities. Key Responsibilities: - Managing schedules and appointments - Handling financial records and bookkeeping - Processing invoices and payments - Preparing and submitting expense reports Essential Skills: - Proficiency in accounting software, particularly QuickBooks and Excel - Excellent organizational skills - Strong communication abilities -Familiar with google drive/sheets/earth Experience in the engineering sector would be a plus, but not necessary. What is crucial is your ability to handle the finances of a growing company with precision and professionalism. Role is for one big data entry project to start along with 1-2 hours a day of on-goin...
I'm in need of a data entry expert who can assist me in compiling and entering mixed data sourced from online databases into a database. Ideal Skills and Experience: - Proficient ...a focus on mixed data (both numeric and textual) - Experience working with online databases - Familiarity with database software and tools - Detail-oriented with a strong focus on accuracy - Able to manage time effectively to meet deadlines - Experience in querying databases using SQL or other querying languages - Strong skills in data cleaning and preparation - Expert proficiency in Microsoft Excel or Google Sheets for data manipulation Your role will involve: - Sourcing mixed data from various online databases - Accurately entering this data into a database The expected volume of data to be pro...
I'm seeking an Excel expert who can help me create a spreadsheet for analyzing viewing and analysing our machine assets and what stage of 'hire' they are on. Should have the ab ability to pick an asset and see the next 6-12 months, or pick a month, set of month, have one view of all assets etc Key Tasks: - Design a user-friendly Excel spreadsheet tailored for viewing and analyzing - Focus on tracking the 'Asset Hire Status'. The ideal freelancer should have: - Extensive experience with Excel, particularly in designing spreadsheets for data analysis. - Strong understanding of operational metrics. - Ability to create a spreadsheet that can track specific metrics effectively.
WE HAVE SOFTWARE BUILT FOR WINDOWS IN PYTHON AND NEED IT UPDATED: 1. Learn current software and get IDE and Git working for our updates. 2. Update Python Windows software to collect from a PC Web Camera STREAM. (See attached image) 3. Update software to accept any video stream. 4. Make sure the current loaded model runs across the stream. 5. Make sure GPU is used. (Not CPU) 6. LOAD / SAVE models function. 7. SHOW GPS coordinate contained in the model. Previous programmer did only 50% of work and dissappeared, you are the next star in our software advancement. I need a simple MVP with the above. I hav e customers waiting to see the MVP working with a screen record. Any and all work is to be loaded to our PC and sent to Git/Bit Bucket DAILY. We have a team who will check t...
...methodical approach ensures that all data is correctly inputted and organized. - Data Cleansing: I can enhance the quality of your data by identifying and correcting errors, ensuring consistency and reliability in your datasets. 2. Excel Proficiency - Advanced Excel Skills: I possess extensive knowledge of Microsoft Excel, including advanced functions, pivot tables, and data visualization techniques. This allows me to not only input data but also analyze and present it effectively. - Macros and Automation: I can streamline data processes through automated solutions using Excel macros, saving you time and reducing manual errors. 3. Attention to Detail - Thorough Review Process: I am meticulous in my work and perform multiple checks to ensure completeness an...
...skills for various projects. Translation: Professional translation services for documents and content. Medical Writing: Assistance with healthcare-related content and research. Data Entry: Accurate and efficient data management. Diet & Public Health Research: Creating reports and articles related to diet and health. PowerPoint Presentations: Creating professional and engaging presentations. Excel Work: Data analysis, charts, and spreadsheet management. Requirements: Strong attention to detail. Relevant experience in any of the above-mentioned fields. Ability to meet deadlines. Deliverables: High-quality, error-free work. Submission within the agreed timeline. Budget: Flexible, depending on the project scope and quality. These projects are long-term, requirin...
I'm seeking a skilled mobile app developer to create an iOS application to manage my loan business. The app should handle various loan parameters and client data,...automate calculations and notifications. Key Features: - Client data management - Loan amount tracking - Interest calculation - Timeframe for repayments - Notification system for due payments - Investor tracking for each loan - Capital totals for investors - Monthly interest calculations for each investor - Active/settled loan status toggle - Automatic Excel database updates Ideal Skills: - iOS App development - Database management - Excel integration - Notification system implementation - Financial software development experience The app should support manual data entry. Please note that I want this ap...
...should come in an Excel spreadsheet format. Key Components of the Project: - Inventory Report: This should detail our current stock levels, any shortages or surpluses, and projected needs based on current production rates. - Production Metrics: The report should include total units produced, production efficiency, and downtime causes. This will help us pinpoint areas for improvement and better understand our overall productivity. - Provide batch tracking information to trace inventory items through their production stages. - Include inventory turnover rate to assess how effectively inventory is being managed over time. - Include cost analysis regarding holding and ordering inventory to optimize financial efficiency. Ideal skills for this project include: - Proficiency in Ex...
I need an Excel data dump sheet designed to mimic the look and feel of my personal expense dashboard. This includes using the same colors as the dashboard. It should be tailored to incorporate specific safety categories, with the data arranged to display correctly on the graph. The ideal freelancer for this project should have - Extensive experience working with Microsoft Excel - Strong design skills to match the dashboard aesthetics - Understanding of safety data categories - Proficiency in creating Pivot Tables
...9 Total Risk Score 15.8 (Moderate Risk) Step 6: Mitigation Strategies For high or critical risks, outline corrective actions such as: Regular audits & compliance checks Enhanced training for caseworkers Improved fraud detection tools Automated eligibility verification This structured scoring method ensures an objective, data-driven risk assessment for LIHEAP. Could you like a customizable Excel template for this?...
More details: Is this project for business or personal use? Personal What information should successful freelancers include in their application? Past work How soon do you need your project completed? This question was skipped by the user
I need a skilled image editor to help with a project. Specific Tasks: - Remove the exclamation mark from the triangle - Replace it with an image I have ready to upload - Add a vape to the image so it appears the man is reaching for it Ideal Skills: - Proficiency in image editing software (e.g., Photoshop, Illustrator) - Attention to detail - Ability to understand and execute creative requests Please note, while the current image file format and resolution have not been specified, it is crucial that the freelancer can work with various file types and is able to maintain or enhance the image quality post-editing.
I'm looking for a comprehensive spreadsheet that will help me manage a speaker management system for an event series. Excel Specification: Speaker Management System Workbook Structure Sheet 1: Dashboard Quick overview of upcoming events Key metrics (number of confirmed speakers, pending approvals, etc.) Deadlines tracker Budget utilisation summary Monthly Event Sheets (Jan-Dec) Each month that has events will have its own sheet containing: Section 1: Event Details (Frozen Top Section) Event Title Date Range (usually 1-4 days for each event but 2 speaker days) Venue Location Target Audience Total Budget Budget Remaining (formula-calculated) Event Website URL Section 2: Speaker Management Grid Columns: Speaker Name Justification/Value Propositio...
I have a portrait photo with uneven lighting that needs to be corrected. The areas that need the most attention are behind the hair and around the head. I would like the ligh...like the lighting to be adjusted in a way that enhances the natural look of the photo, rather than creating dramatic effects. Ideal skills for this project include: - Proficiency in photo editing software like Adobe Photoshop or Lightroom - Experience in portrait photo editing - Ability to enhance natural lighting Freelancers with a keen eye for detail and a knack for subtle adjustments will excel in this project. Please provide samples of previous photo editing work, particularly portrait photos, in your bid. The final edited photo should be provided in JPEG format. The original photo is high resolution ...
...all "false bids" to Freelancer. This file will remain IN WORD. An excel file can be used to attain external data such as addresses and contact information. Payment will be made on COMPLETE project with no partial payments. Our quotations are made from a MS Word document. I am looking for someone to modify this quotation document with the following information. Please indicate if these requests are feasible without any 3rd party software and preferably form only 1 outside excel file for data. We will create an Excel “Contacts” document that will contain all our customer information. This data should be able to be pulled into our quotation. Company Name, address, contact name, email, phone to be pulled form an external Excel file. “...
More details: What format would you prefer for the email addresses? Excel spreadsheet How many local authorities are you targeting? More than 50 What specific information do you need besides email addresses? Contact names, Phone numbers, Email addresses The project needs to be completed within 1 week. Please verify all email addresses to ensure accuracy. These email addresses will be used for outreach campaigns targeting local authorities. Please include the contact departments associated with each email address. Please categorize the email addresses by region. Please conduct manual verification to ensure the accuracy of the email addresses. Please treat all regions with equal priority. The primary purpose of this outreach campaign is to request collaboration. Please name the fi...
I'm looking for an Excel expert who can create a Google Sheet for tracking my cryptocurrency portfolio. The sheet should monitor Bitcoin (BTC) and Solana in real-time, displaying market prices, portfolio movements, and gain/loss metrics. It should also feature Line charts, Bar charts, and Pie charts to visualize the data. Key Requirements: - Proficiency in Excel and Google Sheets - Experience in creating real-time data tracking tools - Ability to create and integrate various types of charts Ideal Skills: - Strong understanding of cryptocurrency and market tracking - Excellent data visualization skills - Attention to detail to ensure accurate tracking of gains and losses
I'm in need of a professional who can develop a method to link multiple Word documents with various Excel files. The goal is to create a comprehensive mapping matrix to facilitate process automation. Key Requirements: - Mapping of diverse data types: This includes text, numbers, formulas, assessment questions and workbook content from the Word documents to the Excel files. - Establishing a Many-to-Many relationship: The project involves linking multiple Word docs to multiple Excel files, ensuring a well-structured and efficient mapping system. Ideal Skills: - Proficiency in Microsoft Word and Excel - Expertise in creating mapping matrices - Experience in process automation Your bid should reflect your ability to deliver a seamless, automated process thr...
...this project will focus on core functionalities like order creation and invoicing, with a simplified user role system (admin and non-admin) and no external integrations. 2. Project Scope 2. Implement a search function to quickly locate orders using various filters such as customer name, order ID, or date range. 3. Allow exporting orders and invoicing data in various formats like CSV, PDF, and Excel for external reporting or bookkeeping needs. 4. Set up email or SMS notifications for important events like order creation, completion, and shipping updates. 5. Maintain a detailed log of changes and actions performed on each order, such as edits, status changes, and notes. 6. Enable bulk processing features to handle multiple orders simultaneously for operations like status up...
I need an Excel spreadsheet template for a quality control inspection report tailored for a machine shop. Key Requirements: - The template should include an inspection checklist - There should be a section for Pass/Fail criteria - The template should be user-friendly and easy to navigate - The design should be professional and suitable for a machine shop context Ideal Skills and Experience: - Proficiency in Excel - Experience with quality control processes in machine shops - Ability to create clear, concise, and professional templates
I'm in urgent need of an Excel macros specialist who can help with data analysis and reporting on financial data. Key Requirements: - Expertise in Excel macros, specifically for data analysis and reporting. - Proficiency in handling and interpreting financial data. - Ability to create summary reports from complex datasets. Ideal candidates will have a strong background in finance and data analysis, with a track record of creating effective Excel macros. Please be prepared to showcase examples of your previous work in this area.
On the Custom Club Jewelry Page please add a link to email for more info or ask about design services
Comprehensive debugging and fixing incomplete tasks and add 3 new features. The project finishing time is 2 weeks. Please check the file for complete inquiry details.
...scripts for efficient data extraction or those with a team capable of handling bulk processing. Requirements: • Expertise in Python or other relevant programming languages for PDF parsing • Experience with libraries such as PyPDF2, PDFMiner, or similar tools • Ability to extract structured data accurately (tables, text, etc.) • Handling of different PDF formats and layouts • Data output must be in Excel (.xlsx) format per template provided. Preferred Qualifications: • Prior experience with large-scale data extraction • Strong attention to detail and data accuracy • Ability to process PDFs with varying structures • Team availability for high-volume processing (if applicable) Selection Process: • We will conduct interviews to und...
...questionnaire with set parameters need to be uploaded on the site for the visitors to take the survey with a description of the survey and its importance. Once a survey is live we need to register the records for 45 days during that time our partner NPOs work locally in promoting and awaring people to take survey. Post 45 days we need to fetch all the information into spreadsheet (Google Sheet, Excel recommend) the using Power BI, python language another team work on analizing the records and forms a detailed illustration for the data. And a well defined resource backed research paper need to publish on the site in the form of blog and a download link for the papers. Based on working description of the company I need a mature design for the website. The work will include &quo...
I'm looking for a professional to help me fill out an Excel sheet for a financial model. The sheet will involve data from the Income Statement, Balance Sheet, Cash Flow, Operating Working Capital, debt, depreciation, amortization, equity, shares, and various financial ratios. The annual report is available for reference. Skills and experience required: - Extensive knowledge of financial modeling - Proficiency in Excel - Ability to interpret and analyze financial statements - Experience working with financial ratios - Attention to detail.
I need to add myself in a few group photo naturally. I can provide more selfie if needed. Let me know if you have this skill! I need that no one able to find that is computer mixing! Thanks alot.
I'm looking for a freelancer who can build a comprehensive dashboard in Excel for tracking employee performance data. Key Requirements: - The dashboard should track 16 key performance indicators (KPIs) related to equipment conditions. - Visual elements should include charts, graphs, gauges, and meters. I already make it but need to enhance and also to add more slides. Ideal Skills: - Proficient in Excel with experience in building dashboards. - Understanding of employee performance and equipment condition metrics. - Capable of creating user-friendly, visually appealing dashboards.
...appointments. Your main responsibilities will include: - Data Entry: Accurately inputting information into Microsoft Excel/Word. - Email Handling: Managing my inbox, sorting emails, and responding to necessary correspondence. - Scheduling Appointments: Coordinating my calendar and setting up meetings. - Travel Arrangements: Booking flights, hotels, and transportation for business trips. - File Management: Organizing and maintaining digital and physical files. - Document Preparation: Creating and editing reports, presentations, and other documents as needed. - Meeting Minutes: Taking detailed notes during meetings and distributing them as needed. I prefer using Microsoft Excel/Word for task management, so proficiency in these programs is essential. Communication will pri...
I'm looking for a freelancer who can analyze and format my sales data into a clear, tabular Excel report. Key Requirements: - Experience with Excel is a must, especially with data formatting. - Familiarity with sales metrics and how to present them in an informative manner. - Ability to meet deadlines and provide a high-quality, easy-to-understand report. The report will primarily focus on total sales, sales by product category, and sales by region.
I'm looking for an experienced Excel professional to compile a calendar for 2025 and 2026. This will include marking work tasks and deadlines, 2nd & 4th Saturdays, Sundays and all Hindu holidays. Key Requirements: - Organize data week-wise in an Excel sheet - Distinctly mark 2nd & 4th Saturdays and all Sundays - Highlight all Hindu holidays and list them in a separate column - Use Conditional Formatting and Pivot Tables to ensure easy readability and proper formatting Ideal Skills: - Proficiency in Microsoft Excel (Formulas, Conditional Formatting, Pivot Tables, etc.) - Data Entry & Processing - Attention to detail - Experience handling large datasets Deliverables: - Well-structured Excel sheet - Clearly marked week-wise data - Properly high...
I'm seeking a meticulous Data Entry Operator to assist with inputting and structuring data into Microsoft Excel. The job will entail: - Transcribing data from a variety of sources including scanned documents, PDFs, and handwritten notes into an Excel spreadsheet. - Ensuring the accuracy of the data and catching any potential errors. - Structuring the data chronologically for easy access and retrieval. - Upholding confidentiality when dealing with sensitive information. Ideal candidates should have: - A good typing speed and a high degree of accuracy. - Proven experience with Microsoft Excel or other data entry software. - An exceptional attention to detail. - The ability to meet deadlines consistently. Project Duration: 1-2 weeks (potential for extension based...
...detail in payroll tasks. The employee information will be provided in a digital format such as an Excel or Spreadsheet. The W-2C forms should be completed within 2 weeks. The completed W-2C forms should be provided in PDF format. You may use any software you are comfortable with for preparing the W-2C forms. The freelancer should also review the corrected wage information to ensure its accuracy. The freelancer only needs to prepare the W-2C forms. The selected freelancer will be responsible for reviewing the corrected wage information to ensure its accuracy. verifying the info with social security to make sure what's being put down as current value is indeed what they have, then we will add the corrected value. The freelancer can use any software they are comfortabl...
...organizing, and optimizing ad creatives for digital marketing campaigns✅ Web Development & Email Marketing Support: Help in basic website updates, email campaign execution, and tracking performance analytics✅ Inbox & Task Organization: Assist in managing and organizing business and customer emails for better workflow efficiency ? Requirements & Qualifications: ✔️ Expert in Google Sheets / Excel (advanced formulas, pivot tables, conditional formatting, scripting)✔️ Experience with Shopify API, , and Zapier✔️ Ability to automate data imports and reports✔️ Strong understanding of demand forecasting & financial modeling✔️ Experience working with inventory tracking and supplier forecasting✔️ Proficiency in customer support data tracking and report generation✔️ Ex...
...skills for various projects. Translation: Professional translation services for documents and content. Medical Writing: Assistance with healthcare-related content and research. Data Entry: Accurate and efficient data management. Diet & Public Health Research: Creating reports and articles related to diet and health. PowerPoint Presentations: Creating professional and engaging presentations. Excel Work: Data analysis, charts, and spreadsheet management. Requirements: Strong attention to detail. Relevant experience in any of the above-mentioned fields. Ability to meet deadlines. Deliverables: High-quality, error-free work. Submission within the agreed timeline. Budget: Flexible, depending on the project scope and quality. These projects are long-term, requirin...
I require an Excel expert to streamline my weekly report process. This involves merging four distinct reports - Maintenance, Operations, Supply Chain Management (SCM), and Finance - into one comprehensive Excel spreadsheet. Key tasks: - Combine the four reports into one Excel sheet on a weekly basis. - Visualize the data trends over time using a bar graph. - Ensure the graph highlights the key trends across the four departments. - Automate the import of data from each of the four reports to reduce manual input. - Develop a dashboard in Excel that displays key metrics and trends in a user-friendly format. - Generate a weekly summary report that provides insights and highlights key findings. - Set up conditional formatting or alerts to flag any significant chang...
Need to cover and update the following points 1: Prevent users from copying and pasting data to the Template file from other files 2: Link the new planning template to VLOOKUP file. Need the Dropdown data validation options on this file to match the Vlookup file that we maintain separately and use for our other templates. 3: Ensure that VLOOKUP file needs to be referenced from original location instead of creating a copy to the folder. 4: Stop workbook links message when file is opened 5: Stop VLOOKUP file closing message when file is closed
I am looking for a skilled Power BI expert to create a dashboard primarily focusing on sales analytics. Key Requirements: - The dashboard should connect to Excel/CSV files. - It should track revenue by product. Ideal Skills and Experience: - Proficiency in Power BI. - Experience in sales analytics. - Ability to work with Excel/CSV data sources.
I'm seeking help with matching date ranges in my data. The data is time-sensitive and needs to be handled with precision. Ideal Skills and Experience: - Proficiency in Excel, particularly with the INDEX and MATCH functions - Strong understanding of date and time data - Experience in data analysis and sorting - Attention to detail to ensure accurate matching of date ranges
I have an Excel sheet containing sales data and I need help converting this information into a parts needed list. The parts list should be organized by dates of sales. Key requirements: - Identify individual components from sales data - Organize parts list by sales dates Ideal skills: - Proficiency in Excel - Experience with data analysis - Attention to detail
