Excel 2007 data input macro jobs
I require the expertise of a professional website designer to create my new website. Key Details: - The website will consist of 5-10 pages. - All the content required is already prepared and will be provided. Ideal Skills: - A proven track record in designing user friendly, professional websites. The s...require the expertise of a professional website designer to create my new website. Key Details: - The website will consist of 5-10 pages. - All the content required is already prepared and will be provided. Ideal Skills: - A proven track record in designing user friendly, professional websites. The successful candidate will be creative, time efficient and have a keen eye for detail. Your input on website functionality and design aesthetics will be mandatory for thi...
I'm currently working on an Excel sheet for performance analysis and I need assistance with writing the SUMIF formula. Key Requirements: - Assist with writing the SUMIF formula for my Excel sheet (vlookup, countif, and other formulas are not needed for this project) - Ensure the formula fits within the context of performance analysis Ideal Freelancer: - Experienced in Excel and in particular, writing SUMIF functions - Knowledge of performance analysis or related fields is a plus
I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient ...with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me res...
...successful the deployment must be: * Entirely automated using CloudFormation and bash scripts. * The landing page must be a public page protected with a username/password authentication block, this should rely upon CloudFront to perform authentication. The username and password should be configurable in the CloudFormation template. The landing page can be simple HTML that displays the username input, password input and login button. * A user friendly domain name should be configured via Route53 that is configurable in CloudFormation. The domain name can be provided if required. Obviously a AWS TLS1.3 PKI certificate is also required. * Behind the landing page is WebGoat running as Docker container. The container should run in ECS FarGate using the Docker container provided...
I'm looking to have a new website created. The key task involved in this is harvesting photos and data from Website A, and using this to create our site. The following details outline the project requirements: - Downloading photos and data from Website A. - Upload these photos and data to the corresponding sections on our website. The new site should mirror the content placement of Website A. Ideal skills for this job include website creation, data extraction, and efficient data input methods. Experience with content migration is highly desirable. Deadline for completion is within a month from the project start date. All data need to be updated each day
I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can help me streamline my data m...
I'm looking for a skilled Excel professional to help me create a custom inventory dashboard. Key Requirements: - The dashboard should focus on inventory management, specifically, visualizing product stock levels. - The data should be arranged in an intuitive manner that allows for quick and easy inventory tracking. Ideal Skills & Experience: - Strong proficiency in Excel, particularly in creating visually appealing and user-friendly dashboards. - Experience in inventory management, with an understanding of product stock levels and their relevance. - Attention to detail as accuracy in data representation is crucial for this project. - Good communication skills and a proactive attitude to ensure the project's success. Please note that due to the ...
...need of a proficient Excel expert who has a solid understanding of Excel macros and compatibility issues with Excel for Mac 2018 or later. The project involves assessing and modifying an existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior experience with Excel for Mac compat...
I need a virtual assistant for a daily one-hour task to input visitor information into a Google Sheet. Key Requirements: - Attention to Detail: It's important that all information is entered accurately and completely. - Manually need to collect data from various source Ideal Candidate: If you are a detail-oriented individual with prior data entry experience and can commit to a daily one-hour task, I'd like to hear from you.
I'm in need of an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projected in one place as a dashboard.
I'm looking for a skilled Excel professional to clean a text-based dataset for me. The dataset is not massive, but it's quite messy. The data cleaning task is relatively straightforward and basic. You'll have to perform operations such as removing duplicates and adjusting formats. Ideal Skills and Experience: - Proficiency in Excel: You should be comfortable working with large datasets in Excel, including applying formulas and functions. - Data Cleaning Expertise: Prior experience in cleaning text data is a major plus. - Attention to Detail: The devil is in the details; I need someone who won't overlook small nuances in the data set. Once the data is cleaned, I'll need you to carry out some basic analysis...
I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Excel skills in a p...
I'm in need of an experienced Shopify designer to create a robust e-commerce portal for my business. The website's primary purpose will be to facilitate online sales for various types of gadgets. Key responsibilities include: - Design an intuitive, user-friendly Shopify store. - Input and organise 50-100 product listings. - Optimisation for conversions. The ideal candidate will have: - Solid experience in Shopify store design and setup. - A good understanding of e-commerce best practices. - Familiarity with gadgets and similar niche products. The end result should be a seamless shopping experience that encourages sales and user return.
Develop macro-enabled Excel file to handle CSV
I'm in need of a professional who can convert a PDF document to Excel format. The PDF contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience in converting PDF documents with mixed content to Excel while maintaining layout integr...
Key Requirements: - Need an expert in Python programming - Familiarity with Pandas and Beautiful Soup - Experience in data analysis The job mainly involves reviewing the existing code, fixing any issues that may hinder the data extraction, and ensuring that the extracted table is ready for analysis. Please note that no additional data preprocessing is required. (feel free to rewrite code if you have better idea) --- name "iXBRL" , inside folder contain multiple html file(hundreds to thousands), each html file contain multiple tables(vary from 15-35, depend on each html file). Python to extract specific table and vertically stack them together to create an Excel file.(first column add html filename.) inside html file is encoded in chinese, so must ...
I have a project that requires purely text data entry. I have a set of handwritten notes which need to be entered into a spreadsheet. Key Requirements: - The data is text-based, and it's crucial that the freelancer can transcribe this accurately and efficiently. - Proficiency in using spreadsheet software like Excel or Google Sheets is a must. Ideal Skills: - Fast and accurate typing skills - Proficient in using spreadsheet software - Experience with data entry, especially from handwritten sources
...attach MOV videos to outgoing emails. - Ensure the script is robust, reliable and can handle various video sizes. - Email content doesn't need to be customized for each recipient, so a standard email template is sufficient. - Mail input from user side Your role will involve: - Understanding the project's requirements and the specific constraints of sending MOV videos via email. - Creating the necessary Python script within the TouchDesigner environment. - Testing and refining the script to ensure it performs reliably across different email platforms. - Creating mail input system Ideal Skills: - Proficiency in TouchDesigner and Python, with a proven track record of integrating the two for practical applications. - Experience in working with email systems and att...
I need an Excel tool that can sort data by category and provide users with an interactive experience. I'm looking for an experienced Excel developer who can create a user-friendly, yet advanced, Excel tool. The tool should have the following features: - **Filtering**: The tool should allow users to filter data by category. This is a crucial aspect of the tool's functionality, as the data will be organized by this field. - **Interactive Buttons**: I would like the tool to have buttons that allow users to sort data. When a button is clicked, the data should rearrange itself based on the selected category. For example, when a user clicks on the button related to 'Category A', all data entries related to ...
From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.
As a client looking to increase my income, I'm in need of a talented graphic designer for logo creation. While I've not specified a preferred style in this listing, I'm expecting the chosen freelancer to be adept at determining and executing the best stylistic approach based on my input. Ideal Skills: - Ability to create engaging, visually appealing logos - Experience in various logo design styles - Excellent communication to understand and execute my vision - Strong graphic design expertise Your portfolio showcasing your previous logo design work will be a critical factor in my hiring decision. Let's create something truly unique together!
I'm looking for a professional who can help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple format for my tables, in line with a minimalist style. Ideal Freelancer: - Proficient in Excel, with a deep understanding of formula creation. - Experienced in table formatting and design, with a flair for minimalism. - Able to deliver high-quality, error-free work in a timely manner.
I am currently in need of an experienced architect who specializes in commercial architectural design and construction document preparation. The perfect candidate for this...perfect candidate for this project should be someone with: - Exceptional skills in architectural design, specifically for small-scale commercial projects (less than 5,000 sq.ft.) - Expertise in preparing detailed construction documents, including drawings, specifications, and contracts. - A proven track record of successful small commercial architectural projects would be a huge advantage Your input will be instrumental in generating compelling designs that make optimal use of space as well as preparing comprehensive construction documents for the build. Looking forward to your applications and architect ...
I need a virtual assistant for a daily one-hour task to input visitor information into a Google Sheet. Key Requirements: - Attention to Detail: It's important that all information is entered accurately and completely. Ideal Candidate: If you are a detail-oriented individual with prior data entry experience and can commit to a daily one-hour task, I'd like to hear from you.
...detailed financial reports and dashboards, primarily based on data from Excel spreadsheets. Key Responsibilities: - Develop compelling, visually appealing reports and dashboards that are easy to interpret and navigate. - Tailor the reports and dashboards specifically to financial analysis, ensuring they provide the insights necessary for informed decision-making. Ideal Candidate: - Proven experience creating financial analysis reports and dashboards in Power BI. - Proficiency in integrating data from Excel spreadsheets. - Strong attention to detail and the ability to translate complex financial information into clear, concise visual elements. This project requires a high level of expertise in Power BI, financial analysis, and data visualization. ...
Hello Andre, sorry for replying this late. After reading your requirements, I can make a shorter version of your needs over here, to see if I'm understanding your request right or not: Objective: Redesign the input page for your users (manufacturers) to document their supply chain process, making it more user-friendly and easy to follow. Current Problem: The existing input page has become overly technical and difficult to navigate. Deliverables: Figma file for desktop and tablet view, that includes a high-quality design and all design components Style: Blue-ish color scheme, professional style If everything is correct, you can accept my proposal and I can start asap ?
...- **Form Integration**: The form should be fully functional, where users can upload images, add text for watermarking, choose a watermark position, and even select an existing image for watermarking. - **Code Adjustment**: The existing watermarking code needs to be integrated and work seamlessly with the form submission. This involves adjusting the code to make it work in conjunction with user input from the form. - **User Experience**: The form should be user-friendly, intuitive, and visually appealing, ensuring a smooth and engaging experience for users. Ideal skills and experience: - Proficiency in PHP and Bootstrap5. - Prior experience in integrating forms with image processing, particularly watermarking, will be a significant advantage. - Strong understanding of user experi...
...of 1-5 minutes. Key services I require include color correction, sound editing, and the addition of visual effects where necessary. Your role as a video editor will be to ensure that the final product is engaging, professional and in line with the vision we have for the videos. You should have a good understanding of what works well for business and event videos, and be able to provide creative input where needed. Key Skills and Experience: - Proven experience in video editing, particularly with business and event videos - Proficient in color correction, sound editing, and adding visual effects - Ability to work efficiently and meet deadlines - Strong communication skills to understand and deliver on the project's requirements Please provide a portfolio of your previous v...
I'm in need of engaging 2D animations, designed to captivate toddlers aged 1-3 years old. The primary goal of these videos is to entertain, making the learning experience fun and imaginative. Key requirements: - Age-appropriate content: The animations should resonat...engaging and visually stimulating experience for young viewers. - Storytelling: The animations will be used to bring to life poems and rhymes, so an ability to translate literature into captivating visuals is essential. - Experience with children's content: While not mandatory, prior experience creating educational or entertaining videos for toddlers would be highly beneficial. I'm open to creative input and suggestions, but the primary focus should be on creating animations that are innovative, enter...
Python Script Developer for Photoshop Automation & WordPress/WooCommerce Integration We are seeking a freelance Python developer to create a script that automates Photoshop tasks and integrates with WordPress/WooCommerce for product customization. The script will: Develop a Python script to automate Photoshop operations. Integrate the script w...freelance Python developer to create a script that automates Photoshop tasks and integrates with WordPress/WooCommerce for product customization. The script will: Develop a Python script to automate Photoshop operations. Integrate the script with WordPress/WooCommerce to retrieve order details. Automatically open Photoshop and modify PSD files based on customer orders. Update text layers with customer input and save customized templat...
I'm looking for a detail-oriented professional to support my business with bookkeeping and budget management tasks. Key Responsibilities: - Accurate management of accounts payable and accounts receivable in QuickBooks - Regular bank reconciliations to ensure that all transactio...payable and accounts receivable in QuickBooks - Regular bank reconciliations to ensure that all transactions are accounted for correctly Ideal Skills and Experience: - Proficiency in QuickBooks software - Prior experience in accounts payable/receivable and bank reconciliations - A keen eye for detail and accuracy - Strong organizational and time-management skills The role will require weekly input, but this may vary depending on the size of transactions. Please provide an estimate of your hourly ra...
Python Script Developer for Photoshop Automation & WordPress/WooCommerce Integration We are seeking a freelance Python developer to create a script that automates Photoshop tasks and integrates with WordPress/WooCommerce for product customization. The script will: Develop a Python script to automate Photoshop operations. Integrate the script w...freelance Python developer to create a script that automates Photoshop tasks and integrates with WordPress/WooCommerce for product customization. The script will: Develop a Python script to automate Photoshop operations. Integrate the script with WordPress/WooCommerce to retrieve order details. Automatically open Photoshop and modify PSD files based on customer orders. Update text layers with customer input and save customized templat...
Python Script Developer for Photoshop Automation & WordPress/WooCommerce Integration We are seeking a freelance Python developer to create a script that automates Photoshop tasks and integrates with WordPress/WooCommerce for product customization. The script will: Develop a Python script to automate Photoshop operations. Integrate the script w...freelance Python developer to create a script that automates Photoshop tasks and integrates with WordPress/WooCommerce for product customization. The script will: Develop a Python script to automate Photoshop operations. Integrate the script with WordPress/WooCommerce to retrieve order details. Automatically open Photoshop and modify PSD files based on customer orders. Update text layers with customer input and save customized templat...
I'm in need of a reliable professional to conduct text data entry for magazine advertisements. The successful freelancer should have: - Strong attention to detail - Proficiency in English - Prior experience in data entry, particularly with swift and accurate text input While not required, experience with magazine ad placements could also be highly beneficial, as the task involves inserting advertisements directly into a magazine. However, please note the specific magazine has not been disclosed at this point. Applicants without such specific experience but with proven data entry skills are still encouraged to bid.
I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently using Word 2010 and will be working with Java/Spring/JavaFX fo...
...is to allow user interaction, specifically enabling users to interact with database. Key Project Details: - This webpage is intended to serve as a platform for users to submit and retrieve data. - Currently, the existing design is in VB.NET WinForm and I need it to be converted into an engaging, robust webpage. - While the conversion of the form is a core need, I also require that the user interface be designed effectively to enhance the overall user experience. Key Skills Needed: - Proficiency in VB.NET and modern web development languages. - Experience in Database Management. - Knowledge in user-input forms design and implementation. - Previous experience in similar projects. Overall, I am expecting an innovative solution that increases our online reach, focusing on a...
I am looking for a skilled web developer who can construct an outstanding e-commerce website targeting the general public. As I am still uncertain about the color scheme or potential branding, I would value your input and creativity in this area. Key Skills & Experience: - Expertise in ecommerce platforms. - Experience with site design and aesthetics. - Familiarity with user-focused design. - Ability to understand and cater to a general public audience. - Proficiency in designing a user-friendly interface. - Suggestions for color schemes is a plus. Overall, I need someone who can create a visually appealing, easy to navigate, and successful online store. Your ability to understand audience preferences and translate this into an engaging and functional website will be key to...
I need a mobile app that can run on both iOS and Android devices. The primary function of this app should be to generate estimates for pressure washing services. Key Requirements: - Cross-platform compatibility: The app should be designed to work seamlessly on both iOS and Android devices. - Estimate Generation: The app should have an easy-to-use interface which allows users to input key details and get an accurate estimate for a pressure washing job. - Customization Options: I want users to be able to customize their service requests within the app. This could include options for different types of pressure washing, areas to be cleaned, etc. Ideal Skills and Experience: - Prior experience in developing and deploying cross-platform mobile applications, especially in the realm of ...
I'm in need of a full-time, mid-level software developer to join our e-commerce company. You should be proficient in Python, Java, and PHP. Your primary responsibilities will include: - Coding and programming: Developing robust, scalable software solutions for our e-commerce platform. - Database management...of our databases and managing related processes. - Bug fixing and troubleshooting: Identifying and addressing software issues to maximize performance. Your experience should ideally span 2-5 years, giving you a good understanding of the nuances of software development. In addition to your technical prowess, you should be able to work efficiently within a team and communicate effectively. Your input will be crucial in enhancing our e-commerce platform and ensuring optimal...
...chatbot should integrate with a database. We could explore other data integration requirements during our discussions. Ideal applicants are those familiar with AI chatbot programming, Google Assistant integration, and broad-reaching app compatibility. Database integration knowledge is essential, with bonus points for those who can offer a variety of data integration possibilities. Please bid only if you are skilled in these areas and ready to collaborate on this task. 'm looking for a skilled freelancer to program an AI chatbot that integrates seamlessly with Google Assistant. The chatbot should handle verbal prompts to perform various tasks, access phone functions when given verbal permission, and search online public sites for data collection and analysis. ...
I have a list of 50000 urls, I would like to scape the pages to see if they contain references to scripts - I will provide a list of the urls and the scripts. Deliverable should be an excel with the 50000 urls and whether they contain the link for each script. Looking for fast turnaround
Title: Automated Data Retrieval from Websites Using CRM and CID Numbers Description: We are looking for an experienced developer to automate the process of retrieving data from specific websites using CRM and CID numbers. The goal is to develop a script or tool that will: Look up Doctor's Specialization: Use CRM numbers to search on the website: CFM Doctors Search Extract doctor's information including their specialization. Look up Disease Descriptions: Use CID numbers to search on the website: MedicinaNet CID10 Search Extract the disease description. Deliverables: ( ) A script or tool that can take a list of CRM and CID numbers as input. Automate the search process on the specified websites. Extract
...Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 300 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Macro, MS Office skills to drive autom...
Hello, I need convert a PDF invoice to Excel to import to our invoices software
I'm looking for an experienced Power BI developer to create bespoke reports and dashboards, which will be integrated into Microsoft Teams. Tasks: - Handling data from Excel spreadsheets and converting it into insightful reports and dashboards. Skills and Experience: - Strong command of Power BI for report and dashboard creation. - Proven experience with Excel spreadsheets. - Good knowledge of integrating Power BI into Microsoft Teams. The goal is to make complex data easy to understand, facilitating better decision-making within our team. Your work will directly impact our day-to-day operations and strategies.
I'm looking for an experienced design engineer to finalize the design of a functional metallic safe. This 10cm diameter round product is intended to function as a mini safe for storing small objects. It's not complex, design is on the last phase, we need a pro to complete the design to be ready to manufacture. The safe resembles a medal, consisting on a top and bottom part that screws togeth...necessary technical details for manufacturing, including lock and secure opening mechanism. Your deliverables will be a complete design package, suitable for presenting to potential manufacturers. Project is almost finished, just a few details to finalize are needed. Successful completion of this project might lead to more collaboration opportunities as I have more designs that need profes...
...a specialized WordPress developer with experience in Excel operations and data showcasing. Key tasks: - Create a WordPress page that extracts numeric and text data from an Excel sheet. - Implement highlights and color-coded information on the webpage for better readability and understanding. - The data on the Excel sheet will be updated on a monthly basis, hence the website should be able to fetch the data automatically upon any modifications. Ideal skills: - Proficiency in WordPress and Excel integration - Experience in creating visually appealing data showcases or infographics - Strong understanding of data extraction and display technologies The aim is to have a user-friendly webpage that accurately repres...
Require a draft sketch of the attached - Drawing Emphasis: The focus of measurements - Skillset: Candidates with proficiency in mechanical engineering and a specialty in structural components are encouraged to apply. Prior experience with motor base designs will be a significant advantage. Your task will be to create a functional and practical design, and your insightful input will be of great value.
