<p style="color: rgb(68, 68, 68); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(68, 68, 68);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">2 Days - 16 CPD Hours</strong></p><p style="color: rgb(68, 68, 68); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(68, 68, 68);">This is a two-day course designed for ward, department and team managers in healthcare. It is suitable for both aspiring ward, department and team managers and those already in post.</p><p style="color: rgb(68, 68, 68); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(68, 68, 68);">The two days interactive and you will go away with some practical ideas and techniques as well as an individual personal development plan. You will learn about how healthcare is structured and the national picture, as well as thinking about your own local issues and how to deal with them.</p>

2 Days - 16 CPD Hours
This is a two-day course designed for ward, department and team managers in healthcare. It is suitable for both aspiring ward, department and team managers and those already in post.
The two days interactive and you will go away with some practical ideas and techniques as well as an individual personal development plan. You will learn about how healthcare is structured and the national picture, as well as thinking about your own local issues and how to deal with them.

M&K Update Ltd

Adult Leadership & Management (ALM)

Allied Health Professions (AHP)

Health Care Management

This is a two-day course designed for ward, department and team managers in healthcare. It is suitable for both aspiring ward, department and team managers and those already in post.

Essential Skills for Ward, Department and Team Managers

Thetford

<header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><div style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><article fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This half day course is designed to help participants who need to write or revise policies and procedures for their organisations. It will help them to develop effective structures for the writing and design and ensure that they meet key legal and good practice requirements on some of the most important policies such as health and safety, equal opportunities and financial procedures. It will also look at the process of consultation and implementation so that the policies obtain &ldquo;buy-in&rdquo; and commitment from staff and volunteers.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Areas covered</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Understanding the purposes of having a range of effective policies and procedures</li><li fr-original-style="" style="box-sizing: border-box;">Determining what policies and procedures your organisation needs</li><li fr-original-style="" style="box-sizing: border-box;">Looking at key policies such as health and safety, equal opportunities and personnel policies</li><li fr-original-style="" style="box-sizing: border-box;">How to write and introduce policies to your staff and volunteers &ndash; the consultation and implementation processes</li><li fr-original-style="" style="box-sizing: border-box;">How to develop an effective system for reviewing your policies and procedures.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course could be run as part of a training programme or could be run in house.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">In-house courses</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The course is designed to be flexible so that it can accommodate the specific needs of a particular organisation or agency. For example, the course could be designed around writing or reviewing specific policies and determining how they will be implemented.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We can also provide a writing or reviewing policy service for individual organisations.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Objectives</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">To give participants a clear understanding of what policies and procedures they need</li><li fr-original-style="" style="box-sizing: border-box;">To provide advice and guidance on key policies so that participants understand the legal requirements</li><li fr-original-style="" style="box-sizing: border-box;">To ensure participants understand how to consult and implement new or revised policies and procedures effectively.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Target Audience</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">People working in the voluntary and community sector or those working in statutory agencies who work closely with VCS groups. The course can be adapted to suit particular needs.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Cost</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">From &pound;150 + travel costs</p></article></div></header></header></header></header><div style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><br fr-original-style="" style="box-sizing: border-box;"></div>

This half day course is designed to help participants who need to write or revise policies and procedures for their organisations. It will help them to develop effective structures for the writing and design and ensure that they meet key legal and good practice requirements on some of the most important policies such as health and safety, equal opportunities and financial procedures. It will also look at the process of consultation and implementation so that the policies obtain “buy-in” and commitment from staff and volunteers.
Areas covered
Understanding the purposes of having a range of effective policies and procedures
Determining what policies and procedures your organisation needs
Looking at key policies such as health and safety, equal opportunities and personnel policies
How to write and introduce policies to your staff and volunteers – the consultation and implementation processes
How to develop an effective system for reviewing your policies and procedures.
This course could be run as part of a training programme or could be run in house.
In-house courses
The course is designed to be flexible so that it can accommodate the specific needs of a particular organisation or agency. For example, the course could be designed around writing or reviewing specific policies and determining how they will be implemented.
We can also provide a writing or reviewing policy service for individual organisations.
Objectives
To give participants a clear understanding of what policies and procedures they need
To provide advice and guidance on key policies so that participants understand the legal requirements
To ensure participants understand how to consult and implement new or revised policies and procedures effectively.
Target Audience
People working in the voluntary and community sector or those working in statutory agencies who work closely with VCS groups. The course can be adapted to suit particular needs.
Cost
From £150 + travel costs

SAVO CIC

Organisational Skills

Policy Writing

This half day course is designed to help participants who need to write or revise policies and procedures for their organisations. It will help them to develop effective structures for the writing and design and ensure that they meet key legal and good practice requirements on some of the most important policies such as health and safety, equal opportunities and financial procedures. It will also look at the process of consultation and implementation so that the policies obtain “buy-in” and commitment from staff and volunteers.

Writing Policies and Procedures

General Admission

Nottinghamshire

<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">COURSE INFORMATION</strong></span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">To provide knowledge and understanding in the following areas:</p><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li fr-original-style="" style="box-sizing: border-box;">Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as a plant operator</li><li fr-original-style="" style="box-sizing: border-box;">Have a working knowledge of the manufacturer&#39;s handbook for the particular machine to be used and other relevant sources of information</li><li fr-original-style="" style="box-sizing: border-box;">Be able to locate and identify the major components of the machine and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Be able to locate and identify steering, driving and braking controls and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all pre-operational checks in accordance with the manufacturer&#39;s and legislative requirements</li><li fr-original-style="" style="box-sizing: border-box;">Safely mount and dismount the machine</li><li fr-original-style="" style="box-sizing: border-box;">Start and stop the engine and safely move the machine off and stop it safely</li><li fr-original-style="" style="box-sizing: border-box;">Configure the machine for travel and maneuver it safely laden and unladen, over varying terrain, rough ground, inclines, in open and confined areas</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all necessary safety checks at the work area</li><li fr-original-style="" style="box-sizing: border-box;">Maneuver the machine to the work area and correctly configure in readiness to carry out lifting and load handling tasks</li><li fr-original-style="" style="box-sizing: border-box;">Carry out lifting and load handling tasks</li><li fr-original-style="" style="box-sizing: border-box;">Lift and transfer loads accurately and safely at different locations</li><li fr-original-style="" style="box-sizing: border-box;">Load and unload external transport safely</li><li fr-original-style="" style="box-sizing: border-box;">Fit, adjust and / or remove attachments</li><li fr-original-style="" style="box-sizing: border-box;">Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation</li><li fr-original-style="" style="box-sizing: border-box;">Carry out all end of shift and shut down procedures</li></ul><h2 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Entry Requirements</h2><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Please note, that in all cases, operators are required to supply proof to support&nbsp;their application. They have to have passed the CITB health, safety &amp; environmental touch screen test within two years prior to their application.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Good understanding of spoken and written English.</p>

COURSE INFORMATION
To provide knowledge and understanding in the following areas:
Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as a plant operator
Have a working knowledge of the manufacturer's handbook for the particular machine to be used and other relevant sources of information
Be able to locate and identify the major components of the machine and explain their functions
Be able to locate and identify steering, driving and braking controls and explain their functions
Conduct all pre-operational checks in accordance with the manufacturer's and legislative requirements
Safely mount and dismount the machine
Start and stop the engine and safely move the machine off and stop it safely
Configure the machine for travel and maneuver it safely laden and unladen, over varying terrain, rough ground, inclines, in open and confined areas
Conduct all necessary safety checks at the work area
Maneuver the machine to the work area and correctly configure in readiness to carry out lifting and load handling tasks
Carry out lifting and load handling tasks
Lift and transfer loads accurately and safely at different locations
Load and unload external transport safely
Fit, adjust and / or remove attachments
Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation
Carry out all end of shift and shut down procedures
Entry Requirements
Please note, that in all cases, operators are required to supply proof to support their application. They have to have passed the CITB health, safety & environmental touch screen test within two years prior to their application.
Good understanding of spoken and written English.

Dynamic Training and Assessments Ltd

Plant Operator

Lifting Operations & Lifting Equipment Regulations (LOLER)

Construction

CSCS (Construction Skills Certification Scheme)

Site Management Safety Training Scheme (SMSTS)

NPORS

Overhead Crane Operator

Lifting Operations

Heavy Equipment Operator

NPORS Industrial Telescopic Handler (N010A)

<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Overview</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">This course is aimed at candidates that require the knowledge and practical skills operate to operate a Concrete Pump safely and efficiently.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Content</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Candidates will be able to:</p><ul style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><li fr-original-style="" style="box-sizing: border-box;">Understand the industry, the dangers of working in the industry and their responsibilities as an operator</li><li fr-original-style="" style="box-sizing: border-box;">Have a working knowledge of the manufacturer&rsquo;s handbook for the particular machine to be used</li><li fr-original-style="" style="box-sizing: border-box;">Locate and identify the major components of the machine and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Locate and identify key controls and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all pre-operational checks in accordance with manufacturer and legislative requirements</li><li fr-original-style="" style="box-sizing: border-box;">Identify and maintain PPE appropriate for concrete pump use</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all necessary safety checks at the work area</li><li fr-original-style="" style="box-sizing: border-box;">Prepare the concrete pump for use and operate machinery safely and efficiently</li><li fr-original-style="" style="box-sizing: border-box;">Complete safe un-blocking and re-connecting procedures</li><li fr-original-style="" style="box-sizing: border-box;">Prepare the concrete pump for cleaning and carry out cleaning tasks safely and efficiently</li><li fr-original-style="" style="box-sizing: border-box;">Understand environmental considerations</li><li fr-original-style="" style="box-sizing: border-box;">Store and transport implements and attachments</li><li fr-original-style="" style="box-sizing: border-box;">Carry out end of shift and shut down procedures</li></ul><div style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><h2 fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Entry Requirements</strong></h2></div><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS CSCS &ndash; Candidates must have achieved the relevant CITB Health, Safety &amp; Environment (HS&amp;E) touch-screen-test within 2 years.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Good understanding of spoken and written English.</p><div style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><h2 fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Duration</strong></h2></div><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Novice course- 5 days depending on experience</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Experienced worker tests- 1 day theory and practical assessment</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Location</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Customer Site (Training &amp; Testing) &ndash; Site must adhere to NPORS specifications</p>

