Excel macro extract name jobs

As a client seeking to improve my understanding of excel, I would like a skilled instructor to guide me through the basics of formulas and functions, data analysis and reporting, as well as formatting and conditional formatting in Excel. Although I don't have a specific completion time, expediency is appreciated. Skills and experiences that would be ideal for this job: - Advanced Knowledge of Excel - Excellent Teaching Skills - Flexibility to cater to learning pace No preference was selected for the type of learning medium, so offering a blend of online videos, live training sessions, and written instructions could be beneficial to cover all bases.

ADMIN ASSISTANT Required - Bookings - Email and Messenger correspondence - Online Advertising on Facebook Marketplace and Gumtree - Search online information - Excel Spreadsheets - Bookkeeping - Office work Job is full time Monday to Friday Thankyou

questions added to excel

I'm in need of a detail-oriented and communicative Virtual Assistant to manage key elem...reconcilliation of payments & invoices - Assisting with keeping track of repairs using Zoho Desk - Handle customer support inquiries via Email, Phone, and Live chat --Respond directly to basic queries --Forward on relevant information to our local staff - Execute order management tasks The ideal candidate should have: - Excellent written and verbal communication skills - Data management and excel skills are critical - Ability to manage multiple tasks simultaneously - Familiarity with various customer support and order management tools - Available for 4-8 hours per day. - Experience with Zoho one - Understanding of laptop parts or experience in the laptop repair industry Please quot...

...freelancer who can handle both video editing and excel management. - Video Editing: I have various types of videos that need to be edited. This includes marketing videos, tutorial videos, event videos, and reels. The ideal candidate is proficient in video editing tools and can create engaging, professional videos that suit different platforms such as social media, websites, and presentations. - Excel Management: On the other hand, I also require assistance in organizing and managing data on Excel. You should have a good grasp of Excel functions and be able to maintain and update spreadsheets effectively. Ideal skills: - Proficient in video editing software - Experience in creating marketing, tutorial, and event videos - Skilled in managing data on Exc...

...entering high complexity data into Excel. The data is scientific research data and involves working with an extensive database. Key Requirements: - High level of attention to detail is crucial, as inaccurate data entry could have significant implications. - Familiarity with Excel and proficiency in data entry. - The data involves scientific research data, so any background in related fields would be beneficial. Tasks: - Entering the data accurately and efficiently. - Applying conditional data validation as required (e.g., specific formats or criteria for entries). - Ensuring the database is updated and maintained accurately. Ideal Skills and Experience: - Proven experience in data entry, ideally with high complexity data. - Strong understanding of Excel, particul...

I'm looking for an expert to scrape data from a website. I will provide the list of data (approx. 16K entries) that will be entered into the search bar and I need 2 fields extracted from each search into an excel sheet. This will be a one-off scrape of the website.

I require a freelancer skilled in data entry. Unfortunately, I was unable to determine the specific type of data entry needed, total entries required, and the format of the data. However, I am seeking a dependable professional who can adapt to different tasks. Ideal skills include: - Strong atte...freelancer skilled in data entry. Unfortunately, I was unable to determine the specific type of data entry needed, total entries required, and the format of the data. However, I am seeking a dependable professional who can adapt to different tasks. Ideal skills include: - Strong attention to detail - Data categorization - Data verification - Data conversion The applicant should be proficient in Excel, CSV, and PDF. This role is likely to involve handling various types of data, so versatili...

I need a professional who assist me in changing the brand name of 50 listings

...looking for a detail-oriented individual to assist with a data entry project. The task involves entering a variety of data types including numeric, text, and alphanumeric, into an Excel file. Key Details: - You will be working with a spreadsheet that has more than 10 columns. - I require the data to be formatted in a specific way: - Color coding: Certain cells should be filled with specific colors. - Conditional formatting: Cells should be formatted based on specific criteria. - Data validation rules: Certain cells should only accept specific types of data. Skills required: - Proficiency in Excel, including experience with conditional formatting, data validation, and color coding. - Strong attention to detail to ensure accurate data entry. - Efficient and r...

