Excel collection macro jobs

Dynamic Field Integration: Addition of customizable fields such as text inputs, date pickers, radio buttons, checkboxes, and select dropdowns within the admin panel. User Registration Form Customization: These dynamic fields will be incorporated into the user registration form, allowing for a more tailored data collection process. Admin Panel Search Functionality: Enhancements to the admin panel to include search functionality that utilizes the newly integrated fields. This will enable admins to search user data effectively based on the customized fields.

Need to extract data from website: , into an Excel file. Specifically name, discipline (medical practitioner, midwife, nurse, OT, physio, psychologist, podiatrist), location (incl suburb and postcode), initial registration date, registration expiry. There would be at least 100,000 rows of data. Only barrier, is this data is not able to be 'searched' efficiently. Individual names can be looked up. Or disciplines with a select number of names demonstrated...but I can't find a way to show ALL clinicians at once. Looking for a solution which can reliably pull all the names from the database.

...meaningful participation in all activities. 4. Facilitate land use mapping aligned with the Social Tenure Domain Model (STDM) and emphasizing the continuum of land rights approach. - Develop a comprehensive training program for enumerators on community engagement techniques, data collection methodologies, early conflict mitigation, and conflict mitigation triage to higher levels, and the use of the Social Tenure Domain Model (STDM) for informal land mapping. - Establish governance structures for data collection, including the formation of a steering committee comprising representatives from government agencies, community leaders, and relevant stakeholders to oversee the process and ensure accountability. - Define roles and responsibilities for data custodianship, in...

I'm looking for an Excel expert who can build a simple yet effective sheet for basic arithmetic calculations. Key requirements: - Perform basic arithmetic operations: The main functionality of the sheet should be to perform basic arithmetic operations such as addition and subtraction. - Real-time collaboration: The sheet should support real-time collaboration, where multiple users can edit the Excel file simultaneously. Ideal skills and experience: - Strong background in Excel: The freelancer should have a deep understanding of Excel and the ability to create formulas for basic arithmetic. - Real-time collaboration proficiency: Experience in implementing real-time collaboration features in Excel will be highly beneficial. - Attention to detai...

I'm looking for a reliable and experienced data entry specialist who can assist me with entering data from images. The images will be directly uploaded to a website, and I need the data to be transcribed into various formats like Excel sheets, Word documents, and for copywriting purposes. Ideal Skills and Experience: - Prior experience with data entry from images - Proficiency in Excel and Word - Copywriting experience is a plus The primary goal of the project is to create a comprehensive database in various formats, so the ability to accurately transcribe and organize data is crucial. The chosen freelancer should have keen attention to detail and a high level of accuracy.

I'm seeking a skilled data analyst who can help me with analyzing longitudinal data from online survey responses. Key Responsibilities: - Conducting latent growth modeling on the longitudinal data - Providing insights on the developmental patterns observed -...insights on the developmental patterns observed - Assisting in the interpretation of the results Ideal Skills and Experience: - Proficiency in handling and analyzing large datasets - Prior experience in the application of latent growth modeling - Strong background in longitudinal data analysis - Ability to effectively communicate complex statistical concepts - Familiarity with online survey data collection methods is a plus If you have the expertise and enthusiasm to dive into this project, I look forward to receiving...

...potential clients. - Convert conversations into promising leads. - Record conversational details into our database. REQUIRED SKILLS AND EXPERIENCE: - Exceptional persuasive communication skills. - Proven experience in lead generation. - Familiarity with the corporate events and conferences sector. - A resilient attitude to handle potential rejections and keep going. This role demands someone ready to excel in a fast-paced environment while showcasing dedication, autonomy and agility. Your ultimate aim will be to assist in the company's expansion through the successful generation of potential leads. This is an excellent opportunity for someone looking to apply and enhance their telecalling skills while significantly contributing to a growing company in the event managemen...

I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.

