Course Objectives This course aims to provide delegates with a foundation for Excel knowledge and skills. ' Customer Feedback Very professional and well mannered, fun and pleasant at the same time. I learnt a lot Carolina Foster - CNN Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all. Laura Smith - James Grant Great course and excellent trainer. Thanks Tracy Preston - Western Power Distribution 1 year email support service Take a look at the consistent excellent feedback from our 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. What is Excel? The Excel Interface Ribbon, Tabs and Groups Microsoft Office Backstage view Working with Workbooks Create a blank Workbook Create a Workbook using a Template Opening and saving Files Working with worksheets Worksheet navigation Select one or multiple Worksheets Insert, Move, Copy or Delete a Worksheet Working with Cells, Rows & Columns Cell References How to select cells or ranges Different types of data Move, Copy and Delete cells Pasting Options Find and Replace Working with Rows and Columns Overview of formulas in Excel Autocalculation The parts of an Excel formula Using calculation operators in Excel formulas The difference between Absolute, Relative and Mixed references Using Excel functions; Sum, Average, Max and Min Cell Formatting Font Format options Number Format options Change the Fill and Borders Cell Alignment An Introduction to Charts Create a simple Chart Format your chart Page Layout and Print Page Layout and Page Break View Change the Page Orientation Set Page Margins Headers and Footers in a worksheet Print a worksheet or workbook Who is this course for? Who is this course for? All users who want to master the main features of Microsoft Excel Requirements Requirements General knowledge of the Windows OS Certificates Certificates Certificate of completion Digital certificate - Included
Learn the basic principles of good programme management using the MSP® approach and prepare for the Foundation and Practitioner examinations on this accredited programme. Duration: 5 days (32.5 hours) Our MSP® Foundation and Practitioner course is designed to teach the basic principles of good programme management in line with the Principles, Themes and Processes described in the MSP® approach. It also prepares delegates for the Foundation and Practitioner examinations. This course is designed for anyone who needs to understand programme management and the practical application of MSP® and to gain the MSP® Foundation and Practitioner qualifications. Delegates should have an understanding of and preferably experience in the issues surrounding business change The MSP® Foundation and Practitioner Course is based upon the “Managing Successful Programmes – 5th Edition” which describes “best practice” guidance for handling all types of transformational change programmes. These are intensive modules and require delegates to undertake some evening work in their own time. Objectives By the end of the course you will be able to: Describe the differences between programmes and projects Describe the Principles, Themes and Processes as described in the MSP® - 5th Edition Practice the application of MSP® Prepare for both the MSP® Foundation and Practitioner Exam Please note that examinations are the responsibility of the examination board, PEOPLECERT and must be organised separately by each person attending. Content Introduction Introduction – what is, and why use, Programme Management The Three Lenses of the MSP® FrameworkMSP PrinciplesMSP ThemesMSP Processes The Themes Overview – introduction to the seven Themes Organization – roles, accountabilities, responsibilities Design – Vision, Benefits, Risk, Target Operating Model Justification – Business case and financial planning Structure – Delivery approaches, Planning and control Knowledge – Knowledge and Information management Assurance – Assurance at multiple levels approach and planning Decisions – Decision-making, Issue and Risk resolution approaches, Data-gathering and options analysis The Processes Overview – the seven processes Identify the Programme – initial justification Design the Outcomes - establishing solid foundations Plan Progressive Delivery – build on the programme design Deliver the Capabilities– oversee programme delivery Embed the Outcomes – adopting new ways of working and realize the benefits Evaluate new information – collecting, evaluating, analysing and presenting new information Close the Programme – final assessment and release resources Practitioner Workshop and Examination MSP® Practitioner Examination Objectives and Guidance MSP® Review MSP® Practitioner Examination Workshops MSP® Practitioner Examination MSP® Foundation and Practitioner Examinations The MSP® Foundation Exam is of 1 hour duration and consists of 60 multiple choice questions. A Pass is 36 correct answers, 60%. The MSP® Practitioner Exam is a written paper of 2.5 hours duration. There are 70 Objective Test style questions to be answered in the 2.5 hours and the candidate may use an annotated manual. The candidate must score 42/70, 60%, to be successful. Presented in association with aims4change, a PEOPLECERT Accredited Training Organisation. MPS® is a Registered Trade Mark of AXELOS Limited.
Inspiring, interactive and unique 4-hour CPD certified training on Communication and Co-production with Parents/Carers
Duration 1 Days 6 CPD hours This course is intended for This course is intended for managers, team leads, and individual contributors on techniques and best practices for continual improvement of themselves as leaders. Overview Define leadership. Assess your own leadership traits. Establish your leadership development plan. Develop your communication skills. Build your reputation. You have transitioned from an individual contributor to a manager, or as an individual contributor, you\'ve acquired practical skills to enhance your leadership abilities. When you want to take your leadership skills to the next level, you assess your leadership traits, develop your communication skills, and build your reputation. These strategies can increase your ability to effectively influence others and get results. Private classes on this topic are available. We can address your organization?s issues, time constraints, and save you money, too. Contact us to find out how. Prerequisites Students taking this course should have completed the course: Practical Leadership (Second Edition) 1. Defining Leadership Topic A: Identify Leadership Attributes Topic B: Identify Leadership Responsibilities 2. Assessing Your Leadership Traits Topic A: Assess Your Leadership Characteristics Topic B: Determine How Colleagues View Your Leadership Topic C: Evaluate Factors that Affect Your Leadership 3. Establishing Your Leadership Development Plan Topic A: Identify Your Destination Topic B: Establish Your Map Topic C: Build a Leadership Development Plan 4. Developing Your Communication Skills Topic A: Upgrade Your Listening Skills Topic B: Improve Your Communication Effectiveness 5. Building Your Reputation Topic A: Establish Your Credibility Topic B: Use Influence to Get Results Additional course details: Nexus Humans Developing Yourself as a Leader (Second Edition) 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 Developing Yourself as a Leader (Second Edition) 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.
MJ Electrical Training offers a one-day online course for a Health & Safety Exemption, which can be used when applying for an ECS Labourers card. ECS (Electrotechnical Certification Scheme) is a card scheme for electrotechnical operatives in the UK. The ECS Labourer card is designed for those working in a supporting role within the electrotechnical industry.
MJ Electrical Training offers a one-day online course for a Health & Safety Exemption, which can be used when applying for an ECS Labourers card. ECS (Electrotechnical Certification Scheme) is a card scheme for electrotechnical operatives in the UK. The ECS Labourer card is designed for those working in a supporting role within the electrotechnical industry.
This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 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 and Business Intelligence. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke course Tailored training courses: in 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. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing
Asbestos Awareness training is a legal requirement for any worker who may encounter asbestos during their work. Modules will provide relevant and detailed knowledge about the dangers of asbestos, the products that contain asbestos, what it looks like, where it may have been used and the practical steps that can be taken to reduce their risk of exposure. In addition to common mandatory modules, learners will also choose a selection of modules relevant to their occupational pathway.
Asbestos Awareness training is a legal requirement for any worker who may encounter asbestos during their work. Modules will provide relevant and detailed knowledge about the dangers of asbestos, the products that contain asbestos, what it looks like, where it may have been used and the practical steps that can be taken to reduce their risk of exposure. In addition to common mandatory modules, learners will also choose a selection of modules relevant to their occupational pathway.
Addressing pain points in personal life Teaching you how to self regulate Psychotherapy Recognizing anger triggers Emotional intelligence training Social skills exercises Anger management person-centred coaching 6 sessions https://relationshipsmdd.com/product/anger-management-therapy-package/