Excel vba sql based column value jobs
I need assistance with cleaning data from several digital Excel files. Key Responsibilities: - Review and clean data in Excel spreadsheets - Ensure data integrity and accuracy Ideal Candidate: - Proficient in Excel - Has experience with data cleaning - Detail-oriented and able to spot errors in data
I need a professional designer to help with redesigning a bungalow house aimed at increasing its market value. The focus will be primarily on the bedrooms and bathrooms, which need to be transformed into appealing, functional spaces that prospective buyers will love. Key Aspects of the Project: - Redesign of bedrooms and bathrooms - Aim to significantly increase property value - Should appeal to the current real estate market Ideal Skills and Experience: - Proven track record in residential design - Strong understanding of real estate market trends - Excellent knowledge of space optimization and aesthetic design
...convey your brand's essence. Here's why I believe I'm the perfect fit for your project: Tailored Creativity: Every design I create is unique, ensuring it aligns perfectly with your brand identity and stands out in the crowded marketplace. Timely Delivery: I understand the importance of deadlines. You can count on me to deliver high-quality designs on time, every time. Collaborative Approach: I value your input and believe the best designs come from a partnership. I’ll work closely with you to ensure the final product exceeds your expectations. Proven Track Record: My portfolio includes successful projects with companies like [mention any relevant companies or projects], which have helped them achieve [mention specific results, like "a 20% increase i...
...Candidate: 1. E-Learning Expertise: I have successfully converted complex presentations into engaging e-learning modules with clear learning objectives and measurable outcomes. 2. GoHighLevel Experience: I am highly skilled in using GoHighLevel to create membership site content and interactive learning experiences. 3. Educational Curriculum Design: My background includes designing knowledge-based, skill-based, and behavioral training programs for diverse audiences. 4. Content Versatility: From PowerPoint conversion to text formatting, I ensure content is user-friendly, professional, and aligned with learning goals. Proposed Plan: Transform your PowerPoint into e-learning modules with clear objectives and a seamless user experience. Develop membership site conte...
...convey your brand's essence. Here's why I believe I'm the perfect fit for your project: Tailored Creativity: Every design I create is unique, ensuring it aligns perfectly with your brand identity and stands out in the crowded marketplace. Timely Delivery: I understand the importance of deadlines. You can count on me to deliver high-quality designs on time, every time. Collaborative Approach: I value your input and believe the best designs come from a partnership. I’ll work closely with you to ensure the final product exceeds your expectations. Proven Track Record: My portfolio includes successful projects with companies like [mention any relevant companies or projects], which have helped them achieve [mention specific results, like "a 20% increase i...
I need a response paper that primarily supports my viewpoint. The paper should be based on a specific book and follow the MLA format. All the references or citations for the paper should come from Born in Blood and Fire a concise history of Latin America by John Charles Chasteen 4th Edition. I have the book online I can send it to you via Email. Ideal Skills: - Excellent writing and critical thinking skills - Proficient in MLA format - Ability to articulate and support a viewpoint Experience: - Prior experience in academic writing, particularly response papers - Familiarity with the specified book would be an advantage - Proven track record of adhering to specific formatting requirements.
We are seeking a skilled AI Developer or team to create a ChatGPT-based conversational AI tailored for , an adult subscription-based platform similar to OnlyFans. This is a project for an 18+ platform, so applicants must be comfortable working in the adult industry. The AI will be used by agencies managing creators on to automate subscriber interactions, increase engagement, and drive sales of PPV (pay-per-view) photos and videos. What We Need: AI Integration: Leverage ChatGPT’s API to develop an AI that can: Engage subscribers in seductive and natural conversations. Build relationships to maintain subscriber interest. Sell pre-uploaded media (photos/videos) using predefined scripts. Customization and Training: Educate the AI to: Mimic the personality and style of ...
I am looking for a Hindi-speaking individual to visit our warehouse in Port Klang, Malaysia. The purpose of this visit is to teach a small group of our Indian staff (1-5 members) basic computer skills. Skills to be taught include: - Using a web browser - Using Google Sheets - Using Microsoft Excel The level of proficiency we aim for is basic. Your role will be crucial in helping our staff become more computer literate and improving their productivity. Ideal candidates will have: - Proficiency in Hindi and Malay - Strong knowledge of basic computer skills - Experience in teaching or training - Patience and good communication skills
I'm in need of a skilled freelancer with extensive experience in Zoho CRM and database management to synchronize our Zoho CRM with our database. Key Responsibilities: 1. Data Update & Cleanup: - Align our CRM ... - Ensure the script is capable of handling incremental updates and can operate on a set schedule. 3. Documentation & Automation: - Create clear and concise documentation detailing the cleanup and synchronization processes. - Automate the sync script for regular execution (e.g., hourly via crontab). Ideal Skills: - Extensive experience with Zoho CRM and its API. - High proficiency in SQL and Python. - Strong familiarity with data cleaning and automation tools. Please reach out if you're interested and share examples of similar projects yo...
Creating marketing content and a website for a DevOps service involves presenting technical concepts in a simple, engaging, and value-focused way. Here’s a detailed idea: --- Website Structure & Content Plan 1. Homepage: The Gateway to DevOps Excellence Headline: “Transform Your Development Process – Achieve Faster Delivery with DevOps.” Subtext: “Streamline workflows, boost collaboration, and automate deployment with our end-to-end DevOps solutions.” Call-to-Action (CTA): "Get Started Today" or "Schedule a Free Consultation." Visuals: A dynamic banner with DevOps tools (like Jenkins, Kubernetes, Docker) and animations showing smooth collaboration. 2. Why DevOps? (Educational Section) Simplify DevOps benefits: fa...
I'm looking for a skilled freelancer with expertise in Power Automate and Excel coding. I need assistance with automating data entry and updates in my Excel worksheets. Key Requirements: - Automate importing data from an email and CSV/Excel files into my Excel sheets. - Streamline the process of updating existing records. Ideal Skills: - Proficiency in Excel and Power Automate. - Experience with data handling and automation. - Strong attention to detail and ability to validate data. The goal is to save time and enhance efficiency with data management. Please share your relevant experience and examples of previous projects.
I'm in need of an Excel expert who can help automate some of my book-keeping tasks. The main focus will be on reconciling accounts. Your responsibilities: - Utilise experience with excel formulas and macros to refresh existing reconciliation process for the book-keeping and management reporting of a small UK charity. - Ensuring accuracy and efficiency in the automation. Ideal skills and experience: - Proficiency in Excel, particularly in using formulas and creating macros. - Background in book-keeping and accounting. - Experience in automating tasks in Excel.
Project Title: Web-Based CRM System Development for HR and Employee Management Project Overview: I am looking for a skilled developer or team to build a Web-Based CRM System that will efficiently handle various HR and employee management functionalities. The system should provide features such as employee data management, attendance tracking, leave management, salary slip generation, performance evaluation, and other HR-related functionalities. I already have a domain and hosting set up; I only need the website to be designed, developed, and deployed. Key Features to Include: 1. Employee Management: Add, edit, and view employee details (e.g., name, department, position, contact information, etc.). Employee ID generation and profile picture upload. 2. Attendance Tracking: D...
I'm looking for a Python expert who can help analyze our customer data. - The primary goal of this project is to derive insights from our customer data to drive business decisions. - The data is stored in databases, so experience with SQL and database management is a plus. - A strong background in data analysis and Python is essential for this project. Please include your relevant experience and examples of similar projects you've completed in your proposal.
I'm looking for a professional developer who can create a network security API similar to Burp Suite. This API should primarily focus on vulnerability scanning, specifically for SQL injection and Host header injection. It should provide detailed technical reports on the vulnerabilities it discovers. Ideal Skills and Experience: - Proficient in API development - Extensive knowledge in network security - Experienced in vulnerability scanning - Familiar with SQL injection and Host header injection - Capable of generating detailed technical reports
...skilled video editor to enhance my social media content aimed for YouTube. Key Responsibilities: - Cutting and trimming: Efficiently refining the footage to maintain a fast-paced, engaging flow typical of successful YouTube content. - Adding text and graphics: Incorporating relevant on-screen text and graphics to underscore key points, promote viewer interaction, and enhance overall production value. Ideal Skills: - Proficient in industry-standard video editing software (e.g., Adobe Premiere Pro, Final Cut Pro). - Creative mindset with a strong understanding of YouTube content dynamics. - Experience in adding engaging text and graphics to videos. Please provide examples of similar projects you've completed in your bid. Thank you! I need this type of videos
I'm in need of a data cleaning professional to help me with a spreadsheet containing 50,000 rows of company details. The data is currently organized in a single column and includes company names in mixed formats. Key Responsibilities: - Extract company names from the data strings - Clean the data manually to ensure accuracy Ideal Candidate: - Proficient in Excel or similar data management software - Exceptional attention to detail - Previous experience with data cleaning or data entry - Able to work independently and meet deadlines Please note that the company names are in mixed formats, so the ability to recognize and standardize these is crucial.
...Token management needs What We're Building: ┌─────────────┐ ┌──────────────┐ ┌────────────┐ │ Beds24 │────►│ Business │────►│ Data │ │ │ │ Logic │ │ Layer │ └─────────────┘ └──────────────┘ └────────────┘ Building a robust data layer and business logic system using serverless functions (Cloudflare Workers/Supabase Functions) and SQL database (D1/PostgreSQL). 1. Modern Data Layer - Complete booking management - Change history tracking - Price and availability tracking - Full audit capability 2. Sync System - Reliable data synchronization - Error handling and recovery - Bidirectional updates - Performance optimization Technical Stack: - Serverless Functions (Cloudflare Workers or S...
I'm looking for a proficient data entry specialist who can help me record mixed data (text and numerical) from Excel files. Key Responsibilities: - Accurately inputting mixed data (text and numerical) from provided Excel files. - Ensuring data integrity and accuracy during the entry process. Ideal Skills: - Proficiency in Excel and data entry. - Attention to detail to ensure data accuracy. - Experience in handling mixed data types. Please provide your experience with similar projects in your bid. Thank you.
...Detail: Strong reporting skills to keep the team updated on progress. Previous experience in telecalling, sales, or customer interaction is a plus. What We Offer Remuneration: INR 20,000 per month (fixed) + attractive sales commission. Growth Opportunity: Potential to transition into a full-time role based on performance. Flexible Work Hours: Ideal for individuals looking to balance other commitments with a rewarding part-time role. How to Apply If you believe you have the skills and drive to excel in this role, please send your updated resume and a short voice recording introducing yourself....
Want to recreate this spreadsheet to add another section, a sixth one called Operations Also want to add our company logo
I'm seeking a professional pitch deck to present our healthcare portal app to potential investors and partners. Key Requirements: - Creative Content: The most crucial aspect of the pitch deck. I need someone who can help craft engaging, compelling content that captures the essence and potential of our app. - Design: The design should be professional and corporate. It should reflect the seriousness of our venture while being visually appealing. - Design Elements: The pitch deck should make use of infographics and charts, images and illustrations, as well as typography and layout. All these elements should be balanced and well integrated to enhance the overall presentation. Market Research: While not the primary focus, a component of market research to identify potential investors an...
I'm in need of a comprehensive Excel workbook that can assist in managing and scheduling both staff and volunteers. The workbook should be capable of: - Scheduling staff and tracking days off - Computing hours and calculating salaries Additionally, the workbook should enable viewing the schedule in Gantt charts. Ideal candidates for this project should have a strong background in Excel, particularly in creating complex workbooks with various functions. Experience in HR or volunteer management is a plus. Please note, I will be providing the data necessary for hours computation and salary calculation.
...Email ID (if available) Key Guidelines: 1. Accuracy: Ensure the data matches the right company and individuals. 2. Relevance: Only collect details from the specified departments or leadership levels. 3. Uniqueness: No duplicate entries; only one set of data per company. 4. Professionalism: Emails should be valid, active, and professional in format. Delivery: - Compile the data into a structured Excel or CSV file using the above format. - Ensure the file is easy to navigate and filter for quality assurance. Let me know if any clarification is needed! If you going to start chat with me come with your pricing....
I'm looking for a LinkedIn expert who can help me to enhance my presence on the platform. The primary goal of this project is to comment, network, and connect with people across the platform. Key Activities: - Commenting on posts: I want you to actively engage with relevant content on LinkedIn. - Networking ...Networking with professionals: I need you to identify and connect with key players in my industry. - Connecting with new people: Expanding my LinkedIn connections is a key part of this project. The ideal freelancer for this project should have: - A knack for networking - Excellent communication skills - Proven experience with LinkedIn engagement - Ability to comment on posts in a way that adds value and showcases expertise Daily Requirements - 50-60 comments Con...
I need a freelancer who can assist me with data extraction from PDF files. The task involves: - Extracting text content from PDF files. - Accurately entering the extracted data into an Excel file. Ideal skills and experience for the job: - Proficiency in data entry with high attention to detail. - Prior experience with PDF data extraction and Excel. - Ability to maintain confidentiality and handle sensitive information with discretion.
Are you new to freelancing or looking for a simple way to start earning money online? Whether you’re a beginner or experienced, this task is designed for anyone who wants to generate income without requiring special skills. Here’s your chance to kickstart your freelancing journey and gain valuable experience while earning bonuses for achieving milestones! •What You’ll Do: Promote Our Website: Share the website with your network via social media, chats, emails, or word of mouth. Generate Leads: Encourage them to sign up and make a profile on our website through your unique referral link. •Requirements & Extra Benefits: No Special Skills Required: We provide all the resources and training to get you started. A smartphone or computer with internet access. Gr...
...implement unit and integration tests to ensure code quality and functionality. Pages and Components (Detailed) Here's a breakdown of the pages and the functionality/components they will need, you can use this list when talking with the freelancer: Homepage (/) Purpose: The main entry point of the website, introducing Idealistic Solutions. Components: Hero Section: Headline (Compelling and clear value proposition) Subheadline (Brief explanation of what Idealistic Solutions does) Call-to-Action Button (e.g., "Explore Our Services," "Get a Demo," "Contact Us") Potentially an Image/Video/Animation related to the SAS industry About Us Teaser Section: Brief Company Introduction Key values or mission. Link to the About Us page. Services Highlight Sect...
I'm looking for an experienced professional to assist my company with creating invoices online.
I'm looking for a skilled data analyst and Python programmer to create a code in Jupyter Notebook for analyzing data from Excel files. The project involves: - Primarily focusing on data analysis - Utilizing Pandas and NumPy libraries Ideal candidates should have: - Extensive experience with data analysis and Python programming - Proficiency in using Pandas and NumPy - Ability to work with Excel files - Familiarity with Jupyter Notebook Please include in your bid examples of similar projects you've completed. You are required to write the necessary program and create an effective presentation describing: The military spending of at least the top 10 nations (in military spending) Compare the data to that country’s GDP, Compare the data to the overall mili...
I'm in need of an Excel expert who can help automate some of my book-keeping tasks. The main focus will be on reconciling accounts. Your responsibilities: - Utilise experience with excel formulas and macros to refresh existing reconciliation process for the book-keeping and management reporting of a small UK charity. - Ensuring accuracy and efficiency in the automation. Ideal skills and experience: - Proficiency in Excel, particularly in using formulas and creating macros. - Background in book-keeping and accounting. - Experience in automating tasks in Excel.
Professional Freelancer | Delivering Excellence with Creativity and Precision Hi, I'm Amith sharma, a dedicated and versatile freelancer with a passion for creating value through innovative solutions. With expertise in ux, poster, video designing, communication and much computer knowledge, I help businesses and individuals bring their ideas to life while meeting their goals effectively. What I Offer: ["Custom video editing and uiux designing tailored to your brand identity."] ["High-quality content writing that captivates your audience."] [ "Responsive and user-friendly websites to enhance your online presence."] Why Choose Me? Attention to Detail: I ensure every project is polished and meets the highest standards. Timely Delivery: Deadlin...
We are migrating data from our current ERP system (that is stored in an SQL database) to Microsoft Dynamics Business Central Cloud. The source database structures is different than Business Central. We have been able to reverse engineer both the databases and create ERD models and DDL scripts. Also we know how to create Dynamics APIs and use AL to interact with Dynamics. We are looking some consulting advice on how best migrate the data into dynamics. For example looking for ideas how to best table and field match, what software tools to use, best proccess etc for this ETL project. Please describe any experience you have with ETL/migrating data between different systems. Please add the word DYMANICS123 to the start of your proposal so we can weed out automated responses. Thanks...
I'm looking for an Excel expert who can create a dynamic data visualization tab for analyzing financial data specifically for ROI metrics. The main focus will be on cost savings and investment returns. Key Requirements: - Use of Charts and Graphs: I need clear and engaging visual representations of the data. - Pivot Tables: Help in summarizing the data and making the analysis more manageable. - Conditional Formatting: To highlight key trends and important information in the data. Ideal Skills: - Advanced Excel: Proficiency in using Excel's more complex features. - Financial Analysis: Understanding of financial data and metrics. - Data Visualization: Ability to present data in a clear and engaging way. Please only bid if you can deliver a high-quality, profession...
...concept for a straightforward 2-player table game, similar to the complexity of blackjack. I am seeking a developer who can initially create a basic, functional version of the game that 2 people can play online. Once this initial version is operational, we can explore enhancements such as animations, sound effects, and eventually, multiplayer support. Key Responsibilities: - Develop a simple, web-based 2-player table game - Implement basic game mechanics and rules - Collaborate on adding features post initial development Future Considerations: If the game proves to be enjoyable and functional, there is potential for this project to expand into a full-fledged app. Ideal Skills: - Game development experience - Proficiency in web technologies (JavaScript, HTML5/CSS3, React) - Str...
I need someone reliable to input data from PDF copies of timesheets from our construction crews into Excel for weekly costing purposes. - Data: Approximately 80 sheets per day, each covering 5–20 personnel - Delivery: I will send these sheets in a couple of batches on Friday / Monday. I need the completed task back first thing Tuesday. - Duration: This will be a weekly task for the next three months. - Resources: I can provide the employee names in Excel format, which will help improve data validation and accuracy. Skills and experience: - Proficiency in any spreadsheet software (Microsoft Excel, Google Sheets, etc.) - Experience in data entry - Attention to detail - Good communication skills Communication: My preferred method is email. I need someone who is...
I am looking for someone to copy and paste ALL the titles from my website into an Excel sheet You must copy and paste everything, EVERYTHING, EEEEEVERYTHING I will check only once and, if I find anything missing, the job will be rejected I have three websites. the budget is CAD$30
I have a corrupted Excel file that I'm unable to recover myself. The file contains complex formulas, and I'm unsure how it was corrupted - it could have been from a software crash, a virus attack, or an unexpected shutdown. - Any experience with data recovery from Excel files would be a plus
I'm in need of a T-shirt designer who specializes in typography-focused designs. I have some reference pictures in a modern style that I would like to emulate.
I'm in need of a professional who can create a product sales invoice in Excel for my business. The ideal freelancer for this project should have extensive experience with Excel and be able to incorporate specific features into the invoice. Key features include: - Automatic tax calculation - Discount options - Customizable logo and branding Each invoice needs to detail each product with: - Product description - Quantity and unit price - Product code or SKU It's crucial that the freelancer understands how to design an invoice that is both functional and visually appealing, reflecting my brand identity.
I have a 30-page PDF spreadsheet that is currently a scanned image. I need this data transcribed into Excel. The data is consistent across the pages, but primarily consists of text and some numbers. Key requirements: - PDF is a scanned image - Data is text-based - Needs to be converted into Excel Ideal skills: - Proficient in data entry and transcription - Familiar with Excel - Attention to detail to ensure accurate data transfer
...and Nontraditional Aviation Operations for Wildfire Response. Engage New Entrepreneurial Talent: Spark innovation by encouraging participation from new entrepreneurs and diverse talent pools, fostering fresh perspectives to address Climate challenges. Participants are required to develop a Challenge Submission that includes the following key elements: A well-defined business model and value proposition statement that incorporates NASA climate or Earth system data sources to deliver a service or product Assessment of market fit and customer base potential including preferred data delivery formats for customers Description of the business’s unit economics Commercialization plan that can be used in a SBIR Phase I application and addresses the business&rsq...
I need an Excel spreadsheet to monitor the billed hours of each of our automotive technicians, as well as their total team hours each day. This tracking should be in relation to the daily goals we've set for them. This website gives some example of what I'm after Key Features: - A bar chart graphic display to visualize the data (along with actual numbers) - Tracking for individual technician hours and combined team hours - Comparison of hours worked against daily goals for individual as well as team -The graphic should represent how close to the set goal they are. Below 80% is red, 80-99.9% is yellow and 100% and up is green. Our automotive technicians are paid a bonus based their actual billed hours vs their target goal for billed hours. Also as a
I'm seeking a skilled WordPress developer to refresh my website's design and enhance its functionality. Key Tasks: - Redesign the site with a focus on a multi-column layout. - Update the navigation and layout aspects. - Install and configure plugins to improve site functionality. Ideal Skills: - Proficient in WordPress. - Strong design sense, especially with multi-column layouts. - Experienced with WordPress plugins. - Good understanding of user-friendly navigation systems. Please include examples of previous WordPress design and functionality projects in your proposal.
I'm looking for a comprehensive three statement model to assist with investment analysis on the company ASML. This model should encompass the following financial statements: - Income Statement - Balance Sheet - Cash Flow Statement In addition to ...to the standard financial statements, the model should also include: - Discounted Cash Flow (DCF) analysis - Comparable company analysis (Comps) - Sensitivity analysis Ideal candidates should have extensive experience in financial modeling and investment analysis. Proficiency in using Excel for complex calculations is crucial, as is a solid understanding of DCF and Comps methodologies. A background in finance or a related field would be beneficial. Your expertise will help guide investment decisions based on the insights p...
I'm seeking an experienced SQL professional to take an advanced Hackerrank SQL assessment on my behalf. The test evaluates various SQL skills and knowledge and is timed; with a duration of approximately 2 hours. Key Requirements: - Complete the assessment within the 2 hour time limit - Demonstrate expertise in the following topics: - Joins and Subqueries - Aggregations and Group by - Indexes and Optimization - Ability to write complex scripting queries Please note, specific SQL standards or databases are not focused on in the test as this question was skipped. However, a general understanding of various SQL databases would be beneficial. Ideal Skills: - Advanced SQL knowledge - Proficient in writing scripting queries - Ability to...
I'm looking for an experienced Web3 developer to help create a unique dApp on the Solana blockchain. The dApp will be designed for a fun, interactive, community-oriented purpose, much like a social network but with the added layers of decentralization and gamification typical of DAO platforms. Key Requirements: - Deep understanding and proven experience in developing decentralized applications (dApps) - Proficiency in the Solana blockchain - Familiarity with DAO principles and gamification techniques - Strong skills in blockchain integration and smart contract development - Creativity and ability to design engaging, user-friendly interfaces Your bid should reflect your ability to deliver a high-quality, engaging dApp that meets these specifications.
I'm seeking a modern-style embroidery design centered around the theme of "shelf life." The design should equally emphasize the concepts of time expiration and value. Key Design Elements: - Incorporate food items to represent shelf life. - Use clocks and watches to signify time expiration. - Include product packaging to depict value. The ideal freelancer for this project would be an experienced designer who understands modern design aesthetics and has a strong background in creating intricate embroidery designs. Creativity, attention to detail, and an ability to balance complex elements within a design will be key to success.
