308 Bar courses in Cardiff delivered Live Online

Better Business Cases™ Foundation: Virtual In-House Training Better Business Cases™ is based on the Five Case Model - which is the UK government's best practice approach to structuring spending proposals and making effective business decisions. Using this best practice approach will allow organizations to reduce unnecessary spending and improve the decision-making process which gives you a greater chance of securing necessary funding and support for initiatives. The goal of the foundation course is to enable participants to work effectively with a team to develop a strong business case in their work environment. What You Will Learn At the end of this program, you will be able to: Describe the philosophy and the underlying rationale of the Five Case Model Identify different types of business case, their purpose, who is responsible for them Recognize when the different types are required in the development of a spending proposal Develop the business case in relation to other recognized and recommended best practices for programme and project management Overview of the Five Case Model Five key components of a business case and the order in which they are presented Three key stages in the development of a spending proposal Definition of a programme / project and the key differences between programmes and projects Purpose of a Business Justification Case (BJC) and in what circumstances it should be considered Purpose of a Strategic Outline Case (SOC) Purpose of an Outline Business Case (OBC) Purpose of a Full Business Case (FBC) Relationship between policies, strategies, programmes, and projects and their deliverables Developing the Strategic Case Purpose and core content of a Strategic Case Purpose of SMART robust spending objectives and the key objectives for spend: economy, efficiency, effectiveness, re-procurement, and statutory or regulatory compliance Four main categories of benefits criteria and the parties involved in their development Three key categories of risk Purpose of identifying constraints and dependencies Difference between direct and indirect benefits Developing the Economic Case Purpose and core content of an Economic Case Purpose of critical success factors and the key critical success factors based upon the Five Case Model Purpose of the long list options and how to generate options and undertake SWOT analysis Minimum of four short-list options, how they are derived, and what they should include (Reference Project / Public Sector Comparator [PSC]) Difference between the preferred way forward and the preferred option Purpose, objectives, key participants, and outputs of Workshop Stage 2 - identifying and assessing the options Rules that should be followed for the treatment of costs and benefits Key differences between economic appraisals and financial appraisals Factors considered when selecting the preferred option Developing the Commercial Case Purpose and core content of a Commercial Case Guiding principles when apportioning risk between the contractual parties Purpose of payment mechanisms Purpose of Step 9 in the development framework: Contracting for the deal Developing the Financial Case Purpose and core content of a Financial Case The financial statements required for all projects The possible impacts to consider Developing the Management Case Purpose and core content of a Management Case Purpose of a programme / project management strategy, framework, and plan Purpose of a change management strategy, framework, and plan Purpose of a benefits realization strategy, framework, and register / plan Purpose of a risk management strategy, framework and register / plan Purpose of a post programme / project evaluation strategy, framework, and plan

Microsoft Excel® in Depth: In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

The package includes the following: Reshaping relationship narratives through therapy Empowering stories in couples therapy Rediscovering connection with Narrative Therapy Exploring alternative perspectives in relationships Overcoming communication barriers through narrative approach Transforming relationship narratives Authentic and empowering couples therapy program Invest in the future of your relationship today and experience the power of Narrative Therapy. Our compassionate therapists are dedicated to guiding you and your partner towards a more authentic, empowering, and fulfilling connection. Take the first step towards transformative change by scheduling a session with us now. 3 x 1 hour https://relationshipsmdd.com/product/narrative-therapy-package/

Access affordable mental health support with low-cost counselling in London. Our qualified counsellors offer budget-friendly therapy sessions to help you through difficult times, including stress, anxiety, depression, and more. We believe that financial constraints should not be a barrier to receiving quality mental health care, and our services are designed to provide effective support at a manageable cost. Key areas: affordable therapy, budget counselling, cheap counselling, cost-effective therapy, economical mental health support, low-cost therapy, financial counselling support. 3 x 1 hour sessions

This one-day course introduces the field of user experience and provides an excellent entry point to our other specialised training courses. UX processes and practices have become a central component of product design, service design and web design.

This one-day course introduces the field of user experience and provides an excellent entry point to our other specialised training courses. UX processes and practices have become a central component of product design, service design and web design.

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Definition of Safeguarding Legislation & agreed ways of working Definition of Safeguarding Legislation & agreed ways of working Every child matters guidance Myths and statistics Effects on young people Leadership/worker skills Common indicators of abuse Reporting of abuse and potential abuse Barriers to reporting abuse Understanding the types of abuse Recognising acts, signs and symptoms of abuse Who is vulnerable / at risk The role of dignity in safeguarding Legislation and policies and procedure What to do should you have a concern Overview of prevent How to respond to an individual should they disclose a concern

Join me over the next 10 weeks to unlock your full potential. Overcoming your day-to-day challenges without procrastination, without losing determination and making better decisions to improve your life! Program Details Module 1 (2 weeks) ✔ Wheel of life ✔ Your learning style ✔ Daily practice tools ✔ How to love and accept yourself Module 2 (3 weeks) ✔ Be self-aware of your inner critic ✔ Connecting with your true self ✔ Crush self-doubt ✔ Transform your inner critic  Module 3 (3 weeks) ✔ Create more energy in your life ✔ Create balance and purpose ✔ Maximise productivity ✔ Create your self care plan  Module 4 (2 weeks) ✔ Build the courage to step up ✔ Playing big ✔ Empowering affirmations ✔ Create your vision and implement it After completing the 10-week group programme, you will: • Be more resilient • Meet your challenges with confidence • Achieve your goals with clarity • Truly SHINE and be your authentic self My session with Pinky allowed me the time to ‘think out loud’ all the factors that were in play and my feelings towards them. She then worked out the barriers I was experiencing and seamlessly worked through them with me. She then gave me tools to continue to work past those barriers with some very achievable goals! I instantly felt like I had a better perspective on this change and felt less chaotic in my thoughts. Thanks, Pinky! - Gemma (Edinburgh)

