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

19648 Addition courses in Sheffield delivered Online

Diabetes Awareness Training

4.3(43)

By John Academy

Overview Switching to a sugar-free life can ward off diabetes. But most people are unaware of their diabetic status, which may lead to severe health conditions if not treated. In this Diabetes Awareness Training, you'll learn how to raise awareness about diabetes and help people fight for their future.  Through this Diabetes Awareness Training, you'll gain a solid understanding of the types, symptoms, risk factors and treatments of diabetes. From the interactive lessons, you'll identify the challenges in managing diabetes and how to overcome them. In addition, you'll know about type 1 and type 2 diabetes and their treatment options.  This advanced course will also teach you about prediabetes, gestational diabetes and many other types of diabetes and explain how their treatment plans differ. Again, you'll learn to identify the symptoms of hypoglycemia and provide immediate treatment. Course Preview Learning Outcomes Determine the challenges of diabetes management. Find a comprehensive overview of type 1 and type 2 diabetes and their treatments. Learn how to identify the warning signs of prediabetes Know the process for treating gestational diabetes Understand how to diagnose and treat hypoglycemia Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email Who Should Take this Diabetes Awareness Training? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Diabetes Awareness Training is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Diabetes Awareness Training Certification After completing and passing the Diabetes Awareness Training successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Path​ The Diabetes Awareness Training provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: General Nurse Health and Social Care Workers Carers Midwives Other Health Care Professionals Module 01: What is Diabetes What is Diabetes 00:45:00 Module 02: The Diabetes Challenge The Diabetes Challenge 00:27:00 Module 03: The Cost of Diabetes in Social Care The Cost of Diabetes in Social Care 00:19:00 Module 04: Type 1 Diabetes Type 1 Diabetes 00:23:00 Module 05: Type 2 Diabetes Type 2 Diabetes 00:26:00 Module 06: Type 2 Diabetes Treatments Type 2 Diabetes Treatments 00:28:00 Module 07: Prediabetes Prediabetes 00:12:00 Module 08: Gestational Diabetes Gestational Diabetes 00:24:00 Module 09: Other Types of Diabetes Other Types of Diabetes 00:14:00 Module 10: Hypoglycaemia Hypoglycaemia 00:20:00 Module 11: Hyperglycaemia and Hyperosmolar Hyperglycaemic State Hyperglycaemia and Hyperosmolar Hyperglycaemic State 00:33:00 Module 12: Glossary of Diabetes Terms Glossary of Diabetes Terms 00:57:00 Assignment Assignment - Diabetes Awareness (Type 1 & 2) 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Diabetes Awareness Training
Delivered Online On Demand5 hours 28 minutes
£24.99

Dementia Awareness Course

4.3(43)

By John Academy

Overview It is projected that the number of dementia patients will rise to 6 million people by 2040 in the UK. To cater to such a large number of people, a large number of skilled workforce is required. If you care currently looking for well-paid career with high demand, this sector will be a good call for you. You can learn the vitals of pursuing a career in this sector with our exclusive Dementia Awareness Course. This course is packed with valuable information on dementia. From the informative modules, you will learn about the different types and stages of dementia. The course will enable you to understand both pharmaceutical and psychological treatments for dementia. Furthermore, you will be able to attain the expertise required for dementia care. In addition, the course will ensure you are well aware of the dementia care act and legislation. Course Preview Learning Outcomes Learn about the different types and stages of dementia Build the expertise to assess dementia Gain an in-depth understanding of the pharmaceutical and psychological treatment for dementia Acquire the skills required for providing care to dementia patients Familiarise yourself with the dementia care act and legislation Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email What Skills Will You Learn from This Course? Caregiving for Dementia Dementia Assessment Who Should Take this Dementia Awareness Course?? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Dementia Awareness Course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Dementia Awareness Course Certification After completing and passing the Dementia Awareness Course successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Path​ This exclusive Dementia Awareness Course will equip you with effective skills and abilities and help you explore career paths such as  Caregiver Social Worker Care Home Worker Module 01: Defining Dementia Defining Dementia 00:25:00 Module 02: The Brain and How Dementia Affects It The Brain and How Dementia Affects It 00:20:00 Module 03: Types of Dementia Types of Dementia 00:20:00 Module 04: Stages of Dementia Stages of Dementia 00:20:00 Module 05: Assessing Dementia Assessing Dementia 00:25:00 Module 06: Pharmaceutical Treatment for Dementia Pharmaceutical Treatment for Dementia 00:25:00 Module 07: Psychological Treatment for Dementia Psychological Treatment for Dementia 00:25:00 Module 08: Raising Awareness and Preventing Dementia Raising Awareness and Preventing Dementia 00:25:00 Module 09: Caregiving for Dementia Caregiving for Dementia 00:20:00 Module 10: Dementia Care: Acts and Legislation Dementia Care Acts and Legislation 00:20:00 Assignment Assignment - Dementia Awareness 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Dementia Awareness Course
Delivered Online On Demand3 hours 45 minutes
£24.99

