53644 Courses in Cardiff delivered Online

Fundamentals of Online Coaching for Teachers is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Fundamentals of Online Coaching for Teachers and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 1 hour studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our Website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working over the age of 16. Assessment The assessment is straightforward, you need to complete the assignment questions that will be provided to you at the end of the course, you can complete the assignment anytime you want. After you complete and submit your assignment, our tutors will assess your assignment and give you feedback if needed.  After your assignment has been assessed and you have passed, you will be qualified and will be able to apply for a course completion certificate. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Fundamentals of Online Coaching for Teachers Introduction to Coaching Authority 00:04:00 Coaching Added Benefit 00:05:00 One-on-One Coaching 00:07:00 Group Coaching 00:07:00 Facebook Group Coaching 00:04:00 Email Coaching 00:05:00 Coaching Clients to Higher Income 00:04:00 Life Coaching 00:05:00 Promoting Coaching Services 00:04:00

Child Neglect Awareness Training Did you know? In the UK, child neglect remains a pressing concern, with over 470,000 children estimated to be affected annually. Our Child Neglect Awareness Training course offers vital insights into recognizing and preventing neglect, equipping you to make a real difference. This child neglect awareness training course will empower you to safeguard vulnerable children effectively, from understanding the types and causes of neglect to navigating legislative frameworks. Child Neglect Awareness Training Course Highlights: Types of Child Neglect: Explore physical, educational, emotional, and medical neglect. Understand how each form impacts a child's well-being. Why Child Neglect Occurs: Child Neglect Awareness Training will uncover the underlying reasons-domestic violence, substance abuse, untreated mental illness, and parenting challenges. Detecting Signs: Learn to identify physical cues, such as neonatal drug toxicology, weight-related issues in infants, and developmental lags. Risk Factors: Learn about disability, behaviour problems, social aggression, and attention issues as risk factors for neglect. Impact on Children From Neglecting: Understand the long-term consequences-depression, PTSD, memory impairments, panic disorder, and ADHD. Assessment Skills: Develop a reasoned approach to assessing child neglect cases. Legal Framework: Familiarise yourself with UK laws, including the Children Act 1989, Children Act 2004, Equality Act 2010, Human Rights Act 1998, and more. Prevention Strategies: Acquire knowledge about primary, secondary, and tertiary prevention methods to combat child negligence. Enrol in our Child Neglect Awareness Training course to empower yourself with the knowledge and skills to recognize, prevent, and address child neglect effectively. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Module 01: Introduction to Child Neglect Introduction to Child Neglect 00:28:00 Module 02: Signs of Child Neglect Signs of Child Neglect 00:51:00 Module 03: Risk Factors for Neglect Risk Factors for Neglect 00:40:00 Module 04: The impact of Child Neglect The impact of Child Neglect 00:38:00 Module 05: Child Neglect Cases Child Neglect Cases 00:43:00 Module 06: Legislation Surrounding Child Neglect Legislation Surrounding Child Neglect 00:36:00 Module 07: Responding to and Reporting Child Neglect Responding to and Reporting Child Neglect 00:47:00 Module 08: Prevent Child Negligence Prevent Child Negligence 00:36:00

