2575 Courses in Hurstpierpoint

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

Develop more advanced training skills such as expert presentation, facilitation and coaching skills. Course overview Duration: 2 days (13 hours) This workshop is for people who want to take their personal skills as a trainer to the next level. It builds on the Underscore Level 1 Train the Trainer course.  In this Level 2 course delegates will develop more advanced training skills such as expert presentation, facilitation and coaching skills. In the modern world learning is often delivered in blended learning formats and this course will introduce delegates to the challenges of blended learning and how to introduce a range of delivery methods into programmes. Attendees will learn how to write more complex learning plans and integrate different methods and media into their plans. Objectives  By the end of the course you will be able to: Describe your Personal Training Style Explain how personality affects communication styles Use techniques to read delegates and adapt communications for greater impact Recognise the ‘games people play’ and how to deal with difficult behaviour Use techniques to establish credibility and enhance your reputation Identify the right approach to take when faced with a range of challenges Use advanced Presentation Skills Use facilitation and coaching skills for experiential workshops Use modern Training Methods and Media Deliver memorable training Note: Delegates attending this programme will be asked to complete an online psychometric in advance of attending the programme in order to help understand personal training styles Content Understanding your Personal Training Style Receive feedback from online Psychometric Understand personal training styles Understand personal communication and working style Understand the impact this has on audience Learn how to adapt your style for greater impact Growing your reputation as a trainer Your Training Persona Training Confidence Training Reputation Trainer Brand Understand the ‘Games People Play’ An introduction to Transactional Analysis (TA) for Trainers Using TA to:Contract for learningUnderstand Trainee AudienceUnderstand interpersonal stylesUnderstand working and thinking stylesWorking in groupsCreativity and innovation Developing deeper Trainer Skills Presentation Magic – making your presentations more effective Facilitation skills for workshops Coaching skills for classrooms and virtual training Delivering experiential workshops Modern Training Methods and Media Incorporating blended learning into your programmes Using Social Learning Using Videos Using Virtual Tools Using CBT and e-learning Pre-course work 1: Complete and online Psychometric Pre-course work 2: Deliver and record a 5-10-minute training session in your workplace on your phone and bring it with you Note: there is an option to have addition 1 hour coaching for delegates to support workplace learning after the course.

Elevate your skills in designing, delivering and evaluating engaging and interactive training that will leave a lasting impact on your team or organisation Course overview Duration: 2 days (13 hours) This Train the Trainer workshop will enable you to gain valuable insights and practice helping you to feel more comfortable and confident delivering training sessions. We will look at some training best practice tools and techniques to ensure you can deliver the learning outcomes required. The workshop covers the training cycle but focuses heavily on interactive and practical training techniques to bring learning to life for participants. There will be opportunities to practice delivery of real work-based training and receive feedback on delivery style. Objectives  By the end of the course you will be able to: Explain Kolb’s model of how adults learn Describe the 4 key learning styles and how to engage people with different learning styles Apply the training cycle to plan, design, deliver and evaluate your training Write SMART training objectives Use and select a variety of methods to make your training interactive, engaging and effective Describe ways to deal with difficult participants or situations that may arise Apply your training skills to deliver structured training sessions with more competence and confidence Content The Training Cycle Assessing needs Planning and preparing Implementing training Reviewing Assessing Assessing Needs Understanding the task Assessing the learner’s current ability Identifying the gap Planning and Preparing Having clear outcomes in mind What people learn: o Knowledge o Skill o Understanding How people learn: preferences and learning styles and methods suitable for each Planning a programme Planning a session – a systematic approach Assessing risk Writing and using SOPs in training Key Skills for Effective Training Explanation and Demonstration Questioning and Listening Observation and Feedback Facilitation and Debriefing skills Coaching Using questioning, listening and feedback to help learners solve problems and develop confidence Evaluation and Assessment How to measure reactions and participant satisfaction Use of tests and assessments to measure learning Organisational measures of learning transfer Leverage You will have the opportunity to deliver two training sessions on this programme and gain valuable feedback to support you in your ongoing training delivery. Participants are required to prepare a 15 minute training session. This can be something you have delivered before or something you’ve created for the course. Please prepare and include any visual aids you would usually use when speaking and bring them with you, f possible, please also bring your smart phone (with camera, and memory capacity for a short video clip to be added), and headphones.

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)

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

Overview In this competitive era no matter how much hard work and solid efforts are contributed still, too many projects end up creating unneeded and unsellable products. There is a significant risk that the outcome of the project may not be relevant to the client/user requirements or become outdated when needs change. Here is where Design Thinking and Agile Management play their role. The combination of Agile and Design Thinking should be used in order to achieve impactful outcomes. Agile and design thinking together works well and gives an effective approach to product development, one that results in efficient resolutions to significant problems. In this course, you'll learn how to define and determine what's important to a user primary in the process, to frontload value, by directing your team on testable narratives about the user and generating an effectively shared perspective. For more dates and Venue, Please email sales@gbacorporate.co.uk

Overview OBJECTIVES Develop practical skills enabling effective communication at the time of an incident Familiarize students with both techniques & technologies involved in crisis communication Provide a health check for your personal & organizational readiness Provide the confidence to know that your response strategies are appropriate and effective Build relevant knowledge through exploring relevant case studies and practical exercises Develop flexible creative and well-motivated teams Upcoming Events Online (USD 1950) Online Streaming Live (Flexible Dates) At Venue (USD 4500) Dubai 20 Feb - 24 Feb Istanbul 27 Feb - 3 March London 20 March - 24 March For more dates and Venue, Please email sales@gbacorporate.co.uk

Overview The Risk Analysis course is a highly demanded certification for roles in project risk management. It recognizes skills, competency, and competency in assessing and identifying project risks, mitigating threats and capitalising on opportunities, while still possessing core knowledge and practical application in all areas of project management. The risk management specialist role on project teams is becoming more important to an organization's success. This course has been designed to benefit professionals who have the responsibility of regularly making important business decisions and wish to enhance their Risk Management abilities and apply them to their businesses. Upcoming Events Online (USD 2250) Online Streaming Live (Flexible Dates) For more dates and Venue, Please email sales@gbacorporate.co.uk

Overview Internal auditing is an independent and objective activity to evaluate an organisation's internal operations. You'll learn how to initiate an audit, prepare and conduct audit activities, compile and distribute audit reports and complete follow-up activities. It is very important for the organisation to have a smooth flow of accounting as it plays a very important role in the development of the organisation. Financial Managers or any person who deals with Accounts need to see that the company accounts are very updated and are free from any risks that can become a problem during the time of Auditing.  Objectives   By the end of the course, participants will be able to: Efficiently dealing with senior leaders with confidence Effective Contribution and Strategically Analysing and Auditing towards business success Analysing and Evaluating as an effective internal audit leader How to manage key relationships with the audit committee Practical methods for managing the audit committee and senior management Describing the significance to help maximize the contribution to their organization