Name: Diploma in Creative Graphic Design - QLS Endorsed (Level 5)
Price: 12 GBP
Availability: InStock

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><b data-stringify-type="bold" fr-original-style=" color: rgb(209, 210, 211);" style="color: rgb(209, 210, 211); box-sizing: border-box;" id="isPasted"><span fr-original-style="color: rgb(0, 0, 0);" style="color: rgb(0, 0, 0); box-sizing: border-box;">Welcome to Organic Cosmetics Formulation: Natural Beauty Guide. In this course, you&#39;ll learn:</span></b></p><ol style="color: rgb(209, 213, 219); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(209, 213, 219);"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong style="color: var(--tw-prose-bold); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: var(--tw-prose-bold);">Introduction to Organic Cosmetics Formulation:</strong></p><ul style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Explore the fundamentals of organic cosmetics, understanding the principles of formulation and the significance of choosing natural ingredients.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Gain insights into the evolving landscape of organic beauty and the global demand for sustainable and eco-friendly cosmetic solutions.</li></ul></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong style="color: var(--tw-prose-bold); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: var(--tw-prose-bold);">Skin Science:</strong></p><ul style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Delve into the science behind skincare, understanding skin types, concerns, and the physiological processes that influence cosmetic formulation.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Learn how to tailor organic cosmetics to individual skin needs, promoting healthy and vibrant skin.</li></ul></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong style="color: var(--tw-prose-bold); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: var(--tw-prose-bold);">Natural Ingredients in Organic Cosmetics:</strong></p><ul style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Discover a wide array of natural ingredients, exploring their properties, benefits, and synergies in cosmetic formulations.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Master the art of ingredient selection to create effective and nourishing products.</li></ul></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong style="color: var(--tw-prose-bold); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: var(--tw-prose-bold);">Organic Facial Skincare Products:</strong></p><ul style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Dive into the formulation of facial skincare products such as cleansers, toners, serums, and moisturizers using organic ingredients.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Understand the specific requirements for facial care and design products that promote skin health and radiance.</li></ul></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong style="color: var(--tw-prose-bold); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: var(--tw-prose-bold);">Organic Body Care Products:</strong></p><ul style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Learn to formulate body lotions, scrubs, and oils using organic ingredients that nourish and rejuvenate the skin.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Explore the unique challenges and opportunities in creating organic body care products.</li></ul></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong style="color: var(--tw-prose-bold); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: var(--tw-prose-bold);">Organic Hair Care Products:</strong></p><ul style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Explore the world of organic hair care, formulating shampoos, conditioners, and treatments that enhance hair health and natural beauty.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Understand the diverse needs of different hair types and how to address them organically.</li></ul></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong style="color: var(--tw-prose-bold); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: var(--tw-prose-bold);">Organic Makeup Products:</strong></p><ul style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Uncover the secrets of formulating organic makeup, including foundations, lipsticks, and eyeshadows.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Embrace the art of creating vibrant and long-lasting makeup without compromising on organic and natural principles.</li></ul></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong style="color: var(--tw-prose-bold); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: var(--tw-prose-bold);">Preservation and Stability of Organic Cosmetics:</strong></p><ul style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Learn essential techniques for preserving and stabilizing organic cosmetic formulations without compromising their integrity.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Understand the role of natural preservatives and antioxidants in maintaining product quality.</li></ul></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong style="color: var(--tw-prose-bold); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: var(--tw-prose-bold);">Quality Control and Safety Assessment:</strong></p><ul style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Master the processes of quality control and safety assessment to ensure the highest standards in your organic cosmetic formulations.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Explore testing methods and regulatory considerations in the organic cosmetics industry.</li></ul></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong style="color: var(--tw-prose-bold); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: var(--tw-prose-bold);">Advanced Organic Cosmetics Formulation:</strong></p><ul style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Elevate your skills with advanced formulation techniques, incorporating cutting-edge natural ingredients for innovative cosmetic solutions.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Explore custom formulations to address specific beauty concerns and trends.</li></ul></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong style="color: var(--tw-prose-bold); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: var(--tw-prose-bold);">Marketing and Branding Organic Cosmetics:</strong></p><ul style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Develop a strategic approach to marketing and branding your organic cosmetics, aligning with ethical and sustainable values.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Learn effective communication strategies to reach and engage environmentally conscious consumers.</li></ul></li></ol>

John Academy

Unlock the secrets of radiant beauty with our 'Organic Cosmetics Formulation: Natural Beauty Guide' course. Dive into the science of skincare, master the art of using natural ingredients, and learn to formulate organic facial, body, and hair care products, as well as makeup. Explore preservation techniques, ensure quality control, and discover the world of sustainable branding. Elevate your skills in the ever-evolving realm of organic beauty with our comprehensive and innovative program.

Organic Cosmetics Formulation: Natural Beauty Guide

General Admission

<p><strong></strong><strong> Our Aim Is Your Satisfaction! Offer Ends Soon; Hurry Up!! </strong><strong></strong></p><p><strong>Are you trying to make yourself ready for a place in the field of law? Finding it hard to learn UK Laws and regulations?</strong> If you're interested in working in a structured environment and building your career in a sector that is expected to grow faster than average in the next several years, this Law &amp; Paralegalcourse may become a great option for you. Earn yourself a certificate online around work and family commitments, at your own pace considering your schedules. <strong>Enrol this </strong>Law &amp; Paralegal course today to boost your skills and move on to the next level.</p><p><strong>This Diploma in Law &amp; Paralegal at QLS Level 6 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 150 CPD points) to make your skill development &amp; career progression more accessible than ever!</strong></p><p>It is said that behind every successful attorney, there is a hard-working paralegal. Our Law &amp; Paralegal diploma training is designed to prepare you to perform substantive and procedural legal work as authorised by law. The Law &amp; Paralegal course defines the steps to make you prepare to perform the duties and responsibilities to work as a paralegal lawyer, this includes - legal research and presentations, scheduling and conducting client interviews, drafting legal documents and performing day to day tasks at law office administration. Furthermore, the course gives you an in-depth overview of the law and legal systems, criminal, property, probate and contract law. Throughout this Law &amp; Paralegal course, you will also demonstrate the ethical values and views of a paralegal lawyer to deal with conflict and resolutions as well.</p><p>This Law &amp; Paralegal course will help you to make a mark for yourself in the competitive job market. This certificate will also help you to create an impression of self-efficacy and dedication that will surely attract prospective employers to give priority to your job application. Enrol today to open and build enchanting career opportunities ahead.</p><p><strong>What will I learn from this Law &amp; Paralegal Course?</strong></p><ul><li>Key Paralegal terminologies</li><li>Effective communication skills for a Paralegal</li><li>Knowledge of the laws and legal systems</li><li>Knowledge of a range of different laws including criminal, property, probate, and contract law</li><li>How to deal with common Paralegal legal matters</li><li>A greater understanding of human rights</li><li>How to deal with conflict and conflict resolution as a Paralegal</li><li>Mandatory knowledge fields and survival tips for Paralegals</li><li>The key people in a law firm or legal department and their relationship with paralegals</li></ul> <p>Take a step toward a brighter future!</p><p><strong>Why Prefer this Law &amp; Paralegal Course?</strong></p><ul><li>Opportunity to earn certificate a certificate endorsed by<strong> the Quality Licence Scheme</strong> &amp; another certificate which is accredited by<strong> CPDQS.</strong></li><li>Get a <strong>free student ID </strong>card! (£10 postal charge will be applicable for international delivery).</li><li>Innovative and engaging content.</li><li>Free assessments.</li><li>24/7 tutor support.</li></ul><p><strong>*** Course Curriculum ***</strong></p><p>Here are the topics you will cover in the <strong>Law &amp; Paralegal </strong>Course:</p><ul><li>Module 01: Understanding the Concept of Paralegal</li><li>Module 02: Key Legal Terminology</li><li>Module 03: Effective Communication Skills for Paralegals</li><li>Module 04: The Legal Workplace &amp; Professionals</li><li>Module 05: Law &amp; Legal Systems</li><li>Module 06: Contract &amp; Business Law</li><li>Module 07: Property Law</li><li>Module 08: Wills, Probate, Estate Law</li><li>Module 09: Criminal Law</li><li>Module 10: Common Paralegal Legal Matters</li><li>Module 11: Human Rights</li><li>Module 12: Conflict and Conflict Resolution</li><li>Module 13: Professional Conduct and Ethics of Paralegals</li><li>Module 14: Mandatory Knowledge Fields and Survival Tips for Paralegals</li></ul><p><strong>Assessment Process</strong></p><p>After completing an online module, you will be given immediate access to a specially designed MCQ test. The results will be immediately analyzed, and the score will be shown for your review. The passing score for each test will be set at 60%.</p><p>After passing the <strong>Diploma in Law &amp; Paralegal at QLS Level 6 course </strong> exam, you will be able to request a certificate at an additional cost that has been endorsed by the Quality Licence Scheme.</p> <h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        150 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>This course is specially designed for people who want to specialise in a certain type of law to work in a corporate setting as legal business advisors. Moreover, people already working in the relevant field can also enrol on this course to advance their knowledge and skill set. Besides, this <strong>Law &amp; Paralegal </strong>course can be taken by anyone of all academic backgrounds.</p>
                        </div> <h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>You will not need any prior background or expertise to enrol in this course.</p>
                        </div> <h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <ul><li>Legal Staffing Recruiter</li><li>Development and Training Manager</li><li>Pro Bono Program Coordinator</li><li>Project Manager for Legal Support Vendor</li><li>Business Development/Sales for legal support vendor</li><li>Legislative Affairs Director for a county government agency</li></ul>
                        </div> <h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>CPDQS Accredited Certificate</h4>
        <p>
            Digital certificate -
            £10
        </p>
        <h4>Diploma in Law &amp; Paralegal at QLS Level 6</h4>
        <p>
            Hard copy certificate -
            £129
        </p>
            <div> <p><strong>Show off Your New Skills with a Certificate of Completion</strong></p><p>After successfully completing the <strong>Diploma in Law &amp; Paralegal at QLS Level 6</strong>course, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of -</p><ul><li><strong>129 GBP inside the UK</strong></li><li><strong>139 GBP (including postal fees) for international delivery</strong></li></ul><p><strong>CPDQS Accredited Certificate</strong></p><ul><li><strong>29 GBP</strong> for Printed Hardcopy Certificate inside the UK</li><li><strong>39 GBP</strong> for Printed Hardcopy Certificate outside the UK (international delivery)</li></ul> </div>

                        </div>

Academy for Health and Fitness

Law & Paralegal Diploma

<p><strong>24 Hours Left! Don't Let the Winter Deals Slip Away - Enrol Now!</strong></p><p>Are you interested in a field that is rewarding and helps people excel in their day to day lives? Would you like to know what anatomy is and how the human body works? Are you searching for a way to break into the healthcare field? If so, then the Sports Therapy course can help you develop skills and knowledge to drive your career forward and open doors to enchanting opportunities ahead!</p><p><strong>This Diploma in Sports Therapy at QLS Level 5 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 180 CPD points) to make your skill development &amp; career progression more accessible than ever!</strong></p><p>Sports therapy aims to help regain and restore the pain-free and comfortable movement and overall health experienced before an injury, illness or disability. Through this sports therapy course, you will demonstrate an understanding of the types, anatomy, and causes of athletic injuries, as this course is all about preventing and recovering athletic injuries for athletes and individuals. In addition, this sports therapy course incorporates the sports therapist's roles, responsibilities, and ethical values.</p><p>This course can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence!</p><p><strong>What will I learn from this course?</strong></p><ul><li>An overview of athletic injuries</li><li>Anatomy of athletic injuries</li><li>Professionalism and ethics of sports therapy</li><li>Gain an understanding of the anatomy and kinesiology relevant to sports therapy</li><li>How to assess athletic injuries</li><li>Understand the common and major Athletic injuries</li><li>First aid treatments essential to athletic injuries</li><li>Rehabilitation exercise to recover from injury</li><li>Various athletic massage treatments</li><li>Fundamentals of hydrotherapy &amp; electrotherapy</li></ul><p><strong>Why Prefer Us for Your Sports Therapy Training?</strong></p><ul><li>Opportunity to earn a certificate endorsed by <strong>the Quality Licence Scheme</strong> and another certificate accredited by <strong>CPDQS.</strong></li><li>Get instant access to this <strong>Sports therapy</strong> course.</li><li>Learn from anywhere in the world</li><li>This course is simple to understand</li><li><strong>Sports therapy training</strong> is entirely online, interactive lesson with voiceover audio</li><li>Get Lifetime access to the <strong>Sports therapy</strong> course materials</li><li><strong>Sports therapy </strong>comes with 24/7 tutor support</li></ul> <p>Take a step toward a brighter future with <strong>Sports Therapy Training</strong></p><p><strong>*** Course Curriculum of Sports Therapy Training***</strong></p><ul><li>Module 1: Introduction <strong>Sports Therapy</strong></li><li>Module 2: Professionalism and Ethics</li><li>Module 3: Anatomy &amp; Kinesiology</li><li>Module 4: Assessment of Athletics Injuries</li><li>Module 5: Athletics Injuries Depend on Sport Profile</li><li>Module 6: Common Athletics Injuries</li><li>Module 7: Major Athletics Injury</li><li>Module 8: First Aid Treatment</li><li>Module 9: Sports Nutrition</li><li>Module 10: Rehabilitation Exercise</li><li>Module 11: Athletics Massage Treatments</li><li>Module 12: Hydrotherapy &amp; Electrotherapy</li></ul><p><strong>Assessment Process of Sports Therapy Training</strong></p><p>You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment.</p><p>After passing the <strong>Diploma in Sports Therapy at QLS Level 5 </strong>exam, you will be able to request a certificate with additional cost that has been endorsed by the Quality Licence Scheme.</p> <h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        180 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>This Sports Therapy Training course is ideal for those who wish to train in the prevention, assessment, treatment, and rehabilitation of sporting injuries. This course is open to everyone of any academic background.</p><p>To get a professional qualification, you can enrol the following:</p><ul><li>Level 3 Diploma in Massage Therapy for Sports (RQF)</li><li>Level 3 Diploma in Sports Massage Therapy (RQF)</li><li>Level 4 Certificate in Massage Therapy for Sports (RQF)</li><li>Level 4 Certificate in Sports Massage Therapy (RQF)</li><li>Level 4 Diploma in Massage Therapy for Sports (RQF)</li><li>Level 3 NVQ Diploma in Level 3 Certificate in Sports Massage Therapy (RQF)</li></ul><p><strong>Disclaimer: </strong></p><p>Kindly be informed that completing this online course does not grant you the authority to practice as a Licensed Therapist. If you are searching for a course that fulfils the HCPC's standards, please contact the HCPC or the RCSLT.</p>
                        </div> <h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>You will not need any prior background or expertise to enrol in this course.</p>
                        </div> <h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Enrolling on this <strong>Sports Therapy Training </strong>course can lead you towards the following career paths:</p><ul><li>Athletic Massage Therapist</li><li>Rehabilitation Therapist</li><li>Sports Therapist</li><li>Spa Massage Therapist</li><li>Associate Athletic Massage Therapists</li></ul><p>And many more!</p>
                        </div> <h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>CPDQS Accredited Certificate</h4>
        <p>
            Digital certificate -
            £10
        </p>
        <h4>Diploma in Sports Therapy at QLS Level 5</h4>
        <p>
            Hard copy certificate -
            £119
        </p>
            <div> <p><strong>Show off Your New Skills with a Certificate of Completion</strong></p><p>After successfully completing the<strong> Diploma in Sports Therapy at QLS Level 5</strong>, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of -</p><ul><li><strong>119 GBP inside the UK</strong></li><li><strong>129 GBP (including postal fees) for international delivery</strong></li></ul><p><strong>CPDQS Accredited Certificate</strong></p><ul><li><strong>29 GBP</strong> for Printed Hardcopy Certificate inside the UK</li><li><strong>39 GBP</strong> for Printed Hardcopy Certificate outside the UK (international delivery)</li></ul> </div>

                        </div>

