12349 Open courses delivered On Demand

Course overview Take a practical approach to enhance your Excel modelling skills with the Advanced Excel Models using Formulas, VBA & Power Query course. In this course, you will learn how to build robust Excel models using Formulas, VBA and Power Query. This Advanced Excel Models using Formulas, VBA & Power Query course offers a wide range of training modules to enhance your abilities to create better models. You will discover the advanced Excel formulas to prepare reports, forecast and perform mathematical calculations. We will introduce you to the three excel models and show the functions used to prepare these pro models. In addition, you will learn the Excel formulas for prepaid expenses and explore the steps to create dynamic dashboards based on Power Query and Pivot Table without any formula. Learning outcomes Familiarize yourself with the advanced Excel formulas Be able to manage prepaid expenses Deepen your understanding of the prepaid expense models Learn about the pro Excel models and formulas Strengthen your knowledge of Power Query and PowerPivot Learn how to create Power query and pivot table based dashboard without any formula Who Is This Course For? This Advanced Excel Models using Formulas, VBA & Power Query course is recommended to anyone interested in learning how to prepare robust Excel models using advanced formulas, Power Query and VBA. In addition, the skills gained from this training will provide excellent opportunities for career advancement. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £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 and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Advanced Excel Models using Formulas, VBA & Power Query Course 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: Data Analyst System Support and Reporting Analyst Introduction Course Outline and Introduction 00:04:00 Minimum Requirements for the Course 00:01:00 Prepayments Introduction 00:01:00 Prepaid Expenses Models: Resources Download Month End Date Prepaid Expenses Amortization Calculation 00:00:00 Exact Prepaid Expenses Payment Date Calculation 00:00:00 Accounting for Prepaid Expenses Prepaid Expenses Accounting Definition: Prepayments 00:03:00 Prepaid Expense Example: How Accounting works for Prepayments 00:03:00 Advantages and Disadvantages of Prepaid Expenses 00:03:00 Excel Formulas Detailed: Introduction to three Excel Models Introduction to PRO Excel Models and Formulas 00:06:00 Date Function 00:05:00 EOMONTH Function 00:04:00 DATEVALUE function 00:03:00 IF Function 00:08:00 IFS Function (Office 365 Only) 00:07:00 VLOOKUP Function 00:07:00 MATCH Function 00:05:00 INDIRECT Function 00:02:00 NAMED Ranges: Name Manager 00:03:00 Advanced Version of VLOOKUP Function 00:07:00 Formula Based Prepaid Expenses Model Introduction to Model and Control Panel Tab (Important Sheet Tab) 00:08:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 1) 00:05:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 2) 00:06:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 3) 00:06:00 IFS Function - Month End date Prepayment calculation 00:04:00 Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary) 00:09:00 Protecting Formulas Cells and Fields in the Model 00:04:00 Calculate Prepaid Expenses Amortisation from Exact Start Date Exact Date Prepaid Amortisation calculation Intro 00:03:00 Formulas update and Model Changes for Exact Prepaid Exps Calculation 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1) 00:04:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2) 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3) 00:02:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4) 00:07:00 IFS Function - Exact Date Prepayments Amortisation 00:04:00 Data Validation Controls (Enhancing Data Input Controls with Protection) 00:10:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 1) 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 2) 00:09:00 Additional Material: Resources 00:00:00 Prepaid Expenses Summary with Power Query and Pivot Table Power Query and Pivot Table Prepayment Summary Table Intro 00:06:00 What is Power Query and Some Awesome Resources for Power Query learning 00:07:00 Power Query and Pivot Table Summary - Deep Dive (Part 1) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 2) 00:04:00 Power Query and Pivot Table Summary - Deep Dive (Part 3) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 4) 00:09:00 Using Array Formulas to Add Formula Protection 00:04:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1 00:02:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version) 00:13:00 Advanced VBA Prepaid Expenses Amortisation Model Changing Macros Security in Excel 00:05:00 Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model 00:06:00 Bonus : New Version - Excel VBA Model for Prepayment Expenditure 00:08:00 BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way Dynamic Dashboard Overview 00:07:00 Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets 00:08:00 Creating Dynamic Data Validation 00:02:00 Creating Named Ranges for Dynamic Table Arrays 00:03:00 Dynamic Date Column Headings for each Divisional PL Table 00:02:00 Dynamic Month and YTD Dashboard tables headings (PRO TIP) 00:03:00 Dynamic VLOOKUP Formula - Preparing First section of the Dashboard 00:04:00 Creating Rolling Dashboard with Dynamic VLOOKUP Function 00:08:00 IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP) 00:03:00 Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function) 00:05:00 Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit 00:05:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1) 00:03:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2) 00:06:00 Power Query & Pivot Tables based Dashboard without any Formulas, Fully Dynamic Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed 00:05:00 Understanding the data files before building dashboard 00:02:00 Consolidating Reports with Power Query (Get & Transform) , How to install PQ 00:08:00 Dynamic File Path Trick in Power Query with Parameters (Amazing trick) 00:06:00 Conditional Cumulative totals with SUMIFS Function 00:04:00 Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code) 00:06:00 Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise 00:06:00 Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast) 00:08:00 Dashboard Creation - Line Charts 00:08:00 Update Dashboard with Additional Divisional Data with Few Click (Magical) 00:03:00 Thankyou Thank you 00:02:00 Ultimate Prepaid Expenditure Model (Super Bonus) 00:02:00 Resources Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

