5473 Courses in Bradford delivered On Demand

The CPD Accredited Travel Agent Course is designed to equip you with the knowledge and expertise needed to succeed in the dynamic world of travel. From understanding the intricacies of booking systems to mastering customer service techniques, this course provides you with the tools to navigate the travel industry with confidence. The flexible, online format allows you to learn at your own pace, meaning you can fit your studies around your lifestyle. With a focus on industry-standard practices and customer relations, this course is perfect for anyone looking to refine their skills or take their travel career to the next level. Whether you're new to the industry or seeking to build upon existing knowledge, this programme is structured to ensure you’re well-versed in everything from travel booking processes to international regulations. All while gaining a CPD accreditation to demonstrate your commitment to professional development. 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 Travel Agent profession Free Assessment to test learners' knowledge and skills Course Curriculum: Module 01: Introduction to Travel and Tourism Module 02: Tourism Products and Services Module 03: Tour Operating and Travel Retailing Module 04: Marketing in Travel and Tourism Module 05: Developing Communication Skills Module 06: Customer Service and Satisfaction Module 07: Crisis and Visitor Attraction Management Module 08: Transport Management Procedure Module 09: Tourism in the New Normal World/ Post COVID Travel Destinations Module 10: Sustainable Tourism Module 11: Public Awareness Campaigns Module 12: Brexit and its Impact on Tourism Industry Module 13: Travel and Tourism Issues to Contend with Module 14: Human Resource Management in Travel Industry Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing the Travel Agent - CPD Accredited course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Travel Agent - 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 Travel Agent - 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 Travel Agent - 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.

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.

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

Allergies can have a significant impact on a person's life. Dietary allergies cannot be cured, but knowing how to eat, order food, and shop wisely can significantly improve a person's quality of life. A critical and expanding public health concern is food allergy. Hence, it is essential that food business owners, employees, and customers understand all the aspects of Food Allergen Awareness and what they can do to make the environment as safe as possible for people with allergies. Have you given up looking for a program that can aid in your knowledge advancement and provide you with the tools necessary to meet the challenge? Do you want to start a career that most closely resembles your interests? If you answered yes, you've come to the correct place because our thoughtfully constructed Food Allergen course will help you move in the proper direction. Our Food Allergen program seeks to increase people's understanding of how a food or ingredient allergy affects customers. It explains how to ensure that clients are well-informed about their food choices. Customers must avoid allergenic foods and products to avoid allergic responses. This course will help you keep yourself and your clients safe. Our business professionals developed this detailed Food Allergen course to fulfil the demand of employees. It will undoubtedly improve your self-esteem, potential to commercialise yourself, and career. If you work hard enough to complete this assignment, you will continue to shine and arouse the enthusiasm of everyone you meet. By engaging in this Food Allergen program, you will receive appropriate guidance in the current and future workplace skill regulations. Food allergies are on the rise. We all must understand food allergies and the risks associated with eating them. That is why, whether you work in the food sector or not, you should take our course. This Food Allergen Course will assist you in dealing with food allergens regularly. If you've ever had a smidgeon of doubt, you're passing up the most important opportunities to accelerate your career path as well as yourself. This is your opportunity to show the universe your point of view and convince businesses to hire you. So, stay focused and you'll hit the top. Learning Outcomes After completing this Food Allergen course, you will be able to- Examine the difference between food allergies and food intolerance to gain a better understanding of food science. Describe how to prevent allergen contamination during food preparation and operation. Describe how to mark allergens during the preparation and selling of food correctly. Describe the best practices for businesses when it comes to food allergens. Describe food allergen laws, compliance, and penalties. Find out what to do if you have an allergic reaction. Why Choose Food Allergen Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. This course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ***Other Benefits of Food Allergen Course Free One PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Unlimited Retake Exam Expert Tutor Support [ Note: Free PDF certificate as soon as completing the Food Allergen course] This Food Allergen course is ideal for you if you work or want to work for a food-related business that produces, sells, or serves food. The course comprises a series of easy-to-digest, in-depth lessons that will offer you a deep, expert level of knowledge. You will receive a solid foundation from this course that will enable you to become a self-assured expert in food allergy awareness and to develop more advanced skills to fill in the gaps for increased effectiveness and productivity. Our Food Allergen Course will provide you with hands-on experience and knowledge from industry scholars and specialists. Every person who handles food has a legal responsibility to ensure that the food they make, trade, or distribute is fit for human consumption. This is especially crucial to consider when feeding people who have food intolerances or allergies. As one of the leading course providers and most well-known e-learning professionals, we're dedicated to giving you the greatest learning experience possible. Become a professional too by taking this Food Allergen Course. To thrive in today's competitive environment, you must have a specific set of skills. In this strenuous Food Allergen course, you will learn the most demanded skills for releasing your career and broadening your current capabilities and knowledge. That's not even the best part. Our specialists are available around the clock to answer your questions about this course and guide you through the entire learning process. So why are you still waiting? Stop squandering any more of your time. Enrol in our Food Allergen program immediately to get started on the path to a rewarding career! Detailed Course Curriculum of *** Food Allergen *** Module 1: Introduction What is a Food Allergen? Coeliac Disease Symptoms of an Allergic Reaction Symptoms of Anaphylaxis Food Handler Responsibilities The 14 Named Food Allergens Module 2: Consequences of Food Allergies What People can be Allergic Management and Treatment of Food Allergy Management and Treatment of Anaphylaxis Module 3: Food Allergies and Intolerance Definition of Food Intolerance Symptoms of Food Intolerance Types of Food Intolerance Difference Between an Allergy and Intolerance to Food What Causes Food Allergies and Intolerances? Diagnosed Food Intolerances Module 4: Providing Allergen Information to Consumers The UK Food Information Regulations The 14 key Allergens that must Inform Consumers The Penalties for Failure to Comply with the Regulations Module 5: Food Allergen Law and the Food Labelling Regulations General Food Safety Legislation The Food Information for Consumers (FIC) Regulation Food Labelling Regulations Prepacked Foods Foods Prepacked for direct sale (PPDS) Natasha's Law Loose Foods Distance Selling (takeaways) Module 6: Preventing Allergenic Cross Contamination HACCP Food Deliveries Food Storage Food Processing Cleaning Method Training Personal Hygiene Emergency Situations --------------- Assessment Method After completing each module of the Food Allergen, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for Food Allergen course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This Food Allergen is suitable for - Students Fresh Graduates Job seekers Anyone interested in learning food allergens People who are already working in similar fields and want to expand their knowledge and skills Requirements There are no specific requirements for this Food Allergen Course because it does not require any advanced knowledge or skills. Students who intend to enrol in this Course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path The certification and skills you get from this Food Allergen Course can help you advance your career and gain expertise in several fields, allowing you to apply for high paying jobs in Food-Allergen related sectors. Certificates Certificate of completion Digital certificate - Included