Odbc excel as400 vba jobs

...quiz generation, AI-generated visuals for each question, and content optimization for YouTube. The project consists of multiple quiz categories, with a structured automation system to generate videos at scale. Project Scope: ? Quiz & Video Automation Create 5 master video templates for different sports categories. After template setup, remaining videos will be generated automatically from an Excel database. ? AI-Generated Visuals One AI-generated image per question to visually enhance quizzes. Each quiz contains 50 questions, requiring 50 unique images per video. ? YouTube Content Optimization Write video descriptions, hashtags, and metadata to optimize reach. Ensure consistent formatting for all uploads. ? Quiz Categories & Timeline International Soccer Teams (211 d...

I have a significant project involving over 1000 mechanical pipes. I am seeking an expert in Navisworks with over 5 years of experience who has worked on similar projects - preferably in mining or LNG. The task involves integrating inspection data from multiple Excel CSV files into the Navis drawing. Key Responsibilities: - Reflect the inspection data over the Navis drawing. - Update Navis drawings from 3D scans. - Previous experience with data modeling. The purpose of this integration is to enable different teams to use the drawing with data to extract specific details for various purposes, including: - Maintenance schedules - Compliance reports - Performance metrics - Pipe condition and defect Reports - Clash detection and inspection report Ideal Skills and Experience: - Exper...

...industry/niche. Develop a list of target criteria based on geography, company size, industry segment, etc. Data Collection and Verification: Gather essential contact details including full name, job title, email address, phone number, company name, and website. Verify the accuracy of all data collected to ensure high-quality leads. Database Creation: Organize the collected information into an Excel spreadsheet or Google Sheet with clear, standardized fields for easy filtering and analysis. Update and maintain the database throughout the project as new leads are identified. Tools and Methods: Utilize lead generation tools, CRM systems, and platforms such as LinkedIn, industry directories, and online business databases. Employ effective research techniques and adhere to ethical ...

...layout, header/footer, font style, spacing, etc.). Implement a solution (such as a macro or easy-to-use tool) that allows me to apply this template automatically with just one click to any document. Provide clear instructions on how to use the template or macro so I can apply it efficiently to new documents. Skills Needed: Expertise in Microsoft Word, including templates and macros. Familiarity with VBA (Visual Basic for Applications) for automating tasks (if applicable). Ability to create reusable templates that are easy to implement. Strong attention to detail and an understanding of formatting best practices. Additional Information: The template should work with Microsoft Word 2016 or later. It should be easy to update or adjust settings in case my formatting needs change in...

"Seeking an expert Excel developer to create a comprehensive 5 years business plan and management tool for my organization, a Data Centre services company preparing for IPO within 5 years. Project Requirements: 1. Daily organizational health dashboard 2. Department-specific input pages (Sales, Purchase, Accounts & Finance, HR, Logistics) 3. Real-time P&L updates reflecting daily entries 4. Automatic HR expense integration (salaries, incentives) with instant P&L impact 5. Weekly performance data and ratios for investors and banks Key Features: • User-friendly interface for daily data entry • Robust data validation and error-checking • Automated calculations and report generation in various formats • Year-on-Year comparison for important parameters...

I'm in need of a field verification executiv...cover the following locations: Rajasthan, MP, UK, UP, Delhi NCR. All visits will be supported by visit photographs with Selfee of executive and Geo tagged. Verifications will be conducted multiple times in a day. Each verification must be completed within 24 hours. Verification reports should be detailed and comprehensive. The verification reports should be delivered in the format: either on call, excel, or informed punched in our software or shared over email with photographs evidence of visit duly geo tagged. Reports should include a basic summary of findings. Verification tasks will be assigned daily. Verification tasks are expected to be between 1-5 per day. Verification reports can be provided in the local language of the ver...

...Apple, Samsung, Sony), Product Name (specific model name), Release Date (official launch date in India), and Price (current price in INR). The freelancer must source data from authentic and updated sources such as official brand websites, e-commerce platforms (Amazon, Flipkart, Croma), and reputable tech review sites, ensuring accuracy and completeness. The final dataset should be delivered in an Excel or CSV format with all categories properly sorted in chronological order. Preference will be given to freelancers with experience in data collection, data scraping, or market research, especially in consumer electronics. Interested applicants should provide an estimated completion time and, if possible, a sample dataset for review. Include products released in the last 2 years. En...

