50652 Courses delivered Online

Microsoft Excel® in Depth: Virtual In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Scrum Product Owner Exam Prep: In-House Training: Virtual In-House Training This workshop prepares you for the Scrum.org PSPO™ I certification. A voucher for the exam and the access information you will need to take the exam will be provided to you via email after you have completed the course. NOTE: If you have participated in any of IIL's other Scrum workshops, you can bypass this program and focus on reading/studying the Scrum Guide and taking practice exams from Scrum.org The Product Owner is responsible for maximizing the value of the product and the work of the Development Team. The Product Owner must be knowledgeable, available, and empowered to make decisions quickly in order for an Agile project to be successful. The Product Owner's key accountability is the Product Backlog. Managing, maintaining, and evolving the Product Backlog involves: Establishing a clear vision that engages the Development Team and stakeholders Clearly expressing Product Backlog items Ordering the items in the Product Backlog to best achieve the vision and goals Ensuring that the Product Backlog is visible, transparent, and clear to all Working with the Development Team throughout the project to create a product that fits the customer's need The Professional Scrum Product Owner™ I (PSPO I) certificate is a Scrum.org credential that enables successful candidates to demonstrate a fundamental level of Scrum mastery. PSPO I credential holders demonstrate an intermediate understanding of the Scrum framework, and how to apply it to maximize the value delivered with a product. They will exhibit a dedication to continued professional development, and a high level of commitment to their field of practice. Scrum.org does not require that you take their own sponsored or any preparatory training. However, training can facilitate your preparation for this credential. And this course is based on IIL's Scrum Product Owner Workshop, which is aligned with The Scrum Guide™. It will provide you with the information you need to pass the exam and IIL will make the arrangements for your online exam. You will be provided with an exam code and instructions, so that you can take the exam at your convenience, any time you are ready after the course. Passwords have no expiration date, but they are valid for one attempt only. See additional exam details on the next page. What you will Learn You'll learn how to: Successfully prepare for the Scrum.org PSPO I exam Identify the characteristics of a successful Product Owner Create a powerful vision statement Apply techniques to understand your customers and the market Manage and engage stakeholders Write effective user stories with acceptance criteria Utilize techniques to visualize and prioritize the Product Backlog Participate in the 5 Scrum events as the Product Owner Understand the Product Owner's role in closing a Scrum project Getting Started Introductions Workshop orientation Exam prep preview Fundamentals Recap Agile Manifesto, values, and mindset Product Owner characteristics Good vs. great Product Owner Product Ownership Product ownership Project vision Understand your customers and market Personas Stakeholder management and engagement The Product Backlog User Stories and Acceptance Criteria Preparing User Stories for a Sprint The Product Backlog Visualizing the Product Backlog Product Backlog Prioritization Technical Debt Sprint Planning and Daily Standups Sprint Planning Planning Poker Team Engagement Daily Standups Sprint Review, Retrospectives, and Closing Sprint Reviews Key Agile Patterns Retrospectives Closing the Project Summary and Next Steps Review of course goals, objectives, and content Exam prep next steps

Who is this gas engineer training course aimed at? This gas engineer course is aimed at beginners who would like to enter the gas industry and begin a career as a gas installer. It has been specifically designed for those with no previous experience or limited experience within the gas industry or who have relevant mechanical, engineering, or construction qualifications or experience. If you already have experience in a related trade (e.g., plumbing) our Managed Learning Programme for experienced trades may be a better fit for you. What is the managed learning programme? This is a package course that has been developed by Logic Certification Limited (LCL) and is recognised by the gas industry’s Standard Setting Body (SSB.) It is a route for new entrants to learn, develop and build a portfolio within the gas industry. Once this MLP is completed, candidates can then move on to the new entrant ACS assessment, allowing them to be on the Gas Safe Register

A four-hour workshop on how to retain your talented Neurodiverse colleagues and ensure equality in employment opportunities.

Work stress has been described as the ‘wear and tear’ caused by your working life. In recent times, stress at work has seen a rapidly rising trend. This course looks at your ability to avoid work stress and to control and manage it, when it arises. Excessive and continuous work stress is very damaging, resulting in health problems, loss of productivity and pressure on working relationships. The main problems stem from excessive workloads and impractical deadlines, relationships with colleagues and future job insecurity.

Duration 1 Days 6 CPD hours This course is intended for This course is designed as an introduction to HTML and CSS for those who want to learn to develop standards-compliant web content, with a focus on current HTML5 and CSS3 standards. This course can be taught on Microsoft© Windows©, Apple© Mac OS© X, or Linux©, and supports developers who work in any of those environments. HTML5 is one of the most integral and evolving web technologies that enables a user to structure content and present it on the web.This course lays the foundation for mastering this popular web publishing technology. Authoring Content in HTML Web Development Standards Create an HTML Page Apply HTML Attributes Embedding and Linking Content Embed Content within an HTML Page Link HTML Pages Create Image Maps Formatting Content with CSS Apply Style Sheets to HTML Use CSS to Create Multiple Column Layouts Authoring Complex Content Structures Author Table Content Construct and Format Forms Testing and Publishing HTML Content Identify and Correct Structural and Compatibility Problems Make HTML Content Accessible Publish and Deploy Web Content Additional course details: Nexus Humans HTML5 - Content Authoring Fundamentals 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 HTML5 - Content Authoring Fundamentals 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.