In search of a competent Excel specialist adept in Microsoft Access for multiple automation tasks. I need assistance with: - Macros Development: The main tasks include automation and creating tools. The proficient use of macros in daily operations is essential. - Report Generation: Specifically, the generation of technical proposal reports. Alongside this, the candidate should also be capable of automating the formula calculation process. Familiarity with financial, sales, and project status reports is an added advantage. - Tool Building: The capacity to build tools and other operations geared towards improving efficiency is crucial. Ideal skills include deep understanding of Excel functionalities, proficiency in Microsoft Access, extensive experience in automation via macr...

I need an Excel expert to build a tool that can automatically validate and correct any incorrect country codes in the file. Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in creati...

...manage MIS excel sheets pertaining to data analysis, sales forecasting, and expense tracking on a daily basis. Key tasks: - Establishing excel sheets to analyze a broad range of data - Constructing a sales forecasting model within the excel sheets - Regular tracking and management of expenses via the excel sheets Data sources would primarily be spreadsheets and databases. These excel sheets will require daily updates, enabling close monitoring of key metrics. Ideal skills: - Proficient in Microsoft Excel - Exemplary skills in data analysis and modeling - Good understanding of databases and how to extract data from them Experience in handling and managing sales and expense data is crucial for this project. The freelancer should be able ...

I'm in need of an expert equipped with Doc Clipper proficiency. I've got a collection of PDF files that require clipping. The skillset I'm seeking involves: - Extensive experience with Doc Clipper, specifically with clipping documents effectively. - Proven ability to handle PDF files in Doc Clipper. - Attention to detail to ensure no vital information is left out. Your task will solely focus on clipping PDF files. Apply if you can fulfil these needs with speed and efficiency.

I need an expert to migrate my products from an Excel file to my WooCommerce store. Key Requirements: - Migrate products from an Excel file to WooCommerce - Use attributes to define variations within a single product - Update existing product descriptions during the migration Ideal Skills and Experience: - Strong experience with WooCommerce and product migration - Proficiency in handling product variations using attributes - Attention to detail for updating and modifying product descriptions - Excellent knowledge of data import/export and product management on WooCommerce. - Ability to ensure a smooth and error-free migration process.

I'm looking for an experienced developer to create an inventory management app for both iOS and Android. Key Features: - Data collection - Real-time inventory updates - Barcode scanning - Sales and purchase tracking Ideal Skills: - Strong experience in app development, particularly for iOS and Android - Expertise in inventory management systems - Familiarity with integrating barcode scanning and real-time inventory updates - Previous experience in creating apps with data collection and sales/purchase tracking functionality Please provide examples of your previous work, especially if you have developed similar apps. A good understanding of UI/UX design principles will be highly valued.

I have a significant amount of text that needs to be typed into Excel quickly. The data is in a simple text format, no complex formatting required. Key requirements: - Proficient in Excel and typing - Attention to detail - Ability to work under tight deadlines The data is straightforward text and requires no specific formatting or analysis. The ideal freelancer will be skilled in data entry and be able to commit to a quick turnaround time.

As a client with emphasis on quality, I need the support of an experienced Python programmer who can take charge of the frontend aspect of my web development project. At the core of this project are the following requirements: - Full proficiency in Python as the main programming language for the task - Demonstrated experience in frontend web development using Python - Familiarity with the best practices in Python programming - Capacity to effectively communicate, provide regular updates and accept feedback The missing response for the third question won't be an issue — I am more interested in a Python programmer who can bring their own unique ideas and solutions. You are encouraged to showcase your creative problem-solving skills. Apply if you have the necessary skills and ...

I am seeking an Excel expert who can meticulously enter extensive amounts of text, numeric, and alphanumeric data into my spreadsheet. The task involves entering names, contact details, sales information, and inventory data. The size of the task is quite substantial, with up to 1,048,576 rows and 16,384 columns involved. The role requires a keen eye for detail, accuracy, and dedication. If you are efficient in Excel and possess experience with handling large data sets, your skills will be highly valuable for this project.

