Harpenden

<p>There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service.</p><p>It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way.</p><p>It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level.</p><p>The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away.</p><section>
                    <h3>1 Getting Started</h3><ul><li>The Power BI ecosystem</li><li>Opening Power BI Desktop</li><li>Power BI's four views</li><li>Introduction to Dashboards</li></ul> <h3>2 Importing Files</h3><ul><li>Importing data sources</li><li>Importing an Excel file</li><li>Importing a CSV file</li><li>Importing a database</li><li>Connect to an SQL Server Database</li><li>Import vs. Direct Query</li><li>Importing from the web</li><li>Importing a folder of files</li><li>Managing file connections</li></ul> <h3>3 Shape Data in the Query Editor</h3><ul><li>The process of shaping data</li><li>Managing data types</li><li>Keeping and removing rows</li><li>Add a custom column</li><li>Appending tables together</li><li>Hiding queries in reports</li><li>Fixing error issues</li><li>Basic maths operations</li></ul> <h3>4 The Data Model</h3><ul><li>Table relationships</li><li>Relationship properties</li></ul> <h3>5 Merge Queries</h3><ul><li>Table join kinds</li><li>Merging tables</li></ul> <h3>6 Inserting Dashboard Visuals</h3><ul><li>Things to keep in mind</li><li>Inserting maps</li><li>Formatting Maps</li><li>Inserting charts</li><li>Formatting Charts</li><li>Inserting a tree map</li><li>Inserting a table, matrix, and card</li><li>Controlling number formats</li><li>About report themes</li><li>Highlighting key points</li><li>Filter reports with slicers</li><li>Sync slicers across dashboards</li><li>Custom web visuals</li></ul> <h3>7 Publish and share Reports</h3><ul><li>Publishing to Power BI service</li><li>Editing online reports</li><li>Pinning visuals to a dashboard</li><li>What is Q&amp;A?</li><li>Sharing dashboards</li><li>Exporting reports to PowerPoint</li><li>Exporting reports as PDF files</li></ul> <h3>8 The Power Query Editor</h3><ul><li>Fill data up and down</li><li>Split column by delimiter</li><li>Add a conditional column</li><li>More custom columns</li><li>Merging columns</li></ul> <h3>9 The M Functions</h3><ul><li>Inserting text functions</li><li>Insert an IF function</li><li>Create a query group</li></ul> <h3>10 Pivoting Tables</h3><ul><li>Pivot a table</li><li>Pivot and append tables</li><li>Pivot but don't aggregate</li><li>Unpivot tables</li><li>Append mismatched headers</li></ul> <h3>11 Data Modelling Expanded</h3><ul><li>Understanding relationships</li><li>Mark a date table</li></ul> <h3>12 DAX New Columns</h3><ul><li>New columns and measures</li><li>New column calculations</li><li>Insert a SWITCH function</li></ul> <h3>13 Introduction to DAX Measures</h3><ul><li>Common measure functions</li><li>Insert a SUM function</li><li>Insert a COUNTROWS function</li><li>Insert a DISTINCTCOUNT function</li><li>Insert a DIVIDE function</li><li>DAX rules</li></ul> <h3>14 The CALCULATE Measure</h3><ul><li>The syntax of CALCULATE</li><li>Insert a CALCULATE function</li><li>Control field summarisation</li><li>Things of note</li></ul> <h3>15 The SUMX measure</h3><ul><li>X iterator functions</li><li>Anatomy of SUMX</li><li>Insert a SUMX function</li><li>When to use X functions</li></ul> <h3>16 Time Intelligence Measures</h3><ul><li>Importance of a calendar table</li><li>Insert a TOTALYTD function</li><li>Change financial year end date</li><li>Comparing historical data</li><li>Insert a DATEADD function</li></ul> <h3>17 Hierarchies and Groups</h3><ul><li>Mine data using hierarchies</li><li>Compare data in groups</li></ul> 


                </section>

The In House Training Company

Powerbi

Business Analytics & Intelligence

Microsoft Power BI

Excel Analytics

Microsoft Power Platform

Microsoft BI

Power BI - introduction (2 day) (In-House)

<p>This workshop has been designed to help managers understand their responsibilities and what they need to do to ensure compliance with current workplace legislation - including the fire safety and CDM regulations.</p><p>The day will cover the legal background - including an appreciation of how safety legislation has evolved and why; the logic behind recent developments and the implications for staff and employers; key areas of current legislation; roles and responsibilities in health and safety management, including monitoring contractors and suppliers effectively; implementing sound health and safety policies and procedures; getting staff on board, and implementing effective systems. Also, recognising potential risks and hazards and developing strategies to minimise their impact in the workplace.</p>This course will give participants an understanding of:<ul><li>The broader context of the key areas of health and safety regulation which apply to your<br />organisation</li><li>Existing health and safety practice and guide them in how to shape and implement an effective health and safety policy</li><li>What they should do and the procedures to support it</li><li>Potential areas of risk in the workplace - and how to take action to minimise the threat to staff safety</li><li>How sound health and safety processes can contribute to business performance</li></ul><section>
                    <h3>1 Understanding the workplace legislation</h3><ul><li>Overview of health and safety and workplace legislation</li><li>Compliance, the role of the facilities manager, and who is accountable?</li><li><em>Breakout session to discuss where we are now and to highlight issues of concern</em></li><li>Applying required policies and procedures</li><li>Developing and implementation/review of the safety policy</li><li>Communicating with users, clients and contractors</li><li>Health and safety manual</li><li>'Selling' health and safety</li></ul> <h3>2 Key legislation - a practical working guide</h3><ul><li>Asbestos Regulations</li><li>Construction (Design and Management) Regulations 2007 / 2015</li><li>Control of Substances Hazardous to Health (COSHH) Regulations</li><li>Disability Discrimination Act (DDA)</li><li>Display Screen Equipment (DSE) Regulations 1992</li><li>Electricity at Work Regulations 1989</li><li>Fire Precautions (Workplace ) Regulations 2006</li><li>Health and Safety (Consultation with Employees) Regulations 1996</li><li>Health and Safety (First Aid) Regulations 1981</li><li>Health and Safety at Work etc. Act 1974</li><li>Management of Health and Safety at Work Regulations 1992</li><li>Manual Handling Operations Regulations 1992</li><li>Portable Appliance Testing (PAT)</li><li>Provision and Use of Work Equipment Regulations 1992</li><li>REACH - Registration, Evaluation, Authorisation and restriction of Chemicals</li><li>Reporting of Injuries, Diseases, and Dangerous Occurrences Regulations (RIDDOR) 1995</li><li>Waste Electrical and Electronic Equipment (WEEE) Regulations 2006</li><li>Work Equipment Regulations</li></ul> <h3>3 Controlling contractors</h3><ul><li>Understanding the Regulations</li><li>Selecting and assessing contractors</li><li>Understanding and setting accountability</li><li>Why a method statement?</li><li>How to apply a permit to work system</li><li>Safe systems of work</li><li><em>Round-table discussion to bring out issues from participants' own experience</em></li></ul> <h3>4 Risk assessment</h3><ul><li>Understanding your hazards</li><li>Identifying specialist areas</li><li>How to undertake these assessments</li><li>Implementation of sound systems and processes</li><li><em>Syndicate exercise identifying where assessments are needed and carrying out assessments</em></li></ul> <h3>5 Keeping the work environment safe</h3><ul><li>Sick building syndrome and legionella</li><li>Asbestos</li><li>Waste management</li><li>Pest control</li><li>Provisions for first aid</li><li>Accident reporting and investigation</li><li>At-work driver safety</li><li>Security</li></ul> <h3>6 Fire safety</h3><ul><li>Understanding the Regulatory Reform Fire Safety Order</li><li>Fire certificates</li><li>The fire risk assessment</li><li>Testing fire-fighting equipment?</li><li>Emergency procedures</li><li><em>Workshop to examine the procedures for dealing with different types of emergencies</em></li></ul> <h3>7 Ergonomics programme</h3><ul><li>Ergonomics - important or irrelevant?</li><li>Are you complying with HSE regulations?</li><li>Furniture and equipment</li><li>Display screen equipment assessments</li><li>Homeworking - your concern or not?</li><li><em>Syndicate exercise to review what to do when relocating or refurbishing an office</em></li></ul> <h3>8 Inspecting and auditing</h3><ul><li>Role of Health and Safety Executive Inspectors - 'be prepared'</li><li>FM role</li><li>Staff/trade union involvement</li><li>Independent audits</li><li>Records and reports</li><li>Communicating the results</li></ul> <h3>9 Action plan</h3><ul><li>Participants to list actions they need to take after the course</li></ul> 


                </section>

First Aid At Work

Health & Safety Awareness

Health, Safety & Environment (HSE)

Workplace Health & Safety

Health & Safety

Health & Safety At Work

H&S for FM (In-House)

