Excel vba sql csv jobs

I'm looking for an Excel specialist who can help me compare three files containing inventory data. Specifically, I need to identify quantity discrepancies and item mismatches. Key Responsibilities: - Compare data across three Excel files - Identify quantity discrepancies and item mismatches - Create a separate summary sheet highlighting these differences Ideal Skills: - Proficiency in Excel with extensive experience in data analysis - Detail-oriented with a knack for spotting discrepancies - Ability to organize data in a clear and concise manner

I need an Excel expert to design a spreadsheet for me that includes various charts and graphs for data visualization. The project specifically requires the creation of bar charts and pie charts. Ideal Skills: - Proficiency in Microsoft Excel - Experience in designing custom Excel spreadsheets - Ability to create clear, effective data visualizations Please note, the main purpose of the Excel file has not been defined yet, hence flexibility and adaptability will be key in this project.

I'm looking for an expert in Power BI and SQL Server who can assist with data integration and transformation. Key Responsibilities: - Integrate various data sources into SQL Server - Transform and prepare data for analysis Ideal Skills: - Proficiency in Power BI and SQL Server - Experience in data integration and transformation - Strong analytical skills Please note that specific data sources and transformation tasks may be discussed further. Your ability to handle and manipulate complex datasets will be crucial for success in this project.

I'm looking for an expert in data extraction and cold outreach to help my merchant export company. Key Responsibilities: - Extract data of purchase managers from the United States, United Kingdom, and Australia. - The data should include their Name, Email address, and Phone number. - Organize the extracted data into a CSV file. Ideal Skills: - Proficiency in data extraction and analysis. - Experience in B2B cold outreach, specifically targeting purchase managers. - Familiarity with export-import industry is a plus. - Excellent attention to detail and data accuracy. Your role will be pivotal in helping me initiate email campaigns and WhatsApp bulk messages to potential business partners.

...preferences). 4. Admin Panel: The admin should have a secure login to the admin panel. Admin Features: View a list of all users who have signed up for membership. Filter users based on membership type, registration date, etc. View each user’s details, including form data (e.g., name, contact information). Approve or disapprove membership requests if necessary. Download or export user data to CSV/Excel for reporting purposes. See statistics about user sign-ups, including total users, active/inactive members, etc. 5. Data Security: All user data must be securely stored (preferably using encryption for sensitive data such as passwords). User passwords should be hashed and not stored in plaintext. Admin should have access to manage user data but should only view sensitiv...

I'm looking for a skilled Excel Macro specialist to automate the importing of data from PDF files into my Excel spreadsheet. Fixed Pay - $20 Key Responsibilities: - Create an Excel Macro to automate data entry from PDF files into Excel. Ideal Skills and Experience: - Proven experience with Excel Macros. - Proficiency in data manipulation and automation. - Familiarity with importing data from PDF files. - Excellent problem-solving skills.

I'm seeking a proficient developer to create an AI agent for me. The agent's primary function will be to locate fitness-related businesses in multiple specific regions. The collected data will need to be organized into an Excel table, including details such as: - Name and website of the business - Location and contact details - Person name and job title An example of the task would be finding all personal trainers in Redcliffe, Australia, Postcode 4020. Ideal Skills and Experience: - AI and machine learning development - Data mining and web scraping - Proficient in Excel and data organization - Understanding of fitness industry would be a plus

I'm looking for someone to help me create a financial model in Excel focused on budgeting. The primary task will be filling in the blanks with the appropriate formulas. Ideal Skills: - Proficient in Excel - Experience in financial modeling - Knowledgeable in budgeting processes Please ensure your proposal highlights relevant experience and skills.

I need assistance with matching two lists of brand and company names. The data is in Excel format. - The first list has 4 columns and the second list has 1 column. - The type of matching required is 'fuzzy match'. Ideal skills for this project include proficiency in Excel, experience with data analysis, and knowledge of fuzzy matching techniques. The work needs to be completed by Friday morning India time .

I'm looking for a skilled developer to transform my MS Excel files into a functional web application. Key Requirements: - The web application should be focused on data entry and form submission. - It should be compatible with desktop only. Ideal Skills: - Proficient in web application development. - Experience with data entry and form submission interfaces. - Understanding of desktop compatibility requirements.

I'm looking for a freelancer who can download numerical data from a specific website and organize it in an Excel spreadsheet. The data is updated daily every 3 min, so this will be a regular task. Requirements: - Download and organize all available numerical data columns from the website into Excel. - This task needs to be done daily in sync with the website's updates. Ideal Skills: - Proficiency in Excel and web data extraction. - Attention to detail and ability to follow daily schedules.

