825 Courses in Sheffield delivered Live Online

In this webinar, we will explore the powerful features and benefits of Cademy - the UK's largest education directory, and the all-in-one platform for hosting education services in-person and online.

The Professional Agile Leadership Essentials (PAL-E) is a 2-day hands-on workshop that uses a combination of instruction and hands-on exercises to help managers and other leaders who work directly with agile teams understand how to best support, guide, and coach their teams to improve their agile capabilities. Course Description Professional Agile Leadership Essentials (Scrum.org) Training ONLINE PAL E - Professional Agile Leadership Essentials Agile leadership has a lot to offer businesses today. Organizations have changed a great deal over the years and are no longer the static, structured entities they once were. Agile teams and agile leadership respond to these changes, offering a new way to achieve better results. PAL-E training is designed to help managers, and other leaders, understand how to approach an Agile transformation, and to guide teams to be successful.  Agile teams and leadership bring real benefit Agile organisations and teams thrive in unpredictable and changing environments. They are able to improve efficiency and react quickly to changing markets and customer needs. Achieving this is not something that just happens. The transformation to become an agile organisation is profound, requiring senior leaders, managers, and team members to change how they organise themselves and others, alongside how they work and measure results.  According to consultancy McKinsey: "the key to a successful Agile transformation is for leaders, particularly senior leaders, to develop substantially new mind-sets and capabilities." Scrum Training is a perfect first step in this. Professional Agile Leadership Essentials training The Professional Agile Leadership Essentials (PAL-E) course is a certified 2-day online workshop for team managers and leaders. It will show managers how to effectively develop, support, and guide agile teams to improve their performance. Agile teams are different from traditional structures. There is much more focus on continuous development and learning, as well as self-organisation. The course provides a foundation for managers' and leaders' roles in creating the conditions for a successful Agile transformation. Through detailed instruction and practical exercises, this course will teach leaders and managers how to form, support, and enhance Agile teams. It will guide them through the business, cultural and behavioural changes that must be made to take full advantages of the possibilities of Agile teams. PAL-E Course contents and key objectives The Professional Agile Leadership Essentials course will provide a solid grounding in the background and importance of agile leadership and how to apply it in leading teams.  The main content and learning includes: An understanding of what Agile is, the benefits and impact it can have on business, and the role a manager plays in achieving this. Challenges and techniques of Agile management, and the role management plays in an Agile organisation. How to develop and support Agile teams. How to measure and guide Agile product delivery, and an understanding of core problems in product development. An understanding of how to measure the benefits and impacts of agility in your organisation. Expected Outcomes from a PAL-E workshop PAL-E training highlights how Agile teams perform and the role of leaders and managers in establishing and developing their teams. Agile can help an organisation thrive through a framework that provides a flexible approach to challenges and problem solving. Thje Professional Agile Leadership Essentials course enables you to lead your teams and implement core Agile frameworks that deliver real business benefits. Who Should Attend This Course? Professional Agile Leadership essentials course is designed for leaders and managers in Agile organisations. It is suited to anyone responsible for setting up or establishing Agile techniques and for those managing teams and improving ongoing methods and techniques. After completing the course, participants can obtain industry-recognised certification. This will require passing a rigorous online assessment following the training. There are then plenty more courses that can take you further into Agile techniques. Scrum Master Training, for example, will guide participants through the industry-leading scrum framework for Agile practices. Your Professional Scrum Trainer Meet Jay, founder of Fractal Systems and a dedicated Professional Scrum Trainer. With over 20 years of experience in team and leadership roles, Jay is well-versed in delivering continuous value. His unique teaching approach involves zero PowerPoint and instead relies on engaging, experience-based sessions using techniques from Liberating Structures and Neuro Linguistic Programming. Jay's expertise lies in business transformations, offering training, mentoring, coaching, and consulting to foster success through collaborative efforts. Rapid learning and practical application are the hallmarks of his approach. Jay & the entire Fractal team are invested in your learning journey and are here to support you from start to end, including offering additional valuable support: Free practice assessments for certification success Free resource bundle to master Scrum Free exam revision sheets Free access to an exam simulator Free exam coaching sessions for first-time success Free 1:1 coaching to excel at work Our Clients Our Testimonials

