Name: Advanced Surveying & Construction Site Management (SMSTS) Diploma - CPD Certified
Price: 305 GBP
Availability: InStock

<div>
	<h3><strong>Description</strong></h3>
<p><span>MS Excel introduces multi-dimensional activities through its various feature. Do you want to be the first to look at the MS Excel 2016 Introduction course to learn its vivid use? Don't be late. Look at the </span><b>MS Excel 2016 Introduction</b><span> course and justify its authentic knowing its various fields.</span></p>
<p><span>The course designs in such a way that helps you to know the basic functions of MS Excel and various use of Excel for making calculation, producing charts, and recording data of all kind of business. It teaches you how to create Excel data, simple PivotTable and charts, vivid use of IF, SUM, TOTAL, and AVERAGE. It enables the students to understand how Excel is used in business to analyze the existing data. It also teaches the functions of range, and cell to do different types of activities.</span></p>
<h3><b>Assessment:</b></h3>
<p>This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work.</p>
<h3><strong>Certification:</strong></h3>
<p>After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.</p>
<h3><b>Who is this Course for?</b></h3>
<p><strong>MS Excel 2016 Introduction</strong> is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.</p>
<p>As there is no experience and qualification required for this course, it is available for all students from any academic background.</p>
<h3><b>Requirements</b></h3>
<p>Our<b> MS Excel 2016 Introduction</b> is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.</p>
<h3><b>Career Path</b></h3>
<p>After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.</p>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Introduction</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction</td>
					<td><span>FREE</span> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Getting Started with Excel</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What is Excel</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Opening Excel</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Navigating the Excel User Interface</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the Excel Ribbon</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding Excel Work Components</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the Backstage View</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Creating Workbooks and Using Templates</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating a New Workbook</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Workbooks Using Templates</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Saving an Excel Workbook</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Convert and Checking Compatiblity</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Entering Data</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Navigating a Worksheet by Mouse or Keyboard</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Excel Data Types</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Cell and Range Addressing</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Data Selection Techniques</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Common Excel Commands</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the Autofill Handle</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Excel Formula Basics Data</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What are Formulas and Functions</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Components of a Formula</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Calculation Hierarchy Using the Order of Operations_Revise</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Basic Formulas</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with Basic Functions and Autosum</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Cell References</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the Quick Analysis Tool</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Adjusting a Worksheet</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Modifying Columns and Rows</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Hiding and Unhiding Columns and Rows</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Formatting and Aligning Worksheet Data</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Formatting and Aligning Data</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Merging Data</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Wrapping Text Orientation</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Formatting Numbers</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Borders and Shading</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the Format Painter</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Removing Formatting Quickly</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Using Cell Styles and Themes</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding Cell Styles</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Applying Cell Styles</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Applying Themes</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Inserting Objects and Graphics</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Inserting and Formatting Images</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Inserting and Formatting Shapes</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Inserting and Formatting Smart Art</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Inserting Screenshots</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Inserting Hyperlinks</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Inserting Symbols and Equations</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Inserting Word Art Or Text Boxes</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Inserting Other Excel Objects</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Arranging Objects</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Proofing a Workbook</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Find and Replace</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Finding and Replacing Formatting</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Got to and Go to Special</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the Spell Checker</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the Theasaurus and Translation Feature</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Printing an Excel File</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Printing and Previewing Excel Files</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Custom Margins and Scaling</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Adding Headers and Footers</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Formatting a Page with the Page Layout Tab</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Printing Titles and Specific Worksheet Areas</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Exporting to PDF and XPs</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Managing Worksheets</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Renaming and Coloring Worksheet Tabs</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Adding, Deleting, and Navigating Worksheets</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Moving and Copying Worksheets</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Hiding and Unhiding Worksheets</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Navigating and Viewing Excel Files</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Viewing Workbooks</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Zoom Tools</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Configure Sheet Options</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Freeze Panes and Split Commands</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with Window Commands</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Adjusting Workbook Properties</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Conclusion</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Course Recap</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table>

John Academy

Office Skills & Productivity

Microsoft Certification

Microsoft Excel

Microsoft Office

Microsoft AZ-104

Microsoft Access

MS Excel 2016 Introduction

General Admission

<div>
	<h3><strong>Description:</strong></h3>
<p><span>Microsoft Excel, developed by Microsoft Corporation, is world's leading spreadsheet program for Windows, macOS, Android and iOS. The program includes calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications to make your task easy and for saving your precious time. You can hardly find any company where Microsoft Excel is not used. The knowledge of Excel is a must for meeting any career perspective. The course will help you to achieve the goals.</span></p>
<p><span>The course is divided into three parts - beginners, intermediate and advanced. Therefore after completing the bundle video course, you will be a prolific user of the program. As the course is sectioned based on the level of difficulty, you will know the basics of Excel at first. You will know how to open an excel program, how to put data or know some simple calculations. After the primary knowledge, you will be introduced to some more features and functions of the program such as analyse massive amounts of data, extract actionable information from it, etc. Finally, you will learn the advanced features of Excel program that allows you take the right business decisions for your company.</span></p>
<h3><b>Assessment:</b></h3>
<ul>
<li><span>At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not.</span></li>
<li><span>Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.</span></li>
</ul>
<h3><b>Certification:</b></h3>
<ul>
<li><span>After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement.</span></li>
<li><span>Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.</span></li>
</ul>
<h3><b>Who is this Course for?</b></h3>
<p><b>Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate &amp; Advanced </b><span>is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.</span></p>
<p><span>As there is no experience and qualification required for this course, it is available for all students from any academic background.</span></p>
<h3><b>Requirements</b></h3>
<p><span>Our</span><b> Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate &amp; Advanced</b><span> is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.</span></p>
<h3><b>Career Path</b></h3>
<p><span>After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.</span></p>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Getting Started with Microsoft Office Excel 2016</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Navigate the Excel User Interface</td>
					<td><span>FREE</span> </td>
					<td><span><i></i> 00:28:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Excel Commands</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create and Save a Basic Workbook</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Enter Cell Data</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Excel Help</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Performing Calculations</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create Worksheet Formulas</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Insert Functions</td>
					<td> </td>
					<td><span><i></i> 00:17:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Reuse Formulas and Functions</td>
					<td> </td>
					<td><span><i></i> 00:17:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Modifying a Worksheet</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Insert, Delete, and Adjust Cells, Columns, and Rows</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Search for and Replace Data</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Proofing and Research Tools</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Formatting a Worksheet</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Apply Text Formats</td>
					<td> </td>
					<td><span><i></i> 00:17:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Apply Number Format</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Align Cell Contents</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Apply Styles and Themes</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Apply Basic Conditional Formatting</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create and Use Templates</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Printing Workbooks</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Preview and Print a Workbook</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Set Up the Page Layout</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Configure Headers and Footers</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Managing Workbooks</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Manage Worksheets</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Manage Workbook and Worksheet Views</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Manage Workbook Properties</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4"> Working with Functions</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Work with Ranges</td>
					<td><span>FREE</span> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Specialized Functions</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Work with Logical Functions</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Work with Date &amp; Time Functions</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Work with Text Functions</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Working with Lists</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Sort Data</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Filter Data</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Query Data with Database Functions</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Outline and Subtotal Data</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Analyzing Data</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create and Modify Tables</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Apply Intermediate Conditional Formatting</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Apply Advanced Conditional Formatting</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Visualizing Data with Charts</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create Charts</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Modify and Format Charts</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Advanced Chart Features</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Using PivotTables and PivotCharts</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create a PivotTable</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Analyze PivotTable Data</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Present Data with PivotCharts</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Filter Data by Using Timelines and Slicers</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Working with Multiple Worksheets and Workbooks</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Links and External References</td>
					<td><span>FREE</span> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use 3-D References</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Consolidate Data</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Using Lookup Functions and Formula Auditing</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Lookup Functions</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Trace Cells</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Watch and Evaluate Formulas</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Sharing and Protecting Workbooks</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Collaborate on a Workbook</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Protect Worksheets and Workbooks</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Automating Workbook Functionality</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Apply Data Validation</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Search for Invalid Data and Formulas with Errors</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Work with Macros</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Creating Sparklines and Mapping Data</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create Sparklines</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>MapData</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Forecasting Data</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Determine Potential Outcomes Using Data Tables</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Determine Potential Outcomes Using Scenarios</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use the Goal Seek Feature</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Forecasting Data Trends</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Refer A Friend</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Refer A Friend</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table>

Microsoft MS-700

Microsoft 365

Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced

