Excel data form invoke vba jobs

I'm looking for a skilled Data Analyst with expertise in Google Data Studio to create dashboards from Google Sheets data. Key Requirements: - Analysis of performance metrics - Use of Excel/CSV files as data sources - Creation of interactive components in dashboards - Incorporation of custom date range filters - Integration of multiple data sources beyond Excel/CSV - Development of custom report templates - Dashboards/Data visualization Ideal Skills: - Proficiency in Google Data Studio - Strong data analysis capabilities - Experience with Excel/CSV files - Understanding of performance metrics

I am seeking an expert in Microsoft Excel to create a simple yet effective spreadsheet for tracking sales. The spreadsheet should allow me to monitor: - Sales by date - Salesperson (Client names) - Goal percentage in relation to team sales goals The ideal freelancer for this project should have extensive experience in Microsoft Excel, and be able to create a user-friendly, intuitive spreadsheet that meets my requirements. Please, be prepared to demonstrate your prior work in Excel.

...• Engagement Boost: Optimizing content for engagement to lead to higher interaction rates, such as likes, shares, and comments, which can help build a loyal community around for the brand. • Brand Consistency: Ensuring a consistent brand message and aesthetic across all social media platforms to strengthen brand identity and make it more recognizable. • Customer Insights: Analyzing social media data by providing valuable insights into customer preferences and behaviors, helping us to tailor our marketing strategies more effectively. • Influencer Collaborations: identify and collaborate with influencers who align with our brand, expanding our reach and credibility. 11.2 On-Page SEO: On-page SEO focuses on optimizing individual web pages to rank higher and earn...

I need an expert in Excel to set up a comprehensive spreadsheet that tracks my retail product inventory, wholesale and shipping costs, sales prices and profits. Key Requirements: - Design an Excel spreadsheet to monitor: - Retail product inventory - Wholesale costs and shipping costs - Sales prices and profits - Implement a functionality to import order data from Faire, my wholesale provider, on a monthly basis. - Create automatic monthly sales and profit reports utilizing the imported order data from Faire. Ideal Skills: - Proficiency in Excel - Experience in designing inventory tracking systems - Familiarity with data import functionalities - Understanding of retail and wholesale cost tracking Please bid if you have the relevant experien...

...Fabrication – Excel & ERP Integration Project Overview Impress Group is a precision engineering company supplying components globally. We specialize in laser cutting, bending, milling, turning, powder coating, welding, and fabrication and need a fully automated, accurate, and structured pricing model to improve efficiency and consistency in job costing. This project, called Project Alpha, aims to develop a dynamic, rules-based Excel pricing tool that: - Automates the quoting process using simple user inputs from technical drawings - Prevents incorrect quoting by restricting users from quoting parts beyond our manufacturing capabilities - Calculates accurate process pricing for all services - Generates time decimals for ERP integration (routing times) ...

I need an excel sheet for my chemical inventory. The sheet should have the following columns: - Item/description - Item # - Quantity - Reorder status (some automated cell that when the quantity on hand matches the min quantity then it turns red?) - Vendor - Expiration date - Methods the chemicals are used for - order status and/or Comments The ideal candidate will have experience with chemical inventory management. Please include advanced search and filter options for better usability. I do have an example of an excel sheet we’ve been using that I can share, it’s not organized at all but it’ll give an idea of what information we’ve been tracking.

I'm looking for a professional with profound expertise in Excel and data handling to assist me with hashing and encrypting mixed data (text and numbers) within the software. Key responsibilities include: - Hashing and encrypting mixed data using AES (Advanced Encryption Standard) - Ensuring the primary purpose of data encryption revolves around maintaining data integrity Ideal skills and experience for the job: - Mastery in Excel with a strong background in data handling - Proven experience with AES encryption - Strong understanding and capability in ensuring data integrity through encryption Please provide your relevant experience and examples of similar projects you have completed in your proposal.

