5473 Courses in Glasgow delivered On Demand

The Child Neglect Awareness & Protection - CPD Accredited Course offers an in-depth exploration of the crucial topic of child neglect, aiming to provide learners with a strong foundation in recognising the signs and understanding the legal and ethical frameworks designed to protect children. This course equips participants with the knowledge to identify various forms of neglect and offers valuable insights into the impact neglect can have on a child's development and well-being. The curriculum is structured to be easily accessible and relevant to a broad audience, from professionals in child protection to anyone wanting to gain a better understanding of this critical issue. Throughout the course, learners will be introduced to a range of strategies and interventions that can be applied in different settings to help protect vulnerable children. With engaging content, real-life case studies, and up-to-date resources, this course ensures that participants gain not only theoretical knowledge but also a clear understanding of their role in promoting child welfare. Perfect for those seeking to improve their knowledge in child protection, this course is designed to make a meaningful impact and support learners in making informed decisions in their professional or personal lives. Still not convinced? Take a glimpse of the key benefits you'll get with - Lessons prepared in collaboration with Professionals User-friendly Learner Management System (LMS) Syllabus designed in line with the standards of the UK Education System Updated Study Materials focusing both on Knowledge and Skill based training Guidance to expand in 'a' territory and move forward with Child Psychologist or Child Carer profession Free Assessment to test learners' knowledge and skills Course Curriculum: Module 01: Introduction to Child Neglect Module 02: Signs of Child Neglect Module 03: Risk Factors for Neglect Module 04: The impact of Child Neglect Module 05: Child Neglect Cases Module 06: Legislation Surrounding Child Neglect Module 07: Responding to and Reporting Child Neglect Module 08: Prevent Child Negligence Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing the Child Neglect Awareness & Protection - CPD Accredited course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Child Neglect Awareness & Protection - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Child Neglect Awareness & Protection - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Child Neglect Awareness & Protection - CPD Accredited training.

Your bike won’t fix itself—but it’ll certainly thank you for learning how. The Beginner Bike Maintenance CPD Accredited Course is your no-nonsense guide to keeping your bicycle in good working order, without the need for guesswork or mysterious creaking sounds. Whether you're commuting to work, enjoying countryside rides, or attempting to remember where you last left your Allen keys, this course will help you make sense of your bike from top to tyres. Designed with beginners in mind, the course introduces essential maintenance knowledge in a clear, approachable way. You'll explore topics such as tyre checks, brake adjustments, chain care, and basic troubleshooting—so you're better equipped to keep your bike rolling smoothly. Delivered entirely online, this course offers the flexibility to learn at your own pace, with bite-sized lessons and jargon-free guidance. It’s sensible, straightforward, and far more rewarding than wrestling with a repair video at 11pm. Still not convinced? Take a glimpse of the key benefits you'll get with - Lessons prepared in collaboration with Professionals User-friendly Learner Management System (LMS) Syllabus designed in line with the standards of the UK Education System Updated Study Materials focusing both on Knowledge and Skill based training Guidance to expand in 'a' territory and move forward with Bicycle Mechanic profession Free Assessment to test learners' knowledge and skills Course Curriculum: Module 01: Know Your Bike Module 02: Must-Haves for Your Toolbox Module 03: Regular Bike Maintenance Module 04: Tyre Module 05: The Wheels Module 06: The Brakes Module 07: The Saddle Module 08: The Chain Module 09: The Steering System Module 10: The Gears Module 11: Pedals and Drivetrain Module 12: Suspension Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing the Beginner Bike Maintenance - CPD Accredited course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Beginner Bike Maintenance - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Beginner Bike Maintenance - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Beginner Bike Maintenance - CPD Accredited training.

The Construction Site Management - CPD Accredited Course provides a thorough exploration of the vital aspects of managing a construction site efficiently. Aimed at individuals keen to build expertise in the field, this course equips learners with the skills needed to oversee construction projects from start to finish. From safety protocols to resource allocation, participants will gain a solid understanding of the complexities involved in managing a site, ensuring smooth operations and compliance with industry standards. Through this course, you’ll learn the ins and outs of scheduling, budgeting, team coordination, and quality control – all crucial for managing construction projects that meet deadlines and stay within budget. Whether you’re looking to advance your career or broaden your knowledge in the field, this course is designed to provide the insight necessary to succeed. With a balance of theoretical and strategic knowledge, you’ll be ready to tackle the challenges that come with managing dynamic construction environments. Course Curriculum: Module 01: Introduction to Construction Management Module 02: Site Management Module 03: Cost Estimation Module 04: Cost Management Module 05: Planning and Management of Equipment Module 06: Construction Materials Management Module 07: Stock Control Module 08: Supply Chain Management Module 09: Preliminary Site Investigation and Site Organisation Module 10: Vendor Analysis in Construction Management Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Construction Site Managment - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Construction Site Managment - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Construction Site Managment - CPD Accredited training.

