Packt

CKAD

Kubernetes

Docker

Learn Kubernetes and prepare yourself for CKA and CKAD certifications. This course helps you gain the knowledge required to design and deploy cloud-native applications on a Kubernetes cluster. All you need is a good understanding of the Docker fundamentals to get started.

Kubernetes - Certified Kubernetes Administrator (CKA) 2022

General Admission

Horsham

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Unlock the Power of Teams: Elevate your leadership with our Building and Leading Effective Teams course. Learn the art of collaboration, communication, and synergy to create high-performing teams that drive success</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><div data-section-id="1695042071629" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="500" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><img src="https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/77df68e-28e4-057f-41d6-ca1d3577146_Course_Overview_Icon.png" alt="" style="width: 80px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 80px;" fr-original-class="fr-draggable"></div></div><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="500" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><br id="isPasted" fr-original-style="" style="box-sizing: border-box;"></div></div><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Course overview</h3><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Duration: 1 day (6 hours)</strong></p><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);">Everyone works in teams today in one way or another. Whatever we do in the workplace we need to interact with another person or a number of people at various times. It is important that we know how to communicate, how to listen, how to work together and how to overcome conflict when it arises in our workplace.</p><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);">Challenges are often created by a lack of trust, poor conflict handling skills, a lack of shared vision and confusion over roles and responsibilities. This course will help delegates understand how to encourage more productive team working in the workplace. By the end of the course delegates will be able to describe what makes a High Performing Team and realistically assess their current strengths and weaknesses.</p><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);">Delegates will also be able to identify and plan behavioural changes that will improve the team&rsquo;s performance.</p><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);">The course is experiential based with lots of learning by doing activities, reflecting and discussion. &nbsp;This will allow team members to get to know/improve their knowledge of team colleagues and energise or re-energise teams.</p><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="500" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><br fr-original-style="" style="box-sizing: border-box;"></p></div></div></section></div><div data-section-id="1695042071630" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><img src="https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/8ba0826-4fb5-333c-0ea4-28c13064336b_Objectives_Icon.png" alt="" style="width: 80px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 80px;" fr-original-class="fr-draggable"></div></div><div data-section-id="1694266245578" style="color: rgb(89, 89, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Objectives&nbsp;</h3><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Know more about their colleagues</li><li fr-original-style="" style="box-sizing: border-box;">Be able to describe what makes a high performing team</li><li fr-original-style="" style="box-sizing: border-box;">Understand the importance of playing to different strengths and skills</li><li fr-original-style="" style="box-sizing: border-box;">Recognise the need for clear and effective communication</li></ul></div></div></section></div><div data-section-id="1694266514989" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></section></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><img src="https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/cbd24e-e374-8bf2-2a2e-66ae236e51d4_Content_Icon.png" alt="" style="width: 80px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 80px;" fr-original-class="fr-draggable"></p></section></div><div data-section-id="1695042071631" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-section-id="1695048787156" style="color: rgb(89, 89, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Content</h3><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">The Importance of Team Work</h5><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);">The importance of teamwork The &lsquo;third dimension&rsquo; &ndash; how working together has the potential to achieve more The dangers of an overly competitive workplace culture Psychological Safety</p><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Team Development Models</h5><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);">Stages of Team Development Behaviours at each stage Dysfunctional Teams &ndash; what does good and bad look like Characteristics of high performing and elite teams</p><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Teaming and Leadership Skills</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Teaming competencies</li><li fr-original-style="" style="box-sizing: border-box;">Active Listening</li><li fr-original-style="" style="box-sizing: border-box;">Proactive Language</li><li fr-original-style="" style="box-sizing: border-box;">Values and Beliefs</li><li fr-original-style="" style="box-sizing: border-box;">Building Mental Fitness of Teams</li><li fr-original-style="" style="box-sizing: border-box;">Becoming an inspirational leader</li><li fr-original-style="" style="box-sizing: border-box;">Establishing a climate of psychological safety&nbsp;</li></ul><div style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Team Challenges</h5></div><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">The importance of Accountability</li><li fr-original-style="" style="box-sizing: border-box;">The Team Charter</li><li fr-original-style="" style="box-sizing: border-box;">Smart Teams:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Building Trust</li><li fr-original-style="" style="box-sizing: border-box;">Building Collaboration</li><li fr-original-style="" style="box-sizing: border-box;">Overcoming Conflict</li><li fr-original-style="" style="box-sizing: border-box;">Gaining Commitment</li><li fr-original-style="" style="box-sizing: border-box;">Developing Shared Goals</li></ul></li><li fr-original-style="" style="box-sizing: border-box;">The importance of shared goals</li><li fr-original-style="" style="box-sizing: border-box;">Effective Team communication</li></ul></div></div></section></div><div data-section-id="1695048787157" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><br fr-original-style="" style="box-sizing: border-box;"></div></div></section></div>

Underscore Group

Building and Leading Effective Teams

Alpha Academy

Wellness And Fitness Training Level 3

<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;">Manage the day to day operations involved in supply chain.</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;"><strong style="color: rgb(16, 24, 64); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(16, 24, 64);"><span style="color: rgb(16, 24, 64); box-sizing: border-box;" fr-original-style=" color: rgb(16, 24, 64);">Transport And Warehouse Operations Supervisor Level 3</span></strong><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;">Course Duration / 12 Months Level 3</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">Apprenticeship Standard</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></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 Overview</strong></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;"><br fr-original-style="" style="box-sizing: border-box;"></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The broad purpose of the occupation is to manage the day to day operations involved in supply chain, ensuring activity, personnel and/or vehicles meet customer expectations along with regulatory and legal requirements. The standard allows you to specialise in one of two areas; the transport supervisor ensures the safe and compliant utilisation of all drivers and equipment whilst the warehouse supervisor ensures the provision of a professional incoming goods, storage and dispatch service to customers.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Duty 1 Deliver good customer service to internal and external customers as per agreed contracts and organisation&#39;s process.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Duty 2 Monitor and record staff performance and behaviour including recruitment, allocation and right to work entitlement.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Duty 3 Ensure that the transport operation centre or warehouse is working efficiently, using IT systems and promote productivity.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Duty 4 Brief and debrief team members on a daily basis to provide information, advice and guidance.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Duty 5 Plan the training needs of transport/ warehouse operatives to ensure regulatory compliance.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Duty 6 Follow internal and external audit procedures for transport and warehouse operations.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Duty 7 Monitor and report on the day to day operational performance of the supply chain.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Duty 8 Organise and plan the use of resources.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Duty 9 Ensure correct personal protective equipment is issued and maintained for the team.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Duty 10 Identify opportunities to improve organisations processes and practices.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Duty 21 Supervise receipt of goods, ensuring the correct goods are received, handled safely, ensuring any risks are identified.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Duty 22 Supervise stowing of goods into storage in order to optimise space, improve distribution and preserve condition inline with health and safety and reduce risks.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Duty 23 Supervise reverse logistics operations in line with environmental and company policy.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Duty 24 Supervise the replenishment, picking, packing and decanting of goods.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Duty 25 Oversee the dispatching of goods; identifying any problems with goods or special instructions.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Duty 26 Carry out stock control and stock checks to ensure that appropriate stock levels are maintained.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Duty 27 Ensure the workplace is clean and tidy, meet the required hygiene and fire safety standards.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Duty 28 Monitor and record checks of racking and mechanical handling equipment.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(16, 24, 64); box-sizing: border-box;" fr-original-style="color: rgb(16, 24, 64);"><strong style="color: rgb(16, 24, 64); font-weight: 700; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(16, 24, 64);"><span style="color: rgb(16, 24, 64); box-sizing: border-box;" fr-original-style=" color: rgb(16, 24, 64);">Transport And Warehouse Operations Supervisor Level 3</span></strong></span></strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Content</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></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;">Knowledge</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Recruitment and selection process and practice</li><li fr-original-style="" style="box-sizing: border-box;">Factors that affect workplace efficiency and how these can be managed</li><li fr-original-style="" style="box-sizing: border-box;">Organisational and individual KPIs and strategies for meeting these.</li><li fr-original-style="" style="box-sizing: border-box;">People management policies complaint with ACAS</li><li fr-original-style="" style="box-sizing: border-box;">Organisational procedures for delivering customer service, managing customer accounts</li><li fr-original-style="" style="box-sizing: border-box;">The application of Health and Safety regulations in transport and warehousing operations.</li><li fr-original-style="" style="box-sizing: border-box;">Road traffic incident procedures and offences both UK and International</li><li fr-original-style="" style="box-sizing: border-box;">Environmental impact of transport and warehousing operations</li><li fr-original-style="" style="box-sizing: border-box;">IT systems and tools used to manage transport and warehouse operations</li><li fr-original-style="" style="box-sizing: border-box;">Stock management processes and procedures</li><li fr-original-style="" style="box-sizing: border-box;">Stowing procedures to nominated warehouse locations</li><li fr-original-style="" style="box-sizing: border-box;">Picking schedules and dispatch times</li><li fr-original-style="" style="box-sizing: border-box;">Insurance requirements for fleet operators including level of cover, causes of invalidation</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></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;">Skills</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Identify skill and knowledge gaps in own performance and team performance</li><li fr-original-style="" style="box-sizing: border-box;">Plan training to meet the requirements of the business and the team members</li><li fr-original-style="" style="box-sizing: border-box;">Lead team and departmental communications and meetings</li><li fr-original-style="" style="box-sizing: border-box;">Ensure vehicle, driver and load documentation is available for the journey</li><li fr-original-style="" style="box-sizing: border-box;">Ensure the vehicle is safe and legally loaded and vehicle is marked and labelled compliantly</li><li fr-original-style="" style="box-sizing: border-box;">Use IT equipment and systems for the role such as telematics</li><li fr-original-style="" style="box-sizing: border-box;">Plan and review warehouse compliance and efficiencies</li><li fr-original-style="" style="box-sizing: border-box;">Lead and review the process for returned, damaged goods, customer bespoke and direct orders</li><li fr-original-style="" style="box-sizing: border-box;">Supervise loading to ensure correct procedures are used</li><li fr-original-style="" style="box-sizing: border-box;">Communicate with internal and external customers</li><li fr-original-style="" style="box-sizing: border-box;">Identify and propose innovative business improvements</li><li fr-original-style="" style="box-sizing: border-box;">Carry out risk assessments appropriate to work environment</li><li fr-original-style="" style="box-sizing: border-box;">Lead team and departmental communications and meetings</li><li fr-original-style="" style="box-sizing: border-box;">Carry out disciplinary and manage grievances as per organisational guidelines</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></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;">Behaviours</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Demonstrate the organisations values to promote and enhance brand reputation.</li><li fr-original-style="" style="box-sizing: border-box;">Demonstrate ownership and responsibility for their own safety and that of others</li><li fr-original-style="" style="box-sizing: border-box;">Take ownership for your own performance and training committing to self-improvement.</li><li fr-original-style="" style="box-sizing: border-box;">Positive attitude and approach to their work even when priorities and working patterns change</li><li fr-original-style="" style="box-sizing: border-box;">Use own initiative when needed to ensure that employer needs and expectations are met</li><li fr-original-style="" style="box-sizing: border-box;">Approachable and open to changeTreat equipment and technology responsibly and with respect</li></ul>

