2635 Courses in Guildford

Learn the key skills to become a Manager in an organisation. How can you get the best from your new team. Course overview Duration: 2 days (13 hours)  This workshop is suitable for those who have recently started their first direct line management role. This is a practical workshop and focusses on understanding the role of a people manager in managing workloads amongst the team, the individuals within their team and getting the best out of the team. Objectives  State the key roles and responsibilities of a people manager Use your time effectively to plan and prioritise your own and the work of others for expedient results Set objectives that engage those reporting to you Delegate tasks effectively that motivate the individuals you delegate to Appreciate how to deal with both good and under-performance Adopt the most appropriate leadership style Manage the team through its natural development and through times of change Add value to meetings you attend and chair Content Roles and Responsibilities Understanding your roles and responsibilities for people management Management vs Leadership Action Centred Leadership Managing Workloads How to prioritise the management of tasks, the individuals and the team Objective setting – how to set objectives and how to engage individuals in their objectives Practical application on prioritisation and objective setting Managing Individuals Delegating tasks and work effectively Understanding motivation and how best to motivate individuals Managing performance – the Skill/Will matrix How to manage good performers Dealing with under-performance Goleman’s 6 Leadership styles Choosing the appropriate leadership style for the right person and situation Managing the Team Understanding team roles and dynamics How to manage the team as it develops Team learning and development Managing teams through times of change Tips and techniques for focused meetings

Understand the needs and benefits arising from a structured project risk management approach, the process and supporting methods for identifying analysing and responding to risks. Course overview Duration: 2 day (13 hours) Our Project Risk Management course addresses risk management throughout the project lifecycle. This course is designed for project staff, including project leaders, sponsors, project team members, support staff and functional staff involved in project activity. The workshop is especially suited to teams working on bids, feasibility and project start up. The workshop covers the need and benefits arising from a structured project risk management approach, the process and supporting methods for identifying analysing and responding to risks, human behavioural factors affecting risk management performance, and organisational interfaces and governance requirements. Objectives  By the end of the course you will be able to: Describe success factors and benefits arising from effective risk management Explain human behaviour factors affecting risk management Establish the project context and conduct an initial risk assessment Define an appropriate strategy and produce a risk management plan Define risk identification strategies and apply appropriate identification methods Identify and record important risk information including ownership Establish risk probability and impact levels; produce probability impact charts and severity time charts Establish exposure levels and contingency requirements Explain the principles of quantitative analysis Define and evaluate response options Implement effective risk management process control Content Principles of risk management Terminology Purpose Success factors Benefits and overall process Human factors that impact on risk management Initiate Analyse and determine context factors relevant to risk management Develop a robust risk management strategy for the life of the project How to conduct an initial risk assessment and define an outline strategy Identification Development of a risk identification strategy Appropriate methods and their strengths and weaknesse Determine an appropriate strategy and identify risks in a given case study Animating text Slide titles Bullet points Applying animation to Slide Master Assessment Methods commonly used for assessing and prioritising risks Evaluating exposure and contingency requirement Demonstration of quantitative methods and exercises to assess risks and contingency levels Planning and implementing responses Appropriate methods for responding to risks Defining implementation and control plans Assigning ownership Defining appropriate plans Conducting net benefits analysis and examining effectiveness Manage process Organisational interfaces and specific requirements to ensure appropriate controls Improvements and compliance with governance requirements

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

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.

Gain practical skills in influencing and decision-making, perfect for anyone working in team-based or project-focused environments, with interactive, hands-on learning. Course overview Duration: 1 day (6.5 hours) This is a highly interactive and practical course which will help you to use influencing and decision making techniques. This workshop has been specifically designed to give you an opportunity to learn and test a range of influencing and decision making models and techniques. The course is aimed at anyone who interacts with others on a regular basis, especially those in project management disciplines, multi disciplinary, matrix type organisations where healthy debate and challenge are key to achieving optimum resolutions. Objectives By the end of the course you will be able to: Utilise a variety of new techniques to enhance your influencing skills Recognise the impact of non-verbal communication and use it to enhance influencing behaviours Use language skills necessary to get your message across in an influential way Apply different techniques for dealing with aggression Understand VUCA – Volatility, Uncertainty, Complexity & Ambiguous Use Perception, Bias, Decision Making and Judgement Understand personal preferences and approaches to Decision Making Speed read others approach to decision making Apply Mindsets, Skillsets and Toolsets for decision making Content What is influencing? Sources of power Influencing skills Choosing the right approach Developing Skills Communication skills – the language of influence Different influencing techniques and when to use them Having the confidence to challenge Dealing with confrontation and challenges in a confident manner The Decision Lifecycle – Personal Preferences Understand the human facts that influence decision making Understanding personal preferences and approaches to Decision Making Understand the impact of Perception, Bias and judgement in decision making Speed reading others approach to decision making Frameworks to provide context for decision making Understand the business factors that influence decision making - VUCA The Cynefin Framework – decision making in complex situations Understanding which business context, you operate in – simple, complicated, complex or chaotic Understanding how to decide in complexity Practical Practical exercises Case studies Personal action planning

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

