3113 Management courses in Borehamwood delivered Live Online

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' 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 course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback 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 classrom, 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. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate 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 5 Days 30 CPD hours This course is intended for The primary audience for this course are Technology Consultants, System AdministratorsTechnical Architects, and Support Consultants. Overview Understand and use the Monitoring and Alerting Infrastructure (MAI) for monitoring the system landscape with SAP Solution ManagerSetup and Configure the monitoring types System Monitoring, Self- Monitoring, End-user Experience, Integration Monitoring, Job & BI MonitoringUse the features of the Technical Monitoring Work CenterUse Technical Reporting options (EWA, SL Reporting, Interactive Reporting)Use the SAP Solution Manager Administration work center for Troubleshooting In this course, students learn to understand and use the Monitoring and Alerting Infrastructure (MAI) for monitoring the system landscape with SAP Solution Manager Setup and configure the monitoring types. Course Outline Get an overview about the Technical Monitoring in SAP Solution Manager 7.1 Get an overview about the Monitoring and Alerting Infrastructure (MAI) architecture Get a deep understanding about Monitoring Templates Using the Alert Inbox including Guided Procedures Configure Work Mode Management and Notification Management Configure and using System Monitoring Configure and using Interface Channel Monitoring and Connection Monitoring Configure and using End-user Experience Monitoring Configure and using BI-Monitoring and Job Monitoring Configure and using PI-Monitoring, Message Flow Monitoring and Workflow Monitoring Using Technical Reporting (EarlyWatch Alerts, Service Level Reporting, Interactive Reporting and Dashboards) Get an overview about SAP IT Infrastructure Management Get an overview about SAP Mobile Apps for the Monitoring and Alerting Infrastructure (MAI) Configure and using SAP Solution Manager Self-Monitoring and Self Diagnosis Using Monitoring and Alerting Infrastructure Analysis Tools