<p>Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified<strong> Psychology &amp; Counselling</strong> bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our <strong> 37 </strong>course mega bundle that will exceed your expectations within your budget.</p><p>The<strong> Psychology &amp; Counselling</strong> related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then <strong>StudyHub </strong>proposes a preparatory bundle. This comprehensive <strong>Psychology &amp; Counselling</strong> bundle will help you build a solid foundation to become a proficient worker in the sector.</p><p><strong>This Psychology &amp; Counselling Bundle consists of the following</strong><strong> 30 </strong><strong>CPD Accredited Premium courses -</strong></p><ul><li>Course 01 :Advanced Training in Psychology</li><li>Course 02 :Counselling and Psychotherapy</li><li>Course 03 :Mental Health Care Training - MCA &amp; DOLS</li><li>Course 04 :Psychology of Anxiety and Stress</li><li>Course 05 :Psychology and Therapy of Addictions Certificate</li><li>Course 06 :CBT (Cognitive Behavioural Therapy)</li><li>Course 07 :Psychology of Older Age Certificate</li><li>Course 08 :Occupational Therapy Diploma Level 3</li><li>Course 09 :Journal Therapy</li><li>Course 10 :Art Therapy</li><li>Course 11 :Biohacking Course: Boost Your Physical &amp; Mental Health</li><li>Course 12 :Programs in Consciousness &amp; Psychology</li><li>Course 13 :Anti Social Behaviour: Understanding &amp; Preventing</li><li>Course 14 :Child Psychology</li><li>Course 15 :Educational Psychology &amp; Development Training</li><li>Course 16 :Child And Family Psychology - Diploma</li><li>Course 17 :Speech And Language Therapy</li><li>Course 18 :Autism Awareness</li><li>Course 19 :Play Therapy</li><li>Course 20 :Beating Depression Course</li><li>Course 21 :Beating Anxiety Course</li><li>Course 22 :Why Do We Do The Things We Do Psychology Course</li><li>Course 23 :Mental Freedom Course</li><li>Course 24 :Motivational Psychology Online</li><li>Course 25: Motivational Psychology of the Successful Entrepreneur</li><li>Course 26: Sport &amp; Exercise Psychologist</li><li>Course 27: COVID-19: Psychological First Aid Training</li><li>Course 28: Parapsychology Course</li><li>Course 29: Human Rights</li><li>Course 30: Time Management Training</li></ul><p><strong>7 </strong><strong>Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques-</strong></p><ul><li>Course 1: Career Development Plan Fundamentals</li><li>Course 2: CV Writing and Job Searching</li><li>Course 3: Interview Skills: Ace the Interview</li><li>Course 4: Video Job Interview for Job Seekers</li><li>Course 5:Create a Professional LinkedIn Profile</li><li>Course 6:Business English Perfection Course</li><li>Course 7:Networking Skills for Personal Success</li></ul><p><strong>Learning Outcome</strong></p><p><strong>This tailor-made </strong><strong>Psychology &amp; Counselling</strong><strong> bundle will allow you to-</strong></p><ul><li>Uncover your skills and aptitudes to break new ground in the related fields</li><li>Deep dive into the fundamental knowledge</li><li>Acquire some hard and soft skills in this area</li><li>Gain some transferable skills to elevate your performance</li><li>Maintain good report with your clients and staff</li><li>Gain necessary office skills and be tech savvy utilising relevant software</li><li>Keep records of your work and make a report</li><li>Know the regulations around this area</li><li>Reinforce your career with specific knowledge of this field</li><li>Know your legal and ethical responsibility as a professional in the related field</li></ul> <p>This Psychology &amp; Counselling Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments.</p><p><strong>Certification</strong></p><p>After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and <strong>1 hardcopy certificate for the Title Course completely free</strong>. Other Hard Copy certificates need to be ordered at an additional cost of •8.</p> <h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        370 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div> <h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Psychology &amp; Counselling bundle! This bundle is also ideal for professionals looking for career advancement.</p>
                        </div> <h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>To participate in this course, all you need is -</p><ul><li>A smart device</li><li>A secure internet connection</li><li>And a keen interest in Psychology &amp; Counselling</li></ul>
                        </div> <h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.</p>
                        </div>

Studyhub UK

Psychological Wellbeing Practitioner

Clinical Psychology

Psychology Counselling

Counselling Skills

Centre for Counselling & Psychotherapy Training (CCPT)

Professional Skills Course (PSC)

Psychology & Counselling Level 4

<p>Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified<strong> Domestic Engineering </strong>bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our <strong>37 </strong>course mega bundle that will exceed your expectations within your budget.</p> <p>The<strong> Domestic Engineering</strong> related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then <strong>StudyHub </strong> proposes a preparatory bundle. This comprehensive <strong>Domestic Engineering</strong> bundle will help you build a solid foundation to become a proficient worker in the sector.</p> <p><strong>This Domestic Engineering Bundle consists of the following</strong><strong> 30 </strong><strong>CPD Accredited Premium courses - </strong></p> <ul> <li>Course 01 : Energy Engineer Course</li><li>Course 02 : Solar Energy</li><li>Course 03 : Essential Hydro Electric Power Plant Training</li><li>Course 04 : Electrical Power System and High Voltage Engineering</li><li>Course 05 : Electrical Engineering for Electrical Substations</li><li>Course 06 : Leadership and Management Skills Complete Diploma</li><li>Course 07 : Business Strategy Planning</li><li>Course 08 : Financial Management</li><li>Course 09 : Project Management Course</li><li>Course 10 : Operations Management</li><li>Course 11 : Effective Communication Skills</li><li>Course 12 : Delegation Skills</li><li>Course 13 : Functional Skills IT</li><li>Course 14 : Project Management Essential Skills Level 3</li><li>Course 15 : Environment Management</li><li>Course 16 : Sustainable Energy and Development Diploma</li><li>Course 17 : Environmental Engineering</li><li>Course 18 : Flight Mechanics</li><li>Course 19 : Aircraft and Airplane Engineering: Basic to Advanced</li><li>Course 20 : Domestic Appliance Repairing Course</li><li>Course 21 : Diploma in Lean Process and Six Sigma</li><li>Course 22 : Quality Management</li><li>Course 23 : Compliance &amp; Business Risk Management</li><li>Course 24 : Decision Making and Critical Thinking</li><li>Course 25: Power Electronics for Electrical Engineering</li><li>Course 26: Engineering Management</li><li>Course 27: Electric Circuits for Electrical Engineering</li><li>Course 28: Trigonometry for Electrical Engineering</li><li>Course 29: Electrical Technician</li><li>Course 30: Electronic &amp; Electrical Devices Maintenance</li></ul> <p><strong>7 </strong><strong>Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques-</strong></p> <ul> <li>Course 1: Career Development Plan Fundamentals</li></ul> <ul> <li>Course 2: CV Writing and Job Searching</li></ul> <ul> <li>Course 3: Interview Skills: Ace the Interview</li></ul> <ul> <li>Course 4: Video Job Interview for Job Seekers</li></ul> <ul> <li>Course 5: Create a Professional LinkedIn Profile</li></ul> <ul> <li>Course 6: Business English Perfection Course</li></ul> <ul> <li>Course 7: Networking Skills for Personal Success</li></ul> <p><strong>Learning Outcome</strong></p> <p><strong>This tailor-made Domestic Engineering</strong><strong> bundle will allow you to-</strong></p> <ul> <li>Uncover your skills and aptitudes to break new ground in the related fields</li><li>Deep dive into the fundamental knowledge</li><li>Acquire some hard and soft skills in this area</li><li>Gain some transferable skills to elevate your performance</li><li>Maintain good report with your clients and staff</li><li>Gain necessary office skills and be tech savvy utilising relevant software</li><li>Keep records of your work and make a report</li><li>Know the regulations around this area</li><li>Reinforce your career with specific knowledge of this field</li><li>Know your legal and ethical responsibility as a professional in the related field</li></ul> <p>This Domestic Engineering Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments.</p> <p><strong>Certification</strong></p> <p>After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and <strong>1 hardcopy certificate for the Title Course completely free</strong>. Other Hard Copy certificates need to be ordered at an additional cost of •8.</p> <h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        370 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div> <h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Domestic Engineering bundle! This bundle is also ideal for professionals looking for career advancement.</p> 
                        </div> <h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>To participate in this course, all you need is -</p> <ul> <li>A smart device</li><li>A secure internet connection</li><li>And a keen interest in Domestic Engineering</li></ul> 
                        </div> <h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.</p> 
                        </div>

Design & Technology Courses (DT)

Construction Engineering

Engineering Construction Industry Training (ECITB)

Electrical Engineering

Environmental Engineering

Heating Engineer

Domestic Engineering

<p>Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified<strong> Surveying &amp; Site Management </strong> bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our <strong>37 </strong>course mega bundle that will exceed your expectations within your budget.</p> <p>The<strong> Surveying &amp; Site Management </strong> related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then <strong>StudyHub </strong>proposes a preparatory bundle. This comprehensive <strong>Surveying &amp; Site Management </strong> bundle will help you build a solid foundation to become a proficient worker in the sector.</p> <p><strong>This Surveying &amp; Site Management  Bundle consists of the following</strong><strong> 30 </strong><strong>CPD Accredited Premium courses -</strong></p> <ul> <li>Course 1: Quantity Surveyor Training</li><li>Course 2: Building Surveyor</li><li>Course 3: Land Surveying</li><li>Course 4: Construction Site Planning and Managment</li><li>Course 5: Construction Cost Estimation Diploma</li><li>Course 6: Construction Safety Diploma</li><li>Course 7: Construction Industry Scheme (CIS)</li><li>Course 8: Property Management Training</li><li>Course 9: Effective Communication Skills for Technical People</li><li>Course 10: Leadership Styles</li><li>Course 11: Workplace First Aid Level 3</li><li>Course 12: Workplace Management Training</li><li>Course 13: COSHH Training for Assessors</li><li>Course 14: LOLER Training Level 2</li><li>Course 15: RIDDOR Training</li><li>Course 16: Working at Height</li><li>Course 17: Lone Worker Safety Diploma</li><li>Course 18: Ladder Safety Training</li><li>Course 19: Time Management Training</li><li>Course 20: Property Development Diploma</li><li>Course 21: Property Law</li><li>Course 22: Property Business Training - Level 5</li><li>Course 23: Residential Property Sales</li><li>Course 24: Public Housing Management</li><li>Course 25: WELL Building Standard</li><li>Course 26: Building Design And Construction With LEED V4.1</li><li>Course 27: AutoCAD VBA Programming for Beginners</li><li>Course 28: AutoCAD Programming using C# with Windows Forms</li><li>Course 29: Cost Control and Management Training</li><li>Course 30: Positive Workplace Environment</li></ul> <p><strong>7 </strong><strong>Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques-</strong></p> <ul> <li>Course 1: Career Development Plan Fundamentals</li><li>Course 2: CV Writing and Job Searching</li><li>Course 3: Interview Skills: Ace the Interview</li><li>Course 4: Video Job Interview for Job Seekers</li><li>Course 5:Create a Professional LinkedIn Profile</li><li>Course 6:Business English Perfection Course</li><li>Course 7:Networking Skills for Personal Success</li></ul> <p><strong>Learning Outcome</strong></p> <p><strong>This tailor-made </strong><strong>Surveying &amp; Site Management </strong> <strong> bundle will allow you to-</strong></p> <ul> <li>Uncover your skills and aptitudes to break new ground in the related fields</li><li>Deep dive into the fundamental knowledge </li><li>Acquire some hard and soft skills in this area </li><li>Gain some transferable skills to elevate your performance</li><li>Maintain good report with your clients and staff</li><li>Gain necessary office skills and be tech savvy utilising relevant software </li><li>Keep records of your work and make a report </li><li>Know the regulations around this area</li><li>Reinforce your career with specific knowledge of this field </li><li>Know your legal and ethical responsibility as a professional in the related field</li></ul> <p>This Surveying &amp; Site Management  Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments.</p> <p><strong>Certification</strong></p> <p>After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and <strong>1 hardcopy certificate for the Title Course completely free</strong>. Other Hard Copy certificates need to be ordered at an additional cost of •8.</p> <h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        370 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div> <h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Surveying &amp; Site Management  bundle! This bundle is also ideal for professionals looking for career advancement.</p> 
                        </div> <h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>To participate in this course, all you need is -</p> <ul> <li>A smart device</li><li>A secure internet connection</li><li>And a keen interest in Surveying &amp; Site Management </li></ul> 
                        </div> <h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields. </p> 
                        </div>

