2974 Link courses delivered Online

Microsoft Excel® in Depth: 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

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?

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.

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

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 12 March: 9 - 12:30 Friday 15 March: 9 - 12:30 Friday 22 March: 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:  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.

Microsoft Project Orange Belt ® 2013 - Español: On-Demand This course is intended for both novice and experienced project managers, or any user of Project 2013. Participants must be involved in or be responsible for scheduling, estimating, budgeting, coordinating, controlling, and staffing projects and supporting projects. Project 2013 users. This course is intended for both new and experienced project managers, or any user of Project 2013. Participants must be involved in or responsible for scheduling, estimating, budgeting, coordinating, controlling, and staffing projects and supporting Project 2013 users. What You Will Learn Understand what's new in the Project 2013 release. Initialize Project to start flattening. Create a good project schedule, including WBS, estimates, dependencies, constraints, deadlines, and calendar usage. Assign resources and costs to tasks. Understand the types of tasks and the scheduling formula. Analyze the use of resources and optimize the schedule. Establish a baseline and a progress monitoring strategy. Use Earned Value Explain the potential of managing multiple projects. Ready to Go with Project 2013 Summary of Project 2013 Establish a new Project Schedule (Options, templates, files, etc.) Set the Project Schedule Enter Tasks The Planning Process Importar Tareas (Word, Excel, SharePoint) Create and manage a WBS (includes tasks, manual tasks, summary tasks, milestones, and WBS coding) Enter Estimates Trends in estimates The Gradual Planning Approach Enter Estimates on Duration and Effort Task types Enter Dependencies The principles of Dynamic Programming Types of Dependencies Selecting the right type of dependency Enter Dependencies in Project 2013 Understanding Due Dates, Restrictions and Task Calendar Use Deadlines and Restrictions Enter Deadlines and Restrictions in Project 2013 Enter Resources and Costs Resource Types Enter Resources in Project 2013 Calendars and Resources Enter Costs in Project 2013 Enter Assignments Assignments on a Schedule Assignments and Task Types Enter Assignments in Project 2013 Allocations and Costs Optimize the Schedule The Critical Path Method and the Resource Critical Path Resource Leveling Optimize Time, Cost and Resources in Project 2013 Update Schedule the baseline Strategies and Update Situations Prepare the Status and Forecast Report in Project 2013 Reports Using reports and dashboards Using visual reports Format and print reports Customize fields and views Earned Value Management (EVM) Earned Value Summary Applying Earned Value in Project 2013 Evaluate the Project Why evaluate? Compare results against baselines Generate templates for future projects Consolidated Schedules Creating a Consolidated Schedule Use a resource group Links between projects Solving common problems Baseline and follow-up

Program Management Skills: On-Demand Program managers coordinate and give oversight to the efforts of marketing groups, project teams, product delivery, maintenance and support, operations and staff from various functional groups, including suppliers, business partners, and other external bodies. The goal is to ensure that proposed business transformation, through the delivery of complex products and processes, is implemented to realize the organization's strategic benefits and objectives, for which the program was selected. The goals of this course are twofold: To provide participants with key program management principles and techniques, recognized as best practices, to enable more effective program management; and to leverage core elements of the program management life cycle, processes, tools and techniques, to enable program management effectiveness. The participant will learn and apply the principles of program management through discussions, activities, and case study exercises. What You Will Learn At the end of this workshop, you will be able to: Maximize the transformational impact of a program according to the business needs Explain management principles and techniques and apply them within a program context Implement program governance and organization that will produce expected benefits Plan for and manage benefit realization, risks, issues, and quality Manage component projects' interdependencies that are linked to both program and strategic objectives Engage program stakeholders effectively. Improve communication and action planning effectiveness for programs in organizations Getting Started Introductions Course structure Course goals and objectives Foundation Concepts Fundamental definitions and concepts Program challenges and benefits Program best practices and success criterion Stakeholder management Governance: program management office and program boards Standard for Program Management overview Vision, Leadership, and the Business Case What is vision, why, and how? Leadership vs. Management Program business case Program Organization and Governance Program organization Program governance Program board roles and responsibilities Benefits Management Benefits explored Benefits management Benefits realization Program Management Planning Program management plan Program blueprint and roadmap Program component dossier Program tranches Program estimating Program scheduling Program Monitoring and Controlling Program Control - An Overview Program Monitoring and Controlling Monitoring and Controlling Transition Program Risk and Issue Management Risk and issue management overview Program risk management Program issue management Program Quality Management Program quality management overview Program quality management principles Program Stakeholder Management Stakeholder engagement overview Stakeholder engagement planning EI, trust, communication and stakeholder engagement Program Closure and Benefits Sustainment Program closure overview Closing the program Program benefits sustainment Summary What did we learn, and how can we implement this in our work environments?