I'm looking for an experienced Power BI specialist to revamp my current dashboard. The primary purpose of this dashboard is to facilitate reporting and analysis. Key Requirements: - Proficient in Power BI - Experience with data visualization - Ability to create engaging charts, graphs, maps, and tables Current Data Sources: - Excel files - SQL databases - APIs Your Role: - Enhance the current dashboard for better reporting and analysis - Connect and visualize data from the specified sources Ideal Skills and Experience: - Expertise in Power BI - Strong background in data analysis and visualization - Ability to create user-friendly and informative dashboards

I'm in need of a proficient Excel spreadsheet for quoting mechanical engineering parts. The spreadsheet should include automated calculations to streamline the quoting process. Ideal skills for this project include: - Advanced Excel capabilities - Understanding of mechanical engineering parts - Experience in creating quotation spreadsheets. - Ability to create and troubleshoot complex Excel formulas. Please ensure that your bid reflects your expertise and previous work in this area.

I need assistance reviewing a 900-page PDF document to extract and summarize project milestones into a high-level summary. The milestones need to be organized in chronological order by specific dates found within the document. Your task will include: - Identifying key project milestones from the document. - Creating a high-level summary of these milestones in excel spreadsheet format referencing the page numbers of documents into a contents column once documents rearranged into chronological order - Organizing the scanned documents chronologically according to the dates of the milestones found in the documents Ideal skills for this project include: - Proficient reading and comprehension skills. - Ability to distil complex information into concise summaries. - Experience with project...

I'm in need of a professional to help me organize some legal documents and prepare various spreadsheets for legal purposes. The types of documents that need to be organized include text messages, expenses, and emails. Ideal Skills: - Document management - Spreadsheet proficiency (Excel, Google Sheets) - Attention to detail - Understanding of legal documentation processes - Confidentiality and discretion Project Requirements: - Organize text messages, expenses, and emails - Prepare spreadsheets for expense tracking, communication logs, email records - Categorize expenses by date, type of expense, and client Please keep in mind that this project requires a high degree of confidentiality and discretion. Your ability to maintain privacy while handling these sensit...

I'm seeking a long-term Odoo developer, ideally a junior with 1-2 years of experience. The primary focus of this role will be on custom module development. Key Responsibilities: - Design and develop customized Odoo modules - Collaborate on various ongoing projects Ideal Skills: - Proficiency in Odoo - Experienc...experience. The primary focus of this role will be on custom module development. Key Responsibilities: - Design and develop customized Odoo modules - Collaborate on various ongoing projects Ideal Skills: - Proficiency in Odoo - Experience in custom module development - Problem-solving skills for bug fixing and maintenance - Understanding of system integration - experience on pos customization, excel reports , upgrading DB This is a long-term position with an hou...

I need a Power App form designed for data entry, specifically for capturing user information. This form will be integrated with workflows that generate a PDF and a CSV file, which then get sent to our service desk. Ideal skills for this project include: - Proficiency in Microsoft Power Apps - Experience with form design and development - Understanding of workflows and automated processes - Ability to generate and format PDF and CSV files - Familiarity with service desk communication protocols - Experience in using Power Automate for workflow automation. As the project does not specify which particular fields of user information are needed, the freelancer will need to use their expertise to recommend the most relevant fields to include in the form.

I need a Windows computer fully configured and set up with the same software and settings as my existing one, at a different business location. Key Requirements: - Install and setup crucial software: Dropbox, Excel, Windows, Outlook - Replicate network configurations, user profiles, and preferences from the original computer Ideal Skills and Experience: - Proficiency in Windows computer setup - Experience with software installation and configuration - Knowledge of network setups and configurations - Understanding of user profile and preference replication

...to assist with migrating my rental properties from Excel spreadsheets to Xero. Key Responsibilities: - Build a comprehensive chart of accounts - Configure Property, Plant, and Equipment (PPE), depreciation, mortgages, rental income, prepaid income, etc. - Set up classes in Xero to manage income from different properties - Configure the system for two property owners - Migrate data for a total of five properties Challenges: The main challenge I face is ensuring Xero is configured correctly to handle my particular needs. Ongoing Support: After the initial migration is complete, I would require occasional support to troubleshoot and assist with any issues. Current Categorization: Currently, all my rental property transactions in Excel are categorized by proper...