Sports Therapy: Sports Massage, Sports First Aid & Sports Nutrition Diploma

<p><strong>48-Hour Knowledge Knockdown! Prices Reduced Like Never Before!</strong></p><p><strong></strong><strong> Our Aim Is Your Satisfaction! Offer Ends Soon; Hurry Up!! </strong><strong></strong></p><p>Are you looking to improve your current abilities or make a career move? Our unique English Law course might help you get there! Expand your expertise with high-quality training - study the English Law course and get an expertly designed, great-value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the English Law online training course.</p><p><strong>This </strong><strong>Diploma in English Law at QLS Level 5</strong><strong> course is endorsed by The Quality Licence Scheme and accredited by CPDQS</strong><strong> (with 150 CPD points</strong><strong>) </strong><strong>to make your skill development &amp; career progression more accessible than ever!</strong></p><p>The English Law course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the English Law course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this course.</p><p>This English Law training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence!</p><p><strong>Why Prefer This English Law Course?</strong></p><ul><li>Opportunity to earn certificate a certificate endorsed by <strong>the Quality Licence Scheme</strong> &amp; another accredited by <strong>CPDQS </strong>after completing the English Law course</li><li>Get a <strong>free student ID card!</strong> (£10 postal charge will be applicable for international delivery)</li><li>Innovative and engaging content.</li><li>Free assessments</li><li>24/7 tutor support.</li></ul> <p>Take a step toward a brighter future!</p><p><strong>*** Course Curriculum ***</strong></p><p>Here are the topics you will cover in the Diploma in English Law:</p><p><strong>Module 01: Understanding the Concept of Paralegal</strong></p><ul><li>Who Is a Paralegal?</li><li>Who Can Become a Paralegal?</li></ul><p><strong>Module 02: Key Legal Terminology</strong></p><ul><li>Alternative Dispute Resolution (ADR)</li><li>Bill</li><li>Bilateral NDA</li></ul><p><strong>Module 03: Effective Communication Skills for Paralegals</strong></p><ul><li>Importance of Good Communication</li><li>Modes of Communication</li></ul><p><strong>Module 04: The Legal Workplace &amp; Professionals</strong></p><ul><li>Professional roles within the legal sector</li><li>Key People within the Legal Sector</li></ul><p><strong>Module 05: Law &amp; Legal Systems</strong></p><ul><li>The UK legal system</li><li>How laws are Made</li></ul><p><strong>Module 06: Contract &amp; Business Law</strong></p><ul><li>Contract Section</li><li>What is a Contract?</li></ul><p><strong>Module 07: Property Law</strong></p><ul><li>What is Property Law?</li><li>Property Law Acts</li></ul><p><strong>Module 08: Wills, Probate, Estate Law</strong></p><ul><li>Estates</li><li>Wills</li><li>Probate</li><li>Trusts</li></ul><p><strong>Module 09: Criminal Law</strong></p><ul><li>Criminal Law</li><li>Tort Law</li></ul><p><strong>Module 10: Common Paralegal Legal Matters</strong></p><ul><li>Family Law</li><li>Civil Proceedings</li><li>Bankruptcy</li><li>Insurance</li></ul><p><strong>Module 11: Human Rights</strong></p><ul><li>What are Human Rights?</li><li>Characteristics of Human Rights</li></ul><p><strong>Module 12: Conflict and Conflict Resolution</strong></p><ul><li>Introduction to Conflict &amp; Conflict Management</li><li>Types of Conflict</li><li>Levels of Conflict</li><li>Stages of Conflict</li><li>Conflict Management Styles</li></ul><p><strong>Module 13: Professional Conduct and Ethics of Paralegals</strong></p><ul><li>Confidentiality</li><li>Confidentiality limitations</li><li>Ethical Issues</li><li>Values</li></ul><p><strong>Module 14: Mandatory Knowledge Fields and Survival Tips for Paralegals</strong></p><ul><li>Things Every Paralegal Should Know</li><li>Survival Tips to Thrive in the Legal Environment</li></ul><p><strong>Assessment Process</strong></p><p>After completing an online course module, you will be given immediate access to a specially designed MCQ test. The results will be immediately analysed, and the score will be shown for your review. The passing score for each test will be set at 60%.</p><p>After passing the <strong>Diploma in English Law at QLS Level 5 </strong>exam, you will be able to request a certificate at an additional cost that has been endorsed by the Quality Licence Scheme.</p> <h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        150 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><strong>This Diploma in English Law is for you if you:</strong></p><ul><li>Want to have a deeper insight into English Law</li><li>Actively working in English Law and am interested in exploring it a bit further.</li><li>Are you a student pursuing a relevant field of study?</li><li>Seeking employment in the English Law field.</li></ul>
                        </div> <h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p><strong>Diploma in English Law </strong></p><p>You will not need any prior background or expertise to enrol in this Diploma in English Law.</p>
                        </div> <h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>After completing this Diploma in English Law, you are to start your career or begin the next phase of your career.</p>
                        </div> <h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            £10
        </p>
        <h4>Diploma in English Law at QLS Level 5</h4>
        <p>
            Hard copy certificate -
            £119
        </p>
            <div> <p><strong>Show off Your New Skills with a Certificate of Completion</strong></p><p>After successfully completing the <strong>Diploma in English Law at QLS Level 5</strong>, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of -</p><ul><li><strong>119 GBP inside the UK</strong></li><li><strong>129 GBP (including postal fees) for International Delivery</strong></li></ul><p><strong>Certificate Accredited by CPDQS</strong></p><ul><li><strong>29 GBP for Printed Hardcopy Certificate inside the UK</strong></li><li><strong>39 GBP for Printed Hardcopy Certificate outside the UK (International Delivery)</strong></li></ul> </div>

                        </div>

Diploma in English Law

<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div>
			<div></div>
		</div>
				</div>
				</div>
				<div>
				<div>
			
				</div>
				<div>
				<div>
					<div><p>Step into our cool Scrum Master course! It's a journey into the world of Agile and Scrum. You'll start from the beginning and become an expert.</p><p>You'll start by learning about old development models and how Agile improved them. You'll get to know all about Scrum, like the team, events, and artifacts, and how to make Scrum work in big groups. With real-life examples, you'll see Scrum in action, making it easier to understand.</p><p>Then, you'll learn about advanced topics like Agile requirements, how to estimate work, and Agile metrics. If you want to pass the PSM1 exam, there's a part of the course just for you, with handy tips and tricks.</p><p>Our course is the perfect way to learn about Agile and Scrum. You'll start from the basics and work your way up to advanced topics. We'll even give you some tips on how to pass the PSM1 exam.</p><p>There will be tests throughout the course to check your progress, and when you finish, you'll get your special Scrum Master certificate. Join our Scrum Master course today and become an Agile and Scrum whizz!</p></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</div></section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2><b> Learning outcome</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Learn how development models changed to Agile.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Know Scrum, its teams, events, and artifacts.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Learn how to make Scrum work in big teams.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Understand Agile needs, how to estimate work, and metrics.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Get a special Scrum Master certificate.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					</div>
				</div>
				<div>
				<div>
					
			</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> <b>Why should I take this course?</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Become a pro at Agile and Scrum.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Get more job chances in the Agile Scrum field.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Boost your skills in managing projects.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Get ready for the PSM1 exam.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Learn how to use Scrum in real life.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> <b>Career Path</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Scrum Master</span>
									</li>
								<li>
											<span>
													</span>
										<span>Agile Coach</span>
									</li>
								<li>
											<span>
													</span>
										<span>Product Owner</span>
									</li>
								<li>
											<span>
													</span>
										<span>Agile Project Manager</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> <b>Requirements</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>No formal qualifications required, anyone from any academic background can take this course.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Access to any internet-enabled smart device.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section><div>
                            <div>
                                <h2>Course Curriculum</h2>
                            </div>
                            			<div>
				

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4"><strong>OBJECTIVES AND TARGETS </strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Objectives and Targets</td><td><span>🕐 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Download: course curriculum in pdf</td><td><span>🕐 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>FROM THE TRADITIONAL DEVELOPMENT MODEL TO THE AGILE</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Waterfall. Typical challenges</td><td><span>🕐 00:05:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Agile history and 2001's Manifesto</td><td><span>🕐 00:11:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Agile. A different approach</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Agile benefits</td><td><span>🕐 00:02:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>When agile is best applied + success factors</td><td><span>🕐 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Download: Agile Vs Waterfall. Overview diagram</td><td><span>🕐 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Download: Agile Vs Waterfall side by side by project stage</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>2020 SCRUM GUIDE: WHAT'S NEW!</strong></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>2020 SCRUM GUIDE: WHAT'S NEW!</td><td><span>🕐 00:22:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>BONUS: FULL EBOOK OF THE COURSE!</strong></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>BONUS -  Full eBOOK of the Course</td><td><span>🕐 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>SCRUM</strong></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Download: the Scrum Guide</td><td><span>🕐 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Download: the Scrum Glossary</td><td><span>🕐 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Download: Framework Navigator</td><td><span>🕐 00:01:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Scrum introduction</td><td><span>🕐 00:12:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Theory and values</td><td><span>🕐 00:08:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>THE SCRUM TEAM</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>The Scrum Team - Introduction</td><td><span>🕐 00:08:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Product, Product Goal and Product Owner</td><td><span>🕐 00:14:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Developers</td><td><span>🕐 00:03:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>The scrum master</td><td><span>🕐 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Characteristics of a perfect scrum master</td><td><span>🕐 00:23:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>SCRUM EVENTS</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Introduction</td><td><span>🕐 00:03:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>The Sprint</td><td><span>🕐 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Download: Diagram of a typical Sprint (with events, roles, artifacts)</td><td><span>🕐 00:01:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>The sprint planning</td><td><span>🕐 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>The daily scrum</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>The sprint review</td><td><span>🕐 00:06:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>The sprint retrospective</td><td><span>🕐 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>SCRUM ARTIFACTS</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Product backlog</td><td><span>🕐 00:08:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Sprint backlog</td><td><span>🕐 00:02:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Increment and definition of done</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Commitments</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>SCALING SCRUM</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Introduction</td><td><span>🕐 00:02:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Scrum of scrums</td><td><span>🕐 00:02:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Nexus framework</td><td><span>🕐 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Download: the Nexus Framework poster</td><td><span>🕐 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>SCRUM IN PRACTICE !</strong></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>A day in the life of a typical Sprint</td><td><span>🕐 00:32:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>AGILE REQUIREMENTS</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Products, Initiatives, Epics, Features, Stories and Tasks</td><td><span>🕐 00:11:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>ESTIMATION TECHNIQUES</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Underlying theory, t-shirt sizing, planning poker</td><td><span>🕐 00:09:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Bucket system, affinity mapping, time unit</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>AGILE METRICS</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Underlying theory. Velocity</td><td><span>🕐 00:07:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Sprint burn-down</td><td><span>🕐 00:08:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Release burn-up, cumulative flow, other metrics</td><td><span>🕐 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>PSM1 CERTIFICATION PREPARATION GUIDELINES, TIPS &amp; TRICKS</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>How to best prepare for PSM I Certification</td><td><span>🕐 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>PSM1 CERTIFICATION PREPARATION GUIDELINES, TIPS &amp; TRICKS</strong></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>PSM I EXAM SIMULATOR #1 and #2 (80+80 HIGH QUALITY QUESTIONS. REAL MODE)</td><td><span>🕐 00:01:00</span></td>
				</tr>
				</tbody></table></div>

			</div>
		                        </div>

Skill Up

Certified ScrumMaster (CSM)

Certified SAFe Agilist

ACP (Agile Certified Practitioner)

Scrum

Scrum Master Professional Certificate (SMPC)

Professional Scrum Master (PSM)

Are you looking for a challenging and rewarding career? Becoming a pro Scrum Master is a great option. Our course will teach you everything you need to know to get started. Sign up today!

Scrum Master CPD Accredited certification with Agile

<div>
						<div>
				<div>
									<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
								<div>
				<p><span>Register on the Neuro-linguistic Programming (NLP) Diploma today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career.</span></p>
<p><span>The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials.</span></p>
<p><span>Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion.</span></p>
<p><span>The Neuro-linguistic Programming (NLP) Diploma is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones.</span></p>
<p><span>The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly!</span></p>
<h5><b>What You Get With The Neuro-linguistic Programming (NLP) Diploma</b></h5>
<ul>
<li><span>Receive a e-certificate upon successful completion of the course</span></li>
<li><span>Get taught by experienced, professional instructors</span></li>
<li><span>Study at a time and pace that suits your learning style</span></li>
<li><span>Get instant feedback on assessments </span></li>
<li><span>24/7 help and advice via email or live chat</span></li>
<li><span>Get full tutor support on weekdays (Monday to Friday)</span></li>
</ul>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					<div>
							
					<div></div>
											<div></div>
														
							
					<div></div>
											<div></div>
														
							
					<div></div>
											<div></div>
														
							
					<div></div>
											<div></div>
														
					</div>
			</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Course Design</h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<div id="course-home"><div><p><span>The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.</span></p><p><span>You are taught through a combination of</span></p><ul><li><span>Video lessons</span></li><li><span>Online study materials</span></li></ul></div></div>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Certification</h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<p><span>Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who Is This Course For:</h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<p><span>The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge.</span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Requirements:</h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<p><span>The online training is open to all students and has no formal entry requirements. To study the Neuro-linguistic Programming (NLP) Diploma, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. </span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
									</div>
			</div>
					</div><div>
				<h3>Course Content</h3>

