Programmers excelงาน
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 ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I require a skilled individual who is proficient in Excel to analyze market research data. This work requires a keen eye for detail and understanding of advanced analysis techniques. The main objective of this project is to provide precise quantitative summaries of the market research data. Your responsibilities will include: - Receiving and understanding the raw data provided - Analyzing and interpreting complex data sets - Producing quantitative summaries and reports based on your findings Ideal Skills & Experience: - Proficient in Excel - Previous experience in data analysis - Good understanding of market research principles - Excellent task management skills - Experience in generating data-driven reports. This project is ideal for freelancers with a knack for...
...correct answer (the choice in BOLD). - Some questions "refer to a figure". Most questions have zero or one figures, a few have more. I have provided Columns Figure A... FigureH for these as required. LOOK AT THE EXAMPLE. task is to put all 1090 questions into an excel file. I have put one question in there as a sample. I have also put one image which shows two additional questions. - If you win the project, you will get the full PDF. You will be able to cut and paste from the PDF. - To bid on this project, you must give me the excel file back with these two sample entries put in after the one that I did. The sample is a JPG file so you must type it in manually. Successful project: - All questions in there, in correct order from the PDF. - No typos. - Co...
I'm looking for a reliable freelancer to help with a small-sized project involving Excel data entry. The information will be shared via online documents. Ideal Skills and Experience: - Proficiency in Excel and data entry - Attention to detail is a must - Ability to handle small-scale tasks efficiently
I'm looking for a skilled sales closer with a strong track record in retail sales. The ideal candidate should have a versatile background, capable of handling both brick-and-mortar and e-commerce environments. Experience in the pharmaceutical or healthcare industry is a plus. Key responsibilities include: - Engaging with...include: - Proven track record in retail sales, ideally with experience in both brick-and-mortar and e-commerce - Strong communication and negotiation skills - Ability to understand and communicate the benefits and features of pharmaceutical products - Experience in selling healthcare or pharmaceutical items would be highly beneficial If you believe you have the skills and experience needed to excel in this role, please do get in touch. I look forward to he...
I wil...changes daily , One such project should be made I'm seeking a proficient Excel specialist to take on a project that primarily involves formatting and creating advanced formulas. Key Responsibilities: - Take charge of the spreadsheet's aesthetic and logical formatting - Develop and implement formulas to aid data analysis and interpretation - Arrange numerical data alphabetically from A to Z Ideal Skills: - Proficiency in Excel functions and formulas - Strong attention to detail, particularly regarding formatting - Excellent problem-solving skills Project Timeline: This project needs to be completed within a month, demonstrating your ability to meet deadlines is crucial. So, if you have good experience with Excel, particularly with formatting an...
I'm currently seeking a skilled freelancer for a data entry job concerning primarily text data. The data to be entered will be provided in an Excel spreadsheet and will need to be accurately transferred to an online database. Ideal candidates should have: - Proficiency in Microsoft Excel - Experience with data entry into online databases - Attention to detail and accuracy Please place your bid based on the information provided, and get ready to embark on an engaging and fulfilling data entry task.
...maintenance materials. Currently, we're managing our inventory through Excel spreadsheets. It's getting increasingly cumbersome and we're looking to streamline the process with a dedicated inventory management software. Key Features: - I'm interested in a system that will have robust reporting and analytics capabilities. This will help us keep a close eye on our stock levels, sales trends, and overall inventory health. Ideal Skills and Experience: - Experience with developing inventory management software, particularly for food and maintenance materials - Proficiency in building systems with strong reporting and analytics features - Ability to create user-friendly interfaces for easy data input and retrieval - Experience working with Excel and the abi...
I'm in need of a proficient individual who excels in SPSS for a data interpretation task. The main task involves the analysis of a questionnaire and exporting relevant tables from...individual who excels in SPSS for a data interpretation task. The main task involves the analysis of a questionnaire and exporting relevant tables from SPSS. Here's what I'm looking for: • Skilled in analyzing questionnaires using SPSS • Able to export data into tables • Analysis should be done based on patterns of behavior • Writing a brief description of data based on hypotheses The data is on an Excel file right now. Please bid only if you have relevant skills and experience as it will demand a high level of expertise and detail orientation. Don't hesitate ...
As a Media TV Channel, we are seeking a UDAID Contract Compliance Specialist to review our contracts, ensure compliance with cont...adhere to all terms and conditions outlined in our contracts. - Auditing financial records: You will need to conduct detailed audits of our financial records to guarantee compliance. Industry Experience: While not mandatory, if you've previously worked in the media TV channel sector, it would be an added advantage. Understanding the unique nuances and challenges of this industry will help you excel in this role. Ideal Skills and Experience: - Experience with USAID contracts is a must. - Previous work in media TV channels would be beneficial. - Strong background in contract compliance and financial auditing. - Detail-oriented with excellent commun...
I need a competent Excel specialist to develop a robust strategy for documentations. The specific tasks are not yet determined, and the information that needs to be included will be clarified as we proceed. However, the project has no strict deadline, giving you ample time to plan, organize, and execute best practices. The ideal candidate will possess: - Outstanding Excel skills, including creating and working with complex formulas. - Robust organizational skills to manage and structure vast amounts of information. - Proactive attitude for identifying potential tasks that need documentation. - High attention to detail and accuracy. - Experience in data entry, sales records, and inventory management would be advantageous. Please bid with your plan of action and examples of p...
I'm in need of a sharp Australian expert who has access to the Australian Bureau of Statistics (ABS) database and can help me gather pertinent data regarding Melbourne's older population. If you have experience with ABS table builders this should be a relatively easy job as much of the data is collected in these ranges. Key Deliverables in Excel: - All SA3s in the Eastern and Southern Melbourne planning regions - TOTAL number of people in each SA3 and the number of people in the ages of 50+, 60+, 70+, 80+, 85+ - The number of people with income per week in each SA3 of $3,000-$3,999, $4,000 - $4,999, $5,000 - $5,999, $6,000 - $7,999, $8,000 or more The example table shows information from the 2016 Census and I will need data from the 2021 Census. Key Requirements: - ...
1 excel import task. and fix minor issue in db. Able to work with ftp. Follow and start Immediately
I need a tool that can search multiple sheets in an Excel workbook and copy specific rows to a new sheet based on manual selection. The core requirements of the tool are: - Searching across multiple sheets to find specific data. - Allowing me to manually select a specific number of rows from the search results for copying. Given these criteria, the ideal tool would be: - Capable of working with Excel files. - Providing a user-friendly interface for easy manual selection. If you have experience with these requirements, please reach out.
I need a highly accurate and detail-oriented individual to assist with entering both numeric and text data into Excel. Requirements: - Excellent proficiency in Excel - Previous data entry experience - High level of accuracy and attention to detail - Ability to handle both numeric and text data entry efficiently This role will suit someone who thrives on working with data and can ensure that all data gets entered correctly the first time, every time.
I'm looking for a freelancer proficient in Excel to help me with daily data entry and organization tasks. Key aspects of the project include: - **Data Entry and Organization**: Your main responsibility will be to input new data, as well as maintain and organize existing data in a structured manner. - **Regular Updates**: The document will need to be updated regularly, making consistency and accuracy pivotal in this role. Ideal candidates should have: - Strong proficiency in Excel, particularly in data entry and organization. - A keen eye for detail and a methodical approach to work. - The ability to work consistently, as the document will require daily updates. - Prior experience with similar tasks is a plus, but not essential.
I'm in need of a skilled typist for a data entry project. The task involves entering data into an Excel spreadsheet. Requirements: - Excellent typing speed and accuracy. - Previous experience with data entry. - Proficiency in Excel. - Ability to follow instructions precisely. Ideal Candidate: - Proven track record in data entry tasks. - Strong attention to detail. - Reliable and able to meet deadlines. - Good communication skills. If you have the right skills and experience for the job, I look forward to receiving your bid.
I'm in need of a detail-oriented specialist to perform data entry on textual content that's already well-organized. Key Tasks: - Accurate entry of textual data into Excel format - Pace of work should be efficient without compromising the quality - Ensure a smooth transition of data, maintaining its organization Ideal Skills and Experience: - Previous experience in data entry jobs would be beneficial - Proficiency in Excel - Excellent attention to detail - Ability to handle data in an organized manner - Good command of English language to understand textual data.
I require a professional data scraper to scrape multiple websites. Key tasks include: - No limitation on type of data scraped as this was not specified. - Scraping must be done across multiple websites, specifics will be provided upon project commencement. - All data should be delivered in Excel spreadsheet format. Ideal skills and experience: - Prior experience in web scraping across multiple diverse websites. - Proficient in using different scraping tools. - Strong understanding of Excel and data parsing. - Attention to detail and commitment to high quality, error-free work.
I am looking for an experienced Excel tutor to provide me with in-person lessons focusing on basic formulas and functions. My Current Skill Level: I would rate myself as a beginner - I have minimal experience with Excel and would need a tutor who can help me understand the basics. Skills to Learn: My main goal is to grasp basic formulas and functions within Excel. I'm looking to build a strong foundation before moving onto more complex features. The ideal candidate for this job has: - Proven experience in tutoring or teaching beginners Excel - Strong understanding of basic formulas and functions in Excel - Excellent communication skills to effectively convey concepts to a novice - Availability for in-person sessions If you think you&#...
...coast region of Australia. Key Information Required: - Contact details: I need a name of the person who manages the trucks their phone number. - Geographic location: It's important to know where these individuals or companies are located. - I need the company name The final list should be delivered in an Excel spreadsheet. Ideal Skills and Experience: - Strong research abilities: The ability to dig deep and find the right contacts in these specified industries. - Proficiency in Excel: The ability to compile and present the data in an organized and clear manner. - Understanding of the target industries: Experience in or understanding of the Transportation and logistics, Construction, and Agriculture sectors would be a big plus. Please let me know about any past ...
...the quality of their own leads by contacting the customer by calling or messaging them to scheduling a zoom call using Calendly. The states will depending on the states you hold an active license in. (I will help you get your Non-Residence license in the states you get clients) #2 Agent Acquisition Specialist. I am looking for someone to scout for people looking for jobs that allows them to excel in the company quickly. I am looking to hire 10 more agents just like you. Or agents with potential in any state (CLOSERS). This position with require you to generate your own leads for potential life insurance agents screen them for the criteria listed above, and book the potential agent on a zoom call with me or one of my staff using Calendly. Please note that these agents will...
I need a professional...- Extracting: I require the following contact information to be extracted: Business Name, Email, Phone number, Full address separated by suburb, postcode and state. - Formatting: All extracted data should be structured and organized into an Excel spreadsheet. Ideal Skills: - Web Scraping: Proficiency in web scraping tools and techniques is essential. - Data Entry: Experience with data entry and extraction. - Attention to Detail: Accuracy in capturing and organizing contact details is crucial. - Excel Proficiency: Ability to create and format an Excel spreadsheet effectively. - Communication: Regular communication and updates on the progress of the task would be appreciated. I'm looking for a reliable freelancer who can deliver this tas...
Hello. I have a multiple page excel spreadsheet, but I need it to have more flexibility. It is for a 10 room facility, and it's purpose is to show projected revenue based on room type, employee job type, and schedule. The current spreadsheet has 10 rooms with two room types. Also there are 11employees with 6 job types. Your task will be to change the current spreadsheet to 40 rooms, 3 room types. and 22 employees with 12 job types. Changes to be made to Revenue Targets Page, Column A -I want to be able to select room type from a dropdown menu, and input the revenue for different room types on the Revenue Target page. Room types are Private Room, Shared Room, Shared Medicaid. Employees Page, Column A -I want to select employee job type from a dropdown menu for ea...
I'm looking for an expert in VBA and macros to help streamline my processes in Excel. Key Requirements: Shifts: Defined two shifts in the "task tap": Morning: 6:00 to 15:30 Afternoon: 14:00 to 22:30 Quality: Updated the agreed-upon columns in the "quality tap." And remove the error code if there is no any number Delays: Ensured delays are reflected as discussed. Task Order: Arranged tasks in the "task tap" from oldest to newest. Please review the file and let me know if you have any questions or require further changes. Requirements: 1- Required an option in this file (Excel) that when the planner change the completion date of any task in column K in the TASKS tap, the color of the cell will be changed to yellow, an...
Necesito crear una un excel con formulas que me calculen los montos acumulados segun una tasa de interes
Generar un reporte con tablas dinámicas nivel general y específico de una base de datos de 10,000 usuarios; se requiere mostrar presupuesto ocupado de 2023 y lo que va 2024; por diferentes áreas cómo se ha gastado el presupuesto, lo que se busca es un reporte como el del llamado ejemplo; pero con la información mostrada en base de datos; visualizar presupuesto utilizado por mes, y por usuario a nivel área.
I'm looking for a skilled Excel expert to automate the formatting of a spreadsheet from a Quickbooks export. Key Requirements: - I primarily need the freelancer to set up and automate formatting in my Quickbooks Excel spreadsheets. - The final formatting should be both visually appealing and easy to read for the end user, we will provide guidance on what the end result should look similar to. Ideal Skills and Experience: - Strong proficiency in Excel, especially with automating processes and conditional formatting. - Previous experience working on projects involving data visualization and presentation. - A good eye for design to ensure the data is clearly differentiated and visually engaging.
I have a project that involves data entry from an Excel file. The data needs cleaning and formatting before entry, and the end goal is data analysis. I am looking for a freelancer who can help me with the following: - Excel Data Entry: Transfer data from an Excel file into a designated system. - Data Cleaning & Formatting: Ensure the data is cleaned and formatted correctly before entry. - Data Analysis: Help in structuring the information in a way that facilitates analysis. Ideal skills for this project include experience in data entry, Excel, and data analysis. Looking for a reliable and detail-oriented freelancer to complete this task efficiently.
I require an experienced data cleaning specialist who can proficiently handle Excel spreadsheets. My project involves tidying up datasets related to customer, product, and financial data, though different types of data might need to be scrubbed too. This data cleansing task involves a lower volume dataset of less than 1,000 records. Key tasks include: - Identifying and correcting any inaccuracies. - Identifying and handling missing data. - Assuring the consistency of datasets. The ideal freelancer should have strong skills in spreadsheet management, a keen attention to detail, exceptional data analysis abilities, and a solid understanding of customer, product, and financial data. Experience in Excel and a proven track record in data cleansing are a must.
I am looking for a detail-oriented professional to assist me with basic data entry tasks in Excel. The primary responsibility will be to input data such as names and addresses into an Excel spreadsheet. Key Responsibilities: - Inputting basic data into Excel spreadsheet Furthermore, the project requires data verification. This means ensuring that the data has been accurately entered. You will be required to cross-reference the inputted data against the source material to detect any discrepancies or errors. Ideal Skills & Experience: - Proficient in Excel - Attention to detail - Strong data entry skills - Familiar with data verification processes - Previous experience in basic data entry This project is quite straightforward, but precision and accuracy ...
