Excel vba learning with projectงาน
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 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
สร้าง Website storytelling visualization อธิบายการทำงานของ machine learning ลักษณะประมาณนี้ ร่วมกับ
...สามารถ 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)
โครงการนี้จะ จัดพัฒนาและทำระบบ โจทย์ปัญหา และ ข้อสอบออนไลน์และจัดเก็บฐานข้อมูล ที่เชื่อมโยงกันระหว่างครูและนักเรียน (จะเป็นรูปแบบ outsource e-learning service ให้กับโรงเรียนต่างๆ) นักเรียนจะสามารถ ทำแบบฝึกหัดของแต่ละบทเรียน และ ข้อสอบจำลองที่ไม่ซ้ำกันได้ไม่จำกัดครั้ง โดย สามารถเลือกบทเรียนที่ต้องการทดสอบและระยะเวลาในข้อสอบจำลองได้ เพื่อให้ทุกระดับชั้นได้ประโยชน์ ส่วนครูจะสามารถรู้ได้จากโจทย์ต่างๆที่นักเรียนทำผ่านระบบ ว่านักเรียนยังต้องพัฒนาในเรื่องใด
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
Windows อื่นๆ หรือไม่แน่ใจ interactive e-learning and game.
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
Windows อื่นๆ หรือไม่แน่ใจ interactive e-learning and game.
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I am seeking an expert in machine learning and computer vision who can craft an advanced object detection algorithm. This algorithm will be employed in outdoor settings and must have the capability to accurately identify vehicles, animals, and pedestrians. Essential Skills and Experience: - Expertise in Machine Learning and Computer Vision - Understanding of outdoor environments and their varied conditions - Prior experience in developing object detection algorithms - Familiarity with vehicles, animals, and pedestrian detection The goal is to devise an algorithm that can track and distinguish between multiple objects in outdoor scenes with different weather, light, and visibility conditions. It should perform reliably under these compounded factors.
Im looking to have a Solana ping bot with the ability to detect and attempt to filter out potential scams based on machine learning software. Ensuring that daily 10-100x calls are made effectively. Key Requirements: - AI & Machine Learning Proficiency: The ideal candidate will be well-versed in AI and machine learning technologies, able to design a bot that can learn and adapt to new scamming tactics. - Solana Ecosystem Expertise: Strong understanding of Solana and its projects is crucial to successfully identify potential scams. - Telegram Integration: The bot should be designed to work seamlessly within the Telegram app. I'm looking for an active developer who can work alongside me in this exciting new venture. Please get in touch for further discus...
I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.
I'm in need of a freelancer to assist with labeling text tweets by topic (to aid in machine learning research). Key Requirements: - Labeling 1,000 tweets as to whether they are about the topic sustainability - Must be labeled by hand (no machine learning or AI) by a native English speaker Task: -Open the attached spreadsheet -Read the FULL TEXT of each tweet. Also read the brand handle and sector for reference. Make sure to pay attention to any hashtags included. -You do not need to open any URLs. Make your judgment based only on the text. -If the tweet is about sustainability, enter "1" in column E. If it is not about sustainability, enter "0" in column E. -Note that "sustainability" is a broad topic -- it is often a judgment cal...
I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and efficient sol...
Nous recherchons un développeur full-stack expérimenté pour créer une plateforme de e-learning dédiée à la préparation exhaustive du TAGE MAGE. Ce test est un examen standardisé, composé de divers sous-tests, utilisé pour l'évaluation des compétences managériales et de logique. Objectifs et Fonctionnalités Principales : Développement d'une Landing Page intégrant vidéo introductive, options d'inscription et de connexion. Intégration de paiement sécurisée avec STRIPE, nécessitant la création de comptes utilisateurs. Structure modulaire du site pour les cours, entraînements et tests blancs, avec redirecti...
I'm currently seeking a highly skilled and experienced tutor who is capable of teaching intermediate mathematics to teenagers via engaging video lessons. Key Responsibilities: - Create easy-to-understand, engaging video lessons a...to adjust teaching style to keep the interest and attention of teenagers during lessons Ideal Skills and Experience: - A background in teaching or tutoring, specializing in mathematics - Excellent communication skills, particularly on video - Comfortable with digital tools and technology - Understanding of teenage learning requirements and challenges - Ideally, someone who can make math exciting and less intimidating for learners. Please consider how your style and experience can contribute to keeping teenagers engaged while learning...
I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with...
...personalized, in-depth insights catered to my capacities, skills, and learning speed. We will explore challenges and complex concepts together. Patience and exceptional communication are crucial. - Expertise in Java and Python: You must demonstrate a solid understanding and practical application of these languages in the industry. Exit profiles such as the development of complex systems, application in advanced artificial intelligence, or extensive backend management would be ideal. - Advanced Level Programming: I need a tutor who can help me comprehend and implement advanced aspects of programming beyond basic syntax and concepts. Some topics of interest include multi-threading, database connectivity, advanced algorithms, machine learning, and AI. Please provide proof...
I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19....
I need a website designed and developed that will serve as a platform for my healthcare company. The site will have a three-pronged approach to ...speak to professionals who may want to collaborate or refer patients to us. - **General Public**: I need the site to be informative and engaging for people who might not be in the healthcare field but are interested in learning about our work. I have a preference for a clean and modern design for this website. The design should be professional yet inviting, and should reflect the high standards of my company. I am looking for a web developer with experience in healthcare website design and development, and who can bring a creative yet professional touch to the site. Experience with user-friendly interfaces and SEO optim...
Somos pioneros en la creación de experiencias de aprendizaje digital que transforman la forma en que las empresas desarrollan el talento de sus equipos. Combinamos metodologías de vanguardia, tecnologías inmersivas y diseño instruccional experto para crear cursos e-learning personalizados que inspiran, motivan y generan resultados tangibles. Nuestro enfoque se basa en: Innovación: Exploramos constantemente nuevas herramientas y tendencias para diseñar soluciones de aprendizaje que superen las expectativas. Interactividad: Creamos experiencias de aprendizaje participativas que fomentan la colaboración, el pensamiento crítico y la resolución de problemas. Impacto: Medimos el éxito de nuestros cursos a travé...
NOTE: PLEASE MESSAGE ME IF YOU ARE AN EXPERT AND INTERSTED IN THE PROJECT. I'm currently seeking an expert in AI/Machine Learning, particularly in Natural Language Processing (NLP), who can assist in developing a solution using Python, Vector DB, Neo4j and GPT API. The main goal of this project is to create a sophisticated NLP solution that can work with text data such as documents and emails. Key Requirements: - Strong background in AI/Machine Learning, specifically in NLP. - Experience with Python, Vector DB, Neo4j and GPT API. - Ability to deploy the solution on a Local Server. Your tasks will involve: - Developing an AI/Machine Learning solution using the specified tools. - Ensuring the solution is optimized for processing tex...
Request details FOR EXPERTS WITH EXTENSIVE EXPERIENCE IN THE FIELD ONLY Objective: Scoring Algorithm for evaluating potential investments Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing values, normalization, outliers) • Implementation methods for feature selection (e.g. correlation Analysis, feature importance, etc.) • Identify and run different algorithms (e.g., logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performance metrics (e.g., accu...
...Basic Concepts and Architecture: I need to understand the foundational principles of Oracle Service Bus (OSB). This includes how it works, its key components, and its role in service-oriented architecture. - Service Development and Deployment: I'm interested in learning how to develop services on OSB and deploy them effectively. This includes hands-on exercises and practical examples to reinforce the learning. - Troubleshooting and Optimization: I want to be able to troubleshoot any potential issues that may arise when working with OSB. Additionally, I'd like to understand how to optimize OSB applications for performance and scalability. The ideal candidate should have: - A solid understanding of Oracle Service Bus (OSB) - Previous experience in teach...
I am in need of a research professional to conduct an in-depth study into nursery and early child learning centers. Specific areas of focus should include: - Curriculum and teaching methods for children aged 2 to 4 years. - Parent involvement and communication strategies used in these settings. The purpose of this research is to identify current best practices in these areas. Given this, the ideal candidate will have experience in education research, specifically within early childhood settings. Knowledge in curriculum design, early childhood development, and parent-teacher engagement strategies are a crucial requirements for the task.
I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.
I'm seeking an AI developer to create an AI Resume Creator. The primary focus of this project is to take a normal CV / Resume and format it into our company format. It's quite a simple process, populated some fields, removing personal details and then coping the rest of the text into our format. We would want to be able for the AI to use the template we create and it check it each time to make sure we havent updated anything. We would drop the resume / CV into one folder then it would be added to another folder formatted. Ideal Skills and Experience: - Strong background in AI and Machine Learning - Experience in NLP and chatbot development - Proficiency in creating customizable sections for user-friendly interfaces - Understanding of how to analyze user's s...
...interface that integrates a machine learning model. The primary goal of this application will be to evaluate student applications in real-time. Key Features: - Real-time evaluation feedback: The application should provide instant feedback on student applications, based on the integrated machine learning model. - User authentication: The application should include a secure user authentication system to ensure only authorized users can access and use it. - Data visualization: The application should have data visualization capabilities to help users understand the evaluation process and results better. Integration: - The application will need to integrate with existing systems or databases. The specifics of this integration can be discussed in further detail with...
I need a machine learning model developed in Python. This model should be able to evaluate prospective student applications by comparing them to historical data sets. The goal is to classify and sort the new applicants efficiently. Key Requirements: - Develop a classification-based machine learning model in Python - Understand and work with historical data sets to evaluate new student applications - Deploy the model in a web application format for ease of access Ideal Skills and Experience: - Strong background in machine learning and Python - Previous experience in developing classification models - Ability to understand and work with large data sets - Prior experience with deploying machine learning models in web applications
...Development of a customizable chatbot SaaS platform: The chatbot needs to be easily adaptable and integrable for both educational institutions and businesses. - AI-powered Chatbot: The chatbot should be equipped with AI capabilities to facilitate efficient and effective customer service. - Integration Capabilities: The chatbot should seamlessly integrate with CRM software for customer management and live chat support. Ideal Skills: - Proficiency in chatbot development, particularly SaaS platforms. - Expertise in AI and machine learning to deliver an AI-powered chatbot. - Experience with CRM software and live chat support integration. Your input will be crucial in creating an impactful solution for enhancing customer support. Please include your relevant exp...
I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.
I'm in need of a skilled developer or team that can design and build a highly specialized mobile platform. The platform should be able to adapt to various unique applications. This platform should be intuitive, user-friendly,...should support the interface and experience similar to that of Pi from Inflection AI or ChatGPT from OpenAI. Design: The design should be sleek and modern, catering to a professional and tech-savvy audience. Ideal Skills and Experience: - Proficiency in natural language processing and machine learning - Strong UI/UX design background - Extensive experience in mobile application development - Familiarity with platforms such as Inflection Ai or Open Ai This project will require a team or individual with a strong track record in both...
This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data
I'm seeking an experienced Advanced GMAT tutor to help me excel in the exam. I've chosen to study online, so please ensure you're comfortable with this format. Key Requirements: - Expertise in Advanced GMAT: I'm at an advanced level and I need a tutor who can help me elevate my skills to the next level. - Comprehensive Coverage: I need support in all areas of the GMAT including Quantitative section, Verbal section, Integrated Reasoning, and Essay. - Online Teaching Skills: As I'll be doing all my learning online, you must be adept at teaching through this medium. Ideal Skills and Experience: - Proven track record in GMAT tutoring, especially with advanced students - Strong understanding and grasp of all sections of the GMAT - Experienc...
...company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**: The ability to identify and extract the necessary data points effici...
I will be working on your presentation, which will consist of 30 to 40 slides. I will follow the template you shared with me in our chat and create additional graphics for the SWOT and PESTEL analyses, ensuring they match the theme.
