11975 Teaching & Training courses in Cardiff delivered On Demand

This SENCO - level 3 course is designed for those interested in or who are currently in a SENCO role in the early years setting. This SENCO - level 3 qualification provides learners with a thorough understanding of the roles and responsibilities of the Special Educational Needs Coordinator in early years setting. Learn about the strategies and techniques for assisting children and their families and gain in-depth knowledge of SEN codes of practice. The purpose of this course is to help learners progress to further and higher education and develop new practical skills in health and social care. Learning Outcomes After completing this SENCO - level 3 course, the learner will be able to: Understand the roles and responsibilities of the Special Educational Needs Coordinator in the early years setting. Understand the strategies and techniques for supporting children and their families. Increase knowledge of SEN codes of practice. Why Choose Special Educational Needs Coordination Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ***Courses are included in this SENCO - level 3 Course*** Course 01: SENCO : SENCO - level 3 Course 02: Level 3 Certificate in Understanding Autism Course 03: Level 4 Child Care and Development Course ***Other Benefits of thisCourse*** Free 3 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the course ] Detailed course curriculum Module 1: Roles and Responsibilities of the Special Educational Needs Coordinator in the Early Years Understand the principles, statutory guidance and legislation underpinning practice for children with Special Educational Needs and Disability (SEND) in an early years setting Understand the role of the Early Years Special Educational Needs Coordinator (SENCo) Understand partnership working for the Early Years SENCo Understand early identification and action for children with SEND Module 2: Strategies and Techniques for Supporting Children and Families Understand the graduated approach in an early years setting Understand English as an additional language (EAL) Understand Education, Health and Care (EHC) plans ------------------------- ***Level 3 Certificate in Understanding Autism Course Curriculum Module 1: Autism in Context Module 2: Positive Behavioural Support for Individuals with Autism Module 3: Understand Support and Management of Transitions for Individuals with Autism Module 4: Therapeutic Interventions and Support Available for Individuals with Autism and Co- occurring Conditions Module 5: Communication and Social Interaction with Individuals with Autism Module 6: Safeguarding and Resilience in Autism ------------------------- ***Level 4 Child Care and Development Course Course Curriculum Module 01: Few Basic Things to Keep in Mind Module 02: Caring for newborn Babies Module 03: Feeding Module 04: Nutrition and Health Module 05: Health Concerns Module 06: First Aid and Emergency Module 07: Raising Mentally Healthy Children Module 08: Sex Education Module 09: Common Developmental and Behavioral Challenges Assessment Method After completing each module of the SENCO - level 3, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this SENCO - level 3 course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This SENCO : SENCO - level 3 course is ideal for those already working in a SENCO role as part of their Early Years Practitioner role or interested in doing so. This course is also suitable for childminders. Requirements There are no specific requirements for this SENCO : SENCO - level 3 course because it does not require any advanced knowledge or skills. Students who intend to enrol in this SENCO : SENCO - level 3 course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path This SENCO : SENCO - level 3 course is appropriate for those who want to work in the following fields: Health and social care Childhood studies Community, youth and families Social work Early years Primary teaching Nursing Certificates Certificate of completion Digital certificate - Included

Overview With the ever-increasing demand for Alternative Medicine in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Alternative Medicine may be. Learning about Alternative Medicine or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Alternative Medicine . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Alternative Medicine is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Alternative Medicine course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Alternative Medicine course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Alternative Medicine course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Alternative Medicine , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Alternative Medicine , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Alternative Medicine , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Alternative Medicine course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.    Course Curriculum Chapter 1 History of Alternative Medicine History of Alternative Medicine 00:00 Chapter 2 Alternative Treatment Options Alternative Treatment Options 00:00 Chapter 3 Overall Treatment Plans Overall Treatment Plans 00:00

