617 Courses in Sheffield

Course Objectives This course aims to provide delegates with a foundation for Excel knowledge and skills. ' Customer Feedback Very professional and well mannered, fun and pleasant at the same time. I learnt a lot Carolina Foster - CNN Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all. Laura Smith - James Grant Great course and excellent trainer. Thanks Tracy Preston - Western Power Distribution 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk 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. What is Excel? The Excel Interface Ribbon, Tabs and Groups Microsoft Office Backstage view Working with Workbooks Create a blank Workbook Create a Workbook using a Template Opening and saving Files Working with worksheets Worksheet navigation Select one or multiple Worksheets Insert, Move, Copy or Delete a Worksheet Working with Cells, Rows & Columns Cell References How to select cells or ranges Different types of data Move, Copy and Delete cells Pasting Options Find and Replace Working with Rows and Columns Overview of formulas in Excel Autocalculation The parts of an Excel formula Using calculation operators in Excel formulas The difference between Absolute, Relative and Mixed references Using Excel functions; Sum, Average, Max and Min Cell Formatting Font Format options Number Format options Change the Fill and Borders Cell Alignment An Introduction to Charts Create a simple Chart Format your chart Page Layout and Print Page Layout and Page Break View Change the Page Orientation Set Page Margins Headers and Footers in a worksheet Print a worksheet or workbook Who is this course for? Who is this course for? All users who want to master the main features of Microsoft Excel Requirements Requirements General knowledge of the Windows OS Certificates Certificates Certificate of completion Digital certificate - Included

CPRI training course description This course is designed to give the delegate a technical overview of the CPRI protocols and link setup. We will explain the industry cooperation to define the key internal interface between the radio equipment control (REC) and the radio equipment (RE). Also explained will be the SAP that the CPRI link supports for IQ Interface, frame synchronisation, link control and management and the master and slave ports. We will investigate the CPRI block diagram and together with the data formats and sample mapping solutions. The CPRI frame hierarchy and hyperframe construction will be detailed during this three day overview course. What will you learn Explain the CPRI Block diagram. Understand hyperframing capabilities. Explain the CPRI frame format. Understand how the synchronisation is compliant with 3GPP & WiMAX requirements. Understand the two electrical characteristics of CPRI standard. Understand the CPRI standards structure. Understand the CPRI system & Interface definitions. List the four standard bit rates of the CPRI specification. Understand the CPRI Protocol stacks. CPRI training course details Who will benefit: Anyone looking for a technical overview of the CPRI protocols and link set up. Prerequisites: None. Duration 3 days CPRI training course contents System Description Subsystems. Nodes. Protocol layers. Protocol data planes. User data planes. Antenna carriers. Service Access Points (SAP). Link. Passive Link. Hop. Multi-hop Connection. Logical Connection. Master Port & Slave Port. System Architecture Basic System Architecture & Common Public Radio Interface Definition. System Architecture with a link between Res. Reference configurations: Chain topology, Tree topology, Ring topology. RECs & REs in both chain & tree topology Functional description Radio Functionality. Functional Decomposition between REC and RE: For UTRA FDD, For WiMAX & E-UTRA, For GSM. CPRI Control Functionality. Interface Baseline Interface Specification. Protocol Overview. IQ Data. Synchronisation. L1 Inband Protocol. C & M Data. Protocol Extensions. Vendor Specific Information. Physical Layer Specifications Line Bit Rate. Physical Layer Modes. Electrical Interface. Optical Interface. Line Coding. Bit Error Correction/Detection. Frame Structure. Mapping Methods. Container Blocks. Hyperframes. GSM, UMTS & WiMAX Timing. Link Delay Accuracy & Cable Delay Calibration. Link Maintenance Data Link Layer (Layer 2) Specification Layer 2 Framing for Fast & Slow C & M Channels. Medium Access Control/Data Mapping. Flow Control. Start-up Sequence General. Layer 1 Start-up Timer. State Description. Transition Description. Interoperability Reserved Bandwidth. Version Numbers. Supplementary Specification Details Delay Calibration Example. Reference Test Points. List of Abbreviations & Gloss

