57902 Courses

Duration 1 Days 6 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Write VBA code to create VBA subroutines and functions. Use various programming elements to solve problems through code, including variables,objects, conditional statements, and loops. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code. Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365 (Desktop or Online) courses, Parts 1, 2, and 3. 1. Using VBA to Solve Business Problems Use Macros to Automate Tasks in Excel Identify Components of Macro-Enabled Workbooks Configure the Excel VBA Environment 2. Recording a Macro Use the Macro Recorder to Create a VBA Macro Record a Macro with Relative Addressing Delete Macros and Modules Identify Strategies for Using the Macro Recorder 3. Writing VBA Code Directly Write VBA Code Discover Objects You Can Use Create a Custom Function 4. Solving Problems through Code Make Decisions in Code Work with Variables Perform Repetitive Tasks 5. Improving Your VBA Code Debug VBA Errors Deal with Errors Improve Macro Performance 6. Controlling How and When Macros Run Prompt the User for Information Configure Macros to Run Automatically Additional course details: Nexus Humans VBA with Microsoft Excel (v1.2) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the VBA with Microsoft Excel (v1.2) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Gain advanced knowledge and practical skills in instructing buccal midazolam administration for epilepsy with our Level 4 Award course.

Understand what assertiveness really is and how to deal with challenging situations more confidently.

Our one-day Platelet Rich Plasma training course, also known as PRP or the Vampire Facelift, teaches you all you need to know to become a professional PRP treatment provider. You will practice the famous 'vampire facial' treatment and phlebotomy via simulation and on a live model, and full support is available once you have completed your PRP Course. This treatment is lucrative within your salon and clinic, with growing demand as the treatment becomes ever more popular. Course prerequisites A minimum of 18 years of age Prior Phlebotomy training (Introduction to Phlebotomy) Good command of English This training course requires you to be an active practising aesthetic practitioner with certification / qualification in phlebotomy. If you do not have this you can complete our Phlebotomy training course Course Agenda All courses are intimate with four learners in a class Anatomy and physiology of the skin and blood Infection control Sharps and hazardous waste training First aid and anaphylaxis training Pre-study of PRP theory Phlebotomy Face PRP Hair PRP Extraction, Preparation and Dosage Management How to achieve safe and predictable outcomes Patient management - expectations Practical training Clinical setup Professional live demonstrations

ADVANCED 8 CPD POINTS 1 DAY INTENSIVE COURSE  ONLINE or IN-CLINIC NOTE! After booking we will contact you for scheduling the exact course date! Courses dates are subject to change due to mentors availability. We will inform you via email if a date becomes available! This course theory will help you to understand: We will cover all you need to know in order for you to treat your patients confidently and safely. Dermapen® offers certified microneedling training & certification as part of its education program. The curriculum is available for purchase by all skin care practitioners. The microneedling training will take a look into the history and science of microneedling. 4 hour microneedling training core course The history, improvements and leaders in skin micro-needling Product usage protocols Treatment guidelines Indications and contraindications Before and after patient care Comparative and adjunctive skin therapies Treatment and technical demonstration Certification testing Practice will enable you to learn in 1-day ONE-TO-ONE Training You will also have the opportunity to view a micro needling treatment demonstration at the conclusion of the training. After each lesson, there will be a short quiz. Upon successful completion of the course, you will receive a certificate and title of Dermapen® Certified Practitioner. You need to be medically qualified as a doctor, dentist, nurse, pharmacist or paramedic with full governing body registration and have completed a Foundation Filler Course and to have administered a number of cases. Additional information ATTENDANCE ONLINE (Theory), IN CLINIC (Practice) COURSE LEVEL INTERMEDIATE | Advanced Course