Duration 3 Days 18 CPD hours This course is intended for This course is designed for project leaders, scrum masters, coaches, product owners, and team members who intend on taking the PMI-ACP© exam. Overview Upon successful completion of this course, you will know: ? Agile principles and practices that will enhance team productivity and improve customer satisfaction ? How to create transparent communication among stakeholders ? How to manage project's scope, schedule and budget in an Agile environment ? How to maximize business value and deliver most value early in the project ? How to build high-performing team ? How to plan at multiple levels and manage stakeholders' expectations ? How to detect, track and resolve risks in an Agile project This course provides participants with a solid foundation of the PMI-ACP© exam. Participants will be introduced to PMI Agile concepts and practices. Introduction to the PMI-ACP© Course and ExamAgile Principles and Mindset Agile project Management Framework: ? What is Agility ? Agile Manifesto ? Agile Principles ? Agile Methodologies: Scrum, Kanban, Extreme programming (XP), Lean ? Agile leadership ? Agile process overview Value-Driven Delivery What is Value-driven delivery, how to deliver value early and minimize waste Assessing Value - Return on Investment (ROI), net present value (NPV), Internal rate of return (IRR), earned value management, managing risk Value Based prioritization ? Customer-Valued prioritization, prioritization schemes (Kano analysis, MoSCoW, relative prioritization / ranking Delivering incrementally ? Minimal Viable Product (MVP), Minimal marketable Feature (MMF), Work In progress (WIP), WIP Limits, Bottlenecks, Cumulative Flow Diagram (CFD) Contracting in Agile projects Verification and validation Stakeholder Engagement Identifying project stakeholders Managing stakeholder engagement Establishing a shared vision ? Agile chartering, Definition of 'Done' (DoD), Agile modelling, wireframes, personas Communication Management ? face to face communication, two-way communication, knowledge sharing, information radiators, social media Working collaboratively ? workshops, brainstorming, collaboration games Interpersonal skills for Agile success ? emotional intelligence, active listening, facilitation, negotiation, conflict resolution, participatory decision making Team Performance Agile team roles High-performing Agile teams ? stages of team development Adaptive leadership Creating collaborative team spaces ? co-located teams, osmotic communication, distributed teams Tracking team performance in Agile teams ? burn charts, velocity Adaptive Planning Defining adaptive planning Principles of Agile planning Tools for sizing and estimating Releases and Iterations planning Problem Detection ?nd Resolution How problems impact a project Detecting problems ? lead time and cycle time, defects, variance analysis, trend analysis, control limits Managing projects threats and issues ? risk-adjusted backlog, risk severity, risk burndown graphs Solving problems Continuous Improvement Multiple levels of improvement ? processes, product, people Implementing continuous process improvement ? process tailoring, systems thinking, process analysis, value stream mapping, project pre-mortems Working towards continuous product improvement ? product feedback loops and learning cycle Leading continuous people improvement ? retrospectives, team self-assessments PMI-ACP© Exam Preparation PMI-ACP© Exam Particulars Overview PMI-ACP© Exam Particulars PMI-ACP© Candidate Requirements PMI-ACP© Candidate Fees PMI-ACP© Exam Application Process

Duration 3 Days 18 CPD hours This course is intended for Risk managersBusiness Process OwnersBusiness Finance ManagersBusiness Risk ManagersRegulatory Compliance ManagersProject ManagementPersons responsible for information security or conformity within an organization Overview To understand the concepts, approaches, methods and techniques allowing an effective risk managementaccording to ISO 31000To understand the relationship between the risk management and the compliance with the requirements ofdifferent stakeholders of an organizationTo acquire the competence to implement, maintain and manage an ongoing risk management program accordingto ISO 31000To acquire the competence to effectively advise organizations on the best practices in risk management In this three-day intensive course participants develop the competence to master a model for implementing risk management processes throughout their organization using the ISO 31000:2009 standard as a reference framework. Day 1 Introduction to the Risk Management framework according to ISO 31000 Concepts and definitions related to Risk Management Risk Management standards, frameworks and methodologies Implementation of a Risk Management framework Understanding an organization and its context Day 2 Risk identification and assessment, risk evaluation, treatment, acceptance, communication and surveillance according to ISO 31000 Risk identification Risk analysis and risk evaluation Risk treatment Risk acceptance and residual risk management Risk communication and consultation Risk monitoring and review Day 3 Risk assessment methodologies according to ISO 31000 and Certification Exam Presentation of risk assessment methodologies Certification Exam

Duration 1 Days 6 CPD hours This course is intended for This course is designed for all levels of experience in using Microsoft Project, as well as all levels of experience in project management. In particular, this course is designed for persons who need to author Microsoft Project work schedules including Project Managers and Project Assistants. Overview To be properly introduced, or reintroduced, to Microsoft Project. To gain an understanding of a proven mindset Microsoft Project users should possess each time they open and work Microsoft Project schedules. To gain an understanding of globally accepted project management principles. To be able to effectively apply Microsoft Project into the Initiation and Planning phases of a normal project life cycle. MS Project: Project Initiation and Planning (part 1 of a 3 part series) course provides proven tools and techniques for successfully using Microsoft Project to assist with managing projects. MS Project: Project Initiation and Planning (part 1 of a 3 part series) course provides proven tools and techniques for successfully using Microsoft Project to assist with managing projects.

Duration 2.75 Days 16.5 CPD hours This course is intended for This course is designed for a person with an understanding of project management concepts, as well as general desktop computer skills, and who will be responsible for creating and maintaining project plans. This course will give you the fundamental understanding as well as acquiring the advanced knowledge and skills needed to update a project plan in Microsoft Project during the execution, monitoring, and controlling phases of a project. Overview Identify project management concepts and navigate Microsoft 2. 2. Project Professional. Create a new project plan. Add tasks to a project. Manage task relationships within a project. Manage project resources. fnalize a project plan. Update a project plan. Generate project views to manage a project. Create project reports to share a project's status. Reuse project plan information. Work with multiple projects. This course will familiarize the user with the basic features and functions of MS Project so that it can be used effectively and efficiently in a real-world environment. MS project will give the ability to project managers to update a project plan in Project during the execution, monitoring, and controlling phases of a project GETTING STARTED WITH MICROSOFT PROJECT Topic A: Identify Project Management Concepts Topic B: Navigate in the Microsoft Project Desktop environment DEFINING A PROJECT Topic A: Create a New Project Plan File Topic B: Set Project Plan Options Topic C: Assign a Project Calendar ADDING PROJECT TASKS Topic A: Add Tasks to a Project Plan Topic B: Enter Task Duration Estimates MANAGING TASKS Topic A: Create a Work Breakdown Structure Topic B: Define Task Relationships Topic C: Schedule Tasks MANAGING PROJECT RESOURCES Topic A: Add Resources to a Project Topic B: Create a Resource Calendar Topic C: Enter Costs for Resources Topic D: Assign Resources to Tasks Topic E: Resolve Resource Conflicts FINALIZING A PROJECT PLAN Topic A: Optimize a Project Plan Topic B: Set a Baseline Topic C: Share a Project Plan UPDATING A PROJECT PLAN Topic A: Enter Task Progress Topic B: Enter Overtime Work Topic C: Edit Tasks Topic D: Update Cost Rate Tables Topic E: Update a Baseline VIEWING PROJECT PROGRESS Topic A: Use View Commands Topic B: Add a Custom Field Topic C: Create Custom Views Topic D: Format and Share the Timeline View REPORTING ON PROJECT PROGRESS Topic A: View Built-in Reports Topic B: Create Custom Reports Topic C: Create a Visual Report REUSING PROJECT PLAN INFORMATION Topic A: Create a Project Plan Template Topic B: Share Project Plan Elements with Other Plans WORKING WITH MULTIPLE PROJECTS Topic A: Share Resources Topic B: Link Project Plans Additional course details: Nexus Humans Microsoft Project 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 Microsoft Project 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.

Getting Started The Master of Business Administration Top Up is a prestigious postgraduate qualification that leading employers highly value. The programme is designed to enhance business managers' strategic thinking and decision-making and develop their critical understanding of business management. The programme is designed for individuals who hold a Qualifi Level 7 Diploma in Strategic Management and Leadership. This programme covers the core business sectors: entrepreneurship, marketing, accounting, statistics, finance, business ethics, business law, managerial economics, business strategy and analysis, operations, administration and communication. This programme, qualified from UK business schools, is well acknowledged and globally respected as it dominates critical thinking and research. MBA can also help you specialise in a new industry you want to move to or in your current sector. This professional qualification improves the chances of progression in a career path. This qualification helps the learner to oversee, supervise and allocate the operations in a business firm. The programme aims to make the candidate capable of understanding the functional aspects of a company and acquiring the skills for communication and decision-making. The MBA Top-Up programme is awarded and delivered 100% online by Anglia Ruskin University. At Anglia Ruskin University, you will study through Canvas, a world-class online Learning Management System (LMS), accessed from your phone, pc or tablet at home or on the move. Canvas provides instant access to study materials, forums, and support from tutors and classmates, as well as enabling easy submission of your assignments. After successfully completing your studies, you'll be invited to attend a graduation ceremony on campus at Anglia Ruskin University. If attending the ceremony in person is not possible, we'll arrange to send your certificate to you. School of Business and Technology London partners with Chestnut Education Group to promote this programme. About Awarding Body Anglia Ruskin University began in 1858 as the Cambridge School of Art founded by William Beaumont. It was then merged with the Cambridge shire College of Arts and Technology and the Essex Institute of Higher Education and was renamed Anglia Polytechnic. It was then given university status in 1992 and renamed Anglia Ruskin University in 2005. The university has campuses in the UK (Cambridge, Chelmsford, London and Peterborough), as well as they are partnered with institutions around the world including Berlin, Budapest, Trinidad, Singapore and Kuala Lumpur. Assessment Major Project No examinations Entry Requirements Qualifi Level 7 Diploma in Strategic Management and Leadership or any equivalent diploma Further, candidates are also required to demonstrate their English language proficiency. Progression An MBA graduate can pursue a fruitful career in many industries. MBA can open career opportunities in various sectors such as banking and financial services, investment banking, management consulting, insurance, hospitality, media, information technology (IT) and marketing. MBA is often a pathway to promotion or a career change as you will gain a professional reputation and develop essential skills in the sector one chooses to pursue. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. Structure MBA Top-Up Programme Structure Dissertation (Major Project) Delivery Methods The MBA Top-Up programme is awarded and delivered 100% online by Anglia Ruskin University. At Anglia Ruskin University, you will study through Canvas, a world-class online Learning Management System (LMS), accessed from your phone, pc or tablet at home or on the move. Canvas provides instant access to study materials, forums, and support from tutors and classmates, as well as enabling easy submission of your assignments. After successfully completing your studies, you'll be invited to attend a graduation ceremony on campus at Anglia Ruskin University. If attending the ceremony in person is not possible, we'll arrange to send your certificate to you. School of Business and Technology London partners with Chestnut Education Group to promote this programme. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

This course is designed to enable learners to increase their understanding of risk assessment and risk management in Health and Social Care settings.

The learning objectives that we believe you require to be covered within the training include: A detailed understanding of the CDM 2015 Regulations and how they should work in practice An understanding of the key roles (Designer, Principal designer, contractor, principal contractor and client) under CDM 2015 What constitutes design and when you may be acting as a designer The requirements for notification Pre construction information, the construction phase plan and the H&S file An opportunity for delegates to ask questions and gain clarification on specific project requirements 1 Introduction Why manage health and safety? The costs of accidents Construction industry statistics Why CDM 2015? 2 Overview of health and safety law and liabilities Criminal and civil law Liability Enforcement and prosecution Compliance - how far do we go? Statutory duties 3 Health and safety law in construction - the current framework Framework of relevant legislationHealth and Safety at Work etc Act 1974Management of Health and Safety at Work Regulations 1999Construction (Design and Management) Regulations 2015Work at Height Regulations 2005 Who is responsible for the risks created by construction work? Shared workplaces/shared responsibilities Control of contractors - importance of contract law 4 CDM 2015 - the principles and current best practice Scope - what is construction? Application - when do the Regulations apply? The CDM management systemDutyholders (client, designer, principal designer, principal contractor, contractor)Documents (pre construction information, Notification, construction phase Plan, H&S File)Management process The 2015 HSE guidance / industry best practice Clarification of roles and responsibilities 5 Competence under CDM 2015 What is 'Competence'? The criteria to be used in construction Achieving continuous improvement 6 Part 4 Construction Health Safety and Welfare Overview of Part 4 Responsibilities Welfare arrangements 7 Risk assessment and the role of the designer Principles of risk assessment Loss prevention / hazard management What is a suitable risk assessment?Design v construction risk assessmentThe client is a designer?Whose risk is it? 8 Risk assessment exercise Understanding the principles of design risk assessment Identifying hazards under the control of clients and designers Quantifying the risk 9 Questions, discussion and review

Supporting people managers The flagship CAPE programme is different to other management development programmes. We offer people management training that supports managers to feel equipped, enabled and empowered to make an immediate and lasting impact. You will benefit from learning how conversation styles, self-belief and authenticity matter and practice your skills with one of our many charity partners towards the end of your training. 12 month multi-element programme Learn new coaching skills Work with charities to utilise your skills Limited spaces £1,795 plus VAT per person Our mission is to help you become a brilliant manager.