<p>This five-day programme empowers participants with the skills and knowledge to understand and effectively apply best practice commercial and contracting principles and techniques, ensuring better contractor performance and greater value add.</p><p>This is an assessed programme, leading to the International Association for Contracts &amp; Commercial Management (IACCM)'s coveted Contract and Commercial Management Practitioner (CCMP) qualification.</p>By the end of this comprehensive programme the participants will be able to:<ul><li>Develop robust contracting plans, including scopes of work and award strategies</li><li>Undertake early market engagements to maximise competition</li><li>Conduct effective contracting and commercial management activities, including ITT, RFP, negotiated outcomes</li><li>Understand the legalities of contract and commercial management</li><li>Negotiate effectively with key stakeholders and clients, making use of the key skills of persuading and influencing to optimise outcomes</li><li>Undertake effective Supplier Relationship Management</li><li>Appreciate the implications of national and organisational culture on contracting and commercial activities</li><li>Appreciate professional contract management standards</li><li>Set up and maintain contract and commercial management governance systems</li><li>Take a proactive, collaborative, and agile approach to managing commercial contracts</li><li>Develop and monitor appropriate and robust KPIs and SLAs to manage the contractor and facilitate improved contractor performance</li><li>Appreciate the cross-functional nature of contract management</li><li>Collaborate with clients to deliver sustainable performance and to manage and exceed client expectations</li><li>Understand the roles and responsibilities of contract and commercial managers</li><li>Use effective contractor selection and award methods and models (including the 10Cs model) and use these models to prepare robust propositions to clients</li><li>Make effective use of lessons learned to promote improvements from less than optimal outcomes, using appropriate templates</li><li>Effectively manage the process of change, claims, variations, and dispute resolution</li><li>Develop and present robust propositions</li><li>Make appropriate use of best practice contract and commercial management tools, techniques, and templates</li></ul><section>
                    <h3>DAY ONE</h3> <h3>1 Introduction</h3><ul><li>Aims</li><li>Objectives</li><li>KPIs</li><li>Learning strategies</li><li>Plan for the programme</li></ul> <h3>2 The contracting context</h3><ul><li>Key objectives of contract management</li><li>Importance and impact on the business</li></ul> <h3>3 Critical success factors</h3><ul><li>Essential features of professional commercial and contract management and administration</li><li>The 6-step model</li></ul> <h3>4 Putting the 'management' into commercial and contract management</h3><ul><li>Traditional <em>v</em> 'new age' models</li><li>The need for a commercial approach</li><li>The added value generated</li></ul> <h3>5 Definitions</h3><ul><li>'Commercial management'</li><li>'Contract management'</li><li>'Contracting'</li><li>... and why have formal contracts?</li></ul> <h3>6 Stakeholders</h3><ul><li>Stakeholder mapping and analysis</li><li>The 'shared vision' concept</li><li>Engaging with key functions, eg, HSE, finance, operations</li></ul> <h3>7 Roles and responsibilities</h3><ul><li>Contract administrators</li><li>Stakeholders</li></ul> <h3>8 Strategy and planning</h3><ul><li>Developing effective contracting plans and strategies</li></ul>  <h3>DAY TWO</h3> <h3>1 Contract control</h3><ul><li>Tools and techniques, including CPA and Gantt charts</li><li>A project management approach</li><li>Developing effective contract programmes</li></ul> <h3>2 The contracting context</h3><ul><li>Key objectives of contract management</li><li>Importance and impact on the business</li></ul> <h3>3 Tendering</h3><ul><li>Overview of the contracting cycle</li><li>Requirement to tender</li><li>Methods</li><li>Rationale</li><li>Exceptions</li><li>Steps</li><li>Gateways</li><li>Controls</li><li>One and two package bids</li></ul> <h3>4 Tender assessment and contract award I - framework</h3><ul><li>Tender board procedures</li><li>Role of the tender board (including minor and major tender boards)</li><li>Membership</li><li>Administration</li><li>Developing robust contract award strategies and presentations</li></ul>  <h3>DAY THREE</h3> <h3>1 Tender assessment and contract award II - processes</h3><ul><li>Pre-qualification processes</li><li>CRS</li><li>Vendor registration rules and processes</li><li>Creating bidder lists</li><li>Disqualification criteria</li><li>Short-listing</li><li>Using the 10Cs model</li><li>Contract award and contract execution processes</li></ul> <h3>2 Minor works orders</h3><ul><li>Process</li><li>Need for competition</li><li>Role and purpose</li><li>Controls</li><li>Risks</li></ul> <h3>3 Contract strategy</h3><ul><li>Types of contract</li><li>Call-offs</li><li>Framework agreements</li><li>Price agreements</li><li>Supply agreements</li></ul> <h3>4 Contract terms I: Pricing structures</h3><ul><li>Lump sum</li><li>Unit price</li><li>Cost plus</li><li>Time and materials</li><li>Alternative methods</li><li>Target cost</li><li>Gain share contracts</li><li>Advance payments</li><li>Price escalation clauses</li></ul> <h3>5 Contract terms II: Other financial clauses</h3><ul><li>Insurance</li><li>Currencies</li><li>Parent body guarantees</li><li>Tender bonds</li><li>Performance bonds</li><li>Retentions</li><li>Sub-contracting</li><li>Termination</li><li>Invoicing</li></ul> <h3>6 Contract terms III: Risk and reward</h3><ul><li>Incentive contracts</li><li>Management and mitigation of contractual risk</li></ul>  <h3>DAY FOUR</h3> <h3>1 Contract terms IV: Jurisdiction and related matters</h3><ul><li>Applicable laws and regulations</li><li>Registration</li><li>Commercial registry</li><li>Commercial agencies</li></ul> <h3>2 Managing the client-contractor relationship</h3><ul><li>Types of relationship</li><li>Driving forces</li><li>Link between type of contract and style of relationships</li><li>Motivation - use of incentives and remedies</li></ul> <h3>3 Disputes</h3><ul><li>Types of dispute</li><li>Conflict resolution strategies</li><li>Negotiation</li><li>Mediation</li><li>Arbitration</li></ul>  <h3>DAY FIVE</h3> <h3>1 Performance measurement</h3><ul><li>KPIs</li><li>Benchmarking</li><li>Cost controls</li><li>Validity of savings</li><li>Balanced scorecards</li><li>Using the KPI template</li></ul> <h3>2 Personal qualities of the contract manager</h3><ul><li>Negotiation</li><li>Communication</li><li>Persuasion and influencing</li><li>Working in a matrix environment</li></ul> <h3>3 Contract terms V: Drafting skills</h3><ul><li>Drafting special terms</li></ul> <h3>4 Variations</h3><ul><li>Contract and works variation orders</li><li>Causes of variations</li><li>Risk management</li><li>Controls</li><li>Prevention</li><li>Negotiation with contractors</li></ul> <h3>5 Claims</h3><ul><li>Claims management processes</li><li>Controls</li><li>Risk mitigation</li><li>Schedules of rates</li></ul> <h3>6 Close-out</h3><ul><li>Contract close-out and acceptance / completion</li><li>HSE</li><li>Final payments</li><li>Performance evaluation</li><li>Capturing the learning</li></ul> <h3>7 Close</h3><ul><li>Review</li><li>Final assessment</li><li>Next steps</li></ul> 


                </section>

Association of Proposal Management Professionals (APMP)

Commercial Manager

Construction Management

Construction Design & Management (CDM)

Contract Management

Commercial & Contract Management Certification Program (CCM)

Contract and commercial management for practitioners (In-House)

School of Business and Technology London

Doctor of Business Administration (DBA)


Course Aim
This course will provide delegates involved in tackling the financial underpinning of corrupt behaviour with the knowledge, concepts and practices necessary to understand and mitigate illicit financial flows.
Course Objectives
This course aims to increase and enhance delegates’ understanding of the typologies of illicit financial movements and of the mechanisms, structures and tools necessary to identify, trace and mitigate the impact of such flows.
It assumes no prior knowledge of the subject but ensures through a high level of interactivity that delegates with any level of experience in the field will be able share and receive the collective knowledge of the group.
Course Outline
The nature and extent of corruption in general and in the context of delegates’ working experience
International Legislative and Regulatory frameworks such as the UN Convention Against Corruption
The Illicit Financial Flows Environment including the level of financial corruption globally, so-called ‘secrecy’ jurisdictions, illicit financial flow circuits and their enablers
Developing and instituting investigative strategies for mitigating financial corruption including operational procedures and asset recovery 
Global, regional and national anti-bribery provisions
The proactive use of auditing to discover the loopholes of regulatory approaches to tackling illicit financial flows 
Financial regulation as an illicit financial flow mitigatory practice
Risk management strategies and concepts based on real-world and real-time threat assessments
Mitigating financial flows including elective tax policy, reducing capital flight and obtaining multi-jurisdictional technical assistance
The role of the private and public sector in assisting with tackling financial corruption including the role of offshore’ tax havens and their reduction of financial transparency
Tackling the normalisation of financial corruption through dedicated training and education programmes
Enhancing elective political engagement through an understanding of the nature and impact of populist anti-corruption rhetoric and analysis of the legislative process and its created or common blocking mechanisms
Strengthening public sector transparency including the notion of professional ethics and ensuring ethical practice in procurement
Utilising the Media and enhancing advocacy to illustrate the nature, extent and impact of financial corruption
Incorporating technology and innovation in investigative practice
International Legislative, Regulatory and Institutional provisions including sanctions
National Counter-Financial Corruption strategies
Creating an elective anti-corruption agency


Global Risk Alliance Ltd

Law Enforcement

Certification in Business Accounting & Taxation (CBAT)

Audit

This course will provide delegates involved in tackling the financial underpinning of corrupt behaviour with the knowledge, concepts and practices necessary to understand and mitigate illicit financial flows.

Tackling Financial Corruption

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

MBA (Advanced Entry)- Inclusive of Level 7 Pathway Diploma

MBA Top-Up - Inclusive of Level 7 Pathway Diploma

BA (Hons) Business and Management Top-Up - Inclusive of Level 4 and 5 Pathway Diploma

Horsham

<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;">Expand your VBA knowledge further and learn some of the more advanced coding features.</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);">This course is aimed at experienced VBA users or those who have attended our&nbsp;<a href="https://www.underscore-group.com/training/training-courses/technical-and-office-programs/vba-in-excel/" target="_blank" rel="noopener noreferrer" style="color: rgb(255, 152, 0); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(255, 152, 0);">Part 1</a>&nbsp;course and have started to use the language.</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);">Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models</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;">Use comparison operators and system functions</li><li fr-original-style="" style="box-sizing: border-box;">Use Arrays</li><li fr-original-style="" style="box-sizing: border-box;">Work with ranges</li><li fr-original-style="" style="box-sizing: border-box;">Work with the worksheets and workbooks collections and objects</li><li fr-original-style="" style="box-sizing: border-box;">Use application objects</li><li fr-original-style="" style="box-sizing: border-box;">Use the FileSystemObject</li><li fr-original-style="" style="box-sizing: border-box;">Create function procedures</li><li fr-original-style="" style="box-sizing: border-box;">Import and save text files</li><li fr-original-style="" style="box-sizing: border-box;">Connect to other applications</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);">Comparison operators &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 Comparison operators and functions</li><li fr-original-style="" style="box-sizing: border-box;">The LIKE function</li><li fr-original-style="" style="box-sizing: border-box;">Wildcards</li><li fr-original-style="" style="box-sizing: border-box;">Using SELECT Case</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">System functions &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;">The VAL function</li><li fr-original-style="" style="box-sizing: border-box;">Case functions</li><li fr-original-style="" style="box-sizing: border-box;">Trim functions</li><li fr-original-style="" style="box-sizing: border-box;">Text functions</li><li fr-original-style="" style="box-sizing: border-box;">Date functions</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Excel worksheet functions &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 Excel functions in VBA</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Arrays &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;">Creating arrays</li><li fr-original-style="" style="box-sizing: border-box;">Using arrays</li><li fr-original-style="" style="box-sizing: border-box;">Ubound and Lbound</li><li fr-original-style="" style="box-sizing: border-box;">Single and multi dimensional arrays</li><li fr-original-style="" style="box-sizing: border-box;">Static vs dynamic arrays</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Working with ranges &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;">Creating range objects</li><li fr-original-style="" style="box-sizing: border-box;">Passing data between range objects and arrays</li><li fr-original-style="" style="box-sizing: border-box;">Using Transpose</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">The Excel object 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;">The object browser</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Working with collections &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;">Collections</li><li fr-original-style="" style="box-sizing: border-box;">Creating object variables</li><li fr-original-style="" style="box-sizing: border-box;">Setting object variables</li><li fr-original-style="" style="box-sizing: border-box;">The For Each . . . Next Loo</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Sheet collections &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;">The worksheets collection</li><li fr-original-style="" style="box-sizing: border-box;">The worksheet object</li><li fr-original-style="" style="box-sizing: border-box;">The sheets collection</li><li fr-original-style="" style="box-sizing: border-box;">Using object</li><li fr-original-style="" style="box-sizing: border-box;">Grouping worksheets</li><li fr-original-style="" style="box-sizing: border-box;">Using Typename</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">The Workbook collection &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;">The workbooks collection</li><li fr-original-style="" style="box-sizing: border-box;">Setting workbook variables</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Application objects &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;">Excel default information</li><li fr-original-style="" style="box-sizing: border-box;">Display/alerts</li><li fr-original-style="" style="box-sizing: border-box;">Screen updating</li><li fr-original-style="" style="box-sizing: border-box;">Status bar</li><li fr-original-style="" style="box-sizing: border-box;">On Time</li><li fr-original-style="" style="box-sizing: border-box;">Using Wait</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Systems dialog boxes &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;">Showing dialog boxes</li><li fr-original-style="" style="box-sizing: border-box;">Using dialog boxes</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Working with files &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;">Searching for files and folders</li><li fr-original-style="" style="box-sizing: border-box;">The DIR function</li><li fr-original-style="" style="box-sizing: border-box;">The FileSystemObject</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Function 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;">Creating functions</li><li fr-original-style="" style="box-sizing: border-box;">Adding arguments</li><li fr-original-style="" style="box-sizing: border-box;">Calling functions</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Working with text files &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;">Searching for files and folders</li><li fr-original-style="" style="box-sizing: border-box;">The DIR function</li><li fr-original-style="" style="box-sizing: border-box;">The FileSystemObject</li><li fr-original-style="" style="box-sizing: border-box;">Using the FILE and FOLDER collections</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Sharing data with other applications &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;">Early vs Late Binding</li><li fr-original-style="" style="box-sizing: border-box;">Setting references to other applications</li><li fr-original-style="" style="box-sizing: border-box;">Creating application variables</li><li fr-original-style="" style="box-sizing: border-box;">Setting application variables</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>

