Name: Advanced Excel Course (Formula, VLOOKUP & Power Query)
Price: 12 GBP
Availability: InStock

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>This intermediate course is designed for integration specialists and senior-level developers with experience in IBM Integration Bus application development.</p>Overview<p>After completing this course, you should be able to:Use event driven message processing to control the flow of messages by using message aggregation, message collections, message sequences, and time-sensitive nodesTransform data by using Microsoft .NET and XML stylesheetsAnalyze and filter information in complex XML documentsExtend DFDL message modelsUse message sets and the Message Repository Manager (MRM) parserProvide a message flow application as a web serviceRequest a web service from within a message flowDescribe how to implement WS-Addressing and WS-Security standards in IBM Integration BusCreate an integration serviceCreate and implement an IBM MQ request and response service definitionCreate and implement a database service definitionConfigure security-enabled message processing nodesCreate a decision service that implements business rules to provide routing, validation, and transformationExpose a set of integrations as a RESTful web serviceUse a global cache to store static dataRecord and replay data that a message flow application processesImplement publish and subscribe with IBM Integration BusDescribe the workload management options for adjusting the message processing speed, and controlling the actions that are taken on unresponsive flows and threadsConstruct user-defined patternsDescribe how IBM Integration Bus integrates with other IBM products such as IBM WebSphere Enterprise Service Bus and IBM DataPower Appliances</p><p>This course focuses on using IBM Integration Bus to develop, deploy, and support platform-independent message flow applications and integration services.</p></div><div id="course-pills-2"><h4>Course Outline</h4><ul><li>Course introduction</li><li>Using event driven processing nodes</li><li>Exercise: Implementing message aggregation</li><li>Transforming data with Microsoft .NET</li><li>Transforming data with XSL stylesheets</li><li>Analyzing XML documents</li><li>Modeling complex data with DFDL</li><li>Exercise: Extending a DFDL model</li><li>Working with message sets and the MRM domain</li><li>Supporting web services</li><li>Exercise: Implementing web services</li><li>Developing integration solutions by using integration services</li><li>Exercise: Creating an integration service</li><li>Connecting a database by using a discovered service</li><li>Connecting IBM MQ by using a discovered service</li><li>Exercise: Creating IBM MQ and database services</li><li>Creating a decision service</li><li>Exercise: Creating a decision service</li><li>Developing integration solutions by using a REST API</li><li>Using the global cache</li><li>Implementing message flow security</li><li>Exercise: Implementing IBM Integration Bus runtime security</li><li>Implementing publish/subscribe</li><li>Monitoring message flow events</li><li>Exercise: Recording and replaying message flow data</li><li>Managing the workload</li><li>Creating patterns for reusability</li><li>Extending IBM Integration Bus</li><li>Course summary</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans WM676 IBM Integration Bus V10 Application Development II 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 WM676 IBM Integration Bus V10 Application Development II course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Nexus Human

Service Design Courses (SDC)

MuleSoft Certified Integration Architect (MCIA)

IBM MQ

Manager Training

MuleSoft Certified Developer (MCD)

Trainers Course

WM676 IBM Integration Bus V10 Application Development II

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>Security-operations (SecOps), or security, orchestration, automation, and response (SOAR) engineers, managed security service providers (MSSPs), service delivery partners, system integrators, and professional services engineers</p>Overview<p>This training is designed to enable a SOC, CERT, CSIRT, or SOAR engineer to start working with Cortex XSOAR integrations, playbooks, incident-page layouts, and other system features to facilitate resource orchestration, process automation, case management, and analyst workflow.<br />The course includes coverage of a complete playbook-development process for automating a typical analyst workflow to address phishing incidents. This end-to-end view of the development process provides a framework for more focused discussions of individual topics that are covered in the course.</p><p>The Cortex? XSOAR 6.8: Automation and Orchestration (EDU-380) course is four days of instructor-led training that will help you:<br />Configure integrations, create tasks, and develop playbooks<br />Build incident layouts that enable analysts to triage and investigate incidents efficiently<br />Identify how to categorize event information and map that information to display fields<br />Develop automations, manage content, indicator data, and artifact stores, schedule jobs, organize users and user roles, oversee case management, and foster collaboration<br />This class is powered by Cloud Harmonics.</p></div><div id="course-pills-2"><h4>Course Outline </h4><ul><li>Module 1 - Core Functionality and Feature Sets</li><li>Module 2 - Enabling and Configuring Integrations</li><li>Module 3 - Playbook Development</li><li>Module 4 - Classification and Mapping</li><li>Module 5 - Layout Builder</li><li>Module 6 - Solution Architecture</li><li>Module 7 - Docker</li><li>Module 8 - Automation Development and Debugging</li><li>Module 9 - The Marketplace and Content Management</li><li>Module 10 - Indicators and Threat Intelligence Management</li><li>Module 11 - Jobs and Job Scheduling</li><li>Module 12 - Users and Role-Based Access Controls (RBAC)</li><li>Module 13 - Integration Development</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Palo Alto Networks: Cortex XSOAR 6.8: Automation and Orchestration(EDU-380) 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 Palo Alto Networks: Cortex XSOAR 6.8: Automation and Orchestration(EDU-380) 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>

Online Course Creation

Professional Agile Leadership (PAL)

Professional Skills Course (PSC)

Palo Alto Networks: Cortex XSOAR 6.8: Automation and Orchestration(EDU-380)

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>This course is designed for technical professionals who require the skills to administer IBMÂ© MQ queue managers on distributed operating systems, in the Cloud, or on the IBMÂ© MQ Appliance.</p>Overview<p>After completing this course, you should be able to:Describe the IBMÂ© MQ deployment optionsPlan for the implementation of IBMÂ© MQ on-premises or in the CloudUse IBMÂ© MQ commands and the IBMÂ© MQ Explorer to create and manage queue managers, queues, and channelsUse the IBMÂ© MQ sample programs and utilities to test the IBMÂ© MQ networkEnable a queue manager to exchange messages with another queue managerConfigure client connections to a queue managerUse a trigger message and a trigger monitor to start an application to process messagesImplement basic queue manager restart and recovery proceduresUse IBMÂ© MQ troubleshooting tools to identify the cause of a problem in the IBMÂ© MQ networkPlan for and implement basic IBMÂ© MQ security featuresUse accounting and statistics messages to monitor the activities of an IBMÂ© MQ systemDefine and administer a simple queue manager cluster</p><p>This course provides technical professionals with the skills that are needed to administer IBMÂ© MQ queue managers on distributed operating systems and in the Cloud. In addition to the instructor-led lectures, you participate in hands-on lab exercises that are designed to reinforce lecture content. The lab exercises use IBMÂ© MQ V9.0, giving you practical experience with tasks such as handling queue recovery, implementing security, and problem determination.<br />Note: This course does not cover any of the features of MQ for z/OS or MQ for IBMÂ© i.</p></div><div id="course-pills-2"><h4>Course introduction</h4><h4>IBMÂ© MQ review</h4><h4>IBMÂ© MQ installation and deployment options</h4><h4>Creating a queue manager and queues</h4><h4>Exercise: Using commands to create a queue manager and queues</h4><h4>Introduction to IBMÂ© MQ Explorer</h4><h4>Exercise: Using IBMÂ© MQ Explorer to create queue managers and queues</h4><h4>Testing the IBMÂ© MQ implementation</h4><h4>Exercise: Using IBMÂ© MQ sample programs to test the configuration</h4><h4>Implementing distributed queuing</h4><h4>Exercise: Connecting queue managers</h4><h4>IBMÂ© MQ clients</h4><h4>Exercise: Connecting an IBMÂ© MQ client</h4><h4>Implementing trigger messages and monitors</h4><h4>Exercise: Implementing a trigger monitor</h4><h4>Diagnosing problems</h4><h4>Exercise: Running an IBMÂ© MQ trace</h4><h4>Implementing basic security in IBMÂ© MQ</h4><h4>Exercise: Controlling access to IBMÂ© MQ</h4><h4>Backing up and restoring IBMÂ© MQ messages and object definitions</h4><h4>Exercise: Using a media image to restore a queue</h4><h4>Exercise: Backing up and restoring IBMÂ© MQ object definitions</h4><h4>Introduction to queue manager clusters</h4><h4>Exercise: Implementing a basic cluster</h4><h4>Monitoring and configuring IBMÂ© MQ for performance</h4><h4>Exercise: Monitoring IBMÂ© MQ for performance</h4><h4>Course summary</h4></div>

Project Management Qualification (PMQ)

Microsoft Virtual Academy (MVA)

Certified Manager of Quality

PQMS