This recording package is for individuals who did not attend the Rethinking Museums live event. If you attended online on 5 February and would like to upgrade your ticket to include a recording, please click here. Since the end of the pandemic, children, young people and families have faced a barrage of challenges to their standard of living, wellbeing, family life and place within society. Our conference will focus on how museums can become welcoming and accessible spaces that enable all children, young people and families to socialise, relax, play, work and learn. The three key themes of the conference are: Family Against the background of a slow post-Covid recovery and ingrained inequalities of access amongst museum audiences, we will share examples of museum programmes that have successfully welcomed children, young people and families who have historically been excluded. Often these new audiences have found a sense of safety and belonging in their local museums and become less isolated. Society In an increasingly polarised world where online disinformation proliferates, museums have a vital role in enabling people to build empathy and explore social justice issues. Work in this space helps museums remain relevant to younger audiences and helps them feel more optimistic about the future. Careers As the number of museum traineeships and apprenticeships are shrinking, so are the routes into a career in heritage. We’ll explore programmes that are opening up the museum workforce and enabling a wider group of young people to find meaningful work and build skills and confidence for future employment. You can read all about the conference and see the schedule on our website. About the recording The recording will include all of the conference sessions. You will receive the recordings approximately six weeks after the conference. You will be able to watch the recordings for six months from the date of the conference. All of the sessions will be captioned.

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. Course Curriculum You Can Master Microsoft Outlook You Can Master Microsoft Outlook Promo 00:02:00 You Can Ask Me Anytime 00:01:00 Your Facebook Support Group 00:01:00 Quick Win - How To Send an Email in Outlook 00:01:00 Quick Win - How To Print an Email in Outlook 00:01:00 Another Quick Win - You Can Work Offline With Outlook 00:01:00 Getting Started With Outlook Outlook Environment 00:03:00 Outlook Opening 00:02:00 Outlook Interface Options 00:04:00 Sending and Receiving Email in Outlook 00:03:00 Sending and Receiving Email in Outlook with Attachments 00:02:00 File Menu Account Settings in Outlook 00:06:00 Automatic Replies in Outlook 00:04:00 Mail Box Settings in Outlook 00:02:00 Rules and Alerts Settings in Outlook 00:04:00 Exporting and Importing Rules and Alerts in Outlook 00:01:00 Opening Options in File Outlook 00:04:00 Home - New Email in Outlook Quick Win - How To Create Folder in Outlook 00:01:00 Quick Win - How To Change Outlook Style 00:01:00 Quick Win - How To Use Quick Access Toolbar 00:01:00 New Email Options in Outlook 00:03:00 Clipboard in New Email 00:05:00 Basic Text in New Email 00:07:00 Name, Include and Tags in New Email 00:03:00 Inserting Table Into New Email 00:10:00 Inserting Images Into New Email 00:10:00 Inserting Shapes Into New Email 00:06:00 Inserting SmartArt Into New Email 00:04:00 Inserting New Chart Into New Email 00:05:00 Taking Screenshot Into New Email 00:02:00 Links, Text and Symbol 00:03:00 Themes, Show Fields, Encrypt, Tracking and More Options in New Email 00:03:00 Formatting Text in New Emails 00:03:00 Text Style in New Email 00:04:00 Reviewing Menu in New Email 00:03:00 Home - New Appointment New Appointment at Home Menu 00:06:00 Home - New Meeting New Meeting at Home Menu 00:01:00 Home - New Contact New Contact in Home Menu 00:05:00 Home - New Task Create New Task 00:03:00 Other New Item in Home 00:02:00 Home - Other Functions Email Deletion in Outlook 00:02:00 Responding to A Email in Outlook 00:02:00 Quick Steps, Tag and Other Functions 00:03:00 Send and Receive Complete Guide of Send and Receive 00:03:00 Home - Folder Complete Folder Guide 00:05:00 Review and Outlook View and Help in Outlook 00:04:00 Options Options Intro 00:03:00 General Options in Outlook 00:05:00 Mail Options in Outlook 00:06:00 Calendar Options in Outlook 00:03:00 Contact Options in Outlook 00:01:00 Task Options in Outlook 00:01:00 Search Options in Outlook 00:02:00 Language Options in Outlook 00:02:00 Ease of Access Options in Outlook 00:02:00 Advanced Option in Outlook 00:04:00 Ribbon and Quick Access Toolbar Customization 00:02:00 Security Is Everything Quick Win - Create Unknown Password 00:01:00 Security Is Everthing 00:01:00 Quick Win - Insecurity Is Coming from You And Others 00:01:00 Understand Security Type or Category 00:02:00 Life Savers - You Should Know These 00:04:00 Have Proper Password - Start Securing You Now 00:03:00 Don't Use the Same Password Anymore 00:02:00 Should You Use Longer Password or Complicated! 00:03:00 Last-Pass & Authy Mobile App 00:02:00 The Best and Only Solution to Make and Keep Password Un-Crack-Able 00:08:00 Lastpass Setup and Configure 00:10:00 Last-Pass Options Part 1 00:03:00 Last-Pass Options Part 2 00:04:00 Last-Pass Option Part 3 00:04:00 2FA Makes You Even Stronger in Password 00:05:00 Security Is Everything, Keep Secured Your Devices 00:07:00 Security on Your Data and Privacy 00:08:00 Conclusion Congratulations 00:01: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