Words have power—and knowing how to wield them with precision, flair and purpose is a skill worth mastering. This Creative Writing course is designed for those with a passion for storytelling, whether you're drawn to fiction, poetry, blogs, or writing that lives outside the box. From shaping vivid characters to creating irresistible narratives, you’ll explore the core principles of imaginative writing while discovering your unique voice along the way. Crafted with flexibility in mind, this course welcomes learners of all backgrounds, from curious beginners to those dusting off old notebooks. It’s delivered entirely online, so you can work through the modules at your own pace, whenever inspiration strikes—be it sunrise or during your fifth cup of tea. By the end, you’ll walk away with sharpened writing tools, a fresh perspective, and a CPD certificate to proudly display (or post on your fridge for motivation). Whether you're writing for pleasure or polishing your skills for publication, this course offers a smart and enjoyable way to grow. Still not convinced? Take a glimpse of the key benefits you'll get with - Lessons prepared in collaboration with Professionals User-friendly Learner Management System (LMS) Syllabus designed in line with the standards of the UK Education System Updated Study Materials focusing both on Knowledge and Skill based training Guidance to expand in 'a' territory and move forward with Content Developer profession Free Assessment to test learners' knowledge and skills Accredited learning and widely recognised certificate from reputed CPD Accreditation Bodies Course Curriculum: Module 01: Introduction to Creative Writing Module 02: The Development of Creative Writing Module 03: Novel Writing Module 04: Writing Non-Fiction Module 05: Creating Fictional Characters Module 06: Writing Realistic Dialogue Module 07: Writing Horrors, Thriller and Murder Stories Module 08: Writing for Children Module 09: Writing Poetry Module 10: Proposal Writing Module 11: Critical Thinking Module 12: Business Writing Module 13: Other Writings Module 14: Editing, Evaluating and Getting Published Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing the Creative Writing - CPD Accredited course. For each test, the pass mark will be set to 60%. CPD 10 CPD hours / points Accredited by The CPD Certification Service Who is this course for? The Creative Writing - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Creative Writing - CPD Accredited training.

Gas safety isn't just a technical detail—it’s a serious matter that affects lives, properties, and businesses. This CPD-accredited Gas Safety course has been designed with clarity and responsibility in mind, ideal for anyone who wants to build awareness around gas hazards, understand safety measures, and stay informed about the latest industry regulations. Whether you work in facilities management, oversee property maintenance, or simply wish to boost your foundational knowledge, this course provides straight-talking guidance without the fluff. The content is entirely online and thoughtfully structured, so you can absorb vital safety information at your own pace and in your own space. From identifying warning signs to understanding key protocols around gas appliances, this course helps you develop a sharp understanding of safe practices. With a smart, no-nonsense approach, it’s geared for those who take safety seriously—and want to prove it with recognised CPD certification. Course Curriculum: Module 01: Gas Safety Legislation Module 02: Combustion Module 03: Transmission System: Pipes and Flues Module 04: Ventilation Module 05: Tightness Testing Module 06: Meter Regulator Check Module 07: Appliance Pressures and Gas Rates Module 08: Emergency Isolation Controls and Valves Module 09: Gas Safety Devices and Controls Module 10: Gas Warning Labelling Module 11: Emergency and Evacuation Procedures Module 12: Chimney Standards, Inspection and Testing Module 13: Gas Appliances and Safety Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. CPD 10 CPD hours / points Accredited by The CPD Certification Service Who is this course for? The Gas Safety - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Gas Safety - CPD Accredited training.

If you've ever found yourself correcting someone else's parallel parking from the passenger seat—or silently grading their roundabout etiquette—this course is probably your natural habitat. The Driving Instructor - CPD Accredited Course is tailored for those ready to steer learners in the right direction with confidence, theory-based expertise, and a healthy supply of patience. Delivered entirely online, it offers a flexible and engaging approach to the knowledge needed to guide others through the rules of the road without raising your blood pressure. Designed with precision and no unnecessary detours, this course helps build a thorough understanding of essential driving concepts, instructional strategies, safety standards, and DVSA-aligned regulations. Whether you're starting out or seeking to sharpen your road-savvy instructional finesse, you'll find the material informative, accessible, and refreshingly free from clichés. It’s the perfect route for those who enjoy helping others find their way—ideally using their mirrors, indicators, and a touch of common sense. Still not convinced? Take a glimpse of the key benefits you'll get with - Lessons prepared in collaboration with Professionals User-friendly Learner Management System (LMS) Syllabus designed in line with the standards of the UK Education System Updated Study Materials focusing both on Knowledge and Skill based training Guidance to expand in 'a' territory and move forward with Driving Instructor profession Free Assessment to test learners' knowledge and skills Accredited learning and widely recognised certificate from reputed CPD Accreditation Bodies Course Curriculum: Module 01: The Driving Instructor Module 02: Structured Driver Training Module 03: The ADI Exams Module 04: Communication Skills and Dealing with a New Client Module 05: Learning to Drive Module 06: Driving Large Vehicles Module 07: Assessment Items Module 08: Disabilities and Impairments Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing the Driving Instructor - CPD Accredited course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Driving Instructor - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Driving Instructor - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Driving Instructor - CPD Accredited training.

