• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

18036 Addition courses in Nottingham delivered On Demand

Traffic Marshal (Banksman) - Level 3 Advanced Diploma With Complete Career Guide Course

5.0(2)

By Training Express

The Traffic Marshal (Banksman) – Level 3 Advanced Diploma with Complete Career Guide course provides in-depth knowledge for those wishing to step into the role of a Traffic Marshal or Banksman. This accredited qualification offers a comprehensive understanding of key responsibilities and regulations associated with managing site traffic and ensuring safety. Designed for individuals looking to further their careers in construction or other site management sectors, this course gives learners the confidence and expertise needed to manage site operations effectively. With no need for physical attendance, the course is delivered entirely online, enabling learners to study at their own pace. Whether you're aiming to enter the field or elevate your current skill set, the course covers critical aspects such as traffic control methods, site safety protocols, and the legal requirements surrounding the role. This is an excellent opportunity to gain the necessary knowledge to work confidently and competently in the traffic management field, ensuring safe, efficient operations on construction sites and other high-traffic areas. ________________________________________________________________________ Key Features: CPD Certified Traffic Marshal (Banksman) - Level 3 Advanced Diploma 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 Traffic Marshalling Module 02: Traffic Management Module 03: Temporary Traffic Control Module 04: Traffic Risk Assessment Module 05: Vehicle Signaling Module 06: Reversing Vehicles Module 07: Health and Safety ________________________________________________________________________ Complete Career Guide for Traffic Marshal (Banksman) - Level 3 Advanced Diploma (A to Z) This isn't just a course; it's your ticket to thriving in the sector and your roadmap to the Traffic Marshal. In addition to mastering the essentials of Traffic Marshal, 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 Traffic Marshal. Your dream career starts here! List of career guide courses included in Traffic Marshal (Banksman) - Level 3 Advanced Diploma 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: Master the art of Traffic Marshalling with confidence. Assess traffic risks proficiently for effective management. Skillfully guide reversing vehicles in diverse scenarios. Demonstrate a comprehensive understanding of health and safety protocols. Efficiently manage traffic flow with precision and expertise. Navigate through real-world scenarios with practical skills. ________________________________________________________________________ Accreditation All of our courses, including the Traffic Marshal (Banksman) - Level 3 Advanced Diploma 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 Traffic Marshal (Banksman) - Level 3 Advanced Diploma 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 seeking career advancement in traffic management roles. Professionals looking to enhance their skill set in traffic control. Job seekers aiming to enter the transportation industry. Anyone interested in ensuring road safety and efficiency. Career path Traffic Management Coordinator - £25K to 35K/year. Traffic Control Supervisor - £27K to 40K/year. Traffic Safety Officer - £24K to 35K/year. Highway Maintenance Worker - £20K to 30K/year. Road Safety Auditor - £28K to 45K/year. Certificates 10 CPD Accredited e-Certificates Digital certificate - Included 10 CPD Accredited Hard Copy Certificates Hard copy certificate - Included

Traffic Marshal (Banksman) - Level 3 Advanced Diploma With Complete Career Guide Course
Delivered Online On Demand1 hour
£50

Understanding the Care and Management of Diabetes With Complete Career Guide Course

5.0(2)

By Training Express

