1645 Courses in Cardiff delivered Online

Our Safeguarding courses have been created because, first and foremost, each and every one of us has basic human rights. Chief among these is the right to be healthy, happy and treated well, regardless of race, age, gender or location. When these rights are abused in some way it’s wrong, and it is therefore vital that guidelines, policies and procedures are followed to enable everyone, without exception to live a life in which these basic values and rights are maintained and upheld. This course is aimed at anyone who has a duty of care for, or comes into contact with, adults in need of care and support, either as a paid professional or a volunteer. This includes, but isn’t limited to, those that work in domiciliary care, the NHS, community centres, prisons or with a family member at home, and sets out the roles and responsibilities everyone must undertake to protect an adult’s right to live in safety, free from abuse and neglect. You and the organisation you work for must take appropriate and proportional measures necessary for the protection of adults in your care, while still ensuring they are supported and empowered to have control over how they want to live their lives and this course can bring you one step closer to being able to do this. This means that whatever the circumstance, you and the organisation you work for must take appropriate and proportional measures necessary for the protection of adults in your care, while still ensuring they are supported and empowered to have control over how they want to live their lives. During this course you will hear many facts, figures and details surrounding the risk to adults in need of care and support, the types of abuse suffered and key safeguarding legislation put in place to minimise the abuse of adults with care and support needs. By the end of this course, you will have learned a better understanding of safeguarding principles and be able to apply them to your role. This includes being able to define the key terminology in relation to safeguarding; identify the principle laws that relate to safeguarding and why they have been put in place to minimise abuse; recognise and respond to the ten types of abuse suffered by vulnerable adults; identify and report concerns of abuse or neglect; describe your role, responsibilities and boundaries; ensure people are supported and encouraged to make their own decisions and give informed consent, and finally manage the environment to minimise the risk of abuse.

The Disability Awareness course is a comprehensive program designed to provide participants with a solid understanding of disabilities, including, historical perspectives, legislation, reasonable adjustments, and strategies for fostering inclusivity in all environments. Through interactive online modules, participants will gain valuable insights into the diverse experiences of individuals with disabilities and develop the knowledge and skills necessary to create an inclusive online space.

Duration 1 Days 6 CPD hours This course is intended for This course is for employees of Sun Life who want to expand their skills when using HUE to work with SQL databases. Overview Upon successful completion of this course, students will be able to better operate HUE when interacting with SQL databases. In this course, students will learn additional skills when using HUE to interact with SQL databases. Using Subqueries to Perform Advanced Querying Search Based on Unknown Values Compare a Value with Unknown Values Search Based on the Existence of Records Generate Output Using Correlated Subqueries Filter Grouped Data Within Subqueries Perform Multiple-Level Subqueries Manipulating Table Data Insert Data Modify and Delete Data Manipulating the Table Structure Create a Table Create a Table with Constraints Modify a Table's Structure Back Up Tables Delete Tables Working with Views Create a View Manipulate Data in Views Create Aliases Modify and Delete Views Indexing Data Create Indexes Drop Indexes Managing Transactions Create Transactions Commit Transactions

Having a clear business vision and plan for your business is the difference between setting your GPS to take you from Scotland to England and then trying to work out where you want to go compared to setting your GPS to go from a postcode in Edinburgh to a postcode in London! Create a business plan you can use to grow your business successfully

With this course, you will master all CloudFormation concepts, and become confident in writing CloudFormation templates using YAML. Throughout the course, you will encounter various interesting examples and activities that will help you to consolidate your learning.

Motorsport is as much a business as it is a sport. Our new master’s programme will provide students with a broad range of modules which examine the national and international aspects of the industry from a commercial perspective. From governance, structure and international sports law, through to the importance and interdependence of commercial rights holders, promoters, manufacturer, teams, sponsors and the role played by the media, this course is aimed at enhancing the professional and career prospects of those with an aspiration of working within this exciting and challenging global industry. Our programme will help you to develop as professionals with a strong grounding in ethics and a clear sense of how motorsport relates to various cultures, stakeholders and the sectors it interacts with.

