Excel vba improve worksheetงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
1. ใส่ VBA ให้รายการที่ Tickแล้ว ย้ายจากtabแรกย้ายไปเก็บใน tab2 (done list) และให้วันที่ในtab2 เป็นวันที่ที่ย้าย 2. ใน tab ถ้าวันที่ในรายการ ไหน <3 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
...สามารถ 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 ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
Improve my PS website ranking for 10 local keywords in 1 month - organic SEO - white hat only - off-site SEO - website to own the top ranking for 10 local keywords - work report (weekly) - every wednesday - keywords ranking report (weekly) - every wednesday - need to see improved ranking result in 1 month. - not more than 75 USD - keyword นายสิบตำรวจ สอบประทวน สอบนายสิบตำรวจ นายสิบ สายอำนวยการ นายสิบ สายปราบปราม สมัครนายสิบ สมัครนายสิบตํารวจ ติวนายสิบ กำหนดการสอบนายสิบ สมัครเรียนนายสิบ
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
Improve my PS website ranking for 10 local keywords in 1 month - organic SEO - white hat only - off-site SEO - work report (weekly) - keywords ranking report (weekly) - need to see improved ranking result in 1 month to continue another month - not more than 75 USD - keyword นายสิบตำรวจ สอบประทวน สอบนายสิบตำรวจ นายสิบ สายอำนวยการ นายสิบ สายปราบปราม สมัครนายสิบ สมัครนายสิบตํารวจ ติวนายสิบ กำหนดการสอบนายสิบ สมัครเรียนนายสิบ
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
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 content to enhance visibility - Track analytics to measure and improve our LinkedIn performance Your primary goal will be to nurture professional relationships within our industry. This role will require a strategic approach to networking, utilizing engaging content to foster connections. The content you'll be focusing on is mainly company updates and achievements. You must translate our successes and milestones into compelling, shareable posts that will resonate with our LinkedIn ...
...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...
...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 personality. Safety Gear: Since our organization prioritizes safety, let's add a safety vest and possibly safety goggles to complete the look. I love the Locs in the last photo much better than the first. Our organization is also really big on safety, so adding in ...
I need an expert to retrieve a missing Excel document from my Windows configured laptop. This document has been missing since February 2024, and I have no backup available. The document was created using an unknown version of Excel, so the freelancer would need to check the specifics during the recovery process. Key requirements: - Recover the missing Excel document which was lost for unknown reasons - No backup available - The document was created using an unknown version of Excel Skills and experience needed: - Proficient in data recovery - Experience in retrieving files from Windows systems - Familiarity with different versions of Microsoft Excel
As a professional in computational chemistry or biophysics, I'm currently looking for an expert mentor in the field to guide me through various aspects of molecular modeling and simu...- Has publications in international journals - Strong background in Protein structure prediction, Molecular simulations, Coarse-grain modeling - Proven experience in mentoring or teaching - Excellent communication skills and the ability to convey complex technical information in a clear and concise manner Your guidance will be crucial in helping me deepen my understanding of these topics and improve my practical skills. I'm particularly interested in a structured, systematic approach to learning and problem-solving in the area. Looking forward to finding an experienced mentor to guide me t...
...instruction, guidance, and feedback to enhance students' comprehension and to inform future tutoring sessions. -- Maintain accurate records of tutoring sessions, including attendance, progress notes, and relevant information to deliver comprehensive progress reports. -- Collaborate with Team Leaders and colleagues to review QA analysis, session KPIs, and overall performance to continuously improve yourself and your team. -- Perform any assigned or necessary additional duties. ROLE REQUIREMENTS -- Be at least 18 years old with a bachelor's degree. -- Fluent in English (CEFR Level B2 or higher) and demonstrate a mastery in Math (Basic Math; Pre- Algebra; Algebra; Geometry; Trigonometry; Pre-Calculus; Calculus; ACT/SAT) or English Language Arts (Engli...
...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...
...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.
...outcome. - Color correction: The images require color correction to enhance their overall appearance and ensure consistency across the set. This involves adjusting brightness, contrast, and saturation to achieve the desired look. - Image retouching: Certain imperfections in the images need to be addressed through retouching. This may include blemish removal, skin smoothing, or other enhancements to improve the overall quality. Additionally, there will be a need for placing the product image in both stock photo backgrounds and AI-generated backgrounds. The successful freelancer will need to seamlessly integrate the product into these environments, ensuring a natural and appealing final result. The final deliverable should be in JPEG format. I am looking for someone with an eye f...
I need a skilled ERPnext developer who can deliver top-notch technical solutions to improve our system. The project is urgent and needs to be completed ASAP. Key Requirements: - Customization of Sales & CRM, Payroll, Project task management, HR modules: We are looking for someone to tailor these modules to our business needs, ensuring they function optimally. - Seamless integration with erpnext: We need the developer to integrate our system with erpnext seamlessly, without any disruptions in our current workflows. The ideal freelancer for this job would have: - Proficient in ERPnext: Experience working on ERPnext projects and a deep understanding of its functionality. - Integration Skills: Capable of integrating systems smoothly and efficiently. - Urgency: Able to work quickly...
I'm looking for a back-end developer to enhance the functionalities of an existing website. The goal is to introduce new features and improve the website's overall performance and user experience. The main tasks include: - Integrating user login and authentication systems in the website - Implementing database integration - Incorporating a payment processing system The website is currently built with Ruby, so proficiency in this language is highly preferred for this project.
I'm seeking a skilled web designer to improve an existing visually engaging, informational website for a general audience (mostly big companies and legal companies worldwide) It will primarily host text and image content. Ideal candidate should: - Have a rich portfolio of visually diverse websites - Have strong expertise in designing image-focused sites - Understand best practices to cater the design for a general public - Be detail oriented, and able to optimize images for quick loading times and responsive design. The existing website that i want to improve is
I'm looking for an experienced SEO specialist who can help me in enhancing the search engine rankings of my website. Key Project Details: - Current SEO State: The website has a moderate SEO foundation in place. - Primary Goal: The primary objective of this project is to improve search engine rankings. - Target Audience: The target audience for the website is primarily general consumers. Ideal Skills and Experience: - Proven Track Record: Demonstrated track record in improving search engine rankings for websites. - SEO Expertise: Comprehensive knowledge of SEO techniques and best practices. - Audience Understanding: Ability to tailor SEO strategies to reach and engage general consumers effectively. Please bid if you believe you have the skills and experience to help me ach...
...Instagram, and Twitter pages. This will include creating and scheduling posts to keep my audience interested and coming back for more, increasing followers and being proactive with responses. We will provide all of the content. *Ad Campaigns* You will also be responsible for managing and creating our ad campaigns across these platforms. This includes monitoring performance, adjusting the campaigns to improve reach and engagement, and ensuring they are in line with the brand. *SEO and Analytics* A key part of this role is analyzing engagement and performance metrics. This data will be crucial in helping us understand what's working, what's not, and what we can adjust for better results. Experience in SEO would also be beneficial. The overall goal of this project is to...
I'm currently facing a few issues with my Linux-based server infrastructure. These issues include slow performance, frequent downtime, and security breaches. I am looking to prioritize speed optimization as a primary focus for improvement. Few Days Work - Maybe One Day. Key Tasks: - Identify bottlenecks that are causing slow ...medium-sized networks. - Excellent problem-solving skills and a proactive approach to network maintenance. - The ability to work independently and efficiently. - Good communication skills to report on network status and issues. Please reach out if you're confident in your abilities to help us strengthen and optimize our network infrastructure. We need your help today, budget $200. > Help us improve our existing infrastructure, find the bugs ...
I'm looking for an expert in network infrastructure to help with our small and simple Node (VPS) Server and Private Network. Key Responsibilities: - Securing our network: Identifying and implementing necessary security measures to ensure our network is safe and resistant to cyber attacks. - Monitoring our network: Setting up...medium-sized networks. - Excellent problem-solving skills and a proactive approach to network maintenance. - The ability to work independently and efficiently. - Good communication skills to report on network status and issues. Please reach out if you're confident in your abilities to help us strengthen and optimize our network infrastructure. We need your help today, budget $300. > Help us improve our existing infrastructure, find the bugs ...
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 ...
Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.
We are a payment company similar to Stripe, committed to providing secure and efficient payment solutions. After conducting market research, we have identified a series of keywords and marketing needs. Now, we are lookin...similar to Stripe, committed to providing secure and efficient payment solutions. After conducting market research, we have identified a series of keywords and marketing needs. Now, we are looking for an experienced SEO writer to help us write articles to improve our website's search ranking and increase traffic. Your responsibilities will be: - Conducting comprehensive keyword research and analysis to optimize our content and increase visibility - Implementing robust on-page optimization strategies - Focusing on content optimization to improve our ...
...the TIKTOK Operation course, and I am looking for several TIKTOK creators who can face the camera to imitate and shoot simple oral videos. You don't need to have a lot of social media experience, as long as you're willing to try. Your main responsibilities include: - Execute video shoot according to the script we provided. - You can also write your own script based on the content we provide or improve. To increase brand awareness, your content should be engaging and cause widespread sharing and liking on the platform. The ideal candidate should have: - Look comfortable in front of the camera. - Fluent in English or Spanish - We cater to the North American market, which would be great if you are American or Mexican Ability to work independently and under strict deadline...
...language content. We are seeking someone with excellent language skills, attention to detail, and a passion for delivering high-quality work. **Responsibilities:** - Proofreading and editing Spanish language content for grammar, punctuation, spelling, and style consistency. - Ensuring that all content adheres to linguistic standards and guidelines. - Providing feedback and suggestions to writers to improve the quality of their Spanish language content. - Collaborating with the content team to maintain consistency in tone, style, and messaging across all Spanish language materials. - Assisting with translation tasks as needed. **Requirements:** - Native Spanish speaker with fluency in written and spoken Spanish. - Proven experience in editing, proofreading, or a related field. -...
I'm in need of a professional with expertise in HubSpot and its integration with our app Primary Objectives: - Increase customer engagement - Streamline our onboarding process - Improve our lead generation process Key Tasks: - Develop and implement a strategy for CRM integration between HubSpot and Sheets - Optimise the use of HubSpot features with Sheets integration The ideal person for this task should have proven experience with HubSpot, excellent understanding of CRM systems, and an ability to streamline processes for optimal efficiency. Capability to troubleshoot and resolve any issues that may arise during the transition period is crucial.
I'm looking for a Shopify ASO expert to help me increase app downloads, improve app visibility in search results, and boost app ratings and reviews for my application aimed at businesses. Key responsibilities: - Optimizing app store presence - Enhancing app visibility on Shopify - Implementing strategies to drive more downloads - Encouraging and managing app reviews and ratings Your application should include: - Your relevant past work in ASO, particularly on Shopify - Your experience in increasing app downloads, improving visibility, and boosting ratings - Any unique strategies or insights you can bring to our project The target audience for the app are businesses, so experience in marketing towards B2B would be beneficial.
...The primary focus will be on boosting the site's performance and ensuring a more seamless user experience. Key Project Goals: - Optimize loading speed: Currently, my website has a moderate loading speed, which is not ideal for ensuring a smooth and efficient user experience. I need the freelancer to improve this aspect significantly. - Enhance internal pages: I'm also looking for the revamping of internal pages. This includes making them more visually appealing and user-friendly. - Improve internal links: Moreover, I need someone who can enhance the internal navigation and links. This is crucial for ensuring visitors can easily find what they are looking for and to increase overall website usability. Ideal Skills and Experience: - Proficiency in Shopify: It&...
I'm currently seeking a well-rounded expert to take on several crucial tasks, primarily focusing on SEO enhancements and graphic design modifications for my Wix website, performed on both desktop and mobile platforms. Below is a summary of the tasks I expect to be tackled: SEO: • Keyword optimization - Maximize the usage of relevant and high-ranking keywords to improve my website's visibility and ranking. • Backlink building - Develop genuine and high-quality backlinks that will increase my website's credibility and boost its search engine ranking. • Content optimization - Enhance my website's overall content to make it more SEO-friendly, thereby increasing its ranking and user engagement. Wix Design: With respect to graphic design improvem...
I'm looking for an experienced designer to completely revamp my mobile and web applications. The redesign will cover all aspects including the UI, UX, and overall structure. Key Responsibilities: - Redesign the User Interface (UI) to improve the visual appeal, and tie it in with the intended brand image. - Enhance the User Experience (UX) by ensuring the applications are intuitive, user-friendly and engaging. - Rethink the overall Layout and Structure of the applications to improve usability and functionality. Design Preferences: - The design should be Modern and Minimalist. - Clean and Professional aesthetic is preferred. Required Skills: - Proven experience in designing mobile and web applications, with an emphasis on UI/UX and overall structure. - Proficiency in mo...
...payment solutions. -Nice to have: experience in the medical business. Duties of the role -Architect, discuss, design, implement systems within the Scratch ecosystem. From simple (but important) sign-up forms to complex back-offices to end-user facing forms to multi-service signal-based event integration. -Help Scratch develop its test infrastructure and write tests to improve application test coverage. -Participate in all technical and product discussions together with the team. -Work with high quality and business sustainability in mind. -Developing front end and back end applications. -Designing and maintaining database schemas. -Ensuring responsiveness of applications. -Working alongside graphic designer...