Navigating the intricate world of diabetes care has never been more accessible or informative. This course provides a thorough exploration of diabetes management, designed to deepen your understanding of the condition’s complexities. From recognising the various types of diabetes to exploring the latest approaches in monitoring and treatment, you will acquire knowledge essential for supporting those affected by this widespread condition. Whether you are seeking to broaden your expertise or considering a career in healthcare, this course offers a solid foundation in diabetes care. Alongside clinical insights, the course delves into the professional pathways available in diabetes management, highlighting career opportunities and development prospects within this vital healthcare field. You’ll gain clarity on how to interpret care guidelines, understand patient needs, and contribute meaningfully to health support teams—all from the comfort of your own space. With content tailored to suit a global audience, the course ensures you remain informed about current practices and future trends in diabetes care, making it a valuable resource for anyone keen on advancing their knowledge and career in this area. ________________________________________________________________________ Key Features: CPD Certified Understanding the Care and Management of Diabetes 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 Diabetes Module 02: Diabetes Types Module 03: Person-Centred Support Module 04: Balanced Diet Module 05: Diabetes Management Module 06: Diabetes Prevalence & Controlling ________________________________________________________________________ Complete Career Guide for Understanding the Care and Management of Diabetes (A to Z) This isn't just a course; it's your ticket to thriving in the sector and your roadmap to the Care and Management. In addition to mastering the essentials of Care and Management, 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 Care and Management. Your dream career starts here! List of career guide courses included in Understanding the Care and Management of Diabetes 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: Identify various types of diabetes for tailored support. Demonstrate person-centred approaches in diabetes care delivery. Evaluate dietary plans for optimal diabetes management. Apply strategies to control and mitigate diabetes prevalence. Develop comprehensive understanding and skills in diabetes management. Analyze trends and statistics to inform effective diabetes support strategies. ________________________________________________________________________ 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? Healthcare professionals seeking specialized knowledge. Individuals interested in diabetes care careers. Nutritionists and dieticians aiming to expand expertise. Community health workers focusing on diabetes outreach. Career path Diabetes Specialist Nurse - £25K to 45K/year. Diabetes Educator - £30K to 50K/year. Clinical Dietician - £25K to 40K/year. Public Health Advisor - £28K to 45K/year. Health Promotion Officer - £26K to 42K/year. Certificates 10 CPD Accredited e-Certificates Digital certificate - Included 10 CPD Accredited Hard Copy Certificates Hard copy certificate - Included

Understanding the Care and Management of Diabetes With Complete Career Guide Course
Delivered Online On Demand1 hour
£50

C# Programming Masterclass

By The Teachers Training

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

C# Programming  Masterclass
Delivered Online On Demand5 hours 5 minutes
£27.99

Advanced Mathematics

4.9(27)

By Apex Learning

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

Advanced Mathematics
Delivered Online On Demand3 hours 23 minutes
£12

Complete CCTV Operator Training - CPD Certified

By Training Tale

CCTV Operator: CCTV Do you wish to become a better CCTV operator or launch a career in the field? We have created a fantastic CCTV Operator Training course to teach you about this device and its functions. You will learn all you need to enter an interesting and fulfilling career with our CCTV Operator Training. You will learn about the many kinds of CCTV systems and how to run them efficiently from the CCTV Operator Training. In addition, the CCTV Operator Training teaches students how to spot and report unusual activities. The legal and ethical aspects of CCTV operating are also explained in the CCTV Operator Training. All things considered, the CCTV Operator Training is ideal for understanding data protection techniques. Unlock your potential with our CCTV Operator Training to learn how to watch CCTV footage and report any suspicious behaviour with the right documentation. Special Offers of this CCTV: CCTV Operator Course This CCTV Operator Course includes a FREE PDF Certificate. Lifetime access to this CCTV Operator: CCTV Operator Course Instant access to this CCTV Operator: CCTV Operator Course Get FREE Tutor Support from Monday to Friday in this CCTV Operator: CCTV Operator Course Painting and CCTV: CCTV Operator Bundle Courses Course 01: CCTV Operator Training Course 02: AML ( Anti Money Laundering ) Course 03: Handyperson Training CCTV Operator: CCTV Industry Experts Designed this CCTV Operator course into 9 detailed modules. Course Curriculum of CCTV Operator Training Module 1: Introduction to CCTV Systems Module 2: CCTV Camera Technology Module 3: Video Signals and Transmission Module 4: CCTV Recording and Storage Module 5: Monitoring and Control Module 6: CCTV System Setup and Configuration Module 7: CCTV System Maintenance and Troubleshooting Module 8: Legal and Ethical Considerations Module 9: Emergency Response and Incident Handling Who is this course for? CCTV Operator: CCTV Anyone interested in learning about the complexities of CCTV: CCTV technology should take this CCTV: CCTV Operator Training. Career path CCTV Operator: CCTV Numerous work options will become available to you upon completion of the CCTV: CCTV Operator Training. For example, junior CCTV: CCTV operator, senior CCTV: CCTV operator, experienced CCTV: CCTV operator, and many more!

