5522 Courses in London delivered Live Online

Scrum Master Workshop: In-House Training: Virtual In-House Training A Scrum Master helps project teams properly use the Scrum framework, increasing the likelihood of the project's overall success. Scrum Masters understand Scrum values, practices, and applications and provide a level of knowledge and expertise above and beyond that of typical project managers. Scrum Masters act as 'servant leaders', helping the rest of the Scrum Team work together and learn the Scrum framework. Scrum Masters also protect the team from both internal and external distractions. What you will Learn You'll learn how to: Comprehend the Agile Manifesto and mindset Explain the fundamental principles of Scrum Guide the Scrum team in their responsibilities Write requirements in the form of user stories Define Ready and Done Estimate using planning poker and prioritize using MoSCoW Facilitate the team through the 5 Sprint events Fulfill the role of Scrum Master in a Scrum project Create Information Radiators to enable transparency Define the structure of the retrospective Foundation Concepts Agile History, Values, and Mindset Introduction to Scrum Scrum events Scrum artifacts Scrum Roles and Responsibilities Product Owner responsibilities Scrum Master responsibilities The Team responsibilities Cross-functional Teams Building Effective Teams The Product Backlog and User Stories The Product Backlog User Stories Definition of Done Backlog grooming Estimating User Stories Story points, planning poker Prioritizing User Stories The Sprint Team capacity and velocity The Sprint Planning Meeting The Sprint Backlog The Sprint Learning to self-manage, self-organize, self-improve Sprint Review and Retrospective Project Progress and Completion The Daily Scrum The Task Board and The Burndown Chart Information Radiators Closing a Scrum Project Summary and Next Steps Review of course goals, objectives, and content

