17992 Addition courses delivered On Demand

Ever wondered who draws your blood for tests and why it’s such a precise task? Welcome to the world of Phlebotomy and Venipuncture – a vital field where skill, focus, and calm hands come together. This course offers a structured learning path for anyone keen to understand the techniques behind safe blood collection, patient preparation, vein selection, and aftercare. If you're curious about working in a healthcare environment and want to play a key role in diagnostics without becoming a doctor or nurse, this might just be your lane. From understanding different types of equipment to learning the do’s and don’ts of venepuncture, you’ll gain the knowledge you need without needing to put on gloves. It's all online – detailed, simple, and suitable for those who want a flexible way to study. Whether you're aiming to work in hospitals, labs, clinics, or blood donation centres, this course will get you one step closer. Plus, the added career guide is a bonus – giving you useful direction in a field that’s always in demand and constantly evolving. ________________________________________________________________________ Key Features: CPD Certified Phlebotomy & Venipuncture Training With Complete Career Guide 10 Instant e-certificate and hard copy dispatch by next working day Fully online, interactive course with audio voiceover Developed by qualified professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum: Module 01: Getting to Know PhlebotomyTitle Module 02: Blood Circulation Module 03: Phlebotomy Equipment Module 04: Learning Venipuncture Module 05: Learning Dermal Puncture Module 06: Special Blood Collection Method Module 07: Infection Control and Risk Management ________________________________________________________________________ Complete Career Guide for Phlebotomy & Venipuncture Training (A to Z) This isn't just a course; it's your ticket to thriving in the sector and your roadmap to the Phlebotomy. In addition to mastering the essentials of Phlebotomy, you'll also gain valuable skills in CV writing, job searching, communication, leadership, and project management. These 9 complementary courses are designed to empower you at every stage of your journey. Stand out in your career, from crafting a winning CV to excelling in interviews. Develop the leadership skills to inspire your team and efficiently manage projects. This holistic approach ensures you're not just job-ready but career-ready. Enrol today, and let's build your success story together in Phlebotomy. Your dream career starts here! List of career guide courses included in Phlebotomy & Venipuncture Training With Complete Career Guide: Course 01: Professional CV Writing and Job Searching Course 02: Communication Skills Training Course 03: Career Development Training Course 04: Time Management Course 05: Returning to Work Training Course 06: Level 3 Diploma in Project Management Course 07: Leadership Skills Course 08: Body Language Course 09: Interview and Recruitment ________________________________________________________________________ Learning Outcomes: Understand the fundamentals of phlebotomy and its significance. Demonstrate knowledge of blood circulation and its physiological aspects. Identify and utilize various phlebotomy equipment effectively. Master the techniques involved in both venipuncture and dermal puncture. Acquire proficiency in special blood collection methods. Demonstrate competence in infection control and risk management. ________________________________________________________________________ Accreditation All of our courses, including the Phlebotomy & Venipuncture Training With Complete Career Guide course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Phlebotomy & Venipuncture Training With Complete Career Guide, you will immediately be sent your digital certificates. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we recommend renewing them every 12 months. Assessment At the end of the courses, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals aspiring to enter the field of phlebotomy. Healthcare professionals seeking to enhance their skills. Students pursuing a career in medical sciences. Those interested in specialized blood collection methods. Career path Phlebotomist - £20K to 28K/year. Laboratory Technician - £22K to 30K/year. Medical Assistant - £18K to 25K/year. Clinical Research Coordinator - £25K to 35K/year. Healthcare Administrator - £30K to 40K/year. Certificates 10 CPD Accredited e-Certificates Digital certificate - Included 10 CPD Accredited Hard Copy Certificates Hard copy certificate - Included

