Name: Level 3 Teaching Assistant Diploma - Specialist Support with Children (RQF)
Price: 595 GBP
Availability: InStock

<p>Gaining thorough knowledge or specialising in a specific field requires finding relevant courses in the proper order. This is a daunting task for anyone, especially someone who needs a broad understanding of the subject. Moreover, It can take a lot of work to find a thorough course on a particular topic, especially one that starts at the very beginning and covers everything. Hence, to make life easier, we present you with this all-inclusive, cutting-edge UK Pension and Employment Law bundle to help you in this endeavour.  </p> <p>Experts design our UK Pension and Employment Law bundle to prepare you for the challenges of this ever-competitive world. The courses in the bundle include practical and real-life scenarios and theories to help you become familiar with the most recent developments in this rapidly expanding UK Pension and Employment Law sector. Furthermore, you'll be in complete charge of your learning journey; you can learn anywhere and anytime.</p> <p>To make your learning process as smooth as possible, our team has prepared round-the-clock to answer your every query. So, don't hesitate to enrol in the UK Pension and Employment Law bundle and gain a competitive advantage.</p> <p><strong>Learning Outcomes</strong></p> <p>This unique bundle will help you to-</p> <ul> <li>Acquire a deeper understanding of UK Pension and Employment Law</li><li>Help you in achieving your career goal </li><li>Make you confident in your knowledge and skills</li><li>Be aware of the employment trends in related industries.</li><li>Adapt to an ever-changing industry</li></ul><p>The UK Pension and Employment Law resources were created with the help of experts, and all subject-related information is kept updated regularly to ensure learners stay caught up on the latest developments.</p> <p><strong>Course Curriculum</strong></p> <p><strong>Course 1: UK Pension (Level 3 at QLS)</strong></p> <ul> <li>Module 01: Overview of the UK Pension system</li><li>Module 02: Type of Pension Schemes</li><li>Module 03: Pension Regulation</li><li>Module 04: Pension Fund Governance</li><li>Module 05: Law and Regulation of Pensions in the UK</li><li>Module 06: Key Challenges in UK Pension System</li></ul> <p><strong>Course 2: Employment Law (Level 5 at QLS)</strong></p> <ul> <li>Module 01: Basics of Employment Law</li><li>Module 02: Legal Recruitment Process</li><li>Module 03: Employment Contracts</li><li>Module 04: Employee Handbook</li><li>Module 05: Disciplinary Procedure</li><li>Module 06: National Minimum Wage &amp; National Living Wage</li><li>Module 07: Parental Right, Sick Pay &amp; Pension Scheme</li><li>Module 08: Discrimination in the Workplace</li><li>Module 09: Health &amp; Safety at Work</li><li>Module 10: Dismissal, Grievances and Employment Tribunals</li><li>Module 11: Workplace Monitoring &amp; Data Protection</li></ul> <p><strong>Certification</strong></p> <p>Learners will get 2 QLS Endorsed Certificate + 2 CPD Accredited Certificate of achievement directly at their doorstep after successfully completing the package! It should be noted that international students must pay a £10 shipping cost.</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        80 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>Anyone who is interested in a particular field, wants to strengthen their resume, or wants to grow in their career would benefit from this UK Pension and Employment Law bundle.</p> 
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>Anyone can enrol in this Training.</p> 
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>You will get a competitive edge and have access to a variety of employment prospects after completing this UK Pension and Employment Law bundle.</p> 
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>
            <div> <p>2 PDF CPD Certificate Completely free of charge.</p> </div>
        <h4>Certificate of completion</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div> <p>2 Hard Copy QLS Endorsed Certificate Completely free of charge.</p> </div>

                        </div>

Imperial Academy

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access

UK Pension and Employment Law - Double Endorsed Certificate

General Admission

<p>Gaining thorough knowledge or specialising in a specific field requires finding relevant courses in the proper order. This is a daunting task for anyone, especially someone who needs a broad understanding of the subject. Moreover, It can take a lot of work to find a thorough course on a particular topic, especially one that starts at the very beginning and covers everything. Hence, to make life easier, we present you with this all-inclusive, cutting-edge Pension UK and Insurance Broker bundle to help you in this endeavour.</p><p>Experts design our Pension UK and Insurance Broker bundle to prepare you for the challenges of this ever-competitive world. The courses in the bundle include practical and real-life scenarios and theories to help you become familiar with the most recent developments in this rapidly expanding Pension UK and Insurance Broker sector. Furthermore, you'll be in complete charge of your learning journey; you can learn anywhere and anytime.</p><p>To make your learning process as smooth as possible, our team has prepared round-the-clock to answer your every query. So, don't hesitate to enrol in the Pension UK and Insurance Broker bundle and gain a competitive advantage.</p><p><strong>Learning Outcomes</strong></p><p>This unique bundle will help you to-</p><ul><li>Acquire a deeper understanding of Pension UK and Insurance Broker</li><li>Help you in achieving your career goal</li><li>Make you confident in your knowledge and skills</li><li>Be aware of the employment trends in related industries.</li><li>Adapt to an ever-changing industry</li></ul><p>The Pension UK and Insurance Broker resources were created with the help of experts, and all subject-related information is kept updated regularly to ensure learners stay caught up on the latest developments.</p><p><strong>Course Curriculum</strong></p><p><strong>Course 01: Pension UK (Level 3 at QLS)</strong></p><ul><li>Module 01: Overview of the UK Pension system</li><li>Module 02: Type of Pension Schemes</li><li>Module 03: Pension Regulation</li><li>Module 04: Pension Fund Governance</li><li>Module 05: Law and Regulation of Pensions in the UK</li><li>Module 06: Key Challenges in UK Pension System</li></ul><p><strong>Course 02: Insurance Broker (Level 5 at QLS)</strong></p><ul><li>Module 01: Insurance Industry</li><li>Module 02: The UK Insurance Industry</li><li>Module 03: Principles of Insurance</li><li>Module 04: General Insurance</li><li>Module 05: Personal Lines Insurance</li><li>Module 06: Commercial Lines Insurance</li><li>Module 07: Liability Insurance</li><li>Module 08: Life Insurance</li><li>Module 09: Insurance Fraud</li><li>Module 10: Underwriting Process</li></ul><p><strong>Certification</strong></p><p>Learners will get<strong> 2 QLS Endorsed Certificate + 2 CPD Accredited</strong> Certificate of achievement directly at their doorstep after successfully completing the package! It should be noted that international students must pay a £10 shipping cost.</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        80 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>Anyone who is interested in a particular field, wants to strengthen their resume, or wants to grow in their career would benefit from this Pension UK and Insurance Broker bundle.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Anyone can enrol in this Training.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <ul><li>Insurance Broker: £25,000 - £70,000 per year</li><li>Pension Advisor: £30,000 - £60,000 per year</li><li>Financial Consultant: £35,000 - £75,000 per year</li><li>Wealth Manager: £40,000 - £90,000 per year</li><li>Insurance Sales Manager: £45,000 - £100,000 per year</li><li>Financial Planning Manager: £50,000 - £120,000 per year</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Hardcopy QLS Certificate</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div><p>2 Hard Copy QLS Endorsed certificate Completely free of charge.</p></div>
        <h4>PDF Certificate</h4>
        <p>
            Digital certificate -
            Included
        </p>
            <div><p>2 Free CPD Accredited PDF Certificate</p></div>

                        </div>

Pension UK and Insurance Broker - Double Endorsed Certificate