Application delivery training course description A concise hands on course covering section 1 of the F5 networks AD fundamentals exam. The course focuses on the technology and not any one manufacturers product. This will enable delegates to work with devices from any manufacturer. Practical hands on with Cisco and Microsoft systems follow the major sessions to reinforce the theory. What will you learn Explain, compare and contrast the OSI layers. Explain protocols and technologies specific to the data link layer. Explain protocols and apply technologies specific to the network layer. Explain the features and functionality of protocols and technologies specific to the Transport layer. Explain the features and functionality of protocols and technologies specific to the Application layer Application delivery training course details Who will benefit: Anyone taking the F5 networks AD fundamentals exam. Technical staff working in Application delivery. Prerequisites: None. Duration 3 days Application delivery training course contents What is TCP/IP? Protocols, services. The Internet, RFCs, The OSI 7 layer model. Layer 1 cables. Ping and addressing Host configuration of IP addresses, subnet masks, default gateways, ipconfig, ping. Hands on Configuring TCP/IP, ping. Ethernet and the data link layer 802.3, evolution, choosing cables, topologies, CSMA/CD, hubs, NICs, MAC addresses. Hands on Analysing MAC addresses. IP and Ethernet Relationship. Hands on ARP. What is a switch? Switches connect multiple devices, switches versus hubs, simultaneous conversations, switches work at layer 2, the forwarding database, how the forwarding database is built, broadcast and collision domains. Hands on Difference between hubs and switches. Link aggregation Loops, broadcast storms, STP, Architectures, modes, link aggregation, load sharing, resilience. Hands on fail over times. VLANs Virtual versus physical LANs, Why have VLANs? Broadcast domains. Hands on VLANs effect on traffic. IP IP datagram format, ICMP datagram format. Hands on Analysing IP and ICMP packets. IP addressing Format of addresses, registering, dotted decimal notation, choosing addresses, DHCP. Hands on impact of addressing errors. Routing What is a router? Reason for routing, network addressing, default gateways, how routing works, routing and addresses, routing tables, traceroute. Hands on Using a routed network. Routing protocols IGPs, EGPs, RIP & OSPF. Hands on Configuring routers for RIP and OSPF. Subnetting When to subnet, subnet masks, working with subnetting, CIDR notation. Hands on Changing the routed network to use subnetting. The transport layer UDP, Ports, TCP, acknowledgements, sliding windows. Hands on Analysing packets. Applications Clients, servers, web, Email SMTP, resource sharing, IM, VoIP, Video over IP, terminal emulation, FTP. Hands on FTP, SIP. Web pages URLs, DNS, names to IP addresses. HTTP, versions and status codes. Keepalives, cookies. Hands on Analysing HTTP headers.

This qualification is ideal for those already working, or preparing to work within industry wishing to become a First Aider in the workplace for the purposes of the Health and Safety (First Aid) Regulations 1981 and the Health and Safety (First Aid) Regulations (Northern Ireland) 1982. Topics covered include: the roles and responsibilities of the First Aider, CPR, Using a defibrillator, assessing an incident, recognising signs and symptoms of injury and illness, assisting a casualty who is suffering from major injury and illness, chest injuries, spinal injuries and anaphylaxis. How long will it take me to achieve this qualification? This is a 3 credit qualification, with a guided learning hour’s value of 24 and it has a minimum contact time of 18 hours, which is typically delivered via a 3 day course. For those retraining, the course time can be reduced to 2 days. How is the qualification assessed? Learners must undertake a practical assessment of their competence along with a short open response knowledge assessment, where learners are required to provide a short response to a prescribed series of questions. What next? In line with guidance provided by the HSE, the qualification supports/approves work place first aiders for a period of 3 years, after which point learners will need to retake the course. In addition to this, it is also recommended that learners refresh their knowledge annually.   Cost – £179.00 per delegate. (including refreshments, certificates and workbooks) Get in touch via the contact us page for up and coming dates. Why not use your place of work and let us take the burden of travelling away from you.

