Harpenden

<p>This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets.</p>This course will help participants:<ul><li>Create tables</li><li>Use functions</li><li>Manage rows and columns</li><li>Write formulas</li><li>Manage sheets</li><li>Use content formats</li><li>Handle larger tables</li><li>Create reports and charts</li></ul><section>
                    <h3>1 Creating a table</h3><ul><li>Creating an Excel table from scratch</li><li>Wrapping text in cells</li><li>Speeding up data entry using AutoFill</li><li>Sorting columns</li></ul> <h3>2 Inserting function</h3><ul><li>Inserting function calculators</li><li>Using AutoSum to sum numbers</li><li>Statistical calculations AVERAGE, MAX and MIN</li></ul> <h3>3 Table rows and columns</h3><ul><li>Inserting and deleting rows and columns</li><li>Adjusting multiple column widths and row heights</li><li>Hiding and unhiding rows and columns</li></ul> <h3>4 Formula writing</h3><ul><li>The basics of formula writing</li><li>Understanding mathematical symbols</li><li>Using multiple mathematical symbols in a formula</li><li>When to use brackets</li><li>Troubleshooting calculation errors</li></ul> <h3>5 Managing sheets</h3><ul><li>Inserting, renaming, moving and deleting sheets</li><li>Copying a worksheet to another file</li><li>Copying a table to another sheet</li></ul> <h3>6 Managing content formats</h3><ul><li>Applying data formats</li><li>Managing number formats</li><li>Controlling formats with the Format Painter</li></ul> <h3>7 Managing larger tables</h3><ul><li>Applying freeze panes to lock tables when scrolling</li><li>Sorting on multiple columns</li><li>Using filters to extract table information</li></ul> <h3>8 Creating and modifying charts</h3><ul><li>Creating a pie chart</li><li>Creating a column chart</li><li>Inserting chart titles and data labels</li><li>Controlling chart formatting</li><li>Changing chart types</li></ul> <h3>9 Printing</h3><ul><li>Previewing and printing tables and charts</li><li>Modifying page orientation</li><li>Adjusting print margins</li><li>Printing a selection</li></ul> <h3>10 Calculating with absolute reference</h3><ul><li>The difference between a relative and absolute formula</li><li>Changing a relative formula to an absolute</li><li>Using $ signs to lock cells when copying formulas</li></ul> <h3>11 Pivot tables</h3><ul><li>Create a pivot table report</li><li>Insert a pivot chart into a report</li></ul> 


                </section>

The In House Training Company

Office Skills & Productivity

Office Skills

Excel Analytics

Microsoft Excel

Microsoft Office

Spreadsheet

Excel - introduction (In-House)

<p>This very practical one-day IACCM-approved programme enables participants to manage the process of commercial contracting and contract management effectively and efficiently to ensure value for money, improved service, and appropriate relationships. It covers a wide range of contract types in terms of risk and value. The programme empowers participants with the tools and techniques needed to collaborate with all key stakeholders.</p>By the end of the programme participants will be able to:<ul><li>Understand the total process of managing contracts</li><li>Exploit opportunities to extract even more added value</li><li>Develop appropriate relationships with contractors</li><li>Understand and use a range of contracting strategies and options</li><li>Measure and improve contract performance</li><li>Understand the impact of legislation on contract performance</li></ul><section>
                    <h3>1 Welcome</h3><ul><li>Introductions</li><li>Aims and objectives</li><li>Plan for the day</li></ul> <h3>2 Contract management</h3><ul><li>An overview of the contracting process, mapping the 'territory'</li></ul> <h3>3 Contract managers</h3><ul><li>Skills</li><li>Knowledge</li><li>Attributes</li><li>Responsibilities</li></ul> <h3>4 Critical success factors</h3><ul><li>Defining successful outcomes</li><li>Effective stakeholder engagement</li><li>Creating a shared vision of the outcomes</li></ul> <h3>5 Placing contracts</h3><ul><li>How to develop an effective specification and scope of work documents</li><li>How to develop a robust contracting strategy</li><li>Appropriate types of contract</li></ul> <h3>6 Customers and stakeholders</h3><ul><li>Customer and stakeholder analysis</li><li>Managing expectations and the 'shared vision' concept to ensure customer co-operation, satisfaction, and delight</li></ul> <h3>7 Working with suppliers</h3><ul><li>Creating and developing commercial relationships</li><li>Types of relationship</li><li>How to manage difficult relationships</li><li>Contractor motivational issues</li><li>How to use incentives</li></ul> <h3>8 Negotiation and related skills</h3><ul><li>Introduction to key negotiation skills</li><li>Persuading and influencing skills to work with stakeholders to improve outcomes for all</li></ul> <h3>9 Dealing with change</h3><ul><li>Claims and variations</li><li>How to challenge contractor claims and requests for variations by making use of contractual terms</li><li>Specifications to prevent false claims</li></ul> <h3>10 Performance improvement</h3><ul><li>How to measure and improve contractor performance</li><li>Developing KPI systems</li><li>Using contractual terms and conditions and basic legal principles</li></ul> <h3>11 Contract close</h3><ul><li>The importance of effective contract close processes</li></ul> <h3>12 Close</h3><ul><li>Review of key learning points</li><li>Personal action planning</li></ul> 


                </section>

Introduction To Construction

Construction Management

Construction Design & Management (CDM)

Contract Management

Commercial & Contract Management Certification Program (CCM)

Institute of Leadership & Management (ILM)

Introduction to contract management (In-House)

<p>This course starts with data transformation strategies, exploring capabilities in the Power Query Editor, and data-cleansing practices. It looks at the Advanced Query Editor to view the M language code.</p><p>This course focuses on advanced DAX measures that include filtering conditions, with a deep dive into time intelligence measures. Like the M query language, DAX is a rich functional language that supports variables and expression references.</p>This course also looks at the creation of dynamic dashboards and incorporates a range of visualisations available in Power BI Desktop and online in the AppSource. The course finishes with a look at setting up end user level security in tables.<section>
                    <h3>1 The query editor</h3><ul><li>Split by row delimiter</li><li>AddDays to determine deadlines</li><li>Advanced query editor</li></ul> <h3>2 Fuzzy matching joins</h3><ul><li>Matching inconsistencies by percentage</li><li>Matching with transformation table</li></ul> <h3>3 Logical column functions</h3><ul><li>Logical functions IF, AND, OR</li><li>Using multiple conditions</li><li>Including FIND in functions</li></ul> <h3>4 Editing DAX measures</h3><ul><li>Make DAX easier to read</li><li>Add comments to a measure</li><li>Using quick measures</li></ul> <h3>5 The anatomy of CALCULATE</h3><ul><li>Understanding CALCULATE context filters</li><li>Adding context to CALCULATE with FILTER</li><li>Using CALCULATE with a threshold</li></ul> <h3>6 The ALL measure</h3><ul><li>Anatomy of ALL</li><li>Create an ALL measure</li><li>Using ALL as a filter</li><li>Use ALL for percentage</li></ul> <h3>7 DAX iterators</h3><ul><li>Anatomy of iterators</li><li>A closer look at SUMX</li><li>Using RELATED in SUMX</li><li>Create a RANKX</li><li>RANKX with ALL</li></ul> <h3>8 Date and time functions</h3><ul><li>Overview of functions</li><li>Create a DATEDIFF function</li></ul> <h3>9 Time intelligent measures</h3><ul><li>Compare historical monthly data</li><li>Create a DATEADD measure</li><li>Creating cumulative totals</li><li>Creating cumulative measures</li><li>Visualising cumulative totals</li></ul> <h3>10 Visualisations in-depth</h3><ul><li>Utilising report themes</li><li>Create a heatmap</li><li>Comparing proportions</li><li>View trends with sparklines</li><li>Group numbers using bins</li><li>Setting up a histogram</li></ul> <h3>11 Comparing variables</h3><ul><li>Visualising trendlines as KPI</li><li>Forecasting with trendlines</li><li>Creating a scatter plot</li><li>Creating dynamic labels</li><li>Customised visualisation tooltips</li><li>Export reports to SharePoint</li></ul> <h3>12 User level security</h3><ul><li>Setting up row level security</li><li>Testing user security</li></ul> 


                </section>

Powerbi

Business Analytics & Intelligence

Microsoft Power BI

Microsoft Power Platform

Microsoft BI

Power BI - advanced (1 day) (In-House)