Rachel Hood

Supply Chain Management

Supply chain management (SCM)

Manage the day to day operations involved in supply chain.

Transport And Warehouse Operations Supervisor Level 3

<div data-section-id="1695385309833" style="color: rgb(89, 89, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" style="color: rgb(255, 255, 255); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Following on from the Macros course look at how you can write your own Visual Basic code within Excel to fully automate tasks and save time.</p></div></div></section></div><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><div data-section-id="1695042071629" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="500" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div data-aos="fade-up" data-aos-delay="500" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><img src="https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/77df68e-28e4-057f-41d6-ca1d3577146_Course_Overview_Icon.png" alt="" style="width: 80px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 80px;" fr-original-class="fr-draggable"></div></div><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Course overview</h3><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Duration:&nbsp;2 days (13 hours)</strong></p><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);">Our VBA in Excel course is an introduction to using the Visual Basic for Applications language for programming in Excel. It looks at structures, syntax and coding standards.</p><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);">This course is designed for existing experienced users of Excel who can record and run macros and those who have dabbled in VBA but would like some formal training and help to put some structure to their code.</p><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="500" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><br fr-original-style="" style="box-sizing: border-box;"></p></div></div></section></div><div data-section-id="1695042071630" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><img src="https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/8ba0826-4fb5-333c-0ea4-28c13064336b_Objectives_Icon.png" alt="" style="width: 80px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 80px;" fr-original-class="fr-draggable"><br fr-original-style="" style="box-sizing: border-box;"></div></div><div data-section-id="1694266245578" style="color: rgb(89, 89, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Objectives&nbsp;</h3><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);">By the end of the course you will be able to:</p><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Write visual basic procedures</li><li fr-original-style="" style="box-sizing: border-box;">Create event and general procedures</li><li fr-original-style="" style="box-sizing: border-box;">Use commands from the Excel data model</li><li fr-original-style="" style="box-sizing: border-box;">Use statements and functions</li><li fr-original-style="" style="box-sizing: border-box;">Use a selection of debugging tools</li><li fr-original-style="" style="box-sizing: border-box;">Create and use variables and constants</li><li fr-original-style="" style="box-sizing: border-box;">Use different types of loops</li><li fr-original-style="" style="box-sizing: border-box;">Create an Excel user form</li></ul></div></div></section></div><div data-section-id="1694266514989" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></section></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><img src="https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/cbd24e-e374-8bf2-2a2e-66ae236e51d4_Content_Icon.png" alt="" style="width: 80px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 80px;" fr-original-class="fr-draggable"></p></section></div><div data-section-id="1695042071631" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-section-id="1695048787156" style="color: rgb(89, 89, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Content</h3><div data-section-id="1695060919750" style="color: rgb(89, 89, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">The VBA environment &nbsp;</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Project explorer</li><li fr-original-style="" style="box-sizing: border-box;">Excel objects</li><li fr-original-style="" style="box-sizing: border-box;">Modules</li><li fr-original-style="" style="box-sizing: border-box;">Properties window</li><li fr-original-style="" style="box-sizing: border-box;">Code window</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Code structure</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Code structure</li><li fr-original-style="" style="box-sizing: border-box;">Navigating within your code</li><li fr-original-style="" style="box-sizing: border-box;">Adding comments</li><li fr-original-style="" style="box-sizing: border-box;">Using WITH</li><li fr-original-style="" style="box-sizing: border-box;">Steps to creating a VBA procedure</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Procedures&nbsp;</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Sub procedures</li><li fr-original-style="" style="box-sizing: border-box;">Event procedures</li><li fr-original-style="" style="box-sizing: border-box;">Calling procedures</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">The Excel data model&nbsp;</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Workbook commands</li><li fr-original-style="" style="box-sizing: border-box;">Worksheet commands</li><li fr-original-style="" style="box-sizing: border-box;">Excel selection methods</li><li fr-original-style="" style="box-sizing: border-box;">Data manipulation commands</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Debugging&nbsp;</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Using breakpoints</li><li fr-original-style="" style="box-sizing: border-box;">Stepping through code</li><li fr-original-style="" style="box-sizing: border-box;">The immediate window</li><li fr-original-style="" style="box-sizing: border-box;">The watch window</li><li fr-original-style="" style="box-sizing: border-box;">The locals window points</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Variables and Constants&nbsp;</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Declaring variables</li><li fr-original-style="" style="box-sizing: border-box;">Declaring multiple variables</li><li fr-original-style="" style="box-sizing: border-box;">Variable data types</li><li fr-original-style="" style="box-sizing: border-box;">Concatenation</li><li fr-original-style="" style="box-sizing: border-box;">Scope of variables</li><li fr-original-style="" style="box-sizing: border-box;">Constants</li><li fr-original-style="" style="box-sizing: border-box;">Declaring constants</li><li fr-original-style="" style="box-sizing: border-box;">Using constants</li><li fr-original-style="" style="box-sizing: border-box;">Scope of constants</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Looping&nbsp;</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Do while loops</li><li fr-original-style="" style="box-sizing: border-box;">Do until loops</li><li fr-original-style="" style="box-sizing: border-box;">For next loops</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Conditional Statements</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">IF statement</li><li fr-original-style="" style="box-sizing: border-box;">SELECT CASE statement</li><li fr-original-style="" style="box-sizing: border-box;">Comparison statements</li><li fr-original-style="" style="box-sizing: border-box;">Logical operators</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Creating a User Form</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Form layout</li><li fr-original-style="" style="box-sizing: border-box;">The control toolbox</li><li fr-original-style="" style="box-sizing: border-box;">Naming conventions</li><li fr-original-style="" style="box-sizing: border-box;">Adding objects</li><li fr-original-style="" style="box-sizing: border-box;">Naming objects</li><li fr-original-style="" style="box-sizing: border-box;">Captions</li><li fr-original-style="" style="box-sizing: border-box;">Displaying the form</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Object properties</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Object properties</li><li fr-original-style="" style="box-sizing: border-box;">Setting properties at design time</li><li fr-original-style="" style="box-sizing: border-box;">Setting properties at run time</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Interconnectivity between the user form and Excel</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Comparing values</li><li fr-original-style="" style="box-sizing: border-box;">Transferring information</li><li fr-original-style="" style="box-sizing: border-box;">Running code</li></ul></div></div></section></div></div></div></section></div><div data-section-id="1695048787157" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><br fr-original-style="" style="box-sizing: border-box;"></div></div></section></div>

VBA in Excel - Part 1

<div data-section-id="1695385309833" style="color: rgb(89, 89, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" style="color: rgb(255, 255, 255); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Learn how to create fully relational databases and how to input, extract and report on data.</p></div></div></section></div><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><div data-section-id="1695042071629" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="500" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div data-aos="fade-up" data-aos-delay="500" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><img src="https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/77df68e-28e4-057f-41d6-ca1d3577146_Course_Overview_Icon.png" alt="" style="width: 80px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 80px;" fr-original-class="fr-draggable"></div></div><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Course overview</h3><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Duration:&nbsp;2 days (13 hours)</strong></p><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);">Our Access Database Design and reporting course looks at the key elements to building fully relational databases and entering and extracting information from them.</p><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);">This course is designed for new users who need to build relational database systems.</p><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div></section></div><div data-section-id="1695042071630" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><img src="https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/8ba0826-4fb5-333c-0ea4-28c13064336b_Objectives_Icon.png" alt="" style="width: 80px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 80px;" fr-original-class="fr-draggable"><br fr-original-style="" style="box-sizing: border-box;"></div></div><div data-section-id="1694266245578" style="color: rgb(89, 89, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Objectives&nbsp;</h3><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);">By the end of the course you will be able to:</p><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Create a new database</li><li fr-original-style="" style="box-sizing: border-box;">Create data tables</li><li fr-original-style="" style="box-sizing: border-box;">Set field validation and properties</li><li fr-original-style="" style="box-sizing: border-box;">Enter data and manage data</li><li fr-original-style="" style="box-sizing: border-box;">Create forms</li><li fr-original-style="" style="box-sizing: border-box;">Use queries to extract data</li><li fr-original-style="" style="box-sizing: border-box;">Create parameter queries</li><li fr-original-style="" style="box-sizing: border-box;">Create calculations in queries</li><li fr-original-style="" style="box-sizing: border-box;">Build relational databases</li><li fr-original-style="" style="box-sizing: border-box;">Use sub datasheets</li><li fr-original-style="" style="box-sizing: border-box;">Build multi table queries</li><li fr-original-style="" style="box-sizing: border-box;">Use advanced form and report design techniques</li></ul></div></div></section></div><div data-section-id="1694266514989" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><img src="https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/cbd24e-e374-8bf2-2a2e-66ae236e51d4_Content_Icon.png" alt="" style="width: 80px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 80px;" fr-original-class="fr-draggable"></p></section></div><div data-section-id="1695042071631" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-section-id="1695048787156" style="color: rgb(89, 89, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Content</h3><div data-section-id="1695060919750" style="color: rgb(89, 89, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);">Creating a database<ul style="color: rgb(89, 89, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Creating a new database</li><li fr-original-style="" style="box-sizing: border-box;">Database elements</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Creating a data table</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Setting field properties</li><li fr-original-style="" style="box-sizing: border-box;">Using input masks</li><li fr-original-style="" style="box-sizing: border-box;">Using input masks</li><li fr-original-style="" style="box-sizing: border-box;">Validation rules</li><li fr-original-style="" style="box-sizing: border-box;">Default values</li><li fr-original-style="" style="box-sizing: border-box;">Setting a primary key</li><li fr-original-style="" style="box-sizing: border-box;">Creating lookup fields</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Data entry&nbsp;</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Adding data</li><li fr-original-style="" style="box-sizing: border-box;">Deleting data</li><li fr-original-style="" style="box-sizing: border-box;">Quick keys for data entry</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Working with data</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Sorting data</li><li fr-original-style="" style="box-sizing: border-box;">Filtering data</li><li fr-original-style="" style="box-sizing: border-box;">Finding information</li><li fr-original-style="" style="box-sizing: border-box;">Navigation</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Creating data form</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Creating quick forms</li><li fr-original-style="" style="box-sizing: border-box;">The form wizard</li><li fr-original-style="" style="box-sizing: border-box;">Amending forms</li><li fr-original-style="" style="box-sizing: border-box;">Formatting</li><li fr-original-style="" style="box-sizing: border-box;">Setting the tab order</li><li fr-original-style="" style="box-sizing: border-box;">Entering data using forms</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Creating queries</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Creating a query</li><li fr-original-style="" style="box-sizing: border-box;">Setting criteria</li><li fr-original-style="" style="box-sizing: border-box;">Using the expression builder</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Creating parameter queries</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Using wildcards</li><li fr-original-style="" style="box-sizing: border-box;">Using more than one parameter</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Using calculations in queries</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Adding a totals row</li><li fr-original-style="" style="box-sizing: border-box;">Formatting results</li><li fr-original-style="" style="box-sizing: border-box;">Adding calculations</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Printing and reporting</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Printing tables and queries</li><li fr-original-style="" style="box-sizing: border-box;">Creating reports</li><li fr-original-style="" style="box-sizing: border-box;">Building and amending reports</li><li fr-original-style="" style="box-sizing: border-box;">Adding headers and footers</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Working with relational databases</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Relational database principles</li><li fr-original-style="" style="box-sizing: border-box;">Importing data from other sources</li><li fr-original-style="" style="box-sizing: border-box;">Linking information between tables</li><li fr-original-style="" style="box-sizing: border-box;">One-to-one and one-to-many links</li><li fr-original-style="" style="box-sizing: border-box;">Defining referential integrity</li><li fr-original-style="" style="box-sizing: border-box;">Amending links</li><li fr-original-style="" style="box-sizing: border-box;">Deleting links</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Sub datasheets</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Viewing a subdatasheet</li><li fr-original-style="" style="box-sizing: border-box;">Removing a subdatasheet</li><li fr-original-style="" style="box-sizing: border-box;">Connecting a subdatasheet</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Multiple table queries</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Deciding which tables to use</li><li fr-original-style="" style="box-sizing: border-box;">Adding tables to the query</li><li fr-original-style="" style="box-sizing: border-box;">Creating links between tables</li><li fr-original-style="" style="box-sizing: border-box;">Setting join properties</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Advanced form design</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Field properties</li><li fr-original-style="" style="box-sizing: border-box;">Creating lookup fields</li><li fr-original-style="" style="box-sizing: border-box;">Adding calculated fields</li><li fr-original-style="" style="box-sizing: border-box;">Applying conditional formatting</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Advanced report design</h5><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Field properties</li><li fr-original-style="" style="box-sizing: border-box;">Report properties</li><li fr-original-style="" style="box-sizing: border-box;">Alternate colour bandings</li><li fr-original-style="" style="box-sizing: border-box;">Concatenating fields</li><li fr-original-style="" style="box-sizing: border-box;">Adding calculated fields</li><li fr-original-style="" style="box-sizing: border-box;">Sorting and grouping</li><li fr-original-style="" style="box-sizing: border-box;">Grouping settings</li><li fr-original-style="" style="box-sizing: border-box;">Adding headers and footers</li><li fr-original-style="" style="box-sizing: border-box;">Adding dates, times, page numbers</li></ul></div></div></div></section></div><div data-section-id="1695048787157" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><br fr-original-style="" style="box-sizing: border-box;"></div></div></section></div>

Access - Database Design and Reporting

Birmingham

Erdington

Queensway

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This Tableau Desktop Training course is a jumpstart to getting report writers and analysts with little or no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in two days of your time.</p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For Private options, online or in-person, please send us details of your requirements:</p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This Tableau Desktop Training course is a jumpstart to getting report writers and analysts with little or no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in two days of your time. Having a quick turnaround from starting to use Tableau, to getting real, actionable insights means that you get a swift return on your investment of time and money.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This accelerated approach is key to getting engagement from within your organisation so everyone can immediately see and feel the impact of the data and insights you create. This course is aimed at someone who has not used Tableau in earnest and may be in a functional role, eg. in sales, marketing, finance, operations, business intelligence etc.</p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><section data-particle_enable="false" data-particle-mobile-disabled="false" data-id="28546e3a" data-element_type="section" style="color: rgb(98, 98, 98); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(98, 98, 98);"><div data-id="530ff072" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><section data-particle_enable="false" data-particle-mobile-disabled="false" data-id="7ae5fe7" data-element_type="section" data-settings='{"background_background":"classic"}' fr-original-style="" style="box-sizing: border-box;"><div data-id="461193e7" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="8fd671b" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 style="color: rgb(7, 41, 77); box-sizing: border-box;" fr-original-style=" color: rgb(7, 41, 77);">The course is split into 3 phases and 9 modules:</h2></div><div data-id="58a6c8fc" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 style="color: rgb(7, 41, 77); box-sizing: border-box;" fr-original-style=" color: rgb(7, 41, 77);">PHASE 1: GET READY</h2></div><div data-id="5f8c8664" data-element_type="widget" data-widget_type="accordion.default" fr-original-style="" style="box-sizing: border-box;"><h5 data-tab="1" tabindex="0" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">MODULE 1: LAUNCH TABLEAU</h5><div data-tab="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Check Install &amp; Setup</li><li fr-original-style="" style="box-sizing: border-box;">Why is Visual Analytics Important</li></ul></div><h5 data-tab="2" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">MODULE 2: GET FAMILIAR</h5><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">What is possible</li><li fr-original-style="" style="box-sizing: border-box;">How does Tableau deal with data</li><li fr-original-style="" style="box-sizing: border-box;">Know your way around</li><li fr-original-style="" style="box-sizing: border-box;">How do we format charts</li><li fr-original-style="" style="box-sizing: border-box;">Dashboard Basics &ndash; My First Dashboard</li></ul><h5 data-tab="3" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">MODULE 3: DATA DISCOVERY</h5><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Connecting to and setting up data in Tableau</li><li fr-original-style="" style="box-sizing: border-box;">How Do I Explore my Data &ndash; Filters &amp; Sorting</li><li fr-original-style="" style="box-sizing: border-box;">How Do I Structure my Data &ndash; Groups &amp; Hierarchies, Visual Groups</li><li fr-original-style="" style="box-sizing: border-box;">How Tableau Deals with Dates &ndash; Using Discrete and Continuous Dates, Custom Dates</li></ul></div></div></section><section data-particle_enable="false" data-particle-mobile-disabled="false" data-id="2696f5d3" data-element_type="section" data-settings='{"background_background":"classic"}' fr-original-style="" style="box-sizing: border-box;"><div data-id="ec4f006" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="4520c476" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 style="color: rgb(7, 41, 77); box-sizing: border-box;" fr-original-style=" color: rgb(7, 41, 77);"><br fr-original-style="" style="box-sizing: border-box;"></h2><h2 style="color: rgb(7, 41, 77); box-sizing: border-box;" fr-original-style=" color: rgb(7, 41, 77);">Phase 2: GET SET</h2></div><div data-id="16ebe443" data-element_type="widget" data-widget_type="accordion.default" fr-original-style="" style="box-sizing: border-box;"><h5 data-tab="1" tabindex="0" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">MODULE 4: MAKE CALCULATIONS</h5><div data-tab="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">How Do I Create Calculated Fields &amp; Why</li></ul></div><h5 data-tab="2" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">MODULE 5: MAKE CHARTS</h5><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Charts that Compare Multiple Measures &ndash; Measure Names and Measure Values, Shared Axis Charts, Dual Axis Charts, Scatter Plots</li><li fr-original-style="" style="box-sizing: border-box;">Showing Relational &amp; Proportional Data &ndash; Pie Charts, Donut Charts, Tree Maps</li></ul><h5 data-tab="3" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">MODULE 6: MAKE TABLES</h5><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Creating Tables &ndash; Creating Tables, Highlight Tables, Heat Maps</li></ul></div></div></section><section data-particle_enable="false" data-particle-mobile-disabled="false" data-id="5e5df3ea" data-element_type="section" data-settings='{"background_background":"classic"}' fr-original-style="" style="box-sizing: border-box;"><div data-id="491b064f" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="357bfc09" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 style="color: rgb(7, 41, 77); box-sizing: border-box;" fr-original-style=" color: rgb(7, 41, 77);">Phase 3: GO</h2></div><div data-id="4dd84eb2" data-element_type="widget" data-widget_type="accordion.default" fr-original-style="" style="box-sizing: border-box;"><h5 data-tab="1" tabindex="0" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">MODULE 7: ADD CONTEXT</h5><div data-tab="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><ul fr-original-style="" style="box-sizing: border-box;"><li 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;">Reference Lines and Bands</p></li></ul></div><h5 data-tab="2" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">MODULE 8: MAKE MAPS</h5><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;">Answering Spatial Questions &ndash; Mapping, Creating a Choropleth (Filled) Map</div></li></ul><h5 data-tab="3" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">MODULE 9: MAKE DASHBOARDS</h5><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Using the Dashboard Interface</li><li fr-original-style="" style="box-sizing: border-box;">Dashboard Actions</li></ul></div></div></section></div></section><section data-particle_enable="false" data-particle-mobile-disabled="false" data-id="5b9fdc59" data-element_type="section" data-settings='{"background_background":"classic"}' style="color: rgb(98, 98, 98); box-sizing: border-box;" fr-original-style=" color: rgb(98, 98, 98);"><div data-id="649bcdb4" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="315826bb" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(255, 255, 255); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This training course includes over&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">25</strong>&nbsp;hands-on exercises and quizzes to help participants&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&ldquo;learn by doing&rdquo;</strong>&nbsp;and to assist group discussions around real-life use cases. Each attendee receives a login to our extensive training portal which covers the theory, practical applications and use cases, exercises, solutions and quizzes in both written and video format.</p></div><div data-id="6243dea8" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(255, 255, 255); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Students must use their own laptop with an active version of Tableau Desktop 2018.2 (or later) pre-installed.</p></div></div></section><section data-particle_enable="false" data-particle-mobile-disabled="false" data-id="649f95d" data-element_type="section" data-settings='{"background_background":"classic"}' fr-original-style="" style="box-sizing: border-box;"><div data-id="1c207d92" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="1bce9646" data-element_type="widget" data-widget_type="heading.default" style="color: rgb(98, 98, 98); box-sizing: border-box;" fr-original-style="color: rgb(98, 98, 98);"><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><h2 style="color: rgb(17, 41, 74); box-sizing: border-box;" fr-original-style=" color: rgb(17, 41, 74);">What People Are Saying About This Course</h2></div><div data-id="780525c2" data-element_type="widget" data-settings='{"slides_per_view":"2","slides_to_scroll":"1","space_between":{"unit":"px","size":0,"sizes":[]},"slides_per_view_tablet":"2","speed":500,"space_between_tablet":{"unit":"px","size":10,"sizes":[]},"space_between_mobile":{"unit":"px","size":10,"sizes":[]}}' data-widget_type="testimonial-carousel.default" style="color: rgb(98, 98, 98); box-sizing: border-box;" fr-original-style="color: rgb(98, 98, 98);"><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><img src="https://cdn.vizdj.com/wp-content/uploads/2021/11/quote-icon.png" alt="Richard L., Intelliflo" fr-original-style="" style="cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-class="fr-draggable"></div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">&ldquo;Excellent Trainer &ndash; knows his stuff, has done it all in the real world, not just the class room.&rdquo;</div><cite fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(7, 41, 77); box-sizing: border-box;" fr-original-style=" color: rgb(7, 41, 77);">Richard L., Intelliflo</span></cite></div><div data-id="780525c2" data-element_type="widget" data-settings='{"slides_per_view":"2","slides_to_scroll":"1","space_between":{"unit":"px","size":0,"sizes":[]},"slides_per_view_tablet":"2","speed":500,"space_between_tablet":{"unit":"px","size":10,"sizes":[]},"space_between_mobile":{"unit":"px","size":10,"sizes":[]}}' data-widget_type="testimonial-carousel.default" fr-original-style="" style="box-sizing: border-box;"><font color="#07294d" fr-original-style="" style="box-sizing: border-box;"><i fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></i></font><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><img src="https://cdn.vizdj.com/wp-content/uploads/2021/11/quote-icon.png" alt="Chelsey H., QVC" style="color: rgb(98, 98, 98); cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(98, 98, 98);" fr-original-class="fr-draggable"></div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">&ldquo;Tableau is a complicated and powerful tool. After taking this course, I am confident in what I can do, and how it can help improve my work.&rdquo;</div><cite style="color: rgb(98, 98, 98); box-sizing: border-box;" fr-original-style="color: rgb(98, 98, 98);"><span style="color: rgb(7, 41, 77); box-sizing: border-box;" fr-original-style=" color: rgb(7, 41, 77);">Trevor B., Morrison Utility Services</span></cite></div><div data-id="780525c2" data-element_type="widget" data-settings='{"slides_per_view":"2","slides_to_scroll":"1","space_between":{"unit":"px","size":0,"sizes":[]},"slides_per_view_tablet":"2","speed":500,"space_between_tablet":{"unit":"px","size":10,"sizes":[]},"space_between_mobile":{"unit":"px","size":10,"sizes":[]}}' data-widget_type="testimonial-carousel.default" fr-original-style="" style="box-sizing: border-box;"><font color="#626262" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></font></div><div data-id="780525c2" data-element_type="widget" data-settings='{"slides_per_view":"2","slides_to_scroll":"1","space_between":{"unit":"px","size":0,"sizes":[]},"slides_per_view_tablet":"2","speed":500,"space_between_tablet":{"unit":"px","size":10,"sizes":[]},"space_between_mobile":{"unit":"px","size":10,"sizes":[]}}' data-widget_type="testimonial-carousel.default" fr-original-style="" style="box-sizing: border-box;"><font color="#626262" fr-original-style="" style="box-sizing: border-box;"><img src="https://cdn.vizdj.com/wp-content/uploads/2021/11/quote-icon.png" alt="Trevor B., Morrison Utility Services" fr-original-style="" style="cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-class="fr-draggable"></font></div><div data-id="2de0482d" data-element_type="widget" data-settings='{"slides_per_view":"2","space_between":{"unit":"px","size":0,"sizes":[]},"slides_per_view_tablet":"2","speed":500,"space_between_tablet":{"unit":"px","size":10,"sizes":[]},"space_between_mobile":{"unit":"px","size":10,"sizes":[]}}' data-widget_type="testimonial-carousel.default" style="color: rgb(98, 98, 98); box-sizing: border-box;" fr-original-style="color: rgb(98, 98, 98);"><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">&ldquo;I would highly recommend this course for Tableau beginners, really easy to follow and keep up with as you are hands on during the course. Trainer really helpful too.&rdquo;</div><cite fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(7, 41, 77); box-sizing: border-box;" fr-original-style=" color: rgb(7, 41, 77);">Chelsey H., QVC</span></cite></div><div data-id="2de0482d" data-element_type="widget" data-settings='{"slides_per_view":"2","space_between":{"unit":"px","size":0,"sizes":[]},"slides_per_view_tablet":"2","speed":500,"space_between_tablet":{"unit":"px","size":10,"sizes":[]},"space_between_mobile":{"unit":"px","size":10,"sizes":[]}}' data-widget_type="testimonial-carousel.default" style="color: rgb(98, 98, 98); box-sizing: border-box;" fr-original-style="color: rgb(98, 98, 98);"><br fr-original-style="" style="box-sizing: border-box;"></div><div data-id="2de0482d" data-element_type="widget" data-settings='{"slides_per_view":"2","space_between":{"unit":"px","size":0,"sizes":[]},"slides_per_view_tablet":"2","speed":500,"space_between_tablet":{"unit":"px","size":10,"sizes":[]},"space_between_mobile":{"unit":"px","size":10,"sizes":[]}}' data-widget_type="testimonial-carousel.default" style="color: rgb(98, 98, 98); box-sizing: border-box;" fr-original-style="color: rgb(98, 98, 98);"><img src="https://cdn.vizdj.com/wp-content/uploads/2021/11/quote-icon.png" alt="Chelsey H., QVC" fr-original-style="" style="cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-class="fr-draggable"><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">&ldquo;He is a natural trainer, patient and very good at explaining in simple terms. He has an excellent knowledge base of the system and an obvious enthusiasm for Tableau, data analysis and the best way to convey results. We had been having difficulties in the business in building financial reports from a data cube and he had solutions for these which have proved to be very useful.&rdquo;</div><cite fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(7, 41, 77); box-sizing: border-box;" fr-original-style=" color: rgb(7, 41, 77);">Matthew H., ISS Group</span></cite></div></div></section>

Tableau Training Uk

Tableau Desktop Training - Foundation

Power BI Introduction

<p>Embark on a journey of understanding and preparing for British citizenship with the comprehensive '<strong>British Citizenship Training</strong>' course. This educational experience begins with an in-depth exploration of what British citizenship entails, providing learners with a clear understanding of its significance and implications. As you move through the modules, the course unveils the various types of British citizenship, enriching your comprehension of the diverse pathways to becoming a British citizen. The curriculum then delves into the intricacies of nationality, immigration, and legislation, ensuring a robust grasp of the legal framework governing citizenship in the UK. This foundation is crucial for anyone aspiring to navigate the complex landscape of British immigration and citizenship.</p>
<p>Further, the course provides detailed insights into the processes of entering and staying in the UK, both temporarily and permanently. It demystifies the often-complex citizenship application tests, offering guidance and preparation tips. As the course progresses, it addresses the nuances of dual nationality and citizenship, and critically examines the impact of Brexit on both EEA and non-EEA citizens. With modules focusing on living rights in the UK, seeking employment pre and post-application, and obtaining visas, this course is an invaluable resource for anyone looking to understand and successfully navigate the journey to British citizenship. Concluding with an exploration of British life and culture, the course not only prepares you for the practical aspects of citizenship but also integrates you into the rich tapestry of British society.</p>
<p><strong>Learning Outcomes</strong></p>
<ul>
<li>Understand the fundamental concepts and types of British citizenship.</li>
<li>Gain knowledge of UK nationality laws, immigration policies, and legislation.</li>
<li>Learn about the processes for entering and residing in the UK, including visa acquisition.</li>
<li>Prepare effectively for citizenship application tests and understand dual nationality concepts.</li>
<li>Acquire insights into British life, culture, and employment landscape for prospective citizens.</li>
</ul>
<h3><b>Why choose this British Citizenship Training?</b></h3>
<ol>
<li>Unlimited access to the course for a lifetime.</li>
<li>Opportunity to earn a certificate accredited by the <b>CPD Quality Standards</b> and <b>CIQ </b>after completing this course.</li>
<li>Structured lesson planning in line with industry standards.</li>
<li>Immerse yourself in innovative and captivating course materials and activities.</li>
<li>Assessments designed to evaluate advanced cognitive abilities and skill proficiency.</li>
<li>Flexibility to complete the Course at your own pace, on your own schedule.</li>
<li>Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience.</li>
<li>Unlock career resources for CV improvement, interview readiness, and job success.</li>
</ol>
<h3><b>Who is this British Citizenship Training</b><b><span> </span></b><b>for?</b></h3>
<ul>
<li>Individuals aiming to apply for British citizenship or dual nationality.</li>
<li>Expatriates and immigrants seeking comprehensive knowledge of UK immigration laws.</li>
<li>Professionals involved in immigration consultancy and legal advisory roles.</li>
<li>Students and researchers interested in understanding the implications of Brexit on citizenship.</li>
<li>Anyone aspiring to integrate into British society, culture, and the employment sector.</li>
</ul>
<h3><b>Career path</b></h3>
<ul>
<li><strong>Immigration Consultant</strong>: £25,000 - £40,000</li>
<li><strong>Legal Advisor (Immigration and Nationality Law)</strong>: £30,000 - £55,000</li>
<li><strong>Citizenship Application Specialist</strong>: £22,000 - £35,000</li>
<li><strong>Cultural Integration Coordinator</strong>: £20,000 - £32,000</li>
<li><strong>Research Analyst (Immigration and Citizenship)</strong>: £24,000 - £38,000</li>
<li><strong>Employment Advisor for New Citizens</strong>: £23,000 - £37,000</li>
</ul>
<h3><b>Prerequisites</b></h3>
<p><span>This </span><b>British Citizenship Training</b><span> does not require you to have any prior qualifications or experience. You can just enrol and start learning.This </span><b>British Citizenship Training</b><span> was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.</span></p>
<h3><b>Certification</b></h3>
<p><span>After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8.</span></p><div>
				<h3>
	<span>Course Curriculum</span>
</h3>

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4"> Module 01: What Is British Citizenship?</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What Is British Citizenship?</td>
					<td> </td>
					<td><span><i></i> 00:21:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 02: Different Types of British Citizenship</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Different Types of British Citizenship</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 03: Nationality, Immigration and Legislation</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Nationality, Immigration and Legislation</td>
					<td> </td>
					<td><span><i></i> 00:37:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 04: Enter and Stay in the UK Both Temporarily and Permanently</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Enter and Stay in the UK Both Temporarily and Permanently</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 05: Citizenship Application Tests</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Citizenship Application Tests</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 06: Dual Nationality and Citizenship</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Dual Nationality and Citizenship</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 07: Brexit and Its Implications for EEA and Non-EEA Citizens</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Brexit and Its Implications for EEA and Non-EEA Citizens</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 08: Living Rights in the UK</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Living Rights in the UK</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 09: Seeking Employment in the UK (Before and After the Application)</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Seeking Employment in the UK (Before and After the Application)</td>
					<td> </td>
					<td><span><i></i> 00:21:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 10: Obtaining Visas for the UK</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Obtaining Visas for the UK</td>
					<td> </td>
					<td><span><i></i> 00:24:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 11: British Life and Culture</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>British Life and Culture</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Assignment</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Assignment - British Citizenship Training</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table></div>

			</div>

Studyhub UK

Certificate in Further Education & Training (Cert Ed)

Bar Professional Training Course (BPTC)

Certificate in Education & Training (CET)

Engineering Construction Industry Training (ECITB)

British Values

Trainers Course

British Citizenship Training

Visual Analytics Best Practice

Bournemouth

London Waterloo Academy

Flight Attendant

Stewardess

FLIGHT ATTENDANT VIRTUAL VIA ZOOM COURSE, EVENINGS

Registration Fee

Course Fee

Tom Reynolds

Product Management

Agile

Agile PM

Productivity

Kanban

Agile Coach

Attend our world class Kanban University accredited Certified Kanban System Design training course and learn to implement Kanban in your company

Certified Kanban System Design – KMP I - 24-26 September

Standard

Early Bird

<h4 style="color: rgb(12, 46, 63); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(12, 46, 63);">Hello and thank you for joining us.</h4><h4 style="color: rgb(12, 46, 63); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(12, 46, 63);">In this WebWorkshop, you will learn:</h4><ul style="color: rgb(12, 46, 63); box-sizing: border-box;" fr-original-style=" color: rgb(12, 46, 63);"><li 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;">How to get everyone home safe every day.</p></li><li 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;">How to shift from &lsquo;doing&rsquo; safety to &lsquo;being&rsquo; safe.</p></li><li 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;">How to accommodate humans for being human.&nbsp;</p></li><li 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;">How the definition of safety must move beyond the physical to include psychological, emotional and spiritual.</p></li></ul><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">We run these WebWorkshops in a way which makes the information stick. You will not get an hour of PowerPoint slides, and instead will be taken on a journey through what Compassionate Safety is and what it can achieve.</span></div>

Hello and thank you for joining us.In this WebWorkshop, you will learn:
How to get everyone home safe every day.
How to shift from ‘doing’ safety to ‘being’ safe.
How to accommodate humans for being human.
How the definition of safety must move beyond the physical to include psychological, emotional and spiritual.
We run these WebWorkshops in a way which makes the information stick. You will not get an hour of PowerPoint slides, and instead will be taken on a journey through what Compassionate Safety is and what it can achieve.

Ppwd Consulting

PPWD’s Compassionate Safety approach generates environments that accommodate humans for being human. Our approach aligns personal and organisational mindsets, beliefs and values. In doing so, workplaces are created where people thrive and flourish.

PPWD Compassionate Safety WebWorkshop

<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>

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

<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>

Nexus Human

Powerbi

Business Analytics & Intelligence

Microsoft Power BI

Microsoft Power Platform

Microsoft BI

Data Analyst

PL-300T00 Microsoft Power BI Data Analyst

<h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">LEARN TO FOCUS ON INTERPERSONAL SKILLS, BEHAVIOR, AND ENVIRONMENT AND HOW TO PROMOTE DIVERSITY-POSITIVE INTERACTIONS.</h3><div style="color: rgb(33, 37, 41); box-sizing: border-box;" fr-original-style=" color: rgb(33, 37, 41);"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">You will be able to focus on interpersonal skills, behavior, and environment, to see how they promote diversity-positive interactions, as well as learn causes for discriminatory practices and create an action plan for increasing workplace acceptance and harmony.</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);"><b fr-original-style="" style="box-sizing: border-box;">Uncover and discard beliefs and attitudes that foster or block progress</b>. By discovering your strengths as well as liabilities, you can build on the positive and move toward minimizing the negative. As a result, you will gain greater personal and professional satisfaction.</p><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">PART I &ndash; BROADENING THE VIEW</h3>&nbsp;<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Find new perspectives and ways to turn challenges into opportunities. Become skilled at ways to further develop self-awareness and sensitivity.</p><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">PART II &ndash; FAIR STANDARDS</h3>&nbsp;<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Learn about how attitudes expressed in speech and behavior promote or hinder a positive work environment. Determine and apply steps for getting past prejudice for greater productivity.</p><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">PART III &ndash; ORGANIZATIONAL UNITY</h3>&nbsp;<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Discover value in diverse perspectives and personalities and their benefits. Strategize ways to strengthen relationships and turn negative into positive interactions.</p><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">ATTENDEES&nbsp;WILL BE ABLE TO:</strong></h3>&nbsp;<ul fr-original-style="" style="box-sizing: border-box;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Discover new ways to &ldquo;see things differently;&rdquo;</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Use Emotional Intelligence to strengthen relationships and increase awareness of self and others;</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Define Diversity and uncover ways in which it is significantly useful in an organization;</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Develop best practices (rooted in honor and law) to use Diversity in planning, problem solving, and decision-making);</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Manage conflict through unity, using the organization&rsquo;s mission, vision, values, and goals; and</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Understand and communicate value to staff.</li></ul><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><i style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Online Class&mdash;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Diversity &ndash; Building a Thriving Business Environment</strong>&nbsp;is a 4-hour interactive virtual class.&nbsp;</i></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);">&nbsp;</p><h6 style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">Register for this class and you will be sent ONLINE login instructions prior to the class date.</h6></div><div style="color: rgb(33, 37, 41); box-sizing: border-box;" fr-original-style=" color: rgb(33, 37, 41);"><br fr-original-style="" style="box-sizing: border-box;"></div><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><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);">Improving Communications brought our organization to realize how important our employees&mdash;our people&mdash;are to Baystate Dental. By helping us to develop a more thoughtful and sensitive nature, we now relate better with each other and our patients.</p><span style="color: rgb(33, 37, 41); box-sizing: border-box;" fr-original-style="color: rgb(33, 37, 41);">Dr. Kevin Coughlin, DMD, FAGD, MBA</span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Baystate Dental</span>

LEARN TO FOCUS ON INTERPERSONAL SKILLS, BEHAVIOR, AND ENVIRONMENT AND HOW TO PROMOTE DIVERSITY-POSITIVE INTERACTIONS.
You will be able to focus on interpersonal skills, behavior, and environment, to see how they promote diversity-positive interactions, as well as learn causes for discriminatory practices and create an action plan for increasing workplace acceptance and harmony.
Uncover and discard beliefs and attitudes that foster or block progress. By discovering your strengths as well as liabilities, you can build on the positive and move toward minimizing the negative. As a result, you will gain greater personal and professional satisfaction.
PART I – BROADENING THE VIEW
Find new perspectives and ways to turn challenges into opportunities. Become skilled at ways to further develop self-awareness and sensitivity.
PART II – FAIR STANDARDS
Learn about how attitudes expressed in speech and behavior promote or hinder a positive work environment. Determine and apply steps for getting past prejudice for greater productivity.
PART III – ORGANIZATIONAL UNITY
Discover value in diverse perspectives and personalities and their benefits. Strategize ways to strengthen relationships and turn negative into positive interactions.
ATTENDEES WILL BE ABLE TO:
Discover new ways to “see things differently;”
Use Emotional Intelligence to strengthen relationships and increase awareness of self and others;
Define Diversity and uncover ways in which it is significantly useful in an organization;
Develop best practices (rooted in honor and law) to use Diversity in planning, problem solving, and decision-making);
Manage conflict through unity, using the organization’s mission, vision, values, and goals; and
Understand and communicate value to staff.
Online Class—Diversity – Building a Thriving Business Environment is a 4-hour interactive virtual class. 
 