As part of my business operations, I need a robust and all-inclusive Excel-based Point of Sale (POS) and Inventory system. KEY FEATURES: - **Sales Tracking**: The system should track all sales, revealing important stats that can aid decision-making. - **Inventory Management**: Stock should sync automatically with sales from POS, maintaining an accurate record of available goods. - **Customer Database**: Important fields such as Contact Information and Purchase History should be part of this system. Important tax-related fields like the tax fee and tax ID number should also be included. IDEAL SKILLS: Freelancers with a strong background in Excel and inventory management systems are preferred. Experience in integrating POS systems and data entry automation is also desirable....

As part of my business operations, I need a robust and all-inclusive Excel-based Point of Sale (POS) and Inventory system. KEY FEATURES: - **Sales Tracking**: The system should track all sales, revealing important stats that can aid decision-making. - **Inventory Management**: Stock should sync automatically with sales from POS, maintaining an accurate record of available goods. - **Customer Database**: Important fields such as Contact Information and Purchase History should be part of this system. Important tax-related fields like the tax fee and tax ID number should also be included. IDEAL SKILLS: Freelancers with a strong background in Excel and inventory management systems are preferred. Experience in integrating POS systems and data entry automation is also desirable....

I'm seeking a proficient Excel expert who can help me create a complex formula for my Excel sheet. The formula will involve an IF statement assessing multiple values and conditions. its one simple formula Key Details: - The formula should be able to evaluate whether a given value is: - Greater than a certain threshold, - Less than a certain threshold, or - Equal to a specific value. - Each of these conditions should trigger a different calculation (to be defined). You should be familiar with creating complex formulas and IF statements in Excel. Your attention to detail and understanding of data manipulation will be crucial in ensuring the formula works accurately. Additionally, your proactive problem-solving skills will be highly valued as you help me d...

I have a large file from my old website, saved in an unknown format (likely HTML, CSV, or XML). Key Points: - The file is from my old website, saved in an unknown format. - I have access to the old website's dat...them on a new website. - The exact format of the file is unknown. It will be a TAR file and it is rather large file (5.49 gb) Ideal Skills and Experience: - Proficient in web development and file parsing. - Experienced in handling legacy website data. - Strong problem-solving skills for dealing with unknown file formats. - Ability to extract, organize, and migrate content effectively. This project requires someone who can navigate legacy systems and extract relevant data for repurposing. The successful freelancer must be resourceful and capable of producing...

I need a professional who can quickly and accurately input less than 100 rows of data into an Excel file. You'll be provided with all the necessary data, so there's no need for additional sourcing. Ideal Skills and Experience: - Proficiency in Excel - Fast and accurate data entry skills - Attention to detail to ensure correctness - Experience in working with data sets This is a straightforward project that needs to be completed quickly, so I'm looking for someone efficient and reliable. If the data entry is done well, there is potential for more work in the future.

I'm seeking a skilled developer to create a user-friendly macro calculator that's accessible on the web. This tool will help individuals in calculating their daily calorie needs based on their fitness objectives, whether it's weight loss or muscle gain. Key Features: - A simplistic yet engaging web interface that allows users to easily input their details - Capability to calculate an individual's daily caloric needs based on their goals - A results page that provides users with a clear breakdown of their macronutrient requirements The calculator will not require user accounts for tracking progress. Instead, users will have the opportunity to download their results after entering in the details for lead generation. This project is intended to generate leads for ...

My project requires a well-versed professional proficient in to extract critical takeoff quantities from IFC files and integrate them flawlessly into operational smart contracts. Key requirements include: - Extraction of material types and quantity calculations from IFC files - Direct integration of the extracted data into smart contracts to ensure automatic updates - Generation of detailed reports that will pave the way for seamless smart contract integration The perfect candidate will have a strong front-end development foundation and proficiency in IFC.js. Experience with ReactJS and blockchain technology is also essential for the job. Your primary task is to create a user-friendly interface that makes integrating IFC files into smart contracts a breeze. Efficiency, accuracy,...