About this training course Gas well performance is dictated by the combination of inflow and outflow performance. The outflow performance of any gas well is at risk as soon as the gas rate becomes insufficient to lift the associated liquid water and condensate to surface. This condition is referred to as liquid loading and invariably causes intermittent production and significant loss of well capacity and reserves. Liquid loading can be mitigated by different types of gas well deliquification such as compression, velocity string, plunger lift, foam-assisted lift, gas lift and downhole pump. This 5 full-day course will first show how to predict and recognize liquid loading. Next, it will describe how to select, design, install and operate the best sequence of deliquification measures. It will also consider deliquification in the presence of other production threats such as water production and halite blockage. These topics will be illustrated by an abundance of field examples and case studies. The participants will be completing a case study during the training. This case study is preferably based on their own relevant data set. If no such data is available, an external data set will be provided instead. Prerequisites skills: It is necessary for the participants to have a basic knowledge of petroleum engineering and gas well performance. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives On completion of this course, the participants will be able to: Develop skills and tools to understand and model gas well liquid loading and deliquification Understand the principles and practicalities of different deliquification methods Learn how to compare, select and apply deliquification measures by taking own field case as example Target Audience This course is intended for production engineer, surveillance engineer, completion engineer, production/process chemist, reservoir engineer, production programmer, production operator as well as professionals responsible for selecting, installing, operating, monitoring and optimizing deliquification. Course Level Basic or Foundation Training Methods This course utilizes Excel worksheets first introduced in the Optimising Gas Well Performance course. To derive maximum learning value, the participants are requested to bring their own relevant set of field data to complete their own case study during the training. The list of data required will be shared beforehand so data can be timely collected and cleared for external use. The participants should be prepared to complete any unfinished exercises and assignments before next day's session starts. The instructor will be available to discuss any remaining queries after the completion of the course. Trainer Your expert course leader brings with him 35 years of oil and gas field experience within Shell of which 25 years as gas well production engineer. He has covered the full spectrum of activities moving from R&D to green field development to brown field surveillance and optimisation, to become a leading gas well performance and deliquification specialist. He likes to capture the complex reality of gas well inflow, outflow and reservoir performance by means of practical data-driven rules and tools that cover a wide range of conditions i.e. shallow-to-deep, prolific-to-tight, dry-to-wet, green-to-brown, 1-1/2'-to-9-5/8' tubing, and depletion-to-aquifer drive. Before his retirement in end 2020, he worked for various Shell affiliated oil and gas companies including Shell Malaysia, Petroleum Development Oman, NAM Netherlands and Shell R&D in Netherlands and USA. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

A dynamic and interactive one-day or two-half-day live virtual workshop for women leaders in business, government and non-profit organizations.

