42828 Learning courses in Bristol delivered Online

Course Overview Unlock the transformative power of Neuro-Linguistic Programming (NLP) with this dynamic course designed to equip learners with practical frameworks for personal and professional development. Covering the core principles, models, and techniques of NLP, this training enables individuals to improve communication, enhance self-awareness, and foster behavioural change. Learners will explore how language and thought patterns influence actions, developing strategies to set goals, resolve conflicts, and build better relationships. Whether you are looking to enrich your leadership skills, strengthen your emotional intelligence, or support others through coaching, this course offers valuable tools that can be immediately applied across a variety of settings. By the end of the programme, learners will have a solid foundation in NLP methodologies, with the ability to analyse behaviours, shape outcomes, and inspire transformation in themselves and others. Course Description The NLP Training course offers a comprehensive exploration of the foundational theories and practical applications of Neuro-Linguistic Programming. Learners will delve into key topics such as sensory acuity, representational systems, rapport-building, reframing techniques, and anchoring positive states. Through a structured and engaging learning experience, participants will uncover how internal language patterns affect emotional and behavioural responses, and how these can be influenced for personal advancement or supporting others. Emphasis is placed on building a flexible mindset, enhancing communication skills, and mastering strategies for behavioural change. Suitable for both newcomers and professionals across various fields, the course fosters critical thinking and effective interaction techniques. On completion, learners will have developed a strong command of NLP tools, empowering them to foster positive change, support professional growth, and improve interpersonal dynamics in multiple settings. Course Modules Module 01: Introduction to Neuro-Linguistic Programming Module 02: Understanding Human Communication and Behaviour Module 03: Building Rapport and Enhancing Relationships Module 04: Language Patterns and Persuasion Techniques Module 05: Anchoring and Emotional State Management Module 06: Setting Goals and Achieving Outcomes with NLP (See full curriculum) Who is this course for? Individuals seeking to enhance personal and professional communication. Professionals aiming to improve leadership and coaching skills. Beginners with an interest in behavioural psychology and communication models. Anyone aspiring to build stronger relationships and promote positive change. Career Path Life Coach NLP Practitioner Human Resources Specialist Counselling and Mental Health Support Worker Training and Development Professional Sales and Marketing Executive Leadership and Management Consultant

Course Overview This Yoga Training course offers a comprehensive introduction to the principles, history, benefits, and diverse styles of yoga. Designed for learners of all backgrounds, the course provides a well-rounded understanding of yoga's evolution and its significant impact on physical and mental wellbeing. Participants will gain valuable insights into the therapeutic benefits of yoga, its philosophical foundations, and various styles practised globally today. Through clear and structured learning, this course highlights how yoga can contribute to improved balance, flexibility, mindfulness, and stress management. By the end of the training, learners will be well-equipped with essential theoretical knowledge, enabling them to pursue personal growth, introduce yoga into their daily routines, or take the first step towards a deeper exploration of this ancient discipline. Whether aiming for personal enrichment or professional development, this course offers practical value and inspiring outcomes for a diverse range of learners. Course Description Yoga Training: Benefits & Styles delves into the fascinating history, principles, and evolution of yoga, exploring its transformation from ancient spiritual practice to modern wellness discipline. Learners will study the key benefits of yoga, understand its influence on physical and mental health, and explore a variety of traditional and contemporary yoga styles. The course provides a structured overview, introducing different approaches to yoga, their unique features, and cultural significance. Through a carefully curated syllabus, learners will develop a firm understanding of foundational yoga concepts without needing any prior experience. Emphasis is placed on theoretical knowledge, enabling participants to appreciate yoga as a holistic practice that enhances body awareness, stress management, and mental clarity. Upon completion, learners will possess a strong knowledge base, preparing them for further exploration in yoga education or for applying yoga techniques meaningfully in personal or professional contexts. Course Modules Module 01: Introduction - Benefits - History Module 02: More On Yoga Module 03: Still More On Yoga Module 04: Conclusion (See full curriculum) Who is this course for? Individuals seeking to enhance their physical and mental wellbeing through yoga. Professionals aiming to expand their knowledge of holistic wellness practices. Beginners with an interest in understanding the foundations and styles of yoga. Enthusiasts wishing to incorporate yoga theory into personal development goals. Career Path Yoga Instructor (following further practical certification) Wellness Consultant Health and Lifestyle Coach Mindfulness Facilitator Corporate Wellness Adviser Holistic Therapy Assistant

