Excel macro cell format checkงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
หลังจากลูกค้าโทรเข้ามาเมื่อคุยเสร็จแล้วลูกค้ากดวางสาย หรือ พนักงานกดวางสาย อยากให้หลังจากนั้นประมาณ 20 นาทีให้โทรศัพท์กลับไปหาลูกค้าเพื่อประเมิณความพึงพอใจ โดยใช้ macro-survey เป็นเมนูที่จะโทรออกอัตโนมัติ
แปลไทยเป็นอังกฤษได้ไหมครับ อยากให้เขียนอธิบายการทำงานของโปรแกรม/แอพครับ โดยอธิบายให้ครบทุกฟังค์ชั่น และมีการทำงานอย่างไร จาก
แปลไทยเป็นอังกฤษได้ไหมครับ อยากให้เขียนอธิบายการทำงานของโปรแกรม/แอพครับ โดยอธิบายให้ครบทุกฟังค์ชั่น และมีการทำงานอย่างไร จาก
...สามารถ 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)
Thai และ ENG format WAV (PCM,8kHz, 16 bit, Mono, Max size 100MB) ถ่าใด้ครบทุกภาษา ต่อลองราคาใด้คับ
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
ฉันมีข้อมูลของรถตำรวจตรวจสอบในบางเมืองของประเทศไทย ฉันต้องการใครสักคนที่จะแปลข้อมูลเป็นภาษาจีนและทำเครื่องหมายตำแหน่งบนแผนที่ google I have information of the police check car in some cities Thailand . I need someone to translate the information to Chinese and mark the location on the google map.
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
Application ที่องค์กรใช้ มี ระบบ Database ใช้ MS SQL
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
ต้องการ Web Application เพื่อจัดการ GPS Fleet Management โดย มี Hardware GPS 1. กำหนดการเดินทางต่อวัน (สถานที่ ตามใน Database) 2. ระบบคำนวนค่าน้ำมัน/แก้ส ตามระยะทาง 3. ระบบบันทึกการที่รถวิ่งและตรวจสอบว่าไปถึงสถานที่นั้นจริงหรือไม่ (check point)
I have 5 voice files in Thai that I needed translated in the format given below. I : น้องเคยค้นหาแอคเคาท์ใครในออนไลน์ป่ะ อย่างเฟซบุค Have you ever try to look for someone or search for an account online? Or in Facebook S : เคย Yes I : เหมือนฉันชอบคนนี้ ฉันไปตามล่าหา If I like this person I would look for him/her. S : โอ้ย เอาทุกสเต็ปเลย โพสต์รูปอะไรเซฟมาให้หมด Everything from posting to taking picture. S2 : โมเม้นต์นี้ เคยครับ คือคนที่เราอยากจะรู้จักใช่มั้ยครับคนที่เราแอบชอบนั่นแหละ เราจะคอยส่องเฟซเค้า ไปดู If i like that person i would peek at her Facebook. I : ไปแอดเค้ามั้ย Did you add her? S2 : เป็นเพื่อนกันอยู่แล้ว ก็ดูว่าเค้าลงรูปอะไรมั่ง กดไลค์ให้เค้า นั่งดูภาพเค้าอยู่คนเดียวอะไรอย่างงี้ We are already friend. Most of the time just likes and ...
I require a proficient freelancer to assist in data entry from printed documents into an excel sheet. You'll also need to arrange this content meticulously within columns and rows. Your responsibilities will include: - Accurate transcription of data from printed material - Effective organization of the data by columns and rows in Excel The perfect candidate for this job is someone with outstanding data entry skills and a keen eye for detail to ensure accuracy. Experience working with Excel and translating printed documents is a necessity. Accuracy, speed and confidentiality are vital.
I'm seeking a detail-oriented professional to manually transfer valuable ...detail-oriented professional to manually transfer valuable data from Internet sources to an Excel spreadsheet. The ideal candidate for this job should have: - Proven experience in data entry and Excel - Excellent attention to detail and accuracy - Flexibility in terms of formatting as you will have to determine the most effective and efficient structure for the data The challenge of this task lies in manually extracting data from the web, an eye for detail is, therefore, paramount. Your responsibility is to ensure all the data is correctly entered and organized in a clear and comprehensible manner. Your creativity and critical thinking are appreciated when deciding the layout and formatting...
As the project holder, I'm in search of a seasoned data entry associate to populate an Excel spreadsheet. Although the nature of the data is unspecified, a proficient handle on Excel is crucial. Your responsibilities will mainly revolve around the swift, accurate entry of information into sheets, ensuring the data is organized well. Skills and Experience Necessary: - Expertise in data entry, specifically within Excel - A solid track record of data entry jobs successfully completed - Capacity to handle large sets of data - Admirable attention to detail Prospective freelancers are expected to focus their application on previous work experience in data entry. Having proof of similar projects you've executed successfully in the past is a big plus.
I am seeking an experienced freelancer who is proficient in data mining tasks in Excel. the analysis must done in excel by installing the data mining tools in excel The ideal applicant should be capable of installing and executing data mining tools in Excel. Unfortunately, I cannot specify what data mining tasks will be performed, nor the type of data provided for the analysis as these details are not available just yet. However, in order to be eligible for consideration, please include: - Detailed project proposal showcasing your approach to data mining tasks. Feel free to inquire if you need any more details. A strong understanding of data mining in Excel is essential for this task. Looking forward to your proposals.
...should be retained or as close to as possible (Dark Blue - Navy & White). • Expert level Photoshop, Illustrator or Corel Draw skills are a must for quality results. • Previous experience in merchandise design would be a great bonus. Only designers experienced in logo replication and capable of delivering high-resolution results need apply. We will need the sample logo as a Vector, PDF and JPEG format with the colours inverted (dark logo on white background)...
I'm looking for a freelancer to help with a simple Excel data entry task, as well as some basic formula work. I have a spreadsheet that primarily contains numbers. Your role would be to accurately type this data into the sheet, ensuring that every entry is correct and in the right format. This task is meant for particular record-keeping purposes, so precision and attention to detail are crucial. In addition to the data typing, I need some basic Excel formulas applied. Experience with Excel and knowledge of formulas is essential to ensure the data is well-organized and easy to work with. This task is not overly complex but will require someone who is proficient with Excel's formula functions.
I'm looking for a Python script that uses PyAutoGUI to control keyboard inputs, with a specific focus on interacting with a Firefox web page. I am open to creative ideas on how to do this differently then I have described below. Key Requirements: This is basically like a macro, or autohotkey, (if you do a gui then I can determine the winner as soon as whoever finishes first with working code, wins. The gui for the python code is up to you but maybe it could work well if I can have section one establish focus on right scrolling panel and ignore the left panel. Second section: because this is sendkeys basically we will use the keyboard to navigate. A text box stating how many tabs until we get to the first web object button to select, Then a second text box to state how man...
I'm seeking a proficient individual who can efficiently execute data entry tasks. The primary task will be the accurate transcription and input of both numerical and text-based data from scanned documents into Excel spreadsheets, requiring: - High attention to detail for accurate data entry - Ability to transcribe both numerical and text data - Proficiency with Excel and its functionalities - Previous experience with data entry and analysis from scanned documents Your knowledge and precision in data entry will play a crucial role in ensuring data accuracy, which is integral to the success of this project.
I need a modern style video board logo graphics designed based on our existing logo. Requirements: - Design should be minimalist and modern, and fit well within the video board space - Final deliverable should be in JPG format Please showcase relevant experience in graphic design and video board graphics. Your ability to deliver high quality, modern, and minimalist designs will be key to this project.
I need a skilled professional to assist with a data entry task. The project involves the following: - The task is primarily image data entry. - The images will be provided in digital photo format. - The entered data should be compiled into a database. Ideal candidates should have experience with data entry, particularly with image data. Proficiency in database management is also essential. A keen eye for detail to ensure accurate data entry is a plus.
I'm seeking a freelancer who is adept at typing for a task that involves transcribing handwritten notes into Excel. The legibility of the handwriting is average, so this job demands patience, careful observance, and excellent data entry skills. - Your task would be to transcribe the data from handwritten notes into an Excel file. - The content you'd be dealing with primarily includes text. I'd prefer individuals who have previous experience in data entry, especially tasks that require extracting data from handwritten sources, and are proficient in using Excel. Attention to detail is a must, as accuracy is paramount in this job. Your ability to decipher moderately legible handwriting would be a great advantage. Please bring a keen eye for detail, and ...
I'm urgently seeking a freelancer with prior experience in converting images to vector format. Key Requirements: - Experience: Please include examples of previous image to vector conversion work in your application. - Quality: Vector files should be high-quality and maintain the integrity of the original image. Please respond with your experience in this specific area.
I am currently working on a project that requires the integration of Excel with a PostgreSQL database. As such, I am in need of a freelancer who is proficient in both Excel and PostgreSQL. The primary tasks to accomplish include: 1. Exporting data from Excel to SQL 2. Updating PostgreSQL data using Excel You will be working with various kinds of data as we aim to streamline our operations in a more efficient manner. Ideal skills and experience include: - Solid understanding of PostgreSQL - Expert skills in Excel - Previous experience with SQL data exporting and updating The success of this project highly relies on a flawless data transfer between Excel and PostgreSQL. Your expertise will be extremely valuable to our project's completi...
I'm looking for an experienced designer to create my business stationery, this includes a visiting card, two envelopes and a letterhead. All files should be in CDR format. I wish for a minimalistic design style to keep everything very clean and to the point. Although the exact dimensions were not clarified, you should ideally be knowledgeable of average industry standards and be able to guide me in this area if needed. Please include your experience with similar stationery designs in your application.
We're a global market research and mystery shopper company. We undertake worldwide mystery shopping visits and audits across the globe. This task is an audit of an examination center which will require you to check if the security standards are met. You MUST HAVE fluent English skills able to communicate in a professional manner, smart, and well presented as you will be representing the company during the audit. As an auditor, you will arrive at the test center an hour before the start of the exam, present your ID, show a letter of authorisation, which we will provide for you beforehand, and explain what you're about to do. You will then sit with the TCA or the manager and ask a series of questions, and ask to see various things. The audit itself is very simple and ea...
We're a global market research and mystery shopper company. We undertake worldwide mystery shopping visits and audits across the globe. This task is an audit of an examination center which will require you to check if the security standards are met. You MUST HAVE fluent English skills able to communicate in a professional manner, smart, and well presented as you will be representing the company during the audit. As an auditor, you will arrive at the test center an hour before the start of the exam, present your ID, show a letter of authorisation, which we will provide for you beforehand, and explain what you're about to do. You will then sit with the TCA or the manager and ask a series of questions, and ask to see various things. The audit itself is very simple and ea...
We're a global market research and mystery shopper company. We undertake worldwide mystery shopping visits and audits across the globe. This task is an audit of an examination center which will require you to check if the security standards are met. You MUST HAVE fluent English skills able to communicate in a professional manner, smart, and well presented as you will be representing the company during the audit. As an auditor, you will arrive at the test center an hour before the start of the exam, present your ID, show a letter of authorisation, which we will provide for you beforehand, and explain what you're about to do. You will then sit with the TCA or the manager and ask a series of questions, and ask to see various things. The audit itself is very simple and ea...
I am seeking residents of Munich, Germany to conduct an in-store check for a well-known Dairy brand. Project in a Nutshell: 20 SKUS (Products) need to be assessed for the following: Tidiness of shelves, package quality, time to find product and etc. 3-4 samples per a product to be assessed. eg. Product is water: 4 of these will need to be assessed. Consumer will assess 31 samples per a product in total. No purchases required Products include water, plant based and diary. All data will be captured via an App thus good quality photos are needed. Answer questions related to the product via the APP. Full training provided. Requirements of the consumer: Tech Savvy. Promptly answers emails. Flexibility with time 4 weeks to complete Fee for project 1: €600. There is a secon...
I'm in need of an expert to assist with the cleanup of our Medicine database. The goal of this project is to accurately remove all duplicate entries improving the overall accuracy of the data. Ideal Skills & Experience: - Strong background in Database / Excel /CSV management, specifically in the medical field. - Proven track record of similar past work. In your application, please include details of similar projects you've worked on. Efficiency and precision are pivotal for this task. Looking forward to a neat and streamlined database!
I'm looking for a talented content designer who can help create a diverse range of content, including written, visual, multimedia, as well as a PPT and a brochure. Ideal Skills and Experience: - Proficient in designing written, visual and multimedia content - Experienced in creating PowerPoint presentations and brochure design - Familiar with creating content aimed at informing and engaging a youth or student audience Please let me know your relevant experience and how you could help me with this project.
I need a creative, playful logo designed for my dessert company company name is SWEET SENSATIONS DESSERTS. We primarily specialize in cupcakes, pies, and pudding. The preferred color scheme for our logo is a tasteful blend of pink, gray, and white. Ideal Skills and Experience: - Proven experience in crafting distinct and memorabl...branding elements - Prior work on food or bakery industry is beneficial - Proficiency in design software - Ability to translate business needs into creative visuals Job Expectations: - The design should reflect a playful, friendly and enticing vibe - Consider including visuals related to our specialities (cupcakes, pies, and pudding) - Must provide multiple iterations - Final files in vector format I look forward to seeing the unique designs you com...
Were looking for a talented graphic designer with logo and branding experience. We would like to improve our logo and our business card design. The look and feel should remain modern and professional. Deliverables: 1. Improved logo in the various format 2. Improved 2 sided business card that is ready for print with the bleeds / margins Budget $100 Files:
