Advanced excel vba courseงาน
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 ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I seek an experienced stop-motion animator to create a course animation that'd run for approximately 1 hour 48 minutes. • Animation Style: Your forte should be stop-motion animation. Your creativity and sense of timing are key for this project. • Preferred Style: Although I skipped a question concerning 3D style, if you're skilled in that area, it may boost the final outcome. • Project Length: The completed animation should span around 1:48 minutes, ensuring that the course's key points are covered creatively and engagingly. Therefore, if you have proven experience in stop-motion animation and can deliver high-quality work within a specified timeline, you're just the candidate I'm looking for. Proven ability to adhere to project length re...
I need an experienced social media video editor and content creator to produce short videos for a social media advertisement. The advertisement is for an upcoming Alumni Reunion/Networking event. The v...Proficient in video editing software (e.g., Adobe Premiere Pro, Final Cut Pro) - Experienced in creating content for various social media platforms, particularly Facebook, TikTok, and YouTube - Highly creative with a strong visual aesthetic - Knowledge of copyright laws and usage of royalty-free music - Strong communication skills to understand and execute my vision If this sounds like a project you'd excel at, I'd love to see some examples of your previous work. I will provide longer version videos of past events. You'll need to use shorter clips from the long video...
...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...
... It's crucial that the tool supports this language for seamless integration with our existing systems and infrastructure. - Chatbot Functionalities: The tool needs to focus on "Learning and Adaptation." This is critical to ensure our chatbots continuously improve their responses and overall performance based on real-time customer interactions. - Chatbot Customization: I'm looking for an "Advanced" level of chatbot appearance customization. This includes a fully customizable UI, allowing us to align the chatbots with our brand's aesthetics and maintain a consistent user experience. Ideal Skills and Experience: - Proficiency in JavaScript/ reactJS and NodeJS is a must. - Prior experience in developing AI tools for chatbot creation and train...
...CISSP certified instructor with an advanced level of knowledge. The ideal candidate should be able to deliver these classes in an in-person format. Key Training Areas: - Security and Risk Management - Asset Security - Security Architecture and Engineering I need someone who can provide thorough explanations and practical examples of these topics. Your role will be to break down complex concepts into understandable parts for the students. This means ensuring the content is clear, concise, and engaging. Ideal Skills and Experience: - Advanced CISSP certification - Experience in in-person training - Strong communication and presentation skills - Ability to simplify complex ideas - Understanding of adult learning principles Please only apply if you are an Advanced ...
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 simulations. Key Responsibilities: - Provide advanced expertise in Protein structure prediction, Molecular simulations, Coarse-grain modeling - Support in understanding complex concepts - Assist in practical implementation and problem-solving Ideal Experience and Skills: - PhD in Computational Chemistry or Biophysics - 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...
...are several essential tasks that need to be completed in the process: - Advanced Inventory Management: Setting up a comprehensive inventory management system that allows for efficient tracking, control, and optimization. - Odoo Website Customization: I'm looking for customization of the Odoo website to better reflect and serve my business needs. - POS Customization: Tailoring the point-of-sale system within Odoo to ensure it's user-friendly, efficient and meets specific business requirements. - Multi-branch Capabilities: Implementing the necessary features to support multi-branch operations. The successful bidder will have: - Extensive experience in Odoo (OpenERP) migration projects. - Proven track record in advanced inventory management and POS customizations....
...and landing page interactions. Deliverables: - A fully functional AI model deployable within the API and UI environment. - Documentation detailing the model’s architecture, data flow, and integration points. - A user guide for navigating the model’s interface and understanding output data. Expertise Required: - Proven experience in AI/ML, particularly in NLP and predictive analytics. - Of course, Google Ads expertise (supposing to have anyone in your team that can do this part) - Strong background in data integration and API management. - Experience with Google Ads API and Google Search Console is highly advantageous. - Ability to work with cross-functional teams and manage a project from conception to execution. Proposal Submission: - Detailed approach to th...
I need an advanced web application developed. This application will include complex user interactions and data processing. Technical requirements include: - Expertise in Angular for frontend development - Knowledge of Spring Boot for application framework operations - Proficiency in Java Persistence API (JPA) for managing database operations Ideal candidates should have proven track record in building complex, dynamic and interactive web applications using these frameworks. Understanding best practices for each of these frameworks is highly desirable.
...explaining the process by which you calculated these statistics. Calculate the mean, median, mode, and standard deviation of the stock volume. Put in table format for easy review. Write a sentence explaining the process by which you calculated these statistics. Ideal freelancers for this project would be those experienced in statistical analysis and data visualization. Skills in using tools like Excel. If this sounds like your kind of project, get in touch and showcase your skills. The information to use is attached...
Hi everyone, I need a mockup for a course, here are details of the project: Name of the course: Máster en VSL About: it's a course where I teach how to make video sales letters for selling High Ticket programs. I will attach the mockup that I made by myself. And other mockup that I like. You will find also my brand colors. I will also attach the fotos I used in my mockup in case you wanna use them, although it's not necessary.
I need someone to help with offline data entry. The task involves entering less than 1000 entries into an Excel spreadsheet. Accuracy is key as the data will be used for business analysis. Ideal Skills and Experience: - Proficiency in offline data entry - Advanced Excel skills - Ability to maintain high level of accuracy - Previous experience with similar tasks is a plus
I need a high-quality 3D rendering specialist to create a detailed architectural visualization of an urban setting for me. This project requires a high level of skill and attention to detail. Key Points: - Focus: The primary focus of the rendering will be showcasing the architectural design specifically in an urban environment. - Level of Detail: I require advanced level of detail in the 3D rendering including realistic lighting and landscaping elements. - Experience: It would be beneficial if you have prior experience in architectural visualization and urban settings. - Software: Proficiency in software such as 3ds Max, V-Ray, SketchUp, or similar is preferred. Your task will be to bring my concept to life and make it engaging and realistic. The final output should be suitable f...
I'm in need of an experienced...- Proficiency in API integration for seamless data transfer and communication - Prior experience in designing and implementing CRM front-end and back-end relations The most crucial aspect of this project for me is the user interface design and experience. I want a website that not only functions efficiently, but also looks and feels intuitive for users. I'm looking for someone who: - Is an advanced-level developer - Has a strong background in CRM development - Can demonstrate a portfolio of high-quality, custom job - Has experience in Java, YAML, database scripting, API integration, and front-end/back-end relationship management. If you meet these criteria and are up for the challenge of creating a top-tier CRM database website, I'...
...ratings. Include multimedia integration for a richer insight. 3. Job Posting and Application Management -Customizable Job Listings: Design forms with fields for job title, description, skills required, employment type, and location, including special tags for urgency. -Application Process: Interface for direct applications and a dashboard for candidates to track their application status. -Advanced Filtering and Recommender System: Search interfaces that allow dynamic filtering and display the integration of a machine learning-based recommender system. 4. Recruitment Process Management -Interview Scheduling: Calendar integration to show available time slots and scheduled interviews. -Automated Notifications: Design for email and SMS notifications setup. -In-Platform Messag...
As the core of this project, I need a highly skilled DevOps Engineer who is proficient in both Amazon Web Services (AWS) and Microsoft Azure. Your primary tasks would be: - Infrastructure Provisioning on both AWS and Azure. - Setup Continuous Integration/Continuous Deployment (CI/CD) pipelines. - Implement robust monitoring and logging systems. - Additional expertise in Kubernetes, Docker, and Ansible would be an immense advantage. The key aspect of this role is the ability to fully automate these tasks. Your talent in automation should position you at the forefront of modern DevOps best practices. I'm looking forward to working hand in hand with a driven, quality-focused, and experienced DevOps engineer on these essential operations.
Geo-Target Report for Reston National Golf Course Geographic Distribution of Customers Local Area Analysis: Breakdown of customers within a 10-mile radius. Analysis of nearby neighborhoods and 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 c...
I'm looking for a professional and creative PowerPoint expert who can convert my content in...The presentation will highlight market parameters including Competition, Consumer Behavior, and Market Trends. - It's crucial that you convey the information in a captivating and understandable manner, aiming to pitch our sales strategies effectively. Ideal Skills: - Proven experience in designing PowerPoint presentations, preferably for the sales/marketing sector. - Proficiency in utilizing advanced PowerPoint tools and graphics. - Strong understanding of effective presentation techniques for sales/marketing. - Experience with successfully communicating complex market analysis. Please showcase your previous related work in your bid. Looking forward to an attractive and infor...
I'm looking for someone with strong data gathering skills who can create a comprehensive Excel spreadsheet. The spreadsheet must contain a list of all Australian suburbs along with their corresponding Local Government Areas (LGA). The essential points to be kept in mind are: • The list should be sorted by council areas for easy navigation. • Only the name of the suburbs and their corresponding council areas are required. No additional components such as population or region data are necessary. This project might require advanced web searching capabilities and attention to detail to ensure accuracy of the compiled list. Experience in data extraction is highly desirable.
I need someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase order, I should be able to add ...
I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.
As a small business owner seeking to enhance my Go High-Level (GHL) membership courses and sales pages with an AI chatbot, I'm looking for a specialist who can achieve the following: - Answer Customer Queries: The AI chatbot should be able to address queries from potential customers about the courses and sales offerings. - Provide Course Recommendations: It should be able to suggest relevant courses based on users' needs and interests. - Collect User Feedback: I'd like the chatbot to gather feedback from users, which can be valuable for improving the offerings. I'm particularly interested in integrating the AI chatbot in a text-based format. Key Skills: - Proficiency in AI Chatbot Development: Extensive experience in developing, implementing, and integrating ...
I'm in need of a skilled video editor who can take my raw footage and transform it into engaging content for various social media platforms. Key Responsibilities: - Implement advanced editing techniques: Color correction, visual effects, etc. - Tailor video content to suit Instagram, YouTube, and TikTok. - Ensure content is engaging and aligns with the intended purpose of each platform. Ideal Candidate: - Proficient with video editing software and advanced editing techniques. - Prior experience creating content for social media platforms. - Able to work efficiently and meet deadlines. - Good communication skills to understand and execute my vision. Looking forward to seeing your portfolio and discussing how you can help me elevate my social media presence through pr...
I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample
I am looking for someone skilled in photo editing to eliminate certain individuals from my group photos. This task requires a careful and thoughtful touch to ensure that the final product looks authentic and unaffected. The People to be Removed: - Ex-partners - Ex-friends The Photos: - Group photos Ideal skills and experience include: - Advanced proficiency in photo editing software - Attention to detail - Experience with removing people from complex images - Demonstrated ability to maintain the integrity of photos after editing.
I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines
I am searching for a skilled video editor to create engaging content for my YouTube channel. The ideal candidate will have experience in a variety of editing styles, including documentary, podcast, cinematic, tutorials, vlogs, and montages. Requirements: - Strong command of advanced editing techniques - Ability to incorporate a range of styles seamlessly - Proficiency in color grading and audio enhancement - Experience with YouTube content creation Please provide examples of your previous work that demonstrate your proficiency in these areas. Your creativity and ability to engage audiences will be key in this project.
I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.
I need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attention to detail to ensure accurate transfer of all informati...
I need to modify a website and create additional pages. You have experience and knowledge in it, and of course it will be compatible with all screens and different browsers.