Course Overview The Hairdressing and Barbering course offers a comprehensive introduction to the key skills and techniques required in the hair and beauty industry. This course covers essential areas such as hair cutting, styling, and shampooing, providing learners with the foundation necessary for a successful career. By the end of the course, students will have a solid understanding of hairdressing and barbering practices, enabling them to deliver high-quality services. Learners will gain confidence in applying industry-standard techniques and develop a keen eye for customer service. Whether you are new to the field or looking to expand your knowledge, this course is designed to equip you with the necessary skills to thrive in the ever-evolving hairdressing and barbering sector. Course Description This course delves into key topics, including the fundamentals of hair cutting, various hair styling techniques, and the best practices for shampooing. Learners will explore different hair types, cutting methods, and modern styles to meet client needs. The course also highlights essential customer service skills and professional conduct in the hairdressing and barbering industry. The learning experience is structured to guide participants through theory and practice, ensuring that they not only understand the theory behind hairdressing techniques but also develop an appreciation for customer interaction, professionalism, and time management in a salon environment. The aim is to ensure that learners are well-prepared for future roles within the industry, ready to provide excellent services to clients. Course Modules Module 01: Introduction Overview of hairdressing and barbering industry Health and safety standards in the workplace Customer service expectations Module 02: Hair Cutting Techniques for different hair types Scissors and clippers usage Creating various haircuts and styles Module 03: Hair Styling Styling tools and products Creating various styles for different occasions Understanding client preferences and matching styles Module 04: Shampooing Proper techniques for washing and conditioning hair Scalp care and treatments Selecting the right products for different hair types (See full curriculum) Who is this course for? Individuals seeking to start a career in hairdressing and barbering Professionals aiming to enhance their hair styling skills Beginners with an interest in the hair and beauty industry Those looking to expand their customer service and salon management skills Career Path Hairdresser Barber Salon Assistant Freelance Stylist Customer Service Representative in Haircare

Course Overview This comprehensive course on "Complete After Effects for Graphic Design" is designed to equip learners with the skills necessary to use After Effects effectively in graphic design. Covering everything from creating visual effects and patterns to generating artwork from scratch, this course helps learners develop a deep understanding of After Effects tools and techniques. Learners will gain the confidence to create sophisticated animations and special effects that enhance their design projects. With practical lessons and a focus on industry-relevant skills, this course provides invaluable value to anyone looking to strengthen their graphic design capabilities using After Effects. Course Description In this course, learners will dive deep into the essential features of After Effects, including creating special effects, working with patterns and textures, and generating artwork from minimal input. The course takes a structured approach, starting with a solid introduction to After Effects, followed by advanced techniques for creating visually engaging content. By the end of the course, learners will be able to produce impressive animations and effects for use in graphic design projects. Throughout the course, learners will refine their understanding of animation principles and the software's advanced features, equipping them with the skills to implement creative ideas in a professional context. Course Modules Module 01: Introduction Introduction to After Effects interface Understanding key concepts in animation and motion design Navigating the timeline and workspace Module 02: Creating Special Effects Using effects and presets Creating cinematic effects for design Layering techniques and animation adjustments Module 03: Creating Patterns and Textures Working with textures and patterns Developing seamless loops and animated backgrounds Customising effects to suit design projects Module 04: Generating Artwork from (Almost) Nothing Techniques for generating artwork using basic shapes Exploring fractal animations and procedural design Using plugins to expand creative possibilities Module 05: Where to Go from Here Understanding next steps in advancing your After Effects skills Recommended resources for further learning Tips for building a professional portfolio (See full curriculum) Who is this course for? Individuals seeking to enhance their graphic design expertise. Professionals aiming to integrate animation and effects into their design projects. Beginners with an interest in digital design and animation. Designers wishing to improve their proficiency with After Effects. Career Path Graphic Designer Motion Graphics Designer Visual Effects Artist Animation Artist Digital Content Creator