Overview
This course is aimed at candidates that require the knowledge and practical skills operate to operate a Concrete Pump safely and efficiently.
Course Content
Candidates will be able to:
Understand the industry, the dangers of working in the industry and their responsibilities as an operator
Have a working knowledge of the manufacturer’s handbook for the particular machine to be used
Locate and identify the major components of the machine and explain their functions
Locate and identify key controls and explain their functions
Conduct all pre-operational checks in accordance with manufacturer and legislative requirements
Identify and maintain PPE appropriate for concrete pump use
Conduct all necessary safety checks at the work area
Prepare the concrete pump for use and operate machinery safely and efficiently
Complete safe un-blocking and re-connecting procedures
Prepare the concrete pump for cleaning and carry out cleaning tasks safely and efficiently
Understand environmental considerations
Store and transport implements and attachments
Carry out end of shift and shut down procedures
Entry Requirements
NPORS CSCS – Candidates must have achieved the relevant CITB Health, Safety & Environment (HS&E) touch-screen-test within 2 years.
Good understanding of spoken and written English.
Duration
Novice course- 5 days depending on experience
Experienced worker tests- 1 day theory and practical assessment
Location
Customer Site (Training & Testing) – Site must adhere to NPORS specifications

NPORS Concrete Pump (N211)

Altrincham

Basingstoke

Bicester

Birmingham

Bolton

Bradford

Bristol

Cambridge

Cheltenham

Coventry

Derby

Doncaster

Gloucester

Huddersfield

Leeds

Leicester

Liverpool

London

Luton

Manchester

Middlesbrough

Milton Keynes

Newcastle-under-Lyme

Northampton

Norwich

Nottingham

Oxford

Peterborough

Reading

Rotherham

Salford

Sheffield

Slough

Solihull

Stockport

Stockton-on-Tees

Stoke-on-Trent

Swindon

Trowbridge

Warrington

Watford

Wolverhampton

York

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our regionally-based associate Microsofct Word trainers come to your organisation to deliver the training when you need and at the level you require. Or, opt for live virtual classroom courses delivered via Microsoft Teams.<br id="isPasted" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">One of our trainers will speak to you about the scope of your requirement and course lengths may vary depending upon your needs.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Pricing</strong><br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">&pound;450.00 plus VAT per day for up to 3 learners and mileage. Just add &pound;50.00 plus VAT per additional learner up to the 10 delegate maximum.</p>

Our regionally-based associate Microsofct Word trainers come to your organisation to deliver the training when you need and at the level you require. Or, opt for live virtual classroom courses delivered via Microsoft Teams.

One of our trainers will speak to you about the scope of your requirement and course lengths may vary depending upon your needs.

Pricing

£450.00 plus VAT per day for up to 3 learners and mileage. Just add £50.00 plus VAT per additional learner up to the 10 delegate maximum.

FourSquare Innovations Ltd

Office Skills & Productivity

Office Skills

Microsoft Word

FourSquare Training specialise in private, corporate Microsoft Word courses delivered at your premises and tailored to your needs.

Microsoft Word Training

Coalville

Kettering

Lutterworth

Newbury

Runcorn

Telford

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our regionally-based associate Microsoft PowerPoint trainers come to your organisation to deliver the training when you need and at the level you require. Or, opt for live virtual classroom courses delivered via Microsoft Teams.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outlines</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><a href="https://www.foursquaretraining.co.uk/training_course_pages/powerpoint_training_course_in_leeds.html#topics" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Microsoft PowerPoint Beginners - 1 day course</a></li><li fr-original-style="" style="box-sizing: border-box;"><a href="https://www.foursquaretraining.co.uk/training_course_pages/powerpoint_training_manchester_liverpool.html#topics" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Microsoft PowerPoint Advanced - 1 day course</a><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Pricing</strong><br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">&pound;450.00 plus VAT and mileage for up to 3 learners. Just add &pound;50.00 plus VAT per additional learner up to the 10 delegate maximum.</p>

Our regionally-based associate Microsoft PowerPoint trainers come to your organisation to deliver the training when you need and at the level you require. Or, opt for live virtual classroom courses delivered via Microsoft Teams.
Course Outlines
Microsoft PowerPoint Beginners - 1 day course
Microsoft PowerPoint Advanced - 1 day course
Pricing

£450.00 plus VAT and mileage for up to 3 learners. Just add £50.00 plus VAT per additional learner up to the 10 delegate maximum.

Content Design

Microsoft Powerpoint

FourSquare Training specialise in private, corporate Microsoft PowerPoint courses delivered at your premises and tailored to your needs.

Microsoft PowerPoint Training

High Wycombe

Hull

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our regionally-based associate Google Sheets trainers come to your organisation to deliver the training when you need and at the level you require. Or, opt for live virtual classroom courses delivered via Microsoft Teams.<br id="isPasted" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">One of our trainers will speak to you about the scope of your requirement and course lengths may vary depending upon your needs.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outlines</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a href="https://www.foursquaretraining.co.uk/training_course_pages/google-sheets-beginners-course.html#topics" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Sheets Beginners - 1 day course</a></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a href="https://www.foursquaretraining.co.uk/training_course_pages/google-sheets-intermediate-course.html#topics" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Sheets Intermediate - 1 day course</a></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a href="https://www.foursquaretraining.co.uk/training_course_pages/google-sheets-advanced-course.html#topics" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Sheets Advanced - 1 day course</a></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Pricing</strong><br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">&pound;450.00 plus VAT per day for up to 3 learners and mileage. Just add &pound;50.00 plus VAT per additional learner up to the 10 delegate maximum.</p>

Our regionally-based associate Google Sheets trainers come to your organisation to deliver the training when you need and at the level you require. Or, opt for live virtual classroom courses delivered via Microsoft Teams.

One of our trainers will speak to you about the scope of your requirement and course lengths may vary depending upon your needs.
Course Outlines
Sheets Beginners - 1 day course
Sheets Intermediate - 1 day course
Sheets Advanced - 1 day course
Pricing

£450.00 plus VAT per day for up to 3 learners and mileage. Just add £50.00 plus VAT per additional learner up to the 10 delegate maximum.

Google Sheets

FourSquare Training specialise in private, corporate Google Sheets courses delivered at your premises and tailored to your needs.

Google Sheets Courses

Hertford

Melton Mowbray

Worksop

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our regionally-based associate Microsoft Excel trainers come to your organisation to deliver the training when you need and at the level you require. Or, opt for live virtual classroom courses delivered via Microsoft Teams.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outlines</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><a href="https://www.foursquaretraining.co.uk/training_course_pages/excel_training_course_in_leeds.html#topics" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Excel Beginners - 1 day course</a></li><li fr-original-style="" style="box-sizing: border-box;"><a href="https://www.foursquaretraining.co.uk/training_course_pages/excel_training_course_birmingham_excel_training_coventry.html#topics" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Excel Intermediate - 1-2 day course</a></li><li fr-original-style="" style="box-sizing: border-box;"><a href="https://www.foursquaretraining.co.uk/training_course_pages/excel_training_course_aylesbury_excel_training_milton_keynes.html#topics" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Excel Advanced - 1 day course</a></li><li fr-original-style="" style="box-sizing: border-box;"><a href="https://www.foursquaretraining.co.uk/training_course_pages/excel_training_masterclass_course.html#topics" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Excel Masterclass&nbsp;- 3 day course</a></li><li fr-original-style="" style="box-sizing: border-box;"><a href="https://www.foursquaretraining.co.uk/training_course_pages/excel_power_query_training_course.html#topics" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Excel Power Query - 1 day course</a><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong id="isPasted" fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></strong></li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Pricing</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&pound;450.00 plus VAT per day and mileage for up to 3 learners. Just add &pound;50.00 plus VAT per additional learner up to the 10 delegate maximum.</p>

Our regionally-based associate Microsoft Excel trainers come to your organisation to deliver the training when you need and at the level you require. Or, opt for live virtual classroom courses delivered via Microsoft Teams.
Course Outlines
Excel Beginners - 1 day course
Excel Intermediate - 1-2 day course
Excel Advanced - 1 day course
Excel Masterclass - 3 day course
Excel Power Query - 1 day course
Pricing
£450.00 plus VAT per day and mileage for up to 3 learners. Just add £50.00 plus VAT per additional learner up to the 10 delegate maximum.

Microsoft Excel

Spreadsheet

FourSquare Training specialise in private, corporate Microsoft Excel courses delivered at your premises and tailored to your needs.

Microsoft Excel Training

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course information&nbsp;</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">It is envisaged that by the end of this course of training, the learner will be able to answer questions on and perform the following:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator.</li><li fr-original-style="" style="box-sizing: border-box;">Have a working knowledge of the manufacturer&rsquo;s handbook for the particular machine to be used.</li><li fr-original-style="" style="box-sizing: border-box;">Be able to locate and identify the major components of the machine and explain their functions.</li><li fr-original-style="" style="box-sizing: border-box;">Be able to locate and identify key controls and explain their functions.</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all pre-operational checks in accordance with manufacturers and legislative requirements.</li><li fr-original-style="" style="box-sizing: border-box;">Identify and maintain PPE appropriate for plant mover use.</li><li fr-original-style="" style="box-sizing: border-box;">Prepare machinery for use and operate machinery safely and efficiently.</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all necessary safety checks at the work area.</li><li fr-original-style="" style="box-sizing: border-box;">Environmental considerations.</li><li fr-original-style="" style="box-sizing: border-box;">Storage and transport of machinery attachments.</li><li fr-original-style="" style="box-sizing: border-box;">Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation.</li><li fr-original-style="" style="box-sizing: border-box;">Carry out all end of shift and shut down procedures.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Entry requirements&nbsp;</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">In order to be eligible to undertake NPORS testing.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Good understanding of spoken and written English.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">__________________________________________________________________________________</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Assessment&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Assessment will be to NPORS standards consisting of a theory test and practical test.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">__________________________________________________________________________________</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Certification</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">NPORS Traditional card &ndash; With the traditional card, there is no requirements to complete an NVQ, a five-year card is issued and after five years reassessment is required.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">NPORS CSCS &ndash; To ensure that the operator is able to receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card, the candidate will be required to complete an NVQ in the specific item of plant.&nbsp;</p>

Course information 
It is envisaged that by the end of this course of training, the learner will be able to answer questions on and perform the following:
Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator.
Have a working knowledge of the manufacturer’s handbook for the particular machine to be used.
Be able to locate and identify the major components of the machine and explain their functions.
Be able to locate and identify key controls and explain their functions.
Conduct all pre-operational checks in accordance with manufacturers and legislative requirements.
Identify and maintain PPE appropriate for plant mover use.
Prepare machinery for use and operate machinery safely and efficiently.
Conduct all necessary safety checks at the work area.
Environmental considerations.
Storage and transport of machinery attachments.
Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation.
Carry out all end of shift and shut down procedures.
Entry requirements 
In order to be eligible to undertake NPORS testing.
Good understanding of spoken and written English.
__________________________________________________________________________________
Assessment 
Assessment will be to NPORS standards consisting of a theory test and practical test.
__________________________________________________________________________________
Certification
NPORS Traditional card – With the traditional card, there is no requirements to complete an NVQ, a five-year card is issued and after five years reassessment is required. 
NPORS CSCS – To ensure that the operator is able to receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card, the candidate will be required to complete an NVQ in the specific item of plant. 