I need help fixing various SQL triggers and stored procedures that have stopped executing. The issue arose unexpectedly, and I need an experienced professional to diagnose and rectify the problem efficiently.

I'm looking for a professional Excel macro developer who can help me create a macro that extracts specific information from one Excel file and organizes it into another new Excel file. Key Requirements: - The Macro should be able to extract specific information from Sample A and make it into an organized Excel file exactly like Sample B. - NOTE: Sample A will have Comments on what specific information will be extracted and become Sample B. Hover over them to view the comments - NOTE 2: If some of the information in Sample A is Blank, then leave them blank for Sample B Ideal Skills: - Proficient in Excel, especially in creating and implementing macros. - Experience with data organization and manipulation in Excel. - Strong attention to detai...

The objective of this project is to produce an instructional video utilizing Kali Linux to transmit an observer file to a WhatsApp number. This endeavor is intended solely for educational purposes. The following requirements must be met: 1. Kali Linux must be accessed via Oracle Virtual Machine. 2. The video should detail the process of creating the file in formats such as PDF, JPG, Excel, Word, or even video or audio files. 3. The file must be recognized as safe by WhatsApp and Android security measures. 4. The file should enable the sender to view the gallery photos and camera of the WhatsApp Android device. 5. The file must not contain any malicious algorithms. To receive payment, you must demonstrate that you have successfully completed the aforementioned steps. 1. The...

I'm looking for an experienced SQL database specialist to help me design a robust database for my e-commerce platform. Key Responsibilities: - Design a comprehensive SQL database tailored for e-commerce. - Ensure the database can handle high traffic and large volumes of data. Ideal Skills and Experience: - Proven experience in SQL database design, particularly for e-commerce. - Strong understanding of e-commerce data requirements. - Ability to create scalable and efficient database systems.

I need an experienced LinkedIn professional to add leads from the Persona's we have created. Then download all of the leads to CSV file, and also utilise Sales Navigator better for a private LinkedIn business professional profile in Australia. We also have a business Premium account that needs to be utilised by an experienced Business Preium account user. We have 4 hours a week of work to start with, please quote your hourly rate.

I'm looking for a data vendor who can provide a list of homeowners in Los Angeles, California, who have expressed interest in home improvement within the last two weeks. The list should include: - Name and contact details - Property details - Type of home improvement needed - List phone numbers for quick contact. Please deliver the list in an Excel spreadsheet. Ideal candidates for this project should have experience in data collection and analysis. They should be able to provide accurate, up-to-date information in a timely manner. Knowledge of the home improvement sector would be a plus.

I'm looking for a skilled Power BI professional who can create multiple operational reports. The data primarily comes from Excel spreadsheets and will be processed through Power BI. Your proficiency in Excel is crucial. Key Responsibilities: - Create operational reports in Power BI - Utilize Excel spreadsheets and Power BI as primary data sources Preferred Skills: - Mastery in Excel - Expertise in Power BI - Experience in creating operational reports Ideal Candidate: - Able to create visualizations such as bar charts and graphs, pie charts and doughnut charts, and heatmaps.

I'm seeking a proficient SQL developer with extensive experience in Sage X3 ERP. The task is to craft a query that compiles an Inventory Valuation by Date across multiple warehouses. The valuation method is FIFO. Key Requirements: - Expert in SQL with a focus on writing complex queries within Sage X3. - Deep understanding of Sage X3's data structure, particularly inventory and valuation data. - Ability to retrieve accurate inventory valuation details broken down by date. - Skill in referencing the correct tables and fields, and applying all necessary joins and conditions. The query should accurately reflect FIFO inventory valuation across multiple locations. Experience with this ERP system is crucial for success in this role.