I'm looking for an Excel specialist who can automate generating reports with macros and integrate this process with Outlook. Skills Needed: - Advanced Excel proficiency, especially in macro automation. - Strong understanding of report generation. - Experience with Outlook integration. This is a crucial task for improving my productivity and streamlining my reporting process. Please provide examples of similar work you've done in the past.

...rebuild an existing quote request form on my WordPress website. The current form, built with Elementor editor, is proving difficult for customization and needs to be replaced with a more user-friendly solution. Key Requirements: - Extensive experience with WordPress and form plugins - Ability to customize forms with ease - Proficiency in Javascript for enhancing form usability Ideal Skills: - WordPress form plugin expertise (Contact Form 7, WPForms, Gravity Forms) - Advanced CSS for enhanced styling options - Experience with Elementor and its limitations Form Specifications: - The new form must include radio buttons, dropdown menus, and text input fields - The form should be easy to customize and have enhanced styling opt...

I need a skilled WordPress developer with expertise in the Adifier theme. The primary focus will be enhancing the site's functionality, particularly related to user profile features. The project involves tra...enhancing the site's functionality, particularly related to user profile features. The project involves transferring 29,000 members and 1,500 classified ads from our old PHP site to the new Adifier Wordpress site. Username, first name, last name, email address, phone number and city need to be transferred to new site from an excel spreadsheet. Ideal skills for this job include: - Expertise in WordPress and Adifier theme customization - Proficiency in PHP and MySQL for data transfer - Experience with user profile feature enhancement - Excellent problem-solving...

I'm seeking a skilled professional for data migration, specifically moving product data from Excel to SQL. Key Requirements: - Proficient in Excel and SQL - Experience in data migration - Familiarity with handling product data - Able to ensure accuracy and integrity during the migration process

I'm looking for an Excel expert who can assist me with data analysis tasks. Key Responsibilities: - Perform data sorting and filtering tasks - Conduct data analysis to derive insights Ideal Skills: - Proficiency in Excel - Experience in data analysis - Attention to detail for sorting and filtering tasks

I'm looking for a data analyst who can interpret my sales data and visualize it effectively. The primary objective of this project is to compare performance across different time periods, regions, or products. Ideal skills and experience: - Proficiency in data analysis and interpretation - Experience with sales data - Skills in creating clear, insightful visualizations - Ability to compare performance metrics effectively - Advanced skills in Microsoft Excel for data manipulation and analysis. - Experience with statistical analysis to identify trends and patterns in sales data.

Project Title: Looking for Skilled Content Writers, Typists, Translators, and Data Entry Experts Description: I am seeking freelancers with expertise in the following areas: Content Writing: Articles, blogs, and creative story writing. Typing and Copywriting: Fast and accurate typing 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. Requirem...

I'm in need of a detailed research into undergraduate Economics programs across 25 colleges from the USA and UK. The data should be meticulously organized into an Excel sheet. I will give the list of colleges that I need this information for. Key aspects to focus on: - Admission Criteria: What these colleges look for in terms of marks/grades, SAT scores or other standardized tests, and any college-specific tests. Additionally, include information about required essays and subjects to be taken in school. - Program Details: Course curriculum details of the Economics programs offered by these colleges. - Tuition Fees: Detailed information on the tuition fees for the Economics programs at each college. After the initial research on the USA and UK, I plan to expand this p...

I am seeking a skilled VBA/Excel programmer to develop an inventory program within excel that will allow the following: 1) allow me to add products into a components inventory database using a form Fields are: Vendor, SKU, UPC, Status, QTY STOCK, EXP DATE, Category, Brand, Component Name, Component Description, Size, DIMS, Gross Wt, Case Count, Case Cost, Unit Cost, Component URL, Product Image 2) Bundle Design Tool - a graphical design form that allows me to add different components to build a bundled product. Fields are: Bundle Name, Bundle Desc, SKU, Theme Category, Inspired By, QTY STOCK, STOCK STATUS, Target MSRP, Target Cost Website URL, Shipping Weight, Dimensions Components List/Cost Analysis: in the form there will be a list tha...