WM153 IBM MQ V9 System Administration (using Windows for labs)

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>This comprehensive course on <strong>Mechanical Engineering</strong> will deepen your understanding on this topic.</p><p>After successful completion of this course you can acquire the required skills in this sector. This <strong>Mechanical Engineering</strong> comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.</p><p>So enrol in this course today to fast track your career ladder.</p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>There is no experience or previous qualifications required for enrolment on this <strong>Mechanical Engineering</strong>. It is available to all students, of all academic backgrounds.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>Our <strong>Mechanical Engineering</strong> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.</p><p>There is no time limit for completing this course, it can be studied in your own time at your own pace.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-</span></p><ul><li>Open doors of opportunities</li><li>Increase your adaptability</li><li>Keep you relevant</li><li>Boost confidence</li></ul><p>And much more!</p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>14 sections • 68 lectures • 07:29:00 total length</p></div><div><div><div><div><div><div><div><p>•Lecture 1 Introduction: 00:02:00</p></div><div><div><p>•Lecture 2 Multiplying any digit number by 11, 22, and 33: 00:09:00</p></div><div><div><p>•Lecture 3 Integers and ordering of integers: 00:06:00</p></div><div><div><p>•: 00:00:00</p></div><div><div><p>•Lecture 5 Operations on Integers: 00:04:00</p></div><div><div><p>•Lecture 6 Multiplication and Division of Integers: 00:04:00</p></div><div><div><p>•Lecture 7 Powers of Integers (Exponents): 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 8 Complete knowledge about factors and multiples: 00:06:00</p></div><div><div><p>•Lecture 9 Divisibility tests for 2,3,4,5,6: 00:07:00</p></div><div><div><p>•Lecture 10 Divisibility rules 7,8,9,10,11: 00:06:00</p></div><div><div><p>•Lecture 11 Prime Factorization: 00:06:00</p></div><div><div><p>•Lecture 12 Highest Common Factor HCF: 00:10:00</p></div><div><div><p>•Lecture 13 Least Common Multiple LCM: 00:16:00</p></div><div><div><p>•Lecture 14 Relation between LCM and HCF: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 15 Classification of Fractions: 00:04:00</p></div><div><div><p>•Lecture 16 Convert mixed to improper and improper to mixed fractions: 00:03:00</p></div><div><div><p>•Lecture 17 Equivalent Fractions: 00:04:00</p></div><div><div><p>•Lecture 18 Comparing Fractions after converting to like fractions: 00:09:00</p></div><div><div><p>•Lecture 19 Reducing a fraction to lowest term: 00:04:00</p></div><div><div><p>•Lecture 20 Addition and subtraction OF fractions: 00:08:00</p></div><div><div><p>•Lecture 21 Multiplication and division of fractions: 00:11:00</p></div><div><div><p>•Lecture 22 Word problems on fractions: 00:16:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 23 BODMAS and rules to remove brackets: 00:03:00</p></div><div><div><p>•Lecture 24 Simplify expressions using BODMAS rules: 00:05:00</p></div><div><div><p>•Lecture 25 Simplify expressions involving fractions using BODMAS: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 26 Decimal numbers in relation to fractions: 00:08:00</p></div><div><div><p>•Lecture 27 Like and unlike Decimals: 00:05:00</p></div><div><div><p>•Lecture 28 Ordering of Decimal numbers: 00:10:00</p></div><div><div><p>•Lecture 29 Addition and subtraction of Decimal: 00:07:00</p></div><div><div><p>•Lecture 30 Multiplication of Decimal: 00:03:00</p></div><div><div><p>•Lecture 31 Division of Decimal: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 32 Rational number: 00:02:00</p></div><div><div><p>•Lecture 33 Representation of Rational Numbers on Number line: 00:04:00</p></div><div><div><p>•Lecture 34 Determining which fraction is terminating or non terminating: 00:05:00</p></div><div><div><p>•Lecture 35 shortcut method of writing decimal expansion of fraction to decimal: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 36 Rounding to whole number: 00:06:00</p></div><div><div><p>•Lecture 37 Rounding to required number of decimals (1 d.p. ): 00:05:00</p></div><div><div><p>•Lecture 38 rounding to significant digits: 00:07:00</p></div><div><div><p>•Lecture 39 Practice question on three methods of approximation: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 40 Estimation: 00:05:00</p></div><div><div><p>•Lecture 41 Scientific Notation: 00:07:00</p></div><div><div><p>•Lecture 42 Operation on numbers when they are in scientific notation: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 43 Percentage to fraction and fraction to percentage: 00:06:00</p></div><div><div><p>•Lecture 44 Percentage of a quantity and conversation to decimal: 00:06:00</p></div><div><div><p>•Lecture 45 Expressing one quantity as percentage of another quantity: 00:06:00</p></div><div><div><p>•Lecture 46 Finding increase decrease percent: 00:05:00</p></div><div><div><p>•Lecture 47 Uses of percentages-Word Problems: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 48 Ratio- How to express as simple ratio: 00:09:00</p></div><div><div><p>•Lecture 49 How to compare Ratios: 00:04:00</p></div><div><div><p>•Lecture 50 Word problems on finding ratios: 00:07:00</p></div><div><div><p>•Lecture 51To divide a given quantity into a given Ratio: 00:11:00</p></div><div><div><p>•Lecture 52 Proportion: 00:04:00</p></div><div><div><p>•Lecture 53 Practice problems on Proportion: 00:06:00</p></div><div><div><p>•Lecture 54 Continued proportion: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 55 Direct Variation ( or proportion): 00:04:00</p></div><div><div><p>•Lecture 56 Problems based on Direct proportion: 00:10:00</p></div><div><div><p>•Lecture 57 Inverse Variation ( or proportion): 00:10:00</p></div><div><div><p>•Lecture 58 Multiple Ratios: 00:10:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 59 Basics - Profit and Loss: 00:04:00</p></div><div><div><p>•Lecture 60 More practice problems on Profit &amp; Loss: 00:06:00</p></div><div><div><p>•Lecture 61 Selling price formula and Problems: 00:04:00</p></div><div><div><p>•Lecture 62 Cost price formula and Problems: 00:03:00</p></div><div><div><p>•Lecture 63 Higher problems on Profit and Loss: 00:08:00</p></div><div><div><p>•Lecture 64 Basics - Discount.mp4: 00:05:00</p></div><div><div><p>•Lecture 65 Practice problems on Discount: 00:04:00</p></div><div><div><p>•Lecture 66 Tax: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Mock Exam - Functional Skills Maths Teacher: 00:20:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Final Exam - Functional Skills Maths Teacher: 00:20:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Apex Learning

Mechanical Engineering

Computing Skills

Maths Teacher

Further Maths

Computer Skills

Functional Skills Maths Teacher

General Admission

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>This comprehensive course on <strong>Mastering Java for Beginners &amp; Experts</strong> will deepen your understanding on this topic.</p><p>After successful completion of this course you can acquire the required skills in this sector. This <strong>Mastering Java for Beginners &amp; Experts</strong> comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.</p><p>So enrol in this course today to fast track your career ladder.</p><section></section>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
								</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>There is no experience or previous qualifications required for enrolment on this Mastering Java for Beginners &amp; Experts. It is available to all students, of all academic backgrounds.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>Our Mastering Java for Beginners &amp; Experts is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.</p><p>There is no time limit for completing this course, it can be studied in your own time at your own pace.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-</p><ul><li>Open doors of opportunities</li><li>Increase your adaptability</li><li>Keep you relevant</li><li>Boost confidence</li></ul><p>And much more!</p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>13 sections • 70 lectures • 05:35:00 total length</p></div><div><div><div><div><div><div><div><p>•Introduction To This Course.: 00:02:00</p></div><div><div><p>•Setup Eclipse On Windows: 00:05:00</p></div><div><div><p>•Setup Eclipse On Mac OS X: 00:05:00</p></div><div><div><p>•Setup Eclipse On Linux: 00:05:00</p></div><div><div><p>•Run Code Online: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Printing To The Console: 00:04:00</p></div><div><div><p>•Comments.: 00:06:00</p></div><div><div><p>•Variables.: 00:05:00</p></div><div><div><p>•Datatypes: 00:16:00</p></div><div><div><p>•Constant Variables: 00:03:00</p></div><div><div><p>•Console Input: 00:04:00</p></div><div><div><p>•Operators: 00:06:00</p></div><div><div><p>•If statement (Conditional Statement): 00:08:00</p></div><div><div><p>•Switch statement (Conditional Statement): 00:07:00</p></div><div><div><p>•For Loop.: 00:05:00</p></div><div><div><p>•While Loop.: 00:05:00</p></div><div><div><p>•Do While Loop.: 00:05:00</p></div><div><div><p>•Loop Control Statements: 00:03:00</p></div><div><div><p>•Numbers: 00:08:00</p></div><div><div><p>•Characters: 00:06:00</p></div><div><div><p>•Strings.: 00:05:00</p></div><div><div><p>•Arrays: 00:08:00</p></div><div><div><p>•For Each Loop: 00:04:00</p></div><div><div><p>•Date &amp; Time: 00:04:00</p></div><div><div><p>•Regular Expressions.: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Simple Example 1: 00:05:00</p></div><div><div><p>•Passing Values To Functions: 00:03:00</p></div><div><div><p>•Method Overloading: 00:05:00</p></div><div><div><p>•Command Line Arguments: 00:04:00</p></div><div><div><p>•Multiple Arguments Simplified: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Byte Streams: 00:07:00</p></div><div><div><p>•Character Streams: 00:02:00</p></div><div><div><p>•Standard Streams: 00:04:00</p></div><div><div><p>•Listing Files &amp; Folders: 00:02:00</p></div><div><div><p>•Creating Folders: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Simple Example 2: 00:05:00</p></div><div><div><p>•Multiple Catch Blocks: 00:04:00</p></div><div><div><p>•Throw and Throws Keywords: 00:03:00</p></div><div><div><p>•Finally Block: 00:03:00</p></div><div><div><p>•User Created Exceptions: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Simple Class Example: 00:08:00</p></div><div><div><p>•Constructor: 00:04:00</p></div><div><div><p>•This keyword: 00:05:00</p></div><div><div><p>•Inheritance.: 00:06:00</p></div><div><div><p>•Modifier Types: 00:04:00</p></div><div><div><p>•Overriding: 00:05:00</p></div><div><div><p>•Abstraction: 00:05:00</p></div><div><div><p>•Interfaces: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Enum: 00:03:00</p></div><div><div><p>•Stacks.: 00:04:00</p></div><div><div><p>•Vector.: 00:06:00</p></div><div><div><p>•BitSet: 00:05:00</p></div><div><div><p>•Properties: 00:05:00</p></div><div><div><p>•Hashtable: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•List.: 00:04:00</p></div><div><div><p>•Set.: 00:04:00</p></div><div><div><p>•SortedSet: 00:03:00</p></div><div><div><p>•Map: 00:03:00</p></div><div><div><p>•Map.Entry: 00:03:00</p></div><div><div><p>•Sorted Map: 00:02:00</p></div><div><div><p>•Enumeration.: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Client Example.: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Server Example.: 00:11:00</p></div><div><div><p>•Creating Threads Using a Runnable Interface: 00:09:00</p></div><div><div><p>•Creating Threads by Extending a Thread Class: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Simple Example 3: 00:04:00</p></div><div><div><p>•Keyboard Events: 00:04:00</p></div><div><div><p>•Mouse Events: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Resource.: 00:00:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Assignment - Mastering Java for Beginners &amp; Experts: 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Online Course Marketing