Designing a garden requires a professional garden designer who can provide good design and know how to maintain these aesthetics. This course can assure that you will be skilled in knowing gardening design methods after taking it. If you want to become a professional garden designer or landscape artist then this Level 3 Diploma in Garden Design and Maintenance is perfect for you. You will learn to improve your skills in design and organizing the landscape of your client's garden to reach their high expectations. Course Highlights The price is for the whole course including final exam - no hidden fees Accredited Certificate upon successful completion at an additional cost Efficient exam system with instant results Track progress within own personal learning portal 24/7 customer support via live chat Level 3 Diploma in Garden Design and Maintenance has been given CPD accreditation and is one of the best-selling courses available to students worldwide. This valuable course is suitable for anyone interested in working in this sector or who simply wants to learn more about the topic. If you're an individual looking to excel within this field then Level 3 Diploma in Garden Design and Maintenance is for you. We've taken this comprehensive course and broken it down into several manageable modules which we believe will assist you to easily grasp each concept - from the fundamental to the most advanced aspects of the course. It really is a sure pathway to success. All our courses offer 12 months access and are designed to be studied at your own pace so you can take as much or as little time as you need to complete and gain the full CPD accredited qualification. And, there are no hidden fees or exam charges. We pride ourselves on having friendly and experienced instructors who provide full weekday support and are ready to help with any of your queries. So, if you need help, just drop them an email and await a speedy response. Furthermore, you can check the validity of your qualification and verify your certification on our website at anytime. So, why not improve your chances of gaining professional skills and better earning potential. Assessment and Certification At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39. Career Path Not only does our CPD and CiQ accredited course look good on your CV, setting you apart from the competition, it can be used as a stepping stone to greater things. Further advance your learning, launch a new career or reinvigorate an existing one. On successful completion of this course, you have the potential to achieve an estimated salary of £20,000. The sky really is the limit. Course Curriculum Module 1: Gardening Basics Organic Gardening Basics 00:30:00 Having a Plan 00:30:00 Having the Right Tools 01:00:00 Making your Own Mulch 01:00:00 Natural Pest Control 00:30:00 Organic Fertilizer 01:00:00 Planting 01:00:00 Harvesting 01:00:00 What To Avoid 00:30:00 Benefits of Organic Gardening 01:00:00 Module 2: Organic Gardening Why Garden Organically? 01:00:00 Planning Your Organic Vegetable Garden 00:30:00 Growing Your Organic Vegetable Garden 00:30:00 Why Grow an Organic Herb Garden? 00:30:00 Growing an Organic Herb Garden 00:30:00 You Have Organically Grown Herbs, Now What? 01:00:00 Organic Garden Fertilizers 00:30:00 Organic Gardening Compost 00:30:00 Why Use Organic Pest Control? 01:00:00 How to Control Garden Pests Organically 00:30:00 How to Bring Your Organic Plants Indoors; for Easy Year Round Growth 00:30:00 Organic Container Gardening 01:00:00 Organic Hydroponic Gardening 00:30:00 Module 3: Attracting Butterflies WHY SHOULD YOU ATTRACT BUTTERFLIES? 01:00:00 A BUTTERFLY'S LIFE 01:00:00 PLANNING YOUR BUTTERFLY GARDEN 01:00:00 PLANTS TO ATTRACT BUTTERFLIES 01:00:00 Module 4: Garden Maintenance How to Take Care of your Garden 00:15:00 Beginning Garden Care for the New Homeowner 00:30:00 At Home Remedies for Garden Care 00:30:00 Common Garden Problems And Easy Garden Care Solutions 00:15:00 Dogs Beware: Garden Care for the Dog Friendly Home 00:30:00 Garden Care for all Flower and Vegetable Life 00:30:00 Garden Care for the New Neighbor 00:15:00 Garden Care in All Seasons 00:30:00 What to Look for in Plant Selection 00:15:00 Herb Garden Care: Types, Tricks and Tips for Success 00:30:00 How Not to Care for your Garden: Common Garden Care Mistakes to Avoid 00:15:00 How to Choose and Maintain Annuals 00:30:00 How to Make your Seedlings Grow 00:30:00 How to Make Garden Care a Fun Filled Family Activity 00:15:00 Winter Garden Care 00:30:00 Garden Care for All Corners of Your Yard 00:15:00 Must Have Garden Tools for the Proper Garden Care Year Round 01:00:00 Preparing for a Garden 00:30:00 Proper Care to Garden 00:15:00 So, You Want to Start a Garden? Garden Care 00:30:00 The Best Conditions and Home Remedy Secrets to Rose Garden Care 00:30:00 The Different Kinds of Plant Gardens and How to Care for Each Type 00:15:00 What Type of Garden are you Destined to Have? 00:30:00 Top Nine Garden Care Tips from the Experts 00:15:00 Mock Exam Mock Exam - Level 3 Diploma in Garden Design and Maintenance 00:30:00 Final Exam Final Exam - Level 3 Diploma in Garden Design and Maintenance 00:30:00