Job Description: Excel Advanced Formula Specialist Job Overview: We are seeking an Excel Advanced Formula Specialist to join our team. The ideal candidate will have expertise in advanced Excel formulas, functions, data analysis, automation, and reporting. This role involves developing complex formulas, optimizing spreadsheets, and ensuring efficient data handling for business decision-making. Key Responsibilities: Develop and implement advanced Excel formulas (e.g., INDEX-MATCH, VLOOKUP, XLOOKUP, SUMIFS, COUNTIFS, IFERROR, INDIRECT, OFFSET, ARRAYFORMULA). Create and manage pivot tables, charts, and dashboards for data visualization. Automate tasks using Excel VBA (Macros) and Power Query to improve workflow efficiency. Clean, ...

I'm seeking help with automating my Excel spreadsheet. I've done considerable work already and have an instruction document to guide us. - Task: Spreadsheet automation - Software: Microsoft Excel - Assistance: Determining the type of automation needed (potentially macro creation, formulas and functions, or data import/export) Your expertise in Excel and experience with spreadsheet automation will be crucial. I'm open to a call if further clarification is needed. Please provide a time estimate and cost for this task in your proposal.

I have a PDF form created in Adobe Acrobat that requires modification. I need the form to automatically re-calculate when fields are updated. The calculations involve basic arithmetic such as addition, subtraction, multiplication, and division. Key Requirements: - The form involves more than 10 fields that need to be included in the calculations. - Ideal candidates should have extensive experience with Adobe Acrobat and PDF form creation/modification. - A strong understanding of basic arithmetic and its application in form calculations is essential. - Prior experience with creating auto-recalculating PDF forms will be a significant advantage.

I need help with managing and analyzing Excel spreadsheets. The tasks will primarily involve data entry, analysis, and possibly creating charts or graphs to visually represent the data. Ideal skills and experience: - Proficient in Microsoft Excel - Experience with data analysis and visualization - Attention to detail - Good organizational skills

I'm looking for an Excel expert who can design a custom spreadsheet and dashboard template for tracking the completed yearly contract requirements of approximately 1,200 healthcare providers. Currently, we track completion of quarterly training completions, submission of required quality reporting documents, and important contact information which is updated and confirmed quarterly. Key Requirements: - The spreadsheet will be used internally to monitor the completion of specific trainings and the submission of quarterly documents. - It must also track current contact information (email, phone, point of contact, etc.) for each provider. - The dashboard will need to be user-friendly for both internal team and external stakeholders. - Include data visualization features s...

...analytics dashboard that processes revenue and expense data for mobile applications. Project Overview: - Dashboard processes CSV revenue files and Excel expense files - Combines data to gen erate comprehensive reports - Uses React.js with Material UI for frontend - Handles multiple file formats and data transformations Technical Requirements: 1. Strong experience with:   - React.js   - Material UI (MUI)   - Excel/CSV file processing (, Papa Parse)   - JavaScript/ES6+   - Git version control 2. Must be able to:   - Understand existing codebase   - Debug data processing issues   - Add new features   - Optimize performance   - Handle file validati...

I'm looking for an Excel expert who can design a custom spreadsheet and dashboard template for tracking the completed yearly contract requirements of approximately 1,200 healthcare providers. Currently, we track completion of quarterly training completions, submission of required quality reporting documents, and important contact information which is updated and confirmed quarterly. Key Requirements: - The spreadsheet will be used internally to monitor the completion of specific trainings and the submission of quarterly documents. - It must also track current contact information (email, phone, point of contact, etc.) for each provider. - The dashboard will need to be user-friendly for both internal team and external stakeholders. - Include data visualization features s...

...Dashboard) Description: I need a custom web-based tool that integrates with the Facebook Ads Library API and TikTok Ads Library API to collect ad data and display it on a dashboard. The tool should allow me to apply filters such as: • Keyword/Term Search • Landing Page URL • Date Range • Ad Type (Image, Video, Carousel, etc.) • Language • Country Key Features: 1. API Integration: Fetch real-time ad data from Facebook & TikTok Ads Libraries. 2. Dashboard UI: A clean, user-friendly interface to view and filter data. 3. Filtering System: Apply advanced filters to find specific ads. 4. Data Export: Ability to download filtered data in CSV/Excel. 5. Ad Preview: Show ad creatives, captions, and engagement...

