5699 Courses

There’s only so much time in a day, and unfortunately, it doesn't come with a pause button or a snooze function. Our CPD Accredited Time Management Course is designed for individuals looking to master the art of using time without feeling like they’re constantly racing it. Whether you're dealing with overflowing to-do lists or simply wondering where your afternoon went (again), this course provides strategies for planning, prioritising, and getting more done without sacrificing your sanity. Perfect for professionals, remote workers, managers, or anyone who’s ever felt personally victimised by their calendar, this course focuses on goal-setting, task organisation, delegation techniques, and managing distractions. You’ll explore tried-and-tested time frameworks that support productivity, without needing a spreadsheet the size of a football pitch. And because it’s 100% online, you can learn it all from your preferred device—preferably not while also replying to emails and making tea. After all, we’re here to help you manage your time… not test your multitasking limits. Course Curriculum: Module 01: Importance and Benefits of Time Management Module 02: Assess Your Current Work Practice Module 03: Identify the Priorities Module 04: Overcome Procrastination Module 05: Set Your Goals Module 06: Plan The Work and Work The Plan Module 07: Effective Time Management Techniques Module 08: The Art of Anticipating 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 Time Management - 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 Time Management - 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 Time Management - CPD Accredited training.

Lifting Operations and Lifting Equipment Regulations (LOLER) are no laughing matter—despite the acronym’s cheerful tone. This CPD-accredited online course dives straight into the essentials of LOLER, making sure anyone responsible for lifting equipment knows exactly what’s required to meet UK safety standards. With a clear focus on legal duties, risk assessment, equipment inspection, and maintenance procedures, this training is tailored to suit a wide range of industries without wandering into the overly technical or sleep-inducing. Whether you're supervising construction hoists, managing warehouse operations, or overseeing workplace safety, this course is designed to help you keep everything above board—and off the floor. Delivered 100% online, it’s accessible anytime and anywhere, giving you the flexibility to learn without disrupting your schedule (or your coffee breaks). If you're looking to strengthen your understanding of LOLER with content that gets to the point and stays there—this is it. No fluff, no filler, just the facts you need in a format you’ll actually want to read. Course Curriculum: Module 01: Introduction to LOLER Module 02: Part 01 - Selecting Lifting Equipment and Accessories Module 03: Part 02 - Selecting Lifting Equipment and Accessories Module 04: Planning the Lifting Operation Module 05: Factors Affecting Safe Lifting Operation Module 06: Roles and Responsibilities Module 07: Risk Assessment Module 08: Examination and Inspection Module 09: Reports and Defects 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 LOLER Training - 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 LOLER Training - 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 LOLER Training - CPD Accredited training.

Managing a team isn’t just about delegating tasks and crossing fingers. It’s a careful blend of strategy, communication, timing, and the occasional well-timed spreadsheet. This CPD Accredited Team Management course offers a professional route to understanding the fine art of leading others with confidence, clarity, and a surprising amount of diplomacy. From conflict resolution to motivating underperformers (without issuing a company-wide memo in bold caps), the course is designed to help you manage personalities, expectations, and goals with a steady hand and a sharper mind. Whether you’re stepping into management for the first time or looking to refine your approach, this course offers structured insights into what actually works when you're guiding a group towards shared outcomes. Learn how to balance leadership with listening, planning with adaptability, and humour with authority—because managing a team isn’t about shouting the loudest; it’s about saying the right thing at the right time. All, of course, without the need for any awkward group exercises in hotel conference rooms. Course Curriculum: Module 01: Defining Team Module 02: Understanding Management and Leadership Module 03: Building High Performing Teams Module 04: Motivating Team Members Module 05: Talent Management Module 06: Stress Management and Mental Health Module 07: Succession Planning Module 08: Communication Skills Module 09: Negotiation Techniques Module 10: Managing Change Module 11: Managing Time Module 12: Managing Conflict Module 13: Risk Management Process Module 14: Managing Virtual Teams 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 Team Management - 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 Team Management - 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 Team Management - CPD Accredited training.

Discover the joy of growing your own fresh herbs, vegetables, and fruits right from your kitchen windowsill or small garden patch. This Kitchen Gardening course offers a delightful dive into nurturing plants in confined spaces, perfect for anyone looking to bring a touch of green into their daily routine. Whether you have a sprawling garden or just a cosy corner, this course provides clear guidance on selecting the right plants, maintaining healthy soil, and optimising growth conditions without ever needing to leave your home. Designed for enthusiasts keen on cultivating edible delights without the fuss, this course explains the essentials of planting, watering, and caring for your kitchen garden with confidence and flair. Expect to learn clever tips on seasonal planting, pest control, and sustainable gardening practices—all delivered in a friendly, approachable style. Ideal for those who fancy a fresher plate and a greener thumb, this accredited course is a garden-fresh treat for mind and table alike. Course Curriculum: Module 01: Introduction to Kitchen Gardening Module 02: Planning for Kitchen Gardening Module 03: Choosing Vegetables for Your Garden Module 04: Choosing Crops for Your Garden Module 05: Preparing Your Soil with Care Module 06: Preparing the Bed and Planting Your Crops Module 07: Maintaining your Garden and Best Practices Module 08: Practicing Eco-Friendly Pest Management Module 09: Harvesting Your Crops and Storing Safely 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 Kitchen Gardening - 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 Kitchen Gardening - 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 Kitchen Gardening - CPD Accredited training.