Do you want to improve your customer service skills & want to make your customers happy? Do you want to exceed customer expectations and want to create clients who spread words about your business? If yes, then enrol now and benefit from this course. Description: This Customer Service course teaches the basics of customer service and translates that knowledge into practical application. Students will come away from this customer service course knowing how a positive attitude, going a step beyond basic customer service, and dealing effectively with complaints will enhance their work experience. Students will learn the difference between internal and external customers and will find out how the development and implementation of a comprehensive customer service policy promote consistency in how customers are treated and keep customers happy. Who is the course for? Individuals who have any interaction with customers in any business. People who want to take their customer service skills to the next level. Students. Job seekers. 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. Assessment:  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. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, 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 a cost of £39 or in PDF format at a 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 recognised 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: Level 2 Certificate in Customer Service is a useful qualification to possess, and would be beneficial for the following professionals: Administrative Receptionist. Assistant Office Manager. Call Center Customer Service Representative. Call Center Representative. Call Center Supervisor. Customer Care Representative. Customer Service Administrative Assistant. Customer Service Agent. Customer Service Analyst. Customer Service Assistant. Customer Service Associate. Customer Service Introduction To Customer Service 00:15:00 The Power of Positive Thinking in Customer Service 00:30:00 Types of Difficult Customers and How to Help them 01:00:00 How to Deal with Difficult Customers 00:30:00 Conclusion 00:15:00 Customer Service Basics Customer Service and Retention Templates 01:00:00 Customer Service & Retention Checklist 01:00:00 Customer Service Checklist 01:00:00 Customer Service Skills First Lesson 00:30:00 Second Lesson 01:00:00 Third Lesson 00:30:00 Fourth Lesson 00:30:00 Fifth Lesson 01:00:00 Microsoft Word Module One - Getting Started 00:30:00 Module Two - Opening 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Document 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Basic Formatting Tasks 01:00:00 Module Seven - Formatting Paragraphs 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Sharing Your Document 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Excel Module One - Getting Started 00:30:00 Module Two - Opening Excel 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Worksheet 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Building Formulas 01:00:00 Module Seven - Using Excel Functions 01:00:00 Module Eight - Using Quick Analysis 01:00:00 Module Nine - Formatting Your Data 01:00:00 Module Ten - Using Styles, Themes, and Effects 01:00:00 Module Eleven - Printing and Sharing Your Workbook 01:00:00 Module Twelve - Wrapping Up 01:00:00 Mock Exam Mock Exam- Certificate in Customer Service 00:30:00 Final Exam Final Exam- Certificate in Customer Service 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Take The Key Holding Online Course Duration 2-3 Hours What is the Key Holding Course? At our institution, we recognize the importance of responsible key management and the role of key holders in safeguarding properties and assets. Our Online Key Holding Course is designed to equip individuals with the knowledge and skills necessary to become proficient key holders, capable of managing and securing keys responsibly. This comprehensive online program offers flexibility and accessibility, making it ideal for individuals seeking a career or advancement in security, property management, or related fields. Course Overview: Learning style : E-learning, Duration : 2-3 Hours, Venue: Online Why Choose An Online Key Holding Course? Essential Skillset Key holding is a fundamental duty for professionals responsible for securing properties and assets. This course equips you with the essential skills needed to excel in this role. Career Advancement A certified key holder is a valuable asset in many industries. Completing this course opens doors to career advancement and new opportunities. Enrollment Information And Our Commitment To Your Key Holding Success To enrol in our Online Key Holding Course or to obtain more information, please contact us. We are dedicated to helping you become a responsible and proficient key holder, ready to contribute to the safety and security of properties and assets in your chosen field. Course Highlights Our Online Key Holding Course covers a wide range of topics to ensure you’re well-prepared for the responsibilities of key management: Key Management Understand the principles of responsible key management, including key collection, storage, and distribution. Security Protocols Learn about security protocols and procedures for key holders, including alarm response and access control. Legal Requirements Familiarize yourself with the legal and regulatory aspects of key holding, ensuring compliance with relevant laws and regulations. Emergency Response Be prepared to handle emergency situations and take appropriate action when key-related incidents occur.