I'm in need of a design for a printable payroll tracking form. This paper will be used for day-to-day payroll tracking. It should be able to accommodate the following information: - Employee details: While I will be filling out the specifics, the design should allow for comprehensive employee information to be recorded. Ideal skills for this job would include graphic design, experience with creating forms for payroll or HR purposes, and a good understanding of layout and design principles to ensure the form is easy to use and understand.

...seeking a web scraping expert to extract data from the Accredia database and organize the results in an Excel file. Key tasks: - Scrape data on all Italian companies certified UNI/PdR 125:2022, categorized by region. - For each company, extract the following information: - Company name - VAT number - Region - Address - Number of employees, divided by gender if available - Certification date - Certifying body - The data needs to be sourced from: - The final Excel (XLSX) file should have a separate sheet for each region, with companies organized by number of employees. Requirements: - Proficiency in using Selenium for web scraping. - Ability to ensure data accuracy and quality through cross-referencing

I am a college professor seeking assistance in verifying the completion of 17 Python coding assignm...seeking assistance in verifying the completion of 17 Python coding assignments submitted by my students. Each assignment contains 6 problems and is housed in Python/Jupyter notebooks. Your task will be to check that each student has completed each problem. Requirements: - Indicate the file name and the corresponding completion status (6 problems per assignment) on a separate sheet in an Excel spreadsheet. - The Excel report should indicate whether each assignment has been completed or not. - No specific comments are required, just a confirmation of completion. - The results can be organized in any order. Ideal Skills: - Familiarity with Python and Jupyter Notebooks is cruci...

I'm seeking a skilled data analyst with experience in MySQL and Power BI to create a tailored report for me. The report needs to pull data from a local MySQL database and present it in Power BI or alternative tool.. Key Requirements: - Extract bespoke data from a local MySQL database. - Create a report with this data. Report could be in Power BI, excel or other I am open to suggestions. - Include summary statistics in the report. Ideal Skills: - Strong proficiency in MySQL. - Extensive experience with Power BI. - Excellent data analysis skills. - Ability to understand and work with bespoke data. I have attached a mock up of roughly how I would like the report to look. The database is a horseracing database. The way it would work is ...

I need a skilled After Effects professional to duplicate a template for me. The source template...which can easily be replicated. Key Requirements: - Duplication of a general video template in Adobe After Effects - Addition of "comps" to facilitate bulk video downloads based on an Excel sheet Data Specifications: - The Excel sheet contains both text and images - Text from the Excel sheet needs to be incorporated into the videos as text overlays and in the intro/outro text blocks Ideal Skills and Experience: - Proficiency in Adobe After Effects - Experience with video template duplication - Familiarity with creating "comps" for bulk video production - Ability to integrate both text and images from an Excel sheet into a video - Experi...

Excel Healthcare Ltd are looking for a third party company to help us create our Amazon store. If you are a company that has experience in this field, please get in contact with us today.

I'm seeking an Excel expert to assist with transferring data from Excel to MS Project template

I'm looking for a freelancer who can create a simple and minimalistic custom payment form. This form should allow users to input their PayPal email, enabling them to receive payments directly via PayPal. Key Requirements: - Development of a custom payment form - Integration with PayPal for seamless transactions - Design of a simple, user-friendly interface Ideal Skills and Experience: - Proven experience in creating custom payment forms - Strong understanding of PayPal's API and integration methods - UI/UX design skills for creating simple and minimalistic designs

I have attached an Excel spreadsheet. There are 5 tabs. The first tab (called "Config & Matrix") needs to calculate predicted construction completion dates for plot/construction stage combinations (the current predicted construction dates (highlighted in yellow) just contain basic formulas). The formulas that you create will need to take into account the data on the "Project Setup+Management", "Contract Manager Portal" and "Site User Portal" tabs. The "Resource Data! tab can be ignored. If you look at each tab, you will see I have included cell descriptions and example entries. I have also attached a diagram to help you understand how the "Config & matrix" tab needs to calculate both the plot/stage dates...

