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

5219 Model courses

Youth Work Certificate - Training Course

5.0(3)

By School Of Health Care

Youth workers plan, organise and supervise community programs for young people. It enables young people to naturally develop their voice, influence, and place in society, allowing them to reach their full potential. Young people need to develop strong interpersonal and social skills. This Youth Work Certificate course will teach you how to organise youth work and youth engagement activities. The fundamentals of outdoor management and the skills and responsibilities of youth workers will be discussed. In addition, you will learn how to plan, organise, and supervise community programs aimed at young people. You will be introduced to various methodologies and models that have influenced modern youth work practices through both practical and theoretical training. This Youth Work Certificate course's lessons have been designed so that anyone with no prior knowledge of the subject can easily dive into them. So enrol now and successfully start your career. Why choose this Youth Work Certificate course from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the course. >> Main Course: Youth Work Certificate >> Free Courses*** Course 01: Drug and Alcohol Awareness Training Course 02: Level 2 Award in Suicide Awareness >> Others benefit Included with This Youth Work Certificate Course Free 3 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the Youth Work Certificate Course] Learning Objectives After completing this Youth Work Certificate course, the learner will be able to: Understand the fundamentals of youth work. Recognise who are youth workers. Know the role and approaches of youth workers. Explain the ethical conduct and principles in youth work. Describe the social change in youth development work. Know the National Youth Agency (NYA). Explain youth work according to the EU. Know the mental health of youth workers. Deal with stress. Describe youth justice and social work Course Curriculum >> Youth Work Certificate Module 01: Overview to Youth Work Module 02: Youth Workers: Who Are They? Module 03: Role and Approaches of Youth Worker Module 04: Ethical Conduct and Principles in Youth Work Module 05: Career as a Youth Worker (Social Work) Module 06: Social Influences on Youth Worker Module 07: The National Youth Agency (NYA) Module 08: The EU on Youth Work Module 09: Mental Health of Youth Worker Module 10: Dealing with Stress Module 11: Youth Justice and Social Work >> Free Courses course 01 >> Drug and Alcohol 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 course 02 >> Level 2 Award in Suicide Awareness Module 1: Understanding Suicide course 03 >> Adults Support Worker Module 01: Introduction to Adults Support Worker Module 02: Introduction to Psychology of Older Age – Part I Module 03: Psychology of Older Age – Part II Module 04: Impact of Mental Health in the Old Age Module 05: Dealing with Life Module 06: Enhancing Health And Wellbeing course 04 >> Mental Health Support Worker Module 01: An Overview of Mental Health Module 02: Mental Health Support Worker Module 03: Understanding Childhood and Adolescent Psychiatric Disorders Module 04: Understanding Stress and Anxiety Disorders Module 05: Understanding Schizophrenia Module 06: Understanding Personality Disorders Module 07: Understanding Mood Disorders Module 08: Understanding Eating & Sleeping Disorders Module 09: Understanding Self-Harm and Suicide Module 10: Treating Mental Illness with Medication and Therapy Module 11: Laws Related to Mental Health Module 12: Mental Health System Module 13: The Participation of the Service User Assessment Method After completing each module, you will get MCQ quizzes to assess your learning. You will move through the later modules upon successful completion (60% correct answer at least) of the quiz test. This process continues till the end of the course. Apart from this, you do not need to sit for any other assessments. Certification After completing the course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £15 (if claimed by the learner). All of our courses are reviewed regularly to ensure their quality and provide appropriate current training for your chosen subject. Although certificates do not expire (in most cases), it is recommended that they be reviewed or renewed annually. Who is this course for? This Youth Work Certificate is open to people of all backgrounds. Individuals in related professions can also enrol in this course to refresh or strengthen their skills. In addition, students can take this course to gather professional knowledge besides their study or for the future. Requirements To enroll in this Youth Work Certificate course, students must fulfill the following requirements: Good Command over English language Be energetic and self-motivated Basic computer Skill You must be at least 15 years old Career path Enrol in the Youth Work Certificate course today to learn the skills and knowledge required to work with young people and organise youth activities. Opportunities in this field are: Youth Worker Working within a community organisation PE Teacher Social Worker

Youth Work Certificate - Training Course
Delivered Online On Demand18 hours
£12

Level 5 Diploma in Leadership & Management for Residential Child care (England)