Introduction: Imagine a world where there was no right or wrong - one where everyone makes their own baseless rules and we are not bound by any laws, regulations, or compassion for others. This would be a world without ethics - and if you don't think that this would be a good situation, you can fully understand why ethics are so important. This course gives you an overview of the importance of ethics in our lives. It begins with a brief definition of what ethics are and how we can define this ideal and continues with an introduction about why it is important to live an ethical life. This course also examines the different elements that make up ethics and while explaining this, you further can see how important ethics are in everything we do, from communicating with others and the decisions we make at work, to what we believe is 'right' or 'wrong'.   What You Will Learn: How to define ethics in an easy to understand way Why it is so difficult to define ethics across the board Reasons why ethics are so important throughout our lives Why there are so many elements that go into ethics How ethics can affect every decision we make Benefits of Taking This Course: Learn more about what ethics involve and how to make ethical decisions Learn about why you should create your own definition of what is ethical Understand why understanding ethics is so important and why asking questions about ethics might lead to more questions than answers Learn what elements go into creating the ideal of ethics and how these parts work together to help us in our actions, values and goals If you are interested in learning more about why ethics make us safer, this course can give you information on this

Highlights of the Course Course Type: Online Learning Duration: 2 hours 34 minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about life coaching Understand the core competencies and principles of life coaching Explore the various areas of life coaching Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert life coach Time Management and Planning Course for Life Coaches Course Master the skills you need to propel your career forward in life coaching. This course will equip you with the essential knowledge and skillset that will make you a confident life coach and take your career to the next level. This comprehensive time management and planning course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this time management and planning course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective life coaching practice and equip you with the essential skills, confidence and competence to assist you in the life coaching industry. You'll gain a solid understanding of the core competencies required to drive a successful career in life coaching. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for life coach or for people who are aspiring to specialise in life coaching. Enrol in this time management and planning course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive time management and planning course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this life coaching can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This time management and planning course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This time management and planning course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This time management and planning course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction What You Will Learn 00:04:00 Your Personal Values Personal Values Introduction 00:01:00 Why Defining Your Values Is Important 00:02:00 How To Define Your Personal Values 00:05:00 What Does Your Ideal Life Look Like? 00:04:00 Goal Setting Basics Goal Setting Introduction 00:01:00 Why You Have To Set Goals To Get Ahead In Life 00:05:00 The 4 Biggest Goal Setting Mistakes You Must Avoid 00:06:00 SMART Goal Setting 00:01:00 HARD Goal Setting 00:02:00 WOOP Goal Setting 00:04:00 The Secret: Stretch Goal Philosophy 00:03:00 Setting Your First Goal Setting Your First Goal Introduction 00:01:00 Why You Should Start With Long Term Goals 00:05:00 How To Set Long Term Goals Correctly 00:05:00 Turning Long Term Goals Into Short Term Goals 00:05:00 Creating Your Action Plan Action Plan Introduction 00:01:00 How To Create Your List Of Actions 00:02:00 How To Set A Timeline & Create Milestones 00:02:00 How To Allocate Resources Correctly 00:02:00 Habit Building Habits Introduction 00:01:00 What Are Habits 00:01:00 Why Habits Matter 00:01:00 How To Build A New Habit 00:05:00 Habit Stacking - How To Boost Your Results 00:03:00 Choosing The Right Triggers 00:02:00 How To Write Down Your Sequence 00:01:00 How To Create Accountability 00:02:00 Small Goals Every Day 00:01:00 Advanced Goal Setting Strategies & Tips Advanced Strategies Introduction 00:01:00 The Success Cycle 00:06:00 Why New Year's Resolutions Don't Work 00:03:00 Accountability Buddies & Sharing Your Goals Correctly 00:05:00 The 80/20 Rule In Goal Setting 00:03:00 Using Visualization To Reach Your Goals Faster 00:04:00 Designing An Inspiring Vision Board 00:04:00 Affirmations For Goals 00:02:00 Memory Focus & Stress Reduction Memory & Mental Clarity Explained 00:01:00 Memory Building Techniques 00:03:00 Understanding & Reducing Stress 00:06:00 The Best Foods To Fight Stress 00:03:00 Supplements For Better Memory & Focus 00:02:00 Client Coach Relationship Client Coach Relationship Intro 00:01:00 What Clients Expect From Their Coaches 00:03:00 Why Clients Choose One Coach Over Another 00:01:00 What Qualifications Do You Need As A Coach 00:02:00 Client Coach Boundaries 00:02:00 How To Retain Clients Long Term 00:05:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

High Performing Teams. Moccasin Approach, Moccasin Manager,

