Excel sample project database jobs
Hello. I have some Excel Sheets whereby I have some tables in them. I want to protect the sheet. However, when I do so, I notice that I cannot add additional rows to my tables. I need to be able to lock my sheets and add additional rows to my tables when I need them. It is worth noting that I am also copying data from one table to another on a separate sheet sometimes. I want someone to solve this problem for me, and make me a small video to show me how to do it. I need it explained in perfect English in a way that I understand. In simple terms. I am not a coder or anything like this. Although I am good at using Excel. I made a video for you to check, it is a short video. I have the link on the pdf document.
...to create a comprehensive classroom management database. This platform aims to improve the general flow in the classroom, record classwork and homework, and monitor attendance. Furthermore, these data are expected to be compiled into a simplified report format for evaluation. Key Features: • Compatible with both Windows and Mac operating systems. • Ability to generate student reports. • Provide a channel for classroom communications. • Graph progress • Generate alert notifications based on specified indicators. Integrate barcode scanning to access student entry/profile quickly Notifications Requirement: • All system notifications should be configured to be sent via email. Ideal Skills and Experience: • Datab...
I am seeking an individual with proficient skills in Excel and a keen eye for detail. Your main task will be translating handwritten documents containing text, numbers, and dates into formatted Excel spreadsheets. This will require: - Accurate data transcription from handwritten documents into Excel - Filling out more than 20 columns and rows per sheet - Proofreading and immediate correction of errors The ideal candidate should have extensive experience in Excel and data entry, plus superb attention to detail. Knowledge and practice in inputting handwritten data would also be beneficial. Make sure to include any relevant data transcription experience in your proposal.
I need to extract a list of 500+ stores from an online directory. The structure of the directory is: - A home page with a long list of stores. You can see the name of each store. If you click on a store, you will be taken to that store's page. - Each store has its own page in the directory. This page contains lots of data about the company. This is what needs scraping. Key Deliverables: - Excel or CSV file containing contact data for each store Data required to be extracted (if found on the page): - store name (this is the store's name, separate from company name) - store company name - store website URL - store Facebook page - store telephone number - store email - store Introduction paragraph - google maps link - opening hours IMPORTANT: You must ensure accuracy of t...
Confirmis () is a Singapore-based business information provider specializing in connecting businesses with global capabilities; comprised of industry veterans, Confirmis's business model is designed...etc. REQUIREMENTS: • Must be living in (or nearby) Dili, Timor-Leste • Has a camera or phone/tablet of quality with a camera, internet access • Must be available during business hours (9 AM - 4 PM) on working days Please see the attached file for the site visit guidelines. You are only required to deliver the pictures, video & observations and are not expected to put together a report like the Sample Report. Note: Milestone will be released the following week after the site visit to give us time to organize the report and contact you if we need additional cla...
I'm urgently seeking an advanced Excel coder for data analysis. With a budget of just $10, your key role will be to analyze and report on an undisclosed set of data. To be successful in this task, the following skills are desirable: - Expert knowledge of Excel, including creating custom functions - Strong data analysis and reporting abilities - Experience automating repetitive tasks to improve efficiency Please, note that I am aiming for prompt completion of this project, so your ability to produce results ASAP would be beneficial. If your Excel coding skills align with what I'm seeking, please don't hesitate to bid on the project. Improving data accessibility and understanding through your expert analysis is my main goal. Your guidance ...
The requirement is to create a mini-game for the gamification of introducing a detergent at select outlets with real-world awards like free product sample, discount vouchers etc. The game could be on a white background, a cursor in the middle (brand logo) which is drag-able to all areas of the screen to eliminate incoming elements/enemies/projectiles/dirt. The web app must be user friendly and intuitive with basic functionalities. For example, it must have features like: ● 60-second timer (Time limit) ● Drag-able cursor ● 2D Graphics ● Window or Pop-up menu for New Game, End Game, Display Award won by Player at end of game
I'm urgently seeking an advanced Excel coder for data analysis. With a budget of just $10, your key role will be to analyze and report on an undisclosed set of data. To be successful in this task, the following skills are desirable: - Expert knowledge of Excel, including creating custom functions - Strong data analysis and reporting abilities - Experience automating repetitive tasks to improve efficiency Please, note that I am aiming for prompt completion of this project, so your ability to produce results ASAP would be beneficial. If your Excel coding skills align with what I'm seeking, please don't hesitate to bid on the project. Improving data accessibility and understanding through your expert analysis is my main goal. Your guidance ...
I require an Indian male voiceover artist for a casual and informal 2D animation conversation between 2 men. The animation is less than 1 minute long, making it a relatively quick project. - Expertise in voiceover work, specifically in animations and casual tonalities - Native Indian or someone capable of an authentic Indian male voice - The ability to deliver a high-quality, clear audio file in a prompt timeframe Please provide a sample of your work in the bid. Previous experience in animation projects preferred.
I look for assistant from India who will be responsible with finding suppliers, finding new items , preparing catalog and take CARE of the order. We require expierience in sourcing , Excel knowledge and negotatiation skills.
Aiming at building a long-term association with the artist. Nature of work: VoiceOver for animated explainer videos along Requirement: The artist should have a good hold over the language, prompt communication and should have their own setup; with perfect output. Budget: 20 USD a minute P.S.- Creating a job here for initial 5 minutes of content. Sample script:- Operational Performance Review is a check which each enrolled product must undergo to ensure that each unit is labeled accurately before protection is active. During OPR, we monitor your labeled units to ensure that 1) Each unit is being labeled with the correct code. 2) All units are labeled with a Transparency code Note, Transparency protections are not active until products complete the OPR process. Upon starting OPR, yo...
...commercial should have upscale qualities and a touch of sophistication. 2, We require native residents of the United States for the shoot. 3, While we will provide some selling points to be featured in the commercial, the script for the commercial will be defined by you. 4, We have approximate sample clips available for reference. What You'll Get: 1, A payment of $400. We will cover the entire cost with this payment, regardless of how long it takes you to complete it. 2, A high-quality complimentary sample. 3, Opportunities for long-term cooperation. 4, Please note that we will need to review the footage first to ensure it meets our requirements before making the full payment. However, we assure you that we will not intentionally reject your footage if it inde...
I have a specific ACCDE file that needs expert attention. The required tasks for the freelancer include: - Customization of forms and reports in the ACCDE file. This ACCDE file has forms where users...expert attention. The required tasks for the freelancer include: - Customization of forms and reports in the ACCDE file. This ACCDE file has forms where users can input the data, I would like to export this data into excel/csv or SQL (whichever is conviniant) - Current challenge is, unable to look at the VBA code or export full columns how in the form. The ideal candidate has extensive experience with MS Access, specifically in the customization of ACCDE files and data exportation. They should have in-depth knowledge of form and report design as well as MS Access to Excel/CS...
I'm seeking an experienced freelancer to construct a comprehensive Excel worksheet. This worksheet will be used to calculate and compare around 10,000 individual assets with different inservice (depreciation start dates). The assets i specifically am looking at are called SUBbase assets and used in Road construction. We currently have asset lives of around 150 years but wish to compare this life with a variety of years 200/250/300/350 and 400years. Possible different years so needs to be able to amend lives and compare against original. I am looking at having something design that can give comparisons against the original live (which ive highlighted in yellow). The file attached has a large amount of data alot of which isnt necessary The columns in yellow are what you wil...
Attached you can see what I need from a before and after result. Remove imperfections, center ring, add colors, add bottom reflection, add and center logo, fix background. I can provide reference video for how to edit. I believe once you get the hang of it you can edit each image in 10 to 15 minutes. If you are interested you can send a sample using the file titled SAMPLE via chat. Also here is a link where you will find reference procedure videos to produce the expected result:
Hi, Looking for a designer to create a folded takeaway menu leaflet in A3 size 2 Pages (front and back) using InDesign. The menu will be featuring mainly ...include menu items, prices, and descriptions. Ideal skills for this job include proficiency in InDesign, experience in menu design, and an eye for branding and color schemes. When the page is open A3 size and 2 Pages (front and back). It will be a folded leaflet ( total 6 panels), like gate folded. If the job is completed nicely, we are happy to give more work in future. Attached pictures just a sample, to show what kind of job needs to be done. End of the work i need all the raw indesign folder as Package (that should includes Document Fonts, Links , pictures .idml, .indd, pdf ) (orginal files will be send by chat sectio...
I need a VBA macro expert to automate repetitive tasks in Excel. Specifically, the focus is to build a macro that will update data from multiple database systems, pulling all necessary data and accurately updating the Excel file. The requirements include: - Deep knowledge in Excel VBA and macros. - Extensive experience in dealing with database systems. - Attention to detail to ensure valid and accurate data updating. - A solution-oriented approach to identifying potential issues with the automation. The ideal candidate will have a proven track record in creating VBA macros that interact seamlessly with various database systems. They'll bring efficiency and reliability, turning the repetitive updating process into a seamless, automated one.
I am in need of a proficient Excel automation specialist. This job requires updating an existing workbook with new data, automating the creation of rows, columns, and formulas and allowing for an undated workbook to be downloaded without having to re-create all the formulas etc. I am open to the choice of programming language used for the Excel automation, eager to discuss your expertise and preference. Here are the expected tasks: - Modify an existing workbook with new information - Automate the import of current workbooks - Automate the creation of rows, columns, and formulas The frequency of these tasks will be dictated by our data download schedule which is done on an as-needed basis per job schedule. Ideal candidates will have a solid background in Excel automat...
I need a detail-oriented freelancer to assist me in extracting text content from Word documents and transferring it into an Excel spreadsheet. Key Tasks: - Copy text from Word Files - Paste text into Excel Spreadsheet The ideal applicant should have: - Experience in data entry - Strong attention to detail - Proficiency in Word and Excel Speed and accuracy are of the essence in this job, resulting in an efficient conversion without loss of information.
Please create a word or pdf editable essay cover for me. I used chatGPT for the Sample provided.
...analyst keen on weather patterns. To make an informed decision on a project I'm currently undertaking, I require detailed historical rain data for Camden County, New Jersey, spanning the last 2 years. Your key tasks will include: - Gathering and analyzing rainfall data specifically for Camden County, NJ - The data should cover a period of the last 2 years - Present the data in an Excel format Ideal candidates should possess expertise in the following areas: - Meteorological data gathering and analysis - Familiarity with weather recording instruments and systems - Proficiency in transforming raw data into actionable reports - Firm grip on Excel for data input, organization, and presentation With your contribution, this project can march forward wit...
Project Description: We are a transportation company specializing in vehicle transportation across the United States. Our operation involves four main divisions: Drivers, Dispatchers, Accounting, and Management. The current process involves manual data entry into Excel documents for tracking loads, payments, and generating weekly reports and invoices. This process is time-consuming and prone to errors. We aim to automate and streamline our operations by developing a custom web application. Objectives: To develop a user-friendly web application that automates the entry and tracking of load information. To create a system that automatically generates invoices and weekly reports based on the entered data. To allow for real-time data access and updates by different divisions w...
list of about 150 organizations (in docx). Your job is to: — transfer the list of organizations to Google Sheets (or Excel) (just enter the name, not description) — for each of them add in 7 columns: acronym (if there is one), a website, contact email address (office or other main email, not webmaster), city (not whole address, just the city), country, year founded (establishment year), English Wikipedia link (if the organization does not have a Wiki page, leave empty)
Project Description: We are a transportation company specializing in vehicle transportation. Our operation involves four main divisions: Drivers, Dispatchers, Accounting, and Management. The current process involves manual data entry into Excel documents for tracking loads, payments, and generating weekly reports and invoices. This process is time-consuming and prone to errors. We aim to automate and streamline our operations by developing a custom web application. Objectives: To develop a user-friendly web application that automates the entry and tracking of load information. To create a system that automatically generates invoices and weekly reports based on the entered data. To allow for real-time data access and updates by different divisions within the company. Key Fe...
I'm seeking a proficient Python programmer who can build effective scrap...and LinkedIn profiles. Your task will include: - Using Python with Scrapy to collect desired information. - Developing scripts that can identify and retrieve the services provided by the mentioned sites, along with their relevant contact details. - Ensuring that the scripts can also gather a comprehensive list of requirements from LinkedIn profiles. - Lastly, providing the compiled data in an Excel file format. Experience with Python and Scrapy is vital, and a firm understanding of web scraping and data manipulation is necessary. A proven track record in similar tasks would be advantageous. The freelancer must also be aware of and adhere to the legal boundaries around web scraping to avoid any potentia...
... This includes retrieving details such as company names, contact names, addresses, phone numbers, website address and email addresses. Key tasks include: - Scrape all necessary information - Format scraped data into an excel file - Rigorously remove any duplicate entries The ideal freelancer for this project would have a vast amount of experience in web scraping and data mining, as well as a deep understanding of data cleansing to ensure we are only left with unique data points. Highly proficient in Excel and familiarity with Website A's structure would also be advantageous. ----- note there are two parts for each record: Scrape : date: / name of show/ and location on this page: then continue click on each
I urgently need an experienced freelancer to create project management spreadsheets. Here is what I'm specifically looking for: - Proven experience in creating project management spreadsheets. - Quick turnaround as the project is needed ASAP. - Deliver spreadsheets that effectively track and manage project information. - Successful freelancers will need to include detailed project proposals with their applications. This project requires a freelancer with advanced knowledge in Excel or other spreadsheet programming. If you think you're the perfect candidate, don't hesitate to apply. I look forward to see your detailed proposal.
Problem: we want to be reminded / flagged when a contract should be renewed / re-tendered. We want to reminded / flagged six months before the contract expires. The data point we have is the contract expiry (dd/mm/yyyy). Solution: if the contract expiry is less than 6 months away, please make column H red. It needs to be done in a google sheet and in excel.
Looking for an artist highly proficient in sketching to bring life to a number of characters in our new project. The style for these characters is retro cartoon preferred, but hasn't been decided yet. Key Requirements: - Ability to sketch versatile cartoon styles. - English proficiency. - Willingness to work with provided text and sample illustrations. Please include in your application: - Any past work related to cartoon sketching. - Experience in the field. - Detailed project proposals. Ideally, we are looking for a talented freelancer who can understand English. Is detail oriented and has sketch creatively. While specific number of characters is not provided, anticipate sketching multiple characters. The style of the characters is open for now - be r...
I am in need of a meticulous data entry clerk, proficient in both text and numeric data entry. The project involves entering 200-250 items into a pre-provided template. Ideal skills and experience: - Proven data entry work experience. - Strong language skills. - High levels of attention to detail. - Experience with data entry software. or in an excel template - Experience working with templates. Please note: The excel template for data entry will be provided, I'll need you to follow the structure precisely and ensure you maintain high levels of accuracy. The data provided will be a mix of text and numeric data. Fields (Columns) will be : date = date field supplier name = text field nature of items or services ( 7-10 key words) = text f...
I am seeking a professional with strong capabilities in Excel who can assist in creating 5-10 filter views on an online Excel sheet. The successfully completed project will include: - Ability to filter numbers, text and dates with precision - Filter views applied effectively on each individual column - Advanced understanding of Excel to ensure seamless integration of filter views The ideal freelancer for this job will have experience with complex Excel tasks, especially filter views. Your expertise should include a strong understanding of Excel formulas, data types and the ability to navigate and edit online Excel sheets with speed and accuracy. Your work will significantly improve the functionality of my spreadsheet, enabling faster data ...
I have two lists of invoice numbers and associated amounts, formatted in Excel. I need a worksheet created that will compare these lists and highlight any invoice numbers that cannot be found and their corresponding amounts. The comparison results should be incorporated into existing sheet 1. Additionally, the data in these invoice lists includes dates, invoice numbers, and transaction amount. Ideal freelancers for this project should be: - Highly proficient in Excel - Experienced in data comparison and highlighting functions - Able to work with data that includes dates and transaction amounts.
I'm in need of an Excel expert who can utilize Excel macros to automate several of my routine tasks. The main actions to automate are listed below: - Data Entry - Generating Reports These tasks are currently taking a significant amount of time and I'm confident that with the right automation, efficiency can be greatly increased. Ideal candidates should have extensive experience in using Excel macros for automation and report generation. A deep understanding of Excel and automated data entry via macros is essential for the successful completion of this project.
You need to select a subset of data with 100-150 Company related facts from Knowledgenet. Use Facts triplet with these relations (DATE_FOUNDED (ORG–DATE), HEADQUARTERS (ORG–LOC), SUBSIDIARY_OF (ORG–ORG), FOUNDED_BY (ORG–PER), CEO (ORG–PER) for creating the knowledge base. Reference Dataset Links: use tra...(DATE_FOUNDED (ORG–DATE), HEADQUARTERS (ORG–LOC), SUBSIDIARY_OF (ORG–ORG), FOUNDED_BY (ORG–PER), CEO (ORG–PER) for creating the knowledge base. Reference Dataset Links: use inside the dataset as your source of data. Deliverables: * Complete code that can run on Google Colab * Report of the process which you have followed to build & train * Report 15 - sample conversation with a chatbot
I'm seeking a highly skilled freelancer to assist with data processing tasks. Key Responsibilities: - Process various data efficiently Please note, the source of the data to be processed is unspecified at this point. Timeline: - There is no strict deadline for project completion. However, a sense of urgency is appreciated Ideal Skills: - Solid data processing capabilities - Prompt delivery and high-level accuracy - Exceptional problem-solving skills Experience in the data entry field If you think this project aligns with your skills, I'd love to hear from you.
I'm on the lookout for a skilled LinkedIn professional who can help me optimize my profile. With your expertise, I'm hoping to: - Primary (no update of picture and no update of experience) target specifically towards business professionals,...showcasing my skills and experiences in a compelling way. - Set up job alerts for specific target areas. Candidates with experience in social media marketing, particularly on LinkedIn, who can demonstrate previous success in these areas are ideal. Knowledge of LinkedIn's algorithm and professional networking strategies would be a major bonus. ** Please send previous work achievement of link to sample articles or profiles you have completed to be considered. Will narrow down worker and send the profile to view that needs to work...
I'm seeking a professional writer versed in crafting compelling website content. Your tasks will include: - Writing engaging website content that resonates with our target audience and communicates our brand message effectively. i have sample of one website and would need similar pages with different content which should also contain SEO keywords
Creation of a real estate acquisition model including Cash flow, tenancy schedule, lease modeling and renewal assumptions, IRR, levered and unleverred. Including formula to play with the model.
I have multiple Excel files that require thorough cleaning. The data inconsistencies that I need addressed include duplicates, formatting errors, and incorrect entries. There's also a need for merging, splitting, and conditional formatting. Ideal candidates for this project should be proficient with Excel and have experience in data cleaning. They should also be adept at identifying and solving data-related issues. Ultimately, I need all duplicate entries to be removed from these files. • SKILLS REQUIRED: - Proficiency in Excel - Experience in data cleaning - Ability to merge and split data - Familiarity with conditional formatting
## Scrape and fill in the event data in the sample Excel sheet provided to Win ## What I require: - A lesson on how to efficiently and effectively scrape websites for event data - A rundown on the usage of third-party software in web scraping - I have a list of Urls on a google-sheet and I need to scrape event data Your application should provide evidence of your knowledge of third-party web scraping software. This should be very easy for you.. Please bid with the image of the tool you'll be using. I have attached the sample data.. Scrape for all events Columns and the Event Url in Column Q. To confirm that you used a scrapping tool I may give you 500 additional data for you to
Project Description: We are seeking a talented graphic designer to create a captivating social media flyer for our online course. The course targets individuals aged 15-25 and course name is Data analysis with MS Excel Requirements: 1. Design must be visually appealing, professional, and in line with our brand identity. 2. The post should include engaging visuals and concise, compelling copy to capture the audience's attention. 3. Dimensions: WhatsApp status, WhatsApp post, Instagram 4. Incorporate relevant course details such as course name, key benefits, and a call-to-action (e.g., "Enroll Now"). 5. Use our brand color pallette 6. Provide the design in a high-resolution format suitable for social media posting. Deliverables: - One social media post design...
I require a comprehensive spreadsheet created that compares four different real estate brokerages. The spreadsheet should contain multiple tabs, each committed to the follo...four different real estate brokerages. The spreadsheet should contain multiple tabs, each committed to the following aspects: - Fees - Number of transactions closed - Average price point - Stock options - Agent attraction For the 'number of transactions closed', I wish to use a preset value for each brokerage. Moreover, I want the 'fees' data structure to be tiered. Candidates with excellent Excel skills are preferred. It's also beneficial if you have a good understanding of real estate brokerage fees and structures. Attention to detail is essential as the spreadsheet needs to allo...
I require expertise in extracting purchase details from text-based PDF attachments in my Outlook emails and compiling this data in an excel sheet. Key tasks: - Set up a platform that automatically imports data from new email attachments - Extract purchase details from these attachments - Place this data into an Excel sheet accurately. Skills and Experience: - Proficient in Microsoft Outlook and Excel. - Knowledge of data extraction from text-based PDFs. - Automation experience, ability to set up a system that triggers upon receipt of a new email. - High attention to detail required. - Previous work in data extraction or related fields is a plus.
...a MySQL database. Details: * The script must be able to accept a list of codes, that can be easily inputted through copy-pasting into a text box. Each code must be listed on a new line. * For every inputted code, the script should locate the corresponding entry in the MySQL database, where codes are structured as separate rows. * Once matched, the code's associated value must be altered to a specified number, which will be inputted into a second text box as part of the script interface. Additional Requirements: * If a code cannot be found within the database, the PHP script should skip that particular code and a warning message should be displayed to the user. Key Skills: * Proficiency in PHP and MySQL Database Management * Handling user inputs a...
I am in search of a talented individual with experience in contemporary graphic design to create a unique, modern-styled logo for my company. Key Project Details: - My preference is for the logo to incorporate my company's initials and specific shapes or symbols, providing a contemporary and innovative feel. - I am particularly fond of the color blue, and would like this to be used within the logo design. Suitable Freelancers: - Ideally, freelancers bidding on this project will have a solid track record of producing modern, sleek logo designs and are able to effectively integrate symbolic elements into their work. Sample works showcasing this ability will be highly appreciated and increase the chance of selection. Remember, I am looking for a design that is n...
I'm in need of an Excel VBA expert who can write a VBA routine to alter the font of a string. See image attached Sub BookLabel() Select Range StartLabel (H2) Select first x characters of string where x = value in cell F2 Set font =16 Font = Bold Down 1 cell Repeat same Continue to loop until some statement such as “End”, below the last record End Sub
Need to build PowerBI reports and deploy them on Azure server on Microsoft end too. if you know how to do both, then apply Need complex detailed PowerBI reports built - just fyi. So if you only know Charts in Powerbi, dont apply I need good people who can do complex reports and are able to deploy to Azure too. Very important - you must be able to support us duri...built - just fyi. So if you only know Charts in Powerbi, dont apply I need good people who can do complex reports and are able to deploy to Azure too. Very important - you must be able to support us during US EST times as and when required during deployment, updates when needed and troubleshooting. I will need to see samples of what complex PowerBI reports you have done. I am attaching a sample of what I ...
I am seeking a freelancer skilled in Adobe Premiere Pro to teach me the ideal export settings for posting 720p videos on Twitter, using a 4k output video recorded using Loom's screen recorder. I'm interested in knowing how to convert the video for optimal twitter viewing. Key Tasks: - Demonstrate the process of converting my sample Loom 4k output video into the correct Twitter-compatible format for perfect clarity and viewing. Expertise Needed: - Familiarity with Adobe Premiere Pro - Understanding of video conversions and formatting for social media platforms