<p>Boost <strong>Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now</strong></p><p>With a single payment you will gain access to <strong>Stock Market Investing &amp; Trading - Level 2</strong> including <strong>11</strong> Career development courses, <strong>original hardcopy certificate, transcript</strong> and a <strong>student ID card</strong> which will allow you to get discounts on things like music, food, travel and clothes etc.</p><p>Trade efficiently in the stock market, learning advanced techniques and strategies from the Stock Market Investing &amp; Trading - Level 2 course.</p><p>The Stock Market Investing &amp; Trading - Level 2 course aims to equip you with all the required knowledge and skills to trade like a pro in the stock market and gain a consistent profit. You'll be trained on technical and candlestick chart analysis to equip you with the skills to perceive the market accurately. You'll also learn trading tips, exploring tools and exchange policy. What's more, you'll explore some mistakes of new traders that will protect you from making poor trading decisions.</p><p>Thrive in the stock market by enrolling today!</p><p>Take this course anywhere and at any time. Don't let your lifestyle limit your learning or your potential.</p><p>Gain experience online and interact with experts. This can prove to be the perfect way to get noticed by a prospective employer and stand out from the crowd.</p><p>All of our courses have interactive online modules that allow studying to take place where and when you want it to.</p><p>Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes.</p><p><strong>Benefits you'll get choosing Apex Learning for this Stock Market Investing &amp; Trading - Level 2:</strong></p><ul><li>One payment, but lifetime access to 11 CPD courses</li><li>Certificates, student ID for the title course included in a one-time fee</li><li>Full tutor support available from Monday to Friday</li><li>Free up your time - don't waste time and money travelling for classes</li><li>Accessible, informative modules taught by expert instructors</li><li>Learn at your ease - anytime, from anywhere</li><li>Study the course from your computer, tablet or mobile device</li><li>CPD accredited course - improve the chance of gaining professional skills</li><li>Gain valuable knowledge without leaving your home</li></ul><p><strong>Courses are included with this Bundle:</strong></p><ul><li><strong>Course 1: </strong>Stock Market Investing for Beginners<strong><br /></strong></li><li><strong>Course 2: </strong>Forex Trading Level 3</li><li><strong>Course 3: </strong>Budgeting and Forecasting<strong><br /></strong></li><li><strong>Course 4: </strong>Business Analysis Level 3</li><li><strong>Course 5: </strong>Level 2 Financial Planning and Management Course<strong><br /></strong></li><li><strong>Course 6: </strong>Corporate Finance: Working Capital Management<strong><br /></strong></li><li><strong>Course</strong> 7:Team Management</li><li><strong>Course 8: </strong>Microsoft Excel Level 3</li><li><strong>Course 9: </strong>GDPR Data Protection Level 5</li><li><strong>Course 10: </strong>Financial Modeling Using Excel<strong><br /></strong></li><li><strong>Course 11: </strong>Fraud Management &amp; Anti Money Laundering Awareness Complete Diploma<strong><br /></strong></li><li><strong>Course 12: </strong>Risk Management Level 7</li></ul><p><strong>Curriculum:</strong></p><p><strong>Course 1: Stock Market Investing for Beginners<br /></strong></p><ul><li>Module 01: Introduction to the Course</li><li>Module 02: Introduction to Stocks</li><li>Module 03: Money Required for Primary Investment</li><li>Module 04: Opening an Investment Account</li><li>Module 05: Brokerage Account Walkthrough</li><li>Module 06: Finding Winning Stocks</li><li>Module 07: Earning from Dividends</li><li>Module 08: Diversifying Portfolio</li><li>Module 09: Investment Plan</li><li>Module 10: Rebalancing Portfolio</li><li>Module 11: Understanding Order Types</li><li>Module 12: Investment Tax</li><li>Module 13: Investment Rules: Rule-1</li><li>Module 14: Investment Rules: Rule-2</li><li>Module 15: Investment Rules: Rule-3</li><li>Module 16: Investment Rules: Rule-4</li><li>Module 17: Investment Rules: Rule-5</li><li>Module 18: Stock Market Dictionary</li><li>Module 19: Setting Up the Trading Platform</li></ul><p><strong>Course 2: Forex Trading Level 3</strong></p><ul><li>Module 1: Introduction to Forex Trading</li><li>Module 2: Major Currencies and Market Structure</li><li>Module 3: Kinds of Foreign Exchange Market</li><li>Module 4: Money Management</li><li>Module 5: Fundamental Analysis</li><li>Module 6: Technical Analysis</li><li>Module 7: Pitfalls and Risks</li><li>Module 8: Managing Risk</li><li>Module 9: Trading Psychology</li></ul><p><strong>Course 3: Budgeting and Forecasting<br /></strong></p><ul><li>Unit-1. Introduction</li><li>Unit-2. Detail Budget Requirement</li><li>Unit-3. Process of Making Budget</li></ul><p><strong>Course 4: Business Analysis Level 3<br /></strong></p><ul><li>Module 01: Introduction to Business Analysis</li><li>Module 02: Business Processes</li><li>Module 03: Business Analysis Planning and Monitoring</li><li>Module 04: Strategic Analysis and Product Scope</li><li>Module 05: Solution Evaluation</li><li>Module 06: Investigation Techniques</li><li>Module 07: Ratio Analysis</li><li>Module 08: Stakeholder Analysis and Management</li><li>Module 09: Process Improvement with Gap Analysis</li><li>Module 10: Documenting and Managing Requirements</li><li>Module 11: Career Prospect as a Business Analyst in the UK</li></ul><p><strong>Course 5: Level 2 Financial Planning and Management Course</strong></p><ul><li>Personal Finance Calculations</li><li>Saving for Retirement</li><li>Building Credit to Buy a Home</li><li>Personal Finance Guides for Beginners</li><li>Cashflow Management</li><li>Budgets and Money Management</li></ul><p><strong>Course 6: Corporate Finance: Working Capital Management</strong></p><ul><li>Module 01: Course Introduction</li><li>Module 02: Introduction to Working Capital Management</li><li>Module 03: Trade Credit and Receivable Management</li><li>Module 04: Payables Management</li><li>Module 05: Inventory Management Practices</li><li>Module 06: Cash Management Practice</li></ul><p><strong>Course 8: Microsoft Excel Level 3<br /></strong></p><ul><li>Microsoft Excel 2019 New Features</li><li>Getting Started with Microsoft Office Excel</li><li>Performing Calculations</li><li>Modifying a Worksheet</li><li>Formatting a Worksheet</li><li>Printing Workbooks</li><li>Managing Workbooks</li><li>Working with Functions</li><li>Working with Lists</li><li>Analyzing Data</li><li>Visualizing Data with Charts</li><li>Using PivotTables and PivotCharts</li><li>Working with Multiple Worksheets and Workbooks</li><li>Using Lookup Functions and Formula Auditing</li><li>Sharing and Protecting Workbooks</li><li>Automating Workbook Functionality</li><li>Creating Sparklines and Mapping Data</li><li>Forecasting Data</li><li>Excel Templates</li></ul><p><strong>Course 9: GDPR Data Protection Level 5<br /></strong></p><ul><li>Module 01: GDPR Basics</li><li>Module 02: GDPR Explained</li><li>Module 03: Lawful Basis for Preparation</li><li>Module 04: Rights and Breaches</li><li>Module 05: Responsibilities and Obligations</li></ul><p><strong>Course 10: Financial Modeling Using Excel<br /></strong></p><ul><li>Welcome to the Course! Get the Overview of What You'll Learn</li><li>Planning your Financial Model</li><li>Building a Model Template</li><li>Projecting the Income Statement</li><li>Projecting the Balance Sheet</li><li>Projecting Cash Flows</li><li>Advanced Financial Modeling</li><li>BONUS LESSON: Top 5 Excel Features for Financial Modellers</li></ul><p><strong>Course 11: Fraud Management &amp; Anti Money Laundering Awareness Complete Diploma<br /></strong></p><ul><li>Module 01: Introduction to Money Laundering</li><li>Module 02: Proceeds of Crime Act 2002</li><li>Module 03: Development of Anti-Money Laundering Regulation</li><li>Module 04: Responsibility of the Money Laundering Reporting Office</li><li>Module 05: Risk-based Approach</li><li>Module 06: Customer Due Diligence</li><li>Module 07: Record Keeping</li><li>Module 08: Suspicious Conduct and Transactions</li><li>Module 09: Awareness and Training</li></ul><p><strong>Course 12: Risk Management Level 7</strong></p><ul><li>Module 01: Introduction to Risk Management</li><li>Module 02: Risk and Types of Risk</li><li>Module 03: Benefits of Risk Management</li><li>Module 04: Enterprise Risk Management</li><li>Module 05: Risk Management Process</li><li>Module 06: Risk Analysis &amp; Assessment</li><li>Module 07: The Risk Evaluation Process</li><li>Module 08: Managing Financial Risks</li><li>Module 09: The Fundamentals of Operational Risk Management</li><li>Module 10: Managing Technology Risks</li><li>Module 11: Managing Legal &amp; Political Risk</li><li>Module 12: Environmental Risk Assessment</li><li>Module 13: Risk Assessment at Workplace</li><li>Module 14: Market &amp; Social Risk Assessment</li><li>Module 15: Preparing Risk Management Plan: Step by Step</li></ul><p><strong>How will I get my Certificate?</strong></p><p>After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.</p><ul><li><strong>PDF Certificate: Free (Previously it was £10 * 12 = £120)</strong></li></ul><ul><li><strong>Hard Copy Certificate: Free (For The Title Course)</strong></li></ul><p>If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a<strong> Flat 50% discount </strong>on hard copy certificates, and you can get each for just <strong>£10</strong>!</p><p><strong>P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99.</strong></p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        125 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>There is no experience or previous qualifications required for enrolment on this <strong>Stock Market Investing &amp; Trading - Level 2</strong>. It is available to all students, of all academic backgrounds.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Our <strong>Stock Market Investing &amp; Trading - Level 2</strong> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.</p><p>There is no time limit for completing this course, it can be studied in your own time at your own pace.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Having these various CPD certificate will increase the value in your CV and open you up to multiple sectors such as Business &amp; Management, Admin, Accountancy &amp; Finance, Secretarial &amp; PA, Teaching &amp; Mentoring etc.</p>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Apex Learning

Stock Market Investing & Trading - Level 2

Duco Digital Training

Business Analyst

Business Analysis

Business Analytics & Intelligence

Duco Digital Training's BCS Foundation Certificate in Business Analysis has been designed to provide learners with knowledge and understanding of business analysis concepts, principles and techniques for roles such as business a analyst.

Business Analysis Course - BCS Foundation

<div id="msbmAccordion">
<div>
<div id="headingOne">
<h2>

</h2>
</div>
<div id="collapseOne">
<div>
<br />The Professional Certificate Course in Marketing Analytics and Its Importance in Hotel Industry provides a comprehensive understanding of marketing analytics and its importance in the hotel industry. The course covers topics such as the definition of marketing analytics, its importance, and the role it plays in business. The course also delves into the various marketing analytics tools and software functions. Participants will learn about the qualifications needed to become a marketing analytics manager and the benefits that hotels can gain through the use of marketing analytics. The course will also cover hotel marketing and competitors analysis, as well as the meaning and scope of a marketing information system. By the end of the course, participants will have gained a solid understanding of how marketing analytics can be used to improve business performance and achieve marketing goals within the hotel industry.
</div>
</div>
</div>
<div>
<div id="headingOne_B">
<h2>

</h2>
</div>
<div id="collapseOne_B">
<div>
<p>The Professional Certificate Course in Marketing Analytics and Its Importance in Hotel Industry is designed to provide participants with a comprehensive understanding of marketing analytics and its significance in the hotel industry. By the end of the course, participants will have gained a solid understanding of how marketing analytics can be used to improve business performance and achieve marketing goals within the hotel industry.<br /><br />After the successful completion of the course, you will be able to learn about the following,<br /><br /></p>
<p>What is marketing Analytics.</p>
<ul>
<li>Importance Marketing Analytics.</li>
<li>Role of Marketing Analytics in Business.</li>
<li>Marketing Analytics Tools.</li>
<li>Function of marketing analytics software</li>
<li>Qualifications for Marketing Analytics Managers:</li>
<li>What Hotels can do through Marketing Analytics.</li>
<li>Hotel Marketing and Competitors Analysis.</li>
<li>Marketing Information System Meaning and Scope.</li>
</ul>
</div>
</div>
</div>
<div> <div id="headingTwo"> <h2>  </h2> </div> <div id="collapseTwo"> <div> <div> <div> <div> <div> <div id="msbmAccordion"> <div> <div> <div> <div> <div id="headingOne1"> <h2>  </h2> </div> <div id="collapse1968"> <div> <p>The Professional Certificate Course in Marketing Analytics and Its Importance in Hotel Industry provides a comprehensive understanding of marketing analytics and its importance in the hotel industry. The course covers topics such as the definition of marketing analytics, its importance, and the role it plays in business. The course also delves into the various marketing analytics tools and software functions. Participants will learn about the qualifications needed to become a marketing analytics manager and the benefits that hotels can gain through the use of marketing analytics. The course will also cover hotel marketing and competitors analysis, as well as the meaning and scope of a marketing information system. By the end of the course, participants will have gained a solid understanding of how marketing analytics can be used to improve business performance and achieve marketing goals within the hotel industry.</p> <ul> <li> <div> <div> <i></i> </div> <div> <h5>VIDEO - Course Structure and Assessment Guidelines</h5> <p>Watch this video to gain further insight.</p> </div> </div> </li> <li> <div> <div> <i></i> </div> <div> <h5>Navigating the MSBM Study Portal</h5> <p>Watch this video to gain further insight.</p> </div> </div> </li> <li> <div> <div> <i></i> </div> <div> <h5>Interacting with Lectures/Learning Components</h5> <p>Watch this video to gain further insight.</p> </div> </div> </li> <li> <div> <div> <i></i> </div> <div> <h5>Marketing Analytics and Its Importance in Hotel Industry</h5> <p>Self-paced pre-recorded learning content on this topic.</p> </div> </div> </li> <li> <div> <div> <i></i> </div> <div> <h5>Professional Certificate Course in Marketing Analytics and Its Importance in Hotel Industry</h5> <p>Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. </p> </div> </div> </li> </ul> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div>
<div>
<div id="headingThree">
<h2>

</h2>
</div>
<div id="collapseThree">
<div>
All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details.
</div>
</div>
</div>
<div>
<div id="headingFive">
<h2>

</h2>
</div>
<div id="collapseFive">
<div>
There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course.<br />The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience.<br /><br />
<ul>
<li>Marketing professionals</li>
<li>Hotel management executives</li>
<li>Business owners and entrepreneurs</li>
<li>Data analysts</li>
<li>Marketing managers and directors</li>
<li>Hospitality industry professionals</li>
<li>Sales and marketing executives</li>
<li>Advertising and digital marketing professionals</li>
<li>Revenue managers</li>
<li>Customer relationship managers.</li>
</ul>
<br /><br /><br />
</div>
</div>
</div>
</div><div>
<div>

<div>
<h5>Average Completion Time</h5>
<p>2 Weeks</p>
</div>
</div>
</div>
<div>
<div>

<div>
<h5>Accreditation</h5>
<p>3 CPD Hours</p>
</div>
</div>
</div>
<div>
<div>

<div>
<h5>Level</h5>
<p>Advanced</p>
</div>
</div>
</div>
<div>
<div>

<div>
<h5>Start Time</h5>
<p>Anytime</p>
</div>
</div>
</div>
<div>
<div>

<div>
<h5>100% Online</h5>
<p>Study online with ease.</p>
</div>
</div>
</div>
<div>
<div>

<div>
<h5>Unlimited Access</h5>
<p>24/7 unlimited access with pre-recorded lectures.</p>
</div>
</div>
</div>
<div>
<div>

<div>
<h5>Low Fees</h5>
<p>Our fees are low and easy to pay online.</p>
</div>
</div>
</div>

Metropolitan School of Business & Management UK

Master of Business Management (MBM)

Online Course Marketing

Marketing Management

