Excel conditional formatting between two timesงาน
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 ที่กำหนดให้
...fluently and knows driving bike/car. Speak Basic English Familiar with all the tourist attractions in your area or clubs,nightlife. Ideas to make tourists happy for secretarial jobs by being creative, smart, honest, punctual and hard working (10-12 hours daily). Should be currently living in Pattaya or should make his/her own arrangements for staying in Pattaya during internship. The testing phase is between September 29 to October 9, 2017. We are looking forward for people who love their work and are courteous and have good strong personality. Send in your resumes and your expected salary for a week. Additional perks in the bucket for selected employees. Benefits: You will directly work with the CEO for a week. After your internship, in case you are selected then after we setup...
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
Need an accountant who can use Xero accounting program and can help reconcile and tax. Monthly pay between 600-900USD for the right person. ใช้ xero program ได้เปนอย่างดี กระทบยอดบัญชีได้ทุกหมวด ปิดงบการเงิน ต้นทุน
...freelancer to create a click bot intended for mobile devices, mainly for Google Ads, to aid in ad testing for paid advertising. Key Requirements: - The bot should simulate mobile device interactions accurately, especially with Google Ads campaigns. - It should be able to interact with a variety of ad types, including banner ads, video ads, and interstitial ads. - The bot should be able to distinguish between different types of ads and follow a set of predetermined actions to simulate real user behaviour. Ideal Skills: - Proficiency in bot creation and automation for mobile devices. - Experience in working with Google Ads and understanding of how they function. - Strong understanding of paid advertising, particularly in the context of ad testing. - Prior experience with click b...
We am looking for a skilled freelancer ...visually appealing and responsive design for the search table Understanding: - Only Bid if you understand Project - Forward us a Sketch of what you can offer in order for Work to be considered - Many have offered they work without any understanding of project. - We will only create a milestone if the a idea proposal on sketch or link is offered Budget : - We have a tight budget for this table between $100 - $150 - Do not bid higher then this as we will not consider - Only bid an amount you willing to Receive based on the above infomation If you are confident in your skills and can deliver the project within the specified timeline, please submit your proposal. - Verified and Preferred with 5 star rating will be Strongly Considered ...
I'm looking for a skilled front end developer to help me create a dashboard focused on data visualization,The primary objective of this project is to develop a robust data virtualization tool capable of interpreting, displaying, and analysing collision avoidance system data extracted from log files. This tool will enable users to load log files or Excel files, interpret the data, generate reports based on specified parameters, and visualise the insights using a web application or Power BI interface.
I need a skilled Excel user to help me format a single spreadsheet and create formulas to automate some calculations. Key Responsibilities: - Format the spreadsheet to make it visually appealing and easy to read. - Create formulas to automate calculations based on the data input. - Ensure the spreadsheet is user-friendly and easy to update. Ideal Skills and Experience: - Proficiency in Excel, particularly in data formatting and formula creation. - Prior experience in handling data-heavy spreadsheets. - Strong attention to detail to ensure accurate data processing. - Ability to work independently and deliver the project in a timely manner.
I am seeking a meticulous architect to create a modern two-storied house plan with only master upstairs rest of 3 bedrooms to be at the ground floor along with living at the front . Pool and alfresco Key Requirements: - Proficiency in modern architectural design concepts. - Proven experience in creating house plans for permit applications. - Provide accurate dimensions and scaling for two floors. - Ability to adhere strictly to building codes and regulations. - Excellent communication and timeliness in delivery. This application requires you to have a keen eye for detail in modern design and a comprehensive understanding of permit application requirements. Previous experience in this particular field will be advantageous.
I am searching for a knowledgeable expert in Microsoft Excel who can assist me with a variety of tasks. Specifically, I require aid with formulas and functions, and formatting and design. More specifically, I need assistance with summation and averages, and VLOOKUP and INDEX-MATCH commands. The ideal candidate would have substantial proficiency and experience with Excel, with an emphasis on utilising complex formulas and creating aesthetically appealing and comprehensible spreadsheets.
...writer to create an ebook from the material I provide. The requirements are as follows: - Content Rewriting: You will need to rephrase and reword the provided content to ensure it is original and does not appear to be copied. - - Organization and Structuring: The material should be organized into a coherent and logical structure, including chapters and sections as appropriate. - Professional Formatting: The final product should be formatted into a professional-looking ebook, in the format of my choice (PDF etc.). - Collaborative Process: I will review drafts and provide feedback until the final product meets my satisfaction. Please ensure the final ebook is polished, engaging, and free from plagiarism. If you have experience in ebook creation and are able to deliver high-qual...
I have a simple text-based PDF file that I need to be converted into a Word document. The purpose of this conversion is to enable further editing and formatting. Key Requirements: - The PDF is straightforward, with no images or tables, just plain text. - The Word document should follow a standard business format, so no specific styling or custom style guide is needed. Ideal Skills and Experience: - Proficiency in typing and data entry - Familiarity with standard business document formats - Experience in PDF to Word conversion is a plus - Attention to detail to ensure accurate and error-free transcription
I'm seeking an experienced translator who can convert marketing materials between Chinese and English with a focus on maintaining a creative and engaging style. Key Requirements: - Translate marketing materials: These materials will include advertisements, product descriptions, brand content, and other related promotional texts and materials. - Bilingual proficiency: Both in Chinese and English, to ensure accurate and meaningful translations. - Creativity: The translated content should resonate with the audience in the target language while maintaining the essence of the original work. - Marketing expertise: A good understanding of marketing principles and the ability to adapt them to different cultural contexts. Additional Information: - This project requires translations in...
I'm looking for a professional who can get my news articles published in prominent online news platforms such as The New York Times, The Guardian, Times of India, ANI, Hindustan Times, Economics Times, and Forbes. Requirements: - Publishing: I need my content to be published on a weekly basis. - Content Type: The focus will be on news articles, so the ideal candidate will have experience in this specific type of content. Ideal Skills: - Experience in Publishing: A strong track record in getting content published in major online newspapers is essential. - News Article Writing: A background in journalism or writing news-focused content would be highly beneficial. - Networking: Well-established relationships with editors or a proven ability to establish t...
...currently all the emails that are sent from my website are customized using YAYMail, id like this be the same for the new custom email. HIGH LOAD ISSUE Im having an issue with my e-commerce store and the server it is hosted on, my hosting company has notified me that the server load is being reached often due to long running scripts causing the max children connections to be reached multiple times throughout the day, please see a screenshot of the information they have given me on the issue here: They have also indicated that the website appears to have cron jobs running continuously which may be contributing to the over all server load, they have also sent me a screenshot of this issue which can be seen here: They have sent
I am in search of an experienced professional to craft a concise and ...of an experienced professional to craft a concise and engaging company profile for my business. The profile should be in a Word document format and should be between 1-5 pages in length. I specifically want to highlight the following: - Company History: A succinct yet informative overview of our journey, achievements, and milestones. - Products/Services: Detailed descriptions of our offerings, emphasizing their unique features and value propositions. The ideal freelancer for this job should have a good grasp of business language and a proven track record of creating effective company profiles. Excellent writing and Word formatting skills are also essential. Previous experience in my industry will be an...
...items like cars. Key Features: - User Profiles: Users should be able to create and manage their profiles, which would include personal information, rental history, and ratings. - News Feed: The app should provide a dynamic news feed where users can discover new rental listings and updates from the platform. - Messaging: A secure in-app messaging system is crucial for facilitating communication between renters and owners. Ideal Skills: - Proficiency in cross-platform development, with a focus on iOS and Android. - Experience in building social networking apps, especially those with user profiles and messaging functionalities. - Previous work on e-commerce or rental platforms would be an added advantage. If you have the necessary expertise and are excited about developing a hi...
I have a Google Document that I need to convert to WPS Office for editing. The document has specific fonts and styles I'd like to maintain. The ideal freelancer for this job should have: - Proficiency in Google Docs and WPS Office - Strong understanding of document formatting - Attention to detail to ensure fonts and styles are preserved
I'm looking to establish a seamless, efficient synchronization bridge between Nextcloud and Dropbox. Key Requirements: - Master Source: Dropbox - Synchronization: I am open to both real-time or scheduled syncing, the preference being whichever is more efficient. - File Types: I want all file types to be synchronized between the two storage services. Ideal Skills and Experience: - Proficiency in both Nextcloud and Dropbox is essential. - Experience in setting up and maintaining synchronization systems between different cloud services. - Strong understanding of file systems and synchronization methodologies. - Ability to provide insights and advice on the most efficient syncing strategy for my needs. Please include examples of similar projects you'...
I am looking for a developer to help me with a few issues on my website. - LCP (Largest Contentful Paint): I am experiencing slow loading times which I believe is due to Largest Contentful Paint issues. This is negatively impacting user experience and I need assistance in resolving and optimizing this. - JavaScript Errors: There are some JavaScript errors that need to be fixed. It's important to identify the root causes and eliminate them to ensure smooth website performance. - Layout Issues: The website also suffers from layout issues which need to be resolved. This includes fixing elements that are not displaying properly. For JavaScript and Largest Contentful Paint you can use our Microsoft Clarity Account which shows the pages affected. I am looking for a professiona...
I'm seeking an experienced Excel guru to help create / identify two specific formulas on my spreadsheet. This project is URGENT. The right excel Guru can probably figure this out in less than an hour. Easy money. The first formula is related to searching a cell for one of four words and populating an adjacent column with a correlating value, based on the word found. The four words to be searched for are "Low", "Medium", "High", and "Not currently a priority". The adjacent cells are to be populated with correlating values 1, 2, 3, and 0 (to generate a Score). The cells are currently blank, and users of the spreadsheet will fill these cells by selecting from a drop-down list (of these 4 words). The objective is to create a f...
...our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing integration and consolidation is between 1GB and 10GB, so experience handling medium-sized data sets is ideal. Your main aim will be to ensure that the data warehouse is efficient and can handle the needs of our data integration and consolidation. Experience in similar projects is essential. You will be working with roughly 5 databases, some direct access, some via API (including basic XML feed in 1 instance). We do not ha...
I've a design prepared for a landing page and need a WordPress developer to bring this to life. The goal of the page is to provide information, so the focus will be on engaging, clean and user-fr...landing page and need a WordPress developer to bring this to life. The goal of the page is to provide information, so the focus will be on engaging, clean and user-friendly design and layout. Key Requirements: - Implementing the pre-designed layout into WordPress - Ensuring the landing page is mobile responsive - Integration of Google Analytics for tracking purposes - Ensuring fast loading times and smooth navigation Ideal Skills: - Proficiency in WordPress - Strong understanding of UX/UI principles - Familiarity with Google Analytics integration - Mobile responsive de...
I need to automate the process of making 5 bookings on every week. Some key requirements: - The automation should make 5 bookings on each week. - Each booking will have the same course, people and starting-times each week.... only the date varies. - It's crucial that the automation doesn't interfere with the site's functionality and doesn't breach any terms of use. - The booking opens 2 weeks before and others are manually waiting to book, so the booking script needs to run exactly 00:00:01 each week - Would be great if we could activate/deactivate the script ourselves as there will be a time during the winter and summerholiday, where we dont need it. - I have a list with names/logins, password and member-numbers on the 20 players (4 on each time) I need the b...
the workbook consists of the below sections: - Section 1 - Vocational Education & Training - Section 2 - Core & Employability Skills - Section 3 - Learning Design - Section 4 - Learning Delivery - Section 5 - Assessment - Section 6 - Administration - Section 7 - Work Health & Safety each section contains between 15 to 26 questions, i will provide martial to help with finding the answers. the workbook is a training and assessment work book
I'm searching for an experienced Wikipedia editor to transform a draft into a full-fledged live profile of our school on Wikipedia. Please be aware that the profile should n...profile: - The history of the school - Academic programs currently offered The successful freelancer must have a proven track record of creating and maintaining successful Wikipedia pages - please submit past work as evidence of your expertise. The style required for this project demands a balance between informal and professional - I want the school's personality to shine through without compromising the authority and respect required of a learning institution. Ideal Skills: - Wikipedia Formatting and Editing - Research Skills - Writing in an Informal Yet Professional Style - Past Successf...
I'm in need of a skilled content creator to help me generate engaging and informative articles. The articles I need will typically be between 500-1000 words each. These pieces should be concise and well-written, catering to a general audience. I'm looking for someone who can maintain a high standard of writing, ensuring the content is not only informative, but also engaging and easy to read. Previous experience in article writing or content creation is a significant advantage. It would be great if the writer has a background in SEO as the articles will be used to boost my website's visibility. Please provide samples of your previous work, especially if you have experience in article writing or SEO optimization. Your bid should also include the cost per article a...
...less than 3 minutes in duration and requires a range of editing tasks. The key tasks include: - Color grading: Enhancing and adjusting the colors in the video to create a coherent look and feel, as well as to enhance the visual appeal. - Visual effects: Adding or enhancing visual effects to make the video more engaging for the audience. - Transitions: Creating smooth and effective transitions between different scenes in the video. An ideal candidate for this project would have: - Proven experience in editing music videos, especially performance style videos. - Proficiency in color grading, visual effects, and transitions. - Attention to detail and a keen eye for visual aesthetics. - Strong communication skills to understand and implement my vision. Looking forward to seeing y...
I have a set of printed documents that I need to be typed into a microsoft word document in standard formatting. Ideal Skills and Experience: - Proficient in typing with excellent accuracy and speed - Familiarity with Microsoft Word - Attention to detail to ensure the standard formatting is preserved. Please note that the source data will be provided in printed form, so good comprehension and data entry skills are a must.
Hello everyone. I need a query for prestashop version 1.7.8.10. I need to run 2 times a day a check script on products that have quantity 0. When I have quantity 0, I need to disable the product. I need a script that performs this operation 2 times a day.
I'm looking for a skilled developer to create a user-friendly platform that will serve as a comprehensive search tool for dormitories. This platform will cater to both students and dormitory managers. Key Features: - User registration and login system - Detailed search functionality for finding specific dormatories - Comparisons between dormitories, based on user-specific parameters like price, location, user reviews and extras like Wi-Fi availability, breakfast and other services - Information display in a grid view format - Dormitory Profiles: Information provided in these profiles should cover Location, Pricing, Availability, Facilities, Reviews, and Ratings. - Search Mechanism: Users should be able to search for dormitories by Location, Price Range, and Amenities. Ideal s...
I'm looking for a professional email marketing agency that can manage an email campaign for me. Essential skills/experience required: - Proficiency with email service like mailchimp or similar - Previous experience in email marketing, particularly in promoting products - Ability to send follow-up email Key d...mailchimp or similar - Previous experience in email marketing, particularly in promoting products - Ability to send follow-up email Key deliverables: - Sending out 350 emails using our email id - Creating and sending follow-up emails - Providing a detailed report on the campaign's performance Please note, I have a template for the emails already. I also have the database of the people to send out in excel format - company name, email, first name and last name - ...
...competencies and capabilities effectively. Key Requirements: - Deep understanding of PowerPoint design, and good eye for attention-grabbing visuals - Ability to translate corporate and product information into engaging content - Experience in creating corporate PowerPoint presentations is a major plus Specific Elements: - The presentation should showcase our capabilities, the products or services we excel in. - While not necessary, a designer who can incorporate well-crafted infographics would be ideal. Looking forward to collaboratively creating a presentation that helps us stand out from competition and generates interest from potential clients....
