54263 Courses

Learn the skills of being more confident and assertive in the workplace plus be able to influence people to do the things you would like them to do. Course overview Duration: 1 day (6.5 hours) This ‘Assertiveness and Influencing Techniques’ workshop is interactive and practical and facilitated by a subject matter expert via a virtual platform. Exercises and breakout rooms will be used during this training. Delegates are encouraged to login from a location where they feel safe to turn on their camera, use their microphones and engage in conversations as required. Objectives  The aim of this course is to introduce delegates to a variety of influencing skills and techniques to deal with aggression and challenging situations. These skills and techniques will improve confidence and personal effectiveness when working in groups / meetings. By the end of the course delegates will be able to recognise and define what assertive behaviour is and its benefits, the impact of non-verbal communication and how to use it to enhance influencing behaviours. Content What is influencing and assertiveness? Sources of power Influencing skills and choosing the right approach When to be assertive and alternative behaviours Assertive behaviour Behavioural styles and their impact on working relationships Identifying different behaviour types; assertive, aggressive, passive Building confidence and negotiating a win/win result Developing Skills Communication skills – the language of influence and communication dynamics Different influencing techniques and when to use them The art of saying ‘No’ - having the confidence to challenge Receiving criticism assertively and assertiveness behaviour analysis The language of assertion Meeting skills Giving and receiving feedback Dealing with confrontation, aggression and challenges in a confident manner Practical Exercises and Action Planning Practical exercises will be used throughout the training and the training will culminate with the creation of a personal action plan

Are you a manager in Early Years? Do you need some new skills to help manage your teams and be the best you can be? Then have a look at what this course covers and get in touch to book. Week 1. Exploring the role of a Manager in Early Years. Characteristics of an effective manager. Exploring different Leadership Styles and identifying your own. Looking after your own wellbeing. Week 2. How to manage difficult Conversations Exploring different personality types. Developing resillience. 4 Step process for managing a difficult conversation. Week 3. Creating Connection & Belonging within your team The importance of Connecting with a Diverse team. How to create a culture of connection & belonging. An introduction to Leading with Emotional Intelligence. We deliver this session on a one to one virtual platform or face to face. We can deliver to small groups but please contact us separately for costings. This specific course is for training one person at a time.

Master the some of the West End and Broadway’s favourite show tunes by joining our musical theatre singing courses. By attending, you can be assured to learn the correct techniques from day one and enjoy incredible singing lessons. Ideal for those who dream of being part of the show!

Ensure you can fully utilize this powerful tool to create a range of flowcharts and diagrams. Course overview Duration: 1 day (6.5 hours)  Microsoft Visio is a powerful tool designed to simplify complex information through the creation of simple, professional-looking diagrams. While Visio is capable of producing almost any type of drawing this training concentrates on flowcharts, swim lane process diagrams and organisation charts. You will also discover the real power of Visio by adding essential data to the content of your diagrams and producing reports in Excel using this data. This course is designed for either new users of Visio or those who have dabbled and can create basic diagrams. Our course will give you the skills and knowledge you need to navigate your way around this powerful program and produce different types of diagram. Objectives  By the end of the course you will be able to: Create and amend flowcharts Create cross functional (Swim Lane) process flows Produce organisation charts by importing data Add essential data to shapes Export diagram data reports to Excel Present, publish and print Visio diagrams Content Visio essentials Finding your way around Visio Using the ribbon and Quick Access toolbar Keyboard shortcuts Shapes and stencils explained What Visio can do for you Creating basic flowcharts Working with shapes Adding and deleting shapes Joining, aligning and sizing shapes Using Auto-Connect Labelling shapes and connectors Editing and improvinC flowcharts Amending shape and connector labels Using colours to emphasise Changing line styles Moving and copying objects Grouping diagram elements Quick ways of working Cross functional flowcharts Creating Cross-Functional Flowcharts Manipulating functional bands Creating off-page references within diagrams and hyperlinks to other documentation Organising charts and shape data Using the wizard to create an organisation Chart Importing existing Data into to create an organisation chart Modifying an organisation chart Shape Data Adding shape data to a shape Creating shape data sets Diagram reports Exporting data to a report in Excel Exporting to HTML Creating and customizing reports Presenting, publishing and printing Using Page Setup Print previewing Embedding backgrounds Adding headers and footers Converting your final documentation to PDF Saving as HTML Visio with PowerPoint

