3077 Courses in Bristol delivered Live Online

Learn how to use this innovative tool to analyse and validate your schedule, to add and model uncertainty and risk and to work with updated plans to compare project progress. Course overview Duration: 1 day (6.5 hours) This course looks at the powerful features of Nodes and Links. It looks at analysing and validating your schedule, adding uncertainty and risk and working with updated plans to compare project progress. Hands on practice will be gained throughout the course to ensure you can confidentially put your new skills into practice back in the workplace. This course is designed for new users of Nodes and links, no previous experience is required. You should however be familiar with risk management processes and terminology. Objectives  By the end of the course you will be able to: Import and validate plans Analyse and review plans Add and model uncertainty Add and model risk Load updated schedules Re run analysis on updated schedules Content Validating your plan Importing a baseline plan Running a health check Analysing the results Reviewing the plan Analysing critical paths Reviewing activities Reviewing resources Adding Uncertainty Setting uncertainty templates Distributions Adding uncertainty Using Inherit Using AI Reviewing activity distributions Modelling Uncertainty Running the Analysis Reviewing the results Reviewing activity results Risk Drivers Filtering for activities Setting up the Risk Register Setting Risk Templates Adding Risks to the Risk Register Independent vs Dependant Events Setting Probability and Impact Modelling Uncertainty and Risk Mapping risks to activities Running the Analysis Reviewing the results Updated Plans Importing a new plan version Comparing plans Tracking progress Trend analysis Analysing Updated Plans Using updated plans Synchronising uncertainly and risk Rerunning analysis

Ideal for those already using Excel but who really want to get to grips with formulas and functions. Course overview Duration: 1 day (6.5 hours) Our Excel Mastering Formulas and Functions course looks at how to confidently use formulas and functions within Excel. It looks at how to correctly construct formulas and explains how to build common formulas such as working with percentages. It investigates a range of built in Excel functions and shows you how to use the formula auditing tools to help when things go wrong.  This course is aimed at existing users of Excel who want to further their skills. Participants should be able to confidently create and amend worksheets. Objectives By the end of the course you will be able to: Construct Formulas Use a range of common Functions Work with absolute and relative references in formulas Create percentage calculations Use named ranges in formulas Use the XLOOKUP command Create formulas with date and use date functions Use formulas in conditional formatting Use a range of Count functions Use the formula auditing tools Content Formulas vs Functions Constructing formulas Using functions Common Excel functions Using the function wizard vs the formula bar Formulas in tables Absolute vs relative references in formulas Using absolute references in formulas Using partial absolute referencing Range Naming Naming ranges Using range names in formulas Single and multi-cell ranges Working with percentages Creating formulas with percentages Percentage breakdowns Percentage increases Formatting as a percentage Using Lookups Using XLOOKUP to insert information from other spreadsheets Calculating with dates Calculating with dates Using date functions Using formulas in conditional formatting Using conditional formulas Using functions in conditional formatting Count functions COUNT COUNTA COUNTBLANK Formula auditing Using the auditing facility Tracing how formulas are made up Tracing precedents and dependants Evaluating formulas Error checking Showing formulas on a sheet

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

Discover the powerful schedule and cost risk analysis features of PRA. Course overview Duration: 2 days (13 hours) Our Primavera Risk Analysis course gives a detailed introduction to the schedule and risk analysis features of Primavera Risk Analysis. It shows the powerful features of the tool and give hands on practice throughout the course to ensure you can confidentially put your new skills into practice back in the workplace. This course is designed for new users of Primavera Risk Analysis, and no previous experience is required. You should however be familiar with risk management processes and terminology. Objectives  By the end of the course you will be able to: Import schedules into PRA Add three point estimates onto plans Perform schedule and cost analysis Use templated quick risk Run risk analysis Interpret results from the Risk Histogram and Tornado graph Add task percentiles to a Gantt chart Set up a risk register Add qualitative and quantitative risks Link risk to activities in the plan Create reports Use the Distribution Analyser Content Importing schedules Importing MSP and Primavera Schedules Running import checks Checking schedule integrity Schedule risk analysis 3 point estimating Entering uncertainly Different distributions Using quick risk Updating plan Importing plans with 3 point estimates Cost/Resource uncertainty Resource loadings Creating 3 point cost estimates Resource distributions and escalations Simple cost estimates Templated quick risk Setting up and applying templated quick risk Assessing risk at WBS level Running risk analysis Running risk analysis Interpreting results on the Risk Histogram Setting analysis options Task percentiles Setting task percentile options Including task percentiles on the Gantt chart Tornado graph Creating a Tornado graph Viewing sensitivity Analysing sensitivity against activities Setting up the risk register Setting Schema levels Defining criteria and tolerances Setting up a Risk Breakdown Structure (RBS) Working with manageability and proximity Saving scoring matrices Adding custom fields Exporting data Exporting to Excel, Word and PowerPoint Qualitive risks Setting risk IDs Adding risk cause, description and effect Setting up risk details Entering mitigation actions Quantitative risks Linking risks to activities Adding schedule and cost impacts Defining how multiple risks impact Correlation Migrating your plan Adding mitigation actions to your plan as tasks Linking tasks to mitigation actions Actioning your risk register Progressing risks Importing progressed plans Linking register to progressed plans Risk history The Waterfall chart Saving and reporting Exporting the risk register Running reports Creating new reports Building and comparing risk plans Using the distribution analyser Comparing dates and cost