This one-day course introduces the field of user experience and provides an excellent entry point to our other specialised training courses. UX processes and practices have become a central component of product design, service design and web design.

Strategic Thinking: On-Demand The goal of this course is to provide you with the building blocks and the motivation to develop the critical skill of strategic thinking. The participants will consider a four-part model that distinguishes strategic thinking from strategic planning and managing. With that understanding, you will investigate the critical components of strategic thinking and how to apply it effectively. What you Will Learn Define strategic thinking and distinguish it from strategic planning and management Explain a high-level approach to gaining strategic thinking skills Integrate other interpersonal skills, such as self-awareness, systems thinking, leadership, constructive conflict, and collaboration, into the fabric of strategic thinking skills Select appropriate techniques to apply strategic thinking in specific situations Recognize and emulate effective strategic thinking behaviors Getting Started Introductions Course structure Course goals and objectives Foundation Concepts Interactive event: Define Strategic Thinking (ST) Interactive event: Discuss relationship of ST with Strategic Planning, Management and Decision Making Strategic Level Framework - Tying it all together Strategic thinking attributes Strategic Thinking Critical Success Factors Strategic Thinking Critical Success Factors - 5-part model Strategic Thinking and the Organization Critical Success Factors Model applied to an organization Tools Introduction (5): Environmental, 5 Forces, SWOT, Value Proposition, Integral Theory of Worldview Video: Fog of War Strategic Thinking and the Individual Critical Success Factors Model applied to an individual Tools Introduction (5): Thinking Styles, Six Thinking Hats, Reverse Thinking, Systems Thinking, Integral Theory of Worldview Strategic Thinking at the Interpersonal and Team Levels Emotional Intelligence - Self Awareness and Working With Others Team Leadership and Trust Constructive Conflict as the Gateway to Collaboration Interactive event: Testing the Models - Challenge Perspective; What's Missing Applying the critical skill of Strategic Thinking Worldview: Team versus client Trusted Advisor Interactive event: Doing what is asked (Case study, wherein participants review the default case scenario prepared for this workshop and add specific details to make the scenario more relevant to their experiences / needs. Teams develop an action plan for applying ST concepts and techniques they have learned here to the situation, then compare and contrast results.)

Premium Bundle of all Time | Ofqual Regulation + ATHE Awards + CPD Accreditation | Assessment & Tutor Support Included

Join the Scrum.org accredited Live Virtual Class - Professional Scrum Product Owner I™ training (PSPO) to master the fundamentals of Product Ownership. Learn how to take your understanding of Scrum frameworks and apply it to maximise product value. Course Description The Professional Scrum Product Owner (PSPO) course goes beyond requirement writing and Product Backlog management. It equips Product Owners with a comprehensive understanding of product management needed to drive value from their products. The PSPO course is Scrum.org certified and delivered by our professional Scrum trainers. We combine real world industry experience with a hands-on practical approach, the result of which is a 98% first-time pass rate. Say goodbye to PowerPoint and join our interactive PSPO training course to gain key practical skillsets and learn how how to implement frameworks immediately to deliver tangibel results. Embrace a product-focused mindset over project-oriented thinking. Bridge business strategy to product execution with Scrum. Recognise the Product Owner's role as an Agile Product Manager. Master Scrum Principles and Empiricism. Understand Product Owner responsibilities within the Scrum Team. Align the team with business strategy, product vision, Product Goal, and Sprint Goal. Communicate business strategy, product vision, and Product Goal effectively. Learn techniques for Product Backlog Management, Release Management, and Forecasting. Identify valuable metrics for tracking value creation and successful product delivery. Employ techniques to engage stakeholders, customers, and Scrum Team members effectively. Why Train With Us? Develop and solidify your knowledge of the Scrum Framework and the accountabilities of being a product owner with our immersive two-day online PSPO course through instruction and team-based exercises. Led by experienced industry professionals and supportive Professional Scrum Trainers & Product Owners, we go beyond powerpoint to offer engaging, hands-on learning experiences. From debunking myths to empowering your Scrum Teams with the right practices, we'll be with you every step of the way - from learning to passing the test and implementing it seamlessly into your job context. Who Should Attend This Course? Ideal for students across industries dealing with complex problem-solving, the Professional Scrum Product Owner course targets three key groups: Aspiring Product Owners seeking to start their career in the field. Experienced Product Owners aiming to enhance their understanding and address misconceptions about Scrum and the Product Owner role. Scrum Masters desiring to become effective coaches for Product Owners, gaining valuable insights from the course. 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