🌟 Hypnotherapists’ Workshop Day: The Eazzy Slim System & The Hypnotic Gastric Band 🌟 Date: 21st of June | Location: Online (Zoom) | Time: 10 am till 4 pm Are you ready to expand your weight-loss toolkit with powerful, non-invasive techniques that create real and lasting change? Join us for an immersive one-day workshop where we’ll explore the full potential of the Eazzy Slim Programme — a structured, proven system designed specifically for hypnotherapists to help clients achieve sustainable weight loss without the need for medication or surgery. 🔍 What You'll Learn: The Hypno-No-Jab Approach: Discover how to offer clients a highly effective hypnotic alternative to pharmaceutical weight-loss injections like Mounjaro or Ozempic especially important given rising concerns over side effects, long-term use, and the controversial decision to make these drugs available to children. Hypnotic Gastric Band: Learn how to safely and ethically guide clients through a hypnotic gastric band process, mimicking the physical sensation and psychological impact of surgery without any of the risks. The Psychology of Sustainable Change: Explore how to leverage hypnotherapy to reshape beliefs, habits, and identity around eating, self-worth, and health. 🧠 Why It Matters: While medications like Mounjaro can offer temporary results, they often come with side effects, dependency risks, and rebound weight gain once stopped. Likewise, gastric band surgery, once a popular bariatric option, has seen a sharp decline due to its high rate of complications, reoperations, and limited long-term success. Our clients are looking for something different. Something safe. Natural. Sustainable. Empowering. That’s where you come in. 💼 Leave with a Complete Toolkit: Whether you’re working in-person, online, or offering remote packages, this workshop will give you everything you need to start delivering Eazzy Slim straight away, including: Session structure & protocols Client scripts and resources Marketing guidance for positioning your service as a credible alternative to jabs and surgery Q&A and practitioner support 👥 Who This Is For: Qualified hypnotherapists looking to specialise in weight management Practitioners concerned about the long-term health impact of pharmacological weight loss Therapists passionate about offering clients empowering mind-body solutions 🎟️ Secure your place today and become part of the solution. Places are limited to ensure an interactive, high-value experience.
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
Learn how to use Macros in Excel to automate your work and start to see the power these can give you. Course overview Duration: 1 day (6.5 hours) Our Excel – Working with Macros course aims to show how macros can be used to automate commonly used commands and processes. This course is designed for existing experienced users of Excel. You should be confident creating and manipulating Excel spreadsheets and creating formulas before attending this course. Objectives By the end of the course you will be able to: Record and run macros Navigate within the Visual Basic Environment Edit pre-recorded macros Create your own functions Content Recording macros Accessing the Developer Tab Naming conventions and storage locations Recording macros Absolute and relative cell addressing Running macros Assigning macros to the Quick Access Toolbar Assigning macros to objects Creating new tabs Workbook macros Recording macros in a specific workbook Saving the workbook as an Excel Macro-Enabled Workbook Creating quick access items specific to workbooks Importing and manipulating data Importing Delimited Text Files Importing Fixed Width Text Files The Visual Basic environment Project explorer Code window Properties window Renaming modules Deleting modules Working with code Code structure Adding comments Navigating within your code Editing macro code Getting help with syntax Debugging Errors Using debug Function procedures Creating function macros
Agile working is an approach that the NHS supports. It demands new ways of working and thinking. Agile means that work is now seen as an activity, not a place. People are the organisation. The way we communicate has to change. The way we manage has to change. This workshop will let you reflect on what works for you now and where you may need to adapt. You may need to trust and value your team more than ever, but when they aren't in front of you in the office, you will need to question your beliefs. The workshop will help you: Understand what Agile Working is all about Reflect on your management style Recognise the new ways of managing agile workers Choose the right communication methods Understand culture and mindset Identify different ways of measuring performance Focus on innovation and not bureaucracy Manage more effectively This workshop has been designed to support you in effectively managing an agile team. You will need to be open to questioning your existing techniques and be open and responsive to change. 1 What's it all about? What is Agile working? What are your personal management concerns? How to make it work Time / location / role / source 2 Your role as an Agile manager Your style Your team's individual preferences Learning to let go Your management style self assessment 3 The 3 areas of focus Trust Delegation Empowerment 4 Communicating effectively New ways of communicating Managing expectations What are you measuring? 5 Your personal action plan What are you going to do differently?
Duration 5 Days 30 CPD hours This course is intended for For Process Owners, project managers, and other managers who are new to Service Manager. Overview At the end of the course, you will be able to:? Describe the role and intent for each of theService Manager components.? Describe the processes, workflows, and keyactivities for each module.? Use the Service Manager Web and Windowsclient as well as the Employee Self Service portal.? Manage Service Manager operators, usingadministrative tools.? Review how to configure operator, profile, role,environment, folder, and contact objects.? Determine the difference between Incident andProblem Management.? Discuss the Change, Configuration, Knowledge,and Service Level Management processes.? Explain and configure the Service Catalog.? Use Request Management workflows.? Describe the reporting capabilities of ServiceManager. This introductory course provides students with the skills needed to effectively use and manage the Service Manager 9.x software product. This course focuses on teaching the processes embedded in Service Manager. This introductory course provides students with the skills needed to effectively use and manage the Service Manager 9.x software product. This course focuses on teaching the processes embedded in Service Manager. Additional course details: Nexus Humans SM110 - Service Manager 9.x Foundations for Process Owners training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. While we feel this is the best course for the SM110 - Service Manager 9.x Foundations for Process Owners 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. 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.
Duration 5 Days 30 CPD hours This course is intended for New users of HP OperationsManagement (OMi) 9.21, including:? IT Tools engineers? Operations staff? Operations managers? Availability engineers? System administrators? Network administrators Overview At the end of the course, you should be able to:? Use OMi to effectively identify, prioritize, andresolve events? Use OMi to prioritize operational activities based onan event?s impact on key business services? Create event dashboards to meet the informationneeds of specific users? Describe CI resolution and correlation? Identify the health of services and technologycomponents based on Health Indicators (HIs) andKey Performance Indicators (KPIs) presented in OMi? Create and use OMi performance graphs? Create and use OMi tools? Create and tune Topology Based Event Correlation(TBEC) correlation rules? Create and tune Stream Based Event Correlation(SBEC) correlation rules? Create and tune Time Based Event Automation(TBEA) automation rules? Create and tune event suppression rules? Manage OMi user access and permissions? Create and tune OMi notifications? Describe the deployment architecture and options? Configure integration between OMi and HPOperations Management (HPOM)? Configure integration between OMi and HPSiteScope? Configure integration between OMi and NP EndUser Management (EUM) This course is recommended for individuals who are responsible for designing, implementing, or administering effective service operations capabilities for mission-critical business services. This course is recommended for individuals who are responsible for designing, implementing, or administering effective service operations capabilities for mission-critical business services. Additional course details: Nexus Humans OMI120 - Operations Manager i Software 9.x Essentials training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. While we feel this is the best course for the OMI120 - Operations Manager i Software 9.x Essentials 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. 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.
Start from the ground up and learn tips, tricks, shortcuts and build confidence in using Excel.
Enhance your skills and learn how to use a range of advanced formulas and functions to manage and extract data more efficiently. There are some great ones here that will save a lot of time. Course overview Duration: 1 day (6.5 hours) Our Excel Module 4 – Advanced Formulas and Functions course looks at some of the more advanced functions of Excel that can be used to manipulate and extract data. This is an intensive one-day course and designed for experienced users of Excel. Participants should be confident in creating and using Excel and be able to build simple formula before attending. Objectives By the end of the course you will be able to: Use a range of Text functions to manage text data Create and use different types of date and time functions Work with rounding functions Use logical statements Build nested formula Use SUMIF, COUNTIF and AVERAGEIF Cross reference data from other worksheets using LOOKUP, INDEX and MATCH functions Use IS functions and IFERROR to test cell values Content Working with text Splitting text into multiple cells Merging data into one cell Extracting data using text functions Tidying data Working with dates and times Formatting dates and times Date and time functions Calculating date and time differences Using functions to round numbers up and down ROUND ROUNDUP ROUNDDOWN CEILING FLOOR Use lookup functions Lookup functions Creating a lookup table Range naming Using VLOOKUP Using HLOOKUP Using INDEX and MATCH Working with logical statements Creating an IF statement Using the AND plus OR functions Nesting functions Calculating values based on given criteria SUMIF(S) COUNTIF(S) AVERAGEIF(S) Using IS and IFERROR and test cell values ISBLANK ISNUMBER ISTEXT ISERROR IFERROR