Critical Thinking & Decision Making Course

4.3(43)

By John Academy

Overview The ability to use critical thinking can take you a long way in both your personal and professional life. Learn this valuable skill set and enhance your potential with our exclusive Critical Thinking & Decision Making Course. This is the ultimate training ground for those who have little understanding of how to use the power of critical thinking. In this course, you will learn about the significance of critical thinking in your life. The course will help you identify the benefits and the challenges associated with critical thinking. In addition, you will develop a comprehensive understanding of the steps of thinking creatively. Furthermore, the course will show you the strategies to use critical thinking for problem-solving and decision making.  So, if you want to master this winning skill set, enrol today and start learning! Course Preview Learning Outcomes Familiarise yourself with the advantages and obstacles of critical thinking Understand the significance of critical thinking Comprehend the major steps of the critical thinking process Learn the strategies to solve problems and make decisions using critical thinking Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email What Skills Will You Learn from This Course? Critical Thinking Problem-Solving Decision Making Who Should Take this Critical Thinking & Decision Making Course? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Critical Thinking & Decision Making Course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Critical Thinking & Decision Making Course Certification After completing and passing the Critical Thinking & Decision Making Course successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Path​ This exclusive Critical Thinking & Decision Making Course will equip you with effective skills and abilities and help you explore career paths such as  Business person Lawyer Engineer Doctors Officers Module 01: Introduction To Critical Thinking Introduction to Critical Thinking 00:23:00 Module 02: Critical Thinking And The Judgment Of Claims Critical Thinking and the Judgment of Claims 00:19:00 Module 03: Benefits And Barriers Of Critical Thinking Benefits and Barriers of Critical Thinking 00:32:00 Module 04: Importance Of Critical Thinking Importance of Critical Thinking 00:17:00 Module 05: Recognising A Critical Thinker Recognising a Critical Thinker 00:23:00 Module 06: What Are The Critical Thinking Steps? What Are the Critical Thinking Steps 00:17:00 Module 07: Critical Thinking Strategies Critical Thinking Strategies 00:25:00 Module 08: Problem-Solving Through Critical Thinking Problem-Solving Through Critical Thinking 00:25:00 Module 09: Decision Making With Critical Thinking Decision Making with Critical Thinking 00:26:00 Assignment Assignment - Decision Making And Critical Thinking 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Critical Thinking & Decision Making Course
Delivered Online On Demand3 hours 27 minutes
£24.99

Introduction Into Dropshipping on eBay

4.3(43)

By John Academy