Creating a compelling social media hook for your OneNote online course can significantly boost your visibility and attract more learners. Start by crafting a message that highlights the unique benefits of your course, such as its convenience, comprehensive content, and interactive features. Use engaging visuals and testimonials to showcase the value of your course. Leverage the power of storytelling to connect with your audience on an emotional level, making the learning experience relatable and desirable. Tailor your message to fit the platform you're using; for instance, a short and catchy hook for Twitter, a visually appealing post for Instagram, or a detailed and informative article for LinkedIn. Remember to include a clear call-to-action, encouraging potential students to sign up or learn more. By combining these elements, you can create a social media hook that resonates with your target audience and sets your OneNote course apart from the competition.

Overview This comprehensive course on IT Administration and Networking will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This IT Administration and Networking comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this IT Administration and Networking. It is available to all students, of all academic backgrounds. Requirements Our IT Administration and Networking is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 5 sections • 128 lectures • 00:55:00 total length •What is an Operating System: 00:48:00 •Configuring the Operating System: 00:06:00 •What is an Application: 00:10:00 •Using Control Panel: 00:18:00 •Software and Concepts: 00:11:00 •Licensing: 00:06:00 •Using Software: 00:07:00 •Software Tools: 00:10:00 •Software: 00:14:00 •Hardware, Devices, and Peripherals: 00:05:00 •Hardware and Peripherals: 00:07:00 •Storage: 00:12:00 •Connectivity Devices: 00:05:00 •Network Components: 00:09:00 •Identify the Importance of Risk Management: 00:11:00 •Assess Risk: 00:13:00 •Mitigate Risk: 00:24:00 •Integrate Documentation into Risk Management: 00:15:00 •Classify Threats and Threat Profiles: 00:08:00 •Perform Ongoing Threat Research: 00:13:00 •Resources that Aid in Research of Threats: 00:03:00 •Implement Threat Modeling: 00:10:00 •Assess the Impact of Reconnaissance Incidents: 00:11:00 •Performing Reconnaissance on a Network: 00:07:00 •Examining Reconnaissance Incidents: 00:08:00 •Assess the Impact of Social Engineering: 00:11:00 •Assessing the impact of Social Engineering: 00:08:00 •Assessing the Impact of Phishing: 00:03:00 •Types of Wireless Attacks: 00:30:00 •Intrusion Monitoring: 00:08:00 •Wireless Security Risks: 00:22:00 •Authentication Attacks: 00:21:00 •Rogue Devices: 00:04:00 •Public Hotspots: 00:07:00 •Wireless Security Monitoring: 00:21:00 •Device Tracking: 00:18:00 •WLAN Security Infrastructure: 00:38:00 •Management Protocols: 00:23:00 •Other RADIUS Solutions: 00:16:00 •Introduction: 00:30:00 •Child Safety Online: 01:00:00 •Secure Payment Sites: 01:00:00 •Online Banking: 00:30:00 •How To Keep Your Password Safe: 00:30:00 •Common Scams: 01:00:00 •How I Got Pharmed: 01:00:00 •Virus Protection: 01:00:00 •Self Maintenance: 00:30:00 •Personal Information Online: 01:00:00 •Is The Internet Safe?: 00:30:00 •Importance of Cyber Security: 00:30:00 •Spyware Can Destroy: 00:30:00 •How Does Spyware Spread?: 01:00:00 •How To Remove Spyware: 01:00:00 •Anti Spyware Program: 01:00:00 •The Anti Anti-Spyware Programs: 00:30:00 •Research And Learn More: 00:30:00 •Choosing The Best Anti Spyware Tool: 01:00:00 •Computer Security And Spyware: 01:00:00 •The Programs To Avoid: 00:15:00 •Is It Legal?: 00:30:00 •Checklist Of Protection: 00:15:00 •The Information Security Cycle: 00:37:00 •Information Security Controls: 00:36:00 •Authentication Methods: 00:09:00 •Cryptography Fundamentals: 00:56:00 •Security Policy Fundamentals: 00:11:00 •Social Engineering: 00:32:00 •Malware: 00:25:00 •Software-Based Threats: 00:22:00 •Based Threats: 00:39:00 •Wireless Threats and Vulnerabilities: 00:43:00 •Physical Threats and Vulnerabilities: 00:09:00 •Manage Data Security: 00:47:00 •Manage Application Security: 00:55:00 •Manage Device and Host Security: 01:08:00 •Manage Mobile Security: 00:10:00 •A Risk Analysis: 00:17:00 •Implement Vulnerability Assessment Tools and Techniques: 00:05:00 •Scan for Vulnerabilities: 00:27:00 •Mitigation and Deterrent Techniques: 00:19:00 •Respond to Security Incidents: 00:00:00 •Recover from a Security Incident: 00:10:00 •OSI Layers: 00:44:00 •LANs and WANs: 00:14:00 •Network Types: 00:07:00 •Transmissions: 00:36:00 •Cables: 00:41:00 •Fiber Optics: 00:17:00 •Converters and Connectors: 00:27:00 •Wireless Security: 00:15:00 •Authentication.prproj: 00:21:00 •Wireless Security Threats: 00:30:00 •TACACS: 00:10:00 •Keys: 00:26:00 •RADIUS: 00:07:00 •VPN Technologies: 00:16:00 •Tunneling Protocols.prproj: 00:05:00 •Acceptable Use: 01:00:00 •Common Problems: 00:32:00 •Troubleshooting: 00:28:00 •Network Technician Tools: 00:46:00 •Physical and Logical Issues: 00:19:00 •Open or Closed Ports: 00:09:00 •ARP Issues: 00:13:00 •Core Concepts in Healthcare IT: 00:06:00 •EMR EHR Issues: 00:05:00 •Regulations, Standards, and Stakeholders: 00:14:00 •HIPAA Controls and Compliance: 00:08:00 •Roles and Responsibilities: 00:10:00 •Manage Communication and Ethics Issues: 00:15:00 •Legal Best Practices, Requirements, and Documentation: 00:09:00 •Medical Document Imaging: 00:04:00 •Sanitation Management: 00:03:00 •Computing Essentials: 00:05:00 •Networking: 00:33:00 •Manage Servers and Software: 00:27:00 •Hardware Support: 00:14:00 •Set Up a Workstation: 00:08:00 •Troubleshoot Basic IT Issues: 00:15:00 •Troubleshoot Medical IT Issues: 00:20:00 •Implementation of an EMR EHR System: 00:34:00 •Change Control: 00:08:00 •Manage Physical and Logical Security: 00:36:00 •Implement Security Best Practices and Threat Mitigation Techniques: 00:13:00 •Manage Remote Access: 00:06:00 •Manage Wireless Security: 00:15:00 •Perform Backups and Disaster Recovery: 00:16:00