<p>This course is designed for those already using Power BI Desktop and are ready to work with more comprehensive elements of analysing and reporting in Power BI. The course maintains a balanced look at data analysis including the Power Query Editor, with a deep dive into writing DAX formulas, and enhanced dashboard visualisations.</p>The aim of this course is to provide a more complete understanding of the whole Power BI analytics process, by working with business examples that will equip you with the necessary skills to output comprehensive reports and explore Power BI's analytical capabilities in more depth.<section>
                    <h3>1 The Query Editor</h3><ul><li>Grouping rows in a table</li><li>Split row by delimiter</li><li>Add days to determine deadlines</li><li>The query editor</li></ul> <h3>2 Fuzzy Matching Joins</h3><ul><li>Matching inconsistencies by percentage</li><li>Matching with transformation table</li></ul> <h3>3 The Query Editor M Functions</h3><ul><li>Adding custom columns</li><li>Creating an IF function</li><li>Nested AND logics in an IF function</li></ul> <h3>4 DAX New Columns Functions</h3><ul><li>Including TRUE with SWITCH</li><li>Using multiple conditions</li><li>The FIND DAX function</li><li>The IF DAX function</li><li>Logical functions IF, AND, OR</li></ul> <h3>5 Editing DAX Measures</h3><ul><li>Making DAX easier to read</li><li>Add comments to a measure</li><li>Using quick measures</li></ul> <h3>6 The Anatomy of CALCULATE</h3><ul><li>Understanding CALCULATE filters</li><li>Add context to CALCULATE with FILTER</li><li>Using CALCULATE with a threshold</li></ul> <h3>7 The ALL Measure</h3><ul><li>Anatomy of ALL</li><li>Create an ALL measure</li><li>Using ALL as a filter</li><li>Use ALL for percentages</li></ul> <h3>8 DAX Iterators</h3><ul><li>Anatomy of iterators</li><li>A closer look at SUMX</li><li>Using RELATED with SUMX</li><li>Create a RANKX</li><li>RANKX with ALL</li></ul> <h3>9 Date and Time Functions</h3><ul><li>Overview of functions</li><li>Create a DATEDIFF function</li></ul> <h3>10 Time Intelligent Measures</h3><ul><li>Compare historical monthly data</li><li>Create a DATEADD measure</li><li>Creating cumulative totals</li><li>Creating cumulative measures</li><li>Visualising cumulative totals</li></ul> <h3>11 Visualisations In-Depth</h3><ul><li>Utilising report themes</li><li>Applying static filters</li><li>Group data using lists</li><li>Group numbers using bins</li><li>Creating heatmaps</li><li>Comparing proportions</li><li>View trends with sparklines</li></ul> <h3>12 Comparing Variables</h3><ul><li>Visualising trendlines as KPI</li><li>Forecasting with trendlines</li><li>Creating a scatter plot</li><li>Creating dynamic labels</li><li>Customised visualisation tooltips</li><li>Export reports to SharePoint</li></ul> 


                </section>

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

<p>This one-day introduction workshop is intended for users who need to get to grips with the essentials of Microsoft Outlook.  It will provide you with the basic skills you need to effectively start using Outlook to manage your emails, calendar, contacts, tasks and notes.</p>This course will help participants:<ul><li>Send messages with added email options applied</li><li>Quickly file messages away for safe keeping</li><li>Manage messages and attachments</li><li>Organise calendar meetings and check other people's schedules</li><li>Respond to a meeting request</li><li>Create a contacts list</li><li>Manage daily tasks</li><li>Use reading and folder panes</li><li>Create and manage folders</li><li>Use auto reply</li><li>Use notes</li><li>Utilise Outlook's printing functionality</li></ul><section>
                    <h3>1 Getting started</h3><ul><li>Using the reading pane</li><li>Using the folder pane</li><li>Changing inbox views</li><li>Managing the to-do bar</li></ul> <h3>2 Emailing messages</h3><ul><li>Replying to and forwarding messages</li><li>Adding message options</li><li>Attaching files to an email message</li><li>Opening and saving attachments</li></ul> <h3>3 Outlook folders</h3><ul><li>Creating and managing folders</li><li>Moving messages into folders</li><li>Adding folders to favourites</li><li>Using search folder</li><li>Always moving messages in conversation</li><li>Automatically move messages with rules</li></ul> <h3>4 Managing messages</h3><ul><li>Using instant search</li><li>Finding messages by criteria</li><li>Grouping and sorting messages</li><li>Categorising messages</li><li>Adding message follow up flags</li><li>Filtering messages with the people pane</li></ul> <h3>5 Using auto reply</h3><ul><li>Replying to messages whilst you are away</li><li>Managing auto reply settings</li><li>Applying rules to auto reply</li></ul> <h3>6 Outlook calendars</h3><ul><li>Adding and editing appointments</li><li>Adding calendar reminders</li><li>Moving and copying appointments</li><li>Creating all day events</li><li>Recurring appointments</li><li>Sharing your calendar</li><li>Opening another user's calendar</li></ul> <h3>7 Planning a meeting</h3><ul><li>Arranging meetings</li><li>Inviting attendees to meetings</li><li>Responding to meeting invites</li></ul> <h3>8 Outlook contacts</h3><ul><li>Creating and editing a contact</li><li>Saving emails as contacts</li><li>Finding contacts</li><li>Sending messages to contacts</li><li>Creating contact groups</li></ul> <h3>9 Adding tasks</h3><ul><li>Creating and editing tasks</li><li>Completing tasks</li><li>Assigning a task to another user</li><li>Responding to a task request</li></ul> <h3>10 Notes</h3><ul><li>Creating and editing tasks</li><li>Emailing notes</li><li>Sticking notes on your desktop</li></ul> <h3>11 Printing</h3><ul><li>Printing messages</li><li>Printing calendars</li><li>Printing contacts</li></ul> 


                </section>

Office Management

Office Productivity

Outlook

Microsoft Outlook

Outlook - introduction (In-House)

<p>This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result.  It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared.</p>This course will help participants:<ul><li>Calculate with absolute reference</li><li>Group worksheets</li><li>Link to tables</li><li>Use the function library effectively</li><li>Get to grips with the logical IF function</li><li>Use conditional formatting</li><li>Create pivot table reports</li><li>Use data validation</li><li>Master the VLOOKUP function</li></ul><section>
                    <h3>1 Calculating with absolute reference</h3><ul><li>The difference between a relative and absolute formula</li><li>Changing a relative formula to an absolute</li><li>Using $ signs to lock cells when copying formulas</li></ul> <h3>2 Grouping worksheets</h3><ul><li>Grouping sheets together</li><li>Inputting data into multiple sheets</li><li>Writing a 3D formula to sum tables across sheets</li></ul> <h3>3 Linking to tables</h3><ul><li>Linking to a source table</li><li>Using paste link to link a table to another file</li><li>Using edit links to manage linked tables</li></ul> <h3>4 The function library</h3><ul><li>Benefits of writing formulas in the function library</li><li>Finding the right formula using insert function</li><li>Outputting statistics with COUNTA and COUNTBLANK</li><li>Counting criteria in a list with COUNTIFS</li></ul> <h3>5 Logical IF Function</h3><ul><li>Outputting results from tests</li><li>Running multiple tests for multiple results</li><li>The concept of outputting results from numbers</li></ul> <h3>6 Conditional formatting</h3><ul><li>Enabling text and numbers to standout</li><li>Applying colour to data using rules</li><li>Managing rules</li><li>Copying rules with the format painter</li></ul> <h3>7 View side by side</h3><ul><li>Comparing two Excel tables together</li><li>Comparing two sheets together in the same file</li></ul> <h3>8 Pivot table reports</h3><ul><li>Analysing data with pivot tables</li><li>Managing a pivot table's layout</li><li>Outputting statistical reports</li><li>Controlling number formats</li><li>Visualising reports with pivot charts</li><li>Inserting slicers for filtering data</li></ul> <h3>9 Data validation</h3><ul><li>Restricting data input with data validation</li><li>Speeding up data entry with data validation</li></ul> <h3>10 VLOOKUP function</h3><ul><li>Best practices for writing a VLOOKUP</li><li>A false type lookup</li><li>A true type lookup</li><li>Enhance formula results with IFNA</li></ul> <h3>11 Print options</h3><ul><li>Getting the most from print</li><li>Printing page titles across pages</li><li>Scaling content for print</li></ul> 


                </section>

Access VBA

Excel - intermediate (In-House)

<h2>Giving and Receiving Feedback: In-House</h2><p>One of the most under-rated skills of all time, the ability to give and receive feedback is a core skill required by everyone, especially those who have the responsibility for managing others.</p><p>When you are asked, &amp;'Can I give you some feedback?' what is the first thought that goes through your head? In most cases it will be &amp;'what have I done wrong?'. This is at the heart of the matter. Because we tend to associate feedback with negativity, we try to avoid it or we do it badly.</p><p>This workshop is very practical in its nature, giving participants an opportunity to practise and structure a feedback conversation that leaves them with an effective outcome.</p><h3>Learning objectives</h3><p>This workshop will help you:</p><ul><li>Build confidence in giving feedback</li><li>Identify the skills required to give and receive feedback</li><li>Appreciate the difference between observation and inference</li><li>Make your feedback specific</li><li>Deal with challenging people</li><li>Apply the &amp;'Emotional Bank Account' theory to your relationships</li><li>Practise active listening</li><li>Build rapport</li><li>Make sense of body language</li><li>Give and receive feedback</li><li>Summarise and paraphrase to ensure understanding</li></ul><section>
                    <h3>Welcome and introduction</h3><ul><li>Participants are welcomed to the programme and invited to share their personal objectives and challenging upcoming conversations</li><li>Participants are given an action plan template to complete throughout the workshop</li></ul><h3>What stops us?</h3><ul><li>How the word &amp;'feedback' creates an emotional response</li><li>Barriers facing us</li><li>Identifying key skills to give and receive feedback</li><li>Self-assessment</li></ul><h3>The conversation</h3><ul><li>Planning effectively</li><li>The other person</li><li>Why people behave the way they do</li><li>Feedback needs to be specific</li></ul><h3>Tools to support you</h3><ul><li>The Emotional Bank Account</li><li>Win-Win negotiation</li><li>11 types of non-verbal signals</li><li>Building rapport</li></ul><h3>Conflict</h3><ul><li>How do you define conflict?</li><li>Conflict styles</li><li>How to adapt to others' strategies</li><li>Emotion v Logic</li></ul><h3>Your conversation - putting it into practice</h3><ul><li>Your final preparation</li><li>Having the conversation in a 1:1 session</li><li>Getting immediate feedback</li><li>Role shift exercise</li></ul>


                </section>

