2569 Courses near Billingshurst

Unlock the Power of Teams: Elevate your leadership with our Building and Leading Effective Teams course. Learn the art of collaboration, communication, and synergy to create high-performing teams that drive success Course overview Duration: 1 day (6 hours) Everyone works in teams today in one way or another. Whatever we do in the workplace we need to interact with another person or a number of people at various times. It is important that we know how to communicate, how to listen, how to work together and how to overcome conflict when it arises in our workplace. Challenges are often created by a lack of trust, poor conflict handling skills, a lack of shared vision and confusion over roles and responsibilities. This course will help delegates understand how to encourage more productive team working in the workplace. By the end of the course delegates will be able to describe what makes a High Performing Team and realistically assess their current strengths and weaknesses. Delegates will also be able to identify and plan behavioural changes that will improve the team’s performance. The course is experiential based with lots of learning by doing activities, reflecting and discussion. This will allow team members to get to know/improve their knowledge of team colleagues and energise or re-energise teams. Objectives  Know more about their colleagues Be able to describe what makes a high performing team Understand the importance of playing to different strengths and skills Recognise the need for clear and effective communication Content The Importance of Team Work The importance of teamwork The ‘third dimension’ – how working together has the potential to achieve more The dangers of an overly competitive workplace culture Psychological Safety Team Development Models Stages of Team Development Behaviours at each stage Dysfunctional Teams – what does good and bad look like Characteristics of high performing and elite teams Teaming and Leadership Skills Teaming competencies Active Listening Proactive Language Values and Beliefs Building Mental Fitness of Teams Becoming an inspirational leader Establishing a climate of psychological safety Team Challenges The importance of Accountability The Team Charter Smart Teams:Building TrustBuilding CollaborationOvercoming ConflictGaining CommitmentDeveloping Shared Goals The importance of shared goals Effective Team communication

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

Learn the proper way to use PowerPoint and the background features that can make a real difference. Course overview Duration: 1 day (6.5 hours) Our PowerPoint – Professional Presentations course looks at creating professional, business focussed presentations quickly and easily. It ensures delegates are aware of the key concepts in using the tool such as slide masters and by the end of the day you will be able to create and run high quality presentations. This course is designed for new and existing users of PowerPoint who want to get the best out of the tool. Objectives  By the end of the course you will be able to: Create a new presentation Amend the slide master/template Create text slides Animate text on slides Insert pictures and objects Set object animation Insert and work with SmartArt Create charts Run a presentation Content Creating a new presentation Creating a new presentation from a template Using your company template Changing slide layouts Copying, deleting and inserting slides Using the slide master Modifying the Slide Master Using Slide layouts Multiple Slide Masters Slide dates, footers and numbers Creating text slides Working with bullet points Setting spacing Changing text and bullet styles Using Outline view Text animation on a slide Slide titles Bullet points Applying animation to the Slide Master Animating text Slide titles Bullet points Applying animation to Slide Master Drill Down vs Drill Through Review of drill down Creating drill through pages Using drill through Inserting and working with pictures Inserting pictures Inserting online pictures Formatting pictures Adding Drawings Inserting lines and shapes Using Quick Styles Selecting and grouping objects Aligning and positioning objects Add text to a shape Duplicating objects Object animation Simple object animations Working with SmartArt Inserting SmartArt Graphics SmartArt formatting Converting text to SmartArt Inserting charts Creating a slide with a graph Changing chart types Setting chart options Graph animations Presenting your presentation Slide show settings Using Presenter view Using the PowerPoint viewer Slide show presentation tips