Underscore Group

VBA in Excel - Part 2

<p id="isPasted" style="margin: 0cm; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="margin: 0cm;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 14px; font-family: Calibri, sans-serif; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 14px; font-family: Calibri, sans-serif; color: rgb(0, 0, 0);">Course Overview</span></strong></p><p id="isPasted" style="margin: 0cm; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="margin: 0cm;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" style="margin: 0cm; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="margin: 0cm;">Teaching
the theory and practise of suicide intervention skills that can be applied in
any professional or personal setting, captured in a one-day event accredited by
City and Guilds of London. We use only the most experienced suicide prevention
trainers to deliver this unique learning experience: for anyone who seeks
greater understanding and confidence to intervene with people at risk of
suicide. </p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"> </span>













The
Suicide First Aid through Understanding Suicide Intervention (SFAUSI) course
gives learners the knowledge and tools to understand that suicide is one of the
most preventable deaths and some basic skills can help someone with thoughts of
suicide stay safe from their thoughts and stay alive.&nbsp;</p><p style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'><span style="font-size: 14px; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 14px; color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-family: Calibri, sans-serif;"><br fr-original-style="" style="box-sizing: border-box;"></span></strong></span></p><p style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'><span style="font-size: 14px; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 14px; color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-family: Calibri, sans-serif;">Course Content</span></strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">SFAUSI is comprised of 4 parts, each 90 minutes duration. The
programme teaches and practices the skills and knowledge needed to identify
someone who may be thinking about suicide and competently intervene to help
create suicide- safety as a first aid approach.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Part 1&nbsp;</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Introduction to: the day;
     programme; ourselves and suicide prevention </span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Stigma, Survivors of
     bereavement by suicide and the Hidden Toll</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Suicide thoughts and suicide
     behaviour</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Intention of behaviour Versus
     Outcome of behaviour</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Possible Causes of Suicidal
     thoughts</span></li></ul><div fr-original-style="" style="box-sizing: border-box;">Part 2</div><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Suicide &ndash; the Ripple Effect</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Population-based approach to
     suicide prevention </span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Partnership working</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Working with attitudes and
     values</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">&ldquo;I&rsquo;m so glad you told me&rdquo; -
     Audio visual</span>&nbsp;</li></ul><div fr-original-style="" style="box-sizing: border-box;">Part 3</div><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Meeting the needs of a person
     who is thinking about suicide</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Suicide-Safety Guide</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Step 1 &ndash; Recognising suicide
     and asking about suicide</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Step 2 &ndash; Understanding
     options </span><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt"><br fr-original-style="" style="box-sizing: border-box;"></span></li></ul><div id="isPasted" fr-original-style="" style="box-sizing: border-box;">Part 4</div><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><div id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span fr-original-style="" fr-original-class="fr-close-ul" style="box-sizing: border-box;">&nbsp;<span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Step 3 &ndash; Safeguarding suicide</span></span></div></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Suicide-safety and self-care</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">The risk assessment approach</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Suicide and suicide gestures</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Future learning&nbsp;</span></li></ul><p style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'><span style="font-size: 14px; font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-size: 14px; font-family: Calibri, sans-serif;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p id="isPasted" style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-family: Calibri, sans-serif;">Format</span></strong></span></p><p id="isPasted" style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-family: Calibri, sans-serif;"><br fr-original-style="" style="box-sizing: border-box;"></span></strong></span></p><p style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'>






</p><p style="margin: 0in; font-family: Calibri; font-size: 12pt; color: black; box-sizing: border-box;" fr-original-style="margin:0in;font-family:Calibri;font-size:12.0pt;color:black">Taught
over 6 hours using tutor facilitated Socratic learning, tutor-led practise
session, mini lectures, group work and audio-visual presentations. This is a
highly interactive and emotionally engaging learning experience.&nbsp;</p><p style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'><span style="font-size: 14px; font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-size: 14px; font-family: Calibri, sans-serif;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-family: Calibri, sans-serif;">Pre-training requirement</span></strong></span></p><p style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-family: Calibri, sans-serif;"><br fr-original-style="" style="box-sizing: border-box;"></span></strong></span></p><p style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'><span style="font-size: 14px; font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-size: 14px; font-family: Calibri, sans-serif;">No previous experience or training is necessary. Participants will be asked to self-reflect and empathise with a person having thoughts of suicide. There is no expectation on participants to share personal experiences.&nbsp;</span></p><p style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'><span style="font-size: 14px; font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-size: 14px; font-family: Calibri, sans-serif;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-family: Calibri, sans-serif;">Who should attend?&nbsp;</span></strong></span></p><p style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-family: Calibri, sans-serif;"><br fr-original-style="" style="box-sizing: border-box;"></span></strong></span></p><p style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'><span style="font-size: 14px; font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-size: 14px; font-family: Calibri, sans-serif;">Multi-sector managers and practitioners including health, housing, social care, education, criminal justice, call centre operators, private, voluntary and public sector workers and community groups or members.&nbsp;</span></p><p style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'><span style="font-size: 14px; font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-size: 14px; font-family: Calibri, sans-serif;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p style="margin: 0in; font-family: Calibri; font-size: 12pt; color: black; box-sizing: border-box;" fr-original-style="margin:0in;font-family:Calibri;font-size:12.0pt;color:black"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Accreditation</strong>
</p><p style="margin: 0in; font-family: Calibri; font-size: 12pt; color: black; box-sizing: border-box;" fr-original-style="margin:0in;font-family:Calibri;font-size:12.0pt;color:black">&nbsp;</p><p style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'>













</p><p style="margin: 0in; font-family: Calibri; font-size: 12pt; color: black; box-sizing: border-box;" fr-original-style="margin:0in;font-family:Calibri;font-size:12.0pt;color:black">Participants
can choose to register for the City and Guilds accredited unit of learning for
an additional fee of &pound;85 per person. This involves completion of a written
assignment. </p>

Course Overview


Teaching
the theory and practise of suicide intervention skills that can be applied in
any professional or personal setting, captured in a one-day event accredited by
City and Guilds of London. We use only the most experienced suicide prevention
trainers to deliver this unique learning experience: for anyone who seeks
greater understanding and confidence to intervene with people at risk of
suicide. 
   The
Suicide First Aid through Understanding Suicide Intervention (SFAUSI) course
gives learners the knowledge and tools to understand that suicide is one of the
most preventable deaths and some basic skills can help someone with thoughts of
suicide stay safe from their thoughts and stay alive. 


Course Content
SFAUSI is comprised of 4 parts, each 90 minutes duration. The
programme teaches and practices the skills and knowledge needed to identify
someone who may be thinking about suicide and competently intervene to help
create suicide- safety as a first aid approach. 
Part 1 
Introduction to: the day; programme; ourselves and suicide prevention
Stigma, Survivors of bereavement by suicide and the Hidden Toll
Suicide thoughts and suicide behaviour
Intention of behaviour Versus Outcome of behaviour
Possible Causes of Suicidal thoughts
Part 2
Suicide – the Ripple Effect
Population-based approach to suicide prevention
Partnership working
Working with attitudes and values
“I’m so glad you told me” - Audio visual
Part 3
Meeting the needs of a person who is thinking about suicide
Suicide-Safety Guide
Step 1 – Recognising suicide and asking about suicide
Step 2 – Understanding options
Part 4
Step 3 – Safeguarding suicide
Suicide-safety and self-care
The risk assessment approach
Suicide and suicide gestures
Future learning


Format


 
Taught
over 6 hours using tutor facilitated Socratic learning, tutor-led practise
session, mini lectures, group work and audio-visual presentations. This is a
highly interactive and emotionally engaging learning experience. 


Pre-training requirement


No previous experience or training is necessary. Participants will be asked to self-reflect and empathise with a person having thoughts of suicide. There is no expectation on participants to share personal experiences. 


Who should attend? 


Multi-sector managers and practitioners including health, housing, social care, education, criminal justice, call centre operators, private, voluntary and public sector workers and community groups or members. 


Accreditation

 
  
Participants
can choose to register for the City and Guilds accredited unit of learning for
an additional fee of £85 per person. This involves completion of a written
assignment. 

Changing Minds Training

Suicide First Aid

Public Suicide First Aid through Understanding Suicide Intervention (SFAUSI)