For this to happen the site needs to be on page 1 of google/bing for a few keywords

I'm looking for a skilled Python developer who can create a script for me, which I can run on my local machine. The main aim of this script is to automate the process of generating Excel reports. Key Tasks: - The script should automate the generation of reports, saving me the time and effort of doing this manually. Ideal Skills: - Proficiency in Python is a must. - Prior experience in creating automation scripts would be highly beneficial. - Familiarity with Excel and its Python libraries (like pandas or openpyxl) is preferred. I would like to work with someone who can deliver a robust and efficient script that meets these requirements.

I'm seeking an experienced UiPath developer to help me automate complex data entry tasks. The automation will primarily involve: We will be having more than 100 Invoice formats. The system should automatically read these formats and write into excel csv file. Ideally, the freelancer should have extensive experience with UiPath, a deep understanding of data manipulation processes, and a proven track record of automating tasks across web-based applications and database systems. Proficiency in these areas will be crucial for the successful completion of this project. The estimated volume of data for automation is medium. The system should support template-based extraction for data extraction. The automation should run hourly. The system should log ...

I need an online software automate to convert data in some documents. the project is divided in 2 phases. first has to be ready the first phase and then the 2nd phase. Phase 1: Document Generation Extracted data is required to generate: • Share Certificate- Contains 9 fields from the extracted data. • Share Ledger- Contains 12 fields of which 9 fields are in the same as the Share Certificate. • Data extraction from agreements • Excel formatting or a structured table. • Automatic document generation (Share Certificate & Share Ledger in PDF) • Automatic Document Filing • Automatic emailing of Specific Documents Two level logins A. Mester login B. User login • Upload folders of the documents &bul...

I need a method or script to send bulk SMS messages from a phone number located in another country. The phone can be accessed through Google Messages for Web. The phone numbers list where we have to send the message are listed in an Excel sheet. The ideal solution should be easy to use and not overly complicated. Key Requirements: - A simple method or script to send SMS in bulk. - The solution should not be overly complex or difficult to use.

I'm looking for a skilled professional who can automate the trend analysis of stock data in Excel, using Python or other suitable tools. Key Tasks: - Automate data analysis in Excel - Sheet1 data automate copy sheet 2 every minute -Sheet 1 data copy every minute to sheet 2(column F of sheet1) and sheet 4 (column O of sheet 4) as per upload sheet

System Overview The System is a comprehensive data collection and analytics platform built around EasyForms, enabling seamless data entry, integration, and visualization. It consists of three main components: MOBILE APP (Flutter) – A mobile app for field data collection, supporting offline mode, GPS tracking, QR code scanning, and file uploads. Users can register farms, fill forms, and sync data with the system when online. CONNECTOR (Laravel) – A middleware that integrates various data sources into EasyForms. It supports: API uploads to connect external websites. Live database connections for seamless data transfer. File uploads (CSV, Excel, SQL, WHONET/FTP) with field mapping. Dashboard for monitoring connection status and...

I'm looking for an Excel expert to help me set up a task tracking sheet in Excel 2010. The sheet will be used to track team assignments and should include color coding based on team members. Ideal candidates will have: - Proficiency in Excel 2010 - Experience with creating task tracking systems - Ability to work with Arabic language settings - Creativity in color coding systems The final product should be a functional and visually clear task tracker.

I'm looking for a professional to convert my Microsoft Excel project schedule into MS Project. The excel schedule has 675 rows, including headers. The purpose of this conversion is to enable better tracking of the project. 500 rows are the same 4 or 5 tasks with a different identifier and schedule start/end. Not entering any resources or predecessor or successor but need the columns available for me to add later. Looking to have a 2-5 hour turn around. Details: - The current Excel schedule is moderate, repetitive task structure - This is a one-time conversion, I don't need to update the schedule in MS Project regularly. Ideal Skills: - Proficiency in Microsoft Excel and MS Project. - Attention to detail to ensure all tasks and dependencies are accur...