Name: Microsoft Excel Advanced - In-company
Price: 650 GBP
Availability: InStock

Wakefield

<section data-element_type="section" data-id="141278d" fr-original-style=" color: rgb(102, 102, 102);" id="isPasted" style="color: rgb(102, 102, 102); box-sizing: border-box;"><div data-element_type="column" data-id="e6dbe55" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="2d2bccd" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><section data-element_type="section" data-id="2aa0345" fr-original-style=" color: rgb(102, 102, 102);" id="isPasted" style="color: rgb(102, 102, 102); box-sizing: border-box;"><div data-element_type="column" data-id="1938d5f" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="f368761" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><section data-element_type="section" data-id="a40907e" fr-original-style="" id="isPasted" style="box-sizing: border-box;"><div data-element_type="column" data-id="80d9f93" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="d499d73" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 fr-original-style=" color: var( --e-global-color-primary );" style="color: var( --e-global-color-primary ); box-sizing: border-box;">Overview</h2></div></div></section><section data-element_type="section" data-id="699d259" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="column" data-id="4cfd84c" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="32c6b5e" data-widget_type="text-editor.default" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">This one day&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Building Better Work Habits</strong> training course has been developed for everyone in your organisation who may struggle with their own personal effectiveness. They may not have control of their own workload or blame others as to why they&rsquo;re not achieving certain tasks and projects. Alternatively, it might be that high performers want to understand how they can organise themselves in a new way to give themselves more stretch in their roles.</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">The training course will help the learners build self-awareness and will highlight the important parts of working smarter to achieve end goals.</p></div></div></section><section data-element_type="section" data-id="cf3e46f" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="column" data-id="9f8bc76" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="5a51812" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 fr-original-style=" color: var( --e-global-color-primary );" style="color: var( --e-global-color-primary ); box-sizing: border-box;">Description</h2></div></div></section><section data-element_type="section" data-id="649d69e" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="column" data-id="941a4e4" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="fd58605" data-widget_type="text-editor.default" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">We are all busy, and sometimes it seems we do not have enough hours in the day to complete deadlines and projects. It can then eat into our home life, meaning we often end up stressed, or in worst-case scenarios, unwell (both physically and mentally). The reason behind this is often how we work day to day, as opposed to others giving us work at the last minute.</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">These training course materials have been designed to help your participants work more effectively for the long term. This isn&rsquo;t about how to manage a diary or emails, but rather look closely to see what are the blockers which get in the way of success. These small changes in day to day work will have a dramatic impact in both productivity and personal effectiveness.</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">Topics covered:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Productivity: the science bit&nbsp;</strong>&ndash; A chance to explore what we mean by being productive and how that helps us build better work habits, as well as the opportunity to look at some of the science behind myths and bad habits we&rsquo;ve probably already formed. Includes a link to a YouTube video.</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Procrastination, why put off to tomorrow what we can do today!&nbsp;</strong>&ndash; Participants will explore what we procrastinate about, how we procrastinate in our own lives, and what we can do about it!</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Eat That Frog&nbsp;</strong>&ndash; An introduction to Brian Tracy&rsquo;s book &ldquo;Eat that frog&rdquo; and how it can help us improve our working habits. Includes a link to a YouTube video.</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Eat That Frog: Thinking on Paper&nbsp;</strong>&ndash; A chance to put into practice some of Brian Tracy&rsquo;s methods and how to use them in our real lives</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Eat That Frog: Rocks, Pebbles and Sand</strong> &ndash; Taking our goal setting further, we explore Covey&rsquo;s methodology around prioritising our tasks.</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Eat That Frog: The Pareto Principle</strong>&nbsp;&ndash; The final part of the &ldquo;Eat that Frog&rdquo; section looks at how effective we in terms of how we spend our day</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Prioritising: how do we spend our day?</strong>&nbsp;&ndash; Participants explore how proactive they are, and what the danger might be in letting a situation rule their time</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Prioritising: The Priority Matrix</strong>&nbsp;&ndash; Taking the Rock, Pebbles and Sand methodology further, participants explore what truly is urgent and what is important in our day to day</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Prioritising: Company Performance Tensions</strong>&nbsp;&ndash; We may know what our own personal objectives are, however, our business objectives have certain tensions that could impact these. How can we balance these two different objectives to ensure we&rsquo;re successful day to day?</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What&rsquo;s my mindset?</strong>&nbsp;&ndash; Sometimes we can get in the way of our own successes and plans due to our mindset; utilising Carol Dweck&rsquo;s work, it is a chance to reflect on our own mindsets when we&rsquo;re building new work habits. Includes a link to a YouTube video.</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What&rsquo;s my mindset? Energy Cycles</strong>&nbsp;&ndash; Our energy can impact our mindset and how productive we are. A chance to look at what gives us energy, and how we can work more effectively depending on where our energy levels might be</li></ul></div></div></section><section data-element_type="section" data-id="8b42a41" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="column" data-id="6be2803" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="f08ab9c" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 fr-original-style=" color: var( --e-global-color-primary );" style="color: var( --e-global-color-primary ); box-sizing: border-box;">Who should attend</h2></div></div></section><section data-element_type="section" data-id="b209fea" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="column" data-id="ce601c1" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="e88578c" data-widget_type="text-editor.default" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">Anyone interested in understanding in being more effective at work.</p></div></div></section><section data-element_type="section" data-id="c7c52a5" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="column" data-id="68fd8e5" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="cae9269" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 fr-original-style=" color: var( --e-global-color-primary );" style="color: var( --e-global-color-primary ); box-sizing: border-box;">Requirements for Attendees</h2></div></div></section><section data-element_type="section" data-id="ac22cd1" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="column" data-id="28a3b4e" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="02734e3" data-widget_type="text-editor.default" fr-original-style=" color: rgb(102, 102, 102);" style="color: rgb(102, 102, 102); box-sizing: border-box;"><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">None.</p></div><div data-element_type="widget" data-id="0b11949" data-widget_type="button.default" fr-original-style=" color: rgb(102, 102, 102);" style="color: rgb(102, 102, 102); box-sizing: border-box;"><a fr-original-style=" color: rgb(255, 255, 255);" href="mailto:sales@18.132.1.174?subject=%27Building%20Better%20Work%20Habits%27%20Training%20Course" style="color: rgb(255, 255, 255); user-select: auto; box-sizing: border-box; text-decoration: inherit; cursor: pointer;"><br fr-original-style="" style="box-sizing: border-box;">
</a></div></div></section></div></div></section></div></div></section><section data-element_type="section" data-id="f9cb5f1" fr-original-style=" color: rgb(102, 102, 102);" style="color: rgb(102, 102, 102); box-sizing: border-box;"><div data-element_type="column" data-id="bda27b8" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div></section>

Inovra Group

Business Development

Professional Development

Building Better Work Habits

Session for up to ten delegates in a single session

Group Session

London

<h2>Business Relationship Management Fundamentals: In-House Training</h2>
<p>Business Relationship Management (BRM) Fundamentals introduces BRM as a capability, role, and discipline.</p><h3>What you will Learn</h3>
<p>Participants can expect an interactive and lively one-day session, with a high-level introduction to successfully navigate the complexity of BRM. Topics include:</p>
<ul>
<li>Defining BRM as a capability, role, and discipline</li>
<li>Understanding what a BRM does and does not do</li>
<li>Providing the language needed to change perceptions and perspectives</li>
<li>Learn how the BRM discipline interacts with other disciplines (project management, architecture, Business Analysts, Business functions, strategy, etc.) inside an organization</li>
<li>Basic introduction to the different frameworks, processes, and models to bring structure and guidance to BRM</li>
</ul><section>
                    <ul><li>Introductions</li><li>Why BRM?</li><li>BRM defined</li><li>BRM in action</li><li>BRM value</li><li>Reflection and next steps</li><li>Resources</li></ul>


                </section>

IIL Europe Ltd

Business Relationship Management Fundamentals: In-House Training

General Admission

<p>This 1 day course is designed for the end user who is using or will use Office 365. This course will provide delegates with the knowledge and skills to efficiently use Office 365 on a day-to-day basis. The course is designed with real world scenarios in mind. Delegates will learn how to use Outlook Online, Skype for Business, OneDrive for Business, SharePoint Online, and OneNote. At the end of this course delegates will be able to effectively navigate Office 365 and make use of all of the features of Office 365</p><p><strong>Office 365 Overview</strong></p> <ul> <li>Introducing Cloud Computing</li><li>Identify and Outline the Component Products in Office 365 including Outlook Web App, Office Online Apps, OneDrive and Skype for Business</li><li>Navigating around Office 365</li><li>Customising the Office 365 Nav Bar</li><li>Updating your Profile in Office 365</li></ul> <p><strong>Using the Outlook Online Application</strong></p> <ul> <li>Overview of Outlook Online</li><li>Working with Email and Folders</li><li>Outlook People and IM Contacts</li><li>Using the Calendar</li><li>Shared Calendars</li><li>Outlook Tasks in the Web App</li><li>Setting Outlook Options, Signatures, Automatic Replies and Rules</li></ul> <p><strong>Using Skype for Business</strong></p> <ul> <li>Overview of Skype for Business</li><li>Viewing and Setting Presence Status</li><li>Using Instant Messages in Business</li><li>Understanding the Interactive Contact Card in Microsoft Office Applications</li><li>Integration with Outlook</li><li>Using Skype for Business for Online Presentations including Content Sharing, Polls and a Virtual Whiteboard</li></ul> <p><strong>Working with OneDrive for Business</strong></p> <ul> <li>What is OneDrive for Business?</li><li>Navigating around OneDrive</li><li>Accessing Content in OneDrive</li><li>Using the Office Online Apps</li><li>Sharing Documents and Collaborating</li><li>Connecting Microsoft Office to OneDrive</li><li>Creating Office Documents and Saving Directly to OneDrive</li></ul> <p><strong>Using Groups and Delve</strong></p> <ul> <li>Introduction to Groups</li><li>Collaborating using Groups</li><li>Getting to Content using Delve</li></ul><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>Before attending this course, students must have:</p> <ul> <li>Basic understanding of Microsoft Office</li><li>Basic understanding of Microsoft Windows Operating systems</li></ul> 
                        </div>

Microsoft Office Training

Microsoft Office 365 for End Users In-Company (now with live online classes)