Maximum Performance

Giving and Receiving Feedback: In-House

<h2>Giving and Receiving Feedback</h2><p>One of the most under-rated skills of all time, the ability to give and receive feedback is a core skill required by everyone, especially those who have the responsibility for managing others.</p><p>When you are asked, &amp;'Can I give you some feedback?' what is the first thought that goes through your head? In most cases it will be &amp;'what have I done wrong?'. This is at the heart of the matter. Because we tend to associate feedback with negativity, we try to avoid it or we do it badly.</p><p>This workshop is very practical in its nature, giving participants an opportunity to practise and structure a feedback conversation that leaves them with an effective outcome.</p><h3>Learning objectives</h3><p>This workshop will help you:</p><ul><li>Build confidence in giving feedback</li><li>Identify the skills required to give and receive feedback</li><li>Appreciate the difference between observation and inference</li><li>Make your feedback specific</li><li>Deal with challenging people</li><li>Apply the &amp;'Emotional Bank Account' theory to your relationships</li><li>Practise active listening</li><li>Build rapport</li><li>Make sense of body language</li><li>Give and receive feedback</li><li>Summarise and paraphrase to ensure understanding</li></ul><section>
                    <h3>Welcome and introduction</h3><ul><li>Participants are welcomed to the programme and invited to share their personal objectives and challenging upcoming conversations</li><li>Participants are given an action plan template to complete throughout the workshop</li></ul><h3>What stops us?</h3><ul><li>How the word &amp;'feedback' creates an emotional response</li><li>Barriers facing us</li><li>Identifying key skills to give and receive feedback</li><li>Self-assessment</li></ul><h3>The conversation</h3><ul><li>Planning effectively</li><li>The other person</li><li>Why people behave the way they do</li><li>Feedback needs to be specific</li></ul><h3>Tools to support you</h3><ul><li>The Emotional Bank Account</li><li>Win-Win negotiation</li><li>11 types of non-verbal signals</li><li>Building rapport</li></ul><h3>Conflict</h3><ul><li>How do you define conflict?</li><li>Conflict styles</li><li>How to adapt to others' strategies</li><li>Emotion v Logic</li></ul><h3>Your conversation - putting it into practice</h3><ul><li>Your final preparation</li><li>Having the conversation in a 1:1 session</li><li>Getting immediate feedback</li><li>Role shift exercise</li></ul>


                </section>

Giving and Receiving Feedback

<p>This very practical one-day programme provides participants with the skills and knowledge required to be an effective member of the procurement team and to enable them to procure a wide range of resources for the organisation, in a compliant and cost-effective manner. It also empowers them to be able to collaborate with all key stakeholders.</p>By the end of the programme participants will be able to:<ul><li>Understand the basic concepts of good procurement practice</li><li>Apply a range of tools and techniques for developing scopes of work and specifications</li><li>Apply various methods to select and evaluate suppliers</li><li>Develop robust contract award strategies</li><li>Appreciate the commercial importance of effective procurement and opportunities to reduce cost and add value</li><li>Develop appropriate procurement strategies depending on risk and value</li><li>Appreciate the legal aspects of procurement</li></ul><section>
                    <h3>1 Welcome</h3><ul><li>Introductions</li><li>Aims and objectives</li><li>Plan for the day</li></ul> <h3>2 The basics of procurement</h3><ul><li>The concept of total cost of ownership <em>v</em> price</li><li>The procurement cycle</li><li>The roles of the customer and the contractor</li><li>Impact upon profit</li></ul> <h3>3 Specification process</h3><ul><li>Importance of effective specifications</li><li>Specification development process</li><li>Types of specification</li><li>Team approach</li><li>Use of performance specifications</li><li>Early supplier involvement (ESI) / early contractor involvement (ECI)</li></ul> <h3>4 Quality</h3><ul><li>Concepts and practices</li><li>Defining 'fit for purpose'</li><li>Conformance to requirements</li><li>Compliance to standards</li><li>Role of the supplier</li><li>Quality assurance tools and techniques</li></ul> <h3>5 Procurement methods</h3><ul><li>RFP</li><li>RFQ</li><li>ITT</li><li>Negotiated procurement</li><li>Strategic partnerships</li><li>Outsourcing</li></ul> <h3>6 Tendering</h3><ul><li>How to undertake a formal tendering process</li><li>Business case to award</li><li>Critical stages in the process</li><li>Risks and benefits</li></ul> <h3>7 Tender evaluation</h3><ul><li>How to undertake a quotation analysis</li><li>Tools of analysis</li><li>Use of VFM models</li><li>Role of the customer</li><li>Comparisons around cost, quality, and delivery</li></ul> <h3>8 Supplier selection and evaluation</h3><ul><li>Developing critical selection criteria</li><li>Using the 10Cs model</li><li>Importance of effective selection process</li><li>Weighting systems</li><li>Importance of validity and evidence</li></ul> <h3>9 Capital equipment procurement</h3><ul><li>Life cycle cost issues</li><li>Payback calculations</li><li>Compatibility issues</li><li>Maintenance and training issues</li><li>After-sales support</li></ul> <h3>10 Supplier relationships</h3><ul><li>Corporate social responsibility issues</li><li>Communication</li><li>360 feed-back</li><li>Open and ethical</li><li>Initial understanding</li><li>Clear and fair terms and conditions</li></ul> <h3>11 Close</h3><ul><li>Review of key learning points</li><li>Personal action planning</li></ul> 


                </section>

Purchasing

Procurement & Supply

Procurement

Professional Skills Course (PSC)

Introduction to procurement (In-House)

<p>Do you hear yourself saying the same thing over and over again? Do you want to bring some new skills to your role? If you have been in a sales role for some time it is easy to fall into a comfortable pattern. This workshop will help you incorporate advanced techniques drawn from NLP, behavioural science and social psychology into your existing skills.</p>This course will help you:<p> </p><ul><li>Use the consultative sales process to achieve more cross-sales</li><li>Employ advanced rapport-building skills</li><li>Assess the buying preferences of a customer</li><li>Articulate the link between customer goals and needs</li><li>Identify your customer's needs and wants</li><li>Use advanced questioning techniques to gather information</li><li>Resist the temptation to tell when it would be better to ask</li><li>Identify communication preferences</li><li>Given various scenarios, present a product to the explicit need of a customer</li><li>Appreciate the impact of the language used during this stage of the sale and decide what language is appropriate with a variety of customers</li><li>Handle objections positively</li><li>Close the sale or gain commitment to further action</li></ul><section>
                    <h3>1 Introduction</h3><ul><li>Aims and objectives of the training</li><li>Personal introductions and objectives</li><li>Self-assessment of existing sales skills</li><li>Overview of content</li></ul> <h3>2 Understanding yourself and your customers</h3><ul><li>Personal communication style and what this means in a sales situation</li><li>Wants versus needs</li><li>What motivates people to buy</li><li>Using social media tools such as LinkedIn</li><li>Managing your portfolio to maximise sales</li><li>Preparing to sell</li></ul> <h3>3 The sales process</h3><ul><li>Overview of the consultative sales process</li><li>Review personal strengths and weaknesses as a salesperson</li><li>Habits of top-performing sales people</li><li>Common pitfalls</li><li>Articulate sales goals</li></ul> <h3>4 Building rapport</h3><ul><li>11 decisions that customers make in the first 9 seconds</li><li>Spotting buyer communication preferences</li><li>Building rapport with a wide variety of customers</li><li>Dealing with emotions</li><li>Keeping control</li></ul> <h3>5 Questioning and listening</h3><ul><li>Assumptions and how they trip us up</li><li>Structured questioning</li><li>Looking for cross-sales</li><li>Honing your listening skills</li><li>Identifying buyers' motivation</li><li>Using summaries to move the customer forward</li></ul> <h3>6 Presenting products and services to customers</h3><ul><li>Choosing the right time to present</li><li>Using features, advantages and benefits</li><li>Tailoring your presentation of products and services to match buyer preferences and motivations</li></ul> <h3>7 Gaining commitment</h3><ul><li>When to close</li><li>Dealing with difficult customers</li><li>5 things to avoid when handling a customer objection</li></ul> <h3>8 Managing your business</h3><ul><li>The link between service and sales</li><li>Using customer surveys</li><li>Winning back lost business</li></ul> <h3>9 Putting it all together</h3><ul><li>Skills practice</li><li>Personal learning summary and action plans</li></ul> 


                </section>

Negotiation Skills

Professional Selling Skills (PSS)

Meeting Skills

Counselling Skills

Business Communication Skills

Presentation Skills