Need Freelancer for development of excel spreadsheet tool for financial projections, scenario analysis and presentation materials for same. Spreadsheet function is to calculate cash position and standard EBIT/EBITDA information from 2023 to 2040 (pre-revenue through profitability) for a (renewable energy) technology development and licensing company: not manufacturer, not a software developer, nor SAS provider. The basic financial structure includes simple operating cost structure, project-based revenues, non-operating income, minimal capex and equity infusion. Project Revenue Types are: • License payments based on milestones related to tangible progress for design, construction and commissioning of commercial and annual annuities (royalties) based on plant capacity (or ...

...in-game item store for players to purchase skins. Design & Inspiration The website should be clean, responsive, and professional while embodying Rust’s survival aesthetic. Developers can reference the Vital Rust Store for inspiration. Technical Requirements Frontend: Modern, responsive UI (React, Vue, or similar preferred). Backend: Secure and scalable (Node.js, Python, PHP, etc.). Database: SQL or NoSQL depending on scalability needs. Authentication: Steam API for player logins. Payment Processing: Stripe, PayPal, or equivalent. Proposal Requirements Interested developers should submit: A portfolio of relevant projects. A breakdown of technologies they plan to use. Estimated time for completion. Cost estimate and payment structure....

I'm looking for someone to collect information on over 5 million influencers from major Western social media platforms, specifically TikTok, YouTube, and Instagram. The specific data points I need include: - Influencer's Name - Channel Names on platform - Number of followers - Engagement metrics - Content topics - Channel Category - Contact information The collected data should be delivered in CSV format. Ideal candidates for this project should have experience with data collection, familiarity with social media platforms, and ideally, some understanding of influencer marketing. Proficiency in tools for data scraping and data management is a plus. Please ensure you have the capacity to handle large datasets and deliver accurate and organized information.

I need assistance exporting quotes from an Excel price list into a Word document. The quotes should be organized by product category. The exported quotes should include the following details: - Product name and price - Vendor information - Quote expiration date Ideal skills for the job include: - Proficiency in Excel and Word - Attention to detail - Organizational skills

Please Sign Up or Login to see details.

I'm looking for an Excel expert to create a variable tracking Excel file for me. I will be inputting a list of 1000 or more 3-digit numbers (ranging from 1-5) like 123, 231, 542, etc. Key Requirements: - Track the movement of each digit (whether it's +1,2,3, or 4 or -1,2,3,4, and also 0 when the number remains the same in the next sequence). - Provide a tally of movements for each digit in each position. For example, digit 1 in position 1 moved +1 75 times into the next sequence, +2 100 times, and so on. - Allow me to constantly update the list of 1000 numbers. - I will be copying and pasting the numbers into the file. Outputs/Reports Needed: - A summary table that presents the movements in a clear and comprehensible manner. - Please use standard formatt...

I'm seeking a detailed contact list of roofing, restoration, and mitigation companies located in California & Florida. The list should be compiled into an Excel sheet and include: Construction Companies: 1. Mitigation 2. Restoration 3. Reconstruction 4. Roofing 5. Water, Fire, Hail Damage. - Company name and address - Phone number and email - Key contact person's name and role - Specific roles such as Owner, Sales Managers, and HR Ideal skill set for the job includes proficiency in data collection and Excel, and ideally, some experience or understanding of the insurance roofing and restoration industry.

I need help analyzing a list of companies in Excel and identifying duplicates based on specific criteria. Your task will also involve assigning MTAuIDs to these companies according to a set of rules. Key Requirements: - Identify duplicate companies based on their Business Name - Assign different MTAuIDs to Joint Ventures - Assign the same MTAuID to DBAs, CEOs/Presidents, Trade Name companies, AKA companies, and divisions The list of companies includes additional key attributes such as Address, Email, Website, Phone numbers, and Type of Business. Please provide a description of your approach and the code you will use to solve this problem. Ideal candidates should have experience with data analysis, coding, and understanding of business structures.

I'm looking for a freelancer to assist with a copy paste and data entry project. The data is mixed - both numeric and textual - and is currently stored in various online sources. Ideal Skills: - Proficiency in Excel - Experience with Tally ERP software - Strong attention to detail - Ability to work with mixed data types - Prior experience with online data sourcing The final output needs to be in an Excel spreadsheet. Please ensure you can access and work with online data sources before bidding.

I'm seeking a data entry expert to assist with entering menu information. Specifics about the menu type, the data format, and the manner in which it will be provided are yet to be determined, but the need is immediate. Ideal Skills and Experience: - Proficient in data entry - Excellent attention to detail - Able to work under time pressure - Familiarity with common data entry software (Excel, Word, etc.)

I'm currently facing an execution error with my SQL Server. Specifically, I'm receiving incorrect results from my queries. This issue seems to stem from a problem with a particular table. As such, I'm reaching out to seek assistance in identifying and resolving the underlying problem. Ideal skills for this project include: - Proficiency in SQL Server - Experience with troubleshooting execution errors - Ability to diagnose and fix table errors - Strong problem-solving skills and attention to detail I appreciate your expertise in helping me get to the bottom of this issue.