5.0(3)

By School Of Health Care

Leadership & Management: Leadership & Management Our Level 5 Diploma in Leadership and Management for Residential Childcare course is designed to help managers and leaders gain the knowledge and skills they need to work in residential care with children in a management role. This course teaches you how to innovate and respond to a changing environment, as well as how to meet industry challenges and opportunities. Learn from expert tutors with industry experience, teaching you the latest expertise and best practice. This Level 5 Diploma in Leadership and Management for Residential Childcare course is designed for Leadership and Management for Residential Childcare professionals who are aspiring to specialise in Leadership and Management for Residential Childcare. Enrol today and take the next step toward achieving your personal and professional goals. Main Course: Level 5 Diploma in Leadership and Management for Residential Childcare Free Courses included with Level 5 Diploma in Leadership and Management for Residential Childcare (England) Course Course 01: Level 5 Child Care Training Course 02: Level 2 Safeguarding Children Training Course Course 03: Level 3 Award in Childcare and Education Course 04: Level 7 Diploma in Leadership and Management [ Note: Free PDF certificate as soon as completing the Level 5 Diploma in Leadership and Management for Residential Childcare (England) course] Leadership & Management: Leadership & Management This Level 5 Diploma in Leadership and Management for Residential Childcare course consists of 20 modules. Course Curriculum Level 5 Diploma in Leadership and Management for Residential Childcare Course Module 1: Understand children and young people’s development in residential childcare Module 2: Understand support for children and young people who are vulnerable and disadvantaged Module 3: Lead and manage a team within a residential childcare setting Module 4: Lead practice to support the safeguarding and protection of children and young people in residential childcare Module 5: Lead practice for communication and information management in residential childcare settings Module 6: Manage risk in residential childcare Module 7: Lead and manage group living in residential childcare Module 8: Lead a service that can support children or young people who have experienced harm or abuse Module 9: Lead practice to achieve positive outcomes for children and young people in residential childcare Module 10: Implement a Positive Relationship Policy in residential childcare Module 11: Lead practice to support the well-being and resilience of children and young people in residential childcare Module 12: Lead practice in safe use of digital, internet and mobile technology with children and young people Module 13: Undertake professional development in residential childcare settings Module 14: Lead practice to promote the rights, diversity and equality of children and young people in residential childcare Module 15: Lead networks and multi-agency work to benefit children and young people in residential childcare Module 16: Understand the care system and its impact on children and young people Module 17: Lead practice to support young people leaving care Module 18: Understand the context of residential childcare for children and young people with complex disabilities or conditions Module 19: Principles for leading the transition of young people with complex disabilities or conditions to adult services Module 20: Support others to understand models of disability and their effects on working practice with children and young people Assessment Method of Level 5 Diploma in Leadership and Management for Residential Childcare After completing Level 5 Diploma in Leadership and Management for Residential Childcare Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Level 5 Diploma in Leadership and Management for Residential Childcare After completing the Level 5 Diploma in Leadership and Management for Residential Childcare (England) course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £15. Who is this course for? Leadership & Management: Leadership & Management This Level 5 Diploma in Leadership and Management for Residential Childcare course is ideal for anyone in leadership or management within childcare. Special Note: Our Level 5 Diploma in Leadership and Management for Residential Childcare (England) Course is Knowledge based not a regulated course. To get Qualified, you may choose the following options: Level 5 Diploma in Leadership and Management for Residential Childcare (England) (RQF) Level 3 Diploma for Residential Childcare (England) (RQF) Level 5 Diploma in Leadership for Health and Social Care and Children and Young People's Services (England) (RQF) Level 3 Diploma for Residential Childcare (England) (RQF) Level 5 (NVQ) Diploma in Leadership for Health and Social Care and Children's and Young People's Services (England) Level 3 Diploma for Residential Childcare (England) (RQF) ABBE Level 6 Diploma in Residential Surveying and Valuation Level 3 Diploma for Residential Childcare (England) (RQF) Requirements Leadership & Management: Leadership & Management To enrol in this Leadership & Management: Leadership & Management Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Leadership & Management: Leadership & Management Course. Be energetic and self-motivated to complete our Leadership & Management: Leadership & Management Course. Basic computer Skill is required to complete our Leadership & Management: Leadership & Management Course. If you want to enrol in our Leadership & Management: Leadership & Management Course you must be at least 15 years old. Career path Leadership & Management: Leadership & Management With the help of this Level 5 Diploma in Leadership and Management for Residential Childcare (England) course, you will be able to seek several promising career opportunities.