Overview Acquire the skills and strategies to establish a successful dropshipping business through the Introduction Into Dropshipping on eBay course.  Introduction Into Dropshipping on eBay course will introduce you to the essentials of dropshipping, such as - opening eBay and PayPal accounts, finding suppliers and products. It also includes pricing strategies and techniques to optimise listing & images for maximum exposure. You'll also learn about the retail arbitrage process, finding retail liquidation suppliers and getting working capital with no credit check.  In addition, you will gain expertise in importing and creating your own brand with the help of the best research tools, finding profitable categories on eBay, creating an LLC and many more resources. So enrol today in Introduction Into Dropshipping on eBay course and get a set closer to building your business empire! Learning Outcomes  Understand the core concepts of dropshipping and eBay business models Learn the steps to create an eBay and PayPal account Grasp the strategies of finding products and suppliers for your dropshipping business Enrich your understanding of retail liquidation and retail arbitrage Develop the skills to create your own brand Learn how to create an LLC for your business Who Should Take this Introduction Into Dropshipping on eBay Course? The Introduction Into Dropshipping on eBay course will give you an in-depth understanding of dropshipping, importing & creating your brand. If you want to build a successful online business, this course will help you develop the essential skills and competencies. Why Choose This Introduction Into Dropshipping on eBay Course By John Academy? Affordable, well-structured and high-quality e-learning study materials Engaging tutorial videos, materials from the industry-leading experts Opportunity to study in a user-friendly, advanced online learning platform Efficient exam systems for the assessment and instant result UK & internationally recognised accredited qualification Access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities 24/7 student support via email. Assessment Method At the end of the course, you will be required to sit for an online multiple-choice test. Your test will be assessed automatically and immediately. That means you will instantly know whether you have been successful. But don't worry, before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at £39 or in PDF format at £24.  Introduction Into Dropshipping on Ebay Introduction Into The Ebay Business Models 00:04:00 Dropshipping 101 00:04:00 Developing The Right Mindset 00:08:00 How To Create Your Ebay & Paypal Account 00:06:00 How To Find Suppliers For Your Dropshipping Business 00:06:00 How To Find Products For Your Dropshipping Business 00:06:00 Optimizing Your Listing For Maximum Exposure 00:09:00 How To Properly Optimize Your Image Listings 00:04:00 How To Properly Price Your Products 00:07:00 Introduction into Retail Liquidation & Retail Arbitrage The Retail Arbitrage Process 00:09:00 How To Find Retail Liquidation Suppliers 00:08:00 How To Find Retail Liquidation Suppliers Part 2 00:05:00 How To Get Working Capital For Your Business With NO Credit Check! 00:06:00 Introduction Into Importing & Creating Your Own Brand The Best Research Tool For Importing On Ebay 00:08:00 Find The Top Sellers In Every Category On Ebay 00:05:00 Narrowing Down Your Niche Selection 00:05:00 How To Find The Most Profitable Categories On Ebay 00:07:00 Navigating Through Alibaba & Getting Samples 00:05:00 Another Resource To Find Products 00:11:00 Private Label Brand Example 00:10:00 How To Find Outsourcers To Free Up Your Time 00:08:00 Creating An LLC For Your Business 00:05:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Introduction Into Dropshipping on eBay
Delivered Online On Demand2 hours 26 minutes
£25

Mental Health Course

By iStudy UK

In the present pressurized and the quick moving world, many individuals are encountering challenges in keeping up high mental well-being. Regardless of whether you are looking towards enhancing your emotional well-being or you work in a setting where supporting others to meet their psychological well-being needs, this course will give you a firm establishment on which to build. It is the fact that mental health issues and problems are prevalent however help and prevention is always available. People who are suffering from mental health concerns and challenges have a great chance to get better and recover completely. This course is designed to familiarise you with the warning signs of having mental health issues and problems. In addition to this, you will be introduced to practical and useful ways of how you can maintain your positive and productive mental health. You will learn how to develop your coping skills, getting enough hours of sleep, help others, get physically fit and active, stay positive, connect with other people and most importantly get professional advice and help from experts. Course Highlights Mental Health Course is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Mental Health Course into 6 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 3 hours, 25 minutes and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Mental Health Course Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Mental Health Course is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Mental Health Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Mental Health Course Mental Health Basics FREE 00:30:00 Are you Resilient FREE 00:30:00 Take Good Care of Yourself 00:30:00 Healthy Relationships 00:30:00 Risk Factors 00:15:00 When Do You Need to See a Professional? 00:30:00 Mock Exam Mock Exam-Mental Health Course 00:20:00 Final Exam Final Exam-Mental Health Course 00:20:00