<div id="course_curriculum">
<table width="100%">				<tbody><tr>
					<td colspan="4">Module 01</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>NLP Lesson 1 - Introduction, Cause and Effect</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>NLP Lesson 2 - The Map is Not the Territory</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>NLP Lesson 3 - Sensory Acuity</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>NLP Lesson 4 - Rapport</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>NLP Lesson 5 - Representational Systems</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>NLP Lesson 6 - Anchoring</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>NLP Lesson 7 - State Elicitation66</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>NLP Lesson 8 - Language Patterns</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>NLP Lesson 9 - Language Patterns 2</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>NLP Lesson 10 - Chunking</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 02</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>NLP Lesson 11 - Frames &amp; Reframing</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>NLP Lesson 12 - Reframing</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>NLP Lesson 13 - Strategies</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>NLP Lesson 14 - Meta Programs55</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>NLP Lesson 15 - Timelines</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>NLP Lesson 16 - Values</td>
					<td> </td>
					<td><span><i></i> 00:17:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>NLP Lesson 17 - Goalsetting55</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>NLP Lesson 18 - Goalsetting 2cc</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>NLP Lesson 19 - Models _ Applications66</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>NLP Lesson 20 - Satir Categories55</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>NLP Lesson 21 - Emotional Intelligence</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
				</tbody></table></div>

			</div>
			<h2>Frequently Asked Questions</h2>
                        <div>
                            <div>
                                <span>
                                    Are there any prerequisites for taking the course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        There are no specific prerequisites for this course, nor
                                        are there any formal entry requirements. All you need is
                                        an internet connection, a good understanding of English
                                        and a passion for learning for this course.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    Can I access the course at any time, or is there a set
                                    schedule?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        You have the flexibility to access the course at any time
                                        that suits your schedule. Our courses are self-paced,
                                        allowing you to study at your own pace and convenience.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    How long will I have access to the course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        For this course, you will have access to the course
                                        materials for 1 year only. This means you can review the
                                        content as often as you like within the year, even after
                                        you've completed the course. However, if you buy Lifetime
                                        Access for the course, you will be able to access the
                                        course for a lifetime.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    Is there a certificate of completion provided after
                                    completing the course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        Yes, upon successfully completing the course, you will
                                        receive a certificate of completion. This certificate can
                                        be a valuable addition to your professional portfolio and
                                        can be shared on your various social networks.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    Can I switch courses or get a refund if I'm not satisfied
                                    with the course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        We want you to have a positive learning experience. If
                                        you're not satisfied with the course, you can request a
                                        course transfer or refund within 14 days of the initial
                                        purchase.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    How do I track my progress in the course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        Our platform provides tracking tools and progress
                                        indicators for each course. You can monitor your progress,
                                        completed lessons, and assessments through your learner
                                        dashboard for the course.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    What if I have technical issues or difficulties with the
                                    course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        If you encounter technical issues or content-related
                                        difficulties with the course, our support team is
                                        available to assist you. You can reach out to them for
                                        prompt resolution.
                                    </p>
                                </div>
                            </div>
                        </div>

Janets

Learning & Development

Online Course Creation

Managed Learning Programme (MLP)

Neuro-Linguistic Programming (NLP)

NLP Practitioner

Professional Skills Course (PSC)

Neuro-linguistic Programming (NLP) Diploma

<strong>Increase your Excel and Pivot Table skills and knowledge within hours which will get you noticed by top management and prospective employers. Become more productive at using Excel which will save you hours each day and eliminate stress at work.

This course helps you learn about Pivot Tables that can be used for data analysis with a proper approach.</strong>
        <p>We need to analyze data these days since we live in a very data-driven world. Therefore, data is important in any business, whether you are looking for trends or forecasting future business needs. As there is a lot of importance placed on data analysis, you must have the relevant skills to analyze data effectively.

Pivot Tables is an essential Excel skill for jobs that involve analyzing and visualizing large amounts of data. Pivot Tables are an interactive way of quickly summarizing large amounts of data by grouping and aggregating data sets and analyzing data clearly and effectively.

This course will discuss the importance of cleaning your data before creating your first Pivot Table. You'll also learn how to create Pivot Charts and how to format your Pivot Tables and Charts. This course includes downloadable Excel data files that the instructor uses in the guide to follow along.

By the end of this course, you'll learn the skills required to be able to clean the data, put it in the Pivot Table, analyse the data efficiently, and keep it updated with a single click.

Therefore, by opting for this course, you'll be able to take your own information and leverage Pivot Tables to answer questions with ease.

All the resource files are uploaded on the GitHub repository at https://github.com/PacktPublishing/Microsoft-Excel-A-Beginners-Guide-to-Pivot-Tables-in-Excel</p>
        <h2>What You Will Learn</h2><p>Learn basics of Pivot Tables and Charts<br>Clean and prepare your data<br>Create a basic Excel Pivot Table and format numbers in it<br>Use multiple fields and dimension, and methods of aggregation<br>Create Pivot Charts based on Pivot Table data<br>Add new data to the original source dataset, and update Pivot Tables and Charts</p>
        <h2>Audience</h2><p>This course is for anyone who works with Microsoft Excel even if you've never used data analytics, Pivot Table and Pivot Charts. This course is aimed at people who have never used Pivot Tables before and would like to get started. It is also helpful for those who understand Pivot Tables but would like to expand their Excel skills.<br><br>Individuals with basic knowledge of Excel 2019/365 and those upgrading from previous software versions will also be benefitted from this course.<br><br>Knowledge of MS Excel is useful but not mandatory.</p>
        <h2>Approach</h2><p>This is an exhaustive course with easy-to-follow and step-by-step instructions, exercises, and demo files. This course is divided into clear chunks so you can learn at your own pace and focus on your own area of interest.<br><br>The course contains real-world examples that provide the building blocks to create engaging dashboards. Get your data, open up Excel, and go!</p>
        <h2>Key Features</h2><p>Learn from a well-designed curriculum by Microsoft Excel expert in no time with this concise course * Discover Pivot Table and Pivot Charts business-related examples and case studies * Analyze large sets of information with exercise files to practice follow along</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Microsoft-Excel-A-Beginners-Guide-to-Pivot-Tables-in-Excel</p>
        <h2>About the Author</h2><h3>Simon Sez IT</h3><p>Simon Sez IT has offered technical courses for individuals, small businesses, and Fortune 500 companies since 2008, with thousands of employees who can benefit from the easy-to-learn and hands-on software training. It offers over 8,000 video tutorials on a range of software programs.

Simon Sez IT ensures stress-free eLearning and enhanced employee productivity-whether you implement new software or a technological upgrade in your work environment. With over 600,000 students from 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses worldwide.</p>
        <h2>Course Outline</h2><h4>1. Introduction to the Course</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Course Introduction</p><p style='margin: 0'>This video provides an overview of the tutor and about the course.</p></td></tr><tr><td style='padding: 15px;'><p>2. What are Pivot Tables and Why are they Useful?</p><p style='margin: 0'>This video talks about the Pivot Tables and explains why they are useful.</p></td></tr></tbody></table><br><h4>2. Preparing Data for Analysis</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. The Importance of Cleaning Data</p><p style='margin: 0'>This video explains the Importance of cleaning data.</p></td></tr><tr><td style='padding: 15px;'><p>2. Removing Blank Rows</p><p style='margin: 0'>This video talks about removing blank rows.</p></td></tr><tr><td style='padding: 15px;'><p>3. Removing Duplicate Rows</p><p style='margin: 0'>This video demonstrates removing duplicate rows.</p></td></tr><tr><td style='padding: 15px;'><p>4. Clearing Formatting</p><p style='margin: 0'>This video explains how to clear formatting.</p></td></tr><tr><td style='padding: 15px;'><p>5. Applying Number Formatting</p><p style='margin: 0'>This video explains how to apply number formatting.</p></td></tr><tr><td style='padding: 15px;'><p>6. Changing the Case</p><p style='margin: 0'>This video explains how to change the Case.</p></td></tr><tr><td style='padding: 15px;'><p>7. Removing Spaces and Non-printing Characters</p><p style='margin: 0'>This video talks about removing spaces and non-printing characters.</p></td></tr><tr><td style='padding: 15px;'><p>8. Merging and Splitting Columns</p><p style='margin: 0'>This video demonstrates merging and splitting columns.</p></td></tr><tr><td style='padding: 15px;'><p>9. Convert Numbers Stored as Text</p><p style='margin: 0'>This video explains how to convert numbers stored as text.</p></td></tr><tr><td style='padding: 15px;'><p>10. Finding and Replacing Text</p><p style='margin: 0'>This video explains how to find and replace text.</p></td></tr><tr><td style='padding: 15px;'><p>11. Spell Check</p><p style='margin: 0'>This video shows how to do a Spell Check.</p></td></tr><tr><td style='padding: 15px;'><p>12. Exercise 01</p><p style='margin: 0'>This is an exercise video number 01.</p></td></tr></tbody></table><br><h4>3. The Importance of Excel Tables</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Excel Tables versus Pivot Tables</p><p style='margin: 0'>This video demonstrates the difference between Excel Tables and Pivot Tables.</p></td></tr><tr><td style='padding: 15px;'><p>2. Format Data as a Table</p><p style='margin: 0'>This video demonstrates how to format data as a Table.</p></td></tr><tr><td style='padding: 15px;'><p>3. Exercise 02</p><p style='margin: 0'>This is an exercise video number 02.</p></td></tr></tbody></table><br><h4>4. Creating a Basic Pivot Table Report</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Using Recommended Pivot Tables</p><p style='margin: 0'>This video focuses on using recommended Pivot Tables.</p></td></tr><tr><td style='padding: 15px;'><p>2. Creating a Pivot Table from Scratch</p><p style='margin: 0'>This video shows how to create a Pivot Table from scratch.</p></td></tr><tr><td style='padding: 15px;'><p>3. Pivot Table Ribbons and Fields</p><p style='margin: 0'>This video explains about Pivot Table ribbons and fields.</p></td></tr><tr><td style='padding: 15px;'><p>4. Pivoting the Fields</p><p style='margin: 0'>This video explains pivoting the fields.</p></td></tr><tr><td style='padding: 15px;'><p>5. Adding Multiple Dimensions</p><p style='margin: 0'>This video explains about adding multiple dimensions.</p></td></tr><tr><td style='padding: 15px;'><p>6. Deleting Fields and Locking the Report Layout</p><p style='margin: 0'>This video explains about deleting fields and locking the report layout.</p></td></tr><tr><td style='padding: 15px;'><p>7. Exercise 03</p><p style='margin: 0'>This is an exercise video number 03.</p></td></tr></tbody></table><br><h4>5. Aggregation and Grouping</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Methods of Aggregation</p><p style='margin: 0'>This video talks about methods of aggregation.</p></td></tr><tr><td style='padding: 15px;'><p>2. Combining Methods of Aggregation</p><p style='margin: 0'>This video talks about combining methods of aggregation.</p></td></tr><tr><td style='padding: 15px;'><p>3. Grouping and Ungrouping Data</p><p style='margin: 0'>This video explains about grouping and ungrouping data.</p></td></tr><tr><td style='padding: 15px;'><p>4. Exercise 04</p><p style='margin: 0'>This is an exercise video number 04.</p></td></tr></tbody></table><br><h4>6. Formatting Values</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Applying Number Formatting</p><p style='margin: 0'>This video explains how to apply number formatting.</p></td></tr><tr><td style='padding: 15px;'><p>2. Handling Cells with No Data</p><p style='margin: 0'>This video explains handling cells with no data</p></td></tr><tr><td style='padding: 15px;'><p>3. Exercise 05</p><p style='margin: 0'>This is an exercise video number 05.</p></td></tr></tbody></table><br><h4>7. Layout Options</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Subtotals and Grand Totals</p><p style='margin: 0'>This video explains about subtotals and grand totals.</p></td></tr><tr><td style='padding: 15px;'><p>2. Choosing a Report Layout</p><p style='margin: 0'>This video focuses on choosing a report layout.</p></td></tr><tr><td style='padding: 15px;'><p>3. Inserting Blank Rows</p><p style='margin: 0'>This video helps in inserting blank rows.</p></td></tr><tr><td style='padding: 15px;'><p>4. Exercise 06</p><p style='margin: 0'>This is an exercise video number 06.</p></td></tr></tbody></table><br><h4>8. Formatting Pivot Tables</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Applying Pivot Table Styles</p><p style='margin: 0'>This video focuses on applying Pivot Table styles.</p></td></tr><tr><td style='padding: 15px;'><p>2. Modifying Pivot Table Styles</p><p style='margin: 0'>This video explains how to modify Pivot Table styles.</p></td></tr><tr><td style='padding: 15px;'><p>3. Creating a Custom Pivot Table Style</p><p style='margin: 0'>This video focuses on creating a custom Pivot Table style.</p></td></tr><tr><td style='padding: 15px;'><p>4. Exercise 07</p><p style='margin: 0'>This is an exercise video number 07.</p></td></tr></tbody></table><br><h4>9. Sorting and Filtering</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Sorting Pivot Table Data</p><p style='margin: 0'>This video demonstrates sorting Pivot Table data.</p></td></tr><tr><td style='padding: 15px;'><p>2. Filtering Pivot Table Data</p><p style='margin: 0'>This video demonstrates filtering Pivot Table data.</p></td></tr><tr><td style='padding: 15px;'><p>3. Top 10 Filter</p><p style='margin: 0'>This video talks about Top 10 Filter.</p></td></tr><tr><td style='padding: 15px;'><p>4. Exercise 08</p><p style='margin: 0'>This is an exercise video number 08.</p></td></tr></tbody></table><br><h4>10. Creating Pivot Charts</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Selecting the Right Chart Type</p><p style='margin: 0'>This video explains how to select the right chart type.</p></td></tr><tr><td style='padding: 15px;'><p>2. Clustered Column and Bar Charts</p><p style='margin: 0'>This video explains clustered column and bar charts.</p></td></tr><tr><td style='padding: 15px;'><p>3. Line Charts</p><p style='margin: 0'>This video talks about line charts.</p></td></tr><tr><td style='padding: 15px;'><p>4. Pie and Donut Charts</p><p style='margin: 0'>This video demonstrates about the Pie and Donut charts.</p></td></tr><tr><td style='padding: 15px;'><p>5. Map Charts</p><p style='margin: 0'>This video explains about the Map charts.</p></td></tr><tr><td style='padding: 15px;'><p>6. Applying Chart Layouts</p><p style='margin: 0'>This video talks about applying chart layouts.</p></td></tr><tr><td style='padding: 15px;'><p>7. Exercise 09</p><p style='margin: 0'>This is an exercise video number 09.</p></td></tr></tbody></table><br><h4>11. Formatting Pivot Charts</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Adding a Slicer</p><p style='margin: 0'>This video explains adding a slicer.</p></td></tr><tr><td style='padding: 15px;'><p>2. Formatting a Slicer</p><p style='margin: 0'>This video explains formatting a slicer.</p></td></tr><tr><td style='padding: 15px;'><p>3. Adding a Timeline</p><p style='margin: 0'>This video explains how to add a timeline.</p></td></tr><tr><td style='padding: 15px;'><p>4. Connecting Slicers and Timelines</p><p style='margin: 0'>This video focuses on connecting slicers and timelines.</p></td></tr><tr><td style='padding: 15px;'><p>5. Exercise 10</p><p style='margin: 0'>This is an exercise video number 10.</p></td></tr></tbody></table><br><h4>12. Applying Conditional Formatting</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Highlight Cell Rules</p><p style='margin: 0'>This video shows how to highlight cell rules.</p></td></tr><tr><td style='padding: 15px;'><p>2. Data Bars</p><p style='margin: 0'>This video explains about the data bars.</p></td></tr><tr><td style='padding: 15px;'><p>3. Color Scales</p><p style='margin: 0'>This video explains about the color scales.</p></td></tr><tr><td style='padding: 15px;'><p>4. Icon Sets</p><p style='margin: 0'>This video demonstrates the Icon sets.</p></td></tr><tr><td style='padding: 15px;'><p>5. Exercise 11</p><p style='margin: 0'>This is an exercise video number 11.</p></td></tr></tbody></table><br><h4>13. Updating Pivot Tables and Pivot Charts</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Adding Data to the Dataset</p><p style='margin: 0'>This video talks about adding data to the dataset.</p></td></tr><tr><td style='padding: 15px;'><p>2. Updating Pivot Tables and Pivot Charts</p><p style='margin: 0'>This video explains how to update Pivot Tables and Pivot Charts.</p></td></tr><tr><td style='padding: 15px;'><p>3. Exercise 12</p><p style='margin: 0'>This is an exercise video number 12.</p></td></tr></tbody></table><br><h4>14. Course  and Next Steps</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Course  and Next Steps</p><p style='margin: 0'>This is the course conclusion video, and it also helps you with the next steps.</p></td></tr></tbody></table>