Advanced sales skills (In-House)

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">This&nbsp;live virtual<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"> <span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">Business Agility Foundations (ICP-BAF) training &amp; certification program</span></strong>&nbsp;enables the participants to learn:</span></p><p style="margin-left: 20px; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="margin-left: 20px;"><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;">1. How to Adapt to Business Needs</strong>: Participants gain the ability to quickly adapt to changing business requirements, ensuring they can effectively respond to market changes and challenges.</span></p><p style="margin-left: 20px; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="margin-left: 20px;"><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;">2. Opportunity Identification Skills</strong>: Participants are equipped with the skills necessary to identify and leverage potential opportunities for enhancing business systems and delivering better business value.</span></p><p style="margin-left: 20px; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="margin-left: 20px;"><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;">3. Transformation of Management Models</strong>: The program provides insights on how to transform traditional management and corporate governance models into modern frameworks that prioritize agility.</span></p><p style="margin-left: 20px; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="margin-left: 20px;"><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;">4. Business Agility Mindset Building</strong>: It aims to cultivate a mindset focused on business agility, emphasizing the importance of agile principles in the context of business operations.</span></p><p style="margin-left: 20px; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="margin-left: 20px;"><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;">5. Frameworks, Tools, and Techniques</strong>: Participants are introduced to various frameworks, tools, and techniques essential for implementing and maintaining business agility within an organization.</span></p><p style="margin-left: 20px; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="margin-left: 20px;"><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;">6. Coverage of a Broad Range of Topics</strong>: The training covers a wide spectrum of topics, including Leadership, Lean System Thinking, Network Organization, Developing People, Managing Change, and Design Thinking.<br fr-original-style="" style="box-sizing: border-box;"></span></p><ul fr-original-style="" style="box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;"><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="color: rgb(243, 121, 52); box-sizing: border-box;" fr-original-style="color: rgb(243, 121, 52);">Leadership for Agility:</span> </strong>Learn to lead with flexibility, fostering an environment where innovation thrives.</span></li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;"><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="color: rgb(243, 121, 52); box-sizing: border-box;" fr-original-style="color: rgb(243, 121, 52);">Lean System Thinking:</span></strong><span style="color: rgb(243, 121, 52); box-sizing: border-box;" fr-original-style="color: rgb(243, 121, 52);"> </span>Understand how to streamline processes for maximum efficiency and value delivery.</span></li><li style="color: rgb(243, 121, 52); box-sizing: border-box;" fr-original-style="color: rgb(243, 121, 52);"><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;">Network Organization:</strong> <span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Discover how to leverage the power of networked teams and communication for enhanced collaboration and results.</span></span></li><li fr-original-style="" style="box-sizing: border-box;"><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="color: rgb(243, 121, 52); box-sizing: border-box;" fr-original-style="color: rgb(243, 121, 52);">Developing People:</span></strong><span style="color: rgb(243, 121, 52); box-sizing: border-box;" fr-original-style="color: rgb(243, 121, 52);"> </span>Focus on building and nurturing a team capable of driving and sustaining agility.</span></li><li fr-original-style="" style="box-sizing: border-box;"><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="color: rgb(243, 121, 52); box-sizing: border-box;" fr-original-style="color: rgb(243, 121, 52);">Managing Change:</span></strong><span style="color: rgb(243, 121, 52); box-sizing: border-box;" fr-original-style="color: rgb(243, 121, 52);"> </span>Master the strategies for managing change effectively, ensuring your organization remains resilient and responsive.</span></li><li fr-original-style="" style="box-sizing: border-box;"><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="color: rgb(243, 121, 52); box-sizing: border-box;" fr-original-style="color: rgb(243, 121, 52);">Design Thinking:</span></strong><span style="color: rgb(243, 121, 52); box-sizing: border-box;" fr-original-style="color: rgb(243, 121, 52);"> </span>Embrace customer-centric problem solving to create solutions that genuinely meet user needs and stand out in the market.</span></li></ul></ul><p style="margin-left: 20px; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="margin-left: 20px;"><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;">7. The Blend of Theory and Practice</strong>: Through a combination of case studies and theoretical knowledge, the program prepares participants to apply their skills as effective agility practitioners in real-world business scenarios.</span></p><p style="margin-left: 20px; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="margin-left: 20px;"><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;">8. Certification Achievement</strong>: Upon successful completion, participants are awarded the ICP-BAF certification, recognizing their understanding and capability to foster business agility.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><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="color: rgb(65, 168, 95); box-sizing: border-box;" fr-original-style="color: rgb(65, 168, 95);">Bonus Module: <em fr-original-style="" style="box-sizing: border-box;"><u fr-original-style="" style="box-sizing: border-box;">Enhancing Business Agility with AI &amp; Analytics:</u></em>&nbsp;</span></strong>This bonus section covers how artificial intelligence (AI) and analytics can boost business agility. It explains how these technologies simplify decision-making, automate tasks, and analyze data to improve agile practices. Participants will learn about the practical uses of AI and analytics in making businesses more innovative and efficient, with real-world examples from agile environments. This module offers insights into using AI and analytics to enhance the agility of businesses.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">This course will be delivered through <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">live virtual sessions via Zoom</span></strong>.&nbsp;<span style="font-size: 14px; box-sizing: border-box;" id="isPasted" fr-original-style="font-size: 14px;">There are the following dates on which you can opt for this course:</span></span></p><ol fr-original-style="" style="box-sizing: border-box;"><li style="color: rgb(44, 130, 201); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201); font-size: 14px;">Business Agility | 22-23 Apr | 9 am - 5 pm BST | Weekday | 2 days - 8 hrs/day | Best for UK / Europe</li><li style="color: rgb(44, 130, 201); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201); font-size: 14px;">Business Agility | 16-17 May | 9 am - 5 pm BST | Weekday | 2 days - 8 hrs/day | Best for UK / Europe</li><li style="color: rgb(44, 130, 201); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201); font-size: 14px;">Business Agility | 24-25 Jun | 9 am - 5 pm BST | Weekday | 2 days - 8 hrs/day | Best for UK / Europe</li><li style="color: rgb(44, 130, 201); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201); font-size: 14px;">Business Agility | 11-12 Jul | 9 am - 5 pm BST | Weekday | 2 days - 8 hrs/day | Best for UK / Europe</li><li style="color: rgb(44, 130, 201); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201); font-size: 14px;">Business Agility | 5-6 Aug | 9 am - 5 pm BST | Weekday | 2 days - 8 hrs/day | Best for UK / Europe</li><li style="color: rgb(44, 130, 201); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201); font-size: 14px;">Business Agility | 19-20 Sep | 9 am - 5 pm BST | Weekday | 2 days - 8 hrs/day | Best for UK / Europe</li><li style="color: rgb(44, 130, 201); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201); font-size: 14px;">Business Agility | 7-8 Oct | 9 am - 5 pm BST | Weekday | 2 days - 8 hrs/day | Best for UK / Europe</li><li style="color: rgb(44, 130, 201); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201); font-size: 14px;">Business Agility | 14-15 Nov | 9 am - 5 pm GMT | Weekday | 2 days - 8 hrs/day | Best for UK / Europe</li><li style="color: rgb(44, 130, 201); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201); font-size: 14px;">Business Agility | 16-17 Dec | 9 am - 5 pm GMT | Weekday | 2 days - 8 hrs/day | Best for UK / Europe</li></ol><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 14px; box-sizing: border-box;" id="isPasted" fr-original-style="font-size: 14px;"><a href="https://drive.google.com/file/d/1UNdZWuOt1Sh55xk0BPGUclog8GhCiuMm/view?usp=drive_link" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(147, 101, 184); box-sizing: border-box;" fr-original-style="color: rgb(147, 101, 184);">Click Here</span></strong></a>&nbsp;</span>or download the <span style="font-size: 14px; box-sizing: border-box;" id="isPasted" fr-original-style="font-size: 14px;"><span style="color: rgb(243, 121, 52); box-sizing: border-box;" fr-original-style="color: rgb(243, 121, 52);"><u fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">detailed course brochure</strong></u></span></span> via the following link to make an informed decision:</div><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;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);"><a href="https://drive.google.com/file/d/1UNdZWuOt1Sh55xk0BPGUclog8GhCiuMm/view?usp=drive_link" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; color: inherit; cursor: pointer; text-decoration: inherit;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">https://drive.google.com/file/d/1UNdZWuOt1Sh55xk0BPGUclog8GhCiuMm/view?usp=drive_link</span></a><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">&nbsp;</span></span></div></li></ul>

ValueX2

https://www.valuex2.com/icagile-business-agility-foundations-certification-training/
https://www.linkedin.com/company/80563537/

Business Agility Foundations (ICP-BAF) Training & Certification Program | 2 days - 8 hrs/day | 9 am - 5 pm UK Time

General Admission