Looking to dive into the world of plumbing? Our Plumber: Plumbing Training With Complete Career Guide Course provides you with the foundation needed to understand the core aspects of plumbing. From the basics of pipe installation to the more intricate systems that make homes and businesses function, this course ensures you're equipped with the right knowledge to succeed. With an emphasis on clear, easy-to-understand instructions, you’ll build a solid understanding of plumbing without the need for physical presence or on-site training. This course also offers insights into the plumbing industry, including career options and expected salaries. The plumbing sector is essential, and skilled professionals are always in demand. Whether you’re aiming to start your own business or work within an established firm, the possibilities are wide-ranging. With access to expert tips, guidance on tools, and key industry trends, you'll have the resources you need to make informed decisions as you move forward. ________________________________________________________________________ Key Features: CPD Certified 10 Instant e-certificate and hard copy dispatch by next working day Fully online, interactive course with audio voiceover Developed by qualified professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum: Module 01: Basic Components of Plumbing Module 02: Principles of Effective Plumbing Systems Module 03: The Plumbing Tools Module 04: The Plumbing Process Module 05: Central Heating Systems Module 06: Domestic Cold Water System Module 07: Domestic Hot Water System - Part 1 Module 08: Domestic Hot Water System Part 2 Module 09: The Sanitation System and Repairs Module 10: Domestic Rainwater System Installation Module 11: Plumbing Projects: Case Study Module 12: UK Standards for Plumbing ________________________________________________________________________ Complete Career Guide for Plumber: Plumbing Training (A to Z) This isn't just a course; it's your ticket to thriving in the sector and your roadmap to the Plumbing. In addition to mastering the essentials of Plumbing, you'll also gain valuable skills in CV writing, job searching, communication, leadership, and project management. These 9 complementary courses are designed to empower you at every stage of your journey. Stand out in your career, from crafting a winning CV to excelling in interviews. Develop the leadership skills to inspire your team and efficiently manage projects. This holistic approach ensures you're not just job-ready but career-ready. Enrol today, and let's build your success story together in Plumbing. Your dream career starts here! List of career guide courses included in Plumber: Plumbing Training With Complete Career Guide: Course 01: Professional CV Writing and Job Searching Course 02: Communication Skills Training Course 03: Career Development Training Course 04: Time Management Course 05: Returning to Work Training Course 06: Level 3 Diploma in Project Management Course 07: Leadership Skills Course 08: Body Language Course 09: Interview and Recruitment ________________________________________________________________________ Learning Outcomes: Understand fundamental plumbing components and their applications in systems. Apply principles for effective plumbing system design and implementation. Demonstrate proficiency with essential plumbing tools and equipment. Execute the step-by-step plumbing process for residential and commercial projects. Install and maintain central heating, cold and hot water systems. Implement sanitation systems, conduct repairs, and install rainwater systems. ________________________________________________________________________ Accreditation All of our courses, including this Course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Course, you will immediately be sent your digital certificates. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we recommend renewing them every 12 months. Assessment At the end of the courses, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals aspiring to become professional plumbers. Construction workers seeking piping knowledge for career advancement. Homeowners interested in DIY plumbing and maintenance. Building maintenance personnel enhancing their skill set. Anyone keen on understanding UK plumbing standards. Career path Plumber - £25K to 40K/year. Plumbing Supervisor - £30K to 45K/year. Building Services Engineer - £35K to 55K/year. Construction Project Manager - £40K to 65K/year. Plumbing Inspector - £30K to 50K/year. Certificates 10 CPD Accredited e-Certificates Digital certificate - Included 10 CPD Accredited Hard Copy Certificates Hard copy certificate - Included

