Excel macro cell format dataงาน
...skilled freelancer who can help automate various tasks in Excel. This includes, but is not limited to, data entry, formulas, and calculations. Key responsibilities: - Automating data entry processes within Excel - Implementing advanced formulas and calculations to streamline calculations - Generating reports and carrying out data analysis using Excel - Ensuring the accuracy and integrity of automated processes Ideal skills and experience: - Proven experience in automating tasks in Excel - Advanced knowledge of Excel functions and formulas - Ability to understand complex data sets and create accurate reports In your application, I'd like to see: - Examples of similar projects you've worked on - Details of your ex...
Develop a chatbot with a web chat interface using the Llama 2 7bn LLM model to assist users in resetting their passwords. The chatbot will interact with users to collect verification details (employee number, name, date of birth, boss's name, and last four digits of cell number) through a structured conversation. The system will validate user inputs against an API and terminate the conversation after three invalid attempts. Upon successful verification, a text message with the new password will be sent via an external API. The project will include creating APIs for future speech input/output integration, ensure response times under 1.5 seconds, handle multiple simultaneous users with unique identifiers, and provide customizable response messages. The system will be deployed on ...
I am seeking an expert in data entry, particularly in the tasks of document conversion, data processing, and data verification. This role necessitates the management of confidential and sensitive information, hence, a demonstrated respect and understanding for data privacy is paramount. Key Responsibilities: • Document conversion • Data processing • Data verification Required Skills and Experience: • Proficient with MS Excel • Demonstrated experience in similar roles handling sensitive data • Strong attention to detail • Respect for privacy and confidentiality Note: Familiarity and experience with utilizing formulas and pivot tables within Excel are highly desirable, given the nature of t...
I need a skilled video editor who has experience in creating AI videos and is proficient in adjusting videos to various aspect ratios. The primary task is to edit a video for social media promotion across Facebook, Instagram, and YouTube, ensuring it's optimized for each of these platforms in both horizontal, vertical, and square formats. Key...Key Requirements: MUST WORK IN ADOBE PREMIERE AFTER EFFECTS - AI video editing proficiency - Extensive experience in social media video optimization - Ability to adapt video to vertical, horizontal, and square formats - Understanding of social media platform video specifications The edited videos for each platform should be done in different lengths. Prior experience in creating similar multi-format social media video content is def...
I need assistance with copying & pasting data from spreadsheets. The dataset is less than 1,000 entries. Ideal skills and experience for this job: - Experience with data entry, especially from spreadsheets - Attention to detail - Proficiency in Excel - Ability to meet deadlines It's a straightforward task. The goal is to ensure the data is accurately copied and pasted.
I need an experienced Excel programmer to automate repetitive tasks and create custom VBA macros for my project. This assignment requires basic level tasks, so extensive experience in complex macros isn't necessary. Here is what I expect: - Automation of several repetitive tasks to streamline workflow and increase productivity - Creation of custom VBA macros from scratch Ideal Candidate: - Extensive experience with Excel automation and VBA macros - Ability to comprehend and successfully complete basic level assignments - High attention to detail and accuracy Please include your Excel automation and VBA macros experiences in your application. I look forward to working with you on this project.
I'm looking for a professional to help me format my Kindle e-book and design a cover. Key requirements: - Experience in creating e-books for Kindle - Proficiency in cover design - Ability to deliver a polished, professional product Please note: The content of the e-book is already completed, so the main focus will be on formatting and cover design. If you have a portfolio of previous e-books you've worked on, it would be great to see.
I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample
I'm in need of a reliable data entry professional to input a mix of text, numeric, and image data into a spreadsheet. The job involves inputting between 100 to 500 entries. Ideal Skills: - Proficiency in data entry with a strong attention to detail - Ability to handle different data formats (text, numeric, and images) - Experience in spreadsheet software, ideally with knowledge of conditional formatting and data validation. The data may need to be sorted and organized, so any experience or skills in data organization are a plus. It would be beneficial if you have a basic understanding of different types of data and their implications for the final use of the spreadsheet. Please be prepared to propose a basic template or f...
Functionalities of desktop application: 1: scan any buttons fields used computer vision or openai vision or Google gimini to recognize fields or buttons 2: creator record macro auctions in same time record/uploading voice and notes 3:export files then shared the files with others that have same desktop app Output: macro working without in others that have same desktop
I need a professional to format a Chicago bibliography for my assignment from a list of journal article links and website links. Key Requirements: - Chicago Style: The bibliography should adhere strictly to the Chicago citation style. - Journal Articles: You will be formatting the references primarily from journal articles. - No Annotations: I do not require any annotations, just the citation for each source.
Functionalities of desktop app: 1: scan any buttons fields used computer vision or openai vision or Google gimini to recognize fields or buttons 2: creator record macro auctions in same time record/uploading voice and notes 3:export files then shared the files with others that have same desktop app Output: macro working without in others that have same desktop
Functionalities of Chrome extension : 1: scan any buttons fields used computer vision or openai vision or Google gimini to recognize fields or buttons 2: creator record macro auctions in same time record/uploading voice and notes 3:export files then shared the files with others that have same chorme extension Output: macro working without in others that have same extension 4: deployment on marketplace
I'm in need of a professional designer to create a 24-page A5 booklet for my estate agency. I want the design to be traditional and elegant, as our target is to attract new potential clients. Key Requirements: - The booklet should be 24-pages long, a5 sized (6 a4 sh...real-estate market in our locality. Skills and Experience: - I expect the designer to have experience in creating similarly styled elegant and traditional designs. - A good understanding of the real-estate market or experience in designing for estate agencies would be a plus. - The designer should be able to translate information on local property values into a visually appealing and engaging format. If you think you're up to the task, I'm eager to view your portfolio and hear your ideas on how you...
I'm seeking an experienced Excel wizard capable of making my inventory report more dynamic and adaptable. Here's what I need: - Total Calculations: The report doesn't currently update the total inventory count and monetary value when I adjust the count of individual items. I require this to be automated so the totals are accurately recalculated whenever an inventory count changes. - Regular Updates: Going forward, I will be regularly updating inventory counts on a weekly basis. I would appreciate if the system is simplistic and user-friendly for regular updates. Ideal Freelancer Skills: - Advanced knowledge of Excel functionalities - Experience on inventory management systems - Meticulous attention to detail - Ability to create user-friendly systems. The o...
I'm looking for a skilled engineer who can design a self-supported steel chimney for a metal manufacturing plant. This chimney will be integral to industrial emissions control. Tasks Include: - Tailoring the design to accommodate the specific needs of a metal-manufacturing environment. - Incorporating robust safety features and compliances for high-temperature metal emissions. Ideal skills: - Structural Engineering - Industrial Design - Knowledge of industrial emissions standards - Experience with metal manufacturing processes.
I have a small project that involves typing less than 100 pages of handwritten documents into Microsoft Word. I need a skilled typist with exceptional attention to detail. Key Requirements: - Typing of less than 100 pages of handwritten documents into Microsoft Word - Ensuring accuracy and maintaining the original format to the best extent possible - Proficiency in English to ensure the typed content is error-free Ideal Skills: - Experience in data typing, particularly from handwritten sources - Proficiency in Microsoft Word - Strong English language skills for editing and proofreading I am looking for a professional who can deliver this project accurately and efficiently.
...and the Apple App Store. Edit the videos to highlight key features and provide a smooth, engaging experience. Deliverables: Screenshots: 10 screenshots for each Android device. 10 screenshots for each iOS device size (6.7", 6.5", 5.5", 13", and 12.9"). Screenshots must be in PNG or JPEG format. Videos: 2 demonstration videos for Android devices in MP4 format. 3 demonstration videos for each iPhone size (6.7", 6.5", and 5.5") in MP4 format. 3 demonstration videos for each iPad size (13" and 12.9") in MP4 format. Edited versions of the videos meeting the app stores' requirements. Skills Required: Proficiency in using both Android and iOS devices. Experience in capturing and editing screenshots and videos....
...papers - containing approx 50 questions each. For each question, I need someone to: - cut & paste an image of the question into a Google slides / Powerpoint document - 1 question (or sub-question if it requires a different skill per page - 1 document for each paper - name the skill(s) that are required to answer each question - as the title for each page - create a new line in a Google Sheets / Excel document with the following information: - skill required (copied from title of Google Slides document) - page number of Google Slides document that the question appears on Key Requirements: - The questions are from primary school level math exams, so a good understanding of these topics is crucial. - You will need to effectively categorize each question based on th...
...specific text content from a website on a weekly basis. The scraped data should be efficiently saved to a CSV or Excel file for easy review. Capable of being plugged to a distribution app. Key Requirements: - Develop a Python-based web scraper that targets a website to extract text data - The scraper should be designed to run on a weekly schedule - Ensure that the code is concise and easy to understand for potential future modifications - Store the scraped data in a CSV or Excel file format Skills and Experience: - Proficiency in Python programming - Experience with web scraping libraries such as BeautifulSoup or Scrapy - Understanding of scheduling tasks in Python - Familiarity with working with databases, especially CSV or Excel file...
I'm looking for a proficient Excel professional to develop a multi-country income tax calculator. This tool will primarily serve individual taxpayers, and potentially other user groups. Key Requirements: The calculator should support income tax calculations for multiple countries. This requires a deep understanding of tax laws and calculations in each country. - The tool should be user-friendly and intuitive, catering to users with different levels of tax knowledge. - It should be well-structured, with separate sections for each country to avoid any confusion for the end-users. Ideal Skills and Experience: - Advanced Excel proficiency, with experience in creating complex calculators or financial models in Excel. - In-depth knowledge of income tax laws and ...
I need an expert to develop a macro tailored to automating report production tasks in Microsoft Excel. The main purpose of this project is to streamline the process of regular report production and increase overall efficiency. Ideal skills and experience include: - Proficient in Microsoft Excel - Experience in macro development to automate tasks - Knowledge in automating report production Your role will involve designing and implementing a suitable macro for regular report production in Excel. I'm looking for someone who can provide a timely and efficient solution.
Hello, I'm looking for a professional developer who can create an app for Android camera that can receive live video streams from OBS and broadcast them directly onto the primary screen of the smartphone's camera. The app should be able to convert the stream sent from OBS into a format compatible with the phone's primary camera and display it in high quality. The app should be capable of playing the video directly without the need for an external application, but I need a skilled developer with experience in integrating with OBS and efficiently programming the app. The app should be compatible with the latest versions of the Android operating system. Please provide a detailed quote along with a timeline for delivery if interested. Thank you.
I'm in need of a freelancer who can create a realistic profile picture for my gaming platform account. The profile picture should be: - Realistic: I'm looking for a design that captures a lifelike quality. - Original: I don't want the design to be based on a photo I provide. I'm looking for a unique and creative concept. - Gaming Platform Ready:...looking for a unique and creative concept. - Gaming Platform Ready: The design should be tailored for use on a gaming platform. Ideal skills and experience for this job include: - Strong illustration skills with examples of realistic designs in your portfolio. - Ability to come up with original and creative concepts. - Understanding of design requirements for a gaming platform, such as size and format. Looking for...
I'm currently in need of an experienced image editor proficient in working specifically with JPEG files. The main tasks include: - Image cropping - Image resizing - Adding various image filters While I have not elucidated the purpose of the image editing, I anticipate the ...main tasks include: - Image cropping - Image resizing - Adding various image filters While I have not elucidated the purpose of the image editing, I anticipate the need for versatility in tackling a range of potential projects and tasks. Hence, adaptability and broad skills are strongly preferred. Ideal experience and skills: • Extensive image editing background • Familiarity with JPEG file format • Diverse portfolio demonstrating adaptability • Track record of meeting deadlines and...
I have a sizable amount of numeric data that needs to be inputted from handwritten documents. This is a meticulous task that requires attention to detail as the data must be entered accurately. Key tasks include: - Transcribing data from handwritten documents into a digital format. - Ensuring the data is accurate during the entry process. Skills/Experience required: - Proficient in data entry, especially numeric data. - High level of accuracy and attention to detail. - Previous experience with handwritten document data entry is preferred. - Understanding and application of data validation techniques.
I'm in need of a talented video editor to assist me in creating a promotional video. The video is aimed at showcasing our products and services in a documentary-style format. Key Requirements: - The video must be engaging and professional, while maintaining a subtle promotional tone. - No voice-over is needed, so the editing should focus on visual storytelling and flow. - It's crucial that the final cut reflects our brand and values, therefore attention to detail is a must. Ideal Skills and Experience: - Proven experience in creating documentary-style promotional videos. - Proficiency in video editing software. - A keen eye for detail and storytelling. - Understanding of branding and promotional content. If you have any previous work that aligns with this project, plea...
I'm seeking a skilled virtual assistant with proven communication abilities, to work specifically in US timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand profess...virtual assistant with proven communication abilities, to work specifically in US timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand professionally and persuasively when bidding on projects. - Communicating with leads: You'll be responsible for using various messaging platforms to engage with potential clients and leads. Ideal candidates should excel in written communication and have a knack for sales. Proficiency in project management tools is a plus. Our preferred mode of communication with leads is through ...
Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.
I need a tool that will help me process a large amount of images by cropping them automatically to a landscape format. Project UI Link: Key Features: - Image formats supported: JPEG, PNG - Output dimensions: landscape (width > height) - Automatic detection and cropping of the main subject of the image is preferable or that can be selected as need. Ideal Freelancer: - Proficient in image processing and recognition - Experience with automation scripts - Strong background in image data manipulation - Familiarity with JPEG and PNG file formats. If you have the skills and experience necessary to develop such a tool, please get in touch.
I have a set of handwritten documents that are moderately clear and need to be typed out without any changes in the format. I am looking for an experienced typist or data entry specialist for this project. The successful candidate should: - Have a strong proficiency in English - Be able to decipher moderately clear handwriting - Be patient and detail-oriented The task is to accurately transcribe the content of the handwritten pages into a digital document, without any alterations in the layout. Your responsibility is to provide me with a neatly typed, error-free version of the original handwritten text. Please note that the quality of the output will be checked against the original, hence, accuracy is paramount.
I need help with data entry and formatting for a Google Sheet. The data is to be sourced from ONLY 1 Website. Key Tasks: - Copy-pasting text information and images or screenshots from Website 1 into a Google Sheet. - Formatting the data in the Google Sheet with columns and tables. Ideal Skills: - Proficiency in data entry, specifically with Google Sheets. - Strong attention to detail to ensure accuracy and completeness of the data. - Ability to organize data efficiently using columns and tables along with images etc for capturing the User flow in a tree form . Example the website has Question 1 and N number of responses. Based on the responses there are different questions based on the responses. Need to capture that in a tree format.
...investors, and stakeholders Responsibilities: Collaborate with our team to understand the project requirements and objectives Develop a creative and engaging storyboard based on the provided script Create high-quality animations that align with our brand and project goals Incorporate feedback and revisions as needed to ensure the final product meets our expectations Deliver the final animation in a format suitable for online sharing and presentations Requirements: Proven experience in creating animation videos, preferably for software or tech projects Strong portfolio showcasing previous animation work Proficiency in animation software (e.g., Adobe After Effects, Blender, etc.) Ability to work independently and meet deadlines Excellent communication skills to collaborate effect...
The project consists of an AI-based booking platform that receives booking orders from various text sources. The text does not have a predefined format. The AI analyzes the text to generate the corresponding booking order in a predefined format, enabling integration with a small ERP software. Input and output data must be defined and calling functions created in C# if required. The AI is desired to be working on a private local server running Microsoft Windows Server.
I am seeking a skilled and experienced designer who can h...color scheme will be essential in our rebranding process, helping us to align our products with the new brand identity. Ideal Skills: - Extensive experience with Photoshop, particularly with the Hue/Saturation tool - A good eye for aesthetic improvements - Experience with product image editing or e-commerce Deliverables: - All files should be high-resolution(similar to original photos) and in a format same as given image not same as sample color image. Please let me know if you're proficient with Photoshop and have experience with similar projects. I'm looking forward to seeing examples of your past work. Attached Zip file of images. It includes 12 colour variations and 2 products. It means, total 24 variatio...
Project Title: Service Architecture Diagram for Project Beta (Open-source format) Project Description: Project Beta, seeks a qualified freelancer to create a Service Architecture Diagram for our business. This diagram will visually represent the flow of data and interactions between various components within our system. See project requirement doc attached
I need help with my Microsoft Excel project! Specifically, I require assistance with the following: - **Formulas and Functions:** - Basic arithmetic operations. I don't need anything too complex, just fundamental formula structures. - **Automation:** - No macros for repetitive tasks are required, but I need guidance on setting up conditional formatting rules within the document. I'm looking for a Freelancer who is experienced in Excel and is comfortable with basic arithmetic operations and conditional formatting. You should be able to provide clear, concise, and easy-to-follow guidance. A strong attention to detail and excellent communication skills are a must. If you're proficient in these areas, I'd love to hear from you!
I have a file sourced from the internet that was originally in a landscape format, but I need it to be converted into a portrait layout for a poster design. I need this new file to be compatible with CorelDRAW without losing any pixel quality. Requirements: - Convert a landscape design to a portrait layout - Ensure the new file is compatible with CorelDRAW - Maintain high quality and pixel resolution throughout the conversion Ideal Skills: - Proficiency in graphics design - Experience with CorelDRAW - Ability to maintain high-quality resolution - Strong understanding of design principles & layout Please let me know your background in graphics design and any similar projects you've worked on.
I require data entry services targeting both English and Malayalam languages for a medium volume of content sourced from digital files. As such, potential bidders should have the following: - Proficiency in written Malayalam and English to ensure accurate and efficient data entry. - Basic IT skills to navigate and extract data from digital files. - Attention to detail, ensuring data is properly entered without errors. - Experience in the field of data entry, especially if done in multiple languages. Your role will primarily involve transferring data from digital files into our designated format. Please state any relevant experiences or skills in your bid.
I am seeking a proficient and articulate PowerPoint wizard to create a specialized template. It should be capacious to showcase over 20 projects with their respective details in a stylish and easily comprehensible format for senior leadership. Ideal skills and experience: - Proficient in PowerPoint design features - Demonstrable experience in infographic and layout design - Expert in using color combinations to develop engaging slides Key Requirements: - Color scheme: Blue and white is the preferred choice for the PowerPoint slide template. - Project Detailing: Each project should display its Title, Timeline, Key Milestones, Goals, and Challenges. - Organization: Projects should be organized on the PowerPoint slide template based on project status (completed, ongoing). Your de...
...page. The collected data should be simultaneously sent to GoHighLevel (GHL) CRM for automated text and phone call follow-ups, as well as to an Excel sheet for manual review and further action. Key requirements: - Pixel Integration: Develop and implement a pixel solution that captures lead data. - Real-Time Collection: Ensure the system collects data instantly when a lead lands on the specified page. - GoHighLevel (GHL) Integration: Connect the system to GHL for automated text and phone call follow-ups. - Excel Integration: Enable the system to send collected lead data to an Excel sheet via email. Ideal skills and experience: - Proficiency in WordPress and pixel integration. - Experience with CRM systems, particularly GoHighLevel (GHL). ...
I'm in search of a skilled WordPress...creating personalised news media content and working with API content feeds is a must. - **WordPress Development Expertise:** Proficiency in WordPress development is essential. - **E-Commerce Skills:** Understanding of e-commerce functionalities and payment gateway integration. - **Marketing and Analytics Experience:** Knowledge of inbound and outbound marketing strategies, data collection (email addresses, cell phone numbers) and data measurement is required. You will need to be able to set and achieve traffic and revenue targets and earning comission and success fees as part of an on going contract renumeration. Need someone that wants to make a fair base hourly rate andcearn large success fees from traffic flow gains an...
...demonstrating the process of account creation, duplication, and management. Objectives: To illustrate the ease of use and efficiency of for agencies. To demonstrate key features such as account creation, account duplication, and seamless account management. To encourage agencies to sign up for by showcasing its comprehensive toolset. Video Specifications: Length: Approx. 2 minutes Format: High-definition quality, suitable for both web & social media platforms and mobile viewing. Style: Modern, professional, with a direct focus on walkthroughs and screen captures of the platform in use. The color scheme for the video and logos will be attached as a separate document. Audio: Background music should be uplifting but not overpowering. Music should be royalty-free or licensed...
I need a freelancer to help me gather phone numbers from clothing stores in County . You'll be provided with the location and shops to focus on. Key Responsibilities: - Utilize street view to identify shops - Collecting phone numbers of all such shops - Organize and input these numbers into an Excel spreadsheet Ideal Skills: - Proficient in using street view and other location tools - Detail-oriented and capable of data entry - Comfortable using WhatsApp for communication This is a straightforward project, but attention to detail is crucial. Feel free to reach out if you have any questions.
...management. - Expert knowledge of various safety threats and first-hand experience in planning for and mitigating these issues at events. - Excellent crisis and crowd control management skills. - Relevant qualifications in safety and emergency management NEBOSH ICG as minimum - excellent communication management - experience in generating reports - advanced Microsoft skills particularly in (words, excel and power point) Your role will be pivotal in ensuring our events are safe, enjoyable and error-free. The ideal candidate will anticipate issues before they arise and resolve them swiftly when they do. Your proficiency in maintaining safety at massive events will be the key to a long-term partnership. Location: KSA Period: 3 months (extendable) Commencing approx: Aug-Sep 2024...
...configurable conditions. It should facilitate easy data input from Excel and offer detailed comparisons, with the ability to export results to Excel. Offer Creator: The freelancer should create functionality for users to customize sales offers by selecting and modifying purchase conditions, adjusting margins, and generating offer views exportable to Excel. Order Recording: Develop a user-friendly interface for recording orders by selecting sales and purchase offer IDs, entering customer-requested details, and generating informative tables for efficient processing. Inquiry: Enable users to upload customer lists for comparison with purchase prices, configure margins, and calculate selling prices directly. The module should support export to Excel...
I am in need of an expert in B2B lead generation to help me with a specific project. The task involves targeting a local area for potential angel and private investors for an H.M.O in the health sector. Key Job Requirements: - Identify and co...potential angel and private investors for an H.M.O in the health sector. Key Job Requirements: - Identify and compile a list of 50-100 angel or private investors from the local area. - Investors must have a previous history of investing in the health sector. - Delivery of the leads in an Excel spreadsheet format. Ideal Candidate: - Proven experience in B2B lead generation. - Good knowledge of the health sector and investment trends. - Excellent research skills. - Proficient in data management and Excel. - Strong commun...
I'm seeking a skilled video editor for my YouTube channel. The goal is to convert my existing video content into engaging, fast-paced 1-minute clip...overlays or captions throughout the video - Ensuring the final product is suitable for YouTube and other social media platforms Ideal skills and experience: - Proficiency in video editing software (e.g. Adobe Premiere Pro, Final Cut Pro) - Previous experience in creating short form content for YouTube or other social media platforms - Strong understanding of pacing and storytelling in a short format - Ability to use text overlays and captions effectively - Understanding of YouTube content guidelines and best practices If you're a creative and experienced video editor who can bring energy and engagement to my content, I'...
I have a PSD design that I need converted to vector files. These will be used for printing on medium-sized signage. Key requirements: - Conversion from PSD to vector format: The original design is in PSD format and needs to be converted to a vector format suitable for printing on medium-sized signage. Ideal skills and experience: - Proficiency with Adobe Illustrator or other vector design software - Experience with preparing graphics for printing - Understanding of color profiles and print resolution - Good communication to ensure the final vector files are suitable for my printing needs