Using excel sheet database jobs
As I'm launching a new business, I need your expertise in developing VBA scripts and macros in Excel to help me automate several repetitive tasks. I am looking for an expert in MS Excel to develop a special MS Excel Macro which can be integrated to MS Excel environment, in order to generate an output file. This tool will allow us to transform a specific Input file into another Output file. • Input: catalog_product_option-YYYY-MM-DD • Output: The 2 files are attached, with a color mapping to recognize the columns in scope. In summary, we need to be capable to issue an export file in a specific format (see attached picture “”): • Specific Orders of the column (Green) • Suppress the duplicated values for some line items, o...
I'm in need of a proficient Excel specialist who can help create a solution for selecting rows to display in Excel with a total at the bottom. Requirements: - Proficiency in Excel and experience with creating VBA or macros - Ability to display both numerical and text data - Ensure compatibility with Windows Operating System Please note, this task calls for a clean, simple solution. Your proposal should detail your previous work with similar Excel functions.
I'm looking for an experienced freelancer who can efficiently and skillfully create an email list from LinkedIn with half a million entries, organized in Excel. Key requirements: - Resourcefulness: While I didn't specify whether you should use automation, manual searches, or delegate this task to a team, I expect you to use the most proficient method. - Diligence: Each email must be added carefully to avoid repetition or inaccuracies. - Technical proficiency: All data must be arranged in an Excel spreadsheet – extensive experience with Excel is therefore needed. Applicants should impress me with the depth and clarity of their project proposals. Extensive experience in similar tasks is a strong advantage. While I did not specify the purpose of this...
I am having several issues with my Wordpress websit, Elementor-based website hosted on Hostinger. The problems include slow loading time, high page size, and slow server response time, which I believe are primarily due to the presence of high-quality images, integrated videos, and complex web animations on my site. However, I'm unsure if these are the only elements causing the issue. The current loading time of the website is more than 4 seconds, significantly slower than ideal. I am seeking a freelancer who can work on these issues and enhance the performance to make my website load faster. The ideal candidate should have proven experience in: - Wordpress - Elementor - Web Optimization - Understanding of high-quality images and video optimization - Knowledge of reducing page size ...
I'm looking to hire a web developer and designer proficient in building an aesthetically pleasing and functional character-storage site that is equally immersive. Key Features: - A platform for managing and displaying detailed character profiles. - Capabilities to categorize data such as names, descriptions, stats, abilities, and corresponding images or artwork. - An integrated search feature to filter out specific character types. Artwork Requirements: - The site should be able to host a variety of artwork formats like character illustrations, and digital paintings. - The developer should implement features for GIF support, to showcase more dynamic character pieces. The ideal candidate has previous experience designing and developing similar sites, a keen eye for aesthetics, exce...
I'm in need of a data handling professional. Gig is $36 Max. I have a large excel file that houses data from multiple sources but the columns are misaligned. I want it to be organized to Name, email, city, state, phone number, additional info columns. Your task will be to: - Correctly align the columns - Merge any duplicate records Ideal freelancer would have: - A strong background in Excel - Experience in data cleaning - Proven track record of handling large datasets - A keen eye for detail to spot and fix misalignments
Looking for an experienced Excel professional who can help debug my university project. I'm currently grappling with project-related issues and need rapid assistance. Expectations include: - Rectifying the project - Delicate understanding of Excel debugging - Fast turnaround time - as soon as possible Ideal candidate should have prior experience with Excel debugging, problem-solving ability, and methodology to correct projects. Knowledge about appropriate data structures will be appreciated. Being a student's project, confidentiality will be highly appreciated.
I'm looking for a skilled Python developer to combine around 1000 XLSX files into a single one. I need this new file to contain all the data from the original files. The Excel files have a structure where each file contains data for a different entity. The end goal is to have all this data centralized into a single document for easier management and analysis. The successful freelancer for this project should have: - Proficiency in Python, particularly in working with Excel files. - Experience in data manipulation and consolidation. - Strong attention to detail to ensure that all data is accurately captured and combined without loss. Please provide examples of your previous work in Python, particularly relating to data consolidation if possible. This will help me asse...
I have a Word document that requires a few tasks to make it more professional and accessible. - **Photo Conversion**: The photos within the document need to be converted into both tab...an intermediate level of detail. This means that the translation should accurately capture the content and tone of the original document. - **Formatting**: The document should be formatted in a standard business format. This means that the layout, fonts, and styles should be consistent and professional throughout the document. I am looking for a freelancer who has: - Proficiency in Word and Excel - Translation experience, preferable with a business background - Strong attention to detail - Excellent communication skills Please provide a quote and an estimated time for completing this project. ...
I'm in need of an efficient, digital solution to streamline our insurance quoting processes as our current method is manual. Key Features: - Quot...different quotes for the customer's selected coverage. Access: I am open to ideas for the program's accessibility. It could be a web-based platform, a desktop application, or even an Excel program. The primary goal is to transition from manual quoting to a more efficient, digital process. Ideal Freelancer: - Experience: A strong background in insurance software development and a proven track record in creating similar programs. - Innovative: Capable of suggesting and implementing creative solutions for an optimal quoting experience. - Detail-Oriented: Attentive to accuracy and thoroughness in the development of the ...
Hi Milan S., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
I have a very simple web page that has a scrollable table with data. I can't copy and paste the data as a whole into excel, it's requiring that I copy each entry one by one. I'm looking for someone that can help design a simple program to automatically save all data as a csv file. Thanks
I am looking for an experienced Data Entry Operator for a specific task. The main pur...Data Entry Operator for a specific task. The main purpose of this task is to help organize our customer database. Apart from entering data, the operator should ensure that sensitive customer details are properly handled with care and confidentiality. To apply: * Present a detailed project proposal that shows you have fully understood the requirements of the job. Ideal Skills and Experiences: * Proven data entry work experience. * Sensitive to data privacy issues. * Strong attention to detail. * Proficient with Microsoft Office and data programs. Please note: data migration or data analysis is not needed for this role. The focus is on data organization. Let’s make our customer da...
I need a data entry operator proficient with spreadsheet data entry. The work involves keying in data from scanned PDF documents into a spreadsheet. Key Requirements: - Proficiency in spreadsheet data entry - Comfortable working with PDF documents Ideal Skills: - Experience in data entry - Proficiency in spreadsheet software, particularly Excel The scanned documents will be provided to you in PDF format. I will provide clear guidelines on formatting and data entry requirements. The accuracy and efficiency in data entry is crucial for this job.
I'm seeking a professional to assist in preparing detailed personal financial statements, specifically a Balance Sheet and an Income Statement. Key Requirements: - Detailed Presentation: I need an itemized list of my assets, liabilities, and income sources. - High Accuracy: Precision is crucial for this task, as the data will be used for personal financial planning. - Confidentiality: The utmost confidentiality is expected as this involves personal financial information. Ideal Skills and Experience: - Proven experience in preparing detailed financial statements. - Strong attention to detail. - Excellent understanding of personal finance. - Previous experience dealing with sensitive and confidential information.
I'm in need of a capable finance professional with expertise in preparing financial statements to create both an income statement and balance sheet, on a quarterly basis. The statements should conform to the International Financial Reporting Standards (IFRS). Key Responsibilities: - Develop an income statement and balance sheet for the quarter in line with IFRS requirements Ideal Skills and Experience: - Strong background in finance and accounting - Previous experience with IFRS and financial statement preparation - Detail-oriented and proficient in financial analysis and reporting - Ability to meet stringent deadlines and deliver high-quality work Please provide evidence of similar work completed in the past. I am looking for someone who can meticulously organize my...
...should be a dedicated section for setting and monitoring financial goals, which can help in achieving short and long-term financial aspirations. Colorful Design: The design must be visually appealing and colorful, utilizing a palette that is both engaging and suitable for easy viewing and differentiation of categories. **Deliverables:** A fully functional digital template in editable format (e.g., Excel, Google Sheets). A user guide or instructions on how to use and customize the template. Initial design mockups followed by final design files. **Preferences:** Experience in creating financial templates or tools. Strong portfolio featuring clean, modern designs, especially those that effectively use color. Understanding of user interface design for ease of use in digital format...
Need an Excel VBA expert to do automate a workflow of flagging the date of the first non-zero value in a row. I'm looking for a freelancer with the following skills: - Proficient in VBA programming. - Previous experience in developing Excel automation scripts. - Able to deliver the project as soon as possible.
I'm looking for a professional who can help me transfer my accounts details from Tally Prime to Zoho Books. This includes using the last year's trial balance sheet to ensure all data is accurately captured. Looking for someone with knowledge on Indian book keeping practises. Key requirements include: - Migrating important account details from Tally Prime to Zoho Books - No transaction wise migration is needed, but just setup the opening balances for current fiscal in Zoho books using Trial balance from Tally for previous financial year) - Sync balances between Tally data with Zoho - Addressing discrepancies by adjusting them in the current accounting period - Providing training for one person on key features of Zoho Books Ideal skills and experience: - Pr...
I need an Excel macro developed for my employee training tracking workbook. I want to have a feature that sends email notifications to both the new hire and their manager based on the completion date of each training module. Key Requirements: - Email Trigger: The macro should send emails based on the completion date of each training module, not just the hire date. - Email Recipients: The email notifications should be sent to both the new hire and their manager. - Email Content: The email should include the name and email of the new hire, along with a list of overdue training modules. Ideal Skills and Experience: - Proficient in VBA and Excel: You should have a strong background in developing macros and automating processes within Excel. - Familiarity with Employee T...
I'm needing a seasoned professional to aid with various integral aspects of my organization's Hum...all formalities are completed and they're effectively integrated into their teams. - Performance Evaluations: Must be capable of conducting fair and thorough assessments of employee performance, ensuring that all evaluations are both accurate and constructive. Given that we are an organization composed of 50-100 employees, experience handling HR needs of similar scale is most appreciated. To excel in this project, considerable knowledge and experience in recruitment, employee onboarding, and performance evaluations is paramount. Practical understanding of recruitment through diverse channels such as conventional job portals, social media, and recruitment agencies is a...
I need a skilled data analyst to work on a large dataset in Excel. Key Responsibilities: - Sorting and filtering data: The dataset contains over 10,000 rows, so the analyst must be adept at handling large data sets. - Creating pivot tables: Organizing data is a key step in our data cleaning process. - Performing Statistical Analysis: Appropriate statistical analysis will be crucial for accurate data cleaning and preparation. Ideal Skillset: - Proficiency in Excel: The freelancer must have extensive experience working with advanced Excel features and handling large datasets. - Data Analysis Skills: The individual should be well-versed in data analysis techniques, including statistical analysis and data preparation. - Attention to Detail: As the primary goal is data c...
I'm in urgent need of a skilled Excel expert to unmerge text cells in my spreadsheet. Here's what I need: - Unmerge text cells - Format the data as requested - Complete the task ASAP The ideal freelancer for this job should have: - Proven experience in Excel - Strong attention to detail - Ability to work quickly and efficiently Please submit your proposal if you can get this done right away.
Need to deploy the Flask and NextJS project using AWS EC2, and writing the documentations step by step.
I'm looking to update an informational website using Elementor. The site will be targeting the general public and I want it to be mobile-friendly. I need somebody setup a one page main site and a couple of additional pages. Wordpress and Elementor is already installed on the sub-domain. Main Header and Footers have been designed. I would expect this to be completed in 2 hours. Key Requirements: - Design a clean and professional website - Ensure the website is user-friendly for visitors of all ages - Implement responsive design for mobile-friendliness Ideal Skills: - Web design experience - Understanding of user experience principles - Proficiency in creating mobile-friendly websites
Create a database and CREATE TABLE statements for all tables in your ERD (Part A) including primary and foreign keys. 2. INSERT INTO statements for populating the database i. Insert five rows of (made-up) data into each table. Make sure that the data you enter in these tables should be sufficient to return at least one row for each query in Task 3. AL should hold at least 5 bottles of Penfold Grange 2010 in some branch or other
Hi Ahmed I can pay you here for that work on the 2 small excel projects
I am in need of an Excel form that will track data and facilitate scheduling. This will primarily be used by our administrative staff, so ease of use and clarity are paramount. Key Requirements: - The form will need to provide a user-friendly interface for entering data. This should be intuitive and easy for administrative staff to use without any advanced knowledge of Excel. - The form should also be capable of performing calculations based on the data input. These calculations are central to the purpose of the sheet, so they must be accurate and reliable. - Data should be stored across multiple tabs for organizational purposes. This will help ensure that the data remains clear and easy to access as the form is used over time. Ideal Skills: - Strong Excel pro...
...document to be converted into an Excel table. The layout is moderately complex. Here are some additional details: - **Task**: The primary purpose of this conversion is data entry. As such, the Excel table must be an accurate representation of the information in the PDF. - **Layout**: The PDF contains multiple columns of text which need to be correctly mapped to the appropriate cells in the Excel spreadsheet. - **Verification**: After the conversion, manual review and correction are required to ensure that the data has been accurately transcribed. Ideal skills and competencies for this project include: - **Strong attention to detail**: Given the manual verification needed, an eye for detail is crucial. - **Excel proficiency**: A good understanding of Exc...
In Milestone 2 will have below a list of things as discussed over a call, Already done feature mentioned in the sheet, https://docs.google.com/spreadsheets/d/1c07vCbD8xCrZaH5zzypqh8EwvbbHa7wxS-6kAANJtsc/edit#gid=0 Except below list of things in the google drive, Which we will cover in this milestone The cost for this milestone is $1733
Utilizing my knowledge of Excel and APIs, I need a freelancer to exceed Power Query's data size limitations. This is to compile a list of 266 pairs from Binance, which will be sent to you. The final output must: - Bypass Power Query's current limitation from 1000 to 2584. - Arrange the pairs in order of their price. Your solution will enable real-time updates of this data in Excel. It would be beneficial if you have previous experience managing API calls and dealing with large data sets in Excel. Proficiency in real-time data extraction and handling is also crucial. need it fast around 2 Hours not more then this, i had the excel to work on just make this on new sheet
I'm in need of an expert who can assist with entering text data into an Excel spreadsheet. Key Responsibilities: - The primary task is to accurately input text data into the designated cells of an Excel file. Ideal Skills and Experience: - Proficiency in Excel, especially in handling text data. - Attention to detail and accuracy in data entry. - Previous experience in similar projects will be an added advantage. Looking forward to your bids. My typing speed is 55wpm
I am seeking a proficient CBP Entry Data Specialist for a part-time position of approximately 10-20 hours per week. The suitable candidate should efficiently perform tasks including: - Accurate Data Entry - Rigorous Record Keeping - Document Verification The role will require expertise in using tools such as Microsoft Excel and specialized Data Entry Software for smoother execution. Prior familiarity with the Customs and Border Protection database will be a significant advantage, although it's not a mandatory requirement. Excellent attention to detail, accuracy, and organizational skills would make you an ideal candidate for this role.
I'm looking for a meticulous freelancer to help with entering text data into an Excel sheet. My project entails copying texts verbatim from multiple online sources, there's no need for any sort of editing. Here's what you should bring to the project: - Proven experience in data entry - Proficiency in Excel - Ability to handle large volumes of text data - Strong attention to detail to ensure accuracy - Ability to work independently and adhere to deadlines Prior experience with copying data from online sources will be a major plus. Let's put your data entry skills to work in this project!
I have a very simple three js project in a website that I want to be worked on. I will supply a google sheet with 8 co-ordinates per shape, the co-ordinates are given as (X,Y,Z) The first co ordinate is made up of 3 columns named (1X), (1Y) and (1Z) they have a number in the column for shape 1 you must use those 3 numbers to generate the first co-ordinate. Then repeat for (2X), (2Y) AND (2Z) up to the final cordinate (8X), (8Y) and (8Z). Each shape is given along the same row in the google sheet, and has a hexcode colour. The shape should be filled with the hexcode colour in the hexcode colour column. If new rows are added to the google sheet the three js project should add more shapes to the display.
I have a very simple three js project in a website that I want to be worked on. I will supply a google sheet with 8 co-ordinates per shape, the co-ordinates are given as (X,Y,Z) The first co ordinate is made up of 3 columns named (1X), (1Y) and (1Z) they have a number in the column for shape 1 you must use those 3 numbers to generate the first co-ordinate. Then repeat for (2X), (2Y) AND (2Z) up to the final cordinate (8X), (8Y) and (8Z). Each shape is given along the same row in the google sheet, and has a hexcode colour. The shape should be filled with the hexcode colour in the hexcode colour column. If new rows are added to the google sheet the three js project should add more shapes to the display.
I'm in need of an experienced MySQL and Neo4J expert who can help me with designing a database schema and an ERD Diagram from a CSV file. Make a report of the database with proper screenshots and run some queries. more details in chat... Requirements: - Proven expertise in MySQL and Neo4J - Solid understanding of database schema designing - Producing an ERD Diagram
I need a proficient VBA professional who can help develop an Excel recruitment tracker dashboard. Key components should include: - Display recruitment data in visually engaging formats including bar charts, pie charts and tables. - Incorporate dropdowns using macros form control for flexible data querying. - Capture essential data points such as candidate name, the position applied for and the application status. - Provide tracking capabilities for application status reflecting stages like pending, shortlisted, and interview scheduled. -Should have recruitment metrics like Time to hire, recruitment funnel and other key metrics The ideal candidate should have robust skills in VBA and Excel, particularly in creating dynamic and interactive dashboards. Experience in ...
I'm looking for a seasoned Project Designer with a strong understanding of options to conduct an intensive research. Expertise working on softwares, call center, robocaller and conversational ...(implementing cost, monthly cost,etc etc) Responsibilities: do research to find the best integration system in terms of cost and services Skills required: - project building or project manager experiences - wide knowledge of APIs - experienced in integrating, implementing or managing projects or research. how its gonna be delivered and cl as finished is if only: - research docs will be delivered as a EXCEL or Powerpoint, it can be column/tables or presentation - research margin of error doesn't exceed 20% - i dont need need data to be pretty and fancy, as long as its not co...
In need of a meticulous freelancer to undertake a copy-pasting project. Your primary task will be to copy-paste text content into an Excel spreadsheet. Key Responsibilities: - Accurately copy text content. - Efficiently paste the content into a structured Excel database. Ideal Skills: - Proficiency in working with Excel. - Strong attention to detail for error-free work. - Ability to maintain structured and organized data. - Prior experience with copy-pasting tasks a plus. Your effort will be critical in maintaining an accurate and reliable database. I am looking forward to seeing your applications and working with you on this project.
I'm looking for a talented data researcher who can scour government databases to identify Pension variables. The data you'll be researching will be at the heart of the project, so it's pivotal that you are efficient, detailed, and reliable. Key Duties: - Methodically research and compile comprehensive data from government databases - Focus on economic indicator data - Ensure accuracy of collected data Ideal Skills & Experience: - Strong research skills, particularly in government databases - Background in economics, with a solid understanding of economic indicators - Keen attention to detail, ability to interpret and organize complex information effectively - Previous experience in data collection or analysis roles is a huge advantage. Perfect for those who prefer wo...
I'm looking for a skilled and experienced developer to architect a database for a Healthcare application using Node.js. The primary goal of this project is designing a robust, efficient and scalable database that can handle the data requirements of a healthcare application. The database should be able to effectively store and manage sensitive patient information, interaction records, and other relevant data. Key requirements include: - Expert level understanding of Node.js and database design principles - Previous experience developing databases for healthcare applications is a plus - Ability to ensure compliance with healthcare data security standards - Strong problem-solving and analytical skills - Effective communication and collaboration abili...
I'm in need of someone to assist me with typing text data into an Excel sheet. The data will be provided in a digital format (PDF, Word, etc.). Key requirements: - Accurate and fast typing skills - Proficiency in Excel for proper data entry - Familiarity with using specific fonts and sizes for consistent formatting - Experience with data sorting and filtering in Excel Your attention to detail and ability to follow formatting guidelines is crucial. The ideal candidate will be organized, efficient, and able to deliver high-quality work within the agreed timeframe.
I'm seeking a highly skilled Excel expert to develop a versatile, either fully or semi automatic, Excel formula or action algorithm that can handle specific data manipulation tasks. This Excel tool must be able to automatically select data from a certain type of table. Hence flexibility is essential. Likewise, it should be able to arrange this selected data against particular types of rows. The formula should be customizable to adapt to various row types. The main aim is to create a solution which allows for selection and rearrangement of data based on multiple potential criteria, whether by column header, row label, or specific values even though I have not specified them at this point. Therefore, excellent comprehension of Excel data manipulation,...
I need an expert in web scraping, specifically in Python, to extract text data from a particular website. The scraping is a one-time task, not requiring routine updates, and the extracted data needs to be saved in an Excel file (or CSV). This will be hidden behind a login wall - so I suggest that the Python script will go to the website and then wait one minute, where I will manually log in. Ideal Skills and Experiences: - Proficiency in Python for web scraping - Experience with scraping text specifically - Ability to deliver the required output in a CSV format
...geological tools. Key deliverables: - Icons representing various geological tools, specifically: - Wind Rose Diagram - Bore Log - Water Strike - Groundwater Level - Lithology - Field Data Collection - Data Import - Data Export - Data Exchange - Modifications of existing logos to icons to use to indicate integration within the App. Excel (for an Excel export) GWSDat ProUCL AGS Ideal Skills and Experience: - Proficiency in Material Design and minimalistic design styles. - Demonstrable experience in iconography and digital design. - Familiarity with geological graphics would be
As a business owner, I'm constantly confronted with the tedious tasks of data entry, data formatting, sorting, and filtering. I am ...business owner, I'm constantly confronted with the tedious tasks of data entry, data formatting, sorting, and filtering. I am looking to automate this process to save time and improve efficiency. Key Features Needed: -A VBA Macro for Excel to automate data entry and formatting of a text (.txt) file. -Automation of data sorting and filtering needs to be incorporated. Ideal Skills & Experience: -Strong proficiency in VBA and Excel. -Experience in automating data entry, sorting, and filtering via Macros. -Real-world experience dealing with text files in Excel. With your help, I envision a tool that ultimately makes my l...
I am experiencing issues with LDAP SSH user authentication on my Suse SLES 15 SP4 server. This involves an authentication failure specifically with the module. I need help to debug the error Key points include: - Deep understanding of Linux, specifically Suse SLES 15 SP4 - Expertise in LDAP user authentication - Proven experience troubleshooting and resolving authentication errors - Ability to ensure smooth functionality of the LDAP User authentication system The error message is attached. Please note that the LDAP is only used for user authentication, no other functions. I am looking to have this issue corrected as soon as possible.
