180 Courses in London

Join us for a day of discussions and insights on EDI and the Six Stages Framework at our in-person event on June 28, 2024!     THE EDI ROUNDTABLE & SIX STAGES FRAMEWORK CONFERENCE 2024 Navigating & Challenging Everyday Racism and Discriminations. Embedding EDI into your Workplace & Schools Frameworks for Measuring Impact & Progress   Don't miss out on our Annual trailblazing event! Our pioneering event is back by popular demand. Empower your own self development and improve diversity and inclusion in your organisation or workplace. Check out testimonials from last year.   Tickets are now on sale. Only £30 including lunch!   Book now     https://www.eventbrite.co.uk/e/edi-round-table-event-and-the-six-stages-framework-conference-2024-tickets-884939155837?utm-campaign=social&utm-content=attendeeshare&utm-medium=discovery&utm-term=listing&utm-source=cp&aff=ebdsshcopyurl   Join Us In Creating a More Inclusive World.   Are you ready to dive deep into the complexities of equality, diversity, and inclusion? Have you ever wondered how different sectors can collaborate to enhance racial justice and belonging in our ever-evolving society?   Online agenda and details of speakers and panelists https://www.sixstagesframework.com/edi-agenda/   Check out our Speaker/Panelists and Hosts. https://www.sixstagesframework.com/edi-round-table-2024/   https://youtu.be/DDfQtNJsNKE https://www.eventbrite.co.uk/e/edi-round-table-event-and-the-six-stages-framework-conference-2024-tickets-884939155837?utm-campaign=social&utm-content=attendeeshare&utm-medium=discovery&utm-term=listing&utm-source=cp&aff=ebdsshcopyurl    Information for Schools https://www.sixstagesframework.com/schools/   What's Involved? This one-day event is not to be missed. We understand the challenges many face in embedding EDI (Equality, Diversity, and Inclusion) into the fabrics of their organisation.    The Six Stages Inclusive Framework helps organisation (and schools) go beyond performative measures: cultural celebrations, conversations about unconscious bias and white privilege to real action and implementation.    It supports evidence-based practice and data gathering, obtaining base line measures through the Six Stages Framework Diversity Assessments which enable you to chart your progress.   Who’s the Conference For? Corporate Organisations Schools & Local Authorities Health Services Higher Education Police and Criminal Justice Anyone passionate about EDI   An amazing venue!   The Conference will take place at St Martin-in-the Fields, Trafalgar Square, WC2N 4JJ on June 28th, 2024, set in the heart of London. Take a 3D tour of our venue here: https://my.matterport.com/show/?m=74N3JkZtuq4   Engage with Visionaries   Check out our Speaker/Panelists and Hosts. https://www.sixstagesframework.com/edi-round-table-2024/   Start your day with groundbreaking insights from leading experts. Our opening address and keynotes will set the stage for a series of powerful discussions, including:   Diverse Cross-Functional Roundtable: Engage with top professionals in a dynamic panel discussion, followed by an audience Q&A. Exclusive stimulating and thought-provoking conversation between the dynamic sister duo, Afua Hirsch: Award-winning writer, journalist, former barrister and filmmaker; and  Dr. Ama Collison: Millennial Psychology Limited. Networking Lunch: Connect with like-minded individuals and grow your professional network over lunch.  Afternoon Sessions: Dr. Shungu H. M'gadzah: will present a compelling keynote on "The Six Stages Framework: Understanding and Dealing with Everyday Racism.”  Exploring practical applications in various sectors and drawing from the SSF transformational toolkit.   Workshops: To consolidate and explore the days learning and make recommendations to be published in our annual report.   Who's Speaking? Dr. Shungu H. M'gadzah: Six Stages Framework & Inclusion Psychologists Ltd Dr. Ama Collison: Millennial Psychology Afua Hirsch: Award-winning writer, journalist, former barrister and filmmaker   Visit the wide range of market stalls and bookstore on display.  Explore the books from This is Book Love an award-winning collective and bookstore curating and showcasing and bringing together the best multicultural content the world of arts has to offer Schools, Nurseries, Public and corporate spaces www.thisisbooklove.com   Get Your Tickets Tickets are now on sale. Join us for our Annual trailblazing event! Only £30 including lunch!     Book now       https://www.eventbrite.co.uk/e/edi-frameworks-for-inclusive-organisations-measuring-impact-tickets-909290140287?aff=oddtdtcreator     https://www.eventbrite.co.uk/e/edi-round-table-event-and-the-six-stages-framework-conference-2024-tickets-884939155837?utm-campaign=social&utm-content=attendeeshare&utm-medium=discovery&utm-term=listing&utm-source=cp&aff=ebdsshcopyurl   Link for more Information & Testimonials about last year’s event: https://www.inclusionpsychologists.com/post/exploring-equality-diversity-and-inclusion-through-different-professional-lenses-the-six-stages-fr-2   For sponsorship opportunities or Market stalls contact Dr. Shungu at: drshungu@inclusionpsychologists.comor Dr Ama Dr. Ama Collison    Market stalls: We also have space for market stalls at a cost of £100 so if you know organisations who may be interested. Sponsorship: In terms of sponsorship, we are looking for any contribution to costs. We currently have one sponsor- Inclusivitti. https://www.inclusivitii.com/ Support with the event and donations Any help in publicising the event would be appreciated as well as any donations or sponsors. Organisers: https://www.inclusionpsychologists.com/ Dr Shungu H. M'gadzah, Six Stages Framework https://www.millennialpsychology.co.uk/ Dr Ama Collison: Millennial Psychology https://www.diversifyworld.com/ Mr Romain Muhammad: Diversify World Sponsors: Inclusivitti https://www.inclusivitii.com/ Venue: St Martin- in- the- Fields Here is the link to our online 3D tour. Take a 3D tour of our venue here: https://my.matterport.com/show/?m=74N3JkZtuq4 Best wishes,   Shungu   Dr Shungu Hilda M'gadzah Director & Lead Consultant Psychologist Inclusion Psychologists Ltd Tel: 07956 965 266   AUTHOR: Understanding & Dealing with Everyday Racism- The Six Stages Framework The Six Stages Framework Book   https://www.sixstagesframework.com   www.inclusionpsychologists.com  https://www.inclusionpsychologists.com/book-online   Psychology today directory https://www.psychologytoday.com/profile/774567   Follow me on twitter. https://twitter.com/DrShunguM   LinkedIn profile https://www.linkedin.com/in/shunguhildamgadzah/