Learn how to create fully relational databases and how to input, extract and report on data. Course overview Duration: 2 days (13 hours) Our Access Database Design and reporting course looks at the key elements to building fully relational databases and entering and extracting information from them. This course is designed for new users who need to build relational database systems. Objectives  By the end of the course you will be able to: Create a new database Create data tables Set field validation and properties Enter data and manage data Create forms Use queries to extract data Create parameter queries Create calculations in queries Build relational databases Use sub datasheets Build multi table queries Use advanced form and report design techniques Content Creating a database Creating a new database Database elements Creating a data table Setting field properties Using input masks Using input masks Validation rules Default values Setting a primary key Creating lookup fields Data entry Adding data Deleting data Quick keys for data entry Working with data Sorting data Filtering data Finding information Navigation Creating data form Creating quick forms The form wizard Amending forms Formatting Setting the tab order Entering data using forms Creating queries Creating a query Setting criteria Using the expression builder Creating parameter queries Using wildcards Using more than one parameter Using calculations in queries Adding a totals row Formatting results Adding calculations Printing and reporting Printing tables and queries Creating reports Building and amending reports Adding headers and footers Working with relational databases Relational database principles Importing data from other sources Linking information between tables One-to-one and one-to-many links Defining referential integrity Amending links Deleting links Sub datasheets Viewing a subdatasheet Removing a subdatasheet Connecting a subdatasheet Multiple table queries Deciding which tables to use Adding tables to the query Creating links between tables Setting join properties Advanced form design Field properties Creating lookup fields Adding calculated fields Applying conditional formatting Advanced report design Field properties Report properties Alternate colour bandings Concatenating fields Adding calculated fields Sorting and grouping Grouping settings Adding headers and footers Adding dates, times, page numbers

NPORS Quick Hitch Awareness (N034)

This Emergency First Aid at Work (RQF) Level 3 Award qualification is designed for individuals who wish to act as an emergency first aider in their workplace. This Level 3 Award (EFAW) course is fully accredited and is statutory qualification specifically designed for individuals who wish to act as an emergency first aider in their workplace. This Emergency First Aid at Work Qualification is regulated by Ofqual. Course venue: Partnership for Learning Training and Conference Centre South Road Speke Liverpool L24 9PZ Emergency First Aid at Work Training Liverpool – Course Dates for 2023 Friday 21 April 2023 Thursday 25 May 2023 Thursday 29 June 2023 Thursday 27 July 2023 Thursday 31 August 2023 Thursday 28 September 2023 The Cost for the Emergency First Aid at Work ‘Open Course’ per delegate is only £98.00 +Vat. First Aid Courses in Liverpool – Call Dan or Mark on 0151 515 0416 for further details or to secure your first aid course. First aid courses Liverpool and surrounding areas – You can be assured that you are meeting your First Aid Training requirements by attending this course which is Ofqual regulated. To see our 3 Day First Aid Courses in Liverpool please click the link below: 3 Day First Aid at Work Training in Liverpool

This Emergency First Aid at Work (RQF) Level 3 Award qualification meets the requirement of the Health and Safety (First Aid) Regulations 1981, where a person is required to become a qualified ‘First Aider’ (EFAW) in their workplace.

Expand your VBA knowledge further and learn some of the more advanced coding features. Course overview Duration: 2 days (13 hours) This course is aimed at experienced VBA users or those who have attended our Part 1 course and have started to use the language. Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models Objectives  By the end of the course you will be able to: Use comparison operators and system functions Use Arrays Work with ranges Work with the worksheets and workbooks collections and objects Use application objects Use the FileSystemObject Create function procedures Import and save text files Connect to other applications Content Comparison operators Using Comparison operators and functions The LIKE function Wildcards Using SELECT Case System functions The VAL function Case functions Trim functions Text functions Date functions Excel worksheet functions Using Excel functions in VBA Arrays Creating arrays Using arrays Ubound and Lbound Single and multi dimensional arrays Static vs dynamic arrays Working with ranges Creating range objects Passing data between range objects and arrays Using Transpose The Excel object model The object browser Working with collections Collections Creating object variables Setting object variables The For Each . . . Next Loo Sheet collections The worksheets collection The worksheet object The sheets collection Using object Grouping worksheets Using Typename The Workbook collection The workbooks collection Setting workbook variables Application objects Excel default information Display/alerts Screen updating Status bar On Time Using Wait Systems dialog boxes Showing dialog boxes Using dialog boxes Working with files Searching for files and folders The DIR function The FileSystemObject Function procedures Creating functions Adding arguments Calling functions Working with text files Searching for files and folders The DIR function The FileSystemObject Using the FILE and FOLDER collections Sharing data with other applications Early vs Late Binding Setting references to other applications Creating application variables Setting application variables

At times, everyone involved with a business will find themselves in a position where they are faced with difficult decisions. Being able to deal with these situations effectively and confidently is an important interpersonal skill. This is especially true for managers who will be forced to make tough decisions on a regular basis, but need to ensure that the business continues to perform both during and after the difficult decisions have been made. The manner in which they approach and implement these decisions can sometimes be the difference between success and failure. Course SyllabusThe syllabus of the Dealing with Difficult Situations with Confidence course is comprised of four modules, covering the following: Module OneSelf Awareness Attitude towards challenges - self-resilience Going into a challenging scenario - how to prepare Recognising the signs of contention Giving feedback constructively Module TwoHaving Difficult Conversations with Confidence Behaviour labelling - preparing the approach Assertiveness techniques Dealing with a difficult issue focussing on behaviour & consequences Keeping objective and professional throughout Module ThreeExamining Your Preferred Communication Style Recognising the different communication styles Analysing your preferred style - Paradigm FitIn Profiler review Identifying the most appropriate situations for each style Module FourHelpful Interpersonal Skills Effective questioning techniques Active listening Body language Recognising and dealing with behaviours Displaying and creating positive attitudes Remaining Assertive and in control