44606 Courses delivered Online

Overview of Sociology Online Course Sociology is the scientific study of society, exploring how people interact, behave in groups, and form social structures. Our immersive sociology online course will help you uncover the complexities of human societies.  Explore various sociological perspectives, understanding the connections that unite us and influence our shared experiences. Start your journey through diverse cultural landscapes, uncovering the intricate interplay between individuals, groups, and institutions. Investigate the profound impact of socialisation, the nuances of gender and sexuality, and the ever-evolving dynamics of social change.  With over 45,000 students enrolled in the UK, this sociology online course empowers you to navigate the complexities of our interconnected world, fostering a profound understanding of the human condition and the forces that shape our collective narratives. Get a quick look at the course content: This Sociology Online Course will help you to learn: Understand key sociological concepts and theories. Analyse social structures and processes within society. Explore the role of culture and socialisation in shaping individuals. Examine social stratification, gender, and family dynamics. Critically evaluate social change and social movements. Develop research skills for sociological analysis. This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Sociology Online Course. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-One Support from a Dedicated Tutor Throughout Your Course. Study Online - Whenever and Wherever You Want. Instant Digital/ PDF Certificate, 100% Money Back Guarantee, 12 Months Access, Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Sociology Online Course online course, you can order your CPD Accredited Digital / PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? Individuals seeking a more profound comprehension of societal dynamics. Students pursuing undergraduate or postgraduate studies in sociology. Professionals in fields like social work, counselling, or policymaking. Anyone interested in understanding human behaviour and social change. Researchers or analysts exploring sociological concepts and methodologies. Requirements You don't need any educational qualification or experience to enrol in the Sociology Online Course online 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 Sociology graduates pursue diverse careers. Here are some examples with average UK salaries: Social Worker: £22,000 to £35,000/year. Policy Officer - £22,000 to £55,000/year Sociology Lecturer - £33,000 to £51,000/year Researcher - £23,000 to £40,000/year Data Analyst - £23,000 to £60,000/year Course Curriculum Module 01: Introduction to Sociology Introduction to Sociology 00:40:00 Module 02: Sociological Perspectives and Theories Sociological Perspectives and Theories 01:00:00 Module 03: Society and Culture Society and Culture 00:40:00 Module 04: Socialisation and Social Interaction Socialisation and Social Interaction 00:25:00 Module 05: Social Stratification Social Stratification 00:45:00 Module 06: Gender, Sex, and Sexuality Gender, Sex, and Sexuality 00:50:00 Module 07: Marriage and Family Marriage and Family 00:50:00 Module 08: Religion and Education Religion and Education 00:30:00 Module 09: Social Change: Collective Behaviour and Social Movements Social Change: Collective Behaviour and Social Movements 00:30:00 Module 10: Sociological Research Sociological Research 00:25:00 Final Exam Final Exam - Sociology 00:25:00 Assignment Assignment - Sociology 00:00:00