Course Overview Learn the Latest Skills | Acknowledged by CPD & QLS | Acknowledged Certificate | MCQ Based Exam & Tutor Support | Interactive Video Training  Even while there are millions of people who aspire to start a new life abroad, the vast majority of them will never realize their ambitions. Taking a TEFL (TESOL) Course is a terrific way to get started on the path to a new life of living and working abroad if you want to be one of those people who make it happen. Through this course, you will acquire the fundamental abilities required to train as an English language teacher. This involves a critical comprehension of the grammar and structure of the English language as well as a variety of classroom management abilities and language teaching methodologies. What Will You Learn? Gain the fundamental knowledge of the principles of teaching English as a foreign language Discover a wide range of approaches and methods for teaching foreign students Develop the practical skills to deliver engaging, informative and inclusive lessons Explore the role and responsibilities of a TESOL teacher & understand the challenges teacher and students may face Receive an internationally acknowledged teacher education lesson on successful course completion Learn effective methods for teaching the four language skills: reading, writing, speaking and listening Understand the basics of classroom management to create dynamic lesson plans Get expert career guidance and understand your job opportunities & requirements for teaching roles What classes are included in this package? Earn a digital certificate upon successful completion There are no set schedules, so you can work at your own pace. Our email and live chat specialists are available to assist you 24 hours a day, 7 days a week. On weekdays, you'll have access to a full-time tutor. Learn in a user-friendly, cutting-edge online learning environment. High-quality e-learning study materials Benefit from instant feedback through mock exams and multiple-choice assessments Who Should Take This Course? You will learn everything that is needed regarding Teaching English as a Foreign Language. This is an excellent opportunity for anyone from any academic background to learn more and advance their learning, launch a new career or reinvigorate an existing one. Career Path Training offered by the TEFL (TESOL) Course could potentially benefit a range of roles, but would particularly enhance careers in: Teacher Consultancy Life Coach Career Counsellor Other Administrative Roles Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessments Assignment Certificate of Achievement After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99. Please note that overseas students may be charged an additional £10 for postage. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment On successful completion of the TEFL (TESOL) Course, you will be required to sit an online multiple-choice assessment. You will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for a Quality Licence Scheme endorsed certificate of achievement. The assessment will be evaluated automatically and the results will be given to you immediately. Course Content Module 01: Introduction to English Language Teaching & Learning Module 02: Linguistics Module 03: English Pronunciation Module 04: Teaching Grammar and Vocabulary Module 05: Language Teaching Methodologies Module 06: Teaching Receptive Skills: Reading Module 07: Teaching Productive Skills: Writing Module 08: Teaching Receptive Skills: Listening Module 09: Teaching Productive Skills: Speaking Module 10: Lesson Planning and Creating Materials Module 11: Use of Games and Activities Module 12: Technology in Second Language Teaching & Learning Module 13: Classroom Management and Student Motivation Module 14: Teaching English: Situational Approach Module 15: Professional Development and Employment