Marketing Analytics

Hospitality Management

Business & Marketing

Professional Certificate Course in Marketing Analytics and Its Importance in Hotel Industry in London 2024

<p><strong>Get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now</strong></p><p>Tired of browsing and searching for a <strong>Transport Engineering Courses </strong> you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed.</p><p>After surveying thousands of learners just like you and considering their valuable feedback, this all-in<strong>-</strong>one Transport Engineering Courses bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Transport Engineering Courses that will enhance your skills and prepare you for the competitive job market.</p><p>Also, our experts are available for answering your queries on Transport Engineering Courses and help you along your learning journey. Advanced audio-visual learning modules of these Transport Engineering Courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once.</p><p>Furthermore, to help you showcase your expertise in Transport Engineering Courses, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest.</p><p><strong>This Transport Engineering Courses Bundle Consists of the following Premium courses: </strong></p><ul><li><strong> </strong><strong>Course 01: </strong>Transport Planner Course</li><li><strong> </strong><strong>Course 02: </strong>Import/Export Processing</li><li><strong> </strong><strong>Course 03: </strong>Freight Consultant Training</li><li><strong> </strong><strong>Course 04: </strong>Logistic Management</li><li><strong> </strong><strong>Course 05: </strong>Logistics of Crude Oil and Petroleum Products</li><li><strong> </strong><strong>Course 06: </strong>Material Management</li><li><strong> </strong><strong>Course 07: </strong>SAP Controlling (CO) - Product Costing S4HANA</li><li><strong> </strong><strong>Course 08: </strong>Driving Instructor</li><li><strong> </strong><strong>Course 09: </strong>Vehicle Routing Problem with Spreadsheet</li><li><strong> </strong><strong>Course 10: </strong>Driver Safety Awareness Certificate</li><li><strong> </strong><strong>Course 11: </strong>Manual Handling Level 2</li><li><strong> </strong><strong>Course 12: </strong>Health, Safety &amp; Laws at Workplace | Online Course</li><li><strong> </strong><strong>Course 13: </strong>COSHH Training and Safety - Level 2</li><li><strong> </strong><strong>Course 14: </strong>Emergency First Aid and Incident Management at Work</li></ul><p>Enrol now in Transport Engineering Courses to advance your career, and use the premium study materials from Apex Learning.</p><p><strong>Benefits you'll get from choosing Apex Learning</strong><strong>:</strong></p><ul><li>Pay once and get lifetime access to 14 CPD courses from this bundle</li><li>Free e-Learning App for engaging reading materials &amp; helpful assistance</li><li>Certificates, student ID for the course included in a one-time fee</li><li>Free up your time - don't waste time and money travelling for classes</li><li>Accessible, informative modules of Courses designed by expert instructors</li><li>Learn about Courses at your ease - anytime, from anywhere</li><li>Study the Courses from your computer, tablet or mobile device</li><li>CPD accredited course - improve the chance of gaining professional skills</li></ul><p><strong>How will I get my Certificate?</strong></p><p>After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.</p><ul><li><strong>PDF Certificate: Free (For The Title Course)</strong></li><li><strong>Hard Copy Certificate: Free (For The Title Course)</strong></li></ul><p>The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Transport Engineering Courses expertise and essential knowledge, which will assist you in reaching your goal.</p><p><strong>Curriculum of Bundle</strong></p><p><strong> Course 01: Transport Planner Course</strong></p><p><strong>Transport Management</strong></p><ul><li>An Introduction to Successful Transport Management</li><li>The UK's Travel Infrastructure - Road and Rail</li><li>Road Freight and Transport Management</li><li>Passenger Road Transport and its Management</li><li>Rail and Transport Management</li><li>Transport Management for Ports and Inland Waters and Airlines</li><li>Trends, Challenges and Best Practice in Transport Management and Health and Safety</li></ul><p><strong>SAP Transportation Management</strong></p><ul><li>ECC TM EWM Shipment Integrated Scenario</li><li>SAP Transportation Domestic Scenario</li><li>SAP Transportation Management (TM) Integrated Scenario</li><li>TM Overview + End to End Process Flow</li><li>SAP TM Uncontrolled Shipment Scenario</li><li>SAP TM - Air Way bill ID Generation</li><li>Effective SAP TM for perfect order fulfillment</li></ul><p><strong> Course 02: Import/Export Processing</strong></p><ul><li>Module 01: Introduction to Import Export</li><li>Module 02: Organising the Import Export Operation</li><li>Module 03: Products for Your Import Export Business</li><li>Module 04: Target the Marketing and Find Your Customers</li><li>Module 05: Searching, Marketing, and Distribution</li><li>Module 06: Documentation and Supply Chain Management</li><li>Module 07: Pricing, Payment and Shipping Procedure</li><li>Module 08: Necessary Tools for Trading</li></ul><p><strong> Course 03: Freight Consultant Training</strong></p><ul><li>Module 01: Introduction &amp; Why Learn From Me</li><li>Module 02: Commissions - How You'll Get Paid</li><li>Module 03: Finding Shippers</li><li>Module 04: Finding Trucks</li><li>Module 05: Prospecting &amp; Sales Techniques</li><li>Module 06: Working With Data &amp; The FMCSA</li><li>Module 07: The Future Of Trucking</li><li>Module 08: Over Road Transport Brokerage</li><li>Module 09: Working With Brokers &amp; Agents</li><li>Module 10: All About That Paydex</li><li>Module 11: Understanding Overages, Shortages &amp; Damages</li><li>Module 12: How To Get Hired In The Transportation Industry</li><li>Module 13: Starting Your Own Business</li><li>Module 14: Summary &amp; Thank You</li></ul><p><strong> Course 04: Logistic Management</strong></p><ul><li>Module 01: Introduction to Logistic Management</li><li>Module 02: Planning Framework for Logistics</li><li>Module 03: Supply Chain Management</li><li>Module 04: Logistics Management and Organisation</li><li>Module 05: Sourcing, Purchasing, and Procurement</li><li>Module 06: Channels of Distribution</li><li>Module 07: Supplier Relationship Management</li><li>Module 08: Inventory Planning and Management</li><li>Module 09: Principles of Warehousing</li></ul><p>and many more ...</p><p><strong> Course 05: Logistics of Crude Oil and Petroleum Products</strong></p><ul><li>Unit 01: About The Course</li><li>Unit 02: The Different Methods of Transport</li><li>Unit 03: Marine Transport</li><li>Unit 04: Transport by Pipeline</li><li>Unit 05: Comparing Transport Costs</li><li>Unit 06: Storage and Delivery to the Refinery</li><li>Unit 07: Dispatch of Petroleum Products</li><li>Unit 08: Controls at Dispatch</li></ul><p><strong> Course 06: Material Management</strong></p><ul><li>Introduction to Material Management</li><li>Purchasing and Supply Chain Management</li><li>Inventory Management, Planning and Control</li><li>Stores Management and Control</li><li>Forecasting</li><li>Material Requirements Planning</li><li>Materials Handling</li></ul><p><strong> Course 07: SAP Controlling (CO) - Product Costing S4HANA</strong></p><ul><li>Section 1: Introduction</li><li>Section 2: Material Master Data and Pricing Controls</li><li>Section 3: BoM, Activities and Routing</li><li>Section 4: Overheads in Costing</li><li>Section 5: Costing Sheet</li><li>Section 6: Costing Variant</li><li>Section 7: Routing and Work Centres</li><li>Section 8: Cost Component Structure</li><li>Section 9: Execution of Standard Cost Estimation</li></ul><p><strong> Course 08: Driving Instructor</strong></p><ul><li>Module 01: The Driving Instructor</li><li>Module 02: Structured Driver Training</li><li>Module 03: The ADI Exams</li><li>Module 04: Communication Skills and Dealing with a New Client</li><li>Module 05: Learning to Drive</li><li>Module 06: Driving Large Vehicles</li><li>Module 07: Assessment Items</li><li>Module 08: Disabilities and Impairments</li></ul><p><strong> Course 09: Vehicle Routing Problem with Spreadsheet</strong></p><ul><li>Introduction</li><li>VRP Variants</li><li>Conclusion</li></ul><p><strong> Course 10: Driver Safety Awareness Certificate</strong></p><ul><li>Introduction to Safe Driving</li><li>Reading the Signals and Marks on the Road</li><li>Pre-Journey Safety Check (Vehicle and Driver)</li><li>Safe Driving Tactics for Driving in the UK</li><li>Driving in Poor Condition</li><li>Driving and Human Health</li><li>In the Events of Accidents and Breakdowns</li><li>Laws and Policies Involving Road Safety</li></ul><p><strong> Course 11: Manual Handling Level 2</strong></p><ul><li>Introduction, Legislation and Guidance</li><li>Manual Handling Hazards and Injuries</li><li>Manual Handling Risk Assessments</li><li>Controlling and Reducing the Risks</li><li>Safe Lifting Techniques</li></ul><p><strong> Course 12: Health, Safety &amp; Laws at Workplace | Online Course</strong></p><ul><li>Module 01: Workplace Health and Safety Laws</li><li>Module 02: Managing for Health and Safety</li><li>Module 03: Risk Assessment and Common Risks</li><li>Module 04: Workplace Health, Safety and Welfare</li><li>Module 05: Accidents and Ill Health at Work</li><li>Module 06: Electrical, Fire and Gas Safety</li><li>Module 07: Safety in Different Work Settings</li><li>Module 08: Work Equipment Hazards and Risk Control</li><li>Module 09: Other Health and Safety Hazards at Work</li></ul><p><strong> Course 13: COSHH Training and Safety - Level 2</strong></p><ul><li>COSHH Explained</li><li>COSHH Regulations</li><li>Health Problems Related to Hazardous Substances</li><li>Identifying Hazardous Substances</li><li>COSHH Risk Assessments</li><li>Control Measures and Monitoring</li><li>Implementing Control Measures</li></ul><p><strong> Course 14: Emergency First Aid and Incident Management at Work</strong></p><ul><li>Introduction to Workplace First Aid</li><li>Legal Framework for Workplace First Aid</li><li>Incident Management at Work</li><li>Primary Survey</li><li>Secondary Survey</li><li>Basic First-Aid Techniques</li><li>Dealing with Minor Injuries at the Workplace</li><li>Secondary Illness Loss of Responsiveness and CPR</li><li>Secondary Illness Breathing Problems</li><li>Secondary Illnesses and Injuries</li><li>Dealing With Fractures and Dislocations</li><li>Call for an Emergency</li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        140 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>Anyone from any background can enrol in this Courses bundle.</p><p><strong>Disclaimer:</strong> Our comprehensive course will enhance your theoretical knowledge to help you explore your opportunities in relevant sectors. But please note that this course is not a professional qualification and will not allow you to work professionally.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Our course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Having this bundle expertise will increase the value of your CV and open you up to multiple job sectors.</p>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>
            <div> <p>You will get the PDF Certificate for the title course (<strong>Transport Planner Course</strong>) absolutely Free!</p> </div>
        <h4>Certificate of completion</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div> <p>You will get the Hard Copy certificate for the title course (<strong>Transport Planner Course</strong>) absolutely Free! Other Hard Copy certificates are available for £10 each. </p><p>Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.</p> </div>

                        </div>