<p><strong>Course Objectives</strong></p><p>At the end of this course you will be able to:</p><ul><li>Identify the components of the Microsoft Project environment</li><li>Create a new project plan</li><li>Create the project schedule</li><li>Use different views to analyse the project plan</li><li>Create, allocate and manage resources in a project plan</li><li>Finalise a project plan</li><li>Track progress</li><li>View and report project plan information</li></ul><p>' 1 year email support service</p><p><em><strong>Customer Feedback</strong></em></p><ul><li><p><strong>Very good course. Learnt a lot. Looking forward to the next level.</strong></p></li><li>Alexandra - CIAL</li></ul><p>'</p><p>1 year email support service</p><p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p><ul><li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul><p><strong><strong>Tailored training courses:</strong></strong></p><p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p><strong>Introduction to Microsoft Project</strong></p><ul><li>Recap on project management concepts</li><li>Project environment overview</li><li>The 3 databases: Tasks, Resources and Assignments</li><li>Different ways of displaying the Project Plan</li><li>Access Help</li></ul><p><strong>Creating a Project Plan</strong></p><ul><li>Create a New Project Plan</li><li>Project Information</li><li>Create and apply the project calendar</li><li>Defining recurring exceptions to the calendar</li><li>Defining the calendar's work weeks</li><li>Create the Summary tasks</li><li>Create the Work Breakdown Structure</li></ul><p><strong>Task creation and scheduling</strong></p><ul><li>Exploring the Entry Table and its fields</li><li>Task editing and the Task Information window</li><li>Task Durations</li><li>Defining Milestones</li><li>Manual Scheduling vs Automatic Scheduling</li><li>Changing the Task's Calendar</li><li>Create a split in a Task</li><li>Create Task Relationships</li><li>Adding Lag or Lead to a Relationship</li><li>Identifying the Critical Path</li><li>Adding Constraints and Deadlines to Tasks</li><li>Create Recurring Activities</li><li>Adding Notes and links to Tasks</li></ul><p><strong>Managing Resources</strong></p><ul><li>Exploring the Entry Table and its fields</li><li>Resource editing and the Resource Information window</li><li>Resource Types</li><li>Fixed Costs vs Variable Costs</li><li>Adding Resource Costs</li><li>Defining when costs accrue</li><li>Changing the Resource Calendar and Availability</li><li>Project calendar vs Resource and Task Calendar</li><li>Assigning Resources to Tasks</li><li>Effort Driven Scheduling</li><li>Resolving Resource Overallocation</li></ul><p><strong>Tracking the Project Progress</strong></p><ul><li>Setting a Project Baseline</li><li>Entering Actuals</li><li>Different ways of viewing the Progress</li><li>Checking if the Project is on track</li></ul><p><strong>Viewing and Reporting Project Detail</strong></p><ul><li>Adding Tasks to the Timeline and sharing it</li><li>Modifying the Timescale and Zoom level</li><li>Formatting the Gantt View</li><li>Filtering and Grouping Tasks</li><li>Print and Troubleshoot the Gantt View</li><li>Using built-in Reports in Microsoft Project</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>General knowledge of the Windows OS</p>
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Microsoft Office know-how can instantly increase your job prospects as well as your salary.</p><p>80 percent of job openings require spreadsheet and word-processing software skills</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Project Introduction - In-company

<p><strong>Course Objectives</strong></p><p>At the end of this course you will be able to:</p><ul><li>Record and edit a Macro</li><li>Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects.</li><li>Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures</li><li>Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope</li><li>Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks</li><li>Create an error handling routine in case things go wrong with VBA code</li></ul><p>' 1 year email support service</p><p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p><em><strong>Customer Feedback</strong></em></p><ul><li><strong>Best Training Ever!</strong></li><li>Just finished a bespoke 1-1 training course in Excel Advanced, Macros &amp; VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability.</li></ul><ul><li>Amanda Morris - Treasury &amp; Systems Accountant at Reall - Real Equity for All</li></ul><ul><li><p><strong>The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience..</strong></p></li><li>Simon Harper - Lloyd's of London</li></ul><ul><li><p><strong>My learning experience was awesome.</strong></p></li><li>Perdinand Reagan - Subsea7</li></ul><ul><li><p><strong>Very nice and relaxed approach to teaching. Was definitely a good learning experience</strong><strong>.</strong></p></li><li>Jerome Pupe - S5 Agency World</li></ul><ul><li><strong>The Trainer – Very positive + patient + helpful + thorough</strong></li><li>Agnes Souza - Direct Wines</li></ul><p>'</p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p><ul><li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul><p><strong><strong>Tailored training courses:</strong></strong></p><p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p><strong>Introduction to Macros and VBA</strong></p><ul><li>Introducing Visual Basic for Applications</li><li>Recording a Macro</li><li>Naming conventions for Macro Procedures</li><li>Running a Macro</li><li>Absolute or Relative Cell Referencing</li><li>Saving and Opening Files with Macros</li><li>Making macros always available</li><li>Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes</li><li>Editing a Macro in the Visual Basic Editor</li><li>Understanding the Development Environment</li><li>Customising the Editor</li><li>Tips for General Typing in VBA</li><li>Using Visual Basic Help</li></ul><p><strong>Working with Procedures</strong></p><ul><li>Program Design</li><li>Understanding Modules</li><li>Naming Rules</li><li>Creating a Module</li><li>Understanding Procedures</li><li>Programming Macro Concepts</li><li>Creating a Subroutine</li><li>Creating a Function</li><li>Understanding Arguments</li><li>Exiting Procedures</li><li>Calling Procedures</li></ul><p><strong>Objects, Properties, Methods and Events</strong></p><ul><li>Understanding Objects Properties, Methods, and Events</li><li>Navigating the Object Hierarchy</li><li>Understanding Collections</li><li>Accessing a Member of a Collection</li><li>Understanding Hierarchy</li><li>Using the Object Browser</li><li>Using the With Statement</li><li>Working with Properties</li><li>Working with Methods</li><li>Creating an Event Procedure</li><li>Reserved Macro Names</li></ul><p><strong>Using Expressions, Variables and Intrinsic Functions</strong></p><ul><li>Understanding Expressions and Statements</li><li>Declaring Variables</li><li>Understanding Data Types</li><li>Determining the Value of Variables</li><li>Working with Variable Scope</li><li>Using Built-in VBA Functions</li><li>Understanding Constants</li><li>Using Message Boxes</li><li>Controlling the Answer to a Message Box</li><li>Using Input Boxes</li><li>Declaring and Using Object Variables</li></ul><p><strong>Controlling Program Execution</strong></p><ul><li>Understanding Control-of-Flow Structures</li><li>Using the If...End If Decision Structures</li><li>Nested If Statements</li><li>Using the Select Case ... End Select Structure</li><li>Using the Do ... Loop Structure</li><li>Using the For ... Next Structure</li><li>Using the For Each ... Next Structure</li><li>Guidelines for Use of Control-of-Flow Structures</li></ul><p><strong>Debugging and Handling Errors</strong></p><ul><li>Understanding Errors</li><li>Using Debugging Tools</li><li>Setting Breakpoints and Using Break Mode</li><li>Stepping Through Code</li><li>Trapping Errors with the On Error Statement</li><li>Understanding the Err Object</li><li>Working with Inline Error Handling</li><li>Writing an Error-Handling Routine</li></ul><p><strong>Working with Forms and Controls</strong></p><ul><li>Understanding UserForms</li><li>Creating a Form</li><li>Displaying and Removing a Form</li><li>Aligning and Sizing Controls</li><li>Using the Toolbox</li><li>Working with a Form's Properties, Methods, and Events</li><li>Working with Form and Control Properties, Methods and Event</li><li>Setting the Tab Order</li><li>Populating a Control</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Preferably, delegates should have attended the Excel Advanced course.</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Excel Macros & VBA - In-company