<p style="color: rgb(28, 28, 28); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(28, 28, 28);">This course, worth 30 hours of verifiable CPD, will demonstrate your ability to grade and reflect upon your impression technique and demonstrate competence to take impressions unsupervised under prescription.</p><p style="color: rgb(28, 28, 28); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(28, 28, 28);"><img src="https://cavitytraining.co.uk/app/uploads/2023/11/cpdmember.png" alt="CPD member" width="162" height="149" srcset="https://cavitytraining.co.uk/app/uploads/2023/11/cpdmember.png 397w, https://cavitytraining.co.uk/app/uploads/2023/11/cpdmember-300x276.png 300w, https://cavitytraining.co.uk/app/uploads/2023/11/cpdmember-320x294.png 320w" sizes="(max-width: 162px) 100vw, 162px" 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"></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;"><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Learn about the Cavity Training Impression Taking Course</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The course is suited to nurses who aspire to treat patients directly and to take impressions or scan for impressions under the prescription of a registered dentist or clinical dental technician.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To enrol, you must be GDC-registered, work in surgery and hold indemnity insurance. (extended duties) You will need a GDC registered dental professional able and willing to supervise you.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You also need to complete an Anaphylaxis Awareness course &ndash; we offer a free CPD course for this.</p><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Frequently Asked Questions</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">How long is the course?</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The course duration is 2 to 6 months.</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;">When are the classes held?</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You will attend a live webinar class for two Saturday mornings.</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;">Is there an exam at the end?</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">There is no exam at the end, you need to successfully complete 24 assessments with your practice mentor and a complete a 500 word dissertation.</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;">What qualifications do I need to start the course?</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Preferable English and Maths level 4 and above, you must also be GDC registered.</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;">What opportunities for progression is there?</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This qualification allows candidates to further progress onto various post registration qualifications or career opportunities, such as:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">The Certificates in Orthodontic Nursing</li><li fr-original-style="" style="box-sizing: border-box;">Extending a career in prosthetics.</li><li fr-original-style="" style="box-sizing: border-box;">Training as a Lab Technician</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><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;"><article style="color: rgb(28, 28, 28); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(28, 28, 28);"><article style="color: rgb(28, 28, 28); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(28, 28, 28);"><h3 style="color: var(--color-heading-text); box-sizing: border-box;" fr-original-style=" color: var(--color-heading-text);">Course Dates</h3><ul style="color: var(--color-body-text); box-sizing: border-box;" fr-original-style=" color: var(--color-body-text);"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">13th - 27th April 2024</strong><br fr-original-style="" style="box-sizing: border-box;">9:30am - 1:30pm</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">11th - 25th May 2024</strong><br fr-original-style="" style="box-sizing: border-box;">9:30am - 1:30pm</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">8th - 22nd June 2024</strong><br fr-original-style="" style="box-sizing: border-box;">9:30am - 1:30pm</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">13th - 27th July 2024</strong><br fr-original-style="" style="box-sizing: border-box;">9:30am - 1:30pm</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">3rd - 17th August 2024</strong><br fr-original-style="" style="box-sizing: border-box;">9:30am - 1:30pm</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">7th - 21st September 2024</strong><br fr-original-style="" style="box-sizing: border-box;">9:30am - 1:30pm</li></ul></article><article style="color: rgb(28, 28, 28); box-sizing: border-box;" fr-original-style=" color: rgb(28, 28, 28);"><h3 style="color: var(--color-heading-text); box-sizing: border-box;" fr-original-style=" color: var(--color-heading-text);">Costs</h3><p style="color: var(--color-body-text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--color-body-text);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&pound;180.00 per person (inc. VAT)</strong></p><p style="color: var(--color-body-text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--color-body-text);">Please choose from one of the course dates above. Each course is 2 days. The dates above indicate the 2 days of the course.</p></article></article><article style="color: rgb(28, 28, 28); box-sizing: border-box;" fr-original-style=" color: rgb(28, 28, 28);"><br fr-original-style="" style="box-sizing: border-box;"></article>

Cavity Dental Training

Advanced Certificate in Impression Taking including Intra Oral Scanning

Fun videos to help children learn colours, develop colour recognition and spelling skills.

Music Audio Stories presents Can You See It? Learn Colours

Introducing our video series, Can You See It? Learn Colours. These videos encourage children to use their visual abilities, learn how colours are spelled, and how they look, and enjoy finding them in fun pictures. With Music Audio Story characters, sound effects, narration, music, words, fun illustrations, and animations, this series will keep children engaged throughout.

Children will:
See examples of each colour
Hear how each colour is pronounced
Learn how to spell each colour
Have fun finding the colours in pictures
Improve concentration and visual skills
Love the fun illustrations and animations
Enjoy sound effects from Music Audio Stories
Listen to rare music extracts from Music Audio Stories

-> Videos are released on Saturdays at 11 am on YouTube.

Subscribe to our channel at: https://www.youtube.com/user/MusicAudioStories and hit the bell to make sure you don't miss a new video.

Video Series Playlist: https://shorturl.at/utc30

Find out why it's important to develop colour recognition here: https://musicaudiostories.com/blog/can-you-see-it

Enjoy!

♥ 

Music Audio Stories - Making learning easy and fun!

musicaudiostories.com

----------

Subscribe to get a free music audiobook at: http://www.musicaudiostories.com/#subscribe

----------

Twitter: https://twitter.com/musicaudiostory
Instagram: https://www.instagram.com/musicaudiostories/
Facebook: https://www.facebook.com/musicaudiostories/
Storytime with Anna Christina Instagram: https://www.instagram.com/storytimewithannachristina/

Music Audio Stories

A Level English Literature

Preschool

Video

Homeschool

For Kids

Kids

Spelling

