• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

630 Courses

Managing Difficult Employees

By ZandaX

Learn positive ways to manage the difficult members in your team. Includes how to manage deflectors, non-team players, negative personalities, trouble makers and more

Managing Difficult Employees
Delivered Online On Demand1 hour
£12.99

Teaching Assistant Level 2 + Early Years, Teaching and Child Care & SEN Teaching Assistant

By Training Tale

Teaching Assistant Level 1 + Early Years, Teaching and Child Care & SEN Teaching Assistant Online Teaching and Child Care : Teaching and Child Care Online Develop the skills required for childcare and become a better teacher. Teaching and child care are rapidly evolving professions, with most schools now requiring mastery of both teaching and child care skills. Our Teaching and Child Care course is designed to improve teachers' understanding of child psychology and to help them develop higher-level teaching skills. This Teaching and Child Care: Teaching and Child Care course will provide a flexible path to a career in the teaching and child care setting. This Teaching and Child Care course is a bundle of 09 courses. We have sincerely combined these 09 courses with a comprehensive curriculum made by expert teachers to make this course highly valuable for you. Depending on your need, you will get dedicated tutor support throughout this Teaching and Child Care: Teaching and Child Care course. Our tutors are always happy to assist our learners. So, you need to ask for assistance only! With this: Teaching and Child Care course, you will increase your employability skills enormously and stand out from the crowd. So, why do you hesitate? Just enroll on this Teaching and Child Care: Teaching and Child Care course, and the rest is on us to make your learning journey a pleasant one. This Teaching and Child Care: Teaching and Child Care course is fully online and self-paced, so you don't need to worry about timing. You can set your own schedule to continue the courses. Special Offers of this Teaching and Child Care: Teaching and Child Care Course This Teaching and Child Care: Teaching and Child Care Course includes a FREE PDF Certificate. Lifetime access to this Teaching and Child Care: Teaching and Child Care Course Instant access to this Teaching and Child Care: Teaching and Child Care Course Get FREE Tutor Support from Monday to Friday in this Teaching and Child Care: Teaching and Child Care Course Main Course: Teaching Assistant Gift Courses Included with Teaching and Child Care: Teaching and Child Care Course: Early Years: Teaching and Child Care Course Offers free Teaching Assistant Course Early Years: Teaching and Child Care Course Offers free Child Counselling Course Early Years: Teaching and Child Care Course Offers free Teaching and Child Care Course Early Years: Teaching and Child Care Course Offers free SEN Teaching Assistant Course [ Note: Free PDF certificate as soon as completing the Teaching and Child Care: Teaching and Child Care course] Teaching Assistant Level 1 + Early Years, Teaching and Child Care & SEN Teaching Assistant Online Industry Experts Designed this Teaching Assistant: Teaching and Child Care Course into 16 detailed modules. Course Curriculum of Teaching Assistant Course Module 01: Roles and Responsibilities of the Higher-Level Teaching Assistant Module 02: Working in the School Module 03: Working in the Classroom Module 04: Promote Children and Young people's Positive Behaviour Module 05: Support Children and Young People's Health and Safety Module 06: Communication and Professional Relationships with Children, Young People and Adults Module 07: Develop Professional Relationships with Children, Young People and Adults Module 08: Promote Equality, Diversity and Inclusion in Work with Children and Young People Module 09: Understand How to Safeguard the Wellbeing of Children and Young People Module 10: Support Learning Activities Module 11: Schools as Organisations Module 12: Support Assessment for Learning Module 13: Engage in Personal Development in Children's and Young People's Settings Module 14: Understand Child and Young Person Development Module 15: Support Children and Young People to Achieve Their Education Potential Module 16: Support Children and Young People to Make Positive Changes in Their Lives Module 17: Facilitate the Learning and Development of Children and Young People through Mentoring Assessment Method of Teaching and Child Care After completing each module of the Teaching and Child Care: Teaching and Child Care Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Teaching and Child Care After completing the MCQ/Assignment assessment for this Teaching and Child Care: Teaching and Child Care Course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? Teaching Assistant Level 1 + Early Years: Early Years, Teaching and Child Care & SEN Teaching Assistant Online This Teaching and Child Care : Teaching and Child Care course is ideal for those who want to start a career in teaching and child care or are already working in the education and training sector and want to improve skills. Requirements Teaching Assistant Level 1 + Early Years: Early Years, Teaching and Child Care & SEN Teaching Assistant Online Students who intend to enroll in this Early Years: Early Years Course must meet the following requirements: Teaching and Child Care: Teaching and Child Care Good command of the English language Teaching and Child Care: Teaching and Child Care Must be vivacious and self-driven Teaching and Child Care: Teaching and Child Care Basic computer knowledge Teaching and Child Care: Teaching and Child Care A minimum of 16 years of age is required Career path Teaching Assistant Level 1 + Early Years, Teaching and Child Care & SEN Teaching Assistant Online After completing this Teaching and Child Care course, you may be able to pursue a variety of career opportunities. Such as - Primary teacher Nursery Teacher Assistant Teacher Child care assistant EYFS Teacher Nursery Nurse SEN Teacher Teaching and Child Care Certificates Certificate of completion Digital certificate - Included