Look at the in depth features of charts and some specialist tools to make your charts come to life. Course overview Duration: 1 day (6.5 hours) Our Excel Charting Specialist course examines how to unlock the full potential of Charts in Excel. It investigates the useful tools needed for creating bespoke Charts, allowing you to creatively present data more visually. By the end of the course, you will have an awareness of the tools used for creating more advanced Charts and will be able to create your own Dynamic Charts. The course is designed for existing users of Excel who are looking at more advanced ways to visualise data in Excel using Charts. Objectives By the end of the course you will be able to: Create and Amend Charts Format multiple areas of a Chart Use a Combo Chart Apply Conditional Formatting to a Chart Create Dynamic Charts Work with Custom Formatting Create an Advanced Dynamic Chart Content Creating and amending charts Creating Simple Charts Using the Chart Design tab Adding Chart Elements Changing the type of Chart Formatting charts Format Chart Area Format Data Series Format Data Point Format Axis Working with combo charts Adding additional data to a Chart Customising Chart types Creating Clustered Column/line Charts Applying conditional formatting on charts Using IF Statements Highlighting Max/Min Data points in Charts Using Series Overlap Dynamic charts Creating dynamic Target vs Actual Charts Introducing the NA function Hiding data used for Charts Custom formatting charts Formatting Data Labels Customising number formats Using Trend Arrows to show changes Editing Format Code Advanced dynamic charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Combining all elements to create an Advanced Chart Using Error Bars to create a line Adding a scroll bar and linking with data

Learn how to work with and connect multiple data sets to effectively analyse and report on data. Course overview Duration: 1 day (6.5 hours) Within Excel you have some powerful features to enable you to connect and analyse multiple data sources. Power Query enables you to import and manipulate your data, Power Pivot enables you to connect multiple data sources and create pivot tables and pivot charts from them. This course is an introduction to Power Query and Power Pivot in Excel to get you started on creating a powerful reporting capability. Knowledge of working with Excel workbooks and relational databases would be an advantage. Objectives By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Add extra columns of data Append data Merge data from other tables Create data models Build data relationships Build Pivot Tables Build Pivot Charts Use Slicers and Timeline Filters Content Importing data Data sources Importing data Transforming data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Appending queries Appending data from other tables Adding text Columns from example Custom columns Conditional columns Merge queries Setting up and using merge queries Merging in columns of data Creating a data model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Analysing information using pivot tables Creating and modifying a Pivot Table Recalculating the Pivot Table Filtering the Pivot Table Searching the Pivot Table Drilling down to underlying data Customising field names Changing field formatting Pivot charts, slices and timelines Creating Pivot Charts Adding and using Slicers

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

Learn the basics of financial awareness and better understand the language used by accountants and how financial statements fit together within organisations. Course overview Duration: 2 days (13 hours)  This workshop will provide participants with a grasp of basic financial awareness, to help them to better understand the language used by accountants and how financial statements fit together. Training is done in a jargon-free way that is aimed building attendees’ confidence in using financial terms and concepts within their organisation.  Competent financial management has many aspects, it is wide reaching and requires multiple skills but if participants work to become organised and effective in planning, these skills can be easily acquired. There is a misconception that to be a good operational manager dealing with financial decisions people must be accounting or numerical geniuses. There are basic skills that attendees can easily learn that will support them in those areas.  Objectives  By the end of the course you will be able to: Identify the importance of financial management and its impact Identify the link between financial information and decision making Set, manage, monitor and review budgets Analyse financial statements Demonstrate the link between the statements, budgets and decision making. Content Financial Management Budgeting process (generic / client specific if possible) Forecasting and re forecasting process The need for accurate forecasting Accrual v cash accounting revisited Financial Objectives of the business Users of the accounts Financial Tools Depreciation and Amortisation Accruals and Prepayments Deferred and Accrued Income Costs, Opex and Capex Financial Statements The Income Statement The Balance Sheet Understanding capital employed The relationship between balance sheet and income statement The cash flow statement Profitability: gross, operating and net margins Review of client’s management information reports Building the Business Case Break even analysis Discounted Cash Flow Discount factors Net Present Value (NPV) Internal Rate of Return (IRR)