Getting Started The OTHM Level 7 Diploma in Immersive Software Engineering aims to equip learners with advanced-level knowledge and skills to design, develop, and evaluate immersive software engineering systems. By completing this qualification, learners will acquire the skills to support research and innovation in various domains, such as Web and cloud technologies, Security, Automation, Data analytics, and Project methodologies. The primary objective of this diploma is to develop critical thinking and research skills in learners to identify and address complex problems in the software engineering field. Key Benefits This qualification will bring you many vital benefits, such as; The study program is designed to be both stimulating and challenging, providing learners with a chance to gain essential subject knowledge to help them succeed in further studies or the workforce. The program's content has been updated to match the latest employer and higher education requirements. Assessments evaluate both cognitive and affective skills, along with applied skills. Learners will develop valuable knowledge and academic skills, including active research, effective writing and analysis, creative problem-solving, decision-making, and digital literacy. Key Highlights Are you aspiring to become a Software Developer? Then, the OTHM Level 7 Diploma in Immersive Software Engineering program offered by the School of Business and Technology London is the right solution for you. Remember! The assessment for the qualification is done based on assignments only, and you do not need to worry about writing any exam. With the School of Business and Technology London, you can complete the qualification at your own pace, choosing online or blended learning from the comfort of your home. Learning and pathway materials and study guides developed by our OTHM-approved tutors will be available around the clock in our cutting-edge learning management system. Most importantly, at the School of Business and Technology London, we will provide comprehensive tutor support through our dedicated support desk. If you choose your course with blended learning, you will also enjoy live sessions with an assigned tutor, which you can book at your convenience. Career Pathways The OTHM Level 7 Diploma in Immersive Software Engineering can open many career pathways including, but not limited to: Chief technology officer; Est. Salary £1,41,489 per annum Senior software engineer; Est. Salary £55,913 per annum Junior software engineer; Est. Salary £25,904 per annum Team Leader; Est. salary £27,903 per annum     About Awarding Body OTHM is an established and recognised Awarding Organisation (Certification Body) launched in 2003. OTHM has already made a mark in the UK and global online education scenario by creating and maintaining a user-friendly and skill based learning environment. OTHM has both local and international recognition which aids OTHM graduates to enhance their employability skills as well as allowing them to join degree and/or Master top-up programmes. OTHM qualifications has assembled a reputation for maintaining significant skills in a wide range of job roles and industries which comprises Business Studies, Leadership, Tourism and Hospitality Management, Health and Social Care, Information Technology, Accounting and Finance, Logistics and Supply Chain Management. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. UNIT1- Security Engineering Reference No : Unit 1 - F/650/7994 Credit : 20 || TQT : 200 Hours This unit teaches secure software development, system hardening, authentication, encryption, network security, and web application architecture. UNIT2- Software Programming Principles and Practices in Java I Reference No : Unit 2 - H/650/7995 Credit : 20 || TQT : 200 Hours This unit teaches learners about programming languages, including what it is, how it works, and how to interact with computers. Learners will learn the basics through real-world coding examples and regular coding assignments. UNIT3- Agile Project Management Reference No : Unit 3 - J/650/7996 Credit : 20 || TQT : 200 Hours This unit covers project management, Scrum, and Kanab for IT product development. Build products iteratively and optimize value flow for customers. UNIT4- Cloud Computing & DevOps Reference No : Unit 4 - K/650/7997 Credit : 20 || TQT : 200 Hours This unit teaches cloud computing, DevOps, and various cloud models (IaaS, PaaS, SaaS), including different cloud services. UNIT5- Database & SQL Programming Reference No : Unit 5 - L/650/7998 Credit : 20 || TQT : 200 Hours The unit teaches learners the limitations of traditional storage systems, how modern relational databases overcome these challenges, and programming skills to communicate with databases using SQL. UNIT6- Web Designing Reference No : Unit 6 - M/650/7999 Credit : 20 || TQT : 200 Hours This course teaches learners to create HTML, CSS, and JavaScript web pages. Design sites, use styles, tables, lists, and HTML user input properties, and learn JavaScript basics. Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

Gain comprehensive knowledge and practical skills in seizure first aid and rectal paraldehyde administration with our course. Ideal for caregivers, healthcare professionals, educators, and individuals.

Enhance your understanding of petroleum geology for non geologists with EnergyEdge's classroom training. Join our course to gain valuable insights. Enroll now!

