Excel macro internet lookup jobs
I require an expert in Excel to build a comprehensive tracking file. This task involves: - Establishing a data entry form to easily input inventory and project progress details. Knowledge of creating user-friendly interfaces within Excel is beneficial. - Implementing automated calculations to streamline the data analysis process. Strong mathematical and analytical skills are essential. - Creating a graphical representation of data to facilitate understanding. Experience in data visualization is a must. The spreadsheet will track fewer than 10 types of inventory data and project progress data. Your familiarity with inventory management processes and project tracking would be highly valuable. This assignment calls for you to use Excel's capabilities optimally to produce...
I am looking to streamline my excel data entry process. Needs centralized on the automation of numerical data entry in my Excel spreadsheets. Key requirements: - Automate simple data entry into few columns. - Experience with Excel data entry automation required. - Should have good knowledge of Excel functionalities and automations. - Ability to handle numerical data efficiently. Experience in handling simple data entry (few columns) and automating the same would be ideal for this job. Reach out if you need more information and looking forward to your expert assistance in this process improvement.
I am seeking a proficient specialist in Excel 2010, with extensive experience in the creation of VBA Macros, designing data entry sheets, automating tasks, and generating reports. Key responsibilities include: - Design and develop efficient VBA Macros - Design accessible and streamlined data entry sheets - Automate various Excel tasks for increased productivity - Generate comprehensive and insightful reports Ideally, you have advanced knowledge of Excel and VBA Macro programming, demonstrating a proven track record in dealing with complex Excel projects. A strong understanding of spreadsheet automation and report generation is fundamental to execute this project successfully.
I'm in search of a meticulous data entry specialist to assist with my Excel-related work. Key responsibilities: - Data entry: The work pertains to entering simple, text-based data into Excel sheets. - Data sourcing: This role requires you to source the data before entry. Ideal skills for this project: - Proficiency in Excel: A strong grasp of Excel functions and formulas is a must. - Data entry experience: Previous experience with data entry, especially in Excel, is preferred. - Research skills: A knack for sourcing data efficiently and accurately.
...Take pictures of the subject company and its vicinity, as per Confirmis’ standard operating guidelines. • Provide observation about the company to gauge activeness, e.g., staff working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) Lamphaya Klang, Muak Lek District, Saraburi 30130, Thái Lan • Has a camera or phone/tablet of quality with a camera, internet access • Must be available during business hours (9 AM - 4 PM) on working days Please see the attached file for the site visit guidelines. You are only required to deliver the pictures, video & observations and are not expected to put together a report like the Sample Report. Note: Milestone will be released the following week after the site ...
Confirmis ( ) is a Singapore-based business information provider specializing in connecting businesses with global capabilities; comprised of industry veterans, Confirmis business model ...operators, etc. • Take pictures of the candidate’s residential address, as per Confirmis’ standard operating guidelines. • Provide observation about the address such as the location, the building, etc • Job will only take less than one hour to accomplish (excluding travel time) REQUIREMENTS: • Must be living in (or nearby) Choa Chu Kang ST 52, • Has a camera or phone/tablet of quality with a camera, internet access Note: Payment will be released the following week after the site visit to give us time to organize the report and contact you if we need additiona...
I need a proficient Excel user to create a workbook for my multiservice business. What I Require: - The ability to record both cash, check and card income, as well as expenditure for each. This tool needs to be able to accommodate and separate these different transactions for easy access and clarity. Desired Features: - It should automatically calculate the daily and monthly income for each category. - Must also offer a daily and monthly balance for cash flow. Skills & Experience: - Strong Excel skills are a necessity. - Ideally, the freelancer should have experience with creating business financial sheets. Timeline: - I'd like this project completed as soon as possible. Urgency is key.
As an internet entrepreneur, I am on the hunt for a word wizard who can create engaging and compelling blog content. I need someone who: - Grasps the nuances of Knowledge Management - Caps off their writing skills with an intermediate understanding of the topic. Skills and Experience Needed: With your intermediate grasp on Knowledge Management and prowess in web content writing, your job is to translate complex ideas into engaging content that can engage my website's audience. An ideal candidate will be: - A seasoned web content writer with a portfolio that includes blog posts. - Familiar with writing in a relatable tone while staying true to facts. Your task is to produce blog posts that focus on Knowledge Management. I need a creative storyteller who can weave compelling ...
I'm in need of a freelancer who can assist me with the styling and formatting of an Excel spreadsheet. Your task will primarily involve applying cell style formatting. Specifically, I'm requiring assistance with: - Implementing cell style formatting. Please note that while the exact type of cell styles are not defined yet, I will be able to provide more details and guidance once the project begins. Ideal skills for this job would include: - Proficiency in Microsoft Excel - Previous experience with complex Excel formatting - Ability to work independently and on deadline Please, in your bid, include examples of any similar jobs you've completed.
I'm looking for an Azure professional who can help me set up an Azure cloud solution to host my Excel data. The project involves: - Hosting Excel Data: I will provide you with an Excel file, which I would like hosted on Microsoft Azure. The data in this file will not be updated frequently, just once for now. - Web Application: I would like the Excel data to be accessed through a web application. This means you will need to set up a simple, user-friendly interface for viewing and possibly manipulating the data. Ideal Skills: - Experience with Microsoft Azure, particularly in hosting data. - Proficiency in setting up web applications. Please get in touch if you have the right expertise, and we can discuss the project further.
Targeted party(s): 2 Company,...local and national news medias and social media in both native language and English. Example of worthy and relevant news: Court (legal) actions (either as plaintiff and/or defendant) Bankruptcy/Insolvency announcement/court judgments Significant news on the individual(s) or Party(s) as well as related family members (if any) PROJECT DURATION: 4 hrs– 8 hrs (maximum) SKILLSETS: Experienced in internet research, related to the local law; Experienced in Pre-employment background checks, legal check or HR is a plus Strong in both local and English language proficiency DELIVERY ELEMENTS: All relevant news, if reported in native language must be translated into English Weblink of the news, together with: Source link, News date, and Summary of the ne...
I am seeking a detail-oriented freelancer to input text and numerical data into 3 small Excel spreadsheets, containing 1 column each. 2 spreadsheets for emails, one called Minnesota, one called Midwest. 1 spreadsheet of inventory numbers. See attached. Only emails are needed. Inventory is on yellow paper Ideal Skills: - Proficient in Excel - Attention to detail - Knowledge of data organization and management Highlight the entries that you are not sure of, or the handwriting is to difficult to read. English fluency in a must.
The task centers around leveraging Python programming and machine learning skills to perform data analysis. The data to be analyzed are contained in an Excel sheet, specifically focusing on customer data. The ideal freelancer for this task should exhibit the following: - Strong proficiency in Python programming. - Solid experience with machine learning. - Familiarity with data analysis, particularly descriptive analysis. - Ability to accurately interpret customer data. The task requires a reading of the Excel sheet and performing data analysis based on the customer data contained within. The chosen Python and machine learning expert will focus on descriptive analysis techniques to extract meaningful insights. Your insights should guide our strategies in terms of customer se...
I'm in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Excel files, CSV files, and SQL databases - Transformation of data, including extraction and update of parameter values from Data Models in each Workspace Ideally, the freelancer would carry a strong understanding and hands-on experience with PowerShell scripting, Power BI, data transformation techniques, and working with database source files like Excel, CSV, and SQL formats.
Hello, I have 6 simple contact web forms that I would like recorded into a single matrix. The goal is to see the field alignment and comparison between the form data.
I'm in need of an expert who can efficiently extract text data from about 160 unstructured PDFs and enter it into a database. Key Responsibilities: - Extracting unstructured text data from PDF files - Accurately entering this data into a database Ideal Skills: - Proficiency in data entry - Experience handling unstructured data - Attention to detail The work will require a computer, a stable internet connection, and the ability to commit to accurate and efficient data entry. Experience with unstructured data is highly preferred.
I'm seeking an expert data analyst specializing in financial data analysis for real estate development projects. The focus will be on the financial aspects of our upcoming construction project, specifically concerning future projections for the next 10 years. Candidates should be competent in: - Creating custom excel/ google sheet template - Forecasting Capital Expenditure - Predicting Cash Flow - Delivering revenue Projections Your role will involve analyzing, interpreting, and providing insights on these aspects. Proficiency in financial modeling and forecasting is a must. Knowledge about the construction sector will be highly regarded, and prior experience in real estate development is a bonus. To make informed decisions, we're relying on accurate and in-depth anal...
I'm in need of an experienced TikTok video content provider to create short promotional videos for my internet cable service. Key Requirements: - Video Content: I am looking for engaging, attention-grabbing content that showcases the benefits of our service. - Video Length: Each video should be less than 15 seconds. Please include your experience in your application. I'm looking forward to seeing your past work and detailed project proposals.
...with a focus on Object-Oriented Programming (OOP). The application will be simple yet effective, featuring offline usage capability which is crucial for productivity in various environments. Key Requirements: • Application Compatibility: The app must be compatible with Windows, Mac and Android platforms. • Offline Functionality: The app should allow users to continue using without a constant internet connection. Skills and Experience: • Proficient in Java OOP. • Extensive experience developing applications for different platforms. • Good understanding of implementing offline capabilities in applications. Application Guidelines: • Freelancers are required to provide detailed project proposals, showcasing how they plan to approach the project,...
I need a skilled Excel professional to help me with data analysis and manipulation using the Solver add-in to solve optimization problems. Key Requirements: - Perform data analysis and manipulation in Excel - Apply Solver add-in to solve optimization problems Ideal Skills and Experience: - Strong proficiency in Excel - Prior experience with data analysis and manipulation - Familiarity with Solver add-in in Excel - Ability to interpret data to solve optimization problems - Attention to detail and accuracy for successful data manipulation Please include your relevant experience and how you can address the task described above in your bid.
I am looking for a skilled Excel dashboard developer to build a proficient tool to track vital business metrics a balance scorcard. The ideal candidate for this job should have: - Expertise in creating user-friendly KPI and balanced scor cards dashboards. - Understanding of various KPIs including revenue growth, customer acquisition, and conversion rate. Key Project Details: - I already have specific KPIs to be tracked and would share them with you post project initiation. - The dashboard should be designed to automatically update on a monthly basis based on manual input that would be added to calculation sheet for each kPI. - The dashboard must be easy to read, understand, and interactive. - the dash board should include risk alert for KPIs we are falling behind in My expectat...
I'm in need of a skilled professional who can create a Terraform script to build my AWS infrastructure from scratch. Key Components: - The infrastructure should be deployed inside its own VPC in AWS - The infrastructure should deploy an RDS database, specifically MySQL, that is securely accessible from the backend and frontend servers, but not accessible from outside the VPC or internet. Instance size: , allocated storage: 100Gb. Admin user/password should be supplied as variables -- I will specify them in the command line. Also a separate user account should be created to access this database. The user should have read/write access, I will again supply the username and password via command line. - The solution should include a set of servers to run both backend and frontend ...
...personal tax return. However, I'm now urgently in need of a tax return amendment specialist who can swiftly and accurately adjust elements of my tax return. This will encompass the following areas: - Income adjustments -Write off my home write i conduct business at. -I use my vehicle -[Removed by Freelancer.com Admin for offsiting - please see Section 13 of our Terms and Conditions] meetings internet I'm looking for someone with specific experience in these areas who can decipher complex financial information with ease and deliver accurate results. The task is to be completed impressively swiftly - on the same day. I expect the freelancer to be wholly familiar with 1040 X filing, comprehensive in understanding deduction that can be written off whizz at navigating in...
This is a Fulltime Project for Someone Speaking Excellent English And Spanish. 30-40 Hours A Week Hi, I am looking for a virtual assistant that is bilingual in Spanish and English and is available to work from 9am PST until 3 or 5pm PST Monday through Friday for a doctor's office long term (>12 months). Must have reliable internet. Duties include - data entry - translating over the phone - calling people to obtain information - scheduling appointments - responding to emails and voicemails - using a Slack like program You will have weekly meetings to answer any questions with the doctor (who is also bilingual). You will have access to a mentor/support team. You will be given scripts to use and specific questions to ask. You do NOT have to: scribe, create social media, c...
I'm looking for an Excel expert to develop an NSE options chain tool that will provide real-time data. The primary goal of this software is to facilitate educational purposes by explaining the basic concepts of options trading. Key Requirements: - Real-Time Data: The tool should be able to fetch and update real-time data from the NSE options chain. - Educational Focus: The content presented should be geared towards explaining the basic concepts of options trading in a clear and easy-to-understand manner. - Excel Proficiency: The ideal candidate should have a strong command over Excel and be able to integrate real-time data sources effectively. Ideal Skills and Experience: - Advanced Excel Skills: Proficiency in VBA and data connections is a must. - NSE ...
...English. - Example of worthy and relevant news: o Court (legal) actions (either as plaintiff and/or defendant) o Bankruptcy/Insolvency announcement/court judgments o Significant news on the individual(s) or Party(s) as well as related family members (if any) Requirements: 1. Fluent both orally and written in English and the local language (Khmer) 2. Have good research skills, and experience in internet research, preferably business-related 3. A native of India, domiciled in Cambodia DELIVERY ELEMENTS: • All relevant news, if reported in the native language (Khmer) must be translated into English • Weblink of the news, together with o Source name o News date Note: Milestone will be released the following week (Monday) after the job completion to give us time to org...
I'm in need of an Excel expert who can help me automate data entry and formatting tasks. I also need assistance in creating a macro to generate daily status reports. Key Tasks: - Automate data entry tasks - Automate formatting tasks - Create a daily status report macro Requirements: - Proficiency in Excel and VBA macro creation - Experience in automating data entry and formatting - Previous history of generating reports using VBA - Strong communication skills and ability to understand and translate my requirements efficiently.
I'm in need of a skilled Excel expert who can assist with advanced formulas and functions. The main task will be related to carrying over formulas in both the same sheet and different sheets. Key requirements: - Advanced knowledge and experience in Excel formulas and functions - Proficiency in carrying over formulas across multiple cells and sheets - Ability to efficiently manage and implement complex formulas Your responsibilities will include: - Identifying the most suitable formulas based on specific requirements - Implementing the formulas accurately and ensuring they work correctly - Carrying over these formulas as needed across multiple cells and sheets If you're an Excel guru with a strong background in advanced formulas and functions, and are conf...
...company and its vicinity, as per Confirmis’ standard operating guidelines. • Provide observation about the company to gauge activeness, e.g., staff working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) National Highway Khon Buri, Khon Buri District, Nakhon Ratchasima 30330, Thailand • Has a camera or phone/tablet of quality with a camera, internet access • Must be available during business hours (9 AM - 4 PM) on working days Please see the attached file for the site visit guidelines. You are only required to deliver the pictures, video & observations and are not expected to put together a report like the Sample Report. Note: Milestone will be released the following week after the site visi...
I need a skilled Excel VBA Macro expert to develop a VBA macro that can automate reports, specifically with numerical data. Your task will revolve mainly around creating a function that streamlines the reporting process, making it efficient and error-free. Ideal Skills: - Extensive knowledge in Excel VBA - Strong background in automated reporting using Excel - Familiarity with handling numerical data Experience required: - Prior experience developing Excel VBA macros - Proven track record in creating automated reports .
...English. -Example of worthy and relevant news: o Court (legal) actions (either as plaintiff and/or defendant) o Bankruptcy/Insolvency announcement/court judgments o Significant news on the individual(s) or Party(s) as well as related family members (if any) PROJECT DURATION: 4 hrs – 8 hrs (maximum) SKILLSETS: - Thai native with strong language skills is prioritized -Experienced in internet research, related to the local law; -Experienced in Pre-employment background checks, legal check or HR is a plus -Strong in both local and English language proficiency -Knows the sources to conduct Litigation and Bankruptcy check in the Thailand + has extensive skills in public domain and social media researching. DELIVERY ELEMENTS: -All relevant document and news,...
...and verifying professional credentials and contact details. Responsibilities: Systematically collect and verify contact information and qualifications of therapists and autism specialists, ensuring that all data is up-to-date and accurate. Utilize a range of sources such as professional healthcare directories, medical institutions’ databases, specialized LinkedIn searches, and other reliable internet resources. Organize data into a structured directory format, detailing names, specialties, practice locations, phone numbers, and email addresses. Ensure compliance with data protection regulations and maintain confidentiality while handling personal data of healthcare professionals. Provide regular progress reports to the management team, highlighting insights into the data ...
I'm in need of an experienced individual to expertly handle data entry tasks. Specifically, the role will involve inputting personal customer details into databases. Ideal Skills and Experience: • Proficiency in using Excel • Attention to detail • Experience in data entry, particularly with personal customer details • Ability to handle confidential information responsibly Your primary task will be to input data accurately and efficiently. Please ensure you have the above-mentioned skills before bidding. A keen eye for detail and confidentiality are paramount.
I need a proficient Excel macro creator to help with tasks involving data automation and formatting. The macro will need to work seamlessly across multiple sheets in Excel 365. Key tasks involve: - Automated data entry across multiple Excel sheets. - Formatting the entered data to adhere to specific standards. Ideal Skills and Experience: - Advanced knowledge of Microsoft Excel 365. - Complete understanding of Excel Macro creation. - Demonstrated ability to automate data entry and formatting in Excel. Your commitment to timely and accurate results will be highly appreciated. Thank you in advance for your time and efforts.
As the project owner, I'm looking for a skilled professional to create detailed AutoCAD drawings for the electrical services of a building. The level of detail required is macro-level, focusing on building wiring. This project is for a college assignment. The project requires the preparation of the following AutoCAD drawings: Containment Drawing: Showcasing the paths and management of electrical conduits and other containment systems. All containment will be mounted on suspended Unistrut brackets, with a minimum of 800mm of space above the false ceiling. Single Line Schematic: A detailed schematic for the main distribution board, illustrating the arrangement and connections of switches, fuses, circuit breakers, and other electrical components. Layout Drawings: These will in...
I have a current report in Excel 365 that I'd like to improve. Key Requirements: - Automate formulas to avoid errors: I need an expert to automate specific formulas in the report, which primarily involve Sum, Average, and Count functions. - Complete totals by searching information in the other existing sheets: For this, the formulas should pull information from Sheet 1, Sheet 2, and Sheet 3 to ensure the accuracy and completeness of the totals. Ideal Candidate: - Experience in Excel 365, particularly in automating formulas and cross-referencing data from multiple sheets. - Attention to detail and the ability to ensure the accuracy of the final report. This project is ideal for someone who is skilled in Excel and has experience in managing complex data set...
...implementation of a customer database. This database needs to be user-friendly and efficient, allowing salespeople to easily manage and access customer information. Offline Functionality: While I'm not entirely sure if offline functionality is required, it would be beneficial for the app to have this capability. This would ensure that the salespeople can continue to work efficiently regardless of their internet connection. Ideal Skills: - Experience in cross-platform mobile app development (iOS and Android) - Proficiency in customer database implementation - Understanding of offline functionality in mobile apps This project is very important to me, and I'm looking for a developer who can deliver a high-quality, user-friendly mobile application that meets the needs of...
I'm seeking a proficient app developer to create a business app primarily for Android maybe iOS. This app should be primarily centered around the ability to post "whitelist sessions" to car parking enforcement software via JSON. Key App Features: - Posting whitelist sessions to car park enforcement software - Backlogging user entered information if posting fails due to internet connection or any other reason - Ability to customise user interface for each client - Ability to specify how long each whitelist session is i.e. 2 hours, 3 hours, 1 day etc etc. Given the technical nature of the app, the potential freelancer should possess the following skills and experience: - Proficiency in Android app development - Familiarity with business app development - Understand...
I need an Excel budget tracker developed, with specific focus on tracking and calculating expenses related to my business. - The tool should enable me to manually enter expenses and automatically sort these costs into categories. - The main category of interest is 'Commercial Expenses', so having a well-defined, categorizable section for this is important. - I additionally require a feature for budget calculation, providing an easy-to-understand analysis of financial outgoing compared to overall budget. Ideal freelancers for the job would be those proficient in Excel and financial analytics. Experience in developing similar budget tracking tools would be a valuable addition. I have a base of what I need. I need the budget data tab updated with the new budget as w...
I'm in need of an Excel expert who can assist me with a project that involves data analysis, financial calculation, and advanced formula and functions. This project involves working on a single Excel file with the main goal of improving data organization. This requires a hands-on approach, strong problem-solving skills, and a keen eye for detail. Skills/Experience Needed: - Advanced Excel proficiency - Strong background in data analysis and financial modeling - Experience in creating complex formulas and functions - Excellent organizational and problem-solving skills. Your work will be instrumental in streamlining our data handling processes and make them more efficient. Please provide examples of similar projects you've worked on in the past.
I'm looking for a talented video editor who can enhance my YouTube content. Key requirements include: - Expertise in editing YouTube videos specifically with a dynamic and engaging approach. - Ability to deliver polished edits within a tentative duration of 5-10 minutes per video. - Proficiency in creativity and storytelling,...not specified a particular style. - Willingness to work on a continual basis as the frequency of videos is high. Ideal Skills & Experience: - Prior experience in YouTube video editing. - Proven track record in creating engaging content. - Strong understanding of YouTube best practices. - Capability to work efficiently to meet deadlines. If you are passionate about YouTube content creation and excel in video editing, this could be an exciting o...
...with a unique project involving Raspberry Pis and AWS Greengrass. Your main task would be to develop a system that allows Raspberry Pis to share updates with nearby devices offline. Key Requirements: - The system should be designed to share updates specifically with other Raspberry Pi devices running Raspbian, offline. - The purpose of sharing these updates is to cater to locations with limited internet access. This is essential for our project as it ensures that the devices can remain updated despite the lack of connectivity. - The system should be able to initiate the update process automatically. This means it should be able to detect nearby devices and share the necessary updates without requiring manual intervention. Ideal Skills and Experience: - Proficiency in Raspberry ...
I need a simple, efficient leaderboard app that can be displayed on a TV via a Raspberry Pi. The app should allow users to add/edit scores from their mobile devices. I will also need the app to function without an internet connection, using WiFi Direct with no need for Bluetooth. Key Requirements: - Development for both iOS and Android platforms - Real-time score updates - Player profile management Ideal Skills: - Proficiency in mobile app development for iOS and Android - Experience with Raspberry Pi integration and WiFi Direct - Prior experience with real-time data handling - Strong understanding of offline functionality in mobile apps
i need menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description.
For this project, I need an expert well-versed in Excel-based data analysis to conduct statistical analysis, data visualisation, and predictive modelling on a medium-sized dataset comprising of 1,000 - 10,000 records. - Statistical Analysis: Analyze the data to uncover trends, patterns, and correlations. - Data Visualization: Generate intuitive charts, graphs and other visual representations to better understand the data. - Predictive Modeling: Develop predictive models to forecast future trends based on current data. Ideal Skills: - Proficient in Excel for data analysis - Proven experience in statistical analysis and predictive modeling - Excellent data visualization skills - Understanding of handling medium-sized datasets. This analyst should prioritize accuracy, prec...
I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel
