57505 Courses

Following on from the Macros course look at how you can write your own Visual Basic code within Excel to fully automate tasks and save time. Course overview Duration: 2 days (13 hours) Our VBA in Excel course is an introduction to using the Visual Basic for Applications language for programming in Excel. It looks at structures, syntax and coding standards. This course is designed for existing experienced users of Excel who can record and run macros and those who have dabbled in VBA but would like some formal training and help to put some structure to their code. Objectives  By the end of the course you will be able to: Write visual basic procedures Create event and general procedures Use commands from the Excel data model Use statements and functions Use a selection of debugging tools Create and use variables and constants Use different types of loops Create an Excel user form Content The VBA environment Project explorer Excel objects Modules Properties window Code window Code structure Code structure Navigating within your code Adding comments Using WITH Steps to creating a VBA procedure Procedures Sub procedures Event procedures Calling procedures The Excel data model Workbook commands Worksheet commands Excel selection methods Data manipulation commands Debugging Using breakpoints Stepping through code The immediate window The watch window The locals window points Variables and Constants Declaring variables Declaring multiple variables Variable data types Concatenation Scope of variables Constants Declaring constants Using constants Scope of constants Looping Do while loops Do until loops For next loops Conditional Statements IF statement SELECT CASE statement Comparison statements Logical operators Creating a User Form Form layout The control toolbox Naming conventions Adding objects Naming objects Captions Displaying the form Object properties Object properties Setting properties at design time Setting properties at run time Interconnectivity between the user form and Excel Comparing values Transferring information Running code

Coming soon! Embark on a transformative odyssey into operational leadership with our Level 5 Operations Department Manager course. Meticulously designed for individuals venturing into the role of an Operations Department Manager, whether through recent recruitment or a well-deserved promotion, this program is a gateway to acquiring advanced skills and unique insights crucial for success in the realm of operations.

SAP Training London: Overview What is SAP? SAP is one of the largest ERP(Enterprise Resource Planning) software in the world. It provides end to end solution for Financials, Manufacturing, Logistics, Distributions etc. SAP applications, built around their latest R/3 system, provide the capability to manage financial, asset, and cost accounting, production operations and materials, personnel, plants, and archived documents. The R/3 system runs on a number of platforms including Windows and MAC and uses the client/server model. SAP Business Cases/ Live Project Our SAP training courses are designed in a way which gives the students maximum exposure of real-life scenario through no of business cases and guidance on implementation by professional SAP Consultants. Free SAP Access Free SAP Sandbox Access provided for 6 months so that you can practice even after your SAP training course. Certificate of Attendance- You receive a certificate once you finish the course from Osborne Training,  You can also do an external exam to receive certification from SAP (Optional), for details on exam booking you may visit the SAP website. SAP Training Modules Available Financial & Controlling (FICO) High-Performance Analytic Appliance (HANA) Supply Relationship Management (SRM) Customer Relationship Management (CRM)

Understand how to effectively manage conflict and learn that conflict can be healthy and need not damage relationships. Course overview Duration: 1 day (6.5 hours) Conflict and differences of opinion are inevitable in the today’s fast moving, complex business world, some would argue they are even necessary. This highly interactive and practical course addresses the many aspects of effectively managing conflict and will help you ensure that conflict can be healthy and need not damage the relationship. This workshop has been specifically designed to give you an opportunity to learn and test a range of influencing and conflict handling models and techniques. The course is aimed at anyone who interacts with others on a regular basis. Objectives  By the end of the course you will be able to: Utilise influencing skills to pre-empt and defuse conflict Resolve conflict by choosing the right approach Recognise the impact of non-verbal communication in managing conflict Use language skills necessary to get you message across in the ‘right’ way Present your case in a reasonable and responsible manner Identify behaviours that can help or hinder interactions with others Apply different techniques for managing conflict positively and for dealing with aggression Content Developing Influence Networking Sources of influence Influencing techniques Effective Behaviour Choosing the right approach Techniques to pre-empt or defuse conflict Behavioural styles and their impact on working relationships Triggers to aggressive behaviour Managing conflict flash points Dealing with different behaviour types Developing Skills Communication skills in conflict situations Using the right language Verbal and non verbal communications Managing our body language Your conflict management style analysis Thomas Killman Conflict Handling Instrument Working in groups Practical exercises and case studies The language of mediation Transactional Analysis Practical Practical exercises Case studies Personal action planning

Coming soon! Tailored for seasoned professionals, our Level 7 Senior Leader course is for those seeking to enhance their leadership capabilities, this program is designed for individuals aspiring to or currently occupying senior leadership roles. Delve into advanced concepts of strategic leadership, organizational effectiveness, and change management. Explore the nuances of decision-making at the executive level, honing your skills in navigating complex business landscapes.

To increase your awareness and understanding of what safeguarding children means, in order to increase your confidence to enable you to make a positive contribution towards the process.

Understand the biases we all have and the impact they can have in the workplace. Look at how to minimise their impact on others and the organisation. Course overview Duration: 1 day (6.5 hours) The purpose of this course is to help individuals understand and recognise their own unconscious biases, and to provide strategies on how to minimise the impact of those biases in the workplace. The course will provide an overview of what unconscious bias is, its prevalence and impact, and ways to mitigate its effects. Objectives By the end of the course you will be able to: Define unconscious bias and recognise different types of bias Understand how unconscious bias affects decision-making and behaviours in the workplace Identify their own unconscious biases Understand the impact of unconscious bias on individual and team performance Apply strategies to mitigate the effects of unconscious bias in the workplace Content Module 1: Introduction to Unconscious Bias Definition of unconscious bias History and prevalence of unconscious bias Different types of unconscious bias (e.g. affinity bias, confirmation bias) Module 2: Understanding the Impact of Unconscious Bias How unconscious bias affects decision-making and behaviours in the workplace Examples of unconscious bias in the workplace Impact of unconscious bias on individual and team performance Module 3: Recognising Your Own Unconscious Biases Identifying personal biases Tools to recognise and minimise unconscious biases Module 4: Mitigating the Impact of Unconscious Bias in the Workplace Best practices for reducing unconscious bias in the workplace Strategies for managerial and executive leadership to combat unconscious bias Tips for creating a culture of inclusion and diversity

COSHH Training Liverpool – Under the Control of Substances Hazardous to Health Regulations, 2002, every business needs a COSHH assessment, and if the business employs five or more employees, the assessment needs to be documented.

We deliver forklift training to both individuals and companies. Courses are delivered onsite at our training centre or arrangements can be made to deliver at a company’s premises.

Join this course for full access to our Small Animal Sonography Webinar archive.  Speaker: Mark Overend qualified from Glasgow University in 1990 and since then has held several positions and Directorships within practice and the veterinary industry. He was awarded the ESVPS GP Cert in cardiology in 2010, and a the PgC (Small Animal Cardiology Studies) (Distinction) from Harper Adams University in 2017. Mark has been running a cardiology and ultrasound referral service for the last 12 years (now a travelling service) but also lectures to and trains vets all over the UK in the fields of Ultrasound and Cardiology.