Teaching Assistant Level 2 + Early Years, Teaching and Child Care & SEN Teaching Assistant
Delivered Online On Demand16 hours
£12

Food Safety Management in Covid-19 Pandemic

4.7(160)

By Janets

This Food Safety Management in Covid-19 Pandemic Course is the most efficient and reliable way to ensure that your catering business or eating establishment is fully protected from Covid infections, and can deal with the aftermath in forthcoming months. All areas with food preparation, storage, and delivery will need to adhere to strict hygiene standards and ensure that their clientele remains safe and healthy. You can get the training here and now to safeguard your livelihood and train your colleagues in the required hygiene control levels. When you enrol in this specially tailored tutorial, you will be given professionally sourced information regarding the reopening of food businesses and the subsequent adaptations needed. This crucial information is combined with updated procedures for food storage, preparation and packaging of foodstuff, redefined hazard control procedures, and the current UK legislation in place for Food Safety. The Food Safety Management in Covid-19 Pandemic Course delivers expert training and a timely and concise manner. The individual online learning modules will empower you to organise and take the tuition at your convenience, swiftly learning the details required. Using a combination of online study tools and practical assessments, you are sure to absorb the guidelines in no time at all. Get your business prepared for the future with the contents of this course. Why choose this Food Safety Management in Covid-19 Pandemic Course? Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full tutor support on weekdays 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 Mock exams Multiple-choice assessment Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate. 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? This course is aimed at anyone that works in, or owns, a business that provides fresh food and meals to paying customers. The information herein is appropriate to business open during or after national lockdowns. Career Path The information presented in the modules of the Food Safety Management in Covid-19 Pandemic Course will specifically benefit those working in the food industry, whether it involves handling, preparing, or serving foodstuff. It will prove most useful for the following careers and roles:  Catering Manager Restaurant or Café Owner Food Handler Kitchen Porter Chef or Bar Staff Quality Control Inspector Course Content Module 1: Reopening and Adapting Your Food Business During COVID-19 Reopening and Adapting Your Food Business during COVID-19 00:13:00 Module 2: Personal Hygiene Personal Hygiene 00:28:00 Module 3: Food Storage Food Storage 00:25:00 Module 4: Food Preparation and Processing for Food Manufacturing Food Preparation and Processing for Food Manufacturing 00:25:00 Module 5: Food and Temperature Control Food and Temperature Control 00:31:00 Module 6: Hazard Control Measures and Refrigeration Hazard Control Measures and Refrigeration 00:29:00 Module 7: Physical, Chemical and Allergenic Hazards Physical, Chemical and Allergenic Hazards 00:27:00 Module 8: Food Hygiene and Safety: Legislation Food Hygiene and Safety Legislation 00:27:00 Mock Exam Mock Exam - Food Safety Management in Covid-19 Pandemic 00:20:00 Final Exam Final Exam - Food Safety Management in Covid-19 Pandemic 00:20:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00: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.