Overview of Speech & Language Therapy for Children Unearthing a Child's Voice: Opportunities in Speech & Language Therapy Imagine a child's laughter cascading like wind chimes, weaving stories with every syllable. But for some children, words are elusive butterflies, just out of reach. This is where the magic of Speech & Language Therapy comes in. In the UK alone, millions of children experience communication challenges, hindering their academic and social development. Yet, the demand for skilled therapists far outpaces the supply. This presents a unique opportunity for you to become a champion, a bridge builder, helping children unlock their voices and unleash their full potential. This comprehensive Speech & Language Therapy for Children course , equips you with the knowledge and tools to navigate this rewarding field. From understanding the intricate science of speech to mastering therapeutic techniques, you'll delve into the fascinating world of child development, language acquisition, and joint disorders like stuttering and dyslexia. Empower a child's voice. Shape a brighter future. Enroll in 'Speech & Language Therapy for Children' today! Get a quick look at the course content: This Speech & Language Therapy for Children Course will help you to learn: Comprehend the theoretical underpinnings of speech & language development. Analyse the anatomical and physiological systems supporting speech production. Identify and diagnose various speech & language disorders in children. Develop and implement effective intervention strategies for diverse needs. Evaluate the impact of therapy and collaborate with families and educators. Promote literacy and language acquisition through engaging, evidence-based practices. This course covers the topics you must know to stand against the tough competition. The future is truly yours to seize with this Speech & Language Therapy for Children. 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, your skills and knowledge will be tested with an MCQ exam or assignment. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Speech & Language Therapy for Children course, you can order your CPD Accredited Digital / PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? Aspiring speech & language therapists Teachers, child care professionals, and early years practitioners Parents and caregivers seeking to support their child's communication development Anyone passionate about child development and language acquisition Requirements You don't need any educational qualification or experience to enrol in the Speech & Language Therapy for Children 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 Speech & Language Therapist - £28K to £50K/year Educational Psychologist - £30K to £55K/year SEN (Special Educational Needs) Teacher - £27K to £45K/year Early Years Practitioner - £22K to £35K/year Language Assistant - £20K to £30K/year Course Curriculum Module 01: An Overview Of Speech Therapy An Overview Of Speech Therapy 00:13:00 Module 02: The Science Of Speech The Science Of Speech 00:20:00 Module 03: The Anatomy Of Speech The Anatomy of Speech 01:00:00 Module 04: Characteristic Of Speech: Linguistic Discipline Characteristic of Speech: Linguistic Discipline 00:27:00 Module 05: Literacy And Language Development Literacy and Language Development 00:22:00 Module 06: Child Speech & Language Disorders Child Speech & Language Disorders 00:32:00

Duration 2 Days 12 CPD hours This course is intended for This course is intended for SQL Server administrators who work in a Windows network environment. At least one year of experience administering SQL Servers and using PowerShell is recommended. Overview After completing this course, students will be able to: •Install and Configure SQL Server and all its components using PowerShell •Manage day-to-day SQL Server Administration with PowerShell •Maintain the SQL Server environment using PowerShell scripting and programming options This course provides candidates with the knowledge and skills needed to use PowerShell for SQL Server administration. Students will learn how to manage day-to-day and scheduled maintenance tasks. Install and Configure SQL Server with PowerShell Install SQL Server Configure Database Settings Configure SQL Server Settings Configure SQL Server Policy-Based Management Lab 1: Configuring SQL Server with PowerShell Administering SQL Servers with PowerShell Managing Users and Roles Managing Database Performance Managing Database Availability Managing SQL Server Features Lab 1: Administering SQL Servers with PowerShell Maintaining SQL Server with PowerShell Managing Backups and Restores Maintaining Database Integrity and Performance Monitoring and Auditing Task Automation Generating Reports Lab 1: Maintaining SQL Servers with PowerShell

As part of this course, you will learn how to communicate your organisation’s vision and values to others effectively.

This instructor-led video course focuses on the major injuries and illnesses that are likely to occur when participating in sports.

This course aims to help you advance your career by ensuring that you excel in business management.

The Manual Handling course shows you which tasks require manual handling and how to keep yourself safe.

Duration 1 Days 6 CPD hours In this hands on workshop for Agile Scrum Masters, Release Train Engineers and anyone serving as Jira Administrators, Jira experts will lead you through advanced configuration and customization settings in Jira, from installation through to customized screens, workflows, filters and reports. Jira Administration Adding and managing Users Administering and managing Groups Global Jira Settings Jira layout and interface customization User authentication and security Jira Customization Customization of screens and fields Customization of workflows Project and Board Administration Configuring and managing Projects Configuring and managing Boards Creating and managing Filters JQL Jira Integration Integrating Jira with Atlassian Tools Retrospectives and Documentation in Confluence Code management with Bitbucket Integration management with Bamboo Building a Dashboard with gadgets Jira Plug-ins and Marketplace