... and manage relational (SQL) and non-relational databases for data storage and retrieval. Cloud Technologies: Leverage cloud platforms such as AWS, GCP, or Azure to deploy and manage data infrastructure. Collaboration: Work closely with data scientists, analysts, and software engineers to support analytical and machine learning projects. Data Quality & Performance Optimization: Ensure data accuracy, consistency, and security while optimizing performance. Monitoring & Troubleshooting: Identify and resolve data pipeline performance bottlenecks and failures. Required Work Experience: 2+ years of experience in data engineering or a related field. Proven experience developing ETL pipelines and data processing workflows. Hands-on experience with PySpark, Pandas, and SQL...

I'm looking for an experienced data scraper who can gather information from various social media platforms. Ideal Skills: - Proficient in web scraping techniques - Familiarity with social media platforms - Excel data management skills The scraped data needs to be compiled in an Excel format. The specifics of the data to be scraped will be discussed in further detail with the chosen freelancer. Please include relevant experience in your proposal.

Please Sign Up or Login to see details.

I'm looking for a skilled data parser who can extract product information from a specified website and organize it into an Excel spreadsheet. The data that needs to be extracted includes product descriptions. Ideal candidates for this project should: - Have experience with web scraping and data parsing - Be proficient in Excel - Have an eye for detail to ensure all data is correctly captured and organized.

...analytical skills and the ability to interpret quantitative and qualitative data. •Knowledge in validating information sources and critically analyzing data. •High level of English proficiency (C1 or higher) with advanced writing and editing skills in English. •Experience working with business intelligence reports, impact metrics, or financial analysis (preferred). •Familiarity with data analysis tools (Excel, Power BI, Tableau, etc.) is a plus. •Attention to detail and ability to manage multiple reports simultaneously. Key competencies: •Critical thinking and ability to detect inconsistencies. •Accuracy and attention to detail. •Ability to synthesize and communicate clearly. •Autonomy and proactivity in problem-solving. •Adaptab...

I need my Excel worksheet polished for print. The project involves enhancing the current layout of the worksheet, specifically to optimize it for printing. Key Requirements: - Adjusting the page layout and margins to ensure the worksheet is print-friendly. - Creating a green color scheme that is suitable for printing. Ideal candidate should have: - Proficient Excel skills especially in layout enhancement. - Experience in creating print-friendly documents.

Freelance Developer Needed: .NET Blazor Server Application with WhatsApp Integration I'm looking for a skilled freelance developer to build a robust and secure .NET Blazor Server application with comprehensive WhatsApp integration and API capabilities. The ideal candidate should have extensive experience with Blazor Server, .NET development, SQL Server, secure coding practices, and DevOps principles. Full source code sharing without any locks or time-based restrictions is mandatory. Project Overview: This application will serve as a platform for sending WhatsApp messages (both template and non-template), managing WhatsApp numbers, and providing API access to third-party applications. Security is paramount, and all development must adhere to best practices. This project will ...

I'm looking for a detailed Excel spreadsheet that covers the top 20 social media accounts for every sports team across the NBA, AFL (Australian rules football), NFL, MLB, IPL and international cricket. The accounts should span Twitter, Instagram, TikTok, and news outlets. Specific Requirements: - Top 20 Twitter accounts - Top 20 Instagram accounts - Top 20 TikTok accounts - Top 20 news outlet accounts - top 20 journalists covering the team - top 20 player accounts Each entry should include: - Account name - Profile link - Number of followers - Engagement metrics - Average post frequency: The average number of posts per day or week. Ideal Skills: - Proficiency in Excel - Familiarity with social media platforms - Ability to gather and analyze engagement metrics - ...

...growing team. Professional development and growth opportunities. To Apply: When applying for this role please include reference ATCMAX250127B when you provide an overview of top 4 reasons you feel you're suitable for this North American role. All applicants must past up to 2 levels of practical assessments to be considered for this which includes an Excel assessment. If you're not highly proficient in analyzing large amounts of data in Excel or equivalent, please don't apply....

...6️⃣ Communication Between Website and Desktop Application Develop an API or WebService to allow the desktop application to check the user’s license status. If the license is active, grant access to the application. If the license expires, the login must be automatically blocked. 7️⃣ Security Encrypt user data, especially passwords and payment information. Implement protection against attacks like SQL Injection and XSS. Use SSL certificates to secure transactions. Implement a method to prevent multiple simultaneous logins with the same account. 8️⃣ Additional Monetization - Google Ads Set up the website to sell an advertising space for Google Ads. 9️⃣ Extras in the Desktop Application Add a Disclaimer module in the application. Encapsulate the code to prevent reverse enginee...