Can You See It? Video Series One - Preschool Learning 

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>The Microsoft 365 Endpoint Administrator is responsible for deploying, configuring, securing, managing, and monitoring devices and client applications in a corporate setting. Their duties include managing identity, access, policies, updates, and apps. They work alongside the M365 Enterprise Administrator to develop and execute a device strategy that aligns with the requirements of a modern organization. Microsoft 365 Endpoint Administrators should be well-versed in M365 workloads and possess extensive skills and experience in deploying, configuring, and maintaining Windows 11 and later, as well as non-Windows devices. Their role emphasizes cloud services over on-premises management technologies.</p><p></p><p></p><p>In this course, students will learn to plan and execute an endpoint deployment strategy using contemporary deployment techniques and implementing update strategies. The course introduces essential elements of modern management, co-management approaches, and Microsoft Intune integration. It covers app deployment, management of browser-based applications, and key security concepts such as authentication, identities, access, and compliance policies. Technologies like Microsoft Entra ID, Azure Information Protection, and Microsoft Defender for Endpoint are explored to protect devices and data.</p><p></p>Prerequisites<p>The Modern Desktop Administrator must be familiar with M365 workloads and must have strong skills and experience of deploying, configuring, and maintaining Windows 11 and later, and non-Windows devices.</p></div><div id="course-pills-2"><h3>1 - Explore the Enterprise Desktop</h3> <ul> <li>Examine benefits of modern management</li> <li>Examine the enterprise desktop life-cycle model</li> <li>Examine planning and purchasing</li> <li>Examine desktop deployment</li> <li>Plan an application deployment</li> <li>Plan for upgrades and retirement</li> </ul> <h3>2 - Explore Windows Editions</h3> <ul> <li>Examine Windows client editions and capabilities</li> <li>Select client edition</li> <li>Examine hardware requirements</li> </ul> <h3>3 - Understand Microsoft Entra ID</h3> <ul> <li>Examine Microsoft Entra ID</li> <li>Compare Microsoft Entra ID and Active Directory Domain Services</li> <li>Examine Microsoft Entra ID as a directory service for cloud apps</li> <li>Compare Microsoft Entra ID P1 and P2 plans</li> <li>Examine Microsoft Entra Domain Services</li> </ul> <h3>4 - Manage Microsoft Entra identities</h3> <ul> <li>Examine RBAC and user roles in Microsoft Entra ID</li> <li>Create and manage users in Microsoft Entra ID</li> <li>Create and manage groups in Microsoft Entra ID</li> <li>Manage Microsoft Entra objects with PowerShell</li> <li>Synchronize objects from AD DS to Microsoft Entra ID</li> </ul> <h3>5 - Manage device authentication</h3> <ul> <li>Describe Microsoft Entra join </li> <li>Examine Microsoft Entra join prerequisites limitations and benefits</li> <li>Join devices to Microsoft Entra ID</li> <li>Manage devices joined to Microsoft Entra ID</li> </ul> <h3>6 - Enroll devices using Microsoft Configuration Manager</h3> <ul> <li>Deploy the Microsoft Configuration Manager client</li> <li>Monitor the Microsoft Configuration Manager client</li> <li>Manage the Microsoft Configuration Manager client</li> </ul> <h3>7 - Enroll devices using Microsoft Intune</h3> <ul> <li>Manage mobile devices with Intune</li> <li>Enable mobile device management</li> <li>Explain considerations for device enrollment</li> <li>Manage corporate enrollment policy</li> <li>Enroll Windows devices in Intune</li> <li>Enroll Android devices in Intune</li> <li>Enroll iOS devices in Intune</li> <li>Explore device enrollment manager</li> <li>Monitor device enrollment</li> <li>Manage devices remotely</li> </ul> <h3>8 - Execute device profiles</h3> <ul> <li>Explore Intune device profiles</li> <li>Create device profiles</li> <li>Create a custom device profile</li> </ul> <h3>9 - Oversee device profiles</h3> <ul> <li>Monitor device profiles in Intune</li> <li>Manage device sync in Intune</li> <li>Manage devices in Intune using scripts</li> </ul> <h3>10 - Maintain user profiles</h3> <ul> <li>Examine user profile</li> <li>Explore user profile types</li> <li>Examine options for minimizing user profile size</li> <li>Deploy and configure folder redirection</li> <li>Sync user state with Enterprise State Roaming</li> <li>Configure Enterprise State Roaming in Azure</li> </ul> <h3>11 - Execute mobile application management</h3> <ul> <li>Examine mobile application management</li> <li>Examine considerations for mobile application management</li> <li>Prepare line-of-business apps for app protection policies</li> <li>Implement mobile application management policies in Intune</li> <li>Manage mobile application management policies in Intune</li> </ul> <h3>12 - Deploy and update applications</h3> <ul> <li>Deploy applications with Intune</li> <li>Add apps to Intune</li> <li>Manage Win32 apps with Intune</li> <li>Deploy applications with Configuration Manager</li> <li>Deploying applications with Group Policy</li> <li>Assign and publish software</li> <li>Explore Microsoft Store for Business</li> <li>Implement Microsoft Store Apps</li> <li>Update Microsoft Store Apps with Intune</li> <li>Assign apps to company employees</li> </ul> <h3>13 - Administer endpoint applications</h3> <ul> <li>Manage apps with Intune</li> <li>Manage Apps on non-enrolled devices</li> <li>Deploy Microsoft 365 Apps with Intune</li> <li>Additional Microsoft 365 Apps Deployment Tools</li> <li>Configure Microsoft Edge Internet Explorer mode</li> <li>App Inventory Review</li> </ul> <h3>14 - Protect identities in Microsoft Entra ID</h3> <ul> <li>Explore Windows Hello for Business</li> <li>Deploy Windows Hello</li> <li>Manage Windows Hello for Business</li> <li>Explore Microsoft Entra ID Protection</li> <li>Manage self-service password reset in Microsoft Entra ID</li> <li>Implement multi-factor authentication</li> </ul> <h3>15 - Enable organizational access</h3> <ul> <li>Enable access to organization resources</li> <li>Explore VPN types and configuration</li> <li>Explore Always On VPN</li> <li>Deploy Always On VPN</li> </ul> <h3>16 - Implement device compliance</h3> <ul> <li>Protect access to resources using Intune</li> <li>Explore device compliance policy</li> <li>Deploy a device compliance policy</li> <li>Explore conditional access</li> <li>Create conditional access policies</li> </ul> <h3>17 - Generate inventory and compliance reports</h3> <ul> <li>Report enrolled devices inventory in Intune</li> <li>Monitor and report device compliance</li> <li>Build custom Intune inventory reports</li> <li>Access Intune using Microsoft Graph API</li> </ul> <h3>18 - Deploy device data protection</h3> <ul> <li>Explore Windows Information Protection</li> <li>Plan Windows Information Protection</li> <li>Implement and use Windows Information Protection</li> <li>Explore Encrypting File System in Windows client</li> <li>Explore BitLocker</li> </ul> <h3>19 - Manage Microsoft Defender for Endpoint</h3> <ul> <li>Explore Microsoft Defender for Endpoint</li> <li>Examine key capabilities of Microsoft Defender for Endpoint</li> <li>Explore Windows Defender Application Control and Device Guard</li> <li>Explore Microsoft Defender Application Guard</li> <li>Examine Windows Defender Exploit Guard</li> <li>Explore Windows Defender System Guard</li> </ul> <h3>20 - Manage Microsoft Defender in Windows client</h3> <ul> <li>Explore Windows Security Center</li> <li>Explore Windows Defender Credential Guard</li> <li>Manage Microsoft Defender Antivirus</li> <li>Manage Windows Defender Firewall</li> <li>Explore Windows Defender Firewall with Advanced Security</li> </ul> <h3>21 - Manage Microsoft Defender for Cloud Apps</h3> <ul> <li>Explore Microsoft Defender for Cloud Apps</li> <li>Planning Microsoft Defender for Cloud Apps</li> <li>Implement Microsoft Defender for Cloud Apps</li> </ul> <h3>22 - Assess deployment readiness</h3> <ul> <li>Examine deployment guidelines</li> <li>Explore readiness tools</li> <li>Assess application compatibility</li> <li>Explore tools for application compatibility mitigation</li> <li>Prepare network and directory for deployment</li> <li>Plan a pilot</li> </ul> <h3>23 - Deploy using the Microsoft Deployment Toolkit</h3> <ul> <li>Evaluate traditional deployment methods</li> <li>Set up the Microsoft Deployment Toolkit for client deployment</li> <li>Manage and deploy images using the Microsoft Deployment Toolkit</li> </ul> <h3>24 - Deploy using Microsoft Configuration Manager</h3> <ul> <li>Explore client deployment using Configuration Manager</li> <li>Examine deployment components of Configuration Manager</li> <li>Manage client deployment using Configuration Manager</li> <li>Plan in-place upgrades using Configuration Manager</li> </ul> <h3>25 - Deploy Devices using Windows Autopilot</h3> <ul> <li>Use Autopilot for modern deployment</li> <li>Examine requirements for Windows Autopilot</li> <li>Prepare device IDs for Autopilot</li> <li>Implement device registration and out-of-the-box customization</li> <li>Examine Autopilot scenarios</li> <li>Troubleshoot Windows Autopilot</li> </ul> <h3>26 - Implement dynamic deployment methods</h3> <ul> <li>Examine subscription activation</li> <li>Deploy using provisioning packages</li> <li>Use Windows Configuration Designer</li> <li>Use Microsoft Entra join with automatic MDM enrollment</li> </ul> <h3>27 - Plan a transition to modern endpoint management</h3> <ul> <li>Explore using co-management to transition to modern endpoint management</li> <li>Examine prerequisites for co-management</li> <li>Evaluate modern management considerations</li> <li>Evaluate upgrades and migrations in modern transitioning</li> <li>Migrate data when modern transitioning</li> <li>Migrate workloads when modern transitioning</li> </ul> <h3>28 - Manage Windows 365</h3> <ul> <li>Explore Windows 365</li> <li>Configure Windows 365</li> <li>Administer Windows 365</li> </ul> <h3>29 - Manage Azure Virtual Desktop</h3> <ul> <li>Examine Azure Virtual Desktop</li> <li>Explore Azure Virtual Desktop</li> <li>Configure Azure Virtual Desktop</li> <li>Administer Azure Virtual Desktop</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans MD-102T00 : Microsoft 365 Endpoint Administrator 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 MD-102T00 : Microsoft 365 Endpoint Administrator 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

Microsoft Certification

Microsoft 365

Microsoft AZ-900

Microsoft AZ-104

Microsoft AZ-303

Microsoft AZ-700

MD-102T00 Microsoft 365 Endpoint Administrator

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is intended for existing IT professionals who have some networking knowledge and experience and are looking for a single course that provides insight into core and advanced networking technologies in Windows Server. This audience would typically include: Network administrators who are looking to reinforce existing skills and learn about new networking technology changes and functionality in Windows Server. System or Infrastructure Administrators with general networking knowledge who are looking to gain core and advanced networking knowledge and skills on Windows Server.</p>Overview<p>Plan and implement an IPv4 network. Implement Dynamic Host Configuration Protocol (DHCP). Implement IPv6. Implement Domain Name System (DNS). Implement and manage IP address management (IPAM). Plan for remote access. Implement DirectAccess. Implement virtual private networks (VPNs). Implement networking for branch offices. Configure advanced networking features. Implement Software Defined Networking.</p><p>55343A is the Community Courseware equivalent of retired Legacy Course 20741BC - Networking with Windows Server 2016. This 5-day classroom-based course provides the fundamental networking skills required to deploy and support Windows Server in most organizations. It covers IP fundamentals, remote access technologies, and more advanced content including Software Defined Networking. Although this course and the associated labs are written for Windows Server 2022, the skills taught will also be backwards compatible for Server 2016 and Server 2019.</p>Prerequisites<p>In addition to professional experience, students who attend this training should already have the following technical knowledge:  </p><li>Experience working with Windows Server  </li><li>Knowledge of the Open Systems Interconnection (OSI) model  </li><li>Understanding of core networking infrastructure components and technologies such as cabling, routers and switches  </li><li>Familiarity with networking topologies and architectures such as local area networks (LANs), wide area networks (WANs) and wireless networking  </li><li>Some basic knowledge of the TCP/IP protocol stack, addressing and name resolution  </li><li>Experience with and knowledge of virtualization  </li><li>Hands-on experience working with the Windows client operating systems such as Windows 10 or Windows 11<p></p></li></div><div id="course-pills-2"><h3>1 - Planning and implementing an IPv4 network</h3> <ul> <li>Planning IPv4 addressing</li> <li>Configuring an IPv4 host</li> <li>Managing and troubleshooting IPv4 network connectivity</li> </ul> <h3>2 - Implementing DHCP</h3> <ul> <li>Overview of the DHCP server role</li> <li>Deploying DHCP</li> <li>Managing and troubleshooting DHCP</li> </ul> <h3>3 - Implementing IPv6</h3> <ul> <li>Overview of IPv6 addressing</li> <li>Configuring an IPv6 host</li> <li>Implementing IPv6 and IPv4 coexistence</li> <li>Transitioning from IPv4 to IPv6</li> </ul> <h3>4 - Implementing DNS</h3> <ul> <li>Implementing DNS servers</li> <li>Configuring zones in DNS</li> <li>Configuring name resolution between DNS zones</li> <li>Configuring DNS integration with Active Directory Domain Services (AD DS)</li> <li>Configuring advanced DNS settings</li> </ul> <h3>5 - Implementing and managing IPAM</h3> <ul> <li>Overview of IPAM</li> <li>Deploying IPAM</li> <li>Managing IP address spaces by using IPAM</li> </ul> <h3>6 - Remote access in Windows Server</h3> <ul> <li>Overview of remote access</li> <li>Implementing the Web Application Proxy</li> </ul> <h3>7 - Implementing DirectAccess</h3> <ul> <li>Overview of DirectAccess</li> <li>Implementing DirectAccess by using the Getting Started Wizard</li> <li>Implementing and managing an advanced DirectAccess infrastructure</li> </ul> <h3>8 - Implementing VPNs</h3> <ul> <li>Planning VPNs</li> <li>Implementing VPNs</li> </ul> <h3>9 - Implementing networking for branch offices</h3> <ul> <li>Networking features and considerations for branch offices</li> <li>Implementing Distributed File System (DFS) for branch offices</li> <li>Implementing BranchCache for branch offices</li> </ul> <h3>10 - Configuring advanced networking features</h3> <ul> <li>Overview of high performance networking features</li> <li>Configuring advanced Microsoft Hyper-V networking features</li> </ul> <h3>11 - Implementing Software Defined Networking</h3> <ul> <li>Overview of SDN.</li> <li>Implementing network virtualization</li> <li>Implementing Network Controller</li> </ul></div>