<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;">Price</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&pound;750 inc VAT</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Finance options</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">In Company training - &pound;750 for groups of up to 8 delegates.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Discounts for Nonprofits/Charities...&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Study method</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">On-site</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Duration</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">2 days, Full-time</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Qualification</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">No formal qualification</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Certificates</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Certificate of completion - Free</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Additional info</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Tutor is available to students</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 style="color: rgb(15, 21, 26); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(15, 21, 26);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Objectives</strong></p><p style="color: rgb(15, 21, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);">At the end of this course you will be able to:</p><ul style="color: rgb(15, 21, 26); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><li fr-original-style="" style="box-sizing: border-box;">Identify the components of the Microsoft Project environment</li><li fr-original-style="" style="box-sizing: border-box;">Create a new project plan</li><li fr-original-style="" style="box-sizing: border-box;">Create the project schedule</li><li fr-original-style="" style="box-sizing: border-box;">Use different views to analyse the project plan</li><li fr-original-style="" style="box-sizing: border-box;">Create, allocate and manage resources in a project plan</li><li fr-original-style="" style="box-sizing: border-box;">Finalise a project plan</li><li fr-original-style="" style="box-sizing: border-box;">Track progress</li><li fr-original-style="" style="box-sizing: border-box;">View and report project plan information</li></ul><p style="color: rgb(15, 21, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);">&#39; 1 year email support service</p><p style="color: rgb(15, 21, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Customer Feedback</strong></em></p><ul style="color: rgb(15, 21, 26); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><li fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Very good course. Learnt a lot. Looking forward to the next level.</strong></p></li><li fr-original-style="" style="box-sizing: border-box;">Alexandra - CIAL</li></ul><p style="color: rgb(15, 21, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);">1 year email support service</p><p style="color: rgb(15, 21, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);">Take a closer look at the&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">consistent excellent feedback from our growing corporate clients</strong>&nbsp;visiting our site&nbsp;<em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">ms-officetraining co uk</strong></em></p><p style="color: rgb(15, 21, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);">With more than 20 years experience, we deliver courses on all levels of the Desktop version of&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p style="color: rgb(15, 21, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);">Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;public, one to one, tailored and bespoke courses.</strong></p><ul style="color: rgb(15, 21, 26); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Our competitive rates&nbsp;start from &pound;550.00 per day of training</strong></li></ul><p style="color: rgb(15, 21, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Tailored training courses:</strong></p><p style="color: rgb(15, 21, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);">You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><section style="color: rgb(15, 21, 26); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(15, 21, 26);"><h2 fr-original-style="" style="box-sizing: border-box;">Description</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Introduction to Microsoft Project</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Recap on project management concepts</li><li fr-original-style="" style="box-sizing: border-box;">Project environment overview</li><li fr-original-style="" style="box-sizing: border-box;">The 3 databases: Tasks, Resources and Assignments</li><li fr-original-style="" style="box-sizing: border-box;">Different ways of displaying the Project Plan</li><li fr-original-style="" style="box-sizing: border-box;">Access Help</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Creating a Project Plan</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Create a New Project Plan</li><li fr-original-style="" style="box-sizing: border-box;">Project Information</li><li fr-original-style="" style="box-sizing: border-box;">Create and apply the project calendar</li><li fr-original-style="" style="box-sizing: border-box;">Defining recurring exceptions to the calendar</li><li fr-original-style="" style="box-sizing: border-box;">Defining the calendar&#39;s work weeks</li><li fr-original-style="" style="box-sizing: border-box;">Create the Summary tasks</li><li fr-original-style="" style="box-sizing: border-box;">Create the Work Breakdown Structure</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Task creation and scheduling</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Exploring the Entry Table and its fields</li><li fr-original-style="" style="box-sizing: border-box;">Task editing and the Task Information window</li><li fr-original-style="" style="box-sizing: border-box;">Task Durations</li><li fr-original-style="" style="box-sizing: border-box;">Defining Milestones</li><li fr-original-style="" style="box-sizing: border-box;">Manual Scheduling vs Automatic Scheduling</li><li fr-original-style="" style="box-sizing: border-box;">Changing the Task&#39;s Calendar</li><li fr-original-style="" style="box-sizing: border-box;">Create a split in a Task</li><li fr-original-style="" style="box-sizing: border-box;">Create Task Relationships</li><li fr-original-style="" style="box-sizing: border-box;">Adding Lag or Lead to a Relationship</li><li fr-original-style="" style="box-sizing: border-box;">Identifying the Critical Path</li><li fr-original-style="" style="box-sizing: border-box;">Adding Constraints and Deadlines to Tasks</li><li fr-original-style="" style="box-sizing: border-box;">Create Recurring Activities</li><li fr-original-style="" style="box-sizing: border-box;">Adding Notes and links to Tasks</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Managing Resources</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Exploring the Entry Table and its fields</li><li fr-original-style="" style="box-sizing: border-box;">Resource editing and the Resource Information window</li><li fr-original-style="" style="box-sizing: border-box;">Resource Types</li><li fr-original-style="" style="box-sizing: border-box;">Fixed Costs vs Variable Costs</li><li fr-original-style="" style="box-sizing: border-box;">Adding Resource Costs</li><li fr-original-style="" style="box-sizing: border-box;">Defining when costs accrue</li><li fr-original-style="" style="box-sizing: border-box;">Changing the Resource Calendar and Availability</li><li fr-original-style="" style="box-sizing: border-box;">Project calendar vs Resource and Task Calendar</li><li fr-original-style="" style="box-sizing: border-box;">Assigning Resources to Tasks</li><li fr-original-style="" style="box-sizing: border-box;">Effort Driven Scheduling</li><li fr-original-style="" style="box-sizing: border-box;">Resolving Resource Overallocation</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Tracking the Project Progress</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Setting a Project Baseline</li><li fr-original-style="" style="box-sizing: border-box;">Entering Actuals</li><li fr-original-style="" style="box-sizing: border-box;">Different ways of viewing the Progress</li><li fr-original-style="" style="box-sizing: border-box;">Checking if the Project is on track</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Viewing and Reporting Project Detail</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Adding Tasks to the Timeline and sharing it</li><li fr-original-style="" style="box-sizing: border-box;">Modifying the Timescale and Zoom level</li><li fr-original-style="" style="box-sizing: border-box;">Formatting the Gantt View</li><li fr-original-style="" style="box-sizing: border-box;">Filtering and Grouping Tasks</li><li fr-original-style="" style="box-sizing: border-box;">Print and Troubleshoot the Gantt View</li><li fr-original-style="" style="box-sizing: border-box;">Using built-in Reports in Microsoft Project</li></ul></section><section style="color: rgb(15, 21, 26); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><h2 fr-original-style="" style="box-sizing: border-box;">Who is this course for?</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans.</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></section><section style="color: rgb(15, 21, 26); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><h2 fr-original-style="" style="box-sizing: border-box;">Requirements</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">General knowledge of the Windows OS</p></section><section style="color: rgb(15, 21, 26); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><h2 fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></h2><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><h2 fr-original-style="" style="box-sizing: border-box;">Career path</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Microsoft Office know-how can instantly increase your job prospects as well as your salary.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">80 percent of job openings require spreadsheet and word-processing software skills</p></section>

Microsoft Project Introduction/Intermediate - In-company

General admission

Edinburgh

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Becoming a &ldquo;Mental Health First Aider&rdquo; in your organisation</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;">Online Training Course Overview</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Mental Health First Aid is about providing staff with the skills to help someone who is developing a mental health problem or experiencing a mental health crisis. The impact of physical illness and injury is widely understood as a cause of lost productivity and revenue within a business or organisation. However, mental ill-health is responsible for significant disruption, turnover, and lost productivity.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Training Course Objectives</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">By the end of this online training course, participants will be able to:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Understand the role and limitations of the Mental Health "First Aider"</li><li fr-original-style="" style="box-sizing: border-box;">Recognise the symptoms of mental ill-health</li><li fr-original-style="" style="box-sizing: border-box;">Provide initial help and referral to those in need</li><li fr-original-style="" style="box-sizing: border-box;">Promote wellbeing in the workplace</li><li fr-original-style="" style="box-sizing: border-box;">Be mindful of your own wellbeing in the role</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Designed For</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Anyone who wants to become a mental health first aider (MHFA)</li><li fr-original-style="" style="box-sizing: border-box;">All Managers, Supervisors and Team Leaders</li><li fr-original-style="" style="box-sizing: border-box;">All HRM Professionals</li><li fr-original-style="" style="box-sizing: border-box;">Anyone who wants to broaden their understanding of workplace mental health</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Learning Methods</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course will utilise various proven learning techniques to ensure maximum understanding, comprehension, and retention of the information presented. Exercises, small group work, case studies and short video clips are used to enhance learning.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The course is taught by a Consultant Psychologist, a Certified Employee Assistance Professional (CEAP) with over 25-years&rsquo; experience with Workplace Mental Health.&nbsp;</p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Training Course Outline</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Introduction to mental health first-aid concepts</li><li fr-original-style="" style="box-sizing: border-box;">Limitations of your role</li><li fr-original-style="" style="box-sizing: border-box;">Understanding mental health stigma</li><li fr-original-style="" style="box-sizing: border-box;">Determinants/causes of mental health issues</li><li fr-original-style="" style="box-sizing: border-box;">Understanding common mental health issues</li><li fr-original-style="" style="box-sizing: border-box;">How do you know if someone is experiencing a problem?</li><li fr-original-style="" style="box-sizing: border-box;">Getting help and helping others</li><li fr-original-style="" style="box-sizing: border-box;">Finding external professional help - Referral skills</li><li fr-original-style="" style="box-sizing: border-box;">Self-care &ndash; being mindful of your own wellness</li></ul>

Buon Consultancy

Mental Health First Aid

Mental Health "First Aid" Course (£695 total for this 1-day course for a group of up to 12 people)

<p><strong>Course Objectives</strong></p><p>This course aims to provide delegates with a foundation for Excel knowledge and skills.</p><p>'</p><p><em><strong>Customer Feedback</strong></em></p><ul><li><strong>Very professional and well mannered, fun and pleasant at the same time. I learnt a lot</strong></li><li>Carolina Foster - CNN</li></ul><ul><li><strong>Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all.</strong></li><li>Laura Smith - James Grant</li></ul><ul><li><strong>Great course and excellent trainer. Thanks</strong></li><li>Tracy Preston - Western Power Distribution</li></ul><p>1 year email support service</p><p>Take a look at the <strong>consistent excellent feedback from our corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p><ul><li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul><p><strong><strong>Tailored training courses:</strong></strong></p><p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p><strong>What is Excel?</strong></p><p><strong>The Excel Interface</strong></p><ul><li>Ribbon, Tabs and Groups</li><li>Microsoft Office Backstage view</li></ul><p><strong>Working with Workbooks</strong></p><ul><li>Create a blank Workbook</li><li>Create a Workbook using a Template</li><li>Opening and saving Files</li></ul><p><strong>Working with worksheets</strong></p><ul><li>Worksheet navigation</li><li>Select one or multiple Worksheets</li><li>Insert, Move, Copy or Delete a Worksheet</li></ul><p><strong>Working with Cells, Rows &amp; Columns</strong></p><ul><li>Cell References</li><li>How to select cells or ranges</li><li>Different types of data</li><li>Move, Copy and Delete cells</li><li>Pasting Options</li><li>Find and Replace</li><li>Working with Rows and Columns</li></ul><p><strong>Overview of formulas in Excel</strong></p><ul><li>Autocalculation</li><li>The parts of an Excel formula</li><li>Using calculation operators in Excel formulas</li><li>The difference between Absolute, Relative and Mixed references</li><li>Using Excel functions; Sum, Average, Max and Min</li></ul><p><strong>Cell Formatting</strong></p><ul><li>Font Format options</li><li>Number Format options</li><li>Change the Fill and Borders</li><li>Cell Alignment</li></ul><p><strong>An Introduction to Charts</strong></p><ul><li>Create a simple Chart</li><li>Format your chart</li></ul><p><strong>Page Layout and Print</strong></p><ul><li>Page Layout and Page Break View</li><li>Change the Page Orientation</li><li>Set Page Margins</li><li>Headers and Footers in a worksheet</li><li>Print a worksheet or workbook</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>All users who want to master the main features of Microsoft Excel</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>General knowledge of the Windows OS</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Excel Introduction - In-company

<p><strong>Course Objectives</strong></p><p>The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data.</p><p>'</p><p><em><strong>Customer Feedback</strong></em></p><ul><li><p><strong>Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great.</strong></p></li><li>Kelly Moreley - TACT</li></ul><ul><li><strong>Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys.</strong></li><li>Jenny Price - Acer</li></ul><p>1 year email support service</p><p>Take a look at the <strong>consistent excellent feedback from our corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses.</p><p><strong><strong>Tailored training courses:</strong></strong></p><p>In, in company training, you can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p><strong>Recap on Excel formulas and calculations</strong></p><ul><li>Overview of formulas in Excel</li><li>Relative, Absolute and Mixed cell references</li></ul><p><strong>Group editing worksheets</strong></p><p><strong>Autofill and Flash Fill</strong></p><p><strong>Changing Excel’s environment Options</strong></p><ul><li>Changing the default number of sheets</li><li>Creating an Autofill Custom List</li><li>Adding tools to the Quick Access Toolbar</li></ul><p><strong>Mastering Excel Tables</strong></p><ul><li>Introducing Excel Tables</li><li>Formatting a Table</li><li>Creating Calculated Columns</li><li>Using Slicers to filter your data</li><li>Using Totals to get statistics out of your data</li><li>Removing duplicates</li><li>Converting Tables back to normal Ranges</li></ul><p><strong>Using names Ranges</strong></p><ul><li>In Excel formulas</li><li>As a way of navigating through the workbook</li></ul><p><strong>Advanced Formulas</strong></p><ul><li>Simple IF examples</li><li>Using IF to check if a cell is blank</li><li>Nested IFs</li><li>VLOOKUP</li><li>HLOOKUP</li><li>Text Functions</li><li>Date Functions</li></ul><p><strong>Conditional formatting</strong></p><ul><li>Apply Conditional Formatting</li><li>Customising Conditional Formatting</li><li>Using Icons in Conditional Formatting</li><li>Using Formulas to conditionally format cells</li></ul><p><strong>Linking spreadsheets and workbooks</strong></p><ul><li>Making a reference to another worksheet</li><li>Making a reference to another workbook</li><li>Editing links</li><li>Troubleshooting links</li></ul><p><strong>Analysing databases</strong></p><ul><li>Quick analysis</li><li>Sorting a database</li><li>Apply filters to a database</li><li>Advance filter</li><li>Sorting and Filtering by Conditional Formats</li></ul><p><strong>Charts</strong></p><ul><li>Analyse trends in data using Sparklines</li><li>Creating charts from start to finish</li><li>Exploring the different Chart Types</li><li>Apply Chart Styles</li><li>Formatting Chart Elements</li><li>Filtering Charts by Series or Categories</li><li>Adding a Trendline to a Chart</li><li>Create a Chart Template</li></ul><p><strong>Attaching security to a spreadsheet and workbook</strong></p><ul><li>Protect Cells</li><li>Protect Structure of worksheets</li><li>Protect a Workbook by adding passwords</li></ul><p><strong>Introduction to Pivot Tables</strong></p><ul><li>What are Pivot Tables?</li><li>Using recommended pivot tables to analyse your data</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>For those who want to explore in more detail formulas and functions, data analysis and data presentation.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Preferably, delegates would have attended the Excel Introduction course.</p>
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Excel know-how can instantly increase your job prospects as well as your salary.</p><p>80 percent of job openings require spreadsheet and word-processing software skills</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Excel Intermediate - In-company

<p><strong>Course Objectives</strong></p><p>At the end of this course you will be able to:</p><ul><li>Work with advanced lookup and reference functions</li><li>Create macros to automate common tasks</li><li>Use advanced techniques to analyse data</li><li>Create PivotTables and PivotCharts</li><li>Work with data validation tools</li><li>Import and export data</li></ul><p>'</p><p><em><strong>Customer Feedback</strong></em></p><ul><li><strong>Best Training Ever!</strong></li><li>Just finished a bespoke 1-1 training course in Excel Advanced, Macros &amp; VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability.</li></ul><ul><li>Amanda Morris - Treasury &amp; Systems Accountant at Reall - Real Equity for All</li></ul><ul><li><p><strong>The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic.</strong></p></li><li>Marving Lopez - AM Best Europe</li></ul><ul><li><strong>Pedro was excellent. Very knowledgeable, clear and great rapport with class.</strong></li><li>Darren Barkey - Direct Wines</li></ul><ul><li><strong>Great content and learnt a lot. Really enjoyable :)</strong></li><li>Kristie-Lee Ryan - Stirling Ackroyd</li></ul><p>1 year email support service</p><p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p><ul><li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul><p><strong><strong>Tailored training courses:</strong></strong></p><p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p>Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in.</p><p><strong>Advanced Functions</strong></p><ul><li>COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL</li><li>IF, OR, AND, IFERROR</li><li>VLOOKUP to lookup Exact Values and Approximate values</li><li>MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET</li></ul><p><strong>Analysing Data</strong></p><ul><li>PMT function to calculate a monthly payment of a loan</li><li>What If Analysis using Goal Seek</li><li>Use scenarios to consider many different variables</li><li>Using Solver Add-in to optimize variables</li></ul><p><strong>PivotTables</strong></p><ul><li>Create a PivotTable to analyse worksheet data</li><li>Add or remove fields in a PivotTable</li><li>Change the data source for a PivotTable</li><li>Working with external data sources</li><li>Using different Statistical Functions</li><li>Calculate a Running Total, % of Grant Total, Difference From…</li><li>Using the Slicer and Timeline to filter the PivotTable</li><li>Using Filters in a PivotTable</li><li>Group by Date, Auto Group by ranges of values, Custom Group</li><li>Create a PivotChart</li><li>The GETPIVOTDATA function</li></ul><p><strong>Formula auditing</strong></p><ul><li>Precedents and dependents</li><li>Error checking</li><li>Watch a formula and its result by using the Watch Window</li><li>Evaluate a nested formula one step at a time</li></ul><p><strong>Data Validation</strong></p><ul><li>Number Validation</li><li>Data List Validation</li><li>Message Prompts and Alerts</li><li>Conditional Data Validation</li><li>Data Validation Errors</li></ul><p><strong>Consolidation</strong></p><ul><li>Consolidate data by position</li><li>Consolidate data by category</li><li>Use a formula to consolidate data</li></ul><p><strong>Outline (group) data in a worksheet</strong></p><ul><li>Create an outline of rows</li><li>Create an outline of columns</li><li>Copy outlined data</li><li>Hide or remove an outline</li></ul><p><strong>Connect external data to your workbook</strong></p><ul><li>Using the Power Query Editor to import data</li><li>From Text and CSV, From Access, From Web, From another Workbook</li><li>Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more.</li><li>Deleting Applied Steps</li><li>Refreshing your data</li></ul><p><strong>Working with Form Controls; Buttons, Option Buttons and Scroll Bars</strong></p><p><strong>Introduction to Macros</strong></p><ul><li>Change Macro Security settings</li><li>How to Record a macro</li><li>Some Macro Examples</li><li>Delete a macro</li><li>Edit the macro to view the VBA code</li><li>Copy part of a macro to create another macro</li><li>Assign a macro to a button</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Preferably, delegates should have attended the Excel Intermediate course.</p>
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Excel know-how can instantly increase your job prospects as well as your salary.</p><p>80 percent of job openings require spreadsheet and word-processing software skills</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Excel Advanced - In-company

Manchester

Research Quality Association

Introduction to Computer Systems Validation

RQA Member

Non Member

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material.</p>Overview<p>After completing this course, you will be able to:<br />Describe key database concepts in the context of SQL Server<br />Describe database languages used in SQL Server<br />Describe data modelling techniques<br />Describe normalization and denormalization techniques<br />Describe relationship types and effects in database design<br />Describe the effects of database design on performance<br />Describe commonly used database objects</p><p>This course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management. Students will learn fundamental database concepts through demonstrations and hands-on labs on a SQL Server instance.<br />This material updates and replaces course Microsoft course 10985 which was previously published under the same title.</p></div><div id="course-pills-2"><h4>Module 1: Introduction to databases</h4><ul><li>Introduction to Relational Databases</li><li>Other Databases and Storage</li><li>Data Analysis</li><li>SQL Server Database Languages</li></ul><h4>Module 2: Data Modeling</h4><ul><li>Data Modelling</li><li>Designing a Database</li><li>Relationship Modeling</li></ul><h4>Module 3: Normalization</h4><ul><li>Fundamentals of Normalization</li><li>Normal Form</li><li>Denormalization</li></ul><h4>Module 4: Relationships</h4><ul><li>Introduction to Relationships</li><li>Planning Referential Integrity</li></ul><h4>Module 5: Performance</h4><ul><li>Indexing</li><li>Query Performance</li><li>Concurrency</li></ul><h4>Module 6: Database Objects</h4><ul><li>Tables</li><li>Views</li><li>Stored Procedures, Triggers and Functions</li></ul></div>

Nexus Human

Microsoft SQL Server

Microsoft SQL

AWS Certified Database

SQL Server

Trainers Course

Database Administration

55315: Introduction to SQL Databases

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

Certified in Cybersecurity (CC)

IT Certifications

Cyber Security

Certified Ethical Hacker (CEH)

Certified Cyber Professional (CCP)

Ethical Hacking

EC-Council Certified Ethical Hacker (CEH) v12

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>The primary audience for this course is Enterprise Desktop Support Technicians (EDSTs). These technicians provide Tier 2 support to users with domain-joined computers running the Windows 11 OS, typically in medium to large enterprise organizations.</p>Overview<p>Important Windows 11 features    How these features are used in an Active Directory    How to troubleshoot these features</p><p>This is a 5-day ILT course that is designed to provide you with the knowledge and skills required to support and troubleshoot Windows 11 PCs and devices in an on-premises Windows Server Active Directory domain environment.</p></div><div id="course-pills-2"><h3>1: Introducing Windows 11</h3> <ul> <li> Overview of Windows 11</li>  <li> Recommendations for typical troubleshooting procedures</li>  <li>Troubleshooting installation and deployment</li>  <li> Introduction to management and troubleshooting tools</li> </ul>  <h3>2: Administering Windows 11 remotely</h3> <ul> <li> Using Windows Admin Center</li>  <li>Using Windows PowerShell</li>  <li> Implementing Remote Management</li> </ul>  <h3>3: Troubleshooting startup and performing system recovery</h3> <ul> <li> Recovering Windows 11</li>  <li> Configuring the Registry</li>  <li>Troubleshooting Windows 11 startup</li>  <li> Implementing and troubleshooting BitLocker</li>  <li> Troubleshooting OS service Issues</li> </ul>  <h3>4: Troubleshooting devices and device drivers</h3> <ul> <li> Overview of hardware troubleshooting</li>  <li>Troubleshooting device drivers</li> </ul>  <h3>5: Configuring and troubleshooting network connectivity</h3> <ul> <li> Configuring network connectivity</li>  <li> Troubleshooting network connectivity</li>  <li> Implementing and troubleshooting name resolution</li>  <li> Implementing and troubleshooting remote access</li> </ul>  <h3>6: Troubleshooting Group Policy</h3> <ul> <li>Overview of Group Policy</li>  <li> Resolve GPO application issues on client devices</li> </ul>  <h3>7: Configuring and Troubleshooting Security Settings</h3> <ul> <li> Implementing network security</li>  <li> Implementing Windows 11 security features</li>  <li> Configuring and troubleshooting user accounts</li> </ul>  <h3>8: Configuring and Troubleshooting User State</h3> <ul> <li> Implementing and troubleshooting user state</li>  <li> Implementing and troubleshooting Folder Redirection</li> </ul>  <h3>9: Configuring and Troubleshooting Resource Access</h3> <ul> <li> Configuring and troubleshooting file access.</li>  <li> Configuring and troubleshooting shared folders.</li>  <li> Implementing and troubleshooting Work Folders.</li>  <li>Managing and troubleshooting printers.</li>  <li>Recovering files.</li> </ul>  <h3>10: Troubleshooting apps</h3> <ul> <li> Troubleshooting desktop apps</li>  <li> Troubleshooting app compatibility</li>  <li> Managing UWP apps</li> </ul>  <h3>11: Monitoring and Maintaining Windows 11</h3> <ul> <li> Monitoring Windows 11</li>  <li>Optimizing Windows 11 performance</li>  <li> Managing Windows 11 updates</li> </ul></div>

IT Technician

IT Support

Microsoft Certification

Computer Maintenance

Microsoft AZ-303

55342 Supporting and Troubleshooting Windows 11

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>Successful students have experience and knowledge in IT operations, including networking, virtualization, identity, security, business continuity, disaster recovery, data platforms, and governance. Students also have experience designing and architecting solutions.</p> <p>Before attending this course, students must have previous experience deploying or administering Azure resources and strong conceptual knowledge of:</p> <ul> <li><p>Azure compute technologies such as VMs, containers and serverless solutions</p> </li> <li><p>Azure virtual networking to include load balancers</p> </li> <li><p>Azure Storage technologies (unstructured and databases)</p> </li> <li><p>General application design concepts such as messaging and high availability</p> </li> </ul><p></p><p></p><p>This course teaches Azure Solution Architects how to design infrastructure solutions. Course topics cover governance, compute, application architecture, storage, data integration, authentication, networks, business continuity, and migrations. The course combines lecture with case studies to demonstrate basic architect design principles.</p><p></p>Prerequisites<p>Before attending this course, students must have previous experience deploying or administering Azure resources and conceptual knowledge of:  </p><li>Azure Active Directory</li>  <li>Azure compute technologies such as VMs, containers and serverless solutions</li>  <li>Azure virtual networking to include load balancers</li>  <li>Azure Storage technologies (unstructured and databases)</li>  <li>General application design concepts such as messaging and high availability</li>  <li>AZ-104T00 - Microsoft Azure Administrator<p></p></li></div><div id="course-pills-2"><h3>1 - Design governance</h3> <ul> <li>Design for governance</li> <li>Design for management groups</li> <li>Design for subscriptions</li> <li>Design for resource groups</li> <li>Design for resource tags</li> <li>Design for Azure Policy</li> <li>Design for role-based access control (RBAC)</li> <li>Design for Azure landing zones</li> </ul> <h3>2 - Design an Azure compute solution</h3> <ul> <li>Choose an Azure compute service</li> <li>Design for Azure Virtual Machines solutions</li> <li>Design for Azure Batch solutions</li> <li>Design for Azure App Service solutions</li> <li>Design for Azure Container Instances solutions</li> <li>Design for Azure Kubernetes Service solutions</li> <li>Design for Azure Functions solutions</li> <li>Design for Azure Logic Apps solutions</li> </ul> <h3>3 - Design a data storage solution for non-relational data</h3> <ul> <li>Design for data storage</li> <li>Design for Azure storage accounts</li> <li>Design for data redundancy</li> <li>Design for Azure Blob Storage</li> <li>Design for Azure Files</li> <li>Design for Azure managed disks</li> <li>Design for storage security</li> </ul> <h3>4 - Design a data storage solution for relational data</h3> <ul> <li>Design for Azure SQL Database</li> <li>Design for Azure SQL Managed Instance</li> <li>Design for SQL Server on Azure Virtual Machines</li> <li>Recommend a solution for database scalability</li> <li>Recommend a solution for database availability</li> <li>Design security for data at rest, data in motion, and data in use</li> <li>Design for Azure SQL Edge</li> <li>Design for Azure Cosmos DB and Table Storage</li> </ul> <h3>5 - Design data integration</h3> <ul> <li>Design a data integration solution with Azure Data Factory</li> <li>Design a data integration solution with Azure Data Lake</li> <li>Design a data integration and analytic solution with Azure Databricks</li> <li>Design a data integration and analytic solution with Azure Synapse Analytics</li> <li>Design strategies for hot, warm, and cold data paths</li> <li>Design an Azure Stream Analytics solution for data analysis</li> </ul> <h3>6 - Design an application architecture</h3> <ul> <li>Describe message and event scenarios</li> <li>Design a messaging solution</li> <li>Design an Azure Event Hubs messaging solution</li> <li>Design an event-driven solution</li> <li>Design a caching solution</li> <li>Design API integration</li> <li>Design an automated app deployment solution</li> <li>Design an app configuration management solution</li> </ul> <h3>7 - Design authentication and authorization solutions</h3> <ul> <li>Design for identity and access management (IAM)</li> <li>Design for Microsoft Entra ID</li> <li>Design for Microsoft Entra business-to-business (B2B)</li> <li>Design for Azure Active Directory B2C (business-to-customer)</li> <li>Design for conditional access</li> <li>Design for identity protection</li> <li>Design for access reviews</li> <li>Design service principals for applications</li> <li>Design managed identities</li> <li>Design for Azure Key Vault</li> </ul> <h3>8 - Design a solution to log and monitor Azure resources</h3> <ul> <li>Design for Azure Monitor data sources</li> <li>Design for Azure Monitor Logs (Log Analytics) workspaces</li> <li>Design for Azure Workbooks and Azure insights</li> <li>Design for Azure Data Explorer</li> </ul> <h3>9 - Design network solutions</h3> <ul> <li>Recommend a network architecture solution based on workload requirements</li> <li>Design patterns for Azure network connectivity services</li> <li>Design outbound connectivity and routing</li> <li>Design for on-premises connectivity to Azure Virtual Network</li> <li>Choose an application delivery service</li> <li>Design for application delivery services</li> <li>Design for application protection services</li> </ul> <h3>10 - Design a solution for backup and disaster recovery</h3> <ul> <li>Design for backup and recovery</li> <li>Design for Azure Backup</li> <li>Design for Azure blob backup and recovery</li> <li>Design for Azure files backup and recovery</li> <li>Design for Azure virtual machine backup and recovery</li> <li>Design for Azure SQL backup and recovery</li> <li>Design for Azure Site Recovery</li> </ul> <h3>11 - Design migrations</h3> <ul> <li>Evaluate migration with the Cloud Adoption Framework</li> <li>Describe the Azure migration framework</li> <li>Assess your on-premises workloads</li> <li>Select a migration tool</li> <li>Migrate your structured data in databases</li> <li>Select an online storage migration tool for unstructured data</li> <li>Migrate offline data</li> </ul> <h3>12 - Introduction to the Microsoft Azure Well-Architected Framework</h3> <ul> <li>Azure Well-Architected Framework pillars</li> <li>Cost optimization</li> <li>Operational excellence</li> <li>Performance efficiency</li> <li>Reliability</li> <li>Security</li> </ul> <h3>13 - Microsoft Azure Well-Architected Framework - Cost Optimization</h3> <ul> <li>Develop cost-management discipline</li> <li>Design with a cost-efficiency mindset</li> <li>Design for usage optimization</li> <li>Design for rate optimization</li> <li>Monitor and optimize over time</li> </ul> <h3>14 - Microsoft Azure Well-Architected Framework - Operational excellence</h3> <ul> <li>Embrace DevOps culture</li> <li>Establish development standards</li> <li>Evolve operations with observability</li> <li>Deploy with confidence</li> <li>Automate for efficiency</li> <li>Adopt safe deployment practices</li> </ul> <h3>15 - Microsoft Azure Well-Architected Framework - Performance efficiency</h3> <ul> <li>Negotiate realistic performance targets</li> <li>Design to meet capacity requirements</li> <li>Achieve and sustain performance</li> <li>Improve efficiency through optimization</li> </ul> <h3>16 - Microsoft Azure Well-Architected Framework - Reliability</h3> <ul> <li>Design for business requirements</li> <li>Design for resilience</li> <li>Design for recovery</li> <li>Design for operations</li> <li>Keep it simple</li> </ul> <h3>17 - Microsoft Azure Well-Architected Framework - Security</h3> <ul> <li>Plan your security readiness</li> <li>Design to protect confidentiality</li> <li>Design to protect integrity</li> <li>Design to protect availability</li> <li>Sustain and evolve your security posture</li> </ul> <h3>18 - Getting started with the Microsoft Cloud Adoption Framework for Azure</h3> <ul> <li>Customer narrative</li> <li>Common blockers</li> </ul> <h3>19 - Prepare for successful cloud adoption with a well-defined strategy</h3> <ul> <li>Customer narrative</li> <li>Capture strategic motivation</li> <li>Define objectives and key results</li> <li>Evaluate financial considerations</li> <li>Understand technical considerations</li> <li>Create a business case</li> </ul> <h3>20 - Prepare for cloud adoption with a data-driven plan</h3> <ul> <li>Customer narrative</li> </ul> <h3>21 - Choose the best Azure landing zone to support your requirements for cloud operations</h3> <ul> <li>Customer narrative</li> <li>Common operating models</li> <li>Design areas for Azure landing zones</li> <li>Design principles for Azure landing zones</li> <li>Journey to the target architecture</li> <li>Choose an Azure landing zone option</li> <li>Deploy the Azure landing zone accelerator</li> <li>Enhance your landing zone</li> </ul> <h3>22 - Migrate to Azure through repeatable processes and common tools</h3> <ul> <li>Customer narrative</li> <li>Migration process</li> <li>Migration tools</li> <li>Common tech platforms</li> </ul> <h3>23 - Address tangible risks with the Govern methodology of the Cloud Adoption Framework for Azure</h3> <ul> <li>Customer narrative</li> <li>Govern methodology</li> <li>Corporate policies</li> <li>Governance disciplines</li> <li>Deploy a cloud governance foundation</li> <li>The Cost Management discipline</li> </ul> <h3>24 - Ensure stable operations and optimization across all supported workloads deployed to the cloud</h3> <ul> <li>Establish business commitments</li> <li>Deploy an operations baseline</li> <li>Protect and recover</li> <li>Enhance an operations baseline</li> <li>Manage platform and workload specialization</li> </ul> <h3>25 - Innovate applications by using Azure cloud technologies</h3> <ul> <li>Follow the innovation lifecycle</li> <li>Azure technologies for the build process</li> <li>Infuse your applications with AI</li> <li>Azure technologies for measuring business impact</li> <li>Azure technologies for the learn process</li> </ul> <h3>26 - Prepare for cloud security by using the Microsoft Cloud Adoption Framework for Azure</h3> <ul> <li>Customer narrative</li> <li>Methodology</li> <li>Security roles and responsibilities</li> <li>Simplify compliance and security</li> <li>Simplify security implementation</li> <li>Security tools and policies</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans AZ-305T00: Designing Microsoft Azure Infrastructure Solutions 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 AZ-305T00: Designing Microsoft Azure Infrastructure Solutions course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Microsoft AZ-900

Microsoft AZ-104

Microsoft Azure

Microsoft AZ-700

AWS Certified Solutions Architect

AZ-305T00 Designing Microsoft Azure Infrastructure Solutions

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>This four-day course is intended for Windows Server Hybrid Administrators who have experience working with Windows Server and want to extend the capabilities of their on-premises environments by combining on-premises and hybrid technologies. Windows Server Hybrid Administrators implement and manage on-premises and hybrid solutions such as identity, management, compute, networking, and storage in a Windows Server hybrid environment.</p><p></p><p></p><p>This course teaches IT Professionals how to manage core Windows Server workloads and services using on-premises, hybrid, and cloud technologies. The course teaches IT Professionals how to implement and manage on-premises and hybrid solutions such as identity, management, compute, networking, and storage in a Windows Server hybrid environment.</p><p></p>Prerequisites<p></p><li>Experience with managing Windows Server operating system and Windows Server workloads in on-premises scenarios, including AD DS, DNS, DFS, Hyper-V, and File and Storage Services  </li><li>Experience with common Windows Server management tools (implied in the first prerequisite).  </li><li>Basic knowledge of core Microsoft compute, storage, networking, and virtualization technologies (implied in the first prerequisite).  </li><li>Experience and an understanding of core networking technologies such as IP addressing, name resolution, and Dynamic Host Configuration Protocol (DHCP)  </li><li>Experience working with and an understanding of Microsoft Hyper-V and basic server virtualization concepts  </li><li>Basic experience with implementing and managing IaaS services in Microsoft Azure  </li><li>Basic knowledge of Azure Active Directory  </li><li>Experience working hands-on with Windows client operating systems such as Windows 10 or Windows 11  </li><li>Basic experience with Windows PowerShell<p></p></li></div><div id="course-pills-2"><h3>1 - Introduction to AD DS</h3> <ul> <li>Define AD DS</li> <li>Define users, groups, and computers</li> <li>Define AD DS forests and domains</li> <li>Define OUs</li> <li>Manage objects and their properties in AD DS</li> </ul> <h3>2 - Manage AD DS domain controllers and FSMO roles</h3> <ul> <li>Deploy AD DS domain controllers</li> <li>Maintain AD DS domain controllers</li> <li>Manage the AD DS Global Catalog role</li> <li>Manage AD DS operations masters</li> <li>Manage AD DS schema</li> </ul> <h3>3 - Implement Group Policy Objects</h3> <ul> <li>Define GPOs</li> <li>Implement GPO scope and inheritance</li> <li>Define domain-based GPOs</li> <li>Create and configure a domain-based GPO</li> <li>Define GPO storage</li> <li>Define administrative templates</li> </ul> <h3>4 - Manage advanced features of AD DS</h3> <ul> <li>Create trust relationships</li> <li>Implement ESAE forests</li> <li>Monitor and troubleshoot AD DS</li> <li>Create custom AD DS partitions</li> </ul> <h3>5 - Implement hybrid identity with Windows Server</h3> <ul> <li>Select a Microsoft Entra integration model</li> <li>Plan for Microsoft Entra integration</li> <li>Prepare on-premises Active Directory for directory synchronization</li> <li>Install and configure directory synchronization with Microsoft Entra Connect</li> <li>Implement Seamless Single Sign-On</li> <li>Enable Microsoft Entra login in for Windows VM in Azure</li> <li>Describe Microsoft Entra Domain Services</li> <li>Implement and configure Microsoft Entra Domain Services</li> <li>Manage Windows Server 2019 in a Microsoft Entra Domain Services environment</li> <li>Create and configure a Microsoft Entra Domain Services instance</li> <li>Join a Windows Server VM to a managed domain</li> </ul> <h3>6 - Deploy and manage Azure IaaS Active Directory domain controllers in Azure</h3> <ul> <li>Select an option to implement directory and identity services using Active Directory Domain Services in Azure</li> <li>Deploy and configure Active Directory Domain Services domain controllers in Azure VMs</li> <li>Install a replica Active Directory domain controller in an Azure VM</li> <li>Install a new Active Directory forest on an Azure VNet</li> </ul> <h3>7 - Perform Windows Server secure administration</h3> <ul> <li>Define least privilege administration</li> <li>Implement delegated privileges</li> <li>Use privileged access workstations</li> <li>Use jump servers</li> </ul> <h3>8 - Describe Windows Server administration tools</h3> <ul> <li>Explore Windows Admin Center</li> <li>Use Server Manager</li> <li>List Remote Server Administration Tools</li> <li>Use Windows PowerShell</li> <li>Use Windows PowerShell to remotely administer a server</li> </ul> <h3>9 - Perform post-installation configuration of Windows Server</h3> <ul> <li>List the available post-installation configuration tools</li> <li>Configure Server Core using Sconfig</li> <li>Use DSC to configure Windows Server</li> <li>Perform post-installation configuration with Windows Admin Center</li> <li>Configure a server with answer files</li> </ul> <h3>10 - Just Enough Administration in Windows Server</h3> <ul> <li>Explain the concept of Just Enough Administration (JEA)</li> <li>Define role capabilities for a JEA endpoint</li> <li>Create a session configuration file to register a JEA endpoint</li> <li>Describe how JEA endpoints work to limit access to a PowerShell session</li> <li>Create and connect to a JEA endpoint</li> <li>Demonstration: Connect to a JEA endpoint</li> </ul> <h3>11 - Administer and manage Windows Server IaaS Virtual Machine remotely</h3> <ul> <li>Select the appropriate remote administration tool</li> <li>Manage Windows Virtual Machines with Azure Bastion</li> <li>Create an Azure Bastion host</li> <li>Configure just-in-time administration</li> </ul> <h3>12 - Manage hybrid workloads with Azure Arc</h3> <ul> <li>Describe Azure Arc</li> <li>Onboard Windows Server instances</li> <li>Connect hybrid machines to Azure from the Azure portal</li> <li>Use Azure Arc to manage Windows Server instances</li> <li>Restrict access with RBAC</li> </ul> <h3>13 - Configure and manage Hyper-V</h3> <ul> <li>Define Hyper-V</li> <li>Define Hyper-V Manager</li> <li>Configure Hyper-V hosts using best practices</li> <li>Configure Hyper-V networking</li> <li>Assess advanced Hyper-V networking features</li> <li>Define nested virtualization</li> </ul> <h3>14 - Configure and manage Hyper-V virtual machines</h3> <ul> <li>List the virtual machine configuration versions</li> <li>List the virtual machine generation versions</li> <li>List available VHD formats and types</li> <li>Create and configure VMs</li> <li>Determine storage options for VMs</li> <li>Define shared VHDs and VHD Sets</li> <li>Implement guest clusters using shared VHDX</li> </ul> <h3>15 - Secure Hyper-V workloads</h3> <ul> <li>Define guarded fabric</li> <li>Define the Host Guardian Service</li> <li>Explore TPM-trusted attestation</li> <li>Define KPS</li> <li>Determine key features of shielded VMs</li> <li>Compare encryption-supported and shielded VMs in a guarded fabric</li> <li>Implement a shielded VM</li> </ul> <h3>16 - Run containers on Windows Server</h3> <ul> <li>Define containers</li> <li>List the differences between containers and VMs</li> <li>Define Windows Server and Hyper-V containers and isolation modes</li> <li>Explore Docker</li> <li>Prepare a Windows Server 2019 host for container deployment</li> <li>Security, Storage, and Networking with Windows containers</li> </ul> <h3>17 - Orchestrate containers on Windows Server using Kubernetes</h3> <ul> <li>Define orchestration</li> <li>Define Kubernetes</li> <li>Deploy Kubernetes resources</li> <li>Create a Kubernetes cluster on Windows</li> <li>Define Azure Arc</li> <li>Connect an Azure Arc-enabled Kubernetes cluster to Azure Arc</li> </ul> <h3>18 - Plan and deploy Windows Server IaaS Virtual Machines</h3> <ul> <li>Describe Azure compute</li> <li>Describe Virtual Machine storage</li> <li>Deploy Azure Virtual Machines</li> <li>Create a windows Virtual Machine using the portal</li> <li>Create a windows Virtual Machine using Azure CLI</li> <li>Deploy Azure Virtual Machines using templates</li> <li>Describe additional management optimization options</li> </ul> <h3>19 - Customize Windows Server IaaS Virtual Machine images</h3> <ul> <li>Create a generalized image</li> <li>Create a new Virtual Machine from a managed image</li> <li>Create a managed image of a generalized virtual machine in Azure</li> <li>Create a Virtual Machine from a managed image</li> <li>Implement Azure Image Builder</li> <li>Create a windows Virtual Machine using Azure Image Builder template</li> <li>Create a Windows Virtual Machine with Azure Image Builder using PowerShell</li> </ul> <h3>20 - Automate the configuration of Windows Server IaaS Virtual Machines</h3> <ul> <li>Describe Azure Automation</li> <li>Implement Azure Automation with DSC</li> <li>Remediate noncompliant servers</li> <li>Describe Custom Script Extensions</li> <li>Configure a Virtual Machine by using DSC</li> </ul> <h3>21 - Deploy and manage DHCP</h3> <ul> <li>Use DHCP to simplify IP configuration</li> <li>Install and configure the DHCP role</li> <li>Configure DHCP options</li> <li>Configure DHCP scopes</li> <li>Select DHCP high availability options</li> <li>Implement DHCP Failover</li> </ul> <h3>22 - Implement Windows Server DNS</h3> <ul> <li>Explore the DNS architecture</li> <li>Work with DNS zones and records</li> <li>Install and configure the DNS role</li> <li>Implement DNS forwarding</li> </ul> <h3>23 - Implement IP Address Management</h3> <ul> <li>Define IP Address Management</li> <li>Deploy IP Address Management</li> <li>Administer IP Address Management</li> <li>Configure IP Address Management options</li> <li>Manage DNS zones with IP Address Management</li> <li>Manage DHCP servers with IP Address Management</li> <li>Use IP Address Management to manage IP addressing</li> </ul> <h3>24 - Implement remote access</h3> <ul> <li>Examine the remote access options in Windows Server</li> <li>Select and set up VPNs</li> <li>Use NPS to create and enforce network access policies</li> <li>Plan and implement NPS</li> <li>Deploy a PKI for remote access</li> <li>Use WAP as a reverse web proxy</li> </ul> <h3>25 - Implement hybrid network infrastructure</h3> <ul> <li>Describe Azure network topologies</li> <li>Implement Azure VPN options</li> <li>Create a route-based VPN gateway using the Azure portal</li> <li>Implement Azure ExpressRoute</li> <li>Configure Azure Virtual WAN</li> <li>Implement DNS in hybrid environments</li> </ul> <h3>26 - Implement DNS for Windows Server IaaS VMs</h3> <ul> <li>Understand Azure DNS</li> <li>Implement Azure DNS</li> <li>Create an Azure DNS zone and record using the Azure portal</li> <li>Implement DNS with Azure IaaS virtual machines</li> <li>Implement split-horizon DNS in Azure</li> <li>Troubleshoot DNS</li> </ul> <h3>27 - Implement Windows Server IaaS VM IP addressing and routing</h3> <ul> <li>Implement a virtual network</li> <li>Implement IaaS VM IP addressing</li> <li>Assign and manage IP addresses</li> <li>Configure a private IP address for a virtual machine using the Azure portal</li> <li>Create a virtual machine with a static public IP address using the Azure portal</li> <li>Implement IaaS virtual machine IP routing</li> <li>Implement IPv6 for Windows Server IaaS virtual machines</li> </ul> <h3>28 - Manage Windows Server file servers</h3> <ul> <li>Define the Windows Server file system</li> <li>List the benefits and uses of File Server Resource Manager</li> <li>Define SMB and its security considerations</li> <li>Configure SMB protocol</li> <li>Define Volume Shadow Copy Service</li> </ul> <h3>29 - Implement Storage Spaces and Storage Spaces Direct</h3> <ul> <li>Define the Storage Spaces architecture and its components</li> <li>List the functionalities, benefits, and use cases of Storage Spaces</li> <li>Implement Storage Spaces</li> <li>List the functionalities, components, benefits, and use cases of Storage Spaces Direct</li> <li>Implement Storage Spaces Direct</li> </ul> <h3>30 - Implement Windows Server Data Deduplication</h3> <ul> <li>Define the architecture, components, and functionality of Data Deduplication</li> <li>Define the use cases and interoperability of Data Deduplication</li> <li>Implement Data Deduplication</li> <li>Manage and maintain Data Deduplication</li> </ul> <h3>31 - Implement Windows Server iSCSI</h3> <ul> <li>List the functionalities, components, and use cases of iSCSI</li> <li>List the considerations for implementing iSCSI</li> <li>Implement iSCSI</li> <li>Configure high availability for iSCSI</li> </ul> <h3>32 - Implement Windows Server Storage Replica</h3> <ul> <li>List the functionalities and components of Storage Replica</li> <li>Examine the prerequisites for implementing Storage Replica</li> <li>Implement Storage Replica by using Windows Admin Center</li> <li>Implement Storage Replica by using Windows PowerShell</li> </ul> <h3>33 - Implement a hybrid file server infrastructure</h3> <ul> <li>Describe Azure File services</li> <li>Configure Azure Files</li> <li>Configure connectivity to Azure Files</li> <li>Describe Azure File Sync</li> <li>Implement Azure File Sync</li> <li>Deploy Azure File Sync</li> <li>Deploy Azure File Sync 2</li> <li>Manage cloud tiering</li> <li>Migrate from DFSR to Azure File Sync</li> </ul></div>

Microsoft Certified Solutions Associate (MCSA)

Windows Server

AZ-800T00 Administering Windows Server Hybrid Core Infrastructure

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>The primary audience for this course is any IT, facilities or data centre professional, consultant and/or those who work in network cabling system design, implementation and operation.</p>Overview<p>With few exceptions, enterprises today rely on IT for the delivery of business-critical services - often directly to the end consumer.</p><p>It is therefore vital that the mission-critical data centre is designed, maintained and operated with high-availability and efficiency in mind. Among all the facilities, network cabling is the foundation for the network and one of the major contributors to the availability of the data center.CNCDPÂ© is a 2-day course designed to expose participants to in-depth knowledge in designing and installing the data network cabling system which includes key subject matters such as; technical standards, designing of different cabling sub-systems, calculation of material requirements, architecture, installation, testing and acceptance.</p></div><div id="course-pills-2"><h4>Introduction to Structured Cabling System (SCS)</h4><ul><li>Brief history of SCS</li><li>Basic copper and fibre transmission</li><li>Copper and fibre cabling</li><li>Single and multimode fibre</li><li>Step/graded index multimode fibre</li><li>Difference between Commercial Wiring and data centre cabling</li><li>Development of standards</li><li>Role of standards</li><li>ANSI/TIA 568 standard</li><li>Common standards</li><li>The new usage of cabling to support Smart building</li></ul><h4>Horizontal and Administration - Commercial Building</h4><ul><li>Standard diagram recap: ANSI/TIA-568</li><li>Functional elements and example</li><li>Scenario A: Determine the number of work areas</li><li>Scenario B: Determine the number of user locations</li><li>Zone wiring</li><li>Administration: Interconnect and cross-connect</li><li>Angled and flat panels</li><li>Creating a cabling schematic design</li><li>Convert schematic into physical layout</li><li>Calculating the material list</li></ul><h4>Horizontal and Administration - Data Centre</h4><ul><li>Standard diagram recap: TIA-942</li><li>Basic/Reduced/Typical data centre setup</li><li>Traditional 3 layers network design/ Spine and Leaf network design</li><li>Select termination hardware</li><li>Administration design</li><li>ToR/EoR/Spine &amp; Leaf cabling design</li><li>Network and cabling resiliency</li><li>Create cabling schematic design for ToR/EoR</li><li>Convert into patch panel/rack layout</li><li>Calculate the material list for ToR/EoR</li></ul><h4>Building Backbone - Commercial Building</h4><ul><li>Backbone diagram</li><li>Calculate the copper backbone requirements per Telecom Room (TR)</li><li>Calculate the fibre backbone requirements per Telecom Room</li><li>Summarize the building backbone requirements</li><li>Recognised cables</li><li>Backbone Patch panels</li><li>The maximum backbone distances</li><li>Create cabling schematic design</li><li>Converting the schematic design into patch panel/ rack layout</li></ul><h4>Building Backbone - Data Centre</h4><ul><li>TIA-942 based backbone topology</li><li>TIA-942 backbone requirements</li><li>Recognised backbone cable</li><li>ToR/EoR/Spine and Leaf</li><li>Backbone distance estimation</li><li>Resiliency of backbone cable routes</li><li>Creating cabling schematic design</li><li>Converting the schematic design into patch panel/ rack layout</li><li>Field and Fusion Termination for fibre connectors</li><li>Pre-terminated fibre trunk and copper cables</li></ul><h4>Architectural Considerations</h4><ul><li>ANSI/TIA569-D Cable pathway and spaces</li><li>Common requirements for the rooms</li><li>Definition of the rooms</li><li>Entrance Room/Demarcation</li><li>Ceiling and floor pathways types</li><li>Cable trays/basket/ladder/conduit</li><li>Inner duct/sleeve/slot</li><li>Calculating of pathway size</li><li>Cable run best practices</li><li>Cable management/AIM</li><li>Grounding and bonding</li><li>Separation distance requirements for copper cabling to power cabling</li><li>Fire stopping</li><li>Fire rated barrier</li><li>Fire rated jacket cable</li></ul><h4>Campus / Outdoor Backbone</h4><ul><li>Common campus cable installation and cable types : Aerial cable / Direct-buried / Underground in-conduit</li><li>Outdoor cable installation planning</li><li>Lightning / surge protection</li><li>Approved ground for surge protector</li><li>Creating a schematic diagram</li><li>Converting a schematic into a physical layout</li></ul><h4>Site Inspection and Testing</h4><ul><li>Visual site inspection notes</li><li>Installation common issues</li><li>Copper testing standard</li><li>Permanent link / Channel / Patch cord / MPTL testing configuration</li><li>Fibre connectors</li><li>Fibre testing standard</li><li>Tier 1 &amp; 2 certification</li><li>Fibre link definition</li><li>Fibre testing steps</li><li>Fibre inspection and cleaning</li><li>Calibrating the test sets - 3 methods</li><li>Setting up mandrel for testing</li><li>Fibre loss budget calculation</li><li>G.657 Bend insensitive fibre</li><li>Optical Time-Domain Reflectometer (OTDR)</li></ul><h4>Exam - Certified Network Cabling Design Professional (CNCDPÂ©)</h4><ul><li>The exam is a 60-minute closed book exam, with 40 multiple-choice questions.</li><li>The candidate requires a minimum of 27 correct answers to pass the exam.</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Certified Network Cabling Design Professional (CNCDP) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Certified Network Cabling Design Professional (CNCDP) 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 Technology Specialist (CTS)

Cisco Certified Network Professional certification (CCNP)

Construction Design & Management (CDM)

Structured Cabling

IT Networking Fundamentals

Computer Networking

Certified Network Cabling Design Professional (CNCDP)

<p style="color: rgb(15, 21, 26); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(15, 21, 26);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Become a Certified User Experience Professional</strong></p><p style="color: rgb(15, 21, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);">Build a career in UX with the world&rsquo;s only university credit-rated online UX course. Acquire the mindset, the skills and the confidence that make UX designers so valuable. A rewarding and meaningful career awaits.</p><p style="color: rgb(15, 21, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Why become a UX designer?</strong></p><ul style="color: rgb(15, 21, 26); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Be in demand</strong><br fr-original-style="" style="box-sizing: border-box;">UX is a high-growth sector. The demand for UX designers far outstrips the supply of qualified professionals.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Get well paid</strong><br fr-original-style="" style="box-sizing: border-box;">UX designers are highly paid. The average entry-level salary for a UX designer in the United Kingdom is &pound;35,465 (PayScale, 2019)<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Love your job</strong><br fr-original-style="" style="box-sizing: border-box;">UX designers make an impact. They solve real-world problems using an exciting mix of research, design, technology and psychology.</li></ul><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;">Study method</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Online, self-paced</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Duration</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">6 months</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Access to content</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">12 months</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Qualification</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Level 8 Diploma - User Experience Design</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Awarded by Glasgow Caledonian University</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Regulated by SQA</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Additional info</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Exam(s) / assessment(s) is included in price</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Tutor is available to students</p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><section style="color: rgb(15, 21, 26); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(15, 21, 26);"><h2 fr-original-style="" style="box-sizing: border-box;">Description</h2><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Duration: 6 months<br fr-original-style="" style="box-sizing: border-box;"></strong>Get certified in six months following a flexible, structured learning path.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Delivery: Online<br fr-original-style="" style="box-sizing: border-box;"></strong>The course is delivered entirely online, including video modules, mentor-led webinars and support.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Assessment: 2-hour exam<br fr-original-style="" style="box-sizing: border-box;"></strong>Before getting certified, you&#39;ll be assessed during a two-hour exam taken online.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Outcomes for you</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Think like a UX designer; adopt the mindset that sets them apart</li><li fr-original-style="" style="box-sizing: border-box;">Showcase your knowledge with a portfolio of project work</li><li fr-original-style="" style="box-sizing: border-box;">Speak with the confidence that comes from a true, deep understanding of UX</li><li fr-original-style="" style="box-sizing: border-box;">Advance your career with job-ready skills</li><li fr-original-style="" style="box-sizing: border-box;">Complete a university credit-rated course, valued by employers globally</li><li fr-original-style="" style="box-sizing: border-box;">Become a Certified UX Professional</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Learn with us</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We&rsquo;ve worked hard to design the best possible online learning experience for you. As well as an unmatched syllabus, our approach includes:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Projects &amp; portfolio</strong><br fr-original-style="" style="box-sizing: border-box;">Learn by doing with a series of real-world projects ideal for your UX portfolio.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Mentors &amp; webinars</strong><br fr-original-style="" style="box-sizing: border-box;">Be guided by our hand-picked, world-class mentors during monthly webinars.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Structure &amp; support</strong><br fr-original-style="" style="box-sizing: border-box;">Stay motivated with a structured programme supported by fellow students and our customer success team.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What you&rsquo;ll learn</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We&rsquo;ve put together a university credit-rated curriculum that&rsquo;s deep, rigorous and<br fr-original-style="" style="box-sizing: border-box;">covers everything you need to know to become a certified UX professional and<br fr-original-style="" style="box-sizing: border-box;">turbocharge your career.</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Module 01</strong>&nbsp;- Introduction to UX design</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Module 02</strong>&nbsp;- User research</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Module 03</strong>&nbsp;- User goals</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Module 04</strong>&nbsp;- Structure and navigation</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Module 05</strong>&nbsp;- Interactions</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Module 06</strong>&nbsp;- Design principles</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Module 07</strong>&nbsp;- Design patterns</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Module 08</strong>&nbsp;- Mobile</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Module 09</strong>&nbsp;- Workflows</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Module 10</strong>&nbsp;- Prototyping and handover</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Module 11</strong> - AI and UX</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Module 12</strong> - Creating your portfolio</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Module 13</strong> - Career guidance Hub</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Tutorials for Figma</strong></li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Projects and portfolio</strong>&nbsp;- Projects that build into a portfolio</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Exam</strong>&nbsp;- 2-hour final exam</li></ul></section><section style="color: rgb(15, 21, 26); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><h2 fr-original-style="" style="box-sizing: border-box;">Requirements</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Background</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You don&rsquo;t need experience in design or technology to enrol in our courses, although having one or both is a definite bonus. Our students come from a diverse array of backgrounds, including project management, development, graphic design, product management, business analysis and so on.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Commitment</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You do need to be motivated and committed. We set a high bar. Studying for one of our professional qualifications requires a certain amount of time, energy and focus. Our team will be there to support you along every step of the way but success will come as a result of your own diligence.</p></section><section style="color: rgb(15, 21, 26); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><h2 fr-original-style="" style="box-sizing: border-box;">Career path</h2><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">The average salary for entry level user experience designers is &pound;28,000</li><li fr-original-style="" style="box-sizing: border-box;">The average salary for user experience designers with 1-5 years experience ranges from &pound;29,000 to &pound;50,000</li><li fr-original-style="" style="box-sizing: border-box;">The average salary for user experience managers/leads is &pound;80,000</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Information from LinkedIn Salary Reports, based on real jobs listings.</p></section>

UX Design Institute 

Product Design

UI / UX Design

Professional Diploma in UX Design

Southend on Sea

Droitwich Spa

Portsmouth

Rotherham

Leeds

Slough

Bingley

Newport

Peterborough

Milton Keynes 

Nottingham

Paisley

Birmingham

Luton

Hull

Northampton

Bedford

Liverpool 

Swansea

BASIC to ADVANCED COURSE PACKAGE

Complete 3 courses over 2 full days and receive three qualifications:

Introduction to Phlebotomy Certificate (Nationally Recognised Level 3, Ireland Level 5)
Days 1 and 2: 9.30am – 5.00pm

Advanced Phlebotomy Certificate (Nationally Recognised Level 4, Ireland Level 6)
Day 1: 5.30pm - 8.30pm

Geopace Certificate of Competency (Nationally Recognised Accredited, CPD Practical Skills)
Day 2: 5.30pm - 8.30pm

Please make sure you verify the precise dates and timings of your course when you receive your booking confirmation, as it may vary from the information provided above.






Key Facts & Summary:


COURSE 1: INTRODUCTION TO PHLEBOTOMY COURSE - NATIONALLY RECOGNISED AND ACCREDITED VENEPUCTURE COURSE
UK Level Three (Ireland Level Five)
DUALLY ACCREDITED - Open College Network (OCN) and The CPD Certification Service (21 CPD Points)

PART 1 (DAY 1) - 9.30am to 5.00pm
PART 2 (DAY 2) - 9.30am to 5.00pm

Adheres to World Health Organisation guidelines (meets or exceeds all guidelines) and Skills for Health Directive HSC376

A TWO DAY venepuncture course at Level 3. Trains up to the point of live blood draws.

On completion awards a Nationally Recognised and Accredited Certificate in Phlebotomy.

DAY ONE (PART 1) - THEORY
Attend the course location of your choice – starts at 9.30am and finishes approx. 5.00pm

DAY TWO (PART 2) - CLASSROOM
Your classroom tutor will recap on the theory element (above) after which you will begin your practical sessions learning and developing the skills required up to the point of Live Blood Draws.

DOWNLOAD A COURSE ITINERARY HERE



COURSE 2: ADVANCED PHLEBOTOMY COURSE - NATIONALLY RECOGNISED AND ACCREDITED VENEPUCTURE COURSE
UK Level Four (Ireland Level 6)
DUALLY ACCREDITED - Open College Network (OCN) and The CPD Certification Service (14 CPD Points)

PART 1 - THEORY
Complete your theory training online in the comfort of your own home or at work.

PART 2 - CLASSROOM
Follow on from your Day One Theory training, in the evening, from 5.30pm - 8.30pm

Adheres to World Health Organisation guidelines (meets or exceeds all guidelines) and Skills for Health Directive HSC376

Skills and Practical Development:
Covers advanced specialised phlebotomy techniques to give you the leading edge as a phlebotomist. Learn to use a wide range of non-routine equipment.

On completion awards a Nationally Recognised and Accredited Certificate in Advanced Phlebotomy.

DOWNLOAD A COURSE ITINERARY HERE



COURSE 3: ROUTE TO COMPETENCY MASTERCLASS
CPD ACCREDITED - The CPD Certification Service

CLASSROOM
Follow on from your Day Two practical training, in the evening, from 5.30pm - 8.30pm

Adheres to World Health Organisation guidelines (meets or exceeds all guidelines) and Skills for Health Directive HSC376

GEOPACE LIVE BLOOD SESSIONS enabling you to draw human blood under 1-to-1 supervision of your tutor. You will follow a Competency Checklist, signed off by your tutor on completion.

On completion awards a Geopace Certificate of Competency - Nationally Recognised and Accredited Route to Competency - Live Blood Draws Certificate

DOWNLOAD A COURSE ITINERARY HERE




How do I attend?

EITHER -
CLASSROOM OPTION - Attend one of our scheduled classroom locations, completing your Introduction to Phlebotomy Course over 2 days. You will also complete your Advanced Training at the end of the first day and your Competency Training at the end of the second day.

Our Introduction to Phlebotomy and Advanced Phlebotomy Training Kits are supplied at no charge when booking our virtual classroom training option.
If you would like to add one or both of these kits to your classroom training option then these are available to add at time of booking. Our comprehensive training kits each mirror the same equipment and supplies used in the classroom and both include detailed video tutorials, allowing you to continue to practice and "hone" your skills after you have completed your practical training.

OR -

VIRTUAL CLASSROOM OPTION- Complete your theory training online at home or work, then join us for a one day Zoom session to complete your Introduction to Phlebotomy virtual classroom training, followed by your Advanced Training in the evening of the same day. You have the option to add a classroom-based competency session, awarding a CPD Accredited Geopace Certificate of Competency, at time of booking.

Our Virtual Classroom option includes two very comprehensive training kits - one for your introductory course and one for your advanced course. Kits are included at no charge (normally £79.95 each) and are yours to keep and to continue to practice with after you have finished your courses. The equipment and supplies included in your kits are the same as those used if you choose the classroom option.

How do I book?

Choose whether you would like to attend in a classroom or if you would like to complete your training by virtual classroom.
Click on the Classroom - Booking Options or Virtual Classroom - Booking Options buttons below to see all upcoming dates and locations.

Please note - Competency Training
Our Route to Competency Masterclass - Live Blood Sessions can only be completed in a classroom environment. This is included when you book a classroom option. When booking the virtual classroom option you can choose to add this at time of booking. You will receive a voucher code to enable you to book onto any upcoming dates or locations. For most of our two day course we run our competency training at the end of the second day and therefore you should be able to complete your full training programme with us over two days.

If you are completing your training by virtual classroom please see our list of competency training locations here.

If you would like to "mix and match" your training dates and/or locations then please call our admin team on 01525 713377 who will be more than happy to put a training package together for you on dates and / or locations that suit you.

All courses are accredited and are Skills for Health & WHO compliant.

Geopace Training

Allied Health

Allied Health Professions (AHP)

Blood Taking

Healthcare Workers

Venepuncture

Phlebotomist

Phlebotomy

Accredited Phlebotomy

Healthcare

THIS COURSE PACKAGE INCLUDES:
1: INTRODUCTION TO PHLEBOTOMY COURSE (GPT003) - Level 3 (Ireland Level 5)
2: ADVANCED PHLEBOTOMY COURSE (GPT005) - Level 4 (Ireland Level 6)
3: GEOPACE COMPETENCY CERTIFICATE - CPD Certified (optional with Virtual Classroom)

Learn how to take blood ... train as a Phlebotomist

FAST-TRACK YOUR PHLEBOTOMY TRAINING

WITH OUR

COMPLETE TRAINING PACKAGE

20% off -  Multi-Course Discount

    Cover all stages from beginner through to Level 4

    Available as Classroom or Virtual Classroom

    Complete your beginner to advanced training in 2 days

    Awards 2 accredited qualifications - Introduction to Phlebotomy and Advanced Phlebotomy qualifications

    Both courses are dually accredited (OCN & CPD)

    Geopace Certificate of Competency included with classroom attendance or available as an option when booking virtual classroom

    Covers all steps up to live blood draw

    Learn advanced skills and techniques

    Virtual Classroom options include comprehensive Practise@Home Training Kits (yours to keep)

    Basic understanding of English language required

    OPEN TO ALL APPLICANTS


Phlebotomy Training - Beginner to Advanced PACKAGE

ONLINE STUDY + ONE DAY ZOOM SESSION
NO CLASSROOM ATTENDANCE REQUIRED


Awarding Body: Dual Accreditation - Open College Network (OCN Credit4Learning) & The CPD Certification Service (21 CPD Points)
 
Award Level: UK - Level Three (Advanced) + 21 CPD Points
Ireland Level Five (Advanced) + 21 CPD Points
 
Minimum Age: 18 (16 with parental consent)
 
Entry requirements: None. English Level 2 desirable
 
Training Locations: Study online + virtual classroom.
 
Practical Training: Includes FREE Practise@Home Phlebotomy Training Kit worth £79.99
This comprehensive 76 piece practical training kit includes mini-arm trainer, sharps container and all medical grade supplies needed as well as a step-by-step 30 minute training video.



PART 1 (THEORY) - STUDY AT HOME ONLINE :
Complete your theory training online in the comfort of your own home or at work. Stop/start when it suits you and complete the online modules at your own pace. Can be completed on multiple devices such as laptop, smart-phone, desktop computer, kindle, tablet etc.
 
PART 2 (PRACTICAL SESSIONS) - JOIN US FOR A COMPREHENSIVE ONE DAY ZOOM SESSION:
Full instructions will be provided. We will send you a completely free Practise@Home Phlebotomy Training Kit, including a mini-arm trainer, for you to keep. You will follow your tutor's on-screen instructions during your Zoom virtual classroom sessions as you learn and develop your phlebotomy skills. The procedures and practices taught online are exactly the same as you would learn in the classroom. At any time before or after your course you can watch our 30 minute step-by-step video to refresh your knowledge and continue to use your training kit to practice your skills.
 
(THIS COURSE AWARDS THE SAME NATIONALLY RECOGNISED AND DUALLY ACCREDITED QUALIFICATION AS OUR CLASSROOM AND HYBRID COURSE VERSIONS)


Please make sure you verify the precise dates and timings of your course when you receive your booking confirmation, as it may vary from the information provided above.


COURSE ITINERARY

 
A dually-accredited hybrid modular venepuncture course awarding an
OCN Accredited Level Three Certificate (3 credits) & 21 CPD Points


Nationally Recognised Qualification


Part 1 - online (eLearning) Part 2 - Virtual Classroom (1 Day Zoom)


PRE-COURSE
Home study pack - download and complete before the virtual classroom sessions

PART 1 - ONLINE
M01: Course Overview
M02: History, Definitions and Roles
M03: Work-flow cycles
M04: Professionalism
M05: Health & Safety
M06: Blood Collection Systems
M07: Anatomy & Physiology
M08: Blood Composition
M09: Using the equipment
M10: Performing the venepuncture - see Classroom Part 2
M11: Lab Tests and Bottle Types
M12: Analytical Errors
M13: Informal Quiz – answers
M14: Award – accredited certificates, value, application and overview. Job Opportunities.


PART 2 - VIRTUAL CLASSROOM (ONE DAY ZOOM SESSION)
M01: Introduction: Welcome, Introductions and Overview.
M10: Performing the venepuncture (theory overview)
P01: Practical Session 1 – Equipment familiarisation - "Tools of the Trade"
P02A: Practical Session 2A – Unpacking your training kit
P02B: Practical Session 2B - A look at the mini-arm trainer and associated equipment
P03: Practical Session 3 – Using the tourniquet and identifying a vein
P04: Practical Session 4 – Handling and assembling the equipment. Familiarisation and procedures including initial skill-set development
P05: Practical Session 5 - Further skill-set development and consolidation. Discussing needle types including winged infusion sets (butterfly needles)
P06A: Practical Session 6A – Performing the venepuncture on the mini-arm trainer. Palpating the vein, performing the venepuncture. Sample handling and labelling.
P06B: Practical Session 6B – Consolidating pre- and post-venepuncture procedures.
 
Additional support material can be downloaded as you progress through the course online.





ZOOM SESSION

VIRTUAL CLASSROOM (ZOOM) SESSIONS 
Our Virtual Classroom training course consists of online study (Part 1 - theory) and Virtual Classroom Zoom sessions (Part 2 - practical skill-set development)
You must complete your Part 1 online study before joining us for your Zoom session(s).
Once you have enrolled on this course you will be sent a free Practise@Home Training Kit, This is yours to keep and can be reused any many time as you wish after you have completed the course.
Your Booking Confirmation will include your Zoom log-in details.



Learn how to take blood ... train as a Phlebotomist

    Nationally Recognised Qualification

    No previous experience or qualifications needed

    OCN Accredited - Level 3 (advanced)

    CPD Accredited (The CPD Certification Service)

    Covers all steps up to live blood draw

    Practise on artificial arm and fake blood!

    Basic understanding of English language required

    OPEN TO ALL APPLICANTS


Introduction to Phlebotomy Course (GPT003VC) - 1 DAY Virtual Classroom

259 Courses in Coventry

Building Better Work Habits

By Inovra Group

Business Relationship Management Fundamentals: In-House Training

By IIL Europe Ltd

Microsoft Office 365 for End Users In-Company (now with live online classes)

By Microsoft Office Training

Microsoft Project Introduction - In-company

By Microsoft Office Training

Microsoft Excel Macros & VBA - In-company

By Microsoft Office Training

Microsoft Project Introduction/Intermediate - In-company

By Microsoft Office Training

Mental Health "First Aid" Course (£695 total for this 1-day course for a group of up to 12 people)

By Buon Consultancy

Microsoft Excel Introduction - In-company

By Microsoft Office Training

Microsoft Excel Intermediate - In-company

By Microsoft Office Training

Microsoft Excel Advanced - In-company

By Microsoft Office Training

Search By Location