Excel macro check data format jobs

I'm in need of an expert in Excel with a strong command of mathematical calculations, conditional formatting, and data analysis. You will be primarily working with numeric and date/time data. Key requirements: - Mastery of mathematical calculations within Excel - Proficiency in using conditional formatting - Solid understanding of data analysis techniques The outcome of this role involves: - Generating comprehensive reports from complex data - Automating tasks for increased efficiency Experience in automating tasks and generating reports within Excel is highly valued.

Please Sign Up or Login to see details.

Hi, Please bid if you are available today and complete this in next 2 hours. It is a very quick task for a person who has good hands in After Effects. We have one source files of GIF and we need to export into JSON format so that it can be integrated with our web app. Thanks

I need a proficient Excel professional to handle some text data entry tasks, specifically focusing on detailed product descriptions. Your main responsibility will be: - Inputting product specifications into Excel spreadsheets The ideal candidate must have a keen attention to detail and excellent Excel skills. Knowledge in product specifications will be a great advantage. Please submit your bid with any relevant data entry experience and we can discuss further.

I require an experienced data entry specialist with proficiency in Microsoft Excel to assist me. The tasks involve: - Inputting and organizing relatively small amounts of data (less than 100 rows) - Analyzing data and generating reports Ideally, the freelancer should be familiar with Excel formulas and macros. Good data interpretation skills and attention to detail are needed to accurately analyze and reports the results. A capacity for hard work is also appreciated, as I am dedicated to this work and will need someone who can keep up.

I have a existing logo and I need a proficient graphic designer to create logos, icons, and a LinkedIn banner suitable for Facebook, Twitter, and LinkedIn with the same brand color. Key tasks include: - Creation of optimized logos and icons for Facebook and Twitter. - Design a banner for LinkedIn that aligns with my existing branding. - Implement brand colors consistently but creatively acro...any applicant will be experienced in graphic design and social media branding, with a portfolio demonstrating clean, professional design ethos, and a keen eye for brand aesthetics. Time management is essential as I require this project to be completed as soon as possible. Note: Create images of different size and formats such as jpeg, jpg, png Provide all the sources files along with original ...