Historical Association webinar series: Direct history teaching Presenters: Mike Hill and Jacob Olivey In this opening session, Jacob and Mike will outline what they mean by direct history teaching. They will explain how this differs from some methods that have become common in history teaching – and why a more direct approach can be more effective, inclusive, and enjoyable for pupils.  To use your corporate recording offer on this webinar please fill in this form: https://forms.office.com/e/Qr1PfgRHSS We are able to offer the webinars in this series at a subsidised cost as the presenters' time has been partially funded by their school, Ark Soane Academy. We are open to developing partnerships across schools and trusts. If you are interested in discussing this further, please contact Mel Jones at melanie.jones@history.org.uk

Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course are persons who are new to reporting with Microsoft© SQL Server© Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors. The secondary audience for this course are persons who are using Report Designer (SSRS). Course participants may be business analysts, programmer analysts, data analysts, database administrators, or IT professionals and may or may not have experience with Microsoft© SQL Server© Report Builder and SSRS, programming (Visual Basic), and/or Transact-Structured Query Language (T-SQL) experience. Overview After completing this course, students will be able to: Create parameter reports. Create list reports. Format reports with complex expressions. Add images and subreports. Add drilldown and drillthrough functionality. Add sparklines, data bars, and indicators. In this course, students will continue their learning on the foundations of report writing with Microsoft© SQL Server© Report Builder and SSRS. The focus will be on report creation by connecting to a database and manipulating the data. 1 - Parameter Reports Parameterized Reporting Create Report Parameters Modify Report Parameters Provide Default Parameter Values Provide Available Values for Parameters Lab: Creating Parameterized Reports 2 - List Data Regions Introducing the List Data Region Create Reports Using List Data Regions Modify Reports Which Use List Data Regions Lab: Creating List Reports 3 - Enhancing Reports with Complex Expressions Formatting Reports Top N Reports Running Values Lab: Enhancing Reports with Complex Expressions 4 - Enhance Reports with Images and Subreports Add Images to Reports Retrieve Images from a Database Introducing SSRS (SQL Server Reporting Services) Report Server Add Subreports to Reports Lab: Working With Images and Subreports 5 - Drilldown and Drillthrough Reports Add and Configure Drilldown Reporting Add and Configure Drillthrough Reporting Lab: Add Drilldown and Drillthrough Functionality to Reports 6 - Sparklines, Data Bars, and Indicators Sparklines Data Bars Indicators Lab: Adding Sparklines, Data Bars, and Indicators to Reports Additional course details: Nexus Humans 55128 Writing Reports with Report Builder and SSRS Level 2 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the 55128 Writing Reports with Report Builder and SSRS Level 2 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

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 classroom, one to one, tailored and bespoke courses. Tailored In Company training: 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. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Duration 2 Days 12 CPD hours This course is intended for Operations managers, account representatives, customer service staff, help desk and technical support, and anyone working directly with customer will benefit from this course. Overview Define customer service in relation to both internal and external customers Recognize how your attitude affects customer service Identify your customer\'s needs Generate repeat business with outstanding customer service Build goodwill through in-person customer service Provide outstanding customer service over the phone Connect with customers through online tools Deal effectively with difficult situations This course offers practical tools and techniques to win clients, create loyal advocates for your business, and deliver excellent customer service. Private classes on this topic are available. We can address your organization?s issues, time constraints, and save you money, too. Contact us to find out how. 1. Customer Service - A Baseline Recognizing Your Customers Understanding Your Role in Customer Service 2. Developing A Customer Service Mind-Set Leveraging Your First Impression Feeling Positively About Customers Mastering Moods and Emotions 3. Identifying Customer Needs Understanding the Customer\'s Situation Avoiding Assumption and Prejudgment Meeting Basic Needs Seeking to Exceeding Expectations Building Repeat Relationships 4. Connecting with the Customer Achieving Authenticity through Body Language Responding Effectively to Problems Mastering Online Etiquette Seeking Customer Feedback 5. Dealing with Difficult Situations Effectively Addressing Complaints De-escalating Anger Establishing Common Ground Remaining Calm, Respectful and Objective 6. Effectively Addressing Complaints Creating a Memorable Customer Experience Additional course details: Nexus Humans Providing Outstanding Customer Service training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Providing Outstanding Customer Service course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Embark on an exciting adventure with our Trail Hunting Course, where we delve into the art of teaching dogs to follow a scent trail of a specific odor in their environment. This course offers the perfect blend of tracking and trailing, honing in on your canine companion's natural instincts.