Course Overview Grasp the opportunity to learn Microsoft Excel from the ABCs to an advanced level within one course. The Microsoft Excel Masterclass in 2021 course will start with the basics with MS excel and gradually turn you into an expert user. The Microsoft Excel Masterclass in 2021 course will first focus on the tools and functions of excel. You will comprehend the skills to create basic formulas in excel. In this step by the step learning process, you will have the adequate knowledge and ability to make all sorts of adjustments to your worksheets. The course will teach you many strategies for cell formatting. From the easy to follow modules, you will grasp the techniques to insert shapes and images into your sheets. You will also understand how to visualize your data in charts. In the end, you will study the benefits of using excel templates. The Microsoft Excel Masterclass in 2021 course will provide you with first-hand training on excel. Enroll in the course and take your excel skills to the next level. Learning Outcomes Get an introduction to Microsoft Excel and its functions Understand the process of data validation and data visualization Learn how to adjust excel worksheets Know about the conditional functions Familiarize yourself with the process of inserting images and shapes Who is this course for? Those who want to learn Microsoft Excel. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The Microsoft Excel Masterclass in 2021 course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Business Professional Data Operator Administrative Officer Data Analyst Unit 01: Excel from A-Z Course Introduction Excel from A-Z Course Intro 00:03:00 Excel Job Opportunities 00:03:00 Excel Job Types 00:04:00 Microsoft Excel Marketplace 00:04:00 What is Microsoft Excel? 00:04:00 Who is This Course For? 00:04:00 Unit 02: Getting Started With Excel Finding & Opening Excel 00:01:00 Excel's Start Screen 00:03:00 Explaining the Excel Interface 00:03:00 Excel Interface Continued 00:01:00 Excel Workbook vs. Excel Worksheet 00:02:00 Saving an Excel Document 00:04:00 Customizing the Quick Access Toolbar 00:02:00 Customizing the Excel Ribbon 00:03:00 Excel Shortcut Keys 00:02:00 Unit 03: Values, Referencing and Formulas Creating Excel Labels 00:03:00 Entering Numeric Values in Excel 00:03:00 Formatting Date Values in Excel 00:05:00 Building Basic Formulas in Excel 00:05:00 Order of Operations 00:06:00 Relative vs. Absolute Cell References 00:07:00 Unit 04: Intro to Excel Functions Excel Functions Explained 00:03:00 The SUM() Function 00:08:00 The MIN() & MAX() Function 00:04:00 The AVERAGE() Function 00:02:00 COUNT() Functions 00:05:00 Unit 05: Adjusting Excel Worksheets Moving & Copying Data 00:07:00 Insert & Delete Rows and Columns 00:05:00 Adjusting the Width and Height of Cells 00:05:00 Hiding and Unhiding Excel Rows and Columns 00:04:00 Renaming, Moving & Deleting Excel Worksheets 00:05:00 Adding Protection to Specific Cells 00:04:00 Protecting the Structure of a Workbook 00:02:00 Adding a Workbook Password to Open File 00:02:00 Unit 06: Visually Pleasing Cell Formatting Formatting Fonts and Cell Background Color 00:05:00 Adding Cell Borders 00:05:00 Formatting Data Appropriately 00:05:00 The Magic behind Excel's Format Painter 00:04:00 Creating Styles for Formatting Efficiency 00:06:00 Merging Cells for a Cleaner Look 00:03:00 The Power of Conditional Formatting 00:06:00 Unit 07: How to Insert Images and Shapes! Grab User's Attention using Illustrations 00:09:00 Customizing Icons 00:05:00 Create Compelling Graphics with SmartArt 00:06:00 Unit 08: Visualize Data with Charts The Commonly Used Column Chart 00:03:00 Changing the Chart Design 00:02:00 Formatting Elements of a Chart 00:06:00 Modifying the Data, Type & Location of a Chart 00:06:00 Unit 09: Excel's Printing Options Print Preview Options 00:04:00 Excel's Page Layout View 00:07:00 Printing a Specific Range of Cells 00:03:00 Converting Spreadsheets to PDF Files 00:02:00 Unit 10: Benefits of Using Excel Templates Why Create an Excel Template 00:01:00 How to Create an Excel Template 00:05:00 Unit 11: Working with Excel Datasets How to Prepare Data for Analysis 00:04:00 How to Sort Data in Excel 00:03:00 Multi-Level Sorting 00:03:00 Custom Sorting Datasets in Excel 00:02:00 Applying Filters to Datasets 00:05:00 Creating Subtotals within a Dataset 00:06:00 Converting Datasets into Tables 00:06:00 Finding & Removing Duplicate Values 00:07:00 Unit 12: Excel Database Functions The SUMIF() Function 00:09:00 The DSUM() Function 00:08:00 The DSUM() Function Cont. 00:07:00 The SUBTOTAL() Function 00:06:00 Unit 13: Excel Data Validation What is Excel Data Validation? 00:02:00 Creating a Drop Down List with Data Validation 00:07:00 Different Types of Excel Data Validation 00:06:00 Adding Custom Alerts to Data Validation 00:07:00 Creating a Dynamic Drop Down List 00:03:00 Complex Validation: Dependent Drop Down List! 00:09:00 Unit 14: Excel PivotTables Creating an Excel Pivot Table 00:06:00 Modifying Excel PivotTables 00:06:00 Grouping & Filtering PivotTable Data 00:07:00 Drilling Down into PivotTable Data 00:02:00 Creating Pivot Charts & Utilizing Slicers 00:08:00 Unit 15: Excel's PowerPivot Add-In What is PowerPivot? 00:04:00 Activating the Excel PowerPivot Add-In 00:02:00 Creating Relationships between Data Tables 00:06:00 Using Data Models to Create PivotTables 00:05:00 How to Create PowerPivot KPI's 00:08:00 Unit 16: Excel's Conditional Functions Excel's IF() Function 00:05:00 IF() Function with AND() Criteria 00:05:00 IF() Function with OR() Criteria 00:05:00 Nesting Multiple IF() Functions 00:07:00 The COUNTIF() Function 00:04:00 Key Benefits of Named Ranges 00:04:00 Unit 17: Excel's Lookup Function VLOOKUP() Function 00:09:00 The Beauty of Excel's IFERROR() Function 00:04:00 HLOOKUP() Function 00:06:00 INDEX() Function 00:05:00 MATCH() Function 00:05:00 INDEX() and MATCH() Combined 00:05:00 Two-Way Lookup with INDEX() and MATCH() 00:04:00 Unit 18: Text Based Functions in Excel LEFT(), RIGHT() and MID() Function 00:07:00 Extracting Specific Text using LEN() & SEARCH() 00:13:00 Combining Text with CONCATENATE() 00:06:00 Quick Tips & Other Text Based Functions 00:06:00 Unit 19: Auditing Formulas and Views in Excel Tracing Precedents & Dependents in Formulas 00:04:00 Showing Formulas 00:02:00 Grouping Data 00:03:00 3D Referencing in Formulas 00:05:00 Utilizing the Watch Window in Excel 00:03:00 How to Freeze Panes in Excel 00:03:00 Unit 20: Excel's 'what If?' Tools Excel's Scenario Manager Tool 00:06:00 Goal Seek in Excel 00:06:00 Compare Results with Excel Data Tables 00:04:00 Solver Tool 00:11:00 Unit 21: Welcome to Excel VBA The Power Behind Excel VBA 00:03:00 A Look Inside the Visual Basic Editor (VBE) 00:04:00 Recording a Macro 00:09:00 Saving & Opening a Macro-Enabled Workbook 00:02:00 Unit 22: The VBA Language Modules and Procedures 00:07:00 Objects, Methods and Properties 00:06:00 Excel VBA Variables 00:05:00 Unit 23: Writing VBA Code Referencing a Range 00:14:00 InputBox & MsgBox 00:06:00 Using Variables in VBA Code 00:05:00 If Then Else Statement 00:10:00 Worksheet Functions inside VBA 00:08:00 Creating User Defined Functions 00:09:00 User Defined Functions within VBA Scripts 00:06:00 Unit 24: Important VBA Tools and Logic Find Last Row of Data 00:06:00 Find Last Column of Data 00:03:00 With Statement 00:05:00 Debugging & Error Handling 00:07:00 Debugging & Error Handling Cont. 00:07:00 Unit 25: Excel VBA Lopps For Next Loop 00:09:00 Do Until Loop 00:06:00 For Each Loop 00:04:00 Unit 26: Triggering Macros Assigning Macros to Shapes 00:04:00 Form Controls vs ActiveX Controls 00:08:00 Worksheet Events 00:04:00 Workbook Events 00:03:00 Fun with VBA Events! 00:07:00 Unit 27: Excel User Forms Creating an Excel UserForm 00:03:00 Adding Controls to UserForms 00:10:00 How to Show an UserForm 00:03:00 Passing TextBox Values to Desired Cells 00:07:00 Passing Option Buttons to Desired Cells 00:07:00 UserForm ComboBoxes 00:08:00 Clearing Values from UserForm Controls 00:03:00 How to Close an UserForm 00:02:00 UserForms and Protected Sheets 00:05:00 Unit 28: Starting a Career in Excel Creating an Excel Resume 00:05:00 Getting Started with Freelancing 00:06:00 How to Become an Excel Freelancer 00:05:00 Top Freelance Websites 00:05:00 How to Get Your First Client 00:08:00 Personal Branding 00:07:00 Networking Do's and Don'ts 00:04:00 Importance of Having a Website 00:04:00 Resources Resources - Microsoft Excel Masterclass in 2021 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00