Quantity Surveyor

CSCS (Construction Skills Certification Scheme)

Site Management Safety Training Scheme (SMSTS)

Quantity Surveying

Building Surveying

Finance Cert & Exam Prep

Property Development

Trainers Course

Continuous Professional Development (CPD)

Property Development, Management & Estimation

<p>Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified<strong> Property law and Management</strong> bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our <strong> 37 </strong>course mega bundle that will exceed your expectations within your budget.</p> <p>The<strong> Property law and Management</strong> related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then <strong>StudyHub </strong>proposes a preparatory bundle. This comprehensive <strong>Property law and Management</strong> bundle will help you build a solid foundation to become a proficient worker in the sector.</p> <p><strong>This Property law and Management Bundle consists of the following</strong><strong> 30 </strong><strong>CPD Accredited Premium courses -</strong></p> <ul> <li>Course 1: Quantity Surveyor Training</li><li>Course 2: Building Surveyor</li><li>Course 3: Land Surveying</li><li>Course 4: Construction Site Planning and Managment</li><li>Course 5: Construction Cost Estimation Diploma</li><li>Course 6: Construction Safety Diploma</li><li>Course 7: Leadership Styles</li><li>Course 8: Workplace First Aid Level 3</li><li>Course 9: Workplace Management Training</li><li>Course 10: COSHH Training for Assessors</li><li>Course 11: LOLER Training Level 2</li><li>Course 12: RIDDOR Training</li><li>Course 13: Working at Height</li><li>Course 14: Lone Worker Safety Diploma</li><li>Course 15: Ladder Safety Training</li><li>Course 16: Time Management Training</li><li>Course 17: Construction Industry Scheme (CIS)</li><li>Course 18: Property Management Training</li><li>Course 19: Property Development Diploma</li><li>Course 20: Property Law</li><li>Course 21: Property Business Training - Level 5</li><li>Course 22: Residential Property Sales</li><li>Course 23: Public Housing Management</li><li>Course 24: WELL Building Standard</li><li>Course 25: Building Design And Construction With LEED V4.1</li><li>Course 26: AutoCAD VBA Programming for Beginners</li><li>Course 27: AutoCAD Programming using C# with Windows Forms</li><li>Course 28: Cost Control and Management Training</li><li>Course 29: Positive Workplace Environment</li><li>Course 30: Effective Communication Skills for Technical People</li></ul> <p><strong>7 </strong><strong>Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques-</strong></p> <ul> <li>Course 1: Career Development Plan Fundamentals</li><li>Course 2: CV Writing and Job Searching</li><li>Course 3: Interview Skills: Ace the Interview</li><li>Course 4: Video Job Interview for Job Seekers</li><li>Course 5:Create a Professional LinkedIn Profile</li><li>Course 6:Business English Perfection Course</li><li>Course 7:Networking Skills for Personal Success</li></ul> <p><strong>Learning Outcome</strong></p> <p><strong>This tailor-made </strong><strong>Property law and Management</strong><strong> bundle will allow you to-</strong></p> <ul> <li>Uncover your skills and aptitudes to break new ground in the related fields</li><li>Deep dive into the fundamental knowledge </li><li>Acquire some hard and soft skills in this area </li><li>Gain some transferable skills to elevate your performance</li><li>Maintain good report with your clients and staff</li><li>Gain necessary office skills and be tech savvy utilising relevant software </li><li>Keep records of your work and make a report </li><li>Know the regulations around this area</li><li>Reinforce your career with specific knowledge of this field </li><li>Know your legal and ethical responsibility as a professional in the related field</li></ul> <p>This Property law and Management Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments.</p> <p><strong>Certification</strong></p> <p>After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and <strong>1 hardcopy certificate for the Title Course completely free</strong>. Other Hard Copy certificates need to be ordered at an additional cost of •8.</p> <h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        370 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div> <h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Property law and Management bundle! This bundle is also ideal for professionals looking for career advancement.</p> 
                        </div> <h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>To participate in this course, all you need is -</p> <ul> <li>A smart device</li><li>A secure internet connection</li><li>And a keen interest in Property law and Management</li></ul> 
                        </div> <h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields. </p> 
                        </div>

Property Management

Legal Practice Course (LPC)

Bar Professional Training Course (BPTC)

Bar Practice Course (BPC)

Commercial & Contract Management Certification Program (CCM)

Property law and Management

<p>Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified<strong> Facilities Management and Organizational Skills</strong> bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our <strong>37 </strong>course mega bundle that will exceed your expectations within your budget.</p> <p>The<strong> Facilities Management and Organizational Skills</strong> related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then <strong>StudyHub </strong>proposes a preparatory bundle. This comprehensive <strong> Facilities Management and Organizational Skills</strong> bundle will help you build a solid foundation to become a proficient worker in the sector.</p> <p><strong>This Facilities Management and Organizational Skills Bundle consists of the following</strong><strong> 30 </strong><strong>CPD Accredited Premium courses - </strong></p> <ul> <li>Course 1: Land Surveying and Cost Estimation</li><li>Course 2: Multiplex Building Cost Estimation Using Xactimate</li><li>Course 3: Construction Estimation using RSMeans</li><li>Course 4: Construction Cost Estimation Using Xactimate</li><li>Course 5: Quantity Surveying &amp; Cost Estimation</li><li>Course 6: Surveying Basics</li><li>Course 7: Building Surveying</li><li>Course 8: Residential Surveyor</li><li>Course 9: Construction Industry Scheme (CIS)</li><li>Course 10: Construction Management Level 3</li><li>Course 11: Site Safety Plus</li><li>Course 12: CSCS Health and Safety in a Construction Environment (Leading to CSCS Green Card)</li><li>Course 13: Construction Risk Assessment</li><li>Course 14: Operations and Supply Chain Management</li><li>Course 15: Environmental Engineering</li><li>Course 16: Advanced Electrical Safety</li><li>Course 17: Emergency First Aid at Work (EFAW)</li><li>Course 18: Asbestos Surveying</li><li>Course 19: COSHH Awareness</li><li>Course 20: Gas Safety</li><li>Course 21: Construction Project Management</li><li>Course 22: Site Management Safety Training Scheme</li><li>Course 23: CDM Regulations</li><li>Course 24: Purchasing and Procurement Diploma</li><li>Course 25: LOLER Regulations and LOLER Inspection Training</li><li>Course 26: Manual Handling Interactive Training</li><li>Course 27: Noise and Hearing Protection</li><li>Course 28: PUWER</li><li>Course 29: Supervisor Training</li><li>Course 30: Logistic Maangement</li></ul> <p><strong>7 </strong><strong>Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques-</strong></p> <ul> <li>Course 1: Career Development Plan Fundamentals</li><li>Course 2: CV Writing and Job Searching</li><li>Course 3: Interview Skills: Ace the Interview</li><li>Course 4: Video Job Interview for Job Seekers</li><li>Course 5:Create a Professional LinkedIn Profile</li><li>Course 6:Business English Perfection Course</li><li>Course 7:Networking Skills for Personal Success</li></ul> <p><strong>Learning Outcome</strong></p> <p><strong>This tailor-made </strong><strong>Facilities Management and Organizational Skills</strong><strong> bundle will allow you to-</strong></p> <ul> <li>Uncover your skills and aptitudes to break new ground in the related fields</li><li>Deep dive into the fundamental knowledge</li><li>Acquire some hard and soft skills in this area</li><li>Gain some transferable skills to elevate your performance</li><li>Maintain good report with your clients and staff</li><li>Gain necessary office skills and be tech savvy utilising relevant software</li><li>Keep records of your work and make a report</li><li>Know the regulations around this area</li><li>Reinforce your career with specific knowledge of this field</li><li>Know your legal and ethical responsibility as a professional in the related field</li></ul> <p>This Facilities Management and Organizational Skills Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments.</p> <p><strong>Certification</strong></p> <p>After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and <strong>1 hardcopy certificate for the Title Course completely free</strong>. Other Hard Copy certificates need to be ordered at an additional cost of •8.</p> <h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        370 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div> <h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Facilities Management and Organizational Skills bundle! This bundle is also ideal for professionals looking for career advancement.</p> 
                        </div> <h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>To participate in this course, all you need is -</p> <ul> <li>A smart device</li><li>A secure internet connection</li><li>And a keen interest in Facilities Management and Organizational Skills</li></ul> 
                        </div> <h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.</p> 
                        </div>