I'm urgently seeking an expert raw PHP developer for short term 30 days project. T...existing PHP reporting panel with SQL-Server database at our Nikaton, Dhaka, Bangladesh office. Freelancer have to work in our physical office . It's not a remote job. MS-SQL database expertise is required. The office hours are from 9 A.M. to 6 P.M., and lunch is complimentary. The project involves: - Implementing new features. - Bug fixing. - Performance optimization. - Export options (PDF, Excel) Ideal candidates should have: - Extensive experience in raw PHP and MS-SQL Server. - Excellent problem-solving skills for bug fixing and performance optimization - Familiarity with creating user-defined filters, customizable layouts, and export options Freelancers who are able to start tom...

I am in urgent need of an expert freelancer skilled in data copying. The task involves extracting text data from an online database and transferring it into an Excel spreadsheet. Ideal Skills and Experience: - Proficient in data copying and extraction - Experienced with online databases - Highly skilled in Excel - Detail-oriented and able to maintain data integrity throughout the process

...access an Excel sheet on Google Drive and display specific information from the sheet to users on request. Key Requirements: - The bot will retrieve and display share market data from an Excel sheet. - The bot should have 5 buttons, each providing different functionalities relating to stock data. - The bot should both read and update the Excel sheet with new information. Functionality of the 5 Telegram Buttons: 1. Name of Stock Purchased by Mutual Funds as on Date 2. Fundamental Stock for Wealth Creation 3. Bullish Momentum Stock- For Intraday, Swing Or Call Option Strategy 4. Bearish Momentum Stock - For Intraday or Put Option Strategy 5. Stock where Highest Delivery was taken Ideal Skills and Experience: - Proficiency in creating Telegram bots - Experience wit...

I need a skilled freelancer who can efficiently extract social media content from various sources including websites, social media profiles, and directories or databases. The extracted data should be delivered in Excel/CSV format. Ideal Skills and Experience: - Proficiency in data extraction and mining - Familiarity with social media platforms - Experience with web scraping - Ability to deliver data in specified formats

I'm looking for a skilled data scraper who can extract emails, phone numbers, and addresses from business directories. The final product should be delivered in an Excel spreadsheet. Key Requirements: - Proficient in using web scraping tools. - Experience with extracting data from business directories. - Attention to detail to ensure data accuracy. - Ability to deliver in an Excel format. Please include samples of similar work in your proposal.

Please note that the Budget is fixed - Need very beginner skills users only - budget is a...improvement suggestions 2) Answer on your own for about 80 questions 3) Compile your answers in Excel worksheet and format as required. -this is a simple task and will require up to 5 sessions of 2 hours each via chat -Project budget is fixed and it is not by hour -Need users with beginner skills only -Please note no place holder bid - what you bid will be your final price for this task I'm looking for beginner users of social media apps to provide feedback on a new app. The primary focus is on user experience. You will need to compile your observations and feedback in an Excel spreadsheet. Ideal Skills and Experience: - Familiarity with a variety of social media apps - Basic ...

...travel data from a PDF into an organized Excel spreadsheet. The source material is PDF travel packages Responsibilities: Thoroughly review the provided PDF document. Extract data related to meet the required specifications. ( Name of hotel, travel date, Beds, flights etc..) Organize the data into a well-structured Excel spreadsheet with appropriate headings and formatting for easy search and reference. In Color Ensure accuracy of all data entries and correct formatting to maintain data integrity. Deliver a clean, searchable Excel file that categorizes different types of Hotels, rooms, according to size, type, type, and other relevant criteria. Requirements: Proven experience in data extraction and management. Strong proficiency in Microsoft Excel with ...

Please Sign Up or Login to see details.