General Admission

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>The primary audience for this course is any IT, facilities or data centre professional who works in and around the data centre and who has the responsibility to achieve and improve the availability and manageability of the data centre.</p>Overview<p>After completion of the course the participant will be able to:? Choose an optimum site for mission-critical data centre based on current and future needs? Describe all components that are important for high availability in a data centre and how to effectively setup the data centre? Name and apply the various industry standards? Describe the various technologies for UPS, fire suppression, cooling, monitoring systems, cabling standards, etc, and to select and apply them effectively to cost-efficiently enhance the high-availability of the data centre.? Review the electrical distribution system to avoid costly downtime? Enhance cooling capabilities and efficiency in the data centre by using existing and new techniques and technologies for the increased cooling requirements of the future? Design a highly reliable and scalable network architecture and learn how to ensure installers apply proper testing techniques? Create effective maintenance contracts with equipment suppliers ensuring the best return on investment? Setup effective data centre monitoring ensuring the right people get the right message? Ensure proper security measures, both procedural and technical, are established to safeguard your company's valuable information in the data centre</p><p>The course will address how to setup and improve key aspects such as power, cooling, security, cabling, safety, etc., to ensure a high available data centre. It will also address key operations and maintenance aspects.</p></div><div id="course-pills-2"><h4>The Data Centre, it?s Importance and Causes for Downtime</h4><h4>Data Centre Standards and Best Practices</h4><h4>Data Centre Location, Building and Construction</h4><ul><li>Selecting appropriate sites and buildings and how to avoid pitfalls<br />Various components of an effective data centre and supporting facilities setup</li></ul><h4>Raised Floor/Suspended Ceiling</h4><ul><li>Uniform, concentrated and rolling load definitions<br />Applicable standards<br />Raised Floor guidelines<br />Signal Reference Grid, grounding of racks<br />Disability act and regulations<br />Suspended ceiling usage and requirements</li></ul><h4>Light</h4><ul><li>Standards<br />Light fixture types and placement<br />Emergency lighting, Emergency Power Supply (EPS)</li></ul><h4>Power Infrastructure</h4><ul><li>Power infrastructure layout from generation to rack level<br />ATS and STS systems<br />Redundancy levels and techniques<br />Three-phase and single-phase usage<br />Power distribution options within the computer room<br />Power cabling versus bus bar trunking<br />Bonding versus grounding<br />Common Mode Noise and isolation transformers<br />Distribution boards, form factors and IP-protection grades<br />Power quality guidelines<br />Real power versus apparent power<br />How to size and calculate load in the data centre Generators<br />Static and dynamic UPS systems, selection criteria, how they operate and energy efficiency option<br />Battery types, correct selection and testing<br />Thermo-graphics</li></ul><h4>Electro Magnetic Fields</h4><ul><li>Electrical fields and magnetic fields definitions and units of measurements<br />Sources of EMF<br />Effects of EMF on human health and equipment<br />(H)EMP<br />Standards<br />EMF shielding solutions</li></ul><h4>Equipment Racks</h4><ul><li>Rack standards, properties and selection criteria<br />Security considerations<br />Power rail/strip options</li></ul><h4>Cooling Infrastructure</h4><ul><li>Temperature and humidity recommendations<br />Cooling measurement units and conversion rates<br />Sensible and latent heat definitions<br />Differences between comfort and precision cooling<br />Overview of different air conditioner technologies<br />Raised floor versus non-raised floor cooling<br />Placement of air conditioner units and limitations to be observed<br />Supplemental cooling options<br />Cold aisle/hot aisle containment</li></ul><h4>Water Supply</h4><ul><li>Importance of water supply and application areas<br />Backup water supply techniques</li></ul><h4>Designing a Scalable Network Infrastructure</h4><ul><li>The importance of a Structured Cabling System<br />Planning considerations<br />Copper and Fiber cable technology and standards<br />ANSI/TIA-942 Cabling hierarchy and recommendations<br />Testing and verification<br />SAN storage cabling<br />Network redundancy<br />Building-to-building connectivity<br />Network monitoring system requirements</li></ul><h4>Fire Suppression</h4><ul><li>Standards for fire suppression<br />Detection systems<br />Various total flooding fire suppression techniques and systems, their benefits and disadvantages<br />Handheld extinguishers<br />Signage and safety<br />Regulatory requirements and best practices</li></ul><h4>Data Centre Monitoring</h4><ul><li>Data centre monitoring requirements<br />EMS versus BMS<br />Water leak detection systems<br />Notification options and considerations</li></ul><h4>Operational Security and Safety Practices</h4><ul><li>Data centre security layers<br />Physical, infrastructure and organisational security<br />Safety measures and essential signage</li></ul><h4>Labelling</h4><ul><li>Choosing a labelling scheme<br />Recommended labelling practices<br />Network labelling</li></ul><h4>Documentation</h4><ul><li>How to setup proper documentation<br />Document management policies and procedures</li></ul><h4>Cleaning</h4><ul><li>Cleaning practices for the data centre</li></ul><h4>MTBF/MTTR</h4><ul><li>Standards and definitions<br />Calculation models<br />The ?real? value</li></ul><h4>Maintenance Contracts/SLA/OLA</h4><h4>EXAM: Certified Data Centre Professional</h4></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Certified Data Centre Professional (CDCP) 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 Certified Data Centre Professional (CDCP) 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

IT Certifications

Certified Cloud Security Professional (CCSP)

AWS Certified Cloud Practitioner

Certified in Data Protection (CDP)

Certified Cyber Professional (CCP)

Certified Data Centre Professional (CDCP)

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Be it a career change, an exciting new hobby, perfecting existing skills or simply enhancing professional employment prospects&ndash; we help you unlock creativity through our industry aligned all-encompassing Graphic Design Course.</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 fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">" Having done my level 1 and level 2 in graphic design, I felt that I still had gaps in my knowledge and I wasn&#39;t comfortable with what I knew. I signed up with Blue Sky Graphics and I am really glad I did. I am definitely better now than when I started and this is all thanks to my tutor and Blue Sky Graphics 🙂 "</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;"><section data-id="a1c66d1" data-element_type="section" data-settings='{"background_background":"classic"}' style="color: rgb(74, 74, 74); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(74, 74, 74);"><div data-id="a6cdb97" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="adfa4f2" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><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;">A Comprehensive Advanced Course</strong></p></div><div data-id="8058df1" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The graphic design course is a structured academic and industry aligned advanced course suitable for complete beginners, intermediates or those wanting to improve their existing skill set. The graphic design course is comprehensive and through our teaching methodology is designed to train participants to become professional Graphic Designers. There is an emphasis on corporate illustration, composition, painting and logos as well as advertisement designs while focusing on vectors, lines, features, shapes, and spaces. All this will be integrated into how graphic elements are printed after they are processed in graphic design software for the purpose of visually illustrating emotions and messages.</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;">During the course you will be exposed to:&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">advertisements, magazines, newspapers, corporate graphic designs particular to company cultures and brand identity, stationery, letterheads, business cards, logos, books, packaging and much more.</strong></p></div><div data-id="68acc2a" data-element_type="widget" data-widget_type="image.default" fr-original-style="" style="box-sizing: border-box;"><img width="1024" height="692" alt="" data-srcset="https://blueskygraphics.co.uk/wp-content/uploads/2022/12/Student-work-123456-1024x692.webp 1024w, https://blueskygraphics.co.uk/wp-content/uploads/2022/12/Student-work-123456-300x203.webp 300w, https://blueskygraphics.co.uk/wp-content/uploads/2022/12/Student-work-123456-768x519.webp 768w, https://blueskygraphics.co.uk/wp-content/uploads/2022/12/Student-work-123456.webp 1440w" data-src="https://blueskygraphics.co.uk/wp-content/uploads/2022/12/Student-work-123456-1024x692.webp" data-sizes="(max-width: 1024px) 100vw, 1024px" src="https://blueskygraphics.co.uk/wp-content/uploads/2022/12/Student-work-123456-1024x692.webp" sizes="(max-width: 1024px) 100vw, 1024px" srcset="https://blueskygraphics.co.uk/wp-content/uploads/2022/12/Student-work-123456-1024x692.webp 1024w, https://blueskygraphics.co.uk/wp-content/uploads/2022/12/Student-work-123456-300x203.webp 300w, https://blueskygraphics.co.uk/wp-content/uploads/2022/12/Student-work-123456-768x519.webp 768w, https://blueskygraphics.co.uk/wp-content/uploads/2022/12/Student-work-123456.webp 1440w" 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 data-id="e3de655" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The graphic design course teaches you to understand and learn how to operate a labyrinthine yet amazing world of Adobe software. With this software we explore the uses of words, shapes, textures, forms, sizes and colours to communicate by combining ideas and images to make a new concept. Graphic design through common misconception is not just about layout and typography, but much more about ideas behind visual meaning. Graphic design can make a company more successful in the world if it makes communication smart, attractive and able to captivate its audience. Graphic design can effectively be used by businesses to make (or break) their brand identity, increase sales, promote web traffic or promote services and products through advertising on their websites to convey complex data to its readers in a clear way.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Elements of graphic design include:&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Colour, Size, Texture, Line, Shape, Space and, Form</strong>. It is important that each element is understood correctly, and this is one of the key principles we teach on our graphic design course. In other terms, graphic design communicates certain ideas or messages through visuals. These visuals can be as simple as a business logo, or as complex as pages of web design. This course goes beyond just the practical side of graphic design and includes the theory and substance behind modern graphic design.<br fr-original-style="" style="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;">Your teacher will guide you on:</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">What salary you can expect at the start of your career?<br fr-original-style="" style="box-sizing: border-box;">How to get new clients for your business for freelance designers ?<br fr-original-style="" style="box-sizing: border-box;">How to find work for the new graphic designer starting out in the big world?<br fr-original-style="" style="box-sizing: border-box;">How to quickly integrate into the graphic design field?<br fr-original-style="" style="box-sizing: border-box;">How to combine working from home versus working at a studio ?</p></div><div data-id="9eeb2d6" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></div></div></section><section data-id="9dd6ca4" data-element_type="section" data-settings='{"background_background":"classic"}' style="color: rgb(74, 74, 74); box-sizing: border-box;" fr-original-style=" color: rgb(74, 74, 74);"><div data-id="c7b1c39" data-element_type="column" data-settings='{"background_background":"classic"}' fr-original-style="" style="box-sizing: border-box;"><div data-id="d1226d1" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 style="color: rgb(44, 132, 238); box-sizing: border-box;" fr-original-style=" color: rgb(44, 132, 238);">Begin one-to-one online learning with your very own private tutor</h2></div></div></section><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><img src="https://images.cademy.co.uk/0832ed64-c289-46fe-8a61-ae4fb9d9c688/14e85caa-6eee-4593-8ec3-48bdfc839153/original.webp" style="width: 698px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 698px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto;" fr-original-class="fr-draggable"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); 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;"><br 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;"></p><div data-id="833cc17" data-element_type="widget" data-widget_type="heading.default" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><div data-id="833cc17" data-element_type="widget" data-widget_type="heading.default" style="color: rgb(74, 74, 74); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(74, 74, 74);"><h2 style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);">Interested?</h2></div><div data-id="63ead7e" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(12, 12, 12); box-sizing: border-box;" fr-original-style=" color: rgb(12, 12, 12);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our course is 7 months long, consisting of 1 hour 30 minutes of online one-to-one sessions. When you enrol at Blue Sky Graphics expect at least 90 minutes of class sessions and 2 &ndash; 4 hours of homework per week.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">If we accommodate the course delivery into a shorter time frame, (for e.g. over 4 months instead of 7 months the Flexi 3 doubles from &pound;265.00 to &pound;450.00 over 4 months) the instalment is billed at the delivery rate.&nbsp;</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;">The cost of traditional schooling is typically more expensive than online courses, but in the end it all comes down to how good the tutors are. With our online courses you can gain skills that are a necessity for graphic design remotely.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">That&rsquo;s right! Learn the skills needed to use Photoshop, Illustrator, InDesign and portfolio!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The online courses cost &pound;1799.00 (VAT inclusive) with no extra hidden costs and there are affordable instalment options too. Pay via debit or credit card or use a payment plan. A deposit of &pound;294.00 is required to secure your position.</p></div></div><div data-id="63ead7e" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(12, 12, 12); box-sizing: border-box;" fr-original-style=" color: rgb(12, 12, 12);"><br fr-original-style="" style="box-sizing: border-box;"></div>