Certified Facility Manager (CFM)

Management Skills

Facility Management

Facilities Management and Organizational Skills

<p>Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified<strong> Site Surveying and Management</strong> bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our <strong> 37 </strong>course mega bundle that will exceed your expectations within your budget.</p> <p>The<strong> Site Surveying and Management</strong> related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then <strong>StudyHub </strong>proposes a preparatory bundle. This comprehensive <strong>Site Surveying and Management</strong> bundle will help you build a solid foundation to become a proficient worker in the sector.</p> <p><strong>This Site Surveying and Management Bundle consists of the following</strong><strong> 30 </strong><strong>CPD Accredited Premium courses - </strong></p> <ul> <li>Course 1: Construction Management Level 3</li><li>Course 2: Construction Project Management</li><li>Course 3: Site Management Safety Training Scheme</li><li>Course 4: CDM Regulations</li><li>Course 5: Site Safety Plus</li><li>Course 6: CSCS Health and Safety in a Construction Environment (Leading to CSCS Green Card)</li><li>Course 7: Construction Risk Assessment</li><li>Course 8: Quantity Surveying</li><li>Course 9: Building Surveying</li><li>Course 10: Land Surveying and Cost Estimation</li><li>Course 11: Operations and Supply Chain Management</li><li>Course 12: Environmental Engineering</li><li>Course 13: Advanced Electrical Safety</li><li>Course 14: Emergency First Aid at Work (EFAW)</li><li>Course 15: Asbestos Surveying</li><li>Course 16: COSHH Awareness</li><li>Course 17: Gas Safety</li><li>Course 18: Environmental Health</li><li>Course 19: Abrasive Wheels</li><li>Course 20: Purchasing and Procurement Diploma</li><li>Course 21: LOLER Regulations and LOLER Inspection Training</li><li>Course 22: Manual Handling Interactive Training</li><li>Course 23: Fire Safety</li><li>Course 24: Noise and Hearing Protection</li><li>Course 25: PUWER</li><li>Course 26: Supervisor Training</li><li>Course 27: Logistic Maangement</li><li>Course 28: Concussion Injuriy</li><li>Course 29: Working in Confined Spaces</li><li>Course 30: Working at Height Training</li></ul> <p><strong>7 </strong><strong>Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques-</strong></p> <ul> <li>Course 1: Career Development Plan Fundamentals</li><li>Course 2: CV Writing and Job Searching</li><li>Course 3: Interview Skills: Ace the Interview</li><li>Course 4: Video Job Interview for Job Seekers</li><li>Course 5:Create a Professional LinkedIn Profile</li><li>Course 6:Business English Perfection Course</li><li>Course 7:Networking Skills for Personal Success</li></ul> <p><strong>Learning Outcome</strong></p> <p><strong>This tailor-made </strong><strong>Site Surveying and Management</strong><strong> bundle will allow you to-</strong></p> <ul> <li>Uncover your skills and aptitudes to break new ground in the related fields</li><li>Deep dive into the fundamental knowledge </li><li>Acquire some hard and soft skills in this area </li><li>Gain some transferable skills to elevate your performance</li><li>Maintain good report with your clients and staff</li><li>Gain necessary office skills and be tech savvy utilising relevant software </li><li>Keep records of your work and make a report </li><li>Know the regulations around this area</li><li>Reinforce your career with specific knowledge of this field </li><li>Know your legal and ethical responsibility as a professional in the related field</li></ul> <p>This Site Surveying and Management Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments.</p> <p><strong>Certification</strong></p> <p>After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and <strong>1 hardcopy certificate for the Title Course completely free</strong>. Other Hard Copy certificates need to be ordered at an additional cost of •8.</p> <h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        370 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div> <h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Site Surveying and Management bundle! This bundle is also ideal for professionals looking for career advancement.</p> 
                        </div> <h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>To participate in this course, all you need is -</p> <ul> <li>A smart device</li><li>A secure internet connection</li><li>And a keen interest in Site Surveying and Management</li></ul> 
                        </div> <h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields. </p> 
                        </div>

Construction Design & Management (CDM)

Advanced Surveying & Construction Site Management (SMSTS) Diploma - CPD Certified

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>This course is for Azure Security Engineers who are planning to take the associated certification exam, or who are performing security tasks in their day-to-day job. This course would also be helpful to an engineer that wants to specialize in providing security for Azure-based digital platforms and play an integral role in protecting an organization's data.</p><p></p><p></p><p>This course provides IT Security Professionals with the knowledge and skills needed to implement security controls, maintain an organization?s security posture, and identify and remediate security vulnerabilities. This course includes security for identity and access, platform protection, data and applications, and security operations.</p><p></p>Prerequisites<p></p><li>AZ-104T00 - Microsoft Azure Administrator</li>  <li>Security best practices and industry security requirements such as defense in depth, least privileged access, role-based access control, multi-factor authentication, shared responsibility, and zero trust model.</li>  <li>Be familiar with security protocols such as Virtual Private Networks (VPN), Internet Security Protocol (IPSec), Secure Socket Layer (SSL), disk and data encryption methods.</li>  <li>Have some experience deploying Azure workloads. This course does not cover the basics of Azure administration, instead the course content builds on that knowledge by adding security specific information.</li>  <li>Have experience with Windows and Linux operating systems and scripting languages. Course labs may use PowerShell and the CLI.</li><p></p></div><div id="course-pills-2"><h3>1 - Manage identities in Microsoft Entra ID</h3> <ul> <li>Secure users in Microsoft Entra ID</li> <li>Secure groups in Microsoft Entra ID</li> <li>Recommend when to use external identities</li> <li>Secure external identities</li> <li>Implement Microsoft Entra Identity protection</li> </ul> <h3>2 - Manage authentication by using Microsoft Entra ID</h3> <ul> <li>Configure Microsoft Entra Verified ID</li> <li>Implement multifactor authentication (MFA)</li> <li>Implement passwordless authentication</li> <li>Implement password protection</li> <li>Implement single sign-on (SSO)</li> <li>Integrate single sign-on (SSO) and identity providers</li> <li>Recommend and enforce modern authentication protocols </li> </ul> <h3>3 - Manage authorization by using Microsoft Entra ID</h3> <ul> <li>Configure Azure role permissions for management groups, subscriptions, resource groups, and resources</li> <li>Assign built-in roles in Microsoft Entra ID</li> <li>Assign built-in roles in Azure</li> <li>Create and assign a custom role in Microsoft Entra ID</li> <li>Implement and manage Microsoft Entra Permissions Management</li> <li>Configure Microsoft Entra Privileged Identity Management </li> <li>Configure role management and access reviews by using Microsoft Entra Identity Governance</li> <li>Implement Conditional Access policies</li> </ul> <h3>4 - Manage application access in Microsoft Entra ID</h3> <ul> <li>Manage access to enterprise applications in Microsoft Entra ID, including OAuth permission grants</li> <li>Manage app registrations in Microsoft Entra ID</li> <li>Configure app registration permission scopes</li> <li>Manage app registration permission consent</li> <li>Manage and use service principals</li> <li>Manage managed identities for Azure resources</li> <li>Recommend when to use and configure a Microsoft Entra Application Proxy, including authentication</li> </ul> <h3>5 - Plan and implement security for virtual networks</h3> <ul> <li>Plan and implement Network Security Groups (NSGs) and Application Security Groups (ASGs)</li> <li>Plan and implement User-Defined Routes (UDRs)</li> <li>Plan and implement Virtual Network peering or gateway</li> <li>Plan and implement Virtual Wide Area Network, including secured virtual hub</li> <li>Secure VPN connectivity, including point-to-site and site-to-site</li> <li>Implement encryption over ExpressRoute</li> <li>Configure firewall settings on PaaS resources</li> <li>Monitor network security by using Network Watcher, including NSG flow logging</li> </ul> <h3>6 - Plan and implement security for private access to Azure resources</h3> <ul> <li>Plan and implement virtual network Service Endpoints</li> <li>Plan and implement Private Endpoints</li> <li>Plan and implement Private Link services</li> <li>Plan and implement network integration for Azure App Service and Azure Functions</li> <li>Plan and implement network security configurations for an App Service Environment (ASE)</li> <li>Plan and implement network security configurations for an Azure SQL Managed Instance</li> </ul> <h3>7 - Plan and implement security for public access to Azure resources</h3> <ul> <li>Plan and implement Transport Layer Security (TLS) to applications, including Azure App Service and API Management</li> <li>Plan, implement, and manage an Azure Firewall, Azure Firewall Manager and firewall policies</li> <li>Plan and implement an Azure Application Gateway</li> <li>Plan and implement an Azure Front Door, including Content Delivery Network (CDN)</li> <li>Plan and implement a Web Application Firewall (WAF)</li> <li>Recommend when to use Azure DDoS Protection Standard</li> </ul> <h3>8 - Plan and implement advanced security for compute</h3> <ul> <li>Plan and implement remote access to public endpoints, Azure Bastion and just-in-time (JIT) virtual machine (VM) access</li> <li>Configure network isolation for Azure Kubernetes Service (AKS)</li> <li>Secure and monitor AKS</li> <li>Configure authentication for AKS</li> <li>Configure security for Azure Container Instances (ACIs)</li> <li>Configure security for Azure Container Apps (ACAs)</li> <li>Manage access to Azure Container Registry (ACR)</li> <li>Configure disk encryption, Azure Disk Encryption (ADE), encryption as host, and confidential disk encryption</li> <li>Recommend security configurations for Azure API Management</li> </ul> <h3>9 - Plan and implement security for storage</h3> <ul> <li>Configure access control for storage accounts</li> <li>Manage life cycle for storage account access keys</li> <li>Select and configure an appropriate method for access to Azure Files</li> <li>Select and configure an appropriate method for access to Azure Blob Storage</li> <li>Select and configure an appropriate method for access to Azure Tables</li> <li>Select and configure an appropriate method for access to Azure Queues</li> <li>Select and configure appropriate methods for protecting against data security threats, including soft delete, backups, versioning, and immutable storage</li> <li>Configure Bring your own key (BYOK)</li> <li>Enable double encryption at the Azure Storage infrastructure level</li> </ul> <h3>10 - Plan and implement security for Azure SQL Database and Azure SQL Managed Instance</h3> <ul> <li>Enable database authentication by using Microsoft Entra ID</li> <li>Enable and monitor database audit</li> <li>Identify use cases for the Microsoft Purview governance portal</li> <li>Implement data classification of sensitive information by using the Microsoft Purview governance portal</li> <li>Plan and implement dynamic mask</li> <li>Implement transparent data encryption?</li> <li>Recommend when to use Azure SQL Database Always Encrypted</li> </ul> <h3>11 - Plan, implement, and manage governance for security</h3> <ul> <li>Create, assign, and interpret security policies and initiatives in Azure Policy</li> <li>Configure security settings by using Azure Blueprint</li> <li>Deploy secure infrastructures by using a landing zone</li> <li>Create and configure an Azure Key Vault</li> <li>Recommend when to use a dedicated Hardware Security Module (HSM)</li> <li>Configure access to Key Vault, including vault access policies and Azure Role Based Access Control</li> <li>Manage certificates, secrets, and keys</li> <li>Configure key rotation</li> <li>Configure backup and recovery of certificates, secrets, and keys</li> </ul> <h3>12 - Manage security posture by using Microsoft Defender for Cloud</h3> <ul> <li>Implement Microsoft Defender for Cloud</li> <li>Identify and remediate security risks by using the Microsoft Defender for Cloud Secure Score and Inventory</li> <li>Assess compliance against security frameworks and Microsoft Defender for Cloud</li> <li>Add industry and regulatory standards to Microsoft Defender for Cloud</li> <li>Add custom initiatives to Microsoft Defender for Cloud</li> <li>Connect hybrid cloud and multicloud environments to Microsoft Defender for Cloud</li> <li>Identify and monitor external assets by using Microsoft Defender External Attack Surface Management</li> </ul> <h3>13 - Configure and manage threat protection by using Microsoft Defender for Cloud</h3> <ul> <li>Enable workload protection services in Microsoft Defender for Cloud, including Microsoft Defender for Storage, Databases, Containers, App Service, Key Vault, Resource Manager, and DNS</li> <li>Configure Microsoft Defender for Servers</li> <li>Configure Microsoft Defender for Azure SQL Database</li> <li>Manage and respond to security alerts in Microsoft Defender for Cloud</li> <li>Configure workflow automation by using Microsoft Defender for Cloud</li> <li>Evaluate vulnerability scans from Microsoft Defender for Server</li> </ul> <h3>14 - Configure and manage security monitoring and automation solutions</h3> <ul> <li>Monitor security events by using Azure Monitor</li> <li>Configure data connectors in Microsoft Sentinel</li> <li>Create and customize analytics rules in Microsoft Sentinel</li> <li>Configure automation in Microsoft Sentinel</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans AZ-500T00 Microsoft Azure Security Technologies training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the AZ-500T00 Microsoft Azure Security Technologies course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Nexus Human