Computer Programming

Mastering Java for Beginners & Experts

<h2><b>Overview</b></h2>
<span>This </span><b>Microsoft Excel Course for Everyone - Complete Excel Course</b><span> is your passport to spreadsheet mastery.</span>

<span>Explore Excel in detail and improve your abilities with practical activities that go beyond boring lectures. Take on spreadsheets like an expert, from data entry to difficult formulas and eye-catching graphics. </span>

<span>But the magic doesn't end there! After finishing successfully, you'll not only impress with your proficiency with Excel, but you'll also obtain a respected <strong>CPD certification</strong> to enhance your CV and make a statement in the job market. Consider it your golden ticket to go up in your job!</span>

<span>Enrol right away to see how your confidence and chances rise! Don't wait!</span>
<h2><b>How will I get my certificate?</b></h2>
<span>You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.</span>
<h2><b>Who is This course for?</b></h2>
<span>There is no experience or previous qualifications required for enrolment on this </span><b>Microsoft Excel Course for Everyone - Complete Excel Course</b><span>. It is available to all students, of all academic backgrounds.</span>
<h2><b>Requirements</b></h2>
<ul>
 	<li><span>Compatible with a wide range of gadgets, including smartphones, tablets, laptops, Macs, and PCs.</span></li>
 	<li><span>Particularly designed to be easily accessed with an internet connection on tablets and smartphones.</span></li>
 	<li><span>No strict deadlines; learn whenever it's convenient for you.</span></li>
 	<li><span>Individuals with basic English proficiency.</span></li>
</ul>
<h2><b>Career Path</b></h2>
<span>After completing this course, it will increase the value of your CV and open you up to multiple sectors, such as :  </span>
<ul>
 	<li><b>Data Analyst: </b><span>£25,000 - £50,000 per year</span></li>
 	<li><b>Financial Analyst:</b><span> £30,000 - £60,000 per year</span></li>
 	<li><b>Operations Manager:</b><span> £35,000 - £70,000 per year</span></li>
 	<li><b>Accountant:</b><span> £25,000 - £50,000 per year</span></li>
 	<li><b>Business Intelligence Analyst:</b><span> £35,000 - £65,000 per year</span></li>
</ul>
<span>These salary ranges can vary based on factors such as experience, location, and the specific industry of the business.</span> <h3>Course Curriculum</h3><div><p>15 sections • 80 lectures • 06:51:00 total length</p></div><div><div><div><div><div><div><div><p>•Introduction: 00:03:00</p></div><div><div><p>•Course Curriculum: 00:04:00</p></div><div><div><p>•Getting started on Windows, macOS, Android, and IOS: 00:01:00</p></div><div><div><p>•How to ask great questions: 00:02:00</p></div><div><div><p>•FAQ's: 00:01:00</p></div><div><div><p>•Starting Excel: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:02:00</p></div><div><div><p>•Worksheet basics: 00:22:00</p></div><div><div><p>•Entering values and formulas: 00:12:00</p></div><div><div><p>•Data formats: 00:10:00</p></div><div><div><p>•Data handling basics - cut copy and paste: 00:07:00</p></div><div><div><p>•Save and print in excel: 00:10:00</p></div><div><div><p>•Excel Ranges: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:01:00</p></div><div><div><p>•Basic formula operations: 00:06:00</p></div><div><div><p>•Mathematical functions level 1: 00:20:00</p></div><div><div><p>•Mathematical functions level 2: 00:12:00</p></div><div><div><p>•Text functions level 1: 00:09:00</p></div><div><div><p>•Text functions level 2: 00:13:00</p></div><div><div><p>•Logical functions: 00:11:00</p></div><div><div><p>•Date time functions: 00:06:00</p></div><div><div><p>•V Lookup formula: 00:12:00</p></div><div><div><p>•HLookup formula: 00:04:00</p></div><div><div><p>•HLookup + Match formula: 00:09:00</p></div><div><div><p>•Match + Index formula: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:02:00</p></div><div><div><p>•XLookup: 00:08:00</p></div><div><div><p>•Handling #NA and Approximates match in XLookup: 00:11:00</p></div><div><div><p>•Wildcard matching in XLookup: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:02:00</p></div><div><div><p>•Split text into columns: 00:07:00</p></div><div><div><p>•Flash Fill: 00:07:00</p></div><div><div><p>•Remove Duplicates: 00:08:00</p></div><div><div><p>•Data Validation: 00:07:00</p></div><div><div><p>•Get- import Data from Text: 00:06:00</p></div><div><div><p>•Get - import Data from CSV: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:01:00</p></div><div><div><p>•Formatting Font: 00:04:00</p></div><div><div><p>•Formatting Alignment: 00:06:00</p></div><div><div><p>•Formatting Number: 00:05:00</p></div><div><div><p>•Formatting Date: 00:03:00</p></div><div><div><p>•Formatting tables: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:01:00</p></div><div><div><p>•Creating Pivot Table: 00:07:00</p></div><div><div><p>•Value field settings: 00:04:00</p></div><div><div><p>•Number format: 00:02:00</p></div><div><div><p>•Pivot Table Design: 00:03:00</p></div><div><div><p>•Excel Exercise: 00:01:00</p></div><div><div><p>•Solution for Excel Exercise: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:01:00</p></div><div><div><p>•Excel Charts - Categories: 00:03:00</p></div><div><div><p>•Elements of a chart: 00:04:00</p></div><div><div><p>•Easy way to create charts: 00:02:00</p></div><div><div><p>•Column or Bar charts: 00:04:00</p></div><div><div><p>•Formatting charts: 00:04:00</p></div><div><div><p>•Line charts: 00:02:00</p></div><div><div><p>•Area charts: 00:02:00</p></div><div><div><p>•Pie and Doughnut charts: 00:04:00</p></div><div><div><p>•Format AreaPlot or XY chart: 00:08:00</p></div><div><div><p>•Scatter or bubble charts: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:01:00</p></div><div><div><p>•Frequency Distribution and Histograms: 00:04:00</p></div><div><div><p>•Waterfall charts: 00:02:00</p></div><div><div><p>•Hierarchy charts: sunburst and tree map: 00:03:00</p></div><div><div><p>•Combination charts: 00:02:00</p></div><div><div><p>•Sparklines: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Pivot charts: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Maps chart: 00:04:00</p></div><div><div><p>•3D Maps chart: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:01:00</p></div><div><div><p>•Stock charts: 00:02:00</p></div><div><div><p>•Radar charts: 00:02:00</p></div><div><div><p>•Surface charts: 00:02:00</p></div><div><div><p>•Heat maps: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Named ranges: 00:05:00</p></div><div><div><p>•Indirect Name range Function: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Import Data table from PDF file - Excel 2021: 00:04:00</p></div><div><div><p>•Import Data from Website - Excel 2019 above: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Project: Sales forecast tracker: 00:07:00</p></div><div><div><p>•Product Sale Tax invoice: Tax Calculations: 00:05:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Microsoft Certification

Finance Cert & Exam Prep

Microsoft Excel

Spreadsheet

Microsoft Excel Course for Everyone - Complete Excel Course

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>This comprehensive course on <b>Workshop Technology: Machine Shop Theory</b> will deepen your understanding on this topic.</span></p><p><span>After successful completion of this course you can acquire the required skills in this sector. This <b>Workshop Technology: Machine Shop Theory</b> comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.</span></p><p><span>So enrol in this course today to fast track your career ladder.</span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
								</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>There is no experience or previous qualifications required for enrolment on this <b>Workshop Technology: Machine Shop Theory</b>. It is available to all students, of all academic backgrounds.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Our <b>Workshop Technology: Machine Shop Theory</b> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.</span></p><p><span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business &amp; Management, Admin, Accountancy &amp; Finance, Secretarial &amp; PA, Teaching &amp; Mentoring etc.</span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>9 sections • 41 lectures • 02:20:00 total length</p></div><div><div><div><div><div><div><div><p>•Scope of the Course: 00:10:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Metal Cutting Processes: 00:02:00</p></div><div><div><p>•Cutting Tools: 00:03:00</p></div><div><div><p>•Nomenclature of Single Point Cutting Tool: 00:04:00</p></div><div><div><p>•Tool Signature: 00:02:00</p></div><div><div><p>•Mechanics of Metal Cutting: 00:04:00</p></div><div><div><p>•Types of Chips: 00:03:00</p></div><div><div><p>•Coolant or Cutting Fluids: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Types of Lathe Machine: 00:09:00</p></div><div><div><p>•Construction of A Lathe: 00:09:00</p></div><div><div><p>•Accessories and Attachments: 00:07:00</p></div><div><div><p>•Specification of Lathe: 00:02:00</p></div><div><div><p>•Lathe Operations: 00:02:00</p></div><div><div><p>•Taper and Taper Turning: 00:04:00</p></div><div><div><p>•Thread Cutting: 00:03:00</p></div><div><div><p>•Cutting Speed and Feed: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Construction of A Drilling Machine: 00:04:00</p></div><div><div><p>•Types of Drilling Machine: 00:09:00</p></div><div><div><p>•Types of Drills: 00:03:00</p></div><div><div><p>•Twist Drill Geometry: 00:04:00</p></div><div><div><p>•Drilling Operations: 00:05:00</p></div><div><div><p>•Size of Drilling Machine: 00:01:00</p></div><div><div><p>•Cutting Speed and Feed: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Working Principle: 00:03:00</p></div><div><div><p>•Types of Shaper: 00:01:00</p></div><div><div><p>•Parts of Shaper: 00:05:00</p></div><div><div><p>•Shaper Mechanism: 00:04:00</p></div><div><div><p>•Shaper Operations: 00:01:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Types of Planer: 00:01:00</p></div><div><div><p>•Working Principle: 00:02:00</p></div><div><div><p>•Difference Between Shaper and Planer: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Principle Parts of Slotter: 00:03:00</p></div><div><div><p>•Slotter Operations: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Working Principle: 00:02:00</p></div><div><div><p>•Milling Methods: 00:03:00</p></div><div><div><p>•Types of Milling Cutters: 00:01:00</p></div><div><div><p>•Types of Milling Machines: 00:07:00</p></div><div><div><p>•Size of Milling Machine: 00:01:00</p></div><div><div><p>•Indexing and Dividing Head: 00:02:00</p></div><div><div><p>•Milling Operations: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Assignment - Workshop Technology: Machine Shop Theory: 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Design & Technology Courses (DT)