Introducing Divorce Therapy Package: Navigating the Challenges, Healing, and Finding Renewed Purpose Are you going through the difficult process of divorce and seeking support to cope with the emotional challenges and transitions? Miss Date Doctor’s Divorce Therapy Package offers you a compassionate and understanding space to navigate the complexities of divorce, heal from the emotional wounds, and find renewed purpose in life. Divorce is a life-altering event that can lead to a wide range of emotions, including grief, anger, sadness, and uncertainty about the future. Our experienced therapists are here to help you process these emotions, gain clarity, and develop coping strategies to move forward positively. Here’s how the Divorce Therapy Package can support you: Emotional Healing: Our therapists provide a safe and non-judgmental space where you can freely express your emotions related to the divorce. We’ll help you process grief and loss, anger, and other challenging emotions to facilitate healing. Navigating Transitions: Divorce often involves significant life changes. We’ll guide you in navigating these transitions, such as adjusting to single life, co-parenting, or re-entering the dating scene. Coping Strategies: Divorce therapy equips you with coping strategies to manage stress, anxiety, and uncertainty during this period of change. Gaining Clarity: Our therapists will work with you to gain clarity about your goals and aspirations, helping you find a new sense of purpose and direction in life. Communication Skills: Divorce therapy can also address communication issues, helping you effectively communicate with your ex-partner and children during the divorce process and beyond. Building Resilience: Divorce therapy fosters resilience, empowering you to bounce back from challenges and embrace a new chapter in life with strength and determination. Self-Discovery: Divorce can be an opportunity for self-discovery and personal growth. We’ll help you explore your values, strengths, and interests, creating a foundation for a fulfilling future. Supportive Environment: Our therapists provide unwavering support throughout your divorce journey, offering guidance and empathy as you work towards healing and renewal. The Divorce Therapy Package at Miss Date Doctor offers you a transformative experience during a challenging time in your life. Our therapists understand the complexities of divorce and are committed to helping you navigate this transition with grace and resilience. Invest in your emotional well-being and take the first step towards healing and renewal with the Divorce Therapy Package. Embrace the opportunity for growth and self-discovery as you embark on a journey of healing and empowerment. Let our skilled therapists guide you towards finding strength, purpose, and a brighter future beyond divorce. 3 X 1 hour https://relationshipsmdd.com/product/divorce-therapy-package/

Remote working is on the increase. However, managing a remote team is not always the same as managing a traditional, single-site office-based team.

Birth Right Hypnobirthing is a full antenatal birth preparation course for pregnancy. Particularly useful for those who are scared of giving birth. Whether this is your first or tenth baby this information is essential. Whether you're looking for a natural birth or support for your caesarean birth this course will support you and give you the tools for the best birth for you.

Grateful Leadership: In-House Training Effective leaders must find ways to enhance people's level of engagement, commitment, and support, especially during the difficult periods of time that all organizations may face. Grateful leaders can tap into the power of personal commitment and dedication by acknowledging people in an authentic and heartfelt manner. Those leaders who model true acknowledgment behavior will inspire others to do the same and to want to dramatically increase their levels of contribution to the organization, making the power of acknowledgment transformational. What you will Learn You'll learn how to: Understand and develop the capability to act upon the need for Grateful Leadership to create a culture of appreciation in the workplace Understand the potentially huge benefits of Grateful Leadership in the workplace Overcome the barriers to using acknowledgment Demonstrate the language and subtleties of authentic and heartfelt acknowledgement behavior Describe the Seven Principles of Acknowledgment for 'High-Interest Benefits' in the context of participant's personal leadership style Describe how to coach teams, managers, and other corporate stakeholders in using Grateful Leadership to produce breakthrough results Getting Started Introductions Course goals and objectives Introspection on the practice of Grateful Leadership The Workforce Engagement Sustainability Challenge Employees who are engaged, not engaged, and actively disengaged The costs of non-engagement Meeting the workforce engagement challenge Acknowledgment, Engagement, and Leadership Acknowledgment and its benefits Recognition versus acknowledgment 'Challenging people' case study Blanchard, Covey, Keith (Servant Leadership): how acknowledgment fits into these leadership models Leadership and acknowledgment The 5 C's - Consciousness, Courage, Choice, Communication, Commitment Employing the Power of Acknowledgment Overcoming barriers to acknowledgment The Seven High-Interest Benefits Principles of Acknowledgment Exploring the acknowledgment process Applying the Principles of Acknowledgment within the Context of Your Personal Leadership Style Case study The ROI of Grateful Leadership Creating your Grateful Leadership Personal Action Plan™ Creating a Vision Statement for your organization that incorporates Grateful Leadership into your corporate culture The 360° Grateful Leadership Competency Assessment Summary What did we learn, and how can we implement this in our work environments?