3815 Link courses

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

This course bundle is made up of three separate certification courses: 1. PRINCE2® Foundation; 2. PRINCE2® Practitioner; 3. IASSC Lean Six Sigma Black Belt. The PRINCE2® Foundation And Practitioner course includes the official certification exams. By passing the Foundation and Practitioner exams, you will be an officially certified PRINCE2® Practitioner. The IASSC Lean Six Sigma Black Belt course includes the official IASSC Six Sigma Black Belt exam. By passing this exam, you will be officially certified by the IASSC as a Six Sigma Black Belt. You have 14 months to complete all of the courses in this bundle and take the exams. Read below to find out more about the courses contained within this bundle.

Use Cases for Business Analysis: Virtual In-House Training The use case is a method for documenting the interactions between the user of a system and the system itself. Use cases have been in the software development lexicon for over twenty years, ever since it was introduced by Ivar Jacobson in the late 1980s. They were originally intended as aids to software design in object-oriented approaches. However, the method is now used throughout the Solution Development Life Cycle from elicitation through to specifying test cases, and is even applied to software development that is not object oriented. This course identifies how business analysts can apply use cases to the processes of defining the problem domain through elicitation, analyzing the problem, defining the solution, and confirming the validity and usability of the solution. What you will Learn You'll learn how to: Apply the use case method to define the problem domain and discover the conditions that need improvement in a business process Employ use cases in the analysis of requirements and information to create a solution to the business problem Translate use cases into requirements Getting Started Introductions Course structure Course goals and objectives Foundation Concepts Overview of use case modeling What is a use case model? The 'how and why' of use cases When to perform use case modeling Where use cases fit into the solution life cycle Use cases in the problem domain Use cases in the solution domain Use case strengths and weaknesses Use case variations Use case driven development Use case lexicon Use cases Actors and roles Associations Goals Boundaries Use cases though the life cycle Use cases in the life cycle Managing requirements with use cases The life cycle is use case driven Elicitation with Use Cases Overview of the basic mechanics and vocabulary of use cases Apply methods of use case elicitation to define the problem domain, or 'as is' process Use case diagrams Why diagram? Partitioning the domain Use case diagramming guidelines How to employ use case diagrams in elicitation Guidelines for use case elicitation sessions Eliciting the problem domain Use case descriptions Use case generic description template Alternative templates Elements Pre and post conditions Main Success Scenario The conversation Alternate paths Exception paths Writing good use case descriptions Eliciting the detailed workflow with use case descriptions Additional information about use cases Analyzing Requirements with Use Cases Use case analysis on existing requirements Confirming and validating requirements with use cases Confirming and validating information with use cases Defining the actors and use cases in a set of requirements Creating the scenarios Essential (requirements) use case Use case level of detail Use Case Analysis Techniques Generalization and Specialization When to use generalization or specialization Generalization and specialization of actors Generalization and specialization of use cases Examples Associating generalizations Subtleties and guidelines Use Case Extensions The <> association The <> association Applying the extensions Incorporating extension points into use case descriptions Why use these extensions? Extensions or separate use cases Guidelines for extensions Applying use case extensions Patterns and anomalies o Redundant actors Linking hierarchies Granularity issues Non-user interface use cases Quality considerations Use case modeling errors to avoid Evaluating use case descriptions Use case quality checklist Relationship between Use Cases and Business Requirements Creating a Requirements Specification from Use Cases Flowing the conversation into requirements Mapping to functional specifications Adding non-functional requirements Relating use cases to other artifacts Wire diagrams and user interface specifications Tying use cases to test cases and scenarios Project plans and project schedules Relationship between Use Cases and Functional Specifications System use cases Reviewing business use cases Balancing use cases Use case realizations Expanding and explaining complexity Activity diagrams State Machine diagrams Sequence diagrams Activity Diagrams Applying what we know Extension points Use case chaining Identifying decision points Use Case Good Practices The documentation trail for use cases Use case re-use Use case checklist Summary What did we learn, and how can we implement this in our work environment?

A short course in Wellbeing Coaching for individuals who would like to develop coaching skills to support others in improving their wellbeing.

During this live-online masterclass we will focus on understanding recent developments in the mental health and wellbeing of children in the UK, including looking at the impact of cultural and technological changes over recent years and the impact this is having in schools.

If you've been looking for a welcoming space to explore your creativity, come along to our community art & craft workshops. From ceramics to painting, papercraft to hand printing, you're free to explore your creativity, make new friends & relieve some stress in our relaxed, social environment.

