1584 Courses

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

Unlock the power of effective negotiation. Gain essential skills to navigate complex deals, build lasting partnerships, and achieve optimal outcomes. Course overview Duration: 1 day (6.5 hours) This course is designed for those who need to understand and be able to use essential negotiation skills to make them more effective in their role. Externally you maybe negotiating with suppliers, customers, regulatory authorities and other organisations. Internally you will be negotiating with stakeholders, colleagues, and team members which could be for resources, time, budget or facilities. Being able to negotiate agreements that are acceptable to all parties requires skill and is essential to maintain healthy, functional relationships. This will be a facilitated workshop designed to be flexible to achieve the desired outcome. We will achieve the objectives through a mixture of facilitated discussion, interactive exercises designed to give insight and facilitator input. During the day we will deal with the stages of a negotiation from preparation to closing. Individuals will get the opportunity to practice the skills needed to create win-win outcomes through a number of generic but realistic scenarios. Objectives By the end of the course you will be able to: State the principles of effective negotiation Prepare effectively for different types of negotiation Set negotiation objectives and identify what can be ‘traded’ Explain how assertiveness and influencing skills can affect outcomes Deploy appropriate strategies and tactics to achieve the best results Use different techniques to deal with difficult customers and difficult situations Content Influencing Seek first to understand, and then be understood The importance of understanding the other party’s position and how to do it The power of non-verbal communication Dealing with difficult customers and difficult situations whilst maintaining a positive relationship How to approach negotiations Identifying potential negotiations and preparing for potential outcomes Aiming for results which deliver win/win outcomes Developing a win/win mindset and behaviours Rights and responsibilities of negotiators Setting Negotiation Objectives Clarifying essential, desirable and ideal objectives Assessing the most favoured, realistic target and walk away positions The Negotiation Process The importance of preparation Creating an opening proposal Where to pitch the opening proposal Bargaining/Trading - Gaining Momentum Knowing your parameters – what can be traded? Choosing a strategy and tactics Dealing with questionable tactics and ploys Building rapport – the communication process Asking the right questions and active listening Being assertive, demanding your rights and ensuring you meet your responsibilities Closing Techniques Trial and actual closing techniques Signalling Summarising and documenting the agreement Follow up and implementation of the deal

Discover the amazing features this tool has to offer in combining, collating and editing documents and the forms, markups and redaction techniques available. Duration 1 day (6.5 hours) Overview This Adobe Acrobat course looks at the powerful features of the tool quite often overlooked.  The course requires the use of either the Standard or Professional versions of Acrobat as the free Acrobat Reader only has limited functionality. Learn how to combine documents into a single file, edit and mark up PDFs, compare documents, redact data from documents and create fillable forms. Objectives  By the end of the course you will be able to: Create PDFs from other tools Set security Collate and combine files into a single PDF Edit PDF files Complete and sign documents Create fillable forms Mark up PDF documents Compare files Redact data Content Creating PDFs Building PDF documents from Word, Excel and PowerPoint Setting PDF options for print, image quality and security Working in Acrobat Home, Tools and Document Views Using the Navigation Panel and Pane Floating toolbar and Contextual menus Collating and Combining Files Combining multiple files into a single PDF Adding extra files Deleting pages and reorganising pages Editing Files Editing text and graphics Adding text and images Adding headers and footers, watermarks and backgrounds Adding Links Adding manual links Automatic links Completing and signing documents Using fill and sign to complete forms Adding signatures Creating Fillable and Signable Forms Prepare a form Autodetect fillable fields Add manual fillable fields Adding drop downs, check boxes, etc. Naming fields Setting field properties Previewing the form Marking Up Documents Marking up changes Using sticky notes Using the highlighter pen Adding stamps Attaching documents and audio Replying to comments Comparing Files Selecting settings Comparison report Reviewing differences Using the changes pane Redacting Data (Acrobat Professional only) Setting redaction options Redacting chosen text Searching and redacting words, phrases or patterns Redacting whole pages Applying redaction

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

Watch a film, don't read a powerpoint! We provide a comprehensive and engaging video-based online COSHH training course. This COSHH online training course course is specifically designed to educate and empower individuals working in the UK, enabling them to understand and effectively manage the risks associated with hazardous substances in the workplace. Understanding COSHH is essential for controlling risks from substances hazardous to health, improving safety and creating a healthy working environment. Our course will give you an in-depth look at COSHH regulations, minimum standards and the impact of hazardous substances, as well as teaching you how to identify risks and control them. Our comprehensive programme will make sure you are equipped with the skills to efficiently manage safety in the workplace, keeping your staff safe and compliant with COSHH regulations. Sign up now for our COSHH training course and trust us to give you a comprehensive understanding of COSHH.

The shortage of electricians has lead to an increased demand nationwide and in turn a sharp rise in salary. Our training solutions can help you gain nationally recognised qualifications such as City & Guilds and NVQ. Not only you will train in state-of-the-art training centres, but you can also have the opportunity to attain the Work Based Performance Units and complete a portfolio of diverse evidence of onsite work.

3 - 4 hour course A course for (unpaid) carers and volunteers who care for people with mobility problems Gives learners the skills to protect their own backs Course Contents: The importance of safe manual handling Basic Risk Assessments Types of equipment designed to aid moving people safely Use of a wheelchair Safely moving people in and out of their wheelchair Safely moving people in and out of a car Use of banana boards and similar objects Helping people get up out of their chairs Helping people to walk by themselves, using sticks or zimmer frames where required Benefits of this course: This is a very practical course 36% of carers have injuries such as back pain, caused by their caring responsibilities This course is there to help carers take care of themselves by showing them, and giving time to practice, techniques to aid the person they care for move by themselves where possible CPD Accredited This course is not an Ofqual regulated qualification, and has no accreditation attached. Candidates will, however, receive a certificate of attendance, as seen to the left.

Come and learn the basics of Kinesiology in this fun, interactive online course. The modules covered include History of Kinesiology The 7 Factors of the Intervertebral Foramina How to Muscle Test A Kinesiologist Toolkit Testing for Hydration Testing for Protein Deficiency Kinesiology Food Sensitivity Testing Emotional Stress Release How to become a Kinesiology Professional Learning Objectives Your takeaways from the Introduction to Kinesiology course will include the ability to: Understand the origins of Kinesiology Explain the toolkit of a Kinesiologist Perform a basic muscle test Describe the different muscle tests for protein deficiency and hydration Understand how food sensitivity muscle testing works Implement basic Kinesiology tools such as Emotional Stress Release

Emergency learn to swim, private 1-1 lessons are for those who need to learn to swim quickly. These are offered as single 2 hour sessions, ideal for swimmers or 5 x 2hr packages, ideal for non-swimmers. A swimming crash course can help you learn the skills and build the confidence in water in a very short period of time. Cruise ships, off-shore workers, oil workers - water safety. Flight attendants & Pilots swim proficiency test training. Holiday, vacation or honeymoon with water activities

Watch a film, don't read a powerpoint! Isn’t it time you considered doing a Driving Safety course? 36% of all road deaths and injuries involves someone driving for work – that’s about 200 deaths or serious injuries a week. At Shout Out Safety, we are committed to providing comprehensive online health and safety courses to a UK audience. Our Driving Safety training course is designed to equip individuals with the knowledge and skills necessary to ensure safe driving practices. This CPD accredited course is divided into four sections, each covering essential topics related to driving for work, pre-trip preparations, recognising and managing hazards, and implementing good driving practices. With a duration of less than one hour, our course offers a convenient and efficient way to enhance your driving safety awareness.