I need a reliable freelancer to assist with data input. Here's a breakdown of the project: - **Task:** Your primary job will be to input data from online forms into either Microsoft Excel or Google Sheets. - **Experience Required:** It is necessary for you to have prior experience with both of these tools. This will ensure you're able to work efficiently and accurately. - **Attention to Detail:** Given the nature of the task, it's crucial that you have excellent attention to detail. Even the smallest mistake can have significant implications. If you have the experience and skills mentioned above, I would love to hear from you.

...development expert to create a sophisticated WhatsApp bot. This bot will encompass key functionalities including automated responses, user data collection, and the facilitation of products or services sales. Key bot functionalities will include: - Responding to Frequently Asked Questions (FAQs). - Sending appointment reminders. - Advising on account statuses and dues paid. - Send chat to a operator - Receive info from Sugar Comunity Edition and Sap B1 and send to the customer The perfect candidate for this project will have: - Proven experience in chatbot development. - Deep understanding of WhatsApp API. - Experience with user data collection techniques. - An eye for detail and problem-solving skills. - Excellent communication skills. Please prov...

I'm looking for a skilled C++ developer to create a CAD software primarily focused on 3D modeling, compatible with Windows OS. Key Features: - Primarily 3D Modeling: The software should excel in 3D modeling capabilities, providing robust tools and functionalities for creating and editing 3D designs. - Compatibility: The software should be specifically designed to run seamlessly on Windows operating system, ensuring optimal performance and user experience. - File Format Support: The software should support importing and exporting of DWG files, for compatibility with AutoCAD files. Ideal Skills and Experience: - Proficient in C++: Extensive experience in C++ development, with a strong understanding of software architecture and design patterns. - CAD Software De...

...user authentication. Features: Community Forum and Social Groups: BuddyBoss Engage in discussions, share knowledge, and connect with industry peers. User Profiles: Customize profiles to highlight skills, interests, and business objectives. Networking Tools: Facilitate connections between entrepreneurs, investors, and consultants for mutual benefit. Resource Library: Access a curated collection of articles, tools, and resources to support business growth and development. Learning Management System (LMS): Learndash Offer educational resources, courses, and training materials to users. Event Management System: Event Management Host and manage events such as workshops, webinars, and networking sessions. Consultant Pool with Booking Management: Bookly Users can browse a...

Firstly, I want to know if what I am asking can actually be created in Excel 365 and used in Excel 365 Online. Please dont reply to this post without replying that it can or can't be done. If not, an alternative solution would be greatly appreciated. I need help creating an excel spreadsheet to track student progress in a course using 5 different options that also includes the date the option was selected. I can create the drop down list with the submission options, and apply color rules but I can not work out how to make the cell below change to the same color as the option selected and the date it was selected appear in the same cell. I need to include the date the option was selected selected and because you can't have two formulas in conditional form...

I am in need of a proficient Excel expert who can create a custom spreadsheet for me. This spreadsheet will help in calculating the overtime rates for my 6 employees on a monthly basis. Key Requirements: - The Excel sheet should calculate 3 types of overtime rates: standard (1x), holiday (2x), and evening/weekend (1.5x) - The formulae should be designed to take into account that an employee works a 40 hour basic week with typical overtime of between 1-20 hours. - The sheet should take into account that the employees are not paid for 30mins of travel time to and from work, the employees tell me what time they left home, arrived at site, left site and arrived home. - Standard hours are 08.30-17.00 Mon-Fri with a 0.5hour unpaid break and a 0.5 hour unpaid break if working over ...

More details: What type of data do you need to type into the Excel sheet? Text What is the source of the data that will be typed into the Excel sheet? PDF documents Will the data need any kind of formatting or should it be entered as is in the source document? Enter as is

I require a highly skilled professional with dexterity in MS Excel and Video Editing. Tasks will encompass: For MS Excel: - Comprehensive data analysis - Detailed spreadsheet formatting - Advanced formula creation for profound financial analysis. For Video Editing: - Apt video trimming - Expert color correction - Adding text and graphics creatively to videos. Ideal candidate will have proven ability in both fields, demonstrating both attention to detail in data management, and creativity in video enhancement. Proficiency in financial analysis and data visualization is a major plus.

