Automate data collection excel websiteงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
...สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 15,000 ครับ รวมระบบหลังบ้าน ไม่รวม host กับ domain ครับผม 12:13 Avatar ทั้งนี้ต้องดูรายละเอียด ข้อ 1, 3 และ 6 อีกครั้งครับผม วันนี้ 15:24 ฉันสนใจจ้าง 15:25 โทษทีครับ ที่คุยไว้หลายเดือนก่อน โดนเบรคโปรเจคไป นี่จะกลับมาทำ 15:25 พอจะลดได้มั้ยครับ 15:32 อยากจะทำเว็บไซต์รวบรวมยอดขาย พนักงานให้มี Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แล้วแต่แกนที่เราต้องการ export รายงานออกมาเป็น excel ได้ 2. มีระบบ Log in...
ทำ excel คำนวนภาษีส่วนบุคคล 5 คน โดยสามารถเปลี่ยน variable ต่างต่างได้เพื่อทำ scenario analysis (ie ถ้ารายได้ x จะได้ x) ______________________________________________ Excel personal tax calculations for 5 people, with different variables changing for scenario analysis. (ie if income x is obtained x)
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I need an experienced freelancer to assist me in typing data from handwritten notes into an Excel sheet. Key Requirements: - Previous Experience: Please include details of your previous work in this area - Handwriting Deciphering: Due to the nature of the data being handwritten, you'll need to have good skills in deciphering handwriting - Accuracy: It's crucial that the information is entered into the Excel sheet with the highest level of accuracy Looking forward to your application.
I’m looking for an experienced programmer who can create an automation script for a website. Key Requirements: - Automation Tasks: Your main job would be to automate various tasks on a website. This could involve anything from data entry to form submissions, and possibly content scraping. The specific tasks will be shared with you in detail. - Python Expertise: Given the nature of this task, your proficiency in Python is a must. If you have experience with automating websites using Python, that would be a huge plus. - Experience: Your application should showcase your relevant experiences and past projects. I’m looking for someone who has a proven track record in this field. Please include relevant examples of your past work in your application. Loo...
I have a series of PDFs with text that needs to be typed into an Excel sheet. The data is mainly textual in nature. Key Requirements: - Data Entry: You'll be responsible for accurately inputting the text from PDFs into the corresponding cells in Excel. Ideal Skills: - Proficiency in Excel: You should be comfortable using Excel and have experience with data entry. - Typing Skills: Fast and accurate typing skills are essential. - Attention to Detail: The data needs to be entered accurately to ensure the integrity of the information. - Familiarity with PDFs: Experience working with PDFs is beneficial. Please note, there are no specific formatting requirements beyond accurate data entry.
I want data to be accurately typed into Excel. This will consist of entries involving text, numbers, and dates. The textual data requires no special formatting. Using your expertise in Excel, I'd like basic arithmetic formulas applied to the numbers for computations. These formulas will include simple operations such as addition and subtraction. Ideal freelancers for this task would be proficient in Excel with a keen eye for detail to maintain data accuracy. They should also be adept in using basic arithmetic formulas in Excel. Prior experience in data entry will be a plus. Prompt delivery is essential for this project.
I have a number of scanned documents that contain financial figures. I need someone to accurately type these into an Excel sheet for further analysis. Key Requirements: - Experience with data typing and analysis in Excel, particularly financial data. - Attention to detail is paramount; precision in typing is crucial for the accuracy of the analysis. - Proficiency in English is a must, as the data will be in English and will need to be accurately transcribed. The ideal candidate should have prior experience in financial data entry and analysis, and comfortable working with scanned documents. Your work will be the foundation for subsequent data analysis, so precision and attention to detail is key.
My primary goal is to create a specialized automation software for Facebook. I'm looking for freelancers who have demonstrated experience in this area. Key Requirements: - Automation Skills: I need someone with a proven track record in creating automation software for Facebook. The tool should be able to automate various tasks on the platform efficiently. - Experience: Please provide examples of your past work in automating tasks on Facebook or other similar platforms.
I am seeking an teacher well versed in Excel 2021 to create a comprehensive intermediate-level course. This course will total between 12-15 hours and will be delivered through both video lectures and interactive exercises and quizzes. Here's an overview of the specific topics the course must cover. • Formulas and Functions • Data Analysis and Visualization • Pivot Tables and Charts • Advanced Functions • Named Ranges • Tables • Charts and Slicers The ideal freelancer for this project will possess strong instructional skills, extensive experience with Excel 2021, and a knack for making complex concepts easy to grasp.
I need someone to assist me in entering data into an Excel sheet as well as performing some basic calculations on the data. Key Responsibilities: - Entering a mix of text and numerical data into an Excel sheet - Apply summation and average calculations to the entered numbers - Ensuring all data is accurately entered and calculations are correctly computed Ideal Skills & Experience: - Proficient in Excel and data entry - Comfortable with basic mathematical calculations - Attention to detail to ensure accuracy - Previous experience in a similar task would be beneficial
We are looking for Data in the following markets Mexico, Portugal, Colombia and Peru. In these markets we have advertisers for the purchase of data. We need B2C data only, with as much segmentation as possible, name, age, zip code and mobile phone. We are looking for a Data Engineer to perform this work. B2C data is enough for us. We do not have a general industry preference. Data buyers want a target between 22 - 55 years old, but they usually go for volume and don't specify as much. Please come to us witth the website where you grab the records.
I need assistance with a small-scale copy and paste data entry task. The data is less than 1,000 rows and is in a spreadsheet format. Ideal Skills and Experience: - Proficiency in spreadsheet software such as Excel or Google Sheets - Attention to detail to ensure accurate data entry - Efficiency in copy and paste tasks to complete the job promptly This is Medium Task for 1 day Max and will be Fixed Price of 800RS. We have to Refer the Raw File and Practice test for the Students and will it in the correct format in the Practice Bulk upload
I need an experienced freelance instructor to deliver a video course on intermediate-level Excel, lasting between 12-15 hours. The course should cover the following key topics: - Data analysis - Excel functions & formulae - Pivot tables and charts The perfect candidate for this project will have extensive experience with all these Excel components, as well as a background in teaching Excel. Although I don't have specific learning objectives for course participants at this time, I do expect the curriculum to be comprehensive and the instructional delivery to be engaging and easily understood. As we move forward, I'm open to collaborating on the development of more specific learning objectives.
I'm looking for someone to collect data from bank employees in Bhopal, India. The data is to be collected with the help of Google Forms. There are a total of 11 banks and you are required to collect a minimum 11 responses from each bank, which means total of 121 responses. The response must be accurate. Ideal freelancers for this project should be well-versed in data collection methodologies and possess strong interpersonal skills to effectively engage with the bank employees. The successful candidate will be responsible for: - Conducting data collection from bank employees in Bhopal - Ensuring accuracy and integrity of the collected data - Delivering the data in an organized and structured format. The method of data ...
I have code for login trading accound and fetch token data. I need to update more data from the code to my system.I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Need ot automate the buy/sell order Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR an...
...comprehensive list of all meet-ups, conferences, and trade-shows related to mutual funds, real estate, wealth management, and financial planning that are going to be held in Ahmedabad, Surat, and Vadodara. Key Requirements: - The data must encompass a wide range of events across these financial sectors. - Only events in the cities of Ahmedabad, Surat, and Vadodara should be included. Submission: - The final deliverable should be in a spreadsheet format, making it easy for me to analyze and organize the data. Ideal Freelancer: - Experience in event data collection would be a huge plus. - Familiarity with the financial sector, particularly mutual funds, real estate, wealth management, and financial planning, will be beneficial. - A detail-oriented freelance...
I am in need of a skilled freelancer who has extensive experience in data entry to create a comprehensive Excel sheet. Some data will be provided, however, additional information will need to be sourced by the selected freelancer. Ideal skills and experience for this job: - Proven data entry work experience - Strong attention to detail - Ability to source accurate and relevant data - Experience working with Excel including text, numbers, and dates In your application, please provide details regarding your previous experience related to Excel and data entry. This will ensure that I can make an informed decision when awarding the job.
I have a project where I need you to work with numbers in an Excel sheet. Ideal Expertise: - Proficiency in data entry - Strong knowledge of Excel - Attention to detail - Ability to maintain accuracy and consistency in data entry - Proven experience in similar projects - Able to meet deadlines Please let me know if this is something you can assist with.
We are launch our new brand of lingerie and pyjamas. To bring our vision to life, we are looking for a skilled and creative sketch artist to collaborate with us on designing the initial sketches for our collection. As a freelancer, you will have the opportunity to showcase your talent and contribute to the creation of a unique and stylish range of lingerie and pyjamas that will captivate our target audience. We are seeking someone with a passion for fashion, attention to detail, and the ability to translate ideas into beautiful sketches. If you are a talented sketch artist with experience in fashion design and a keen interest in lingerie and pyjama wear, we would love to hear from you. This is an exciting opportunity to be part of a new and innovative brand in the fashion industr...
Desenvolvi uma planilha de excel mas estou a necessitar de ajuda para criar duas novas formulas.
I have 3 construction programs currently in Excel that I need to be converted into Microsoft Project. The programs are primarily focused on project scheduling and do not require resource management features. Key requirements: - Convert 3 construction programs from Excel to Microsoft Project - Create interactive Gantt charts with dependencies - No need for resource management features, just the scheduling aspect Ideal skills/experience for this project: - Proficiency in Microsoft Project - Experience in project scheduling and Gantt chart creation - Previous work in construction or similar industries would be beneficial Feel free to ask me if you need any further details.
I'm looking for a detail-oriented researcher to help me gat...- charts can come later. Time is critical - ideally 24 hours. - Sector-wise breakdown: I am particularly interested in the finance/investment sector. Hence, your role will be to provide in-depth insights into the investment figures within this sector. Ideal candidate should have: - Strong research experience - Experience in economics or finance - Ability to analyze & interpret data - Proficient in Excel or data analysis tools - Access and experience with databases including Office for National Statistics (ONS) in the UK /EUROSTAT and STATISTA (paid) for the EU and Investment Association (UK) This project requires a detail-oriented, problem-solving researcher. The figures/charts should all be ref...
I require a meticulous professional to help transfer text data from a series of printed documents into an Excel sheet. There's no special symbols or diagrams at all, just plain text. Ideal Skills and Experience: - Thorough understanding of Microsoft Excel - Attention to detail - Proven experience of working with printed documents - Excellent typing speed with the high level of accuracy The project needs to be completed accurately with consistency and timely manner.
...building and road data from OpenStreetMap in CSV format on a monthly basis or with a html frontend site, where we can "click" in Downloadbutton. Key requirements: - Automate the retrieval of building and road data from OpenStreetMap - Download the data in CSV format - Set up the system to run the download process on a monthly basis optimizely on html frotend with a download button Format of the csv: ID (from OSM), ZIP, City, District of City, Federal State, District, Street, Housenumber If available the Community and the Code of the Community Ideal skills and experience: - Proficient in OpenStreetMap data retrieval - Programming experience to automate data downloads - Strong understanding of CSV data formatting - Ab...
I'm looking to deploy a robust visitor tracking system on my website which goes beyond the conventional approaches of merely tracking visitor data, and can help me in capturing contact information of potential customers who do not complete any forms on the site. Key Requirements: - Advanced Visitor Data Collection: The system should be able to capture details like device type, referral source, behavior patterns, and time on page for all visitors. - Contact Information Extraction: The primary goal is to extract the contact details (Name, Address, Phone, and Email) of the visitors who do not submit any form on the site. Ideal Skills and Experience: - Proficiency in Third-Party Tracking Services: The selected freelancer should be well-versed with various t...
I'm in urgent need of a seasoned expert in Microsoft Excel, particularly in creating financial models with emphasis on cash flow management. The ideal freelancer for this project should have proven experience in constructing similar tools for businesses. Key Areas of Focus: 1. Housemaid Cash Flow Tracker: This spreadsheet will facilitate tracking cash provided to our two housemaids and matching their submitted invoices. With three team members involved, it needs to be straightforward and efficient. 2. Monthly Household Budget Expenses: This spreadsheet will serve as a comprehensive monthly budget for all household expenses, including groceries, Amazon purchases, and payments to other suppliers. I envision a format where invoices and supplier names are listed vertically, with ...
...for an expert in Excel who can assist me with designing a functional cash flow budget. The primary aim of this tool will be to help me track and effectively manage two team members expenses. Key requirements for this project are: - Excellent proficiency in Excel, particularly in designing complex budgets and financial spreadsheets. - Experience creating automated functions within Excel, specifically for totalling expenses. - Ability to create a user-friendly and aesthetically pleasing interface that enables efficient data entry and report viewing. The freelancer would need to provide consistent updates and flexibility for potential adjustments during the process. This initiative is essential for my financial planning and needs to be done professionally....
need a skilled freelancer who is an expert in creating financial formulas in Excel. You'll work exclusively with data I provide. Ideal candidate should have: * Expertise in Excel with a specific focus on financial formulas Ddata will be provided
I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.
As an individual currently managing a project with numerous details and a profit loss statement, I need assistance with daily tasks for our Excel sheets. This will include: - Data entry and organization to streamline workflow - Basic arithmetic calculations for accuracy - Statistical analysis to make informed decisions - Formatting and visual presentation for clarity This role requires proficiency in Excel, a keen eye for details, and strong analytical skills. Experience in financial or project management is a plus. The job will be ongoing and requires daily attention. If your expertise aligns with these needs, please apply.
I am ready to award this proj...straight away. I need a professional who can assist me in finding and saving 6-8 images and 1-2 data sheets for 65 items from a single website. Key Requirements: - The images and data sheets are located in specific sections on the website. Search for product name, select product name and then save images and data sheets. - The collected images and data sheets should be organized by item name and saved into directory name and complete directory containing all information sent to me Skillsets Required: - Excellent web research skills. - Proficiency in data and image saving. - Ability to organize and name files properly. - Detail-oriented to avoid any mix-up. - High level of patience for manual collecti...
Saya sedang membuat thesis bagian 4 & 5, saat ini membutuhkan assistance dari freelance yang bisa bantu menulis thesis dan menyebar / mengambil data retailer secara online Specific requirement - Pernah mengerjakan Thesis - Fluent dalam bahasa Indonesia - Teliti Hope to work with you in the future! cheers
I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.
I'm looking for an expert in Excel to assist with a project involving data entry and analysis. The Excel sheet you'll be working on has more than 50 columns and rows and will contain a mix of text, numbers, and dates. You'll be responsible for the following: - Accurate and timely entry of the data provided - Ensuring the data is appropriately formatted and organized - Conducting thorough data analysis, including but not limited to trends, comparisons, and any other insights that can be drawn from the data The ideal candidate for this project should have: - Proficiency in Excel and experience with large data sets - Strong attention to detail - Ability to perform data analysis and present insights - Good ...