This course provides detailed safeguarding adults & children awareness, including essential knowledge in the recognition and reporting of abuse and neglect, procedures and responsibilities. This is for all workforce involved in Social Care from the health, public, independent, or voluntary sectors. This subject forms standard 10 & 11 in The Care Certificate.

This course provides detailed safeguarding adults & children awareness, including essential knowledge in the recognition and reporting of abuse and neglect, procedures and responsibilities. This is for all workforce involved in Social Care from the health, public, independent, or voluntary sectors. This subject forms standard 10 & 11 in The Care Certificate.

Handset and/or Voicemail Training 1600’s, 1400, 96/95 series handsets, J Series and voicemail One X Communicator One-X Mobile IX Workplace Desktop and Mobile App Web Conferencing Collaboration System Administration Training up to Release 11 Voicemail Pro Administration Training ACCS Agent, Supervisor and Administration Training XIMA/CHRONICALL/ACR Agent, Realtime, Recording and Reporting

This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: Create tables Use functions Manage rows and columns Write formulas Manage sheets Use content formats Handle larger tables Create reports and charts 1 Creating a table Creating an Excel table from scratch Wrapping text in cells Speeding up data entry using AutoFill Sorting columns 2 Inserting function Inserting function calculators Using AutoSum to sum numbers Statistical calculations AVERAGE, MAX and MIN 3 Table rows and columns Inserting and deleting rows and columns Adjusting multiple column widths and row heights Hiding and unhiding rows and columns 4 Formula writing The basics of formula writing Understanding mathematical symbols Using multiple mathematical symbols in a formula When to use brackets Troubleshooting calculation errors 5 Managing sheets Inserting, renaming, moving and deleting sheets Copying a worksheet to another file Copying a table to another sheet 6 Managing content formats Applying data formats Managing number formats Controlling formats with the Format Painter 7 Managing larger tables Applying freeze panes to lock tables when scrolling Sorting on multiple columns Using filters to extract table information 8 Creating and modifying charts Creating a pie chart Creating a column chart Inserting chart titles and data labels Controlling chart formatting Changing chart types 9 Printing Previewing and printing tables and charts Modifying page orientation Adjusting print margins Printing a selection 10 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 11 Pivot tables Create a pivot table report Insert a pivot chart into a report