Learners will be introduced to the design, installation, commissioning, and maintenance of Access Control systems.

Duration 2 Days 12 CPD hours This course is intended for Any professionals who need to work effectively with others without direct authority, as well as mid- and upper-level executives and managers who would benefit from understanding the motivations of others to achieve successful results for the business. Overview Build workplace relationships based on mutual trust and respect Collaborate effectively through influence and persuasion Recognize and enhance your sources of personal power Choose and apply appropriate influence strategies Work with resistance to gain commitment and buy-in In this course, you will learn to become proficient in the art of persuasion, selecting and utilizing appropriate styles and strategies to have the most influential effect, as well as understanding how to protect yourself from being manipulated by others. Private classes on this topic are available. We can address your organization?s issues, time constraints, and save you money, too. Contact us to find out how. 1. An Influence Baseline Enabling Collaboration Facilitating Constructive Dialogue 2. Elements of Influence Focusing on the Outcome Seeing Influence as a Mental Equation Differentiating Influence from Manipulation 3. Power and Persuasion Developing and Using Power Sources Developing the Art of Persuasion Appealing to Integrity, Emotions, and Intellect Building Five Types of Trust Applying Five Principles of Influence 4. A Network of Influence Building a Purposeful Network Strategic Reputation Management Protecting Your Credibility 5. Applying Influence Strategies Adapting the Approach Identifying Thinking Differences Applying Strategies to Styles 6. Working With Resistance Encountering and Addressing Resistance Building Collaboration through Quality Dialogue Getting Results through Persistence and Persuasion Additional course details: Nexus Humans Extending Your Sphere of Influence training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Extending Your Sphere of Influence course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Leading Cross-Cultural Virtual Teams: In-House Training High-performing teams are a must in this world of intense competition and higher expectations. Global virtual teaming has become a necessity as organizations become increasingly distributed and suppliers and clients actively engage in joint projects. Teams work across geographical and organizational boundaries to deliver solutions and services to global users where distance and differences, both geographic and cultural, amplify the effect of issues and factors that are relatively straightforward when managing a team of people in the same location. This course delivers practical concepts and techniques that participants will start using immediately on their global projects. What you will Learn At the end of this program, you will be able to: Define relationships among foundational concepts (leadership and three dimensions of diversity) and explain their potential impacts on project performance Describe key components of successful project leadership and build selected Transformational Leadership skills Prepare to convert project challenges stemming from personal or cultural diversity into potential competitive advantage Implement selected best practices to meet key challenges facing virtual project teams Foster and grow an environment that supports continued success for CCVTs Foundation Concepts Basic definitions Critical success factors for leading cross-cultural virtual teams (CCVTs) A roadmap to success for leading CCVTs Leadership Excellence in Any Project Environment Leading effectively in a global environment Transformational leadership The four components of Transformational Leadership Leveraging Personal Diversity Overview of personal diversity Mind styles The theory of multiple intelligences Connecting Transformational Leadership and personal diversity Embracing Cultural Diversity Introduction to cultural intelligence The impact of culture Cultural Dimensions Theory The Culture Map Managing Virtual Diversity Overview of virtual diversity Virtual time management Virtual processes and technology Virtual leadership Creating an Environment for Success Supporting a cross-cultural virtual-team (CCVT-) friendly environment Building a foundation of trust Developing a team charter Recap and review Summary and Next Steps Personal action plan