Machining

Workshop Technology: Machine Shop Theory

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>This comprehensive course on <strong>Microsoft Excel - 25 Must-Know Formulas and Functions </strong></span><span>will deepen your understanding on this topic.</span></p><p><span>After successful completion of this course you can acquire the required skills in this sector. This <strong>Microsoft Excel - 25 Must-Know Formulas and Functions</strong></span><b> </b><span>comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.   </span></p><p><span>So enrol in this course today to fast-track your career ladder.</span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>There is no experience or previous qualifications required for enrolment on this <strong>Microsoft Excel - 25 Must-Know Formulas and Functions</strong></span><span>. It is available to all students, of all academic backgrounds.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Our <strong>Microsoft Excel - 25 Must-Know Formulas and Functions</strong></span><span> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.</span></p><p><span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-</span></p><ul><li><span>Open doors of opportunities</span></li><li><span>Increase your adaptability</span></li><li><span>Keep you relevant</span></li><li><span>Boost confidence</span></li></ul><p><span>And much more!</span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>2 sections • 2 lectures • 01:12:00 total length</p></div><div><div><div><div><div><div><div><p>•Must-Know Formulas and Functions: 01:12:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Resource - Microsoft Excel - 25 Must-Know Formulas and Functions: 00:00:00</p></div></div></div></div></div></div></div></div>

Microsoft Office

Microsoft Certified Trainer (MCT)

Microsoft Excel - 25 Must-Know Formulas and Functions

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>This comprehensive course on <strong>Data Analysis and Forecasting in Excel</strong> will deepen your understanding on this topic.</p><p>After successful completion of this course you can acquire the required skills in this sector. This <strong>Data Analysis and Forecasting in Excel</strong> comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.</p><p>So enrol in this course today to fast track your career ladder.</p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
								</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>There is no experience or previous qualifications required for enrolment on this <strong>Data Analysis and Forecasting in Excel</strong>. It is available to all students, of all academic backgrounds.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>Our <strong>Data Analysis and Forecasting in Excel</strong> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.</p><p>There is no time limit for completing this course, it can be studied in your own time at your own pace.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-</span></p><ul><li>Open doors of opportunities</li><li>Increase your adaptability</li><li>Keep you relevant</li><li>Boost confidence</li></ul><p>And much more!</p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>10 sections • 31 lectures • 04:43:00 total length</p></div><div><div><div><div><div><div><div><p>•Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00</p></div><div><div><p>•Search for and Replace Data: 00:09:00</p></div><div><div><p>•Use Proofing and Research Tools: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Sort Data: 00:10:00</p></div><div><div><p>•Filter Data: 00:10:00</p></div><div><div><p>•Query Data with Database Functions: 00:09:00</p></div><div><div><p>•Outline and Subtotal Data: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Apply Intermediate Conditional Formatting: 00:07:00</p></div><div><div><p>•Apply Advanced Conditional Formatting: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create Charts: 00:13:00</p></div><div><div><p>•Modify and Format Charts: 00:12:00</p></div><div><div><p>•Use Advanced Chart Features: 00:12:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create a PivotTable: 00:13:00</p></div><div><div><p>•Analyze PivotTable Data: 00:12:00</p></div><div><div><p>•Present Data with PivotCharts: 00:07:00</p></div><div><div><p>•Filter Data by Using Timelines and Slicers: 00:11:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Use Links and External References: 00:12:00</p></div><div><div><p>•Use 3-D References: 00:06:00</p></div><div><div><p>•Consolidate Data: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Use Lookup Functions: 00:12:00</p></div><div><div><p>•Trace Cells: 00:09:00</p></div><div><div><p>•Watch and Evaluate Formulas: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Apply Data Validation: 00:13:00</p></div><div><div><p>•Search for Invalid Data and Formulas with Errors: 00:04:00</p></div><div><div><p>•Work with Macros: 00:18:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create Sparklines: 00:07:00</p></div><div><div><p>•MapData: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Determine Potential Outcomes Using Data Tables: 00:08:00</p></div><div><div><p>•Determine Potential Outcomes Using Scenarios: 00:09:00</p></div><div><div><p>•Use the Goal Seek Feature: 00:04:00</p></div><div><div><p>•Forecasting Data Trends: 00:05:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Excel Analytics

Data Skills

Data Analyst

Data Analysis and Forecasting in Excel

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>This comprehensive course on </span><b><span>Advanced Excel Course (Formula, VLOOKUP &amp; Power Query)</span></b> will deepen your understanding on this topic. <span><span>After successful completion of this course you can acquire the required skills in this sector. This </span><b>Advanced Excel Course (Formula, VLOOKUP &amp; Power Query)</b> comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.</span></p><p><span><span>So enrol in this course today to fast track your career ladder.</span></span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
								</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>There is no experience or previous qualifications required for enrolment on this </span><b><span>Advanced Excel Course (Formula, VLOOKUP &amp; Power Query)</span></b>. It is available to all students, of all academic backgrounds.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Our </span><b><span>Advanced Excel Course (Formula, VLOOKUP &amp; Power Query)</span></b> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. <span><span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span></span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-</p><ul><li>Open doors of opportunities</li><li>Increase your adaptability</li><li>Keep you relevant</li><li>Boost confidence</li></ul><p>And much more!</p><p> </p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>5 sections • 41 lectures • 02:56:00 total length</p></div><div><div><div><div><div><div><div><p>•How to Get the most of the course: 00:01:00</p></div><div><div><p>•Text formulas in Excel: 00:08:00</p></div><div><div><p>•Text Formulas Exercise: 00:01:00</p></div><div><div><p>•Text Formulas Exercise (answers): 00:01:00</p></div><div><div><p>•Mathematical Formulas In Excel: 00:04:00</p></div><div><div><p>•Mathematical Formulas Exercise: 00:01:00</p></div><div><div><p>•Mathematical Formulas Exercise (answers): 00:01:00</p></div><div><div><p>•Date and Time Formulas In Excel: 00:05:00</p></div><div><div><p>•Date and Time Formulas Exercise: 00:01:00</p></div><div><div><p>•Date and Time Exercise Formulas (answers): 00:01:00</p></div><div><div><p>•Logic Formulas In Excel: 00:12:00</p></div><div><div><p>•Logic Formula Exercise: 00:01:00</p></div><div><div><p>•Logic Formula Exercise (answers): 00:01:00</p></div><div><div><p>•Financial Formula In Excel: 00:06:00</p></div><div><div><p>•Financial Formula Exercise: 00:01:00</p></div><div><div><p>•Financial Formula Exercise (answers): 00:02:00</p></div><div><div><p>•Informational Formula In Excel: 00:04:00</p></div><div><div><p>•Informational Formula Exercise: 00:01:00</p></div><div><div><p>•Informational Formula Exercise (answers): 00:01:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Menu Example with Excel Vlookup: 00:08:00</p></div><div><div><p>•Wildcard Search with Excel Vlookup: 00:09:00</p></div><div><div><p>•Looking to the Left with Excel Vlookup: 00:17:00</p></div><div><div><p>•2-Way Lookup: 00:14:00</p></div><div><div><p>•Comparing Lists with Excel Vlookup: 00:03:00</p></div><div><div><p>•Microsoft Excel Vlookup Tips and Tricks: 00:14:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Power Query Intro and Excel version: 00:03:00</p></div><div><div><p>•Excel Power Query - Introduction: 00:03:00</p></div><div><div><p>•Enabling M in Power Query: 00:02:00</p></div><div><div><p>•Transform Data - Trim in Excel Power Query: 00:05:00</p></div><div><div><p>•Transform Data - Format Dates and Values in Excel Power Query: 00:02:00</p></div><div><div><p>•Simple Expressions: 00:08:00</p></div><div><div><p>•Simple Expressions - Nested Expressions: 00:03:00</p></div><div><div><p>•Transform Data - Parsing URLs in Excel Power Query: 00:05:00</p></div><div><div><p>•Variables: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Formatting Excel Keyboard Shortcuts: 00:02:00</p></div><div><div><p>•Table Excel Keyboard Shortcuts: 00:02:00</p></div><div><div><p>•Editing Excel Keyboard Shortcuts: 00:05:00</p></div><div><div><p>•Formula Excel Keyboard Shortcuts: 00:03:00</p></div><div><div><p>•Workbook Excel Keyboard Shortcuts: 00:02:00</p></div><div><div><p>•Handy Excel Shortcuts Keyboard Shortcuts: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Assignment - Advanced Excel Course (Formula, VLOOKUP &amp; Power Query): 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Advanced Excel Course (Formula, VLOOKUP & Power Query)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is targeted toward an IT Professional that has the technical knowledge and skills required to conceptualize, design, and engineer secure solutions across complex enterprise environments. Students should have a minimum of 10 years experience including at least 5 years of hands-on technical security experience.</p>Overview<p>Upon successful completion of this course, students will be able to:  Identify enterprise security fundamentals.  Apply enterprise security technology solutions.  Implement security design and solutions.  Manage risk, policies and procedures within an enterprise.  Integrate security solutions within an enterprise.  Conduct security research and analysis.</p><p>In this course, students will examine advanced security concepts, principles, and implementations that pertain to enterprise level security.</p>Prerequisites<p></p><ul><li>CompTIA Cybersecurity Analyst (CySA+) Certification</li></ul><p></p></div><div id="course-pills-2"><h3>1 - Enterprise Security Architecture</h3> <ul> <li>The Basics of Enterprise Security</li> <li>The Enterprise Structure</li> <li>Enterprise Security Requirements</li> </ul> <h3>2 - Enterprise Security Technology</h3> <ul> <li>Common Network Security Components and Technologies</li> <li>Communications and Collaboration Security</li> <li>Cryptographic Tools and Techniques</li> <li>Advanced Authentication</li> </ul> <h3>3 - Enterprise Resource Technology</h3> <ul> <li>Enterprise Storage Security Issues</li> <li>Distributed, Shared, and Virtualized Computing</li> <li>Cloud Computing and Security</li> </ul> <h3>4 - Security Design and Solutions</h3> <ul> <li>Network Security Design</li> <li>Conduct a Security Assessment</li> <li>Host Security</li> </ul> <h3>5 - Application Security Design</h3> <ul> <li>Application Security Basics</li> <li>Web Application Security</li> </ul> <h3>6 - Managing Risk, Security Policies, and Security Procedures</h3> <ul> <li>Analyze Security Risk</li> <li>Implement Risk Mitigation Strategies and Controls</li> <li>Implement Enterprise-Level Security Policies and Procedures</li> <li>Prepare for Incident Response and Recovery</li> </ul> <h3>7 - Enterprise Security Integration</h3> <ul> <li>The Technology Life Cycle</li> <li>Inter-Organizational Change</li> <li>Integrate Enterprise Disciplines to Achieve Secure Solutions</li> </ul> <h3>8 - Security Research and Analysis</h3> <ul> <li>Perform an Industry Trends and Impact Analysis</li> <li>Perform an Enterprise Security Analysis</li> </ul></div>