Overview With the ever-increasing demand for Childhood Nutrition in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Childhood Nutrition may be. Learning about Childhood Nutrition or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Childhood Nutrition. That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Childhood Nutrition is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Childhood Nutrition course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Childhood Nutrition course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Childhood Nutrition course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Childhood Nutrition, Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Childhood Nutrition, Anyone looking for a certificate of completion on doing an online training on this topic, Students of Childhood Nutrition, or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Childhood Nutrition course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.    Course Curriculum Module 1 The Importance of Proper Nutrition The Importance of Proper Nutrition 00:00 Module 2 What Nutrients are Kids Commonly Missing What Nutrients are Kids Commonly Missing 00:00 Module 3 Teach Your Children to Eat Healthy.docx Teach Your Children to Eat Healthy.docx 00:00 Module 4 Optimal Nutrition for Kids Optimal Nutrition for Kids 00:00 Module 5 Meal Time for Your Kids Meal Time for Your Kids 00:00 Module 6 Illnesses Associated with Poor Nutrition Illnesses Associated with Poor Nutrition 00:00

🌟 Unlock Your Full Leadership Potential with the Executive Leadership Mastery Program! 🌟 Are you ready to elevate your career to new heights and become the leader you were born to be? Introducing our exclusive online course - the Executive Leadership Mastery Program! Designed for ambitious professionals like you, this comprehensive program will equip you with the skills, strategies, and mindset necessary to thrive in the fast-paced world of executive leadership.   🚀 What You'll Master: 🌐 Introduction: Get ready to embark on a transformational journey! We'll lay the foundation for success by exploring the principles of effective executive leadership, setting the stage for your personal and professional growth. 🔥 Module 1: Leadership Skills Training Dive deep into the core of leadership excellence. Learn how to inspire and motivate your team, navigate challenges with resilience, and make strategic decisions that drive success. Uncover the secrets of renowned leaders and apply their proven techniques to your own leadership style. 🛠️ Module 2: Management Skills Training Discover the art of effective management. From project planning to resource allocation, you'll gain practical skills to streamline operations and boost productivity. Learn how to lead with confidence, ensuring that your team is not just meeting, but exceeding, organizational goals. 🌟 Module 3: Creating A Great Culture Explore the critical role of organizational culture in achieving sustained success. Discover how to foster a positive work environment that encourages innovation, collaboration, and employee satisfaction. Transform your workplace into a hub of creativity and excellence. 🤝 Module 4: Teamwork - Create High-Performance Teams Master the art of teamwork and collaboration. Learn strategies to build and lead high-performance teams that deliver outstanding results. From effective communication to conflict resolution, this module will empower you to cultivate a dynamic team that consistently achieves and surpasses expectations.   🎓 Why Choose Our Program: ✨ Expert Guidance: Learn from industry experts and thought leaders with a wealth of real-world experience. ✨ Flexibility: Access the course anytime, anywhere, and at your own pace, fitting seamlessly into your busy schedule. ✨ Practical Application: Our curriculum is designed for immediate application, ensuring you see results in your leadership style and team dynamics. ✨ Networking Opportunities: Connect with a community of like-minded professionals, fostering valuable relationships for your career advancement.   🚀 Elevate your leadership journey today! Don't miss this opportunity to join the ranks of successful executives who have transformed their careers with the Executive Leadership Mastery Program.   👉 Enroll Now and take the first step towards becoming the exceptional leader you are destined to be! 👈 Course Curriculum Introduction Introduction 00:00 Module 1: Leadership Skills Training Module 1: Leadership Skills Training 00:00 Module 2: Management Skills Training Module 2: Management Skills Training 00:00 Module 3: Creating A Great Culture Module 3: Creating A Great Culture 00:00 Module 4: Teamwork - Create High Performance Teams Module 4: Teamwork - Create High Performance Teams 00:00