Food Safety Management in Covid-19 Pandemic
Delivered Online On Demand4 hours 5 minutes
£25

Microsoft Office Skills (MS Excel, Word, PowerPoint, Access), Administration & IT Training

4.8(9)

By Skill Up

All-in-one Package| CPD Certified| 35 Courses Training| 350 CPD Points| Free PDF+ Transcript Certificate| Lifetime Access

Microsoft Office Skills (MS Excel, Word, PowerPoint, Access), Administration & IT Training
Delivered Online On Demand8 days
£120

Sales Management 4-in-1 Master Class

By ZandaX

Learn how to get control - and great results - in a sales management role. Includes Creating a Solid Foundation, Setting Up Your Team, Sales Processes & Techniques, Sales Forecasting, Targets & KPIs.

Sales Management 4-in-1 Master Class
Delivered Online On Demand4 hours
£24.99

Group Hypnotherapy Anchoring & Fear Release Masterclass M3

5.0(22)

By The Northern College Of Clinical Hypnotherapy

This masterclass revisits the concept of anchoring in group settings and explores how it can be effectively combined with fear release techniques. We'll focus on creating shared anchors that the group can use to access positive emotional states, both during, alongside and after fear release exercises.

Group Hypnotherapy Anchoring & Fear Release Masterclass M3
Delivered Online On Demand1 hour
£25

Teacher Training - Course

By Training Tale