Land management plays a pivotal role in shaping the sustainable future of our environment and communities. This CPD accredited course offers a detailed exploration of key principles, including soil conservation, resource allocation, and land use planning. It’s designed to equip professionals with a thorough understanding of the strategies essential to managing land efficiently while balancing environmental, economic, and social factors. Whether you work in agriculture, property development, or environmental consultancy, this course brings valuable insights to your fingertips. Delving into topics such as sustainable resource stewardship and legal frameworks governing land use, the course is structured to enhance your knowledge and decision-making capabilities. Its content is crafted to fit busy professionals seeking flexible, online learning that fits neatly around their schedule. Expect clear explanations, relevant case studies, and up-to-date information that keeps you informed on the latest trends and challenges within land management. All this, with a professional tone lightly sprinkled with wit to keep the journey engaging and far from dull. Course Curriculum: Module 01: Land Management: An Introduction Module 02: Land Use and Land Use Planning Module 03: Soil Management Module 04: Land Degradation and Management Module 05: Weed Management Module 06: Watershed Management Module 07: Irrigation Management Module 08: Land Tenure, Administration and Transection Module 09: Land Registration and Acquisition Module 10: Land Law 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 Land Management - 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 Land Management - 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 Land Management - CPD Accredited training.

Good management is the pillar of a company's success. Whether it's a project or a team, without proper management, it'll inevitably fail. Ask any business owner, and they'll tell you just how difficult it is to find trustworthy and skilled management for a business. But if you're a professional, this is good news for you because businesses are willing to pay good money for people who are good at management. This KYC - CPD Accredited course is expertly made to make you highly skilled at KYC - CPD Accredited, thus opening the doors to many opportunities and high-salary jobs for you. We understand that your schedule is busy, and you won't necessarily be able to make extra time for a course all the time; this is why our course is flexible and allows you to study at your own speed. Rather than changing your schedule to do a course, the course itself becomes available to you at all times so that you don't have to worry about deadlines and whatnot. To aid you in your career progression, the course also comes with certification, and to get your very own certificate, you just have to study the course and pass the test at the end; you won't have to pay extra or anything like that for your certificate. The entire course is highly intuitive, and the lessons are detailed and meticulously crafted to make each lesson as easily digestible as possible. For a deeper look at what the course specifically covers, have a look at the Description section below; there's a full curriculum breakdown given there. Furthermore, just to ensure that you are getting what you are paying for and there's no room for disappointment, you get a full 100% money-back guarantee, so there's nothing to worry about. You can enrol in the course with complete confidence. Course Curriculum: Module 01: Introduction to KYC Module 02: Customer Due Diligence Module 03: AML (Anti-Money Laundering) Module 04: KYC, AML, and Data Privacy Regulations for Businesses Operations in the United Kingdom Module 05: Regulations to be Complied by Industries Module 06: Methods for carrying out KYC and AML and the Future of KYC Compliance 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 KYC - CPD Accredited course, you will qualify for the CPD Certification Service (CPD UK) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards Who is this course for? The KYC - 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 KYC - 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

Quality matters—whether it's in product design, process efficiency, or customer satisfaction. This CPD-accredited Quality Management Diploma brings together key knowledge from three essential areas: quality management frameworks, product strategy, and modern supply chain and branding techniques. Designed for learners aiming to understand quality from a 360-degree perspective, this online course provides a structured approach to mastering the essentials of quality control, product positioning, and supply chain communication. The course offers focused insights across three modules: Quality Management, Product Management, and Retail Supply Chain. Each module contributes to a broader understanding of how quality is maintained, monitored, and communicated across industries. Whether you're working in manufacturing, retail, product development, or business operations, this course gives you the tools to approach quality with confidence, clarity, and an eye for improvement. Delivered entirely online, the content is accessible anytime—ideal for those who prefer to study at their own pace with no scheduling pressure. This Quality Management bundle includes: Course 01: Quality Management Course 02: Product Manager Course 03: Retail: Supply Chain Management, Branding, Communication Key Benefits CPD Accredited Quality Management Course Get instant Free PDF certificate Fully online Quality Management courses Developed by professionals Self-paced learning and laptop, tablet, and smartphone-friendly 24/7 Learning Assistance Quality Management Course Curriculum: Module 01: Introduction to Quality Management Module 02: Total Quality Management Module 03: Quality Measurement and Improvement Module 04: Quality Control Module 05: Understanding Customer Expectations and Needs Module 06: Six Sigma Module 07: Supply Chain Management Module 08: Quality Audits Learning Outcomes: Grasp the fundamentals of Quality Management principles. Implement Total Quality Management strategies for organizational excellence. Measure and enhance product/service quality with effective techniques. Apply rigorous Quality Control processes to optimize operations. Analyze customer expectations and tailor products/services accordingly. Master the principles and methodologies of Six Sigma. Quality Management Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing each Quality Management - course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Quality Management course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 30 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? Quality Assurance professionals Managers Business owners Supply Chain Managers and Quality Auditors Graduates eager to gain expertise in Quality Management. Quality Control personnel Requirements There are no formal entry requirements for the Quality Management course, with enrollment open to anyone! Career path Quality Assurance Manager Process Improvement Specialist Supply Chain Coordinator Quality Control Analyst Six Sigma Consultant Quality Auditor Certificates CPD Certificate (HARDCOPY) Hard copy certificate - Included CPD Certificate (PDF) Digital certificate - Included

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