This SENCO - Special Educational Needs Coordination course is designed for those interested in or who are currently in a Special Educational Needs Coordination role in the early years setting. This SENCO qualification provides learners with a thorough understanding of the roles and responsibilities of the Special Educational Needs Coordinator in early years setting. Learn about the strategies and techniques for assisting children and their families and gain in-depth knowledge of SEN codes of practice. The purpose of thiscourse is to help learners progress to further and higher education and develop new practical skills in health and social care. Learning Outcomes After completing this Special Educational Needs Coordination course, the learner will be able to: Understand the roles and responsibilities of the Special Educational Needs Coordinator in the early years setting. Understand the strategies and techniques for supporting children and their families. Increase knowledge of SEN codes of practice. Why Choose SENCO Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ***Courses are included in this SENCO - Special Educational Needs Coordination Course*** Course 01: SENCO - Special Educational Needs Coordination Course 02: Level 2 Certificate in Understanding Common Childhood Illnesses Affecting Children Course 03: Care and support for Vulnerable Children ***Other Benefits of this Course*** Free 3 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the course ] Course Curriculum Module 1: Roles and Responsibilities of the Special Educational Needs Coordinator in the Early Years Understand the principles, statutory guidance and legislation underpinning practice for children with Special Educational Needs and Disability (SEND) in an early years setting Understand the role of the Early Years Special Educational Needs Coordinator (SENCo) Understand partnership working for the Early Years SENCo Understand early identification and action for children with SEND Module 2: Strategies and Techniques for Supporting Children and Families Understand the graduated approach in an early years setting Understand English as an additional language (EAL) Understand Education, Health and Care (EHC) plans ------------------------- ***Level 2 Certificate in Understanding Common Childhood Illnesses Affecting Children Course Curriculum Module 1: Understand How to Provide a Safe and Healthy Environment for Babies and Young Children Module 2: Understand Common Childhood Illnesses Module 3: Understand Health Emergencies and Specific Health Conditions in an Early Years Setting ------------------------- ***Care and support for Vulnerable Children Course Curriculum Module 01: Introduction Module 02: The Rights of Children Module 03: Understanding the Distinction Between Vulnerability and Risk Module 04: Child in Crisis Module 05: Controlling The Issues Module 06: Available Services Module 07: History and Future Developments Assessment Method After completing each module of the Special Educational Needs Coordination, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this SENCO course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This SENCO - Special Educational Needs Coordination course is ideal for those already working in a SENCO - Special Educational Needs Coordination role as part of their Early Years Practitioner role or interested in doing so. This course is also suitable for childminders. Requirements There are no specific requirements for this Special Educational Needs Coordination course because it does not require any advanced knowledge or skills. Students who intend to enrol in this course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path This SENCO course is appropriate for those who want to work in the following fields: Health and social care Childhood studies Community, youth and families Social work Early years Primary teaching Nursing Certificates Certificate of completion Digital certificate - Included