NPORS Plant Mover - Non Operational Duties (N132)

<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Overview</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">This course is for candidates who are required to operate 360 re handlers to lift, move and transport materials. This course will give the candidate the required knowledge and skills to carry this task out safely and efficiently.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Content</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Candidates will be able to:</p><ul style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><li fr-original-style="" style="box-sizing: border-box;">Understand the industry, the dangers of working in the industry and their responsibilities as a plant operator</li><li fr-original-style="" style="box-sizing: border-box;">Understand the manufacturer&rsquo;s handbook for the particular machine to be used</li><li fr-original-style="" style="box-sizing: border-box;">Locate and identify the major components of the machine and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Locate and identify steering, driving and braking controls and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all pre-operational checks in accordance with manufacturer&rsquo;s and legislative requirements</li><li fr-original-style="" style="box-sizing: border-box;">Safely mount and dismount the machine</li><li fr-original-style="" style="box-sizing: border-box;">Start and stop the engine and safely move the machine off and stop it safely</li><li fr-original-style="" style="box-sizing: border-box;">Configure the machine for travel and manoeuvre it safely across varying terrain in open and confined areas</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all necessary safety checks at the work area</li><li fr-original-style="" style="box-sizing: border-box;">Manoeuvre the machine to the work area and correctly configure in readiness to carry out processing tasks</li><li fr-original-style="" style="box-sizing: border-box;">Carry out processing task</li><li fr-original-style="" style="box-sizing: border-box;">Load material onto transporting vehicles, containers or processing plant</li><li fr-original-style="" style="box-sizing: border-box;">Fit and remove attachments</li><li fr-original-style="" style="box-sizing: border-box;">Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation</li><li fr-original-style="" style="box-sizing: border-box;">Carry out all end of shift and shut down procedures</li></ul><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Entry Requirements</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS CSCS &ndash; Candidates must have achieved the relevant CITB Health, Safety &amp; Environment (HS&amp;E) touch-screen-test within 2 years.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Good understanding of spoken and written English.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Duration</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Novice course &ndash; 5 days</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Experienced worker tests &ndash; 1 day theory and practical assessment</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Location</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Customer Site (Training &amp; Testing) &ndash; Site must adhere to NPORS specifications</p>

Overview
This course is for candidates who are required to operate 360 re handlers to lift, move and transport materials. This course will give the candidate the required knowledge and skills to carry this task out safely and efficiently.
Course Content
Candidates will be able to:
Understand the industry, the dangers of working in the industry and their responsibilities as a plant operator
Understand the manufacturer’s handbook for the particular machine to be used
Locate and identify the major components of the machine and explain their functions
Locate and identify steering, driving and braking controls and explain their functions
Conduct all pre-operational checks in accordance with manufacturer’s and legislative requirements
Safely mount and dismount the machine
Start and stop the engine and safely move the machine off and stop it safely
Configure the machine for travel and manoeuvre it safely across varying terrain in open and confined areas
Conduct all necessary safety checks at the work area
Manoeuvre the machine to the work area and correctly configure in readiness to carry out processing tasks
Carry out processing task
Load material onto transporting vehicles, containers or processing plant
Fit and remove attachments
Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation
Carry out all end of shift and shut down procedures
Entry Requirements
NPORS CSCS – Candidates must have achieved the relevant CITB Health, Safety & Environment (HS&E) touch-screen-test within 2 years.
Good understanding of spoken and written English.
Duration
Novice course – 5 days
Experienced worker tests – 1 day theory and practical assessment
Location
Customer Site (Training & Testing) – Site must adhere to NPORS specifications

NPORS Material Re - Handler (N722)

<p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(37, 46, 57);">When it comes to designing our dream future, there are a few &nbsp;aspects to be considered...</p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);">Firstly, amongst the chaos, how often do we actually create space to think about what we genuinely want for ourselves?</p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);">And then when we do, are they our own desires, or someone else&#39;s?</p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Vision boards help you to gain clarity</strong>&nbsp;on what you truly want from life</p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);">I will teach you to&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">connect&nbsp;</strong>back in with your&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">core values,&nbsp;</strong>an overview behind&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">manifestation</strong>&nbsp;and how our early life experiences may have impacted us now (positively and negatively).</p><ul style="color: rgb(37, 46, 57); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><li fr-original-style="" style="box-sizing: border-box;">Experience a short meditation to clear and open the mind</li><li fr-original-style="" style="box-sizing: border-box;">Identify your big dreams and goals, your values and how this aligns with your identity and purpose.</li><li fr-original-style="" style="box-sizing: border-box;">Create your unique vision board from scratch.</li></ul><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);">The Workshop will be a hybrid of meditation, fun and networking helping you to connect back in with who you truly are, your centre of creativity, and visualise your dream life.</p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);">This is for you if you say yes to one or more of the following:</p><ul style="color: rgb(37, 46, 57); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><li fr-original-style="" style="box-sizing: border-box;">you are ready to explore what you want from life</li><li fr-original-style="" style="box-sizing: border-box;">you feel stuck and uninspired</li><li fr-original-style="" style="box-sizing: border-box;">you have a vision, but you want to have a daily reminder of your dreams and goals</li><li fr-original-style="" style="box-sizing: border-box;">you want to manifest your vision or dream life quicker</li><li fr-original-style="" style="box-sizing: border-box;">you would like to passionately connect with your goals and dreams</li><li fr-original-style="" style="box-sizing: border-box;">you would like to connect with your sacral chakra and instil some creativity into your energy</li></ul><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Are you ready to create the life that lights you up?</strong></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(37, 46, 57);"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Resources required:</strong></em><em fr-original-style="" style="box-sizing: border-box;">&nbsp;</em></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><em fr-original-style="" style="box-sizing: border-box;">Everyone: Notepad + pen, quiet space for reflection.&nbsp;</em></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><em fr-original-style="" style="box-sizing: border-box;">If you know you definitely want to create your Vision Board on your Computer, then please come ready with access to Microsoft word or Canva. &nbsp;</em></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><em fr-original-style="" style="box-sizing: border-box;">Otherwise (and this is my favourite way to start a vision board experience), you will also need;</em></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><em fr-original-style="" style="box-sizing: border-box;">Access to images that you can cut out. &nbsp;Here are some ideas on building your portfolio of images:</em></p><ul style="color: rgb(37, 46, 57); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">buy your favourite magazine/ ask around your friends/ family if you can have it rather than being thrown away</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">local supermarkets that offer their free magazine</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">travel agents&nbsp;</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">keep hold of local magazines/ newspapers/ flyers dropped through the door</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">photos that you don&#39;t mind cutting up</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">celebratory cards</em></li></ul><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><em fr-original-style="" style="box-sizing: border-box;">Please also have access to A3 card (you can buy these from craft stores) ; scissors, glue.</em></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><em fr-original-style="" style="box-sizing: border-box;">You can go super creative here as much as you would like; feathers, sparkle. you could even connect with the outdoors if you know how to preseve your items.&nbsp;</em></p>

When it comes to designing our dream future, there are a few aspects to be considered...
Firstly, amongst the chaos, how often do we actually create space to think about what we genuinely want for ourselves?
And then when we do, are they our own desires, or someone else's?
Vision boards help you to gain clarity on what you truly want from life
I will teach you to connect back in with your core values, an overview behind manifestation and how our early life experiences may have impacted us now (positively and negatively).
Experience a short meditation to clear and open the mind
Identify your big dreams and goals, your values and how this aligns with your identity and purpose.
Create your unique vision board from scratch.
The Workshop will be a hybrid of meditation, fun and networking helping you to connect back in with who you truly are, your centre of creativity, and visualise your dream life.
This is for you if you say yes to one or more of the following:
you are ready to explore what you want from life
you feel stuck and uninspired
you have a vision, but you want to have a daily reminder of your dreams and goals
you want to manifest your vision or dream life quicker
you would like to passionately connect with your goals and dreams
you would like to connect with your sacral chakra and instil some creativity into your energy
Are you ready to create the life that lights you up?


Resources required: 
Everyone: Notepad + pen, quiet space for reflection. 

If you know you definitely want to create your Vision Board on your Computer, then please come ready with access to Microsoft word or Canva. 

Otherwise (and this is my favourite way to start a vision board experience), you will also need;

Access to images that you can cut out. Here are some ideas on building your portfolio of images:
buy your favourite magazine/ ask around your friends/ family if you can have it rather than being thrown away
local supermarkets that offer their free magazine
travel agents
keep hold of local magazines/ newspapers/ flyers dropped through the door
photos that you don't mind cutting up
celebratory cards

Please also have access to A3 card (you can buy these from craft stores) ; scissors, glue.

You can go super creative here as much as you would like; feathers, sparkle. you could even connect with the outdoors if you know how to preseve your items. 

Sinéad Robertson

Personal Development

Mindfulness

Life Coaching

Manifestation & Law of Attraction

Meditation

Creative Therapy

𝐃𝐢𝐝 𝐘𝐨𝐮 𝐤𝐧𝐨𝐰?
😍Vision Boards improves your chance of success! 
Here's just a few benefits from the process of vision boarding ⤵️
🔸 Helps you to connect with what you truly want from life;
🔸 Shift your mindset;
🔸 Provides a tool to align and focus your goals
And are a great opportunity to meet new and like minded people!
I'm looking forward to hosting this vision board workshop with you.  
🙏🏻Give me a shout if you have any questions.

Design your Dream Life Vision Board

