610 Learning courses in Sheffield

This interactive course has been designed to help participants manage their time more efficiently and to develop the skills for effective workplace planning

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Certificates Certificates Certificate of completion Digital certificate - Included

Networks demystified training course description A concise overview course covering all aspects of networking with particular emphasis of use of the 7 layer model as a framework for discussing and learning new network terms enabling delegates to recognise the main buzzwords used in the industry. What will you learn Use the 7 layer model to classify networking terms. Differentiate between LANS and WANS. Recognise bandwidth measurements. List LAN and WAN technologies. Recognise cabling issues in a network. Networks demystified training course details Who will benefit: Sales staff, managers and other non-technical personnel. Technical personnel may benefit more from our Intro to data communications and networking course. Prerequisites: None. Duration 1 day Networks demystified training course contents What are networks? What is a network? Types of network, Local Area Networks (LANs), Wide Area Networks (WANs), connecting networks together with routers. The 7 layer model What is the 7 layer model? The importance of standards, using the 7 layer model to classify networking terms. Cables Copper, Fibre, Air, standards, connectors, LAN cables, WAN cables, distance limitations, hubs and repeaters, other issues. The radio spectrum. Bandwidth Bits and bytes. Bandwidth measurements, common technologies and their bandwidth, the impact of applications on bandwidth. Full and half duplex. Joining cables together to increase bandwidth (Link aggregation). LANs and WANs What is Ethernet? What is WiFi? What are Leased lines? What is MPLS? Ethernet switches Ethernet 'packets', MAC addresses, what is a switch, what is the difference between a hub and a switch. TCP/IP What is TCP/IP? What is a protocol? What is IP? What is TCP? The role of routers in joining LANS and WANS, What is the Internet? Applications Ways to use the network, clients, servers, web browsing and HTTP, Email, instant messaging, multimedia applications.

Effective report writing, the exchange of information, ideas, opinions and decisions between people at all levels, internally and externally, makes a vital contribution to organisational success.

Our 2 day course will enable students to attain the knowledge and practical competencies needed to deal with a range of first aid situations when looking after children. For more information click on the tabs below, or get in touch, we’d be more than happy to answer any queries. At Immerse Training we pride ourselves on offering First Aid and Pre-Hospital Care Training that meets your specific needs. All our courses meet the requirements of the relevant awarding body. On top of that, we are more than happy to create bespoke elements that tailor each programme to suit your first aid or care responsibilities. Qualification Information This qualification and learning outcomes are based on the recommendations of: The Resuscitation Council (UK) Skills for Health Assessment Principles for First Aid Qualifications Course Content Following this course students will be able to Understand the role and responsibilities of a paediatric first aider. Be able to administer first aid to an infant and a child with head, neck or back injury. Assess an emergency situation safely. Understand how to administer first aid to an infant with conditions affecting the eyes, ears and nose. Be able to provide first aid for an infant and a child who is unresponsive and breathing normally. Understand how to administer emergency first aid to an infant and a child with an acute medical condition or sudden illness. Be able to provide first aid for an infant and a child who is unresponsive and not breathing normally. Understand how to administer first aid to an infant and a child who is experiencing the effects of extreme heat and cold. Be able to provide first aid for an infant and a child who is choking. Understand how to administer first aid to an infant and a child who has sustained an electric shock. Be able to provide first aid to an infant and a child with external bleeding. Understand how to administer first aid to an infant and a child with burns or scalds. Be able to provide first aid to an infant and a child who is suffering from shock. Understand how to administer first aid to an infant and a child who has been poisoned. Understand how to administer first aid to an infant and a child with bites, stings and minor injuries. Understand how to provide first aid to an infant or child with anaphylaxis. Who should attend? This qualification is for people who have a specific responsibility at work, or in voluntary and community activities, to provide first aid to children (including babies) when dealing with: An emergency situation. Chronic or sudden paediatric illness. Paediatric injury. Pre-requisites Students must be at least 16 years old on the first day of training. Assessment and Certifications Assessment of this course is continuous and also includes 2 theory/multiple choice question papers. Successful students will receive an Immerse Training Certificate, which is valid for three years. This certificate will be issued by Qualsafe, the awarding body for Immerse Training. Additional Information Completion of the Level 3 Award in Paediatric First Aid at Work includes 2 credits at Level 2 of the Qualification Credit Framework (QCF). Paediatric First Aid Courses First Aid courses for individuals and workplaces who provide care to or work with children and young people. Our paediatric courses are fully accredited, registered and meet Health and Safety Executive (HSE) and OFSTED guidelines. From 1 day Emergency Paediatric First Aid to day Paediatric First Aid courses. We specialise in on-site courses at your workplace, tailored to the specific risks associated with your business. All courses can be delivered at our training centre in Poole, Dorset or we can deliver on-site across Bournemouth, Poole, Dorset, Hampshire and the South of England.

Learn the basics of Data Science, combining a supported #CISCO Skills for All online course with practical learning and a project to help consolidate the learning.

Managing Successful Programmes (MSP®) 5th Edition Foundation: In-House Training Managing Successful Programmes (MSP®) is a globally-recognized framework for best practice programme management. MSP certification provides guidance for programme managers, business change managers and the next step for project managers to develop their knowledge and skills to be able to positively respond to the challenges for managing programmes and larger, more strategic or multiple projects. MSP 5th edition emphasizes flexibility, adaptability, and responsiveness by adopting an incremental approach to the programme lifecycle and thus enabling organizational agility. AXELOS offers two levels of MSP Examination: MSP Foundation and MSP Practitioner. The MSP Foundation Examination is intended to assess whether the candidate can demonstrate sufficient recall and understanding of the MSP programme management framework. The MSP Foundation qualification is a prerequisite for the MSP Practitioner Examination, which assesses the ability to apply understanding of the MSP programme management framework in context. The MSP® 5th Edition Foundation course is a training based on the exam specification for MSP Foundation certification and is aligned with the Managing Successful Programmes (5th Edition) guide from AXELOS. What you will Learn At the end of this course, participants will be able to: Understand key concepts relating to programmes and MSP Understand how the MSP principles underpin the MSP framework Understand the MSP themes and how they are applied throughout the programme Understand the MSP processes and how they are carried out throughout the programme Key Concepts of MSP Programmes Three Lenses of MSP Principles Themes and Governance Organization Organization Theme Organization Structure Individual Roles Stakeholder Management Design Design Theme Benefits Risk Identification and Prioritization Target Operating Model Documents and Key Roles Justification Justification Theme Business Case Financial Planning Documents and Key Roles Structure Structure Theme Delivery Planning Dependencies Benefits Realization Plan Resourcing Documents and Key Roles Knowledge Knowledge Theme Knowledge Management Information Management Document and Key Roles Assurance Assurance Theme Assurance at Multiple Levels Assurance Planning Document and Key Roles Decisions Decisions Theme Issue Resolution Risk Response Data Gathering and Reporting Options and Analysis Document and Key Roles MSP Processes Identify the Programme    Design the Outcomes Plan Progressive Delivery Deliver the Capabilities Embed the Outcomes Evaluate New Information Close the Programme

The Institution of Occupational Health and Safety (IOSH) is a globally respected chartered body that champions the highest workplace standards of health and safety.  Safehouse are proud to offer training of the IOSH Managing Safely course. This training programme is designed for any individual who has organisational responsibilities for managing health and safety risks, resources and workplace practices. Once complete, it provides an excellent foundation for further study for those looking to pursue a career in health and safety and gain qualifications accredited by the National Examination Board in Occupational Safety and Health (NEBOSH) or NVQ Course Programme and Duration The IOSH Managing Safely course takes three full days to complete and covers, in detail, the core responsibilities of anyone tasked with managing workplace health and safety. Those responsibilities are covered in seven distinct units of study: Unit 1: Introducing managing safely Unit 2: Assessing risks Unit 3: Controlling risks Unit 4: Understanding responsibilities Unit 5: Understanding hazards Unit 6: Investigating incidents Unit 7: Measuring Performance To help prepare candidates for end-of-course examinations, daily interactive homework assignments and quizzes will also be set by the tutor. Certification In order to successfully complete the course and gain IOSH certification, delegates must complete a 45-minute examination to assess their learning and carry out a practical assessment to demonstrate the application of knowledge gained. Location At our Barnsley based training centre, with free parking on site bistro, free wifi and a great learning environment. Easily accessible from Junction 36 and 37 of the M1. Course Costs Course fees include expert tuition, course materials, examinations and certification. Costs are £395.00 plus VAT with discounts available for multiple booking / delegates.

