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.
Register on the Healthy Habits for Life today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Healthy Habits for Life is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Healthy Habits for Life Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Healthy Habits for Life, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Healthy Habits for Life Course Promo 00:03:00 Lesson 01: Introduction 00:01:00 Lesson 02: What are Healthy Habits? 00:04:00 Lesson 03: Lifestyle Choices 00:04:00 Lesson 04: Quality of Life/Work-Life Balance 00:04:00 Lesson 05: Getting the Best out of your Daily Routines 00:04:00 Lesson 06: Health and Fitness Tips 00:04:00 Lesson 07: Healthy Diet Hacks 00:04:00 Lesson 08: How to Get More Quality Sleep 00:04:00 Lesson 09: Benefits of Drinking More Water 00:05:00 Lesson 10: Conclusion - Final Thoughts & Ideas 00:01:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.
Register on the Bodyguard Training today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Bodyguard Training is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Bodyguard Training Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Bodyguard Training, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Module 01: Introduction to Bodyguard Training Introduction to Bodyguard Training 00:20:00 Module 02: Personal Security Personal Security 00:25:00 Module 03: Laws and Legislation Laws and Legislation 00:30:00 Module 04: Threat Assessment and Risk Management Threat Assessment and Risk Management 00:35:00 Module 05: Operational Planning Operational Planning 00:30:00 Module 06: Behavioural Intelligence Behavioural Intelligence 00:25:00 Module 07: Anti-Ambush Drills Anti-Ambush Drills 00:20:00 Module 08: Searching Techniques Searching Techniques 00:30:00 Module 09: On Foot Protection On Foot Protection 00:35:00 Module 10: Physical Intervention Physical Intervention 00:25:00 Module 11: Vehicle Escort Procedures Vehicle Escort Procedures 00:20:00 Module 12: Route Reconnaissance Route Reconnaissance 00:25:00 Module 13: Surveillance and Basic Anti Surveillance Techniques Surveillance and Basic Anti Surveillance Techniques 00:25:00 Module 14: Firearms and Explosive Handling Firearms and Explosive Handling 00:20:00 Module 15: Protectee Variations Protectee Variations 00:20:00 Module 16: Medical Emergency Assistance Medical Emergency Assistance 00:25:00 Module 17: How COVID-19 Affected Close Protection Services How COVID-19 Affected Close Protection Services 00:25:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.
Description Learn to organize your work based on priority and know to fulfil the task in time with proper daily planning. If you want to learn the secret strategies of making your work done by following the right daily plan, then enrol the Daily Planning Training course and starts learning. Planning is a must for every aspect of life including personal achievement, business goal or educational goals. As it allows you to prioritize your work and helps you to get more done in less time, planning is essential for achieving a certain goal. If you want success, then daily planning is a surefire way that will help you to obtain your goals and objectives. Instead of these, daily planning guides you to produce quality work and keeps you disciplined. The course is designed to teach you the techniques of planning achievable goals. Inside the course, you will learn how to become stress-free and plan in a way that is easily achievable. The methods of splitting the tasks into various time and ways will be discussed in the course. The necessity of daily planning, the strategies of saying 'No' or 'Yes', the methods of dealing with telephones, and other interactions will also be explained thoroughly. Apart from these, you will learn to analyse the gap of your current situation and the desired goal. To recapitulate, the course not only explains the importance of daily planning but also shows you how to plan effectively. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Daily Planning Training is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Daily Planning Training is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction & getting started An Introduction to Daily Planning FREE 00:04:00 The 2 week challenge - video 00:02:00 Let's set the scene Mind the gap! 00:03:00 Thieves & Pirates A short introduction to this section 00:02:00 Managing time pirates 00:05:00 Do I procrastinate? ..... I'll have to think about that! Why Is Big Data Important? 01:00:00 Let's tackle it NOW! 00:03:00 Not another meeting?! Marvellous Meetings 00:03:00 Interruptions, interruptions, interruptions ring, ring' 'do you have a minute' & the FAT attack 00:03:00 The holy grail The 'zero inbox' 00:05:00 PPPPP PPPPP introduction 00:03:00 step by step 00:03:00 The to-do-list To-Do-Lists 00:02:00 Prime & down time Prime & down time 00:02:00 Daily planning chart What a plan looks like and what goes where 00:02:00 Yes or No? just say 'no'! 00:04:00 'yes' 00:01:00 An action plan for success A 10 step plan for fulproof success 00:03:00 A daily planning visual metaphor - you don't want to skip this! I can't fit everything in.or can I 00:02:00 Summary Course Summary 00:02:00 Bonus Lecture Bonus Lecture 00:01:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
CV Writing and Job Searching Course Overview This course provides essential knowledge and techniques for crafting an effective CV and navigating the job search process. Learners will gain a thorough understanding of how to create a standout CV, tailor it to specific job applications, and implement strategies for successful job hunting. The course covers key aspects such as understanding recruitment processes, utilising job boards, and preparing for interviews. By the end of the course, learners will be equipped with the skills to optimise their CV, boost their job search efforts, and increase their chances of securing employment. Course Description This course delves into the fundamentals of CV writing and job searching, offering learners a step-by-step guide to creating a CV that catches the attention of employers. Topics covered include identifying key skills, structuring a CV for impact, understanding job descriptions, and leveraging various job search platforms. Learners will also explore interview preparation, effective networking, and how to tailor applications to specific roles. Throughout the course, participants will develop an understanding of how to present their strengths and experiences in a way that aligns with employer expectations, enhancing their employability prospects. CV Writing and Job Searching Curriculum: Module 01: CV Writing and Job Searching (See full curriculum) Who is this course for? Individuals seeking to enhance their CV writing and job search skills Professionals aiming to advance their career prospects Beginners with an interest in career development and job hunting Anyone looking to re-enter the job market or make a career change Career Path Recruitment Specialist HR Manager Job Coach or Career Advisor Recruitment Consultant Employer Branding Specialist Job Search Strategist
English for Job Interview Course Overview: This course is designed to help learners build confidence and fluency when preparing for job interviews in English. It covers essential interview techniques, language, and strategies to handle various interview scenarios. Learners will gain the skills needed to effectively communicate their qualifications, strengths, and experiences, while responding to questions in a professional manner. By completing the course, learners will be well-prepared to approach job interviews with the confidence needed to succeed. Course Description: In this course, learners will explore key interview topics such as how to answer difficult questions, how to present themselves professionally, and how to make a lasting impression during an interview. The course offers detailed insights into common interview questions, appropriate language usage, and how to craft compelling answers that highlight skills and experience. Learners will be guided through various types of interview formats, including behavioural and situational interviews, to ensure they are ready for any challenge. The course is structured to provide a supportive learning environment that encourages confidence building and mastery of essential job interview techniques. English for Job Interview Curriculum: Module 01: English for Job Interview: Introduction Module 02: How to Answer Difficult Interview Questions (See full curriculum) Who is this course for? Individuals seeking to improve their job interview performance Professionals aiming to advance in their career by mastering interview techniques Beginners with an interest in preparing for interviews in English Job seekers looking to improve their interview skills and boost their confidence Career Path Job interview consultant HR assistant or coordinator Career coach Recruitment consultant Professional seeking career advancement
Chakra Healing and Balancing Online Training Course Overview This Chakra Healing and Balancing Online Training course provides an in-depth exploration of the chakra system, focusing on its role in personal healing and energy balance. Learners will gain a comprehensive understanding of the seven main chakras and their connection to physical, emotional, and spiritual well-being. By examining the techniques for balancing and healing these energy centres, participants will develop the ability to enhance their own wellness practices and support others. This course equips learners with knowledge they can apply immediately, making it a valuable resource for personal growth and professional development in holistic health practices. Course Description Throughout this course, learners will explore each chakra in detail, understanding its specific function, associated qualities, and how imbalances manifest in the body and mind. Topics include chakra energy, methods for chakra cleansing, meditation practices, and tools for restoring harmony. The course offers an engaging learning experience through a structured combination of theory and techniques. By the end of the course, learners will be skilled in identifying chakra imbalances, applying healing practices, and incorporating chakra work into daily life for improved wellness. This training empowers individuals to use chakra healing in both personal and professional settings. Chakra Healing and Balancing Online Training Curriculum Module 01: Module 02: Module 03: (See full curriculum) Who is this course for? Individuals seeking to improve their personal well-being. Professionals aiming to incorporate chakra healing into their practice. Beginners with an interest in holistic health and energy work. Anyone interested in deepening their understanding of spiritual wellness. Career Path Holistic Health Practitioner Wellness Coach Reiki Practitioner Energy Healer Yoga Instructor Spiritual Guide
Presentation Skills Course Overview This course on Presentation Skills is designed to help learners develop the confidence and techniques necessary to deliver engaging and effective presentations. It covers key aspects of presentation delivery, from understanding audience psychology to mastering various engagement techniques. Learners will be guided on how to structure content, use humour, and create a safe, welcoming environment for their audience. By the end of the course, participants will be equipped with the skills to deliver presentations that are not only informative but also captivating and memorable. Course Description Throughout this course, learners will explore the essential principles behind effective presentation techniques. The content includes creating a sense of security for the audience, fostering a positive atmosphere, and using humour to enhance engagement. Learners will also delve into methods of connecting with different audience types, ensuring their message is both clear and compelling. The course will include modules that focus on both verbal and non-verbal communication, giving learners the ability to present confidently in any setting. By the end of this course, participants will be prepared to present with impact, regardless of their experience level. Presentation Skills Curriculum Module 01: Introduction to Archetype Module 02: Make Your Audience Feel Safe Module 03: Make Your Audience Feel Good Module 04: Make Your Audience Laugh Module 05: Course Wrap Up (See full curriculum) Who is this course for? Individuals seeking to improve their public speaking skills. Professionals aiming to enhance their communication and presentation abilities. Beginners with an interest in presentation techniques. Anyone looking to build confidence when presenting to groups. Career Path Public Speaking Coach Corporate Trainer Event Speaker Communications Specialist Marketing and Sales Presentations
Mediation for single parents Coparenting therapy Addressing painpoints Communication strategies Bespoke coparenting plan Tools and emotional intelligence training Establish a healthy productive co parenting relationship Personal mediator phonecalls in between sessions Protecting your child strategies Life coaching https://relationshipsmdd.com/product/coparenting-package-2/
Discussion of past issues Support Divorce aftermath coaching Confidence building Self-assessment Analysation Dating support Dating assistance Emotional intelligence Dating languages training 7 sessions 45 mins https://relationshipsmdd.com/relationship-advice-for-men/