Thinking about getting into bricklaying but not sure where to start? This Bricklayer Training course offers a structured route through the key knowledge areas you'll need. Whether you're curious about construction techniques or want to understand the principles behind bricklaying projects, this course is designed to make the subject clear, accessible and genuinely enjoyable to learn. With easy-to-follow lessons, expert insights, and a clear career guide included, this course is suited to anyone interested in exploring bricklaying from a professional perspective. You'll gain solid theoretical knowledge and be guided through essential construction processes, safety considerations, and industry expectations — all from the comfort of home. No mud, no mess — just meaningful learning with practical relevance and plenty of career-focused value. ________________________________________________________________________ Key Features: CPD Certified Bricklayer Training: Bricklaying Diploma Course With Complete Career Guide 10 Instant e-certificate and hard copy dispatch by next working day Fully online, interactive course with audio voiceover Developed by qualified professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum: Module 01: Introduction to Bricklaying Module 02: Tools of Bricklaying Module 03: Bonding of Bricklaying Module 04: Basic Techniques of Bricklaying Module 05: Constructing Walls Module 06: Basic Joint Finishes Module 07: Building Curved Arches Module 08: Building Curved Brickwork and Defects and Maintenance of Bricklaying ________________________________________________________________________ Complete Career Guide for Bricklayer Training: Bricklaying Diploma Course (A to Z) This isn't just a course; it's your ticket to thriving in the sector and your roadmap to the Bricklayer. In addition to mastering the essentials of Bricklayer, you'll also gain valuable skills in CV writing, job searching, communication, leadership, and project management. These 9 complementary courses are designed to empower you at every stage of your journey. Stand out in your career, from crafting a winning CV to excelling in interviews. Develop the leadership skills to inspire your team and efficiently manage projects. This holistic approach ensures you're not just job-ready but career-ready. Enrol today, and let's build your success story together in Bricklayer. Your dream career starts here! List of career guide courses included in Bricklayer Training: Bricklaying Diploma Course With Complete Career Guide: Course 01: Professional CV Writing and Job Searching Course 02: Communication Skills Training Course 03: Career Development Training Course 04: Time Management Course 05: Returning to Work Training Course 06: Level 3 Diploma in Project Management Course 07: Leadership Skills Course 08: Body Language Course 09: Interview and Recruitment ________________________________________________________________________ Learning Outcomes: Gain a comprehensive understanding of bricklaying principles and techniques. Master the usage of essential bricklaying tools for various tasks. Learn the art of bonding in bricklaying, ensuring structural integrity. Acquire proficiency in constructing walls with precision and efficiency. Develop skills in creating basic joint finishes for professional results. Explore advanced techniques, including building curved arches and brickwork. ________________________________________________________________________ Accreditation All of our courses, including the Bricklayer Training: Bricklaying Diploma Course With Complete Career Guide, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Bricklayer Training: Bricklaying Diploma Course With Complete Career Guide, you will immediately be sent your digital certificates. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we recommend renewing them every 12 months. Assessment At the end of the courses, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals aspiring to become skilled bricklayers. Construction enthusiasts seeking a solid foundation in bricklaying. Novices interested in mastering the art of constructing walls. Those aiming to enhance their knowledge of bricklaying techniques. Individuals looking to explore opportunities in curved brickwork. Career path Bricklayer - £22K to 35K/year. Construction Site Supervisor - £30K to 45K/year. Masonry Specialist - £25K to 40K/year. Building Inspector - £30K to 50K/year. Construction Project Manager - £40K to 60K/year. Certificates 10 CPD Accredited e-Certificates Digital certificate - Included 10 CPD Accredited Hard Copy Certificates Hard copy certificate - Included

C# Programming Masterclass is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this C# Programming Masterclass and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Introduction Introduction 00:04:00 Basics to get started Intro 00:02:00 Visual Studio 00:07:00 Comments 00:02:00 Variables 00:08:00 Print and read console 00:04:00 Math 00:08:00 LogIc Intro 00:02:00 Boolean 00:07:00 IF 00:08:00 IF ELSE, ELSE 00:08:00 Switch 00:05:00 WHILE loop 00:07:00 FOR loop 00:03:00 Methods (basic) Basics of a method 00:07:00 Parameters 00:05:00 Returns 00:08:00 Classes (basics) Basics of a class 00:07:00 Access 00:06:00 Static 00:07:00 Variavles (basic) Read line 00:03:00 Arrays 00:06:00 FOR EACH loop 00:05:00 Convert 00:04:00 Cast 00:04:00 Error handling Try and Catch 00:07:00 Usefull methods Date 00:12:00 Text (advanced) Split, remove, substring 00:14:00 Classess (advanced) More on construction 00:11:00 More on access 00:04:00 Inheritance 00:09:00 EXAMPLE - time converter 00:17:00 Binary (advanced) Read a text file 00:13:00 Write a text file 00:10:00 Serialize object to byte array 00:15:00 Asynchronous (advanced) Task 00:07:00 Async and await 00:15:00 Multitasking 00:07:00 Search in objects (linq) Where 00:11:00 Find 00:05:00 Order, group and merge 00:10:00 Pratice Conclusion Bonus lecture 00:01:00