Certificate in Information Security Management Principles (CISMP)

Certified Cloud Security Professional (CCSP)

ASIS Certified Protection Professional (CPP)

Certified Cyber Professional (CCP)

Cissp

CompTIA Security+

CompTIA Advanced Security Practitioner (CASP+)

<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 any IT, facilities or data centre professional, who are involved in the design/build, renovation or relocation of a mission-critical data centre.</p>Overview<p>This 5-day course is designed to prepare participants to analyse a given business case and perform technical evaluation for a project plan and a set of designs for the implementation of a mission critical data centre.<br />The course also engages participants in product evaluations and demonstrates how to select equipment and develop equipment test scripts (IET) and integrated performance and validation testing (IPVT). CDCEÂ© builds upon knowledge gained in CDCP and CDCS courses. Participants who pass the exam will join the industry's elite data centre project design experts.<br />CDCEÂ© is the highest level training in the EPI Design and Build training track under the EPI Data Centre Training Framework. Participants must hold a valid CDCS certificate in order to be able to register for the CDCE class.</p><p>CDCEÂ© is the premier certification for data centre professionals in the data centre design/build and related fields.</p></div><div id="course-pills-2"><h4>Data Centre Life Cycle</h4><ul><li>Data centre lifecycle stages and phases<br />Exercise: Stage/Phase/Milestone/Document mapping</li></ul><h4>Design Preparation</h4><ul><li>Creation of a SON ? Statement Of Need<br />Technology review<br />Conceptual sizing<br />How to calculate for computer room space<br />How to calculate facility space<br />How to calculate incoming power<br />Exercise: Conceptual sizing building and power<br />Analysing capacity of existing facility<br />Analysing investment options<br />Site selection<br />Permits and approvals<br />Exercise: Site selection<br />Conceptual design<br />Budget and project timeline<br />Business case preparation<br />Project delivery structure<br />Project management options<br />Project manager and team</li></ul><h4>Design Planning</h4><ul><li>OSRA?Operational Systems Requirement Analysis<br />TFRA?Technical Facilities Requirement Analysis<br />Operations and maintenance review<br />RFP?Request For Proposal process<br />Vendor selection</li></ul><h4>Design Development</h4><ul><li>Project planning<br />Design development<br />PDR ? Preliminary Design Review<br />Equipment selection<br />FDR/V ? Final Design Review/Validation<br />Exercise: Full design validation of power, cooling, floor plans, fire suppression<br />Design freeze and LLTI<br />Creation of construction documents<br />BOM/BOQ ? Bill Of Material/Bill Of Quantity<br />Exercise: Equipment selection</li></ul><h4>Acquire</h4><ul><li>Requirements of purchase orders<br />Shipping terms<br />FWT/FAT ? Factory Witness Test/Factory Acceptance Test<br />Sequencing<br />Incoming goods inspection and handling<br />Asset management</li></ul><h4>Construct</h4><ul><li>Temporary essential services<br />Erection of the building<br />Permanent essential services<br />Building inspection<br />Snag list<br />COF?Certificate Of Fitness</li></ul><h4>Fit-Out</h4><ul><li>Fit-Out<br />Builders cleaning<br />As-Built Drawings</li></ul><h4>Test &amp; Commissioning</h4><ul><li>IET?Individual Equipment Test<br />IPVT/IST?Integrated Performance Verification Test/Integrated Systems Test<br />Common mistakes with IET/IPVT<br />Deep cleaning<br />Exercise: IET/IPVT scripting</li></ul><h4>Hand-Over</h4><ul><li>Facility hand-over requirements and documents<br />PCC?Practical Completion Certificate<br />DLP?Defect Liability Period<br />Defect Management<br />ICT Systems Installation<br />ICT Systems Testing<br />Hand-Over/DLP Expiry<br />FCC?Final Completion Certificate</li></ul><h4>Retirement</h4><ul><li>Reasons and definitions of retirement<br />Building the business case and project plan<br />Sequencing<br />Transfer of site<br />Demolishing of site<br />Legal matters<br />FCC?Final Completion Certificate</li></ul><h4>Exam: Certified Data Centre Expert (CDCEÂ©)</h4><ul><li>The CDCEÂ© exam is in two parts: Part A is a 90-minute closed book exam, with 60 multiple-choice questions. For Part A, the candidate requires a minimum of 45 correct answers to pass the exam. Part B is a 90-minute closed book exam, with 25 open questions. For Part B the candidate needs to obtain a minimum of 75% to pass.</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Certified Data Centre Expert (CDCE) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Certified Data Centre Expert (CDCE) 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

Construction Design & Management (CDM)

Cisco Certified Internetwork Expert (CCIE)

Certified in Data Protection (CDP)

Certified Data Centre Expert (CDCE)

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

CompTIA Network+

Cloud Architecture

AWS Certified Cloud Practitioner

CompTIA A+