...and control systems. This project involves the collection and monitoring of signal frequency data for analysis purposes. TASKS INCLUDE: - Developing and implementing a robust data acquisition system in LabVIEW to monitor signal frequency. - Designing and deploying control systems. - Regular monitoring and analysis of collected data. RECOMMENDED SKILLS: - Prior experience with LabVIEW programming is essential. - Expertise in the creation and usage of data acquisition and control systems. - Knowledgeable in signal frequency monitoring and analysis. - Solid background in automation and process control. My ideal candidate is detail-oriented with a strong understanding of LabVIEW, particularly in the context of signal frequency data collection and monitoring. It would be b...

I'm seeking an expert in MS Power Automate, well-versed in implementing unique flows using different AI Chat APIs - particularly Chat GPT API and Cohere AI API. The primary task is to create a power flow capable of running batches of prompts effectively. Key expectations are: - Expertis...implementing unique flows using different AI Chat APIs - particularly Chat GPT API and Cohere AI API. The primary task is to create a power flow capable of running batches of prompts effectively. Key expectations are: - Expertise in MS Power Automate, API integration, and AI-oriented applications. - Background in working with Chat GPT API and Cohere AI API. - Ability to deliver results on a web excel sheet. Please note that an understanding of additional AI Chat APIs is highly valuable fo...

I'm in need of a well-experienced web developer to craft an intuitive school fees management system. This system needs to be accessible both on web and mobile platforms, ensuring comprehensive accessibility and usability. Key Features: - The system should allow for ease in Student Registration. - There should be a function for efficient Fee Collection. - A robust Payment Tracking module to ensure the accurate monitoring of all school fee payments. Ideal Skills and Experience: - A demonstrable record of developing web systems, specifically with a focus on finance or fee tracking modules. - Experience in creating responsive designs that work seamlessly across both mobile and desktop environments. - Great understanding of user experience, ensuring the interface is user-friendly ...

The purpose of this project is to create a detailed, technical drawing using SolidWorks 2022. The emphasis of the project is documentation of plastic parts, both on a macro and micro-level. Key Requirements: - Able to generate technical drawings that include overall dimensions, shapes, specific features, and tolerances of plastic parts. - SolidWorks 2022 ONLY!! - Extensive experience and understanding in documentation of manufacturing processes and components - Expertise in rendering intricate details of plastic parts - Must be able to abide by all requirements for precision-driven, technical documentation - Detailed and clear communication The ideal candidate will have a background in mechanical engineering or a related field, as well as experience in creating detailed, techni...

I require a professional data scraper, ideally with experience in handling image retrieval. The task will involve sourcing and scraping image data from various undisclosed sources. The type of images to be scraped has not been specified, providing an open spectrum for data collection. However, previous experience dealing with diverse image types is highly beneficial. The deadline for this project has not been outlined, indicating flexibility on the completion date. Ideal Skills: - Expertise in data scraping - Strong experience handling image data - Ability to source from various platforms - Flexibility with time management.

I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.

We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. No testing of tutorials has to be done as the technical aspect of the articles is fine but they've been put together by non-native speakers. Starting with a paid trial.

I have several thousands PDFs that need to be read, interpreted and transcribed into a supplied spreadsheet format. It is important that you: 1) Have an existing team to help with a task that is estimated to take 2 weeks 2) Proficiency in PDF to Excel transcription 3) Ability to complete the task efficiently Applicants based in India only.

I have three separate Excel documents that need to be merged into a single, optimized sheet. In this new file, we should only pull specific data columns including Defect ID, Defect Type, Date Opened, Priority, Description, Reproduction Steps, Actual Result, Date Closed, Assigned To, and Comments. These columns must be combined while maintaining clarity and structure. After this task, a dynamic dashboard that displays the current state of the project is required. This dashboard should offer a variety of visualizations. We are particularly interested in bar charts, pie charts, and line charts to present the data in a clear and digestible manner. Ideal candidates for this project are those with: - In-depth expertise in Excel data management - Experience in creating dynamic das...