🌈 Unlock the Power of Chinese Chromotherapy with Our Exclusive Online Course! 🌟   🎓 Introducing the Chinese Chromotherapy Certification Course: Illuminate Your Path to Holistic Healing! 🎓 Are you ready to embark on a journey that transcends the boundaries of traditional healing? Dive into the enchanting world of color therapy with our comprehensive online course - Chinese Chromotherapy Certification!   🌟 Module 1: Fundamentals of Color Therapy Discover the foundational principles that have made Chinese Chromotherapy a revered practice for centuries. In this module, you will: ✨ Explore the Origins: Delve into the rich history of Chinese Chromotherapy and its roots in ancient Chinese medicine. ✨ Color Psychology: Uncover the profound impact each color has on the human mind, body, and spirit. ✨ Energy Channels: Learn how colors influence the flow of energy through meridians, promoting balance and vitality. ✨ Practical Applications: Gain hands-on experience with basic color therapy techniques to enhance your understanding. 🌈 Module 2: Application of Color Therapy Now that you've mastered the fundamentals, it's time to put your knowledge into action! In this module, you will: ✨ Chromotherapy in Practice: Explore real-life case studies showcasing the transformative effects of Chinese Chromotherapy. ✨ Customized Treatments: Develop the skills to create personalized color therapy plans tailored to individual needs. ✨ Incorporate into Daily Life: Discover how to integrate color therapy seamlessly into daily routines for sustained well-being. ✨ Certification Assessment: Showcase your expertise through a comprehensive certification assessment, validating your proficiency in Chinese Chromotherapy.   🎓 Why Choose Our Chinese Chromotherapy Certification Course? 🌟 Expert Guidance: Learn from seasoned professionals with a wealth of experience in Chinese Chromotherapy. 🌟 Flexibility: Study at your own pace, with 24/7 access to course materials from the comfort of your home. 🌟 Interactive Learning: Engage in dynamic discussions, practical exercises, and immersive activities to enhance your learning experience. 🌟 Global Community: Connect with like-minded individuals from around the world, fostering a supportive network of fellow chromotherapy enthusiasts. 🌟 Lifetime Access: Enjoy unlimited access to course updates and resources, ensuring your knowledge remains current and relevant.   🚀 Elevate your healing journey and become a certified Chinese Chromotherapy practitioner today! Enroll now and illuminate the path to holistic well-being. 🚀 Course Curriculum Fundamentals of Color Therapy Color Therapy- Programme Overview 00:00 Color Therapy- Basics Of Light And Colour 00:00 Color Therapy- Foundations Of Colour Therapy 00:00 Application of Color Therapy Colour Therapy_ Methods of Application 00:00 Violet Color Therapy 00:00 INDIGO Color Therapy 00:00 BLUE Color Therapy 00:00 GREEN Color Therapy 00:00 Yellow Color Therapy 00:00 Orange Color Therapy 00:00 Red Color Therapy 00:00 Pink Color Therapy 00:00 Brown Color Therapy 00:00 Gray Color Therapy 00:00 White Color Therapy 00:00 Black Color Therapy 00:00

Overview With the ever-increasing demand for Food Safety in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Food Safety may be. Learning about Food Safety or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Food Safety . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Food Safety is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Food Safety course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Food Safety course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Food Safety course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Food Safety , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Food Safety , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Food Safety , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Food Safety course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.  Course Curriculum Module 1 - Food Safety -An Introduction Food Safety -An Introduction 00:00 Module 2 - Food Safety Challenges in the Global Supply Chain Food Safety Challenges in the Global Supply Chain 00:00 Module 3 - Recognising Food Safety Hazards Recognising Food Safety Hazards 00:00 Module 4 - Designing Safety into a Food Product Designing Safety into a Food Product 00:00 Module 5 - Designing a Safe Food Process Designing a Safe Food Process 00:00 Module 6 - Maintaining and Improving a Food Safety Programme Maintaining and Improving a Food Safety Programme 00:00 Module 7 - Food Safety in Foodservice Operations Food Safety in Foodservice Operations 00:00 Module 8 - Personal Hygiene Personal Hygiene 00:00

Nursery School teacher Training is a complete course that imparts the systems, ways and process needed to educate children at Primary, Pre Primary, Montessori and Nursery Schools. You can pursue the course from any part of the world without worrying about time constraints since we offer Class room ( Offline), online and distance learning mode. A aspirant can choose between any of the three modes of learning. The course puts special emphasis on “ Child Psychology ” that a school teacher has to know to educate children. therefore, the Nursery school teacher Training is a complete course which enables one to become a skilled & Resourceful school teacher.