<p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" id="isPasted" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><strong style="box-sizing: border-box; font-weight: 700;" fr-original-style="box-sizing: border-box; font-weight: 700;">LOOKING FOR: PICTURE BOOKS, MG, YA</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Clare Wallace joined the Darley Anderson Agency in January 2011 and is building both the Darley Anderson Children&rsquo;s Agency and the Darley Anderson Illustration Agency lists. As chief talent-spotter, Clare loves to discover memorable new characters, bold and unique voices, strong concepts and gripping storytelling. She represents picture books, middle-grade, teenage and YA. Clare is particularly looking for funny chapter books for younger readers at the moment, as well as contemporary MG, YA fantasy, romance, and rom coms, especially with underrepresented protagonists. Whatever the age range, Clare loves a big hook, a lot of heart, and a standout voice. For picture books she has the widest taste, from daft to lyrical, rhyming to prose. If your submission doesn&rsquo;t fit a description here, it doesn&rsquo;t mean Clare doesn&rsquo;t want to receive it. She often doesn&rsquo;t know what she&rsquo;s looking for until she finds it (although she is not the person for steampunk or space opera). Her list gives a good indication of her taste.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The clients Clare represents include Perdita &amp; Honor Cargill, Caroline Crowe, Tom Ellen, Martyn Ford, Stewart Foster, Olivia Hope, A M Howell, Polly Ho-Yen, Rachel Ip, Beth Reekles, J.P. Rose, Lindsay Galvin, Dave Rudden, Deirdre Sullivan and Efua Traor&eacute;.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Clare would like you to send a covering letter, a one page synopsis and the first three chapters (Max 5000 words) of your manuscript. For picture books, please submit a covering letter and up to three completed texts.</strong></p><p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">(<em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">In addition to the paid sessions, Clare is kindly offering one free session for low income/underrepresented writers. Please email <a href="mailto:agent121@iaminprint.co.uk" style="box-sizing: border-box; text-decoration: inherit; cursor: pointer; user-select: auto; font-size: var(--font-size);" fr-original-style="box-sizing: border-box; text-decoration: inherit; cursor: pointer; user-select: auto;">agent121@iaminprint.co.uk</a> to apply, outlining your case for this option which is offered at the&nbsp;</em><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">discretion of&nbsp;</em><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">I Am In Print)</em>.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">By booking you understand you need to conduct an internet connection test with<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;</strong><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">I Am In Pr</em><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">int</em> prior to the event. You also agree to email your material in one document to reach <em fr-original-style="" style="box-sizing: border-box;">I Am In Print</em> by the stated submission deadline and note that <em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">I Am In Print</em> take no responsibility for the advice received during your agent meeting.</p><p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><strong style="box-sizing: border-box; font-weight: 700;" fr-original-style="box-sizing: border-box; font-weight: 700;">The submission deadline is: Monday 7 October 2024</strong></p>

LOOKING FOR: PICTURE BOOKS, MG, YA
Clare Wallace joined the Darley Anderson Agency in January 2011 and is building both the Darley Anderson Children’s Agency and the Darley Anderson Illustration Agency lists. As chief talent-spotter, Clare loves to discover memorable new characters, bold and unique voices, strong concepts and gripping storytelling. She represents picture books, middle-grade, teenage and YA. Clare is particularly looking for funny chapter books for younger readers at the moment, as well as contemporary MG, YA fantasy, romance, and rom coms, especially with underrepresented protagonists. Whatever the age range, Clare loves a big hook, a lot of heart, and a standout voice. For picture books she has the widest taste, from daft to lyrical, rhyming to prose. If your submission doesn’t fit a description here, it doesn’t mean Clare doesn’t want to receive it. She often doesn’t know what she’s looking for until she finds it (although she is not the person for steampunk or space opera). Her list gives a good indication of her taste.
The clients Clare represents include Perdita & Honor Cargill, Caroline Crowe, Tom Ellen, Martyn Ford, Stewart Foster, Olivia Hope, A M Howell, Polly Ho-Yen, Rachel Ip, Beth Reekles, J.P. Rose, Lindsay Galvin, Dave Rudden, Deirdre Sullivan and Efua Traoré.
Clare would like you to send a covering letter, a one page synopsis and the first three chapters (Max 5000 words) of your manuscript. For picture books, please submit a covering letter and up to three completed texts.
Please send EITHER picture books OR another genre, not both in one submission.
(In addition to the paid sessions, Clare is kindly offering one free session for low income/underrepresented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print). 
By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting.
The submission deadline is: Monday 11 November 2024

I Am In Print

Fiction Writing

SOLD OUT! 25th November Clare Wallace #Agent121. Looking for: PICTURE BOOKS, MG, YA

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p><p>This three-day instructor-led course is aimed at modern device management professionals looking to manage their enterprise devices using Microsoft Intune. This course will cover Enrolment, Application Management, Endpoint Security and Windows Autopilot as well as Azure Active Directory Conditional Access and Identity Protection. The delegates will learn how to enroll devices, deploy applications and manage them to maximize user productivity and device security.</p></div><div id="course-pills-2"><h3>1: Introduction to Microsoft Intune</h3> <ul> <li> Mobile Device Management</li> <li>Microsoft Intune</li> <li> Azure Active Directory</li> <li>AAD Identity Protection</li> <li> AAD Conditional Access</li></ul>  <h3>2: Microsoft Intune Device Management</h3><ul> <li>Enrolling Devices</li> <li> Device Compliance</li> <li> Device Profiles</li> <li>Device Updates</li></ul>  <h3>3: Microsoft Intune Application Management</h3><ul> <li> Application Management</li> <li> Deploying Applications</li> <li> Application Configuration</li> <li> Managing Applications</li> <li> Policy Sets and Guided Scenarios</li></ul>  <h3>4: Microsoft Intune Endpoint Security</h3><ul> <li> Security Baselines and tasks</li> <li> Antivirus</li> <li>Disk Encryption</li> <li>Firewall</li> <li>Atack Surface reduction</li> <li> Endpoint detection and response</li> <li> Account Protection</li></ul>  <h3>5: Deploying Windows with Windows Autopilot</h3><ul> <li> Windows Autopilot overview</li> <li> Preparing for Windows Autopilot deployment</li> <li>Deploying Windows 11 using Windows Autopilot</li></ul>  <h3>6: Microsoft Intune Additional and Premium Features</h3><ul> <li> Remote Help</li> <li> Tunnel for Mobile Application Management</li> <li>Endpoint Privilege Management</li> <li> Advanced Endpoint Analytics</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55399 Implementing and Managing Microsoft Intune training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the 55399 Implementing and Managing Microsoft Intune 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.  <p></p>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.<p></p></div>

Duration
3 Days
18 CPD hours
This three-day instructor-led course is aimed at modern device management professionals looking to manage their enterprise devices using Microsoft Intune. This course will cover Enrolment, Application Management, Endpoint Security and Windows Autopilot as well as Azure Active Directory Conditional Access and Identity Protection. The delegates will learn how to enroll devices, deploy applications and manage them to maximize user productivity and device security.
1: Introduction to Microsoft Intune
Mobile Device Management
Microsoft Intune
Azure Active Directory
AAD Identity Protection
AAD Conditional Access
2: Microsoft Intune Device Management
Enrolling Devices
Device Compliance
Device Profiles
Device Updates
3: Microsoft Intune Application Management
Application Management
Deploying Applications
Application Configuration
Managing Applications
Policy Sets and Guided Scenarios
4: Microsoft Intune Endpoint Security
Security Baselines and tasks
Antivirus
Disk Encryption
Firewall
Atack Surface reduction
Endpoint detection and response
Account Protection
5: Deploying Windows with Windows Autopilot
Windows Autopilot overview
Preparing for Windows Autopilot deployment
Deploying Windows 11 using Windows Autopilot
6: Microsoft Intune Additional and Premium Features
Remote Help
Tunnel for Mobile Application Management
Endpoint Privilege Management
Advanced Endpoint Analytics
Additional course details:
Nexus Humans 55399 Implementing and Managing Microsoft Intune 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 55399 Implementing and Managing Microsoft Intune 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.


Nexus Human

Microsoft AZ-900

Microsoft Certified Trainer (MCT)

Manager Training

Trainers Course

Microsoft AZ-303

Microsoft AZ-700

55399 Implementing and Managing Microsoft Intune

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is designed for anyone who needs an understanding of IT Service Management to help deliver better value to customers. It is appropriate for all IT staff and management, as well as customers who work closely with IT to support business requirements. This course is also designed for students who are seeking the ITILÂ© 4 Foundation certification and who want to prepare for ITILÂ© 4 Foundation exam.</p>Overview<p>By the completion of this course, you will have a deep understanding of the 7 Guiding Principles, 4 Dimensions of Service Management, 34 ITILÂ© Practices, and the new Service Value Chain that incorporate the core of ITILÂ© version 4.</p><p>ITILÂ© is the world?s leading best practice framework for implementing IT Service Management. ITIL version 4 introduces IT Service Management through the lens of a Service Value System (SVS), which provides a holistic end-to-end view of how to successfully contribute to business value, and also how to leverage concepts from models such as Lean IT, Agile, DevOps and Organizational Change Management. This foundational course immerses you in the guiding principles, dimensions, and practices of ITILÂ© 4.  This course will earn you 21 PDUs. <br /><br /> <b>This class includes an exam voucher. </b></p></div><div id="course-pills-2"><h3>1 - ITIL 4 OVERVIEW</h3> <ul> <li>Introduction to ITIL</li> <li>Key Concepts of ITIL</li> </ul> <h3>2 - The ITIL Framework</h3> <ul> <li>The Four Dimensions of Service Management</li> <li>The ITIL Service Value System</li> </ul> <h3>3 - The ITIL Guiding Principles</h3> <ul> <li>Focus on Value</li> <li>Start Where You Are</li> <li>Progress Iteratively with Feedback</li> <li>Collaborate and Promote Visibility</li> <li>Think and Work Holistically</li> <li>Keep It Simple and Practical</li> <li>Optimize and Automate</li> </ul> <h3>4 - THE ITIL SERVICE VALUE SYSTEM (SVS)</h3> <ul> <li>Governance</li> <li>The Service Value Chain</li> <li>Continual Improvement</li> </ul> <h3>5 - Key ITIL Practices</h3> <ul> <li>Continual Improvement</li> <li>Service Level Management</li> <li>Change Control</li> <li>Incident Management</li> <li>Service Request Management</li> <li>Service Desk</li> <li>Problem Management</li> </ul> <h3>6 - Other ITIL Practices</h3> <ul> <li>General Management Practices</li> <li>Service Management Practices</li> <li>Technical Management Practices</li> </ul></div>

Duration
3 Days
18 CPD hours
This course is intended for
This course is designed for anyone who needs an understanding of IT Service Management to help deliver better value to customers. It is appropriate for all IT staff and management, as well as customers who work closely with IT to support business requirements. This course is also designed for students who are seeking the ITILÂ© 4 Foundation certification and who want to prepare for ITILÂ© 4 Foundation exam.
Overview
By the completion of this course, you will have a deep understanding of the 7 Guiding Principles, 4 Dimensions of Service Management, 34 ITILÂ© Practices, and the new Service Value Chain that incorporate the core of ITILÂ© version 4.
ITILÂ© is the world?s leading best practice framework for implementing IT Service Management. ITIL version 4 introduces IT Service Management through the lens of a Service Value System (SVS), which provides a holistic end-to-end view of how to successfully contribute to business value, and also how to leverage concepts from models such as Lean IT, Agile, DevOps and Organizational Change Management. This foundational course immerses you in the guiding principles, dimensions, and practices of ITILÂ© 4. This course will earn you 21 PDUs. 

 This class includes an exam voucher. 
1 - ITIL 4 OVERVIEW
Introduction to ITIL
Key Concepts of ITIL
2 - The ITIL Framework
The Four Dimensions of Service Management
The ITIL Service Value System
3 - The ITIL Guiding Principles
Focus on Value
Start Where You Are
Progress Iteratively with Feedback
Collaborate and Promote Visibility
Think and Work Holistically
Keep It Simple and Practical
Optimize and Automate
4 - THE ITIL SERVICE VALUE SYSTEM (SVS)
Governance
The Service Value Chain
Continual Improvement
5 - Key ITIL Practices
Continual Improvement
Service Level Management
Change Control
Incident Management
Service Request Management
Service Desk
Problem Management
6 - Other ITIL Practices
General Management Practices
Service Management Practices
Technical Management Practices

IT Service Management

ITIL

IT Certifications

IT (Information Technology)

International Trauma Life Support (ITLS)

Institute of Leadership & Management (ILM)

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is designed for Administrators who need to setup, configure and manage SharePoint Online as part of their Office 365 Administration.</p>Overview<p>After completing this course, students will gain the skills to:  - Understand the architecture of SharePoint Online  - Have knowledge of all the components in SharePoint Online  - Have on hands on experience configuring the components of SharePoint Online  - Have hands on experience configuring the options  - Work with Site Collections and storage options  - Manage user profiles and social profiling  - Understand and configure data connectivity in SharePoint Online  - Build a taxonomy structure   - Understand and configure Search in SharePoint Online  - Configure and deploy apps  - Understand and define Enterprise content management and data loss prevention.  - Configure additional options and features in SharePoint Online such as Information Rights Management</p><p>This course will introduce the audience to SharePoint Online Administration in Office 365 and explain and demonstrate the configuration options for SharePoint Online. The course is appropriate for existing SharePoint on-premises administrators and new administrators to Office 365 who need to understand how to correctly setup SharePoint Online for their company. The course will also help SharePoint on-premise administrators understand the differences between SharePoint on-premises and SharePoint Online.</p></div><div id="course-pills-2"><h3>1 - INTRODUCTION TO OFFICE 365 AND SHAREPOINT ONLINE</h3> <ul> <li>Introduction to the Office 365 Administration Center</li> <li>Configure Reporting</li> <li>Accessing SharePoint management tools</li> <li>Accessing security and compliancy</li> <li>Managing Office 365 and SharePoint Online with PowerShell</li> <li>Comparing On Premises SharePoint with SharePoint Online</li> <li>User identity in Office 365 and SharePoint Online</li> <li>Manging user domains</li> <li>Building Hybrid scenarios</li> <li>OneDrive and Sites redirection</li> <li>Yammer redirection</li> <li>Understand hybrid search</li> <li>Hybrid business data connectivity</li> <li>Hybrid taxonomy</li> </ul> <h3>2 - WORKING WITH SITE COLLECTIONS</h3> <ul> <li>Introduction to classic and modern admin centers</li> <li>Creating Site Collections</li> <li>Defining ownership and security for site collections</li> <li>Configuring Storage</li> <li>Configure External Access to site collections</li> <li>Recovering site collections</li> <li>Configure external sharing</li> <li>Managing site collections with PowerShell</li> </ul> <h3>3 - MANAGING USER PROFILES</h3> <ul> <li>Overview of the profile service</li> <li>Defining profile properties</li> <li>Map profile properties to a term store</li> <li>Creating custom profile properties</li> <li>Managing audiences</li> <li>Creating audiences</li> <li>Managing user profile policies</li> <li>Configure trusted my site host locations</li> <li>Configure preferred search center locations</li> <li>Defining read access permission levels</li> <li>Configuring newsfeed options</li> <li>Setup email notifications</li> <li>Configure my site cleanup</li> </ul> <h3>4 - WORKING WITH DATA CONNECTIONS</h3> <ul> <li>Introduction to Data Connections</li> <li>Overview of PowerApps, Flow and PowerBi</li> <li>Overview of the business connectivity service</li> <li>Introduction to BDC definition files</li> <li>Creating BDC definition files</li> <li>Introduction to the secure store service</li> <li>Configuring the secure store service</li> <li>Creating secure store target application settings</li> <li>Configure connections to cloud services</li> <li>Configure connections to on-premises services</li> <li>Tools to build data connections</li> <li>Creating external content types</li> <li>Building external lists using external data</li> </ul> <h3>5 - MANAGING THE TERM STORE</h3> <ul> <li>Overview of the term store</li> <li>Understanding terms and life cycle management</li> <li>Creating term groups</li> <li>Creating the term store</li> <li>Creating Term Sets in the UI</li> <li>Creating Term Sets via importing via a CSV</li> <li>Creating terms in the UI</li> <li>Creating terms via PowerShell and CSOM</li> <li>Manage terms with synonyms and pinning</li> <li>Configure delegated administration</li> </ul> <h3>6 - CONFIGURING SEARCH</h3> <ul> <li>An Introduction to the search service</li> <li>Classic versus Modern search experience</li> <li>Understanding Managed Properties</li> <li>Create Managed Properties</li> <li>Manage Authoritative pages</li> <li>Understand Result sources</li> <li>Create and configure result sources</li> <li>Understand Query rules</li> <li>Promoting results through query rules</li> <li>Remove search results from the index</li> <li>Exporting search configurations</li> <li>Importing search configurations</li> </ul> <h3>7 - CONFIGURING APPS</h3> <ul> <li>An Introduction to Apps</li> <li>Understanding the App Catalog</li> <li>Building the App catalog</li> <li>Adding Apps to the catalog</li> <li>Add Apps to your SharePoint sites</li> <li>Adding Apps via the marketplace store</li> <li>Manage App licensing</li> <li>Configure store access settings</li> <li>Monitoring app usage</li> </ul> <h3>8 - ENTERPRISE CONTENT MANAGEMENT IN SHAREPOINT ONLINE</h3> <ul> <li>An Introduction to ECM in SharePoint Online</li> <li>Components of ECM</li> <li>Office 365 versus classic compliancy</li> <li>Understanding In-Place records management</li> <li>Configure In-Place records management</li> <li>Understanding the records center</li> <li>Build and configure a records center</li> <li>Understanding the compliancy policy center</li> <li>Build a compliancy policy center and configure policies</li> <li>Discover the security and compliancy center</li> <li>Configure an eDiscovery center</li> <li>Build an eDiscovery case</li> <li>Understand data loss prevention</li> <li>Build a data loss prevention policy and query</li> <li>Working with classification and data governance</li> </ul> <h3>9 - MANAGE OPTIONS FOR SHAREPOINT ONLINE</h3> <ul> <li>Configure OneDrive features</li> <li>Configure use of Yammer or Newsfeeds</li> <li>Understand Information Rights Management</li> <li>Configure Information Rights Management</li> <li>Define site classification options</li> <li>Understand early release options for Office 365</li> <li>Configure Early release options for your Office 365 tenant</li> <li>Manage Access Control</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55238 SharePoint Online for Administrators training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the 55238 SharePoint Online for Administrators 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.  <p></p>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.<p></p></div>

Duration
3 Days
18 CPD hours
This course is intended for
This course is designed for Administrators who need to setup, configure and manage SharePoint Online as part of their Office 365 Administration.
Overview
After completing this course, students will gain the skills to: - Understand the architecture of SharePoint Online - Have knowledge of all the components in SharePoint Online - Have on hands on experience configuring the components of SharePoint Online - Have hands on experience configuring the options - Work with Site Collections and storage options - Manage user profiles and social profiling - Understand and configure data connectivity in SharePoint Online - Build a taxonomy structure - Understand and configure Search in SharePoint Online - Configure and deploy apps - Understand and define Enterprise content management and data loss prevention. - Configure additional options and features in SharePoint Online such as Information Rights Management
This course will introduce the audience to SharePoint Online Administration in Office 365 and explain and demonstrate the configuration options for SharePoint Online. The course is appropriate for existing SharePoint on-premises administrators and new administrators to Office 365 who need to understand how to correctly setup SharePoint Online for their company. The course will also help SharePoint on-premise administrators understand the differences between SharePoint on-premises and SharePoint Online.
1 - INTRODUCTION TO OFFICE 365 AND SHAREPOINT ONLINE
Introduction to the Office 365 Administration Center
Configure Reporting
Accessing SharePoint management tools
Accessing security and compliancy
Managing Office 365 and SharePoint Online with PowerShell
Comparing On Premises SharePoint with SharePoint Online
User identity in Office 365 and SharePoint Online
Manging user domains
Building Hybrid scenarios
OneDrive and Sites redirection
Yammer redirection
Understand hybrid search
Hybrid business data connectivity
Hybrid taxonomy
2 - WORKING WITH SITE COLLECTIONS
Introduction to classic and modern admin centers
Creating Site Collections
Defining ownership and security for site collections
Configuring Storage
Configure External Access to site collections
Recovering site collections
Configure external sharing
Managing site collections with PowerShell
3 - MANAGING USER PROFILES
Overview of the profile service
Defining profile properties
Map profile properties to a term store
Creating custom profile properties
Managing audiences
Creating audiences
Managing user profile policies
Configure trusted my site host locations
Configure preferred search center locations
Defining read access permission levels
Configuring newsfeed options
Setup email notifications
Configure my site cleanup
4 - WORKING WITH DATA CONNECTIONS
Introduction to Data Connections
Overview of PowerApps, Flow and PowerBi
Overview of the business connectivity service
Introduction to BDC definition files
Creating BDC definition files
Introduction to the secure store service
Configuring the secure store service
Creating secure store target application settings
Configure connections to cloud services
Configure connections to on-premises services
Tools to build data connections
Creating external content types
Building external lists using external data
5 - MANAGING THE TERM STORE
Overview of the term store
Understanding terms and life cycle management
Creating term groups
Creating the term store
Creating Term Sets in the UI
Creating Term Sets via importing via a CSV
Creating terms in the UI
Creating terms via PowerShell and CSOM
Manage terms with synonyms and pinning
Configure delegated administration
6 - CONFIGURING SEARCH
An Introduction to the search service
Classic versus Modern search experience
Understanding Managed Properties
Create Managed Properties
Manage Authoritative pages
Understand Result sources
Create and configure result sources
Understand Query rules
Promoting results through query rules
Remove search results from the index
Exporting search configurations
Importing search configurations
7 - CONFIGURING APPS
An Introduction to Apps
Understanding the App Catalog
Building the App catalog
Adding Apps to the catalog
Add Apps to your SharePoint sites
Adding Apps via the marketplace store
Manage App licensing
Configure store access settings
Monitoring app usage
8 - ENTERPRISE CONTENT MANAGEMENT IN SHAREPOINT ONLINE
An Introduction to ECM in SharePoint Online
Components of ECM
Office 365 versus classic compliancy
Understanding In-Place records management
Configure In-Place records management
Understanding the records center
Build and configure a records center
Understanding the compliancy policy center
Build a compliancy policy center and configure policies
Discover the security and compliancy center
Configure an eDiscovery center
Build an eDiscovery case
Understand data loss prevention
Build a data loss prevention policy and query
Working with classification and data governance
9 - MANAGE OPTIONS FOR SHAREPOINT ONLINE
Configure OneDrive features
Configure use of Yammer or Newsfeeds
Understand Information Rights Management
Configure Information Rights Management
Define site classification options
Understand early release options for Office 365
Configure Early release options for your Office 365 tenant
Manage Access Control
Additional course details:
Nexus Humans 55238 SharePoint Online for Administrators 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 55238 SharePoint Online for Administrators 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.


Microsoft Certification

Microsoft Sharepoint

Microsoft 365

Microsoft AZ-104

SharePoint

55238 SharePoint Online for Administrators

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is intended for IT professionals who need to manage the day-to-day environment of an SCCM 2012 SP1 or newer environment. Knowledge of the workings of a standalone primary SCCM site and basic PowerShell experience is recommended.</p>Overview<p>Create additional site system roles on existing or new servers. Modify high level site settings. Create and modify Discovery Methods, Boundaries and Boundary Groups. Create Collections using any of the membership rules available. Delegate authority through Roles and Scopes. Install the Configuration Manager client, modify client settings and restrict access to site systems. Deploy software to clients. Deploy software updates to clients. Configure compliance settings targeted against collections. Modify settings that govern monitoring functions such as Alerts and Status Settings. Work with Task Sequences for Operating System Deployment. Write basic PowerShell scripts using cmdlets learned and scripting constructs to accomplish configuration tasks.</p><p>This course provides students with the knowledge and skills needed to use PowerShell for System Center Configuration Manager (SCCM) administration. In this course, students learn how to access the PowerShell cmdlets included with SCCM 2012 R2 and use them to perform configuration tasks for a primary site. Individual cmdlets will be used in working with objects such as Boundaries, Boundary Groups, Collections, Software Deployment, Patching, Compliance Settings, OSD Task Sequences, and many others. Basic scripting will also be covered so that students can learn how to put PowerShell to use when working with large sets of objects.</p>Prerequisites<p></p><li>Basic Windows and Active Directory knowledge.  </li><li>Conceptual knowledge of Configuration Manager objects and how they interact.  </li><li>Basic experience performing configuration tasks in ECM using the graphical console.  </li><li>Experience working from a command prompt.  </li><li>Basic knowledge of the fundamentals of Windows PowerShell.<p></p></li></div><div id="course-pills-2"><h3>1 - REVIEW OF SYSTEM CENTER CONFIGURATION MANAGER CONCEPTS</h3> <ul> <li>Architecture of an System Center 2012 Configuration Manager Installation</li> <li>Managing Assets</li> <li>Content Delivery and Management</li> <li>Security, Monitoring, and Remote Management</li> </ul> <h3>2 - MANAGING RESOURCES</h3> <ul> <li>Implementing Discovery</li> <li>Organizing Resources with Collections</li> <li>Working with Boundaries</li> </ul> <h3>3 - WORKING WITH CLIENTS</h3> <ul> <li>Installing the Configuration Manager Client</li> <li>Managing Client Settings</li> <li>Managing Client Operations</li> <li>Monitoring Client Status</li> </ul> <h3>4 - DISTRIBUTING SOFTWARE</h3> <ul> <li>Configure the Software Distribution Components</li> <li>Working with Distribution Points</li> <li>Creating Content for Distribution</li> <li>Deploying Software Applications</li> </ul> <h3>5 - UPDATING SYSTEMS WITH WSUS AND SCCM</h3> <ul> <li>Integrating Configuration Manager and WSUS</li> <li>Managing Updates through Software Update Groups</li> <li>Creating and Deploying Update Packages</li> <li>Working with Automatic Deployment Rules</li> </ul> <h3>6 - HOW POWERSHELL CAN MANAGE COMPLIANCE SETTINGS</h3> <ul> <li>Creating Compliance Settings Objects</li> <li>Deploying and Monitor the Baseline</li> </ul> <h3>7 - CONFIGURING OPERATING SYSTEM DEPLOYMENT OBJECTS</h3> <ul> <li>Preparing the OSD Environment</li> <li>Working with Task Sequences</li> </ul> <h3>8 - WORKING AT THE SITE LEVEL</h3> <ul> <li>Modify the Site</li> <li>Adding Site System Roles</li> <li>Adding a Secondary Site</li> </ul> <h3>9 - SECURITY AND MONITORING</h3> <ul> <li>Configuring Role Based Administration</li> <li>Implementing Endpoint Protection</li> <li>Configuring Monitoring Options</li> </ul> <h3>10 - USING POWERSHELL SCRIPTING TO AUTOMATE SCCM TASKS</h3> <ul> <li>Review of Scripting Constructs</li> <li>Introduction to the Configuration Manager WMI Classes</li> </ul></div>

Duration
3 Days
18 CPD hours
This course is intended for
This course is intended for IT professionals who need to manage the day-to-day environment of an SCCM 2012 SP1 or newer environment. Knowledge of the workings of a standalone primary SCCM site and basic PowerShell experience is recommended.
Overview
Create additional site system roles on existing or new servers. Modify high level site settings. Create and modify Discovery Methods, Boundaries and Boundary Groups. Create Collections using any of the membership rules available. Delegate authority through Roles and Scopes. Install the Configuration Manager client, modify client settings and restrict access to site systems. Deploy software to clients. Deploy software updates to clients. Configure compliance settings targeted against collections. Modify settings that govern monitoring functions such as Alerts and Status Settings. Work with Task Sequences for Operating System Deployment. Write basic PowerShell scripts using cmdlets learned and scripting constructs to accomplish configuration tasks.
This course provides students with the knowledge and skills needed to use PowerShell for System Center Configuration Manager (SCCM) administration. In this course, students learn how to access the PowerShell cmdlets included with SCCM 2012 R2 and use them to perform configuration tasks for a primary site. Individual cmdlets will be used in working with objects such as Boundaries, Boundary Groups, Collections, Software Deployment, Patching, Compliance Settings, OSD Task Sequences, and many others. Basic scripting will also be covered so that students can learn how to put PowerShell to use when working with large sets of objects.
Prerequisites

Basic Windows and Active Directory knowledge.
Conceptual knowledge of Configuration Manager objects and how they interact.
Basic experience performing configuration tasks in ECM using the graphical console.
Experience working from a command prompt.
Basic knowledge of the fundamentals of Windows PowerShell.
1 - REVIEW OF SYSTEM CENTER CONFIGURATION MANAGER CONCEPTS
Architecture of an System Center 2012 Configuration Manager Installation
Managing Assets
Content Delivery and Management
Security, Monitoring, and Remote Management
2 - MANAGING RESOURCES
Implementing Discovery
Organizing Resources with Collections
Working with Boundaries
3 - WORKING WITH CLIENTS
Installing the Configuration Manager Client
Managing Client Settings
Managing Client Operations
Monitoring Client Status
4 - DISTRIBUTING SOFTWARE
Configure the Software Distribution Components
Working with Distribution Points
Creating Content for Distribution
Deploying Software Applications
5 - UPDATING SYSTEMS WITH WSUS AND SCCM
Integrating Configuration Manager and WSUS
Managing Updates through Software Update Groups
Creating and Deploying Update Packages
Working with Automatic Deployment Rules
6 - HOW POWERSHELL CAN MANAGE COMPLIANCE SETTINGS
Creating Compliance Settings Objects
Deploying and Monitor the Baseline
7 - CONFIGURING OPERATING SYSTEM DEPLOYMENT OBJECTS
Preparing the OSD Environment
Working with Task Sequences
8 - WORKING AT THE SITE LEVEL
Modify the Site
Adding Site System Roles
Adding a Secondary Site
9 - SECURITY AND MONITORING
Configuring Role Based Administration
Implementing Endpoint Protection
Configuring Monitoring Options
10 - USING POWERSHELL SCRIPTING TO AUTOMATE SCCM TASKS
Review of Scripting Constructs
Introduction to the Configuration Manager WMI Classes

Sccm

Microsoft Certified Technology Specialist (MCTS)

Microsoft SC-100

Commercial & Contract Management Certification Program (CCM)

Microsoft SC-200

55133 PowerShell for System Center Configuration Manager Administrators

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is designed for software developers, testers, and architects who design and develop software in various programming languages and platforms, including desktop, web, cloud, and mobile, and who want to improve their ability to deliver software that is of high quality, particularly regarding security and privacy.<br />This course is also designed for students who are seeking the CertNexus Cyber Secure Coder (CSC) Exam CSC-210 certification</p>Overview<p>In this course, you will employ best practices in software development to develop secure software.You will:<br />Identify the need for security in your software projects.<br />Eliminate vulnerabilities within software.<br />Use a Security by Design approach to design a secure architecture for your software.<br />Implement common protections to protect users and data.<br />Apply various testing methods to find and correct security defects in your software.<br />Maintain deployed software to ensure ongoing security...</p><p>The stakes for software security are very high, and yet many development teams deal with software security only after the code has been developed and the software is being prepared for delivery. As with any aspect of software quality, to ensure successful implementation, security and privacy issues should be managed throughout the entire software development lifecycle. <br />This course presents an approach for dealing with security and privacy throughout the entire software development lifecycle. You will learn about vulnerabilities that undermine security, and how to identify and remediate them in your own projects. You will learn general strategies for dealing with security defects and misconfiguration, how to design software to deal with the human element in security, and how to incorporate security into all phases of development.<br /></p></div><div id="course-pills-2"><h4>Identifying the Need for Security in Your Software Projects</h4><ul><li>Identify Security Requirements and Expectations</li><li>Identify Factors That Undermine Software Security</li><li>Find Vulnerabilities in Your Software</li><li>Gather Intelligence on Vulnerabilities and Exploits</li></ul><h4>Handling Vulnerabilities</h4><ul><li>Handle Vulnerabilities Due to Software Defects and Misconfiguration</li><li>Handle Vulnerabilities Due to Human Factors</li><li>Handle Vulnerabilities Due to Process Shortcomings</li></ul><h4>Designing for Security</h4><ul><li>Apply General Principles for Secure Design</li><li>Design Software to Counter Specific Threats</li></ul><h4>Developing Secure Code</h4><ul><li>Follow Best Practices for Secure Coding</li><li>Prevent Platform Vulnerabilities</li><li>Prevent Privacy Vulnerabilities</li></ul><h4>Implementing Common Protections</h4><ul><li>Limit Access Using Login and User Roles</li><li>Protect Data in Transit and At Rest</li><li>Implement Error Handling and Logging</li><li>Protect Sensitive Data and Functions</li><li>Protect Database Access</li></ul><h4>Testing Software Security</h4><ul><li>Perform Security Testing</li><li>Analyze Code to find Security Problems</li><li>Use Automated Testing Tools to Find Security Problems</li></ul><h4>Maintaining Security in Deployed Software</h4><ul><li>Monitor and Log Applications to Support Security</li><li>Maintain Security after Deployment</li></ul></div>

Duration
3 Days
18 CPD hours
This course is intended for
This course is designed for software developers, testers, and architects who design and develop software in various programming languages and platforms, including desktop, web, cloud, and mobile, and who want to improve their ability to deliver software that is of high quality, particularly regarding security and privacy.
This course is also designed for students who are seeking the CertNexus Cyber Secure Coder (CSC) Exam CSC-210 certification
Overview
In this course, you will employ best practices in software development to develop secure software.You will:
Identify the need for security in your software projects.
Eliminate vulnerabilities within software.
Use a Security by Design approach to design a secure architecture for your software.
Implement common protections to protect users and data.
Apply various testing methods to find and correct security defects in your software.
Maintain deployed software to ensure ongoing security...
The stakes for software security are very high, and yet many development teams deal with software security only after the code has been developed and the software is being prepared for delivery. As with any aspect of software quality, to ensure successful implementation, security and privacy issues should be managed throughout the entire software development lifecycle. 
This course presents an approach for dealing with security and privacy throughout the entire software development lifecycle. You will learn about vulnerabilities that undermine security, and how to identify and remediate them in your own projects. You will learn general strategies for dealing with security defects and misconfiguration, how to design software to deal with the human element in security, and how to incorporate security into all phases of development.

Identifying the Need for Security in Your Software Projects
Identify Security Requirements and Expectations
Identify Factors That Undermine Software Security
Find Vulnerabilities in Your Software
Gather Intelligence on Vulnerabilities and Exploits
Handling Vulnerabilities
Handle Vulnerabilities Due to Software Defects and Misconfiguration
Handle Vulnerabilities Due to Human Factors
Handle Vulnerabilities Due to Process Shortcomings
Designing for Security
Apply General Principles for Secure Design
Design Software to Counter Specific Threats
Developing Secure Code
Follow Best Practices for Secure Coding
Prevent Platform Vulnerabilities
Prevent Privacy Vulnerabilities
Implementing Common Protections
Limit Access Using Login and User Roles
Protect Data in Transit and At Rest
Implement Error Handling and Logging
Protect Sensitive Data and Functions
Protect Database Access
Testing Software Security
Perform Security Testing
Analyze Code to find Security Problems
Use Automated Testing Tools to Find Security Problems
Maintaining Security in Deployed Software
Monitor and Log Applications to Support Security
Maintain Security after Deployment

Certified in Cybersecurity (CC)

Certificate in Information Security Management Principles (CISMP)

Cyber Security

Cyber Security Foundation

Certified Cyber Professional (CCP)

CompTIA Security+

CertNexus Certified Cyber Secure Coder (CSC-210)

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p></p><p>This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.</p><p></p><p></p><p>This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.</p><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Transact-SQL</h3> <ul> <li>Work with schemas</li> <li>Explore the structure of SQL statements</li> <li>Examine the SELECT statement</li> <li>Work with data types</li> <li>Handle NULLs</li> </ul> <h3>2 - Sort and filter results in T-SQL</h3> <ul> <li>Sort your results</li> <li>Limit the sorted results</li> <li>Page results</li> <li>Remove duplicates</li> <li>Filter data with predicates</li> </ul> <h3>3 - Combine multiple tables with JOINs in T-SQL</h3> <ul> <li>Understand joins concepts and syntax</li> <li>Use inner joins</li> <li>Use outer joins</li> <li>Use cross joins</li> <li>Use self joins</li> </ul> <h3>4 - Write Subqueries in T-SQL</h3> <ul> <li>Understand subqueries</li> <li>Use scalar or multi-valued subqueries</li> <li>Use self-contained or correlated subqueries</li> </ul> <h3>5 - Use built-in functions and GROUP BY in Transact-SQL</h3> <ul> <li>Categorize built-in functions</li> <li>Use scalar functions</li> <li>Use ranking and rowset functions</li> <li>Use aggregate functions</li> <li>Summarize data with GROUP BY</li> <li>Filter groups with HAVING</li> </ul> <h3>6 - Modify data with T-SQL</h3> <ul> <li>Insert data</li> <li>Generate automatic values</li> <li>Update data</li> <li>Delete data</li> <li>Merge data based on multiple tables</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the DP-080T00 Querying Data with Microsoft Transact-SQL 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.  <p></p>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.<p></p></div>

Duration
2 Days
12 CPD hours
This course is intended for

This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.


This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.

1 - Introduction to Transact-SQL
Work with schemas
Explore the structure of SQL statements
Examine the SELECT statement
Work with data types
Handle NULLs
2 - Sort and filter results in T-SQL
Sort your results
Limit the sorted results
Page results
Remove duplicates
Filter data with predicates
3 - Combine multiple tables with JOINs in T-SQL
Understand joins concepts and syntax
Use inner joins
Use outer joins
Use cross joins
Use self joins
4 - Write Subqueries in T-SQL
Understand subqueries
Use scalar or multi-valued subqueries
Use self-contained or correlated subqueries
5 - Use built-in functions and GROUP BY in Transact-SQL
Categorize built-in functions
Use scalar functions
Use ranking and rowset functions
Use aggregate functions
Summarize data with GROUP BY
Filter groups with HAVING
6 - Modify data with T-SQL
Insert data
Generate automatic values
Update data
Delete data
Merge data based on multiple tables
Additional course details:
Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL 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 DP-080T00 Querying Data with Microsoft Transact-SQL 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.


Learning & Development

Design & Technology Courses (DT)

Data Skills

Teaching & Training

DP-080T00 Querying Data with Microsoft Transact-SQL

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p></p><p>The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.</p><p></p><p></p><p>This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.</p><p></p>Prerequisites<p></p><li>Understanding core data concepts.</li>  <li>Knowledge of working with relational data in the cloud.</li>  <li>Knowledge of working with non-relational data in the cloud.</li>   <li>Knowledge of data analysis and visualization concepts.</li>   <li>DP-900T00 Microsoft Azure Data Fundamentals is recommended<p></p></li></div><div id="course-pills-2"><h3>1 - Discover data analysis</h3> <ul> <li>Overview of data analysis</li> <li>Roles in data</li> <li>Tasks of a data analyst</li> </ul> <h3>2 - Get started building with Power BI</h3> <ul> <li>Use Power BI</li> <li>Building blocks of Power BI</li> <li>Tour and use the Power BI service</li> </ul> <h3>3 - Get data in Power BI</h3> <ul> <li>Get data from files</li> <li>Get data from relational data sources</li> <li>Create dynamic reports with parameters</li> <li>Get data from a NoSQL database</li> <li>Get data from online services</li> <li>Select a storage mode</li> <li>Get data from Azure Analysis Services</li> <li>Fix performance issues</li> <li>Resolve data import errors</li> </ul> <h3>4 - Clean, transform, and load data in Power BI</h3> <ul> <li>Shape the initial data</li> <li>Simplify the data structure</li> <li>Evaluate and change column data types</li> <li>Combine multiple tables into a single table</li> <li>Profile data in Power BI</li> <li>Use Advanced Editor to modify M code</li> </ul> <h3>5 - Design a semantic model in Power BI</h3> <ul> <li>Work with tables</li> <li>Create a date table</li> <li>Work with dimensions</li> <li>Define data granularity</li> <li>Work with relationships and cardinality</li> <li>Resolve modeling challenges</li> </ul> <h3>6 - Add measures to Power BI Desktop models</h3> <ul> <li>Create simple measures</li> <li>Create compound measures</li> <li>Create quick measures</li> <li>Compare calculated columns with measures</li> </ul> <h3>7 - Add calculated tables and columns to Power BI Desktop models</h3> <ul> <li>Create calculated columns</li> <li>Learn about row context</li> <li>Choose a technique to add a column</li> </ul> <h3>8 - Use DAX time intelligence functions in Power BI Desktop models</h3> <ul> <li>Use DAX time intelligence functions</li> <li>Additional time intelligence calculations</li> </ul> <h3>9 - Optimize a model for performance in Power BI</h3> <ul> <li>Review performance of measures, relationships, and visuals</li> <li>Use variables to improve performance and troubleshooting</li> <li>Reduce cardinality</li> <li>Optimize DirectQuery models with table level storage</li> <li>Create and manage aggregations</li> </ul> <h3>10 - Design Power BI reports</h3> <ul> <li>Design the analytical report layout</li> <li>Design visually appealing reports</li> <li>Report objects</li> <li>Select report visuals</li> <li>Select report visuals to suit the report layout</li> <li>Format and configure visualizations</li> <li>Work with key performance indicators</li> </ul> <h3>11 - Configure Power BI report filters</h3> <ul> <li>Apply filters to the report structure</li> <li>Apply filters with slicers</li> <li>Design reports with advanced filtering techniques</li> <li>Consumption-time filtering</li> <li>Select report filter techniques</li> <li>Case study - Configure report filters based on feedback</li> </ul> <h3>12 - Enhance Power BI report designs for the user experience</h3> <ul> <li>Design reports to show details</li> <li>Design reports to highlight values</li> <li>Design reports that behave like apps</li> <li>Work with bookmarks</li> <li>Design reports for navigation</li> <li>Work with visual headers</li> <li>Design reports with built-in assistance</li> <li>Tune report performance</li> <li>Optimize reports for mobile use</li> </ul> <h3>13 - Perform analytics in Power BI</h3> <ul> <li>Explore statistical summary</li> <li>Identify outliers with Power BI visuals</li> <li>Group and bin data for analysis</li> <li>Apply clustering techniques</li> <li>Conduct time series analysis</li> <li>Use the Analyze feature</li> <li>Create what-if parameters</li> <li>Use specialized visuals</li> </ul> <h3>14 - Create and manage workspaces in Power BI</h3> <ul> <li>Distribute a report or dashboard</li> <li>Monitor usage and performance</li> <li>Recommend a development life cycle strategy</li> <li>Troubleshoot data by viewing its lineage</li> <li>Configure data protection</li> </ul> <h3>15 - Manage semantic models in Power BI</h3> <ul> <li>Use a Power BI gateway to connect to on-premises data sources</li> <li>Configure a semantic model scheduled refresh</li> <li>Configure incremental refresh settings</li> <li>Manage and promote semantic models</li> <li>Troubleshoot service connectivity</li> <li>Boost performance with query caching (Premium)</li> </ul> <h3>16 - Create dashboards in Power BI</h3> <ul> <li>Configure data alerts</li> <li>Explore data by asking questions</li> <li>Review Quick insights</li> <li>Add a dashboard theme</li> <li>Pin a live report page to a dashboard</li> <li>Configure a real-time dashboard</li> <li>Set mobile view</li> </ul> <h3>17 - Implement row-level security</h3> <ul> <li>Configure row-level security with the static method</li> <li>Configure row-level security with the dynamic method</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans PL-300T00: Microsoft Power BI Data Analyst training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the PL-300T00: Microsoft Power BI Data Analyst 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.  <p></p>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.<p></p></div>

Duration
3 Days
18 CPD hours
This course is intended for

The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.


This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.

Prerequisites

Understanding core data concepts.
Knowledge of working with relational data in the cloud.
Knowledge of working with non-relational data in the cloud.
Knowledge of data analysis and visualization concepts.
DP-900T00 Microsoft Azure Data Fundamentals is recommended
1 - Discover data analysis
Overview of data analysis
Roles in data
Tasks of a data analyst
2 - Get started building with Power BI
Use Power BI
Building blocks of Power BI
Tour and use the Power BI service
3 - Get data in Power BI
Get data from files
Get data from relational data sources
Create dynamic reports with parameters
Get data from a NoSQL database
Get data from online services
Select a storage mode
Get data from Azure Analysis Services
Fix performance issues
Resolve data import errors
4 - Clean, transform, and load data in Power BI
Shape the initial data
Simplify the data structure
Evaluate and change column data types
Combine multiple tables into a single table
Profile data in Power BI
Use Advanced Editor to modify M code
5 - Design a semantic model in Power BI
Work with tables
Create a date table
Work with dimensions
Define data granularity
Work with relationships and cardinality
Resolve modeling challenges
6 - Add measures to Power BI Desktop models
Create simple measures
Create compound measures
Create quick measures
Compare calculated columns with measures
7 - Add calculated tables and columns to Power BI Desktop models
Create calculated columns
Learn about row context
Choose a technique to add a column
8 - Use DAX time intelligence functions in Power BI Desktop models
Use DAX time intelligence functions
Additional time intelligence calculations
9 - Optimize a model for performance in Power BI
Review performance of measures, relationships, and visuals
Use variables to improve performance and troubleshooting
Reduce cardinality
Optimize DirectQuery models with table level storage
Create and manage aggregations
10 - Design Power BI reports
Design the analytical report layout
Design visually appealing reports
Report objects
Select report visuals
Select report visuals to suit the report layout
Format and configure visualizations
Work with key performance indicators
11 - Configure Power BI report filters
Apply filters to the report structure
Apply filters with slicers
Design reports with advanced filtering techniques
Consumption-time filtering
Select report filter techniques
Case study - Configure report filters based on feedback
12 - Enhance Power BI report designs for the user experience
Design reports to show details
Design reports to highlight values
Design reports that behave like apps
Work with bookmarks
Design reports for navigation
Work with visual headers
Design reports with built-in assistance
Tune report performance
Optimize reports for mobile use
13 - Perform analytics in Power BI
Explore statistical summary
Identify outliers with Power BI visuals
Group and bin data for analysis
Apply clustering techniques
Conduct time series analysis
Use the Analyze feature
Create what-if parameters
Use specialized visuals
14 - Create and manage workspaces in Power BI
Distribute a report or dashboard
Monitor usage and performance
Recommend a development life cycle strategy
Troubleshoot data by viewing its lineage
Configure data protection
15 - Manage semantic models in Power BI
Use a Power BI gateway to connect to on-premises data sources
Configure a semantic model scheduled refresh
Configure incremental refresh settings
Manage and promote semantic models
Troubleshoot service connectivity
Boost performance with query caching (Premium)
16 - Create dashboards in Power BI
Configure data alerts
Explore data by asking questions
Review Quick insights
Add a dashboard theme
Pin a live report page to a dashboard
Configure a real-time dashboard
Set mobile view
17 - Implement row-level security
Configure row-level security with the static method
Configure row-level security with the dynamic method
Additional course details:
Nexus Humans PL-300T00: Microsoft Power BI Data Analyst 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 PL-300T00: Microsoft Power BI Data Analyst 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.


Powerbi

Business Analytics & Intelligence

Microsoft Power BI

Microsoft Power Platform

Microsoft BI

Data Analyst

PL-300T00 Microsoft Power BI Data Analyst

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>The CompTIA Cloud Essentials+ Specialty certification is relevant to IT specialists, IT technical services specialists, IT relationship managers, IT architects, consultants, business and IT management, business process owners, and analysts.</p>Overview<p>Upon successful completion of this course, students will be able to:  Learn the fundamental concepts of cloud computing.  Learn the business aspects and impact of cloud computing.  Differentiate the types of cloud solutions and the adoption measures needed for each.  Identify the technical challenges and the mitigation measures involved in cloud computing.  Identify the steps to successfully adopt cloud services.  Identify the basic concepts of ITIL and describe how the ITIL framework is useful in the implementation of cloud computing in an organization.  Identify the possible risks involved in cloud computing and the risk mitigation measures, and you will also identify the potential cost considerations for the implementation of cloud and its strategic benefits.</p><p>Students will weigh the pros and cons of cloud computing to make effective decisions and meet IT challenges.</p></div><div id="course-pills-2"><h3>1 - Understanding Cloud Computing Concepts</h3> <ul> <li>Topic A: Understand Basic Cloud Concepts and Terms</li> <li>Topic B: Identify Cloud Network and Cloud Storage Technologies</li> <li>Topic C: Recognize Cloud Design Aspects</li> </ul> <h3>2 - Applying Cloud Business Principles</h3> <ul> <li>Topic A: Relate Cloud Concepts to Business Principles</li> <li>Topic B: Establish Cloud Vendor Relations</li> <li>Topic C: Distinguish the Financial Aspects of Engaging a Cloud Service Provider</li> <li>Topic D: Report Financial Expenditures</li> </ul> <h3>3 - Advising a Cloud Design and Migration</h3> <ul> <li>Topic A: Relate Cloud Concepts to Cloud Design and Migration</li> <li>Topic B: Use Cloud Assessments</li> <li>Topic C: Manage Cloud Design</li> <li>Topic D: Compare Cloud Migration Approaches</li> <li>Topic E: Identify Benefits and Solutions of Cloud Services</li> </ul> <h3>4 - Operating in the Cloud</h3> <ul> <li>Topic A: Relate Cloud Concepts to Technical Operations</li> <li>Topic B: Identify the Technical Aspects of Cloud Operations</li> <li>Topic C: Understand DevOps in the Cloud</li> <li>Topic D: Explain Cloud Security Concerns, Measures, and Concepts</li> </ul> <h3>5 - Managing Cloud Governance</h3> <ul> <li>Topic A: Relate Cloud Concepts to Governance</li> <li>Topic B: Apply Risk Management Concepts</li> <li>Topic C: Understand Compliance and the Cloud</li> <li>Topic D: Manage Policies and Procedures for Cloud Services</li> </ul> <h3>6 - Appendix A: Mapping Course Content to the CompTIA Cloud Essentials+ (Exam CLO-002)</h3> <h3>7 - Appendix B: CompTIA Cloud Essentials+ (Exam CLO-002) Acronyms</h3> <h3>8 - Glossary</h3> <h3>9 - Index</h3></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans CompTIA Cloud Essentials Plus Certification (Exam CLO-002) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the CompTIA Cloud Essentials Plus Certification (Exam CLO-002) 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.  <p></p>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.<p></p></div>

Duration
3 Days
18 CPD hours
This course is intended for
The CompTIA Cloud Essentials+ Specialty certification is relevant to IT specialists, IT technical services specialists, IT relationship managers, IT architects, consultants, business and IT management, business process owners, and analysts.
Overview
Upon successful completion of this course, students will be able to: Learn the fundamental concepts of cloud computing. Learn the business aspects and impact of cloud computing. Differentiate the types of cloud solutions and the adoption measures needed for each. Identify the technical challenges and the mitigation measures involved in cloud computing. Identify the steps to successfully adopt cloud services. Identify the basic concepts of ITIL and describe how the ITIL framework is useful in the implementation of cloud computing in an organization. Identify the possible risks involved in cloud computing and the risk mitigation measures, and you will also identify the potential cost considerations for the implementation of cloud and its strategic benefits.
Students will weigh the pros and cons of cloud computing to make effective decisions and meet IT challenges.
1 - Understanding Cloud Computing Concepts
Topic A: Understand Basic Cloud Concepts and Terms
Topic B: Identify Cloud Network and Cloud Storage Technologies
Topic C: Recognize Cloud Design Aspects
2 - Applying Cloud Business Principles
Topic A: Relate Cloud Concepts to Business Principles
Topic B: Establish Cloud Vendor Relations
Topic C: Distinguish the Financial Aspects of Engaging a Cloud Service Provider
Topic D: Report Financial Expenditures
3 - Advising a Cloud Design and Migration
Topic A: Relate Cloud Concepts to Cloud Design and Migration
Topic B: Use Cloud Assessments
Topic C: Manage Cloud Design
Topic D: Compare Cloud Migration Approaches
Topic E: Identify Benefits and Solutions of Cloud Services
4 - Operating in the Cloud
Topic A: Relate Cloud Concepts to Technical Operations
Topic B: Identify the Technical Aspects of Cloud Operations
Topic C: Understand DevOps in the Cloud
Topic D: Explain Cloud Security Concerns, Measures, and Concepts
5 - Managing Cloud Governance
Topic A: Relate Cloud Concepts to Governance
Topic B: Apply Risk Management Concepts
Topic C: Understand Compliance and the Cloud
Topic D: Manage Policies and Procedures for Cloud Services
6 - Appendix A: Mapping Course Content to the CompTIA Cloud Essentials+ (Exam CLO-002)
7 - Appendix B: CompTIA Cloud Essentials+ (Exam CLO-002) Acronyms
8 - Glossary
9 - Index
Additional course details:
Nexus Humans CompTIA Cloud Essentials Plus Certification (Exam CLO-002) 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 CompTIA Cloud Essentials Plus Certification (Exam CLO-002) 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.


1693 Courses in Liverpool

Essential Skills for Ward, Department and Team Managers

By M&K Update Ltd

Writing Policies and Procedures

By SAVO CIC

NPORS Industrial Telescopic Handler (N010A)

By Dynamic Training and Assessments Ltd

NPORS Concrete Pump (N211)

By Dynamic Training and Assessments Ltd

Microsoft Word Training

By FourSquare Innovations Ltd

Microsoft PowerPoint Training

By FourSquare Innovations Ltd

Google Sheets Courses

By FourSquare Innovations Ltd

Microsoft Excel Training

By FourSquare Innovations Ltd

NPORS Plant Mover - Non Operational Duties (N132)

By Dynamic Training and Assessments Ltd

NPORS Material Re - Handler (N722)

By Dynamic Training and Assessments Ltd

Search By Location