I need an Excel expert to help me generate all possible combinations of 12 distinct objects, amounting to 2048 total objects. This will involve the use of Pivot Tables, Macros, and Complex Formulas. Key Requirements: - Proficiency in Excel: You should be highly skilled and experienced in using Excel and its various functions. - Experience with Pivot Tables: You must know how to create and manipulate Pivot Tables to organize the data effectively. - Macro Creation: You will be required to write macros to automate certain processes and tasks. - Strong Command of Complex Formulas: You should be comfortable working with complex formulas to handle the extensive data manipulation required. The end result will be a PDF file containing all possible combinations, deriv...

upload text file into site and extract his content

...* Display search results in user interface * User Interface * Develop user interface for Quivr Agent * Include search bar, search results, and settings Cloud Component: Calendar Service * Calendar Integration * Integrate with Microsoft Graph API for calendar data * Retrieve calendar events and appointments * Event Processing * Process calendar events and appointments * Extract relevant information (e.g., attendees, location, time) * Notification * Send notifications to users for upcoming events and appointments * Use SendGrid for email notifications * User Management * Integrate with Azure Active Directory for user authentication and authorization * Manage user roles and permissions Cloud Component: Prep Material Service * Prep Material Gen...

I'm currently in need of a proficient CAD designer to create detailed, highly precise drawings based on a reference image I provide in JPEG format. Main Responsibilities: - Produce...Responsibilities: - Produce advanced CAD drawings that capture intricate details and exact measurements - Interpret the reference image accurately into the design This job is ideally suited for a CAD specialist with: - Exceptional skills in generating high-level detailed CAD drawings - Demonstrable experience working on CAD designs for manufacturing purposes. - Strong ability to interpret and extract details from JPEG images These CAD drawings will be used directly for manufacturing, so extreme precision and attention to detail are crucial. Please only bid if you understand and can meet thes...

I'm in need of an administrative assistant who is proficient in Microsoft Excel for data entry and updating tasks. Specifically, this role entails managing my product inventory. Your primary responsibilities would involve: - Entering and updating inventory data on a regular basis - Organizing and ensuring the accuracy of each entry - Handling large data sets in Microsoft Excel - Following-up to make sure if the items in the inventory is still available It would be beneficial if you're detail-oriented and have prior experience in this kind of work. Don't hesitate if you have questions. Looking forward to your bids.

I'm on the hunt for a unique and unforgettable name for my trendy accessories brand. The perfect candidate for this task would be someone with significant experience in branding, particularly in the field of fashion and accessories. Here are some considerations to guide your proposal: - The brand name must be catchy and stand out in the crowd. It should spark interest and be easy to remember. - The name should reflect the trendy nature of our products. - Understanding and experience with the fashion and accessories market would be beneficial. - No need for domain availability. Put your creative hats on and help me find a brand name that will resonate with our customers and set us apart from the competition!

I'm in need of an Excel expert to assist in creating advanced statistical or financial functions. Your job will be to help me with these complex Excel tasks and generate charts or graphs as the final output. Key Requirements: - Deep understanding of Advanced statistical or financial functions in Excel. - Ability to generate visual representations through charts or graphs. Your role would entail: - Collaborating with me to understand the data and the desired outcomes. - Leveraging your expertise to implement the appropriate statistical or financial functions within Excel. - Presenting the results in a visually compelling manner through the creation of charts or graphs. Please share your relevant experience and any sample work you've done in the pa...

...generating outputs with annotations, conclusions, and recommendations, and allowing the download of reports in PDF format for each subject consulted. Main Features: 1. Intuitive user interface to access the Colombia Rama Judicial file analysis system from Infolaftsearch. 2. Functionality to upload files downloaded from the Colombia Rama Judicial website. 3. Processing of uploaded files to extract and structure the required information*. 4. Visualization and filtering of the list of processes. 5. Detailed view of specific process information. 6. Temporary storage of uploaded files in the browser. 7. Functionality to delete data being processed and start a new analysis. 8. Automatic process to delete old records from the database. 9. Recording of deletions for audit and...