Dive into the enriching world of Gardening and Horticulture. From landscaping design to hydroponics, plant nutrition, and pest management, this course offers comprehensive knowledge and practical skills. Unearth opportunities for a career in this green and growing field.

Overview of Diploma in Caregiving Caregiving is a growing field in the UK. Over 12 million people are 65 or older. This means there's a big need for trained caregivers. This Diploma in Caregiving teaches you how to care for adults. You can work in their homes or care settings. The course covers many important topics. These include adult care, medication management, and keeping vulnerable people safe. Our course covers many important topics. You will learn to safeguard vulnerable adults, communicate effectively in care settings, and prevent infections. We also teach adult nursing and basic life support so that you will be ready for emergencies.   Communication is key in caregiving. This course shows you how to talk well with the people you care for. You'll also learn how to work with adults at different life stages. Each stage has its own needs. The course helps you understand these needs. This knowledge will make you a better caregiver.  This course is perfect for anyone who wants to work in adult care. It is also great for those interested in domiciliary care and home caregiving. If you want to understand the basics of caregiving or improve your skills in adult nursing, this course is for you. It is also ideal for those who care about safeguarding and supporting vulnerable adults.  Join us today and take the first step toward a meaningful career in caregiving. With our Diploma in Caregiving, you will be ready to meet the growing demand for skilled caregivers in the UK. Start your journey now and make a positive impact on the lives of those in need. Get a Quick Look at The Course Content: This Diploma in Caregiving Course will help you to learn: Understand adult care across different life stages. Apply safety protocols in domiciliary care settings. Administer basic life support and resuscitation. Manage and administer medication correctly. Safeguard vulnerable adults effectively and responsibly. Communicate efficiently in caregiving environments. This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Diploma in Caregiving. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online - Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Diploma in Caregiving course, you can order your CPD Accredited Digital / PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? Aspiring caregivers aiming to work with adults in various settings. Individuals interested in domiciliary care and home caregiving. Those looking to understand the fundamentals of caregiving. Caregivers seeking to enhance their skills in adult nursing. Anyone passionate about safeguarding and supporting vulnerable adults. Requirements You don't need any educational qualification or experience to enrol in the Diploma in Caregiving course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Diploma in Caregiving Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Home Caregiver - £18K to 25K/year. Domiciliary Carer - £19K to 26K/year. Mental Health Nurse - £24K to 40K/year. Adult Care Worker - £20K to 30K/year. Medication Administration Specialist - £22K to 32K/year. Course Curriculum Prerequisite Document Prerequisite Document 00:20:00 Diploma in Caregiving Module 01: Adult Care in Different Life Stages 00:17:00 Module 02: Working with Adults 00:30:00 Module 03: Introduction to Domiciliary Care 00:15:00 Module 04: Health and Safety for Domiciliary Carers 00:33:00 Module 05: CSTF Infection Prevention and Control 00:37:00 Module 06: CSTF Resuscitation - Basic Life Support 00:24:00 Module 07: Medication Management and Administration 00:18:00 Module 08: Mental Health Care 00:23:00 Module 09: Safeguarding of Vulnerable Adults 00:15:00 Module 10: Safeguarding Legislations 00:25:00 Module 11: Safeguarding Vulnerable Adults Policy, Roles and Responsibilities 00:23:00 Module 12: Importance of Communication in Care 00:33:00 Module 13: Sharing Information and Responding to a Disclosure 00:20:00 Module 14: Reporting Your Concern 00:17:00 Module 15: Adult Nursing 00:05:00 Module 16: Health and Safety 00:26:00 Module 17: Hygiene 00:28:00 Module 18: Rest and Sleep Management 00:17:00 Module 19: Mobility and Immobility Issues of Patients 00:15:00 Module 20: Pain Management 00:23:00 Module 21: Nutrition 00:14:00 Module 22: Assisting with Elimination 00:28:00 Module 23: Oxygenation 00:28:00 Module 24: Introduction to End of Life Care 00:18:00 Module 25: Health and Social Care 00:19:00 Module 26 : Principles, Theories, and Values of Person-Centred Care 00:14:00 Module 27: Complexities of Consent 00:15:00 Module 28: Caregiving for Dementia 00:10:00