Psychological Wellbeing Practitioner Unlock your potential as a Psychological Wellbeing Practitioner with our comprehensive course. Gain the skills and knowledge necessary to effectively treat mental health issues and make a lasting impact on the lives of others. In this Psychological Wellbeing Practitioner course, you'll explore current approaches to common mental health challenges, delving into the differences between psychotherapy and counselling. Here, you will discover the various therapies available, including psychodynamic psychotherapy, counselling approaches, and third-wave therapies. As a Psychological Wellbeing Practitioner, organisational skills, interpersonal skills, and effective communication are crucial. Plus, this Psychological Wellbeing Practitioner course will equip you with these essential abilities and the ability to work under pressure and remain calm in challenging situations.  Engaging patients is crucial in providing adequate care. Thus, the course will educate you about a range of assessment strategies and risk management techniques to ensure the safety and well-being of your clients. Additionally, you'll delve into low-intensity CBT treatment techniques, including behavioural activation, worry management for GAD, panic management, and exposure theory. Furthermore, you will become familiar with forms of psychotherapy for depression, anxiety, schizophrenia, and eating disorders to broaden your skillset. Crisis intervention is a vital aspect of any psychological well-being practitioner's role. Therefore, this Psychological Wellbeing Practitioner course will teach you how to deal with distressed clients effectively, recognize signs of crisis, and help clients find solutions. Take advantage of this invaluable opportunity to make a difference in people's lives. Enrol now and embark on your journey towards improving mental health one step at a time. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Module-1: Introduction to Psychotherapy Introduction to Psychotherapy 00:16:00 Module-2: Skills of a Psychological Wellbeing Practitioner Skills of a Psychological Wellbeing Practitioner 00:16:00 Module-3: Types of Therapies Types of Therapies 00:16:00 Module-4: Engaging and Assessing the Patients Engaging and Assessing the Patients 00:19:00 Module-5: Low Intensity CBT Treatment Low Intensity CBT Treatment 00:16:00 Module-6: Forms of Psychotherapy Forms of Psychotherapy 00:17:00 Module-7: Helping the Client in Crisis Helping the Client in Crisis 00:16:00 Module-8: Crisis Intervention Crisis Intervention 00:12:00

Sports Medicine is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Sports Medicine and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 4 hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Module 1: Sports Medicine Sports Medicine 00:20:00 Module 2: Careers in Sports Medicine Careers in Sports Medicine 00:18:00 Module 3: Top Ten Common Sports Injuries Top Ten Common Sports Injuries 00:30:00 Module 4: Common Sports Medicines Common Sports Medicines 00:28:00 Module 5: Nutrition and Weight Management Nutrition and Weight Management 00:32:00 Module 6: Medical Problems Faced by Athletes Medical Problems Faced by Athletes 00:35:00 Module 7: Sports and Exercise Sports and Exercise 00:36:00 Module 8: Imaging in Sports Medicine Imaging in Sports Medicine 00:34:00 Module 9: Performance Enhancement Performance Enhancement 00:20:00 Module 10: The Future of Sports Science The Future of Sports Science 00:22:00

Business Analysis is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Business Analysis and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 5 hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Business Analysis Introduction to Business Analysis 00:17:00 Business Processes 00:47:00 Business Analysis Planning and Monitoring 00:30:00 Strategic Analysis and Product Scope 00:31:00 Solution Evaluation 00:27:00 Investigation Techniques 00:48:00 Ratio Analysis 00:29:00 Stakeholder Analysis and Management 00:25:00 Process Improvement with Gap Analysis 00:28:00 Documenting and Managing Requirements 00:31:00 Career Prospect as a Business Analyst in the UK 00:16:00

Home Workout for Fitness, Weight and Health is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Home Workout for Fitness, Weight and Health and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 01 hour studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Section 01: Introduction & First Concepts Introduction 00:01:00 Keeping Fit A Route to Sanity 00:08:00 Doing It For Yourself 00:06:00 Section 02: Science & Benefits of Staying Fit Benefits of Staying Fit 00:07:00 The Science behind Physical Fitness 00:07:00 Section 03: Creating & Maintaining Your Diet & Workout Plan Physical Fitness & Your Sex Life 00:07:00 Tips To Create a Workout Plan 00:07:00 How to Create a Great Diet Plan 00:08:00 How to Maintain Your Plan & Momentum 00:07:00 Section 04: Final Ideas & Tips Conclusion - Final Thoughts & Ideas 00:02:00