I have a requirement for someone well versed in Excel formulas and calculations, specifically with respect to tracking approaching dates. The main objective is to monitor upcoming deadlines. Ideal candidates should have: - Proficiency in Excel calculations and conditional formatting - Expertise in implementing algorithms to track deadlines - Strong attention to detail - Previous experience in project tracking or similar Your role would involve setting up the necessary formulas and conditional formatting to efficiently track these dates. Understanding the importance and urgency of deadlines, your input would greatly assist in managing our tasks better.

I'm experiencing issues with an Excel file that shows as 'We found a problem with some content...' when trying to open it. The file is 99.7 MB, which may be the issue. File is mainly contact details, text and photos. I've tried Excel's 'Open and Repair' tools with no success. I am aiming to work with an Excel expert who can recover the data without loss, if possible. The freelancer should have: - Intensive experience with Excel - A deep understanding of Excel file structures and experience in fixing corrupted Excel files - Familiarity with various recovery methods beyond just 'Open and Repair' I am looking forward to saving my data with your expertise. Let's discuss a potential solution ASAP. Please ...

I'm looking for an Excel expert to repair my medium-sized spreadsheet which is currently corrupted and crashes upon trying to open. Key tasks include: - Diagnosing why the file is crashing upon opening - Recovering both crucial data and restoring the original structure The success of this project is crucial as there is vital information that needs to be salvaged from the corrupted Excel file. Ideal freelancer should have: - Extensive experience working with large Excel datasets - Proven ability to recover corrupted files - Strong attention to detail to ensure all data and structure is accurately restored

Project Description: I need a developer to create a system that queries multiple external sources (18) through APIs, web scraping, and web page reengineering processes to extract information and structure it in the expected format. The system should generate a record of each query made, indicating whether results were obtained, no results were obtained, or if the source was not available. A document detailing all the sources of information from which data should be extracted will be provided. Main Features: 1. Automatic Querying of External Sources: Perform queries to multiple external sources according to the provided specifications. 2. Data Structuring: Process the obtained information and structure it in the required format. 3. Query Log Generation: Create a detailed log of all...

I'm in need of a proficient coder who specializes in regular expressions (regex). The goal is to extract specific data from a log file. Here are the task details: - Develop a regex expression to parse a log file - Specifically, I need to retrieve software name, version and install date Ideal Skills: - Strong experience with regex expressions - Understanding of log file structures - Attention to detail In your proposal, please include examples of previous similar projects.

excel assignment for an event study. template and example below

I'm in need of a professional accountant to handle my quarterly bookkeeping and financial statements. The ideal candidate should be well-versed in accounting principles and practices, have experience in bookkeeping and financial statement preparation. Familiarity with QuickBooks and Excel is crucial. Key responsibilities: - Perform quarterly bookkeeping tasks - Prepare accurate and timely financial statements - Maintain clear and organized financial records The successful freelancer will be consistent, detail-oriented, and able to meet deadlines. Experience with similar projects is a plus. Please provide your relevant experience along with your bid.

...successful conversions. *Drive Lead Conversion: Ultimately, our goal is to convert these leads into satisfied paying customers, driving tangible business growth. Desired Skills & Experience: Proficiency in lead generation and management across Facebook, Instagram, and Google Ads platforms. Demonstrated success in designing and managing effective lead capture forms. Strong analytical prowess to extract actionable insights from lead tracking and analytics data. Proven expertise in developing and implementing successful lead nurturing strategies. We invite you to share your relevant experience and outline specific strategies you would employ to help us achieve our objectives. Join us in shaping the future of our digital presence and driving impactful results for our business. ...

Develop macro-enabled Excel workbook

