Excel vba tutorial expertงาน
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)
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
สวัสดีคุณ Facebook Marketing Expert ฉันสนใจประวัติของคุณและต้องการเสนอโปรเจคให้คุณ เราสามารถหารือเกี่ยวกับรายละเอียดต่างๆ ผ่านการสนทนาได้
วาดภาพจำลองโคมไฟของบริษัท ตามแบบ 2d ที่เป็น outline พร้อมรายละเอียดสัดส่วน และขนาดให้พร้อม อยากให้เห็น texture และรายละเอียดของงานให้ได้เหมือนของจริงมากที่สุด เช่น เหล็ก นอต พลาสติด สายไฟ อลูมิเนียม เเสงไฟ เงา อาจจะต้องมีหลายมุม ทั้งแขวน ตั้ง วาง จำนวนงาน : 7 แบบ (แต่ละแบบมีอย่างน้อย 3 มุม) รวม 21 รูป
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
looking for voice talent for a 2-minute tutorial video. Script is in Thai. must sound young and energetic. please use the lines below to send sample เดบิตออนไลน์ช่วยให้คุณสามารถทำการโอนเงินเรียลไทม์ง่ายจากบัญชีธนาคารออนไลน์ขของคุณเข้ามายังบัญชีโบด็อกอย่างไรก็ตามหากคุณออนมือถือหรือที่บ้านทางคอมพิวเตอร์มันเป็นวิธีที่เร็วที่สุดสำหรับการโอนเข้าบัญชีโบด็อกของคุณ Thanks!
I need a proficient freelancer to help convert my Excel files, containing both numerical and textual data, into Word documents. The aim of this conversion is to ease the process of creating reports. The data should be precisely formatted into tables in the Word documents for a cleaner presentation. The ideal candidate would require: - Excellent skills in Microsoft Excel and Word. - Proficiency in data conversion and formatting. - Attention to detail to maintain data integrity. - High regard for timeliness and efficiency. Understanding the importance of report creation in business communication, this work must be meticulously done, reflecting professionalism in every converted document.
I am seeking an experienced WordPress developer to help finalize the setup of my travel agency website. I have purchased the Travolo theme and need assistance with installation, configuration, and customization to ensure the site is travel-agent friendly. Key tasks include theme installation, importing demo content, setting up essential plugins (like booking systems), and customizing the site to match my brand's aesthetics. Additionally, I need to integrate functionality that supports booking, customer management, and inquiry forms.
I'm in need of an experienced data entry specialist to extract and populate the data from a PDF document into an Excel spreadsheet. I'm keen on having one cell for each data point, so only bid if you're confident about achieving this. This project also requires excellent attention to detail as it involves preserving symbols and special characters from the PDF into the Excel file. Key Requirements: - Excellent data entry skills - Experience with Excel and PDF documents - Ability to accurately preserve symbols and special characters In case of unexpected data or errors found in the PDF, kindly exclude it from the Excel file altogether. I'm looking for a professional with a keen eye for spotting such inconsistencies to ensure data integrity...
...for an experienced data entry professional to help me in typing less than 10 pages from a text document to Excel. This project involves text-based data entry. Here’s what I am looking for in the ideal candidate: - Proficient with Excel and able to input data with high accuracy - Experienced in copy-typing from PDF or other formats to Excel - Fast typing speed with a keen eye for details Ultimately, I require a reliable individual that can work efficiently within a set timeline. Your responsibilities will include: - Transferring data from the document into Excel accurately - Proofreading data entries to ensure no mistakes were made Please ensure you bring a good understanding of Excel functionalities. The text to be copied is less than 10 pag...
I need an expert in financial analysis to evaluate the financial performance of a project centered around HDFC Bank. Key Requirements: - Analyze Share Value: The primary task involves analyzing the share value of the project. - Provide Recommendations: You will be expected to provide clear and justified recommendations of whether to buy, sell, or hold the share. - Draw Conclusions: Based on your analysis and recommendations, a conclusive statement on the project's financial performance is crucial. Ideal Skills: - Proven Experience: A strong background in financial analysis, particularly in evaluating financial performance. - Proficiency in HDFC Bank: Prior experience in analyzing the financials of HDFC Bank or similar institutions would be a plus. - Data Interpretation: The ...
I'm looking for a professional in the United States, specialised in tax and insurance write-off. particularly in the retail sector. Your focus will be on securing monetary reimbursement from customer returns and damages. You'll help optimize business operations by applying your expert knowledge in this field. Key Requirements: - Deep understanding of US tax law and insurance write-off regulations. - Proven experience in claiming refunds for various business expenses in the retail industry. - Robust knowledge about customer returns, damaged goods and their impact on tax and insurance claims. - Ability to educate my team on the opportunities and legalities surrounding these write-offs. Your expertise in this area will highly contribute to improving the financial health o...
I am seeking an experienced HTML/CSS/JQUERY/PHP developer with at least 4 years of experience to join me on a project. for agency Website/portfolio. Key Skills: - Proficient in HTML and CSS, with experience in responsive design, CSS animations, and the Bootstrap framework. - Strong command of JQUERY and PHP. As part of the application process, I'd like to see: - The number of years you have worked in this field. - Examples of your previous projects showcasing your expertise in the mentioned technologies. Please only apply if you meet these requirements and have a portfolio that demonstrates your proficiency in these areas. Experience is key, so make sure to highlight this in your application. Looking forward to seeing your applications.
I'm in need of a skilled PPC specialist with expertise in Google Ads. The main objective of our PPC campaign is to generate quality leads targeting Small Business Owners. Key Resp...skilled PPC specialist with expertise in Google Ads. The main objective of our PPC campaign is to generate quality leads targeting Small Business Owners. Key Responsibilities: - Set up, manage, and optimize our PPC campaigns on Google Ads. - Develop strategies to improve lead generation targeting Small Business Owners. - Track KPIs to assess performance and pinpoint issues. Ideal Skills: - Expert knowledge in Google Ads. - Proven experience in lead conversion. - Understanding of Small Business Market. Proven track record in similar projects is a significant advantage. More details will be s...
I'm seeking a skilled social media pro to boost our brand presence in the bridal jewelry market. - Platforms: Your primary focus will be Instagram, Facebook and Pinterest. - Responsibilities: A mix of social media management and advertising. - Primary Goal: To significantly increase our brand awareness in the bridal jewelry niche. This role requires someone who is well-versed in the dynamics of these platforms and their respective algorithms. Experience in the jewelry or bridal market is a huge plus. Your primary KPI will be how well you can grow our brand's visibility and reputation online. If you can deliver a comprehensive social media strategy that significantly increases our brand awareness, please bid.
I'm seeking a talented designer to create a distinctive and functional outfit for women's competitive tennis. SINGLET AND SKIRT Key Points: - The outfit will consist of a singlet and skirt. The specific fabric for the outfit is yet to be decided. - It shoul...appealing, suitable for the competitive tennis environment. Requirements: - Strong design skills, particularly in sportswear. - Experience in creating custom clothing for sports. - Knowledge of functional and performance-enhancing fabrics. - A keen eye for fashion and current trends in sportswear. Your task is to develop a unique and high-performing outfit that will help a female tennis player excel in competitive play. The successful design should not only enhance performance but also make a distinct fashion sta...
I need a professional familiar with Pointy, as I need help with my Google Local advertising. I have integrated my inventory from my point of sale software to the Google Merchant Center through Pointy. I understand the potential of this platform in driving more foot traffic to my physical store and boosting my sales, but I lack the knowledge and experience to make the most out of it. Key Aspects: - Pointy and Google Local Expertise: I need someone who understands how Pointy works and is able to navigate the Google Local platform effectively. - Local Audience Targeting: Although I skipped a question regarding my target audience, I'm particularly interested in attracting local customers through this advertising channel. - Urgency: I need this project completed ASAP. Ideal Skills a...
I need a proficient SEO expert to rank my live escort site amongst the top 5 search engines for 8 to 10 specific keywords. This role requires the following: - Proficient understanding and application of SEO tactics - Experience in ranking websites for specific keywords - Ability to operate within the guidelines of search engines Key Tasks: - Improve the site's ranking for the keywords 'Delhi escorts', 'escort service in Delhi', 'Delhi escort service', 'Delhi escort' and 4 to 6 more keywords. - Recommend and implement any necessary changes to website content or design to aid ranking. - Regular reporting on site ranking for those keywords. Applicants with previous experience in SEO for escort websites are preferred, however, it is not a...
I'm looking for a skilled Webflow designer, ideally with Figma experience, to redesign and implement our website. We’re seeking a revamp of the overall design, layout, and navigation. This project involves building a Figma design template/wireframe in Webflow for all relevant products. Key requirements include: - Redesigning the overall design and layout to enhance visual appeal. - Improving navigation and user experience, with a focus on simplifying menu navigation. - Updating the color scheme and fonts to align with our existing brand colors and fonts. - Rearranging content sections and incorporating more visual elements like images and videos to make the site more engaging. Ideal skills for this project would include: - Proficiency in Webflow for website redesign and implem...
Job Overview: You will manage product listings on our e-commerce site to ensure accuracy, clarity, and organization. Responsibilities: - Re-categorize products to enhance logical grouping. - Update and verify product images to reflect the actual items. - Adjust product prices as necessary based on internal guidelines. - Revise product descriptions to ensure they are clear and accurate. - Conduct periodic inventory reviews to ensure availability matches our records. Please let us know if you're interested.
Seeking experienced PHP developer to modify our site, to suit our needs. There are several modifations that need done. To qualify: You MUST be ONLY working on our project. If you have other projects going on at the same time then this is not the right fit. We want ONE individual to make changes and NOT an agency. You must be experienced with software by Botble (this one is farmart). It is written with Laravel in plug in format, so you must have experience with this type of code structure and you must write all new code in this format. Once awarded you will be given task. Milestone for the first days tasks will be activated, and payment will be released once the days tasks are live on our site verified to be working. You must complete that task within a timely manner in order to be hir...
I am seeking an AI coder for the development of a full-featured online ordering platform that emphasizes on streamlining orders and deliveries. Primarily, the platform should be designed to : - Excel on both desktop and mobile devices ensuring a smooth customer experience on all interfaces. - Prioritize on real-time scheduling functionality that optimizes order fulfilment with exemplary efficiency. -Connect to Service Monster API -Use as payment gateway. Ideal candidates should possess profound expertise in AI coding specifically in enhancing online platform functionalities. Experience with building real-time scheduling systems is critical for this project. Furthermore, a strong background in mobile and desktop compatibility is essential. The aim is to create an ordering
I'm in need of a talented individual who can produce a high-quality, engaging 1-3 minute educational video in 2D cartoon style. This project is specifically for an educational purpose that should resonate well with a diverse audience in an appealing manner. The ideal candidate for the job would have: - A strong portfolio of previous 2D cartoon style animation work. - Proven ability to communicate complex information in an engaging, visual manner. - Proficiency with modern animation tools. - Keen attention to detail and creative thinking skills. As a key part of this job will involve conceptualising and creating a video that can communicate effectively, storytelling skills are essential. Applicants should be ready to demonstrate their ability to use animation to engage viewers and ...
I have an android app and it's source code I need the following done 1. Some video file types are not loading. 2. I need the aspect ratio to be full screen by default I need those issues fixed and full written instructions what was done to fix the problem. Must be an expert in Android Studio
I have an android app and it's source code I need the following done 1. Some video file types are not loading. 2. I need the aspect ratio to be full screen by default I need those issues fixed and full written instructions what was done to fix the problem. Must be an expert in Android Studio
I am seeking an experienced RPA Developer to automate tasks relating to Excel and Web interaction. Basically you will take 1 data from 1 excel cell (example cell d5) with that data you will create an hyperlink you will open a broswer tab with that link analize the result of the web programming 1 or 2 IF statements Proceed to generate the unatended "clicks" in that web close the tab iterate with the next excel cell (in this case d6) repeat the web process Until Excel's data EOF Everything configurable via external TXT file - name of the excel file - starting cell - basic hyperlink - how to compose the final hyperlink - the IFs statements - the sequence of clicks for each IF condition Immediate offers after posting will be directly ignored as ...
...candidate will be responsible for inputting, updating, and maintaining data accurately and efficiently. - Email and calendar management: Handling and organizing emails and managing calendars, scheduling appointments and meetings. - Customer service and support: Providing excellent customer service, addressing queries and concerns. Software and Tools: - Microsoft Office Suite: Proficiency in Word, Excel, and PowerPoint is required. - Vettrak Student Management System: Experience with this software is beneficial but not mandatory. - Dropbox: Familiarity and experience with file management on Dropbox. - Facebook and Instagram. Ideal Skills and Experience: - Previous experience in administration, data entry, and customer service roles. - Intermediate proficiency in Microsoft Office...
I am in need of a skilled bookkeeping specialist proficient in Tally data entry and Excel data entry and formatting. Key Tasks: - Entering less than 100 entries per week into Tally. - Formatting and managing Excel data. The work will be ongoing, with updates and reports required weekly. Ideal Candidate: - Must possess extensive experience with Tally and Excel. - Proficiency in bookkeeping and data entry. - Ability to handle tasks efficiently and with a high degree of accuracy. - Understanding of financial reports and data reconciliation. The ideal freelancer will be able to deliver clean, well-organized data, and provide timely reports. If you have the skills and experience required, please get in touch.
I have a legitimate need to hack and mirror a person's phone for investigative purposes. I need this done as quickly as possible. Key project requirements: - The target device is an Samsung, running the latest android version. - The hacking and mirroring process should be discreet and undetectable by the phone's owner. - I need a report on the target device's activities, including text messages, calls, social media interactions, and GPS locations and apps. Ideal freelancer: - Proven experience in phone hacking and mirroring. - Sound understanding of iOS and the latest smartphone technologies. - Ability to deliver results quickly and discreetly. - A good track record of maintaining client confidentiality. Please include examples of your past work in your application.
I am looking for someone proficient in typing to convert content from a 30 page PDF into Word and Excel documents. The majority of the content will go in Word with a few items to be transcribed into Excel. Requirements: - High typing accuracy and speed - Familiarity with Word and Excel formatting Specific instructions: - For Word, the content should be formatted in Calibri 12 point font and single spaced. - For Excel, maintain one row per entry for optimal readability. Ideal candidates should have prior experience in similar data entry tasks. Familiarity with PDF conversion tools, text formatting, and spreadsheet management would be a plus.
I am in need of an expert cloud architect skilled in AWS . Your primary responsibilities will include: Teaching me Landing Zones Mentoring Cloud architect Regular consultation in shaping up the cloud architecture as we evolve as a business cost vs performance vs business needs Solution architect Please note: - I am seeking an individual, not a company. Only industry professionals need apply. - You should be able to provide a practical demonstration of your skills in these areas. - Your proficiency with cloud Architect and Cloud operations will be a critical factor in the selection process. NOTE: STRICTLY NO BEGINNERS OR RANDOM WEB DEVELOPERS OR EASY MONEY ATTITUDE PERSONALITIES DO NOT APPLY FOR THIS If you meet these criteria, please apply with details of your relevant exp...
...year I try to do something to crack everyone up and this year I am trying to out do myself. This year I was hoping to use OBS & FaceSwap software to to make me look like other famous people on the video screen. Some of the employees can't make it so I want it to work on Zoom because that will be how they will be attending. Their is a tutorial below that describes exactly what I want to do. As explained in the tutorial I like the idea of being able to press 1 to be Biden, 2 Trump, 3 Arnold Schwarzenegger, and so on. I would like to be able to talk and change my facial expressions etc and I want the video experience to be smooth and life-like. I would need it delivered within a week. I don't mind paying a fair wage for this but I want us to be reasonabl...
