5413 Courses delivered Live Online

An in depth look at Pivot Tables and their powerful features to summarise and visualize your data. Course overview Duration: 1 day (6.5 hours) Our Excel – Pivot Table Specialist course is a comprehensive guide to working with Pivot Tables for those who need to learn more about the use of Pivot Tables to summarise and analyse information. This course is designed for existing experienced users of Excel. You should be a confident Excel user and be able to create and edit worksheets and write basic formulas. Objectives By the end of the course you will be able to: Build and customise Pivot Tables Group and sort information Filter information Use slicers and the timeline filter Add different summary calculations Create Pivot Charts Add calculated fields and items Content The anatomy of a Pivot Table Using a Pivot Cache Building a Pivot Table The Pivot Table interface Refreshing the Pivot Table Adding column, row, page and data fields Changing data orientation Showing data fields in columns or rows Drilling down to underlying data Setting Pivot Table options Format options Totals and filters options Display and printing options Data options Customising Pivot Tables Modifying field names Data formatting Changing field layout options Changing summary calculations Working with subtotals Filtering and sorting Filtering items Sorting data Value and label filters Creating top 10 reports Using the Search filter Using the Slicer tool Use the Timeline filter Grouping Grouping date fields Grouping numeric fields Adding your own groups Summary calculations Running totals Differences year on year, month on month % Differences year on year, month on month % of Row, Column, Total and other fields Pivot charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Adding calculated fields Adding calculated items

Unveil Africa’s political future: Dive into colonial legacies, state-building challenges, democratization efforts, the African Union’s influence, and emerging great power rivalries. Discover sharp, insightful takes on contemporary African politics.

Explore "International Security in a Changing World" through live online learning. Join expert-led sessions to understand global security dynamics, emerging threats, and strategic solutions in an interactive, real-time format. Enroll now to stay informed and engaged.

Face to Face training customised and bespoke. One to One Online or Face to Face

Teaching EFL + Proficiency trains students/EFL Teachers in techniques for English Language Teaching and to raise their level of English to Proficiency.

Learn how to channel your inner activist, increase your resilience, communicate directly and be happy not to take no for an answer.

Join our Home Office Audit course to gain the expertise needed to navigate Home Office compliance and audit visits successfully. Prepare your organisation for compliance excellence with our comprehensive training Contact our legal team for more information and to learn more about our immigration training courses. Our Home Office Audit Training is designed to empower HR professionals, employers, and businesses with the knowledge and skills necessary to confidently handle compliance checks and excel during audit visits. Whether you’re new to compliance or looking to enhance your organization’s audit readiness, this comprehensive course covers the full spectrum of Home Office audits. From identifying triggers for compliance checks to post-audit follow-up and consequences, we provide practical insights and strategies for success. By the end of this training, you will be well-equipped to navigate Home Office compliance and enforcement visits with confidence. Gain the knowledge and practical skills necessary to ensure your organisation’s compliance, excel during audits, and effectively address any audit matters that may arise.   Course joining links, materials and instructions are sent out 24hours before the course starts. Why Study with Immigration Advice Service? Immigration Advice Service has been providing professional immigration services for over 10 years in the public, private and corporate sectors. Our fully qualified and OISC regulated trainer will guide you through the process and ensure you are competent with elements covered within the course. Course Content: Overview of Home Office Compliance and enforcement visits Identifying triggers for compliance checks What the audit visit entails – format & scope Key focus for Home Office Audit Common questions asked at audit visit Practical tips to attend Post audit follow up and consequences

Course Overview: Introduction to COPD in Primary CareThese introductory days are tailored for nurses and other healthcare professionals who are new to the realm of COPD care or have not received formal training in this area. Led by Paula Matson, a Respiratory Specialist and Practice Nurse, the program is designed to build a foundational understanding of COPD and empower participants to provide effective care to COPD patients in primary care settings.These introductory sessions offer a comprehensive journey from the fundamentals of COPD understanding to a confident approach in patient review and management, emphasizing the importance of early intervention and holistic care in primary care settings. Learning Outcomes: Upon completion of this Introduction to COPD course, participants will attain the following learning outcomes: 1. Emphasize Early Prevention: Recognize the significance of early prevention in COPD management and its impact on patient outcomes. 2. Grasp COPD Physiology: Develop a foundational understanding of the physiological underpinnings of COPD, aiding accurate assessment and care. 3. Comprehend Medications and Roles: Acquire knowledge about COPD medications, comprehending their diverse roles in managing symptoms. 4. Non-Pharmacological Management: Understand and appreciate non-pharmacological approaches to COPD care and symptom management. 5. Inhaler Proficiency: Gain expertise in managing various types of inhaler devices, ensuring effective medication delivery. 6. Documentation Proficiency: Understand the importance of meticulous documentation, including utilizing templates for streamlined care. 7. Review and Self-Management: Realize the value of regular patient review and supervised self-management plans for COPD patients. 8. Problem Solving and Solutions: Foster discussions to address relevant practice issues and collaboratively discover effective solutions. 9. Commitment to Ongoing Development: Recognize the importance of continuous professional development in the evolving landscape of COPD care These introductory sessions offer a comprehensive journey from the fundamentals of COPD understanding to a confident approach in patient review and management, emphasizing the importance of early intervention and holistic care in primary care settings.

Learn how to create a digital and data transformation strategy, using system thinking.

So often change fails because of our own pursuit of perfection. Learning to love imperfect change will improve your resilience and help you deliver positive change.