CompTIA Cloud+

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>The Microsoft 365 Endpoint Administrator is responsible for deploying, configuring, securing, managing, and monitoring devices and client applications in a corporate setting. Their duties include managing identity, access, policies, updates, and apps. They work alongside the M365 Enterprise Administrator to develop and execute a device strategy that aligns with the requirements of a modern organization. Microsoft 365 Endpoint Administrators should be well-versed in M365 workloads and possess extensive skills and experience in deploying, configuring, and maintaining Windows 11 and later, as well as non-Windows devices. Their role emphasizes cloud services over on-premises management technologies.</p><p></p><p></p><p>In this course, students will learn to plan and execute an endpoint deployment strategy using contemporary deployment techniques and implementing update strategies. The course introduces essential elements of modern management, co-management approaches, and Microsoft Intune integration. It covers app deployment, management of browser-based applications, and key security concepts such as authentication, identities, access, and compliance policies. Technologies like Microsoft Entra ID, Azure Information Protection, and Microsoft Defender for Endpoint are explored to protect devices and data.</p><p></p>Prerequisites<p>The Modern Desktop Administrator must be familiar with M365 workloads and must have strong skills and experience of deploying, configuring, and maintaining Windows 11 and later, and non-Windows devices.</p></div><div id="course-pills-2"><h3>1 - Explore the Enterprise Desktop</h3> <ul> <li>Examine benefits of modern management</li> <li>Examine the enterprise desktop life-cycle model</li> <li>Examine planning and purchasing</li> <li>Examine desktop deployment</li> <li>Plan an application deployment</li> <li>Plan for upgrades and retirement</li> </ul> <h3>2 - Explore Windows Editions</h3> <ul> <li>Examine Windows client editions and capabilities</li> <li>Select client edition</li> <li>Examine hardware requirements</li> </ul> <h3>3 - Understand Microsoft Entra ID</h3> <ul> <li>Examine Microsoft Entra ID</li> <li>Compare Microsoft Entra ID and Active Directory Domain Services</li> <li>Examine Microsoft Entra ID as a directory service for cloud apps</li> <li>Compare Microsoft Entra ID P1 and P2 plans</li> <li>Examine Microsoft Entra Domain Services</li> </ul> <h3>4 - Manage Microsoft Entra identities</h3> <ul> <li>Examine RBAC and user roles in Microsoft Entra ID</li> <li>Create and manage users in Microsoft Entra ID</li> <li>Create and manage groups in Microsoft Entra ID</li> <li>Manage Microsoft Entra objects with PowerShell</li> <li>Synchronize objects from AD DS to Microsoft Entra ID</li> </ul> <h3>5 - Manage device authentication</h3> <ul> <li>Describe Microsoft Entra join </li> <li>Examine Microsoft Entra join prerequisites limitations and benefits</li> <li>Join devices to Microsoft Entra ID</li> <li>Manage devices joined to Microsoft Entra ID</li> </ul> <h3>6 - Enroll devices using Microsoft Configuration Manager</h3> <ul> <li>Deploy the Microsoft Configuration Manager client</li> <li>Monitor the Microsoft Configuration Manager client</li> <li>Manage the Microsoft Configuration Manager client</li> </ul> <h3>7 - Enroll devices using Microsoft Intune</h3> <ul> <li>Manage mobile devices with Intune</li> <li>Enable mobile device management</li> <li>Explain considerations for device enrollment</li> <li>Manage corporate enrollment policy</li> <li>Enroll Windows devices in Intune</li> <li>Enroll Android devices in Intune</li> <li>Enroll iOS devices in Intune</li> <li>Explore device enrollment manager</li> <li>Monitor device enrollment</li> <li>Manage devices remotely</li> </ul> <h3>8 - Execute device profiles</h3> <ul> <li>Explore Intune device profiles</li> <li>Create device profiles</li> <li>Create a custom device profile</li> </ul> <h3>9 - Oversee device profiles</h3> <ul> <li>Monitor device profiles in Intune</li> <li>Manage device sync in Intune</li> <li>Manage devices in Intune using scripts</li> </ul> <h3>10 - Maintain user profiles</h3> <ul> <li>Examine user profile</li> <li>Explore user profile types</li> <li>Examine options for minimizing user profile size</li> <li>Deploy and configure folder redirection</li> <li>Sync user state with Enterprise State Roaming</li> <li>Configure Enterprise State Roaming in Azure</li> </ul> <h3>11 - Execute mobile application management</h3> <ul> <li>Examine mobile application management</li> <li>Examine considerations for mobile application management</li> <li>Prepare line-of-business apps for app protection policies</li> <li>Implement mobile application management policies in Intune</li> <li>Manage mobile application management policies in Intune</li> </ul> <h3>12 - Deploy and update applications</h3> <ul> <li>Deploy applications with Intune</li> <li>Add apps to Intune</li> <li>Manage Win32 apps with Intune</li> <li>Deploy applications with Configuration Manager</li> <li>Deploying applications with Group Policy</li> <li>Assign and publish software</li> <li>Explore Microsoft Store for Business</li> <li>Implement Microsoft Store Apps</li> <li>Update Microsoft Store Apps with Intune</li> <li>Assign apps to company employees</li> </ul> <h3>13 - Administer endpoint applications</h3> <ul> <li>Manage apps with Intune</li> <li>Manage Apps on non-enrolled devices</li> <li>Deploy Microsoft 365 Apps with Intune</li> <li>Additional Microsoft 365 Apps Deployment Tools</li> <li>Configure Microsoft Edge Internet Explorer mode</li> <li>App Inventory Review</li> </ul> <h3>14 - Protect identities in Microsoft Entra ID</h3> <ul> <li>Explore Windows Hello for Business</li> <li>Deploy Windows Hello</li> <li>Manage Windows Hello for Business</li> <li>Explore Microsoft Entra ID Protection</li> <li>Manage self-service password reset in Microsoft Entra ID</li> <li>Implement multi-factor authentication</li> </ul> <h3>15 - Enable organizational access</h3> <ul> <li>Enable access to organization resources</li> <li>Explore VPN types and configuration</li> <li>Explore Always On VPN</li> <li>Deploy Always On VPN</li> </ul> <h3>16 - Implement device compliance</h3> <ul> <li>Protect access to resources using Intune</li> <li>Explore device compliance policy</li> <li>Deploy a device compliance policy</li> <li>Explore conditional access</li> <li>Create conditional access policies</li> </ul> <h3>17 - Generate inventory and compliance reports</h3> <ul> <li>Report enrolled devices inventory in Intune</li> <li>Monitor and report device compliance</li> <li>Build custom Intune inventory reports</li> <li>Access Intune using Microsoft Graph API</li> </ul> <h3>18 - Deploy device data protection</h3> <ul> <li>Explore Windows Information Protection</li> <li>Plan Windows Information Protection</li> <li>Implement and use Windows Information Protection</li> <li>Explore Encrypting File System in Windows client</li> <li>Explore BitLocker</li> </ul> <h3>19 - Manage Microsoft Defender for Endpoint</h3> <ul> <li>Explore Microsoft Defender for Endpoint</li> <li>Examine key capabilities of Microsoft Defender for Endpoint</li> <li>Explore Windows Defender Application Control and Device Guard</li> <li>Explore Microsoft Defender Application Guard</li> <li>Examine Windows Defender Exploit Guard</li> <li>Explore Windows Defender System Guard</li> </ul> <h3>20 - Manage Microsoft Defender in Windows client</h3> <ul> <li>Explore Windows Security Center</li> <li>Explore Windows Defender Credential Guard</li> <li>Manage Microsoft Defender Antivirus</li> <li>Manage Windows Defender Firewall</li> <li>Explore Windows Defender Firewall with Advanced Security</li> </ul> <h3>21 - Manage Microsoft Defender for Cloud Apps</h3> <ul> <li>Explore Microsoft Defender for Cloud Apps</li> <li>Planning Microsoft Defender for Cloud Apps</li> <li>Implement Microsoft Defender for Cloud Apps</li> </ul> <h3>22 - Assess deployment readiness</h3> <ul> <li>Examine deployment guidelines</li> <li>Explore readiness tools</li> <li>Assess application compatibility</li> <li>Explore tools for application compatibility mitigation</li> <li>Prepare network and directory for deployment</li> <li>Plan a pilot</li> </ul> <h3>23 - Deploy using the Microsoft Deployment Toolkit</h3> <ul> <li>Evaluate traditional deployment methods</li> <li>Set up the Microsoft Deployment Toolkit for client deployment</li> <li>Manage and deploy images using the Microsoft Deployment Toolkit</li> </ul> <h3>24 - Deploy using Microsoft Configuration Manager</h3> <ul> <li>Explore client deployment using Configuration Manager</li> <li>Examine deployment components of Configuration Manager</li> <li>Manage client deployment using Configuration Manager</li> <li>Plan in-place upgrades using Configuration Manager</li> </ul> <h3>25 - Deploy Devices using Windows Autopilot</h3> <ul> <li>Use Autopilot for modern deployment</li> <li>Examine requirements for Windows Autopilot</li> <li>Prepare device IDs for Autopilot</li> <li>Implement device registration and out-of-the-box customization</li> <li>Examine Autopilot scenarios</li> <li>Troubleshoot Windows Autopilot</li> </ul> <h3>26 - Implement dynamic deployment methods</h3> <ul> <li>Examine subscription activation</li> <li>Deploy using provisioning packages</li> <li>Use Windows Configuration Designer</li> <li>Use Microsoft Entra join with automatic MDM enrollment</li> </ul> <h3>27 - Plan a transition to modern endpoint management</h3> <ul> <li>Explore using co-management to transition to modern endpoint management</li> <li>Examine prerequisites for co-management</li> <li>Evaluate modern management considerations</li> <li>Evaluate upgrades and migrations in modern transitioning</li> <li>Migrate data when modern transitioning</li> <li>Migrate workloads when modern transitioning</li> </ul> <h3>28 - Manage Windows 365</h3> <ul> <li>Explore Windows 365</li> <li>Configure Windows 365</li> <li>Administer Windows 365</li> </ul> <h3>29 - Manage Azure Virtual Desktop</h3> <ul> <li>Examine Azure Virtual Desktop</li> <li>Explore Azure Virtual Desktop</li> <li>Configure Azure Virtual Desktop</li> <li>Administer Azure Virtual Desktop</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans MD-102T00 : Microsoft 365 Endpoint Administrator training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the MD-102T00 : Microsoft 365 Endpoint Administrator course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Microsoft 365

Microsoft AZ-900

Microsoft AZ-104

Microsoft AZ-303

Microsoft AZ-700

MD-102T00 Microsoft 365 Endpoint Administrator

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

Microsoft SQL

SQL Server

55366 Querying Data with Transact-SQL

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is designed for anyone seeking CCNA certification. The course also provides foundational knowledge for all support technicians involved in the basic installation, operation, and verification of Cisco networks. The job roles best suited to the material in this course are:<br />Entry-level network engineer<br />Network administrator<br />Network support technician<br />Help desk technician</p>Overview<p>This course will help you:<br />Learn the knowledge and skills to install, configure, and operate a small- to medium-sized network<br />Gain a foundation in the essentials of networking, security, and automation<br />Earn 30 CE credits toward recertification</p><p>The Implementing and Administering Cisco Solutions (CCNA) v2.0 course gives you a broad range of fundamental knowledge for all IT careers. Through a combination of lecture, hands-on labs, and self-study, you will learn how to install, operate, configure, and verify basic IPv4 and IPv6 networks. The course covers configuring network components such as switches, routers, and wireless LAN controllers; managing network devices; and identifying basic security threats. The course also gives you a foundation in network programmability, automation, and software-defined networking. This course helps you prepare to take the 200-301 CiscoÂ© Certified Network Associate (CCNAÂ©) exam. By passing this one exam, you earn the CCNA certification. This course also earns you 30 Continuing Education (CE) credits towards recertification.</p></div><div id="course-pills-2"><h4>Course Outline </h4><ul><li>Exploring the Functions of Networking ? Lecture</li><li>Introducing the Host-to-Host Communications Model ? Lecture</li><li>Operating Cisco IOS Software ? Lecture</li><li>Introducing LANs ? Lecture</li><li>Exploring the TCP/IP Link Layer ? Lecture</li><li>Starting a Switch ? Lecture</li><li>Introducing the TCP/IP Internet Layer, IPv4 Addressing, and Subnets ? Lecture</li><li>Explaining the TCP/IP Transport Layer and Application Layer ? Lecture</li><li>Exploring the Functions of Routing ? Lecture</li><li>Configuring a Cisco Router ? Lecture</li><li>Exploring the Packet Delivery Process ? Lecture</li><li>Troubleshooting a Simple Network ? Lecture</li><li>Introducing Basic IPv6 ? Lecture</li><li>Configuring Static Routing ? Lecture</li><li>Implementing VLANs and Trunks ? Lecture</li><li>Routing Between VLANs ? Lecture</li><li>Introducing OSPF ? Lecture</li><li>Building Redundant Switched Topologies ? Self-study</li><li>Improving Redundant Switched Topologies with EtherChannel ? Lecture</li><li>Exploring Layer 3 Redundancy ? Self-study</li><li>Introducing WAN Technologies ? Self-study</li><li>Explaining Basics of ACL ? Lecture</li><li>Enabling Internet Connectivity ? Lecture</li><li>Introducing QoS ? Self-study</li><li>Explaining Wireless Fundamentals ? Self-study</li><li>Introducing Architectures and Virtualization ? Self-study</li><li>Explaining the Evolution of Intelligent Networks ? Lecture</li><li>Introducing System Monitoring ? Lecture</li><li>Managing Cisco Devices ? Lecture</li><li>Examining the Security Threat Landscape ? Self-study</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Cisco Implementing and Administering Cisco Solutions v2.0 (CCNA) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Cisco Implementing and Administering Cisco Solutions v2.0 (CCNA) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Cisco Certified Network Associate (CCNA)