You need to become competent and skilled enough to become a teacher in your chosen area. With our Teacher Training Course bundle, you will acquire the necessary knowledge and skills and eventually become a qualified teacher in different settings. This Teacher Training Course is a bundle of 10 courses. We have sincerely combined these 10 courses with a comprehensive curriculum made by the expert teachers to make this Teacher Training Course highly valuable for you. Depending on your need, you will get dedicated tutor support throughout this Course. Our tutors are always happy to assist our learners. So, you need to ask for assistance only! With this Course, you will get 10 courses! It means you will get 10 different certificates of achievement once you complete all the courses successfully. Imagine how your CV will be enriched. And the PDF certificates are completely free. With this Course, you will increase your employability skill enormously and stand out from the crowd. So, why do you hesitate? Just enrol on this Teacher Training Course, and the rest is on us to make your learning journey a pleasant one. This Teacher Training Course is fully online and self-paced, so you don't need to worry about timing. You can set your own schedule to continue the courses. Let's see what are those 10 courses included in this Teacher Training Course - Level 2 Award in Support Work in Schools and Colleges Level 3 Award in Childcare and Education Diploma in Special Education Needs (SEN) EYFS Teaching Diploma Primary Teaching Diploma Teaching Assistant Early Years Level 4 Dyslexia Autism Diploma ADHD Awareness Course Learning Outcomes By the end of this Course, you will be able to - Identify different teaching roles and responsibilities. Become competent to qualify for the QTS test. Be a teacher in your chosen field. Deal with students effectively and efficiently in different settings. Take care of the Special Education Needs and other problems the children face. Why Teacher Training Bundle 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. ***Other Benefits of This Bundle Course*** 10 PDF Certificate Free Expert Tutor Support Lifetime Access Free Retake Exam [ Course 01 ] Level 2 Award in Support Work in Schools and Colleges Module 01: Understand Schools and Colleges as Organisations Module 02: Understand Children and Young People's Development Module 03: Understand Communication and Professional Relationships with Children, Young People and Adults Module 04: Understand Children and Young People's Health and Safety Module 05: Safeguarding Children and Young People Module 06: Understand Equality, Diversity and Inclusion in Work with Children and Young People -------------------------------- [ Course 02 ] Level 3 Award in Childcare and Education Module 1: Child Development from Conception to Seven Years Module 2: Children's Health and Wellbeing -------------------------------- [ Course 03 ] Diploma in Special Education Needs (SEN) Module 01: Introduction Module 02: A Quick Overview of the New SEND Code of Practice Module 03: Legislation Related to SEN Module 04: SEN Assessments and Descriptors Module 05: Education for Children with Disabilities Module 06: Common SEN Conditions Found Within Mainstream Schools and many more... -------------------------------- [ Course 04 ] EYFS Teaching Diploma Module 01: An Overview of EYFS Module 02: Significance of Early Years in Development Module 03: Teaching Techniques Focusing EYFS Module 04: Curriculum for EYFS Teaching Module 05: EYFS Teaching Career Module 06: Fostering Learning and Development Module 07: Children Having Special Education Needs or Disabilities Module 08: Guiding Parents to the Early Years Foundation Stage Module 09: Safety Requirements And many more... -------------------------------- [ Course 05 ] Primary Teaching Diploma Module 01: Primary Education in the UK Module 02: Responsibilities, Qualifications and Skills Module 03: Initial Teacher Training Module 04: Types of Schools in the UK Module 05: Importance of Early Years in Development Module 06: EYFS Teaching Techniques Module 07: Teaching Primary English [ Course 06 ] -------------------------------- Teaching Assistant Module 01: Roles and Responsibilities of the Teaching Assistant Module 02: Working in the School Module 03: Working in the Classroom Module 04: Promote Children and Young people's Positive Behaviour Module 05: Support Children and Young People's Health and Safety Module 06: EYFS Teaching Techniques Module 07: Teaching Primary English Module 08: Teaching Primary Mathematics Module 09: Teaching Primary Science, Design and Technology Module 10: Teaching Other Primary Subjects And many more... -------------------------------- [ Course 07 ] Early Years Level 4 Module 1: Supporting the Emotional and Physical Well-being of Children Module 2: Equality, Diversity and Professional Partnerships Module 3: Health and Safety Legislation Module 4: Observations, Assessments and Planning Module 5: Safeguarding Children Module 6: The Early Years Foundation Stage Module 7: Managing in a Nursery Environment Module 8: Engaging in Professional Development ------------------------------------- [ Course 08 ] Level 3 Dyslexia Awareness Module 01: An Overview of Dyslexia Module 02: Learning Difficulties Due to Dyslexia Module 03: Impact of Dyslexia in the Educational Setting Module 04: Helping Adults with Dyslexia Module 05: Dyslexia in the Workplace Module 06: Approaches in Dyslexia Module 07: Dyslexia Strengths and Rewards Module 08: Assessment and Evaluation of Dyslexia Module 09: Dyslexia Friendly Learning Environment Module 10: Relevant Laws for Dyslexia -------------------------------- [ Course 9 ] Autism Diploma Course Module 01: Introduction to Autism Spectrum Disorder (ASD) Module 02: Approaches to Helping People and Children with Autism Module 03: Diagnosis of Autism Module 04: Communication Module 05: Cognitive Styles and Functions in Autism Module 06: Autistic Behaviour Module 07: Organisation Systems with Autistic Individuals Module 08: Autism Awareness Module 09: Government Policies on Autism in England -------------------------------- [ Course 10: ] ADHD Awareness Course Module 01: Overview of ADHD Module 02: The Experience of Treatment and Care for ADHD Module 03: Families and ADHD Module 04: Psychological Interventions for Children with ADHD in Educational Settings and Parent Training Module 05: ADHD and Attention Difficulties Module 06: Cognitive Approaches in ADHD Module 07: The Organisation of Care for ADHD Assessment Method After completing each module of Teacher Training Bundle Course, 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 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 Bundle Course is ideal for you to become a teacher in any setting. Moreover, existing teachers will also benefit from this Teacher Training Bundle Course by enriching their knowledge and skills. Requirements There is no specific requirement to enrol for this Bundle Course. However, you need to be over 16. Besides, to gain the best out of this Teacher Training Bundle Course, you must have a strong passion for becoming a teacher. Career path You can become skilled in different teaching professions with this Teacher Training Bundle Course. Such as - Primary Teacher Primary Teaching Assistant Teaching Assistant EYFS Teacher Nursery Nurse SEN Teacher Certificates Certificate of completion Digital certificate - Included

