Excel macro pull data internet jobs
I am in need of a proficient Excel Expert for data filtering and formatting. You must exhibit exceptional skills in the mentioned areas: - Filtering: Your role will include filtering my data sheets as per specific conditions. Mastery in this area is a must. - Formatting: I need my numbers formatted in a general fashion for proper import. Therefore, a comprehensive understanding of number formatting is necessary. This project requires advanced working knowledge of Excel and a meticulous eye for detail. For successful completion, you need to display exceptional proficiency in Excel's data filtering and a deep understanding of general number formatting.
I'm looking for a meticulous data entry specialist adept at managing Excel files. Your responsibilities will include: - Copying and pasting information; - Organizing and cleaning the data; - Verifying the accuracy of the data. Specific skills and experience required for this project include: - Proficiency in Microsoft Excel; - Experience in data cleaning and organization; - Competence in data verification. Your objective will be to manage and improve the overall quality of our Excel data and to carry out your tasks efficiently. Consideration will be given to freelancer applicants with proven track records in similar projects.
I am in need of a professional who can expand and improve my overall online presence. I didn't provide specifications related to any particular google reputation issues or aspects of my online presence to prioritize, thus, it's a broad-scope project aiming at both the eradication of any existing issues and preventive measures for future internet reputation management. Ideal candidate should possess: - Expertise in online reputation management - Proficiency in Search Engine Optimization (SEO) - Experience with various social media platforms, blogs, and review sites - Strong understanding of Google's ranking algorithms and SEO tools. The goal is to suppress negative information, if present, and ensure positive online presence across multiple platforms. Please provid...
This project is about creating a professional yet creative business profile (information memorandum) for a business brokerage, powered by an easily updatable Excel back-end. I'm looking for someone with strong document design and spreadsheet expertise. At the moment we have the attached document that is both out of date (design wise) and requires 100% data input from staff. I am wanting a document that answers can be imported directly from excel. The generated profile will be about 20-25 pages long and include approximately 60 distinct data fields, these fields will be collected from each client and answers stored in an excel sheet. The idea being - we need a beautiful document that can have easily duplicated merge fields. - Company name and sum...
...visibility, I am determined to build a strong online reputation through genuine Google reviews. It is imperative for these Google reviews to be professional, real, and accurately reflect my hard work. I want freelancers to help me achieve this goal, and attract more clients with high-quality reviews. Ideal candidates should: - Understand the importance of online reviews in building a strong Internet presence - Be skilled in crafting professional, succinct reviews that highlight specific attributes The reviews should prominently highlight: - Quality of service - Professionalism - Responsiveness Freelancers who have experience in online reputation management or similar projects will be given preference. I want to work with a freelancer who can demonstrate an understanding of...
I'm seeking a talented graduate graphic designer capable of creating an appealing, bright, and colorful...And for version two upload it to a standard free media player so subscribers can get it into email. This needs to be print ready and i need fast turn around with few if any back and forth questioning. - Strong grasp on modern design principles and decisiveness - Ability to translate both informal and professional tones visually - Ability to engage with a young, professional demographic To excel in this task, ideally you will have: - Prior experience in designing for print media especially newspapers - Ability to deliver innovative and playful layouts minimalistically - Fluency in Adobe Creative Suite or similar tools I look forward to seeing your fresh, dynamic, and ...
I need to find an online sales person to help us get sales on the internet.
I need an expert to modify my existing Excel spreadsheet and transform it into a fillable PDF form. The interactive form will contain a description field, checkboxes, date field, price fields, perhaps one calculation but that isn't necessary. I have attached a sample of the excel file. There may be a few changes. Does this sound like something you can do? Here's what I'm looking for: - Ideal Skills: Extensive experience with Excel and PDF form creation is a must. - Experience working with custom fonts and graphics that will need to be duplicated onto the form -Experience: Please include any previous work involving the conversion of an Excel file into a fillable PDF form. Please note that the data that needs to be captured in the fo...
Looking for a professional financial analyst adept in scrutinizing balance sheets. - Your primary task will be financial statement analysis, specifically focusing on the balance sheet. - Proficiency with Excel spreadsheets is crucial as all data will be provided in this format. Ideal Skills: - Comprehensive knowledge of financial statement analysis - Expertise in Excel - Proven experience in financial analysis, particularly balance sheets. The perfect freelancer will have a keen eye for detail and the ability to draw insights from financial data. Budget is 50$
I need assistance in creating a VLookup formula in Excel to fetch matching data from another worksheet. Having already identified the columns, the formula should be designed to fetch data from the specified columns. Freelancers with extensive experience in Excel formulas and in particular, the creation of VLookup functions, are highly preferred. Knowledge, skill, and proficiency in Excel spreadsheet manipulation are essential.
Go over two excel sheets and highlight records from first sheet containing specific text from the second sheet
I require a tool or script that can effectively convert my checking account bank statement from PDF to Excel. There are 4 bank accounts, from 2017 to 2023 - totaling 159 files in PDF. - 2 accounts from Santander - 2 accounts form Caixa Economica Please find attached 2 PDF files as an example. For Caixa Economica statements, there are only 2 PDFs (one for each account). For Santander, the PDFs are divided by month. Details: - Critical data fields to be extracted include: transaction date, transaction description, transaction amount, number of destination accounts for PIX, TEDs and DOCs (bank transfers), and account balance. Ensure accuracy in these fields during conversion. - The Excel spreadsheet should have 4 tabs, one for each bank account. - The converter shoul...
I am in need of a proficient Excel expert for some unknown tasks. Since I haven't detailed the specifics, I would like potential freelancers to be adept with: - Formulas and calculations - Data analysis and reporting - Data manipulation and formatting Whether it's creating a new spreadsheet or modifying an existing one, I will need help. Therefore, display adaptability and experience in various Excel scenarios. Your application should include past work, experience and a detailed project proposal despite the brevity of my requirements. Please provide as much detail as possible in your proposal, due to the unspecified nature of the tasks.
I'm seeking a skilled Excel user for formula automation and chart creation in my project. Your role includes: - Creating Excel formulas that automate various functionalities. - Incorporating charts into the spreadsheet to visually represent the data. Although the specific type of charts hasn't been specified, a proficiency in creating diverse types of charts (including bar, line, and pie) will be advantageous. A strong understanding and experience with Excel formula automation and data visualization are essential for this task.
I'm in need of an expert with proficiency in Excel and Quickbooks. An Excel spreadsheet needs to be created. The data dump will be provided, your task will be to extract specific information from it. The needed data includes: - Sales data (Date and Customer name, Amount and units sold) - Expense details (Date, Vendor name, and rental paid per unit) Need various information to be in one place and one click. The extraction process must be automated and compatible with Quickbooks for seamless integration. The ideal candidate should have experience in data extraction, Microsoft Excel, and Quickbooks, as well as exemplary accuracy skills to ensure the data is free from mistakes.
I'm in search of a proficient, creative Shopify designer who has the ability to design a visually appealing and functional website for my Fashion and Apparel eCommerce business. Ideally, you should have: - A strong portfolio in Shopify website design, preferably with experience in the fashion sector. - An intuitive understanding of designing for an adult audience (26-50 years) considering their internet browsing habits, style preferences and buying behavior. - The ability to visualise and implement an engaging, easy-to-navigate layout that promotes products effectively and maximizes conversions. - Willingness to collaborate on design options and translate my brand vision into the website aesthetic. I'm open to ideas, suggestions, and I trust your expertise to design a s...
I am seeking a freelancer who excels in using Excel to manage large data sets. You will need to perform specific tasks, including: - Data Filtering: Skilled in using various Excel functions to sort and filter large amounts of data. - Basic Arithmetic Operations: Proficient in performing addition operations on the data set. - Statistical Analysis: Capable of conducting descriptive statistical analysis on the data provided. The ideal candidate possesses an excellent command of Excel, and a strong background in statistical methodologies.
The purpose of this project is to copy the attached creatives exactly the same but to ensure the crests are in alphabetical order. I'm in need of a reliable designer who can recreate the attached design for a backdrop and a pull up banner. The design needs to be exactly the same, aside from a rearrangement of the crests. The finalized design should be saved in CMYK format for print purposes. Here's what I'm looking for in an ideal candidate: The designs need to be the exact same as the attached, only thing is the attached is incorrect as their is a crest in the wrong order. 1 x Output (For Print): 800mmx2200mm 2 x Output (For Print): 2200mm x2200mm Athlone Town AFC Bohemian FC (Please make the Red text that says Dublin Originals, curved lines and sinsce 1890 WHI...
I need to redevolop a simple shopping cart based on Excel VBA. Requirement is to rework current design and function. I prefer developer that can with russian and english language, as this would help get some information from former versions. Pls contact me. BR Michael
I am looking for a dedicated and skilled professional to fill the role of a virtual voice and messaging assistant. Key Responsibilities: - Primarily, you will be tasked with answering customer queries with clarity and precision. - Additionally, you should be able to carry out typing tasks with a quick turnaround time. Required Skills & Experience: - To excel in this role, you should have a strong background in customer service, with exceptional verbal and written communication skills in Spanish. - Experience in related roles, especially as a virtual assistant, is highly desirable. This role will require a firm understanding of my business and the ability to represent it effectively to our clients. If you can handle these tasks competently and professionally, I am eager to he...
I have to create an exe which contains data in gridview and the data also contains the path of the image. And all the images are saved inside the folder. Whose path is given in the database record. So I have to export excel from gridview. I have attached the files as an example, you can prefer that.
...find companies on the internet that utilize "Pirate Ship" for their express shipping needs. My interest is primarily focused on e-commerce, retail, and manufacturing companies that have opted for overnight or 2nd-day shipping services. Please note, your assignment will include: - Identifying such companies - Gathering specific information about them including sales revenue, company name - Collecting their contact details: name, phone number, and email address Ideal candidates for this task will possess the following skills: - Strong research and data entry capabilities - Sound understanding of e-commerce, retail, and manufacturing industries - Proficient in MS Excel or similar data management tools - Exceptional attention to detail to ensure a...
I am in need of an accounting expert with a minimum of 3 years experience to handle bookkeeping, accounts receivable and accounts payable tasks. The ideal candidate should have excellent proficiency in Excel, Microsoft Access and Netsuite. Your responsibility will include: - Maintaining and updating financial records, invoices and receipts - Performing accounts receivable/payable duties - Handling any other task that involves Excel, Microsoft Access or Netsuite. Strong attention to detail, problem-solving skills and knowledge of accounting principles and laws are required.
I'm seeking a Texas-based remote supporter to manage diverse tasks within the realms of technical troubleshooting, administrative duties, and customer support. The responsibilities include: Technical Troubleshooting: - Hardware issues: Need to troubleshoot and resolve hardware problems whenever they arise - Softwar...scheduling: Should have experience in scheduling appointments, ensuring there are no meetings overlapping Customer Support: - Must demonstrate professional interaction, resolve queries, and deliver high-quality service to our customers. Needed skills and experience: - Proven technical troubleshooting abilities - Experience in appointment scheduling - Excellent customer service skills - Reliable internet connection - Close proximity to Texas for efficient...
As an experienced user of AutoCAD bricksCAD, I am looking for an Autolisp programmer adept with the creation of tailor-made commands to enhance my workflow. Key tasks form the scope of this assignment: 1. Creating a basic electrical single line diagrams using interaction between excel data and predefined blocks in bricksCAD such as transformer, breaker, main switch board, distribution board, busbars,other electrical components.
In need of a data maestro who thrives on getting everything in order and has the ability to make Excel sing. As an experienced data entry individual, you will be tasked with the following: - Sorting and organizing data into meaningful, easily navigable formats - Mastery in crafting complex formulas to make excel work its magic - Examining and validating data meticulously to ensure cleanliness and accuracy Your extensive experience with handling numerical data, specifically sourced from online platforms, is crucial for this project. Mention your proven track record and provide specific examples of past projects in your application. Show your competence with handling online-sourced data and how you leveraged it to create insightful a...
...and names from a specific industry portal in the USA and other countries. The portal includes both individual members and companies. Approximately 6,000 emails need to be collected. Requirements: 1. Research Skills: You should be proficient in internet research and have the ability to find accurate and relevant contact information. 2. Attention to Detail: Precise data collection is crucial. Ensure that names and emails are correctly recorded. 3. Time Commitment: We expect timely completion of the project. 4. Confidentiality: Treat all collected data as confidential and adhere to privacy guidelines. Deliverables: • A well-organized spreadsheet containing 3,000 valid emails and corresponding names. Payment: • We will pay proportionately for any additional va...
I'm seeking a proficient electronics engineer to design a PCB board for a control system project. The PCB board needs to integrate key components: - A GPS Module - An ESP32 Microcontroller , Internet-POE ESP32 project is actually started, we already have the autium files with dimmension, but is full of mistakes. As an experienced professional in circuit design and prototyping, you will be tasked with ensuring these components are integrated seamlessly. Particularly, extensive knowledge in microcontrollers and GPS modules is essential for this project. The ultimate goal is a reliable and efficient PCB board for our control system.
We are seeking an experienced freelancer proficient in process management and organizational workflows to develop an enhanced new hire onboarding process template in an easy to edit format (Excel, canvas, powerpoint) with a focus on optimizing the HR team's roles. Key Responsibilities: Design and implement a comprehensive workflow that streamlines the new hire onboarding process, specifically addressing the tasks performed by the HR team across different stages. Department Talent Acquisition Team: Screen Candidates Manage the Interview Process Extend Offers Manage Pre-Screening Process Provide First Day Instructions Initiate Pre-Onboarding Packets for Candidate Completion Monitor Completion of New Hire Paperwork Monitor I-9 Section 1 & 2 Completion on First Day Candidat...
I urgently need an expert in automation with a good understanding of Excel and Notepad files to streamline my data entry process. The aim is to allow for efficient and error-free data input to reduce the amount of time I spend manually entering data. Job Requirements: - Creation of an automated system for data entry tasks - Ability to process text input and numeric input - Capability to input data pulled from other files Skills & Experience: - Proven experience in automating Excel and Notepad processes - Strong knowledge of data input methodologies - Exceptional attention to detail and accuracy - Proficiency in creating secure and reliable automation systems - Ability to deliver work promptly Please note, this project is...
...detail Page - Page Speed insights will be used for measurement - We DONT accept Chrome Lighthouse result - We ONLY accept score over 89 for the performance, other scores such as Accessibility, Best Practices, SEO will be not considered as success of the project. - We pay extra bonus if Performance score is over 97 - You have to work locally, do changes and will create a pull request to our github repo. After PR reviewed and merged it will be deployed to server by us. Performance test at will be running our page URL's VERY IMPORTANT INFORMATIONS: - No in advance payment - No payment will be done if any of 3 pages that stated above, performance score is lower than 89 Ideal Skills: - Expertise in HTML, React JS frontend development - Comprehensive
I require a professional with vast experience in data cleaning using Excel. My numeric data, currently less than 1000 records, needs some tidying. Key tasks include: - Removing duplicate entries. - Handling any missing values. - Correcting any inconsistent entries. Proficiency in Excel data tools and understanding of data cleansing methodologies are important. Candidates who have worked on similar projects will likely provide a faster turnaround.
I need an expert in Excel reporting and MIS dashboard creation to analyze and visualize my sales leads data and conversions, need to add all formulas where it I put in the team deatols with their leads and conversions and it automatically gives me the stats eith pie focus areas for tracking would be: - lead generation daily - Revenue - Sales daily Few more parametees Key requirements are: - The ability to handle large volume of data - Efficiency in creating automatic update processes, as the report and the dashboard should update daily when data comes in - Strong understanding of sales and financial metrics - Precision, accuracy, and attention to detail The ideal freelancer would be fast, reliable, and have an outstanding record in Excel and data...
I am in need of a proficient and meticulous data-entry specialist who can confidently manage text, numbers, and dates in an Excel spreadsheet. The exact volume of columns and rows is yet to be determined, but efficiency and attention to detail will be key. Additionally, the ability to potentially create a working template may be required, as this decision has not yet been finalized. Therefore, experience with Excel template design is desirable alongside robust data-entry skills.
...This includes: I WILL HAVE SESSIONS TO KNOW ABOUT PHPSTORM AND HE/SHE WILL ELABORATE HOW TO USE FOR EFFECTIVE CODING. ONLY BID IF YOU HAVE STRONG UNDERSTANDING OF PHPSTORM. 1. Code Navigation: I specifically want to master "Go to definition", "Find usages", and "Code folding". 2. VCS Integration: I need someone knowledgeable with Version Control System to show me how to effectively merge, push, and pull requests in PhpStorm. 3. Live Templates: Creating, managing, and using Live Templates is a feature I would like to take full advantage of. Ideally, I am looking for someone experienced in tutoring or demonstrating software utilization, with excellent command of the PHPSTORM environment. Familiarity with code debugging, refactoring, and completion wou...
I urgently need an experienced hand in data management. The forefront duties include: - Transferring data between multiple documents. - Sorting & filtering said data. - Internet-based data sourcing. Although not directly specified, relevant knowledge in data analysis would drastically improve the efficiency of the assigned tasks. This project requires an immediate start, eye-for-detail and an attitude for perfection. An understanding of basic data analysis and statistical manipulation is preferred, if not mandatory. Please, only those with relevant experience and immediate availability apply.
For my project, I am seeking a meticulous freelancer with strength in data entry. Here's what the task involves: - Entering text-based data sourced from various online resources. - Accurately translating the information provided into an Excel spreadsheet format. The ideal candidate should possess solid data entry skills, attention to detail, experience with Microsoft Excel, and an ability to efficiently surf the web to locate crucial data. A basic understanding of the privacy concerns associated with handling online data will also be advantageous. In summary, I need an efficient individual who can quickly turn online text-based data into ordered and professionally formatted Excel spreadsheets.
I need help setting up PowerMTA and HAProxy on a CentOS server for an effective mail system. Haproxy needs to be configured correctly in order to relay an unlimited number of private proxies to send bulk mails to the Internet. Only accept an expert who has the right expertise. Thanks
Hlo! I have done MS in statistics. I read your job description. I have expertise in SPSS, R studio, excel, minitab, quantitative and statistical analysis. I will provide you with the finest work that perfectly aligns with your time and budget constraints. Thanks waiting for your response. Regards, Hira Mahmood
...Requirements ### Admin Features 1. **User Management** - **Description**: Admins can create and delete user accounts, managing access levels within the application. - **Functionality**: Includes forms for entering user information and mechanisms for account deletion. 2. **Lead Management** - **Description**: Admins can upload leads from Excel files or enter them manually into the system. - **Functionality**: Supports Excel file uploads and manual data entry forms. 3. **Email Notifications** - **Description**: Automatic notifications are sent to admins whenever a new lead or user is created. - **Functionality**: Integrates with an email service to dispatch notifications. ### User Features 1. **Dashboard Customization** - **Description**: The user dashboa...
I am seeking a dedicated and experienced VBA developer to build an inventory management software that tracks both physical and digital...Features Required: - Inventory Tracking: The system needs to provide accurate and updated record of both physical and digital goods. - Purchase Order Management: An automated reordering function based on predefined parameters is paramount for the efficient operation of our procurement process. The ideal freelancer should have a strong background in building inventory management systems with Excel VBA as well as in-depth knowledge of automated reordering functionalities. This knowledge is critical in order to assure the success of this project. It's also expected that the candidate is proactive and asks any needed question to parse requireme...
I'm looking to collect specific details about farms in the Western Cape. The information will be used for market research purposes and should be perfectly structured in Excel format. Required data include: email & Cell number Experience in data collection, particularly in the agricultural sector, is preferred. Strict attention to detail and high proficiency in Excel are very much required. Knowledge about crops or livestock is advantageous due to the nature of data to be collected. It must be automated.
... and securely by learning more about the following features: Use, Filter, and Update a SharePoint List (Video) Manage Large List and Libraries Restore Items in the Recycle Bin that were Deleted from SharePoint (Video) Add or Remove a News Post (Video) Create a Page (Video) Collaborating in SharePoint With Office and OneDrive or SharePoint, multiple people can work together on a Word document, Excel spreadsheet, or PowerPoint presentation at the same time together. Collaborate in SharePoint Create and Share Files in a Library (Video) Share SharePoint Files and Folders Document Collaboration and Co-authoring Please note that no interactive elements, like quizzes or polls, are to be included in the slides. The ideal candidate for this job will have extensive experience with Of...
I need to know if there is a way to automate a process to transfer data from an excel spreadsheet to an organization chart in Visio. Or a way to validate the data that is on an excel spreadsheet matches what is on an organization chart and show any mistakes
I am seeking a skilled Excel specialist to create a sophisticated and intuitive spreadsheet that serves as a project management tool. The spreadsheet must include the following specific features: - Project Tracking: The main feature I need is the ability to track the progress of multiple projects. Main Aspects: - Milestone Achievements: The spreadsheet must enable tracking of various project milestones. It should notify when a milestone is due and when it is achieved. - Task Deadlines: Deadlines for each task must be clearly displayed and flag whenever a task deadline is approaching or missed. Visual Representation: - Progress Bar: The progress of each milestone contained within a project should be visually represented using a progress bar. - Color-Coded Cells: Milestones a...
I'm seeking an expert familiar with Power Automate to help create a flow that initiates when a new form submission occ...a new form submission occurs. The specifics of the job include: - Trigger Event: The flow must activate upon each new form submission. - Desired Action: After each trigger, I want the flow to capture all answers from the form submission and automatically perform data entry into an Excel sheet. Following that, the system must load the sheet into a specific workbook in SharePoint. Ideal Skills and Experience: - Experience in setting up Power Automate flows - Proficiency with Excel and SharePoint - Strong understanding of data collection and processing from form submissions If you are capable and experienced in these areas, I encourage ...
I am looking for someone proficient in Excel and familiar with MySQL databases to assist me with data collection, manipulation, and analysis. The ideal freelancer would - Have proven experience in Excel, specifically in data manipulation and analysis. - Be familiar with MySQL databases or apache spark - Understand how to generate comprehensible reports. - Possess an analytical mind to identify trends and patterns from the data collected. The purpose of collecting, manipulating, and analyzing the data is to have a single type of database for all the data-driven decisions I need to make. As such, knowledge in building and working with databases is an added advantage. To make a convincing proposal, show me how you've done...