Cisco Certified Network Professional certification (CCNP)

Cisco Certified Entry Networking Technician (CCENT)

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

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is intended for entry-level computer support professionals with a basic knowledge of computer hardware, software, and operating systems who wish to increase their knowledge and understanding of networking concepts and acquire the required skills to prepare for a career in network support or administration, or who wish to prepare for the CompTIA Network+ certification. CompTIA Network+ is the first certification IT professionals specializing in network administration and support should earn. Network+ is aimed at IT professionals with job roles such as network administrator, network technician, network installer, help desk technician, and IT cable installer. This course is also designed for students who are seeking the CompTIA Network+ certification and who want to prepare for the CompTIA Network+ N10-008 Certification Exam.</p>Overview<p>In this course, you will describe the major networking technologies and systems of modern networks and configure, manage, and troubleshoot modern networks. Explain the OSI and TCP/IP Models. Explain properties of network traffic. Install and configure switched networks. Configure IP networks. Install and configure routed networks. Configure and monitor ports and protocols. Explain network application and storage issues. Monitor and troubleshoot networks. Explain network attacks and mitigations. Install and configure security devices. Explain authentication and access controls. Deploy and troubleshoot cabling solutions. Implement and troubleshoot wireless technologies. Compare and contrast WAN technologies. Use remote access methods. Identify site policies and best practices.</p><p>CompTIA's Network+ certification is a foundation-level certification designed for IT professionals with around one year of experience, whose job role is focused on network administration.<br /><br />The CompTIA Network+ exam will certify the successful candidate has the knowledge and skills required to troubleshoot, configure, and manage common network devices; establish basic network connectivity; understand and maintain network documentation; identify network limitations and weaknesses; and implement network security, standards, and protocols. The candidate will have a basic understanding of enterprise technologies, including cloud and virtualization technologies.  <br /><br /> The Official CompTIAÂ© Network+Â© (Exam N10-008): will teach you the fundamental principles of installing, configuring, and troubleshooting network technologies and help you to progress a career in network administration. In this course, you will build on your existing user-level knowledge and experience with personal computer operating systems and networks to master the fundamental skills and concepts that you will need to use on the job in any type of networking career.</p>Prerequisites<p></p><ul><li>CompTIA A+ Certification (Exams 220-1001 and 220-1002)</li></ul><p></p></div><div id="course-pills-2"><h3>1 - Explaining the OSI and TCP/IP Models</h3> <ul> <li>Topic A: Explain OSI Model Layers</li> <li> Topic B: Explain the TCP/IP Suite</li> </ul> <h3>2 - Explaining Properties of Network Traffic</h3> <ul> <li>Topic A: Explain Media Types and Access Methods</li> <li> Topic B: Deploy Ethernet Standards</li> <li> Topic C: Configure and Monitor Network Interfaces</li> </ul> <h3>3 - Installing and Configuring Switched Networks</h3> <ul> <li>Topic A: Install and Configure Hubs and Bridges</li> <li> Topic B: Install and Configure Switches</li> <li> Topic C: Compare and Contrast Network Topologies</li> <li> Topic D: Compare and Contrast Network Types</li> </ul> <h3>4 - Configuring IP Networks</h3> <ul> <li>Topic A: Configure IPv4 Addressing Components</li> <li> Topic B: Test IP Interfaces with Command Line Tools</li> <li> Topic C: Configure IPv4 Subnets</li> <li> Topic D: Configure Private and Public IPv4 Addressing Schemes</li> <li> Topic E: Configure IPv6 Addressing Components</li> <li> Topic F: Configure DHCP Services</li> </ul> <h3>5 - Installing and Configuring Routed Networks</h3> <ul> <li>Topic A: Explain Characteristics of Routing</li> <li> Topic B: Install and Configure Routers</li> </ul> <h3>6 - Configuring and Monitoring Ports and Protocols</h3> <ul> <li>Topic A: Explain the Uses of Ports and Protocols</li> <li> Topic B: Use Port Scanners and Protocol Analyzers</li> <li> Topic C: Explain the Use of Name Resolution Services</li> <li> Topic D: Configure DNS and IPAM Services</li> </ul> <h3>7 - Explaining Network Application and Storage Services</h3> <ul> <li>Topic A: Explain the Uses of Network Applications</li> <li> Topic B: Explain the Uses of Voice Services and Advanced Networking Devices</li> <li> Topic C: Explain the Uses of Virtualization and Network Storage Services</li> <li> Topic D: Summarize the Concepts of Cloud Services</li> </ul> <h3>8 - Monitoring and Troubleshooting Networks</h3> <ul> <li>Topic A: Monitor Network Interfaces and Logs</li> <li>Topic B: Explain Network Troubleshooting Methodology</li> <li>Topic C: Troubleshoot Common Network Services Issues</li> </ul> <h3>9 - Explaining Networking Attacks and Mitigations</h3> <ul> <li>Topic A: Summarize Common Networking Attacks</li> <li>Topic B: Explain the Characteristics of VLANs</li> <li>Topic C: Explain the Characteristics of NAT and Port Forwarding</li> </ul> <h3>10 - Installing and Configuring Security Devices</h3> <ul> <li>Topic A: Install and Configure Firewalls and Proxies</li> <li>Topic B: Explain the Uses of IDS/IPS and UTM</li> </ul> <h3>11 - Explaining Authentication and Access Controls</h3> <ul> <li>Topic A: Explain Authentication Controls and Attacks</li> <li>Topic B: Explain the Uses of Authentication Protocols and Directory Services</li> <li>Topic C: Explain the Uses of Port Security and NAC</li> <li>Topic D: Implement Network Device Hardening</li> <li>Topic E: Explain Patch Management and Vulnerability Scanning Processes</li> </ul> <h3>12 - Deploying and Troubleshooting Cabling Solutions</h3> <ul> <li>Topic A: Deploy Structured Cabling Systems</li> <li>Topic B: Deploy Twisted Pair Cabling Solutions</li> <li>Topic C: Test and Troubleshoot Twisted Pair Cabling Solutions</li> <li>Topic D: Deploy Fiber Optic Cabling Solutions</li> </ul> <h3>13 - Implementing and Troubleshooting Wireless Technologies</h3> <ul> <li>Topic A: Install and Configure Wireless Technologies</li> <li>Topic B: Troubleshoot Wireless Performance Issues</li> <li>Topic C: Secure and Troubleshoot Wireless Connectivity</li> </ul> <h3>14 - Comparing and Contrasting WAN Technologies</h3> <ul> <li>Topic A: Compare and Contrast WAN Core Service Types</li> <li>Topic B: Compare and Contrast WAN Subscriber Service Types</li> <li>Topic C: Compare and Contrast WAN Framing Service Types</li> <li>Topic D: Compae and Contrast Wireless and IoT WAN Technologies</li> </ul> <h3>15 - Using Remote Access Methods</h3> <ul> <li>Topic A: Use Remote Access VPNs</li> <li>Topic B: Use Remote Access Management Methods</li> </ul> <h3>16 - Identifying Site Policies and Best Practices</h3> <ul> <li>Topic A: Manage Networks with Documentation and Diagrams</li> <li>Topic B: Summarize the Purposes of Physical Security Devices</li> <li>Topic C: Compare and Contrast Business Continuity and Disaster Recovery Concepts</li> <li>Topic D: Identify Policies and Best Practices</li> </ul></div>

IT Networking Fundamentals