...Specialist with experience in piping engineering to assist in converting technical data from a PDF into an organized Excel spreadsheet. The source material is the "TROUVAY & CAUVIN – PIPING EQUIPMENT 2001" book, which includes detailed specifications of pipes and pipe fittings. Responsibilities: Thoroughly review the provided PDF document. Extract data related to pipes and pipe fittings, including dimensions, weights, and specifications. Organize the data into a well-structured Excel spreadsheet with appropriate headings and formatting for easy search and reference. Ensure accuracy of all data entries and correct formatting to maintain data integrity. Deliver a clean, searchable Excel file that categorizes different types of pipes and fittings ...

Task for UiPath Developer We are currently using UiPath for automation and need a developer to enhance workflow efficiency and ensure proper job handling. Scope of Work: 1. Prevent Unnecessary Execution: After completing the scraping process for a specific date, write "Done" in the corresponding Excel sheet. Ensure the process does not continue running when there are no new tasks. 2. Automate Video Upload & Processing: After uploading a video to YouTube, take the video file and upload it to for automatic processing and splitting into clips. 3. Upload Clips as Shorts: Once completes processing, upload the generated clips as YouTube Shorts and TikTok videos. Additional Information: A detailed video explanation of all tasks will be provided for clarity...

I need a professional to assist me with Microsoft Word, Excel, and PowerPoint. Key Responsibilities: - Document Creation and Formatting: Creating well-structured documents in Word with a professional touch. - Presentation Design and Enhancements: Transforming my ideas into compelling PowerPoint presentations. Ideal Skills: - Proficiency in Microsoft Word, Excel, and PowerPoint - Excellent document design and formatting skills - Strong presentation design abilities - Attention to detail - Good communication skills Note: I am open to suggestions and further enhancements based on your expertise.

I'm in need of an Excel expert who can help me create dynamic data connections using VLOOKUP and HLOOKUP. Key tasks include: - Using lookup and reference formulas to establish these connections - Assisting with the necessary formula setup Ideal skills include: - Proficiency in Excel, particularly with VLOOKUP and HLOOKUP - Experience in creating dynamic data connections - Strong problem-solving abilities to troubleshoot any issues that arise Ensure the data connections update automatically. Please include additional data processing as part of the project requirements. part numbers

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 .

Certainly! Here's an updated version of your description, now including both Excel data clearing and technical support for mobile and laptop devices: --- **Excel Data Clearing & Technical Support for Mobile and Laptop Devices:** Are you struggling with messy Excel data or facing technical issues with your mobile or laptop? I’m here to help! With a strong background in both data management and technical support, I offer comprehensive services to ensure your technology is running smoothly and your data is organized perfectly. **Excel Data Clearing Services:** - Removing duplicates and irrelevant data. - Correcting formatting errors (dates, numbers, text). - Standardizing data entries (addresses, names, product codes). - Identifying and fixing m...

I'm seeking a project manager with expertise in performance tracking to help me customize a scorecard template I have for tracking the performance of individual project managers. The template currently tracks all projects per project manager for the current year. Key Responsibilities: - Adjust the layout/design of the existing template t...Responsibilities: - Adjust the layout/design of the existing template to better suit our needs - Ensure the scorecard effectively tracks key performance indicators: task completion rate, time management, and quality of work Ideal Skills and Experience: - Previous experience in project management - Strong skills in data analysis and performance tracking - Proficient in design/layout adjustments of Excel or similar templates - Excellent atte...

I am looking for a data entry operator who can efficiently handle text data sourced from online forms. The data will need to be entered into Excel spreadsheets. The ideal freelancer for this job should: - Have excellent attention to detail - Be proficient in data entry - Have experience working with Excel - Be able to work independently and meet deadlines - Possess fast and accurate typing skills Please bid if you're skilled and experienced in this type of work. The expected weekly volume of forms to be processed is between 100 and 500.

I'm looking for a professional who can help me develop a market risk model monitoring dashboard. This dashboard will primarily be used by our Fund Manager to keep tabs on our public, privet funds. Key Features of the Dashboard: - Monitor key metrics such as VaR (Value at Risk), Exposure Limits, and Liquidity Ratios. - Provide a user-friendly interface for real-time monitoring and li... Exposure Limits, and Liquidity Ratios. - Provide a user-friendly interface for real-time monitoring and limit checking. - Include any breaches in predefined risk thresholds. Ideal Skills and Experience: - Strong background in finance and risk management. - Proven experience in developing dashboards. - Prior work with public and privet funds is a plus. The dashboard should be developed using Excel...