Graphic Design Courses Birmingham

Graphic Design

GRAPHIC DESIGN COURSE

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>The Microsoft Security Operations Analyst collaborates with organizational stakeholders to secure information technology systems for the organization. Their goal is to reduce organizational risk by rapidly remediating active attacks in the environment, advising on improvements to threat protection practices, and referring violations of organizational policies to appropriate stakeholders. Responsibilities include threat management, monitoring, and response by using a variety of security solutions across their environment. The role primarily investigates, responds to, and hunts for threats using Microsoft Sentinel, Microsoft Defender for Cloud, Microsoft 365 Defender, and third-party security products. Since the Security Operations Analyst consumes the operational output of these tools, they are also a critical stakeholder in the configuration and deployment of these technologies.</p><p></p><p></p><p>Learn how to investigate, respond to, and hunt for threats using Microsoft Sentinel, Microsoft Defender for Cloud, and Microsoft 365 Defender. In this course you will learn how to mitigate cyberthreats using these technologies. Specifically, you will configure and use Microsoft Sentinel as well as utilize Kusto Query Language (KQL) to perform detection, analysis, and reporting. The course was designed for people who work in a Security Operations job role and helps learners prepare for the exam SC-200: Microsoft Security Operations Analyst.</p><p></p>Prerequisites<p></p><li>Basic understanding of Microsoft 365</li>  <li>Fundamental understanding of Microsoft security, compliance, and identity products</li>   <li> Intermediate understanding of Windows 10</li>  <li> Familiarity with Azure services, specifically Azure SQL Database and Azure Storage</li>   <li> Familiarity with Azure virtual machines and virtual networking</li>   <li>Basic understanding of scripting concepts.</li><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Microsoft 365 threat protection</h3> <ul> <li>Explore Extended Detection &amp; Response (XDR) response use cases</li> <li>Understand Microsoft Defender XDR in a Security Operations Center (SOC)</li> <li>Explore Microsoft Security Graph</li> <li>Investigate security incidents in Microsoft Defender XDR</li> </ul> <h3>2 - Mitigate incidents using Microsoft 365 Defender</h3> <ul> <li>Use the Microsoft Defender portal</li> <li>Manage incidents</li> <li>Investigate incidents</li> <li>Manage and investigate alerts</li> <li>Manage automated investigations</li> <li>Use the action center</li> <li>Explore advanced hunting</li> <li>Investigate Microsoft Entra sign-in logs</li> <li>Understand Microsoft Secure Score</li> <li>Analyze threat analytics</li> <li>Analyze reports</li> <li>Configure the Microsoft Defender portal</li> </ul> <h3>3 - Protect your identities with Microsoft Entra ID Protection</h3> <ul> <li>Microsoft Entra ID Protection overview</li> <li>Detect risks with Microsoft Entra ID Protection policies</li> <li>Investigate and remediate risks detected by Microsoft Entra ID Protection</li> </ul> <h3>4 - Remediate risks with Microsoft Defender for Office 365</h3> <ul> <li>Automate, investigate, and remediate</li> <li>Configure, protect, and detect</li> <li>Simulate attacks</li> </ul> <h3>5 - Safeguard your environment with Microsoft Defender for Identity</h3> <ul> <li>Configure Microsoft Defender for Identity sensors</li> <li>Review compromised accounts or data</li> <li>Integrate with other Microsoft tools</li> </ul> <h3>6 - Secure your cloud apps and services with Microsoft Defender for Cloud Apps</h3> <ul> <li>Understand the Defender for Cloud Apps Framework</li> <li>Explore your cloud apps with Cloud Discovery</li> <li>Protect your data and apps with Conditional Access App Control</li> <li>Walk through discovery and access control with Microsoft Defender for Cloud Apps</li> <li>Classify and protect sensitive information</li> <li>Detect Threats</li> </ul> <h3>7 - Respond to data loss prevention alerts using Microsoft 365</h3> <ul> <li>Describe data loss prevention alerts</li> <li>Investigate data loss prevention alerts in Microsoft Purview</li> <li>Investigate data loss prevention alerts in Microsoft Defender for Cloud Apps</li> </ul> <h3>8 - Manage insider risk in Microsoft Purview</h3> <ul> <li>Insider risk management overview</li> <li>Create and manage insider risk policies</li> <li>Investigate insider risk alerts</li> <li>Take action on insider risk alerts through cases</li> <li>Manage insider risk management forensic evidence</li> <li>Create insider risk management notice templates</li> </ul> <h3>9 - Investigate threats by using audit features in Microsoft Defender XDR and Microsoft Purview Standard</h3> <ul> <li>Explore Microsoft Purview Audit solutions</li> <li>Implement Microsoft Purview Audit (Standard)</li> <li>Start recording activity in the Unified Audit Log</li> <li>Search the Unified Audit Log (UAL)</li> <li>Export, configure, and view audit log records</li> <li>Use audit log searching to investigate common support issues</li> </ul> <h3>10 - Investigate threats using audit in Microsoft Defender XDR and Microsoft Purview (Premium)</h3> <ul> <li>Explore Microsoft Purview Audit (Premium)</li> <li>Implement Microsoft Purview Audit (Premium)</li> <li>Manage audit log retention policies</li> <li>Investigate compromised email accounts using Purview Audit (Premium)</li> </ul> <h3>11 - Investigate threats with Content search in Microsoft Purview</h3> <ul> <li>Explore Microsoft Purview eDiscovery solutions</li> <li>Create a content search</li> <li>View the search results and statistics</li> <li>Export the search results and search report</li> <li>Configure search permissions filtering</li> <li>Search for and delete email messages</li> </ul> <h3>12 - Protect against threats with Microsoft Defender for Endpoint</h3> <ul> <li>Practice security administration</li> <li>Hunt threats within your network</li> </ul> <h3>13 - Deploy the Microsoft Defender for Endpoint environment</h3> <ul> <li>Create your environment</li> <li>Understand operating systems compatibility and features</li> <li>Onboard devices</li> <li>Manage access</li> <li>Create and manage roles for role-based access control</li> <li>Configure device groups</li> <li>Configure environment advanced features</li> </ul> <h3>14 - Implement Windows security enhancements with Microsoft Defender for Endpoint</h3> <ul> <li>Understand attack surface reduction</li> <li>Enable attack surface reduction rules</li> </ul> <h3>15 - Perform device investigations in Microsoft Defender for Endpoint</h3> <ul> <li>Use the device inventory list</li> <li>Investigate the device</li> <li>Use behavioral blocking</li> <li>Detect devices with device discovery</li> </ul> <h3>16 - Perform actions on a device using Microsoft Defender for Endpoint</h3> <ul> <li>Explain device actions</li> <li>Run Microsoft Defender antivirus scan on devices</li> <li>Collect investigation package from devices</li> <li>Initiate live response session</li> </ul> <h3>17 - Perform evidence and entities investigations using Microsoft Defender for Endpoint</h3> <ul> <li>Investigate a file</li> <li>Investigate a user account</li> <li>Investigate an IP address</li> <li>Investigate a domain</li> </ul> <h3>18 - Configure and manage automation using Microsoft Defender for Endpoint</h3> <ul> <li>Configure advanced features</li> <li>Manage automation upload and folder settings</li> <li>Configure automated investigation and remediation capabilities</li> <li>Block at risk devices</li> </ul> <h3>19 - Configure for alerts and detections in Microsoft Defender for Endpoint</h3> <ul> <li>Configure advanced features</li> <li>Configure alert notifications</li> <li>Manage alert suppression</li> <li>Manage indicators</li> </ul> <h3>20 - Utilize Vulnerability Management in Microsoft Defender for Endpoint</h3> <ul> <li>Understand vulnerability management</li> <li>Explore vulnerabilities on your devices</li> <li>Manage remediation</li> </ul> <h3>21 - Plan for cloud workload protections using Microsoft Defender for Cloud</h3> <ul> <li>Explain Microsoft Defender for Cloud</li> <li>Describe Microsoft Defender for Cloud workload protections</li> <li>Enable Microsoft Defender for Cloud</li> </ul> <h3>22 - Connect Azure assets to Microsoft Defender for Cloud</h3> <ul> <li>Explore and manage your resources with asset inventory</li> <li>Configure auto provisioning</li> <li>Manual log analytics agent provisioning</li> </ul> <h3>23 - Connect non-Azure resources to Microsoft Defender for Cloud</h3> <ul> <li>Protect non-Azure resources</li> <li>Connect non-Azure machines</li> <li>Connect your AWS accounts</li> <li>Connect your GCP accounts</li> </ul> <h3>24 - Manage your cloud security posture management?</h3> <ul> <li>Explore Secure Score</li> <li>Explore Recommendations</li> <li>Measure and enforce regulatory compliance</li> <li>Understand Workbooks</li> </ul> <h3>25 - Explain cloud workload protections in Microsoft Defender for Cloud</h3> <ul> <li>Understand Microsoft Defender for servers</li> <li>Understand Microsoft Defender for App Service</li> <li>Understand Microsoft Defender for Storage</li> <li>Understand Microsoft Defender for SQL</li> <li>Understand Microsoft Defender for open-source databases</li> <li>Understand Microsoft Defender for Key Vault</li> <li>Understand Microsoft Defender for Resource Manager</li> <li>Understand Microsoft Defender for DNS</li> <li>Understand Microsoft Defender for Containers</li> <li>Understand Microsoft Defender additional protections</li> </ul> <h3>26 - Remediate security alerts using Microsoft Defender for Cloud</h3> <ul> <li>Understand security alerts</li> <li>Remediate alerts and automate responses</li> <li>Suppress alerts from Defender for Cloud</li> <li>Generate threat intelligence reports</li> <li>Respond to alerts from Azure resources</li> </ul> <h3>27 - Construct KQL statements for Microsoft Sentinel</h3> <ul> <li>Understand the Kusto Query Language statement structure</li> <li>Use the search operator</li> <li>Use the where operator</li> <li>Use the let statement</li> <li>Use the extend operator</li> <li>Use the order by operator</li> <li>Use the project operators</li> </ul> <h3>28 - Analyze query results using KQL</h3> <ul> <li>Use the summarize operator</li> <li>Use the summarize operator to filter results</li> <li>Use the summarize operator to prepare data</li> <li>Use the render operator to create visualizations</li> </ul> <h3>29 - Build multi-table statements using KQL</h3> <ul> <li>Use the union operator</li> <li>Use the join operator</li> </ul> <h3>30 - Work with data in Microsoft Sentinel using Kusto Query Language</h3> <ul> <li>Extract data from unstructured string fields</li> <li>Extract data from structured string data</li> <li>Integrate external data</li> <li>Create parsers with functions</li> </ul> <h3>31 - Introduction to Microsoft Sentinel</h3> <ul> <li>What is Microsoft Sentinel?</li> <li>How Microsoft Sentinel works</li> <li>When to use Microsoft Sentinel</li> </ul> <h3>32 - Create and manage Microsoft Sentinel workspaces</h3> <ul> <li>Plan for the Microsoft Sentinel workspace</li> <li>Create a Microsoft Sentinel workspace</li> <li>Manage workspaces across tenants using Azure Lighthouse</li> <li>Understand Microsoft Sentinel permissions and roles</li> <li>Manage Microsoft Sentinel settings</li> <li>Configure logs</li> </ul> <h3>33 - Query logs in Microsoft Sentinel</h3> <ul> <li>Query logs in the logs page</li> <li>Understand Microsoft Sentinel tables</li> <li>Understand common tables</li> <li>Understand Microsoft Defender XDR tables</li> </ul> <h3>34 - Use watchlists in Microsoft Sentinel</h3> <ul> <li>Plan for watchlists</li> <li>Create a watchlist</li> <li>Manage watchlists</li> </ul> <h3>35 - Utilize threat intelligence in Microsoft Sentinel</h3> <ul> <li>Define threat intelligence</li> <li>Manage your threat indicators</li> <li>View your threat indicators with KQL</li> </ul> <h3>36 - Connect data to Microsoft Sentinel using data connectors</h3> <ul> <li>Ingest log data with data connectors</li> <li>Understand data connector providers</li> <li>View connected hosts</li> </ul> <h3>37 - Connect Microsoft services to Microsoft Sentinel</h3> <ul> <li>Plan for Microsoft services connectors</li> <li>Connect the Microsoft Office 365 connector</li> <li>Connect the Microsoft Entra connector</li> <li>Connect the Microsoft Entra ID Protection connector</li> <li>Connect the Azure Activity connector</li> </ul> <h3>38 - Connect Microsoft Defender XDR to Microsoft Sentinel</h3> <ul> <li>Plan for Microsoft Defender XDR connectors</li> <li>Connect the Microsoft Defender XDR connector</li> <li>Connect Microsoft Defender for Cloud connector</li> <li>Connect Microsoft Defender for IoT</li> <li>Connect Microsoft Defender legacy connectors</li> </ul> <h3>39 - Connect Windows hosts to Microsoft Sentinel</h3> <ul> <li>Plan for Windows hosts security events connector</li> <li>Connect using the Windows Security Events via AMA Connector</li> <li>Connect using the Security Events via Legacy Agent Connector</li> <li>Collect Sysmon event logs</li> </ul> <h3>40 - Connect Common Event Format logs to Microsoft Sentinel</h3> <ul> <li>Plan for Common Event Format connector</li> <li>Connect your external solution using the Common Event Format connector</li> </ul> <h3>41 - Connect syslog data sources to Microsoft Sentinel</h3> <ul> <li>Plan for syslog data collection</li> <li>Collect data from Linux-based sources using syslog</li> <li>Configure the Data Collection Rule for Syslog Data Sources</li> <li>Parse syslog data with KQL</li> </ul> <h3>42 - Connect threat indicators to Microsoft Sentinel</h3> <ul> <li>Plan for threat intelligence connectors</li> <li>Connect the threat intelligence TAXII connector</li> <li>Connect the threat intelligence platforms connector</li> <li>View your threat indicators with KQL</li> </ul> <h3>43 - Threat detection with Microsoft Sentinel analytics</h3> <ul> <li>What is Microsoft Sentinel Analytics?</li> <li>Types of analytics rules</li> <li>Create an analytics rule from templates</li> <li>Create an analytics rule from wizard</li> <li>Manage analytics rules</li> </ul> <h3>44 - Automation in Microsoft Sentinel</h3> <ul> <li>Understand automation options</li> <li>Create automation rules</li> </ul> <h3>45 - Threat response with Microsoft Sentinel playbooks</h3> <ul> <li>What are Microsoft Sentinel playbooks?</li> <li>Trigger a playbook in real-time</li> <li>Run playbooks on demand</li> </ul> <h3>46 - Security incident management in Microsoft Sentinel</h3> <ul> <li>Understand incidents</li> <li>Incident evidence and entities</li> <li>Incident management</li> </ul> <h3>47 - Identify threats with Behavioral Analytics</h3> <ul> <li>Understand behavioral analytics</li> <li>Explore entities</li> <li>Display entity behavior information</li> <li>Use Anomaly detection analytical rule templates</li> </ul> <h3>48 - Data normalization in Microsoft Sentinel</h3> <ul> <li>Understand data normalization</li> <li>Use ASIM Parsers</li> <li>Understand parameterized KQL functions</li> <li>Create an ASIM Parser</li> <li>Configure Azure Monitor Data Collection Rules</li> </ul> <h3>49 - Query, visualize, and monitor data in Microsoft Sentinel</h3> <ul> <li>Monitor and visualize data</li> <li>Query data using Kusto Query Language</li> <li>Use default Microsoft Sentinel Workbooks</li> <li>Create a new Microsoft Sentinel Workbook</li> </ul> <h3>50 - Manage content in Microsoft Sentinel</h3> <ul> <li>Use solutions from the content hub</li> <li>Use repositories for deployment</li> </ul> <h3>51 - Explain threat hunting concepts in Microsoft Sentinel</h3> <ul> <li>Understand cybersecurity threat hunts</li> <li>Develop a hypothesis</li> <li>Explore MITRE ATT&amp;CK</li> </ul> <h3>52 - Threat hunting with Microsoft Sentinel</h3> <ul> <li>Explore creation and management of threat-hunting queries</li> <li>Save key findings with bookmarks</li> <li>Observe threats over time with livestream</li> </ul> <h3>53 - Use Search jobs in Microsoft Sentinel</h3> <ul> <li>Hunt with a Search Job</li> <li>Restore historical data</li> </ul> <h3>54 - Hunt for threats using notebooks in Microsoft Sentinel</h3> <ul> <li>Access Azure Sentinel data with external tools</li> <li>Hunt with notebooks</li> <li>Create a notebook</li> <li>Explore notebook code</li> </ul></div>

