7077 Courses near Worcestershire delivered Live Online

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

This confidentially & effective record keeping training course is aimed at assisting staff to understand what is expected of them regarding confidentiality, maintaining accurate up to date records and documents.

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

Our excellent one to one singing courses are suitable for all adults, from absolute beginners without any prior musical knowledge to advanced amateur pianists. They can be joined at any time during the year and are provided by highly qualified and experienced singing instructors.

This course explores Autism and the current body of thinking and knowledge around Autistic Spectrum Disorders. This enables learners to consider how to adapt their practice with useful strategies to better support an individual with autism.

Our intensive singing courses are greatly enjoyed by adults who are eager to boost their vocal abilities within a short period. You can either attend to work on a specific aspect of your voice or your overall vocal technique. Expect tremendous progress in a few days of focused studies.

Total Taxation Training Course It is a comprehensive practical training programme on Taxation designed to build the bridge between knowledge and practical aspects of accounting and tax. With this tax classes all modules of tax and accounting are covered and after completing the modules you will have the chance to get hands on experience which will open the door for lucrative tax and accounting sector. Our Total Taxation courses are suitable for claiming CPD points. Advanced Excel Bookkeeping VAT Training - Preparation and Submission Personal Tax Return Training Company Accounting and Tax Training

By being both highly enjoyable and educational, our group singing lessons are ideal for adults who want to combine learning and socialising. Studying in a group format is a great way to improve your vocal skills while connecting with like-minded singing lovers. Open to beginners.

Develop the essential skills to begin your presentation journey. Course overview Duration: 1 day (6.5 hours) Overview When surveyed about their greatest fears, many people cite public speaking as their first. Also, in today’s business world staff and management are expected more and more to present to an audience of some kind. Whether it’s holding a staff meeting, speaking at a business event, training or simply motivating a team, this requires continued development of presentation knowledge and skills. This workshop offers participants the opportunity to develop the skills necessary to deliver confident, meaningful presentations that influence and inspire their audiences. Objectives  By the end of the course you will be able to: Design, develop and deliver a confident presentation Control nerves during training sessions Make presentations memorable and relevant for an audience, therefore improving the opportunity for influence Deal with questions and minimise the impact of difficult situations Content Presenting with Power Why presenting with power is important How to present with power How to improve your public speaking Setting up for Successful Presentations Techniques that will help prepare effectively How to anticipate problems with presenting How to apply techniques to prepare for successful presentation Dealing with Nerves Effective preparation techniques to manage stress How performance anxiety affects you How to implement a plan to successfully deliver a presentation

This course is developed for staff and volunteers to raise awareness of drug and alcohol misuse issues and are adequately informed and enabled to work effectively with individuals with dependencies.