Overview Networking has become a crucial factor in the modern workplace. It is the most effective method of developing your business or career and is a key component of your personal brand. This one day course will teach you how to be able to build strong business relationships, develop a level of personal credibility and increase your network of contacts in order to enhance your visibility and create opportunities for yourself and your organisation. Description This training course will help your participants build a professional reputation and develop a network of connections through the two key methods available to them; face-to-face and online. Attendees will discover how to effectively combine these two approaches and create a strategy for networking success that will generate their own community and actively grow their personal network. This will result in an improved performance in their approach to networking and consequently provide opportunities and prospects that will increase their business success. The training provides them with the tools and techniques to both plan a successful, strategic approach to networking and develop their personal communication skills, which will ensure they build effective business relationships. Topics covered: Why Network? – Establishing the importance of networking with some shocking statistics and an activity that defines the importance of networking to the individual. This is followed by some insight into the key aims of a networking strategy, what puts people off, as well as some personal revelations about networking. Increase Your Business Presence – Looking at the components of a strong business presence, including; credibility, personal brand, visibility and social capital. Developing a Networkers Attitude – An exercise that clarifies the perfect attitudes and behaviours of great networkers and comparing the participants against this. Thus identifying areas for development. Face to Face Networking – An overview and insight into the main types of face to face networking opportunities available with the benefits and pitfalls of each. Online Networking – An overview of the different social media and online networking tools and how to get the best out of them. Includes; LinkedIn, Twitter, Facebook and online forums. Communication Skills for Networking Success – Ensuring a good first impression, creating an opening sound bite and writing an online profile that promotes and engages. Developing a Conversation – Building on the opening sound bite and developing a conversation through good questioning techniques and following a selection of key networking rules. Including an activity to test and practice the skills. Working a Room – A fun activity that embeds and develops learning while encouraging practice and communication. This activity covers 10 of the main skills required to work a room. Breaking into a Group – Identifying body language to spot when a group or pair is open to new people entering the conversation or would rather not encourage participation. Knowing how to break into a group, what to say and how to remain professional. Exiting a Conversation – Developing some techniques to extricate oneself from a conversation without causing embarrassment or rudeness. The Follow-Up – Using a structure to identify the most important contacts created and establishing when and how to follow up with each group. Includes example follow-up email and a chance to develop their own. Creating a Network Plan – Participants are provided with a networking action plan to review and complete. This sets them on the journey of developing their networking skills and ensures they have a strategy and goals to target. Who should attend Anyone who is looking to improve their networking performance, or the networking performance of a management or sales team. Requirements for Attendees No pre-requisites required.

Overview Networking has become a crucial factor in the modern workplace. It is the most effective method of developing your business or career and is a key component of your personal brand. This one day course will teach you how to be able to build strong business relationships, develop a level of personal credibility and increase your network of contacts in order to enhance your visibility and create opportunities for yourself and your organisation. Description This training course will help your participants build a professional reputation and develop a network of connections through the two key methods available to them; face-to-face and online. Attendees will discover how to effectively combine these two approaches and create a strategy for networking success that will generate their own community and actively grow their personal network. This will result in an improved performance in their approach to networking and consequently provide opportunities and prospects that will increase their business success. The training provides them with the tools and techniques to both plan a successful, strategic approach to networking and develop their personal communication skills, which will ensure they build effective business relationships. Topics covered: Why Network? – Establishing the importance of networking with some shocking statistics and an activity that defines the importance of networking to the individual. This is followed by some insight into the key aims of a networking strategy, what puts people off, as well as some personal revelations about networking. Increase Your Business Presence – Looking at the components of a strong business presence, including; credibility, personal brand, visibility and social capital. Developing a Networkers Attitude – An exercise that clarifies the perfect attitudes and behaviours of great networkers and comparing the participants against this. Thus identifying areas for development. Face to Face Networking – An overview and insight into the main types of face to face networking opportunities available with the benefits and pitfalls of each. Online Networking – An overview of the different social media and online networking tools and how to get the best out of them. Includes; LinkedIn, Twitter, Facebook and online forums. Communication Skills for Networking Success – Ensuring a good first impression, creating an opening sound bite and writing an online profile that promotes and engages. Developing a Conversation – Building on the opening sound bite and developing a conversation through good questioning techniques and following a selection of key networking rules. Including an activity to test and practice the skills. Working a Room – A fun activity that embeds and develops learning while encouraging practice and communication. This activity covers 10 of the main skills required to work a room. Breaking into a Group – Identifying body language to spot when a group or pair is open to new people entering the conversation or would rather not encourage participation. Knowing how to break into a group, what to say and how to remain professional. Exiting a Conversation – Developing some techniques to extricate oneself from a conversation without causing embarrassment or rudeness. The Follow-Up – Using a structure to identify the most important contacts created and establishing when and how to follow up with each group. Includes example follow-up email and a chance to develop their own. Creating a Network Plan – Participants are provided with a networking action plan to review and complete. This sets them on the journey of developing their networking skills and ensures they have a strategy and goals to target. Who should attend Anyone who is looking to improve their networking performance, or the networking performance of a management or sales team. Requirements for Attendees No pre-requisites required.