Getting Started The main aim of the OTHM Level 7 Diploma in Data Science is to enhance the knowledge and skills required to extract business-oriented insights from data. This involves comprehending how value and information circulate in a business and utilising this knowledge to recognise potential business prospects.The main aim of the OTHM Level 7 Diploma in Data Science is to enhance the knowledge and skills required to extract business-oriented insights from data. This involves comprehending how value and information circulate in a business and utilising this knowledge to recognise potential business prospects. Key Benefits This qualification will bring you many vital benefits, such as; Learners can gain the essential subject knowledge needed to progress successfully into further study or the world of work. Refreshed content that is closely aligned with employer and higher education needs Develop a comprehensive knowledge of classical data analytics, including statistical inference, predictive modelling, time series analysis and data reduction. Become familiar with and use the tools and techniques used in data visualisation. Assessments that consider cognitive skills along with affective and applied skills Key Highlights Do you wish to be a Data Scientist? Then, The OTHM Level 7 Diploma in Data Science program offered by the School of Business and Technology London is the right solution for you. Remember! The assessment for the qualification is done based on assignments only, and you do not need to worry about writing any exam. With the School of Business and Technology London, you can complete the qualification at your own pace, choosing online or blended learning from the comfort of your home. Learning and pathway materials and study guides developed by our OTHM-approved tutors will be available around the clock in our cutting-edge learning management system. Most importantly, at the School of Business and Technology London, we will provide comprehensive tutor support through our dedicated support desk. If you choose your course with blended learning, you will also enjoy live sessions with an assigned tutor, which you can book at your convenience. Career Pathways The OTHM Level 7 Diploma in Data Science can open many career pathways including, but not limited to: Data scientist- Est. Salary £59,680 Data Analyst- Est. Salary £42,984 Business Analyst-Est. Salary £54,413   About Awarding Body OTHM is an established and recognised Awarding Organisation (Certification Body) launched in 2003. OTHM has already made a mark in the UK and global online education scenario by creating and maintaining a user-friendly and skill based learning environment. OTHM has both local and international recognition which aids OTHM graduates to enhance their employability skills as well as allowing them to join degree and/or Master top-up programmes. OTHM qualifications has assembled a reputation for maintaining significant skills in a wide range of job roles and industries which comprises Business Studies, Leadership, Tourism and Hospitality Management, Health and Social Care, Information Technology, Accounting and Finance, Logistics and Supply Chain Management. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. UNIT1- Data Science Foundations Reference No : Unit 1 - F/650/5562 Credit : 20 || TQT : 200 Hours This unit introduces various data science concepts, including data administration, governance, and big data sources. UNIT2- Probability and Statistics for Data Analysis Reference No : Unit 2 - H/650/5563 Credit : 20 || TQT : 200 Hours The objective of this unit is to offer a comprehensive introduction to the fundamental principles of probability and statistics, starting from the basics. It will cover a wide spectrum of data analysis procedures and methodologies. UNIT3- Advanced Predictive Modeling Reference No : Unit 3 - J/650/5564 Credit : 20 || TQT : 200 Hours You will become acquainted with key predictive modelling methods and their underlying foundational principles in this unit. UNIT4- Data Analysis and Visualisation Reference No : Unit 4 - K/650/5565 Credit : 20 || TQT : 200 Hours This unit serves as a crucial foundation for grasping the core concepts of the data analysis process, encompassing data collection, data cleansing, data analysis, and the effective communication of insights through visualisations and dashboard tools. UNIT5- Data Mining Machine Learning and Artificial Intelligence Reference No : Unit 5 - J/650/5573 Credit : 20 || TQT : 200 Hours The primary aim of this unit is to provide an introduction to the scientific principles underpinning machine intelligence and to explore the philosophical discourse surrounding the endeavour to simulate human intelligence for addressing real-world challenges. UNIT6- Advanced Computing Research Methods Reference No : Unit 6 - L/650/5566 Credit : 20 || TQT : 200 Hours This unit aims to enhance learners' skills in preparing for diverse forms of academic computing research by guiding them through creating and designing a research proposal. Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

The RYA Coastal Skipper course is for sailors who want to go a little further afield. We will teach you advanced skippering techniques, including preparation for sea, pilotage, yacht handling under power and sail, and delegating duties to the crew. The course also includes emergency situations such as recovering a man overboard under power and sail. There will be plenty of practice in the harbour, learning to manoeuvre the boat in smaller places and mooring in a variety of conditions. We will practice blind navigation, so that if you are in heavy weather or fog you will make it to the nearest harbour safely. It is recommended that the coastal skipper theory course is completed prior to the practical course - however, there is the option to self-study. You also have to have logged 300 NM over 15 days at sea (including two as a skipper) and eight night sail hours. The course runs over five days and nights. You will be living on one of our fully coded yachts with up to four other crew members and your Yachtmaster Instructor. Your food is included in the cost, as is overnight stays in harbours. To add to the experience of gaining your RYA Coastal Skipper, you will get the benefit of continuing your sailing experience on the west coast of Scotland.