Overview This comprehensive course on Advanced Mathematics will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Advanced Mathematics comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Advanced Mathematics. It is available to all students, of all academic backgrounds. Requirements Our Advanced Mathematics is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 8 sections • 30 lectures • 03:23:00 total length •Introduction: 00:01:00 •Introduction to Mathematical Logic, What is Sentence, Statements and their Types: 00:02:00 •Introduction to Logical Connectivity, Tautology, Contradiction, Contingency, Pattern: 00:06:00 •Quantitative and Quantified Statement and types and example: 00:03:00 •Dual: Replacing of Connections and Symbols: 00:02:00 •Negations of Compound Statement, Converse, Inverse, & Contrapositive: 00:03:00 •Algebra of Statements and Law: 00:05:00 •Real Life application of Logic to Switching Electric Circuit: 00:05:00 •Introduction to Matrices, Multiplication and Addition using Matrix: 00:06:00 •Inverse of Matrix Uniqueness of Inverse, Elementary Transformation: 00:09:00 •Method of REDUCTION AND INVERSION with real life example how we can implement: 00:17:00 •Introduction to Trigonometric Function: 00:03:00 •General Solutions and Theorem: 00:10:00 •Solution of Triangle: Polar Co-ordinates: 00:21:00 •Rules and Theorems of Sin Cosine and Tan: 00:22:00 •Introduction & Combined Equations: 00:07:00 •Degrees and Types: 00:13:00 •Some Theorem: 00:17:00 •Introduction - vector Cartesian theorem: 00:02:00 •Cartesian Equation & 2 Point Theorem: 00:03:00 •Theorems & Problem Solving: 00:05:00 •Distance of Point Line: 00:05:00 •Skew Lines: 00:01:00 •Distance of skew lines: 00:03:00 •Distance between parallel lines: 00:02:00 •Equation of Plane and Cartesian Form: 00:10:00 •Linear Programming Introduction: 00:08:00 •Introduction to LPP (Linear Programming Problem): 00:05:00 •LPP Problem Solving: 00:07:00 •Assignment - Advanced Mathematics: 00:00:00

