Excel macro cell format data jobs

I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.

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

...Store the JWT token in the browser's localStorage or sessionStorage • Interception of HTTP Requests:  Use Axios interceptors to add the JWT token to the header of all requests. Handling ERROR and SUCCESS Messages with Pop-ups • Error • Success Credit Card Tokenization on the Front End • Use API to tokenize credit card information before sending it to the backend Device Responsiveness • Cell phone • Desktop • Notebook • WideScreen Monitors • Tablets Pagination of Cards on the HOME Page and SEARCH RESULTS Page • Pagination Implementation: Use a pagination library like react-paginate . Organization of Cards, according to the Filters Used in the Search Results • Available Filters:  Category  Price  Location  Avail...

...tackle a variety of issues. I need several files repaired and converted to SVG format. The files in question span across icons, images, and phrases, and have issues such as pixelation, blurriness, and distortion. These files will primarily be used on my website. Key responsibilities include: - Identifying and rectifying pixelation, blurriness and distortion issues in multiple icons, images, and phrases - Converting these files to high-quality SVG format - Ensuring the repaired and converted files are suitable for website use Ideal candidates should have: - Proficiency in repairing and converting a variety of file types - Experience in dealing with pixelation, blurriness, and distortion issues - Knowledge of SVG format, and its specific requirements for web use - A...

I need to set up a system to parse semi structured emailed reports into structured format. Could build custom solution or simply help me set it up on an existing service such as mailparser.io.

I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines

I'm in search of an experienced CISSP certified instructor with an advanced level of knowledge. The ideal candidate should be able to deliver these classes in an in-person format. Key Training Areas: - Security and Risk Management - Asset Security - Security Architecture and Engineering I need someone who can provide thorough explanations and practical examples of these topics. Your role will be to break down complex concepts into understandable parts for the students. This means ensuring the content is clear, concise, and engaging. Ideal Skills and Experience: - Advanced CISSP certification - Experience in in-person training - Strong communication and presentation skills - Ability to simplify complex ideas - Understanding of adult learning principles Please only apply if ...

...requirements: - Maintain high level of detail: The STEP file should preserve all intricate details of the original design, especially for complex assemblies. This is crucial for my CAD software to work seamlessly and accurately. - No post-conversion modifications: I do not need any modifications made to the design after the conversion. The primary goal is to simply have the file converted to STEP format. Ideal Skills & Experience: - Proficiency in CAD software and file formats: Experience in converting files from STL to STEP and knowledge of the intricacies of these formats is essential. - Attention to detail: The final converted file should reflect all the details of the original STL file, especially for complex assemblies. Please provide examples of similar work you'...

I am looking for a professional with expertise in color grading and correction to edit a short video less than 5 minutes in duration. The raw footage is in iPhone & DJI Drone format, and I require an experienced eye to enhance and uplift the visuals, making them appealing and vibrant. A strong proficiency in video editing software and an artistic sense for colors are critical. Skills and experience required: • Expert with color grading and correction techniques. • Experience working with iPhone & DJI Drone video formats. • Proficient with mainstream video editing software. • Artistic sense and understanding of color theory. I will send you footage that I need edited into short clips for social media.

I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.

I need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attention to detail to ensure accurate tran...

**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be required. 1 being password and field protected and t...

Please Sign Up or Login to see details.

Hi Md Zoherul I.,I need 26 signs made. 18 hole just like a golf course. 12"x18" I will send you the old signs to use to create newer version signs. I will need these in vector format.

The purpose of my project is to create an 'about us' video that highlights the services my academic servic... specifically in the domain of mouse model utilization. The video will majorly showcase the phenotypic analysis services and the various studies we conduct using animal models for research. The content must be tailored in a way that caters to our target audience which includes researchers, academic institutions, and government officials. This would involve presenting complex information in a format that is easily understandable by both scientific and non-scientific audiences. Skills required: - Expertise in video creation and editing - Understanding of scientific research, specifically dealing with mouse models - Ability to communicate complex concepts in a simp...

...content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm looking for someone who can create a tool that not only collates data...

I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.

I require an expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to Detail: The work involves handling a large amount of ...

...seeking a skilled illustrator to create unique minimalist abstract designs for use in a digital platform. - Responsibilities: - Create unique, original abstract designs in a minimalist style. - Collaborate on design direction, aligning with existing aesthetics and guidelines. - Ensure a sizeable resolution suitable for clear digital display - Deliver final work in a suitable digital format (.png, .jpeg etc.) - Desired Skills and Experience: - Proven experience in creating abstract designs, particularly in a minimalist style. - Strong portfolio showcasing design versatility and creativity. - Familiarity with digital platform requirements. - Receptive to feedback and focused on creating client satisfaction. I anticipate a series of these illustr...

I need a professional sound engineer to perform three main tasks on an audio file that exceeds 5 minutes in length. The original audio file is in MP4 format. The tasks include: - Removing background noise and interference, - Fixing audio distortion, - Enhancing the overall clarity of the audio. Ideally, the person for this job has experience in audio editing, sound engineering, and professional software for audio clean-up. Previous work with MP4 audio files will be preferred. This task requires precise and careful attention to audio details.

I need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want to use “setup&...

...currently available in JPEG format. I don't need any redesigning, just a simple resizing to ensure that they scale perfectly for large flags. The flags will be used both indoors and outdoors, so the resolution needs to be top-notch. Key Requirements: - Convert four JPEG logos into high-resolution files - Ensure the logos are suitable for large flag printing - Keep the original design of the logos intact - The logos should be scalable without any loss of quality Change the color of the black flag to a nice green. Ideal Skills and Experience: - Proficient in graphic design and image editing - Experience with logo resizing and conversion to high-resolution formats - Understanding of print design and resolution requirements - Previous experience with flag design or large-fo...

...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...

Please Sign Up or Login to see details.

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 am in need of professional help to bring structure and uniformity to my extensive Word document, which is 60 pages. The scope of work will include: - Text and paragraph layout adjustment: This involves ensuring proper alignment, indenting, and spacing across the entire document. - Consistent formatting: I want the document to maintain a uniform format throughout, with common styling in terms of font size, type, text color, and more. The ideal freelancer for this job would have excellent attention to detail, a high degree of proficiency in Microsoft Word, and a background in editorial work or document design. Experience with large word documents is a plus. Your commitment to delivering work on time alongside quality is paramount.

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.

I have a few guitar tabs that I'd like converted into the Rocksmith format. - The tabs can be a mix of genres. - I need these tabs to be converted to Rocksmith format, so that they can be easily playable within the Rocksmith software. - The guitar tabs may not be in standard tuning, so a knowledge of different tunings and how to adapt them for Rocksmith is preferred. Ideal skills and experience for this project include: - Proficiency in guitar. - Experience with Rocksmith and how to convert tabs to its format. - Knowledge of different guitar tunings and how they can be adapted for Rocksmith.

...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.