Vba import data project excel jobs
...specific MLB data. Essential parts of this data include game statistics, player performance, and team standings. The spreadsheet should be organized in a user-friendly way as mentioned below: 1. Date Range: The spreadsheet must cover a specified date range, which I'll provide upon hiring. 2. Included Players/Teams: The spreadsheet should cover designated players and/or teams - the specifics of which I'll supply once you're on board. 3. Additional Factors: In keeping with the finer details, the spreadsheet should also cover the Date of Game, Team A vs Team B data, analysis on which pitcher is better, and predictions on which team will win. The ideal candidate will have a strong background in data manipulation, particularly in Excel or...
I am looking for a software solution to extract exam questions and answers from PDF files and organize them into an Excel spreadsheet. The extracted data should be structured such that each question is listed in one column, its corresponding answers are listed in subsequent columns, and each row represents a single question and its answers. Project Requirements: PDF/Doc Parsing: The software should be able to parse PDF/Doc files containing exam questions and answers. Extracted data should include the question text and its associated answers. Data Organization: Questions should be listed in the first column of the Excel spreadsheet. Answers should be organized in subsequent columns, with each answer corresponding to the respective question. The nu...
I'm looking for a skilled professional who can create more than 10 bar charts for a PowerPoint presentation. Requirements: - Proficiency in Microsoft Excel - Experience in visualizing survey results - Strong understanding of chart design principles The charts will need to visually represent survey data in a way that's engaging and easy to understand. Your role will be crucial in transforming raw data into meaningful insights. Please include relevant experience in your bid, and share any similar projects you’ve worked on in the past.
I'm searching for a Shopify expert who can seamlessly import reviews into my Shopify store from another Shopify store via a specific plugin. Subtle Points: - You should have prior experience in not only importing reviews but doing so specifically through the plugin. - Please be knowledgeable about the different formats reviews could be stored in, although in this case, it's specifically via a plugin. Skills and Experience: - Extensive experience with Shopify, particularly in importing/exporting data - Proficient with plugins and their utilization for data transfer - Specific prior experience with the concerned plugin - Excellent problem-solving skills for any unexpected issues during import - Diligent attention to detail to ensure all reviews are i...
...two data entry projects. The tasks involved include: 1. Updating Gas Station Addresses: - The spreadsheet requires updating existing address data for about 80 gas stations based in Jamaica. - I have a specific format that I require this in, which I will share with you upon commencement of the project. 2. Car Make & Model List: - The second spreadsheet requires the creation of a comprehensive list of car makes and models, supplemented with brief, succinct descriptions of each car. - I have a list in word document, there may be some duplicates and there could also be more that I have not considered The successful freelancer need not have to be a subject matter expert, but should be able to undertake data entry tasks with accuracy and ...
I need help with a moderately complex data cleaning project. My spreadsheet data has missing elements that need addressing. What this entails: - Locating and dealing with missing data in the spreadsheets - Proposing solutions to prevent future missing data The perfect candidate would proficient in Excel or similar spreadsheet software, and have a keen eye for detail. Past experience with data cleaning would be advantageous.
I'm seeking a skilled individual to automate a series of tasks on Microsoft Excel, Sharepoint, Microsoft Teams and Email, using Pulover Macro and AHK where needed. Requirements include: - Automating a series of tasks in Microsoft Excel. This includes data manipulation, data analysis and reporting. The process is already mapped out and can be shared with you. - Using Pulover Macro and AHK, as well as VBA to facilitate the automation process. - Ensuring the automation process involves uploading files to Sharepoint, sending messages on Teams, and emails. The key deliverable for you is not just the completion of the automation process, but a clear and concise explanation of each step once the task is finished. This will be crucial for future troublesh...
I have a list of contacts in an excel file, and I need someone to find their email addresses. - The main task will be to locate and verify the email addresses of these contacts. It is crucial that the emails provided are accurate. - The purpose of this exercise is for personalized outreach to these individuals and not for mass email marketing or research purposes. The ideal freelancer for this job is someone with excellent research skills, an ability to meticulously verify information, and experience in email marketing or personalized outreach. A high level of proficiency with Excel is also required. Files: There are lots of entries that need to be completed. you will need to add the email address of
We are looking for a highly skilled Technical Support Specialist to join our team remotely. As a Technical Support Specialist, you will be responsible for providing excellent customer service and technical assistance to our clients. Your main duties will include troubleshooting hardware and software issues, managing device configurations, and providing account support. To excel in this role, you should have a strong technical background, excellent problem-solving skills, and the ability to communicate effectively with customers. Skills required: - Technical troubleshooting - Device management - Account support - Customer service - Communication skills
I need an Excel sheet that can help me analyze customer information for trends and patterns. This will involve: - Basic Formulas and Functions: The data room should have basic formulas and functions that allow for the easy manipulation and analysis of customer data. - Data Room Design: The sheet should be designed to be user-friendly and intuitive, making it easy for me to analyze the data without getting lost in the spreadsheet. - Data Analysis: The main goal of this project is to analyze the customer data for trends. So, the ideal freelancer will have experience with data analysis and the ability to create custom formulas to uncover patterns. - Attention to Detail: Accuracy is key in this project. I need someone wh...
I am looking for a skilled Alteryx expert who can take on a project involving data blending from complex Excel spreadsheets. The project specifically involves: - Utilizing Alteryx for blending data from multiple sheets in Excel - Handling complex data structures within the Excel spreadsheets, including nested tables and formulas. Ideal candidates will have: - Proven experience with Alteryx, particularly in handling data blending tasks - Strong understanding of complex data structures, like those found in nested tables and formulas in Excel This project requires a high level of attention to detail and proficiency in data manipulation, so please only apply if you have the necessary expertise.
...(RTB) works within traditional waterfall project teams or within a strategic, agile, DevOps project team. Observing and documenting the current state objectively and develop clear solution requirements through influence, facilitation, and communication. The individual will gain an understanding of the customers, identify business problems that need to be solved, and document the current state drivers of those problems. The individual will need to map process flows, capture data requirements, create user stories, and document findings in a format understandable to all stakeholders. The Functional Business Analyst 2- RTB will serve as a liaison among IT, business partners, product owners, architects, data analysts, quality assurance analysts, project man...
I need a freelancer proficient with both Excel and Photoshop for two primary tasks. Excel Work: - Conduct data analysis and create visualizations, leveraging skills in updating and organizing data Photoshop Work: - Provide graphic design and photo editing services Ideal candidate should have solid experience in both platforms and a keen eye for details. Understanding my needs in data management and visual design will be a key success factor.
...one for my website. There are some extra columns in certain tables in the new database, so understanding the essence of the project is pivotal. Here's what I need assistance with: 1. Importing Data: I have a detailed list of specific tables and columns which need to be brought into the new setup. Your work will heavily rely on this list. 2. Data Combination: While importing the data, some of it requires merging. I won't be able to guide you on how this should be done, so it will fall under your professional judgment. Your proven experience and innovative strategies will come into play here. I am hoping to find someone who has extensive experience in MySQL, data merging, and database migration. Should you comprehend the project's su...
I'm in need of a SketchUp expert to complete a basic context model. This project is primarily for architectural visualization, so the focus is on creating approximate representation of the basic shapes and structures, using a google maps 3d import as a guide. I've set up the file, so it just requires the rest of the buildings to be modelled. Ideal Skills and Experience: - Proficiency with SketchUp. - Previous experience in architectural visualization projects. - Strong understanding of basic building structures. - A keen eye for detail and design aesthetics.
hello everyone we have a CRM which allows us to manage our customers, a CRM entirely coded by us in html php and javascript. we have started to integrate a function which allows us to insert customers into our CRM using an excel file, but I don't have the time to finish that. It must be ready before the end of the day, today! mandatory deadline. if we are satisfied we will entrust you with many other missions on this brand new CRM
I am in need of an individual with skills to assist with the migration of data from FS5 and .IDX files. My project involves: - files in FS5 or .IDXfiles that need to be migrated into a usable, readable CSV format that can be edited a - Handling text data specifically, and ensuring its integrity is maintained throughout the conversion. Potential freelancers need to have: - Knowledge of FS5 /.idx files. - Strong knowledge and understanding of text data management. - Excellent problem-solving aptitude, as the difficulty level can vary across files. I look forward to a thorough demonstration of your ability.
As a vendor, I have three excel sheets containing product numbers and corresponding data. Both sheets are error-free and completely filled in, but the second sheet has its entries in a mixed order. I need a freelancer who is adept in working with Excel to match the data in the sheets based on product I.D number using the product numbers and or product name (TRS Direct Sheet) to match the size dimensions in the other sheets as highlighted via colored columns (must match colors) Sheet format cannot be moved or changed or altered in the cells already published on the 2 sheets as listed only the DATA MASTA it effects the upload process. area highlight pink no information or changes to be made or added please scroll through to observe existing pink cells. Her...
I'm in need of an adept hydraulic or fluids engineer to create a PVC pipe gold trap tailored specifically for high water flow. Key components for this project would be: - Efficiency: The design should excel in gold particle collection, regardless of particle size - from less than 0.5mm to 2mm. - Adaptability: The trap will be utilized in a sandy soil environment. - Durability: The trap should possess a high erosion resistance to exceed in everyday wear and tear in mining operations. Your expertise in fluid mechanics, material selection and applying scientific principles to practical application would make you an excellent fit for the task. An understanding of the gold mining process would be a plus but isn't necessary. I'm looking forward to discussing your i...
As your client, I'm looking for a specialist having a proficient knowledge of Microsoft Excel to achieve a simple data manipulation project. The task involves predictive analysis of data, heavily leveraging date and time functions. Key Responsibilities: - Manipulating data using simple Excel functions. - Predictive analysis using Excel based on the manipulated data. Ideal Candidate: - Sufficient proficiency in Microsoft Excel, with specialised expertise in date and time functions. - Strong attention to detail and accuracy in data entry and analysis. - Superior skills in organising and ability to handle increasing complexity when required.
I am seeking a skilled freelancer to manage my MLS listings. Your responsibilities will include: Propli task: New Development upload Requirements: we are looking for a data entry team to upload and update the details of new development constructions project on the Costa del Sol (southern Spain) As a starter project, we will provide you access details to one developer’s website (Nvoga) where they have 11 different projects listed. Your “intro” job will be to extract the information from the “Salvia” development (No.3 on the page) in that site and insert it into our site. We have also provided a few videos showing a complete walk-through of the process 2 of the projects which you should be able to use as a reference. Once we have checke...
I'm seeking for an expert in Excel VBA with strong debugging and troubleshooting skills along with the ability to optimize the performance of existing macros. The key responsibilities would be: - Debugging and troubleshooting my created Excel VBA Macros - Enhancing the efficiency and performance of these Macros - Inclusion of new features as required - And finally be able to explain the code for each module. What I'd really value is a clear and concise explanation of what each module does, and this requirement would be fulfilled best by providing detailed comments in the code. This project is perfect for anyone with a deep understanding of Excel VBA, Macro functionality, and a passion for clear and enlightening code documentat...
...PrestaShop and data migration who can efficiently perform a full data import from my current PrestaShop 1.7.5 site to the new version, 1.7.8. Specific Requirements: - Absolutly all data should be transferred. - The primary focus will be on migrating 'Customer Data' and 'Order history'. Therefore, these two areas have must be accurately and efficiently imported without loss. There are around 40 items to be imported, 900 customers. The new graphics will need to be set as per my instructions for the "warehouse" theme, The development web space for the new site is already ready with the new wharehouse theme already installed. Ideal Skills: - Proven experience with PrestaShop is a must, particularly with data...
I'm in need of an expert who can proficiently convert a 12-page Excel document into an editable PDF while maintaining its original layout. Key requirements: - Preserve the current layout of the Excel document in the converted PDF. - Ensure the PDF is editable not a read-only. - Important: There are links and media embedded in the Excel document that must remain functional in the PDF. Ideal skills to have: - Strong experience with Excel and PDF conversions. - Attention to details especially concerning layout preservation and media functionality. - Excellent communication skills to address any clarifications promptly. This project requires specific expertise, and the exact replication of the Excel layout is critical. If you feel suited fo...
I'm seeking a SQL and snowflake expert. I have a small table in snowflake, for which I need a view to be created. The view will have some failed from the table and then some calculated fields based on the original table. Needs to be done asap. Will share the table data and columns of the table in and excel sheet and the desired results as well for your reference.
To fill ...Expert who can efficiently create a dashboard that helps in tracking and visualizing Employment Metrics. Key Project Requirements: - Connect and import data from CSV files - Visual representation of data utilizing Line charts, Bar charts, and Geographical maps - All visualizations must be designed to track Employment data pulled from a pre-existing census Ideal Experience: - Proven experience in creating interactive Tableau dashboards - Proficient in handling CSV data within Tableau - Excellent experience with line charts, bar charts, and geographical mapping - Experience in employment data analysis or HR data visualization is a distinct advantage This is a fascinating project that needs advanced skills on Table...
...for Electronics and Automotive. - Filter by Specifications: There should be a feature that allows users to filter parts based on specifications. The site should be sleek, modern, and easy to navigate. It should also be optimized for mobile use. Please note, I don't have any specific color scheme or branding preferences, so you'll have creative freedom in that regard. Ideal skills for this project include: - Proficiency in web development - Experience in developing similar navigation systems - Knowledge of user experience and user interface design - Ability to optimize websites for mobile use If you think you're the right person for the job, please get in touch. Examples
...extracting or scraping the subscriber data from a large Telegram channel and groups. The ultimate goal is to invite these subscribers to my own channel. Key Results: - Extract or scrape customer data from specified Telegram channels or Groups. - The type of data required is mainly (phone number - user) - Extracting data from private channels or groups - Provides a complete list of extracted customers - Ensure customer data is ready to easily import into my channels for invitations Ideal Skills & Experience: - Proficiency in web scraping tools and techniques - Experience with Telegram algorithms - Experience with Telegram API or similar platforms - Proven track record in handling and managing large amounts of data - Strong communicat...
I'm in need of a skilled developer with expertise in Yii framework to add new functionality to our existing system that serves a financial services purpose. The successful candidate will be responsible for implementing the following features: - Add menu new menu item...to add new functionality to our existing system that serves a financial services purpose. The successful candidate will be responsible for implementing the following features: - Add menu new menu items using the language file - Bank statement mapping - Bank statement import - Bank statement transaction allocation A full specification is available for the selected candidate. Ideal skills and experience for this job include: - Proficiency in Yii framework - Strong PHP skills I look forward to your proposal fo...
I am in need of a dedicated, smart, and detail-oriented Virtual Assistant to help me for 10-20 hours per week with specific emphasis on data entry and analysis. Key tasks will include: - Data input - Data categorizing and sorting - Providing analytical summaries of data - Exploring trends and patterns - Collaborative problem-solving based on findings The ideal candidate should have strong experience with data entry, analysis, and Microsoft Excel, along with solid administrative skills. Attention to detail, strong organizational skills, and the ability to work independently are crucial for this role. If you're versatile, motivated, and have an analytical mind, I would love to have you on my team!
I need a skilled freelancer to convert several Excel spreadsheets into interactive PDF files, preserving the original Excel formatting. The converted PDF files should retain all functionality, including interactive components such as forms or clickable links. Ideal Skills: - Proficiency in Excel - Expertise in PDF conversion with interactive elements - Exceptional attention to detail to ensure formatting preservation Experience Required: - Extensive experience in converting Excel to interactive PDFs - Proven track record of working with similar projects from the past - Familiarity with handling complex Excel formatting.
I'm on the lookout for proficient freelancers who excel in web development, app creation, and video editing. This is a great opportunity for those who are able to deliver top-notch results efficiently and at a reasonable cost. What I'm Looking For: - Web Development: The primary focus is on creating an e-commerce website. Ideal candidates should possess a strong foundation in e-commerce website development and a keen eye for design. - App Creation: I'm seeking app developers with a proven track record. Your ability to develop seamless, user-friendly apps that deliver a great user experience is essential. - Video Editing: Skilled video editors with experience in producing high-quality, professional results. In Your Application: I'm most interested in your exper...
I am looking for a data scraper to extract information from the JazzCash agent locator list available on their website (). Key Requirements: - I need the data to be delivered in an Excel spreadsheet format. - The specific details that I require for each Jazz locator are the Name and Address, along with the Services offered. - The scraping needs to be done only once; it will not be recurring. Ideal Skills and Experience: - Proficiency in web scraping, particularly using tools like Python's Beautiful Soup or Scrapy. - Experience in extracting data from websites with dynamic content. - Strong attention to detail to ensure accurate data extraction. - Previous experience with similar data scraping projects will be an advantage. I am particularly...
I am seeking a skilled freelancer to guide me in creating Power Automate flows that efficiently import data from a single worksheet Excel document into Dataverse. Key Tasks: - Develop a couple of Power Automate flows to import Excel data into Dataverse. - I have had many difficulties with date and lookup/choice columns not correctly importing. Ideal Candidate: - Expert knowledge and experience in Power Automate. - Proficient in Data Integration between applications. - Knowledgeable in creating approval workflows and automated notifications. - Previous experience with Excel-data integration into Dataverse. - Excellent communication skills.
I am looking to create an Excel tool that will streamline our disbursement process. The tool needs to handle data entry automation, calculation of disbursement amounts, and generation of disbursement reports. Key Features: - Data Entry Automation: This will help us input information quickly and without errors. The tool should automate data entry to reduce human error and increase efficiency. - Calculation of Disbursement Amounts: Once the data is entered, the tool should automatically calculate the disbursement amounts based on predefined criteria. This will help us ensure that the amounts are accurate and consistent. - Generation of Disbursement Reports: After the calculations are done, the tool should be able to generate reports in a clear and user-...
I'm in need of a talented full-stack JavaScript...developer can provide recommendations and explain their platform choice, whether it's React.js and Node.js, or Angular.js and , or Vue.js and Django. Your role will encompass both front-end and back-end development. To excel in this job, you need to have: • A strong grasp of full-stack JavaScript development • A robust knowledge of various frameworks • Experience in building web applications • Excellent problem-solving abilities and detail-orientated approach • Strong communication skills to ensure clear discussion of the project details and progress This project is a fantastic opportunity for developers with the right skills to help shape an innovative web application. Let's...
I'm currently in need of a competent individual proficient in data entry tasks. The ideal candidate must have strong experience and skills in managing and operating data with Excel Spreadsheets. Your task revolves primarily around: - Data entry into an Excel Spreadsheet Experience with Excel Spreadsheets is a must for this project. Perfect attention to detail and accuracy are vital. Applicants should be able to work autonomously and deliver high-quality results. Please note that the type of data to be handled has not been specified; it may include text, numerical, or image data.
...structured sales data. Key Project Details: - **Cloud Platform**: The ideal candidate should have proficiency in Azure to run machine learning models effectively. - **Primary Goal**: The primary purpose of this data analysis is to enhance our customer segmentation strategies. As such, the project will require a deep understanding of customer behavior and sales patterns. - **Data Type**: The data provided for this project is structured, primarily in Excel and CSV files. Your ability to effectively manipulate and analyze this data will be crucial. Ideal Skills and Experience: - Proficiency in Azure and strong experience in running ML models on the platform - Proven track record in customer segmentation and sales data...
I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks
We are engaged in the bag industry import and export supplier of the company, is committed to providing customers with more cost-effective bag production services. Now we need an engineer to help us build a company promotional page, which is required to meet the aesthetics of European and American customers. If you are good at it and interested in this job, welcome to contact me and communicate the design details. Please confirm with a reply starting with Hello World.
This project requires a freelancer with advanced skills in Excel. I am outsourcing tasks revolving data management. Key Aspects include: - Advanced manipulation of Excel functions - Complex calculations - Refined data analysis When applying, please focus on: - Your practical experience with similar tasks Having realized the depth of this project, it's pivotal that you have an advanced understanding of Excel. Ideally, your background should perfectly align with data management, advanced calculations, and analytical tasks. Demonstrating this through past projects and describing your specific insights gained from those experiences will be a big plus.
I am seeking a highly skilled freelancer to undertake a multifaceted project involving the detailed completion and enhancement of a CSV file for upload to Square. This extensive project requires three core competencies: meticulous data extraction from our website, proficient data entry into an Excel form, and the creation of engaging service descriptions using AI tools. The ultimate goal is to craft a CSV file that not only meets but exceeds the requirements for Square's platform, ensuring a seamless upload process. Key Responsibilities: Data Extraction and Accuracy: Initiate the project by extracting data from specific sections of our website. This data must be accurately transcribed into an Excel form, adhering ...
I have a Java application currently running on Java 8 that demands an urgent cert...application currently running on Java 8 that demands an urgent certificate update. The application connects with an AWS RDS instance using PostgreSQL and current requirements necessitate an upgrade to a new certificate. Upon successful import and upgrade of the new cert in the AWS environment, the change then needs to be effectively verified through a manual testing process. Skills & Experience required: • Profound understanding of and substantial experience in Java 8 • Experienced working with AWS RDS (specifically PostgreSQL) • Capable of certificate upgrade & import in AWS • Well-versed in manual testing procedures. Please, only submit a proposal if you ca...
I require an Excel specialist proficient in creating dynamic and functional spreadsheets. This project involves designing a new Excel sheet that handles both numerical and text data. You would need to: - Set up the sheet, capable of performing multiple features such as automated calculations and conditional formatting rules. - Configure simple calculations for GP indicators basing on specific cost prices. - Ensure the spreadsheet can efficiently process a mix of numeric and text data. Strong skills in Excel and data management are essential for this project. Familiarity with advanced Excel functions and an ability to provide quick, efficient solutions to data processing problems would also be very beneficial. A good u...
...professional with a strong background in Excel to develop a keyword search tool for an Excel database. This tool will primarily be used for filtering data and linking to articles hosted on a network. Key Requirements: - Experience creating and managing Excel databases - Proficiency in implementing keyword search tools in Excel I would like the sheet to have a Main/Search Page and another page for the database. I want to be able to add new entries to the database section and have them be searchable on the main page. I want to be able to create new searchable keywords on the database page and have them populate and be searchable on the main page. I would like to be able to enter multiple search terms into the search box to narrow the results. Proj...
...IMMEDIATELY! - Extract data in a specified format. - Transfer data from the price listing PDF to an Excel spreadsheet. - Input details such as SKU, Name, Description, Brand, Cost Price, Length, Width, Height, and Weight, which are highlighted in blue. - If any title or heading is not mentioned in the details provided in item #3, add it to columns U-Z. - Ensure all data is formatted correctly, with names in proper case and prices as numerical values. I'm in need of a proficient data entry freelancer to help convert a scanned image PDF to an Excel spreadsheet. Key Details: - The PDF contains less than 50 pages. - The data in the PDF is in the form of scanned images, making it crucial that the freelancer has experience in...
I am seeking a skilled freelancer to guide me in creating Power Automate flows that efficiently import data from a single worksheet Excel document into Dataverse. Key Tasks: - Develop a couple of Power Automate flows to import Excel data into Dataverse. - I have had many difficulties with date and lookup/choice columns not correctly importing. Ideal Candidate: - Expert knowledge and experience in Power Automate. - Proficient in Data Integration between applications. - Knowledgeable in creating approval workflows and automated notifications. - Previous experience with Excel-data integration into Dataverse. - Excellent communication skills.
I'm launching an import and distribution enterprise and require an impressive, eye-catching logo that captures the spirit of our new business. The logo's color scheme must include Red, White, and Blue and incorporate a "Star" symbol. Although our business focus is global, our primary target markets will be Chile, New Zealand, Australia, and China. Key Qualities To Reflect In Design: - Innovation - Reliability - Stability - Trust - Confidence Skills & Experience: - Previous experience in designing logos for startups or import/export businesses. - Strong understanding of color theory and symbolism. - Ability to effectively incorporate symbols into design. - Proficiency in contemporary design trends. - Familiarity with cultural nuances of our target mar...