Level 5 Diploma in Leadership & Management for Residential Child care (England)
Delivered Online On Demand35 hours
£12

CSCS Preparation, Construction & Site Management with Building Surveying

5.0(3)

By School Of Health Care

CSCS Preparation, Construction & Site Management with Building Surveying Every year in the UK, people are killed, injured, or suffer work-related illnesses while carrying out their jobs. This CSCS : CSCS - Health and Safety in a Construction Environment course contains important health and safety information and principles, UK laws and legislation, and many work-related illnesses and injuries. This CSCS : CSCS Preparation course includes fundamental electric, gas, and fire safety training, as well as the many forms of PPE, how to operate safely with hazardous chemicals, and other important subjects. After completing this CSCS : CSCS - Health and Safety in a Construction Environment course, you will be able to properly assess and identify onsite hazards, evaluate workplace safety, and ensure complete competence when doing high-risk activities like working at heights. You will also have all the practical knowledge required to work successfully in any construction industry by taking this CSCS : CSCS Preparation course. Learning Outcome of CSCS Preparation, Construction & Site Management with Building Surveying Importance and traits of the construction industry. Basic knowledge about Project Life Cycle. Explain about Project Statutory Clearance. Learn about Work Breakdown Structure and Its Purpose. Understanding the process of estimation and resources allocation for a project. Learn different types of Network Diagrams. Know how to monitor and control risk. Learn how to estimating for planning and scheduling. Understand multiple types of buildings. Learn how to access to site and site roads. Know about how to store various construction materials. Learn all the benefits of Purchasing Equipment. Know about Inventory Management, Stock Planning and Data Bank. Learn about Quality Specification. Other Benefits of This CSCS : CSCS - Health and Safety in a Construction Environment CSCS - Health and Safety in a Construction Environment offer FREE PDF Certificates CSCS - Health and Safety in a Construction Environment offer Lifetime Access CSCS - Health and Safety in a Construction Environment offer Free Retake Exam CSCS - Health and Safety in a Construction Environment offer Expert Tutor Support Main Course: Level 1 Health and Safety in a Construction Environment Gift Courses Included with CSCS Preparation, Construction & Site Management with Building Surveying Course Course 01: Construction Site Management Course 02: Building Surveying Course 03: Level 7 Construction Management [ Note: Free PDF certificate as soon as completing the CSCS Preparation, Construction & Site Management with Building Surveying Course] CSCS Preparation, Construction & Site Management with Building Surveying Course Curriculum of CSCS - Health and Safety in a Construction Environment Module 1: Health and Safety in a Construction Environment CSCS: Know the principles of risk assessment for maintaining and improving health and safety at work CSCS: Know the importance of safe manual handling in the workplace CSCS: Know the importance of working safely at height in the workplace CSCS: Know risks to health within a construction environment CSCS: Know the importance of working around plant and equipment safely Course Curriculum of Level 7 Construction Management Module 1: Introduction to Construction Management Module 2: Arrangement of Construction Projects Module 3: Work Breakdown Structure Explained Module 4: The Process of Estimation and Resources Allocation for a Project Module 5: Planning Project Effectively Module 6: Project Risk Management Module 7: Estimating Cost Module 8: Initial Site Investigation and Assessment Module 9: Site Organisation Module 10: Planning for Construction Equipment Module 11: Managing Construction Equipment Module 12: Managing Construction Materials Module 13: Human Resources Management (HRM) Module 14: Building Better Teams Module 15: Managing Conflict Module 16: Managing Anger and Violence in the Workplace Module 17: Storage Management Module 18: Purchasing and Vendor Management Module 19: Quality Control for Construction Works Module 20: Legal Features of Contracting Course Curriculum of Construction Site Management Module 1: Introduction to Construction Management Module 2: Construction Site Management Module 3: Equipment Procurement Plan Module 4: Construction Project Management Module 5: Equipment Planning Module 6: Purchasing and Procurement Management Module 7: Material Management Module 8: Project Planning Module 9: Management of Construction Project Contract Module 10: Human Resource Management Module 11: Health and Safety in Construction Environment Module 12: Working at Height Module 13: Team Building and Management Module 14: First Aid at Construction Site Module 15: Managing Violence at the Workplace Course Curriculum of Building Surveying Module 01: Foundations of Building Surveying Module 02: Legal Framework in Building Construction Module 03: Construction Contracts and Project Administration Module 04: Advanced Building Information Modeling (BIM) Applications Module 05: Innovations in Building Technology Module 06: Structural Surveys: Foundations and Wall Assessments Module 07: Comprehensive Building Investigations: Floors to Roofs and Chimneys Module 08: Inspection of Building Services Module 09: Diagnosing Building Pathology Assessment Method of CSCS - Health and Safety in a Construction Environment After completing CSCS Preparation, Construction & Site Management with Building Surveying Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Certification of CSCS - Health and Safety in a Construction Environment After completing the CSCS Preparation, Construction & Site Management with Building Surveying course, you can instantly download your certificate for FREE. Who is this course for? CSCS Preparation, Construction & Site Management with Building Surveying This CSCS Preparation, Construction & Site Management with Building Surveying course is designed for those who work on construction sites. Special Note: Our Course is knowledge Based course. Requirements CSCS Preparation, Construction & Site Management with Building Surveying To enrol in this CSCS: CSCS Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our CSCS: CSCS Health and Safety in a Construction Environment Course. Be energetic and self-motivated to complete our CSCS: CSCS Health and Safety Course. Basic computer Skill is required to complete our CSCS : CSCS Health and Safety Course. If you want to enrol in our CSCS : CSCS Health and Safety Course, you must be at least 15 years old. Career path CSCS Preparation, Construction & Site Management with Building Surveying A wide range of professional possibilities in the connected field, including project manager, building inspector, site engineer, and many more, can be explored with the help of this CSCS Preparation, Construction & Site Management with Building Surveying Course!