Understand and explore what you and others do that develops and destroys working relationships. Course overview Duration: 2 days (13 hours) This is an exciting opportunity to dive into the very heart of human behaviour as we encourage you to explore what you and others do that develops and destroys working relationships.  We start by getting you to determine where in your working life you need to develop effective relationships before guiding you through a process of analysing personalities and behaviours and then giving you the skills to create and maintain great relationships.  Objectives  By the end of the course you will be able to: Create a stakeholder map and analyse which relationships need to be developed Describe different personality types and how these can cause connection and conflict Develop behaviours that help build relationships Bring more assertiveness to your relationships Have courageous conversations and handle conflict should it occur Content Getting started The benefits of great working relationships Determining what you want specifically from your relationships at work Developing a stakeholder map to enable you to analyse who you need to build relationships with and how you might do this Defining your personal brand How your personal brand could impact relationships Understanding others Exploring different personality types Understanding how others are both similar and different to you Identifying when personality differences might cause conflict Better Behaviour Exploring the concept of transactional analysis How transactional analysis can help to build or break relationships Understanding life positions How life positions impact your behaviour and that of others How to use transactional analysis in creating better relationships Developing Relationships Understanding the common ways poor communication can cause problems in relationships Developing assertive communication Making human connections at work in order to build better relationships and create trust Maintaining Relationships Recognition and Tiny Noticeable Things How to have courageous conversations e.g. giving feedback A model for handling conflict when it occurs

Understand what diversity and inclusion is and how to manage it affectively in the workplace. Course overview Duration: 1 day (6.5 hours) Diversity and Inclusion in the workplace will help you develop an understanding of why diversity and inclusion is important to a business, what it is and how individuals and teams can work effectively together and harness the power that comes from valuing diversity and promoting inclusion. Objectives  By the end of the course you will be able to: Describe why diversity and inclusion is important in teams and organisations Explain and overcome unconscious bias and other beliefs that cause exclusion and impact the workplace Recognise your own diversity and understand the value of diversity and inclusion in teams Develop an Action Plan to create an inclusive work climate Content Understand Diversity and Inclusion What the Equality Act 2010 says about diversity Understanding protected characteristics Learn how to create an optimum climate to unlock the power of a diverse teams Understanding Yourself and Unconscious Bias Identify your own unique characteristics and how these could impact your performance Examine self-limiting beliefs and how these can impact personal performance Experience how unconscious bias impacts our information gathering, problem solving, judgement and decision making Creating a Diverse and Inclusive Team Climate Understand the importance of respect, the role of trust and what valuing diversity really means Apply the ABC Model to the creation of a diverse climate:Awareness – be alert, self-aware and aware of othersBoundaries – understand how things can go wrong when working with others: boundaries, banter and bullyingCoaching – learn listening and coaching skills to promote inclusion Create an achievable, personal action plan that can be applied immediately in the workplace to improve diversity, promote teaming and create an inclusive work climate

Learn how to use Master Projects and Resource Pools to create better visibility across projects. Course overview Duration: 4 hours This course shows you how to create Master Projects allowing you to roll several sub projects into a master view. It also shows techniques to create resource pools to share resources between projects to enable you to better manage your resource teams and check resource loading. This half day course looks at how to practically do this and setup both elements. This is aimed at existing users of Microsoft Project who need to create master schedules and share resources and loadings. Objectives  By the end of the course you will be able to: Create master projects Insert and update sub projects Create a resource pool Share resources between projects Check resource loadings between projects Content Working with multiple projects Consolidating projects Linking to sub projects Setting the master project as read only Saving consolidated projects Working on consolidated projects Setting task links between projects Getting source project information Removing projects from the consolidation Sharing resources Creating a resource pool Sharing resources Opening projects that share resources Updating the resource pool Refreshing the resource pool Opening a resource pool Removing resource sharing

Learn how to create a mail merge in Word to allow you to send personalized emails to groups of people. Course overview Duration: 2 hours This course looks at how you can create a list of contacts with emails and then build a document to email out to everyone. This ensures that everyone gets a personal email but no one else sees the recipients. Objectives  By the end of the course you will be able to: Create source data to use in a merge Create a document to email out Attach source data contacts Filter recipients Send out emails to all Content Creating source contact data Creating your source data in Excel Creating a Word mail merge document Starting a mail merge document Attaching your source contact data Building the document Emailing your document Previewing the results Running a test to a document Setting up any filters Sending your document to emails