follow these steps: 1 Data Collection: Copy relevant text from writer work such as articles, essay or book into a document or text editor. 2 Cleanings and Preprocessing: Remove any unnecessary text such as header footers or non-essential information. You might also need to correct any formatting issues or errors introduce during copy 3 Text Analysis: Analyze the copied text for various metric such as word frequency readability score sentiment analysis or topic modeling. This can provide insight into the writing style tone and themes present in the text. 4 Statistical Analysis: Calculate statistical metrics such as word count average sentence length or vocabulary richness to gain deeper insights into the writing style and complexity 5 Visualization: Create visualizations...

I'm in need of a proficient database specialist to manually collect email addresses and phone numbers, and compile them into an efficient and reliable database system. The leads to be collected are specifically from the Social Media industry. Ideal Skills and Experience: - Proven experience in data collection and management. - Exceptional research abilities, particular in the social media landscape. - Ability to use manual collection methods efficiently and effectively. - Knowledge and understanding of database management and lead generation. - Accuracy and attention to detail in dealing with phone numbers and email addresses. Roles: - Locating and collecting required data from specific direct websites. - Organizing the data into a systematic database. - Ensuring t...

Hi Jay - been a long time since we interacted. But I want to let you know that we still use the excel file that you created for us way back in 2017. Its been our main stay. I have another Excel file which requires formula to effect colour change in cells under various conditions. Knowing you, it might be just a 10 or 15minute assignment. Would you be able to help. Thanks. Vish

We are excited to announce a new project on collecting YouTube video links for various languages listed below. Weme Gbe Ditammari Gun Phende Songe Bangala Dawro Southern Dagaare Tumbuka Yucateco Southeastern Puebla Nahuatl Sindhi Melpa Ifè Hawai'i Creole English We are looking for participants who are proficient in any of the languages listed above and are interested in assisting with our collection project. If you're interested in participating, please reach out to us and indicate which languages you are skilled in.

I am looking for a skillful freelancer who can assist me in converting an Excel spreadsheet into a daily calendar schedule like this: Key Requirements: - You must have a firm understanding of Excel and calendar scheduling. - You must be capable of adjusting the Excel data to fit into a daily calendar layout. All data will be uploaded by an excel spreadsheet or .csv file

...specifically GST and TDS filing for my 11-20 clients. - Responsibilities: - Filing GST returns - Filing TDS returns - Periodic accounting in tally for selected clients - Income tax return filing - Coordinating with clients on monthly basis for the documents The majority of my clients have less than 70 transactions per month and I use tally software, thus a good grasp of tally software and excel is necessary to handle the above tasks. - Skills and Experience: - Gst return filing experience - Proficient in tally software - Experience with handling multiple clients simultaneously - Knowledge of GST and TDS filing systems appeciated. This is an ongoing project and I am looking for a dedicated and reliable partner in this area as this will be an ongoing and lon...

I'm in need of a skilled software developer to create a custom appraisal system for my textile company. The software should be designed strictly for Windows OS. Key Features: - The primary function of the software should be an assessment tool that can be used for a variety of purposes, such as employee performance tracking, feedback collection, and goal setting and tracking. - The assessment tool should be designed with a mix of multiple choice questions and open text input. Ideal Skills and Experience: - Proficiency in Windows software development. - Experience in creating assessment tools within the software. - Knowledge in developing software for the textile industry would be a plus.

Join our dynamic team as a Real Estate Agent where communication skills meet unwavering motivation and a drive for success! We're seeking experienced individuals with a knack for leadership, a commitment to ethi...redefine excellence in real estate! - Uploading photos and descriptions of properties - Sorting listings by location and price - Providing regular updates on availability - Scheduling site visits for potential customers - Providing customer support to potential buyers For the lead generation aspect, you'll be targeting first-time home buyers, investors, rental property seekers, and end users. To excel in this role, you should have experience in real estate sales and understanding of different audience segments. Excellent communication skills and a proactive app...