CSCS Preparation, Construction & Site Management with Building Surveying
Delivered Online On Demand40 hours
£12

Join our Microsoft Excel course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Microsoft Excel course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Microsoft Excel course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! You will Learn The Following Things: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Microsoft Excel. 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 After completing the Microsoft Excel course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Microsoft Excel is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Microsoft Excel 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 Microsoft Excel Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum 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:03: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:03: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.mp4 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 Little Slice of Pie Charts 00:05: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:06: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.mp4 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 Excels 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 The 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:13: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 Loop 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 00:00:00

Microsoft Excel
Delivered Online On Demand13 hours 2 minutes
£11

Maximizing Academic Success: How to Use a Free Assignment Sample in UK

By david hude

This article explores the advantages of using a Free Assignment Sample in UK to improve academic performance. It highlights how New Assignment Help provides valuable resources tailored to UK academic standards, assisting students in creating well-structured, high-quality assignments.

Maximizing Academic Success: How to Use a Free Assignment Sample in UK
Delivered In-PersonFlexible Dates
FREE

Outstanding Leadership is of Essence

By IIL Europe Ltd

Outstanding Leadership is of Essence We are undergoing an enormous amount of change. Aligning tools, acquiring companies, simplifying processes, creating new business models, onboarding new partners and designing new customer services are only some of the elements that constitute what we call "a year of transformation.' One of these efforts is the "Agile Transformation.' To achieve true business agility, we need to incorporate an understanding of a true agile mindset, its processes and structure into the whole company. This is a challenge since it touches upon all areas, including HR, finance and purchasing processes. This presentation will explore how outstanding leadership that models the right culture, behaviors and accountability is what makes or breaks this effort. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Outstanding Leadership is of Essence
Delivered Online On Demand45 minutes
£10

Data Science and Data Analytics with Python

By Xpert Learning

