Excel filter multiple columns simultaneouslyงาน
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
Programming with c # or C ++ connected to the camera. Face Detection with Face snapshot datetime into the database with MySQL. CCTV ( Detection Face of multiple pages on a single ticket )
I'm looking to build a loyalty app that can be utilized across multiple industries. While I've missed providing specific features, target audience, and user interaction details, my aim is to create a versatile SaaS solution. with same idea in Key requirements: - Development of a user-friendly, scalable, and secure loyalty SaaS platform - Integration of points-based reward system - Provision of customer analytics and insights for business owners - Consideration of various target audiences including retail, restaurants, and service providers - User-friendly interface for both customers and business owners - Integration with Apple wallet and Samsung pay The ideal freelancer for this project would have: - Proficiency in SaaS software development, particularly within
I require someone skilled in data management and conversion to transform my Excel data into CSV format. • The task involves converting Excel datasets into CSV. • Mastery in data conversion, specifically from Excel, and knowledge in CSV files is critical. • Understanding of data integrity to maintain the original information accuracy during conversion is necessary. • Careful attention to detail is required to ensure every data point has been successfully converted. • Prior experience with similar data conversion projects is a plus. • Freelancer should be able to deliver the project within the agreed timeframe, ensuring satisfaction and precision.
Objective: To create a comprehensive guide demonstrating how to change the color of icons to specific RGB codes and remove backgrounds using a widely available tool. Additionally, to develop an After Effects design template that can be replicated to create multiple outputs suitable for sharing on YouTube Shorts. The template should allow for easy text editing while maintaining a consistent overall theme. Lastly, to create a flow chart template and animate it using After Effects or another suitable tool. Requirements: 1. Icon Color Modification and Background Removal Guide: Research and select a widely available tool suitable for icon color modification and background removal. Develop a step-by-step guide detailing the process of changing the color of icons to specific RGB codes an...
...facilitate the sale of tickets for events. The system should be able to handle large quantities of tickets, as well as different ticket types (e.g., VIP, Regular, Early Bird). - **Digital Ticket Delivery**: Users should be able to receive their tickets through digital download. This requires a secure and user-friendly interface for ticket delivery. - **Event Variety**: The system should support multiple types of events, in this case, nightclubs and festivals. It should have a user-friendly interface that accommodates the unique requirements of each type of event. The ideal freelancer for this job should have experience in building e-commerce systems and ticketing platforms. Knowledge of event management software and the entertainment industry is a plus. Please provide examples o...
I require administrative assistance in the task of co...numeric and textual data from standard format PDF scanned documents into an Excel file. Accuracy and attention to detail are critical for this job. Experience with data transcription, PDF documents, and Excel is greatly valued. Your task includes, but is not limited to: - Reviewing each standard-format PDF document - Transcribing the numeric and textual information into Excel - Ensuring high-level accuracy in data transcription - Managing and updating the Excel file as required - Saving the completed PDFs according to a standard naming format The ideal candidate for this job would have a keen eye for detail and demonstrable experience in data transcription or related fields. Familiarity with standard for...
I'm seeking an Excel expert to provide a comprehensive training session for my team of 11-20 individuals. We're at a beginner level and need someone capable of teaching us the basics and showing us how to optimally utilize data analysis and reporting features. - The training should cover: - Basic Excel functions and formulas - Data analysis - Reporting techniques The perfect fit for this project would be someone with an extensive background in Excel, ideally as a trainer or educator. Experience with teaching groups is a must, and the ability to break down complex topics into digestible, understandable parts is essential. Our goal is to increase our productivity and data handling capabilities through this training, so if you have a track recor...
I'm looking for an Excel expert who can create an automated template for a financial renewal analysis dashboard. The dashboard should include basic descriptive statistics functions such as mean, median, mode, standard deviation, correlation, and regression. Key Requirements: - The dashboard needs to focus on the renewal status of our products/services. - It should be able to track the renewal status by product/service type. - The dashboard should be able to automatically update renewal statuses. Ideal Skills and Experience: - Proficiency in Excel and its advanced functions. - Experience in creating automated dashboards. - Understanding of financial data analysis, particularly in the context of renewals. - Strong communication skills to understand our specific needs and...
I'm in need of an intermediate level automated meeting minutes solution on Excel 2016. This project requires expertise in Excel and VBA and knowledge of data categorization. Key requirements include: - **Template Generation**: The tool should be able to generate a meeting minutes template automatically. - **Categorization**: Information in the meeting minutes should be categorized by attendee. Date Task owners Points discussed New Ideas generation' related System Process People Technology others Ideal skill set for this project includes: - Proficiency in Excel, particularly Excel 2016 - Experience in VBA/Macros for Excel - Previous work with data categorization and template generation Looking for someone who can deliver a robust, user-fri...
My project requires an exp...Wikipedia's stringent guidelines for page creation. The individual in focus is a living figure with ample reliable, verifiable, and independent sources to confirm their notability. Key tasks include: - Researching and compiling information - Ensuring presented facts are unbiased and objective - Crafting the write-up adhering to Wikipedia’s content and format regulations - Citations from the multiple sources I will provide Ideal Candidate: - Proficiency in Wikipedia page creation, specifically regarding living individuals - Strong research abilities & understanding of Wikipedia content guidelines and referencing - Excellent English writing skills Looking forward to working with a skilled Wikipedia page creator. Note that we need both E...
I am looking for an expert with experience in integrating multiple delivery service providers into a single platform for my grocery business. The integrations we require include: - Ekart Logistics - Ecomm - Delhivery - Other delivery service providers operating in India The key features we expect from the delivery service include: - Real-time tracking - Delivery time estimation - Customer reviews and ratings I need someone who is skilled in system integration, has experience with delivery service providers, and has a creative approach to problem solving. The goal is not just to integrate these services, but also to understand their operational inclinations so we can optimize for customer satisfaction. The ideal freelancer should have a background in logistics, a good understand...
I am looking for a Video editor that can perform the following tasks - - Remove green screen and replace it with image background - Combine multiple footage - HD (1080) Render
I'm looking for a proficient Python coder who can develop a program that effectively reads numerous reviews and generates a concise summary, encapsulating the main points in 300 words in multiple bullet points. Key Functions: - Extract data from a relational database via SQL queries. - The ability to process and analyze reviews from different platforms such as blogs, social media, and online stores. - Generate a coherent 300-word summary from a multitude of reviews. Required Skills and Experience: - Expert level understanding of Python programming. - Knowledge and experience in SQL querying is a necessity. - Experience with Natural Language Processing for summarization. - Familiarity in dealing with relational databases. - Prior experience with text summarization or related...
I have a need for a meticulous freelancer with solid web research and data entry skills. The project involves researching company details and the necessary data should be accurately entered into an Excel sheet. Key Responsibilities: - Detailed online research to gather specific company data. - Accurate data entry of information into Excel, adhering to specific guidelines. Ideal Candidate Skills: - Strong web research ability. - Very accurate data entry skills. - High proficiency in Excel. - Able to meet deadlines. - Excellent attention to details.
I'm in search of a proficient Web developer to create a full E-wallet web application. This project requires to be Linux compatible and adapted to a modern UX/UI design. Key features should include: - Deposit and Withdraw from E-wallet - Mobile Top Up International - Gift card voucher selling capabilities - A functional crypto wallet - Support for multiple currencies - Integration with several payment gateways - Other innovative features to enhance user engagement and convenience. Ideal Skills and Experience: - Proficient with Linux - Knowledge of modern UX/UI design - Proven experience in developing e-wallet applications - Understanding of payment gateway integrations - Familiarity with cryptocurrency technology. Your proposal should detail your experience in these areas ...
I'm in need of a skilled freelancer with proficient online research and data entry skills. Responsibilities: - Conduct online research to collect necessary data - Expertise in entering numerical data precisely - Compile, verify accuracy and organize the information into a Excel spreadsheet Desired skills/experience: - Attention to detail - Experience in data entry - Excellent knowledge of MS Excel - Strong ability in online researching
...varieties in addition to the existing Peanut variety. Specific Varieties: - The packaging must clearly showcase both Almond and Cashew along with Peanut as part of the rebranding. The ideal candidate for this project will have prior experience in packaging design, especially for food products. You should have a strong understanding of brand integration and how to maintain a cohesive design across multiple product varieties. Experience with Adobe Creative Suite or similar software will be an advantage. Main Scope: Font side: Replace Red with Green, and format of Bali Nutra style. Incase the reese with blue, red, gold foil that overlaps. Color font of Cashew in Blue, Almond in Red, Peanut in Gold. Back Side: Similar to attachment (Exclude Nutritional Data Provide Editable F...
...01 Signup Form with Phone, Email, Address Step 02 A chat box would open up with basic questions as; • Date for Booking • Time Period for Booking Step 03; Within the chat box the next question would be regarding the work profile Users can text to match profiles. Example: I want Bamboo Artisans Step 04: The Chat box will show all profiles for Bamboo Artisans as in the Directory or excel file Excel would be as simple as Skill Set, Profesional Profile Step 05: The User will select the profile they want and the next would be followed to payment gateway. Step 06. Post payment a confirmation message would be sent with contact details Service Provider Interface Step 01 Signup Form Step 02 Detailed Profile Step 03 View Bookings, View Amount which will b...
I'm looking to build a live dashboard that will display the results of both the Presidential and Local elections in real-time. Key Requirements: - I need the dashboard to be able to pull data from reliable sources(officials in polling station in an excel form) and refresh the data in real-time. This will facilitate the display of accurate and up-to-date results. - The design of the dashboard should be clean,animated,interactive, intuitive and easy to understand for users. It needs to be able to show data for both elections simultaneously with the help of a switcher between the two pages. - The dashboard should be mobile responsive, so that it can be viewed on various devices with ease. - The security of the data is paramount, so it's important that the dashboard is...
...Side Social Media Options. 10. Categories Create Option and Select. 11. Trending Page + High View Post. 12. Search Home Page Option. 13. Footer Ads + Link Option. 14. Google Ads Option Manual and Auto. 15. App Listing: App link, Banner+Js Copy+FAQ+Footer Marquee Text 16. Brand Logo Change+ WhatsApp Link 17. Full Analytics All Website Like Every Days, Months, views+ Per Apps Views 18. Admin Pannel Multiple User Like I am Main Admin and My Another Team Members Post Apps+ Views Analytics 19. SEO Friendly URL 20. Sitemap Automatically Generated+ Frequently Daily Change I haven't chosen a design motif yet, so ideally, you're able to suggest and create designs that are user-friendly, attractive, and compatible with the features. In addition, no specific external integrations...
I'm in need of an Expert Excel programmer to help design a user-friendly Excel sheet focusing on stock and ledger management. Specifically, I'm interested in: - Incorporating Automatic Calculations: The ideal candidate should be able to create a system that automates complex calculations based on data inputs. - Dropdown menus: The sheet should offer an easy interface with dropdown menu options for hassle-free data inputs and editing. - Linking Stock and Sales: The sheet should be designed in such a way where the inventory updates automatically from sales data. So, a keen understanding of Excel's data integration and interconnection capabilities is necessary. - Essential Data Fields: My Excel sheet needs to include specific data fields like stock name, q...
...should allow for the easy management of inventory. - Warehouse Overview: An overview of warehouse status and stock levels should be clearly available. User Interface Design: - List View: I envision the inventory management interface as a list view with search and filter options for easy access and manipulation of data. Ideal Skills and Experience: - Proven experience in Python frontend development - Strong understanding and experience in Inventory management systems - Proficiency in creating user-friendly UIs with search and filter options - Ability to distill complex data into clear and actionable insights - Previous experience with warehouse management systems would be a great advantage. If you have the skills and experience needed, I'm looking forward to hearin...
I just need a list of employees from Linkedin Recruiter.. I will get in a google-meet or zoom meet with you, and I give instructions. _We need to find the list of 'Open to Work' People from a particular Company in India. The re...Work' People from a particular Company in India. The reason for doing that is, We want to look for employees, who are considering Job switch from this company. _we will together log into your Linkedin Recruiter account _We will look for 'open to work' candidates _we will export the list (around 313 people) in CSV or Excel or PDF format. _If exporting the list is costly, in that case, I will simply take screenshots of the List (of candidates), and will later convert that into excel sheet. **The Task will take maximum of 1...
I have a project that involves the entry of data from Excel into a new system. The data entries are in Excel format, and I estimate the total number of entries required to be between 100-500. The task will involve a mix of text and numeric data. Ideal Skills: - Proficiency in Excel - Strong attention to detail - Efficient, accurate data entry - Previous experience with data entry projects of similar scale This is a straightforward task that requires someone who can work accurately and efficiently. Meeting the estimated entry count and maintaining data quality are key.
1. Develop a function that copies specific fields from Account records into corresponding Ticket fields automatically. 2. Develop a function that auto-fills multiple Ticket fields based on the input from a manually entered field. This function should dynamically pull data from the account database and populate the ticket fields according to the values entered. If your work meets our expectations, we may be interested in an ongoing collaboration for future projects across various Zoho applications (Desk, CRM, Campaigns, Projects)
10 Minute task on remote app AnyDesk - Disable the possibility of multiple clicks/submissions. - Prevent blank form submissions.
Need an extremely competent financial modeler in Excel who is capable of working with a lot of date math in formulas. You need to work on a working model template. NOTE: Do not apply if you are not genuinely capable of working with complex models. I am looking for help because I'm busy, not because I'm not capable! I make huge financial model templates on topics people don't model. I made a model on "ESOP" (Ownership structures for startups). ISSUE A client input dates in a way I didn't test and I realized I built in circular references I wasn't aware of. TASK Remove circular references (Need to change logic a bit to do it, which is not simple) Ideally break test to see how I messed up date math when dates are similar so won't be issues wi...
I am in need of a robust and efficient inventory management system made in Excel. This project requires: - Tracking of product quantities and managing stock levels to ensure seamless operation - Cataloguing of each product's relevant information including its name, SKU/Part number, quantity, batch number and expiry date - Methods of updating system quantities should be manual entry and bar code scanning. Knowledge in these methods is required. Ideal candidates should have extensive experience in Excel and inventory management system creation, preferably with a sound understanding of retail or related sectors. They should also be adept at implementing bar code scanning into Excel systems. Sharp attention to detail and ability to optimize for efficiency and usab...
...platforms will you post" for reference** Requirements: 1 article for product placement marketing about my Amazon clients' products.(and put the link to the product in your articles) [A new way to clean your pet's teeth] we can discuss and adjust the article if need these articles to at least 10 related news platforms/blogs in the US only. For example, post pet care articles to multiple USA pet care platforms. we can discuss and adjust the platform if need a report detailing which news platforms you posted to and which performed the best. us to quote your article for use on our social media,website and Amazon posts. if you meet those requirements please leave the information i need, Thank you. article: Presenting the best method for cleaning your dog
..."examples of your past work",and "how many platforms will you post" for reference** Requirements: 1 article for product placement marketing about my Amazon clients' products.(and put the link to the product in your articles) we can discuss and adjust the article if needed these articles to at least 10 related news platforms/blogs in the US only. For example, post pet care articles to multiple USA pet care platforms. we can discuss and adjust the platform if needed a report detailing which news platforms you posted to and which performed the best. us to quote your article for use on our social media,website and Amazon posts. if you meet those requirements please leave the information i need, Thank you. (article: Highlighting the importance of hea...
I'm in need of a pro who can assist in adding multiple members to a WhatsApp group at once. The contact details will be forwarded to you via email. Key Requirements: - Adding multiple members at once to a WhatsApp group - Contact details provided via email - Sending confirmation messages to new members via WhatsApp Ideal Skills/Experience: - Proficiency in WhatsApp - Strong email management skills - Excellent communication skills - Experience in managing group memberships is a plus Please let me know if you're up for the job.