Microsoft Certification

Microsoft AZ-900

Microsoft AZ-104

Microsoft SC-200

Microsoft AZ-303

Microsoft AZ-700

SC-200T00 Microsoft Security Operations Analyst

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is designed for anyone seeking CCNA certification. The course also provides foundational knowledge for all support technicians involved in the basic installation, operation, and verification of Cisco networks. The job roles best suited to the material in this course are:<br />Entry-level network engineer<br />Network administrator<br />Network support technician<br />Help desk technician</p>Overview<p>This course will help you:<br />Learn the knowledge and skills to install, configure, and operate a small- to medium-sized network<br />Gain a foundation in the essentials of networking, security, and automation<br />Earn 30 CE credits toward recertification</p><p>The Implementing and Administering Cisco Solutions (CCNA) v2.0 course gives you a broad range of fundamental knowledge for all IT careers. Through a combination of lecture, hands-on labs, and self-study, you will learn how to install, operate, configure, and verify basic IPv4 and IPv6 networks. The course covers configuring network components such as switches, routers, and wireless LAN controllers; managing network devices; and identifying basic security threats. The course also gives you a foundation in network programmability, automation, and software-defined networking. This course helps you prepare to take the 200-301 CiscoÂ© Certified Network Associate (CCNAÂ©) exam. By passing this one exam, you earn the CCNA certification. This course also earns you 30 Continuing Education (CE) credits towards recertification.</p></div><div id="course-pills-2"><h4>Course Outline </h4><ul><li>Exploring the Functions of Networking ? Lecture</li><li>Introducing the Host-to-Host Communications Model ? Lecture</li><li>Operating Cisco IOS Software ? Lecture</li><li>Introducing LANs ? Lecture</li><li>Exploring the TCP/IP Link Layer ? Lecture</li><li>Starting a Switch ? Lecture</li><li>Introducing the TCP/IP Internet Layer, IPv4 Addressing, and Subnets ? Lecture</li><li>Explaining the TCP/IP Transport Layer and Application Layer ? Lecture</li><li>Exploring the Functions of Routing ? Lecture</li><li>Configuring a Cisco Router ? Lecture</li><li>Exploring the Packet Delivery Process ? Lecture</li><li>Troubleshooting a Simple Network ? Lecture</li><li>Introducing Basic IPv6 ? Lecture</li><li>Configuring Static Routing ? Lecture</li><li>Implementing VLANs and Trunks ? Lecture</li><li>Routing Between VLANs ? Lecture</li><li>Introducing OSPF ? Lecture</li><li>Building Redundant Switched Topologies ? Self-study</li><li>Improving Redundant Switched Topologies with EtherChannel ? Lecture</li><li>Exploring Layer 3 Redundancy ? Self-study</li><li>Introducing WAN Technologies ? Self-study</li><li>Explaining Basics of ACL ? Lecture</li><li>Enabling Internet Connectivity ? Lecture</li><li>Introducing QoS ? Self-study</li><li>Explaining Wireless Fundamentals ? Self-study</li><li>Introducing Architectures and Virtualization ? Self-study</li><li>Explaining the Evolution of Intelligent Networks ? Lecture</li><li>Introducing System Monitoring ? Lecture</li><li>Managing Cisco Devices ? Lecture</li><li>Examining the Security Threat Landscape ? Self-study</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Cisco Implementing and Administering Cisco Solutions v2.0 (CCNA) 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 Cisco Implementing and Administering Cisco Solutions v2.0 (CCNA) 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>

Cisco Certified Network Associate (CCNA)

Certified in Cybersecurity (CC)

Cisco Certified Network Professional certification (CCNP)

CompTIA Network+

Cisco Certified Entry Networking Technician (CCENT)

Cisco Certified Internetwork Expert (CCIE)