Power Query and Power Pivot in Microsoft Excel:  A Quickstart Guide   Course Description   Copyright Ross Maynard 2022   Course Description Power Query and Power Pivot are two tools available in Microsoft Excel. If you are serious about data analysis, then you need to know how to use these tools. This Quickstart guide will give you the skills you need to get started with these powerful features. The Power Query tool allows you to import external data and then modify it to meet your needs, before loading it into Excel. These editing tasks are all things you can do manually in Excel, but Power Query greatly speeds things up when you have a large volume of data. The Power Pivot tool allows you to connect multiple data tables in an extended pivot table. Power Pivot also introduces new analysis and query tools to further enhance data analysis. If data analysis is your thing, then this course will help you get up to speed with these feature-filled tools. Through screen-capture video, the course provides a step-by-step guide to the foundation skills needed to use both Power Query and Power Pivot effectively. The course is designed to make your first steps into Power Query easy and to build your confidence to use them on your own. Both Power Query and Power Pivot are also available in Microsoft Power BI – the data visualisation suite. Once you have learned how to use Power Query and Power Pivot in Excel with this course, you’ll have a head start in getting to grips with Power BI Get up to speed with Power Query and Power Pivot in Microsoft Excel with this Quickstart guide.     Key Learning Points  On completion of the course, delegates will be able to: Use Power Query to load data from an external source into Microsoft Excel Clean and manipulate external data before loading it into Excel Consolidate separate files with Power Query Update Excel tables with new data in the same format Use Power Query to “unpivot” report tables to prepare the data for analysis Explain the core functionality of Power Pivot Link data tables together in the Power Pivot data model Create pivot tables that draw data from several source data tables Create performance measures and new analysis in the Power Pivot data model Use the most popular DAX query language functions in Power Pivot     Curriculum Lesson 1: Power Query Quickstart Lesson 2: Consolidating Files with Power Query Lesson 3: Unpivoting a Table Lesson 4: Power Pivot Quickstart Lesson 5: Power Pivot – Adding Data and Functionality Lesson 6: Key DAX Functions for Power Pivot Lesson 7: The DAX CALCULATE Function Lesson 8: Key Learning Points     Pre-Course Requirements There are no pre-course requirements     Additional Resources Starter spreadsheets for each lesson are provided so that learners can follow the steps presented.     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel     Questions What is the main feature of Power Query? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     What is the main feature of Power Pivot? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     Which of the following actions cannot be performed within Power Query? Split text into multiple columns Trimming text and removing spaces Creating calculated columns using DAX functions Make date based calculations   Which of the following statements is true? You can use Power Query to combine files that have the same format and open them all in the same spreadsheet You can use Power Query to link data tables and create pivot tables that pull data items from all the linked tables You can use Power Query to create interactive dashboard reports You can use Power Query to export data files to Microsoft Access and other databases     Which of the following provides a compelling case to use Power Pivot in Microsoft Excel? The data visualisation and presentation features of Power Pivot are much more powerful than those in Excel Power Pivot offers the ability to clean large files of data imported from other systems quickly Existing reports and tables can be “reverse engineered” (unpivoted) to create data tables for more advanced analysis Files sizes in Power Pivot are smaller than in Excel and there is no limit on the number of rows of data that can be stored. This makes it much faster and more efficient to use Power Pivot for large data sets     Power Pivot uses analysis functions from the DAX formula language. What does “DAX” stand for? Digital Architecture Extraction Data Arbitrage Extrapolation Display Analytics Extension Data Analysis Expressions Deeply Annoying Exercise   The DAX CALCULATE function is one of the most powerful and useful functions available in Power Pivot. Which statement best describes it? It performs row by row calculations defined by the user and adds the total of them all together for a specified table It performs row by row calculations defined by the user and displays the maximum result for a specified table It performs a defined calculation and then applies filters specified by the user It filters the data in a specified table according to criteria set by the user   As well as in Power Pivot in Microsoft Excel, in what application are DAX functions also available? Microsoft PowerPoint Microsoft Forms Microsoft Teams Microsoft Power BI   How do DAX functions differ from Microsoft Excel functions? DAX functions are designed specifically for use with SQL based data sources DAX functions are completely new and provide additional functionality within Microsoft Excel DAX functions never take a cell reference or a range as reference, but instead take a column or table as reference DAX date and time functions return a date as a serial number, whereas Excel date and time functions return a datetime data type