Tax Accounting Diploma is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Tax Accounting Diploma and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 04 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Module 01: Tax System and Administration in the UK Tax System and Administration in the UK 00:27:00 Module 02: Tax on Individuals Tax on Individuals 00:25:00 Module 03: National Insurance National Insurance 00:15:00 Module 04: How to Submit a Self-Assessment Tax Return How to Submit a Self-Assessment Tax Return 00:14:00 Module 05: Fundamentals of Income Tax Fundamentals of Income Tax 00:24:00 Module 06: Payee, Payroll and Wages Payee, Payroll and Wages 00:20:00 Module 07: Value Added Tax Value Added Tax 00:26:00 Module 08: Corporation Tax Corporation Tax 00:19:00 Module 09: Double Entry Accounting Double Entry Accounting 00:13:00 Module 10: Management Accounting and Financial Analysis Management Accounting and Financial Analysis 00:16:00 Module 11: Career as a Tax Accountant in the UK Career as a Tax Accountant in the UK 00:18:00

Exploring Gender Through Cultural Anthropology is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Exploring Gender Through Cultural Anthropology and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 03 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Unit 01: Introduction Welcome 00:01:00 What is Anthropology? 00:04:00 Understanding Other Cultures 00:05:00 Why is Gender Important? 00:03:00 Gender & Daily Life 00:03:00 Unit Assignment 00:01:00 Assignment Answers 00:05:00 Unit 02: Cultural Construction of Gender Introduction 00:01:00 Sex & Gender 00:09:00 Gender Roles 00:09:00 Multiple Gender Identities 00:08:00 Sexual Orientation 00:06:00 Human Sexuality 00:05:00 Conclusion 00:02:00 Unit Assignment 00:02:00 Assignment Answers 00:02:00 Unit 03: Gendered Divisions in Life Introduction 00:01:00 Gender & Products 00:02:00 Gender & Space 00:04:00 Gender & Clothing 00:05:00 Gender & Language 00:08:00 Gender & Labour 00:09:00 Conclusion 00:02:00 Unit Assignment 00:02:00 Assignment Answer 00:04:00 Unit 04: Gender Stratification Introduction 00:01:00 Gender Stratification 00:09:00 Gender Inequality 00:06:00 Gender Ideology & Exploitation 00:08:00 Conclusion 00:02:00 Unit Assignment 00:01:00 Unit Answer 00:03:00 Unit 05: Conclusion Course Summary 00:05:00 Real-World Connections 00:03:00 Be Like an Anthropologist (Part 1) 00:01:00 Be Like an Anthropologist (Part 2) 00:07:00 Congrats 00:01:00 Bonus Lecture: Gender 00:01:00 Resources Resources - Cultural Anthropology: Explore Gender 00:00:00