These courses are designed for aspiring 3D artists, students, graduates, creative professionals, CAD designers, and anyone passionate about 3D art. Whether you're looking to launch a career, enhance existing skills, or explore new creative avenues, our courses provide comprehensive training tailored to various skill levels and interests. Check our Website Duration: 16 hours Method: 1-on-1 and Tailored content Dates and Times: Select your preferred hour from Monday to Saturday, available between 9 am and 7 pm. CAD and 3D Studio Max Training Course Duration: 16 hours Course Outline: Introduction to AutoCAD Familiarizing yourself with the AutoCAD interface Navigating the drawing environment Mastering fundamental 2D geometry creation Exploring essential drawing tools and commands Introduction to blocks and symbols for efficient design Advanced AutoCAD Techniques Delving into advanced drawing methods Proficiently manipulating and editing 2D geometry Crafting custom symbols and blocks for enhanced productivity Working with text and annotations for clear communication Utilizing layers and line types for organized design 3D Modeling in AutoCAD Venturing into the world of 3D modeling Precision crafting of 3D solids and surfaces Seamless modification and manipulation of 3D geometry Crafting custom materials and textures for realistic designs Effective utilization of AutoCAD's lighting and camera systems Introduction to 3ds Max Embracing the 3ds Max interface and configuring the workspace Proficiency in navigating within 3ds Max Understanding the viewport for optimized design Exploring basic 3D modeling techniques in 3ds Max Materials and Textures in 3ds Max Application and modification of textures for enhanced designs Mastering the art of UVW mapping for precise texturing Utilizing the material editor for creative freedom Crafting custom materials aligned with your design vision Harnessing the power of Vray materials for lifelike renders Lighting in 3ds Max Introduction to various lighting techniques Grasping light properties for impactful designs Strategic setup of lights to enhance scenes Illuminating scenes with Vray lights Cameras in 3ds Max Mastery of camera systems in 3ds Max Exploring camera properties for cinematic effects Creating animations with cameras for dynamic scenes Utilizing Vray cameras for stunning renders Rendering in 3ds Max Unveiling the art of rendering Utilizing Vray Global Illumination for realistic lighting Leveraging Vray Physical Cameras for precise control Enhancing scenes with Vray HDRI Lighting Following a Vray Rendering Workflow for professional results Advanced Modeling Techniques Proficiency in crafting complex geometry Utilizing modifiers for intricate designs Exploring polygonal modeling for versatile creations Creating both organic and inorganic models with expertise Unleashing the potential of advanced modeling techniques Projects Application of acquired skills to create real-world scenes Designing a detailed interior scene with meticulous attention Crafting a visually impactful exterior scene Creating a complex scene featuring multiple objects and materials Course Requirements: A computer with AutoCAD and 3ds Max installed Basic knowledge of computer operations A keen interest in 2D and 3D modeling and design Course Goals: Upon course completion, you will possess a comprehensive understanding of AutoCAD and 3ds Max, enabling you to craft intricate 3D scenes enriched with advanced materials, textures, lighting, and rendering. These newfound skills empower you to advance your capabilities in both 2D and 3D modeling and rendering. Upon successful completion of this comprehensive AutoCAD and 3ds Max training, participants will attain the following skills: AutoCAD Proficiency: Mastery of 2D geometry, drawing tools, and symbols. Advanced AutoCAD Techniques: Expertise in editing, custom blocks, text, and layers. 3D Modeling in AutoCAD: Competence in crafting 3D solids, textures, and lighting. Introduction to 3ds Max: Proficient navigation of the interface and fundamental 3D modeling. Materials and Textures: Application and customization of textures using Vray. Lighting and Cameras: Mastery of lighting and camera systems within 3ds Max. Rendering: Production of high-quality renders through Vray. Advanced Modeling: Proficiency in handling complex geometry and creating organic models. Real-World Projects: Capability to design interiors, exteriors, and intricate scenes. Skills Acquired: Mastering 3D Modeling Techniques in 3D Studio Max Advanced Texturing and Material Application Skills Proficiency in Lighting and Rendering Techniques Expertise in Animation and Keyframe Techniques Comprehensive Scene Composition and Camera Setup Knowledge Career Opportunities: Senior 3D Modeler Experienced CAD Designer Lighting and Rendering Specialist Animation Director Architectural Visualization Expert Upon completing our 3D Studio Max and CAD Courses, students will acquire advanced 3D modeling, animation, and CAD design skills, paving the way for rewarding careers in roles such as Senior 3D Modeler, CAD Designer, Lighting Specialist, Animation Director, and Architectural Visualization Expert. You will gain access to the following benefits: An Autocad and 3ds Max Certificate of Attendance. A comprehensive PDF training guide for 3ds Max and CAD. Real-time feedback during sessions, with the option to record them as video archives. We offer the following advantages: Price guarantee to ensure the best value for your investment. Personalized one-on-one training for focused learning. Flexible scheduling options available seven days a week, from 9 am to 7 pm. Lifetime email and phone support for ongoing assistance. Assistance with software installation and computer setup. Referral discounts and special offers on group training courses.