For some reason, I'm unable to download the last 10 years of OHLC Nifty 50 data from my Fyers account. I need a professional to access my Windows computer, troubleshoot the issue, and download the data in Excel format. Key Requirements: - You must be able to remotely access a Windows computer - Proficient in using Fyers and troubleshooting data download issues - Able to download data in Excel format Ideal Skills: - Experience with financial data and stock market - Proficiency in using Excel - Good troubleshooting skills

Looking to Setup WhatsApp Business API for our e-commerce platform. Want to send notification , receive photo video with data from the vehicle info ,record data in excel, find info using number plate finder api, and generate QR and provide delivery tracking. Also need to send invoice and Any one already worked on WhatsApp Business API and understand it at deeper level should only bid for this project.

I need an Excel-based call tracker for my medical representatives. The project involves creating a spreadsheet with functionalities for call logging and analytics/reporting. Key Requirements: * Call logging: The tracker should allow for detailed logging of calls made by representatives. * Analytics and Reporting: I need the tracker to generate insights based on call outcomes. I will be manually entering call details, so the spreadsheet should be user-friendly and intuitive. Ideal Skills: * Proficiency in Excel and data analytics * Experience with creating tracking systems * Understanding of sales and call metrics

I am looking for a freelancer who can help me find an entry-level Data Analyst or Engineer role in the USA. I am particularly interested in the technology sector, but I am open to any type of technology ...am looking for a freelancer who can help me find an entry-level Data Analyst or Engineer role in the USA. I am particularly interested in the technology sector, but I am open to any type of technology company, be it a startup, medium-sized company, or a large corporation. Skills and Tools: The ideal role for me would require proficiency in Python and SQL, as well as experience with Tableau and Excel, and PowerBI. I am looking for a freelancer who is well-acquainted with the tech job market, has great networking skills, and can help me land a position that matches my skills and as...

I need a spreadsheet expert to help me analyze data related to divorces. The primary purpose of this project is data analysis. Ideal skills and experience for the job: - Proficiency in Excel or similar spreadsheet software - Experience with data analysis - Ability to identify trends, patterns and insights from data - Strong attention to detail

I need an Excel-based dashboard to monitor a maximum of seven items across 17 construction contractor packages. Key Data Points: - Budget and expenses - Change orders - Weekly progress reports per contractor - Resource allocation across all packages - Schedule tracking for each contractor package - Quality control measures and results Ideal Skills and Experience: - Expertise in Excel - Experience with data visualization - Familiarity with construction project tracking The dashboard should be easy to use, visually clear, and capable of tracking the aforementioned data points efficiently. Please use charts and graphs for the visualizations. Please use bar and line charts for the visualizations. Please include data filtering features to allow users to view specific subsets o...

I'm seeking an Excel expert with a solid background in accounting to enhance and redesign my current financial dashboard. Your role will involve improving the dashboard's design for better readability, adding insightful analytics, automating processes using VBA where possible, and creating custom visualizations and interactive elements. Key Tasks: - Improve the design and layout of the dashboard - Incorporate more detailed and insightful financial analytics, with a focus on ratio analysis and cost-benefit analysis - Use your expertise in Excel to ensure automation where possible - Design and implement custom visualizations, such as graphs, charts, pivot tables, and trend indicators - Create interactive elements to enhance user engagement with the dashboard ...

I'm looking for a proficient developer to create a WebAp...output of quotes, invoices, and processing of payments. Key Functions Include: - Form entry for data collection and processing information to output on a dashboard - Basic calculation functions, primarily for freight cost estimation - Integration with Excel to allow for variable data changes - Imitation of a sample WebApp we have, with additional custom features Data to be Processed: - Customer details - Job request details - Vendor details Ideal Skills: - Proficiency in WebApp development - Experience with Odoo integration - Familiarity with Excel for variable data input - Understanding of basic freight cost calculations Please provide feedback based on this description. We can further discuss the details in...