Mental Health Course
Delivered Online On Demand3 hours 25 minutes
£25

First Aid

By iStudy UK

First Aid Course Overview Being familiar with the fundamentals of first aid is a must, whether you're at home or at work. It's never too late to start training since you never know when you might need to save a life. The goal of this first aid course is to familiarise you with both the basic and advanced concepts of first aid, including how to handle potentially fatal situations and how to examine an injured person from head to toe. Everyone can benefit from our First Aid course, which features professional audiovisual presentations, simple-to-follow modules, and useful guidance for low-risk work environments including restaurants, stores, and offices. First aid kits, the recovery posture, performing CPR, and managing follow-up ailments including allergies and asthma are important subjects. You will study the items of the first aid bag in detail and gain knowledge of the duties and responsibilities of a first aider through case studies and hands-on exercises. You will be guided through the steps and best practices for handling a variety of minor and significant injuries by our knowledgeable educator. In addition to learning first aid skills for adults, this course will teach you how to modify and use basic first aid techniques for a child or baby. Upon completion of this course, you will possess exceptional theoretical and practical expertise, enabling you to assume command in the event of a first aid emergency. As evidence of your new abilities and assurance that you are implementing the appropriate safety precautions for your company or workplace, you will also obtain a CPD-approved certificate. Why You Should Choose First Aid Course Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? First Aid Course is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our First Aid Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. First Aid Module 01: Basic First-Aid Techniques Basic First-Aid Techniques 00:20:00 Module 02: Incident Management at Work Incident Management at Work 00:25:00 Module 03: Primary Survey Primary Survey 00:15:00 Module 04: Secondary Survey Secondary Survey 00:15:00 Module 05: Paediatric First Aid for Common Illnesses, Injuries and Incidents Paediatric First Aid for Common Illnesses, Injuries and Incidents 00:38:00 Module 06: First Aid for Acute Medical Conditions First Aid for Acute Medical Conditions 00:22:00 Module 07: Loss of Responsiveness and CPR Loss of Responsiveness and CPR 00:20:00 Module 08: Medical Emergency Medical Emergencies 00:16:00 Module 09: Things to Keep in Mind Things to Keep in Mind 00:15:00

First Aid
Delivered Online On Demand3 hours 6 minutes
£25

Resume Writing Course

By The Teachers Training

Resume Writing 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 Resume Writing 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 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. Course Introduction Intro and Tips to the Course 00:04:00 General Tips Introduction to General Tips 00:01:00 Words to Avoid 00:10:00 Writing Tip Show Don't tell 00:12:00 Writing Tip Get with the Action 00:10:00 Final Writing Tip 00:02:00 Resume Length 00:02:00 Content: Heading and Top Spot Content Introduction 00:01:00 Heading 00:03:00 Top Spot Objective Versus Career Summary 00:04:00 Top Spot Objective Function and Writing Tips 00:08:00 Top Spot Career Summary Function and Writing Tips 00:09:00 Top Spot How to write an effective career summary 00:26:00 Content: Experience and Education Section Experience Introduction and Selecting Experiences to Include 00:05:00 Experience Headings and Summary 00:05:00 Experience Description of Accomplishments 00:21:00 Experience: Food for thought 00:05:00 Education Section 00:10:00 Content: Optional Sections Optional Section Activities Awards Leadership Honors 00:09:00 Activities/Awards Clarification 00:05:00 Optional Section Skills 00:04:00 Skills Clarification 00:05:00 Optional Section Certification License 00:01:00 Design and Layout Introduction to Design 00:01:00 Main Design Graphics and Element Layout 00:07:00 Designer's Tools Typography and Appropriate White Space 00:07:00 Final Tips Just flip it, Organize, and Bullets 00:04:00 Artsy Resumes 00:05:00 Bonus: Watch me Transform a Resume Step-by-Step Transforming a resume steps 1-4 00:19:00 Continuing transforming a resume steps 5-12 00:16:00