Microsoft AZ-900

Microsoft Azure

Microsoft AZ-303

Microsoft AZ-700

CompTIA Security+

AZ-500T00 Microsoft Azure Security Technologies

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p></p><p>This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.</p><p></p><p></p><p>This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.</p><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Transact-SQL</h3> <ul> <li>Work with schemas</li> <li>Explore the structure of SQL statements</li> <li>Examine the SELECT statement</li> <li>Work with data types</li> <li>Handle NULLs</li> </ul> <h3>2 - Sort and filter results in T-SQL</h3> <ul> <li>Sort your results</li> <li>Limit the sorted results</li> <li>Page results</li> <li>Remove duplicates</li> <li>Filter data with predicates</li> </ul> <h3>3 - Combine multiple tables with JOINs in T-SQL</h3> <ul> <li>Understand joins concepts and syntax</li> <li>Use inner joins</li> <li>Use outer joins</li> <li>Use cross joins</li> <li>Use self joins</li> </ul> <h3>4 - Write Subqueries in T-SQL</h3> <ul> <li>Understand subqueries</li> <li>Use scalar or multi-valued subqueries</li> <li>Use self-contained or correlated subqueries</li> </ul> <h3>5 - Use built-in functions and GROUP BY in Transact-SQL</h3> <ul> <li>Categorize built-in functions</li> <li>Use scalar functions</li> <li>Use ranking and rowset functions</li> <li>Use aggregate functions</li> <li>Summarize data with GROUP BY</li> <li>Filter groups with HAVING</li> </ul> <h3>6 - Modify data with T-SQL</h3> <ul> <li>Insert data</li> <li>Generate automatic values</li> <li>Update data</li> <li>Delete data</li> <li>Merge data based on multiple tables</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL 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 DP-080T00 Querying Data with Microsoft Transact-SQL 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>

Learning & Development

Data Skills

Teaching & Training

DP-080T00 Querying Data with Microsoft Transact-SQL

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p></p><p>The audience for this course is individuals who want to learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure.</p><p></p>Overview<p>Describe core data concepts Identify considerations for relational data on Azure Describe considerations for working with non-relational data on Azure Describe an analytics workload on Azure</p><p></p><p>In this course, students will gain foundational knowledge of core data concepts and related Microsoft Azure data services. Students will learn about core data concepts such as relational, non-relational, big data, and analytics, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will explore fundamental relational data concepts and relational database services in Azure. They will explore Azure storage for non-relational data and the fundamentals of Azure Cosmos DB. Students will learn about large-scale data warehousing, real-time analytics, and data visualization.</p><p></p></div><div id="course-pills-2"><h3>1 - Explore core data concepts</h3> <ul> <li>Identify data formats</li> <li>Explore file storage</li> <li>Explore databases</li> <li>Explore transactional data processing</li> <li>Explore analytical data processing</li> </ul> <h3>2 - Explore data roles and services</h3> <ul> <li>Explore job roles in the world of data</li> <li>Identify data services</li> </ul> <h3>3 - Explore fundamental relational data concepts</h3> <ul> <li>Understand relational data</li> <li>Understand normalization</li> <li>Explore SQL</li> <li>Describe database objects</li> </ul> <h3>4 - Explore relational database services in Azure</h3> <ul> <li>Describe Azure SQL services and capabilities</li> <li>Describe Azure services for open-source databases</li> </ul> <h3>5 - Explore Azure Storage for non-relational data</h3> <ul> <li>Explore Azure blob storage</li> <li>Explore Azure DataLake Storage Gen2</li> <li>Explore Azure Files</li> <li>Explore Azure Tables</li> </ul> <h3>6 - Explore fundamentals of Azure Cosmos DB</h3> <ul> <li>Describe Azure Cosmos DB</li> <li>Identify Azure Cosmos DB APIs</li> </ul> <h3>7 - Explore fundamentals of large-scale data warehousing</h3> <ul> <li>Describe data warehousing architecture</li> <li>Explore data ingestion pipelines</li> <li>Explore analytical data stores</li> </ul> <h3>8 - Explore fundamentals of real-time analytics</h3> <ul> <li>Understand batch and stream processing</li> <li>Explore common elements of stream processing architecture</li> <li>Explore Azure Stream Analytics</li> <li>Explore Apache Spark on Microsoft Azure</li> </ul> <h3>9 - Explore fundamentals of data visualization</h3> <ul> <li>Describe Power BI tools and workflow</li> <li>Describe core concepts of data modeling</li> <li>Describe considerations for data visualization</li> </ul></div>

Azure SQL Database

DP-900T00 Microsoft Azure Data Fundamentals