Transport Engineering Courses

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><u fr-original-style="" style="box-sizing: border-box;">&#39;A Half-Day Course on the Pre-counselling, Management of, and Safe Removal of Intrauterine Contraception&#39;</u></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><u fr-original-style="" style="box-sizing: border-box;">Introduction</u></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Welcome to our focused half-day course on &#39;Intrauterine Contraception Counselling and Removal,&#39; a comprehensive training designed for clinicians seeking to deepen their understanding and skills in the safe management of IUC (Intrauterine Contraception). Our aim is to provide you with the essential knowledge and hands-on experience needed for confident counselling, checking, and removal of IUC, paving the way for effective and safe practice after a period of supervised application.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Overview</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This engaging and informative session is led by esteemed faculty members, Hanna Smith, a Faculty Registered Trainer with the FSRH, and Dr. Ruth Reakes, bringing together a wealth of expertise and real-world experience. The course is structured to ensure a thorough understanding of the mechanisms, applications, and considerations vital to intrauterine devices (IUD/IUS), focusing on the nuances of pre-counselling, routine checks, and the critical aspects of safe removal.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Programme Outline</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">09:15 - Introduction and Setting Course Objectives</em>: A warm welcome and outlining our goals for the day.</li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">09:30 - Comprehensive Overview of IUC Methods</em>: A detailed exploration of the various IUC options available in clinical practice.</li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">10:00 - Effective Counselling Strategies</em>: Key insights into counselling for IUC insertion and removal, including considerations for pregnancy risk, infection risk, and cycle timings.</li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">10:45 - Coffee Break</em>: A moment to relax and network with peers.</li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">11:00 - Best Practices in IUC Checks and Removal</em>: Guidelines on when and how to check IUC, and crucial factors in deciding when to remove or not to remove.</li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">11:20 - Managing Removal Expectations and Referrals</em>: Understanding what to anticipate during removal and identifying scenarios that require specialist referral.</li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">11:50 - Interactive Case Studies</em>: Applying learned concepts to real-world scenarios to enhance practical understanding.</li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">12:30 - Action Plan and Closing</em>: Wrapping up with a discussion on competencies, an evaluation of the course, and final remarks.</li><li fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Learning Outcomes</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Update on IUC Options</em>: Refresh your understanding of available intrauterine contraception methods.</li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Pre-Procedure Patient Consultation</em>: Master the critical information required before IUC fitting and removal.</li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Criteria for IUC Procedures</em>: Acquire a thorough comprehension of the indications for fitting and removing IUC.</li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Practical Confidence in IUC Management</em>: Enhance your skills and confidence in IUC checking, removal, and follow-up care.</li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Navigating IUC Challenges</em>: Learn about developing effective referral pathways for IUD complications.</li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Problem-Solving in Practice</em>: Engage in collaborative problem-solving for common clinical challenges related to IUC.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">(Please note that the programme may be subject to minor changes.)</em></p>

BBO Training

Clinical

Intrauterine Counselling and Removal

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Duration:&nbsp;</strong>This one day course is run over 2 half days virtually using Teams.</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Overview</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our Microsoft Excel Module 1 &ndash; Key Skills and Formula Creation course shows you all the key features to allow you to confidentially build Excel spreadsheets. &nbsp;It shows quick tips and tricks for working with spreadsheets and looks at different types of formula and how to use Excel more effectively.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;The course is aimed at new or existing users who want to build their skills and confidence in Excel.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Objectives</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">By the end of the course you will be able to:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Create workbooks and worksheets</li><li fr-original-style="" style="box-sizing: border-box;">Create different types of formula</li><li fr-original-style="" style="box-sizing: border-box;">Use basic Excel functions</li><li fr-original-style="" style="box-sizing: border-box;">Use absolute and relative references in formula</li><li fr-original-style="" style="box-sizing: border-box;">Edit and manipulate information</li><li fr-original-style="" style="box-sizing: border-box;">Format worksheets for professional presentation</li><li fr-original-style="" style="box-sizing: border-box;">Create and amend graphs</li><li fr-original-style="" style="box-sizing: border-box;">Preview, print and PDF information</li></ul><div fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Creating a worksheet</strong></div><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Adding text, numbers, dates and times</li><li fr-original-style="" style="box-sizing: border-box;">Using automatic features</li><li fr-original-style="" style="box-sizing: border-box;">Renaming worksheets</li><li fr-original-style="" style="box-sizing: border-box;">Saving a workbook</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Creating simple formulas</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Basic formulas</li><li fr-original-style="" style="box-sizing: border-box;">Formula syntax</li><li fr-original-style="" style="box-sizing: border-box;">Operators and brackets</li><li fr-original-style="" style="box-sizing: border-box;">Ordering calculations</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Using basic functions</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">The function wizard</li><li fr-original-style="" style="box-sizing: border-box;">Using SUM, AVERAGE, MAX and MIN</li><li fr-original-style="" style="box-sizing: border-box;">Copying formula</li><li fr-original-style="" style="box-sizing: border-box;">Auto calculate</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Handling formulas</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Editing formulas</li><li fr-original-style="" style="box-sizing: border-box;">Using absolute references in formulas</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Working with workbooks</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Navigating and editing worksheets</li><li fr-original-style="" style="box-sizing: border-box;">Moving and copying</li><li fr-original-style="" style="box-sizing: border-box;">Adjusting column widths and row heights</li><li fr-original-style="" style="box-sizing: border-box;">Deleting data</li><li fr-original-style="" style="box-sizing: border-box;">Inserting and deleting columns and rows</li><li fr-original-style="" style="box-sizing: border-box;">Zoom</li><li fr-original-style="" style="box-sizing: border-box;">Freeze panes</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Text and number formatting</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Changing text attributes</li><li fr-original-style="" style="box-sizing: border-box;">Changing number formats</li><li fr-original-style="" style="box-sizing: border-box;">Using list autofill</li><li fr-original-style="" style="box-sizing: border-box;">Adding simple borders</li><li fr-original-style="" style="box-sizing: border-box;">Using the Mini Toolbar&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Applying cell styles&nbsp;</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Creating and amending graphs</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Creating simple charts</li><li fr-original-style="" style="box-sizing: border-box;">Changing the type of graph</li><li fr-original-style="" style="box-sizing: border-box;">Adding data labels</li><li fr-original-style="" style="box-sizing: border-box;">Customising the graph</li><li fr-original-style="" style="box-sizing: border-box;">Creating Sparklines</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Printing worksheets</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Using&nbsp;print preview</li><li fr-original-style="" style="box-sizing: border-box;">Amending page setup options</li><li fr-original-style="" style="box-sizing: border-box;">Printing a worksheet</li><li fr-original-style="" style="box-sizing: border-box;">Using Page Layout&nbsp;view and Page Break&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Preview&nbsp;</li></ul>Save as a PDF format

Underscore Group

Microsoft Excel

Microsoft

Start from the ground up and learn tips, tricks, shortcuts and build confidence in using Excel.

Excel Module 1 - Key Skills and Formula Creation

<div data-section-id="1695385309833" style="color: rgb(89, 89, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" style="color: rgb(255, 255, 255); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><div data-section-id="1695385309833" style="color: rgb(89, 89, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" style="color: rgb(255, 255, 255); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Enhance your skills and learn how to use a range of advanced formulas and functions to manage and extract data more efficiently. There are some great ones here that will save a lot of time.</p></div></div></section></div><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><div data-section-id="1695042071629" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="500" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div data-aos="fade-up" data-aos-delay="500" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><img src="https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/77df68e-28e4-057f-41d6-ca1d3577146_Course_Overview_Icon.png" alt="" style="width: 80px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 80px;" fr-original-class="fr-draggable"></div></div><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Course overview</h3><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Duration:&nbsp;1 day (6.5 hours)</strong></p><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);">Our Excel Module 4 &ndash; Advanced Formulas and Functions course looks at some of the more advanced functions of Excel that can be used to manipulate and extract data.</p><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);">This is an intensive one-day course and designed for experienced users of Excel. Participants should be confident in creating and using Excel and be able to build simple formula before attending.</p><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="500" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><br fr-original-style="" style="box-sizing: border-box;"></p></div></div></section></div><div data-section-id="1695042071630" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><img src="https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/8ba0826-4fb5-333c-0ea4-28c13064336b_Objectives_Icon.png" alt="" style="width: 80px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 80px;" fr-original-class="fr-draggable"><br fr-original-style="" style="box-sizing: border-box;"></div></div><div data-section-id="1694266245578" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Objectives</h3><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);">By the end of the course you will be able to:</p><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Use a range of Text functions to manage text data</li><li fr-original-style="" style="box-sizing: border-box;">Create and use different types of date and time functions</li><li fr-original-style="" style="box-sizing: border-box;">Work with rounding functions</li><li fr-original-style="" style="box-sizing: border-box;">Use logical statements</li><li fr-original-style="" style="box-sizing: border-box;">Build nested formula</li><li fr-original-style="" style="box-sizing: border-box;">Use SUMIF, COUNTIF and AVERAGEIF</li><li fr-original-style="" style="box-sizing: border-box;">Cross reference data from other worksheets using LOOKUP, INDEX and MATCH functions</li><li fr-original-style="" style="box-sizing: border-box;">Use IS functions and IFERROR to test cell values</li></ul></div></div></section></div><div data-section-id="1694266514989" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></section></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><img src="https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/cbd24e-e374-8bf2-2a2e-66ae236e51d4_Content_Icon.png" alt="" style="width: 80px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 80px;" fr-original-class="fr-draggable"></p></section></div><div data-section-id="1695042071631" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-section-id="1695048787156" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Content</h3><div data-section-id="1695060919750" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Working with text&nbsp;</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Splitting text into multiple cells</li><li fr-original-style="" style="box-sizing: border-box;">Merging data into one cell</li><li fr-original-style="" style="box-sizing: border-box;">Extracting data using text functions</li><li fr-original-style="" style="box-sizing: border-box;">Tidying data</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Working with dates and times &nbsp;</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Formatting dates and times</li><li fr-original-style="" style="box-sizing: border-box;">Date and time functions</li><li fr-original-style="" style="box-sizing: border-box;">Calculating date and time differences</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Using functions to round numbers up and down&nbsp;</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">ROUND</li><li fr-original-style="" style="box-sizing: border-box;">ROUNDUP</li><li fr-original-style="" style="box-sizing: border-box;">ROUNDDOWN</li><li fr-original-style="" style="box-sizing: border-box;">CEILING</li><li fr-original-style="" style="box-sizing: border-box;">FLOOR</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Use lookup functions&nbsp;</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Lookup functions</li><li fr-original-style="" style="box-sizing: border-box;">Creating a lookup table</li><li fr-original-style="" style="box-sizing: border-box;">Range naming</li><li fr-original-style="" style="box-sizing: border-box;">Using VLOOKUP</li><li fr-original-style="" style="box-sizing: border-box;">Using HLOOKUP</li><li fr-original-style="" style="box-sizing: border-box;">Using INDEX and MATCH</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Working with logical statements&nbsp;</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Creating an IF statement</li><li fr-original-style="" style="box-sizing: border-box;">Using the AND plus OR functions</li><li fr-original-style="" style="box-sizing: border-box;">Nesting functions</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Calculating values based on given criteria</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">SUMIF(S)</li><li fr-original-style="" style="box-sizing: border-box;">COUNTIF(S)</li><li fr-original-style="" style="box-sizing: border-box;">AVERAGEIF(S)</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Using IS and IFERROR and test cell values</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">ISBLANK</li><li fr-original-style="" style="box-sizing: border-box;">ISNUMBER</li><li fr-original-style="" style="box-sizing: border-box;">ISTEXT</li><li fr-original-style="" style="box-sizing: border-box;">ISERROR</li><li fr-original-style="" style="box-sizing: border-box;">IFERROR</li></ul></div></div></section></div><div data-section-id="1695060919751" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" style="color: rgb(255, 255, 255); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><br fr-original-style="" style="box-sizing: border-box;"></section></div></div></div></section></div></div></section></div></div></div></section></div><div data-section-id="1695042071631" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-section-id="1695048787156" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><div data-section-id="1695060919751" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><br fr-original-style="" style="box-sizing: border-box;"></div></div></div></section></div></div></section></div>

Excel Module 4 Advanced Formulas and Functions

The Learning College Group

Teaching Assistant