Complete CCTV Operator Training - CPD Certified
Delivered Online On Demand16 hours
£12

Sustainability Training (QLS)

By Imperial Academy

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

Sustainability Training (QLS)
Delivered Online On Demand
£12

Advanced Excel Models using Formulas, VBA & Power Query

4.3(43)

By John Academy

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

Advanced Excel Models using Formulas, VBA & Power Query
Delivered Online On Demand6 hours 8 minutes
£18

Level 3 Diploma in Laboratory Technician

4.3(43)

By John Academy

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

Level 3 Diploma in Laboratory Technician
Delivered Online On Demand12 hours 34 minutes
£25

Allergen Awareness Training

4.3(43)

By John Academy

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

Allergen Awareness Training
Delivered Online On Demand3 hours 37 minutes
£24.99

Fundraising Training

4.3(43)

By John Academy

Overview Developing a solid foundation in fundraising can open new doors of opportunity in a wide range of fields. From our exclusive Fundraising Training course you can grasp this valuable skill set without stepping out of your home.  Through the highly informative modules of this course, you will get a clever understanding of the basic principles of the fundraising cycle. Then the course will show you how to manage the budgets and accounts. In the next modules, you will learn the skills for managing fundraising events. In addition, the course will deliver lectures on marketing and communication. Furthermore, you will get the chance to learn about legal duties and the process of risk management in fundraising. After the completion of the course, you will receive a certificate of achievement. This certificate will add significant value to your resume and boost your employability. Join now! Course Preview Learning Outcomes Familairse yourself with the fundraising cycle Develop the skills to manage the budget, taxes and accounts Build the competence to arrange successful fundraising events Grasp the strategies of effective marketing and communication Get introduced to useful tools and resources for fundraising Understand the process of risk management and legal responsibilities 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? Fundraising Marketing and Communication Risk Management Who Should Take This Fundraising 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 Fundraising 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. Fundraising Training Certification After completing and passing the Fundraising 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 Fundraising Training will equip you with effective skills and abilities and help you explore career paths such as  Campaign Fundraiser Capital Campaign Fundraiser Development Officer Module 01: Introduction to Fundraising Introduction to Fundraising 00:25:00 Module 02: Hiring and Training Development Staff Hiring and Training Development Staff 00:25:00 Module 03: The Fundraising Cycle The Fundraising Cycle 00:25:00 Module 04: Establishing Governance Establishing Governance 00:20:00 Module 05: Managing Budget, Taxes and Accounting Managing Budget, Taxes and Accounting 00:30:00 Module 06: Fundraising Sources Fundraising Sources 00:40:00 Module 07: Arranging Successful Fundraising Events Arranging Successful Fundraising Events 00:40:00 Module 08: Marketing, Public Relations and Communications Marketing, Public Relations and Communications 00:40:00 Module 09: Tools and Resources that Can Help in Fundraising Tools and Resources that Can Help in Fundraising 00:55:00 Module 10: Crowdfunding Crowdfunding 00:30:00 Module 11: The Organisation and Use of Volunteers The Organisation and Use of Volunteers 00:30:00 Module 12: Risk Management Risk Management 00:35:00 Module 13: Legal Responsibilities Legal Responsibilities 00:45:00 Assignment Assignment - Fundraising 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Fundraising Training
Delivered Online On Demand7 hours 20 minutes
£24.99