Duration 2 Days 12 CPD hours This course is intended for This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data, and visualize data and insights using advanced visualizations in charts and dashboards in Excel. To ensure success, you should have baseline skill using Microsoft Excel worksheets, particularly in creating workbooks with formulas and function Overview #NAME? Analyzing data to find issues, insights and opportunities, is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways. Microsoft© Excel© is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis and create diverse and robust data-backed visualizations to show insights, trends, and create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action. 1 - DATA ANALYSIS FUNDAMENTALS Introduction to Data Science Create and Modify Tables Sort and Filter Data 2 - VISUALIZING DATA WITH EXCEL Visualize Data with Charts Modify and Format Charts Apply Best Practices in Chart Design 3 - ANALYZING DATA WITH FORMULAS AND FUNCTIONS Analyze Data with Formulas and Named Ranges Analyze Data with Functions Implement Data Validation, Forms, and Controls Create Conditional Visualizations with Lookup Functions 4 - ANALYZING DATA WITH PIVOTTABLES Create a PivotTable Analyze PivotTable Data 5 - PRESENTING VISUAL INSIGHTS WITH DASHBOARDS IN EXCEL Visualize Data with PivotCharts Filter Data Using Slicers and Timelines Create a Dashboard in Excel 6 - CREATING GEOSPATIAL VISUALIZATIONS WITH EXCEL Create Map Charts in Excel Customize Map Charts in Excel 7 - PERFORMING STATISTICAL ANALYSIS Visualize Trendlines and Sparklines with Excel Analyze Data with the Data Analysis ToolPa 8 - GETTING AND TRANSFORMING DATA Connect to Data with Queries Clean and Combine Data Shape and Transform Data 9 - MODELING AND ANALYZING DATA WITH POWER PIVOT Install Power Pivot in Excel Create Data Models with Power Pivot Create Power Pivots Perform Advanced Data Analysis and Visualization 10 - PRESENTING INSIGHTS WITH REPORTS (OPTIONAL) Plan a Report Create a Report

Course Objectives At the end of this course you will be able to: Identify the components of the Microsoft Project environment Create a new project plan Create the project schedule Use different views to analyse the project plan Create, allocate and manage resources in a project plan Finalise a project plan Track progress View and report project plan information ' 1 year email support service Customer Feedback Very good course. Learnt a lot. Looking forward to the next level. Alexandra - CIAL ' 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 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. Introduction to Microsoft Project Recap on project management concepts Project environment overview The 3 databases: Tasks, Resources and Assignments Different ways of displaying the Project Plan Access Help Creating a Project Plan Create a New Project Plan Project Information Create and apply the project calendar Defining recurring exceptions to the calendar Defining the calendar's work weeks Create the Summary tasks Create the Work Breakdown Structure Task creation and scheduling Exploring the Entry Table and its fields Task editing and the Task Information window Task Durations Defining Milestones Manual Scheduling vs Automatic Scheduling Changing the Task's Calendar Create a split in a Task Create Task Relationships Adding Lag or Lead to a Relationship Identifying the Critical Path Adding Constraints and Deadlines to Tasks Create Recurring Activities Adding Notes and links to Tasks Managing Resources Exploring the Entry Table and its fields Resource editing and the Resource Information window Resource Types Fixed Costs vs Variable Costs Adding Resource Costs Defining when costs accrue Changing the Resource Calendar and Availability Project calendar vs Resource and Task Calendar Assigning Resources to Tasks Effort Driven Scheduling Resolving Resource Overallocation Tracking the Project Progress Setting a Project Baseline Entering Actuals Different ways of viewing the Progress Checking if the Project is on track Viewing and Reporting Project Detail Adding Tasks to the Timeline and sharing it Modifying the Timescale and Zoom level Formatting the Gantt View Filtering and Grouping Tasks Print and Troubleshoot the Gantt View Using built-in Reports in Microsoft Project Who is this course for? Who is this course for? This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans. Requirements Requirements General knowledge of the Windows OS Career path Career path Microsoft Office 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