Register for this class and you will be sent ONLINE login instructions prior to the class date.



Improving Communications brought our organization to realize how important our employees—our people—are to Baystate Dental. By helping us to develop a more thoughtful and sensitive nature, we now relate better with each other and our patients.
Dr. Kevin Coughlin, DMD, FAGD, MBABaystate Dental

Improving Communications Uk

DIVERSITY – BUILDING A THRIVING BUSINESS ENVIRONMENT

Loughborough

<div>
		

		<div>
			
			<p>Recruiting great people to our organisations is the key to high performance and sustainable business success.</p>
			<div><i></i> 2 x 4 hour sessions</div>
			<div><i></i>  £358.80 incl. VAT</div>
			
			
		</div>
	</div>

	

	<div id="filters">
		
		
	</div>

	

    <div>

		
		 
		

		<div></div>

		<div>
			<p>Want to run this event in-house?  Enquire about running this event in-house </p>
			
		</div>

		<div>
			<p>Interested in attending? Have a suggestion about running this event near you?<br />Register your interest now</p>
			
		</div>
	</div>
	<div></div>
	
		
        <div>
			
		</div>
				

	
		<h3>Description</h3>
		<p></p><p>Recruiting great people who not only meet our organisation's needs but also uphold our core values and beliefs has become increasingly important as we navigate the volatility of the post-pandemic employment market. As costs continue to rise, and we experience challenging times in retaining great people, the pressure is on to ensure we recruit those people who offer best fit with our organisations. This training and development course is aimed at early career leaders and managers responsible for recruitment and selection for their departments and teams. It is designed to stimulate and challenge our thinking about how to recruit great people who will, not only meet the needs of the job role, but fit with, and make a valuable contribution to, the wider organisation.</p>