Packt

Microsoft Excel

Increase your Excel and Pivot Table skills and knowledge within hours which will get you noticed by top management and prospective employers. Become more productive at using Excel which will save you hours each day and eliminate stress at work.

This course helps you learn about Pivot Tables that can be used for data analysis with a proper approach.

Microsoft Excel: A Beginners' Guide to Pivot Tables in Excel

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>This comprehensive course on </span><b><span>Advanced Excel Course (Formula, VLOOKUP &amp; Power Query)</span></b> will deepen your understanding on this topic. <span><span>After successful completion of this course you can acquire the required skills in this sector. This </span><b>Advanced Excel Course (Formula, VLOOKUP &amp; Power Query)</b> comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.</span></p><p><span><span>So enrol in this course today to fast track your career ladder.</span></span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
								</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>There is no experience or previous qualifications required for enrolment on this </span><b><span>Advanced Excel Course (Formula, VLOOKUP &amp; Power Query)</span></b>. It is available to all students, of all academic backgrounds.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Our </span><b><span>Advanced Excel Course (Formula, VLOOKUP &amp; Power Query)</span></b> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. <span><span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span></span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-</p><ul><li>Open doors of opportunities</li><li>Increase your adaptability</li><li>Keep you relevant</li><li>Boost confidence</li></ul><p>And much more!</p><p> </p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>5 sections • 41 lectures • 02:56:00 total length</p></div><div><div><div><div><div><div><div><p>•How to Get the most of the course: 00:01:00</p></div><div><div><p>•Text formulas in Excel: 00:08:00</p></div><div><div><p>•Text Formulas Exercise: 00:01:00</p></div><div><div><p>•Text Formulas Exercise (answers): 00:01:00</p></div><div><div><p>•Mathematical Formulas In Excel: 00:04:00</p></div><div><div><p>•Mathematical Formulas Exercise: 00:01:00</p></div><div><div><p>•Mathematical Formulas Exercise (answers): 00:01:00</p></div><div><div><p>•Date and Time Formulas In Excel: 00:05:00</p></div><div><div><p>•Date and Time Formulas Exercise: 00:01:00</p></div><div><div><p>•Date and Time Exercise Formulas (answers): 00:01:00</p></div><div><div><p>•Logic Formulas In Excel: 00:12:00</p></div><div><div><p>•Logic Formula Exercise: 00:01:00</p></div><div><div><p>•Logic Formula Exercise (answers): 00:01:00</p></div><div><div><p>•Financial Formula In Excel: 00:06:00</p></div><div><div><p>•Financial Formula Exercise: 00:01:00</p></div><div><div><p>•Financial Formula Exercise (answers): 00:02:00</p></div><div><div><p>•Informational Formula In Excel: 00:04:00</p></div><div><div><p>•Informational Formula Exercise: 00:01:00</p></div><div><div><p>•Informational Formula Exercise (answers): 00:01:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Menu Example with Excel Vlookup: 00:08:00</p></div><div><div><p>•Wildcard Search with Excel Vlookup: 00:09:00</p></div><div><div><p>•Looking to the Left with Excel Vlookup: 00:17:00</p></div><div><div><p>•2-Way Lookup: 00:14:00</p></div><div><div><p>•Comparing Lists with Excel Vlookup: 00:03:00</p></div><div><div><p>•Microsoft Excel Vlookup Tips and Tricks: 00:14:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Power Query Intro and Excel version: 00:03:00</p></div><div><div><p>•Excel Power Query - Introduction: 00:03:00</p></div><div><div><p>•Enabling M in Power Query: 00:02:00</p></div><div><div><p>•Transform Data - Trim in Excel Power Query: 00:05:00</p></div><div><div><p>•Transform Data - Format Dates and Values in Excel Power Query: 00:02:00</p></div><div><div><p>•Simple Expressions: 00:08:00</p></div><div><div><p>•Simple Expressions - Nested Expressions: 00:03:00</p></div><div><div><p>•Transform Data - Parsing URLs in Excel Power Query: 00:05:00</p></div><div><div><p>•Variables: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Formatting Excel Keyboard Shortcuts: 00:02:00</p></div><div><div><p>•Table Excel Keyboard Shortcuts: 00:02:00</p></div><div><div><p>•Editing Excel Keyboard Shortcuts: 00:05:00</p></div><div><div><p>•Formula Excel Keyboard Shortcuts: 00:03:00</p></div><div><div><p>•Workbook Excel Keyboard Shortcuts: 00:02:00</p></div><div><div><p>•Handy Excel Shortcuts Keyboard Shortcuts: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Assignment - Advanced Excel Course (Formula, VLOOKUP &amp; Power Query): 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Apex Learning

Finance Cert & Exam Prep

Computing Skills

Computer Skills

Trainers Course

Advanced Excel Course (Formula, VLOOKUP & Power Query)

<h3><b>Overview</b></h3>
<span>This comprehensive course on 50 Tips to Upgrade your Excel Skill will deepen your understanding on this topic.</span>

<span>After successful completion of this course you can acquire the required skills in this sector. This 50 Tips to Upgrade your Excel Skill comes with accredited certification which will enhance your CV and make you worthy in the job market.</span>

<span>So enrol in this course today to fast track your career ladder.</span>
<h3><b>How will I get my certificate?</b></h3>
You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.
<h3><b>Who is this course for?</b></h3>
<span>There is no experience or previous qualifications required for enrolment on this <strong>50 Tips to Upgrade your Excel Skill</strong></span><span>. It is available to all students, of all academic backgrounds.</span>
<h3><b>Requirements</b></h3>
<span>Our <strong>50 Tips to Upgrade your Excel Skill</strong></span><span> 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.</span>

<span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span>
<h3><b>Career path</b></h3>
<span>Having these various qualifications 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.</span> <h3>Course Curriculum</h3><div><p>7 sections • 52 lectures • 02:57:00 total length</p></div><div><div><div><div><div><div><div><p>•Welcome: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Camera Tool: 00:05:00</p></div><div><div><p>•Add Line Break in Formula Bar: 00:03:00</p></div><div><div><p>•Advanced Copy-Paste using Office Clipboard: 00:03:00</p></div><div><div><p>•Navigation between Worksheets using Shortcut Keys: 00:01:00</p></div><div><div><p>•Flash Fill: 00:02:00</p></div><div><div><p>•Add Multiple Rows and Columns Quickly: 00:02:00</p></div><div><div><p>•Delete Blank Rows: 00:03:00</p></div><div><div><p>•Multi Level Row and Column Sorting: 00:04:00</p></div><div><div><p>•Add Sparklines: 00:03:00</p></div><div><div><p>•Paste Special - Transpose: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Snap to Grid: 00:03:00</p></div><div><div><p>•Create Custom Auto fill List: 00:06:00</p></div><div><div><p>•Absolute Cell Reference: 00:03:00</p></div><div><div><p>•Import Data from Web page: 00:04:00</p></div><div><div><p>•Move Cell Direction: 00:03:00</p></div><div><div><p>•Delete Data using Mouse: 00:02:00</p></div><div><div><p>•Status Bar Quick Calculations: 00:03:00</p></div><div><div><p>•Link Text Boxes to Cell: 00:04:00</p></div><div><div><p>•Phone Number and ZIP Code Format: 00:04:00</p></div><div><div><p>•Speaking Cell: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Invisible Text: 00:03:00</p></div><div><div><p>•Worksheet Grouping: 00:04:00</p></div><div><div><p>•Advanced Transpose: 00:04:00</p></div><div><div><p>•XLStart Folder: 00:03:00</p></div><div><div><p>•Use Slicers: 00:05:00</p></div><div><div><p>•Convert Text to Numbers: 00:03:00</p></div><div><div><p>•Hiding Workbook Elements: 00:02:00</p></div><div><div><p>•Useful Shortcut Keys: 00:03:00</p></div><div><div><p>•Sort data from Left to Right: 00:03:00</p></div><div><div><p>•Advanced Filter (Complex): 00:11:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Email as PDF: 00:02:00</p></div><div><div><p>•Synchronous Scrolling: 00:03:00</p></div><div><div><p>•Quick Analysis of data within Excel: 00:02:00</p></div><div><div><p>•Fill blank cells with Value: 00:03:00</p></div><div><div><p>•Hidden Chart Source Data: 00:03:00</p></div><div><div><p>•Two more Shortcuts: 00:03:00</p></div><div><div><p>•Add Blank Rows: 00:03:00</p></div><div><div><p>•Custom views in Excel: 00:06:00</p></div><div><div><p>•EMBED Feature: 00:04:00</p></div><div><div><p>•Adding Country code in Mobile Numbers: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Plot an Average Line to a Chart: 00:04:00</p></div><div><div><p>•3D Referencing: 00:04:00</p></div><div><div><p>•Extract Unique Values: 00:03:00</p></div><div><div><p>•Excel Array Formula: 00:04:00</p></div><div><div><p>•Forecast Sheet: 00:04:00</p></div><div><div><p>•Add Spin Controls in Excel: 00:05:00</p></div><div><div><p>•Move Data using Mouse: 00:01:00</p></div><div><div><p>•Add new entry in Auto Correct to use across Office Applications: 00:05:00</p></div><div><div><p>•Find Differences between Two Lists: 00:02:00</p></div><div><div><p>•Find formulas Quickly: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Thank You: 00:01:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Office Skills & Productivity

Study Skills

50 Tips to Upgrade your Excel Skill

<p>Imagine being part of a world where you can express your creativity and turn your thoughts into powerful visual narratives that have an enduring effect. You may turn this desire into a reality with our Diploma in Graphic Design. Enter the design world and let your creative spark fly as you investigate the ideas, methods, and resources that propel the fascinating field of graphic design. This course is your ticket to becoming a proficient graphic designer who can easily combine art and technology, from learning to use Adobe Photoshop to creating captivating logos with Illustrator.</p><p>Our comprehensive Diploma in Graphic Design is meticulously crafted to equip you with the skills and knowledge needed to thrive in the dynamic world of visual communication. This course covers the fundamentals of graphic design, providing you with a solid base to build upon. You'll delve into design principles, understanding how to use colour, typography, and composition to convey powerful messages. Your creativity will be unleashed as you learn how to modify photographs and produce visually appealing content through hands-on training using Adobe Photoshop. Explore logo design with Adobe Illustrator and learn how to create distinctive brand identities. You will become an expert in print production with Adobe InDesign, producing magazines, brochures, and other eye-catching items.</p><p>Enrol today and embark on an exhilarating journey that will unlock the true potential of your creativity.</p><p><strong>Learning Outcomes of the Diploma in Creative Graphic Design Course:</strong></p><ul><li>Develop a strong understanding of the fundamentals and tenets of graphic design</li><li>Gain a thorough understanding of design theory and how it is used</li><li>Learn the fundamental Adobe Photoshop and Illustrator tools and tricks</li><li>Improve your designs and see how versatile blend modes and filters can be</li><li>Create polished logos with software widely used in the industry</li><li>Develop Adobe InDesign skills and learn how to produce eye-catching print work</li></ul><p>Our comprehensive Diploma in Graphic Design is meticulously designed to equip you with the essential skills and knowledge required to thrive in the ever-evolving field of visual communication. This course will take you on a transformative journey, providing you with a solid foundation in the principles of graphic design. From understanding colour theory to leveraging typography and composition, you'll learn how to create visually striking designs that captivate audiences.</p><p>Through hands-on training with Adobe Photoshop, you'll gain the ability to manipulate images, infuse them with your unique style, and bring your creative visions to life. With Adobe Illustrator, you'll discover the art of crafting logos that leave a lasting impression, empowering brands to express their identity and values. Furthermore, you'll explore the versatility of blend modes and filters, enhancing your designs with captivating visual effects.</p><p>In addition, our course delves into the realm of print work with Adobe In Design. From brochures to magazines, you'll master the art of creating visually stunning materials that convey powerful messages. Throughout the course, you'll develop the technical skills and creative mindset needed to excel as a graphic designer, allowing you to pursue diverse career opportunities in design agencies, advertising firms, or even as a freelancer. Unleash your creative potential with our Diploma in Graphic Design and embark on a journey that will shape your future as a visual storyteller.</p><p><strong>Course Curriculum</strong></p><ul><li>Basics of Graphic Design</li><li>Foundation in Design</li><li>Adobe Photoshop Basics</li><li>Designers go to Software</li><li>Blend Modes &amp; Filters</li><li>Creating Logos with Illustrator</li><li>Logo Design Basics</li><li>Adobe in Design and Print Work Introduction</li></ul><p><strong>Assessment &amp; Certification</strong></p><p>Students must finish and turn in a thorough assignment covering all topics in our curriculum. Our expert tutor will review the assignment to ensure it meets Quality Learning Systems (QLS) standards. Once the assessment is successful and passes a quality check, students will be awarded a certificate for completing the Diploma in Graphic Design course.</p><p><strong>Endorsed Certificate of Achievement from the Quality Licence Scheme</strong></p><p>After the course, participants will receive an endorsed certificate as proof of successful completion. The learner may request a certificate if they complete all course assessments.</p><p><strong>Endorsement:</strong></p><p>QLS approves this certified course as a well-qualified, non-regulated training programme. A trainer will be available to help you with any questions, including guidance on your pathways to higher education.</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        150 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>The following categories of learners find this "<strong>Diploma in Creative Graphic Design" </strong>course most related to their jobs and studies:</p><ul><li>Individuals with a passion for art and design</li><li>Creative professionals seeking to expand their skill set</li><li>Students exploring a career in graphic design</li><li>Small business owners want to create their branding</li><li>Marketing professionals looking to enhance their visual communication abilities</li><li>Anyone interested in expressing their creativity through digital design</li></ul>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>There are no specific requirements for enrolling in the Diploma in Graphic Design course. Therefore, learners do not need previous qualifications to sign up for this course.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>The "<strong>Diploma in Creative Graphic Design" </strong>course is complementary skill training for many jobs, including:</p><ul><li>Graphic Designer: £26,000-£32,000 Per year</li><li>Logo Designer: £22,000-£35,000 Per Year</li><li>Print Designer: £20,000-£35,000 Per Year</li><li>Web Designer:£40,000 - £45,000 Per Year</li><li>Graphic Designer - Retail: £30,000 - £35,000 Per Year</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4> Diploma in Graphic Design at QLS Level 5</h4>
        <p>
            Hard copy certificate -
            £75
        </p>

                        </div>