Most organisations and businesses are trying to navigate the best way back to a functional working framework. But two things need to happen - 1. The working practices need to be efficient, sustainable and compatible for meeting the demands and needs of the organisation; it’s clients, it’s workforce and it’s Leaders 2. The culture needs to be welcoming, authentic and supportive otherwise there will be disenfranchisement and potentially a churn of staff and loss of talent What has been proven to be a very successful approach to mitigate the dangers of demotivated team members and poor efficiency levels is a bespoke ‘Ushering the Team Back to the Workplace’ workshop. Programme Outline Below is a template of an actual Programme that has been delivered very successfully for clients such as the NHS; Claranet; Jotun Paints & Workspace. This, however, can be modified to suit any group or size. It will be designed to reflect the Organisation’s preferred Hybrid working framework and communication systems. The options of having the innovative Real Play technique to help handle delicate conversations is especially effective. The biggest gain is to reconnect the relationships via the activities and exercises, which would be selected carefully. Key commitments and buy-in is always the priority outcomes - which this programme will help deliver in just 1 day. The objectives include: Making the transition back to working as a collaborative team Enhancing the Leadership skills of the team Reviewing/establishing the Hybrid working protocols Galvanising the Team spirit Maintain inclusivity among full-time; part-time and Region based team members Energising and motivational Fun! Exercise – Round the Bend The team are to follow the instructions delivered as they walk (and jump) through the route – always keeping a safe distance apart. The instructions become more complicated as they progress. Debriefing points: Dealing with Change Attention to Detail Adapting approach Optimising results Exercise - Number Crunch (3 x Cohorts of 12/13) The team must be effectively led and motivated to work as one unified group to reach their objective of visiting each numbered location within a very tight deadline. Debriefing points: Support and co-ordination Strategy and planning Adapting approach Optimising results Tutorial – Team Dynamics Tuckman model Phases of Development towards Maturity Exercise - Juggling (3 x Cohorts of 12/13) The group(s) will be invited to optimise the number of ‘clients’ (juggling balls) they can manage at one time. This involves devising a sequence between the group to achieve maximum results without making any mistakes. We introduce different balls which represent different degrees of complexity, challenging the group’s preparation and approach to a variety ‘customers’ needs. Debriefing points: Ensuring effective communication Clarifying the approach for dealing with the unexpected Setting expectations and reviewing delivery Treating every colleague with care and respect Tutorial - Email Etiquette The primary standards – best practices ABSURD model Preparation and planning Top Tips World Cafe The team are split into 5-6 sub-groups – each with a specific review focus:- What recommendations do you have to engage the team back into the Workplace? How do we ensure the framework is efficient? What are the best ways to optimise team working strategically when most/all team members are in the office? What potential barriers are there? How do we accommodate for the Regional team members? What are the benefits to bringing the team back to the workplace? Each session has 2 – 3 rounds with each table’s ‘host’ sharing feedback for applying to the Team Action Plan – or Charter. Debriefing points: Each Syndicate’s recommendations and capture the key actions they generate 'Real Play' We offer an innovative solution to bring real Leadership/team scenarios to life. We use actors who improvise scenarios which have been specified by the group. The group is split the group into 2 sub-groups, one with the Actor, the other with the Trainer. Each group has a brief and has to instruct their Trainer/Actor on how to approach the scenario supplied. The Actor and Trainer perform the role play(s) as instructed by their respective teams; however, during the action they can be paused for further recommendations or direction. The outcome is the responsibility of the team(s) – not the performers Assign 24 x ‘Directors’ (4 for each Player – Phil & Julia – for each Real Play. Potential Real Play Scenarios: Engaging with a team member as to how the new working plans will be applied. Overcoming concerns to the new working practices/framework Addressing issues where a team member feels excluded from the teamworking practices/culture Debrief the Programme Individual Action Plans Team Priorities for application into the workplace

Managing teams and projects to meet a private, public or voluntary organisation's goals.

A professional for direct customer support within all sectors and organisation types.

Identifying, attracting and shortlisting candidates for the recruitment process to fulfil the requirements of the business brief.

Ensuring learning and development contributes to improved performance in the workplace at an individual, team and organisation level.

Helping customers buy products or services from retail organisations such as department stores, garden centres, high street chains, supermarkets and online and mail order businesses.