<p></p>
	
		<h3>Target Student</h3>
		<p></p><p>This session is suitable for early careers leaders and managers who have, or will have, responsibility for recruitment and selection in their teams/departments.</p>
<p></p>
	
		<h3>Modules/Lessons</h3>
		<p></p><p>By the end of this course, participants will understand:</p>
<ul>
<li>the importance of designing effective, authentic recruitment and selection processes</li>
<li>how to ensure these processes reflect organisational values</li>
<li>how to design selection processes that better assess values fit with the organisation</li>
<li>how to make recruitment and selection both meaningful and inclusive</li>
<li>how to attract, and get the very best from, the strongest applicants</li>
</ul>
<p></p>

Mpi Learning - Professional Learning And Development Provider

Recruiting great people to our organisations is the key to high performance and sustainable business success.

Values Based Recruitment

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>This course is intended for IT Professionals who are already experienced in general Windows Server, Windows client, Azure, and Microsoft 365 administration, and who want to learn more about using Windows PowerShell for administration. No prior experience with any version of PowerShell or any scripting language is assumed. This course is also suitable for IT Professionals already experienced in server administration, including Microsoft Exchange Server, Microsoft SharePoint Server, and Microsoft SQL Server.</p><p></p><p></p><p>This course provides students with the fundamental knowledge and skills to use PowerShell for administering and automating administration of Windows servers. This course provides students the skills to identify and build the command they require to perform a specific task. In addition, students learn how to build scripts to accomplish advanced tasks such as automating repetitive tasks and generating reports. This course provides prerequisite skills supporting a broad range of Microsoft products, including Windows Server, Windows Client, Microsoft Azure, and Microsoft 365. In keeping with that goal, this course will not focus on any one of those products, although Windows Server, which is the common platform for all of those products, will serve as the example for the techniques this course teaches.</p><p></p>Prerequisites<p>Before attending this course, students must have: </p><ul><li>-Experience with Windows networking technologies and implementation.</li> <li>- Experience with Windows Server administration, maintenance, and troubleshooting.</li></ul><p></p></div><div id="course-pills-2"><h3>1 - Review Windows PowerShell</h3> <ul> <li>Learn about Windows PowerShell</li> <li>Get familiar with Windows PowerShell applications</li> <li>Identify factors to install and use Windows PowerShell</li> <li>Configure the Windows PowerShell console</li> <li>Configure the Windows PowerShell Integrated Scripting Environment (ISE)</li> <li>Use Visual Studio Code with PowerShell</li> </ul> <h3>2 - Understand the command syntax in Windows PowerShell</h3> <ul> <li>Discover the structure of PowerShell cmdlets</li> <li>Discover the parameters for using PowerShell cmdlets</li> <li>Review the tab completion feature in PowerShell</li> <li>Display the About files content in PowerShell</li> </ul> <h3>3 - Find commands and Get-Help in Windows PowerShell</h3> <ul> <li>Define modules in PowerShell</li> <li>Find cmdlets in PowerShell</li> <li>Use command aliases in PowerShell</li> <li>Use Show-Command and Get-Help in PowerShell</li> <li>Interpret the help file contents and update the local help content in PowerShell</li> </ul> <h3>4 - Manage Active Directory Domain Services using PowerShell cmdlets</h3> <ul> <li>Manage user accounts in PowerShell</li> <li>Manage groups and group memberships in PowerShell</li> <li>Manage computer accounts in PowerShell</li> <li>Manage organizational units and Active Directory objects in PowerShell</li> </ul> <h3>5 - Manage network service settings for Windows devices using PowerShell cmdlets</h3> <ul> <li>Manage IP addresses in PowerShell</li> <li>Manage IP routing in PowerShell</li> <li>Manage DNS clients in PowerShell</li> <li>Manage Windows Firewall settings in PowerShell</li> </ul> <h3>6 - Manage Windows Server settings using PowerShell cmdlets</h3> <ul> <li>Automate management tasks using the Group Policy management cmdlets</li> <li>Manage server roles and services using PowerShell cmdlets</li> <li>Manage Hyper-V Virtual Machines using PowerShell cmdlets</li> <li>Manage Internet Information Services using PowerShell cmdlets</li> </ul> <h3>7 - Manage settings for a local Windows machine using PowerShell cmdlets</h3> <ul> <li>Manage Windows 10 using PowerShell</li> <li>Manage permissions with PowerShell</li> </ul> <h3>8 - Understand the Windows PowerShell pipeline</h3> <ul> <li>Review Windows PowerShell pipeline and its output</li> <li>Discover object members in PowerShell</li> <li>Control the formatting of pipeline output</li> </ul> <h3>9 - Select, sort, and measure objects using the pipeline</h3> <ul> <li>Sort and group objects by property in the pipeline</li> <li>Measure objects in the pipeline</li> <li>Select a set of objects in the pipeline</li> <li>Select object properties in the pipeline</li> <li>Create and format calculated properties in the pipeline</li> </ul> <h3>10 - Filter objects out of the pipeline</h3> <ul> <li>Learn about the comparison operators in PowerShell</li> <li>Review basic filter syntax in the pipeline</li> <li>Review advanced filter syntax in the pipeline</li> <li>Optimize the filter performance in the pipeline</li> </ul> <h3>11 - Enumerate objects in the pipeline</h3> <ul> <li>Learn about enumerations in the pipeline</li> <li>Review basic syntax to enumerate objects in the pipeline</li> <li>Review advanced syntax to enumerate objects in the pipeline</li> </ul> <h3>12 - Send and pass data as output from the pipeline</h3> <ul> <li>Write pipeline data to a file</li> <li>Convert pipeline objects to other forms of data representation in PowerShell</li> <li>Control additional output options in PowerShell</li> </ul> <h3>13 - Pass pipeline objects</h3> <ul> <li>Pipeline parameter binding</li> <li>Identify ByValue parameters</li> <li>Pass data by using ByValue</li> <li>Pass data by using ByPropertyName</li> <li>Identify ByPropertyName parameters</li> <li>Use manual parameters to override the pipeline</li> <li>Use parenthetical commands</li> <li>Expand property values</li> </ul> <h3>14 - Connect with data stores using PowerShell providers</h3> <ul> <li>Define Windows PowerShell providers</li> <li>Review the built-in providers in PowerShell</li> <li>Access provider help in PowerShell</li> </ul> <h3>15 - Use PowerShell drives in PowerShell</h3> <ul> <li>Explain PowerShell drives in PowerShell</li> <li>Use PowerShell drive cmdlets in PowerShell</li> <li>Manage the file system in PowerShell</li> <li>Manage the registry in PowerShell</li> <li>Work with certificates in PowerShell</li> <li>Work with other PowerShell drives in PowerShell</li> </ul> <h3>16 - Review CIM and WMI</h3> <ul> <li>Review architecture of CIM and WMI</li> <li>Review repositories in CIM and WMI</li> <li>Locate online class documentation by using CIM and WMI cmdlets</li> </ul> <h3>17 - Query configuration information by using CIM and WMI</h3> <ul> <li>List local repository namespaces and classes by using CIM and WMI</li> <li>Query instances by using commands and WMI Query Language</li> <li>Connect to remote computers by using CIM and WMI cmdlets</li> <li>Query repository classes from remote computers by using CIMSession objects</li> </ul> <h3>18 - Query and manipulate repository objects by using CIM and WMI methods</h3> <ul> <li>Discover methods of repository objects by using CIM and WMI</li> <li>Locate class methods and documentation by using CIM and WMI</li> <li>Invoke methods of repository objects by using CIM and WMI</li> </ul> <h3>19 - Manage variables in Windows PowerShell scripts</h3> <ul> <li>Define variables in Windows PowerShell scripts</li> <li>Create variable names in Windows PowerShell scripts</li> <li>Assign values and types to variables in Windows PowerShell scripts</li> <li>Identify the methods and properties of variables in Windows PowerShell scripts</li> <li>Use string variables and methods in Windows PowerShell scripts</li> <li>Use date variables and methods in Windows PowerShell scripts</li> </ul> <h3>20 - Work with arrays and hash tables in Windows PowerShell scripts</h3> <ul> <li>Define an array in Windows PowerShell scripts</li> <li>Work with array lists in Windows PowerShell scripts</li> <li>Define hash tables in Windows PowerShell Scripts</li> <li>Work with hash tables in Windows PowerShell scripts</li> </ul> <h3>21 - Create and run scripts by using Windows PowerShell</h3> <ul> <li>Review Windows PowerShell scripts</li> <li>Modify scripts in the PowerShell Gallery</li> <li>Create scripts using Windows PowerShell</li> <li>Review the PowerShellGet module in Windows PowerShell</li> <li>Run scripts and set the execution policy in Windows PowerShell</li> <li>Review Windows PowerShell and AppLocker</li> <li>Sign the scripts digitally in Windows PowerShell</li> </ul> <h3>22 - Work with scripting constructs in Windows PowerShell</h3> <ul> <li>Review and use the ForEach loop in Windows PowerShell scripts</li> <li>Review and use the If construct in Windows PowerShell scripts</li> <li>Review and use the Switch construct in Windows PowerShell scripts</li> <li>Review the For construct in Windows PowerShell scripts</li> <li>Review other loop constructs in Windows PowerShell scripts</li> <li>Review Break and Continue in Windows PowerShell scripts</li> </ul> <h3>23 - Import data in different formats for use in scripts by using Windows PowerShell cmdlets</h3> <ul> <li>Use the Get-Content command in Windows PowerShell scripts</li> <li>Use the Import-Csv cmdlet in Windows PowerShell scripts</li> <li>Use the Import-Clixml cmdlet in Windows PowerShell scripts</li> <li>Use the ConvertFrom-Json cmdlet in Windows PowerShell scripts</li> </ul> <h3>24 - Use methods to accept user inputs in Windows PowerShell scripts</h3> <ul> <li>Identify values that might change in Windows PowerShell scripts</li> <li>Use the Read-Host cmdlet in Windows PowerShell scripts</li> <li>Use the Get-Credential cmdlet in Windows PowerShell scripts</li> <li>Use the Out-GridView cmdlet in Windows PowerShell scripts</li> <li>Pass parameters to a Windows PowerShell script</li> </ul> <h3>25 - Troubleshoot scripts and handle errors in Windows PowerShell</h3> <ul> <li>Interpret error messages generated for Windows PowerShell commands</li> <li>Add output to Windows PowerShell scripts</li> <li>Use breakpoints in Windows PowerShell scripts</li> <li>Interpret error actions for Windows PowerShell commands</li> </ul> <h3>26 - Use functions and modules in Windows PowerShell scripts</h3> <ul> <li>Review functions in Windows PowerShell scripts</li> <li>Use variable scope in Windows PowerShell scripts</li> <li>Create modules in Windows PowerShell scripts</li> <li>Use the dot sourcing feature in Windows PowerShell</li> </ul> <h3>27 - Manage single and multiple computers by using Windows PowerShell remoting</h3> <ul> <li>Review the remoting feature of Windows PowerShell</li> <li>Compare remoting with remote connectivity</li> <li>Review the remoting security feature of Windows PowerShell</li> <li>Enable remoting by using Windows PowerShell</li> <li>Use one-to-one remoting by using Windows PowerShell</li> <li>Use one-to-many remoting by using Windows PowerShell</li> <li>Compare remoting output with local output</li> </ul> <h3>28 - Use advanced Windows PowerShell remoting techniques</h3> <ul> <li>Review common remoting techniques of Windows PowerShell</li> <li>Send parameters to remote computers in Windows PowerShell</li> <li>Set access protection to variables, aliases, and functions by using the scope modifier</li> <li>Enable multi-hop remoting in Windows PowerShell</li> </ul> <h3>29 - Manage persistent connections to remote computers by using Windows PowerShell sessions</h3> <ul> <li>Review persistent connections in Windows PowerShell</li> <li>Create and manage persistent PSSessions by using Windows PowerShell</li> <li>Disconnect PSSessions by using Windows PowerShell</li> <li>Review the feature of implicit remoting in Windows PowerShell</li> </ul> <h3>30 - Review Azure PowerShell module</h3> <ul> <li>Review Azure PowerShell</li> <li>Review the benefits of the Azure PowerShell module</li> <li>Install the Azure PowerShell module</li> <li>Migrate Azure PowerShell from AzureRM to Azure</li> <li>Review Microsoft Azure Active Directory module for Windows PowerShell and Azure Active Directory PowerShell for Graph modules</li> </ul> <h3>31 - Review the features and tools for Azure Cloud Shell</h3> <ul> <li>Review the characteristics of Azure Cloud Shell</li> <li>Review the features and tools of Azure Cloud Shell</li> <li>Configure and experiment with Azure Cloud Shell</li> </ul> <h3>32 - Manage Azure resources with Windows PowerShell</h3> <ul> <li>Create a new Azure virtual machine by using Windows PowerShell commands</li> <li>Manage Azure virtual machines by using Windows PowerShell commands</li> <li>Manage Azure related storage by using Azure PowerShell</li> <li>Manage Azure subscriptions by using Azure PowerShell</li> </ul> <h3>33 - Manage users, groups, and licenses in Microsoft Entra ID by using Windows PowerShell</h3> <ul> <li>Review benefits to manage Microsoft 365 services by using Windows PowerShell</li> <li>Connect to the Microsoft 365 tenant by using Windows PowerShell</li> <li>Manage users in Microsoft 365 by using Windows PowerShell</li> <li>Manage groups in Microsoft 365 by using Windows PowerShell</li> <li>Manage roles in Microsoft 365 by using Windows PowerShell</li> <li>Manage licenses in Microsoft 365 by using Windows PowerShell</li> </ul> <h3>34 - Manage Exchange Online by using Windows PowerShell</h3> <ul> <li>Connect to Exchange Online by using Windows PowerShell</li> <li>Manage mailboxes in Exchange Online by using Windows PowerShell</li> <li>Manage resources in Exchange Online by using Windows PowerShell</li> <li>Manage admin roles in Exchange Online by using Windows PowerShell</li> </ul> <h3>35 - Manage SharePoint Online by using Windows PowerShell</h3> <ul> <li>Install and connect to SharePoint Online Management Shell by using Windows PowerShell</li> <li>Manage SharePoint Online users and groups by using Windows PowerShell</li> <li>Manage SharePoint sites by using Windows PowerShell</li> <li>Manage SharePoint Online external user sharing by using Windows PowerShell</li> </ul> <h3>36 - Manage Microsoft Teams by using Windows PowerShell</h3> <ul> <li>Review Microsoft Teams PowerShell module</li> <li>Install the Microsoft Teams PowerShell module</li> <li>Manage teams with Microsoft Teams PowerShell module</li> </ul> <h3>37 - Create and manage background jobs using Windows PowerShell</h3> <ul> <li>Define the types of background jobs in Windows PowerShell</li> <li>Start remote jobs and CIM/WMI jobs in Windows PowerShell</li> <li>Monitor jobs in Windows PowerShell</li> <li>Retrieve results for running jobs in Windows PowerShell</li> </ul> <h3>38 - Create and manage scheduled jobs using Windows PowerShell</h3> <ul> <li>Create and run Windows PowerShell scripts as scheduled tasks</li> <li>Define scheduled jobs in Windows PowerShell</li> <li>Create job option and job trigger objects in Windows PowerShell</li> <li>Create and register a scheduled job in Windows PowerShell</li> <li>Retrieve the results from a scheduled job in Windows PowerShell</li> </ul></div>

