Excel if between multiple rangesงาน
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 ที่กำหนดให้
...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 ได้เปนอย่างดี กระทบยอดบัญชีได้ทุกหมวด ปิดงบการเงิน ต้นทุน
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 searching for a skilled copywriter with a knack for creating informative and educational material. The main focus of the job is not decided yet, as I have multiple areas of interest. Ideally, the right candidate will: - Have experience with various topics - Possess a knack for translating complex topics into accessible content - Have a firm understanding of how to engage and educate a reader through writing Being adaptable and open to a range of subject matters is an absolute must for this project. Your ability to create compelling, informative, and educational copy will govern the success of this task. Looking forward to welcoming you aboard!
This project requires the development of a website for promoting a business in Aurangabad. I am targeting a professional audience, primarily aged between 35 and 60. Key Requirements: - Expertise in creating engaging, user-friendly websites. - Experience in developing websites for businesses and organizations. - Understanding of how to effectively target a professional demographic. Ideal Skills and Experience: - Proficiency in HTML/CSS, JavaScript, and responsive design. - Prior experience in creating websites for business promotion. - Understands the preferences and browsing habits of professionals aged 35-60. - Strong UI/UX design skills to create an engaging user experience. This project is an exciting opportunity to create a platform that will help elevate a business's p...
I'm in need of a proficient PowerBI analyst who can effectively connect to different data sources: Excel spreadsheets, SQL database, and CSV files. Your tasks involve creating detailed reports and conducting: - Sales performance analysis - Financial dashboards - Customer segmentation I have a preference for Bar and Pie charts in the visualization of these reports. Ideal applicants should have valuable experience in these fields and have an innate knack for making data comprehensible. Excellence in the mentioned chart formats is paramount. Having a solid background in Excel, SQL and CSV data manipulation will be a plus.
I'm looking for a talented graphic designer who can create a vintage style poster to advertise my product. The target demographic is adults between the age of 25 and 50. Key Requirements: - Proficiency in Adobe Suite, particularly Photoshop and Illustrator - Strong understanding of vintage aesthetics - Proven experience in designing marketing materials for the specified age group The perfect candidate for this job would have previous experience in designing vintage style promotional posters and would understand the aesthetics that appeal to the 25-50 age group. This project will require a good balance between creativity and understanding of marketing strategy. Proficiency in English is required to ensure effective communication throughout the project.
We're looking for a developer experienced with AWS Amplify, API Gateway & Cognito to... 1: Fix the integration between registration form on web app and existing cognito user pool such that registration and login/logout works. 2: Deliver integration with mapping service to display registered users on web app map. 3: Deliver integration with API of a 3rd party IoT service along with some basic business logic. This work forms part of a wider development by a green tech start up. The opportunity to take an equity stake in the business is an option if a suitable candidate is identified. Note that project details will only be disclosed under NDA.
I'm seeking a capable graphic designer with a good eye for detail and creativity to design a business card for me. Your creativity will be key, as I am unsure about the color scheme or design but am inclined towards a detailed and artistic style. Key Requirements: - Detailed and artistic design: Create an engaging business card that strikes a balance between aesthetic appeal and information conveyance. - Brand Color Scheme: I am open to suggestions on the color scheme and design. Key here is a look that aligns with an artistic style. - Content: Though I have no specific content currently, a standard business card structure (with places for name, contact details, company's logo and slogan, and social media handles) should be followed. Ideal Skills: - High-level proficie...
I am seeking for property manager who have strong attention to details, college degree, access to email and knowledge of use a device (computer or phone), basic software tools (Microsoft Office - Word & Excel). Responsibilities • Gathering data from one source (Google Drive) to enter into document management (databases or partner websites by case) • Checking and reviewing documents for accuracy and completion • Attaching supporting files to the document management • Searching for additional information for documents that are incomplete • Verifying, correct, and delete unnecessary data, or combine data Data Management: Your job also includes maintaining basic property data such as address and size. The ability to organize, update, and retrieve this in...
Description: Are you a freelance sales professional with a knack for closing deals and a passion for helping others succeed in their careers? Our startup is seeking an experienced freelancer to join ...accounting industries, including common interview practices and requirements. - Outstanding communication and interpersonal skills, with the ability to tailor your pitch to different audience groups. - Self-motivated and results-driven, with a strong desire to achieve and exceed sales targets. If you're a freelancer looking for an exciting opportunity to leverage your sales skills and make a meaningful impact on the careers of others, we want to hear from you! Join us in empowering individuals to excel in their job interviews and achieve their professional goals. DM your...
I'm looking for a proficient software developer to create a bulk direct message tool specifically for Twitter. The primary goal of this tool is to enable me to send a pre-set message to multiple Twitter accounts at once. Key Requirements: - The tool should be able to send the same message to an unlimited number of Twitter accounts without any limits. - The message to be sent will remain the same for all accounts. There's no need for customization per recipient. Ideal Skills: - Proficiency in Twitter API and automation tools. - Previous experience in developing bulk messaging software. - Knowledge of best practices for bot development on Twitter.
I require a proficient developer to build slick and modern apps for bo...The app and website should be capable of generating and displaying astrology predictions personalized for each user. - Astrology articles and blogs: It should include a space for the regular posting of related literature like articles and blogs. - Online Purchasing: Users should have the ability to make purchases online. as well as they can buy pooja product online - Multiple Astrologer: The platform should support multiple astrologers, allowing users to choose their preferred one. The aesthetic I envision is modern and clean. An ideal candidate would have experience in developing web and mobile platforms with similar features and a portfolio which reflects their ability to create modern, visually appe...
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
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...
Description: Are you a freelance sales professional with a knack for closing deals and a passion for helping others succeed in their careers? Our startup is seeking an experienced freelancer to join...accounting industries, including common interview practices and requirements. - Outstanding communication and interpersonal skills, with the ability to tailor your pitch to different audience groups. - Self-motivated and results-driven, with a strong desire to achieve and exceed sales targets. If you're a freelancer looking for an exciting opportunity to leverage your sales skills and make a meaningful impact on the careers of others, we want to hear from you! Join us in empowering individuals to excel in their job interviews and achieve their professional goals. DM your ...
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 trac...
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...
...as per CEI 0-16 standard." additionally they tell me this: Additionally, considering that the distribution network voltage in Umbria is at 20 kV, there is a transformer power limit of 2000 kVA with Vcc at 6%. In fact, CEI 0-16 standard states that 'The user must not install transformer sections exceeding this power threshold; except for cases of larger sizes provided that, due to the impedances between the connection point and the LV side of the transformers (MT user lines, transformer short-circuit impedance, any limiting reactances), the fault current calculated at the transformer's LV terminals is limited to a value equivalent to that obtained considering only the limiting effect due to transformers of the limit size referred to in the previous paragraph.' ...
I'm seeking an expert who can assist me with the configuration of Zapier, to automate email to new leads acquired from Facebook. Here's what I need: - Configure Zapier to connect Facebook with Outlook. - The automated email should contain a collaboration ...can assist me with the configuration of Zapier, to automate email to new leads acquired from Facebook. Here's what I need: - Configure Zapier to connect Facebook with Outlook. - The automated email should contain a collaboration proposal. - The focus of collaboration is specifically on business development. Ideal candidate should be proficient with Zapier, familiar with setting up workflows between Facebook and Outlook, and understanding of email marketing. Prior experience in setting similar configurations wi...
I've developed a webpage using HTML, CSS, and JavaScript. While it functions perfectly on my local machine, I encounter issues once I upload it to the server. The server in question is hosted on Hostinger. I'm unsure if any changes have been made to the server configuration file. Key Points: - Troubleshoot the server upload issue - Resolve discrepancies between local and online versions - Clarify if server configuration files have been altered - Ensure the webpage functions as intended on the server Ideal Freelancer: - Experienced in HTML, CSS, and JavaScript - Proficient in server hosting with Hostinger - Skilled in server configuration file troubleshooting - Capable of identifying and correcting server-side programming discrepancies I'm seeking a p...
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...
As an online retailer, I need my Shopify store revamped to differentiate between products available for sale in Europe and other parts of the world. This system should work based on shipping restrictions, which I'll provide. Additional details: - Create clear and separate sections for products available in Europe and the rest of the world. - Organize with shipping restrictions in mind. - The system for product display within these sections isn't decided yet. Open to suggestions. Ideal freelancers for this task would be well-versed in Shopify and have experience in site organization and region-specific product differentiation. Familiarity with shipping regulations worldwide would be advantageous.
I need a professional to convert my Google document into a Word format. The primary purpose of this conversion is to share the document with my collaborators who use Word exclusively. The document contains integrated tab...the Word format. The freelancer must ensure that: - The converted Word document maintains the same formatting as the Google document. - Some tables, graphs, and images are editable as per my instructions, while the rest remain static. Ideal freelancers for this job would possess the following skills and experience: - Proficiency in Microsoft Word and Google Docs. - Abilities in discerning between editable and non-editable elements in a document. - Attention to detail to keep the formatting intact during conversion. - Previous experience with similar conversi...
so i have selfhosted this and i need something like this in between u just need to change style/css of radio form to look something like that package image
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...