To make the drastic carbon reductions that are needed around the world, we need a global population that is educated, engaged and empowered to make the necessary changes. That’s why we believe Carbon Literacy training is so important – and why we need a multitude of trainers to deliver it. The Lighthouse Carbon Literacy - Train the Trainer course is designed to prepare you for delivering Carbon Literacy training, and support you on your journey to becoming a Carbon Literacy Trainer (CLT). Train the Trainer is normally delivered online to cohorts of up to 6 learners. Course timetable:  Tuesday 4 June: 9 - 12:30 Friday 7 June: 9 - 12:30 Friday 14 June: 9 - 12:30 Learners can arrive from 8:45am onwards. What we provide: Three half days of interactive workshops Facilitated peer learning amongst a small group Guided self-study and resources Guidance to inform your road to becoming a certified Trainer Skills for creating your own Carbon Literacy course A practical and hands-on approach to Carbon Literacy training 1:1 follow up coaching session Private LinkedIn Group. What you commit to: Attend and engage in training workshops Complete all self-study and homework Complete and submit Trainer evidence to the Carbon Literacy Project. Course requirements: The Lighthouse Train the Trainer course is designed to develop confidence, understanding and training skills in learners who already have a level of understanding of carbon and some experience of delivering training. Before commencing this course, learners should: Have experience of delivering training Have completed a Carbon Literacy training course Have worked with business in some capacity Aspire to deliver Carbon Literacy training either internally within the business they work in, or externally to other businesses. Why Lighthouse? Lighthouse has a proven track record of working with businesses to deliver sustainability improvements, from building circularity into business models to reducing carbon impacts. Last year we trained more than 700 employees from companies including Beko plc; Silent Night; Boston Scientific and PZ Cussons. Our course is fast-paced, informative and action-focused. Price: £750 + VAT. And if these dates don't suit you... If you want to book a course for your employees or discuss the design of a bespoke course, contact hello@lighthouse-sustainability.co.uk.

To make the drastic carbon reductions that are needed around the world, we need a global population that is educated, engaged and empowered to make the necessary changes. That’s why we believe Carbon Literacy training is so important – and why we need a multitude of trainers to deliver it. The Lighthouse Carbon Literacy - Train the Trainer course is designed to prepare you for delivering Carbon Literacy training, and support you on your journey to becoming a Carbon Literacy Trainer (CLT). Train the Trainer is normally delivered online to cohorts of up to 6 learners. Course timetable:  Wednesday 10 April: 9 - 12:30 Wednesday 17 April: 9 - 12:30 Thursday 25 April: 9 - 12:30 Learners can arrive from 8:45am onwards. What we provide: Three half days of interactive workshops Facilitated peer learning amongst a small group Guided self-study and resources Guidance to inform your road to becoming a certified Trainer Skills for creating your own Carbon Literacy course A practical and hands-on approach to Carbon Literacy training 1:1 follow up coaching session Private LinkedIn Group. What you commit to: Attend and engage in training workshops Complete all self-study and homework Complete and submit Trainer evidence to the Carbon Literacy Project. Course requirements: The Lighthouse Train the Trainer course is designed to develop confidence, understanding and training skills in learners who already have a level of understanding of carbon and some experience of delivering training. Before commencing this course, learners should: Have experience of delivering training Have completed a Carbon Literacy training course Have worked with business in some capacity Aspire to deliver Carbon Literacy training either internally within the business they work in, or externally to other businesses. Why Lighthouse? Lighthouse has a proven track record of working with businesses to deliver sustainability improvements, from building circularity into business models to reducing carbon impacts. Last year we trained more than 700 employees from companies including Beko plc; Silent Night; Boston Scientific and PZ Cussons. Our course is fast-paced, informative and action-focused. Price: £750 + VAT. And if these dates don't suit you... If you want to book a course for your employees or discuss the design of a bespoke course, contact hello@lighthouse-sustainability.co.uk.