Azure PowerShell

Powershell

Microsoft AZ-104

Power Automate

Microsoft AZ-303

Microsoft Power Automate

AZ-040T00 Automating Administration with Powershell

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">VALUES ARE A CORE PART OF WHO WE ARE. YOU WILL RECOGNISE HOW VALUES INFLUENCE &amp; DRIVE BEHAVIOUR IN RESPONSE TO WHAT YOU PERCEIVE, HEAR &amp; UNDERSTAND IN EACH SITUATION. ALIGN WITH A SENSE OF PURPOSE, INNER BALANCE, AND EMOTIONAL HEALTH &amp; WELLBEING.</p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><section data-preview-item="checklist" data-section-uid="GdpgkrzlO" style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><header fr-original-style="" style="box-sizing: border-box;"><section data-preview-item="checklist" data-section-uid="AuZTsY3zI" style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><header fr-original-style="" style="box-sizing: border-box;"><header style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><h2 style="color: rgb(76, 76, 76); box-sizing: border-box;" fr-original-style=" color: rgb(76, 76, 76);">LEARNING OBJECTIVES</h2><p style="color: rgb(76, 76, 76); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(76, 76, 76);">BY THE END OF THIS COURSE YOU WILL BE ABLE TO</p></header><article style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><ul fr-original-style="" style="box-sizing: border-box;"><li 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;">Identify your core values and how they influence behaviour in different situations</p></li><li 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;">Learn about the importance of values in an organisation</p></li><li 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;">Apply organisational values to your job role</p></li></ul></article></header></section><a style="color: rgb(30, 133, 76); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(30, 133, 76);"></a><header fr-original-style="" style="box-sizing: border-box;"><h2 style="color: rgb(76, 76, 76); box-sizing: border-box;" fr-original-style=" color: rgb(76, 76, 76);"><br fr-original-style="" style="box-sizing: border-box;"></h2></header></header></section><section data-preview-item="upsells" data-section-uid="Hb3VJQ04Y" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><article fr-original-style="" style="box-sizing: border-box;"><header fr-original-style="" style="box-sizing: border-box;"><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><header style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><header style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><header style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><h2 style="color: rgb(76, 76, 76); box-sizing: border-box;" fr-original-style=" color: rgb(76, 76, 76);">COURSE OUTLINE</h2></header><article style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(255, 255, 255); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"></i><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">What are values?</p></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(255, 255, 255); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"></i><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Working with your values</p></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(255, 255, 255); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"></i><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Identifying with organizational values</p></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(255, 255, 255); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"></i><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Next steps</p></li></ul></article></header></header></header></article></section>

