Excel grab data different sheet jobs
I’m looking to hire a proficient Microsoft Excel expert, specifically, someone who excels in automation tasks. Tasks for this project include: - Creating automation scripts for: - Data Formatting: The job will require you to set up scripts that format data according to preset conditions. Understanding of and experience with conditional formatting in Excel is critical. - Report Generation: I will require automatic generation of reports from collected data. Your experience with creating automated report systems in Excel will come in handy. In terms of skills, experience with Excel including knowledge in macros and VBA scripting is a must-have. The ideal candidate should have developed automatic report systems in the past and h...
I require a comprehensive financial audit. The successful freelancer will review my business' revenue and expenses, balance sheet, and cash flow statement for the previous financial year. Key Details: - Scope: All areas of financial report ($300,000.00 only) - Period: Prior fiscal year Jan 2023-June (only 6 months) Necessary skills and experience: - You need to have a strong background in accounting and financial analysis. - Proven experience conducting financial audits is a must. - Confidentiality and professionalism are paramount. The intention is to understand our financial health, identify any discrepancies and areas needing improvement. Your detailed report should clearly outline your audit findings and recommendations.
Please READ INSTRUCTIONS carefully. Engaging YouTube thumbnail. The design should be significantly catchy to attract the attention of potential viewers. this is for a Real Estate Investor Coach , who is releasing a video about the best strategy to go from 1 house to 10 houses fast. The thumbnail design must be like the examples of the ones I'm attaching. ...(Step by Step) but it should be in SPANISH because my client is Spanish speaker. De 1 casa a 10 casas! La Mejor Estrategia (Paso a paso) I'm also attaching pictures of the influencer. Since the pictures dont have hand gestures like the ones in the examples, I would like for you to insert the hands. (please take a look at the examples) The thumbnail must be vert attractive, clean, big so it can grab the a...
Seeking an expert in commercial architectural drafting for frameless mirrors in a fitness room. The successful freelancer should have a robust portfolio that includes prior work related to mirror/architectural drafting. Key Project Details: - The drawings should incorporate specific custom dimensions for each sheet mirror. These precise dimensions will be shared during the course of our discussion. - There will be an approval process with the design team and field dimensions after the walls are built. 1-2 iterations of revisions should be expected. - There will be multiple openings in the glass requiring precise dimensions for mirror cutouts. Ideal freelancer's skills and experience: - Prior experience in drafting submittals. Frameless mirror or glazing drafting experience...
I need a custom Excel database with a scorecard for tracking and storing specific data related to the customization of my cow-calf ranch. The main points to evaluate are: 1. Cow & Calf Weights: The database should be capable of storing, tracking, and analyzing the weight of both cows and calves. 2. Pregnancy records and AI: These essential data must be incorporated into the database and made easily accessible for regular reviewing. 3. Feeding info: Details about what the animals are fed, when, and how much should be easily trackable. 4. Graphics Specification: The data should be visualized through engaging and informative bar charts. 5. Individual Animal Productivity: The bar charts should clearly show individual animal productivity. The right candidat...
We are currently seeking English voice actors for male characters for a gaming project. Here are the desired skills and experience: - Voice acting experience - Ability to deliver a quick turnaround, as this project needs completing ASAP. - Understanding of audio recording and editing tools. - Excellent inter...and expressiveness, to ensure the audio captures listeners' attention. Due to the confidentiality of the project, we will send you the audition files upon receiving your application. If possible, you may also send your voice reel and contact information, so that we can reach out to you promptly for any suitable opportunities in the future. This is an exciting opportunity for voice actors who excel at creating intense, dramatic performances. Your voice could bring my p...
...has a keen understanding of the top trends in the iconography. The creative direction for this project leans towards a clean, simplified look that better matches Windows applications such as the Microsoft Office suite icons, for example, Word, Excel, and PowerPoint. Key Project Requirements: - Your design should reflect a professional yet attractive flat design style - The color scheme should be sophisticated and simplistic, complementing Microsoft Office's aesthetic - Please incorporate design elements that resonate with Microsoft Office's Word, Excel, and PowerPoint icons Ideal Skills and Experience: - Demonstrable experience with flat icon design - A deep understanding of Microsoft Office's design aesthetics - Provable proficiency in graphic design sof...
I'm looking for a MySQL expert who can create a complex query to retrieve data from multiple tables (Table A, Table B, and Table C) of my database. These tables are interconnected, and the goal is to join data from all these tables, perform necessary calculations, then save the result into another table. Excel file with explanation is attached. Required Skills: - Experience in MySQL query writing - Ability to handle multi-table complex join operations
I'm seeking a proficient freelancer to convert my Excel spreadsheet into a user-friendly form. This form will require expertise in creating interactive components for data entry, incorporating error checking devices, and embedding calculation functionality. Key Aspects: - I require text boxes and drop-down menus for the data entry fields, ensuring a smooth and efficient user experience. - The form must seamlessly check for errors as data is entered, flagging any inconsistencies or inaccuracies. - The ability to tally calculations within the form is a must-have feature. Ideal Skills: - Experience with Excel to form transformations - Proficiency in text boxes and drop-down menu creation - Strong aptitude for error detection and rectification As t...
I need expert assistance with financial statements, specifically the balance sheet and income statement. The specialist I seek should have in-depth knowledge and experience in the following areas: - Assets - Liabilities - Equity - Revenue - Expenses I anticipate an in-depth and comprehensive analysis of these sections to understand the financial standing of my business. Proven experience in these areas is desired.
The bot must go through each post code in Leicester starting at LE1 and first check that the post code falls under Leicester City Council which can be checked below: https://www.g...10-6012-8002-0592-3292 We only want to record address that have an EPC rating of E, F or G. All other ratings must be ignored. If these criteria are met we want the bot to store the full house address details in an excel sheet and then move on to the next property in the list. If a property doesn't meet this criteria then it must ignore that property and move on to the next one. Once the bot gets to the end of the list it must start the process all over again from the start using a different post code. I would like the coder to figure out a way of finding all the different p...
I’m seeking a detail-oriented freelancer for data mining work. Your main task for this project would be to find both email addresses and phone numbers of companies in the 'hosteleria' sector in Spain. This sector includes establishments like restaurants, bars, pubs, breweries, wineries, takeaways, hotels, and residences. Key Responsibilities: • Identify relevant companies in the stated sector • Accurately find and collate their email addresses and phone numbers • Meticulously organise data gathered into an Excel Spreadsheet Preferred Qualifications: • Proven experience in data mining or a similar position • Proficient in data collection and management • Familiarity with Excel and other data org...
...intelligence-based web scraping capabilities, specifically tailored for data extraction. The key functionality of this product will involve passing an Excel document containing up to 100 URLs (represented as rows) for the application to parse. From these active internet links, the app should be proactive in obtaining textual data and preparing it for subsequent use. It's essential for my operations that this extracted information is made readily available as a downloadable file. Ideal skills for the project: - Proficiency in React Js, Node Js, MongoDB - Experience in developing AI-based solutions - Strong background in web scraping - Familiarity with data extraction mechanisms This project will greatly streamline my data-gathering processes an...
...Dropdown, data grid, and the button. On load, the dropdown will populate with the values that will be sourced from the Excel file. The user will select one value from the dropdown. Based on that value the data will load from the access database. This data grid will be changed by the user and it needs to update the access database accordingly in real time.. There will be multiple users on the website, more than 350 and they will constantly be changing this. There is also a third factor, the main Excel data, and will all get changed according to that file, this needs to be updated every 10 minutes. We have a project in C# completed but it is not working on the multi-user environment, because changes are not made in real-time, and instead of ...
I need a custom Excel database with a scorecard for tracking and storing specific data related to the customization of my cow-calf ranch. The main points to evaluate are: 1. Cow & Calf Weights: The database should be capable of storing, tracking, and analyzing the weight of both cows and calves. 2. Pregnancy records and AI: These essential data must be incorporated into the database and made easily accessible for regular reviewing. 3. Feeding info: Details about what the animals are fed, when, and how much should be easily trackable. 4. Graphics Specification: The data should be visualized through engaging and informative bar charts. 5. Individual Animal Productivity: The bar charts should clearly show individual animal productivity. The right candidat...
Hlo! I have done MS in statistics. I read your job description. I have expertise in SPSS, R studio, excel, data visualization and statistical analysis. I will provide you with the finest work that perfectly aligns with your time and budget constraints. Thanks waiting for your response. Regards, Hira Mahmood
I'm looking for a Microsoft Excel guru who can re-arrange my numerical data, which is in multiple columns, in a random order. The purpose of this randomization is so i can call numbers in random order.
In need of a seasoned Excel VBA expert to develop a comprehensive techno-economic analysis tool for solar projects. The automated tool should accomplish the following: - Automate data entry - Generate informative reports - Perform data analysis to inform strategic decision-making Key functionalities to include: - Calculation of Return on Investment (ROI) - Estimation of energy production The tool should take the following inputs to calculate ROI and energy production: - Initial Investment Cost - Annual Energy Production - Energy Tariff - Maintenance Cost Ideal Candidate: - Mastery of Excel and VBA - Previous experience in creating financial/technical analysis tools - Understanding of solar energy industry would be a plus
I require a skilled freelancer to convert my PDF document, which is less than 10 pages long, into an Excel file. All data from the PDF needs to be included without exception. This task does not require replication of the original PDF format during conversion. Ideal Experience & Skills: - Experience in data entry - Proficiency in Excel - Detail oriented - Prior experience with PDF conversion to Excel will be a bonus. This task is simple and straightforward yet it requires precision; therefore, applicants with a keen eye for detail are preferred.
I need a custom Excel database with a scorecard for tracking and storing specific data related to the customization of my cow-calf ranch. The main points to evaluate are: 1. Cow & Calf Weights: The database should be capable of storing, tracking, and analyzing the weight of both cows and calves. 2. Pregnancy records and AI: These essential data must be incorporated into the database and made easily accessible for regular reviewing. 3. Feeding info: Details about what the animals are fed, when, and how much should be easily trackable. 4. Graphics Specification: The data should be visualized through engaging and informative bar charts. 5. Individual Animal Productivity: The bar charts should clearly show individual animal productivity. The right candidat...
...content across my social media platforms and blog. This system should be compatible with Facebook, Instagram, YouTube, TikTok, and Wordpress, Using automations, having a control panel for editing each post if necessary All content is in Hebrew Language My objective it to: 1. Create a blog Article/post on my site though: A. A list of articles names, Category, keywords, Meta description (Excel sheet). The article will consist of a minimum 900 words, and will include: introduction, content, bullet points, quotes, and any SEO tricks to make it more appalling to google search engine, Including research and publications sources links. (we will add Images to the article ourselves) You may see an article format here :
...extracting data from the Collins Dictionary website for personal stud purposes. The goal is to scrape all the entries in the Italian-English and English-Italian sections of the site. The data will be used in a flashcard app (Anki), so would need to be put into 2x Excel files, with each dictionary entry on its own row, and columns containing all relevant grammatical information and example sentences. In need of a highly skilled web scraper. You need to avoid disrupting site functionality, which can lead to access denial or legal issues. Prior experience with data extraction from language-related or education websites is a plus. Key requirements include: - Extraction of Italian to English, and English to Italian translations from Collins Dictionary website...
I'm looking for a skilled spreadsheet specialist who can meticulously compare two CSV files and pinpoints any disc...should highlight it in the original CSV file rather than creating a new one or recording the differences in a separate document. Skills and Experience: - High proficiency in handling and managing CSV files. - Experience in data comparison and error spotting, especially in large datasets. - Advanced knowledge of spreadsheet software, such as Microsoft Excel or Google Sheets, to effectively highlight discrepancies. - Excellent attention to detail, providing accuracy in finding discrepancies based on exact match criteria. If you're detail-oriented and have a knack for data analysis, this project is your chance to shine. Please bid with relevant...
I'm seeking an Excel professional with strong skills in exploratory data analysis (EDA). Key tasks include: - Performing data visualization - Applying descriptive statistics - Conducting missing data analysis The main goal of this project is to conduct a thorough EDA to find insights and anomalies within the data. This analysis needs to be done on an Excel file that is larger than 1GB. The ideal freelancer for this project would have significant experience working with large datasets, especially in Excel, a good understanding of EDA techniques, and a knack for uncovering hidden trends and patterns. Strong skills in data visualization, descriptive statistics, and missing data analysis are essential for this role. Unive...
We're looking to edit an existing automated process created years back. Youll have to see the attachments to see the correlation below. We would like to generate a QR codes containing the information below to then be printed on the LP and MP cards (as seen in the ) attachment. MP Card 1) Date 2) Part Type- MP 3) Item Group Number- 1 of # 4) Order Number- ORD0076301 5) Customer Name- Legend senior living 6) Item- Legend senior living 7) MP Material Type- SPL Cordovan (#192) 8) If "No Image"- No Image 9) Item Quantity- 25 10) Product Line- SPL LB Card 1) Date 2) Part Type- LB 3) Item Group Number- 1 of # 4) Order number- ORD0076301 5) Customer Name- Legend senior living 6) Item- 4 Part 411 7) LB Material- Black 5265 8) Corners Material- SPL Cordovan (#192) 9) If "N...
...well-versed in a wide range of accounting practices. I need comprehensive services which will include: - Bookkeeping: Maintaining accurate records of all financial transactions. - Tax Preparation: Ensure compliance with tax laws and regulations, provide guidance about potential tax liabilities, and handle filing requirements. - Financial Statement Preparation: Prepare statements like P&L, and balance sheet to provide insight on the company’s financial status. - Expert use of Zoho for accounting entries. - Other services including GST filing and TDS. Ideal candidates should be certified accountants with considerable experience working with small businesses. Familiarity with Zoho is a must. Maintain top-level professionalism and confidentiality, and have a strong sense...
I am in need of a professional who can modify the level of access on my existing Google Sheet. Though a shared user, they should have only the edit access with some specific limitations. Please see the important details below: Access Requirements: - The user should be able to edit the data within two specific cells: 'from date' and 'to date.' - The user should not be able to access the regular menu of the Google Sheet. - The user should not be able to create a new sheet. - The user should not have the ability to unhide the hidden sheets. Ideal Skills: - Google Sheets expertise - Strong understanding of user permissions - Data protection and confidentiality This project needs to be completed as soon as possible. Therefore, a know...
Data Entry Specialist Needed for Weekly Task Key Requirements: - Proficient in data entry and comfortable working with Google Sheets - Attention to detail and accuracy in data entry - Ability to complete the task within 1 week Ideal Skills and Experience: - Previous experience in data entry - Familiarity with Google Sheets - Excellent organizational and time management skills
We require expertise in developing an Excel file that utilizes VBA code to automate specific tasks. Primary objectives of the project include: - Creation of an Excel file referenced to a specific dataset - Designing a robust VBA code system to import data from the reference file - The VBA code should perform complex calculations and data transformations pertinent to technical and economic analysis The ideal candidate will have a rich experience in data analysis, particularly in managing, interpreting, and simplifying complex data systems, with a strong proficiency in Excel and VBA code development. Familiarity with technical and economic analysis would be highly beneficial. Please ensure you have tangible examples of similar work to s...
...each day at 9am. It gets the upselling data of my staff from the previous day and sends an sms to them with their %. It only sends an sms to them if they worked the previous day. It is working fine at the moment. The upgrades required is: It doesn't work with any new staff members so we need to update it so it automatically sends to new staff members. There are 2 stores with 2 managers and each manager needs a detailed sms with all the staff at their store and each staff % for the previous day The phython code currently gets the staffs details from a website but the website doesn’t have the staffs phone number, just the name and upselling %. The name and phone number is on a different wesbite. So the code should first run a report and create/edit and excel...
I have a product - Transport Management System. I need to conduct a competitor pricing research. I need to identify pricing of each of these products at different tiers and packages - 1K shipments, 10K shipments, 100K shipments. I have attached the sheet that needs to be filled post the research. Have also entered sample values for reference. Methodology I cannot reach out to these companies as myself since they will sense my company as their competitor and give me an unfair pricing. I want you to reach out to each of these companies sales team as a potential client. Schedule a meeting where they can share their demo and pricing for the given tiers. I need you to lead the meeting while also keeping me in the meeting as your assistant so that I can understand their demo and ...
I require an expert in Python, specifically with experience in using pandas, I am trying to convert a csv file to excel but am experiencing issues with new line characters. Key Responsibilities: - Amend my current Python script to properly process new line characters when converting from csv to excel - Ensure the success of the conversion without any data corruption or loss Ideal Candidate: - Solid Python coding skills - Deep understanding of pandas library - Prior experience dealing with file conversion challenges This task has a sense of urgency, as I need it completed ASAP. Please bid with consideration to these requirements and the time frame.
...creating content across gaming, beauty, lifestyle and comedy, I'm in search of a talented thumbnail artist who can cater to a diverse audience. Your expertise will be beneficial in designing enticing thumbnails for a broad spectrum of themes. Here's what we're looking for: - Ability to cater to different genres: Gaming, Beauty, Lifestyle, and Comedy. - Deep understanding of appealing to different target audiences including gamers, beauty enthusiasts, lifestyle followers and a sense of humor to grab comedy lovers. - We skipped discussing key elements, suggesting we value artistic freedom. However, remember each design should be reflective and representative of the video's content. Ideal skills and experience: - Previous experience in thumbnail...
...application that can read and manipulate data from a tour-based Excel file. Specifically, here is what I need from the software: 1. Ability to read an Excel file with 8 columns. 2. The primary functionality should involve reassigning data from column 8 to column 1. However, this transfer must respect one constraint - each value must be unique. 3. Once the reassignment has been completed, the software should be able to export the changed data into a new Excel file. The programming involved in this project may require significant experience with Excel, a strong knowledge of Windows interface, and proficiency in a programming language that can interface with these programs. It’s vital that the software created can function effec...
I am in need of a highly skilled and experienced Excel expert who can construct a CRM system in Excel to manage my sales data that's tailored to my specific needs. This CRM system should be able to conduct the following tasks: - Capture and manage all sales data. - Track follow-ups effectively, ensuring no opportunity is missed. - Generate reports and analytics based on this data to aide in decision making, including but not limited to, sales trends and future projections.
As a business professional, I need assistance with Excel data entry. Specifically, I need expertise in compiling specific types of data from the web into an Excel format. The project's primary scope entails: - Compiling contact details from various online sources. Given your expertise, you ought to have: - Varied experience in Excel data entry. - A keen eye for detailed, accurate data compilation from the internet. - Strong organizational skills that aid in arranging data logically and usefully in Excel. - Knowledge of Excel functions and commands. - A proven track record in web research. I look forward to receiving well-informed bids from freelancers with matching skills and experience.
Project Overview: I'm offering my services to collect your videos and accurately input the data into an Excel sheet. *Scope of Work:* 1. Video Collection: I will gather your videos from various sources. 2. Data Entry:* Ensuring precise entry of all relevant details into the Excel sheet. 3. Quality Assurance: I'll maintain a high standard of accuracy and completeness. 4. *File Management:* Organizing the videos systematically for easy reference. Why Choose Me: With dedication, attention to detail, and commitment to your satisfaction, I aim to deliver top-quality results. If you're interested in my services, let's discuss further details and get started on this project together. Looking forward to working with you! Best rega...
...platform-specific, so I need a designer who is comfortable creating posts for various social media platforms. - Handle all aspects of creation: From content to design, you have to handle everything. We will provide you access to our Google sheet where you have to write a platform, website name, caption, and hashtags and upload the post image there. - Be flexible in style: Since I haven't decided on a specific style, I'd like a designer who can easily adapt between minimalist, bold and vibrant, or elegant and professional styles, or even something entirely different. Ideal skills would include familiarity with all the major platforms' design guidelines (Facebook, Instagram, Twitter etc.) and strong copywriting abilities, in addition to graphic design. Experi...
We're looking for a freelancer who excels in the creation and implementation of SharePoint lists. Our project involves less than 10 Excel files that need to be imported and transformed into SharePoint Lists. Once successfully implemented, we need these various Lists to synchronize their data effectively. An ideal candidate for this task will have: - Proven experience in working with SharePoint and its List feature - Familiarity with Power BI would be beneficial - Ability to provide detailed project proposals If you can provide guidance on the potentialities and limitations of Power BI functionality, that would be a plus. We value open communication, precision and a results-driven approach.
I need an expert in data entry to implement copying of data from 20 different PDF files, written fully in English, into separate Excel sheets. Key Requirements: - Solid understanding of Excel functionality. - Flawless literacy in English to ensure accurate data transfer. - Ability to follow my predefined format for Excel entries. - Attention to detail for data arrangement based on the sample format provided. Experience in similar data entry projects will be looked upon favorably.
I'm in need of a proficient expert in Excel, SQL, and Python for data analysis, data visualization, and automation. The data complexity is moderate, so a good understanding of data manipulation and cleansing techniques is required. IT IS A TIMED TASK - please only reach out if it’s okay Main Responsibilities Include: - Analyzing the given data - Visualizing analyzed data - Automating tasks that involve data manipulation
I am looking for a skilled freelancer to help with an Excel data entry project that entails advanced formula application. Creativity is welcomed as I am open to the freelancer deciding the most effective and efficient spreadsheet format. A sound understanding of Excel and data manipulation is essential. Knowledge in creating detail-oriented and accurate spreadsheets is a must. Ideally, your skills and experience would include: - Proficiency in Excel - Adeptness in advanced formula application - Ability to design and format effective spreadsheets - Strong attention to detail - Prior experience in data entry projects.
This project revolves around the organization and entry of both textual and numerical data from PDF files into Excel. Specifically, the task involves: - Converting data from both scanned images and text from the PDF source. - Transfering that data into a set Excel format for easier data organization. A freelancer with the ability to decipher and accurately enter data is ideal. Strong attention to detail, proficiency in Excel, and experience with PDF data extraction will be critical for this project. Capturing all the necessary details from both textual and numerical data accurately is paramount.
1. We have 32 backups from the same database as .sql-files. From one table of this database we need all instances in one csv-file (with the same codepage as stated in the sql-file ). So basicly you must: - import 1st backup on your sql-server - export the table "contracts" to "csv for Excel" - repeat for all 31 other backups - put everything together in one big csv-file that is readable in Excel (pls maintain german umlaute) 2. There should be a menu-item (i.e. "Report"); clicking this asks for the date "Welches Datum?"; the current date is proposed but can be changed by choosing a date in a calendar. The report should consist of: 1. All customers that have been added at the given date. 2. All contracts that have been added at ...
We are looking for a Full time Virtual Assistant , who can work full time for us , its a 8 hours daily and 5 days working We need someone who have basic knowledge about social media , Google sheet , Canvas Etc ..you will be assigned multiple tasks each day to perform Only Apply if you can work full time not freelancer base
I'm seeking a dot net developer well-versed in the implementation of SDK functionality. The project centers around encoding product IDs using the TSC T800 RFID printer. Expertise in data encryption is crucial for success. Also, deep familiarity with TSC T800 and mastery of .NET programming are coveted. The work includes: - Configuring the TSC T800 for product ID encoding - Accurate and efficient utilisation of the SDK functionality - Assuring the reliable transfer of data to the TSC T800 and successful encoding To excel in this, understanding RFID technology, .NET proficiency, and experience working with SDKs is integral. Applicants with past work on similar projects will be preferred. This project requires precision, meticulousness, and adherence to guidelines,...
...make it easier to combine all the information about our agents' work. We have only 6 agents So, what we want is to keep track of how many tasks each agent completes, record that in Google Sheets, and then organize it neatly on another sheet. We also want to figure out things like the total number of tasks done overall and how many were successful. It's about using simple formulas Here's what we need: 1. Record Data: 6 Agents enter their completed tasks into Google Sheets. It's only 5 or 6 fields 2. Consolidation: We need to combine all this data from different agents into one place 3. Analysis: We want to use formulas and features in Google Sheets to figure out stuff like total tasks completed and successful outcomes. So, in simpler ...
Looking to optimize my current skills in a manner that generates revenue. As of now, I am particularly interested in data entry projects. Freelancers looking to bid on my project, take note: - Prior data entry experience is a key deciding factor. Showcase your experience in your application. - Illustrate your ability to deliver quality work in a timely manner. Skills you should ideally possess: - Proficient in Microsoft Office Suite, especially Excel - High attention to detail - Able to work swiftly and accurately. Let's turn our skills into a profitable venture together.
...with a variety of tasks that call for advanced Excel and digital marketing expertise. Excel Tasks: - Inputting financial, sales and inventory data meticulously. - Implementing complex formulas and functions for data manipulation. Digital Marketing Tasks: - Managing social media platforms effectively creating engaging content. - Leading SEO optimizations for enhanced web ranking. - Conducting well-targeted email marketing for improved audience reach. Ideal Skills and Experience: - Proficiency in Excel, particularly data entry, functions and formulas. - Experience in diverse aspects of digital marketing such as social media management, SEO optimization, and email marketing. - Prior experience working with financial, sales and inventory ...