This very practical one-day IACCM-approved programme enables participants to manage the process of commercial contracting and contract management effectively and efficiently to ensure value for money, improved service, and appropriate relationships. It covers a wide range of contract types in terms of risk and value. The programme empowers participants with the tools and techniques needed to collaborate with all key stakeholders. By the end of the programme participants will be able to: Understand the total process of managing contracts Exploit opportunities to extract even more added value Develop appropriate relationships with contractors Understand and use a range of contracting strategies and options Measure and improve contract performance Understand the impact of legislation on contract performance 1 Welcome Introductions Aims and objectives Plan for the day 2 Contract management An overview of the contracting process, mapping the 'territory' 3 Contract managers Skills Knowledge Attributes Responsibilities 4 Critical success factors Defining successful outcomes Effective stakeholder engagement Creating a shared vision of the outcomes 5 Placing contracts How to develop an effective specification and scope of work documents How to develop a robust contracting strategy Appropriate types of contract 6 Customers and stakeholders Customer and stakeholder analysis Managing expectations and the 'shared vision' concept to ensure customer co-operation, satisfaction, and delight 7 Working with suppliers Creating and developing commercial relationships Types of relationship How to manage difficult relationships Contractor motivational issues How to use incentives 8 Negotiation and related skills Introduction to key negotiation skills Persuading and influencing skills to work with stakeholders to improve outcomes for all 9 Dealing with change Claims and variations How to challenge contractor claims and requests for variations by making use of contractual terms Specifications to prevent false claims 10 Performance improvement How to measure and improve contractor performance Developing KPI systems Using contractual terms and conditions and basic legal principles 11 Contract close The importance of effective contract close processes 12 Close Review of key learning points Personal action planning

This course starts with data transformation strategies, exploring capabilities in the Power Query Editor, and data-cleansing practices. It looks at the Advanced Query Editor to view the M language code. This course focuses on advanced DAX measures that include filtering conditions, with a deep dive into time intelligence measures. Like the M query language, DAX is a rich functional language that supports variables and expression references. This course also looks at the creation of dynamic dashboards and incorporates a range of visualisations available in Power BI Desktop and online in the AppSource. The course finishes with a look at setting up end user level security in tables. 1 The query editor Split by row delimiter AddDays to determine deadlines Advanced query editor 2 Fuzzy matching joins Matching inconsistencies by percentage Matching with transformation table 3 Logical column functions Logical functions IF, AND, OR Using multiple conditions Including FIND in functions 4 Editing DAX measures Make DAX easier to read Add comments to a measure Using quick measures 5 The anatomy of CALCULATE Understanding CALCULATE context filters Adding context to CALCULATE with FILTER Using CALCULATE with a threshold 6 The ALL measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentage 7 DAX iterators Anatomy of iterators A closer look at SUMX Using RELATED in SUMX Create a RANKX RANKX with ALL 8 Date and time functions Overview of functions Create a DATEDIFF function 9 Time intelligent measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 10 Visualisations in-depth Utilising report themes Create a heatmap Comparing proportions View trends with sparklines Group numbers using bins Setting up a histogram 11 Comparing variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint 12 User level security Setting up row level security Testing user security