Green Key Health

Emotional Wellbeing

Wellbeing

Self Esteem & Confidence

Leadership

Personal Transformation

Personal values are a core part of who you are. Recognising how your values influence and drive behaviour in response to what you hear, perceive and understand in each situation is important to understanding and formulating your response. Aligning values within your life helps with fundamental decision making and supports emotional and physical wellbeing.

ME AND MY VALUES: WHO AM I?

Telford

<div style="color: rgb(33, 33, 33); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 33, 33);"><section fr-original-style="" style="box-sizing: border-box;"><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;"><span style="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">What is our Phoenix Effect workshop about?</span></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Our Phoenix Effect workshop helps your organisation burn down the toxic elements of its organisational culture and working environment and rebuild them through a positive, collaborative, and people-focused long-term plan.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The plan is created by the end of the workshop for everyone to take away and collaborate in its success. The success will be managed, driven and, yes, even policed by the&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">O</strong>rganisational&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">C</strong>ulture&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">E</strong>ngagement&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">T</strong>eam (<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">OCET</strong>), or whatever name you decide to give it.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The team will consist of individuals from all levels within the organisation who are motivated to make this work and see the growth of a new and better organisational culture driven by its organisational values (make sure your values are people-focused).&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The overarching psychological safety will be&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">guaranteed</strong>&nbsp;in the People Strategy document (I can help you with that if you haven&rsquo;t got one yet). In it, the organisation will state that all colleagues, regardless of their position, will not just be permitted to say what they want to anyone at all, but that they will do so as part of their job.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Furthermore, the organisational values should be copied into every job description as part of the employee contract. This, in turn, permits the one-to-one chats to ensure colleagues are doing their jobs by performing as they should&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">and</strong> behaving in a manner that supports the organisational values and culture. &nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The organisation will then be set up to continue on that journey, with everyone working collaboratively in a psychologically safe environment to grow a superb organisation to work in and attract new talent.&nbsp;</p><section fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><span style="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">Who Should Attend and Why?</span></h3></section><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;">Who</strong>?&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">All people in HR and Training/L&amp;D. People from various levels who will have volunteered and been identified as motivated to drive the organisation-wide development required to succeed.&nbsp;&nbsp;</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;">Why</strong>?&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We should ALL want to help improve our working environment and make our teams feel safe and happy.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Regardless of who we work with or for, we must all do everything we can to work well together and build and maintain excellent working relationships. &nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">When we truly understand things from the perspective of others (our Moccasin Approach<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>), we are far better able to communicate and work with them effectively and efficiently.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">It&rsquo;s the people in an organisation who make it or break it. They help create positivity or negativity. Do well by your people, and they will do well by you.</p><p style="font-size: medium; font-family: Aptos, sans-serif; margin: 0cm; color: rgb(0, 0, 0); font-style: normal; font-weight: 400; text-align: start; text-indent: 0px; text-decoration: none; box-sizing: border-box;" id="isPasted" fr-original-style="margin-right:0cm;margin-left:0cm;font-size: medium;font-family: Aptos, sans-serif;margin: 0cm;color: rgb(0, 0, 0);font-style: normal;font-weight: 400;text-align: start;text-indent: 0px;text-decoration: none;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 24px; font-family: Calibri, sans-serif; color: rgb(32, 56, 100); box-sizing: border-box;" fr-original-style="font-size:24px;font-family: Calibri, sans-serif;color: rgb(32, 56, 100);">Workshop Content</span></strong></p><p style="font-size: medium; font-family: Aptos, sans-serif; margin: 0cm; color: rgb(0, 0, 0); font-style: normal; font-weight: 400; text-align: start; text-indent: 0px; text-decoration: none; box-sizing: border-box;" fr-original-style="margin-right:0cm;margin-left:0cm;font-size: medium;font-family: Aptos, sans-serif;margin: 0cm;color: rgb(0, 0, 0);font-style: normal;font-weight: 400;text-align: start;text-indent: 0px;text-decoration: none;"><span style="font-family: Calibri, sans-serif; color: rgb(32, 56, 100); box-sizing: border-box;" fr-original-style="font-family: Calibri, sans-serif;color: rgb(32, 56, 100);">All Phoenix Effect workshops are facilitated by our managing director, Mac Macdonald, who has vast experience helping organisations from all industries of all sizes and sectors.&nbsp;</span></p><p style="font-size: medium; font-family: Aptos, sans-serif; margin: 0cm; color: rgb(0, 0, 0); font-style: normal; font-weight: 400; text-align: start; text-indent: 0px; text-decoration: none; box-sizing: border-box;" fr-original-style="margin-right:0cm;margin-left:0cm;font-size: medium;font-family: Aptos, sans-serif;margin: 0cm;color: rgb(0, 0, 0);font-style: normal;font-weight: 400;text-align: start;text-indent: 0px;text-decoration: none;"><span style="font-family: Calibri, sans-serif; color: rgb(32, 56, 100); box-sizing: border-box;" fr-original-style="font-family: Calibri, sans-serif;color: rgb(32, 56, 100);"><br fr-original-style="" style="box-sizing: border-box;"></span></p><ul type="disc" style="margin-bottom: 0cm; color: rgb(0, 0, 0); font-style: normal; font-weight: 400; text-align: start; text-indent: 0px; text-decoration: none; margin-top: 0cm; box-sizing: border-box;" fr-original-style="margin-bottom: 0cm;color: rgb(0, 0, 0);font-style: normal;font-weight: 400;text-align: start;text-indent: 0px;text-decoration: none;margin-top: 0cm;"><li style="margin: 0cm; font-size: 16px; font-family: Aptos, sans-serif; color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="margin: 0cm; font-size: 16px; font-family: Aptos, sans-serif; color: rgb(40, 50, 78);"><span style="font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-family: Calibri, sans-serif;">We open with our ingredients of Emotional Intelligence (EI).</span></li><li style="margin: 0cm; font-size: 16px; font-family: Aptos, sans-serif; color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="margin: 0cm; font-size: 16px; font-family: Aptos, sans-serif; color: rgb(40, 50, 78);"><span style="font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-family: Calibri, sans-serif;">We then delve into the truth about Organisational Culture (OC) and share our honest thoughts and opinions.</span></li><li style="margin: 0cm; font-size: 16px; font-family: Aptos, sans-serif; color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="margin: 0cm; font-size: 16px; font-family: Aptos, sans-serif; color: rgb(40, 50, 78);"><span style="font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-family: Calibri, sans-serif;">Everyone completes our OC self-assessment in small groups and then shares their thinking to build a starting hit list.</span></li><li style="margin: 0cm; font-size: 16px; font-family: Aptos, sans-serif; color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="margin: 0cm; font-size: 16px; font-family: Aptos, sans-serif; color: rgb(40, 50, 78);"><span style="font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-family: Calibri, sans-serif;">Small group discussions to establish possible solutions to their OC issues?&nbsp;</span></li><li style="margin: 0cm; font-size: 16px; font-family: Aptos, sans-serif; color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="margin: 0cm; font-size: 16px; font-family: Aptos, sans-serif; color: rgb(40, 50, 78);"><span style="font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-family: Calibri, sans-serif;">What causes these issues, and what can we suggest as possible solutions?</span></li><li style="margin: 0cm; font-size: 16px; font-family: Aptos, sans-serif; color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="margin: 0cm; font-size: 16px; font-family: Aptos, sans-serif; color: rgb(40, 50, 78);"><span style="font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-family: Calibri, sans-serif;">How will the fire burn down the old culture, and how will the new culture rise from those ashes and plan the change?</span></li><li style="margin: 0cm; font-size: 16px; font-family: Aptos, sans-serif; color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="margin: 0cm; font-size: 16px; font-family: Aptos, sans-serif; color: rgb(40, 50, 78);"><span style="font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-family: Calibri, sans-serif;">We will discuss our&nbsp;ES<sup fr-original-style="" style="box-sizing: border-box;">2</sup> thinking and see why it is critical to this Phoenix Effect objective.&nbsp;</span></li><li style="margin: 0cm; font-size: 16px; font-family: Aptos, sans-serif; color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="margin: 0cm; font-size: 16px; font-family: Aptos, sans-serif; color: rgb(40, 50, 78);"><span style="font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-family: Calibri, sans-serif;">We discuss &ldquo;Consequence Conversations&rdquo; and why they must be used.</span></li><li style="margin: 0cm; font-size: 16px; font-family: Aptos, sans-serif; color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="margin: 0cm; font-size: 16px; font-family: Aptos, sans-serif; color: rgb(40, 50, 78);"><span style="font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-family: Calibri, sans-serif;">We examine our &ldquo;ARCHWAY Approach&rdquo;&reg; to understand why it can be used as a health checker.&nbsp;</span></li></ul></section></div><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><br fr-original-style="" style="box-sizing: border-box;"></div><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; -webkit-user-select: none; box-sizing: border-box;"><div style="color: rgb(33, 33, 33); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 33, 33);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">LENGTH</strong></div><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);">1 Day</div><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">NEXT WORKSHOP START</strong></div><div style="color: rgb(33, 33, 33); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 33, 33);">Let&#39;s chat and confirm a date.</div><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(33, 33, 33); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 33, 33);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">WORKSHOP DELIVERY</strong></div><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);">The best environment for this workshop is face-to-face, but we can facilitate this workshop online.</div><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><div style="color: rgb(33, 33, 33); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 33, 33);"><div style="color: rgb(33, 33, 33); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 33, 33);"><div style="color: rgb(33, 33, 33); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 33, 33);"><div style="color: rgb(33, 33, 33); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 33, 33);"><div style="color: rgb(33, 33, 33); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 33, 33);"><section fr-original-style="" style="box-sizing: border-box;"><h2 title="Course delivery details" style="color: rgb(33, 33, 33); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 33, 33);">Workshop delivery and venue</h2></section></div><section 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;">When you consider the content we deliver, we are sure you will understand why we always prefer to deliver our workshops, courses and programmes face-to-face.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Face-to-face workshops and courses can be held at a location of your choice or, if you wish, a central UK location, such as the Macdonald Burlington Hotel in Birmingham, located directly across from the Birmingham New Street train station.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We can deliver our workshops, courses and programmes online, although this will mean splitting elements into manageable learning events to suit the online environment.</p></section></div></div></div></div></div></div></div></div>