If you’re interested in becoming a fully qualified Teaching Assistant, but don’t know where to start your learning journey, then the Teaching Assistant Level 3 Diploma training course could be the perfect option for you. Learn the skills and knowledge needed to succeed!

The Teaching Assistant Level 3 Diploma course has been designed by our team of teaching experts to provide you with a complete overview of what is needed to become a successful TA. Enrol on the Teaching Assistant Level 3 Diploma course today and kickstart a new and exciting career helping children reach their full potential.

Level 3 Teaching Assistant Diploma - Specialist Support with Children (RQF)

Full Price

Deposit of £65.00 followed by 10 x £55.00 per month.

Deposit payment

1/10 monthly instalments

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>This course is for Azure Administrators. The Azure Administrator implements, manages, and monitors identity, governance, storage, compute, and virtual networks in a cloud environment. The Azure Administrator will provision, size, monitor, and adjust resources as appropriate.</p><p></p><p></p><p>This course teaches IT Professionals how to manage their Azure subscriptions, secure identities, administer the infrastructure, configure virtual networking, connect Azure and on-premises sites, manage network traffic, implement storage solutions, create and scale virtual machines, implement web apps and containers, back up and share data, and monitor your solution.</p><p></p>Prerequisites<p>Successful Azure Administrators start this role with experience in virtualization, networking, identity, and storage. Understanding of on-premises virtualization technologies, including: VMs, virtual networking, and virtual hard disks. Understanding of network configurations, including TCP/IP, Domain Name System (DNS), virtual private networks (VPNs), firewalls, and encryption technologies. Understanding of Active Directory concepts, including users, groups, and role-based access control. Understanding of resilience and disaster recovery, including backup and restore operations.</p></div><div id="course-pills-2"><h3>1 - Configure Microsoft Entra ID</h3> <ul> <li>Describe Microsoft Entra ID benefits and features</li> <li>Describe Microsoft Entra concepts</li> <li>Compare Active Directory Domain Services to Microsoft Entra ID</li> <li>Select Microsoft Entra editions</li> <li>Implement Microsoft Entra join</li> <li>Implement Microsoft Entra self-service password reset</li> </ul> <h3>2 - Configure user and group accounts</h3> <ul> <li>Create user accounts</li> <li>Manage user accounts</li> <li>Create bulk user accounts</li> <li>Create group accounts</li> <li>Create administrative units</li> </ul> <h3>3 - Configure subscriptions</h3> <ul> <li>Identify Azure regions</li> <li>Implement Azure subscriptions</li> <li>Obtain an Azure subscription</li> <li>Identify Azure subscription usage</li> <li>Implement Microsoft Cost Management</li> <li>Apply resource tagging</li> <li>Apply cost savings</li> </ul> <h3>4 - Configure Azure Policy</h3> <ul> <li>Create management groups</li> <li>Implement Azure policies</li> <li>Create Azure policies</li> <li>Create policy definitions</li> <li>Create an initiative definition</li> <li>Scope the initiative definition</li> <li>Determine compliance</li> </ul> <h3>5 - Configure role-based access control</h3> <ul> <li>Implement role-based access control</li> <li>Create a role definition</li> <li>Create a role assignment</li> <li>Compare Azure roles to Microsoft Entra roles</li> <li>Apply role-based access control</li> <li>Review fundamental Azure RBAC roles</li> </ul> <h3>6 - Configure Azure resources with tools</h3> <ul> <li>Use the Azure portal</li> <li>Use Azure Cloud Shell</li> <li>Use Azure PowerShell</li> <li>Use Azure CLI</li> </ul> <h3>7 - Use Azure Resource Manager</h3> <ul> <li>Review Azure Resource Manager benefits</li> <li>Review Azure resource terminology</li> <li>Create resource groups</li> <li>Create Azure Resource Manager locks</li> <li>Reorganize Azure resources</li> <li>Remove resources and resource groups</li> <li>Determine resource limits</li> </ul> <h3>8 - Configure resources with Azure Resource Manager templates</h3> <ul> <li>Review Azure Resource Manager template advantages</li> <li>Explore the Azure Resource Manager template schema</li> <li>Explore the Azure Resource Manager template parameters</li> <li>Consider Bicep templates</li> <li>Review QuickStart templates</li> </ul> <h3>9 - Configure virtual networks</h3> <ul> <li>Plan virtual networks</li> <li>Create subnets</li> <li>Create virtual networks</li> <li>Plan IP addressing</li> <li>Create public IP addressing</li> <li>Associate public IP addresses</li> <li>Allocate or assign private IP addresses</li> </ul> <h3>10 - Configure network security groups</h3> <ul> <li>Implement network security groups</li> <li>Determine network security group rules</li> <li>Determine network security group effective rules</li> <li>Create network security group rules</li> <li>Implement application security groups</li> </ul> <h3>11 - Configure Azure DNS</h3> <ul> <li>Identify domains and custom domains</li> <li>Verify custom domain names</li> <li>Create Azure DNS zones</li> <li>Delegate DNS domains</li> <li>Add DNS record sets</li> <li>Plan for Azure Private DNS zones</li> <li>Review Azure Private DNS zone scenarios</li> </ul> <h3>12 - Configure Azure Virtual Network peering</h3> <ul> <li>Determine Azure Virtual Network peering uses</li> <li>Determine gateway transit and connectivity</li> <li>Create virtual network peering</li> <li>Extend peering with user-defined routes and service chaining</li> </ul> <h3>13 - Configure network routing and endpoints</h3> <ul> <li>Review system routes</li> <li>Identify user-defined routes</li> <li>Determine service endpoint uses</li> <li>Determine service endpoint services</li> <li>Identify private link uses</li> </ul> <h3>14 - Configure Azure Load Balancer</h3> <ul> <li>Determine Azure Load Balancer uses</li> <li>Implement a public load balancer</li> <li>Implement an internal load balancer</li> <li>Determine load balancer SKUs</li> <li>Create back-end pools</li> <li>Create health probes</li> <li>Create load balancer rules</li> </ul> <h3>15 - Configure Azure Application Gateway</h3> <ul> <li>Implement Azure Application Gateway</li> <li>Determine Azure Application Gateway routing</li> <li>Configure Azure Application Gateway components</li> </ul> <h3>16 - Configure storage accounts</h3> <ul> <li>Implement Azure Storage</li> <li>Explore Azure Storage services</li> <li>Determine storage account types</li> <li>Determine replication strategies</li> <li>Access storage</li> <li>Secure storage endpoints</li> </ul> <h3>17 - Configure Azure Blob Storage</h3> <ul> <li>Implement Azure Blob Storage</li> <li>Create blob containers</li> <li>Assign blob access tiers</li> <li>Add blob lifecycle management rules</li> <li>Determine blob object replication</li> <li>Upload blobs</li> <li>Determine Blob Storage pricing</li> </ul> <h3>18 - Configure Azure Storage security</h3> <ul> <li>Review Azure Storage security strategies</li> <li>Create shared access signatures</li> <li>Identify URI and SAS parameters</li> <li>Determine Azure Storage encryption</li> <li>Create customer-managed keys</li> <li>Apply Azure Storage security best practices</li> </ul> <h3>19 - Configure Azure Files and Azure File Sync</h3> <ul> <li>Compare storage for file shares and blob data</li> <li>Manage Azure file shares</li> <li>Create file share snapshots</li> <li>Implement Azure File Sync</li> <li>Identify Azure File Sync components</li> <li>Deploy Azure File Sync</li> </ul> <h3>20 - Configure Azure Storage with tools</h3> <ul> <li>Use Azure Storage Explorer</li> <li>Use the Azure Import/Export service</li> <li>Use the WAImportExport tool</li> <li>Use the AzCopy tool</li> </ul> <h3>21 - Configure virtual machines</h3> <ul> <li>Review cloud services responsibilities</li> <li>Plan virtual machines</li> <li>Determine virtual machine sizing</li> <li>Determine virtual machine storage</li> <li>Create virtual machines in the Azure portal</li> <li>Connect to virtual machines</li> </ul> <h3>22 - Configure virtual machine availability</h3> <ul> <li>Plan for maintenance and downtime</li> <li>Create availability sets</li> <li>Review update domains and fault domains</li> <li>Review availability zones</li> <li>Compare vertical and horizontal scaling</li> <li>Implement Azure Virtual Machine Scale Sets</li> <li>Create Virtual Machine Scale Sets</li> <li>Implement autoscale</li> <li>Configure autoscale</li> </ul> <h3>23 - Configure Azure App Service plans</h3> <ul> <li>Implement Azure App Service plans</li> <li>Determine Azure App Service plan pricing</li> <li>Scale up and scale out Azure App Service</li> <li>Configure Azure App Service autoscale</li> </ul> <h3>24 - Configure Azure App Service</h3> <ul> <li>Implement Azure App Service</li> <li>Create an app with App Service</li> <li>Explore continuous integration and deployment</li> <li>Create deployment slots</li> <li>Add deployment slots</li> <li>Secure your App Service app</li> <li>Create custom domain names</li> <li>Back up and restore your App Service app</li> <li>Use Azure Application Insights</li> </ul> <h3>25 - Configure Azure Container Instances</h3> <ul> <li>Compare containers to virtual machines</li> <li>Review Azure Container Instances</li> <li>Implement container groups</li> <li>Review the Docker platform</li> </ul> <h3>26 - Configure file and folder backups</h3> <ul> <li>Describe Azure Backup benefits</li> <li>Implement Backup Center for Azure Backup</li> <li>Configure Azure Recovery Services vault backup options</li> <li>Use the Microsoft Azure Recovery Services (MARS) agent</li> <li>Configure on-premises file and folder backups</li> </ul> <h3>27 - Configure virtual machine backups</h3> <ul> <li>Explore options to protect virtual machine data</li> <li>Create virtual machine snapshots in Azure Backup</li> <li>Set up Azure Recovery Services vault backup options</li> <li>Back up your virtual machines</li> <li>Restore your virtual machines</li> <li>Implement System Center DPM and Azure Backup Server</li> <li>Compare the MARS agent and Azure Backup Server</li> <li>Implement soft delete for your virtual machines</li> <li>Implement Azure Site Recovery</li> </ul> <h3>28 - Configure Azure Monitor</h3> <ul> <li>Describe Azure Monitor key capabilities</li> <li>Describe Azure Monitor components</li> <li>Define metrics and logs</li> <li>Identify monitoring data and tiers</li> <li>Describe activity log events</li> <li>Query the activity log</li> </ul> <h3>29 - Configure Azure alerts</h3> <ul> <li>Describe Azure Monitor alerts</li> <li>Manage Azure Monitor alerts</li> <li>Create alert rules</li> <li>Create action groups</li> </ul> <h3>30 - Configure Log Analytics</h3> <ul> <li>Determine Log Analytics uses</li> <li>Create a Log Analytics workspace</li> <li>Create Kusto (KQL) queries</li> <li>Structure Log Analytics queries</li> </ul> <h3>31 - Configure Network Watcher</h3> <ul> <li>Describe Azure Network Watcher features</li> <li>Review IP flow verify diagnostics</li> <li>Review next hop diagnostics</li> <li>Visualize the network topology</li> </ul></div>

Nexus Human

Microsoft AZ-900

Microsoft Virtual Academy (MVA)

Microsoft AZ-104

Microsoft Azure

Microsoft AZ-303

Microsoft AZ-700