Kingston Open College

Design & Technology Courses (DT)

Graphic Design

Creative Design

Graphic Designer

Graphic Design & Illustration

Diploma in Professional Studies (DPS)

FREE Certification:QLS Endorsed + CPD Accredited | Instant Access | Round-the-Clock Tutor Support

Diploma in Creative Graphic Design - QLS Endorsed (Level 5)

For new users and the curious.
IMPORTANT: Once you are signed up, send us your requests on what you would like to see within the demonstration and learn on the course. We will then cater for your needs and answer them during the session.
This is designed to be an introduction into how to start a room by room survey using the Heat Engineer app, then sending this survey to the online dashboard. We will then go through the different steps to complete this heat loss report. Optional pages will also be worked through and shown. 
Examples of how to select the flow temperature and the heat source (heat pumps and boilers) will be presented once the heat loss result is completed. 
Scope of works
Estimated Start Time	Duration mins	Topic	Platform / Device
7:00:00 PM	5	Welcome introduction - Show an example Heat loss report from online - The end result	Website
7:05:00 PM	2	How to sign up and the different account types 5 mins	Website
7:07:00 PM	4	What the app is used for and sending to the online account – Show about page	Website & app
7:11:00 PM	2	Login into the app (Example used is an iPhone 14) – what is My Info and the History	App (mobile & tablets)
7:13:00 PM	3	Briefly show the estimator tool	App (mobile & tablets)
7:16:00 PM	2	How to start a new room by room survey	App (mobile & tablets)
7:18:00 PM	10	Open up example from History and enter two rooms - One standard and one vaulted. PowerPoint to help visualise	App (mobile & tablets)
7:28:00 PM	1	Send survey to main dashboard	App (mobile & tablets)
7:29:00 PM	3	Quick Intro to dashboard.	Website
7:32:00 PM	1	Show profile setup	Website
7:33:00 PM	7	Open sent survey go through step 1 to step 8	Website
7:40:00 PM	2	Selecting a heat source - Heat Pump in this example	Website
7:42:00 PM	15	Optional pages overview, emitters and performance, current radiators, new radiators, DHW, Bivalent system and fuel comparison page.	Website
7:57:00 PM	2	Print report off or send copy to a supplier	Website
7:59:00 PM	5	Adding Designers	
8:04:00 PM	1	Our future plans	Website
8:05:00 PM	15	Heat Manager - Digital file system for you and your customers	Website
8:20:00 PM	Any feedback and further questions please email to support@heat-engineer.com		
Questions - You will be able to ask further questions after the event.
Delivered by Rich Cartwright BEng DipEd MCIPHE
NEW RADIATORS
We use EN442 standard to enable you to customise the defined MWT (°c) and the results will highlight if the radiator will heat the room for a given internal design temperature. We like to promote the need to design low temperature systems!
Add multiple designers to your account
You can now add extra dashboard users to complete heat loss and heating design reports on your Heat Engineer Software account.
DHW (DOMESTIC HOT WATER)
This will calculate the projected energy demand and running costs for DHW and domestic cylinder sizing.
EMITTERS AND PERFORMANCE
This page is primarily used for heat pump designs. Once you specify the flow temperature for each room the SCOP (Seasonal Coefficient of Performance) values will be shown, and the system will show if radiators are over or undersized.
CURRENT RADIATORS
Use the app on site to enter the current radiators and our system will display the output values for different flow temperatures.
FUEL COMPARISON
Multiple fuels to compare against, you can adjust the price per unit and CO2 factor (kg/kWh). Present these running costs to your clients.
PHOTOS AND NOTES
Photos and notes which you or your surveyors have taken will be shown when you open the report from your dashboard. You may also upload and download photos from your PC / laptop too.
 

Heat Engineer

Heating Engineer

For new users and the curious.

Hello,

For new users and the curious.

IMPORTANT: Firstly, once you are signed up, send us your requests on what you would like to see within the demonstration and learn on the course. We will then cater for your needs and answer them during the session.

This is designed to be an introduction into how to start a room by room survey using the Heat Engineer app, then sending this survey to the online dashboard. We will then go through the different steps to complete this heat loss report. Optional pages will also be worked through and shown. 

Examples of how to select the flow temperature and the heat source (heat pumps and boilers) will be presented once the heat loss result is completed. 

How to use Heat Engineer Software V2 (Selectable dates)

General admission

<div fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Menopause Update</strong></div><div fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></div><div fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Focus:</strong></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">This specialised training day is meticulously designed for healthcare professionals, including nurses, allied healthcare practitioners (AHPs), and general practitioners (GPs), who are already practicing in the field of menopause care. With established NICE (National Institute for Health and Care Excellence) Guidance, practitioners can gain heightened confidence in effectively managing women experiencing menopause-related issues.</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Meet the Expert:</strong></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">Dr. Katie Barber, a seasoned GP with 15 years of experience in Oxfordshire and Buckinghamshire, leads this comprehensive update. Dr. Barber&#39;s journey into Women&#39;s Health began during her GP training when she earned diplomas from the Royal College of Obstetricians and Gynaecologists and the Faculty of Sexual and Reproductive Healthcare. Her work at the John Radcliffe Hospital&#39;s Gynaecology department, where she held a special interest in Gynaecology, sparked her enthusiasm for assisting women in navigating the various facets of menopause. Dr. Barber&#39;s expertise is further underlined by her Advanced Certificate of Menopause Care from the Faculty of Sexual and Reproductive Healthcare and her accreditation as a British Menopause Society specialist and Menopause trainer in Oxfordshire. She served as the Clinical Lead for the NHS Menopause service at the John Radcliffe in Oxfordshire until March 2021 and currently holds the role of Clinical Lead for the NHS Community Gynaecology Service in Oxfordshire. In 2020, she launched her private service, Oxford Menopause.</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Agenda:</strong></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">09.15 - Coffee and Registration</div><div fr-original-style="" style="box-sizing: border-box;">09.30 - Introduction and Course Objectives</div><div fr-original-style="" style="box-sizing: border-box;">09.40 - Physiology, Diagnosis, and Principles of Treatment</div><div fr-original-style="" style="box-sizing: border-box;">10.45 - Coffee</div><div fr-original-style="" style="box-sizing: border-box;">11.00 - Risks, Benefits, and Special Considerations (e.g., Premature Ovarian Insufficiency)</div><div fr-original-style="" style="box-sizing: border-box;">13.00 - Lunch</div><div fr-original-style="" style="box-sizing: border-box;">14.00 - Practical Prescribing and Common Pitfalls</div><div fr-original-style="" style="box-sizing: border-box;">14.30 - Vulvo-Vaginal Symptoms and Testosterone</div><div fr-original-style="" style="box-sizing: border-box;">14.30 - Case Studies and Q&amp;A</div><div fr-original-style="" style="box-sizing: border-box;">15.30 - Discussion and Sharing Good Practice - Close</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">Learning Outcomes:</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">1. Stay Current with Menopausal Evidence: Develop an up-to-date awareness of the latest evidence and clinical guidance concerning menopausal issues and treatment options.</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">2. Foster Critical Patient Discussions: Demonstrate a critical understanding of key discussion points with patients, enabling more informed and productive consultations.</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">3. Problem-Solving Skills: Engage in discussions about relevant practice problems and collaboratively explore solutions within the context of menopause care.</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">4. Values and Attitudes: Develop an awareness of how personal attitudes and values may influence practice in menopause care, fostering a more patient-centric approach.</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">5. Professional Accountability: Understand the ongoing development of practice in the field of menopause care and embrace professional accountability as an integral aspect of providing high-quality care.</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">6. Navigating NICE Guidance: Gain a comprehensive understanding of the NICE Guidance, empowering practitioners to align their practice with established best practices.</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">Please note: Course content may be subject to minor updates and adjustments.</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>

BBO Training

Clinical