...extension that allows users to extract lead data (emails, phone numbers, job titles, LinkedIn profiles, etc.) from websites and social media platforms (e.g., LinkedIn, Gmail, etc.), similar to Apollo, Skrapp, and Lusha. Integrate the extension with for easy export and management of leads. Build an intuitive and user-friendly interface that lets users view, filter, and export their leads (CSV, Google Sheets, etc.). Add features for email validation, contact enrichment, and automatic syncing with accounts. Ensure the extension works efficiently and is optimized for fast performance, without consuming too many system resources. Adhere to data privacy regulations (GDPR, CCPA, etc.) in terms of how data is scraped and stored. Perform cross-browser compatibility testing and debugging

Troubleshoot excel xlookup formula

...store the data in a manageable format. Key Responsibilities: Develop a Chrome extension that integrates seamlessly with major websites to scrape user contact information (email, phone, LinkedIn profile, etc.). Implement advanced search and filtering capabilities to refine data. Ensure data privacy and compliance with relevant laws (GDPR, CCPA, etc.). Build features for users to export data to CSV, Google Sheets, etc. Implement a user-friendly interface and dashboard. Perform extensive testing and debugging to ensure smooth performance. Requirements: Proven experience in developing Chrome Extensions (provide examples). Strong knowledge of JavaScript, HTML, CSS, and related web technologies. Familiarity with web scraping techniques and APIs. Ability to work with third-party serv...

...into an Excel spreadsheet. You'll be dealing with: - Data Fields: Name, Address, Email Your tasks will include: - Data Entry: Inputting the specified data fields into Microsoft Excel - Data Cleaning: Ensuring the data is accurate and free from errors - Data Validation: Adhering to unique data validation rules as instructed Ideal skills and experience for the job: - Proficiency in Microsoft Excel - Experience in data entry and data cleaning - Attention to detail for data accuracy - Ability to meet deadlines - Familiarity with data validation rules Please be prepared to adhere to: - Expected Format: Data must be entered in Excel - Accuracy Standards: High level of accuracy is required - Deadlines: Timely completion of the project - Specific Software: ...

I'm seeking a seasoned developer to create a robust web-based CRM system for my business. The system is intended to streamline the management of sales, orders, expenses, and payments, both internally and with external API servers. Key Features: - Automation of data import from CSV/XLSX files and APIs with built-in data validation - Accurate order matching - Comprehensive tracking of expenses, employee salaries, and overall profitability - Fund reconciliation capability with Binance and other payment sources - Support for multi-currency transactions - Role-based access for different user levels: Admins, Managers, and Employees - Generation of detailed financial and operational reports Ideal Candidate: The perfect candidate for this project is an expert in CRM development with ...

I'm looking for someone to send my cover letter and resume to a list of recruiters. Details: - The email addresses are in an Excel spreadsheet. - I want the emails to be personalized with each recruiter's name, but not tailored to their specialization. - I would like email to come from a gmail address Ideal skills for this project: - Proficiency in Excel - Excellent written communication skills - Ability to personalize mass emails - Familiarity with email services such as Gmail or Outlook

...Work alongside the best, elevate your skills, and accomplish things you never thought possible. * Shape the Future: Directly contribute to innovations that will redefine how things are done in the commercial real estate tech industry. If you’re not confident you’re in the top 5%, please don’t apply. We’re looking for exceptional developers who thrive on high-stakes challenges and are ready to excel in a fast-paced, dynamic environment. About Us ======== We’re a rapidly growing startup in the commercial real estate tech space, and we're looking for a Laravel Developer who’s not just skilled – but hungry to take on challenges, move fast, and make an impact. We're a small but mighty team, and we need someone who thrives in a hig...

I'm in need of a freelancer who can assist with data entry from PDF documents. The job entails copy-pasting information from these documents into Excel. Ideal Skills and Experience: - Proficiency in Excel - Experience with data entry - Attention to detail - Ability to handle PDF documents - Good copy-pasting skills

I'm looking for a skilled professional who can convert my existing Excel/Numbers order form into an online order entry system. This project will involve creating both a basic version and a database-driven version of the order form. Key Requirements: - The online order form should be integrated with a custom Order Entry System. - It would need to replicate the tabs on the excel and the basic formulas - It should have the capacity to store customer data, specifically contact information and details pertaining to my business clients and schools. Ideal Skills and Experience: - Proficiency in Excel and Numbers - Experience in developing online order systems - Knowledge of database management - Understanding of customer data storage solutions Please no...

I'm looking for someone to extract stock symbols (tickers) for companies listed on the NSE and BSE, and enter them into an Excel spreadsheet. I need this done just once, so there's no need for ongoing updates. Skills and experience ideal for this job include: - Proficiency in data entry and Excel - Familiarity with stock markets, particularly NSE and BSE - Ability to accurately extract and input data.