AZ-104T00 Microsoft Azure Administrator

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>The primary audience for this course is an IT, facilities or data centre operations professional working in and around the data centre and having the responsibility to achieve and improve high-availability and manageability of the data centre.</p>Overview<p>After completion of the course the participant will be able to:? Understand the design life cycle of data centres and the stages involved? Discuss the data centre requirements in great level of detail with vendors, suppliers and contractors to ensure that these requirements are met? Validate design plans, quotes and offers proposed by vendors/contractors? Understand redundancy levels for both the data centre design/setup and maintenance? Understand the various building considerations such as bullet proofing, mitigation of seismic activity, fire ratings and thermal stability? Understand how to install a raised floor that meets requirements, avoiding misalignment, level differences and leakage? Understand how to read a Single Line Electrical Diagram to identify and avoid the most common design issues? Choose the correct UPS and parallel configuration, learn and avoid classic parallel installation mistakes? Understand how to calculate battery banks, validate offered configurations to ensure they meet requirements? Understand what distance to keep to avoid EMF issues for human safety and equipment disturbances? Understand the fundamental cooling setup, CFM, Delta-T and other important factors? Understand contamination factors and limitations? Understand full details of fire suppression options, how to calculate gas content and verify installations? Understand how to measure data centre energy efficiency and how to improve it</p><p>The course will bring participants to the level of a suitable sparring partner with suppliers. They will be able to verify offers provided by vendors for correctness, effectiveness and efficiency.</p></div><div id="course-pills-2"><h4>Data Centre Design/Life Cycle Overview</h4><ul><li>Overview of the phases of a data centre life cycle<br />Planning, re-alignment and continuous improvement</li></ul><h4>Standards and Rating Level Definitions</h4><ul><li>Rating level history<br />Difference between Uptime and TIA-942<br />Rating level definitions<br />Redundancy options (N+1), 2N, 2(N+1)<br />Concurrent Maintainability/Compartmentalisation<br />Example configurations<br />Substation and feed requirements<br />Maintenance options<br />Operational processes guidelines/standards<br />Skill development</li></ul><h4>Building Considerations</h4><ul><li>Building location considerations<br />Floor and hanging loads requirements<br />Fire rating for walls and glass<br />Blast protection<br />Bullet proofing<br />Forced entry protection</li></ul><h4>Advanced Raised Floor &amp; Suspended Ceiling</h4><ul><li>Raised floor installation guidelines<br />Techniques to install a proper and leveled raised access floor<br />Common mistakes<br />Choosing the right tiles and their locations<br />Seismic-mitigating floor constructions<br />Choosing the correct suspended ceiling</li></ul><h4>Advanced Power</h4><ul><li>Power infrastructure layout;<br />Formulas which you should know for the data centre<br />Single Line Electrical diagrams; how to read to ensure key components are present for protection<br />Over current protection devices (MCB/MCCB/VCB/ACB/Fuses) definitions and what to use where<br />Earth Leakage devices (RCB/RCD/ELCB/GFCI/ALCI/RCBO), definitions and what to use where<br />Sizing of protective components<br />Lightning strikes and surge protection devices (TVSS/SPD), how they operate, where to use and how to install<br />Power cabling and cable run considerations<br />PDU/DB setup and minimum requirements<br /><br />Generators;<br />Generator types: Standy/Prime/Continuous<br />Component make up and functions<br />Fuel storage and calculation<br />Paralleling of gen-sets<br />Generator room/area requirements<br /><br />UPS Systems;<br />Required specifications for UPS systems<br />How to read data sheets and select the correct UPS<br />Requirements for parallel configurations and avoid pitfalls such as single point of failures<br />How parallel installation should be done, classic mistakes made by installers and how to avoid these<br /><br />Harmonic Filters;<br />Active/Passive filters and their application<br /><br />Battery Banks;<br />Battery bank terminology<br />Designing battery banks, how to calculate, and double check the battery bank to be installed<br />Battery charging pitfalls and ensuring the right charger is being installed and used<br />Using parallel battery banks; how to properly install them, limitations and risks when using batteries in parallel<br />How to test batteries correctly and make decisions on cell/block or string replacement<br />Battery casing choices; ABS, V0, V1, V2<br />Alternative energy storage; flywheel, re-usable cell, compressed air UPS, etc.</li></ul><h4>Advanced Electro Magnetic Fields</h4><ul><li>Sources of EMF<br />Difference between single, three phase and bus-bar EMF<br />Options available to measure EMF and how to interpret the results from single-axes and composite measurements<br />Guidance on safe distance for equipment and humans<br />Calculation of EMF attenuation factor for shielding material permeability and saturation factors</li></ul><h4>Advanced Cooling</h4><ul><li>Important definitions; dry-bulb, wet-bulb, dew-point, RH, sensible and latent heat<br />Psychometric chart and ASHRAE recommendations<br />Environmental class definitions and thermal specifications<br />Temperature/humidity measurements guideline<br />Heat dissipation methods<br />Altitude impact on temperature intake to ICT equipment<br />Floor plan setup for effective cooling<br />Differences in tile surface and supporting structure and the air-flow performance impact<br />Rack door construction and the flow performance impact<br />Equipment Delta-T and its impact<br />Optimising air flow<br />Thermal units conversions<br />Calculations for air volume displacement (CFM/CMH)<br />Cooling capacity calculations<br />Air-conditioning selection<br />De- / humidifying options<br />Air conditioning efficiency<br />SHR impact on cost saving<br />Efficiency indicator<br />New cooling principle and techniques (Submerged, VSD/VRF/ECF/water- and air side economisers)<br />Redundancy guidelines for air-conditioners avoiding classic misconceptions and mistakes for meeting ANSI/TIA-942 compliant designs<br />Installation requirements<br />Connections to fire panel and EPO<br />Commissioning of air conditioners<br />Set points and calibration<br />CFD (Computational Fluid Dynamics)</li></ul><h4>Advanced Fire Protection</h4><ul><li>The fire triangle and elements to stop a fire<br />Detection systems in detail (VESDA, VIEW, smoke sensors)<br />Considerations for installation of sensors<br />Proper testing of smoke sensors<br />Water based systems i.e. deluge, wet-pipe, dry-pipe, pre-action and why most of them don't work and how to detect this<br />Details on Inert and Halocarbon systems and how to select the correct system for your data centre<br />How to calculate the gas content ensuring the appropriate level is installed to suppress the fire including safety considerations<br />Other requirements for gas systems such as release times, hold times, pipe install requirements and other important factors<br />Requirements for the fire detection panel<br />Installation verification, methods, what to check and how<br />New advanced fire suppression technologies</li></ul><h4>Design and Install Scalable Networking Cabling System</h4><ul><li>ANSI/TIA942 cabling structure topology<br />ToR, EoR Design<br />Intelligent patching systems<br />Installation best practice such as routing, bending radius, separation from power, containment fill ratio, fiber link loss calculator, bonding and grounding requirement<br />Standard for telecommunications labeling and administration</li></ul><h4>Environmental Specifications and Contamination Control</h4><ul><li>Acoustic noise effects, regulations, specifications and limits<br />Data centre contaminations and classifications<br />Measurements, standards and limits<br />Preventive measures and avoidance</li></ul><h4>Data Centre Efficiency</h4><ul><li>Business drivers to go Green<br />High-availability or Green?<br />Green guidelines and standards<br />How to measure it and what are acceptable numbers compared to the general industry<br />PUE classes defined by Green Grid and issues with PUE<br />Techniques for saving energy in all parts of the data centre i.e. application/system level, cooling, power distribution</li></ul><h4>Mock Exam</h4><h4>EXAM: Certified Data Centre Specialist</h4></div>

Service Design Courses (SDC)

IT Certifications

Construction Design & Management (CDM)

Certificate of Business Continuity Programme (CBCI)

Certified in Data Protection (CDP)

Electrical Design

Certified Data Centre Specialist (CDCS)

<span dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">In January 2024 alone, reports were published about the SRA taking enforcement action against 3 firms and 4 individuals for failure to comply with the Money Laundering Regulations 2017. The fines issued for these non-compliances total over &pound;570,000 plus costs. The absence of staff training, or requirement to complete additional training, was noted in a number of these cases.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Action has not only been taken against solicitors, but also other individuals who are not regulated by the SRA, whose breaches were so serious that the SRA felt compelled to take action.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">As all SRA enforcement action, from rebukes to fines, is published by the SRA, the potential financial and reputational impact upon firms may be felt by all staff, regardless of whether they had any direct involvement with the non-compliance.</span></p><span dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">This course will cover the following to assist support staff in understanding the fundamental aspects of AML.</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The basics of what AML is</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">In scope / not in scope work for AML</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">POCA / TA</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">PCPs - CDD &amp; EDD</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Clients</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Risks &ndash; what could raise a risk?</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Reporting to the MLRO / MLCO</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Tipping off</li></ul></span><h2 fr-original-style="" style="box-sizing: border-box;">Target Audience</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;">The online course is suitable for support staff or legal practitioners wanting to understand the basics of AML.</span></p></span><h2 data-key="21" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Resources</h2><p data-key="28" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span data-key="29" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="29:0" fr-original-style="" style="box-sizing: border-box;">Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training.</span></span></p><p data-key="30" data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJoZWFkaW5nLXRocmVlJTIyJTJDJTIyZGF0YSUyMiUzQSU3QiUyMmNsYXNzTmFtZSUyMiUzQW51bGwlN0QlMkMlMjJub2RlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMnRleHQlMjIlMkMlMjJsZWF2ZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMkNvdXJzZSUyME5vdGVzJTIyJTJDJTIybWFya3MlMjIlM0ElNUIlNUQlN0QlNUQlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyQ29tcHJlaGVuc2l2ZSUyMGFuZCUyMHVwJTIwdG8lMjBkYXRlJTIwY291cnNlJTIwbm90ZXMlMjB3aWxsJTIwYmUlMjBwcm92aWRlZCUyMHRvJTIwYWxsJTIwZGVsZWdhdGVzJTIwd2hpY2glMjBtYXklMjBiZSUyMHVzZWZ1bCUyMGZvciUyMG9uZ29pbmclMjByZWZlcmVuY2UlMjBvciUyMGNhc2NhZGUlMjB0cmFpbmluZy4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCUyQyU3QiUyMm9iamVjdCUyMiUzQSUyMmJsb2NrJTIyJTJDJTIydHlwZSUyMiUzQSUyMnBhcmFncmFwaCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlMjJjbGFzc05hbWUlMjIlM0FudWxsJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJ0ZXh0JTIyJTJDJTIybGVhdmVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJQbGVhc2UlMjBub3RlJTIwYSUyMHJlY29yZGluZyUyMG9mJTIwdGhlJTIwY291cnNlJTIwd2lsbCUyMCUyMiUyQyUyMm1hcmtzJTIyJTNBJTVCJTVEJTdEJTJDJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJub3QlMjAlMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMm1hcmslMjIlMkMlMjJ0eXBlJTIyJTNBJTIyYm9sZCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlN0QlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMmJlJTIwbWFkZSUyMGF2YWlsYWJsZS4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCU1RCU3RA==" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span data-key="31" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="31:0" fr-original-style="" style="box-sizing: border-box;">Please note a recording of the course will&nbsp;</span><span data-offset-key="31:1" fr-original-style="" style="box-sizing: border-box;"><strong data-slate-leaf="true" fr-original-style="" style="font-weight: 700; box-sizing: border-box;">not&nbsp;</strong></span><span data-offset-key="31:2" fr-original-style="" style="box-sizing: border-box;">be made available.</span></span></p><h2 data-key="35" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span data-key="36" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="36:0" fr-original-style="" style="box-sizing: border-box;">Speaker</span></span></h2><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><a href="https://dglegal.co.uk/the-team/helen-torresi/" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 180, 205); box-sizing: border-box;" fr-original-style="color: rgb(0, 180, 205);">Helen Torresi, Consultant, DG Legal</span></strong></a></h3><p style="color: rgb(89, 89, 91); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(89, 89, 91);"><span style="color: rgb(89, 89, 91); box-sizing: border-box;" fr-original-style="color: rgb(89, 89, 91);">Helen is a qualified solicitor with a diverse professional background spanning leadership roles in both the legal and tech/corporate sectors. Throughout her career, she has held key positions such as COLP, HOLP, MLCO, MLRO and DPO for law firms and various regulated businesses and services.</span></p><p style="color: rgb(89, 89, 91); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(89, 89, 91);"><span style="color: rgb(89, 89, 91); box-sizing: border-box;" fr-original-style="color: rgb(89, 89, 91);">Helen&rsquo;s specialised areas encompass AML, complaint and firm negligence handling, DPA compliance, file review and auditing, law management, and operational effectiveness in law firms, particularly in conveyancing (CQS).</span></p>

