Small excel test projectงาน
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)
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
...Retrieval • Rabbit Line Payment Gateway การเชื่อมต่อจากระบบอื่นๆที่อยู่ในขอบเขต (Provider) • QR Payment Notification โดยในลักษณะการทำงานเป็นรูปแบบของ โครงการที่ต้องมีการเข้ามาฟัง requirement และ design ร่วมกันกับหน่วยงานที่ดูแล มีเอกสารที่ต้องจัดส่งต่อไปนี้ (โดยสามารถรรับทำบางส่วนหรือทั้งหมดได้ ซึ่งงบประมาณก็จะต่างกันไป) a. Functional Specification b. Technical Specification c. Unit Test Result d. Release note and software configuration e. Deployment steps and checklist f. Knowledge Transfer (Training) document g. Operation manual & Troubleshooting document กำหนดขึ้นระบบ วันที่ 31 มค 2561 แต่ระยะเวลาพัฒนาจริงๆ จะมีแค่ประมาณ 1 - 2 เดือนเท่านั้น
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
- อยากพัฒนาตัวเองแบบก้าวกระโดด - อยากทำงานกับผู้มีประสบการณ์ในการบริหาร IT international project ด้วย Agile ตัวจริง - อยากทำงานกับ guru ตัวจริงในการทำ automated test และ TDD - อยากเรียนรู้ technology ใหม่ๆ ที่ full stack developers ต้องทำได้ - อยากทำงานแบบ work from home ไม่ต้องมาเครียดกับรถติดและเวลาเข้างาน - มี passion ในการช่วยพัฒนาสังคมด้วยเทคโนโลยี - ใช้ชีวิตอยู่ได้ด้วยเงินไม่เกิน 50,000 บาท ต่อเดือน - มี skill เหล่านี้ : AngularJS 1.5.X, Bootstrap 3.x, Responsive design, Jquery 1.11.x, Java Script/DOM, Rest web service / JSON / HTTP Request, Git (Optional : Less or Sass css, Webstrom) ถ้าทั้งหมดคือตัวตนของคุณ [Removed for encouraging offsite communication which is against our Terms and Conditions.] PromptCoach () คือ startup สาย Edutec ที่มีปณิธานแ
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I require an expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to Detail: The work involves handling a large amount of data, so ...
I'm in need of a diligent freelancer to handle manual data entry for my Excel sheet. The data primarily consists of numerical information. The numbers will be provided in digital format, such as PDF or Word documents. Your responsibilities will include accurately inputting these numbers into the corresponding cells within the Excel spreadsheet. The main goal of this project is to maintain data integrity and ensure a high level of accuracy in the data entry process. Ideal Skills and Experience: - Proficiency in Excel - Strong attention to detail - Previous experience in data entry - Good time management skills
I need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want to use “setup” 3- 3- Generate report even i...
...various tasks in Excel. This includes, but is not limited to, data entry, formulas, and calculations. Key responsibilities: - Automating data entry processes within Excel - Implementing advanced formulas and calculations to streamline calculations - Generating reports and carrying out data analysis using Excel - Ensuring the accuracy and integrity of automated processes Ideal skills and experience: - Proven experience in automating tasks in Excel - Advanced knowledge of Excel functions and formulas - Ability to understand complex data sets and create accurate reports In your application, I'd like to see: - Examples of similar projects you've worked on - Details of your experience with Excel automation - A detailed project pro...
I...3-5 messages per day at random times. The number of messages should be adjustable within the app. The messages should be sent between 9:00 AM and 10:00 PM (always at random times). The time range during which the messages are sent should be adjustable within the app. Why do we need such an app? These messages are intended to prompt a person in the WhatsApp group to take an alcohol test and post the video of the test in the WhatsApp group. The purpose is to monitor an individual with alcohol dependency to ensure they do not consume alcohol. The other members of the WhatsApp group will then review the posted video. These 3-5 prompts should appear at random times in the WhatsApp group each day. If it is too difficult to implement with WhatsApp, another messaging service cou...
I am seeking an expert in data entry, particularly in the tasks of document conversion, data processing, and data verifi...necessitates the management of confidential and sensitive information, hence, a demonstrated respect and understanding for data privacy is paramount. Key Responsibilities: • Document conversion • Data processing • Data verification Required Skills and Experience: • Proficient with MS Excel • Demonstrated experience in similar roles handling sensitive data • Strong attention to detail • Respect for privacy and confidentiality Note: Familiarity and experience with utilizing formulas and pivot tables within Excel are highly desirable, given the nature of tasks to be performed. Integrity, diligence, and meticulousness a...
I need assistance with copying & pasting data from spreadsheets. The dataset is less than 1,000 entries. Ideal skills and experience for this job: - Experience with data entry, especially from spreadsheets - Attention to detail - Proficiency in Excel - Ability to meet deadlines It's a straightforward task. The goal is to ensure the data is accurately copied and pasted.
I'm looking for assistance with pre-employment vetting in Rouen, France. The pre-employment test that I want to conduct is employment-specific. This is crucial for me because I want to ensure the people I'm hiring are well-suited for their roles. Your role in this project will be to set up and conduct the test, and deliver a comprehensive report on each candidate's performance. Ideal freelancers for this project should have experience in pre-employment testing and a solid understanding of the specific requirements for employment. Please note that I haven't specified the field or industry for the employment opportunity. The test should be general enough to apply to a wide range of positions.
I need an experienced Excel programmer to automate repetitive tasks and create custom VBA macros for my project. This assignment requires basic level tasks, so extensive experience in complex macros isn't necessary. Here is what I expect: - Automation of several repetitive tasks to streamline workflow and increase productivity - Creation of custom VBA macros from scratch Ideal Candidate: - Extensive experience with Excel automation and VBA macros - Ability to comprehend and successfully complete basic level assignments - High attention to detail and accuracy Please include your Excel automation and VBA macros experiences in your application. I look forward to working with you on this project.
I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample
We are starting a project to develop a QR code payment application called "Metropol Pay" that will run on the Android platform. The application will be designed to perform the following basic functions, with a user-friendly interface: get tokens QR code creation Payment inquiry Cancellation and refund procedures These functions will be exposed via AIDL and can be triggered via App2App from another application. The application will manage Metropol Pay's payment processes, show the user the QR code and query the transaction details. When opened, Metropol Pay will receive a token with a 5-minute validity period from a Token API, then generate the QR code and display it on the POS screen. The screen will be designed to be user-friendly and informative, and the necessary...
I'm seeking an experienced Excel wizard capable of making my inventory report more dynamic and adaptable. Here's what I need: - Total Calculations: The report doesn't currently update the total inventory count and monetary value when I adjust the count of individual items. I require this to be automated so the totals are accurately recalculated whenever an inventory count changes. - Regular Updates: Going forward, I will be regularly updating inventory counts on a weekly basis. I would appreciate if the system is simplistic and user-friendly for regular updates. Ideal Freelancer Skills: - Advanced knowledge of Excel functionalities - Experience on inventory management systems - Meticulous attention to detail - Ability to create user-friendly systems. The o...
I'm looking for a skilled engineer who can design a self-supported steel chimney for a metal manufacturing plant. This chimney will be integral to industrial emissions control. Tasks Include: - Tailoring the design to accommodate the specific needs of a metal-manufacturing environment. - Incorporating robust safety features and compliances for high-temperature metal emissions. Ideal skills: - Structural Engineering - Industrial Design - Knowledge of industrial emissions standards - Experience with metal manufacturing processes.
...proficient in Front-end development, UI/UX design, and Responsive design. Key Responsibilities: - Collaborate with the team to brainstorm, design and create visually appealing web content - Translate wireframes and mockups into high-quality code - Implement best-practices in UI/UX design to enhance user experience - Ensure the website is responsive and optimized for a variety of devices - Regularly test and troubleshoot to maintain the quality of the website The ideal candidate should be: - Proficient in HTML, CSS, and JavaScript for front-end development - At least an intermediate level of experience in UI/UX design - Able to work both independently and as part of a team - Detail-oriented with a strong eye for design aesthetics - Comfortable with both full-time and part-time w...
...is capable of efficiently extracting table data from PDF documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - Expertise in Excel automation and customization. - Strong background in user management and access control systems. - Previous...
I'm looking for a professional who can help me set up a free SSL certificate on my Linux VPS. Here are some key details about the project: GOT FREE SSL FOR ONE YEAR AND CAN INSTALL ON VPS USING COMMAND LINE. - Operating System: My VPS is running on Linux. - Root Access: I have full root access to the VPS. - Web Server: The VPS is currently running on Apache. Key Responsibilities: - Install and configure a free SSL certificate on my VPS. - Ensure that the SSL is correctly integrated with the Apache server. - Test the SSL setup to guarantee that it works efficiently. Ideal Candidate: - Extensive experience with Linux VPS systems and root access. - Proven track record of setting up SSL certificates on Apache. - Strong understanding of SSL configuration and security prot...
I am looking for an experienced tester for my remittance mobile app. The app is designed to work on both iOS and Android devices. The project involves a thorough and detailed analysis of its functionality on these platforms. We have currently launched our version 1 of the app so now we would like feedback of everything to make version 2 more professional. Requirements: - Proficiency in testing mobile applications - Familiarity with both iOS and Android platforms - Experience with remittance or financial apps Tasks: - Test the app's functionality and usability - Report any crashes, bugs or weaknesses found - Suggest possible improvements or updates Please share your previous work experiences specifically in mobile app testing. Knowledge and understanding of remitta...
I...3-5 messages per day at random times. The number of messages should be adjustable within the app. The messages should be sent between 9:00 AM and 10:00 PM (always at random times). The time range during which the messages are sent should be adjustable within the app. Why do we need such an app? These messages are intended to prompt a person in the WhatsApp group to take an alcohol test and post the video of the test in the WhatsApp group. The purpose is to monitor an individual with alcohol dependency to ensure they do not consume alcohol. The other members of the WhatsApp group will then review the posted video. These 3-5 prompts should appear at random times in the WhatsApp group each day. If it is too difficult to implement with WhatsApp, another messaging service cou...
THIS IS NOT A BUSINESS ANALYSIS FROM THE PERSPECTIVE OF BUSINESS VALUATION OR FINANCE. THIS IS A REQUIREMENT GATHERING AND FINALIZATION FOR LEAD CAPTURE PAGES. It is a small proejct. I have a few lead capture pages to be designed and I need your expertise in developing the requirements, process mapping, wireframing, and possible test cases. It is not a large project but it does have a few variants of lead capture processes.
...papers - containing approx 50 questions each. For each question, I need someone to: - cut & paste an image of the question into a Google slides / Powerpoint document - 1 question (or sub-question if it requires a different skill per page - 1 document for each paper - name the skill(s) that are required to answer each question - as the title for each page - create a new line in a Google Sheets / Excel document with the following information: - skill required (copied from title of Google Slides document) - page number of Google Slides document that the question appears on Key Requirements: - The questions are from primary school level math exams, so a good understanding of these topics is crucial. - You will need to effectively categorize each question based on th...
I'm lookin...scraped data should be efficiently saved to a CSV or Excel file for easy review. Capable of being plugged to a distribution app. Key Requirements: - Develop a Python-based web scraper that targets a website to extract text data - The scraper should be designed to run on a weekly schedule - Ensure that the code is concise and easy to understand for potential future modifications - Store the scraped data in a CSV or Excel file format Skills and Experience: - Proficiency in Python programming - Experience with web scraping libraries such as BeautifulSoup or Scrapy - Understanding of scheduling tasks in Python - Familiarity with working with databases, especially CSV or Excel files I'm open to discuss further enhancements and updates to the pr...
I'm in need of a mechanism design expert who can assist me in creating a small mechanism. The purpose of this mechanism is to move objects, and it will be operated manually. Key Responsibilities: - Detailed force analysis: An important aspect of this project is a comprehensive force analysis to ensure the mechanism functions as intended. Hand calculations to be included. - CAD Model: The CAD model should be of intermediate complexity with multiple components and moderate detailing. - Concept Sketches: Creating detailed concept sketches which will guide the design process. - Materials & BOM: Selection of materials suitable for the mechanism and creating a Bill of Materials. - FEA: Performing Finite Element Analysis to evaluate the performance and structural integrity...
I'm looking for a proficient Excel professional to develop a multi-country income tax calculator. This tool will primarily serve individual taxpayers, and potentially other user groups. Key Requirements: The calculator should support income tax calculations for multiple countries. This requires a deep understanding of tax laws and calculations in each country. - The tool should be user-friendly and intuitive, catering to users with different levels of tax knowledge. - It should be well-structured, with separate sections for each country to avoid any confusion for the end-users. Ideal Skills and Experience: - Advanced Excel proficiency, with experience in creating complex calculators or financial models in Excel. - In-depth knowledge of income tax laws and ...
I need an expert to develop a macro tailored to automating report production tasks in Microsoft Excel. The main purpose of this project is to streamline the process of regular report production and increase overall efficiency. Ideal skills and experience include: - Proficient in Microsoft Excel - Experience in macro development to automate tasks - Knowledge in automating report production Your role will involve designing and implementing a suitable macro for regular report production in Excel. I'm looking for someone who can provide a timely and efficient solution.
...Copywriting Basic Wordpress (change text, add a button, upload a file, etc) And others related to the position You must be a FAST learner, attentive to details, curious, with great writing skills. Looking for someone that pays attention and doesn’t keep making the same mistakes over and over. Attention to detail. Common sense. This job will part-time as a test period, after that it will be full-time. First, there is a task I’ll give as a test. Payment for part-time during trial period: Fee: 250 USD Performance bonus: 50 USD (how many times you make mistakes, how much time it takes to do stuff, etc) Results bonus: 50 USD (how many of X, Y, and Z do you deliver successfully) Commissions: 100 to 300 (after the first month) If your work complies with my qu...
I'm seeking an exam invigilator with at least a Bachelor's degree to administer an on-site exam in Salmiya, Kuwait. This is a one-time gig with the potential for future opportunities. We provide test administration and accommodation solutions to test-takers nationwide. For this purpose, we look for professionals who we contact on an "as-needed" basis to see if they are available to assist test takers for their approved accommodations. We provide complete training and assignments pay hourly for the entire scheduled time, even if the exam ends early. We have a computer exam coming up where a test taker has been approved for communication assistance. The candidate is deaf or hard of hearing but is able to read lips. For this assignment, you wo...
I'm seeking a skilled virtual assistant with proven communication abilities, to work specifically in US timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand professionally and persuasively when ...communication abilities, to work specifically in US timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand professionally and persuasively when bidding on projects. - Communicating with leads: You'll be responsible for using various messaging platforms to engage with potential clients and leads. Ideal candidates should excel in written communication and have a knack for sales. Proficiency in project management tools is a plus. Our preferred mode of communication with leads is t...
Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.
We need support with HUAWEI S5731-h48T switches. Specifically, starting from a reset switch, we need to understand: A brief, concise introduction on how the configuration works in general. How to enable SSH connection on all switch ports: 2.a. How to change the default port for SSH connection. How to ena...line and WEB interface. How to set ports to UNTAG mode, both via command line and WEB interface. How to export and reload the configuration. DETAILS: The support operation must be performed via TEAMVIEWER connection to a laptop that is connected via SERIAL to the reset switch. At the end of the work, we need specific commands along with comments and best practices. Upon completion, we will test the provided commands in the documentation and require support if something i...
