Excel contractorงาน
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 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 and Good review, Dont expect more I am not big fish...
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.
tengo libros excel que tienen diferentes planillas, son registros de notas de estudiantes, pueden ser varias hojas del libro excel, quiero poder transferir esa informacion a hojas con el mismo diseño en gsheets, y viceversa, lo que ponga en excel quieor que se envie a gsheets, y lo mismo de gsheets, puedo tener varios libros excel, cada uno con diferentes datos, quiero que cada libro excel y gsheets sea individual referente otro, y que se almacenen en diferente cuenta de correo electronico. adjunto imagen de referencia de una hoja del libro en excel. quiero saber cotizacion, manera de hacerlo, que se requeriria por favor.
I need a freelancer to create an Excel Database that stores detailed information on the quality non-conformities of our production. This Excel file should allow us to log in and track all necessary details related to each non-conformity event. Key fields required: -all fields see attached , and generate unique number NCR/ This project requires someone with strong Excel skills, good at setting up databases for easy data input, and retrieval. Our goal is to streamline the process of tracking these quality non-conformities and using this data to improve the quality of our product offering.
Project Overview: I am seeking assistance in integrating image links into two Excel sheets containing a total of 620 and 46 product entries for my Shopify store. Each entry includes links to the official websites where the products are sold. The task involves creating a new column labeled Images in both Excel sheets and inserting corresponding image links. This integration is crucial for ensuring that when uploading a CSV file to Shopify, each product will display its respective images seamlessly. Project Details: Scope: Adding image links to Excel sheets for 666 products in total. Task: Create a new column labeled Images in each Excel sheet and insert corresponding image links for each product. Requirements: Image links should open the respective product images...
I require a skilled contractor to integrate an existing API from an unspecified shipping carrier into my Prestashop store. This integration would enable automatic interaction between the carrier and my store. The key functionality sought is for the automatic posting of customer orders to the carrier's system and the subsequent status update in the Prestashop system whenever the carrier adjusts this status. What I expect from freelancers: - Past work details should be included in the application to demonstrate experience and expertise. Required API Functions: - Customer orders made in Prestashop should automatically post to the carrier system via their API. - Any changes of status made by the carrier should reflect in the Prestashop orders panel. Anticipated Status Changes: -...
Complete Excel Analytical and Descriptive Analysis on provided dataset by Friday 4 pm
...present the results in a detailed, report that relates to each hypothesis for my thesis research. The analysis is expected to be done using Excel analyses then further descriptive analysis is needed, focusing on summarising the main characteristics of the data and how they prove/disprove each hypothesis. This will involve exploring the responses to the survey questions, identifying patterns, trends, and constructing summary statistics. The key deliverable for this project will be as follows: an Excel spreadsheet with... - raw data in one tab (provided for you in the attached excel document) - cleaned data a separate tab (provided for you attached excel document) - your statistical analyses on other separate tabs a Word doc or PDF with... - insights and f...
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 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 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.
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 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 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.
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 gathe...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 referenced with t...
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.
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. If you...
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 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 communication skills to provide regular updates a...
I'm on the lookout for a talented virtual assistant who thrives on lengthy hours of work and enjoys every second of it! This isn't your usual VA role, though - I'm seeking someone who can confidently handle the following responsibilities: - Social Media Management: More specifically, I need someone adept at Instagram. You'll be responsible for handling and managin...our audience. Ideal Skills and Experience: - Clear understanding of the Instagram platform and how to optimally engage audience in it - Skills in crafting Instagram worthy content - visuals, captions, and stories - Experience in managing professional instagram account is a plus - Must be organized, communicative, and able to handle long hours of work If this sounds like the sort of work you'd exc...
For this project, I require an expert who can efficiently extract text content from two distinct webpages and input my data into an Excel file organized by rows. Given that all types of data hold equal importance to me, of essence is for the professional to: - Accurately scrape all text content from the specified webpages - Ensure no data is skewed or omitted during this process - Neatly organize the data by rows in the Excel file The ideal candidate for this job should be proficient in web scraping tools and techniques, possesses an acute attention to detail, and is experienced in using Excel to ensure data is properly formatted and easy to analyze. Please note that minimizing errors during this process is critical, as the data collected will directly influence fur...
...contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, where you will be able to ...
I require a freelancer to type text data into an Excel sheet from printed documents. Scope of work: - Convert printed text documents into digital format via Excel - Ensure data is accurately entered The project does require specific formatting: - Data should be arranged in rows Ideal candidate: - Must have proficient Excel skills - Experience with data entry - Attention to detail, to ensure accuracy in work - Able to follow specific instructions for data organization
...tenure, salary and location of our employees. Your ability to structure and organize these aspects will be key. - Creating an Excel-based system: I'm looking for a dashboard that's easy to dissect and understand. As such, I'd like the final product to be in Excel spreadsheet format. This means you should be very proficient in Excel, knowing how to integrate formulas, tables and other relevant features. - Monthly updates: The dashboard should be designed to be updated monthly. You should be dedicated to ensuring that the data is up-to-date and accurately represented. Ideal freelancer should have: - Proven experience in HR analytics and dashboards - Excellent Excel skills - Ability to present complex data in a clear and concise manner - Strong...
I have an excel sheet with intermediate complexity data, including formulas and charts. I need someone to transfer this data into tables, with the primary goal of organizing the information for better clarity and ease of understanding. Key Tasks: - Type the data into tables: This needs to be done with meticulous attention to detail to ensure accuracy and integrity of the data. - Apply borders and shading: To enhance the visibility of the tables and make them aesthetically pleasing. - Utilize headers: Rows and columns should have appropriate headers to aid in quick data navigation. Ideal Freelancer: - Proficient in Excel: Ability to work with intermediate level of data such as formulas and charts. - Strong attention to detail: Critical for ensuring that data is entered accur...
...looking for an Excel expert who can create a comprehensive sales target tracking spreadsheet for my customers. This spreadsheet should have several key functionalities. Features Needed: - Customer Information: It should contain a section where I can input and maintain all my customer's details. - Sales Tracking: The spreadsheet should enable me to track my sales targets daily and provide a detailed analysis of my performance. - Target Achievement: The spreadsheet should also be able to analyze the achievement or shortfall of selected items target completion by each customer. Analysis Required: - I would love to have a feature that shows how well sales targets are being achieved as per defined targets. Ideal candidate should have great attention to detail, proficiency...