The ability to influence others is a life skill but also one that has never been so critically useful at work. This one day workshop will set you on the road to discover what you need to be able to think and do that will help you take people with you. This involves learning some new tools and strategies that fit the situation you are in and making sure you use the right skills and behaviours to influence well, whether it is a single person or a room full of cynical expectant people! This workshop will enable you to: Learn about and understand influencing styles and strategies available and formulate plans and ideas on how to use them in influencing situations Understand which skills and behaviours to use to be the most effective influencer Have greater confidence in situations where they need to influence someone Use thinking, speaking and behavioural techniques that enable influencing to be effective and positive Review and evaluate learning and have an action plan to take back and implement in the workplace 1 Welcome, introductions & getting to know you and why you are here Course objectives 2 Personal objectives Introducing a learning diary 3 Gallery exercise - using images of exemplars brought by participants Plenary discussion The skills and behaviours of an exemplar influencer 4 Group task - what does your self-evaluation say? Discussion and conclusions 5 Influencing - what is it? - why do we need it? The current organisational landscape including values and behaviours the influencer operates in 6 Pit Stop - 'pull / push', 'the lost horse' and 'talking at' 7 Direct / support / delegate / coach: the different choices and approaches to choose from 8 Updating the learning diary 9 Power and types of power - its impact on influencing ability and approach and what is within your control Group task and discussion 10 The 5 influencing styles tool Series of tasks and exercises Drilling down to a personal action plan for maximising influence 11 'The person with the most flexibility has the most influence' Skills and behaviours for effective influencing Exercises and techniques that develop skills for influencing 12 Review and evaluation Action planning

This course is designed for those already using Power BI Desktop and are ready to work with more comprehensive elements of analysing and reporting in Power BI. The course maintains a balanced look at data analysis including the Power Query Editor, with a deep dive into writing DAX formulas, and enhanced dashboard visualisations. The aim of this course is to provide a more complete understanding of the whole Power BI analytics process, by working with business examples that will equip you with the necessary skills to output comprehensive reports and explore Power BI's analytical capabilities in more depth. 1 The Query Editor Grouping rows in a table Split row by delimiter Add days to determine deadlines The query editor 2 Fuzzy Matching Joins Matching inconsistencies by percentage Matching with transformation table 3 The Query Editor M Functions Adding custom columns Creating an IF function Nested AND logics in an IF function 4 DAX New Columns Functions Including TRUE with SWITCH Using multiple conditions The FIND DAX function The IF DAX function Logical functions IF, AND, OR 5 Editing DAX Measures Making DAX easier to read Add comments to a measure Using quick measures 6 The Anatomy of CALCULATE Understanding CALCULATE filters Add context to CALCULATE with FILTER Using CALCULATE with a threshold 7 The ALL Measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentages 8 DAX Iterators Anatomy of iterators A closer look at SUMX Using RELATED with SUMX Create a RANKX RANKX with ALL 9 Date and Time Functions Overview of functions Create a DATEDIFF function 10 Time Intelligent Measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 11 Visualisations In-Depth Utilising report themes Applying static filters Group data using lists Group numbers using bins Creating heatmaps Comparing proportions View trends with sparklines 12 Comparing Variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint

This one-day introduction workshop is intended for users who need to get to grips with the essentials of Microsoft Outlook. It will provide you with the basic skills you need to effectively start using Outlook to manage your emails, calendar, contacts, tasks and notes. This course will help participants: Send messages with added email options applied Quickly file messages away for safe keeping Manage messages and attachments Organise calendar meetings and check other people's schedules Respond to a meeting request Create a contacts list Manage daily tasks Use reading and folder panes Create and manage folders Use auto reply Use notes Utilise Outlook's printing functionality 1 Getting started Using the reading pane Using the folder pane Changing inbox views Managing the to-do bar 2 Emailing messages Replying to and forwarding messages Adding message options Attaching files to an email message Opening and saving attachments 3 Outlook folders Creating and managing folders Moving messages into folders Adding folders to favourites Using search folder Always moving messages in conversation Automatically move messages with rules 4 Managing messages Using instant search Finding messages by criteria Grouping and sorting messages Categorising messages Adding message follow up flags Filtering messages with the people pane 5 Using auto reply Replying to messages whilst you are away Managing auto reply settings Applying rules to auto reply 6 Outlook calendars Adding and editing appointments Adding calendar reminders Moving and copying appointments Creating all day events Recurring appointments Sharing your calendar Opening another user's calendar 7 Planning a meeting Arranging meetings Inviting attendees to meetings Responding to meeting invites 8 Outlook contacts Creating and editing a contact Saving emails as contacts Finding contacts Sending messages to contacts Creating contact groups 9 Adding tasks Creating and editing tasks Completing tasks Assigning a task to another user Responding to a task request 10 Notes Creating and editing tasks Emailing notes Sticking notes on your desktop 11 Printing Printing messages Printing calendars Printing contacts