CompTIA Network+

Networking Skills

Cisco Certified Entry Networking Technician (CCENT)

IT Networking Fundamentals

Computer Networking

55343 Networking with Windows Server

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p><p>Earning your SHRM Certified Professional (SHRM-CP) or SHRM Senior Certified Professional (SHRM-SCP) credential makes you a recognized expert and leader in the HR field and a valuable asset to your organization, keeping  you and your organization more competitive in today's economy. This professional distinction sets you apart from your colleagues, proving your high level of knowledge and skills. Students will be able to identify areas of strength and build on them. They will also see where they will need further concentrated study in preparation for their exam.</p></div><div id="course-pills-2"><h3>1 - INTRODUCTION</h3> <ul> <li>The SHRM Body of Competency and Knowledge? (BoCK)</li> <li>The SHRM-CP and SHRM-SCP Certifications</li> <li>The SHRM Learning SystemÂ© for SHRM-CP/SHRM-SCP</li> </ul> <h3>2 - HR COMPETENCIES</h3> <ul> <li>Behavioral Competencies</li> </ul> <h3>3 - DOMAIN 1: PEOPLE</h3> <ul> <li>Functional Area #1: HR Strategic Planning</li> <li>Functional Area #2: Talent Acquisition </li> <li>Functional Area #3: Employee Engagement and Retention </li> <li>Functional Area #4: Learning and Development</li> <li>Functional Area #5: Total Rewards</li> </ul> <h3>4 - DOMAIN 2: ORGANIZATION</h3> <ul> <li>Functional Area #6: Structure of the HR Function</li> <li>Functional Area #7: Organizational Effectiveness and Development</li> <li>Functional Area #8: Workforce Management</li> <li>Functional Area #9: Employee and Labor Relations</li> <li>Functional Area #10: Technology Management</li> </ul> <h3>5 - DOMAIN 3: WORKPLACE</h3> <ul> <li>Functional Area #11: HR in the Global Context</li> <li>Functional Area #12: Diversity and Inclusion</li> <li>Functional Area #13: Risk Management</li> <li>Functional Area #14: Corporate Social Responsibly</li> <li>Functional Area #15: U.S. Employment Law and Regulations</li> </ul> <h3>6 - FINAL EXAM/REVIEW/DISCUSSION</h3></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans SHRM-CP/SHRM-SCP Certification Preparation 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 SHRM-CP/SHRM-SCP Certification Preparation 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>

Clifton Practice Hypnotherapy Training (CPHT)

Chartered Institute of Personnel Development (CIPD)

Certified Payroll Professional (CPP)

Certified Supply Chain Professional (CSCP)

Scrum Master Professional Certificate (SMPC)

SHRM-CP/SHRM-SCP Certification Preparation

<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>This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills.</p>Overview<p>Create single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queries</p><p>This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling.</p>Prerequisites<p></p><ul> <li>Basic understanding of relational databases.</li> <li>Basic Windows knowledge.</li> </ul><p></p></div><div id="course-pills-2"><h3>Module 1: Introduction to Transact-SQL</h3><ul> <li>What is Transact-SQL</li> <li>The SELECT statement</li> <li>The WHERE clause</li> <li>Sorting results</li> <li>Calculations</li> <li>CASE expressions</li> </ul>   <h3>Module 2: Joining tables with Transact-SQL</h3><ul> <li>The JOIN clause</li> <li>Inner joins</li> <li>Outer joins</li> <li>Self joins and cross joins</li> </ul>  <h3>Module 3: Filtering and sorting results</h3><ul> <li>Implement the ORDER BY clause</li> <li>Filter data with the WHERE clause</li> <li>Limit the number of rows returned by a query</li> <li>Implement NULL logic</li> </ul>  <h3>Module 4: SQL Server data types</h3><ul> <li>Understand data types</li> <li>Implement string data types</li> <li>Implement temporal data types</li> </ul>  <h3>Module 5: Inserting, updating and deleting data</h3><ul> <li>Insert new records</li> <li>Update existing records</li> <li>Delete data</li> </ul>   <h3>Module 6: Using SQL Server functions with Transact-SQL</h3><ul> <li>Understand function types in SQL Server</li> <li>Convert data using functions</li> <li>Implement logical functions</li> <li>Work with NULL data using functions</li> </ul>  <h3>Module 7: Aggregating data with Transact-SQL</h3><ul> <li>Implement aggregation in SQL Server</li> <li>Group records in SQL Server</li> <li>Filter aggregated data</li> </ul>   <h3>Module 8: Implement subqueries with Transact-SQL</h3><ul> <li>Implement scalar and multi-valued sub-queries</li> <li>Implement correlated subqueries</li> <li>Implement existence checks with subqueries</li> </ul>   <h3>Module 9: Create queries that use table expressions</h3><ul> <li>Create views</li> <li>Create table-valued functions</li> <li>Implement derived tables</li> <li>Implement common table expressions</li> </ul>  <h3>Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data</h3><ul> <li>Write queries with the UNION operator</li> <li>Write queries with the INTERSECT and EXCEPT operators</li> <li>Write queries with the APPLY operator</li> </ul>    <h3>Module 11: Implement window functions in queries</h3><ul> <li>Understand window functions</li> <li>Impement window functions</li> </ul>    <h3>Module 12: Use PIVOT and grouping sets in queries</h3><ul> <li>Implement PIVOT in queries</li> <li>Implement grouping sets in queries</li> </ul>   <h3>Module 13: Use stored procedures in queries</h3><ul> <li>Query data with stored procedures</li> <li>Interact with stored procedures using input and output parameters</li> <li>Write simple stored procedures</li> <li>Pass dynamic SQL to SQL Server</li> </ul>    <h3>Module 14: Implement programming features in Transact-SQL</h3><ul> <li>Understand T-SQL programming elements</li> <li>Implement loops and conditions in T-SQL queries</li> </ul>   <h3>Module 15: Add error handling to queries</h3><ul> <li>Understand SQL Server error handling</li> <li>Implemet structured exception handling</li> </ul>   <h3>Module 16: Use transactions in queries</h3><ul> <li>Understand database transactions</li> <li>Implement transactions in T-SQL</li> </ul></div>

Computing Skills

Microsoft SQL

Data Skills

SQL Server

Trainers Course

55366 Querying Data with Transact-SQL