This 1 day course is designed for the end user who is using or will use Office 365. This course will provide delegates with the knowledge and skills to efficiently use Office 365 on a day-to-day basis. The course is designed with real world scenarios in mind. Delegates will learn how to use Outlook Online, Skype for Business, OneDrive for Business, SharePoint Online, and OneNote. At the end of this course delegates will be able to effectively navigate Office 365 and make use of all of the features of Office 365 Office 365 Overview Introducing Cloud Computing Identify and Outline the Component Products in Office 365 including Outlook Web App, Office Online Apps, OneDrive and Skype for Business Navigating around Office 365 Customising the Office 365 Nav Bar Updating your Profile in Office 365 Using the Outlook Online Application Overview of Outlook Online Working with Email and Folders Outlook People and IM Contacts Using the Calendar Shared Calendars Outlook Tasks in the Web App Setting Outlook Options, Signatures, Automatic Replies and Rules Using Skype for Business Overview of Skype for Business Viewing and Setting Presence Status Using Instant Messages in Business Understanding the Interactive Contact Card in Microsoft Office Applications Integration with Outlook Using Skype for Business for Online Presentations including Content Sharing, Polls and a Virtual Whiteboard Working with OneDrive for Business What is OneDrive for Business? Navigating around OneDrive Accessing Content in OneDrive Using the Office Online Apps Sharing Documents and Collaborating Connecting Microsoft Office to OneDrive Creating Office Documents and Saving Directly to OneDrive Using Groups and Delve Introduction to Groups Collaborating using Groups Getting to Content using Delve Requirements Requirements Before attending this course, students must have: Basic understanding of Microsoft Office Basic understanding of Microsoft Windows Operating systems

The Level 1 Diploma in Motor Vehicle Studies is designed to encourage and enable learners who have an interest in this area of study to acquire knowledge and skills to aid progression to further study or employment.

  The GDPR Foundation training enables delegates to understand how to define and implement a privacy compliance framework aligned to best practice. During this training course, you will be able to understand the fundamental privacy principles and become familiar with the role of the Data Protection team and the DPO. About This Course   At Foundational level, candidates prove they have understood the fundamental methodologies, requirements, best practice and management approach of a Privacy Compliance Framework. Learning principles;   Understand the General Data Protection Regulation requirements and the fundamental principles of privacy Understand the obligations, roles and responsibilities of the Data Protection Officer Understand the concepts, approaches, methods and techniques to effectively participate in the implementation process of a compliance framework with regard to the protection of personal data.   Educational approach; Lecture sessions are illustrated with practical questions and examples Practical exercises include examples and discussions Practice tests are similar to the Certification Exam   Course Agenda Day 1: Introduction to GDPR and Data Protection Principles Day 2: The General Data Protection Regulation requirements and Certification Exam Prerequisites   There are no prerequisites for this course. What's Included?   Refreshments & Lunch (Classroom courses only Course Slide Deck CPD Certificate   Who Should Attend?   Individuals involved in the processing of Personal Data and Information Security Individuals seeking to gain knowledge about the main privacy principles Individuals interested to pursue a career in Data Protection Provided by   This course is Accredited by NACS and Administered by the IECB Assessment   Delegates sit a combined exam, consisting of in-course quizzes and exercises, as well as a final 40 question, multiple choice exam on Day 2 of the course. The overall passing score is 70%, to be achieved within the 60 minute time allowance. Exam results are provided within 24 hours, with both a Certificate and a digital badge provided as proof of success.

Virtual Agile Teams: Virtual In-House Training Agile teams are a must in this world of intense competition, marketing demands, and changing expectations. Global virtual teaming has become a necessity as organizations become increasingly distributed, with suppliers and clients actively engaged in joint projects. Agile Teams now work across geographical, organizational, and cultural boundaries to deliver solutions and services to global users. Distance and differences may amplify the effect of issues and factors that are relatively straightforward for co-located Agile teams. This workshop delivers practical concepts and techniques that participants will start using immediately with their virtual Agile teams. The goal of the course is to enable you to successfully execute your preferred Agile or Scrum methods in a virtual project team environment. What you will Learn At the end of this program, you will be able to: Explain the characteristics of a virtual team and how they differ from a co-located team Build an effective virtual Agile team using a Team Charter approach Develop Release Plans, including prioritizing user stories, with a virtual Agile Team Construct a Sprint plan, including effective user story estimates, virtually Execute a Sprint, including essential Agile or Scrum ceremonies, virtually Conduct effective virtual meetings in an environment supportive of Agile and Scrum methods Foundation Concepts Agile Mindset and Values Agile Benefits and Methods Scrum Overview Co-located vs. Virtual Teams Forming Virtual Agile Teams Exploring Virtual Leadership Focusing on Virtual Agile Leaders Developing a Virtual Agile Team Charter Meeting Team Challenges in a Virtual Environment Planning Releases with a Virtual Agile Team Planning releases overview Estimating user stories Prioritizing user stories Setting release parameters Getting consensus on the release plan Planning a Sprint for a Virtual Project Sprint Planning Overview Confirming Sprint Scope with Virtual Agile Teams Developing a Sprint Delivery Plan for Virtual Agile Teams Running a Sprint in a Virtual Environment Self-organizing a Sprint for a Virtual Agile Team Using Scrum tools in a Virtual Environment Conducting End of Sprint Meetings in a Virtual Environment Iterating as a Virtual Agile Team Creating an Environment for Success Piloting a virtual Agile team Creating an Agile-friendly virtual environment