I need an Excel-based call tracker for my medical representatives. The project involves creating a spreadsheet with functionalities for call logging and analytics/reporting. Key Requirements: - Call logging: The tracker should allow for detailed logging of calls made by representatives. - Analytics and Reporting: I need the tracker to generate insights based on call outcomes. I will be manually entering call details, so the spreadsheet should be user-friendly and intuitive. Ideal Skills: - Proficiency in Excel and data analytics - Experience with creating tracking systems - Understanding of sales and call metrics

I'm looking for a data consultant to help with consolidating and analyzing a large number of Excel spreadsheets. The project involves: - Data Consolidation: Merging data from different spreadsheets into one cohesive dataset. - Pivot Tables: Utilizing pivot tables to summarize and analyze the data. - Lookups: Using lookup functions to cross-reference and find relevant data points. - Splitting of Files: Organizing and splitting data into manageable files. Ideal Skills: - Advanced Excel skills: Proficient in using Excel functions, formulas, and features. - Data Analysis experience: Previous experience in analyzing large datasets. - Attention to Detail: Ability to spot inconsistencies and errors in the data. - Time Management: Capable of working efficiently to meet ...

I'm seeking an expert in Excel who can assist with automating calculations and report generation in my bonus allocation workbook. The project requires the creation of a couple of bar and line charts, as well as help designing a tier-based system reliant on weighted project amounts determined by various financial metrics. Ideal skills and experience include: - Proficiency in Excel with a strong understanding of automation features - Experience with creating and interpreting bar and line charts - Knowledge of financial metrics and their application in project weighting - Ability to design a tier-based system. - Expertise in data visualization techniques The successful freelancer will help streamline my workbook, making it more efficient and user-friendly. The goal is t...

I'm seeking a personal assistant to help manage the bookkeeping for my stock trading account. Key responsibilities include: - Monitor trading activity for recording - Record and reconcile all transactions - Prepare trading journal and stock charts screenshoots - Ensure accurate and ti...data entry or bookkeeping, and excellent attention to detail. They should also be proficient with reading stocks price candle charts, having basic knowledge of stock trading (not mandatory), and proficient in using numerous tool for Visual illustration of trading journal, Microsoft office software with English language as these tasks may also be required. Candidates should be proficient in using Excel for financial record-keeping. The assistant will be required to handle bookkeeping tasks d...

I'm looking for a ChatGPT specialist who can integrate this AI tool into Excel for generating reports based on hospital data. The ideal freelancer for this job should have: - Proficiency in Excel and ChatGPT - Skills in AI integration - Report generation expertise Please note that the specifics of the report content have yet to be determined, so flexibility and creativity will be key to this project.

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 need assistance with handling customer data. Key Responsibilities: - Data entry - Data analysis - Data cleaning The ideal candidate should: - Be proficient in Excel. - Have experience with data management and analysis. - Be capable of cleaning and maintaining data integrity. Please note that tasks will be primarily focused on customer data.

I'm in need of a field verification executive for assisting in conducting residence, office, business and document verification du...cover the following locations: Rajasthan, MP, UK, UP, Delhi NCR. All visits will be supported by visit photographs with Selfee of executive and Geo tagged. Verifications will be conducted multiple times in a day. Each verification must be completed within 24 hours. Verification reports should be detailed and comprehensive. The verification reports should be delivered in the format: either on call, excel, or informed punched in our software or shared over email with photographs evidence of visit duly geo tagged. Reports should include a basic summary of findings. Verification tasks will be assigned daily. Verification tasks are expected to be betwe...

I have an Excel workbook that has an error in the February tab. The daily totals are not posting in the correct cells. I need you to fix this issue and ensure that the tab matches both the layout and the formula structure of the January tab. Additionally, I need the remaining months of the workbook resized to look like the January tab. Ideal skills and experience for this job: - Proficiency in Microsoft Excel - Strong analytical skills to identify and rectify errors - Prior experience with data management and workbook formatting - Attention to detail to ensure accuracy and consistency