Course Overview Learn the Latest Skills | Accredited by CPD | Recognised Certificate | MCQ Based Exam & Tutor Support | Interactive Video Training  Mental health is just as important as physical health. However, a healthy body will not do you good if your mental health is abysmal. And the sad thing is that many people struggle with their mental health. And most people don't even realise that they need professional help. Therefore, we created this Mental Health Support Worker Training - Level 3 course. If you want to learn about mental health and help people suffering from mental health issues, this course is for you. You will gain the skills to understand various mental health conditions and how to work with and provide treatment for people struggling with their mental health. Get started with our course now and get proper mental support worker training to help people with their mental health. Enrol now and get certified! Please note: This course only gives you the theoretical knowledge you need to excel in this field. This Mental Health Support Worker Training - Level 3 doesn't entitle you to practise as a professional in this field. What Will You Learn? Overview of mental health support worker Learn about different anxiety and mood disorders How to treat various mental illness Laws and policies concerning mental health Have a strong, flexible mental aptitude and adapt to unpredictable situations What classes are included in this package? Earn a digital Certificate upon successful completion accredited by UK and internationally recognised accredited qualification There are no set schedules, so you can work at your own pace. Our email and live chat specialists are available to assist you 24 hours a day, 7 days a week. On weekdays, you'll have access to a full-time tutor. Learn in a user-friendly, cutting-edge online learning environment. High-quality e-learning study materials Lifetime Access Benefit from instant feedback through mock exams and multiple-choice assessments Who Should Take This Course? Mental Health Support Worker Training - Level 3 is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This is a great opportunity for all students from any academic background to learn more about this subject. Career Path Training offered by the Mental Health Support Worker Training - Level 3 could potentially benefit a range of roles but would particularly enhance careers in: Health Care Assistant Support Worker Home care support worker Clinical Psychiatrist Nurse Neuropsychologist Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessments Assignment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Method of Assessment On successful completion of the Mental Health Support Worker Training - Level 3, you will be required to sit an online multiple-choice assessment. You will need to score 60% or above to pass the course. The assessment will be evaluated automatically and the results will be given to you immediately. Retake fee If you do not pass the exam first time, you can purchase the Retake Exam for £1.99 and try again. Course Contents Module 1: Introduction to Mental Health Module 2: Overview of Mental Health Support Worker Module 3: Childhood and Adolescent Psychiatric Disorders Module 4: Stress and Anxiety Disorders Module 5: Schizophrenia Module 6: Personality Disorders Module 7: Mood Disorders Module 8: Eating & Sleeping Disorders Module 9: Self-Harm and Suicide Module 10: Medication and Therapy in the Treatment of Mental Illness Module 11: Mental Health Legislation and Services Module 12: Community Mental Health Teams (CMHTs) Module 13: The Participation of the Service User

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

The 120 hours TEFL (TESOL) Masterclass - CPD Accredited 3 Courses Bundle is designed for individuals who aspire to teach English to non-native speakers. This extensive course offering covers everything from foundational language teaching strategies to more advanced classroom management and lesson planning. With the CPD accreditation, you can be confident in the quality and credibility of the course content, equipping you with the knowledge needed to teach English effectively in diverse educational settings. Throughout the three courses, learners will gain insight into the most effective teaching methodologies, the nuances of different cultural contexts, and the skills required to create engaging, structured lessons. The course allows flexibility, meaning you can study at your own pace and at a time that suits you, all while enhancing your professional qualifications. This package provides a solid foundation for those wishing to teach English globally, setting you on the right path to becoming a confident and competent English teacher. Course Curriculum: Module 01: Introduction to IELTS Module 02: IELTS Test Format Module 03: Grammar for IELTS: Basics of Grammar Module 04: Grammar for IELTS: The Basics of Sentence Module 05: Grammar for IELTS: Structure of Sentence Module 06: Grammar for IELTS: Punctuation & Capitalisation Module 07: The Listening Section Module 08: The Reading Section [Academic] Module 09: The Writing Section [Academic] Module 10: The Speaking Section Module 11: IELTS [General Training] Module 12: IELTS Life Skills Module 13: What To Do Before The IELTS Test? Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing each 120 hours TEFL (TESOL) Masterclass - CPD Accredited 3 Courses Bundle bundle course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this 120 hours TEFL (TESOL) Masterclass - CPD Accredited 3 Courses Bundle course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. This 120 hours TEFL (TESOL) Masterclass - CPD Accredited 3 Courses Bundle provides you with the required knowledge and skills to achieve a rewarding career in a rapidly growing industry. By enrolling today, you can take your knowledge to a whole new level and quickly reap the rewards of your study in relevant fields. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced-level topics. The courses in the 120 hours TEFL (TESOL) Masterclass - CPD Accredited 3 Courses Bundle bundle are relevant, reliable, and up-to-date. Moreover, since the courses are CPD QS accredited, they will boost your career and improve your CV. Industry experts design the 120 hours TEFL (TESOL) Masterclass - CPD Accredited 3 Courses Bundle to ensure you learn everything thoroughly. All three courses in the bundle will help you to give your career a boost. We look forward to sharing our knowledge and experience to help you become more confident and comfortable with the topic. Enrol today and start your journey to career development. These comprehensive courses are available in this 120 hours TEFL (TESOL) Masterclass - CPD Accredited 3 Courses Bundle Course 01: 120 hours TEFL (TESOL) Course 02: English: Spelling, Pronunciation and Grammar Course 03: IELTS Preparation ** Special Offer: Free PDF and Hard Copy Certificates** Key Benefits Get instant PDF and Hard Copy certificate Fully online courses Developed by qualified professionals Self-paced learning and laptop, tablet, and smartphone-friendly 24/7 Learning Assistance CPD 30 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The 120 hours TEFL (TESOL) Masterclass - CPD Accredited 3 Courses Bundle training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our 120 hours TEFL (TESOL) Masterclass - CPD Accredited 3 Courses Bundle training.