A Complete Guide for Effective LinkedIn Ads' is a comprehensive course that covers the fundamentals of setting up and managing successful LinkedIn Ads campaigns. Participants will learn to drive website traffic, utilize sponsored messages, generate leads, and effectively manage billing centers on the platform. Learning Outcomes: Understand the basics of LinkedIn Ads and their role in digital marketing. Learn how to set up LinkedIn Ads to drive targeted website traffic. Discover techniques for leveraging sponsored messages to engage with the audience. Acquire the skills to create and optimize LinkedIn Ads for lead generation. Gain proficiency in managing the billing center for efficient campaign budgeting and monitoring. Why buy this Excel VBA/Macros Foundations? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Excel VBA/Macros Foundations there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Excel VBA/Macros Foundations course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Excel VBA/Macros Foundations does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Excel VBA/Macros Foundations was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Excel VBA/Macros Foundations is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Recording Macros vs Writing VBA 00:04:00 Understanding Objects in Excel VBA 00:07:00 Understanding VBA Syntax and Parts of Speech 00:10:00 Activating the Developer tab 00:01:00 Recording a basic Macro 00:05:00 Absolute vs Relative Macro recording 00:04:00 Section 02: Exploring the Visual Basic Environment Introduction to the Visual Basic Environment 00:02:00 The Project Explorer 00:02:00 The Properties Window 00:02:00 The Code Window 00:04:00 Immediate, Locals and Watch Window 00:03:00 Dealing with Modules 00:03:00 Comments in Excel VBA 00:01:00 Section 03: The Range Object Introduction and Changing Cell Values 00:10:00 Adding a text to a cell 00:01:00 Dealing with Named Ranges 00:03:00 Value vs Text Property 00:04:00 Row and Column properties 00:02:00 The Select Method 00:02:00 The Count Property 00:04:00 The Address Property 00:09:00 The Formula Property 00:03:00 The Number Format Property 00:07:00 The Font Property 00:08:00 Section 04: Understanding the Cells Collection Object What is the cells object? 00:06:00 Using the Cells collection to affect cells positionally within a range 00:05:00 Affecting all cells within a sheet 00:02:00 Combining Range and cells objects 00:03:00 Section 05: Working with Sheets/Worksheets Selecting Sheets 00:06:00 Adding Sheets 00:11:00 Sheets vs Worksheets 00:04:00 Copying Sheets 00:05:00 Moving Sheets 00:01:00 Deleting Sheets 00:04:00 Section 06: Understanding Variables in Excel VBA Introduction to Variables 00:06:00 Variable Data Types 00:09:00 Declaring Variables 00:14:00 Object Variables 00:08:00 Calling a procedure from Another Procedure & Variable Scope 00:03:00 Public and Private Variables 00:07:00 Declaring Constants 00:04:00 Exercises-Variables 00:06:00 Section 07: Dealing with Workbooks Referring to Workbooks-Different ways 00:04:00 Closing Workbooks 00:03:00 Adding and Saving Workbooks Part 1 - Save method 00:04:00 Adding and Saving Workbooks Part 2 - Save as method 00:10:00 Opening Workbooks 00:06:00 Section 08: Must Know Excel VBA Logic Finding the Last row 00:09:00 Finding the Last Column 00:04:00 Finding the next row 00:04:00 The WITH Statement 00:04:00 Comparison operators in Excel VBA 00:01:00 IF Statements- Simple IF Statements 00:07:00 IF THEN ELSE Structure 00:03:00 IF THEN ELSEIF Structure 00:07:00 Nested IFs 00:04:00 OR - AND logical operators 00:07:00 NOT Logical operator 00:03:00 CASE Statements Part 1 - Single Case Statements 00:09:00 CASE Statements Part 2 - Nested Case Statements 00:06:00 Case Statements-Exercise 00:01:00 GOTO and Labels 00:03:00 Section 09: Looping in Excel VBA Loops-Introduction 00:01:00 FOR NEXT Loop 00:11:00 Exit For 00:09:00 Exercise - For Next loop 00:01:00 FOR EACH Loop - Intro 00:07:00 FOR EACH Loops - More examples 00:05:00 Do Loop - Introduction 00:04:00 Do Loop Example 00:01:00 Do Until 00:02:00 Do While 00:02:00 Do while vs Do until - Movies Example 00:04:00 Exit Do Statement 00:05:00 Exercise - Do Loop 00:01:00 Section 10: Interacting with Your Users The Messagebox - Introduction 00:03:00 Messagebox -Inputs 00:07:00 Messagebox - Capturing the User's input 00:05:00 Adding a new line to your VBA Strings 00:02:00 The Inputbox - introduction 00:04:00 Inputbox - Example1 - Capturing a user's name 00:05:00 Inputbox -Employee Database Example Part 1 00:05:00 Inputbox -Employee Database Example Part 2 00:04:00 Exercise - InputBox 00:02:00 Section 11: Error Handling in Excel VBA Error Handling - Introduction 00:09:00 Different Error types in action 00:04:00 On Error Goto statement 00:04:00 Resetting the error handling Status with On Error Goto 00:02:00 The Err Object 00:07:00 Setting a Breakpoint 00:02:00 Section 12: Triggering Code with Events! Worksheet Events -Selection change 00:08:00 Worksheet Events - Worksheet Activate event 00:03:00 Worksheet Events - Deactivate event 00:02:00 Worksheet Events - Before Delete Event 00:02:00 Worksheet Events - Before Double click event 00:08:00 Worksheet Events - Before Right Click event 00:03:00 Worksheet Events - Calculate event 00:03:00 Enabling and Disabling Events 00:03:00 Worksheet events - Worksheet change event 00:11:00 Workbook Events - Follow Hyperlink event 00:02:00 Worksheet events -Exercise 00:01:00 Workbook Events - Workbook open event 00:05:00 Workbook Events - Workbook Activate event 00:02:00 Workbook Events - Workbook Before save event 00:06:00 Workbook Events - Workbook Aftersave event 00:04:00 Workbook Events - Workbook Beforeclose event 00:09:00 Workbook Events - Workbook BeforePrint event 00:03:00 Workbook Events -Workbook De-activate events 00:02:00 Workbook Events - New Chart event 00:08:00 Workbook Events -New sheet event 00:03:00 Workbook Events - Sheet calculate event 00:03:00 Workbook Events - Sheet De-activate event 00:06:00 Workbook Events - Follow Hyperlink event 00:02:00 Workbook Events - Workbook Window Activate event 00:06:00 Workbook Events - Workbook Window De-Activate event 00:02:00 Workbook Events - Window Resize event 00:02:00 Exercise- Workbook Events 00:01:00 Resources Resources - Excel VBA/Macros Foundations 00:00:00 Assignment Assignment - Excel VBA/Macros Foundations 00:00:00