Overview Appreciative Inquiry is a form of action research that collects people’s stories of best practices. We can use these best practices as a way to initiate organisational change. This course will guide attendees through the process of Appreciative Inquiry (AI) and give them the techniques to succeed in using the AI system. This course will benefit anyone that leads change and wants to create positive dialogue that leads to improvements within their organisation. Description David Cooperrider, Suresh Srivastva, and their colleagues at Case Western Reserve University developed AI in the 1980s. According to them, the aim of Appreciative Inquiry is to help the organisation in: Envisioning a collectively desired future Realising that vision in ways that successfully translate intention into reality and beliefs into practices The AI approach can be applied in almost all groups of people and once the process starts, the change is put in motion. The appreciative approach works in individual conversations among colleagues, managers and employees. AI consultants around the world are increasingly using an appreciative approach to bring about collaborative and strengths-based change. This course will provide attendees with the means to effectively develop the skills of managers for the benefit of their organisation. They will be taken through the full process of appreciative inquiry; developing a wide understanding of the tools and techniques required to effectively improve communication and affect change. What can Appreciative Inquiry achieve? Well, just imagine you were better able to: Solve problems within an organisation in a positive and forward-thinking way. Be more curious and excited about the challenges faced within the business. Ask unconditional, positive questions to strengthen the organisations capacity to increase potential. Approach change in an affirmative mindset. Use questions to create movement and change within the company. Simply apply core communication skills, for overall organisational success Topics covered: What is Appreciative Inquiry? – A review of the subject with an activity that helps embed understanding and a case study that explains the process in action. Benefits of Appreciative Inquiry to the Organisation – Establishing how AI can aid and improve the way an organisation works and how people communicate within it. Exploring how specific organisational issues can be viewed positively. Appreciative Inquiry Questions – Understanding how questions can be used to identify positive organisational improvements and refocus our approach to business issues. Appreciative Inquiry Interviews – A set process for performing AI interviews and framing consultations to get the best out of those involved. A chance to practice the given approach and hone personal skills. The 4D Model – An overview of the AI 4D Model (Discovery, Dream, Design, Destiny) and how it is applied. The 4D Model: Topic – Demonstrating how selecting the topic is the beginning of the 4D model process. Choosing the participants own topic to work on throughout the training. The 4D Model: Discovery – Showing how positive discussions are kick-started at this stage and taking a chance to look at, ‘the best there is and what has been’. The 4D Model: Dream – ‘Thinking big and beyond what they have in the past’. Creating an amazing and positive vision for the future. The 4D Model: Design – Laying the foundation with a design of the vision, principles, and set of propositions that describe the ideal end state. Defining the desired state by creating a hierarchy and blueprint for success. The 4D Model: Destiny – Defining clear actions that will help the organisation and individuals achieve what they have set out to. The output is the self-reinforcing nature of using positive and affirmative inquiry to improve the business. The 4D Model: Summary Task – Review of learning and knowledge check. The Change Process – Exploring Dr. Kotter’s 8-step change process and how it can support the AI approach. Rooms of Change – Understanding feelings and attitudes to change, using this interesting and memorable model. Using an activity to help participants consider their own ‘change position’ and what this might mean for them. Strategies for Managing Change – A simple set of skills to help overcome the challenges faced by people trying to implement change. Applying these strategies to the 4D Model and Appreciative Inquiry. Recall Quiz – A chance to review learning in an engaging way. Summary – Developing actions and key points to take away. Who should attend Managers who want to learn about and practice the Appreciative Inquiry approach to drive positive changes. Requirements for Attendees None.

The emphasis is on competence, fitness to practice and life-long learning. Underpinning this is that clinical specialists and experts take the lead in teaching and training to develop knowledge and skills. However, not everyone has the tools to teach knowing how to is the key to successful learning, this programme is designed to Train the Trainer.