Cisco Implementing and Administering Cisco Solutions v2.0 (CCNA)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>The Certified Ethical Hacking v12 course will significantly benefit security officers, auditors, security professionals, site administrators, and anyone who is concerned about the integrity of the network infrastructure.</p>Overview<p>Information security controls, laws, and standards. Various types of footprinting, footprinting tools, and countermeasures. Network scanning techniques and scanning countermeasures Enumeration techniques and enumeration countermeasures Vulnerability analysis to identify security loopholes in the target organization?s network, communication infrastructure, and end systems. System hacking methodology, steganography, steganalysis attacks, and covering tracks to discover system and network vulnerabilities. Different types of malware (Trojan, Virus, worms, etc.), system auditing for malware attacks, malware analysis, and countermeasures. Packet sniffing techniques to discover network vulnerabilities and countermeasures to defend against sniffing. Social engineering techniques and how to identify theft attacks to audit human-level vulnerabilities and social engineering countermeasures. DoS/DDoS attack techniques and tools to audit a target and DoS/DDoS countermeasures. Session hijacking techniques to discover network-level session management, authentication/authorization, and cryptographic weaknesses and countermeasures. Webserver attacks and a comprehensive attack methodology to audit vulnerabilities in webserver infrastructure, and countermeasures. Web application attacks, comprehensive web application hacking methodology to audit vulnerabilities in web applications, and countermeasures. SQL injection attack techniques, injection detection tools to detect SQL injection attempts, and countermeasures. Wireless encryption, wireless hacking methodology, wireless hacking tools, and Wi-Fi security tools. Mobile platform attack vector, android vulnerability exploitations, and mobile security guidelines and tools. Firewall, IDS and honeypot evasion techniques, evasion tools and techniques to audit a network perimeter for weaknesses, and countermeasures. Cloud computing concepts (Container technology, serverless computing), the working of various threats and attacks, and security techniques and tools. Penetration testing, security audit, vulnerability assessment, and penetration testing roadmap. Threats to IoT and OT platforms and defending IoT and OT devices. Cryptography ciphers, Public Key Infrastructure (PKI), cryptography attacks, and cryptanalysis tools.</p><p>CEH provides an in-depth understanding of ethical hacking phases, various attack vectors, and preventative countermeasures. It will teach you how hackers think and act maliciously so you will be better positioned to setup your security infrastructure and defend against future attacks. An understanding of system weaknesses and vulnerabilities helps organizations strengthen their system security controls to minimize the risk of an incident. CEH was built to incorporate a hands-on environment and systematic process across each ethical hacking domain and methodology, giving you the opportunity to work towards proving the required knowledge and skills needed to achieve the CEH credential. You will be exposed to an entirely different posture toward the responsibilities and measures required to be secure. Now in its 12th version, CEH continues to evolve with the latest operating systems, tools, tactics, exploits, and technologies.</p></div><div id="course-pills-2"><h3>1 - Introduction to Ethical Hacking</h3> <ul> <li>Information Security Overview</li> <li>Cyber Kill Chain Concepts</li> <li>Hacking Concepts</li> <li>Ethical Hacking Concepts</li> <li>Information Security Controls</li> <li>Information Security Laws and Standards</li> </ul> <h3>2 - 2 - Foot-printing and Reconnaissance</h3> <ul> <li>Footprinting Concepts</li> <li>Footprinting through Search Engines</li> <li>Footprinting through Web Services</li> <li>Footprinting through Social Networking Sites</li> <li>Website Footprinting</li> <li>Email Footprinting</li> <li>Who is Footprinting</li> <li>DNS Footprinting</li> <li>Network Footprinting</li> <li>Footprinting through Social Engineering</li> <li>Footprinting Tools</li> <li>Footprinting Countermeasures</li> </ul> <h3>3 - Scanning Networks</h3> <ul> <li>Network Scanning Concepts</li> <li>Scanning Tools</li> <li>Host Discovery</li> <li>Port and Service Discovery</li> <li>OS Discovery (Banner Grabbing/OS Fingerprinting) </li><li>Scanning Beyond IDS and Firewall</li> <li>Draw Network Diagrams</li> </ul> <h3>4 - Enumeration</h3> <ul> <li>Enumeration Concepts</li> <li>NetBIOS Enumeration</li> <li>SNMP Enumeration</li> <li>LDAP Enumeration</li> <li>NTP and NFS Enumeration</li> <li>SMTP and DNS Enumeration</li> <li>Other Enumeration Techniques</li> <li>Enumeration Countermeasures</li> </ul> <h3>5 - Vulnerability Analysis</h3> <ul> <li>Vulnerability Assessment Concepts</li> <li>Vulnerability Classification and Assessment Types</li> <li>Vulnerability Assessment Solutions and Tools</li> <li>Vulnerability Assessment Reports</li> </ul> <h3>6 - System Hacking</h3> <ul> <li>System Hacking Concepts</li> <li>Gaining Access</li> <li>Escalating Privileges</li> <li>Maintaining Access</li> <li>Clearing Logs</li> </ul> <h3>7 - Malware Threats</h3> <ul> <li>Malware Concepts</li> <li>APT Concepts</li> <li>Trojan Concepts</li> <li>Virus and Worm Concepts</li> <li>Fileless Malware Concepts</li> <li>Malware Analysis</li> <li>Countermeasures</li> <li>Anti-Malware Software</li> </ul> <h3>8 - Sniffing</h3> <ul> <li>Sniffing Concepts</li> <li>Sniffing Technique: MAC Attacks</li> <li>Sniffing Technique: DHCP Attacks</li> <li>Sniffing Technique: ARP Poisoning</li> <li>Sniffing Technique: Spoofing Attacks</li> <li>Sniffing Technique: DNS Poisoning</li> <li>Sniffing Tools</li> <li>Countermeasures</li> <li>Sniffing Detection Techniques</li> </ul> <h3>9 - Social Engineering</h3> <ul> <li>Social Engineering Concepts</li> <li>Social Engineering Techniques</li> <li>Insider Threats</li> <li>Impersonation on Social Networking Sites</li> <li>Identity Theft</li> <li>Countermeasures</li> </ul> <h3>10 - Denial-of-Service</h3> <ul> <li>DoS/DDoS Concepts</li> <li>DoS/DDoS Attack Techniques</li> <li>BotnetsDDoS Case Study</li> <li>DoS/DDoS Attack Tools</li> <li>Countermeasures</li> <li>DoS/DDoS Protection Tools</li> </ul> <h3>11 - Session Hijacking</h3> <ul> <li>Session Hijacking Concepts</li> <li>Application Level Session Hijacking</li> <li>Network Level Session Hijacking</li> <li>Session Hijacking Tools</li> <li>Countermeasures</li> </ul> <h3>12 - Evading IDS, Firewalls, and Honeypots</h3> <ul> <li>IDS, IPS, Firewall, and Honeypot Concepts</li> <li>IDS, IPS, Firewall, and Honeypot Solutions</li> <li>Evading IDS</li> <li>Evading Firewalls</li> <li>IDS/Firewall Evading Tools</li> <li>Detecting Honeypots</li> <li>IDS/Firewall Evasion Countermeasures</li> </ul> <h3>13 - Hacking Web Servers</h3> <ul> <li>Web Server Concepts</li> <li>Web Server Attacks</li> <li>Web Server Attack Methodology</li> <li>Web Server Attack Tools</li> <li>Countermeasures</li> <li>Patch Management</li> <li>Web Server Security Tools</li> </ul> <h3>14 - Hacking Web Applications</h3> <ul> <li>Web Application Concepts</li> <li>Web Application Threats</li> <li>Web Application Hacking Methodology</li> <li>Web API, Webhooks, and Web Shell</li> <li>Web Application Security</li> </ul> <h3>15 - SQL Injection</h3> <ul> <li>SQL Injection Concepts</li> <li>Types of SQL Injection</li> <li>SQL Injection Methodology</li> <li>SQL Injection Tools</li> <li>Evasion Techniques</li> <li>Countermeasures</li> </ul> <h3>16 - Hacking Wireless Networks</h3> <ul> <li>Wireless Concepts</li> <li>Wireless Encryption</li> <li>Wireless Threats</li> <li>Wireless Hacking Methodology</li> <li>Wireless Hacking Tools</li> <li>Bluetooth Hacking</li> <li>Countermeasures</li> <li>Wireless Security Tools</li> </ul> <h3>17 - Hacking Mobile Platforms</h3> <ul> <li>Mobile Platform Attack Vectors</li> <li>Hacking Android OS</li> <li>Hacking iOS</li> <li>Mobile Device Management</li> <li>Mobile Security Guidelines and Tools</li> </ul> <h3>18 - IoT and OT Hacking</h3> <ul> <li>IoT Hacking</li> <li>IoT Concepts</li> <li>IoT Attacks</li> <li>IoT Hacking Methodology</li> <li>IoT Hacking Tools</li> <li>Countermeasures</li> <li>OT Hacking</li> <li>OT Concepts</li> <li>OT Attacks</li> <li>OT Hacking Methodology</li> <li>OT Hacking Tools</li> <li>Countermeasures</li> </ul> <h3>19 - Cloud Computing</h3> <ul> <li>Cloud Computing Concepts</li> <li>Container Technology</li> <li>Serverless Computing</li> <li>Cloud Computing Threats</li> <li>Cloud Hacking</li> <li>Cloud Security</li> </ul> <h3>20 - Cryptography</h3> <ul> <li>Cryptography Concepts</li> <li>Encryption Algorithms</li> <li>Cryptography Tools</li> <li>Public Key Infrastructure (PKI) </li><li>Email Encryption</li> <li>Disk Encryption</li> <li>Cryptanalysis</li> <li>Countermeasures</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans EC-Council Certified Ethical Hacker (CEH) v.12 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 EC-Council Certified Ethical Hacker (CEH) v.12 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>

Cyber Security

Certified Ethical Hacker (CEH)

Ethical Hacking