<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 IT professionals who are responsible for planning, configuring, and managing an Office 365 environment. Students who attend this course are expected to have a fairly broad understanding of several on-premises technologies such as Domain Name System (DNS) and Active Directory Domain Services (AD DS). In addition, they should have a general understanding of Microsoft Exchange Server, Microsoft Teams, and Microsoft SharePoint.</p>Overview<p>Plan and provision Office 365 Manage Users and Groups in Office 365 Deploy and Configure Tools and Applications for Office 365 Plan and Manage Exchange Online Plan and Manage SharePoint Online Plan and Manage Microsoft Teams Plan and Manage other Office 365 Services Implement Security and Compliance in Office 365 Report, Monitor and Troubleshoot Office 365</p><p>This five-day course describes how to set up, configure and manage an Office 365 tenant including identities, and the core services of Microsoft 365. In this five-day course, you will learn how to plan the configuration of an Office 365 tenant including integration with existing user identities; plan, configure and manage core services; and report on key metrics. <br /><br /> Although this course and the associated labs are written for Office 365 with Windows 11, the skills taught will also be backwards compatible with Windows 10. This course is based on the features available in the Office 365 E3 license as these are the core features in Office 365 and Microsoft 365 plans.</p></div><div id="course-pills-2"><h3>1 - Planning and Provisioning Office 365</h3> <ul> <li>Overview of Office 365</li> <li>Core Services of Office 365</li> <li>Requirements for an Office 365 Tenant</li> <li>Planning a Pilot and Deployment</li> <li>Creating an Office 365 Tenant</li> <li>Adding Custom Domains and Managing DNS Settings</li> <li>Lab: Provisioning Office 365</li> </ul> <h3>2 - Managing Users and Groups in Office 365</h3> <ul> <li>Managing User Accounts and Licences</li> <li>Managing Passwords and Authentication</li> <li>Create and Managing the Different Types of Groups in Office 365</li> <li>Managing Users and Groups with PowerShell</li> <li>Managing Users and Groups in the Azure AD Admin Center</li> <li>Role Based Access and Administrative Roles</li> <li>Planning and Configuring Directory Synchronization</li> <li>Lab: Managing Users and Groups in Office 365</li> <li>Lab: Planning and Configuring Directory Synchronisation</li> </ul> <h3>3 - Deploying and Configuring Tools and Applications for Office 365</h3> <ul> <li>Planning Network Configuration for Office 365 Tools and Applications</li> <li>Using the Office Configuration Tool</li> <li>Click to Run Installation Use and Control</li> <li>Managing Centralized Deployment of Tools, Applications and Add-ins</li> <li>Reporting</li> <li>Lab: Deploying and Configuring Tools and Applications for Office 365</li> </ul> <h3>4 - Planning and Managing Exchange Online</h3> <ul> <li>What is Exchange Online</li> <li>Managing Exchange Online Mailboxes</li> <li>Managing Office 365 Groups in Exchange Online</li> <li>Configuring Exchange Online Permissions</li> <li>Managing Exchange Online using PowerShell</li> <li>Plan and Configure Mail Flow</li> <li>Plan and Configure Email Protection</li> <li>Lab: Planning and Managing Exchange Online</li> </ul> <h3>5 - Planning and Managing SharePoint Online</h3> <ul> <li>What is SharePoint Online</li> <li>Understanding the relationship between SharePoint, OneDrive, Teams, and Office 365 Groups</li> <li>SharePoint Online Architecture</li> <li>Configure SharePoint Online</li> <li>Configure and Control External Sharing</li> <li>Managing SharePoint Online Site Collections</li> <li>Managing SharePoint Online using PowerShell</li> <li>Lab: Planning and Managing SharePoint Online</li> </ul> <h3>6 - Planning and Managing Microsoft Teams</h3> <ul> <li>What is Microsoft Teams</li> <li>How Microsoft Teams integrates with other Office 365 Services</li> <li>Create and Manage Organization Wide Settings</li> <li>Create, Manage and Assign Microsoft Teams Policies</li> <li>Plan and Configure External and Guest Access</li> <li>Managing Microsoft Teams using PowerShell</li> <li>Lab: Planning and Managing Microsoft Teams</li> </ul> <h3>7 - Planning and Managing Other Office 365 Services</h3> <ul> <li>Yammer</li> <li>Planner</li> <li>Visio</li> <li>Bookings</li> <li>Delve</li> <li>Forms</li> <li>Power Platform</li> <li>Stream</li> <li>Sway</li> <li>Viva</li> <li>Scheduler</li> <li>Add-ins, including Find Time and Junk Reporter</li> <li>Lab: Planning and Managing Office 365 Services</li> </ul> <h3>8 - Security and Compliance in Office 365</h3> <ul> <li>Overview of Security and Compliance Features in Office 365</li> <li>Extending Security and compliance Features with Additional Licences</li> <li>Using the Microsoft Defender Portal and Secure Score</li> <li>Using the Office 365 Compliance Portal and Compliance Score</li> <li>Plan and Configure Retention Labels and Policies</li> <li>Plan and Configure Data Loss Prevention Policies</li> <li>Create and Assign Sensitivity Labels</li> <li>Configure Safe Attachments and Safe Links Policies</li> <li>Plan and Configure Multi Factor Authentication</li> <li>Lab: Configure Security and Compliance in Office 365</li> </ul> <h3>9 - Reporting, Monitoring and Troubleshooting Office 365</h3> <ul> <li>Monitoring Office 365 Service Health</li> <li>Troubleshooting Administrative Access in Office 365</li> <li>Troubleshoot Directory Synchronization</li> <li>Troubleshooting Exchange Online</li> <li>Troubleshooting SharePoint Online</li> <li>Troubleshooting Microsoft Teams</li> <li>Troubleshooting Office 365 Security and Compliance</li> <li>Lab: Reporting, Monitoring and Troubleshooting in Office 365</li> </ul></div>

55354 Administering Office 365

<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 Enterprise network staff responsible for help desk support, system administration, and network design.</p>Overview<p>At Course Completion: - Features and functions of Group Policy - Use Group Policy management tools to manage security policies - Design a Group Policy infrastructure - Group Policy processing architecture - Back up, restore, import, and copy Group Policy Objects through the Group Policy - Management Console - Use Windows PowerShell to manage Group Policy - Implement security using Group Policy - Configure the desktop environment with Group Policy - Configure roaming profiles and Folder Redirection - Assign and publish software packages - Implement AppLocker and software restriction policies - Create and deploy Administrative Templates - Configure Group Policy preferences</p><p>In this course, you will learn how to reduce costs and increase efficiencies in your network. You will discover how to consolidate the administration of an enterprise IT infrastructure with Group Policy, and you will learn to control and manage computer systems and domain users running Windows Server 2016 and Windows clients. Create Group Policies, implement administrative and security templates, and determine best practices when deploying software packages. Walk away with the experience and tools needed to optimize your enterprise systems and networks, implement administrative and security templates, and determine best practices when deploying software packages.</p></div><div id="course-pills-2"><h3>1 - Introduction to Configuration Management</h3> <ul> <li>Configuration Management Overview</li> <li>Configuration Management Using Group Policy</li> <li>Group Policy Features Introduced with Later Versions of Windows</li> <li>Using Windows PowerShell in the Configuration Management Process</li> </ul> <h3>2 - Using Group Policy Management Tools</h3> <ul> <li>Local and Domain Policies</li> <li>Using Group Policy Management Console</li> <li>Understanding Group Policy Refresh</li> </ul> <h3>3 - Designing a Group Policy Infrastructure</h3> <ul> <li>Design Stages for a Group Policy Infrastructure</li> <li>Planning your Group Policy Design</li> <li>Designing Your Group Policy Solution</li> <li>Deploying Your Group Policy Solution</li> <li>Managing Your Group Policy Solution</li> </ul> <h3>4 - Understanding the Architecture of Group Policy Processing</h3> <ul> <li>Group Policy Components in AD DS</li> <li>Understanding the Group Policy Deployment Order</li> <li>Modifying Group Policy Processing</li> </ul> <h3>5 - Troubleshooting and Backing Up GPOs</h3> <ul> <li>Using Group Policy Troubleshooting Tools</li> <li>Integration of RSoP Functionality</li> <li>Group Policy Logging Options</li> <li>Backing Up, Restoring, Importing, and Copying GPOs</li> <li>Building Migration Tables</li> </ul> <h3>6 - Securing Windows Using Group Policy</h3> <ul> <li>Exploring the Windows Security Architecture</li> <li>Securing User Accounts</li> <li>Exploring Security Policies</li> <li>Windows Firewall with Advanced Security</li> <li>Implementing Domain Security</li> <li>Security Policy Options for Window Client and Windows Server</li> </ul> <h3>7 - Implementing Application Security Using Group Policy</h3> <ul> <li>Managing UAC Settings</li> <li>Defending Against Malware</li> <li>Using AppLocker to Restrict Software</li> <li>Implementing Windows App Security Settings</li> </ul> <h3>8 - Configuring the Desktop Environment with Group Policy</h3> <ul> <li>Exploring Script Types and Controlling Script Execution</li> <li>Defining the Desktop, Start Menu, and Taskbar Settings</li> <li>Defining the Control Panel Settings</li> <li>Defining the Windows Components Settings</li> <li>Configuring the Printer Management and Pruning Settings</li> <li>Defining the Network Settings</li> <li>Discovering the new Group Policy Settings</li> </ul> <h3>9 - Implementing User State Virtualization</h3> <ul> <li>Configuring Folder Redirection</li> <li>Managing Offline Files</li> <li>Implementing User Experience Virtualization</li> <li>OneDrive for Business</li> </ul> <h3>10 - Assigning and Publishing Software Packages</h3> <ul> <li>Using MSI Packages to Distribute Software</li> <li>Using Group Policy as a Software Deployment Method</li> <li>Deploying Software</li> <li>Setting Up Distribution Points</li> <li>Using the Systems Center Configuration Manager to Distribute Software</li> </ul> <h3>11 - Configuration Management with Windows PowerShell</h3> <ul> <li>Introducing Windows PowerShell</li> <li>Using Windows PowerShell</li> <li>Writing PowerShell Scripts</li> <li>Windows PowerShell Library for Group Policy</li> <li>Windows PowerShell-Based Logon Scripts</li> </ul> <h3>12 - Implementing PowerShell Desired State Configuration</h3> <ul> <li>Introducing Group Policy Preferences</li> <li>Comparing Preferences and Policy Settings</li> <li>Options for Applying Preferences</li> <li>Configure Preference Settings</li> </ul> <h3>13 - Configuring Group Policy Preferences</h3> <ul> <li>Introducing Group Policy Preferences</li> <li>Comparing Preferences and Policy Settings</li> <li>Options for Applying Preferences</li> <li>Configuring Preferences Settings</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 50255 Managing Windows Environments with Group Policy 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 50255 Managing Windows Environments with Group Policy 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>

50255 Managing Windows Environments with Group Policy