Computer Networking

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is designed for people who are seeking to launch a career in cybersecurity.</p>Overview<p>Assess the security posture of an enterprise environment and recommend and implement appropriate security solutions; Monitor and secure hybrid environments, including cloud, mobile, and IoT; Operate with an awareness of applicable laws and policies, including principles of governance, risk, and compliance; Identify, analyze, and respond to security events and incidents.</p><p>CompTIA Security+ is a global certification that validates the baseline skills necessary to perform core security functions and is the first security certification a candidate should earn.<br /> <br /> CompTIA Security+ establishes the core knowledge required of any cybersecurity role and provides a springboard to intermediate-level cybersecurity jobs.</p></div><div id="course-pills-2"><h3>Lesson 1: Summarize Fundamental Security Concepts</h3> <ul> <li>Security Concepts</li> <li>Security Controls</li> </ul> <h3>Lesson 2: Compare Threat Types</h3> <ul> <li>Threat Actors</li> <li>Attack Surfaces</li> <li>Social Engineering</li> </ul> <h3>Lesson 3: Explain Cryptographic Solutions</h3> <ul> <li>Cryptographic Algorithms</li> <li>Public Key Infrastructure</li> <li>Cryptographic Solutions</li> </ul> <h3>Lesson 4: Implement Identity and Access Management</h3> <ul> <li>Authentication</li> <li>Authorization</li> <li>Identity Management</li> </ul> <h3>Lesson 5: Secure Enterprise Network Architecture</h3> <ul> <li>Enterprise Network Architecture</li> <li>Network Security Appliances</li> <li>Secure Communications</li> </ul> <h3>Lesson 6: Secure Cloud Network Architecture</h3> <ul> <li>Cloud Infrastructure</li> <li>Embedded Systems and Zero Trust Architecture</li> </ul> <h3>Lesson 7: Explain Resiliency and Site Security Concepts</h3> <ul> <li>Asset Management</li> <li>Redundancy Strategies</li> <li>Physical Security</li> </ul> <h3>Lesson 8: Explain Vulnerability Management</h3> <ul> <li>Device and OS Vulnerabilities</li> <li>Application and Cloud Vulnerabilities</li> <li>Vulnerability Identification Methods</li> <li>Vulnerability Analysis and Remediation</li> </ul> <h3>Lesson 9: Evaluate Network Security Capabilities</h3> <ul> <li>Network Security Baselines</li> <li>Network Security Capability Enhancement</li> </ul> <h3>Lesson 10: Assess Endpoint Security Capabilities</h3> <ul> <li>Implement Endpoint Security</li> <li>Mobile Device Hardening</li> </ul> <h3>Lesson 11: Enhance Application Security Capabilities</h3> <ul> <li>Application Protocol Security Baselines</li> <li>Cloud and Web Application Security Concepts</li> </ul> <h3>Lesson 12: Explain Incident Response and Monitoring Concepts</h3> <ul> <li>Incident Response</li> <li>Digital Forensics</li> <li>Data Sources</li> <li>Alerting and Monitoring Tools</li> </ul> <h3>Lesson 13: Analyze Indicators of Malicious Activity</h3> <ul> <li>Malware Attack Indicators</li> <li>Physical and Network Attack Indicators</li> <li>Application Attack Indicators</li> </ul> <h3>Lesson 14: Summarize Security Governance Concepts</h3> <ul> <li>Policies, Standards, and Procedures</li> <li>Change Management</li> <li>Automation and Orchestration</li> </ul> <h3>Lesson 15: Explain Risk Management Processes</h3> <ul> <li>Risk Management Processes and Concepts</li> <li>Vendor Management Concepts</li> <li>Audits and Assessments</li> </ul> <h3>Lesson 16: Summarize Data Protection and Compliance Concepts</h3> <ul> <li>Data Classification and Compliance</li> <li>Personnel Policies</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans CompTIA Security Plus Certification (Exam SY0-601) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the CompTIA Security Plus Certification (Exam SY0-601) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is for experienced information technology (IT) professionals, typically described as Enterprise Desktop Administrators (EDAs). These EDAs deploy, manage, and maintain PCs, devices, and applications across medium, large, and enterprise organizations. A significant portion of this audience uses, or intends to use, the latest release of Configuration Manager to manage and deploy PCs, devices, and applications.</p>Overview<p>Describe the features Configuration Manager and Intune include, and explain how you can use these features to manage PCs and mobile devices in an enterprise environment. Analyze data by using queries and reports. Prepare a management infrastructure, including configuring boundaries, boundary groups, and resource discovery, and integrating mobile-device management with Intune. Deploy and manage the Configuration Manager client. Configure, manage, and monitor hardware and software inventory, and use Asset Intelligence and software metering. Identify and configure the most appropriate method to distribute and manage content used for deployments. Distribute, deploy, and monitor applications for managed users and systems. Maintain software updates for PCs that Configuration Manager manages. Implement Endpoint Protection for managed PCs. Configure an operating-system deployment strategy by using Configuration Manager. Manage and maintain a Configuration Manager site.</p><p>This five-day course describes how to use Configuration Manager and its associated site systems to efficiently manage network resources. In this five-day course, you will learn day-to-day management tasks, including how to manage applications, client health, hardware and software inventory, operating system deployment, and software updates by using Configuration Manager. You also will learn how to optimize Endpoint Protection, manage compliance, and create management queries and reports.  Although this course and the associated labs are written for Microsoft Endpoint Configuration Manager and Windows 11, the skills taught will also be backwards compatible with previous editions of System Center Configuration Manager and Windows 10.</p>Prerequisites<p></p><li>Networking fundamentals, including common networking protocols, topologies, hardware, media, routing, switching, and addressing.</li>  <li>Active Directory Domain Services (AD DS) principles and fundamentals of AD DS management.</li>  <li>Installation, configuration, and troubleshooting for Windows-based personal computers.</li>  <li>Basic concepts of public key infrastructure (PKI) security.</li>  <li>Basic understanding of scripting and Windows PowerShell syntax.</li>  <li>Basic understanding of Windows Server roles and services.</li>  <li>Basic understanding of the configuration options for iOS and Android Mobile device platforms.</li><p></p></div><div id="course-pills-2"><h3>1 - Managing computers and mobile devices in the enterprise</h3> <ul> <li>Overview of systems management by using enterprise management solutions</li> <li>Overview of the Configuration Manager architecture</li> <li>Overview of the Configuration Manager administrative tools</li> <li>Tools for monitoring and troubleshooting a Configuration Manager site</li> </ul> <h3>2 - Analyzing data using queries, reports, and CMPivot</h3> <ul> <li>Introduction to queries</li> <li>Configuring SQL Server Reporting Services</li> <li>Analyzing the real-time state of a device by using CMPivot</li> </ul> <h3>3 - Preparing the Configuration Manager management infrastructure</h3> <ul> <li>Configuring site boundaries and boundary groups</li> <li>Configuring resource discovery</li> <li>Organizing resources using device and user collections</li> </ul> <h3>4 - Deploying and managing the Configuration Manager client</h3> <ul> <li>Overview of the Configuration Manager client</li> <li>Deploying the Configuration Manager client</li> <li>Configuring and monitoring client status</li> <li>Managing client settings and performing management operations</li> </ul> <h3>5 - Managing inventory for PCs and applications</h3> <ul> <li>Overview of inventory collection</li> <li>Configuring hardware and software inventory</li> <li>Managing inventory collection</li> <li>Configuring software metering</li> <li>Configuring and managing Asset Intelligence</li> </ul> <h3>6 - Distributing and managing content used for deployments</h3> <ul> <li>Preparing the infrastructure for content management</li> <li>Distributing and managing content on distribution points</li> </ul> <h3>7 - Deploying and managing applications</h3> <ul> <li>Overview of application management</li> <li>Creating applications</li> <li>Deploying applications</li> <li>Managing applications</li> <li>Deploying and managing Windows apps</li> </ul> <h3>8 - Maintaining software updates for managed PCs</h3> <ul> <li>The software updates process</li> <li>Preparing a Configuration Manager site for software updates</li> <li>Managing software updates</li> <li>Configuring automatic deployment rules</li> <li>Monitoring and troubleshooting software updates</li> <li>Enabling third-party updates</li> </ul> <h3>9 - Implementing Defender Protection for managed PCs</h3> <ul> <li>Overview of Endpoint Protection in Configuration Manager</li> <li>Configuring, deploying, and monitoring Endpoint Protection policies</li> <li>Configuring and deploying advanced threat policies</li> <h3>10 - Managing compliance and secure data access</h3> <ul> <li>Overview of Compliance Settings</li> <li>Configuring compliance settings</li> <li>Viewing compliance results</li> <li>Managing resource and data access</li> <h3>11 - Managing operating system deployment</h3> <ul> <li>An overview of operating system deployment</li> <li>Preparing a site for operating system deployment</li> <li>Deploying an operating system</li> <li>Managing Windows as a service</li> <h3>12 - Managing and maintaining a Configuration Manager site</h3> <ul> <li>Configuring role-based administration</li> <li>Configuring Remote Tools</li> <li>Overview of Configuration Manager site maintenance and Management Insights</li> <li>Backing up and recovering a Configuration Manager site</li> <li>Updating the Configuration Manager infrastructure</li> <h3>13 - What?s new in Microsoft Endpoint Configuration Manager</h3> <ul> <li>Whats new in Microsoft Endpoint Manager covering each semi annual release</li> </ul></ul></ul></ul></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55348: Administering Microsoft Endpoint Configuration Manager training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the 55348: Administering Microsoft Endpoint Configuration Manager course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Sccm

Microsoft Certified Technology Specialist (MCTS)

Commercial & Contract Management Certification Program (CCM)

IT Manager

55348 Administering Microsoft Endpoint Configuration Manager

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

Networking Skills

55343 Networking with Windows Server

5385 Computing courses delivered Online

WM676 IBM Integration Bus V10 Application Development II

By Nexus Human

Palo Alto Networks: Cortex XSOAR 6.8: Automation and Orchestration(EDU-380)

By Nexus Human

WM153 IBM MQ V9 System Administration (using Windows for labs)

By Nexus Human

Functional Skills Maths Teacher

By Apex Learning

Mastering Java for Beginners & Experts

By Apex Learning

Microsoft Excel Course for Everyone - Complete Excel Course

By Apex Learning

Workshop Technology: Machine Shop Theory

By Apex Learning

Microsoft Excel - 25 Must-Know Formulas and Functions

By Apex Learning

Data Analysis and Forecasting in Excel

By Apex Learning

Advanced Excel Course (Formula, VLOOKUP & Power Query)

By Apex Learning