Excel macro dynamic chartงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
หลังจากลูกค้าโทรเข้ามาเมื่อคุยเสร็จแล้วลูกค้ากดวางสาย หรือ พนักงานกดวางสาย อยากให้หลังจากนั้นประมาณ 20 นาทีให้โทรศัพท์กลับไปหาลูกค้าเพื่อประเมิณความพึงพอใจ โดยใช้ macro-survey เป็นเมนูที่จะโทรออกอัตโนมัติ
...สามารถ 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 ที่กำหนดให้
คำนวณ Dynamic flow เพื่อดูการ action เปิด-ปิดของตัว Valve ที่ Condition เเตกต่างกัน
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
Create a Dynamic Web pages for calculate transport charge using MySQL and PHP ต้องการโปรแกรมที่สามารถคำนวณค่าขนส่งสินค้าโดยนำข้อมูลที่มีผู้กรอกลงหน้าเวบมาคำนวณกับ Data base ค่าขนส่งสินค้าที่มี แล้วส่งให้ผู้กรอกลงหน้าเวบทางอีเมล
...focus on lead generation. Your primary task will be to integrate efficient contact forms across strategic pages to facilitate visitor engagement and ultimately, lead generation. I need somebody who can work with Velo to create the following: I have a website that I would like to create dynamic pages for all locations in the UK. I need the original template setting up, instructions how to generate the pages automatically. I need to be able to change the recipient of the form data on each of the dynamic pages. Key Points: - Your expertise in Wix Velo is essential as this platform is the foundation for the project. - You'll be tasked with implementing contact forms in key locations. These forms should be intuitive and user-friendly. - Experience with lead gener...
I'm looking for a developer to help me create a dynamic todo list using ReactJS. I don't have a specific design in mind, so I'm open to suggestions. The main functionalities I need are adding, editing, and deleting tasks. Skills and Experience: - Proficiency in HTML, CSS, and JavaScript - Experience with ReactJS - Ability to create clean and user-friendly interfaces - Knowledge of state management in React - Strong problem-solving skills and attention to detail
I am seeking a skilled full-stack developer to create a dynamic e-commerce website for a customised workwear business. The website must have a feature for customers to be able to customise a blank product with their own logo/design. The website's primary objective is to host a substantial number of products for sale, so experience with building comprehensive online stores is a must. Key Requirements: - E-commerce Expertise: I need a freelancer who's well-versed in e-commerce site development. Your prior experience with creating such platforms, particularly with a product range exceeding 100 items, will be highly beneficial. - Payment Gateway Integration: The website should allow customers to pay via credit card and PayPal. Your proficiency in integrating these payment me...
I am looking for a freelancer with experience in setting up a hosting environment on a Windows system for a dynamic website. Key Requirements: - Operating System: Windows - Website Type: Dynamic (WordPress, Joomla, etc.) - Full Setup: I need help with the complete setup including installation and configuration of necessary software Please include your relevant experience and skills in your proposal.
Functionalities of Chrome extension : 1: scan any buttons fields used computer vision or openai vision or Google gimini to recognize fields or buttons 2: creator record macro auctions in same time record/uploading voice and notes 3:export files then shared the files with others that have same chorme extension Output: macro working without in others that have same extension 4: deployment on marketplace
I'm seeking an experienced Excel wizard capable of making my inventory report more dynamic and adaptable. Here's what I need: - Total Calculations: The report doesn't currently update the total inventory count and monetary value when I adjust the count of individual items. I require this to be automated so the totals are accurately recalculated whenever an inventory count changes. - Regular Updates: Going forward, I will be regularly updating inventory counts on a weekly basis. I would appreciate if the system is simplistic and user-friendly for regular updates. Ideal Freelancer Skills: - Advanced knowledge of Excel functionalities - Experience on inventory management systems - Meticulous attention to detail - Ability to create user-friendly systems....
I'm looking for a skilled engineer who can design a self-supported steel chimney for a metal manufacturing plant. This chimney will be integral to industrial emissions control. Tasks Include: - Tailoring the design to accommodate the specific needs of a metal-manufacturing environment. - Incorporating robust safety features and compliances for high-temperature metal emissions. Ideal skills: - Structural Engineering - Industrial Design - Knowledge of industrial emissions standards - Experience with metal manufacturing processes.
I'm looking to revamp the user interface of my Solar2d application. The main goa...user interface of my Solar2d application. The main goal of this project is to refresh the look and feel of the app. I have a UX Designer who has completed a number of screens in Figma. Key points: - The focus is on enhancing the user interface. - The design style should be modern and sleek. - Incorporating high-quality images and icons to make the app visually appealing would be a plus. - Dynamic animations and interactive elements can be considered but are not the main priority. Ideal skills and experience for this project include: - Proficiency in Solar2d or similar platforms. - A strong portfolio that showcases knowledge - Ability to work on enhancing user experience and visual appeal ...
I need a dedicated LinkedIn Specialist to refine and manage our company's LinkedIn presence. Responsibilities: - Post three times a week, maintaining a consistent and engaging schedule - Connect with HR professionals and key decision-makers, aiming to cultivate a strong network - Engage with ...and milestones into compelling, shareable posts that will resonate with our LinkedIn audience. Ideal Skills: - Proven experience managing LinkedIn profiles for businesses - Excellent networking and relationship-building skills - Strong content creation and curation ability - Proficiency in LinkedIn's analytics and tracking tools This role is about more than just posting; it's about creating a dynamic, professional online presence that will help us establish strong relations...
I'm looking to hire a skilled web designer for a position in my agency. The ideal candidate should be proficient in Front-end development, UI/UX design, and Responsive design. Key Responsibilities: - Collaborate with the team to brainstorm, design and create visually appealing web content - ...who sign up and have previous work on display will be given a chance to work with a client. If a client wants to have the service as a monthly recurring subscription to my agency then the same freelancer/contractor will be working with them until/if the client feels they no longer need the service. This is a great opportunity for someone who wants to grow their web design career and work in a dynamic, creative environment. If you meet the criteria and are ready to contribute to our team...
...is capable of efficiently extracting table data from PDF documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - Expertise in Excel automation and customization. - Strong background in user management and access control systems. - Previous...
I'm looking for a creative video creator with a knack for engaging with adult audiences through dynamic visuals and infographics. Key Requirements: - The primary goal of this project is to teach new concepts. The ideal freelancer should have a background in educational content or health and wellness. - The video should be at an intermediate level of detail, presenting the information with some depth but not delving into overly complex or technical language. Skills and Experience: - Experience in creating educational content, especially for adult audiences. - Proven ability in designing visually appealing and engaging infographics. - A good understanding of health and wellness topics and the ability to present them in a clear, accessible way. - Familiarity with video editing ...
Are you ready to bring my vision for a children's book series to life? We're seeking a talented illustrator to transform our vision into beautiful illustrations that will captivate young readers. While we've created our cover art using generative AI and love the character it produced, we need your artistic touch to develop the dynamic images for the inside pages. What I Love: Pink Hard Hat and Gloves: The vibrant pink hard hat and gloves, especially with our logo customization, are fantastic! Facial Expression and Lashes: The character's facial expression and lashes are perfect and align beautifully with our design style. What We Can Improve: Locs: I prefer the locs from the last photo over the first one – they have more character and person...
...highlight the mural. • Secondly, there are missing portions of the sign text that I would like restored. The complete text should read as: [Sharkey Issaquena Medical Clinic]. Freelancers must have excellent photo manipulation skills to integrate the missing text smoothly and convincingly. • Lastly, the picture lacks vibrancy, I want the colors and saturation adjusted for a more eye-catching and dynamic result. Expertise in Adobe Photoshop or similar graphic design software is a must, as well as an eye for detail and aesthetics. Previous experience with architectural photos or restoration projects will be considered advantageous....
...papers - containing approx 50 questions each. For each question, I need someone to: - cut & paste an image of the question into a Google slides / Powerpoint document - 1 question (or sub-question if it requires a different skill per page - 1 document for each paper - name the skill(s) that are required to answer each question - as the title for each page - create a new line in a Google Sheets / Excel document with the following information: - skill required (copied from title of Google Slides document) - page number of Google Slides document that the question appears on Key Requirements: - The questions are from primary school level math exams, so a good understanding of these topics is crucial. - You will need to effectively categorize each question based on th...
I'm in need of a team of live streamers based in S...specific products and brands that I want the team to promote during the live streams. Ideal candidates should: - Be based in Saudi Arabia and have a good understanding of the local TikTok community - Have a passion for product reviews and promotions - Have a strong presence on TikTok with a good number of followers - Be able to effectively engage with the audience and drive sales - Be creative, dynamic, and able to think on their feet Your primary responsibility will be to host live streams, review and promote the products I provide, and engage with the audience in a way that maximizes sales and brand awareness. If you're a Saudi Arabia-based team of live streamers or an individual who meets the above criteria, I'...
...a website on a weekly basis. The scraped data should be efficiently saved to a CSV or Excel file for easy review. Capable of being plugged to a distribution app. Key Requirements: - Develop a Python-based web scraper that targets a website to extract text data - The scraper should be designed to run on a weekly schedule - Ensure that the code is concise and easy to understand for potential future modifications - Store the scraped data in a CSV or Excel file format Skills and Experience: - Proficiency in Python programming - Experience with web scraping libraries such as BeautifulSoup or Scrapy - Understanding of scheduling tasks in Python - Familiarity with working with databases, especially CSV or Excel files I'm open to discuss further enhancements and up...
I'm looking for a proficient Excel professional to develop a multi-country income tax calculator. This tool will primarily serve individual taxpayers, and potentially other user groups. Key Requirements: The calculator should support income tax calculations for multiple countries. This requires a deep understanding of tax laws and calculations in each country. - The tool should be user-friendly and intuitive, catering to users with different levels of tax knowledge. - It should be well-structured, with separate sections for each country to avoid any confusion for the end-users. Ideal Skills and Experience: - Advanced Excel proficiency, with experience in creating complex calculators or financial models in Excel. - In-depth knowledge of income tax laws and ...
I need an expert to develop a macro tailored to automating report production tasks in Microsoft Excel. The main purpose of this project is to streamline the process of regular report production and increase overall efficiency. Ideal skills and experience include: - Proficient in Microsoft Excel - Experience in macro development to automate tasks - Knowledge in automating report production Your role will involve designing and implementing a suitable macro for regular report production in Excel. I'm looking for someone who can provide a timely and efficient solution.
As a creator of wood and epoxy furniture and an aspiring YouTuber I require an experienced Shopify website developer who can create a platform for my products. The website should include a product catalogue and testimonials. Key tasks: - Develop a dynamic and visually appealing Shopify store. - Incorporate a user-friendly product catalogue system. - Integrate a testimonials section. The successful candidate does not need to worry about generating product descriptions or snapping exquisite product images; I will provide all necessary content. However, they should be able to present this content in the most engaging manner possible on the platform. Also I have a crappy site hosted by Wordpress already and would like to take that domain name over to Spotify if possible. I would al...
...database structures and maintaining data integrity. - API Integration: The application will interface with external systems through APIs. Your role will involve seamless integration. Frontend Developer Tasks: - JavaScript Development: Your JavaScript expertise will be crucial in building interactive and responsive user interfaces. - React Development: You will be working with React to create dynamic, efficient, and scalable frontend components. - User Interface Design: An eye for design and user experience is essential. You'll be responsible for creating an intuitive and appealing interface. The main purpose of this project is to build a sophisticated web payment application from the ground up. The successful team will need to communicate effectively, work well together, a...
I have a detailed, digital drawing of a couple of processes and I need a professional to convert it into a 1-page flow chart using Microsoft Visio. This task should take less than an hour for an experienced individual. Requirements: - Convert a digital, highly detailed process drawing (attached) into a 1-page flow chart - Expertise in Microsoft Visio - Any flow chart model you can use that is editable in case of changes. The ideal candidate should be able to quickly understand the processes from the drawing and translate them into a clear, concise and visually appealing flow chart. Experience with similar tasks and a quick turnaround are both highly desirable.
I am looking for an artist to create character drawings. I have specific characters in mind that I would like to be drawn. The project involves drawing 2 characters in 2D, a man and a woman in different postures. These drawing will be used in a ergonomics review, it has to be pr...character drawings. I have specific characters in mind that I would like to be drawn. The project involves drawing 2 characters in 2D, a man and a woman in different postures. These drawing will be used in a ergonomics review, it has to be professional and technical sometimes. Skills and Experience: - Proficiency in 2D character drawing - Ability to bring characters to life with expressive and dynamic poses - Attention to detail in line work and shading - Experience in creating unique and original charact...
Skills required Front-end: React or Angular for building a dynamic web application. Back-end: Node.js with Express for server management and API integration. Database: MongoDB or PostgreSQL for storing session data securely. Authentication: OAuth for handling secure authentication with streaming services. Technical Requirements and Development 1. Secure Authentication: Implement OAuth or a similar secure authentication protocol to allow users to log into their streaming services without storing their credentials. 2. Device Management: Develop a system to manage devices that can stream content, ensuring only authorized users can access the services during their stay. 3. Session Management: Ensure that user sessions are automatically ended upon checkout, or provide a simple way for ...
...communities. Heatmap visualization showing customer density. Regional Analysis: Breakdown of customers within a 50-mile radius. Analysis of major towns and cities contributing to the customer base. Heatmap visualization showing customer density. Sample Visualizations Heatmap of Customer Distribution: Shows areas with the highest concentration of customers. Bar Chart of Top 10 Cities/Towns: Displays the cities/towns with the most customers. Pie Chart of Customer Age Groups: Illustrates the distribution of customers by age group. Map of National Customer Reach: Highlights the states from which customers visit. I need a comprehensive geo-targeting report for a US-based business. The report will primarily focus on a specific city, state, and country, delving into neighborhood...
I'm looking to create a dynamic and user-friendly business website that effectively communicates my brand and services to visitors. The website should be visually appealing, easy to navigate, and optimized for search engines to help increase visibility. - A clean, modern design that aligns with my brand's identity. - Intuitive navigation structure to help users find information quickly. - Responsive design to ensure the website looks great on all devices. - Content Management System (CMS) integration to easily manage and update content. - Search Engine Optimization (SEO) to enhance online presence and attract more traffic. - E-commerce functionality, if required, to sell products or services online. - Social media integration to connect with my audience on different platf...
I'm seeking a skilled virtual assistant with proven communication abilities, to work specifically in US timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand profess...virtual assistant with proven communication abilities, to work specifically in US timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand professionally and persuasively when bidding on projects. - Communicating with leads: You'll be responsible for using various messaging platforms to engage with potential clients and leads. Ideal candidates should excel in written communication and have a knack for sales. Proficiency in project management tools is a plus. Our preferred mode of communication with leads is through ...