In January 2024 alone, reports were published about the SRA taking enforcement action against 3 firms and 4 individuals for failure to comply with the Money Laundering Regulations 2017. The fines issued for these non-compliances total over £570,000 plus costs. The absence of staff training, or requirement to complete additional training, was noted in a number of these cases.
Action has not only been taken against solicitors, but also other individuals who are not regulated by the SRA, whose breaches were so serious that the SRA felt compelled to take action. 
As all SRA enforcement action, from rebukes to fines, is published by the SRA, the potential financial and reputational impact upon firms may be felt by all staff, regardless of whether they had any direct involvement with the non-compliance.
This course will cover the following to assist support staff in understanding the fundamental aspects of AML.
The basics of what AML is
In scope / not in scope work for AML
POCA / TA
PCPs - CDD & EDD
Clients
Risks – what could raise a risk?
Reporting to the MLRO / MLCO
Tipping off
Target Audience
The online course is suitable for support staff or legal practitioners wanting to understand the basics of AML.
Resources
Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training.
Please note a recording of the course will not be made available.
Speaker
Helen Torresi, Consultant, DG Legal
Helen is a qualified solicitor with a diverse professional background spanning leadership roles in both the legal and tech/corporate sectors. Throughout her career, she has held key positions such as COLP, HOLP, MLCO, MLRO and DPO for law firms and various regulated businesses and services.
Helen’s specialised areas encompass AML, complaint and firm negligence handling, DPA compliance, file review and auditing, law management, and operational effectiveness in law firms, particularly in conveyancing (CQS).

DG Legal

Anti-Money Laundering (AML)

Anti-Money Laundering (AML) Training For Support Staff Course

General Delegate

A discount is available for delegates attending from firms with a current retainer contract with DG Legal (please contact us by email to admin@dglegal.co.uk for confirmation of eligibility).   If you choose this option and are not eligible, you are still bound to pay the full rate and will be invoiced accordingly.

Retainer Delegate

<p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(var(--color_25));"><span style="color: rgb(184, 49, 47); box-sizing: border-box;" fr-original-style="color: rgb(184, 49, 47);">Attention: This course is delivered over 2 half-days (3pm to 6:30pm London time, consecutive half-days excluding weekend). If you&#39;re interested in the same course but delivered over 1 full day, please click&nbsp;</span><span style="color: rgb(184, 49, 47); box-sizing: border-box;" fr-original-style="color: rgb(184, 49, 47);"><a href="https://www.ask-sonia.com/training/other-brcgs-courses/gluten-free-auditor" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; color: inherit; cursor: pointer; text-decoration: inherit;"><u fr-original-style="" style="box-sizing: border-box;">here</u></a></span><span style="color: rgb(184, 49, 47); box-sizing: border-box;" fr-original-style="color: rgb(184, 49, 47);">. Thank you.</span></p><p style="color: rgb(77, 77, 79); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(77, 77, 79);">This training course has been designed for auditors to help gain an appreciation of celiac disease and non-celiac gluten sensitivity, understand the Gluten-Free Certification Program Global Standard requirements and to provide guidance on auditing a Gluten-Free Management System. Training for Issue 4 is now available and is a mandatory requirement for all Gluten-Free Certification Program certified auditors.</p><p style="color: rgb(77, 77, 79); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Auditors should have a minimum of 5 years&rsquo; experience in auditing food safety/ quality systems. This may include internal, 2nd party and 3rd party auditing. Must have valid lead auditor training certificate for any FSMS standard.</p><p style="color: rgb(77, 77, 79); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Assessment: 50 question exam (pass mark 75%)</p><h4 style="color: rgb(234, 118, 0); box-sizing: border-box;" fr-original-style=" color: rgb(234, 118, 0);">At the end of this course, you will be able to:</h4><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Identify key objective evidence required to determine compliance with the Gluten-Free Certification Program Global Standard</li><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Correctly complete auditor documentation.</li><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Be able to effectively communicate a clear &ldquo;snap-shot&rdquo; regarding the operation and the levels of conformity.</li><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Recall GMPs relating to gluten management</li><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">List the individual components that make up the Gluten-free Certification Program Global Standard</li><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Identify different gluten controls that must be implemented as part of a gluten-free management system</li></ul><div id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; color: rgb(243, 121, 52); box-sizing: border-box;" fr-original-style="font-size: 16px; color: rgb(243, 121, 52);">Note: This course is proposed as either 1 full day, or 2x half-days. Please carefully review the date &amp; time options before confirming your booking.</span></div>

Ask Sonia Limited

Food Safety

Auditor

Official BRCGS Gluten-Free Issue 4 for Auditors course.
Delivered online (Zoom) by a live BRCGS Approved Training Partner.
Exam and Certificate fee included in the price.

BRCGS Gluten-Free Issue 4 for Auditors (2 Half-Day Sessions)

<p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(var(--color_25));"><span style="color: rgb(184, 49, 47); box-sizing: border-box;" fr-original-style="color: rgb(184, 49, 47);">Attention: This course is delivered over 2 half-days (3pm to 6:30pm London time, consecutive half-days excluding weekend). If you&#39;re interested in the same course but delivered over 1 full day, please click&nbsp;</span><span style="color: rgb(184, 49, 47); box-sizing: border-box;" fr-original-style="color: rgb(184, 49, 47);"><a href="https://www.ask-sonia.com/training/other-brcgs-courses/gluten-free-sites" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; color: inherit; cursor: pointer; text-decoration: inherit;"><u fr-original-style="" style="box-sizing: border-box;">here</u></a></span><span style="color: rgb(184, 49, 47); box-sizing: border-box;" fr-original-style="color: rgb(184, 49, 47);">. Thank you.</span></p><p style="color: rgb(77, 77, 79); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(77, 77, 79);">This training course has been designed for new or existing Gluten-Free Certification Program customers to help gain an appreciation of celiac disease and non-celiac gluten sensitivity, understand the Gluten-Free Certification Program Global Standard requirements and to provide guidance on implementing a preventative, risk-based Gluten-Free Management System.</p><p style="color: rgb(77, 77, 79); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">This training will also explain the process that a business will need to follow in order to become a certified Gluten-Free site.</p><h4 style="color: rgb(234, 118, 0); box-sizing: border-box;" fr-original-style=" color: rgb(234, 118, 0);">Key learning objectives:</h4><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Identify the impact that celiac disease has on individuals and demonstrate an understanding of why the food industry is required to manage gluten</li><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Explain the concept of cross contact and the potential for cross contact in a food production process</li><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Outline key legal requirements relating to gluten-free labelling</li><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Identify different gluten controls that must be implemented as part of a gluten-free management system</li><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Outline the importance of prerequisite programs in safeguarding a gluten-free site</li><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Describe the process for obtaining certification to the Gluten-free Certification Program Global Standard</li><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Understand the protocol for audits to the Standard</li></ul><div id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; color: rgb(243, 121, 52); box-sizing: border-box;" fr-original-style="font-size: 16px; color: rgb(243, 121, 52);">Note: This course is proposed as either 1x full day, or 2x half-days. Please carefully review the date &amp; time options before confirming your booking.</span></div>

Official BRCGS Gluten-Free Issue 4 for Sites course.
Delivered online (Zoom) by a live BRCGS Approved Training Partner.
Exam and Certificate fee included in the price.

BRCGS Gluten-Free Issue 4 for Sites (2 Half-Day Sessions)

<p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(var(--color_25));">This official BRCGS two-day course will enable you to undertake internal audits and prepare companies for third party audits. It is delivered through a series of workshop-led discussions, presentations and an interactive case study. During the live case study, you will be given feedback and support to enable you to carry out an audit at your own workplace.</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">You will be assessed throughout the course (50%) and you will also need to undertake a workplace audit and submit an audit report for assessment (50%). You will need to gain a 75% pass for this assessment.</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">This course is part of the <a href="http://demo-brcgs.wearesigma.com/training/brcgs-professional/about-the-programme/" target="_blank" rel="noreferrer noopener" style="color: inherit; user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: inherit;">BRCGS Professional recognition programme</a>.&nbsp;</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">At the end of the course, you will:</p><ul style="color: rgb(var(--color_25)); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));"><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Understand the roles and responsibilities of auditors</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Be able to plan and conduct an internal audit</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Know how to write concise, accurate and factual audit reports</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Be able to undertake audit follow-up activities</p></li></ul>

This official BRCGS two-day course will enable you to undertake internal audits and prepare companies for third party audits. It is delivered through a series of workshop-led discussions, presentations and an interactive case study. During the live case study, you will be given feedback and support to enable you to carry out an audit at your own workplace.
You will be assessed throughout the course (50%) and you will also need to undertake a workplace audit and submit an audit report for assessment (50%). You will need to gain a 75% pass for this assessment.
This course is part of the BRCGS Professional recognition programme. 
At the end of the course, you will:
Understand the roles and responsibilities of auditors
Be able to plan and conduct an internal audit
Know how to write concise, accurate and factual audit reports
Be able to undertake audit follow-up activities

Internal Auditing

HACCP

Official BRCGS Product Safety Management course: Internal Auditor
Delivered online (Zoom) by a live BRCGS Approved Training Partner.
Exam and Certificate fee included in the price.

BRCGS Internal Auditor (2 Days)