Menopause Update

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>This course is intended for IT Professionals who are already experienced in general Windows Server, Windows client, Azure, and Microsoft 365 administration, and who want to learn more about using Windows PowerShell for administration. No prior experience with any version of PowerShell or any scripting language is assumed. This course is also suitable for IT Professionals already experienced in server administration, including Microsoft Exchange Server, Microsoft SharePoint Server, and Microsoft SQL Server.</p><p></p><p></p><p>This course provides students with the fundamental knowledge and skills to use PowerShell for administering and automating administration of Windows servers. This course provides students the skills to identify and build the command they require to perform a specific task. In addition, students learn how to build scripts to accomplish advanced tasks such as automating repetitive tasks and generating reports. This course provides prerequisite skills supporting a broad range of Microsoft products, including Windows Server, Windows Client, Microsoft Azure, and Microsoft 365. In keeping with that goal, this course will not focus on any one of those products, although Windows Server, which is the common platform for all of those products, will serve as the example for the techniques this course teaches.</p><p></p>Prerequisites<p>Before attending this course, students must have: </p><ul><li>-Experience with Windows networking technologies and implementation.</li> <li>- Experience with Windows Server administration, maintenance, and troubleshooting.</li></ul><p></p></div><div id="course-pills-2"><h3>1 - Review Windows PowerShell</h3> <ul> <li>Learn about Windows PowerShell</li> <li>Get familiar with Windows PowerShell applications</li> <li>Identify factors to install and use Windows PowerShell</li> <li>Configure the Windows PowerShell console</li> <li>Configure the Windows PowerShell Integrated Scripting Environment (ISE)</li> <li>Use Visual Studio Code with PowerShell</li> </ul> <h3>2 - Understand the command syntax in Windows PowerShell</h3> <ul> <li>Discover the structure of PowerShell cmdlets</li> <li>Discover the parameters for using PowerShell cmdlets</li> <li>Review the tab completion feature in PowerShell</li> <li>Display the About files content in PowerShell</li> </ul> <h3>3 - Find commands and Get-Help in Windows PowerShell</h3> <ul> <li>Define modules in PowerShell</li> <li>Find cmdlets in PowerShell</li> <li>Use command aliases in PowerShell</li> <li>Use Show-Command and Get-Help in PowerShell</li> <li>Interpret the help file contents and update the local help content in PowerShell</li> </ul> <h3>4 - Manage Active Directory Domain Services using PowerShell cmdlets</h3> <ul> <li>Manage user accounts in PowerShell</li> <li>Manage groups and group memberships in PowerShell</li> <li>Manage computer accounts in PowerShell</li> <li>Manage organizational units and Active Directory objects in PowerShell</li> </ul> <h3>5 - Manage network service settings for Windows devices using PowerShell cmdlets</h3> <ul> <li>Manage IP addresses in PowerShell</li> <li>Manage IP routing in PowerShell</li> <li>Manage DNS clients in PowerShell</li> <li>Manage Windows Firewall settings in PowerShell</li> </ul> <h3>6 - Manage Windows Server settings using PowerShell cmdlets</h3> <ul> <li>Automate management tasks using the Group Policy management cmdlets</li> <li>Manage server roles and services using PowerShell cmdlets</li> <li>Manage Hyper-V Virtual Machines using PowerShell cmdlets</li> <li>Manage Internet Information Services using PowerShell cmdlets</li> </ul> <h3>7 - Manage settings for a local Windows machine using PowerShell cmdlets</h3> <ul> <li>Manage Windows 10 using PowerShell</li> <li>Manage permissions with PowerShell</li> </ul> <h3>8 - Understand the Windows PowerShell pipeline</h3> <ul> <li>Review Windows PowerShell pipeline and its output</li> <li>Discover object members in PowerShell</li> <li>Control the formatting of pipeline output</li> </ul> <h3>9 - Select, sort, and measure objects using the pipeline</h3> <ul> <li>Sort and group objects by property in the pipeline</li> <li>Measure objects in the pipeline</li> <li>Select a set of objects in the pipeline</li> <li>Select object properties in the pipeline</li> <li>Create and format calculated properties in the pipeline</li> </ul> <h3>10 - Filter objects out of the pipeline</h3> <ul> <li>Learn about the comparison operators in PowerShell</li> <li>Review basic filter syntax in the pipeline</li> <li>Review advanced filter syntax in the pipeline</li> <li>Optimize the filter performance in the pipeline</li> </ul> <h3>11 - Enumerate objects in the pipeline</h3> <ul> <li>Learn about enumerations in the pipeline</li> <li>Review basic syntax to enumerate objects in the pipeline</li> <li>Review advanced syntax to enumerate objects in the pipeline</li> </ul> <h3>12 - Send and pass data as output from the pipeline</h3> <ul> <li>Write pipeline data to a file</li> <li>Convert pipeline objects to other forms of data representation in PowerShell</li> <li>Control additional output options in PowerShell</li> </ul> <h3>13 - Pass pipeline objects</h3> <ul> <li>Pipeline parameter binding</li> <li>Identify ByValue parameters</li> <li>Pass data by using ByValue</li> <li>Pass data by using ByPropertyName</li> <li>Identify ByPropertyName parameters</li> <li>Use manual parameters to override the pipeline</li> <li>Use parenthetical commands</li> <li>Expand property values</li> </ul> <h3>14 - Connect with data stores using PowerShell providers</h3> <ul> <li>Define Windows PowerShell providers</li> <li>Review the built-in providers in PowerShell</li> <li>Access provider help in PowerShell</li> </ul> <h3>15 - Use PowerShell drives in PowerShell</h3> <ul> <li>Explain PowerShell drives in PowerShell</li> <li>Use PowerShell drive cmdlets in PowerShell</li> <li>Manage the file system in PowerShell</li> <li>Manage the registry in PowerShell</li> <li>Work with certificates in PowerShell</li> <li>Work with other PowerShell drives in PowerShell</li> </ul> <h3>16 - Review CIM and WMI</h3> <ul> <li>Review architecture of CIM and WMI</li> <li>Review repositories in CIM and WMI</li> <li>Locate online class documentation by using CIM and WMI cmdlets</li> </ul> <h3>17 - Query configuration information by using CIM and WMI</h3> <ul> <li>List local repository namespaces and classes by using CIM and WMI</li> <li>Query instances by using commands and WMI Query Language</li> <li>Connect to remote computers by using CIM and WMI cmdlets</li> <li>Query repository classes from remote computers by using CIMSession objects</li> </ul> <h3>18 - Query and manipulate repository objects by using CIM and WMI methods</h3> <ul> <li>Discover methods of repository objects by using CIM and WMI</li> <li>Locate class methods and documentation by using CIM and WMI</li> <li>Invoke methods of repository objects by using CIM and WMI</li> </ul> <h3>19 - Manage variables in Windows PowerShell scripts</h3> <ul> <li>Define variables in Windows PowerShell scripts</li> <li>Create variable names in Windows PowerShell scripts</li> <li>Assign values and types to variables in Windows PowerShell scripts</li> <li>Identify the methods and properties of variables in Windows PowerShell scripts</li> <li>Use string variables and methods in Windows PowerShell scripts</li> <li>Use date variables and methods in Windows PowerShell scripts</li> </ul> <h3>20 - Work with arrays and hash tables in Windows PowerShell scripts</h3> <ul> <li>Define an array in Windows PowerShell scripts</li> <li>Work with array lists in Windows PowerShell scripts</li> <li>Define hash tables in Windows PowerShell Scripts</li> <li>Work with hash tables in Windows PowerShell scripts</li> </ul> <h3>21 - Create and run scripts by using Windows PowerShell</h3> <ul> <li>Review Windows PowerShell scripts</li> <li>Modify scripts in the PowerShell Gallery</li> <li>Create scripts using Windows PowerShell</li> <li>Review the PowerShellGet module in Windows PowerShell</li> <li>Run scripts and set the execution policy in Windows PowerShell</li> <li>Review Windows PowerShell and AppLocker</li> <li>Sign the scripts digitally in Windows PowerShell</li> </ul> <h3>22 - Work with scripting constructs in Windows PowerShell</h3> <ul> <li>Review and use the ForEach loop in Windows PowerShell scripts</li> <li>Review and use the If construct in Windows PowerShell scripts</li> <li>Review and use the Switch construct in Windows PowerShell scripts</li> <li>Review the For construct in Windows PowerShell scripts</li> <li>Review other loop constructs in Windows PowerShell scripts</li> <li>Review Break and Continue in Windows PowerShell scripts</li> </ul> <h3>23 - Import data in different formats for use in scripts by using Windows PowerShell cmdlets</h3> <ul> <li>Use the Get-Content command in Windows PowerShell scripts</li> <li>Use the Import-Csv cmdlet in Windows PowerShell scripts</li> <li>Use the Import-Clixml cmdlet in Windows PowerShell scripts</li> <li>Use the ConvertFrom-Json cmdlet in Windows PowerShell scripts</li> </ul> <h3>24 - Use methods to accept user inputs in Windows PowerShell scripts</h3> <ul> <li>Identify values that might change in Windows PowerShell scripts</li> <li>Use the Read-Host cmdlet in Windows PowerShell scripts</li> <li>Use the Get-Credential cmdlet in Windows PowerShell scripts</li> <li>Use the Out-GridView cmdlet in Windows PowerShell scripts</li> <li>Pass parameters to a Windows PowerShell script</li> </ul> <h3>25 - Troubleshoot scripts and handle errors in Windows PowerShell</h3> <ul> <li>Interpret error messages generated for Windows PowerShell commands</li> <li>Add output to Windows PowerShell scripts</li> <li>Use breakpoints in Windows PowerShell scripts</li> <li>Interpret error actions for Windows PowerShell commands</li> </ul> <h3>26 - Use functions and modules in Windows PowerShell scripts</h3> <ul> <li>Review functions in Windows PowerShell scripts</li> <li>Use variable scope in Windows PowerShell scripts</li> <li>Create modules in Windows PowerShell scripts</li> <li>Use the dot sourcing feature in Windows PowerShell</li> </ul> <h3>27 - Manage single and multiple computers by using Windows PowerShell remoting</h3> <ul> <li>Review the remoting feature of Windows PowerShell</li> <li>Compare remoting with remote connectivity</li> <li>Review the remoting security feature of Windows PowerShell</li> <li>Enable remoting by using Windows PowerShell</li> <li>Use one-to-one remoting by using Windows PowerShell</li> <li>Use one-to-many remoting by using Windows PowerShell</li> <li>Compare remoting output with local output</li> </ul> <h3>28 - Use advanced Windows PowerShell remoting techniques</h3> <ul> <li>Review common remoting techniques of Windows PowerShell</li> <li>Send parameters to remote computers in Windows PowerShell</li> <li>Set access protection to variables, aliases, and functions by using the scope modifier</li> <li>Enable multi-hop remoting in Windows PowerShell</li> </ul> <h3>29 - Manage persistent connections to remote computers by using Windows PowerShell sessions</h3> <ul> <li>Review persistent connections in Windows PowerShell</li> <li>Create and manage persistent PSSessions by using Windows PowerShell</li> <li>Disconnect PSSessions by using Windows PowerShell</li> <li>Review the feature of implicit remoting in Windows PowerShell</li> </ul> <h3>30 - Review Azure PowerShell module</h3> <ul> <li>Review Azure PowerShell</li> <li>Review the benefits of the Azure PowerShell module</li> <li>Install the Azure PowerShell module</li> <li>Migrate Azure PowerShell from AzureRM to Azure</li> <li>Review Microsoft Azure Active Directory module for Windows PowerShell and Azure Active Directory PowerShell for Graph modules</li> </ul> <h3>31 - Review the features and tools for Azure Cloud Shell</h3> <ul> <li>Review the characteristics of Azure Cloud Shell</li> <li>Review the features and tools of Azure Cloud Shell</li> <li>Configure and experiment with Azure Cloud Shell</li> </ul> <h3>32 - Manage Azure resources with Windows PowerShell</h3> <ul> <li>Create a new Azure virtual machine by using Windows PowerShell commands</li> <li>Manage Azure virtual machines by using Windows PowerShell commands</li> <li>Manage Azure related storage by using Azure PowerShell</li> <li>Manage Azure subscriptions by using Azure PowerShell</li> </ul> <h3>33 - Manage users, groups, and licenses in Microsoft Entra ID by using Windows PowerShell</h3> <ul> <li>Review benefits to manage Microsoft 365 services by using Windows PowerShell</li> <li>Connect to the Microsoft 365 tenant by using Windows PowerShell</li> <li>Manage users in Microsoft 365 by using Windows PowerShell</li> <li>Manage groups in Microsoft 365 by using Windows PowerShell</li> <li>Manage roles in Microsoft 365 by using Windows PowerShell</li> <li>Manage licenses in Microsoft 365 by using Windows PowerShell</li> </ul> <h3>34 - Manage Exchange Online by using Windows PowerShell</h3> <ul> <li>Connect to Exchange Online by using Windows PowerShell</li> <li>Manage mailboxes in Exchange Online by using Windows PowerShell</li> <li>Manage resources in Exchange Online by using Windows PowerShell</li> <li>Manage admin roles in Exchange Online by using Windows PowerShell</li> </ul> <h3>35 - Manage SharePoint Online by using Windows PowerShell</h3> <ul> <li>Install and connect to SharePoint Online Management Shell by using Windows PowerShell</li> <li>Manage SharePoint Online users and groups by using Windows PowerShell</li> <li>Manage SharePoint sites by using Windows PowerShell</li> <li>Manage SharePoint Online external user sharing by using Windows PowerShell</li> </ul> <h3>36 - Manage Microsoft Teams by using Windows PowerShell</h3> <ul> <li>Review Microsoft Teams PowerShell module</li> <li>Install the Microsoft Teams PowerShell module</li> <li>Manage teams with Microsoft Teams PowerShell module</li> </ul> <h3>37 - Create and manage background jobs using Windows PowerShell</h3> <ul> <li>Define the types of background jobs in Windows PowerShell</li> <li>Start remote jobs and CIM/WMI jobs in Windows PowerShell</li> <li>Monitor jobs in Windows PowerShell</li> <li>Retrieve results for running jobs in Windows PowerShell</li> </ul> <h3>38 - Create and manage scheduled jobs using Windows PowerShell</h3> <ul> <li>Create and run Windows PowerShell scripts as scheduled tasks</li> <li>Define scheduled jobs in Windows PowerShell</li> <li>Create job option and job trigger objects in Windows PowerShell</li> <li>Create and register a scheduled job in Windows PowerShell</li> <li>Retrieve the results from a scheduled job in Windows PowerShell</li> </ul></div>

Nexus Human

Azure PowerShell

Powershell

Microsoft AZ-104

Power Automate

Microsoft AZ-303

Microsoft Power Automate

AZ-040T00 Automating Administration with Powershell

Bournemouth

London Waterloo Academy

Flight Attendant

Stewardess

FLIGHT ATTENDANT VIRTUAL VIA ZOOM COURSE, EVENINGS

Registration Fee

Course Fee

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">This live virtual <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">Agility in HR (ICP-AHR) Training &amp; Certification Program</span></strong> enables the participants to learn:</span></p><ol fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">How to <u fr-original-style="" style="box-sizing: border-box;">adopt and apply agile principles, values, and methodologies within the HR department</u> itself &ndash; <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">&ldquo;<span style="color: rgb(147, 101, 184); box-sizing: border-box;" fr-original-style="color: rgb(147, 101, 184);">Agile for HR</span>.&rdquo;</em></strong> &ndash; and</li><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">The <u fr-original-style="" style="box-sizing: border-box;">role of HR in facilitating and supporting the adoption of Agile practices and principles across the organization</u> &ndash; <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">&ldquo;<span style="color: rgb(147, 101, 184); box-sizing: border-box;" fr-original-style="color: rgb(147, 101, 184);">HR for Agile</span>.&rdquo;</em></strong></li></ol><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">During this&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">live-immersive interactive workshop</span></strong>, participants will learn&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">essential concepts</strong>&nbsp;related to&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">&ldquo;Agile for HR&rdquo;</em></strong>&nbsp;through&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(243, 121, 52); box-sizing: border-box;" fr-original-style="color: rgb(243, 121, 52);">practical, easy-to-follow, hands-on exercises</span></strong>. By actively participating, attendees will develop a comprehensive understanding of:</span></p><ol fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Agile HR processes:</strong>&nbsp;adopting iterative and incremental approaches to HR processes like performance management, recruitment, and onboarding.</li><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Agile HR project management:</strong>&nbsp;This involves using Agile project management frameworks (e.g., Scrum or Kanban) to manage HR initiatives.</li><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Cross-functional collaboration:</strong>&nbsp;Promoting collaboration between HR and other departments using Agile principles, such as self-organizing teams and regular feedback loops.</li></ol><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Throughout the course, participants will&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">acquire knowledge</strong>&nbsp;on&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">&ldquo;HR for Agile&rdquo;</em></strong>&nbsp;and&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(243, 121, 52); box-sizing: border-box;" fr-original-style="color: rgb(243, 121, 52);">gain the ability to facilitate and support agile transformation within their organization</span></strong>. The training program includes&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(243, 121, 52); box-sizing: border-box;" fr-original-style="color: rgb(243, 121, 52);">relevant case studies, useful tools, and effective techniques related to</span>:</strong></span></p><ol fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Agile talent acquisition:</strong>&nbsp;Implementing recruitment strategies prioritizing individuals with an Agile mindset and values.</li><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Agile performance management:</strong>&nbsp;shifting to Agile-friendly approaches such as continuous feedback and frequent check-ins.</li><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Agile Learning and Development:</strong>&nbsp;Providing training programs that equip employees with Agile skills and mindsets.</li><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Agile organizational design:</strong>&nbsp;collaborating on restructuring the organization to support Agile practices like cross-functional teams and autonomy.</li></ol><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(65, 168, 95); box-sizing: border-box;" fr-original-style="color: rgb(65, 168, 95);">Bonus Module:</span></strong><span style="color: rgb(65, 168, 95); box-sizing: border-box;" fr-original-style="color: rgb(65, 168, 95);"> </span><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(65, 168, 95); box-sizing: border-box;" fr-original-style="color: rgb(65, 168, 95);"><u fr-original-style="" style="box-sizing: border-box;">Enhancing HR Agility with AI &amp; Analytics:</u></span>&nbsp;</em></strong>This module explores the integration of AI and analytics to revolutionize HR practices, aligning them with agile principles. Participants will learn how these technologies can automate tasks, enhance decision-making, and support agile transformations across the organization. Through focused examples, the session highlights the impact on recruitment, performance management, and overall HR efficiency, offering a forward-looking approach to agile HR management.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">This course will be delivered through <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">live virtual sessions via Zoom</span></strong>.&nbsp;<span style="font-size: 14px; box-sizing: border-box;" id="isPasted" fr-original-style="font-size: 14px;">There are the following dates on which you can opt for this course:</span></span></p><ol fr-original-style="" style="box-sizing: border-box;"><li style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Agile HR | 8-10 Apr | 9 am - 2 pm BST | Weekday | 3 days - 5 hrs/day | Best for UK / Europe</span></li><li style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Agile HR | 13-15 May | 9 am - 2 pm BST | Weekday | 3 days - 5 hrs/day | Best for UK / Europe</span></li><li style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Agile HR | 12-14 Jun | 9 am - 2 pm BST | Weekday | 3 days - 5 hrs/day | Best for UK / Europe</span></li><li style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Agile HR | 22-24 Jul | 9 am - 2 pm BST | Weekday | 3 days - 5 hrs/day | Best for UK / Europe</span></li><li style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Agile HR | 14-16 Aug | 9 am - 2 pm BST | Weekday | 3 days - 5 hrs/day | Best for UK / Europe</span></li><li style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Agile HR | 16-18 Sep | 9 am - 2 pm BST | Weekday | 3 days - 5 hrs/day | Best for UK / Europe</span></li><li style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Agile HR | 9-11 Oct | 9 am - 2 pm BST | Weekday | 3 days - 5 hrs/day | Best for UK / Europe</span></li><li style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Agile HR | 18-20 Nov | 9 am - 2 pm GMT | Weekday | 3 days - 5 hrs/day | Best for UK / Europe</span></li><li style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Agile HR | 18-20 Dec | 9 am - 2 pm GMT | Weekday | 3 days - 5 hrs/day | Best for UK / Europe</span></li></ol><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">The following are the links to the<span style="color: rgb(243, 121, 52); box-sizing: border-box;" fr-original-style="color: rgb(243, 121, 52);"> <u fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">essential documents</strong></u></span> that will help you make an informed decision:<br fr-original-style="" style="box-sizing: border-box;"></span></div><ol fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;"><div fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Detailed <span style="color: rgb(243, 121, 52); box-sizing: border-box;" fr-original-style="color: rgb(243, 121, 52);">course brochure</span>: </strong><a href="https://drive.google.com/file/d/1PARAqO_uN8WLtXb8e6OKoawB60afNwJ_/view?usp=drive_link" 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(147, 101, 184); box-sizing: border-box;" fr-original-style="color: rgb(147, 101, 184);">Click Here</span></strong></a><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;or download via the link below:&nbsp;</strong></div></li></ol><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><a href="https://drive.google.com/file/d/1PARAqO_uN8WLtXb8e6OKoawB60afNwJ_/view?usp=drive_link" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">https://drive.google.com/file/d/1PARAqO_uN8WLtXb8e6OKoawB60afNwJ_/view?usp=drive_link</span></a><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">&nbsp;</span></strong></div></li></ul><ol fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;"><div fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(243, 121, 52); box-sizing: border-box;" fr-original-style="color: rgb(243, 121, 52);">Testimonials</span> from global HR professionals: </strong><a href="https://drive.google.com/file/d/1wYNCJAMiNQeeihcluQEY5JdBkjgYtW6S/view?usp=drive_link" 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(147, 101, 184); box-sizing: border-box;" fr-original-style="color: rgb(147, 101, 184);">Click Here</span></strong></a><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;or download via the link below:&nbsp;</strong></div></li></ol><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><a href="https://drive.google.com/file/d/1wYNCJAMiNQeeihcluQEY5JdBkjgYtW6S/view?usp=drive_link" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">https://drive.google.com/file/d/1wYNCJAMiNQeeihcluQEY5JdBkjgYtW6S/view?usp=drive_link</span></a><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">&nbsp;</span></div></li></ul>