In today's rapidly evolving world, Mechanical Engineering stands as a cornerstone of innovation and progress. Its significance lies in its multifaceted applications across various industries, including automotive, aerospace, energy, and manufacturing. Learning Mechanical Engineering is crucial for individuals aspiring to be at the forefront of technological advancements, as it equips them with the skills to design, analyze, and optimize mechanical systems and processes. The demand for Mechanical Engineers in the UK is substantial, with numerous job opportunities arising from the need to develop sustainable energy solutions, enhance transportation systems, and innovate manufacturing processes. With an average annual salary of £45,000, pursuing a career in Mechanical Engineering promises financial stability and growth prospects. Beyond job prospects and financial rewards, the advantages of studying Mechanical Engineering are manifold. It fosters critical thinking, problem-solving abilities, and creativity, preparing individuals to tackle complex engineering challenges. Moreover, it offers opportunities for global collaboration, allowing professionals to contribute to projects with far-reaching impacts. Embracing Mechanical Engineering not only opens doors to diverse career pathways but also empowers individuals to shape a sustainable and technologically advanced future. Key Features This Mechanical Engineering Course Includes: This Mechanical Engineering course is CPD Certified Free Certificate from Reed CIQ Approved Mechanical Engineering course Developed by Mechanical Engineering Specialist Lifetime Access to Mechanical Engineering course Why Choose Our Course? Choosing our Mechanical Engineering course is a smart investment in your professional future. Our Mechanical Engineering course is designed by industry professionals to stay ahead of trends, offering the most current and relevant content. This Mechanical Engineering course provides you with the tools and knowledge needed to excel in today's competitive landscape. With flexible learning options and a commitment to your success, our Mechanical Engineering course is the key to unlocking your potential and advancing your professional journey. Course Curriculum Mechanical Engineering course: Module 01: Introduction to Engineering Module 02: Mechanics in Engineering - I Module 03: Mechanics in Engineering - II Module 04: Thermodynamics and Heat Transfer Module 05: Energy, Work, and Forces in Engineering Module 06: Fluid Mechanics in Engineering Module 07: Structural Analysis in Engineering Module 08: Machines and Mechanisms - I Module 09: Machines and Mechanisms - II Module 10: Dynamics of Machines Module 11: Design Principles in Mechanical Engineering Module 12: Hydraulic Systems and Machines Module 13: Processes of Strain Hardening Module 14: Solidification Applications Module 15: Principles of Welding Module 16: Engineering Graphics and Drafting Learning Outcomes Mechanical Engineering Course: Understand fundamentals: Grasp core principles of mechanical engineering from introduction to advanced topics. Analyse mechanics: Apply Engineering Mechanics I and II concepts to real-world problems. Master thermodynamics: Comprehend Heat and Thermodynamics principles and their applications. Demonstrate design skills: Execute Mechanical Engineering Design techniques in practical engineering scenarios. Grasp fluid dynamics: Apply knowledge of Fluid Mechanics to solve engineering challenges. Develop drawing proficiency: Proficiently create and interpret Engineering Drawings for communication. Accreditation All of our courses, including this Mechanical Engineering course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in Mechanical Engineering. CPD 10 CPD hours / points Accredited by CPD Quality Standards Mechanical Engineering 3:19:00 1: Module 01: Introduction to Engineering 08:00 2: Module 02: Mechanics in Engineering - I 11:00 3: Module 03: Mechanics in Engineering - II 11:00 4: Module 04: Thermodynamics and Heat Transfer 11:00 5: Module 05: Energy, Work, and Forces in Engineering 10:00 6: Module 06: Fluid Mechanics in Engineering 10:00 7: Module 07: Structural Analysis in Engineering 10:00 8: Module 08: Machines and Mechanisms - I 13:00 9: Module 09: Machines and Mechanisms - II 14:00 10: Module 10: Dynamics of Machines 14:00 11: Module 11: Design Principles in Mechanical Engineering 16:00 12: Module 12: Hydraulic Systems and Machines 21:00 13: Module 13: Processes of Strain Hardening 17:00 14: Module 14: Solidification Applications 10:00 15: Module 15: Principles of Welding 03:00 16: Module 16: Engineering Graphics and Drafting 18:00 17: CPD Certificate - Free 01:00 18: Leave A Review 01:00 Who is this course for? This Mechanical Engineering course can be taken by anyone who wants to understand more about the topic. With the aid of this course, you will be able to grasp the fundamental knowledge and ideas. Additionally, this Mechanical Engineering course is ideal for: Aspiring Engineers: Individuals seeking comprehensive knowledge in mechanical engineering. Technical Professionals: Those desiring expertise in structural mechanics and machine dynamics. Design Enthusiasts: Individuals interested in mastering mechanical design principles and applications. Future Machinists: Those aspiring to understand machines, hydraulic systems, and strain hardening processes. Welding Enthusiasts: Individuals keen on acquiring skills and knowledge related to welding techniques. Requirements Learners do not require any prior qualifications to enrol on this Mechanical Engineering course. You just need to have an interest in Mechanical Engineering. Career path After completing this Mechanical Engineering course you will have a variety of careers to choose from. The following job sectors of Mechanical Engineering are: Mechanical Engineer - £30K to 50K/year. Design Engineer - £25K to 45K/year. Structural Engineer - £28K to 45K/year. Aerospace Engineer - £30K to 55K/year. Manufacturing Engineer - £28K to 50K/year. Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

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. Course Curriculum Supplementary Resources Supplementary Resources - Professional Certification in Counseling - Fully Accredited 00:00:00 Introduction to Counseling Introduction To Programme 00:02:00 Introduction to Counseling 00:04:00 Counseling Techniques and Application Opening a Session 00:04:00 Rapport-Building 00:09:00 Silence in Counselling 00:04:00 Reflection 00:02:00 Paraphrasing 00:03:00 Focusing 00:04:00 Assessment 00:03:00 Appropriate Questioning 00:05:00 The Skill of Confrontation 00:03:00 Idiosyncratic Empathy 00:01:00 Immediacy 00:07:00 The Skill of Simile and Metaphor 00:01:00 Counseling Process- from Fixity to Fluidity 00:04:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

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. Course Curriculum Supplementary Resources Supplementary Resources - Certificate in Counselling Children & Adolescents 00:00:00 Foundation of Children and Adolescents Counseling Course Overview 00:01:00 Introduction to Counselling 00:03:00 Introduction to Child Psychology 00:03:00 Cognitive Development 00:04:00 Socio-Emotional Development 00:06:00 Socio-cultural factors in a child's development 00:02:00 Counseling Techniques and Application Child therapy and counselling - General Guidelines 00:01:00 Opening a Session 00:04:00 Rapport-Building 00:09:00 Reflection 00:02:00 Paraphrasing 00:02:00 Focusing 00:04:00 Assessment 00:02:00 Appropriate Questioning 00:05:00 Counselling Process 00:04:00 Behavioral Problems in Children 00:03:00 Bullying and Child Abuse 00:02:00 Stress 00:02:00 Separation 00:02:00 Depression 00:03:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Drug Awareness Training Online When it comes to the risk of drugs and alcohol in the workplace, our Drug Awareness Training course offers your staff the knowledge of all people's principles and obligations at a workplace. The Drug Awareness Training course takes the learner through the safety responsibilities, testing requirements and processes for drugs and alcohol in the workplace, as well as the implications of any positive tests. By the end of this Drug Awareness Training course, learners will understand the effects of drugs and alcohol on work fitness and how they can contribute to a safe workplace. Learning Outcomes of Drug Awareness Training After completing this Drug Awareness Training course, the learner will be able to: Understand the basic concepts of substance misuse. Demonstrate a thorough understanding of the different types of illegal drugs. Understand the legal, health, and social implications of drug and alcohol abuse. Understand how organizations and individuals are expected to handle substance misuse issues. Demonstrate an understanding of the statistics on drug and alcohol abuse in the UK. Describe the various types of drug treatment services available in the UK. Plan a drug intervention and understand when someone requires assistance. Drug Awareness Training Bundle Course Course 01: Drug and Alcohol Awareness Course 02: Diabetes Awareness Training Course 03: Introduction to Psychotherapy Course 04: Level 5 Mental Health Care - MCA and DOLS Course 05: Time Management Course 06: Level 2 Youth Work Certificate [ Note: Free PDF certificate as soon as completing the Drug Awareness Training course] Drug Awareness Training Course Curriculum of Drug Awareness Training Module 01: Introduction Module 02: Historical Overview Module 03: Nature of Addiction Module 04: Policy Initiatives and Strategy in Alcohol and Drug Use Module 05: Understanding Alcohol Abuse Module 06: Drug Addiction & Abuse Assessment Method of Drug Awareness Training After completing each module of the Drug Awareness Training Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Drug Awareness Training After completing the MCQ/Assignment assessment for this Drug Awareness Training course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? Drug Awareness Training This Drug Awareness Training course is designed for those working in high-risk industries like hospitality and construction and anyone who manages or works with vulnerable people like adolescents. Requirements Drug Awareness Training There are no specific requirements for this Drug Awareness Training course because it does not require any advanced knowledge or skills. Career path Drug Awareness Training This Drug Awareness Training course opens a new door for you to enter the relevant job market. It also gives you the opportunity to gain in-depth knowledge along with the necessary skills to grow in no time. You will also be able to add your new skills to your CV, which will help you advance in your career and become more competitive in your chosen industry. Certificates Certificate of completion Digital certificate - Included

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 Course Overview Course Overview 00:05:00 Virtual Lab Build Video - Downloading ISO and OVA Files for VirtualBox 00:08:00 Video and Lab -Creating a Virtual install of Kali using VirtualBox 00:12:00 Video and lab - Create a virtual install of Metasploitable2 00:10:00 Video and Lab - Creating Windows 7 Pro Target Machine Using VirtualBox 00:07:00 Video and Lab - Creating Windows 10 Target Machine Using VirtualBox 00:08:00 Creating Windows 10 Target Machine Using VirtualBox 00:08:00 Installing the VirtualBox Extension Pack 00:02:00 NMap Installing the WebMap-Nmap Dashboard 00:12:00 Automated Recon/Enumeration Using nmapAutomator 00:10:00 Enumerating a Windows 10 Target Creating a Vulnerable Windows 10 Target 00:04:00 Reverse Shells, Privilege Escalation and Persistent Backdoors. Create a Windows Reverse Shell Using the PowerShell 00:08:00 Create a Reverse Shell Using Command Injection 00:06:00 Create a Reverse Shell Using a File Upload 00:08:00 Launch an Automated Meterpreter Session 00:13:00 Upgrade a Dumb Terminal to Fully Functional BASH Shell 00:09:00 Windows 7 Privilege Escalation Using UAC Bypass 00:05:00 Creating a Persistent Backdoor Using a Persistent Service 00:14:00 PowerShell Empire Create Virtual Install of Server 2016 Full GUI Using VirtualBox 00:12:00 00:09:00 Installing PowerShell Empire StarKiller On Kali Linux 00:05:00 Enumerating Active Directory 00:15:00 Post-Exploitation of Windows Using PowerShell Empire 00:19:00 Post Exploitation of Microsoft Windows Advanced Password Hacking with Metasploit 00:13:00 Post-Exploitation of Microsoft Windows 00:13:00 Brute Force the SMB Password on a Windows Server 00:10:00 Enumerating Active Directory Using RPCClient 00:16:00 Dumping Wi-Fi Credentials Using netsh 00:04:00 Practical Pentesting Labs Heartbleed OpenSSL Exploit Vulnerability 00:17:00 Performing an RDP Brute Force Attack 00:14:00 Exploiting Active Directory using LLMNR/NBT-NS Poisoning 00:11:00 Accessing Kali Across the WAN with NGROK 00:15:00 Pentesting with Netcat 00:12:00 Enumerate DNS Records Using DNSRecon 00:12:00 Auditing Wireless Networks Installing a Wireless Adapter in Kali 00:09:00 Hacking a Wireless Network Using Kali Linux 00:14:00 Wireless Deauthentication Attack 00:06:00 PMKID Client-less Wireless Attack Using Bettercap 00:10:00 Wireshark Overview of Wireshark 3.2 00:10:00 Wireshark Capture Options 00:07:00 Wireshark Toolbar Icons 00:03:00 Capturing Wireless Traffic Using Wireshark 00:05:00 Capturing a 3-way TCP Handshake Using Wireshark 00:05:00 Web App Penetration Testing Creating a virtual install of OWASP 00:05:00 Setting Up Burp Suite 00:09:00 Attack Web Apps with Burp Suite Using SQL Injection 00:11:00 OS Command Injection Using Commix 3.2x 00:16:00 Web Application Firewall Detection Using WAFW00F 00:04:00 Exploit Vulnerable Web Applications Using Command Injection 00:09:00 Exploit Vulnerable Web Applications Using Command Injection 00:09:00 Using Banner Grabbing to Aid in Reconnaissance 00:10:00 Anonymity - Remaining Anonymous While Pentesting Anonymize Kali Using Whonix 00:10:00 CTF - SQL Injection to Shell Walkthrough Lab Preparation for CTF SQL Injection to Shell 00:04:00 CTF Walkthrough for SQL Injection to Shell 00:13:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00