<div id="isPasted" fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(57, 54, 79); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(57, 54, 79);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Introduction Covers B12 deficiency, pernicious anaemia, diagnosis, treatment and management. It also covers signs and symptoms.</strong></p><div id="isPasted" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Please note: this course is for health care professionals &nbsp;or those working in Primary Care. It is not open to Beauticians unless you are a registered healthcare professional. If in doubt- please&nbsp;email&nbsp;annie at <a href="mailto:training@anniebarr.com" fr-original-style="" style="-webkit-user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">training@anniebarr.com</a>&nbsp;or phone +44 7500048222</strong></p></div></div><div fr-original-style="" style="box-sizing: border-box;"><h2 style="color: rgb(57, 54, 79); box-sizing: border-box;" fr-original-style="color: rgb(57, 54, 79);">About this event</h2><h3 style="color: rgb(30, 10, 60); box-sizing: border-box;" fr-original-style="color: rgb(30, 10, 60);">Course Introduction</h3><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">This course concentrates on B12 deficiency, symptoms, treatments and management.</strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);">The course covers B12 deficiency, pernicious anaemia, diagnosis, treatment and management. It also covers signs and symptoms of &nbsp;pernicious anaemia. &nbsp;This course is interactive and we include case studies and discuss issues regarding diagnostic testing.&nbsp;</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);">We review inclusion and exclusion criteria and identification of appropriate clients. Delegates will get the opportunity to review practice with hands on practical demonstrations of how to give injections correctly. We will cover administration techniques, where to give the injections and record keeping / documentation. We will discuss role and responsibilities and contraindications and precautions. The delegates will leave this course with an example of an individual protocol of Patient Specific Direction (PSD) and a competence based framework document to be used in practice. This course is &nbsp;very interactive.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);">AIMS AND OBJECTIVES</p><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Understand the need for accountability and responsibility in relation to role development</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Demonstrate an understanding of safe practice</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Describe the signs and symptoms of pernicious anaemia</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Describe pernicious anaemia and its impact on patients</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Fully understand the principles, and practice B12 deficiency and B12 injections</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Understand the importance of safety issues related to giving injections</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Understand the law relating to role and function of the HCA and prescribing.</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Describe why patients require B12 injections</p><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Be able to correctly identify anatomical sites for injections</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Demonstrate correct administration techniques</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Demonstrate how to correctly dispose of waste</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Demonstrate correct infection control procedures and use of PPE</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Describe when patients require referral and understand the importance of referral using correct clinical pathways</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Demonstrate an understanding of anaphylaxis and emergency procedures</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Understand the need for correct prescribing procedures</p><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Be able to document consultations following your organisations procedures</p></li></ul></li></ul></li></ul><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);">&nbsp;</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);">&nbsp;</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);">COURSE CONTENTS</p><ul fr-original-style="" style="box-sizing: border-box;"><li style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Role and responsibilities</p></li><li style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Accountability guidelines and requirements</p></li><li style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Pernicious anaemia&nbsp;</p></li><li style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Blood- function</p></li><li style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">B12 &nbsp;Deficiency</p></li><li style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Risk factors/groups</p></li><li style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Causes of B12 deficiency</p></li><li style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Diagnosis and reference ranges, testing</p></li><li style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Protocols and guidelines</p></li><li style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Factors affecting B12 diagnosis and treatment</p></li><li style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Factors affecting absorption</p></li><li style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">B12 injections and common side effects</p></li><li style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Could it be B12 Deficiency</p></li><li style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Supplements</p></li><li style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Side effects and management including ADR&rsquo;s</p></li><li style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Contraindications and Precautions</p></li><li style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Correct Administration and techniques including practical session</p></li><li style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Injection sites</p></li><li style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Legal Issues including consent</p></li><li style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Prescribing and Patient Specific Directions</p></li><li style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">What to record</p></li><li style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Storage</p></li><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Disposal of injections/waste</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Infection control</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Needle stick injuries</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Competence and supervised practice</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Policies and procedures</p></li><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Facts and Figures</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Setting up and running a clinic</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Insurance/indemnity</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Research/evidence base and resources<span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p></li></ul></ul></ul><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Please note Anaphylaxis&nbsp;is not covered on this course, however we do run a separate Anaphylaxis&nbsp;1hr training course, which takes place at the end of this B12 webinar. If you wish to do the 1 hr Anaphylaxis&nbsp;also, you should book onto BOTH courses.</span></div><ul fr-original-style="" style="box-sizing: border-box;"><li style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">WHO SHOULD ATTEND?</p></li><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">HCAs</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Nurses</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Doctors</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Pharmacists</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Anyone interested in Vitamin B12 deficiency and pernicious anaemia and those working with clients with B12 deficiency</p></li></ul></ul><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135);">AB Health Group awards CPD points / certificate of attendance for each course. &nbsp;If you would prefer an accredited certificate by our accrediting body Aim Qualifications we can organise this. &nbsp;The charge for the certificate including postage is &pound;30.</p></div>

Course Introduction Covers B12 deficiency, pernicious anaemia, diagnosis, treatment and management. It also covers signs and symptoms.
Please note: this course is for health care professionals or those working in Primary Care. It is not open to Beauticians unless you are a registered healthcare professional. If in doubt- please email annie at training@anniebarr.com or phone +44 7500048222
About this event
Course Introduction
This course concentrates on B12 deficiency, symptoms, treatments and management.
The course covers B12 deficiency, pernicious anaemia, diagnosis, treatment and management. It also covers signs and symptoms of pernicious anaemia. This course is interactive and we include case studies and discuss issues regarding diagnostic testing. 
We review inclusion and exclusion criteria and identification of appropriate clients. Delegates will get the opportunity to review practice with hands on practical demonstrations of how to give injections correctly. We will cover administration techniques, where to give the injections and record keeping / documentation. We will discuss role and responsibilities and contraindications and precautions. The delegates will leave this course with an example of an individual protocol of Patient Specific Direction (PSD) and a competence based framework document to be used in practice. This course is very interactive.
AIMS AND OBJECTIVES
Understand the need for accountability and responsibility in relation to role development
Demonstrate an understanding of safe practice
Describe the signs and symptoms of pernicious anaemia
Describe pernicious anaemia and its impact on patients
Fully understand the principles, and practice B12 deficiency and B12 injections
Understand the importance of safety issues related to giving injections
Understand the law relating to role and function of the HCA and prescribing.
Describe why patients require B12 injectionsBe able to correctly identify anatomical sites for injectionsDemonstrate correct administration techniquesDemonstrate how to correctly dispose of wasteDemonstrate correct infection control procedures and use of PPEDescribe when patients require referral and understand the importance of referral using correct clinical pathwaysDemonstrate an understanding of anaphylaxis and emergency proceduresUnderstand the need for correct prescribing proceduresBe able to document consultations following your organisations procedures
 
 
COURSE CONTENTS
Role and responsibilities
Accountability guidelines and requirements
Pernicious anaemia
Blood- function
B12 Deficiency
Risk factors/groups
Causes of B12 deficiency
Diagnosis and reference ranges, testing
Protocols and guidelines
Factors affecting B12 diagnosis and treatment
Factors affecting absorption
B12 injections and common side effects
Could it be B12 Deficiency
Supplements
Side effects and management including ADR’s
Contraindications and Precautions
Correct Administration and techniques including practical session
Injection sites
Legal Issues including consent
Prescribing and Patient Specific Directions
What to record
Storage
Disposal of injections/waste
Infection control
Needle stick injuries
Competence and supervised practice
Policies and procedures
Facts and Figures
Setting up and running a clinic
Insurance/indemnity
Research/evidence base and resources
Please note Anaphylaxis is not covered on this course, however we do run a separate Anaphylaxis 1hr training course, which takes place at the end of this B12 webinar. If you wish to do the 1 hr Anaphylaxis also, you should book onto BOTH courses.
WHO SHOULD ATTEND?
HCAs
Nurses
Doctors
Pharmacists
Anyone interested in Vitamin B12 deficiency and pernicious anaemia and those working with clients with B12 deficiency
AB Health Group awards CPD points / certificate of attendance for each course. If you would prefer an accredited certificate by our accrediting body Aim Qualifications we can organise this. The charge for the certificate including postage is £30.

AB Health Group

Health & Wellbeing

General Health

Medical Training

Professional Development

Public Health

B12 and Pernicious Anaemia Training - Webinar

Delegate Admission

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to manage information on their computers.</p>Overview<p>Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation.</p><p>This course is intended for those who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organise, calculate, analyse, revise, update, and present your data.</p></div><div id="course-pills-2"><h4>Getting Started with Excel</h4><ul><li>Navigate the Excel User Interface</li><li>Use Excel Commands</li><li>Create and Save a Basic Workbook</li><li>Enter and Edit Cell Data</li><li>Fill Cells with Series of Data (AutoFill and Flash Fill)</li><li>Use Excel Help</li></ul><h4>Performing Calculations</h4><ul><li>Create Worksheet Formulas</li><li>Insert Functions and use Autocomplete</li><li>Reuse Formulas and Functions</li><li>Create an Absolute Reference</li></ul><h4>Modifying a Worksheet</h4><ul><li>Insert, Delete, and Adjust Cells, Columns, and Rows</li><li>Move and Copy Data between Cells</li><li>Search for and Replace Data</li><li>Use Spellcheck and Proofing</li></ul><h4>Formatting a Worksheet</h4><ul><li>Apply Text Formats</li><li>Apply Number Formats</li><li>Align Cell Contents</li><li>Apply and Copy Cell Styles</li><li>Apply Basic Conditional Formatting</li></ul><h4>Printing Workbooks</h4><ul><li>Preview and Print a Workbook</li><li>Controlling Page Layout</li><li>Adding Headers and Footers</li><li>Set Print Titles and Print Ranges</li></ul><h4>Managing Workbooks</h4><ul><li>Manage Worksheets</li><li>Insert and Delete Worksheets</li><li>Manage Workbook and Worksheet Views</li><li>Manage Workbook Properties</li></ul></div>

Office Skills & Productivity

Office Skills

Excel Analytics

Microsoft Office

Spreadsheet

Excel - Excel Essentials and Formulas

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Definition epilepsy Various types of siezures<strong style="color: rgb(57, 54, 79); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(57, 54, 79);"><br fr-original-style="" style="box-sizing: border-box;"></strong></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">About this event</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Definition epilepsy</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Various types of siezures</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Classification and management of seizures</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Ethical and legal responsibilities</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Recognising triggers and precipitants</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Person centred care</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Documentationa and record keeping</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The impact of rescue medication and anti-epileptic drug therapy</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Buccal Midazolam: what is it, uses in epilepsy, side effects</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Rectal Diazepam: uses in epilepsy, side effects, administration</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Emergency care plan and when to call an ambulance</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Risk assessment/promotion of safeguarding and dignity</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Epilepsy medication demonstration</p>

Caring For Care

Epilepsy Medication Training

<div data-testid="richTextElement" style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(var(--color_15)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_15));"><span style="color: rgb(var(--color_19)); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_19));">Online workshops to raise awareness and help prevent different types of disruptive and unacceptable behaviour, workplace bullying and harassment behaviours as well as understanding the impact on health and performance.</span></p></div><div data-testid="richTextElement" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><ul style="color: rgb(var(--color_13)); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_13));"><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_15)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_15));"><span style="color: rgb(var(--color_13)); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_13));">Definitions of bullying, cyberbullying and harassment</span></p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_15)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_15));"><span style="color: rgb(var(--color_13)); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_13));">Overview of current legislation</span></p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_15)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_15));"><span style="color: rgb(var(--color_13)); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_13));">Different forms and behaviours that bullying can take in the workplace</span></p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_15)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_15));"><span style="color: rgb(var(--color_13)); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_13));">Remote working: what makes cyberbullying different?</span></p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_15)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_15));"><span style="color: rgb(var(--color_13)); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_13));">The bullying relationship &ndash; what makes someone bully?</span></p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_15)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_15));"><span style="color: rgb(var(--color_13)); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_13));">Professional, personal and emotional impact of being bullied in the workplace</span></p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_15)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_15));"><span style="color: rgb(var(--color_13)); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_13));">Being an Active Upstander</span></p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_15)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_15));"><span style="color: rgb(var(--color_13)); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_13));">Current best practice for organisations</span></p></li></ul></div>

The definitive guide to workplace bullying & harassment delivered by UK's leading expert. Take a deep dive into the subject - the facts, the experiences, the reasons, and the damage to individuals and businesses.
This online workshop raises awareness and helps you and your teams prevent different types of disruptive and unacceptable bullying and harassment behaviours as well as understanding the impact on health and performance.
Definitions of bullying, cyberbullying and harassment
Overview of current legislation and the preventative duty
Different forms and behaviours that bullying can take in the workplace
Remote working: what makes cyberbullying different?
The bullying relationship – what makes someone bully?
Professional, personal and emotional impact of being bullied in the workplace
Being an Active Upstander
Current best practice for organisations

Conduct Change Ltd

Conflict Resolution

Cultural Awareness

Sexual Harassment

Behaviour Change

Emotional Wellbeing

Harassment

Anti Bullying

UNDERSTANDING WORKPLACE BULLYING AND HARASSMENT
The definitive guide to workplace bullying & harassment delivered by UK's leading expert.

28014 Courses delivered Online

UK Pension and Employment Law - Double Endorsed Certificate

By Imperial Academy

Pension UK and Insurance Broker - Double Endorsed Certificate

By Imperial Academy

Stock Market Investing & Trading - Level 2

By Apex Learning

Business Analysis Course - BCS Foundation

By Duco Digital Training

Professional Certificate Course in Marketing Analytics and Its Importance in Hotel Industry in London 2024

By Metropolitan School of Business & Management UK