With Actress, Acting and Audition Coach Sarah Hannah Introduction Join our internationally recognised Screen Acting Weekly Course and develop your technical performance skills and character understanding over 5 Weekly Evening Sessions before applying your new skills on a professional set at Pinewood Studios as you participate in filming two showreel scenes. Over weekly sessions, the Director will use practical techniques to build your confidence in performance and help you master the technical requirements to be a successful screen actor. You will focus on the importance of character preparations, how to portray emotion, comedy and drama on camera in addition to career advice before shooting a professional acting showreel. Upon completion of the Screen Acting Weekly course, you will emerge with a heightened sense of assurance and confidence in your screen acting abilities and the tools to progress with your acting career, whether you’re new to the industry or a Drama School Graduate looking for more acting opportunities in TV & Film. Meet Your Tutor Sarah Hannah Acting Coach Sarah Hannah is a highly experienced Professional Actress, Acting and Audition Coach. Bringing her extensive experience of working on stage and on screen, Sarah will focus on enhancing your presence on camera and cover the technical skills required of a professional screen actor. Course Outline The course led by Acting Coach Sarah Hannah is held at The Audition House, Central London, and the first 5 weekly sessions run for 3 hours (6-9pm). There are 3 additional showreel filming sessions at Pinewood Studios. You will be required for 2 out of the 3 filming sessions. We film during the day and you will be given a specific filming time and will not be required all day. As this course is inclusive of all levels of ability, it offers a comprehensive overview of screen acting skills, starting from the basics and progressing to more advanced concepts. It will include resources, material and instructional stratergies that cater to beginners while also offering challenges for those with more advanced skills. Booking Options Select a course date and add to cart to proceed with payment. This course has limited availability and spaces are first come first served. Please read our Terms and Conditions before proceeding with your booking. £750.00 Weds 24th April-Thurs 30th May 2024 Lesson 1: Wednesday 24th April 2024 – 6-9pm Central London Lesson 2: Wednesday 1st May 2024 – 6-9pm Central London Lesson 3: Wednesday 8th May 2024– 6-9pm Central London Lesson 4: Wednesday 15th May 2024 – 6-9pm Central London Lesson 5: Wednesday 22nd May 2024 – 6-9pm Central London Filming Sessions: Tuesday 28th, Wednesday 29th and Thursday 30th May 2024 at Pinewood Studios. You are required for 2 of the 3 filming sessions. Weds 18th Sept-Thurs 24th Oct 2024 Lesson 1: Wednesday 18th September 2024 – 6-9pm Central London Lesson 2: Wednesday 25th September 2024 – 6-9pm Central London Lesson 3: Wednesday 2nd October 2024– 6-9pm Central London Lesson 4: Wednesday 9th October 2024 – 6-9pm Central London Lesson 5: Wednesday 16th October 2024 – 6-9pm Central London Filming Sessions: Tuesday 22nd, Wednesday 23rd and Thursday 24th October 2024 at Pinewood Studios. You are required for 2 of the 3 filming sessions. Additional Information Features Practical acting training for screen Shoot two scenes for your professional acting showreel with our Award Winning Crew Suitable if you are (17 yrs+) and committed to improving your screen acting skills Attracts a varied age range from 17 yrs+. International Students Welcome The course is taught in English, so it is important that you have proficient English language skills Small Class Size Learning Outcomes Learn techniques to effectively analyse a Film/TV Script Create truthful and inspirational characters Build confidence performing in-front of camera Understanding the workflow of a busy film set Audition preparation Career advice and direction – how to market yourself Course Location Training Sessions (1-5) 6pm – 9pmThe Audition House, 129A Whitfield Street, Fitzrovia, London, W1T 5EQ The Audition House is a two minute walk from Warren Street tube and 5 minutes from Euston Station Filming Sessions (6-8) Between 8am and 4pmActors Studio, Pinewood Studios, Pinewood Road, Iver Heath, Buckinghamshire, SL0 0NH Free Parking available at Pinewood Studios Free frequent shuttle bus service from London Uxbridge Tube Station, Slough and Gerrards Cross. Transfer from station to Pinewood Studios – 10 minutes Canteen and Coffee shops on site Excellent transport links from London