I am in need of an Excel professional with an intermediate level of proficiency to assist with various tasks on my project. The specifics of these tasks are open for discussion, therefore a degree of flexibility and adaptability is required. You should ideally have proven experience with data analysis, spreadsheet automation, and formula creation despite the fact these haven't been specified outright. An overview of your past relevant projects included in your bid would be highly appreciated. Convince me with your technical prowess and past success stories.

...hands-on research, which means you'll be conducting in-person visits to retail outlets and other relevant venues. So, local knowledge and a good grasp of the Bahrain's retail landscape are necessary. I need insights, not just data, so your ability to interpret and analyse the information you find is critical. Deliverables: Comprehensive report for each country with all the requested information. Excel sheet or Google Sheets document with detailed data. Duration: The project is expected to be completed within 1 week. Please propose a timeline for this project. How long do you estimate it would take to compete the entire project...

I need a proficient individual to assist with data entry into an Excel sheet. The data to be entered is purely textual, derived from printed documents and requires no complicated formatting. Key Responsibilities: - Transfer text data from printed documents to Excel - Ensure accuracy of data entered - Follow simple formatting guidelines Ideal Skills and Experience: - Proficiency in Microsoft Excel - Attention to detail - Experience with data entry - Fast typing speed - Experience working with printed documents This project is ideal for freelancers with a knack for accuracy and speed in data entry, particularly in Microsoft Excel. It involves simple one-word entries and familiarity with printed documents is advantageous.

Elevate your career with us, a premier STR (Short-Term Rental) management firm renowned for its exceptional portfolio of high-end rental properties. We invite accomplished sales executives to join us in our mission to expand and enhance our distinguished collection. This role has a base of $500 p/m + uncapped commision, offering substantial financial rewards aligned with your success. Commission Structure: Initial Engagement: Secure $750 on each $5000 deposit per onboarded property - 15% commission Enhanced Earnings on Balance after the $5000 payment from the prospects: 1BR - $15,000: Receive 12% commission, totalling $1,800. 2BR - $20,000: Receive 15% commission, totalling $3,000. 3BR - $25,000: Receive 18% commission, totalling $4,500. Performance Incentives: Quar...

I am in need of an expert in Excel data entry. The objective of this project is specifically for data entry purposes. The task involves keying in customer information into Excel. Familiarity with this type of data is a big bonus. Attention to detail, fast typing speed, and meticulousness are skills that are necessary to successfully complete the task. Additionally, extraction of specific information will be required. More specifically, identifying trends within a given period from the input data. Therefore, a keen eye for detail and an analytical mind are crucial for this job. In conclusion, if you have experience handling customer information, know your way around Excel, have a knack for finding patterns among data, and can type fast, I am looking forward to work...

We have an excel with macro script which converts a PDF (FFE 1a, 2a, 3a) to EXCEL (FFE) that allows us to be able to read all information we need. Unfortunately it is not working due to some changes in PDF (FFE 1b, 2b, 3b) as an extra page in the front has been added, so we are looking to hire someone that can fix this issue, so that excel can ignore this extra page.

...received use this as a trigger to check if a new email is in another outlook 365 folder, if there is, save the attached excel file as a csv and rename the csv file the date of the email in YYYYMMDD format and save to a folder in onedrive for business. On successful completion send an email confirming success. >If there is no new email in the other outlook 365 folder, email our info@ email address notifying that it is not present. Repeat the checking process 2 days later until successful Flow 2: If a new email is received use this as a trigger to check if a new email is in another outlook 365 folder, if there is, unzip the attachment using a password, save the attached excel file as a csv and rename the csv files the date of the email in YYYYMMDD format and save to a f...

I am working on a Market Research Project, for which I looking for someone living in Mexico. And are open to recording a video of 5 minutes or more in length each which would be recorded shopping IN-STORE (videos can be recorded using their smartphones). One shopper needs to record 2 unique videos. Also, if you can have your friends/family record videos for you then you can earn more with it. For more details please reach out to me.