***With this Personal Development Training for Teachers, get a Personal Hygiene Course completely FREE and prevent yourself from being infected by Coronavirus and other contagious diseases.*** Personal Development Training for Teachers is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Personal Development Training for Teachers and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 9 hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Numeracy and IT Desire for entrepreneurship Over the age of 16 Assessment The assessment is straightforward, you need to complete the assignment questions that will be provided to you at the end of the course, you can complete the assignment anytime you want. After you complete and submit your assignment, our tutors will assess your assignment and give you feedback if needed.  After your assignment has been assessed and you have passed, you will be qualified and will be able to apply for a course completion certificate. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Relationship Management in Classroom for Teachers Developing Healthy Relationships with Students 00:08:00 Communicating Effectively with Parents 00:05:00 Managing Management, How to Deal with the Boss 00:06:00 Psychological Tools for the Champion Teacher 00:05:00 Understanding Problems of Child Development for Teachers Factors That Influence Development 00:39:00 Problems of Infancy 00:19:00 Problems of Childhood 00:23:00 Problems of Adolescence 00:29:00 Advanced Diploma in Child Development Factors That Influence Development 00:39:00 Cognitive Development 00:25:00 Social and Emotional Development 00:44:00 Personality and Intellectual Development in Children 00:39:00 Stages of Language Development 00:29:00 Understanding Moral Development 00:20:00 Level 2 Certificate in Professional Supervision Skills Introduction Getting Started 00:01:00 Setting Expectations Setting Expectations 00:03:00 Setting Expectations Case Study 00:01:00 Setting Goals Setting Goals 00:06:00 Setting Goals Case Study 00:01:00 Assigning Work Assigning Work 00:04:00 Assigning Work Case Study 00:01:00 Degrees of Delegation Degrees of Delegation 00:03:00 Degrees of Delegation Case Study 00:01:00 Implementing Delegation Implementing Delegation 00:07:00 Implementing Delegation Case Study 00:01:00 Providing Feedback Providing Feedback 00:05:00 Providing Feedback Case Study 00:01:00 Managing Your Time Managing Your Time 00:05:00 Managing Your Time Case Study 00:01:00 Resolving Conflict Resolving Conflict 00:04:00 Resolving Conflict Case Study 00:01:00 Tips for Special Situations Tips for Special Situations 00:05:00 Tips for Special Situations Case Study 00:01:00 A Survival Guide for the New Supervisor A Survival Guide For The New Supervisor 00:03:00 A Survival Guide For The New Supervisor Case Study 00:01:00 Wrapping Up Wrapping Up 00:01:00 Classroom Management Training for Teachers Introduction to Teach Like a Champion Introduction Teach Like a Champion 00:10:00 Classroom Management How to Avoid Students Disrupting the Class 00:11:00 How to Stop Distruptions Once They Begin 00:09:00 Choosing an Appropriate Seating Arrangement 00:03:00 Choosing the Best Communication System for the Class 00:10:00 Planning The Critical Importance of Planning 00:08:00 How to Plan an Effective Lesson 00:09:00 How to Plan an Effective Units 00:06:00 How to Plan for the Whole Semester 00:05:00 Assessments and Grading Creating Effective Assessments 00:08:00 Efficient Grading Techniques 00:06:00 The Power of Formative Assessment 00:10:00 The Strengths and Weaknesses of Summative Assessment 00:04:00 Relationship Management Developing Healthy Relationships with Students 00:08:00 Communicating Effectively with Parents 00:05:00 Managing Management, How to Deal with the Boss 00:06:00 Psychological Tools for the Champion Teacher 00:05:00 Conclusion Review the Key Ideas of the Course 00:06:00

Excel Crash Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Excel Crash Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 03 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Analysis of Twitter Dataset and Designing Heatmaps Introduction to the Excel crash course 00:06:00 Understanding the Twitter Dataset 00:05:00 Extracting Other Details for Analysis 00:09:00 Creating Pivot Tables 00:08:00 Applying Conditional Formatting using Color Scales 00:03:00 Adding Slicers to Dashboard 00:02:00 Applying Custom Number Formats 00:03:00 Adding Custom Images to Charts 00:11:00 Interlude - Data Manipulation Challenge 00:02:00 Adding Heatmap Legend 00:02:00 Wrapping Up - Introduction to Open Analytics 00:02:00 Advanced Currency Converter using Dynamic Arrays Introduction to Modern Excel Tables and Dynamic Arrays 00:11:00 Using Power Query for Data Manipulation 00:08:00 Applying Power Query Data Transformations 00:06:00 Structured Table Referencing 00:12:00 XLOOKUP Function and Pivot Table Calculations 00:05:00 Laundry Service Model and Invoicing Dashboard Introduction to the Project 00:01:00 Overview of the Laundry Model Project 00:04:00 Understanding the Inputs 00:03:00 Formatting the Input Tables 00:04:00 Duplicate and Combine Tables with Power Query 00:09:00 Rounding Digits in Power Query 00:02:00 Load Specific Tables from Power Query 00:02:00 Feature Extraction and Named Ranges 00:10:00 Combining Elements - Data Validation with Named Ranges 00:08:00 Combining Elements - Understanding the INDIRECT Function 00:02:00 Combining Elements - Dynamic Drop-down Menu with Data Validation 00:04:00 Combining Elements - INDEX and MATCH with Multiple Criteria 00:12:00 Understanding the MATCH Formula with Multiple Criteria 00:06:00 Business Invoice Dashboard Design 00:06:00