MS-102T00 Microsoft 365 Administrator Essentials

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Candidates for this course design, develop, secure, and troubleshoot Power Platform solutions. Candidates implement components of a solution that include application enhancements, custom user experience, system integrations, data conversions, custom process automation, and custom visualizations. Candidates will gain applied knowledge of Power Platform services, including in-depth understanding of capabilities, boundaries, and constraints.</p>Overview<p>After completing this course, students will be able to:<br />Create a technical design<br />Configure Common Data Service<br />Create and configure Power Apps<br />Configure business process automation<br />Extend the user experience<br />Extend the platform<br />Develop Integrations</p><p>The Microsoft Power Platform helps organizations optimize their operations by simplifying, automating and transforming business tasks and processes. In this course, students will learn how to build Power Apps, Automate Flows and extend the platform to complete business requirements and solve complex business problems.</p></div><div id="course-pills-2"><h4>Create a model-driven application in Power Apps</h4><ul><li>This module introduces you to creating a model-driven app in Power Apps that uses Common Data Service.</li></ul><h4>Get started using Common Data Service</h4><ul><li>This module will explain the concepts behind and benefits of Common Data Service. Creating an environment, entities, fields and options sets are also discussed.</li></ul><h4>Create a canvas app in Power Apps</h4><ul><li>This module introduces you to Power Apps, helps you create and customize an app, and then manage and distribute it. It will also show you how to provide the best app navigation, and build the best UI using themes, icons, images, personalization, different form factors, and controls.</li></ul><h4>Automate a business process using Power Automate</h4><ul><li>This module introduces you to Power Automate, teaches you how to build workflows, and how to administer flows.</li></ul><h4>Create a business process flow in Power Automate</h4><ul><li>This module introduces you to creating business process flows in Power Automate</li></ul><h4>Introduction to developing with Power Platform</h4><ul><li>This module is the first step in learning about platform, tools, and the ecosystem of the Power Platform</li></ul><h4>Extending the Power Platform user experience Model Driven apps</h4><ul><li>This module describes how to create client scripting, perform common actions with client script, and automate business process flow with client scrip. Learn about what client script can do, rules, and maintaining scripts. Discover when to use client script as well as when not to use client script.</li></ul><h4>Create components with Power Apps Component Framework</h4><ul><li>This module describes how to get started with Power Apps Component Framework with an introductory module on the core concepts and components. Then it shows you how to build a component and work with advanced Power Apps Component Framework features.</li></ul><h4>Extending the Power Platform Common Data Service</h4><ul><li>This module looks at the tools and resources needed for extending the Power Platform. We'll start with looking at the SDKs, the extensibility model, and event framework. This learning path also covers when to use plug-ins. Configuration of plug-ins as well as registering and deploying plug-ins.</li></ul><h4>Integrate with Power Platform and Common Data Service</h4><ul><li>This module describes how to integrate with Common Data Service using code by learning about Common Data Service API. Get an in-depth overview of options available with Common Data Service to integrate data and events to Azure.</li></ul><h4>Extend Power Apps portals</h4><ul><li>This module describes how to transform a content portal into a full web app interacting with Common Data Service. We will also cover the options available to customizers and developers to extend the portal functionality and integrate with Office 365, Power Platform, and Azure components.</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans PL-400T00 Microsoft Power Platform Developer training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the PL-400T00 Microsoft Power Platform Developer course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Microsoft PL-900

Microsoft Power Apps

Power Apps

Microsoft Power Platform

Microsoft Power Automate

PL-400T00 Microsoft Power Platform Developer

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p></p><p>The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.</p><p></p><p></p><p>This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.</p><p></p>Prerequisites<p></p><li>Understanding core data concepts.</li>  <li>Knowledge of working with relational data in the cloud.</li>  <li>Knowledge of working with non-relational data in the cloud.</li>   <li>Knowledge of data analysis and visualization concepts.</li>   <li>DP-900T00 Microsoft Azure Data Fundamentals is recommended<p></p></li></div><div id="course-pills-2"><h3>1 - Discover data analysis</h3> <ul> <li>Overview of data analysis</li> <li>Roles in data</li> <li>Tasks of a data analyst</li> </ul> <h3>2 - Get started building with Power BI</h3> <ul> <li>Use Power BI</li> <li>Building blocks of Power BI</li> <li>Tour and use the Power BI service</li> </ul> <h3>3 - Get data in Power BI</h3> <ul> <li>Get data from files</li> <li>Get data from relational data sources</li> <li>Create dynamic reports with parameters</li> <li>Get data from a NoSQL database</li> <li>Get data from online services</li> <li>Select a storage mode</li> <li>Get data from Azure Analysis Services</li> <li>Fix performance issues</li> <li>Resolve data import errors</li> </ul> <h3>4 - Clean, transform, and load data in Power BI</h3> <ul> <li>Shape the initial data</li> <li>Simplify the data structure</li> <li>Evaluate and change column data types</li> <li>Combine multiple tables into a single table</li> <li>Profile data in Power BI</li> <li>Use Advanced Editor to modify M code</li> </ul> <h3>5 - Design a semantic model in Power BI</h3> <ul> <li>Work with tables</li> <li>Create a date table</li> <li>Work with dimensions</li> <li>Define data granularity</li> <li>Work with relationships and cardinality</li> <li>Resolve modeling challenges</li> </ul> <h3>6 - Add measures to Power BI Desktop models</h3> <ul> <li>Create simple measures</li> <li>Create compound measures</li> <li>Create quick measures</li> <li>Compare calculated columns with measures</li> </ul> <h3>7 - Add calculated tables and columns to Power BI Desktop models</h3> <ul> <li>Create calculated columns</li> <li>Learn about row context</li> <li>Choose a technique to add a column</li> </ul> <h3>8 - Use DAX time intelligence functions in Power BI Desktop models</h3> <ul> <li>Use DAX time intelligence functions</li> <li>Additional time intelligence calculations</li> </ul> <h3>9 - Optimize a model for performance in Power BI</h3> <ul> <li>Review performance of measures, relationships, and visuals</li> <li>Use variables to improve performance and troubleshooting</li> <li>Reduce cardinality</li> <li>Optimize DirectQuery models with table level storage</li> <li>Create and manage aggregations</li> </ul> <h3>10 - Design Power BI reports</h3> <ul> <li>Design the analytical report layout</li> <li>Design visually appealing reports</li> <li>Report objects</li> <li>Select report visuals</li> <li>Select report visuals to suit the report layout</li> <li>Format and configure visualizations</li> <li>Work with key performance indicators</li> </ul> <h3>11 - Configure Power BI report filters</h3> <ul> <li>Apply filters to the report structure</li> <li>Apply filters with slicers</li> <li>Design reports with advanced filtering techniques</li> <li>Consumption-time filtering</li> <li>Select report filter techniques</li> <li>Case study - Configure report filters based on feedback</li> </ul> <h3>12 - Enhance Power BI report designs for the user experience</h3> <ul> <li>Design reports to show details</li> <li>Design reports to highlight values</li> <li>Design reports that behave like apps</li> <li>Work with bookmarks</li> <li>Design reports for navigation</li> <li>Work with visual headers</li> <li>Design reports with built-in assistance</li> <li>Tune report performance</li> <li>Optimize reports for mobile use</li> </ul> <h3>13 - Perform analytics in Power BI</h3> <ul> <li>Explore statistical summary</li> <li>Identify outliers with Power BI visuals</li> <li>Group and bin data for analysis</li> <li>Apply clustering techniques</li> <li>Conduct time series analysis</li> <li>Use the Analyze feature</li> <li>Create what-if parameters</li> <li>Use specialized visuals</li> </ul> <h3>14 - Create and manage workspaces in Power BI</h3> <ul> <li>Distribute a report or dashboard</li> <li>Monitor usage and performance</li> <li>Recommend a development life cycle strategy</li> <li>Troubleshoot data by viewing its lineage</li> <li>Configure data protection</li> </ul> <h3>15 - Manage semantic models in Power BI</h3> <ul> <li>Use a Power BI gateway to connect to on-premises data sources</li> <li>Configure a semantic model scheduled refresh</li> <li>Configure incremental refresh settings</li> <li>Manage and promote semantic models</li> <li>Troubleshoot service connectivity</li> <li>Boost performance with query caching (Premium)</li> </ul> <h3>16 - Create dashboards in Power BI</h3> <ul> <li>Configure data alerts</li> <li>Explore data by asking questions</li> <li>Review Quick insights</li> <li>Add a dashboard theme</li> <li>Pin a live report page to a dashboard</li> <li>Configure a real-time dashboard</li> <li>Set mobile view</li> </ul> <h3>17 - Implement row-level security</h3> <ul> <li>Configure row-level security with the static method</li> <li>Configure row-level security with the dynamic method</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans PL-300T00: Microsoft Power BI Data Analyst training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the PL-300T00: Microsoft Power BI Data Analyst course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Powerbi

Business Analytics & Intelligence

Microsoft Power BI

Microsoft BI

Data Analyst

