Excel calculation toolงาน
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 need a freelancer to help me type text from digital files to an Excel spreadsheet. - The data you will be typing is textual in nature, with the content coming from digital files. The final output should be an organized and error-free Excel spreadsheet. - Attention to detail is crucial. The ideal candidate for this job will have experience with data entry, exceptional typing speed and accuracy, and a track record of working efficiently with digital text and Excel. Please be sure to include any relevant experience and your estimated timeframe for completing this task.
As a professional aiming for a senior-level sales role in the fashion, tech, luxury, and hospitality industries, my LinkedIn profile requires a strategic overhaul. At present, it's unfocused and not optimized to attract recruiters. I'm looking for a skilled freelancer with expertise in LinkedIn optimization, particularly...especially for sales positions - In-depth understanding of the fashion, tech, luxury, and hospitality industries - Ability to tailor content to attract recruiters in these specific sectors - Strong communication and collaboration skills to ensure my profile reflects my seniority and expertise in sales. Above all, I'm seeking a freelancer who can help me transform my LinkedIn presence into a powerful tool for securing my next senior sales role in t...
Data Entry Project - I am looking for a freelancer who can assist me with typing work. - The project involves entering data into a spreadsheet or a database. - The ideal candidate should have excellent typing skills and attention to detail. - There is no specific software preference for data cleaning, so the freelancer can use Excel, Python, or any other tool they are comfortable with. - The dataset contains 100-500 records or entries. - The project requires accuracy and efficiency in data entry. - Experience in data analysis would be a plus, but not mandatory. - The freelancer should be able to complete the task within the specified timeframe. - Good communication skills and the ability to follow instructions are important. - This is a one-time project with the potential fo...
...registration, excel upload, and assigning packages. Key Requirements: - Develop a user registration system: The module should collect the following user information: Name, Email address, Phone number, password, course, batch. - Implement an excel upload feature: Users should be able to upload excel files select of course and batch - Enable package assignment: The module should allow for the assignment of packages to users. while user registration or excel upload Ideal Skills and Experience: - Proficient in PHP: As the app is built on this platform, a strong expertise in PHP is essential. - Experience in user registration systems: The successful candidate should have experience in creating user registration modules. - Excel upload integration: Experie...
I run a remodelling company, AXXION REMODELING, specializing in bathroom, kitchen, and basement renovations. I'm looking for a professional to design a modern house and a set of tools for my company. Your design work will play a pivotal role in showcasing our company's craftsmanship, style, and attention to detail. The modern style is key to our brand, so we're looking for a designer who excels in modern aesthetics. Key Project Details: - Design a modern house that reflects the cutting-edge and sophisticated approach of our company. - Create a set of tools for AXXION REMODELING. These tools should be practical, user-friendly, and well-suited for the demands of our day-to-day work. Requirements: - Proficient in modern design aesthetics - Experience in designing tools or eq...
I am in need of a comprehensive dashboard for my online chess academy. This platform will be used by coaches to monitor several aspects of our students' progress and academy administration. Key Features: - Stu...using this dashboard. - Payment Calculations: The dashboard should have a feature that automatically calculates payments based on an hourly rate. Skills and Experience: - Proficiency in dashboard development, preferably with experience in creating online learning platforms is desired. - Strong understanding of data visualization and user interface design. - Experience in integrating payment calculation systems into a dashboard. Your expertise in these areas is crucial in delivering a user-friendly, efficient dashboard that will greatly facilitate the management of my...
I need an Android or PC based application for creating quotations, generating invoices, and tax receipts. It should support offline functionality, with essential features available without an internet connection. Key Features: - Creating Quotations: The app should allow users to create comprehensive and customizable quotations, including options to choose profile, colour, glass, mosquito netting, etc. - Generating Invoices: Users should be able to conveniently generate invoices based on the created quotations. - Generating Tax Receipts: The app should also support the generation of tax receipts. Additional Requirements: - Save as PDF: The ability to save these documents in a PDF format is essential. - Customer Data: The app should maintain a database of customer information. - Edit Old ...
I'm a digital affiliate marketer who needs a comprehensive product cross-referencing and price comparison tool developed for my e-commerce website. The tool should be capable of processing data from around 30,000 products across 5-10 different stores. Key Requirements: - Cross-reference 30,000 products from 5-10 stores: The tool should be able to analyze and compare prices for a substantial number of products across multiple listed stores. - Avoiding Captcha and ad blockers: The tool should be designed to function effectively while avoiding common barriers like Captcha or ad blockers. - User-friendly filters: The tool should offer a variety of filters to help users refine their search results. - Display results directly on product pages: The com...
I need a comprehensive responsibility matrix for our Sap MDG...responsibility matrix for our Sap MDG & BODS project. - The Matrix needs to clearly outline the roles and responsibilities of each team member involved in the project. - It should include both high-level, overarching responsibilities and detailed, task-based responsibilities. - Our intention is to use this matrix as a live document for daily project management, as a reference document and as a tool to facilitate efficient communication between different teams. The successful candidate for this project must have: - Strong knowledge of Sap MDG and BODS - Experience in creating clear, comprehensive and actionable responsibility matrices - Excellent communication skills to ensure that the matrix is effectively used...
I need a web developer to implement a fundraising tool into my Shopify site that will track product sales of multiple teams. This tool should conveniently reside on the same platform as my Shopify site and include a user-friendly dashboard with comprehensive sales data. Key Features: - Monitor sales from multiple teams at the same time, similar to the setup on Poppinpopcornonline.com. - User dashboard should display various metrics: * Total sales per team * Highest selling products per team * Breakdown of individual contributions per team and top three highest sellers * Top selling products for each team member * Ability for the individual team member to share their link via email and social media Ideal Candidate: - Proficient in Shopify development - Experienc...
I have bank statements from Bank A that I need converted into an Excel spreadsheet. The specific transactions you'll be dealing with are both deposits and withdrawals. Here's what I need: - A thorough and meticulous translation of each individual transaction: both deposits and withdrawals. - Once this data is entered into the spreadsheet, I need you to sort it by transaction type. This role requires expertise in Excel and a keen eye for detail is essential, as the integrity of the data will be paramount. Knowledge about financial transactions, specifically deposits and withdrawals, will be useful. A background in bookkeeping or accounting will also be a plus.
I am looking for a skilled web developer to migrate my existing website to WordPress, the platform I believe I will be able to maintain easily. My personal brand is significant to me, and this website is the central tool for its showcase. Key tasks would include: - Migrate content: The written information on my current website is crucial and must be moved to the new site accurately. Ideally, you'll have: - Proficiency in WordPress migration and website design. - A knack for maintaining the integrity of original content in migration. - The ability to help me tie the website into and update my LinkedIn profile. The end goal is a self-maintainable personal brand website on WordPress with all the original detail. I'm open to discussing any design improvements you could su...
I'm seeking an experienced developer to create an online script that can automate the conversion of CSV files. Script must be browser based and linux based. No preference on programming language. Source file will need to be uploaded to CSV converter, and script will sort data and rename columns based of pre-existing requirements. Once conversion is finished, download link generated to download updated CSV.
I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeValue("0:00:...
I need assistance with a simple Excel data entry task. This job purely consists of data entry and doesn't require any form of data analysis. The data I need entered includes names and addresses. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience with data entry
I need a skilled photographer to take some high-quality lifestyle shots of my motorcycle tool bag. Key Requirements: - Lifestyle Shots: The primary focus of the project is to capture the motorcycle tool bag in a rugged and adventurous style. The images should visually convey the bag's utility and durability in a context consistent with the spirit of motorcycle riding. - Usage: The photos are intended for use on social media and online store listings. Ideal Skills & Experience: - Proven track record in product photography, ideally with lifestyle shots in outdoor or adventure settings. - Understanding of motorcycle culture and aesthetic. - Ability to deliver high-resolution, professional quality images suitable for online use. - Strong portfolio of previous work,...
I need a professional with excellent data entry skills to assist in cleaning and refining my existing data sets. The data is currently in Excel format, and I want it to be more organized and polished. Skills and Experience: - Proven data entry skills - Proficiency in Excel - Experience with data cleaning and refinement - Attention to detail Tasks to be completed: - Review the current data sets - Remove any inaccuracies or errors - Reorganize the data if needed - Ensure all data follows a consistent format The ideal candidate is someone with a keen eye for detail and the ability to handle large amounts of data efficiently. I expect prompt delivery and utmost accuracy in the task. If that's you, place your bid now!
I need a Python script that will help automate various tasks. Key tasks for this automation include: - File Management: the script should enable the organized handling of Word documents and Excel spreadsheets. - Data Entry: automation for data entry tasks. - Email Sending: automation for sending emails. The ideal candidate for this job should have: - Strong experience with Python scripting and automation. - Understanding of file management concepts and libraries in Python. - Ability to implement automated data entry and email sending functionalities. Looking forward to finding a professional who can deliver efficient, clean code for this project.
I'm seeking a skilled product designer to develop a high-quality prototype for a Golf Cleaning Tool. This tool should be innovative, showcasing the following key features: - An integrated brush for cleaning club heads - A turning electric head to add efficiency to the cleaning process - An incorporated solvent to sanitize clubs - An extendable clip-on feature for seamless attachment to a golf bag This demonstration prototype aims to thoroughly represent and test the product's functionality. Ideally, applicants should have prior experience in prototyping, strong understanding of golf equipment, and proficiency in incorporating electronic components. Your creative input is welcomed for improvement or enhanced features.
I need a uniquely developed tool for managing my Google reviews. The primary feature of this tool should be automating responses and providing analytics to monitor trends. It should also be able to alert me in real-time to any negative reviews. Key Features - Automated Responses: The tool should be capable of setting automated responses depending on the review sentiment. - Trend Analytics: It's important to be able to track review trends to gauge consumer satisfaction and adjust business strategies. - Negative Review Alerts: Immediate alerts on negative reviews for prompt response and reputation management. Ideal freelancers for this job should have experience in software development and familiarity with Google Review systems. Expertise in review monitoring, ...
Hi Roman, If you remember, last year you did a project for me to show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. W...show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. Would you be available? We can chat about the details, but basically, this is what I want: I have an Excel file with different sheets. For example, Founders, Advisors, Announcements, and Media. I want a code similar to the previous code (of course, more complicated) to read this Excel file and show the content of each sheet in a different format (as the amount of type of information is different). I will share an example of the Excel file with ...
...developer who can create a comprehensive project management tool consisting of a drag and drop kanban board and a drag and drop gantt chart. Key Features for the Kanban Board: - Task tracking: The tool needs to allow me to create tasks and move them across different stages. - Assigning tasks to team members: It should be possible to assign tasks to specific team members. - Adding due dates: The ability to set due dates for tasks is a must. - Notifications: The tool should be able to send notifications to relevant team members when there are updates or changes to their assigned tasks. Key Features for the Gantt Chart: - Creating dependencies between tasks: It should be possible to create task dependencies. - Showing progress of tasks: The tool needs to visua...
I'm seeking a talented developer with a solid understanding of Excel VBA and Python to develop a system that generates and runs Python code via a manual button within Excel. The Python code generated should have the capability to work with financial data specifically. Linguistic proficiency in Excel VBA and Python is required; knowledge in XLwings or a similar tool would be a significant advantage.
The website is designed primarily to serve as an informative platform about our services and broadcasting experience in the Free To Air sector. Information that needs to be conveyed on the website: 1. Detailed overview of the services we offer, outlining how we excel in the market. 2. Showcase our extensive experience in the field, driving confidence in our capabilities. The site will be mainly aimed towards potential clients and Free To Air broadcasters who are looking for reliable broadcast service providers. Ideal freelancers for this job should have proficiency in web design with experience developing informational websites for service-based businesses. Understanding of the broadcasting or related sector would be an advantageous, but not necessary.
As the project coordinator for my team, I need someone who can efficiently monitor our progress, ensuring that we stay on track and meet our deadlines. Key Responsibilities: - Monitor progress of the project - Manage the project in Trello Preferred Tool: Trello - Task assignment and completion - Due dates and deadlines - Comments and discussions Ideal skills and experience for the job: - Experience as a project coordinator - Proficiency in using project management software (specifically Trello) - Strong attention to detail and organizational skills - Excellent communication skills to liaise effectively with the team. The successful candidate will play an integral role in helping us successfully deliver this project.
I need a skilled Wordpress expert to address a migration i...the migration from a server running PHP 7.2.4 where the site worked to a server running PHP 8.2. The front end of the site works but now access to the back end gives the error "There has been a critical error on this website. Learn more about troubleshooting WordPress." I need someone to correct the code so that it works correctly. I believe that the issue may be connected to WPBakery To excel in this project, you should be highly experienced in Wordpress, with a deep understanding of PHP, theme and plugin compatibility issues. Your ability to troubleshoot and resolve migration issues will be crucial. I'm looking for a professional who can efficiently tackle this issue and ensure a smooth, seamless t...
I'm in need...tasks. This may include various forms of data manipulation, collection, and input. - Email Management: You'll be responsible for managing my email inbox. This includes reading, responding, and flagging important messages for my attention. - Appointment Scheduling: The role will also involve coordinating my schedule and setting up appointments. To excel in this role, you should have experience with: - Microsoft Office Suite, including Word, Excel, and PowerPoint. - CRM Software: Knowledge of Customer Relationship Management software will be a huge advantage. I'm looking for someone who can be available on an on-call basis for this role, as tasks may come up sporadically. Your punctuality, attention to detail and excellent communication skill...
...will cancel WOO BEFORE GO-LIVE TACTICS Woo site [store] 1. View cart and checkout – just few things, Apple Pay, Google Pay, specials 2. Add last 75 products - Excel 3. Add banners created, make responsive [786 pixels] 4. Upload same banners in mobile size also – mobile view of website needs fixing 5. Body system content pages – add the content; show team member how to add blogs 6. Build one content page from template; copy to five other pages; add content 7. Fix CSS so images are the correct size; AWS server 8. CDN and caching 9. Shipping partner: tracking number sent back to Pay Pal to close out the sale – adjust shipping calculation 10. Content pages for Woo [most will be done after go live] 11. Site speed 12. Rotating products on front page to...
I'm in need of a skilled Unity developer who can bring to life a 3D visuali...visualization of moving points. The purpose of this visualization is educational, aimed at explaining the concept of trajectory. Key requirements: - The visualization will involve moving points in 3D, following a trajectory that's dictated by data in an Excel file. - The movement of these points should be adjustable by the user in terms of speed. The ideal freelancer for this job would have: - Proficiency in Unity, with a strong background in 3D animations. - Experience in creating educational visualizations. - The ability to integrate data from an Excel file into the Unity project. Please note that while the visualization is primarily educational, it should also be visually engaging ...
2 winners will get 5 euros and a 5-...chance to win 5 Euros: 1. Report the user on Facebook using the appropriate reporting tool. 2. Take a screenshot of the report confirmation. 3. Submit the screenshot as your entry. The user to report: []() Rules: - Only one entry per freelancer. - Duplicate entries will be rejected. - The winner will be chosen randomly using an online random picker tool. Good luck and thank you for your help!
...for tracking attendance and payroll calculations. - Employee Location Tracking: I want the application to have a feature that enables employers to monitor the location of their employees. This is essential for ensuring work efficiency and for safety concerns. - Reports and Productivity Analysis: The app should have the capability to generate reports on employee productivity and efficiency. This tool will help in evaluating the performance of each staff member and making informed decisions based on the data. Ideal Skills: - Proficiency in Android development using Kotlin. - Prior experience in building business applications and employee management systems. - Understanding of GPS tracking and data analysis, along with UI/UX design for productivity tools. If you're a proacti...