ValueX2

https://www.valuex2.com/agile-hr-certification/
https://www.linkedin.com/company/80563537/

ICAgile's Agility in HR (ICP-AHR) Training & Certification Program by ValueX2 | 3 days - 5 hrs/day | 9 am - 2 pm UK Time

<h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">LEARN TO FOCUS ON INTERPERSONAL SKILLS, BEHAVIOR, AND ENVIRONMENT AND HOW TO PROMOTE DIVERSITY-POSITIVE INTERACTIONS.</h3><div style="color: rgb(33, 37, 41); box-sizing: border-box;" fr-original-style=" color: rgb(33, 37, 41);"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">You will be able to focus on interpersonal skills, behavior, and environment, to see how they promote diversity-positive interactions, as well as learn causes for discriminatory practices and create an action plan for increasing workplace acceptance and harmony.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><b fr-original-style="" style="box-sizing: border-box;">Uncover and discard beliefs and attitudes that foster or block progress</b>. By discovering your strengths as well as liabilities, you can build on the positive and move toward minimizing the negative. As a result, you will gain greater personal and professional satisfaction.</p><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">PART I &ndash; BROADENING THE VIEW</h3>&nbsp;<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Find new perspectives and ways to turn challenges into opportunities. Become skilled at ways to further develop self-awareness and sensitivity.</p><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">PART II &ndash; FAIR STANDARDS</h3>&nbsp;<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Learn about how attitudes expressed in speech and behavior promote or hinder a positive work environment. Determine and apply steps for getting past prejudice for greater productivity.</p><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">PART III &ndash; ORGANIZATIONAL UNITY</h3>&nbsp;<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Discover value in diverse perspectives and personalities and their benefits. Strategize ways to strengthen relationships and turn negative into positive interactions.</p><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">ATTENDEES&nbsp;WILL BE ABLE TO:</strong></h3>&nbsp;<ul fr-original-style="" style="box-sizing: border-box;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Discover new ways to &ldquo;see things differently;&rdquo;</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Use Emotional Intelligence to strengthen relationships and increase awareness of self and others;</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Define Diversity and uncover ways in which it is significantly useful in an organization;</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Develop best practices (rooted in honor and law) to use Diversity in planning, problem solving, and decision-making);</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Manage conflict through unity, using the organization&rsquo;s mission, vision, values, and goals; and</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Understand and communicate value to staff.</li></ul><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><i style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Online Class&mdash;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Diversity &ndash; Building a Thriving Business Environment</strong>&nbsp;is a 4-hour interactive virtual class.&nbsp;</i></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">&nbsp;</p><h6 style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">Register for this class and you will be sent ONLINE login instructions prior to the class date.</h6></div><div style="color: rgb(33, 37, 41); box-sizing: border-box;" fr-original-style=" color: rgb(33, 37, 41);"><br fr-original-style="" style="box-sizing: border-box;"></div><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;"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Improving Communications brought our organization to realize how important our employees&mdash;our people&mdash;are to Baystate Dental. By helping us to develop a more thoughtful and sensitive nature, we now relate better with each other and our patients.</p><span style="color: rgb(33, 37, 41); box-sizing: border-box;" fr-original-style="color: rgb(33, 37, 41);">Dr. Kevin Coughlin, DMD, FAGD, MBA</span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Baystate Dental</span>

LEARN TO FOCUS ON INTERPERSONAL SKILLS, BEHAVIOR, AND ENVIRONMENT AND HOW TO PROMOTE DIVERSITY-POSITIVE INTERACTIONS.
You will be able to focus on interpersonal skills, behavior, and environment, to see how they promote diversity-positive interactions, as well as learn causes for discriminatory practices and create an action plan for increasing workplace acceptance and harmony.
Uncover and discard beliefs and attitudes that foster or block progress. By discovering your strengths as well as liabilities, you can build on the positive and move toward minimizing the negative. As a result, you will gain greater personal and professional satisfaction.
PART I – BROADENING THE VIEW
Find new perspectives and ways to turn challenges into opportunities. Become skilled at ways to further develop self-awareness and sensitivity.
PART II – FAIR STANDARDS
Learn about how attitudes expressed in speech and behavior promote or hinder a positive work environment. Determine and apply steps for getting past prejudice for greater productivity.
PART III – ORGANIZATIONAL UNITY
Discover value in diverse perspectives and personalities and their benefits. Strategize ways to strengthen relationships and turn negative into positive interactions.
ATTENDEES WILL BE ABLE TO:
Discover new ways to “see things differently;”
Use Emotional Intelligence to strengthen relationships and increase awareness of self and others;
Define Diversity and uncover ways in which it is significantly useful in an organization;
Develop best practices (rooted in honor and law) to use Diversity in planning, problem solving, and decision-making);
Manage conflict through unity, using the organization’s mission, vision, values, and goals; and
Understand and communicate value to staff.
Online Class—Diversity – Building a Thriving Business Environment is a 4-hour interactive virtual class. 
 
Register for this class and you will be sent ONLINE login instructions prior to the class date.



Improving Communications brought our organization to realize how important our employees—our people—are to Baystate Dental. By helping us to develop a more thoughtful and sensitive nature, we now relate better with each other and our patients.
Dr. Kevin Coughlin, DMD, FAGD, MBABaystate Dental

Improving Communications Uk

DIVERSITY – BUILDING A THRIVING BUSINESS ENVIRONMENT

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p></p><p>This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.</p><p></p><p></p><p>This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.</p><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Transact-SQL</h3> <ul> <li>Work with schemas</li> <li>Explore the structure of SQL statements</li> <li>Examine the SELECT statement</li> <li>Work with data types</li> <li>Handle NULLs</li> </ul> <h3>2 - Sort and filter results in T-SQL</h3> <ul> <li>Sort your results</li> <li>Limit the sorted results</li> <li>Page results</li> <li>Remove duplicates</li> <li>Filter data with predicates</li> </ul> <h3>3 - Combine multiple tables with JOINs in T-SQL</h3> <ul> <li>Understand joins concepts and syntax</li> <li>Use inner joins</li> <li>Use outer joins</li> <li>Use cross joins</li> <li>Use self joins</li> </ul> <h3>4 - Write Subqueries in T-SQL</h3> <ul> <li>Understand subqueries</li> <li>Use scalar or multi-valued subqueries</li> <li>Use self-contained or correlated subqueries</li> </ul> <h3>5 - Use built-in functions and GROUP BY in Transact-SQL</h3> <ul> <li>Categorize built-in functions</li> <li>Use scalar functions</li> <li>Use ranking and rowset functions</li> <li>Use aggregate functions</li> <li>Summarize data with GROUP BY</li> <li>Filter groups with HAVING</li> </ul> <h3>6 - Modify data with T-SQL</h3> <ul> <li>Insert data</li> <li>Generate automatic values</li> <li>Update data</li> <li>Delete data</li> <li>Merge data based on multiple tables</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the DP-080T00 Querying Data with Microsoft Transact-SQL course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Data Skills

Teaching & Training

DP-080T00 Querying Data with Microsoft Transact-SQL

<div data-testid="summary" 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;">Understand and mitigate your own personal drivers of conflict</strong></p><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><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;"><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Have you ever said &#39;They really push my buttons&#39; or &#39;I can&#39;t stand it when people...&#39;?</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">That&#39;s the sound of you being &#39;hooked&#39;. We all have values that we want to live by, and when they are challenged, that&#39;s when we are most likely to engage in a conflict.&nbsp;</p><p id="isPasted" 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;">In this online workshop, Gemma will teach you the conflict hooks model so that you can identify your common hooks and how to handle them to reduce or prevent conflict.&nbsp;</span></p><p id="isPasted" 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;">What you will get from this 60-minute session:</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;">Self-awareness of your conflict hooks</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Empathy for what may hook others</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Confidence to diplomatically speak about conflict with others</li></ul><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;">How we will do it:</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;">Exploration of how conflict hooks show up in teams</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learning how core values are inherent to conflict hooks</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Identifying your own conflict hooks</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Practice articulating your conflict hooks to others</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Tips for how to use your self awareness to reduce or prevent conflict</li></ul></span><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">This online session is designed to be as interactive or passive as you wish. You are most welcome to ask questions, share challenges and discuss your ideas. You are equally we</span>lcome to join with your camera off and just listen in.</span></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);"><span style="color: rgb(0, 0, 0); font-size: 16px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 16px;">This session will be held on zoom &ndash; you will receive the meeting link once you book your place.</span></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);"><span style="color: rgb(0, 0, 0); font-size: 16px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 16px;">________</span></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);"><span style="color: rgb(0, 0, 0); font-size: 16px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 16px;">Meet your trainer:</span></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);"><span style="color: rgb(0, 0, 0); font-size: 16px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 16px;">Hi, I&rsquo;m Gemma Perella; a Personal Development Trainer and founder of The Self Leadership Initiative. The SLI is all about helping you to develop young leaders.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">As a teenager in 2006 I stumbled across a leadership training programme that changed my life. I went from an introverted outsider to a confident and driven educator. Ever since, my mission has been inspiring and empowering young people to become the best versions of themselves.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">Over the last 9 years I&#39;ve been working with organisations that support young people. I deliver interactive and practical training programmes to equip students with the kinds of skills &lsquo;they don&rsquo;t teach you in school&rsquo; in order to help them become the confident, resilient and emotionally intelligent leaders that the world needs.</span></p></div><div data-testid="organizerBrief" fr-original-style="" style="box-sizing: border-box;"><div data-testid="creator-signal-main-section" fr-original-style="" style="box-sizing: border-box;"><section data-testid="simplified-organizer-info" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></section></div></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>

Understand and mitigate your own personal drivers of conflict



Have you ever said 'They really push my buttons' or 'I can't stand it when people...'?
That's the sound of you being 'hooked'. We all have values that we want to live by, and when they are challenged, that's when we are most likely to engage in a conflict. 
In this online workshop, Gemma will teach you the conflict hooks model so that you can identify your common hooks and how to handle them to reduce or prevent conflict. 
What you will get from this 60-minute session:
Self-awareness of your conflict hooks
Empathy for what may hook others
Confidence to diplomatically speak about conflict with others
How we will do it:
Exploration of how conflict hooks show up in teams
Learning how core values are inherent to conflict hooks
Identifying your own conflict hooks
Practice articulating your conflict hooks to others
Tips for how to use your self awareness to reduce or prevent conflict
This online session is designed to be as interactive or passive as you wish. You are most welcome to ask questions, share challenges and discuss your ideas. You are equally welcome to join with your camera off and just listen in.
This session will be held on zoom – you will receive the meeting link once you book your place.
________
Meet your trainer:
Hi, I’m Gemma Perella; a Personal Development Trainer and founder of The Self Leadership Initiative. The SLI is all about helping you to develop young leaders.

As a teenager in 2006 I stumbled across a leadership training programme that changed my life. I went from an introverted outsider to a confident and driven educator. Ever since, my mission has been inspiring and empowering young people to become the best versions of themselves.

Over the last 9 years I've been working with organisations that support young people. I deliver interactive and practical training programmes to equip students with the kinds of skills ‘they don’t teach you in school’ in order to help them become the confident, resilient and emotionally intelligent leaders that the world needs.



The Self Leadership Initiative

Conflict Resolution

Leadership Skills

Team Leading

Conflict Management

Team Leader

Conflict

Leadership

Team Management