Unlock the Secrets of Financial Success with Trading Strategies 101! 📈 Are you ready to take control of your financial future? Dive into the exciting world of trading with our comprehensive course, Trading Strategies 101! Whether you're a complete beginner or an experienced trader looking to refine your skills, this course is your ultimate guide to mastering the art of trading.   Why Trading Strategies 101? Trading in the financial markets can be both thrilling and lucrative, but it's essential to have the right knowledge and strategies in place to succeed. Our course offers a step-by-step approach to understanding the fundamentals of trading, analyzing market trends, and implementing effective strategies to maximize your profits while minimizing risks.   What Will You Learn? Foundations of Trading: Gain a solid understanding of the financial markets, including stocks, forex, and commodities. Learn how to read price charts, interpret market indicators, and identify profitable trading opportunities. Risk Management: Discover crucial risk management techniques to protect your capital and minimize losses. Learn how to set stop-loss orders, calculate position sizes, and develop a disciplined trading mindset. Technical Analysis: Master the art of technical analysis and charting patterns to predict future price movements accurately. Explore popular technical indicators and charting tools used by professional traders worldwide. Fundamental Analysis: Learn how to analyze economic data, company financials, and geopolitical events to make informed trading decisions. Understand the impact of fundamental factors on market trends and price movements. Trading Strategies: Explore a variety of proven trading strategies, including trend following, breakout trading, and momentum trading. Discover how to develop your trading plan and adapt to changing market conditions for consistent profits.   Who is This For? Trading Strategies 101 is perfect for anyone looking to embark on their trading journey or enhance their existing skills. Whether you're a college student eager to learn about finance, a working professional seeking additional income streams, or a retiree looking to grow your nest egg, this course is tailored to meet your needs.   Career Path Upon completing Trading Strategies 101, you'll be equipped with the knowledge and skills to pursue various career opportunities in the financial industry. Whether you aspire to become a full-time trader, work for a financial institution, or manage your investment portfolio, this course serves as a solid foundation for your future success.   FAQs Q: Do I need any prior trading experience to enroll in this course? A: No prior trading experience is required! Trading Strategies 101 is designed for beginners, providing a comprehensive overview of the fundamentals of trading from scratch. Q: Can I take this course if I have a full-time job? A: Absolutely! Our course is designed to be flexible, allowing you to learn at your own pace and fit your studies around your busy schedule. Whether you have a full-time job, family commitments, or other responsibilities, you can access the course materials anytime, anywhere. Q: Will I receive any certification upon completing the course? A: Yes, upon successfully completing Trading Strategies 101, you'll receive a certificate of completion to showcase your newfound knowledge and skills. This certificate can be a valuable addition to your resume and LinkedIn profile, demonstrating your commitment to professional development in the financial industry. Q: How long does it take to complete the course? A: The duration of the course varies depending on your pace of learning and commitment. On average, most students complete the course within a few weeks by dedicating a few hours each week to study and practice. Q: Is there any ongoing support available after completing the course? A: Absolutely! We're committed to your success even after you've completed the course. You'll have access to our community forums, where you can connect with fellow students, ask questions, and engage in discussions. Additionally, our support team is always available to assist you with any queries or concerns you may have.   Don't Miss Out on This Opportunity! Ready to take your trading skills to the next level? Enroll in Trading Strategies 101 today and embark on your journey to financial freedom! With expert guidance, practical insights, and hands-on experience, you'll gain the confidence and expertise to navigate the financial markets with ease. Don't let this opportunity slip away - join us now and unlock the secrets of successful trading! 🚀 Course Curriculum Module 1 Introduction to Trading Strategies Introduction to Trading Strategies 00:00 Module 2 Technical Analysis Fundamentals Technical Analysis Fundamentals 00:00 Module 3 Developing Your Trading Strategy Developing Your Trading Strategy 00:00 Module 4 Risk Management and Trader Psychology Risk Management and Trader Psychology 00:00 Module 5 Advanced Trading Techniques Advanced Trading Techniques 00:00 Module 6 Fundamental Analysis and Market News Fundamental Analysis and Market News 00:00

Level 5 QLS Endorsed Course | CPD & CiQ Accredited | Audio Visual Training | Free PDF Certificate | Lifetime Access

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