Hi, I recently posted a project regarding funding rates, but understood my briefing needed to a bit more clear. See below. Goal: improve reliability of strategy, by adding funding rates to strategy and backtest. Requirements: 1. Retrieve funding rates of Bitmex - Available in draft code (see attachment...paid/received. Example: if in a leveraged position for 47 hours, 5 complete funding rounds are applicable (not 6). - The asset traded (BTC/USD) is held as collateral (BTC). First Long position is not leveraged. No fees will be paid/received (see . Funding fees are applicable in every case except for longCount == 1 and (shortCount and doubleshortCount and doublelongCount and triplelongCount == 0) - check draft code (see attachment). 5. Add funding rates paid/received to strategy...

I'm seeking an experienced graphic designer to create captivating product promotion pictures. These will be utilized for social media marketing and on website banners, requiring eye-catching and engaging designs that will draw attention to our product line. The images should follow the specifications below: - Format: The designer should be capable of delivering the designs in JPEG, PNG, Ai, and Ps formats for maximum compatibility across various platforms. - Usage: The images will be primarily used for social media marketing and website banners. Therefore, they must be of high-quality, optimized for digital platforms, and in web-friendly formats. Ideal candidates will have: - Specializing in natural and high-quality designs (this product is herbal tobacco, sold in Taiwa...

...four custom cabinets (two cabinets of two designs = 4). Fixed bid. - Style: The design should reflect a traditional style that matches my aesthetic requirement. - Materials: The construction will require a minimum 1/2" thick wood, both OSB, plywood, and black walnut veneer. Laser cutting and/or CNC machining technology should be utilized for precision work. Will provide designs in SVG vector format. - Dimensions: The dimensions of these cabinets are beyond the standard ones and will be communicated on project commencement. - Shipping: Once completed, safe packaging and shipping to state of Utah in the U.S.A are required. This project needs a high degree of precision, knowledge of woodworking techniques, as well as experience in working with laser and CNC machines. Wood...

I'm in need of a Virtual Assistant based in South America who can assist with cold calling businesses. Your primary responsibility will be to reach out and set appointments for me. Here's what I'm looking for: 1. Fluency in English language. 2. Capable of doing outbound cold c...skills. 4. Proven experience in appointment setting, preferably from a B2B context, is a must. 5. Must have the ability to persuade and deal with objections professionally. 6. Should be self-directed, assertive and have the ability to work in a fast-paced environment. Your success in this role will be measured by the number of appointments you can set. This is a fantastic opportunity for those who excel in telemarketing and appointment setting. If this matches your skills and experience, I...

I'm currently in need of a skilled and experienced individual to conduct pre-employment checks for my prospective employees. Here's what I specifically require: • Background check that focuses mainly on educational verification. • In particular, the verification process should be aiming to confirm the authenticity of a claimed Bachelor's degree. Ideally, the successful professional would have prior experience in HR, specifically in conducting background checks, and a strong understanding of educational verification procedures. A meticulous attention to detail and legal knowledge related to employee hiring in my specific domain would also be appreciated.

I am in need of a talented PCB designer who can assist with the basic design of a circuit board. This project's main aim is to replace an existing circuit board. Details related to the project: • This is a fairly simple task with only a few components involved, making it very suitable for those who excel in basic PCB design. • I have a schematic diagram that I will provide. Your task will just be to take that schematic and translate it into a PCB design. Ideal Skills and Experience: • Extensive experience with PCB design • Familiarity with basic components • Ability to translate schematics into PCB designs • Strong attention to detail This project is a fantastic opportunity for someone looking to showcase their PCB design skills on a basic yet...

QR code is to launch my mobil app ! This mobile application help customer to navigate in his company and also signal an emergency. Check my mockup attached files

I'm urgently looking for a skilled and experienced web designer to bring my vision of a professional and corporate digital business card website to life. We want same as it's this website or if you can do much better from this. Plz check attached link Looking forward to receiving bids from suitable professionals who can deliver this project ASAP.

I'm needing a skilled photo editor to crop 100 snapshot photos into three specific Social Media (So Me) formats: 1:1 (square), 9:16 (portrait), and 16:9 (landscape). About the Project: - The three formats are non negotiable, so please ensure you can deliver. - I will require the photos to be saved in JPEG format. - Your creative judgment is required to determine the best cropping points for each snapshot. Skills & Experience: - Strong knowledge and experience with photo editing tools is key. - Creative eye for arrangement and framing. - Previous experience cropping and formatting photos for social media is a plus.

I'm in need of a skilled professional who can manage the daily tasks involved in my accounting and bookkeeping. Your responsibilities will include: - Handling accounts payable - Reconciling bank statements - Generating financial reports I use QuickBooks, Xero, and Excel spreadsheets in my daily operations. Therefore, experience and proficiency in these tools are highly required. Experience with daily accounting tasks is a big plus. Attention to detail, high reliability, and a keen understanding of finance protocols will be ideal for this role.

Check and solve issue. Add a new column into table and API

I am pleased to the finalize the proposal between Priya (Your Designer Hub) and @vtechy (Samita G), dated April 1, 2024. Scope of Work:- Send 600 Images (Pre-designed, Non-Exclusive, Without Logo) of different ca...Work:- Send 600 Images (Pre-designed, Non-Exclusive, Without Logo) of different categories(such as Good Morning, Festivals, Motivational, Quotes, Thank You, Birthday, Anniversary, etc) sent by @vtechy(Samita G). Designs will be replaced/redesigned/customized ,if it doesn't fit the requirements. Timeline:- 5 Days Budget:- Total Budget: ₹600 (for 600 Images) Technical Details:- Image Size: 1:1 File Format: JPG/PNG/PSD Please feel free to reach out with any questions or concerns. I'll be putting my best efforts into this project to ensure it meets and exceeds ...

I'm urgently seeking a talented developer (or team) to create a comprehensive Android and iOS app, along with a corresponding website, for my wholesale pharmaceutical business. The main features of the app and site should include: - Daily stock upload: The system must have an interface that supports daily stock uploads using Excel files, ensuring seamless updates on available products. - Order Placement: Customers should be able to browse my products, fill their baskets, and place their orders with ease. - User Registration and Login: Users should be able to create profiles, providing details such as contact information, billing/shipping addresses, and prescription details. Logged-in users should have the option to track their orders and view order history. Freelancers appl...

I'm in need of a skilled designer with expertise in converting images to vector format. The project involves taking a simple logo in PNG format and converting it to a high-quality vector. Key Responsibilities: - The purpose of the logo is primarily for marketing materials, thus it needs to maintain the same color scheme as the original PNG logo. - The level of detail of the new vector logo should closely match that of the original PNG. Ideal Candidate: - Has a strong background in graphic design and image editing. - Proficient in software such as Adobe Illustrator or CorelDRAW. - Pays great attention to detail and can accurately replicate the look and feel of the original logo. - Has experience in creating logo for marketing materials. Your task is to produce a fi...

As a burgeoning entity, I'm looking for a specialist who can design a modern, innovative logo that combines both text and icon. I'm envisioning a logo that will signify our identity in a sleek, fresh and clear format. Here's what I have in mind: - A brilliant mix of text and icon that mirrors modern design principles. - Use of specific colors I have in mind. I'll share the palette once we commence the project. - Ability to convey our brand's personality and goals effectively. I need a professional with a strong background in graphic design and preferably with prior experience in modern logo creation. A strong portfolio demonstrating your previous works in this field will be highly valued. I am confident that the right freelancer will bring a unique and com...

I need an expert in Excel who can optimize my current dashboard. Specific tasks will include: - Enhancing the data analysis function of the dashboard - Improving the visualization of sales and HR manpower data The data will be updated on a monthly basis. Therefore, the dashboard should be designed for easy updating and automation. If you have relevant experience in designing and optimizing Excel dashboards, especially for sales and HR data analysis, your skills are highly desirable for this project.

I'm seeking a proficient data entry specialist to help convert physical documents into a digital format. The specific types of documents haven't been classified yet but require utmost accuracy during the conversion process. Your responsibilities will include: - Ensuring all data is accurate and complete - Verifying inputted data for errors and correcting where necessary - Safeguarding sensitive information The ideal candidate will have: - Excellent keyboarding skills - High level of focus and attention to detail - Previous experience in data entry from physical documents.

...in need of a professional female editor for my non-fiction educational book, which is currently within the range of 10,000 to 50,000 words. It will talk about female specific procedures, so we require proper layout fixes and editing from a female perspective. REQUIRED SERVICES: - Copy Editing: Ensure language is clear, concise, and appropriately suited for the intended audience. - Line Editing: Check for style consistency, smooth transitions, and narrative strength. IDEAL SKILLS: - Strong experience with the non-fiction genre. - Familiarity with common style guides. - Excellent command of the English language. - Attention to detail. Your task would be to polish my manuscript while preserving my voice and making sure the text is free of grammatical and punctuation errors. I wou...

I'm seeking a skilled professional who can diligently perform data entry tasks. The prime responsibilities will be: - To accurately input text data into an Excel spreadsheet and web-based forms. - The task requires complete fluency in English. - The data needs to be arranged according to a specific, custom layout in the Excel spreadsheet, the details for which will be provided during the project. The ideal freelancer would be adept in data management, ensuring accuracy, and should possess advanced Excel skills. Prior experience in specified data entry and a thorough understanding of English is a must for this project.

...looking for a freelancer who can help me with gathering current data on Open Interest and Volume from the NSE and BSE option chain. The ideal candidate should have experience in data collection and analysis, with a strong knowledge of the stock market and options trading. Specific requirements for the project include: - Gathering current data on Open Interest and Volume from the NSE and BSE option chain - Presenting the data in web page with filters - Ensuring that the live data is up-to-time and accurate The freelancer should have the following skills and experience: - Proficiency in data collection and analysis - Strong knowledge of the stock market and options trading - Experience working with Excel and creating tables for data...

...professional to develop a financial model using Excel that relies on total return over a variable number of days and volatility for stock selection and risk differentiation. This model will employ adaptive allocation methods. Ideal qualifications: - Deep knowledge and experience in financial modelling and analysis - Proficiency in Excel - Understanding of portfolio selection and allocation - Familiarity with financial metrics such as Return on Investment (ROI), Standard Deviation, and Sharpe Ratio Project details: - The model should incorporate total return over a flexible duration for stock selection. - Volatility should serve as the basis for managing risk within the portfolio. - The financial model will need to be updated with new data on a daily basis. If...

I am in need of education verification services for my pre-employment vetting process. Skills and Experience Required: - Experience in conducting education verification checks - Familiarity with the educational system and institutions in Turkey Additional Information: - Attention to detail and accuracy are crucial in ensuring the accuracy of the verification process. Candidate Volume: - The project involves vetting 1-5 candidates. Please note that this project does not require additional verification services such as drug testing, credit checks, or social media screening

I'm seeking an Excel expert who can design and build an org chart that visualizes my company's structure. The primary requirements of the project are: - Creating an innovative org chart with 5 to 10 levels of hierarchy. This should lucidly identify reporting relationships and aid in future workforce planning. - Chart must be dynamic and editable, allowing easy updates when there are organizational changes or expansions. Ideal candidates for this project should demonstrate: - Proficient knowledge and experience with Excel. - Previous examples of detailed, dynamic org charts created in Excel. - Strong understanding of organizational structures and how to best represent them visually. - Excellent attention to detail and accuracy.

...real-time with the best price. How can AI help improve user experience for users? Personalised pricing tools Currently, when users want to buy or sell something, Flipspot offers historical data, price charts and recent traded prices to educate the user on how much a product is currently worth. Now, with the help of data scraping & AI, we can first grab price data on other platforms such as Amazon, Gumtree and eBay so we have sufficient data entries to input for the AI to work. With AI, we can take this one step further. First we analyse all the pricing data on Flipspot and other platforms. Then we aggregate the data and feed it into our AI Algorithm to create real-time pricing tools. Some of these features include: • Pricing trends...

I'm in need of a graphic designer to help us in putting together a magazine - layout already created. - Desired Skills: - Proficiency in graphic design, specifically with print format. - Experience with A4 size magazine layouts. - Must have good attention to detail. If you've designed for A4 magazines before, you'll fit right in. Your creativity and attention to detail will help bring this project to life.

I need an experienced Excel and VBA specialist to assist with a project that involves data cleaning and generating reports from a CSV file. This file contains dates and times against power usage for apartments and needs to be processed in Microsoft Excel. The job tasks include: - Fixing inconsistent data entries in the CSV file - Extracting time of usage for each apartment - Creating a repeatable VBA script for future use Ideal freelancers will have strong experience in: - Microsoft Excel for managing and manipulating CSV files - VBA for creating automated tasks related to data cleaning and report generation Your help will save me time and effort in terms of managing this CSV file and creating valuable reports in the future. Successful completi...

I am in need of an Excel guru to assist with my project involving fewer than 5 sheets. Help is needed to organize and format data effectively. Beyond just basic formatting, the project also requires the use of advanced formulas, specifically VLOOKUP and INDEX MATCH. The ideal freelancer for this task should have: - Expert knowledge in Excel formatting and data organization - Proven experience in creating and using advanced Excel formulas like VLOOKUP or INDEX MATCH - Strong attention to detail and focus on data accuracy - The ability to complete tasks efficiently and on time. Rest assured, if this project is successful, there could be more opportunities for similar jobs in the future. Looking forward to your bids.

I'm seeking a talented video editor savvy in reels and TikTok content creat...Think of them as bite-sized entertaining pieces about cryptocurrency trading, perfect for daily posting. I will provide the main trading content that is to be featured in the videos. Your task is to turn these into engaging content that will be eagerly consumed. The videos should be 5 - 15 seconds each with a humorous twist. Required Features: - Pitch-perfect understanding of reels & TikTok video format. - Ability to incorporate humor into the video edits. - A keen interest or understanding of cryptocurrency and finance to ensure accurate yet entertaining content. - Experience in editing videos for social media. Think you’re a perfect fit? Submit your proposal, I'd love to review ...

I'm looking for a proficient Excel expert with extensive experience in data cleaning to assist with a key task. Your primary responsibilities will include: - Identifying and removing duplicate data entries in Excel, Data cleaning - Creating Pivot tables and data aggregations - Efficient dashboard and visuals that showcases trends and patterns via graphical data representation. Please only bid if you are seasoned in creating pivot tables, using Power query and generating visually appealing data insights. Precision and attention to detail are essential skills for this project.

...alcohol. My developer is putting together a website. I want to design 6 bottle labels. For this competition you only need to design TWO bottle labels. I would like these labels to be for 1. Choc Mint Vodka and Gin, I want the designer to show the label on a bottle. The image of the bottle with label needs to look like a real photo not a mock up. The label itself needs to be in a format that can be sent to the label printer. My aim is for customers to be able to see what the bottles will look like. The winner of this competition will then be given first chance to design the other 4 bottles. Once the distillery is open there will be new labels and bottle pictures that need to be designed on a monthly basis. The shape of the bottle that you must use is shown in an attac...

...skilled developer to create a data visualization webpage, similar to Google Earth. Ideal candidates should have a strong background in JavaScript, Python, and HTML/CSS. Key components: - Design: I have a specific design in mind for the webpage, details of which will be shared with the selected freelancer. - Data: The website's function will be to display GPS coordinates (latitude and longitude) alongside relevant site information when hovered over. This would include Site Name, Site Description, and Site Statistics. - Source: All required data is contained in an Excel sheet which I will provide. The ideal freelancer would have experience in data visualization, and expertise in the programming languages mentioned. Additionally, a proficiency i...

I'm in need of data entry professionals who have exceptional skills in gathering text data from online resources and flawlessly entering it onto a spreadsheet. Key Responsibilities: - Sourcing text data from specified online resources - Accurately entering data onto a spreadsheet with minimal errors - Ensuring data entries are formatted correctly and uniformly within the spreadsheet Ideal Skills and Experience: - Proficiency in using spreadsheets: Microsoft Excel or an equivalent is required - Strong attention to detail: This is crucial to avoid mistakes in data entry - Experience in online research: Being able to quickly and efficiently find reliable online resources - Previous experience in data entry: A strong foundation...

I am in need of a skilled photo editor who can help me add a realistic-looking 20kg extra weight to two full body shots of me and one close up. Here's what to know about this project: Required Skills: • Professional expertise in photo manipulation • Experience in editing and adding weight effects to photos Project Details: • Photos are taken with an iPhone camera and currently in HEIF format. • The added weight needs to appear natural and should make me look 20kg heavier. • Two photos that need to be edited are full body shots, the third is a headshot. Your attention to detail and understanding of how to visually represent weight gain on a human body will be integral to this project's success. Please only bid if you're capable of...

As the primary investigator, I have a fully collected dataset in need of expert treatment. The foundation lies in obviously conducting a formal hypothesis testing. I've done the hard part and have my hypotheses all set. This data in SPSS format is calling for your expertise in cleaning and running mediation analysis so as evolution and discovery of insights can occur. Ideal skills and experience: - Mastery of SPSS software for data analysis - Proven experience in statistical hypothesis testing - Ability to clean up datasets quickly and efficiently - Background in running moderation and mediation analysis - Capacity to synthesize complex information and results into clear, actionable insights - Scheduling flexibility to accommodate potential project modulations...

I am looking for someone to create an ad for my upcoming travel day in Houston, Texas Friday and Saturday April 12th and 13th. I need the ad to be in digital format and I need help creating the artwork or images to include in the ad. The ad should effectively promote my erotic massage business and convey that i'll be in Houston, Texas Friday and Saturday and i'll have limited appointments. The target audience should be women who are interested in relaxation and stress-relief after a long week. I need someone who is creative and experienced in creating ads that will raise awareness of my business.

Hi Lin F., you have completed a scraping job for me for the last two years, I need it done again. Please have a look and apply: https://www.freelancer.com/projects/excel/Scrape-data-from-unprotected-URL

I need an expert to masterfully apply and tweak formulas and functions across entire rows and columns within my Excel spreadsheet. Your tasks will be to: - Implement formulas and functions - Apply them to entire rows and columns Ideal skills and qualifications for this job would include advanced proficiency in Excel, especially in applying lookups and mathematical functions like SUM, AVERAGE, COUNT. Proven experience with similar projects is highly preferred.

I am in urgent need of a skilled 3D CAD designer for an innovative submarine project. This design requires a moderate level of detail and complexity and will be based off of rough drawings that I will provide. Your creative insight will be crucial ...concept to life. Your tasks will include: - Creating a 3D model of a one-person submarine - Providing a 360° view of the design concept Ideal Skills: - Proficiency in 3D CAD software - Demonstrable creativity and design thinking - Ability to work quickly and accurately - Knowledge in submarine or relevant designs will be an added advantage Since the file format was not specified, apply your professional judgement on the best suitable format. The job needs to be completed ASAP. Your quick completion of this project will be...

I am in need of a dynamic Excel tool to perform data analysis tasks. The tool must be designed using autofill drop down list, and it will be utilised for: - Employee name selection - The drop down list should offer an autofill option for employee names. - Tallying Totals - The drop-down list selections should be capable of tallying totals. For this project, the ideal freelancer will have strong experience with Excel, particularly with creating and managing drop down lists. Experience with data analysis in Excel will be beneficial. Your task will be to create an easy to use, and automated system that can manage complex quantitative data.

I am seeking a skilled jewish artist experienced in oil painting to create a large, abstract piece exceeding 36 inches in dimension. Key Responsibilities: - Translate creative vision into a high-quality, abstract oil painting - Create a large-sized artwork to be the focal point in a room Skills and Experience: - Proven experience working with oil paints - Portfolio showcasin...experienced in oil painting to create a large, abstract piece exceeding 36 inches in dimension. Key Responsibilities: - Translate creative vision into a high-quality, abstract oil painting - Create a large-sized artwork to be the focal point in a room Skills and Experience: - Proven experience working with oil paints - Portfolio showcasing abstract art expertise - Comfortable with delivering large format...

hello, I would like a logo and a visual identity for my digital marketing agency: Blumup Marketing I want a logo and a name that I can put on my site, I want quality work and a unique logo. I would like to see your work, don't hesitate to contact me :)

I am seeking an experienced freelancer who can craft a captivating 1-3 minute montage music video. This project will require a talent for video editing and custom music composition. - You'll have an array of photos and videos at your disposal, along with my song suggestions, to weave together into a cohesive and engaging video. - A sense of narrative progression within the montage format is important, so skills in storytelling and visual communication are a plus. This is your chance to wield your creative finesse to the fullest. I look forward to seeing your unique interpretations of the contents provided. If you have a showcase of previously completed music videos, I would appreciate if you can share them so I can gauge if your style syncs with what I have in mind.

...need of a skilled Python developer who can build a web scraper to extract data from a map-based website. Here's a high-level rundown of the project: - Develop a Python scraper that can pull geographic coordinates from a map-centric site. - Clean and organize this data so it can be exported in CSV format. - The script must be well-structured and well-documented for future reference or modification. Your skills and experience: - Proficient in Python, with a deep understanding of web scraping practices. - Knowledge of various data structures and understanding of handling data in CSV format. - Experience with GIS, map data, and geographic coordinates would be a significant plus. - Prior experience with large-scale data extractio...

I'm seeking an expert in data collection to gather email addresses from a list of retail shop websites I have. Your responsibility will be to: - Visit each website link that I provide - Identify and collect the contact email address - Organize the data in a spreadsheet, with each email in a separate row Deliverables: - A spreadsheet in either .xlsx or .csv format with the email contact for each retail shop. Desired Skills: - Data Collection - Data Entry - Attention to detail - Proficiency in Excel or similar spreadsheet software - Familiarity with web research.