Leadership Development

Understand and mitigate your own personal drivers of conflict

What are your conflict hooks?

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>Students in this course are interested in Azure development or in passing the Microsoft Azure Developer Associate certification exam.</p><p></p><p></p><p>This course teaches developers how to create end-to-end solutions in Microsoft Azure. Students will learn how to implement Azure compute solutions, create Azure Functions, implement and manage web apps, develop solutions utilizing Azure storage, implement authentication and authorization, and secure their solutions by using KeyVault and Managed Identities. Students will also learn how to connect to and consume Azure services and third-party services, and include event- and message-based models in their solutions. The course also covers monitoring, troubleshooting, and optimizing Azure solutions.</p><p></p>Prerequisites<p>To be successful in this course, learners should have the following: Hands-on experience with Azure IaaS and PaaS solutions, and the Azure Portal. Experience writing in an Azure supported language at the intermediate level. (C#, JavaScript, Python, or Java) Ability to write code to connect and perform operations on, a SQL or NoSQL database product. (SQL Server, Oracle, MongoDB, Cassandra or similar) Experience writing code to handle authentication, authorization, and other security principles at the intermediate level. A general understanding of HTML, the HTTP protocol and REST API interfaces.</p></div><div id="course-pills-2"><h3>1 - Explore Azure App Service</h3> <ul> <li>Examine Azure App Service</li> <li>Examine Azure App Service plans</li> <li>Deploy to App Service</li> <li>Explore authentication and authorization in App Service</li> <li>Discover App Service networking features</li> </ul> <h3>2 - Configure web app settings</h3> <ul> <li>Configure application settings</li> <li>Configure general settings</li> <li>Configure path mappings</li> <li>Enable diagnostic logging</li> <li>Configure security certificates</li> </ul> <h3>3 - Scale apps in Azure App Service</h3> <ul> <li>Examine autoscale factors</li> <li>Identify autoscale factors</li> <li>Enable autoscale in App Service</li> <li>Explore autoscale best practices</li> </ul> <h3>4 - Explore Azure App Service deployment slots</h3> <ul> <li>Explore staging environments</li> <li>Examine slot swapping</li> <li>Swap deployment slots</li> <li>Route traffic in App Service</li> </ul> <h3>5 - Explore Azure Functions</h3> <ul> <li>Discover Azure Functions</li> <li>Compare Azure Functions hosting options</li> <li>Scale Azure Functions</li> </ul> <h3>6 - Develop Azure Functions</h3> <ul> <li>Explore Azure Functions development</li> <li>Create triggers and bindings</li> <li>Connect functions to Azure services</li> </ul> <h3>7 - Explore Azure Blob storage</h3> <ul> <li>Explore Azure Blob storage</li> <li>Discover Azure Blob storage resource types</li> <li>Explore Azure Storage security features</li> <li>Discover static website hosting in Azure Storage</li> </ul> <h3>8 - Manage the Azure Blob storage lifecycle</h3> <ul> <li>Explore the Azure Blob storage lifecycle</li> <li>Discover Blob storage lifecycle policies</li> <li>Implement Blob storage lifecycle policies</li> <li>Rehydrate blob data from the archive tier</li> </ul> <h3>9 - Work with Azure Blob storage</h3> <ul> <li>Explore Azure Blob storage client library</li> <li>Create a client object</li> <li>Manage container properties and metadata by using .NET</li> <li>Set and retrieve properties and metadata for blob resources by using REST</li> </ul> <h3>10 - Explore Azure Cosmos DB</h3> <ul> <li>Identify key benefits of Azure Cosmos DB</li> <li>Explore the resource hierarchy</li> <li>Explore consistency levels</li> <li>Choose the right consistency level</li> <li>Explore supported APIs</li> <li>Discover request units</li> </ul> <h3>11 - Work with Azure Cosmos DB</h3> <ul> <li>Explore Microsoft .NET SDK v3 for Azure Cosmos DB</li> <li>Create stored procedures</li> <li>Create triggers and user-defined functions</li> <li>Explore change feed in Azure Cosmos DB</li> </ul> <h3>12 - Manage container images in Azure Container Registry</h3> <ul> <li>Discover the Azure Container Registry</li> <li>Explore storage capabilities</li> <li>Build and manage containers with tasks</li> <li>Explore elements of a Dockerfile</li> </ul> <h3>13 - Run container images in Azure Container Instances</h3> <ul> <li>Explore Azure Container Instances</li> <li>Run containerized tasks with restart policies</li> <li>Set environment variables in container instances</li> <li>Mount an Azure file share in Azure Container Instances</li> </ul> <h3>14 - Implement Azure Container Apps</h3> <ul> <li>Explore Azure Container Apps</li> <li>Explore containers in Azure Container Apps</li> <li>Implement authentication and authorization in Azure Container Apps</li> <li>Manage revisions and secrets in Azure Container Apps</li> <li>Explore Dapr integration with Azure Container Apps</li> </ul> <h3>15 - Explore the Microsoft identity platform</h3> <ul> <li>Explore the Microsoft identity platform</li> <li>Explore service principals</li> <li>Discover permissions and consent</li> <li>Discover conditional access</li> </ul> <h3>16 - Implement authentication by using the Microsoft Authentication Library</h3> <ul> <li>Explore the Microsoft Authentication Library</li> <li>Initialize client applications</li> </ul> <h3>17 - Implement shared access signatures</h3> <ul> <li>Discover shared access signatures</li> <li>Choose when to use shared access signatures</li> <li>Explore stored access policies</li> </ul> <h3>18 - Explore Microsoft Graph</h3> <ul> <li>Discover Microsoft Graph</li> <li>Query Microsoft Graph by using REST</li> <li>Query Microsoft Graph by using SDKs</li> <li>Apply best practices to Microsoft Graph</li> </ul> <h3>19 - Implement Azure Key Vault</h3> <ul> <li>Explore Azure Key Vault</li> <li>Discover Azure Key Vault best practices</li> <li>Authenticate to Azure Key Vault</li> </ul> <h3>20 - Implement managed identities</h3> <ul> <li>Explore managed identities</li> <li>Discover the managed identities authentication flow</li> <li>Configure managed identities</li> <li>Acquire an access token</li> </ul> <h3>21 - Implement Azure App Configuration</h3> <ul> <li>Explore the Azure App Configuration service</li> <li>Create paired keys and values</li> <li>Manage application features</li> <li>Secure app configuration data</li> </ul> <h3>22 - Explore API Management</h3> <ul> <li>Discover the API Management service</li> <li>Explore API gateways</li> <li>Explore API Management policies</li> <li>Create advanced policies</li> <li>Secure APIs by using subscriptions</li> <li>Secure APIs by using certificates</li> </ul> <h3>23 - Explore Azure Event Grid</h3> <ul> <li>Explore Azure Event Grid</li> <li>Discover event schemas</li> <li>Explore event delivery durability</li> <li>Control access to events</li> <li>Receive events by using webhooks</li> <li>Filter events</li> </ul> <h3>24 - Explore Azure Event Hubs</h3> <ul> <li>Discover Azure Event Hubs</li> <li>Explore Event Hubs Capture</li> <li>Scale your processing application</li> <li>Control access to events</li> <li>Perform common operations with the Event Hubs client library</li> </ul> <h3>25 - Discover Azure message queues</h3> <ul> <li>Choose a message queue solution</li> <li>Explore Azure Service Bus</li> <li>Discover Service Bus queues, topics, and subscriptions</li> <li>Explore Service Bus message payloads and serialization</li> <li>Explore Azure Queue Storage</li> <li>Create and manage Azure Queue Storage and messages by using .NET</li> </ul> <h3>26 - Monitor app performance</h3> <ul> <li>Explore Application Insights</li> <li>Discover log-based metrics</li> <li>Instrument an app for monitoring</li> <li>Select an availability test</li> <li>Troubleshoot app performance by using Application Map</li> </ul> <h3>27 - Develop for Azure Cache for Redis</h3> <ul> <li>Explore Azure Cache for Redis</li> <li>Configure Azure Cache for Redis</li> <li>Interact with Azure Cache for Redis by using .NET</li> </ul> <h3>28 - Develop for storage on CDNs</h3> <ul> <li>Explore Azure Content Delivery Networks</li> <li>Control cache behavior on Azure Content Delivery Networks</li> <li>Interact with Azure Content Delivery Networks by using .NET</li> </ul></div>

Microsoft AZ-900

Microsoft Azure

Microsoft AZ-700

AWS Certified Solutions Architect

AZ-204T00 Developing Solutions for Microsoft Azure

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p></p><p>The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.</p><p></p><p></p><p>This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.</p><p></p>Prerequisites<p></p><li>Understanding core data concepts.</li>  <li>Knowledge of working with relational data in the cloud.</li>  <li>Knowledge of working with non-relational data in the cloud.</li>   <li>Knowledge of data analysis and visualization concepts.</li>   <li>DP-900T00 Microsoft Azure Data Fundamentals is recommended<p></p></li></div><div id="course-pills-2"><h3>1 - Discover data analysis</h3> <ul> <li>Overview of data analysis</li> <li>Roles in data</li> <li>Tasks of a data analyst</li> </ul> <h3>2 - Get started building with Power BI</h3> <ul> <li>Use Power BI</li> <li>Building blocks of Power BI</li> <li>Tour and use the Power BI service</li> </ul> <h3>3 - Get data in Power BI</h3> <ul> <li>Get data from files</li> <li>Get data from relational data sources</li> <li>Create dynamic reports with parameters</li> <li>Get data from a NoSQL database</li> <li>Get data from online services</li> <li>Select a storage mode</li> <li>Get data from Azure Analysis Services</li> <li>Fix performance issues</li> <li>Resolve data import errors</li> </ul> <h3>4 - Clean, transform, and load data in Power BI</h3> <ul> <li>Shape the initial data</li> <li>Simplify the data structure</li> <li>Evaluate and change column data types</li> <li>Combine multiple tables into a single table</li> <li>Profile data in Power BI</li> <li>Use Advanced Editor to modify M code</li> </ul> <h3>5 - Design a semantic model in Power BI</h3> <ul> <li>Work with tables</li> <li>Create a date table</li> <li>Work with dimensions</li> <li>Define data granularity</li> <li>Work with relationships and cardinality</li> <li>Resolve modeling challenges</li> </ul> <h3>6 - Add measures to Power BI Desktop models</h3> <ul> <li>Create simple measures</li> <li>Create compound measures</li> <li>Create quick measures</li> <li>Compare calculated columns with measures</li> </ul> <h3>7 - Add calculated tables and columns to Power BI Desktop models</h3> <ul> <li>Create calculated columns</li> <li>Learn about row context</li> <li>Choose a technique to add a column</li> </ul> <h3>8 - Use DAX time intelligence functions in Power BI Desktop models</h3> <ul> <li>Use DAX time intelligence functions</li> <li>Additional time intelligence calculations</li> </ul> <h3>9 - Optimize a model for performance in Power BI</h3> <ul> <li>Review performance of measures, relationships, and visuals</li> <li>Use variables to improve performance and troubleshooting</li> <li>Reduce cardinality</li> <li>Optimize DirectQuery models with table level storage</li> <li>Create and manage aggregations</li> </ul> <h3>10 - Design Power BI reports</h3> <ul> <li>Design the analytical report layout</li> <li>Design visually appealing reports</li> <li>Report objects</li> <li>Select report visuals</li> <li>Select report visuals to suit the report layout</li> <li>Format and configure visualizations</li> <li>Work with key performance indicators</li> </ul> <h3>11 - Configure Power BI report filters</h3> <ul> <li>Apply filters to the report structure</li> <li>Apply filters with slicers</li> <li>Design reports with advanced filtering techniques</li> <li>Consumption-time filtering</li> <li>Select report filter techniques</li> <li>Case study - Configure report filters based on feedback</li> </ul> <h3>12 - Enhance Power BI report designs for the user experience</h3> <ul> <li>Design reports to show details</li> <li>Design reports to highlight values</li> <li>Design reports that behave like apps</li> <li>Work with bookmarks</li> <li>Design reports for navigation</li> <li>Work with visual headers</li> <li>Design reports with built-in assistance</li> <li>Tune report performance</li> <li>Optimize reports for mobile use</li> </ul> <h3>13 - Perform analytics in Power BI</h3> <ul> <li>Explore statistical summary</li> <li>Identify outliers with Power BI visuals</li> <li>Group and bin data for analysis</li> <li>Apply clustering techniques</li> <li>Conduct time series analysis</li> <li>Use the Analyze feature</li> <li>Create what-if parameters</li> <li>Use specialized visuals</li> </ul> <h3>14 - Create and manage workspaces in Power BI</h3> <ul> <li>Distribute a report or dashboard</li> <li>Monitor usage and performance</li> <li>Recommend a development life cycle strategy</li> <li>Troubleshoot data by viewing its lineage</li> <li>Configure data protection</li> </ul> <h3>15 - Manage semantic models in Power BI</h3> <ul> <li>Use a Power BI gateway to connect to on-premises data sources</li> <li>Configure a semantic model scheduled refresh</li> <li>Configure incremental refresh settings</li> <li>Manage and promote semantic models</li> <li>Troubleshoot service connectivity</li> <li>Boost performance with query caching (Premium)</li> </ul> <h3>16 - Create dashboards in Power BI</h3> <ul> <li>Configure data alerts</li> <li>Explore data by asking questions</li> <li>Review Quick insights</li> <li>Add a dashboard theme</li> <li>Pin a live report page to a dashboard</li> <li>Configure a real-time dashboard</li> <li>Set mobile view</li> </ul> <h3>17 - Implement row-level security</h3> <ul> <li>Configure row-level security with the static method</li> <li>Configure row-level security with the dynamic method</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans PL-300T00: Microsoft Power BI Data Analyst training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the PL-300T00: Microsoft Power BI Data Analyst course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

1839 Courses

Organic Cosmetics Formulation: Natural Beauty Guide

By John Academy

Law & Paralegal Diploma

By Academy for Health and Fitness

Sports Therapy: Sports Massage, Sports First Aid & Sports Nutrition Diploma

By Academy for Health and Fitness

Diploma in English Law

By Academy for Health and Fitness

Scrum Master CPD Accredited certification with Agile

By Skill Up

Neuro-linguistic Programming (NLP) Diploma

By Janets

Microsoft Excel: A Beginners' Guide to Pivot Tables in Excel

By Packt

Advanced Excel Course (Formula, VLOOKUP & Power Query)

By Apex Learning

50 Tips to Upgrade your Excel Skill

By Apex Learning

Diploma in Creative Graphic Design - QLS Endorsed (Level 5)

By Kingston Open College

Search By Location