Write data excel database macro jobs
Repost of the following project: https://www.freelancer.com/projects/excel/transform-text-evaluable-format. The required files will be exchanged after nomination.
Calling all digital nomads: Seize the opportunity to delve into th...work experience in Link Building (Q&As, Forum Submissions, Directory Submissions, Article Submissions, Image Submissions, Social Bookmarking etc.) Excellent written and verbal communication skills in English Language. Strong organizational skills and attention to detail. Willingness to learn and take on new challenges. Should be tech-savvy. Sound knowledge of Google Sheets, Google Docs & Microsoft Excel would be an added advantage. Benefits: Remote, providing flexibility for a comfortable work environment. Gain hands-on experience in SEO and Digital Marketing. Flexible working hours to accommodate academic commitments. Competitive rates based on qualifications and experience. Marketing background will be...
...language, coupled with intelligence, and a proactive work ethic. A pivotal aspect of our requirements is finding someone marked by complete adaptability to engage in diverse and innovative tasks, where a rapid learning ability is a crucial asset. The range of responsibilities includes website evaluations, product comparisons, the utilization of our proprietary software, and task execution within Excel. The expected working hours are 8 hours per day, and compensation ranges from $150 to $250/month, contingent upon productivity levels. The nature of the work is dynamic, requiring flexibility and a willingness to tackle new challenges every week. For instance, this week may involve comparing prices for the following week, scrutinizing details of upcoming products, discovering new p...
I am in need of an inventory reconciliation template, specifically tailored for Excel, to effectively keep track of my products throughout the manufacturing process. Key Components Needed: - Ability to track the Product ID, quantities on hand, and monitor progress throughout manufacturing stages. - A system that marks milestone stages such as raw material sourcing, production progression, quality control measures, and finished goods. Ideal Skills for the Job: - Freelancers with strong experience in Excel-based inventory management systems. - Keen attention to detail. - Knowledge of manufacturing processes.
I'm in need of a capable developer to create an encompassing registration form that collects a wide variety of data from clients. The categories required for this form include name, contact details, date of birth, gender, address, occupation, vehicle details, and next of kin. Additionally, I'd like an ITC and bank verification feature integrated via API. I require the data to be stored in a MySQL database system for easy access and management. When bidding for this project, freelancers must provide detailed project proposals, outlining how they intend to meet these specifics and showcasing their proven experience in handling similar projects. IDEAL SKILLS AND EXPERIENCE: - Proficiency in MySQL. - Experience in developing registration forms. - Familiarity wi...
In need of a fast, accurate, and reliable professional to assist with spreadsheet data entry and transcription from written documents. All tasks will be conducted using Microsoft Excel. Key Responsibilities: - Spreadsheet data entry - Data transcription from written documents Ideal candidate should have: - Proficiency in Microsoft Excel - Experience with data transcription from written documents - Meticulous attention to detail - Excellent typing speed with high accuracy rate
I'm looking for an experienced ESP-IDF firmware developer who can help enhance the functionality of my ESP32 IoT device. Task: Port the Firebase library for Arduino for ESP-IDF V5.1.2 in C language. Library Link: The library should support only the Realtime database functionality only. This role is ideal for someone with experience in ESP-IDF, ESP32, and IoT protocols, specifically Firebase’s Realtime Database Library. Dedicated, meticulous individuals with a knack for problem-solving are most desired for this project.
I'm in need of a skilled PHP developer who can add new modules to our existing web portal. We are focusing currently on the Admin with RBAC module only. The tasks would include: - Integration of modules related to Mutual Funds, Fixed Deposits (FD), and National Pension Scheme (NPS). - Migrating existing data from excel to Database - Unfortunately, the specific features needed for these modules weren't defined. Hence, I encourage freelancers to ask for more details if necessary. Candidates must have: - Expertise in integrating complex modules into existing systems. - Proficiency in PHP. - Strong understanding of the financial services industry. A successful application should contain: - A comprehensive project proposal detailing how you would tackle thi...
I'm seeking an expert in Excel for a data entry project. The primary task involves inputting numeric data in a specific column structure. The project will require: - Comprehensive knowledge of Excel - Experience with numeric data entry - Attention to detail, ensuring accuracy - Ability to follow the specified structure - Proven ability to meet deadlines Please only bid if you meet these prerequisites and can commit to delivering high-quality work.
I'm in need of an experienced Excel wizard who can handle tasks involving data analysis and comparison in the most effective way. The aim is to analyze basic tabular customer data, identify trends, assess performance, and make data-driven decisions. Skills and Experience: - Excel expert who has a proven track record of manipulating and analyzing different forms of data. - A strong understanding of basic tabular data structure. - Ability to visualize and communicate complex ideas effectively.
I have a list of 1125 products and i want to list them into 1 product using the bulk upload excel. Project should be quite straightforward for excel experts
I'm looking for a freelancer with strong skills and experience in Corporate Finance, specifically at an intermediate level. This project will focus primarily on analyzing Balance Sheets and conducting ratio comparisons of two specific companies based in India. To excel in this job, you should have: - Excellent Financial Modeling skills - Strong capabilities in Corporate Finance concepts - Deep understanding of India's business environment and its financial regulations - Amazing attention to detail and precision in financial analysis, with added emphasis on Balance Sheets and business ratio comparisons. This project offers a chance to apply and expand your expertise in Corporate Finance within an Indian context.
1. Cost of works ( from backup files) 2. Project claims all PC (from PC files) 3. schedule of documents 4. schedule of payments
I'm in need of a service that uses Excel to send scheduled emails to an assorted list, ideally with a frequency of every 5 minutes. Details: - The operating system I'm using is Windows. - The email service that the application would need to interface with is Outlook. - The application should ideally be able to handle the CSV Excel file format for the email list. Ideal Skills and Experience: The ideal candidate for this project would have experience with Excel, as well as know how to create an application that interfaces with Outlook's email system. Familiarity with Windows is also crucial. Experience with email schedules, and CSV file handling is a big plus.
I require a professional who can automate a data extraction process from a formatted PDF file and fill an Excel template that will be provided. The data includes names, product titles, order details etc.. The extracted data must be structured in separate rows and columns as per the Excel file.
Hello Project Description: I am in search of a skilled data entry specialist who can assist me with various data entry tasks. The primary responsibility will be to accurately input data from various sources into spreadsheets or databases. Key Responsibilities: - Inputting data accurately and efficiently into spreadsheets or databases. - Verifying the accuracy of data input to ensure high-quality results. - Organizing and maintaining data in a structured manner for easy retrieval and analysis. - Completing assigned tasks within specified deadlines. Skills Required: - Proficiency in data entry techniques and software, including Microsoft Excel and Google Sheets. - Excellent attention to detail and accuracy in data entry. - ...
As someone desiring the production of a high-quality academic paper, I am looking for a proficient and experienced typist. This task involves creating a document pertaining to the field of Business Studies. The ideal candid...pertaining to the field of Business Studies. The ideal candidate will: - Have extensive experience in document creation, particularly academic papers. - Possess outstanding typing skills, ensuring accuracy and speed. - Have a comprehensive understanding, or a strong interest in Business Studies, as the paper will delve deeply into this domain. This project is a great opportunity for those who excel in typewriting and have a flair for academic document creation, particularly in the business field. Your expertise will drive the successful completion of thi...
I am seeking an Excel expert, proficient in advanced formula and functions like Index, Match, Vlookups, and Pivot Tables. Here's what I need help with: - Use advanced functions to analyze large datasets - Utilize lookups and other functions to find specific values and match corresponding data - Leverage your expertise in Pivot Tables and other functions to create dynamic reports and dashboards - Automate these processes as much as possible The overall objective is to thoroughly interpret and present data in a intelligible way. Prior experience with complex data analysis and Excel-based report generation is a plus.
I'm in need of a dedicated team, proficient in both Excel and PowerPoint. This job's split into two functions 1) financial data documents which focuses on business valuation using an existing excel template. ( estimate 30 minutes per document) 2)Business Summary Documents in PowerPoint est 60 minutes per document. The perfect team should: - Be adept in financial data, specifically in Excel - Accuracy and reliability is essential - Ensure Excel proficiency extends to business valuation calculations - Preparing clear and concise PowerPoint documents based on customer input and a standard powerpoint structure, involving some basic data research and collection/collation. We are looking for a company that can handle a larger volum...
I need a seasoned AI expert who can design a user-friendly script for searching and filtering a wide database of RFPs and grants. The script should be optimized to provide results closely aligned with my business profile. Key Features: - Automatic search and filtering mechanism based on specific criteria - Easy-to-navigate interface for convenient use Search Criteria: - The script should focus on keyword and industry when filtering the database. It should be intelligent enough to recognize those significant matches that most align with my business. Candidate Profile: - Ideally, you'll have experience in developing AI-based search scripts. You should understand how to create a product that is both effective in its search capabilities and also easily manageable. Please...
I am in need of 400 top-quality medical dentistry leads specifically from Madrid, Spain. The project factor includes: - Contact Names - Physical Addresses These should be appropriately compiled in an Excel spreadsheet. Successful applicants should include examples of past work related to lead generation to be considered for this project. Exceptional attention to detail and accuracy is extremely critical for this task. Ideal freelancers should have proficiency in Excel and previous experience in the medical or dentistry industry would be a huge plus. Accuracy, punctuality, and confidentiality of the information collected are of paramount importance to this project.
I require a meticulous and diligent professional to handle a large volume of text data entry to an Excel spreadsheet. The project encompasses entering more than 4000 text entries/contacts accurately. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Fast typing speed with a keen eye for detail - Demonstrated experience in large scale data entry . - Fast copy and paste skills Key Responsibilities: - Input more than 4000 text data entries/contacts into Excel - Sustain high levels of accuracy throughout the project - Manages and handles data efficiently within the agreed timescale. - Copy paste contacts - Name, Phone number, company name from a website to excel file.
...create a search tool for my series of Excel spreadsheets. Each spreadsheet stores client records, which consist of: - Name and contact details - Purchase history - Piano Type - Method used to move the piano The search tool should be capable of displaying all these details about each client record. The tool should be designed in a way that it matches any search criteria inserted. This means if any criteria matches with the client's information, that entire record should be displayed. Another key feature is the ranking of the search results. The tool should organize the results alphabetically by the client's name. The ideal freelancer for this job should have a sound understanding of Excel, search algorithms, and UI design. Experience in developing Excel...
I am looking for a skilled freelancer with profound expertise in Excel and SQL, particularly on the Mac platform. Key tasks include: - Importation of numeric data from an Excel workbook into Microsoft Azure Data Studio using Python - The data is arranged over multiple worksheets, all of which are interrelated. - Apart from the primary data importation job, the freelancer will be tasked with devising an efficient method of performing this task on a daily basis. Ideal Skills: - Strong Excel and SQL skills with experience in data migration. - Proven ability to handle related datasets spread over multiple worksheets. - Experience with automation, to maintain daily import tasks. - Familiarity with Mac operating systems. Your bid s...
I am looking for an experienced freelancer with proficiency in excel to develop a streamlined, user-friendly excel sheet for my company. The ideal candidate will be deeply knowledgeable in creating custom formulas, and have tangible experience working with budgeting and accounting. Key requirements: 1. Data Tracking: The excel sheet should be designed to allow for an efficient tracking of Income, Expenses, Sales and Inventory. 2. Formulas: The sheet should incorporate specific formulas for the calculation of Profit Margins, Tax and Budget tracking. 3. Design: A simple and clean layout is expected. The sheet should be easy to navigate, without diverging into unnecessary complexity. Your understanding of financial data and ability to present it ...
I'm seeking multiple part-time staff members for a chemical industry exhibition. I require individuals who can excel in the following tasks: - Demonstrating product features - Assisting with customer inquiries - Managing booth logistics These roles are required on an hourly basis, making flexibility in availability advantageous. Ideally, prospective candidates will have previous experience in exhibition assistance or related fields within the chemical industry. Exceptional public speaking skills, customer service acumen, and organizational abilities will set successful applicants apart in this dynamic, client-facing role.
1) perform full backup for oracle database. 2) oracle database 11g/12 migrate to latest MySQL Enterprise DB. 3) migrate oracle database stored procedure, function, object, data type to MySQL, provide report of the changes after migrate. 4) configure MySQL replication from production to dr site.
I'm seeking someone with a strong background in Excel and VBA programming to automate report generation. Details: - This project entails using VBA/macro to automate financial report generation in Excel. - The reports will be created from financial data with the primary goal to simplify the overall reporting process. - The financial data involved may include expense records, costings, revenue data, among others. Desired Skills & Experience: - Strong Excel VBA programming skills - Prior experience in automation of financial reporting - Proficiency in data processing and analysis is a plus. - Familiarity with financial data and terminology - High attention to detail with a proactive approach towards problem-solving T...
...capable of designing and developing a new database for our project. There is currently no existing database in place. The ideal candidate for this role should be able to: - Design a robust, secure and user-friendly Access database from scratch. - Effectively analyze data and ensure error-free data processing. - Integrate the database with other software to provide seamless workflows. - Generate data reports as needed. After the database has been developed, I will require a written manual detailing its features, usage guidelines and troubleshooting advice. This manual must be clearly written, easy to understand and comprehensive to enable our staff effectively utilize the database. Requirements: - Proven experience in Mi...
...work with a seasoned professional who excels in extracting data from multiple websites, specifically Website A, Website B and Website C. Your Major Responsibilities Will Include: - Performing deep web scraping for sales data. - Compiling the data in an Excel file. - Executing basic data cleaning and minor organization tasks. The Specifics: - The specific data I'm interested in are the names listed in specific directories: Directory A, Directory B and Directory C from each of the mentioned websites. Added Task: - An additional task involves collecting email addresses found on the linked pages of these directories. Ideal Skills and Experience: - Extensive experience with web parsing and data extraction. - Proficiency with Excel...
...a highly organised and detail-oriented accountant to handle bookkeeping tasks for my company. This predominantly includes maintaining our financial records in Excel. Roles and Responsibilities: - Maintaining our financial transactions. We are a small company with less than 50 transactions per month. The accountant will be responsible for maintaining these records and updating them accurately in Excel. Key skills and Experience: - Proficient in Excel: We currently use Excel for our bookkeeping tasks, so we need someone who is experienced in managing finances in Excel. - Experience with bookkeeping: I'm not looking for just an Excel whiz, but someone who truly understands bookkeeping and can organise our finances effectively. - Attention t...
I need a client facing template to show the following metrics for Google Ads branded with , spot to put clients name and logo. Metrics for Google Ads I need to show - Cost Per Click, Total Cost, Cost Per Conversion and Conversion Rate SEO - Conversions, session, users, top pages etc and keyword ranks
...looking for a proficient back-end developer to integrate a NoSQL database into my system. - Functionality: The tasks revolve mainly around database integration, meaning that the ideal candidate must possess extensive knowledge and background in Node.js and NoSQL databases. Prior experience in using MongoDB or Cassandra will be advantageous. - Operations: The integration will involve a mix of basic CRUD operations and complex queries. Your role is to ensure both of these operations are executed seamlessly and efficiently. The right candidate must have the ability to develop and implement complex queries with ease and accuracy. I look forward to connecting with back-end developers with substantial experience in Node.js and database manipulation. Please ensure your...
I require a well-structured Excel spreadsheet for comprehensively tracking a school fundraiser. The requirements are as follows: - Track the number of participants involved in the fundraiser. - Tabulate the amount of money raised in each fundraising event. - Generate separate pages for each grade contributing towards the fundraiser. - Provide both individual student and total grade contribution summaries on each of the aforementioned grade pages. - Sum up all individual amounts raised to compute the final tally. - Finally, a page dedicated to showing the final tally, the amount owed, along with the collective amount raised. - Selling 5 items to keep track of totals for each grade & a final total Ideal Skills: - Advanced knowledge of Excel to create a user-friendly, c...
I need a skilled developer to create a file explorer for Windows that's not only more advanced aesthetically, but also significantly faster and easier to use than Microsoft's current version. Key improvements I'm looking for include: - Increased speed to locate files - Enhanced aesthetic design - Superior navigation I mainly work with Document formats (such as Word, Excel, and PDF and also DWG, DXF) and Image formats (like JPG, PNG). Therefore, these file types should be prioritized in the design and functionality. Ideal freelancers for this project should have extensive knowledge in software development, a keen eye for modern aesthetics, and a deep understanding of end-user experiences. Prior experience in creating file explorers or similar applications is high...
I'm looking for a talented and creative writer who can craft a short story for a modern love theme set in a vibrant city environment. The story genre needs to be comedy, bringing together wit, humor, and love in a contemporary city ba...and dialogues that are realistic and relatable. • Length: This will be a short story. Your skills should include being able to create impactful and engaging tales within limited word counts. • Setting: The story will take place in a city. Experience in creating rich urban settings, with a keen eye for details of city life, is necessary. • Ideal Candidate: This gig is perfect for writers who excel in the comedic genre, can encapsulate the nuances of modern love, and can vividly paint a city landscape. A portfolio of similar work...
...help me export Instagram followers from a public account to an Excel file. The data needed is solely the usernames of each follower, no additional information required. The ideal candidate for this job is tech-savvy, detail-oriented, and comfortable with data extraction and Excel. Experience with social media APIs, especially Instagram, and Excel data handling will be crucial for successfully completing this project. Key Responsibilities: - Extract usernames from a public Instagram account - Import the data to an Excel file - Ensure accurate capture of information No particular organization or formatting in the Excel file is needed. Let's keep this straightforward and simple. Your primary goal is efficiency and a...
details will be share on chat minimal budget will be prioritise max time few hours it's a small job
I have a predefined dataset in an Excel file. The data features the names of different regions or cities, which are neatly organized with each location listed in separate columns. The task is to fill out the missing data for the distance between these locations or cities. Ideal Skills and Experience: - Proficient in Excel - Experience in data entry - Excellent attention to detail - Ability to work accurately and efficiently - Knowledge about using online distance estimator tools would be favorable The successful freelancer should also demonstrate the ability to source and apply the most accurate distance data where needed.
We are looking for someone to fix following issue which is coming every 3 hours. Access denied for user 'root'@'localhost' (using password: YES)
...someone experienced in Excel transcription to create a spreadsheet for me from a scanned PDF contact list. The critical points here are: Requested Skills: - Excel transcription - Data accuracy and organization Project Details: - Please transcribe the non-crossed out contacts data from the scanned PDF (20240305_214525 ) into a digital spreadsheet.* - Follow the column and header structure found in the file - The final spreadsheet must be organized according to the "Customer Name" column. - The final file format should be in Microsoft Excel. *Some contacts have data partially crossed-out. These contacts should be in the final spreadsheet, just without the crossed-out portions. Lastly, ensure that no fully crossed-out data is ...
I'm in need of an Excel Expert proficient in the French language. The task revolves around a large product database for my existing business. The database, currently in CSV format, contains approximately 3534 product titles that need to be matched with their correct categories. Additionally, product descriptions need to be created and added for each title. The product titles also need minimization, ensuring they are concise whilst retaining essential information. The ideal freelancer should possess: - Proficiency in Excel - Good command of French language - Experience with data matching and cataloging - Ability to work with CSV files - Skills in writing succinct, meaningful descriptions Please make sure your proposal accurately portrays your skil...
...for use include: - PDFs - PNG images - Excel spreadsheets - CSV files The project will involve the integration of more than 20 different plots, photos, and tables, with each possibly requiring some minimal editing for best fit and presentation. The ideal freelancer for this project should have: - Proficiency in MS Word - Experience in basic photo and graphic editing - Good understanding of Excel and CSV file manipulation - Ability to ensure all elements are accurately and aesthetically placed within the final report The task won't require heavy editing, but knowledge of how to carry out minor enhancements to optimize visual presentation in the Word template is crucial. Attention to detail will play a key role in this task. Need create a macro to crop and...
I am working on an Excel sheet that performs operations for structuring and analyzing data. However, it's not providing accurate results which is hindering my data analysis. Key Requirements: - Revise existing formulas to correct data return issues. - Make the sheet versatile enough to accurately analyze different sets of data that I will input. Skillset: - Proficiency in Excel and its data analysis functionalities - Strong understanding of data structure - Ability to debug and correct Excel formulas
...experienced PHP Developer, well-versed in MySQL, for creating a script capable of updating around ten tables in a database. The PHP script must not just update these records but also conduct an advanced level of validation checks to ensure data correctness and integrity before the update. This includes checking if fields are not empty, verifying data types/integrity, and using complex procedures to confirm absolute accuracy in the updated information. Ideal skills for the job would comprise: - Proficiency in PHP & MySQL - Solid knowledge of Database Update procedures - Experience with advanced data validation and integrity checks. A PHP script must be able to update a MySQL database. The system must read the existing tables and check if...
I'm looking for an experienced Tableau expert to build us daily reports from CSV/Excel files. This will include: - Creating Sales reports - Setting up Financial reports - Designing Marketing reports We are seeking candidates who have a strong background in data analysis, specifically having worked with CSV/Excel files for data sourcing. Key skills and aptitudes: - Extensive knowledge of Tableau and its functionalities - Proficiency with CSV/Excel files - The ability to keep the reports updated daily - Strong attention to detail - Prior experience in creating financial, marketing and sales reports.
I'm looking for a talented Python developer with a solid understanding of Django and MySQL. The purpose of this project is to develop a robust database management system. These are some key features that the application should have: - Integration with Django's ORM (Object-Relational Mapping) library. - Custom SQL query functionality for advanced data operations. - A system for data backup and recovery to prevent data loss. You should have a proven track record with both Django and MySQL, and be able to show examples of similar projects you have worked on. A strong understanding of database design and management is a must.
Excel web query to extract data into Excel spreadsheet from also extract Live odds comparison table from Currently, these 2 tables are not showing up using Excel web query
I have project need to knkw if it's can be done If you can start now, start your bid with NOW