Teacher Training - Course
Delivered Online On Demand3 days
£59

Photography Course

By KEMP CENTER

Develop your graphic design skills and learn the professional Photoshop tools and techniques Get confident with your camera Have you always wanted to learn more about photography? Do you want to learn the ins and outs of taking professional photos? Look no further! With this photography course, you will learn it all. Get to know different genres, styles, and approaches to photographyy as well as the indispendable technical knowledge and practical skills ready-to-use in your everyday work. This course will take you from beginner to competent photographer with the guidance of some of the best photographers in the industry. Whether you love photography as a hobby, want to be a professional studio photographer, or want the best shots for social media profiles, this course has it all. From this photography course, you will learn the basics of photography and build a foundation of knowledge before progressing to more advanced photography skills. This training is designed for complete beginners as well as those with prior knowledge of some photography concepts who would like to take their understanding deeper. You will learn about everything from camera kit and equipment to composition and working with light. Everything you learn is instantly aplicable to your photography work. Get the knowledg, test your skills and produce high-quality professional photographs. Our photography course experts have compiled their best tips to offer you the most comprehensive photography course. After taking this course you will be comfortable working with different cameras and using them to produce different types of photography. Whether you are new to photography or want to improve your existing skills, this photography course will help you develop the ability to create and share digital images that you can be proud of. You will also develop your technical and visual skills with the help of the tasks on the course to reach a professional working level where you can offer high-quality photography to your clients. The course is a creative mix of learning and practicing through tasks that will strengthen your photographic experience and help you build your first portfolio. The course is full of invaluable content and presented in an easy-to-follow format.  What will you learn from this course? Basic and advanced knowledge of photography Camera equipment Working with light Technical and visual skills in photography Basic knowledge of different branches of photography Who is this course for? Anyone who wants to improve their skills in photography Influencers, social media specialists or graphic designers Anyone who wants to be a professional photographer Or people who want to have great photos from their holidays The world of photography has exploded in recent years and with the forever-growing presence of social media and other platforms, it is set to continue that way. Getting the right shot is important and more and more people are taking a keen interest in photography. If you are one of those people, then you are in the right place! Our photography course is one of the most comprehensive courses that cover all of the basics while teaching advanced photography concepts too. The material shared in the course is developed and designed by experts and covers a wide range of photography topics that will allow you to explore and understand concepts on a deeper level. The course package contains extensive material presented in an engaging format and you will be learning by using specific examples, knowledge repetitions, and varied practical tasks along with a final exam. The course is available to anyone, anywhere, and is delivered on the Kemp Center advanced e-learning platform. It’s time to bring your photos to a whole new level! Join the photography course and get the benefits: Learning from a professional instructor24/7 access from any devicePractical exercisesTests, quizzes and recapsCertificate of completionExtra materials and downloadable bonuses100% satisfaction guarantee Your Singing Instructor: Martin Lee Photographer The course is led by well-known photographers who have been recognized for his outstanding work on projects around the world. Our course instructor has many years of experience working in the photography industry and will be sharing all of his knowledge on everything they have learnt along the way. Our expert has specialized in commercial, fashion, food, portrait and lifestyle photography over the years. He has all of the top tips about working in the industry and have combined their expertise and knowledge to produce an in-depth training so you don’t miss a trick. With the help from our expert you will be guided through all of the necessary techniques and processes required to set yourself apart in a world of constant photography and digital stimulation. He will give you all of the hints and tips about using photography both as a hobby or beginning your professional career and how to break into the industry. Martin has led many photography courses and is passionate about shaping other photographers in the industry to keep up to date with current and emerging trends. Overview of the course: Detailed video presentations 1. Essential knowledge of photography Fundamental photography knowledge Equipment and how to choose the right one that suits your needs and the set Photography scenarios, parameters, features, and settings How to turn your passion into a profession – find success in photography Training videos 1. Photography in practice Working with professional photography studios: Lightroom and Photoshop Creating different types of photography: portrait photography, landscape photography, macro photography Tests 1. Tests and revision of acquired knowledge Basic knowledge of photography Knowledge of specific photography-related aspects and components 2. Final Exam Final test Summary of previously presented knowledge and tasks Course materials Book of Inspiration Best cameras for beginners Wildlife photography- a practical guide How to work with a model during a session Additional materials for use in everyday photography Experience Beginner-IntermediateLanguage English, German, French, Polish, Portuguese A letter from your expert instructor We are pleased to introduce you to a photography course that will change your outlook on this field. This is a course where the instructor is a practitioner, not a theorist, which will allow you to gain practical photography skills.Among other things, you will learn how to use your camera in the right way to be able to get the best pictures out of it. You will also learn about basic processing in Lightroom or Photoshop.With this course, you will learn the basics of photography. What is ISO? How do you catch the light? What are the differences between different types of photography and how to take them correctly? The answers to these questions are included in this course.You will gain solid knowledge that you can back up with a certificate that you receive in hard copy and online.Gain skills for taking better photos with the help of an instructor. See you on the course! Martin Lee – Photographer