Project Estimating and Scheduling: Virtual In-House Training Establishing realistic estimates and goals for projects that support business objectives and meet client expectations is one of the most challenging aspects of project planning. Delivering those results within the agreed-upon time, cost, and quality constraints is also challenging. Attempting to meet impossible deadlines with limited budgets often leads to unplanned product shortfalls, causing long-term support and utilization problems. We have all anguished about this recurring problem, but without having the skills or knowledge to take action, we are unable to break the cycle! The goal of this course is for you to be able to support business objectives and meet client expectations by selecting the right planning approach for realistic and cost effective schedules, as well as project budgets. To achieve that, you will focus on gaining the necessary knowledge, skills, and techniques. What You Will Learn At the end of this program, you will be able to: Use the work breakdown structure (WBS) as the basis for effective estimating of project resources Estimate effort and duration using a variety of techniques Develop preliminary schedules using the critical path method Apply a variety of optimization techniques to refine preliminary schedules Establish realistic schedule and cost baselines, with appropriate contingency reserves Explain how earned value management (EVM) contributes to control time and cost performance Foundation Concepts Project management basic definitions and concepts PES Key driver: competing constraints PES Process and success factors Project Definition and the WBS Project definition overview Work Breakdown Structure (WBS) Decomposition: WBS development technique Resource Planning Resource planning overview Identifying resource requirements Identifying and filling resource gaps Applying resource planning tools Effort and Duration Estimating Estimating overview Estimating perspectives and approaches Estimating techniques Effort and duration estimating best practices Project Scheduling Overview of project scheduling Dependencies and the project network diagram Critical path method (CPM) Optimizing the schedule Budget, Risk, and Contingency Planning Overview of budget, risk, and contingency planning Estimating costs Determining the budget Project risk management processes Planning contingency reserves Project Baseline and Control Overview of project baseline Negotiating and the project baseline Earned value management (EVM) Project variances and actions Project control

Duration 1 Days 6 CPD hours This course is intended for Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology. Overview Upon successful completion of this course, students will be able to: - Use subqueries to generate query output. - Manipulate table data by inserting, updating, and deleting records in a table. - Manipulate the table structure. - Create views, manipulate data through views, modify the view structure, and drop views. - Create indices on table columns and drop inefficient indices. - Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction. In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process. Prerequisites SQL Querying Fundamentals - Part 1 1 - Using Subqueries to Perform Advanced Querying Search Based on Unknown Values Compare a Value with Unknown Values Search Based on the Existence of Records Generate Output Using Correlated Subqueries Filter Grouped Data Within Subqueries Perform Multiple-Level Subqueries 2 - Manipulating Table Data Insert Data Modify and Delete Data 3 - Manipulating the Table Structure Create a Simple Table Create a Table with Constraints Add or Drop Table Columns Add or Drop Constraints Modify the Column Definition Back Up Tables Delete Tables 4 - Working with Views Create a View Manipulate Data in Views Create Aliases Modify and Drop Views 5 - Indexing Data Create Indices Drop Indices 6 - Managing Transactions Create Transactions Commit Transactions