Women in Healthcare Leadership Workshop Our Aims For This Workshop: Become clear about your leadership style and philosophy. Understanding how to navigate yourself and your team in a VUCA environment. How to communicate with presence and impact. Topic 1 Foundations For Effective Leadership Develop your leadership story – (know yourself) Your values, influences and leadership philosophy Clear vision and purpose as a leader Adapting style to suit the context Topic 2 Leading Through Rapid Change (Uncertainty) Exploring the VUCA environment (Volatile, Uncertain, Complex, Ambiguous) Understanding the psychological process of change Resilience and stress management Topic 3 Communication Skills For Influential Leaders How to prepare to be present so you have a presence Explore and understand your own innate communication style Importance of voice, pace, trust, and rapport THE FACILITATOR Ruth Sangale Ruth has 20 years HR and OD experience in the public and private sectors, leaving the NHS in 2012 to set up her own business “Enjoy Work” and specialise in Creative Leadership development and executive coaching. She works internationally coaching and running residential leadership programs for global organisations such as UNICEF, WHO, UN Women, and PLAN International and charitable NGOs in a range of countries including, Afghanistan, Brazil, India, Kenya, and Belize. In the UK she designs and delivers workshops for mostly the NHS, on topics such as career development, resilience and positive psychology, feedback skills, coaching skills for leaders and team development. She is an ICF-accredited coach and has an M Sc in Innovation, Creativity and Leadership. In her work she uses creative tools such as drama, visualization, drawing, mindfulness and storytelling to stimulate creative thinking and develop leadership capability. She has two daughters and in her free time loves hiking, climbing mountains and salsa dancing. THE PANEL Sam Foster - Chief Nursing Officer - Oxford University Teaching Hospitals Sam joined the Board of Oxford University Hospitals NHSFT in September 2017 as an experienced Chief Nurse who previously worked at the Heart of England NHS Foundation Trust where she held the role of Chief Nurse for four years. Sam has also worked in a number of Trusts in clinical, operational and educational roles. Sam's portfolio includes the professional leadership and education of over 5,000 Nurses, Midwives and AHPs. In addition to the Executive leadership of the Trust Facilities and PFI Services, she is accountable for the Estates and delivery of the capital program. Sam leads the Urgent Care program across the Oxfordshire system. Avey Bhatia - Chief Nursing Officer - Guys & St Thomas’ NHS Trust Avey Bhatia is Chief Nurse at Guy’s and St Thomas’ Trust. Avey returned to the Trust as Chief Nurse in November 2020, having trained as a critical care nurse at St Thomas’ in the early part of her career. Avey qualified in 1991 and her clinical experience includes theatres, general intensive care, coronary care and cardiothoracic nursing. She held various staff nurse and sister posts at hospitals in London before becoming Chief Nurse and Director of Infection Prevention and Control at St George's University Hospitals NHS Foundation Trust in 2017.  Avey holds a postgraduate diploma in health services management and a Masters in Public Administration. She is also the Trust’s Director of Patient Experience, and the executive lead for adults’ and children’s safeguarding, and for infection, prevention and control. Beyond Guy’s and St Thomas’, Avey is Vice President for the Florence Nightingale Foundation and Honorary Vice President of The Nightingale Fellowship. She is a Trustee for the St John of Jerusalem Eye Hospital Group.  Caroline Alexander CBE - Group Chief Nurse - Barts NHS Trust Caroline graduated as a nurse in 1987 from Edinburgh University (BSc/RGN) and has an MSc in Nursing Studies from South Bank University (2001). From 1987 to 1993 she specialised in nursing older people in Edinburgh and then London at Guy’s Hospital as a ward sister. Caroline then worked for the Foundation of Nursing Studies for three years supporting nurses to use research in practice. In 1998 Caroline returned to the NHS and worked in Tower Hamlets in a range of roles within older people’s services. In 2005, Caroline took up her first Director post, as Director of Nursing and Therapies within Tower Hamlets PCT. With the clustering of PCTs in London in 2011, she took on the Director of Nursing and Quality within NHS East London and the City initially and then within NHS North East London when the clusters merged in 2012. until she joined NHS England as Regional Chief Nurse for London in April 2013. Caroline took up her current role of Chief Nurse for Barts Health in March 2016. Caroline was a 2008 Florence Nightingale Leadership Scholar and has been awarded Honorary Doctorates from City, University of London in 2017, Middlesex University in 2018 and University of East London in 2021. She is a Trustee of the Foundation of Nursing Studies. In 2020 she was made a CBE in the Queen’s Birthday Honours. Who will attend? Emerging Leaders looking to step into management roles Current Leaders looking to progress into senior management roles This workshop is open to any woman who works in health care and wants to take her next step in their career; women include trans women and non-binary people who are comfortable in a female-centered group. Group Rate Discounts 2-3 people, 7% discount 4+ people, 20% discount We have two group rates which you can take advantage of depending on the size of the group you wish to book: Option 1️⃣ Groups between 2 & 3 are eligible for the 7% Discount. Please use this code at checkout: GROUP 2+  Option 2️⃣ For groups of over 4+ attendees, the eligible discount is 20%. Please use this code at checkout: GROUP 4+  Where do I add the discount code?