About Course Data Science and Data Analytics with Python: A Comprehensive Course for Beginners Unlock the power of data and gain insights that drive informed decisions with this comprehensive course on data science and data analytics with Python. This course is designed for beginners of all skill levels, with no prior programming experience required. You will learn the essential skills to embark on your data-driven journey, including: Data manipulation with NumPy and Pandas Data visualization with Matplotlib and Seaborn Statistical analysis with Python Machine learning and artificial intelligence You will also gain hands-on experience with real-world data projects, allowing you to apply your newfound knowledge to solve real-world problems. By the end of this course, you will be able to: Understand the fundamentals of data science and data analytics Apply Python to manipulate, visualize, and analyze data Use Python to build machine learning and artificial intelligence models Solve real-world data problems This course is the perfect launchpad for your data science journey. Whether you are looking to pivot your career, enhance your skill set, or simply quench your curiosity, this course will give you the foundation you need to succeed. Enroll today and start exploring the fascinating world of data science together! What Will You Learn? Understand the fundamentals of data science and data analytics Apply Python to manipulate, visualize, and analyze data Use Python to build machine learning and artificial intelligence models Solve real-world data problems Course Content Introduction to Python Data Science Introduction to Python Data Science Environment Setup Data Cleaning Packages Working with the Numpy package Working with Pandas Data science package Data Visualization Packages Working with Matplotlib Data Science package (Part - 1) Working with Matplotlib Data Science (Part - 2) A course by Uditha Bandara Microsoft Most Valuable Professional (MVP) RequirementsBeginners level knowledge for working with Data .Programming knowledge not required. Audience Beginners with no prior programming experience Anyone interested in learning data science and data analytics Audience Beginners with no prior programming experience Anyone interested in learning data science and data analytics

Data Science and Data Analytics with Python
Delivered Online On Demand
£9.99

Building Quantity Surveying & Land Laws UK

By EduXpress

Our comprehensive program is meticulously crafted to equip you with the essential skills and knowledge required to thrive in your chosen field. Developed by seasoned professionals with years of industry experience, this course is ideal for those seeking to kickstart their careers or enhance their existing skill set. Featuring an engaging audio-visual presentation and easily digestible modules, our program facilitates a self-paced learning experience. Our dedicated online support team is available on weekdays to provide assistance throughout your journey. Key Learning Outcomes: Grasp the fundamentals and their practical applications. Cultivate the necessary skills for success in your field. Apply newfound knowledge to real-world scenarios. Develop effective solutions for relevant topics. Elevate your employability and career prospects.   Designed to give you a competitive edge in the job market, this course offers lifetime access to materials and the flexibility to learn at your own pace, from the comfort of your home. Why Choose Us? Learn at your own pace with 24/7 online access to course materials. Benefit from full tutor support available Monday through Friday. Acquire essential skills in the convenience of your home through informative video modules. Enjoy 24/7 assistance and advice via email and live chat. Study on your preferred device - computer, tablet, or mobile. Gain a thorough understanding of the course content. Improve professional skills and earning potential upon completion. Access lifetime course materials and expert guidance. Enjoy the convenience of online learning with flexible schedules. Why Enroll in This Course? Our program provides a comprehensive introduction to the subject matter, laying a solid foundation for further study. It empowers students to acquire knowledge and skills applicable to both their professional and personal lives. Assessment: The course incorporates quizzes to evaluate your understanding and retention of the material. These quizzes pinpoint areas for further practice, allowing you to review course materials as needed. Successfully passing the final quiz qualifies you for a certificate of achievement. Career Path: Our course is meticulously designed to equip you for success in your chosen field. Upon completion, you'll have the qualifications to pursue diverse career opportunities across various industries. Course Content Building Quantity Surveying & Land Laws UK Module 1. Introduction to Quantity Surveying Module 2. Building / Construction Economics Module 3. Tools and Techniques of Surveying Module 4. Surveying Instrumentation Module 5. Building Information Modelling (BIM) Module 6. Area Measurement Module 7. Measurement Volumes Module 8. Levelling Module 9. Contouring Module 10. Distance Measurement

Building Quantity Surveying & Land Laws UK
Delivered Online On Demand
£10.49

Assessment Beyond Grades: Fostering a Growth Mindset

By Roy Butler

Fostering a growth mindset in education transforms assessments into tools for learning, encouraging resilience, effort, and continuous improvement beyond traditional grading for enhanced student development.

Assessment Beyond Grades: Fostering a Growth Mindset
Delivered Online On Demand1 hour
FREE

Making the Shift: Project Manager to Scrum Master

By IIL Europe Ltd

Making the Shift: Project Manager to Scrum Master Working within an Agile environment requires more than learning a framework or process. This scenario-driven presentation will address how we traditionally react to the organization and teams as a project manager, and the mental models and behaviors we need to adopt to successfully shift to agility. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Making the Shift: Project Manager to Scrum Master
Delivered Online On Demand15 minutes
£10