Learn a range of tools and techniques to boost your resilience and facilitate sustained performance in stressful times. Course overview The aim of this session is to equip all employees with a range of tools and techniques to boost their resilience and facilitate sustained performance in stressful times.  Objectives  By the end of the course you will be able to: Have a deeper understanding of mental health and application of mindfulness tools Use techniques to manage anxiety and attentional control apply techniques to improve attention stay focussed on key daily goals and manage their wellbeing. Content Boost your resilience. Explain the PERMA Model. Apply tools and techniques to boost your resilience. Learn how to measure your resilience and discover where to improve. Apply resilience building techniques for Mental Health Reducing stress through mindfulness techniques. Apply tools and techniques to manage anxiety and guide relaxation. Explain the psychology of achieving a balanced connection and living with purpose. Apply mindfulness techniques for balance and flow Focusing techniques to improve productivity. Apply techniques to attention control and learn how to be fully present and in the moment. Apply practical tools and techniques to stop distraction, improve focus and manage fear and fatigue

Develop the commercial awareness, financial knowledge and strategic thinking capabilities, to influence the direction of the business Course overview Duration: 2 days (13 hours) This course is aimed at managers who want to develop their commercial awareness, financial knowledge and strategic thinking capabilities, so that they can influence the direction of their business and deliver to their full potential. Day one of the course provides the skills and insights to make sense of your company’s financial position and performance. Day two helps delegates to consider the strategic thinking tools required to plot the forward course needed to maximise the potential of the business. As well as looking at how to make effective business decisions, this course gives a good grounding in finance and profitability. As a two day programme, day one provides the skills and insights to make sense of the company’s financial position and performance. Day two then considers the strategic thinking tools needed to plot the forward course needed to maximise the potential of the business. Objectives By the end of the course you will be able to: An understanding of the balance sheet, profit and loss account, cash flow and statutory and management accounts Learnt to correctly employment key financial ratios to analyse your business A practical definition of strategy analysis tools to examine the current environment and capabilities Steps to devise a mission and vision statement Recognition of the skills and resources needed to achieve the vision Generation of appropriate strategic and tactical commercial objectives Content What is Strategy Defining Strategy Strategic thinking Strategic models Commercial thinking – what is money? Where are we now STEEPLE analysis SWOT Analysis P&E forces at work Political distortions in capitalist markets Where are we trying to get to Setting the mission and vision Creating a BHAG Strategies for deflation and inflation The role of banks Commercial and investment banking Fractional reserving Securitisation How to get there Skill gap analysis Business Process Re engineering The role of creativity How to get there Getting the team on board Individual and team motivation The power of the brand Overcoming challenges Debt and deleveraging Change management Creating value Discounted Cash Flows Building the business case Asset Valuation techniques Making it happen Turning Strategic Thinking into Strategic Plans Scenario planning for an uncertain future Creating commitments and lock in Discussion and review Time will be set aside during the course for review sessions with time for questions, answers and action learning.

Use some of the hidden statistical analysis tools within Excel to build complex data models. Course overview Duration: 1 day (6.5 hours) This advanced Excel course looks at some of the statistical analysis tools available and gives examples of when they might be used. This course is aimed at advanced users of Excel who work with statistical data often and have a good knowledge of Maths. Objectives By the end of the course you will be able to: Use Goal Seek Create and view scenarios Use Forecast Sheet Create single and double input data tables Create models using the solver Install and use the Analysis Toolpak Create and use array formulas Use a range of advanced Financial and Statistical Excel functions Content Using what if analysis options Using Goal Seek Creating, saving and viewing scenarios Generating a Forecast sheet Solver Creating models Projecting scenarios with Solver Using data tables Creating single input data tables Creating double input data tables Projecting with data tables Financial functions PMT FV NPV Analysing data with Analysis ToolPak Installing the Analysis Toolpak Generating statistical analysis Visualising data using Histograms Array formulas Using embedded Excel Array formulas Create an Array formula Multi and single cell Array formula Using TRANSPOSE to flip rows or columns Use the FREQUENCY Function Use an array to count unique entries in a range Dynamic arrays Spilling data Using the new dynamic array functions Advance functions in formulas Statistical functions:MEAN, MEDIAN and MODERANKLARGE and SMALLMODPERCENTILE Use the AGGREGATE function to sum data in ranges with errors