What is our Phoenix Effect workshop about?
Our Phoenix Effect workshop helps your organisation burn down the toxic elements of its organisational culture and working environment and rebuild them through a positive, collaborative, and people-focused long-term plan. 
The plan is created by the end of the workshop for everyone to take away and collaborate in its success. The success will be managed, driven and, yes, even policed by the Organisational Culture Engagement Team (OCET), or whatever name you decide to give it. 
The team will consist of individuals from all levels within the organisation who are motivated to make this work and see the growth of a new and better organisational culture driven by its organisational values (make sure your values are people-focused). 
The overarching psychological safety will be guaranteed in the People Strategy document (I can help you with that if you haven’t got one yet). In it, the organisation will state that all colleagues, regardless of their position, will not just be permitted to say what they want to anyone at all, but that they will do so as part of their job. 
Furthermore, the organisational values should be copied into every job description as part of the employee contract. This, in turn, permits the one-to-one chats to ensure colleagues are doing their jobs by performing as they should and behaving in a manner that supports the organisational values and culture. 
The organisation will then be set up to continue on that journey, with everyone working collaboratively in a psychologically safe environment to grow a superb organisation to work in and attract new talent. 
Who Should Attend and Why?
Who? 
All people in HR and Training/L&D. People from various levels who will have volunteered and been identified as motivated to drive the organisation-wide development required to succeed. 
Why? 
We should ALL want to help improve our working environment and make our teams feel safe and happy. 
Regardless of who we work with or for, we must all do everything we can to work well together and build and maintain excellent working relationships. 
When we truly understand things from the perspective of others (our Moccasin Approach®), we are far better able to communicate and work with them effectively and efficiently. 
It’s the people in an organisation who make it or break it. They help create positivity or negativity. Do well by your people, and they will do well by you.
Workshop Content
All Phoenix Effect workshops are facilitated by our managing director, Mac Macdonald, who has vast experience helping organisations from all industries of all sizes and sectors. 


We open with our ingredients of Emotional Intelligence (EI).
We then delve into the truth about Organisational Culture (OC) and share our honest thoughts and opinions.
Everyone completes our OC self-assessment in small groups and then shares their thinking to build a starting hit list.
Small group discussions to establish possible solutions to their OC issues?
What causes these issues, and what can we suggest as possible solutions?
How will the fire burn down the old culture, and how will the new culture rise from those ashes and plan the change?
We will discuss our ES2 thinking and see why it is critical to this Phoenix Effect objective.
We discuss “Consequence Conversations” and why they must be used.
We examine our “ARCHWAY Approach”® to understand why it can be used as a health checker.



LENGTH - For more information about duration, please get in touch with us to discuss your specific needs, or we can offer advice.  
NEXT WORKSHOP START - Please ask for more information as we deliver bespoke closed events for your people at your location or a mutually suitable location.
WORKSHOP DELIVERY - The best environment for this workshop is face-to-face, but we can facilitate this workshop online.
Workshop delivery and venue
When you consider the content we deliver, we are sure you will understand why we always prefer to deliver our workshops, courses and programmes face-to-face.
Face-to-face workshops and courses can be held at a location of your choice or, if you wish, a central UK location, such as the Macdonald Burlington Hotel in Birmingham, located directly across from the Birmingham New Street train station.
We can deliver our workshops, courses and programmes online, although this will mean splitting elements into manageable learning events to suit the online environment.

Lapd Solutions Ltd

Organisational Behaviour

Employee Engagement

Organisational Skills

Leadership Development

Organisational development, Organisational culture, Organisational values, Organisational environment, 

The Phoenix Effect

Introductory daily rate.

Registered charities and non profits only. 

1771 Courses delivered Online

Kubernetes - Certified Kubernetes Administrator (CKA) 2022

By Packt

Building and Leading Effective Teams

By Underscore Group

Wellness And Fitness Training Level 3

By Alpha Academy

Transport And Warehouse Operations Supervisor Level 3

By Rachel Hood

VBA in Excel - Part 1

By Underscore Group

Access - Database Design and Reporting

By Underscore Group

Tableau Desktop Training - Foundation

By Tableau Training Uk

Power BI Introduction

By Underscore Group

British Citizenship Training

By Studyhub UK

Visual Analytics Best Practice

By Tableau Training Uk