Data Entry from Scanned Business Cards to Excel We are looking for a highly meticulous data entry specialist to transfer information from approximately 2400 scanned business cards into an Excel spreadsheet. === Data Points to Include for Each Card: 1. Name, Position, Company, Phone (include all numbers, Fax (if available) and correct country code, Emails, Websites, Social Media Links, Address, City, Country ,PO Box, category of company 2. AND Any other available information on the cards === Requirements: * High accuracy is crucial; entries will be checked for spelling and number accuracy. * The partner needs to speak English fluently and in writing as well. * Images will need to be renamed at the end of the project to match the row of the card on the sheet * T...

I'm looking for a web scraping expert to help me gather personal profiles, email, and phone numbers from LinkedIn. The data I need should be based on broad search queries. Key Requirements: - Extract specific data: personal profiles, email and phone numbers - Data source: LinkedIn - Search type: Broad search query - Search criteria: Job title or role, Geographic location Ideal Skills: - Proficient in web scraping - Experience extracting data from LinkedIn - Ability to create custom search queries - Prior experience in gathering personal contact information

I'm seeking an expert in the field of data extraction from PDF files. Your responsibility will be to obtain the necessary content from a variety of PDFs diligently and accurately. Ideal Experience and Skills: * Proven track record in data extraction * Proficiency in dealing with PDF file formats * Attention to detail, for precise da...obtain the necessary content from a variety of PDFs diligently and accurately. Ideal Experience and Skills: * Proven track record in data extraction * Proficiency in dealing with PDF file formats * Attention to detail, for precise data extraction While the specific details required for extraction were not specified in the brief, it is expected that the suitable freelancer will have the skills to extract a wide range of content. Please bid wit...

As a website owner, I am in need of a freelancer to scrape the text content from the unstructured, plain text and HTML of my website's homepage. Tasks to complete for this project will include: - Identify valuable text data from the webpage - Create scripts or suitable methods to extract this text data - Clean and deliver the scraped data in a readable, usable format The ideal candidate for this position will be proficient in data scraping technologies, HTML, Python (or similar), and have the ability to work with unstructured data efficiently. Prior experience in a similar project and familiarity with data cleaning will be a huge plus. Please highlight any relevant experiences in your bid.

As an AI Engineer, I'm looking for a specialist to develop an AI system that is proficient in machine learning and computer vision. In particular, I need the system to excel in image recognition and data analysis. Ideal Skills: - Proficiency in machine learning and computer vision - Extensive experience with image recognition and data analysis - Skilled in Python, TensorFlow, and PyTorch The AI Engineer must also have a solid understanding of the Python programming language, as well as experience working with TensorFlow and PyTorch frameworks. The ideal candidate will be able to demonstrate a strong track record in developing and implementing AI systems that can successfully perform image recognition and data analysis tasks.

I require an extensive and careful research task to be undertaken for a list of 8,000 businesses across a region of the UK. I am looking for specific data points, such as: - Names of Managing Directors - Their respe...in accurate data collation and verification and be well-versed with up-to-date UK business registries or databases which must include the businesses website and LinkedIn. A keen attention to detail is necessary, as I require accurate, reliable data. Prior knowledge of UK businesses, particularly management hierarchy, would be advantageous. All information is to be delivered in an easy-to-read Excel spreadsheet format. Note: For the task at hand, focus needs to be put on only current Managing Directors and/or Business Owners. I do not require information on any other ...

I am in need of a skilled professional who can provide the following accounting services using Excel: - Preparation of Financial statements - Cash flow analysis - Financial statements analysis You will be ideally proficient in Excel-based financial modeling and analysis, understanding how to manipulate and interpret data to present clear, concise, and informative reports. A solid background in accounting will ensure accuracy in financial statement preparation and analysis. Your ability to meet deadlines with minimal supervision will be a crucial factor for success. Existing familiarity with my current accounting software, Excel, is mandatory. A background in business finance or related fields and demonstrated experience in similar roles will be viewed favorably. ...

I am seeking for a skilled web scraper who can effectively extract product information from online catalogs on a website. The aim here is quite straightforward; we need to gather and download catalogs to enrich our store's database. To further specify, the data in question include: - Product Images - Product Descriptions - Pricing Information - Category Details You will be tasked to focus on all categories available on the website. As such, proficiency in navigating various website blockades is a must. Your ability to deliver comprehensive, detailed, and accurate information in a well-structured format is crucial to this job. Prior experience in similar e-commerce web scraping projects would be a great advantage. Look forward to your bids. Thanks in advance!

I need a skilled web developer to duplicate 785 WordPress pages within 1 hour. The project involves customization of the URL and page title to align with specific city names provided in an Excel sheet. Key Requirements: - Duplicate 785 WordPress pages quickly and accurately - Customize the URL and title of each page according to its respective city - Ensure that the formatting and layout of the duplicated pages remain consistent with the original - Provide a high level of detail and accuracy to maintain the integrity of the multi-location business promotion strategy Ideal Skills and Experience: - Proficiency in WordPress and web development - Ability to work quickly and accurately under time constraints - Strong attention to detail to ensure correct customization of each page - Ex...

I'm seeking a competent developer to construct an AI-powered chatbot for my WordPress website. This project requires a colorful and creative design that can effectively balance its vibrant nature with its functions. This chatbot should excel in: - Customer support: Ability to resolve queries, troubleshoot, and provide live assistance to customers. - Lead generation: Capability to initiate conversations and attract potential customers. - Appointment scheduling: Seamless calendar synchronization for hassle-free appointment bookings. - Marketing & Promotion: Efficient in promoting services or products, generating interest, and ushering in sales. - Order Exchange & Processing: Capability to handle orders, process them and ensure smooth transactions. - FAQs: Encompasses a...

I'm seeking a competent developer to construct an AI-powered chatbot for my WordPress website. This project requires a colorful and creative design that can effectively balance its vibrant nature with its functions. This chatbot should excel in: - Customer support: Ability to resolve queries, troubleshoot, and provide live assistance to customers. - Lead generation: Capability to initiate conversations and attract potential customers. - Appointment scheduling: Seamless calendar synchronization for hassle-free appointment bookings. - Marketing & Promotion: Efficient in promoting services or products, generating interest, and ushering in sales. - Order Exchange & Processing: Capability to handle orders, process them and ensure smooth transactions. - FAQs: Enco...

As an organization, we are seeking an experienced Data Analytics & MIS Executive to handle critical tasks in the realm of data analysis and MIS. Key Responsibilities: - Conduct in-depth data analysis - Generate regular and ad-hoc reports - Optimize our data systems Skills & Experience Required: - Proficiency in Excel - Proficiency in Power BI - Experience in working with sales data - Experience in working with customer data - Experience in working with EV Car booking data Your role will involve using your analytical skills to interpret complex data and generate insightful reports. You'll also be responsible for ensuring that our systems are optimized for maximum efficiency. The ideal candidate for this role should be a highly skilled professional with a proven track...

I am in need of an artist with a flair for traditional art styles to create an emotionally stirring cover art for my song. It's important that the artwork fully embodies a melancholic sentimentality. (You can create it with AI and combine artist face in it) Key Requirements: - Proficiency in capturing emotion through traditional art mediums - An ability to extract and interpret key events from music - Ability to translate the song's pivotal moment into a compelling visual narrative Bring this song's dramatic climax to life in a somber, moving piece of art. Experienced music interpreters and those with a talent for storytelling in the visual arts would be a natural fit for this project. Proven track record in delivering high quality traditional art pieces is a mus...

You will be required to Copy technical part number from PDFs to excel file. Most of the files have copy paste enabled. I have around 400 PDFs. The brief provided will be very precise and easy to follow. Its a long term project. Will have projects on monthly basis If you understand what we are looking for. A fairly simple project with easy guide to follow through

I have a pressing need to transfer a large quantity of image files. Key Requirements: - Data Transfer: You will be tasked with swiftly transferring a substantial number of image files. - Organization in Excel: Following the transfer, you should organize these images in an Excel document. While this is not a conventional method for handling images, it is a specific requirement for my project. Ideal Skills: - Proficient in Data Transfer: You need to be skilled in transferring data swiftly and accurately. - Excel Expertise: You should have experience in using Excel to organize and manage files. Timeframe: - I would prefer this project to be completed as soon as possible. Please only apply if you have the necessary skills and capacity to deliver on this urg...

I need a Excel macro that can scrape data from a https://www.ebay.com. The Excel macro should be set to run whenever want to update the data in my spreadsheet. Excel should have Product Name Product UPC Product SKU It will then go to find that Product I want excel macro - list with the number of watches/shoes for that item