I'm experiencing issues with Excel's conditional formatting and need an expert to help. Key issues: - Cannot copy entire conditional formatting rules across the spreadsheet. Ideal skills for this project: - Advanced Microsoft Excel expertise - Proficiency in identifying and resolving Excel-related issues - Strong understanding of conditional formatting techniques Please provide regular updates via remote. The troubleshooting will be for Excel 365.

I'm seeking an instructor to help me grasp the concept of optimization, focusing primarily on Linear Programming. As a beginner with Excel Solver, I need someone who can guide me through solving questions with various constraints. Key Requirements: - Expertise in Linear Programming. - Proficient in teaching Excel Solver. - Capable of explaining different types of constraints depending on the case study. -solve with me questions Ideal Skills: - Advanced knowledge of optimization techniques. - Strong communication and teaching skills. - Experience in using Excel Solver for complex problems. As the type of constraints we will be working with will depend on the case, I require a flexible and knowledgeable instructor who can adapt to different scenarios and explai...

I have approximately 3000 rows of data spread across three Excel 365 sheets. I need someone to extract, link, and manage this data for me. The final deliverable will be a detailed report in Excel. This report should include: - Data summaries - Trends and patterns - Comparative analysis PEASE REFER TO THE ATTACHED EXCEL FILES WHICH WILL BE USED THE SCOPE FOR THE BID IS IN THE WORD DOCUMENT There's no need for complex formulas, but the ability to identify and highlight these aspects of the data will be crucial. Your expertise in data management and proficiency in Excel will be key to the success of this project. THANK YOU FOR THE TIME TO READ AND BID

I am looking for a data operator to assist with a complex data entry project. The ideal candidate should have experience in data entry from digital files, specifically using Microsoft Excel. The work involves significant formatting and clean-up of the data. Skills and experience required: - Proficiency in Microsoft Excel - Strong attention to detail - Ability to handle complex data entry tasks - Experience in formatting and cleaning up data - Experience with creating and using Excel Macros 1 year If you are meticulous, experienced in data entry, and proficient in Microsoft Excel, please apply for this project.

I have 35 pages of handwritten documents that need to be typed in xl. The specific requirements, such as document format and font style, can be budget is $10 if you think this is good for you then you are welcome. Otherwise please do not be on this project.

I'm seeking a professional for data entry, specifically focused on numeric data. The data will be sourced from various digital documents and should be entered into either Excel or Google Sheets. Ideal Skills: - Proficient in Excel or Google Sheets - Attention to detail - Experience in data entry, particularly with numeric data - Ability to maintain confidentiality and handle sensitive information responsibly.

I'm seeking an experienced data analyst and Power BI expert to design an engaging and insightful dashboard for tracking both project progress and financial metrics in the construction industry. Key Features: - The dashboard should track project-related metrics such as completion percentage, milestones achieved, and tasks overdue. - Financial metrics shou...percentage, milestones achieved, and tasks overdue. - Financial metrics should include revenue forecasts, expense categorization, and project rating. Ideal Skills: - Proficient in Power BI - Strong background in project management tracking and financial reporting - Experience in the construction industry is a plus - Excellent data visualization skills The dashboard should integrate data from Excel/CSV files. start propos...

I need a data entry/web/Instagram scraping specialist who can help me categorize the 2600 businesses I follow on Instagram. The businesses primarily belong to the fields of architecture, construction, and development, with specific focus on: - Architects - Builders - Developers - Project ...construction, and development, with specific focus on: - Architects - Builders - Developers - Project Managers - Landscape Architects The categorization should include the following fields: - Company Name - Website - State - Profession - Do they follow me back A good command of English is essential for this task, as is the ability to follow clear instructions and input data accurately into an Excel spreadsheet. Experience in data entry, web scraping, and social media analysis would be highly b...

I'm seeking a proficient Excel user for data entry and analysis. Skills and Experience: - Proficient in Excel with experience in using Pivot tables, Formulas and calculations, Charts and graphs - Attention to detail for accurate data entry - Ability to analyze data and generate reports if needed Please note that the specific type of data and primary goal for this project have not been specified. The successful freelancer will need to be flexible and adaptable to different types of data and tasks.