Resume Writing Course
Delivered Online On Demand3 hours 41 minutes
£27.99

Excel Crash Course

By The Teachers Training

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

Excel Crash Course
Delivered Online On Demand2 hours 48 minutes
£27.99

Personal Development Training

By The Teachers Training

Personal Development Training 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 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 02 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. Self awareness breeds CONFIDENCE and self-esteem YOO Promo 00:02:00 Introduction to the Yoo Course 00:05:00 How the Course works 00:03:00 Advice from ancient Greece - Know Thyself! 00:04:00 Jung's main psychological types 00:06:00 It's your preference - in colour! 00:03:00 More about the colourful behavioural model 00:06:00 You on a bad day (The Dark Side) 00:04:00 What people say about you when you're not there 00:06:00 Owning your weaknesses 00:07:00 Confidence building is a journey - not an event 00:05:00 Reading and connecting with others for the best RELATIONSHIPS How a new relationship develops 00:03:00 How to understand and build Rapport 00:04:00 The remaining 3 'R's of relationship development 00:04:00 Reading body language, vocal tone and content 00:06:00 Communicating with the four main personality types 00:05:00 The 5 love languages for understanding those close to you 00:04:00 The top 5 relationship tips 00:06:00 Some relationship hacks and shortcuts - use with care! 00:06:00 Emotional intelligence builds resilience and helps us through life's CHANGES Understanding Emotional Intelligence 00:05:00 Recognising, expressing and regulating emotions 00:05:00 What is within your power? 00:06:00 Choices: Wisdom from a whining dog 00:05:00 A personal lesson in mental and emotional resilience 00:05:00 Nine hundred and fifty three; the most important number ever 00:04:00 Telling yourself a different story 00:07:00

Personal Development Training
Delivered Online On Demand2 hours 6 minutes
£27.99

Level 2 Certificate in Crisis Management Training

By The Teachers Training

Level 2 Certificate in Crisis Management Training  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 Level 2 Certificate in Crisis Management Training 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. Module One: Getting Started Crisis Management 00:01:00 Getting Started 00:01:00 Module Two: Crisis Crisis 00:04:00 Crisis Case Study 00:01:00 Module Three: Workplace Violence Workplace Violence 00:04:00 Workplace Violence Case Study 00:01:00 Module Four: Myths Myths 00:04:00 Myths Case Study 00:01:00 Module Five: Escalation Escalation 00:05:00 Escalation Case Study 00:01:00 Module Six: Concerning Behaviors Concerning Behaviours 00:04:00 Concerning Behaviours Case Study 00:01:00 Module Seven: Domestic Violence Indicators Domestic Violence Indicators 00:04:00 Domestic Violence Indicators Case Study 00:01:00 Module Eight: Triggers of Workplace Violence Triggers of Workplace Violence 00:04:00 Triggers of Workplace Violence Case Study 00:01:00 Module Nine: Conflict Dangers Conflict Dangers 00:04:00 Conflict Dangers Case Study 00:01:00 Module Ten: Response Response 00:05:00 Response Case Study 00:01:00 Module Eleven: Strategies Strategies 00:05:00 Strategies Case Study 00:01:00 Closing 00:01:00

Level 2 Certificate in Crisis Management Training
Delivered Online On Demand56 minutes
£27.99