PL-300T00 Microsoft Power BI Data Analyst

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>Students in this course are interested in Azure development or in passing the Microsoft Azure Developer Associate certification exam.</p><p></p><p></p><p>This course teaches developers how to create end-to-end solutions in Microsoft Azure. Students will learn how to implement Azure compute solutions, create Azure Functions, implement and manage web apps, develop solutions utilizing Azure storage, implement authentication and authorization, and secure their solutions by using KeyVault and Managed Identities. Students will also learn how to connect to and consume Azure services and third-party services, and include event- and message-based models in their solutions. The course also covers monitoring, troubleshooting, and optimizing Azure solutions.</p><p></p>Prerequisites<p>To be successful in this course, learners should have the following: Hands-on experience with Azure IaaS and PaaS solutions, and the Azure Portal. Experience writing in an Azure supported language at the intermediate level. (C#, JavaScript, Python, or Java) Ability to write code to connect and perform operations on, a SQL or NoSQL database product. (SQL Server, Oracle, MongoDB, Cassandra or similar) Experience writing code to handle authentication, authorization, and other security principles at the intermediate level. A general understanding of HTML, the HTTP protocol and REST API interfaces.</p></div><div id="course-pills-2"><h3>1 - Explore Azure App Service</h3> <ul> <li>Examine Azure App Service</li> <li>Examine Azure App Service plans</li> <li>Deploy to App Service</li> <li>Explore authentication and authorization in App Service</li> <li>Discover App Service networking features</li> </ul> <h3>2 - Configure web app settings</h3> <ul> <li>Configure application settings</li> <li>Configure general settings</li> <li>Configure path mappings</li> <li>Enable diagnostic logging</li> <li>Configure security certificates</li> </ul> <h3>3 - Scale apps in Azure App Service</h3> <ul> <li>Examine autoscale factors</li> <li>Identify autoscale factors</li> <li>Enable autoscale in App Service</li> <li>Explore autoscale best practices</li> </ul> <h3>4 - Explore Azure App Service deployment slots</h3> <ul> <li>Explore staging environments</li> <li>Examine slot swapping</li> <li>Swap deployment slots</li> <li>Route traffic in App Service</li> </ul> <h3>5 - Explore Azure Functions</h3> <ul> <li>Discover Azure Functions</li> <li>Compare Azure Functions hosting options</li> <li>Scale Azure Functions</li> </ul> <h3>6 - Develop Azure Functions</h3> <ul> <li>Explore Azure Functions development</li> <li>Create triggers and bindings</li> <li>Connect functions to Azure services</li> </ul> <h3>7 - Explore Azure Blob storage</h3> <ul> <li>Explore Azure Blob storage</li> <li>Discover Azure Blob storage resource types</li> <li>Explore Azure Storage security features</li> <li>Discover static website hosting in Azure Storage</li> </ul> <h3>8 - Manage the Azure Blob storage lifecycle</h3> <ul> <li>Explore the Azure Blob storage lifecycle</li> <li>Discover Blob storage lifecycle policies</li> <li>Implement Blob storage lifecycle policies</li> <li>Rehydrate blob data from the archive tier</li> </ul> <h3>9 - Work with Azure Blob storage</h3> <ul> <li>Explore Azure Blob storage client library</li> <li>Create a client object</li> <li>Manage container properties and metadata by using .NET</li> <li>Set and retrieve properties and metadata for blob resources by using REST</li> </ul> <h3>10 - Explore Azure Cosmos DB</h3> <ul> <li>Identify key benefits of Azure Cosmos DB</li> <li>Explore the resource hierarchy</li> <li>Explore consistency levels</li> <li>Choose the right consistency level</li> <li>Explore supported APIs</li> <li>Discover request units</li> </ul> <h3>11 - Work with Azure Cosmos DB</h3> <ul> <li>Explore Microsoft .NET SDK v3 for Azure Cosmos DB</li> <li>Create stored procedures</li> <li>Create triggers and user-defined functions</li> <li>Explore change feed in Azure Cosmos DB</li> </ul> <h3>12 - Manage container images in Azure Container Registry</h3> <ul> <li>Discover the Azure Container Registry</li> <li>Explore storage capabilities</li> <li>Build and manage containers with tasks</li> <li>Explore elements of a Dockerfile</li> </ul> <h3>13 - Run container images in Azure Container Instances</h3> <ul> <li>Explore Azure Container Instances</li> <li>Run containerized tasks with restart policies</li> <li>Set environment variables in container instances</li> <li>Mount an Azure file share in Azure Container Instances</li> </ul> <h3>14 - Implement Azure Container Apps</h3> <ul> <li>Explore Azure Container Apps</li> <li>Explore containers in Azure Container Apps</li> <li>Implement authentication and authorization in Azure Container Apps</li> <li>Manage revisions and secrets in Azure Container Apps</li> <li>Explore Dapr integration with Azure Container Apps</li> </ul> <h3>15 - Explore the Microsoft identity platform</h3> <ul> <li>Explore the Microsoft identity platform</li> <li>Explore service principals</li> <li>Discover permissions and consent</li> <li>Discover conditional access</li> </ul> <h3>16 - Implement authentication by using the Microsoft Authentication Library</h3> <ul> <li>Explore the Microsoft Authentication Library</li> <li>Initialize client applications</li> </ul> <h3>17 - Implement shared access signatures</h3> <ul> <li>Discover shared access signatures</li> <li>Choose when to use shared access signatures</li> <li>Explore stored access policies</li> </ul> <h3>18 - Explore Microsoft Graph</h3> <ul> <li>Discover Microsoft Graph</li> <li>Query Microsoft Graph by using REST</li> <li>Query Microsoft Graph by using SDKs</li> <li>Apply best practices to Microsoft Graph</li> </ul> <h3>19 - Implement Azure Key Vault</h3> <ul> <li>Explore Azure Key Vault</li> <li>Discover Azure Key Vault best practices</li> <li>Authenticate to Azure Key Vault</li> </ul> <h3>20 - Implement managed identities</h3> <ul> <li>Explore managed identities</li> <li>Discover the managed identities authentication flow</li> <li>Configure managed identities</li> <li>Acquire an access token</li> </ul> <h3>21 - Implement Azure App Configuration</h3> <ul> <li>Explore the Azure App Configuration service</li> <li>Create paired keys and values</li> <li>Manage application features</li> <li>Secure app configuration data</li> </ul> <h3>22 - Explore API Management</h3> <ul> <li>Discover the API Management service</li> <li>Explore API gateways</li> <li>Explore API Management policies</li> <li>Create advanced policies</li> <li>Secure APIs by using subscriptions</li> <li>Secure APIs by using certificates</li> </ul> <h3>23 - Explore Azure Event Grid</h3> <ul> <li>Explore Azure Event Grid</li> <li>Discover event schemas</li> <li>Explore event delivery durability</li> <li>Control access to events</li> <li>Receive events by using webhooks</li> <li>Filter events</li> </ul> <h3>24 - Explore Azure Event Hubs</h3> <ul> <li>Discover Azure Event Hubs</li> <li>Explore Event Hubs Capture</li> <li>Scale your processing application</li> <li>Control access to events</li> <li>Perform common operations with the Event Hubs client library</li> </ul> <h3>25 - Discover Azure message queues</h3> <ul> <li>Choose a message queue solution</li> <li>Explore Azure Service Bus</li> <li>Discover Service Bus queues, topics, and subscriptions</li> <li>Explore Service Bus message payloads and serialization</li> <li>Explore Azure Queue Storage</li> <li>Create and manage Azure Queue Storage and messages by using .NET</li> </ul> <h3>26 - Monitor app performance</h3> <ul> <li>Explore Application Insights</li> <li>Discover log-based metrics</li> <li>Instrument an app for monitoring</li> <li>Select an availability test</li> <li>Troubleshoot app performance by using Application Map</li> </ul> <h3>27 - Develop for Azure Cache for Redis</h3> <ul> <li>Explore Azure Cache for Redis</li> <li>Configure Azure Cache for Redis</li> <li>Interact with Azure Cache for Redis by using .NET</li> </ul> <h3>28 - Develop for storage on CDNs</h3> <ul> <li>Explore Azure Content Delivery Networks</li> <li>Control cache behavior on Azure Content Delivery Networks</li> <li>Interact with Azure Content Delivery Networks by using .NET</li> </ul></div>

AWS Certified Solutions Architect

AZ-204T00 Developing Solutions for Microsoft Azure

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p><p>This three-day instructor-led course is aimed at modern device management professionals looking to manage their enterprise devices using Microsoft Intune. This course will cover Enrolment, Application Management, Endpoint Security and Windows Autopilot as well as Azure Active Directory Conditional Access and Identity Protection. The delegates will learn how to enroll devices, deploy applications and manage them to maximize user productivity and device security.</p></div><div id="course-pills-2"><h3>1: Introduction to Microsoft Intune</h3> <ul> <li> Mobile Device Management</li> <li>Microsoft Intune</li> <li> Azure Active Directory</li> <li>AAD Identity Protection</li> <li> AAD Conditional Access</li></ul>  <h3>2: Microsoft Intune Device Management</h3><ul> <li>Enrolling Devices</li> <li> Device Compliance</li> <li> Device Profiles</li> <li>Device Updates</li></ul>  <h3>3: Microsoft Intune Application Management</h3><ul> <li> Application Management</li> <li> Deploying Applications</li> <li> Application Configuration</li> <li> Managing Applications</li> <li> Policy Sets and Guided Scenarios</li></ul>  <h3>4: Microsoft Intune Endpoint Security</h3><ul> <li> Security Baselines and tasks</li> <li> Antivirus</li> <li>Disk Encryption</li> <li>Firewall</li> <li>Atack Surface reduction</li> <li> Endpoint detection and response</li> <li> Account Protection</li></ul>  <h3>5: Deploying Windows with Windows Autopilot</h3><ul> <li> Windows Autopilot overview</li> <li> Preparing for Windows Autopilot deployment</li> <li>Deploying Windows 11 using Windows Autopilot</li></ul>  <h3>6: Microsoft Intune Additional and Premium Features</h3><ul> <li> Remote Help</li> <li> Tunnel for Mobile Application Management</li> <li>Endpoint Privilege Management</li> <li> Advanced Endpoint Analytics</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55399 Implementing and Managing Microsoft Intune 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 55399 Implementing and Managing Microsoft Intune 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 Certified Trainer (MCT)

Manager Training

55399 Implementing and Managing Microsoft Intune

3376 Courses delivered Online

MS Excel 2016 Introduction

By John Academy

Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced

By John Academy

Psychology & Counselling Level 4

By Studyhub UK

Domestic Engineering

By Studyhub UK

Surveying & Site Management

By Studyhub UK

Property Development, Management & Estimation

By Studyhub UK

Property law and Management

By Studyhub UK

Facilities Management and Organizational Skills

By Studyhub UK

Site Surveying and Management

By Studyhub UK

Advanced Surveying & Construction Site Management (SMSTS) Diploma - CPD Certified

By Studyhub UK