Photography Course
Delivered Online On Demand10 hours
£255

Excel 2016 Advanced

By iStudy UK

If you are looking forward to advance your skills with Microsoft Excel 2016 and want to learn more advanced skills or want to learn the topics covered in this course in the 2016 interface, this Excel 2016 Advanced will be the perfect choice for you! Through the course you will gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. Additionally, you will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in your worksheets and workbooks. You will also learn about Excel's many collaboration features, as well as how to import and export data to and from your workbooks. What Will I Learn? Use Advanced IF Statements Use Advanced Lookup Functions Use Complex Logical and Text Functions Auditing Formulas Working with What-If Analysis Tools Protecting Worksheet and Workbook Use Advanced PivotTables and PowerPivot Tools Automate with Macros Work with Form Controls Ensure Data Integrity Collaborate in Excel Import and Export Data to a Text File Requirements Excel Introduction and Intermediate courses or equivalent experience. Who is the target audience? Students who want to expand their Excel knowledge. Introduction Introduction FREE 00:01:00 Using Advanced IF Statements Summarize Data with SUMIF FREE 00:04:00 Summarize Data with AVERAGIF 00:03:00 Summarize Data with COUNTIF 00:02:00 Using Advanced Lookup Functions Using VLOOKUP with TRUE to find an Approximate Match 00:04:00 Using HLOOKUP TRUE to find an Approximate Match 00:01:00 Using the Index Function 00:03:00 Using the Match Function 00:02:00 Creating a Combined Index and Match Formula 00:04:00 Comparing Two Lists with VLOOKUP 00:02:00 Comparing Two Lists with VLOOKUP and ISNA 00:04:00 Using Complex Logical and Text Functions Creating a Nested IF Function 00:03:00 Using the IFERROR Function 00:02:00 Using the LEN Function 00:02:00 Using the TRIM Function 00:01:00 Using the Substitute Function 00:02:00 Formula Auditing Showing Formulas 00:01:00 Tracing Cell Precedents and Dependents 00:03:00 Adding a watch Window 00:02:00 Error Checking 00:02:00 What-If Analysis Tools Using the Scenario Manager 00:03:00 Using Goal Seek 00:02:00 Analyzing with Data Tables 00:02:00 Worksheet and Workbook Protection Protection Overview 00:02:00 Excel File Password Encryption 00:03:00 Allowing Specific Worksheet Changes 00:01:00 Adding Protection to only Certain Cells in a Worksheet 00:03:00 Additional Protection Features 00:02:00 Advanced Use of PivotTables and PowerPivot Using the Pivot Tables Charts Wizard 00:02:00 Adding a Calculated Field 00:02:00 Adding a Caculated Item 00:02:00 Apply Conditional Formatting to a Pivot Table 00:03:00 Using Filters in the Pivot Table Fields Pane 00:02:00 Creating Filter Pages for a Pivot Table 00:01:00 Enabling a Power Pivot Add In 00:04:00 Automating with Macros What are Macros 00:03:00 Displaying the Developer Tab and Enabling Macros in Excel 00:03:00 Creating a Basic Formatting Macro 00:03:00 Running a Macro 00:02:00 Assigning a Macro to a Button 00:02:00 Creating a More Complex Macro 00:02:00 Viewing and Editing the VBA Code for an Existing Macro 00:03:00 Adding a Macro to the Quick Access Toolbar 00:02:00 Working with Form Controls What are Form Controls 00:02:00 Adding Spin Buttons and Check Boxes to a Spreadsheet 00:02:00 Adding a Combo Box to a Spreadsheet 00:02:00 Ensuring Data Integrity What is Data Validation 00:01:00 Restricting Data Entries to Whole Numbers 00:02:00 Data Validation Restricting Data Entry to a List 00:01:00 Data Validation Restricting Data Entry to a Date 00:01:00 Data Validation Restricting Data Entry to Different Text Lengths 00:01:00 Composing Input Messages 00:02:00 Composing Error Alters 00:02:00 Finding Invalid Data 00:02:00 Editing and Deleting Data Validation Rules 00:01:00 Collaborating in Excel Working with Comments 00:03:00 Printing Comments and Errors 00:02:00 Sharing a Workbook 00:03:00 Tracking Changes in a Workbook 00:03:00 Working with Versions 00:02:00 Sharing Files via Email 00:02:00 Importing and Exporting Data to a Text File Importing a Text File 00:03:00 Exporting a Text File 00:01:00 Conclusion Course Recap 00:01:00 Course Certification