EC-Council Certified Ethical Hacker (CEH) v12

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is for experienced information technology (IT) professionals, typically described as Enterprise Desktop Administrators (EDAs). These EDAs deploy, manage, and maintain PCs, devices, and applications across medium, large, and enterprise organizations. A significant portion of this audience uses, or intends to use, the latest release of Configuration Manager to manage and deploy PCs, devices, and applications.</p>Overview<p>Describe the features Configuration Manager and Intune include, and explain how you can use these features to manage PCs and mobile devices in an enterprise environment. Analyze data by using queries and reports. Prepare a management infrastructure, including configuring boundaries, boundary groups, and resource discovery, and integrating mobile-device management with Intune. Deploy and manage the Configuration Manager client. Configure, manage, and monitor hardware and software inventory, and use Asset Intelligence and software metering. Identify and configure the most appropriate method to distribute and manage content used for deployments. Distribute, deploy, and monitor applications for managed users and systems. Maintain software updates for PCs that Configuration Manager manages. Implement Endpoint Protection for managed PCs. Configure an operating-system deployment strategy by using Configuration Manager. Manage and maintain a Configuration Manager site.</p><p>This five-day course describes how to use Configuration Manager and its associated site systems to efficiently manage network resources. In this five-day course, you will learn day-to-day management tasks, including how to manage applications, client health, hardware and software inventory, operating system deployment, and software updates by using Configuration Manager. You also will learn how to optimize Endpoint Protection, manage compliance, and create management queries and reports.  Although this course and the associated labs are written for Microsoft Endpoint Configuration Manager and Windows 11, the skills taught will also be backwards compatible with previous editions of System Center Configuration Manager and Windows 10.</p>Prerequisites<p></p><li>Networking fundamentals, including common networking protocols, topologies, hardware, media, routing, switching, and addressing.</li>  <li>Active Directory Domain Services (AD DS) principles and fundamentals of AD DS management.</li>  <li>Installation, configuration, and troubleshooting for Windows-based personal computers.</li>  <li>Basic concepts of public key infrastructure (PKI) security.</li>  <li>Basic understanding of scripting and Windows PowerShell syntax.</li>  <li>Basic understanding of Windows Server roles and services.</li>  <li>Basic understanding of the configuration options for iOS and Android Mobile device platforms.</li><p></p></div><div id="course-pills-2"><h3>1 - Managing computers and mobile devices in the enterprise</h3> <ul> <li>Overview of systems management by using enterprise management solutions</li> <li>Overview of the Configuration Manager architecture</li> <li>Overview of the Configuration Manager administrative tools</li> <li>Tools for monitoring and troubleshooting a Configuration Manager site</li> </ul> <h3>2 - Analyzing data using queries, reports, and CMPivot</h3> <ul> <li>Introduction to queries</li> <li>Configuring SQL Server Reporting Services</li> <li>Analyzing the real-time state of a device by using CMPivot</li> </ul> <h3>3 - Preparing the Configuration Manager management infrastructure</h3> <ul> <li>Configuring site boundaries and boundary groups</li> <li>Configuring resource discovery</li> <li>Organizing resources using device and user collections</li> </ul> <h3>4 - Deploying and managing the Configuration Manager client</h3> <ul> <li>Overview of the Configuration Manager client</li> <li>Deploying the Configuration Manager client</li> <li>Configuring and monitoring client status</li> <li>Managing client settings and performing management operations</li> </ul> <h3>5 - Managing inventory for PCs and applications</h3> <ul> <li>Overview of inventory collection</li> <li>Configuring hardware and software inventory</li> <li>Managing inventory collection</li> <li>Configuring software metering</li> <li>Configuring and managing Asset Intelligence</li> </ul> <h3>6 - Distributing and managing content used for deployments</h3> <ul> <li>Preparing the infrastructure for content management</li> <li>Distributing and managing content on distribution points</li> </ul> <h3>7 - Deploying and managing applications</h3> <ul> <li>Overview of application management</li> <li>Creating applications</li> <li>Deploying applications</li> <li>Managing applications</li> <li>Deploying and managing Windows apps</li> </ul> <h3>8 - Maintaining software updates for managed PCs</h3> <ul> <li>The software updates process</li> <li>Preparing a Configuration Manager site for software updates</li> <li>Managing software updates</li> <li>Configuring automatic deployment rules</li> <li>Monitoring and troubleshooting software updates</li> <li>Enabling third-party updates</li> </ul> <h3>9 - Implementing Defender Protection for managed PCs</h3> <ul> <li>Overview of Endpoint Protection in Configuration Manager</li> <li>Configuring, deploying, and monitoring Endpoint Protection policies</li> <li>Configuring and deploying advanced threat policies</li> <h3>10 - Managing compliance and secure data access</h3> <ul> <li>Overview of Compliance Settings</li> <li>Configuring compliance settings</li> <li>Viewing compliance results</li> <li>Managing resource and data access</li> <h3>11 - Managing operating system deployment</h3> <ul> <li>An overview of operating system deployment</li> <li>Preparing a site for operating system deployment</li> <li>Deploying an operating system</li> <li>Managing Windows as a service</li> <h3>12 - Managing and maintaining a Configuration Manager site</h3> <ul> <li>Configuring role-based administration</li> <li>Configuring Remote Tools</li> <li>Overview of Configuration Manager site maintenance and Management Insights</li> <li>Backing up and recovering a Configuration Manager site</li> <li>Updating the Configuration Manager infrastructure</li> <h3>13 - What?s new in Microsoft Endpoint Configuration Manager</h3> <ul> <li>Whats new in Microsoft Endpoint Manager covering each semi annual release</li> </ul></ul></ul></ul></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55348: Administering Microsoft Endpoint Configuration Manager 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 55348: Administering Microsoft Endpoint Configuration Manager 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>

Sccm

Microsoft Certified Technology Specialist (MCTS)

IT Manager

Microsoft Certified Trainer (MCT)

55348 Administering Microsoft Endpoint Configuration Manager

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Candidates for this course design, develop, secure, and troubleshoot Power Platform solutions. Candidates implement components of a solution that include application enhancements, custom user experience, system integrations, data conversions, custom process automation, and custom visualizations. Candidates will gain applied knowledge of Power Platform services, including in-depth understanding of capabilities, boundaries, and constraints.</p>Overview<p>After completing this course, students will be able to:<br />Create a technical design<br />Configure Common Data Service<br />Create and configure Power Apps<br />Configure business process automation<br />Extend the user experience<br />Extend the platform<br />Develop Integrations</p><p>The Microsoft Power Platform helps organizations optimize their operations by simplifying, automating and transforming business tasks and processes. In this course, students will learn how to build Power Apps, Automate Flows and extend the platform to complete business requirements and solve complex business problems.</p></div><div id="course-pills-2"><h4>Create a model-driven application in Power Apps</h4><ul><li>This module introduces you to creating a model-driven app in Power Apps that uses Common Data Service.</li></ul><h4>Get started using Common Data Service</h4><ul><li>This module will explain the concepts behind and benefits of Common Data Service. Creating an environment, entities, fields and options sets are also discussed.</li></ul><h4>Create a canvas app in Power Apps</h4><ul><li>This module introduces you to Power Apps, helps you create and customize an app, and then manage and distribute it. It will also show you how to provide the best app navigation, and build the best UI using themes, icons, images, personalization, different form factors, and controls.</li></ul><h4>Automate a business process using Power Automate</h4><ul><li>This module introduces you to Power Automate, teaches you how to build workflows, and how to administer flows.</li></ul><h4>Create a business process flow in Power Automate</h4><ul><li>This module introduces you to creating business process flows in Power Automate</li></ul><h4>Introduction to developing with Power Platform</h4><ul><li>This module is the first step in learning about platform, tools, and the ecosystem of the Power Platform</li></ul><h4>Extending the Power Platform user experience Model Driven apps</h4><ul><li>This module describes how to create client scripting, perform common actions with client script, and automate business process flow with client scrip. Learn about what client script can do, rules, and maintaining scripts. Discover when to use client script as well as when not to use client script.</li></ul><h4>Create components with Power Apps Component Framework</h4><ul><li>This module describes how to get started with Power Apps Component Framework with an introductory module on the core concepts and components. Then it shows you how to build a component and work with advanced Power Apps Component Framework features.</li></ul><h4>Extending the Power Platform Common Data Service</h4><ul><li>This module looks at the tools and resources needed for extending the Power Platform. We'll start with looking at the SDKs, the extensibility model, and event framework. This learning path also covers when to use plug-ins. Configuration of plug-ins as well as registering and deploying plug-ins.</li></ul><h4>Integrate with Power Platform and Common Data Service</h4><ul><li>This module describes how to integrate with Common Data Service using code by learning about Common Data Service API. Get an in-depth overview of options available with Common Data Service to integrate data and events to Azure.</li></ul><h4>Extend Power Apps portals</h4><ul><li>This module describes how to transform a content portal into a full web app interacting with Common Data Service. We will also cover the options available to customizers and developers to extend the portal functionality and integrate with Office 365, Power Platform, and Azure components.</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans PL-400T00 Microsoft Power Platform Developer 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-400T00 Microsoft Power Platform Developer 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>

Microsoft PL-900

Microsoft Power Apps

Power Apps

Microsoft Power Automate

PL-400T00 Microsoft Power Platform Developer

<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

Power Automate

AZ-040T00 Automating Administration with Powershell

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course will prepare participants to take the FC0-U61 exam to obtain the IT Fundamentals+ certification and help participants learn some of the basic principles and techniques of providing PC, mobile, applications, and network support.</p>Overview<p>On course completion, participants will be able to: - Set up a computer workstation and use basic software applications. - Explain the functions and types of devices used within a computer system. - Apply basic computer maintenance and support principles. - Describe some principles of software and database development. - Configure computers and mobile devices to connect to home networks and to the Internet. - Identify security issues affecting the use of computers and networks.</p><p>This course will prepare participants to take the FC0-U61 exam to obtain the IT Fundamentals+ certification and help participants learn some of the basic principles and techniques of providing PC, mobile, applications, and network support.</p></div><div id="course-pills-2"><h3>1 - Identifying Computer Hardware</h3> <ul> <li>Identify Types of Computing Devices</li> <li>Identify Internal Computer Components</li> <li>Common Computer Connector Types</li> <li>Identify Common Peripheral Devices</li> </ul> <h3>2 - Identifying Computer Software</h3> <ul> <li>Compare Functions and Features of Common Operating Systems</li> <li>Identify Application Software</li> </ul> <h3>3 - Setting Up a Basic Workstation</h3> <ul> <li>Connect Hardware</li> <li>Install and Configure Operating Systems</li> <li>Install and Configure Applications</li> <li>Configure Accessibility Options</li> </ul> <h3>4 - Configuring Network Access</h3> <ul> <li>Network Connection Types</li> <li>Install and Configure a SOHO Router</li> <li>Network and Alternative Technologies</li> <li>Sharing and Storage Methods</li> </ul> <h3>5 - Working with Files, Folders, and Applications</h3> <ul> <li>Create Files</li> <li>Navigate a File Structure</li> <li>Manage Files and Folders</li> <li>Compress and Extract Files</li> <li>Create Screen Captures</li> </ul> <h3>6 - Configuring and Using Wireless Devices</h3> <ul> <li>Configuring Wireless Devices</li> <li>Use Wireless Devices</li> </ul> <h3>7 - Securing Computing Devices</h3> <ul> <li>Identify Security Threats</li> <li>Apply Security Best Practices</li> <li>Perform Secure Web Browsing</li> </ul> <h3>8 - Supporting Computers and Users</h3> <ul> <li>Environmental and Safety Concepts</li> <li>Back Up and Restore Data</li> <li>Manage Software</li> <li>Implement Basic Support Measures</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans CompTIA IT Fundamentals Plus Certification (ITF Plus) (Exam FCO-U61) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the CompTIA IT Fundamentals Plus Certification (ITF Plus) (Exam FCO-U61) 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>

8878 Opera courses

Power BI - introduction (2 day) (In-House)

By The In House Training Company

H&S for FM (In-House)

By The In House Training Company

Contract and commercial management for practitioners (In-House)

By The In House Training Company

Doctor of Business Administration (DBA)

By School of Business and Technology London

Tackling Financial Corruption

By Global Risk Alliance Ltd

Tableau Desktop Training - Foundation

By Tableau Training Uk

MBA (Advanced Entry)- Inclusive of Level 7 Pathway Diploma

By School of Business and Technology London

MBA Top-Up - Inclusive of Level 7 Pathway Diploma

By School of Business and Technology London

BA (Hons) Business and Management Top-Up - Inclusive of Level 4 and 5 Pathway Diploma

By School of Business and Technology London

VBA in Excel - Part 2

By Underscore Group

Search By Location