<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 people who are seeking to launch a career in cybersecurity.</p>Overview<p>Assess the security posture of an enterprise environment and recommend and implement appropriate security solutions; Monitor and secure hybrid environments, including cloud, mobile, and IoT; Operate with an awareness of applicable laws and policies, including principles of governance, risk, and compliance; Identify, analyze, and respond to security events and incidents.</p><p>CompTIA Security+ is a global certification that validates the baseline skills necessary to perform core security functions and is the first security certification a candidate should earn.<br /> <br /> CompTIA Security+ establishes the core knowledge required of any cybersecurity role and provides a springboard to intermediate-level cybersecurity jobs.</p></div><div id="course-pills-2"><h3>Lesson 1: Summarize Fundamental Security Concepts</h3> <ul> <li>Security Concepts</li> <li>Security Controls</li> </ul> <h3>Lesson 2: Compare Threat Types</h3> <ul> <li>Threat Actors</li> <li>Attack Surfaces</li> <li>Social Engineering</li> </ul> <h3>Lesson 3: Explain Cryptographic Solutions</h3> <ul> <li>Cryptographic Algorithms</li> <li>Public Key Infrastructure</li> <li>Cryptographic Solutions</li> </ul> <h3>Lesson 4: Implement Identity and Access Management</h3> <ul> <li>Authentication</li> <li>Authorization</li> <li>Identity Management</li> </ul> <h3>Lesson 5: Secure Enterprise Network Architecture</h3> <ul> <li>Enterprise Network Architecture</li> <li>Network Security Appliances</li> <li>Secure Communications</li> </ul> <h3>Lesson 6: Secure Cloud Network Architecture</h3> <ul> <li>Cloud Infrastructure</li> <li>Embedded Systems and Zero Trust Architecture</li> </ul> <h3>Lesson 7: Explain Resiliency and Site Security Concepts</h3> <ul> <li>Asset Management</li> <li>Redundancy Strategies</li> <li>Physical Security</li> </ul> <h3>Lesson 8: Explain Vulnerability Management</h3> <ul> <li>Device and OS Vulnerabilities</li> <li>Application and Cloud Vulnerabilities</li> <li>Vulnerability Identification Methods</li> <li>Vulnerability Analysis and Remediation</li> </ul> <h3>Lesson 9: Evaluate Network Security Capabilities</h3> <ul> <li>Network Security Baselines</li> <li>Network Security Capability Enhancement</li> </ul> <h3>Lesson 10: Assess Endpoint Security Capabilities</h3> <ul> <li>Implement Endpoint Security</li> <li>Mobile Device Hardening</li> </ul> <h3>Lesson 11: Enhance Application Security Capabilities</h3> <ul> <li>Application Protocol Security Baselines</li> <li>Cloud and Web Application Security Concepts</li> </ul> <h3>Lesson 12: Explain Incident Response and Monitoring Concepts</h3> <ul> <li>Incident Response</li> <li>Digital Forensics</li> <li>Data Sources</li> <li>Alerting and Monitoring Tools</li> </ul> <h3>Lesson 13: Analyze Indicators of Malicious Activity</h3> <ul> <li>Malware Attack Indicators</li> <li>Physical and Network Attack Indicators</li> <li>Application Attack Indicators</li> </ul> <h3>Lesson 14: Summarize Security Governance Concepts</h3> <ul> <li>Policies, Standards, and Procedures</li> <li>Change Management</li> <li>Automation and Orchestration</li> </ul> <h3>Lesson 15: Explain Risk Management Processes</h3> <ul> <li>Risk Management Processes and Concepts</li> <li>Vendor Management Concepts</li> <li>Audits and Assessments</li> </ul> <h3>Lesson 16: Summarize Data Protection and Compliance Concepts</h3> <ul> <li>Data Classification and Compliance</li> <li>Personnel Policies</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans CompTIA Security Plus Certification (Exam SY0-601) 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 Security Plus Certification (Exam SY0-601) 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>

Certified in Cybersecurity (CC)

Certificate in Information Security Management Principles (CISMP)

Certified Cyber Professional (CCP)

CompTIA A+

CompTIA Security+

<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 IT professionals who wish to develop cloud computing skills to enable them to move IT workloads to the cloud and integrate products and services from different providers and industries. Their focus is to ensure that cloud deployments are secure, that automation and orchestration are used effectively to bring business value from the cloud, and that costs are controlled through effective management of cloud vendors.   This course is also designed for students who are preparing to take the CompTIA Cloud+ certification exam CV0-003, or who plan to use Cloud+ as the foundation for more advanced cloud certifications or career roles.</p>Overview<p>In this course, you will deploy, test, secure, manage, optimize, and troubleshoot a cloud solution.   You will:  - Prepare to deploy cloud solutions  - Deploy a pilot project  - Test a pilot project deployment  - Design a secure network for cloud deployment  - Determine CPU and memory sizing for cloud deployments  - Determine storage requirements for cloud deployments  - Plan Identity and Access Management for cloud deployments  - Analyze workload characteristics to ensure successful migration to the cloud  - Secure systems to meet access requirements  - Maintain cloud systems  - Implement backup, restore, and business continuity measures  - Analyze cloud systems for required performance  - Analyze cloud systems for anomalies and growth forecasting  - Troubleshoot deployment, capacity, automation, and orchestration issues  - Troubleshoot connectivity issues  - Troubleshoot security issues</p><p>In this course, you will learn how to implement, maintain, and deliver cloud technologies including network, storage, and virtualization technologies to create cloud solutions.</p></div><div id="course-pills-2"><h3>1 - PREPARING TO DEPLOY CLOUD SOLUTIONS</h3> <ul> <li>Describe Interaction of Cloud Components and Services</li> <li>Describe Interaction of Non-cloud Components and Services</li> <li>Evaluate Existing Components and Services for Cloud Deployment</li> <li>Evaluate Automation and Orchestration Options</li> <li>Prepare for Cloud Deployment</li> </ul> <h3>2 - DEPLOYING A PILOT PROJECT</h3> <ul> <li>Manage Change in a Pilot Project</li> <li>Execute Cloud Deployment Workflow</li> <li>Complete Post-Deployment Configuration</li> </ul> <h3>3 - TESTING PILOT PROJECT DEPLOYMENTS</h3> <ul> <li>Identify Cloud Service Components for Testing</li> <li>Test for High Availability and Accessibility</li> <li>Perform Deployment Load Testing</li> <li>Analyze Test Results</li> </ul> <h3>4 - DESIGNING A SECURE AND COMPLIANT CLOUD INFRASTRUCTURE</h3> <ul> <li>Design Cloud Infrastructure for Security</li> <li>Determine Organizational Compliance Needs</li> </ul> <h3>5 - DESIGNING AND IMPLEMENTING A SECURE CLOUD ENVIRONMENT</h3> <ul> <li>Design Virtual Network for Cloud Deployment</li> <li>Determine Network Access Requirements</li> <li>Secure Networks for Cloud Interaction</li> <li>Manage Cloud Component Security</li> <li>Implement Security Technologies</li> </ul> <h3>6 - PLANNING IDENTITY AND ACCESS MANAGEMENT FOR CLOUD DEPLOYMENTS</h3> <ul> <li>Determine Identity Management and Authentication Technologies</li> <li>Plan Account Management Policies for the Network and Systems</li> <li>Control Access to Cloud Objects</li> <li>Provision Accounts</li> </ul> <h3>7 - DETERMINING CPU AND MEMORY SIZING FOR CLOUD DEPLOYMENTS</h3> <ul> <li>Determine CPU Size for Cloud Deployment</li> <li>Determine Memory Size for Cloud Deployment</li> </ul> <h3>8 - DETERMINING STORAGE REQUIREMENTS FOR CLOUD DEPLOYMENTS</h3> <ul> <li>Determine Storage Technology Requirements</li> <li>Select Storage Options for Deployment</li> <li>Determine Storage Access and Provisioning Requirements</li> <li>Determine Storage Security Options</li> </ul> <h3>9 - ANALYZING WORKLOAD CHARACTERISTICS TO ENSURE SUCCESSFUL MIGRATION</h3> <ul> <li>Determine the Type of Cloud Deployment to Perform</li> <li>Manage Virtual Machine and Container Migration</li> <li>Manage Network, Storage, and Data Migration</li> </ul> <h3>10 - MAINTAINING CLOUD SYSTEMS</h3> <ul> <li>Patch Cloud Systems</li> <li>Design and Implement Automation and Orchestration for Maintenance</li> </ul> <h3>11 - IMPLEMENTING BACKUP, RESTORE, DISASTER RECOVERY, AND BUSINESS CONTINUITY MEASURES</h3> <ul> <li>Back Up and Restore Cloud Data</li> <li>Implement Disaster Recovery Plans</li> <li>Implement Business Continuity Plans</li> </ul> <h3>12 - ANALYZING CLOUD SYSTEMS FOR PERFORMANCE</h3> <ul> <li>Monitor Cloud Systems to Measure Performance</li> <li>Optimize Cloud Systems to Meet Performance Criteria</li> </ul> <h3>13 - ANALYZING CLOUD SYSTEMS FOR ANOMALIES AND GROWTH FORECASTING</h3> <ul> <li>Monitor for Anomalies and Resource Needs</li> <li>Plan for Capacity</li> <li>Create Reports on Cloud System Metrics</li> </ul> <h3>14 - TROUBLESHOOTING DEPLOYMENT, CAPACITY, AUTOMATION, AND ORCHESTRATION ISSUES</h3> <ul> <li>Troubleshoot Deployment Issues</li> <li>Troubleshoot Capacity Issues</li> <li>Troubleshoot Automation and Orchestration Issues</li> </ul> <h3>15 - TROUBLESHOOTING CONNECTIVITY ISSUES</h3> <ul> <li>Identify Connectivity Issues</li> <li>Troubleshoot Connectivity Issues</li> </ul> <h3>16 - TROUBLESHOOTING SECURITY ISSUES</h3> <ul> <li>Troubleshoot Identity and Access Issues</li> <li>Troubleshoot Attacks</li> <li>Troubleshoot Other Security Issues</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans CompTIA Cloud Plus Certification (Exam CV0-003) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the CompTIA Cloud Plus Certification (Exam CV0-003) 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>

Cloud Architecture

Certified Cloud Security Professional (CCSP)

AWS Certified Cloud Practitioner

CompTIA Cloud+

63 Courses in Leicester

Excel - introduction (In-House)

By The In House Training Company

Introduction to contract management (In-House)

By The In House Training Company

Power BI - advanced (1 day) (In-House)

By The In House Training Company

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

By The In House Training Company

Outlook - introduction (In-House)

By The In House Training Company

Excel - intermediate (In-House)

By The In House Training Company

Giving and Receiving Feedback: In-House

By Maximum Performance

Giving and Receiving Feedback

By Maximum Performance

Introduction to procurement (In-House)

By The In House Training Company

Advanced sales skills (In-House)

By The In House Training Company

Search By Location