Vba refresh excel web query jobs
I'm seeking an expert to assist with using the XLOOKUP formula in Excel for data retrieval purposes. The task primarily involves retrieving numeric data from multiple columns. Ideal skills and experience: - Proficiency in Excel, particularly with the XLOOKUP formula - Strong understanding of data retrieval techniques - Experience working with numeric data - Ability to work with multiple columns - Attention to detail to ensure accurate data retrieval
I have a project that involves transcribing handwritten documents into an Excel spreadsheet. This job requires careful attention to detail and the ability to accurately interpret handwriting. Ideal Skills: - Excellent typing skills - Proficient in Microsoft Excel - Strong attention to detail - Good understanding of English - Experience with data entry from handwritten documents
...Easy for Techs who work remotely to access • We can design excel template for the timesheets which can then easily be cut and pasted into Xero (our accounting package which also does our payroll). • The documents are live However, we are unsure as to whether Google Docs will allow us to do the following: • Have 1 x Google Doc with individual tabs which can be quarantined/separated so that Techs can only view their own (and not other Techs) time sheets/tabs? • Allow 2 x payroll staff working at separate locations to edit the time sheets (individual tabs?) submitted by Techs and also make comments that are visible to payroll staff only and not to Techs. Please advise if you think you can assist and set up something for us with an excel template that we...
I'm running a digital marketing agency and I'm in need of a skilled virtual assistant to help with specific projects that require the use of emulators. Your role will involve creating and managing processes on virtual platforms according to precise instructions. Key Skills: - Excellent proficiency with digital tools, especially emulators. - Impeccable organization and abi...problem-solving skills. - Highly proficient in French. - Strict adherence to confidentiality and handling of sensitive data. - A computer capable of supporting emulators like Bluestack. - Fast internet connection. - Quick response time. What We Offer: - Attractive remuneration based on your skills. - A stimulating work environment with varied projects. - Potential for long-term collaboration if you exc...
I'm looking for a professional to create a reporting module for EspoCRM. Essential Features: - Comprehensive daily sales reports focused on product and salesperson performance. - Ability to track 'Sales by Product' and 'Sales by Salesperson'. - User-friendly interface. The module must allow generating reports and being able to download them in Excel, with the possibility of filtering and viewing graphs (optional) Ideal Candidates: - Proficiency in EspoCRM and CRM systems. - Strong background in data analysis and reporting. - Excellent software development skills.
I'm in need of an Excel automation expert to help me with streamlining a master Excel sheet for online use on SharePoint. Key Tasks: - The master Excel sheet should be capable of updating multiple existing files on a daily basis. - It should also generate PDF reports as needed. - I require assistance with data validation and error checking to ensure the integrity of the data. Ideal Skills: - Proficient in Excel with experience in automation. - Familiar with SharePoint. - Capable of creating a robust system for data management. - Able to ensure data integrity through effective validation and error checking processes. The goal is to have a seamless, automated system that can take the burden off manual updates and checks. Looking forward to your bids!
I'm looking for a skilled developer to connect the user reports section of my web application to SAP Crystal Report. The application is built using HTML, CSS, JavaScript, and PHP, and the database is MSSQL. Key Requirements: - Integration of user reports with SAP Crystal Report. - Generation of reports both on-demand and at regular intervals. - Conversion of reports into PDF, Excel, and HTML formats. - Provide options for custom filters in the report generation. - Ensure the generated reports are compatible with mobile devices. - Enable sending scheduled reports via email automatically. Ideal Skills: - Proficiency in HTML, CSS, JavaScript, and PHP. - Strong experience with SAP Crystal Report. - In-depth knowledge of MSSQL. - Ability to set up automatic report generati...
I have a project that involves sorting and combining data in Excel. The task is to identify all the bins for each SKU we keep in stock, and combine all the bin names into one cell, with the total units in the next cell. Data Overview: - Total SKUs: 5000 - Total Lines: 15000 Requirements: - I will provide a specific format/template for the final output. Ideal candidate should have: - Proficiency in Excel, particularly in data sorting and consolidation. - Experience in handling large datasets. - Ability to follow specific instructions and adhere to provided templates.
I'm in need of an Excel specialist to set up an accounting system for LPG gas cylinders. The tasks the Excel sheet needs to handle are tracking inventory levels, generating financial reports, and monitoring cylinder movements. Key Requirements: - Proficiency in Excel - Experience in creating inventory and financial tracking systems - Ability to suggest effective templates and structures for the Excel sheet - Skills in setting up data importing from other sources The ideal freelancer for this project should have a strong background in data analysis and accounting.
I'm in need of a macro for Outlook that can facilitate the downloading of attachments from a selected batch of emails. Key Requirements: - Manual selection by the user to determine which emails to download from. - Post-download, the emails should...can facilitate the downloading of attachments from a selected batch of emails. Key Requirements: - Manual selection by the user to determine which emails to download from. - Post-download, the emails should be moved to a specific folder. - All file types from the email attachments should be downloaded. Ideal Skills and Experience: - Proficiency in creating macros for Outlook. - Familiarity with VBA (Visual Basic for Applications). - Previous experience with email automation tasks. - Attention to detail to ensure all attachments ...
I'm seeking a professional lead generator who can fill out missing data of 32 companies. Data already in attached Excel sheet. Just need to add missing data and founder details. The task is: 1) fill in all the missing blanks for each company and 2) list all the founders of the company in another sheet Thanks
Preferred simulation tool is ANSYS. The project requires fluid dynamics simulation. The fluid to be simulated is Water. The specific flow rate to be simulated is 0.1 m/s. Please provide the results in contours and Excel data. The simulation should use specific geometry provided. The project timeline is 2 weeks. The primary objective of this simulation is performance analysis. The specific geometry will be provided in a CAD file. Include pressure drop measurements in the simulation results.
I'm seeking a freelancer to assist in editing my CSV file. The task involves removing 2 numbers from a specific column. There are 250 entries left. it can be in 1/2 hours. Please use Excel for the CSV editing. Please save the final file as .xlsx. Create a backup of the original CSV file before editing. Please move the removed text to another column. List each removed text value in separate rows in the new column. Remove single digits only from the specific column. Please edit the first column. List the removed single digits separated by commas in the new column. Format the new column with each removed digit in individual rows. Please name the new column 'Removed_Digits'.
I need a freelanc...Extraction Details: - The data to be extracted primarily includes text content, images, and structured data like tables and lists. - The extracted data needs to be compiled and delivered in an Excel file. Ideal Skills and Experience: - Proficiency in data extraction techniques and tools. - Experience with web scraping. - Excel expertise for data organization and presentation. - Experience in data cleaning and preprocessing to ensure the accuracy of extracted data. - Proficiency in using automated scraping tools like BeautifulSoup or Scrapy. - Familiarity with programming languages like Python or JavaScript for web scraping. Please note, this project involves a one-time extraction, so no ongoing commitment is required. The extracted dataset...
I need a freelancer to compile a comprehensive Excel sheet of Indian colleges. The data should encompass: - Fees Range - Course Offered - A brief description about the college (under 100 words) - Highest package offered - NIRF Ranking - College Name - City - State - Ownership The college data should specifically cover institutions offering the following degree programs: - MBA - BTech - MBBS - LLB The following cities college should be included are: bhubaneshwar chennai bangalore mumbai pune kolkata delhi hyderbad adndhra pradesh dehradun guwahati sikkim haryana gujrat bhopal lucknow noida kanpur patna ranchi raipur raurkella bbsr jamshedpur siliguri nagpur kolapur wardha mangalore maisore goa bhillai chandigarh tyrchi Coimbatore Ideal candidates for this project should have pr...
I'm looking for a comprehensive Excel spreadsheet that lists all the accountant firms in South East Queensland, Australia. The spreadsheet should contain detailed information such as the firm's name, email, contact number, address, and names of accountants. Key requirements: - Email verification: All contact details need to be verified via email. - Use of google searches and business directories: I prefer that you source the firms from google searches and business directories. The final deliverable should be in Excel (.xlsx) format. Ideal candidates for this project should have experience in data collection and verification, proficiency in Excel, and access to google searches and business directories. The project should be completed within 1-2 weeks.
I'm looking for a professional Python developer with experience in Excel file manipulation to replace VBS scripts in my Excel files with Python scripts. The primary job of these scripts is to manipulate data within the Excel files, and I need them to be updated to use Python instead. Key requirements: - Replace existing VBS scripts with Python equivalents - Utilize data from one Excel file to modify another Tasks include: - Updating existing data in various Excel files - Making necessary changes to the data in these files Ideal skills include: - Proficiency in Python with experience in Excel file manipulation - Understanding of data manipulation tasks such as sorting, filtering, merging, and transforming data.
I'm seeking a talented designer to refresh my logo. It should align with a modern aesthetic and convey a sense of innovation and creativity. Key Requirements: - A minimalist, modern design - Utilization of specified brand colors (attached in brief) - A creative and innovative approach Ideal Skills and Experience: - Proven experience in logo design - Strong understanding of modern design principles - Ability to interpret and implement brand colors - Creative mindset to convey innovation through design Please find the detailed brief with brand colors attached.
...paid ads on Facebook and LinkedIn. Detailed information about the program and our sales process will be provided. Key Aspects of the Job: - Communicating with leads primarily via phone - Utilizing a consultative sales pitch to close sales - Receiving leads' contact information in an Excel/CSV file Ideal Candidates: - Proven experience in inside sales - Excellent communication skills, particularly over the phone - Ability to understand and implement a consultative sales approach - Comfortable working with Excel/CSV files for lead management The expected volume of leads per week is less than 50. The main goal for the Inside Sales Pro is to increase enrollment in the bootcamps. The Inside Sales Pro is expected to meet monthly sales targets. The Inside Sales Pro will b...
I'm seeking assistance with data entry. Please note that I've skipped answering some questions regarding the specifics of the project. However, I can provide further details upon request. Your ability to work with a variety of data sources and formats will be beneficial. Skills and Experience Required: - Proficient in data entry - Familiarity with Excel spreadsheets, database entry, and Word documents - Ability to handle mixed data types - Attention to detail for ensuring data accuracy - High typing speed for efficient data entry - Experience in data validation and cleaning - Knowledge of database software like MS Access or SQL - Familiarity with automated data entry tools - Understanding of data privacy and confidentiality standards - Experience with cloud-based data st...
I'm seeking a freelancer to provide administrative support for a technology development-focused R&D subsidized project. The role will involve assisting with various administrative tasks, as well as tracking expenses an...financial reporting and budget management - Familiarity with Belgian and European R&D funding processes This role requires moderate involvement in financial reporting and budget management. The freelancer will need to prepare and distribute periodic reports to update the team and stakeholders. The expected duration of the project is up to 3 years. The freelancer should be proficient in using Excel and Google Sheets for administrative tasks and financial tracking. The freelancer will check in with the team weekly to provide updates and coordinate on ...
As a small startup company in need of an HR professional, I am looking for someone with a minimum of 2-5 years experience in HR fro...recruitment, employee onboarding, and performance management. Key Responsibilities: - Recruitment and hiring - Employee onboarding - Performance management - Manage employee relations including conflict resolution and grievance handling. Tools & Software: - Familiarity with EXCEL is a must. Industry Experience: - Prior experience in the retail industry is a requirement. Ideal Skills: - Strong communication and interpersonal skills - Ability to work in a fast-paced startup environment - Proficiency in using EXCEL for HR analytics and reporting. The HR professional will be required to work remotely. This is a long-term role with potent...
I need a VBA script that can extract specific data from my Outlook emails into an Excel spreadsheet. The data to be extracted includes the sender, subject, received date, received time, whether it's a new or follow-up mail, and if it's a follow-up, when the first revert on that mail was and when the last received mail was. Key Requirements: - The script should filter emails based on a specified date range. - The script should be able to extract data from both new and follow-up emails. Ideal Skills: - Proficiency in VBA programming. - Experience with Outlook automation. - Strong understanding of Excel. Please provide examples of similar projects you've completed in your proposal. The script should be run on a daily basis. The extracted data sho...
Add excel import function in existing table. (few columns only)
I'm looking for an expert in Zabbix to create a comprehensive dashboard on the Zabbix web UI for me. This dashboard should monitor the Nexpose service and the port status of 15+ hosts. The specifics of the project include: - Displaying the service and port status in a table format for each host - Utilizing a color coding system of Yellow/Green for Warning/Up - Only indicating whether each host's port is open or closed, and service is running or the need for detailed error messages or performance metrics The dashboard needs to be able to refresh automatically and check the output from each server on a daily basis. Ideal skills and experience for the job include: - Extensive knowledge of and experience with Zabbix - Expertise in creating user-friendly and visu...
I need someone to extract tables from JPEG images and screenshots. The data includes numbers and text and should be presented in an Excel sheet with exact data and formatting including styles from the original tables. Ideal skills and experience include: - Proficiency in Excel - Attention to detail - Experience in data extraction and data entry - Ability to understand and replicate complex formatting The project involves processing between 135 JPEG images or screenshots. The project needs to be completed within 1 week.
...looking for a professional who can help me clean up my Excel file by removing disconnected phone numbers. Specifics: - I will be using Twilio as the phone validation service. - It is crucial that the disconnected numbers are completely deleted from the file, not just moved or highlighted. Ideal candidates should have: - Experience with Excel and data management. - Familiarity with Twilio or similar phone validation services. - A keen eye for detail to ensure no disconnected numbers remain in the file. - Strong communication skills to provide updates and clarify requirements. - A problem-solving attitude to identify alternative methods if issues arise. - Excellent time management to meet deadlines promptly. - Knowledge of advanced Excel techniques and functions. -...
...looking for a professional who can help me clean up my Excel file by removing disconnected phone numbers. Specifics: - I will be using Twilio as the phone validation service. - It is crucial that the disconnected numbers are completely deleted from the file, not just moved or highlighted. Ideal candidates should have: - Experience with Excel and data management. - Familiarity with Twilio or similar phone validation services. - A keen eye for detail to ensure no disconnected numbers remain in the file. - Strong communication skills to provide updates and clarify requirements. - A problem-solving attitude to identify alternative methods if issues arise. - Excellent time management to meet deadlines promptly. - Knowledge of advanced Excel techniques and functions. -...
I'm seeking a database solution designed to manage information related to disability appeals. The database needs to store: - Personal details of the applicants - C...Microsoft Access. The database should include encryption of data to ensure security and confidentiality. Each user will have distinct roles and permissions. User 1 will have read-only access to the database. Implement regular automated backups to ensure data safety. Automated email notifications should be incorporated for important dates or updates in the appeal process. The database must support Excel exports. Automated notifications should include due dates for appeal steps. Include automated email reminders for important dates or updates. The database should use a form-based layout to simplify the input and ret...
...looking for a professional who can help me clean up my Excel file by removing disconnected phone numbers. Specifics: - I will be using Twilio as the phone validation service. - It is crucial that the disconnected numbers are completely deleted from the file, not just moved or highlighted. Ideal candidates should have: - Experience with Excel and data management. - Familiarity with Twilio or similar phone validation services. - A keen eye for detail to ensure no disconnected numbers remain in the file. - Strong communication skills to provide updates and clarify requirements. - A problem-solving attitude to identify alternative methods if issues arise. - Excellent time management to meet deadlines promptly. - Knowledge of advanced Excel techniques and functions. -...
I need a freelancer to convert 43 identical-structured JSON files into a single CSV, Excel, or Google Sheets file. This task should take 15 minutes for someone with the right software. - Preferred output format: JSON (but should be converted to one of the specified formats) - File sharing: I will share the JSON files via email - JSON structure: All files have the same structure Ideal skills for this job include data processing, familiarity with JSON and CSV formats, and proficiency in using relevant software or applications for data conversion.
I need a professional Excel expert, specifically skilled at creating and implementing macros for automation. The project is focused on automating tasks within an Excel workbook. Ideal Skills: - Advanced knowledge in Excel and macro creation - Strong analytical skills - Experience with Excel automation
I'm looking for a skilled data analyst who can help me with my Excel spreadsheet. The task involves: - Organizing data related to a laboratory project - Using formulas to automate data entry validation and correction - Creating visualizations to make the data more understandable - Perform data cleansing to remove any duplicate or irrelevant information. - Use conditional formatting to highlight important data points. - Develop macros to automate repetitive tasks. - Create and configure pivot tables for detailed data summaries. - Implement error-checking mechanisms to ensure data integrity. - Perform trend analysis to identify patterns over time. - Implement advanced Excel formulas for complex data analysis. Experience with Excel and data analysis is crucial for ...
I need a freelancer to extract data from the ongoing projects page of the GSI site and organize it in a single Excel sheet. there are approx 80 entries The information I require includes: - Project Name - Commencement Date (formatted as MM/DD/YYYY) - Completion Date (formatted as MM/DD/YYYY) - Status - Cost Estimate - Cost Awarded - Project Highlights (in paragraph format) - Contractor Name - Consultant Name The ideal freelancer for this project is someone with strong data entry skills, proficient in Excel, and capable of formatting data as specified. Prior experience with data extraction and Excel is preferred.
I'm seeking an experienced data analyst to conduct descriptive analysis on my structured data, which is primarily stored in Excel/CSV files. Key responsibilities: - Conduct comprehensive descriptive analysis - Present findings in an understandable manner - Propose recommendations based on findings Ideal skills: - Proficiency in Excel/CSV - Experience with data visualization tools - Strong analytical and statistical skills - Excellent communication skills for presenting findings
I have 4 excel data sheets containing air quality sensor data regarding CO2 levels and particle matter vs time that I would like visualized into a line graph. Key Requirements: - Transform Excel data into a comprehensive line graph. - Include specific data points on the graph. The cella includes the following: - date and time of measurement - co2 levels - pm 1.0 - pm 2.5 - pm 10 (on only one sheet) Left Y-axis should display the particle matter count. Bottom half of the axis should be 0-10, the top half from 11-80. This is because fast majority of data is in the 0-10 range, but we still want to display the occasional exceedence up to 80. Right Y-axis should display the CO2 levels. The X-axis should display the date and time Ideal Skills: - Proficient in Excel an...
I'm looking for a traditional style PowerPoint slide that depicts our organizational chart. The color scheme should be dark blue and white, reflecting our company colors. Key Requirement...looking for a traditional style PowerPoint slide that depicts our organizational chart. The color scheme should be dark blue and white, reflecting our company colors. Key Requirements: - Design a circular style org chart - Use dark blue and white color scheme - Include specific categories and names as per our hierarchy - Ensure the chart is clear and easy to understand - examples included - excel document contains the content Ideal Skills: - Proficient in PowerPoint - Graphic design skills - Understanding of organizational charts - Attention to detail to accurately portra...
I'm looking for a skilled data analyst who can help me with my Excel spreadsheet. The task involves: - Organizing data related to a laboratory project - Using formulas to automate data entry validation and correction - Creating visualizations to make the data more understandable Experience with Excel and data analysis is crucial for this project. If you can put everything in spanish when you're done, that would be great. Thanks! The project needs to be completed within 4 days. (Sunday 11:59)
I'm looking for a comprehensive list of email addresses for al...Wikipedia link: Key details: - The final product should be an Excel file containing all airports and their corresponding email addresses. - You can source the email addresses from a variety of platforms including official airport websites, aviation directories, and government aviation portals. You're also welcome to use any other sources you deem fit. - The goal is to ensure that we have a complete and accurate list of email addresses for all international airports. Ideal skills and experience for the job include: - Proficiency in data collection and Excel. - Experience with web research. - Familiarity with aviation industry resources would be a plus.
Hi, I need to convert my excel made quote/invoices to html code. The html code will be use in KNACK (CRM) in the email rules to send email. I have about 20-30 templates needs done and there are all slightly different. Check one the the example.
I need someone to scan my accounting receipts and extract data solely in the form of text and numbers. The extracted data should be saved in an Excel file or can be integrated with Accounting software. Ideal Skills: - Data extraction - Attention to detail - Proficiency in Excel Experience: - Prior experience in similar projects - Accounting or bookkeeping background is a plus.
Any trending or patterns analysis across all fields in the report. Sample excel file provided when selected for the project.
...PHP-based web application and command-line script for authenticating users via OAuth2 and accessing their email messages and folders via IMAP. The solution should support both Microsoft Office IMAP (hotmail, outlook) and Google (gmail). #### Requirements 1. **Web Application** - Build a PHP-based web app to authorize users via OAuth2 for: - Microsoft accounts (work, school, or personal) using [Microsoft’s OAuth2 endpoint](). - Google accounts using [Google’s OAuth2 endpoint](). - Upon user authorization, the app should: - Obtain the authorization code and session info. - Exchange the authorization code for an access token. - Store the access token, refresh token
I'm looking for an Excel professional to help me combine about 20 financial data worksheets into one comprehensive spreadsheet with a summary page. Requirements: - Combine over 10 identical worksheets into one spreadsheet. - Create a summary page to reflect the consolidated data. Ideal Skills: - Proficient in Excel. - Quick and efficient, able to complete the task in under an hour. - Attention to detail to ensure all data is accurately combined. The worksheets all have the same structure, which simplifies the task. Please note that the task should not take more than one hour.
I'm looking for a professional Excel expert to design a comprehensive spreadsheet for monthly budgeting. The spreadsheet will need to: - Provide an overview of my monthly budget - Track all my income sources - Monitor my expenses - Provide predefined categories for expenses like groceries, utilities, and entertainment. In addition, the spreadsheet should include sections for planning savings towards specific categories, namely my emergency fund and retirement fund. Ideal skills for this project include: - Advanced proficiency in Microsoft Excel - Experience in creating budgeting spreadsheets - Understanding of personal finance and savings planning. Please provide examples of similar projects you've completed in your proposal. The spreadsheet should have color...
I'm a landlord seeking a proficient Excel expert to create comprehensive spreadsheet trackers for my property business. Key Tracking Aspects: - Rent payments: Monitor and track all incoming rent payments, ensuring timely collections and identifying late payments. - Maintenance requests: Record and manage all maintenance requests, tracking their status and ensuring timely resolutions. - Tenant details: Keep an organized record of all tenant details, enhancing communication and tenant management. - Regulation Certificates: Monitor expiry dates to ensure we are always compliant. Ideal Skills: - Proficiency in Microsoft Excel: The trackers need to be built on Excel, so an advanced understanding of this software is crucial. - Property management knowledge: Familiari...
I'm seeking an expert in quality control and process optimization to enhance my manufacturing process. My primary tool is Statgraphics, and I need someone who can leverage its capabilities to the fullest. Key Responsibilities: - Analyze and identify inefficiencies in the current manufacturing process. -...Analyze and identify inefficiencies in the current manufacturing process. - Use Statgraphics for process optimization. - Collaborate with me to develop and implement solutions. Ideal Skills: - Proficient in Statgraphics. - Experience in manufacturing process optimization. - Strong understanding of quality control principles. Please note, while Statgraphics is our main tool, familiarity with Excel, Minitab, or SPC Software may be beneficial. Focus on enhancing quality co...
I'm looking to refresh my logo. see attached existing logo. and logos i like for inspirations. PLEASE INCLUDE THE FOLLOWING: -Company's Name: SPANOS BBQ -Company's Tagline: "Hey Cowboy" -Art: An american football, a football goal post, and Texas BBQ theme