Overview   With the ever-increasing demand for Touch Typing in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Touch Typing may be.   Learning about Touch Typing or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Touch Typing. That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Touch Typing is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates.   The self-paced online learning methodology by Compete High in this Touch Typing Masterclass course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course!   Instead of searching for hours, enrol right away on this Touch Typing Masterclass course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run.   Who is this course for?   While we refrain from discouraging anyone wanting to do this Touch Typing Masterclass course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Touch Typing, Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Touch Typing, Anyone looking for a certificate of completion on doing an online training on this topic, Students of Touch Typing, or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity   Career Path   This Touch Typing Masterclass course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams. Course Curriculum Module 1 - Introduction of Touch Typing Introduction of Touch Typing 00:00 Module 2 - Getting Started Getting Started 00:00 Module 3 - A Complete Guide for Beginners A Complete Guide for Beginners 00:00 Module 4 - Learn How to Touch Type Learn How to Touch Type 00:00 Module 5 - 5 Techniques or Skills to Master 5 Techniques or Skills to Master 00:00 Module 6 - Reference Guide Reference Guide 00:00 Module 7 - How It is an Essential Skill All Children Should Learn How It is an Essential Skill All Children Should Learn 00:00 Module 8 - Touch Typing Education in Different Countries Touch Typing Education in Different Countries 00:00