Excel 2016 Advanced
Delivered Online On Demand2 hours 21 minutes
£25

Nursery Teacher Course

By Training Tale

You need to become competent and skilled enough to become a teacher in your chosen area. With our Nursery Teacher Course, you will acquire the necessary knowledge and skills and eventually become a qualified teacher in different settings. This Nursery Teacher Course is a bundle of 8 courses. We have sincerely combined these 8 courses with a comprehensive curriculum made by the expert teachers to make this Course highly valuable for you. Depending on your need, you will get dedicated tutor support throughout this Nursery Teacher Course. Our tutors are always happy to assist our learners. So, you need to ask for assistance only! With this Nursery Teacher Course, you will get 8 courses! It means you will get 10 different certificates of achievement once you complete all the courses successfully. Imagine how your CV will be enriched. And the PDF certificates are completely free. With this Course, you will increase your employability skill enormously and stand out from the crowd. So, why do you hesitate? Just enrol on this Nursery Teacher Course, and the rest is on us to make your learning journey a pleasant one. This Nursery Teacher Course is fully online and self-paced, so you don't need to worry about timing. You can set your own schedule to continue the courses. Let's see what are those 8 courses included in this Nursery Teacher Course - Diploma in Special Education Needs (SEN) EYFS Teaching Diploma Primary Teaching Diploma Teaching Assistant Early Years Level 4 Dyslexia Autism Diploma ADHD Awareness Course Learning Outcomes By the end of this Course, you will be able to - Identify different teaching roles and responsibilities. Become competent to qualify for the QTS test. Be a teacher in your chosen field. Deal with students effectively and efficiently in different settings. Take care of the Special Education Needs and other problems the children face. Why Choose Nursery Teacher Course from Training Tale 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 8 certificate as soon as completing the course. ------------------------- Others Benefit Include Nursery Teacher Course 08 PDF Certificate Free Expert Tutor Support Lifetime Access Unlimited Retake [ Note: Free PDF certificate as soon as completing the course ] [ Course 01 ] Diploma in Special Education Needs (SEN) Module 01: Introduction Module 02: A Quick Overview of the New SEND Code of Practice Module 03: Legislation Related to SEN Module 04: SEN Assessments and Descriptors Module 05: Education for Children with Disabilities Module 06: Common SEN Conditions Found Within Mainstream Schools and many more... ----------------------------- [ Course 02 ] EYFS Teaching Diploma Module 01: An Overview of EYFS Module 02: Significance of Early Years in Development Module 03: Teaching Techniques Focusing EYFS Module 04: Curriculum for EYFS Teaching Module 05: EYFS Teaching Career Module 06: Fostering Learning and Development Module 07: Children Having Special Education Needs or Disabilities Module 08: Guiding Parents to the Early Years Foundation Stage Module 09: Safety Requirements And many more... ----------------------------- [ Course 03 ] Primary Teaching Diploma Module 01: Primary Education in the UK Module 02: Responsibilities, Qualifications and Skills Module 03: Initial Teacher Training Module 04: Types of Schools in the UK Module 05: Importance of Early Years in Development Module 06: EYFS Teaching Techniques Module 07: Teaching Primary English ----------------------------- [ Course 04 ] Teaching Assistant Module 01: Roles and Responsibilities of the Teaching Assistant Module 02: Working in the School Module 03: Working in the Classroom Module 04: Promote Children and Young people's Positive Behaviour Module 05: Support Children and Young People's Health and Safety Module 06: EYFS Teaching Techniques Module 07: Teaching Primary English Module 08: Teaching Primary Mathematics Module 09: Teaching Primary Science, Design and Technology Module 10: Teaching Other Primary Subjects And many more... ----------------------------- [ Course 05 ] Early Years Level 4 Module 1: Supporting the Emotional and Physical Well-being of Children Module 2: Equality, Diversity and Professional Partnerships Module 3: Health and Safety Legislation Module 4: Observations, Assessments and Planning Module 5: Safeguarding Children Module 6: The Early Years Foundation Stage Module 7: Managing in a Nursery Environment Module 8: Engaging in Professional Development ----------------------------- [ Course 06 ] Dyslexia Module 01: An Overview of Dyslexia Module 02: Learning Difficulties Due to Dyslexia Module 03: Impact of Dyslexia in the Educational Setting Module 04: Helping Adults with Dyslexia Module 05: Dyslexia in the Workplace Module 06: Approaches in Dyslexia Module 07: Dyslexia Strengths and Rewards Module 08: Assessment and Evaluation of Dyslexia Module 09: Dyslexia Friendly Learning Environment Module 10: Relevant Laws for Dyslexia ----------------------------- [ Course 07 ] Autism Diploma Course Module 01: Introduction to Autism Spectrum Disorder (ASD) Module 02: Approaches to Helping People and Children with Autism Module 03: Diagnosis of Autism Module 04: Communication Module 05: Cognitive Styles and Functions in Autism Module 06: Autistic Behaviour Module 07: Organisation Systems with Autistic Individuals Module 08: Autism Awareness Module 09: Government Policies on Autism in England ----------------------------- [ Course 08 ] ADHD Awareness Course Module 01: Overview of ADHD Module 02: The Experience of Treatment and Care for ADHD Module 03: Families and ADHD Module 04: Psychological Interventions for Children with ADHD in Educational Settings and Parent Training Module 05: ADHD and Attention Difficulties Module 06: Cognitive Approaches in ADHD Module 07: The Organisation of Care for ADHD Assessment Method Nursery Teacher Course After completing each module of Nursery Teacher Course, 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 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 Course is ideal for you to become a teacher in any setting. Moreover, existing teachers will also benefit from this Nursery Teacher Course by enriching their knowledge and skills. Requirements There is no specific requirement to enrol for this Course. However, you need to be over 16. Besides, to gain the best out of this Nursery Teacher Course, you must have a strong passion for becoming a teacher. Career path You can become skilled in different teaching professions with this Course. Such as - Primary Teacher Primary Teaching Assistant Teaching Assistant EYFS Teacher Nursery Nurse SEN Teacher

Nursery Teacher Course
Delivered Online On Demand3 days
£35