Laboratory Technician Level 3 Diploma Course Description: Earn a Level 3 Diploma in Laboratory Technician and gain the skills you need for a rewarding career in Laboratory Science. This comprehensive course covers everything from laboratory equipment to quality assurance and safety measures. So Enrol now and begin your journey to success! This Level 3 Diploma in Laboratory Technician aims to impart basic knowledge to students regarding general laboratory technician work who will apply basic skills and knowledge in the field of science and laboratory technology. In addition, you will gain the skills and confidence to manage the functions of a laboratory, from quality to finance and beyond. Upon completion of this course, you will possess the skills and knowledge required in a laboratory or similar workplace that involves conducting analytical tests. Course Preview Who is this Course for? Level 3 Diploma in Laboratory Technician is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Level 3 Diploma in Laboratory Technician is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certificate of Achievement After completing this course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates & Transcripts can be obtained either in Hardcopy at £14.99 or in PDF format at £11.99. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Level 3 Diploma in Laboratory Technician - New Version Module 01: Introduction to the Course Introduction to the Course 00:14:00 Module 02: Medical Laboratory Services Medical Laboratory Services 00:23:00 Module 03: Laboratory Equipments (Part-01) Laboratory Equipments (Part-01) 00:28:00 Module 04: Laboratory Equipments (Part-02) Laboratory Equipments (Part-02) 00:17:00 Module 05: Microscope and How to Use it Microscope and How to Use it 00:19:00 Module 06: Solutions Used in Clinical/Medical Laboratory Solutions Used in Clinical/Medical Laboratory 00:19:00 Module 07: Sterilisation, Disinfection and Decontamination Sterilisation, Disinfection and Decontamination 00:20:00 Module 08: Basic Haematology Basic Haematology 00:50:00 Module 09: Basic Haemostasis (Coagulation) Basic Haemostasis (Coagulation) 00:30:00 Module 10: Basic Immunology and Immunohematology Basic Immunology and Immunohematology 00:40:00 Module 11: Urinalysis Urinalysis 00:37:00 Module 12: Basic Clinical Chemistry Basic Clinical Chemistry 00:41:00 Module 13: Basic Clinical Microbiology Basic Clinical Microbiology 00:28:00 Module 14: Basic Parasitology Basic Parasitology 00:31:00 Module 15: Laboratory Accidents and Safety Laboratory Accidents and Safety 00:20:00 Module 16: Quality Assurance Quality Assurance 00:22:00 Level 3 Diploma in Laboratory Technician - Old Version Module 01 Introduction to Laboratory Technician 00:30:00 Role of Medical Laboratory Services 00:15:00 Laboratory Policies 00:15:00 Solutions Used in Medical Laboratory 00:30:00 Laboratory Wares 00:45:00 Module 02 Laboratory Instruments 00:45:00 Sterilization and Disinfection 00:30:00 Laboratory Accidents and Safety 01:00:00 Quality Assurance 00:30:00 Glossary 00:15:00 Assessment Assignment - Level 3 Diploma in Laboratory Technician 00:00:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Overview A tiny peanut can put a person in the hospital bed. This is why people in the food business must be aware of food allergens and their impacts. Learn about different types and causes of food allergies and prepare yourself to protect your customers from them with our Allergen Awareness Training. This comprehensive course is designed to provide you with an in-depth knowledge and understanding of food allergens. From the informative modules you will learn about the causes and symptoms. In addition, the course will enhance your knowledge of the laws related to food allergies. Furthermore, you will develop the skills for risk assessment and management. By the end of the course, you will grasp effective skills to serve safe food to your consumers.  Whether you are a current or future professional in the food industry, this course is ideal for you. So enrol now and start learning! Course Preview Learning Outcomes Learn about the causes and symptoms of food allergens Understand the law related to food allergens Develop the skills for risk assessment and allergen management Know about the practical steps you can take to prevent food allergies Grasp the process of informing the consumers about food allergens Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email What Skills Will You Learn from This Course? Knowledge of food allergens Risk assessment and management Prevention of food allergies Who Should Take This Allergen Awareness Training? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Allergen Awareness Training is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Allergen Awareness Training Certification After completing and passing the Allergen Awareness Training successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Path​ This exclusive Allergen Awareness Training will equip you with effective skills and abilities and help you explore career paths such as  Chef Restaurant Staff Caterer Restaurant Manager Module 01: Introduction To Food Allergens And Intolerance Introduction to Food Allergens and Intolerance 00:40:00 Module 02: Causes And Symptoms Of Food Intolerances Causes and Symptoms of Food Intolerances 00:18:00 Module 03: Causes And Symptoms Of Food Allergies Causes and Symptoms of Allergies 00:19:00 Module 04: Allergen Facts Allergen Facts 00:24:00 Module 05: Food Allergens And The Law Food Allergens and the Law 00:12:00 Module 06: Food Allergens - Practical Steps Food Allergens - Practical Steps 00:22:00 Module 07: Allergen Information For Consumers Allergen Information for Consumers 00:19:00 Module 08: Allergen Management And Risk Assessment Allergen Management and Risk Assessment 00:15:00 Module 09: Packaging And Labelling Food Packaging and Labelling Food Emphasising 00:13:00 Module 10: Other Common Allergens Part 1 Other Common Allergens Part 1 00:17:00 Module 11: Other Common Allergens Part 2 Other Common Allergens Part 2 00:18:00 Assignment Assignment - Allergen Awareness - Online Training 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00