Duration 5 Days 30 CPD hours This course is intended for This basic course is intended for anyone who is new to software development and wants, or needs, to gain an understanding of the fundamentals of coding and basics of Java and object-oriented programming concepts. Attendees might include: Technically-minded attendees who want or who want to begin the process of becoming an OO application developer Technical team members from non-development roles, re-skilling to move into software and application development roles within an organization Recent college graduates looking to apply their college experience to programming skills in a professional environment, or perhaps needing to learn the best practices and standards for programming within their new organization Technical managers tasked with overseeing programming teams, or development projects, where basic coding knowledge and exposure will be useful in project oversight or communications needs Overview This 'skills-centric' course is about 50% hands-on lab and 50% lecture, designed to train attendees in basic coding with Java, coupling the most current, effective techniques with the soundest industry practices. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment, guided by our expert team, attendees will learn: The steps involved in the creation and deployment of a computer program What OO programming is and what the advantages of OO are in today's world To work with objects, classes, and OO implementations The basic concepts of OO such as encapsulation, inheritance, polymorphism, and abstraction The basic constructs that all programming languages share The basic Java constructs supporting processing as well as the OO orientation How to use Java exception handling About and how to use classes, inheritance and polymorphism About use collections, generics, autoboxing, and enumerations How to take advantage of the Java tooling that is available with the programming environment being used in the class Getting Started with Programming, OO and Java Basics for Non-Developers is a skills-focused, hands-on coding course that teaches students the fundamentals of programming object oriented (OO) applications with Java to a basic level, using sound coding skills and best practices for OO development. This course is presented in a way that enables interested students to embrace the fundamentals of coding as well as an introduction to Java, in a gentle paced environment that focuses on coding basics.Students are introduced to the application development cycle, structure of programs, and specific language syntax. The course introduces important algorithmic constructs, string and character manipulation, dynamic memory allocation, standard I/O, and fundamental object-oriented programming concepts. The course explains the use of inheritance and polymorphism early on so the students can practice extensively in the hands-on labs. Structured programming techniques and error handling are emphasized. The course includes the processing of command line arguments and environment variables, so students will be able to write flexible, user-friendly programs. Students will leave this course armed with the required skills to begin their journey as a Java programmer using modern coding skills and technologies. Introduction to Computer Programming Introduction to Programming Programming Tools Programming Fundamentals Thinking About Objects Program Basics Programming Constructs Java: A First Look The Java Platform Using the JDK The Eclipse Paradigm Writing a Simple Class OO Concepts Object-Oriented Programming Inheritance, Abstraction, and Polymorphism Getting Started with Java Adding Methods to the Class Language Statements Using Strings Specializing in a Subclass Essential Java Programming Fields and Variables Using Arrays Java Packages and Visibility Advanced Java Programming Inheritance and Polymorphism Interfaces and Abstract Classes Exceptions Java Developer's Toolbox Utility Classes Enumerations and Static Imports Formatting Strings Collections and Generics Introduction to Generics Collections

Ascend to the next level of Excel proficiency with our comprehensive Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course. This in-depth training will equip you with the skills to create sophisticated dashboards using advanced Excel formulas, VBA, and Power Query, empowering you to transform raw data into actionable insights. Master the art of financial modeling with our prepaid expenses models, learning how to calculate amortization schedules and create detailed summaries using Excel formulas. Delve into the power of Power Query to effortlessly manipulate and analyze large datasets, building dynamic dashboards without the limitations of formulas. Learning Outcomes Gain proficiency in creating automated dashboards using advanced Excel formulas, VBA, and Power Query Develop expertise in financial modeling using prepaid expenses models Master the calculation of amortization schedules and prepaid expenses summaries Implement Power Query to manipulate and analyze large datasets Create dynamic dashboards without the limitations of formulas Enhance your Excel skills and data analysis capabilities Why choose this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course for? Accounting and finance professionals seeking to enhance their Excel skills for financial modeling and dashboard creation Business analysts and data analysts aiming to expand their expertise in data manipulation and visualization Excel enthusiasts interested in mastering advanced Excel formulas, VBA, and Power Query Individuals seeking to create interactive and insightful dashboards for data-driven decision-making Anyone seeking to elevate their Excel skills and become a proficient data analyst Career path Financial Analyst (£35,000 - £55,000) Business Analyst (£40,000 - £60,000) Data Analyst (£45,000 - £65,000) Management Accountant (£40,000 - £60,000) Business Intelligence Analyst (£45,000 - £65,000) Senior Financial Analyst (£50,000 - £70,000) Prerequisites This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum 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 Thank you 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 Assignment Assignment - Microsoft Excel: Automated Dashboard Using Advanced Formula VBA Power Query 00:00:00