Name: C++ Complete Coding Course
Price: 12 GBP
Availability: InStock

John Academy

Online Course Marketing

Microsoft Certification

Microsoft 365

Microsoft Excel

Microsoft Office

Microsoft AZ-303

Microsoft Excel Masterclass in 2021

General Admission

<div>
	<h3><b>Description:</b></h3>
<p><span>Adobe Photoshop has become a household name these days. Editing photos has never been easier thanks to this beautiful piece of software. Well thanks to this Adobe Photoshop CS3 for Beginners course, you can now master the software as well.</span></p>
<p><span>This course is designed to help you learn Photoshop in an easy to understand manner. As the name suggests, this course will help you develop a strong foundation within this community. This course will help you get familiar with the different tools and provide plenty of examples along the way. So get this course immediately and build a strong foundation in Adobe Photoshop CS3 for Beginners.</span></p>
<h3><b>Learning Outcomes:</b></h3>
<ul>
<li>Introduction to Photoshop CS3, new features, starting the program, workspace overview and exiting the program</li>
<li>On screen options like the Menu Bar, Toolbox, Palettes, and The Status Bar</li>
<li>Opening, creating, saving files, also find out about different file formats and how to view file info</li>
<li>Customize the Toolbox and Palettes, choose a screen mode and save your workspace</li>
<li>Using help menu, help, how to and online help</li>
<li>Learn the toolbox through selection, crop and slice, retouching, painting and other types of tools</li>
<li>Save, access and delete presets, along with using the preset palette</li>
<li>Explore different palette options like navigator and info palettes and more</li>
<li>View rulers, set up guides, view the grid, and set snap options</li>
<li>Print your pictures through page setup, print command, print dialogue box, and printing single copies</li>
<li>Understand pixels, bitmap and vector images, find out pixel information with info palette and basic anatomy of images</li>
<li>Understand Image Resolution, change image size through pixels, image resampling, using auto resolution, dimension constraints, and changing the image document size</li>
<li>Understand, flip and rotate canvas; and further work with canvas size, colour, and anchor point</li>
<li>RGB and CMYK colours, colour setting and modes</li>
<li>Using colour palette, ramp, picker and swatches</li>
<li>Select complete images; use marquee, lasso, quick selection and refine edge tool; magic wand; and selection through colour range</li>
<li>Add or subtract from selection, modify selections through moving, rotating, resizing, scaling, inverting, skewing and feathering options</li>
<li>Save selected regions, cut, copy, paste, delete selections along with deselect and history palette</li>
<li>Crop and trim images, adjust exposure, and convert to black and white</li>
<li>Use basic editing tools like undo, redo, clear, duplicate and place</li>
</ul>
<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>Adobe Photoshop CS3 for Beginners </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> Adobe Photoshop CS3 for Beginners</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</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>The Photoshop CS3 Screen</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>File Management Basics</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Modifying Your Photoshop Layout</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Getting Help</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Exploring Photoshop</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction to the Photoshop Toolbox</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Tool Presets</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction to the Photoshop Palettes</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Getting Started</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Printing your Image</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Images and Color</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding Digital Images</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Image Size and Resolution</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with Your Canvas</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with Color</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with Color Tools</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Image Basics</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Making Selections</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Manipulating Selections</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Editing with Selections</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Adjusting Your Image</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Basic Editing Tools</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Mock Exam</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Mock Exam- Adobe Photoshop CS3 for Beginners</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Final Exam</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Final Exam- Adobe Photoshop CS3 for Beginners</td>
					<td> </td>
					<td><span><i></i> 00:20: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>

Adobe Photoshop

Computer Skills

Professional Skills Course (PSC)

Adobe After Effects

Adobe Photoshop CS3 for Beginners

<div>
	<h3><b>Course Overview</b></h3>
<p><span>Build a solid foundation on Excel Spreadsheet with the <strong>Basic Excel Spreadsheet</strong> course. This course is designed to introduce you to the ins and outs of excel spreadsheets. Within no time, you will be able to add a new and valuable skill set to your resume.</span></p>
<p><span>The <strong>Basic Excel Spreadsheet</strong> course will show you the essential components of the excel spreadsheet. You will understand the method of entertaining data. The course will enrich your knowledge of Autofill and Autosum. From the bite-sized modules, you will pick up skills to use the basic formulas. The course will show you how to format and manage spreadsheets. You will gain the expertise for linking the sheets together. This comprehensive course will also provide you with a detailed introduction to functions. Upon completing the course you will be equipped with the basic skills to operate a spreadsheet.</span></p>
<p><span>The <strong>Basic Excel Spreadsheet</strong> course is the online platform to train yourself on the fundamentals of spreadsheets. Enroll in the course to elevate your abilities and increase your employability in the relevant sectors.</span></p>
<h3><b>Learning Outcomes</b></h3>
<ul>
<li><span>Understand the fundamentals of Excel spreadsheets</span></li>
<li><span>Learn the process of entering data into spreadsheets</span></li>
<li><span>Enrich your knowledge of formula basics and copywriting formulas</span></li>
<li><span>Grasp the skills for formatting spreadsheets</span></li>
<li><span>Know the process of linking the sheets together</span></li>
<li><span>Become competent in managing the sheets</span></li>
</ul>
<h3><b>Who is this course for?</b></h3>
<p><span>Individuals who want to learn the basics of Excel Spreadsheet</span></p>
<h3><b>Entry Requirement</b></h3>
<ul>
<li><span>This course is available to all learners, of all academic backgrounds.</span></li>
<li><span>Learners should be aged 16 or over to undertake the qualification.</span></li>
<li><span>Good understanding of English language, numeracy and ICT are required to attend this course.</span></li>
</ul>
<h3><b>Certification</b></h3>
<ul>
<li><span>After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24.</span></li>
<li><span>PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days.</span></li>
</ul>
<h3><b>Why choose us?</b></h3>
<ul>
<li><span>Affordable, engaging &amp; high-quality e-learning study materials;</span></li>
<li><span>Tutorial videos/materials from the industry-leading experts;</span></li>
<li><span>Study in a user-friendly, advanced online learning platform;</span></li>
<li><span>Efficient exam systems for the assessment and instant result;</span></li>
<li><span>The UK &amp; internationally recognized accredited qualification;</span></li>
<li><span>Access to course content on mobile, tablet or desktop from anywhere anytime;</span></li>
<li><span>The benefit of career advancement opportunities;</span></li>
<li><span>24/7 student support via email.</span></li>
</ul>
<h3><b>Career Path</b></h3>
<p><b> </b><span>The <strong>Basic Excel Spreadsheet</strong><strong> </strong></span><span>course is a useful qualification to possess and would be beneficial for any related profession or industry such as:</span></p>
<ul>
<li>Business Professional</li>
<li><span>Data Operator</span></li>
<li><span>Data Specialist </span></li>
</ul>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Basic Excel Spreadsheet</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Tour of the Excel screen</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Entering Data</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Autofill Speedfill</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Saving the file</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Autosum</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Formula Basics</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Copying formulas - Relative Formulas</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Totals and Averages</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Formatting the Spreadsheet</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Managing the Sheets</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Copying formulas - absolute formulas</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Linking the Sheets together</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction to Functions</td>
					<td> </td>
					<td><span><i></i> 00:05: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>

Online Course Creation

Computing Skills

Trainers Course

Spreadsheet

Basic Excel Spreadsheet

<div>
	<h3><b>Course Overview</b></h3>
<p><span>Take your Excel skills to the next level with the help of the <strong>Need to Know Advanced Excel Formulas and Functions</strong> course. In this course, the expert instructor will show you how to optimize the use of excel. You will learn a handful of useful functions and formulas that will increase your proficiency in excel.</span></p>
<p><span>The <strong>Need to Know Advanced Excel Formulas and Functions</strong> course aims to increase your competence in excel. The course will teach you the fundamental math functions. You will understand the concept of relative reference and absolute reference. The course will educate you on Autosum. You will receive lectures on how to link sheets and workbooks. The course will enrich your understanding of vlookup and hlookup functions. You will become skilled in training functions. From this course, you will achieve the essential training to upgrade your MS excel skills in no time.</span></p>
<p><span>This <strong>Need to Know Advanced Excel Formulas, and Functions</strong> course will help you build excellent expertise in excel. Enroll in the course to boost your abilities and your employability in the relevant job market.</span></p>
<h3><b>Learning Outcomes</b></h3>
<ul>
<li><span>Understand how to build basic math formulas</span></li>
<li><span>Enrich your understanding of Autosum and relative references</span></li>
<li><span>Learn how to link sheets and workbooks</span></li>
<li><span>Gain the skills for tracking functions</span></li>
<li><span>Deepen your knowledge of Vlookup and Hlookup functions</span></li>
<li><span>Build your skills to work with text functions</span></li>
</ul>
<h3><b>Who is this course for?</b></h3>
<p><span>Those who want to upgrade their excel skills</span></p>
<h3><b>Entry Requirement</b></h3>
<ul>
<li><span>This course is available to all learners, of all academic backgrounds.</span></li>
<li><span>Learners should be aged 16 or over to undertake the qualification.</span></li>
<li><span>Good understanding of English language, numeracy and ICT are required to attend this course.</span></li>
</ul>
<h3><b>Certification</b></h3>
<ul>
<li><span>After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24.</span></li>
<li><span>PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days.</span></li>
</ul>
<h3><b>Why choose us?</b></h3>
<ul>
<li><span>Affordable, engaging &amp; high-quality e-learning study materials;</span></li>
<li><span>Tutorial videos/materials from the industry-leading experts;</span></li>
<li><span>Study in a user-friendly, advanced online learning platform;</span></li>
<li><span>Efficient exam systems for the assessment and instant result;</span></li>
<li><span>The UK &amp; internationally recognized accredited qualification;</span></li>
<li><span>Access to course content on mobile, tablet or desktop from anywhere anytime;</span></li>
<li><span>The benefit of career advancement opportunities;</span></li>
<li><span>24/7 student support via email.</span></li>
</ul>
<h3><b>Career Path</b></h3>
<p><b> </b><span>The </span><b>Need to Know Advanced Excel Formulas and Functions </b><span>course is a useful qualification to possess and would be beneficial for any related profession or industry such as:</span></p>
<ul>
<li>Business Professional</li>
<li><span>Administrative Officer</span></li>
</ul>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Need to Know Advanced Excel Formulas and Functions</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Building basic math formulas</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Autosum and Relative references</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Absolute references</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Named Ranges</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Linking sheets and workbooks</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>If, And, Or, and the nested If functions</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Countif, Sumif, Averageif, Sumifs, and Countifs functions</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Vlookup and Hlookup functions</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Match and Index functions</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Date and time formulas and functions</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Text functions</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Tracing formulas</td>
					<td> </td>
					<td><span><i></i> 00:08: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>

Finance Cert & Exam Prep

Higher Maths

Further Maths

Need to Know Advanced Excel Formulas and Functions

<div>
	<h3><strong>Course overview</strong></h3>
<p><span>Take a practical approach to enhance your Excel modelling skills with the <strong>Advanced Excel Models using Formulas, VBA &amp; Power Query</strong> course. In this course, you will learn how to build robust Excel models using Formulas, VBA and Power Query.</span></p>
<p><span>This <strong>Advanced Excel Models using Formulas, VBA &amp; Power Query</strong> course offers a wide range of training modules to enhance your abilities to create better models. You will discover the advanced Excel formulas to prepare reports, forecast and perform mathematical calculations.  We will introduce you to the three excel models and show the functions used to prepare these pro models. In addition, you will learn the Excel formulas for prepaid expenses and explore the steps to create dynamic dashboards based on Power Query and Pivot Table without any formula.</span></p>
<h3><b>Learning outcomes</b></h3>
<ul>
<li><span>Familiarize yourself with the advanced Excel formulas</span></li>
<li><span>Be able to manage prepaid expenses</span></li>
<li><span>Deepen your understanding of the prepaid expense models</span></li>
<li><span>Learn about the pro Excel models and formulas</span></li>
<li><span>Strengthen your knowledge of Power Query and PowerPivot</span></li>
<li><span>Learn how to create Power query and pivot table based dashboard without any formula</span></li>
</ul>
<h3><b>Who Is This Course For?</b></h3>
<p><span>This  <strong>Advanced Excel Models using Formulas, VBA &amp; Power Query</strong> course is recommended to anyone interested in learning how to prepare robust Excel models using advanced formulas, Power Query and VBA. In addition, the skills gained from this training will provide excellent opportunities for career advancement.</span></p>
<h3><b>Entry Requirement</b></h3>
<ul>
<li><span>This course is available to all learners of all academic backgrounds.</span></li>
<li><span>Learners should be aged 16 or over.</span></li>
<li><span>Good understanding of English language, numeracy and ICT skills are required to take this course.</span></li>
</ul>
<h3><b>Certification</b></h3>
<ul>
<li><span>After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the cost of £24.</span></li>
<li><span>PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days.</span></li>
</ul>
<h3><b>Why Choose Us?</b></h3>
<ul>
<li><span>Affordable, engaging &amp; high-quality e-learning study materials;</span></li>
<li><span>Tutorial videos and materials from the industry-leading experts;</span></li>
<li><span>Study in a user-friendly, advanced online learning platform;</span></li>
<li><span>Efficient exam systems for the assessment and instant result;</span></li>
<li><span>United Kingdom &amp; internationally recognized accredited qualification;</span></li>
<li><span>Access to course content on mobile, tablet and desktop from anywhere, anytime;</span></li>
<li><span>Substantial career advancement opportunities;</span></li>
<li><span>24/7 student support via email.</span></li>
</ul>
<h3><b>Career Path</b></h3>
<p><span>The <strong>Advanced Excel Models using Formulas, VBA &amp; Power Query</strong> Course provides  essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as:</span></p>
<ul>
<li><span>Data Analyst</span></li>
<li><span>System Support and Reporting Analyst</span></li>
</ul>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4"> Introduction</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Course Outline and Introduction</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Minimum Requirements for the Course</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Prepayments Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Prepaid Expenses Models: Resources Download</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Month End Date Prepaid Expenses Amortization Calculation</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Exact Prepaid Expenses Payment Date Calculation</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Accounting for Prepaid Expenses</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Prepaid Expenses Accounting Definition: Prepayments</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Prepaid Expense Example: How Accounting works for Prepayments</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Advantages and Disadvantages of Prepaid Expenses</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Excel Formulas Detailed: Introduction to three Excel Models</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction to PRO Excel Models and Formulas</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Date Function</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>EOMONTH Function</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>DATEVALUE function</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>IF Function</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>IFS Function (Office 365 Only)</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>VLOOKUP Function</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>MATCH Function</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>INDIRECT Function</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>NAMED Ranges: Name Manager</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Advanced Version of VLOOKUP Function</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Formula Based Prepaid Expenses Model</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction to Model and Control Panel Tab (Important Sheet Tab)</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Formula Based Prepaid Expenses Model - Deep Dive (Part 1)</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Formula Based Prepaid Expenses Model - Deep Dive (Part 2)</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Formula Based Prepaid Expenses Model - Deep Dive (Part 3)</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>IFS Function - Month End date Prepayment calculation</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary)</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Protecting Formulas Cells and Fields in the Model</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Calculate Prepaid Expenses Amortisation from Exact Start Date</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Exact Date Prepaid Amortisation calculation Intro</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Formulas update and Model Changes for Exact Prepaid Exps Calculation</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1)</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2)</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3)</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4)</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>IFS Function - Exact Date Prepayments Amortisation</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Data Validation Controls (Enhancing Data Input Controls with Protection)</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Bonus: Prepayment Model with Opening Balance Calculation (Part 1)</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Bonus: Prepayment Model with Opening Balance Calculation (Part 2)</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Additional Material: Resources</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Prepaid Expenses Summary with Power Query and Pivot Table</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Power Query and Pivot Table Prepayment Summary Table Intro</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What is Power Query and Some Awesome Resources for Power Query learning</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Power Query and Pivot Table Summary - Deep Dive (Part 1)</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Power Query and Pivot Table Summary - Deep Dive (Part 2)</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Power Query and Pivot Table Summary - Deep Dive (Part 3)</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Power Query and Pivot Table Summary - Deep Dive (Part 4)</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Array Formulas to Add Formula Protection</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version)</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Advanced VBA Prepaid Expenses Amortisation Model</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Changing Macros Security in Excel</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Bonus : New Version - Excel VBA Model for Prepayment Expenditure</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td colspan="4">BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Dynamic Dashboard Overview</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Importing Profit and Loss Statements Source Files and creating YTD P&amp;L Sheets</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Dynamic Data Validation</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Named Ranges for Dynamic Table Arrays</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Dynamic Date Column Headings for each Divisional PL Table</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Dynamic Month and YTD Dashboard tables headings (PRO TIP)</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Dynamic VLOOKUP Formula - Preparing First section of the Dashboard</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Rolling Dashboard with Dynamic VLOOKUP Function</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP)</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function)</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1)</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2)</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Power Query &amp; Pivot Tables based Dashboard without any Formulas, Fully Dynamic</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding the data files before building dashboard</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Consolidating Reports with Power Query (Get &amp; Transform) , How to install PQ</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Dynamic File Path Trick in Power Query with Parameters (Amazing trick)</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Conditional Cumulative totals with SUMIFS Function</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code)</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast)</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Dashboard Creation - Line Charts</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Update Dashboard with Additional Divisional Data with Few Click (Magical)</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Thankyou</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Thank you</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Ultimate Prepaid Expenditure Model (Super Bonus)</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Resources</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query</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>

Financial Modelling & Analysis

Financial Modelling

Excel Analytics

Practical Accounting

Advanced Excel Models using Formulas, VBA & Power Query

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>This comprehensive course on <strong>Functional Skills Maths - Level 1 (Updated 2022</strong>)<strong> </strong></span>will deepen your understanding on this topic.</p><p><span><span>After successful completion of this course you can acquire the required skills in this sector. This <strong>Functional Skills Maths - Level 1 (Updated 2022)</strong></span> comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.</span></p><p><span><span>So enrol in this course today to fast track your career ladder.</span></span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
								</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>There is no experience or previous qualifications required for enrolment on this <strong>Functional Skills Maths - Level 1 (Updated 2022</strong>)</span>. It is available to all students, of all academic backgrounds.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Our <strong>Functional Skills Maths - Level 1 (Updated 2022)</strong></span> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.</p><p><span><span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span></span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-</span></p><ul><li>Open doors of opportunities</li><li>Increase your adaptability</li><li>Keep you relevant</li><li>Boost confidence</li></ul><p>And much more!</p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>24 sections • 114 lectures • 11:37:00 total length</p></div><div><div><div><div><div><div><div><p>•Lecture 1: Introduction Video: 00:02:00</p></div><div><div><p>•Lecture 2: Quick Guide: 00:01:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 1: Read &amp; Write Large Numbers Part 1: 00:08:00</p></div><div><div><p>•Lecture 2: Read &amp; Write Large Numbers Part 2: 00:13:00</p></div><div><div><p>•Lecture 3: Compare and Order Large Numbers: 00:12:00</p></div><div><div><p>•Downloadable Resources: 00:00:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 1: Why do you Round off a Number?: 00:03:00</p></div><div><div><p>•Lecture 2: Rounding off techniques: 00:07:00</p></div><div><div><p>•Lecture 3: Practice Problems Part 1: 00:09:00</p></div><div><div><p>•Lecture 4: Practice Problems Part 2: 00:08:00</p></div><div><div><p>•Lecture 5: Rounding to Significant Figures: 00:15:00</p></div><div><div><p>•Downloadable Resources: 00:00:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 1: Number System: 00:07:00</p></div><div><div><p>•Lecture 2: Integers and Ordering of Integers: 00:08:00</p></div><div><div><p>•Lecture 3: Addition and Subtractions of Integers: 00:10:00</p></div><div><div><p>•Lecture 4: Operations on Integers: 00:06:00</p></div><div><div><p>•Lecture 5: Multiplication and Division of Integers: 00:07:00</p></div><div><div><p>•Downloadable Resources: 00:00:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 1: Factors and Multiples Basics: 00:07:00</p></div><div><div><p>•Lecture 2: Divisibility tests for 2,3,4,5,6: 00:07:00</p></div><div><div><p>•Lecture 3: Divisibility tests for 7,8,9,10,11: 00:11:00</p></div><div><div><p>•Lecture 4: Prime Factorisation: 00:13:00</p></div><div><div><p>•Lecture 5: Highest Common Factor HCF: 00:13:00</p></div><div><div><p>•Lecture 6: HCF - Division Method: 00:10:00</p></div><div><div><p>•Lecture 7: Least Common Multiple LCM: 00:14:00</p></div><div><div><p>•Downloadable Resources: 00:00:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 1: Classification of Fractions: 00:09:00</p></div><div><div><p>•Lecture 2: Convert mixed to improper and improper to mixed fractions: 00:05:00</p></div><div><div><p>•Lecture 3: Equivalent Fractions: 00:07:00</p></div><div><div><p>•Lecture 4: Comparing Fractions after converting to like fractions: 00:09:00</p></div><div><div><p>•Lecture 5: Reducing a fraction to the lowest term: 00:05:00</p></div><div><div><p>•Lecture 6: Addition &amp; Subtraction of fractions: 00:09:00</p></div><div><div><p>•Lecture 7: Multiplication and Division of Fractions: 00:11:00</p></div><div><div><p>•Lecture 8: Find Fractions of whole number quantities or measurements: 00:08:00</p></div><div><div><p>•Downloadable Resources: 00:00:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 1: Expanded form of Decimals: 00:08:00</p></div><div><div><p>•Lecture 2: Expanded form to Decimal form: 00:03:00</p></div><div><div><p>•Lecture 3: Writing fractions to Decimals: 00:04:00</p></div><div><div><p>•Lecture 4: Converting Decimals to a fraction: 00:05:00</p></div><div><div><p>•Lecture 5: Like &amp; Unlike Decimals: 00:04:00</p></div><div><div><p>•Lecture 6: Comparing &amp; Ordering Decimal Numbers: 00:09:00</p></div><div><div><p>•Lecture 7: Addition and Subtraction of Decimals: 00:06:00</p></div><div><div><p>•Lecture 8: Multiplication of Decimals: 00:07:00</p></div><div><div><p>•Lecture 9: Division of Decimals: 00:06:00</p></div><div><div><p>•Downloadable Resources: 00:00:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 1: Multiply whole numbers and decimals by 10,100 &amp; 1000: 00:09:00</p></div><div><div><p>•Lecture 2: Divide whole numbers and decimals by 10,100 &amp; 1000: 00:05:00</p></div><div><div><p>•Downloadable Resources: 00:00:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 1: Squaring of one-digit and two-digit numbers: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 1: Simple Formula in words for one step or two steps operations: 00:09:00</p></div><div><div><p>•Downloadable Resources: 00:00:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 1: Intro to the metric system: 00:09:00</p></div><div><div><p>•Lecture 2: Length, Mass &amp; Capacity: 00:10:00</p></div><div><div><p>•Lecture 3: Length, Mass &amp; Capacity Addition &amp; Subtraction: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 1: Converting 12-hour time to a 24-hour time: 00:04:00</p></div><div><div><p>•Lecture 2: Converting 24-hour time to a 12-hour time: 00:05:00</p></div><div><div><p>•Lecture 3: Conversion to different units of Time: 00:09:00</p></div><div><div><p>•Lecture 4: Addition with Time: 00:08:00</p></div><div><div><p>•Lecture 5: Subtraction with Time: 00:08:00</p></div><div><div><p>•Lecture 6: Multiplication with Time: 00:07:00</p></div><div><div><p>•Lecture 7: Division with Time: 00:06:00</p></div><div><div><p>•Lecture 8: Finding Time interval between given timings Part 1: 00:05:00</p></div><div><div><p>•Lecture 9: Finding Time interval between given timings Part 2: 00:10:00</p></div><div><div><p>•Lecture 10: Past Paper problem Q1: 00:02:00</p></div><div><div><p>•Lecture 11: Past Paper problem Q2: 00:02:00</p></div><div><div><p>•Lecture 12: Past Paper problem Q3: 00:05:00</p></div><div><div><p>•Lecture 13: Past Paper problem Q4: 00:03:00</p></div><div><div><p>•Lecture 14: Past Paper problem Q5: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 1: Order of Operations - PEMDAS: 00:10:00</p></div><div><div><p>•Lecture 2: Practice Problems on - PEMDAS: 00:05:00</p></div><div><div><p>•Downloadable Resources: 00:00:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 1: Estimation and approximation: 00:07:00</p></div><div><div><p>•Lecture 2: Estimation using Fractions and Decimals: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 1: Simple Ratio and Direct Proportion Part 1: 00:09:00</p></div><div><div><p>•Lecture 2: Simple Ratio and Direct Proportion Part 2: 00:04:00</p></div><div><div><p>•Lecture 3: Simple Ratio and Direct Proportion Part 3: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 1: Scale Drawing: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 1: What is the meaning of Percentage?: 00:02:00</p></div><div><div><p>•Lecture 2: Percentage to Fraction: 00:07:00</p></div><div><div><p>•Lecture 3: Percentage of a quantity and conversation to Decimal: 00:05:00</p></div><div><div><p>•Lecture 4: Expressing one Quantity as a Percentage of another Quantity: 00:07:00</p></div><div><div><p>•Lecture 5: Calculate Percentages of amounts, increase, decrease by 5,10,15%: 00:11:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 1: Calculate simple interest in multiples of 5% on amounts of money: 00:11:00</p></div><div><div><p>•Lecture 2: Calculate discounts in multiples of 5% on amounts of money: 00:08:00</p></div><div><div><p>•Downloadable Resources: 00:00:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 1: Problems based on Money: 00:06:00</p></div><div><div><p>•Downloadable Resources: 00:00:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 1: What is statistics?: 00:04:00</p></div><div><div><p>•Lecture 2: Representation of discrete data in Tables: 00:11:00</p></div><div><div><p>•Lecture 3: One-way Tables: 00:03:00</p></div><div><div><p>•Lecture 4: Two-way Tables: 00:04:00</p></div><div><div><p>•Lecture 5: Grouping of a discrete data Part 1: 00:05:00</p></div><div><div><p>•Lecture 6: Grouping of a discrete data Part 2: 00:04:00</p></div><div><div><p>•Lecture 7: Represent discrete data in Bar Charts (Graphs)Part 1: 00:08:00</p></div><div><div><p>•Lecture 8: Represent discrete data in Bar Charts (Graphs)Part 2: 00:07:00</p></div><div><div><p>•Lecture 9: Pie Charts (Circle graphs) Part 1: 00:08:00</p></div><div><div><p>•Lecture 10: Pie Charts (Circle graphs) Part 2: 00:05:00</p></div><div><div><p>•Lecture 11: Pie Charts (Circle graphs) Part 3: 00:08:00</p></div><div><div><p>•Lecture 12: Mean &amp; Range: 00:09:00</p></div><div><div><p>•Downloadable Resources: 00:00:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 1: Probability on a scale from 0 to 1: 00:12:00</p></div><div><div><p>•Lecture 2: Probabilities of simple events Part 1: 00:03:00</p></div><div><div><p>•Lecture 3: Probabilities of simple events Part 2: 00:06:00</p></div><div><div><p>•Downloadable Resources: 00:00:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 1: Lines &amp; Angles: 00:08:00</p></div><div><div><p>•Lecture 2: Introduction to Triangles: 00:05:00</p></div><div><div><p>•Lecture 3: Polygons: 00:05:00</p></div><div><div><p>•Lecture 4: More 2D Figures: 00:07:00</p></div><div><div><p>•Lecture 5: Line symmetry: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 1: Area &amp; Perimeter Part 1: 00:08:00</p></div><div><div><p>•Lecture 2: Area &amp; Perimeter Part 2: 00:06:00</p></div><div><div><p>•Lecture 3: Area &amp; Perimeter Part 3: 00:08:00</p></div><div><div><p>•Downloadable Resources: 00:00:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Lecture 1: Calculation of the volumes &amp; Surface Area of cubes and cuboids: 00:08:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Apex Learning

FA Level 1

Numeracy

Functional Skills Maths - Level 1 (Updated 2022)

<h3><b>Overview</b></h3>
<span>Master Microsoft Visio 2016 and </span><span>elevate</span><span> your workflow by attending the <strong>Microsoft Visio 2016 - Complete Bundle </strong>course.</span>

<span>In the comprehensive <strong>Microsoft Visio 2016 - Complete Bundle </strong>course, you'll learn about creating, shaping and connecting text in Microsoft Visio 2016. You'll </span><span>learn</span><span> how to add images to a diagram, precise object alignment, and other essentials, </span><span>for effective </span><span>data management. You'll also learn how to integrate hyperlinks into your </span><span>work</span><span> while collaborating with co-authors</span><span>,</span><span> and save your work in different formats to share your work in several platforms. </span>

<span>Save time </span><span>and grow your diagramming skills </span><span>with Microsoft Visio 2016, by enrolling today! </span>
<h3><b>How will I get my certificate?</b></h3>
You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.
<h3><b>Who is this course for?</b></h3>
<span>There is no experience or previous qualifications required for enrolment on this <strong>Microsoft Visio 2016 - Complete Bundle</strong></span><span>. It is available to all students, of all academic backgrounds.</span>
<h3><b>Requirements</b></h3>
<span>Our <strong>Microsoft Visio 2016 - Complete Bundle </strong></span><span>is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.</span>

<span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span>
<h3><b>Career path</b></h3>
<span>Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business &amp; Management , Admin, Accountancy &amp; Finance, Secretarial &amp; PA, Teaching &amp; Mentoring etc.</span> <h3>Course Curriculum</h3><div><p>12 sections • 40 lectures • 16:10:00 total length</p></div><div><div><div><div><div></div></div></div></div><div><div><div><div><div><div><p>•Navigate the Visio Environment: 00:15:00</p></div><div><div><p>•Create a Basic Drawing: 00:30:00</p></div><div><div><p>•Use the Help System: 00:15:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Use Drawing Components: 00:30:00</p></div><div><div><p>•Modify a Drawing: 00:15:00</p></div><div><div><p>•Work with Callouts and Groups: 00:15:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create a Basic Organization Chart: 00:30:00</p></div><div><div><p>•Do More with Organization Charts: 00:15:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Make a Basic Floor Plan: 00:30:00</p></div><div><div><p>•Model a Room Layout: 00:15:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create a Cross-Functional Flowchart: 00:30:00</p></div><div><div><p>•Modify a Cross-functional Flowchart: 00:15:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create Network Diagrams: 00:15:00</p></div><div><div><p>•Use Shape Data: 00:15:00</p></div><div><div><p>•Use Layers: 00:30:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Work with Shape and Connector Styles: 00:15:00</p></div><div><div><p>•Work with Themes and Variants: 00:15:00</p></div><div><div><p>•Work with Containers: 00:15:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Work with Shape Styles: 00:30:00</p></div><div><div><p>•Use 3D Shapes: 00:30:00</p></div><div><div><p>•Apply Backgrounds, Borders, and Titles: 00:30:00</p></div><div><div><p>•Create Custom Stencils: 00:30:00</p></div><div><div><p>•Create Simple Custom Shapes: 00:30:00</p></div><div><div><p>•Create Master Shapes: 00:30:00</p></div><div><div><p>•Create Custom Templates: 00:30:00</p></div><div><div><p>•Generate a Pivot Diagram from an Excel Spreadsheet: 00:30:00</p></div><div><div><p>•Create a Chart from a Project File: 00:30:00</p></div><div><div><p>•Create a Timeline from a Project File: 00:30:00</p></div><div><div><p>•Connect to an Access Database: 00:30:00</p></div><div><div><p>•Create Macros: 00:30:00</p></div><div><div><p>•Modify ShapeSheets: 00:30:00</p></div><div><div><p>•Use Advanced Shape Tools: 00:30:00</p></div><div><div><p>•Save and Share Drawings with One Drive: 00:30:00</p></div><div><div><p>•Review Drawings: 00:30:00</p></div><div><div><p>•Insert Drawings into Other Office Files: 00:30:00</p></div><div><div><p>•Export Drawings: 00:30:00</p></div><div><div><p>•Print Drawings: 00:30:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Activities - Microsoft Visio 2016 - Complete Bundle: 00:00:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Mock Exam- Microsoft Visio 2016 - Complete Bundle: 00:20:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Final Exam- Microsoft Visio 2016 - Complete Bundle: 00:20:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Microsoft Virtual Academy (MVA)

Visio

Microsoft Visio

Microsoft Visio 2016 - Complete Bundle

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>This comprehensive course on </span><b><span>C++ Development: The Complete Coding Guide</span></b> will deepen your understanding on this topic.</p><p><span><span>After successful completion of this course you can acquire the required skills in this sector. This </span><b>C++ Development: The Complete Coding Guide</b> comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.</span></p><p><span><span>So enrol in this course today to fast track your career ladder.</span></span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
								</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>There is no experience or previous qualifications required for enrolment on this </span><b><span>C++ Development: The Complete Coding Guide</span></b>. It is available to all students, of all academic backgrounds.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Our </span><b><span>C++ Development: The Complete Coding Guide</span></b> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.</p><p><span><span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span></span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-</p><ul><li>Open doors of opportunities</li><li>Increase your adaptability</li><li>Keep you relevant</li><li>Boost confidence</li></ul><p>And much more!</p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>14 sections • 79 lectures • 05:35:00 total length</p></div><div><div><div><div><div><div><div><p>•Introduction: 00:04:00</p></div><div><div><p>•What Is C++?: 00:03:00</p></div><div><div><p>•Setting up A Project: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Console Out: 00:04:00</p></div><div><div><p>•Data Types: 00:03:00</p></div><div><div><p>•Variables: 00:04:00</p></div><div><div><p>•Console In: 00:03:00</p></div><div><div><p>•Strings: 00:04:00</p></div><div><div><p>•Constants: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Assignment Operator: 00:03:00</p></div><div><div><p>•Arithmetic Operators: 00:04:00</p></div><div><div><p>•Compound Assignment Operator: 00:03:00</p></div><div><div><p>•Increment &amp; Decrement Operators: 00:04:00</p></div><div><div><p>•Relation &amp; Comparison Operators: 00:06:00</p></div><div><div><p>•Logical Operators: 00:07:00</p></div><div><div><p>•Conditional Ternary Operator: 00:04:00</p></div><div><div><p>•Comma Operator: 00:03:00</p></div><div><div><p>•Type Casting Operator: 00:02:00</p></div><div><div><p>•Bitwise Operators: 00:12:00</p></div><div><div><p>•Size of Operator: 00:03:00</p></div><div><div><p>•Operator Precedence: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•String Streams: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Conditional Statements: 00:07:00</p></div><div><div><p>•For Loop: 00:04:00</p></div><div><div><p>•While Loop: 00:03:00</p></div><div><div><p>•Do While Loop: 00:04:00</p></div><div><div><p>•Range-Based For Loop: 00:03:00</p></div><div><div><p>•GoTo Statement: 00:04:00</p></div><div><div><p>•Switch Statement: 00:05:00</p></div><div><div><p>•Switch Statement: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Functions: 00:03:00</p></div><div><div><p>•Function Return Statement: 00:04:00</p></div><div><div><p>•Function Arguments Passed By Value: 00:05:00</p></div><div><div><p>•Function Arguments Passed By Reference: 00:05:00</p></div><div><div><p>•Function Parameter Default Values: 00:03:00</p></div><div><div><p>•Overloaded Functions: 00:04:00</p></div><div><div><p>•Function Templates: 00:04:00</p></div><div><div><p>•Namespaces: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Arrays: 00:03:00</p></div><div><div><p>•Multidimensional Arrays: 00:03:00</p></div><div><div><p>•References: 00:02:00</p></div><div><div><p>•Pointers: 00:04:00</p></div><div><div><p>•Delete Operator: 00:02:00</p></div><div><div><p>•Struct: 00:04:00</p></div><div><div><p>•Type Aliasing: 00:03:00</p></div><div><div><p>•Unions: 00:04:00</p></div><div><div><p>•Enumerators: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction to Classes: 00:05:00</p></div><div><div><p>•Class Access: 00:04:00</p></div><div><div><p>•Class Constructor: 00:05:00</p></div><div><div><p>•Class Pointers: 00:04:00</p></div><div><div><p>•Overloading Operators: 00:06:00</p></div><div><div><p>•This Keyword: 00:04:00</p></div><div><div><p>•Constant Objects: 00:03:00</p></div><div><div><p>•Getters and Setters: 00:05:00</p></div><div><div><p>•Static Variables: 00:04:00</p></div><div><div><p>•Static Functions: 00:06:00</p></div><div><div><p>•Template Classes: 00:05:00</p></div><div><div><p>•Class Destructor: 00:04:00</p></div><div><div><p>•Class Copy Constructor: 00:03:00</p></div><div><div><p>•Friend Function: 00:06:00</p></div><div><div><p>•Friend Class: 00:06:00</p></div><div><div><p>•Class Inheritance: 00:07:00</p></div><div><div><p>•Multiple Class Inheritance: 00:05:00</p></div><div><div><p>•Virtual Methods: 00:04:00</p></div><div><div><p>•Abstract Base Class: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Error Handling: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Preprocessor Macro Definitions: 00:04:00</p></div><div><div><p>•Preprocessor Conditional Directives: 00:05:00</p></div><div><div><p>•Preprocessor Line Directive: 00:04:00</p></div><div><div><p>•Preprocessor Source File Inclusion: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Opening A File: 00:06:00</p></div><div><div><p>•Writing to a File: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Commenting: 00:04:00</p></div><div><div><p>•Class Header and Implementation: 00:09:00</p></div><div><div><p>•Lists: 00:04:00</p></div><div><div><p>•Vectors: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Resource: 00:00:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Assignment - C++ Development: The Complete Coding Guide: 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Programming Fundamentals

Computer Programming

Continuous Professional Development (CPD)

C++ Development: The Complete Coding Guide

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>This comprehensive course on </span><b><span>Programming AutoCAD to Excel using VB.NET</span></b> will deepen your understanding on this topic.</p><p><span><span>After successful completion of this course you can acquire the required skills in this sector. This </span><b>Programming AutoCAD to Excel using VB.NET</b> comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. </span><span><span>So enrol in this course today to fast track your career ladder.</span></span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
								</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>There is no experience or previous qualifications required for enrolment on this </span><b><span>Programming AutoCAD to Excel using VB.NET</span></b>. It is available to all students, of all academic backgrounds.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Our </span><b><span>Programming AutoCAD to Excel using VB.NET</span></b> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. <span><span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span></span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-</p><ul><li>Open doors of opportunities</li><li>Increase your adaptability</li><li>Keep you relevant</li><li>Boost confidence</li></ul><p>And much more!</p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>7 sections • 102 lectures • 09:34:00 total length</p></div><div><div><div><div><div><div><div><p>•Introduction: 00:04:00</p></div><div><div><p>•Who is this course for?: 00:02:00</p></div><div><div><p>•What will you learn from this course?: 00:05:00</p></div><div><div><p>•Tools needed: 00:01:00</p></div><div><div><p>•Course Prerequisites: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Section Overview - Export AutoCAD Objects to Excel: 00:02:00</p></div><div><div><p>•Exporting Lines to Excel - Overview: 00:02:00</p></div><div><div><p>•Creating the VB.NET-Excel Project: 00:06:00</p></div><div><div><p>•Design of User Interface to Export Lines: 00:10:00</p></div><div><div><p>•Creating the Common Utility Class: 00:19:00</p></div><div><div><p>•Creating the ExportLines Method: 00:12:00</p></div><div><div><p>•Running and Testing ExportLines Method: 00:06:00</p></div><div><div><p>•Exporting MTexts to Excel - Overview: 00:02:00</p></div><div><div><p>•Creating the ExportMTexts Method: 00:11:00</p></div><div><div><p>•Export Polylines to Excel - Overview: 00:01:00</p></div><div><div><p>•Creating the ExportPolylines Method: 00:12:00</p></div><div><div><p>•Running and Testing ExportPoylines Method: 00:12:00</p></div><div><div><p>•Export Blocks (Without Attributes) to Excel - Overview: 00:01:00</p></div><div><div><p>•Creating the ExportBlocks Method: 00:12:00</p></div><div><div><p>•Creating Export Blocks UI and Running the Code: 00:06:00</p></div><div><div><p>•Exporting Blocks (With Attributes) to Excel - Overview: 00:02:00</p></div><div><div><p>•Creating the User Interface for exporting Blocks to Excel: 00:05:00</p></div><div><div><p>•Creation of BlocksForm UI: 00:04:00</p></div><div><div><p>•Coding the BlocksForm Load Event: 00:08:00</p></div><div><div><p>•Testing the BlocksForm UI: 00:03:00</p></div><div><div><p>•Coding the BlocksForm to populate the Listboxes: 00:15:00</p></div><div><div><p>•Coding the BlocksForm Export Button: 00:04:00</p></div><div><div><p>•Coding the ExportBlocksWithAttributes Method: 00:21:00</p></div><div><div><p>•Running and Testing ExportBlocksWithAttributes Method: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Section Overview - Import Excel File into AutoCAD: 00:01:00</p></div><div><div><p>•Importing Lines from Excel File into AutoCAD - Overview: 00:01:00</p></div><div><div><p>•Creating ImportExcelUtil Class: 00:02:00</p></div><div><div><p>•Creating the ImportLines Method: 00:19:00</p></div><div><div><p>•Creating the UI for the ImportLines Method: 00:02:00</p></div><div><div><p>•Coding the ImportLines UI code behind.: 00:07:00</p></div><div><div><p>•Running and Testing ImportLines Method: 00:08:00</p></div><div><div><p>•Importing MTexts into AutoCAD - Overview: 00:01:00</p></div><div><div><p>•Creating the ImportMTexts Method: 00:11:00</p></div><div><div><p>•Creating ImportMTexts User Interface: 00:02:00</p></div><div><div><p>•Running and Testing ImportMTexts Method: 00:02:00</p></div><div><div><p>•Importing Polylines from Excel File into AutoCAD - Overview: 00:01:00</p></div><div><div><p>•Creating the ImportPolylines Method: 00:14:00</p></div><div><div><p>•Creating ImportPolylines User Interface: 00:02:00</p></div><div><div><p>•Running and Testing ImportPolylines Method: 00:03:00</p></div><div><div><p>•Running and Testing ImportPolylines (from a File) Method: 00:02:00</p></div><div><div><p>•Importing Blocks (without Attributes) from Excel File into AutoCAD - Overview: 00:01:00</p></div><div><div><p>•Creating the ImportBlocks Method: 00:09:00</p></div><div><div><p>•Creating the ImportBlocks User Interface: 00:02:00</p></div><div><div><p>•Running and Testing ImportBlocks Method: 00:03:00</p></div><div><div><p>•Importing Blocks (with Attirubtes) from Excel File into AutoCAD - Overview: 00:02:00</p></div><div><div><p>•Creating the ImportBlocksWithAttributes Method: 00:25:00</p></div><div><div><p>•Creating the UI for ImportBlocksWithAttributes Method: 00:04:00</p></div><div><div><p>•Running and Testing ImportBlocksWithAttributes Method: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Exporting Lines to a File - Overview: 00:02:00</p></div><div><div><p>•Creating the ExportToFile Utility Class: 00:04:00</p></div><div><div><p>•Creating ExportLinesToFile Method: 00:14:00</p></div><div><div><p>•Creating the UI for ExportLinesToFile Method: 00:08:00</p></div><div><div><p>•Running and Testing ExportLinesToFile Method: 00:02:00</p></div><div><div><p>•Exporting MTexts to File - Overview: 00:01:00</p></div><div><div><p>•Creating the MTextToFile Method: 00:06:00</p></div><div><div><p>•Creating the UI for the ExportMTextToFile Method: 00:01:00</p></div><div><div><p>•Running and Testing ExportMTextToFile Method.: 00:08:00</p></div><div><div><p>•Exporting Polylines to File - Overview: 00:02:00</p></div><div><div><p>•Creating ExportPolylinesToFile Method: 00:11:00</p></div><div><div><p>•Exporting Polylines to File - User Interface: 00:01:00</p></div><div><div><p>•Running and Testing ExportPolylinesToFile Method: 00:02:00</p></div><div><div><p>•Exporting Blocks (without Attributes) to File - Overview: 00:02:00</p></div><div><div><p>•Creating the ExportBlocksToFile Method: 00:10:00</p></div><div><div><p>•Creating ExportBlocksToFile User Interface: 00:02:00</p></div><div><div><p>•Running and Testing ExportBlocksToFile Method: 00:02:00</p></div><div><div><p>•Exporting Blocks (With Attributes) to a File - Overview: 00:02:00</p></div><div><div><p>•Creating the EXportBlocksWithAttributesToFile Method: 00:19:00</p></div><div><div><p>•Creating the UI for ExportBlocksWithAttributesToFile Method: 00:06:00</p></div><div><div><p>•Coding the BlocksForm for ExportBlocksWithAttributeToFile Method: 00:04:00</p></div><div><div><p>•Running and Testing ExportBlocksWithAttributesToFile Method: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Importing Text File into AutoCAD - Overview: 00:01:00</p></div><div><div><p>•Importing Lines from a Text File into AutoCAD - Overview: 00:02:00</p></div><div><div><p>•Creating the ImportFileUtil Class: 00:01:00</p></div><div><div><p>•Creating the ImportLinesMethod: 00:17:00</p></div><div><div><p>•Creation of ImportLines User Interface: 00:03:00</p></div><div><div><p>•Coding the ImportLines UI button: 00:05:00</p></div><div><div><p>•Running and Testing the ImportLines Method: 00:04:00</p></div><div><div><p>•Importing MTexts from Text File into AutoCAD - Overview: 00:02:00</p></div><div><div><p>•Creating the ImportMTexts Method: 00:09:00</p></div><div><div><p>•Creating the TextStyle Manipulation Code: 00:02:00</p></div><div><div><p>•Creating the UI for the ImportMTexts Method: 00:01:00</p></div><div><div><p>•Running and Testing the ImportMTexts Method: 00:04:00</p></div><div><div><p>•Importing Polylines from a Text File into AutoCAD - Overview: 00:02:00</p></div><div><div><p>•Creating the ImportPolylines Method: 00:18:00</p></div><div><div><p>•Creating the ImportPolylines UI: 00:02:00</p></div><div><div><p>•Running and Testing ImportPolylines (from a File) Method: 00:02:00</p></div><div><div><p>•Importing BLocks (without Attributes) from a Text File into AutoCAD - Overview: 00:02:00</p></div><div><div><p>•Creating the ImportBlocks (without Attributes) Method: 00:15:00</p></div><div><div><p>•Creating the ImportBlocks UI: 00:05:00</p></div><div><div><p>•Running and Testing ImportBlocks (without Attributes) Method: 00:04:00</p></div><div><div><p>•Importing Blocks (with Attributes) from a Text File into AutoCAD - Overview: 00:02:00</p></div><div><div><p>•Creating the ImportBlocksWithAttributes from a File Method: 00:24:00</p></div><div><div><p>•Creating the ImportBlocksWithAttributes (from a File) UI (Part 1): 00:06:00</p></div><div><div><p>•Creating the ImportBlocksWithAttributes (from a File) UI (Part 2): 00:04:00</p></div><div><div><p>•Running and Testing ImportBlocksWithAttributes (from a File) Method: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Conclusion: 00:01:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Assignment - Programming AutoCAD to Excel using VB.NET: 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

AutoCAD

Programming AutoCAD to Excel using VB.NET

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>This comprehensive course on </span><b><span>C++ Complete Coding Course</span></b> will deepen your understanding on this topic.</p><p><span><span>After successful completion of this course you can acquire the required skills in this sector. This </span><b>C++ Complete Coding Course</b> comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.</span></p><p><span><span>So enrol in this course today to fast track your career ladder.</span></span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
								</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>There is no experience or previous qualifications required for enrolment on this </span><b><span>C++ Complete Coding Course</span></b>. It is available to all students, of all academic backgrounds.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Our </span><b><span>C++ Complete Coding Course</span></b> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.</p><p><span><span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span></span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-</p><ul><li>Open doors of opportunities</li><li>Increase your adaptability</li><li>Keep you relevant</li><li>Boost confidence</li></ul><p>And much more!</p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>14 sections • 79 lectures • 05:33:00 total length</p></div><div><div><div><div><div><div><div><p>•Introduction: 00:04:00</p></div><div><div><p>•What Is C++?: 00:03:00</p></div><div><div><p>•Setting up A Project: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Console Out: 00:04:00</p></div><div><div><p>•Data Types: 00:03:00</p></div><div><div><p>•Variables: 00:04:00</p></div><div><div><p>•Console In: 00:03:00</p></div><div><div><p>•Strings: 00:04:00</p></div><div><div><p>•Constants: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Assignment Operator: 00:03:00</p></div><div><div><p>•Arithmetic Operators: 00:04:00</p></div><div><div><p>•Compound Assignment Operator: 00:03:00</p></div><div><div><p>•Increment &amp; Decrement Operators: 00:04:00</p></div><div><div><p>•Relation &amp; Comparison Operators: 00:06:00</p></div><div><div><p>•Logical Operators: 00:07:00</p></div><div><div><p>•Conditional Ternary Operator: 00:04:00</p></div><div><div><p>•Comma Operator: 00:03:00</p></div><div><div><p>•Type Casting Operator: 00:02:00</p></div><div><div><p>•Bitwise Operators: 00:12:00</p></div><div><div><p>•Size of Operator: 00:03:00</p></div><div><div><p>•Operator Precedence: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•String Streams: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Conditional Statements: 00:07:00</p></div><div><div><p>•For Loop: 00:04:00</p></div><div><div><p>•While Loop: 00:03:00</p></div><div><div><p>•Do While Loop: 00:04:00</p></div><div><div><p>•Range-Based For Loop: 00:03:00</p></div><div><div><p>•GoTo Statement: 00:04:00</p></div><div><div><p>•Switch Statement: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Functions: 00:03:00</p></div><div><div><p>•Function Return Statement: 00:04:00</p></div><div><div><p>•Function Arguments Passed By Value: 00:05:00</p></div><div><div><p>•Function Arguments Passed By Reference: 00:05:00</p></div><div><div><p>•Function Parameter Default Values: 00:03:00</p></div><div><div><p>•Overloaded Functions: 00:04:00</p></div><div><div><p>•Function Templates: 00:04:00</p></div><div><div><p>•Namespaces: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Arrays: 00:03:00</p></div><div><div><p>•Multidimensional Arrays: 00:03:00</p></div><div><div><p>•References: 00:02:00</p></div><div><div><p>•Pointers: 00:04:00</p></div><div><div><p>•Delete Operator: 00:02:00</p></div><div><div><p>•Struct: 00:04:00</p></div><div><div><p>•Type Aliasing: 00:03:00</p></div><div><div><p>•Unions: 00:04:00</p></div><div><div><p>•Enumerators: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction to Classes: 00:05:00</p></div><div><div><p>•Class Access: 00:04:00</p></div><div><div><p>•Class Constructor: 00:05:00</p></div><div><div><p>•Class Pointers: 00:04:00</p></div><div><div><p>•Overloading Operators: 00:06:00</p></div><div><div><p>•This Keyword: 00:04:00</p></div><div><div><p>•Constant Objects: 00:03:00</p></div><div><div><p>•Getters and Setters: 00:05:00</p></div><div><div><p>•Static Variables: 00:04:00</p></div><div><div><p>•Static Functions: 00:06:00</p></div><div><div><p>•Template Classes: 00:05:00</p></div><div><div><p>•Class Destructor: 00:04:00</p></div><div><div><p>•Class Copy Constructor: 00:03:00</p></div><div><div><p>•Friend Function: 00:06:00</p></div><div><div><p>•Friend Class: 00:06:00</p></div><div><div><p>•Class Inheritance: 00:07:00</p></div><div><div><p>•Multiple Class Inheritance: 00:05:00</p></div><div><div><p>•Virtual Methods: 00:04:00</p></div><div><div><p>•Abstract Base Class: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Error Handling: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Preprocessor Macro Definitions: 00:04:00</p></div><div><div><p>•Preprocessor Conditional Directives: 00:05:00</p></div><div><div><p>•Preprocessor Line Directive: 00:04:00</p></div><div><div><p>•Preprocessor Error Directive: 00:03:00</p></div><div><div><p>•Preprocessor Source File Inclusion: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Opening A File: 00:06:00</p></div><div><div><p>•Writing to a File: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Commenting: 00:04:00</p></div><div><div><p>•Class Header and Implementation: 00:09:00</p></div><div><div><p>•Lists: 00:04:00</p></div><div><div><p>•Vectors: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Resource - C++ Complete Coding Course: 00:00:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Assignment - C++ Complete Coding Course: 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Coding For Kids

C++ Complete Coding Course

<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>

Nexus Human

Learning & Development

Design & Technology Courses (DT)

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

Microsoft AZ-900

Microsoft AZ-104

Microsoft Azure

Microsoft AZ-700

DP-900T00 Microsoft Azure Data Fundamentals

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>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>

CompTIA Security+

50255 Managing Windows Environments with Group Policy

<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

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p></p><p>This course is suitable for IT personnel who are just beginning to work with Azure. This audience wants to learn about our offerings and get hands-on experience with the product. This course primarily uses the Azure portal and command line interface to create resources and does not require scripting skills. Students in this course will gain confidence to take other role-based courses and certifications, such as Azure Administrator. This course combines lecture, demonstrations, and hands-on labs. This course will also help prepare someone for the AZ-900 exam.</p><p></p><p></p><p>This course will provide foundational level knowledge on cloud concepts; core Azure services; and Azure management and governance features and tools.</p><p></p>Prerequisites<p>There are no prerequisites for taking this course. Familiarity with cloud computing is helpful, but isn't necessary.</p></div><div id="course-pills-2"><h3>1 - Describe cloud computing</h3> <ul> <li>What is cloud computing</li> <li>Describe the shared responsibility model</li> <li>Define cloud models</li> <li>Describe the consumption-based model</li> </ul> <h3>2 - Describe the benefits of using cloud services</h3> <ul> <li>Describe the benefits of high availability and scalability in the cloud</li> <li>Describe the benefits of reliability and predictability in the cloud</li> <li>Describe the benefits of security and governance in the cloud</li> <li>Describe the benefits of manageability in the cloud</li> </ul> <h3>3 - Describe cloud service types</h3> <ul> <li>Describe Infrastructure as a Service</li> <li>Describe Platform as a Service</li> <li>Describe Software as a Service</li> </ul> <h3>4 - Describe the core architectural components of Azure</h3> <ul> <li>What is Microsoft Azure</li> <li>Get started with Azure accounts</li> <li>Describe Azure physical infrastructure</li> <li>Describe Azure management infrastructure</li> </ul> <h3>5 - Describe Azure compute and networking services</h3> <ul> <li>Describe Azure Virtual Machines</li> <li>Describe Azure Virtual Desktop</li> <li>Describe Azure Containers</li> <li>Describe Azure Functions</li> <li>Describe application hosting options</li> <li>Describe Azure Virtual Networking</li> <li>Describe Azure Virtual Private Networks</li> <li>Describe Azure ExpressRoute</li> <li>Describe Azure DNS</li> </ul> <h3>6 - Describe Azure storage services</h3> <ul> <li>Describe Azure storage accounts</li> <li>Describe Azure storage redundancy</li> <li>Describe Azure storage services</li> <li>Identify Azure data migration options</li> <li>Identify Azure file movement options</li> </ul> <h3>7 - Describe Azure identity, access, and security</h3> <ul> <li>Describe Azure directory services</li> <li>Describe Azure authentication methods</li> <li>Describe Azure external identities</li> <li>Describe Azure conditional access</li> <li>Describe Azure role-based access control</li> <li>Describe zero trust model</li> <li>Describe defense-in-depth</li> <li>Describe Microsoft Defender for Cloud</li> </ul> <h3>8 - Describe cost management in Azure</h3> <ul> <li>Describe factors that can affect costs in Azure</li> <li>Compare the Pricing and Total Cost of Ownership calculators</li> <li>Describe the Microsoft Cost Management tool</li> <li>Describe the purpose of tags</li> </ul> <h3>9 - Describe features and tools in Azure for governance and compliance</h3> <ul> <li>Describe the purpose of Microsoft Purview</li> <li>Describe the purpose of Azure Policy</li> <li>Describe the purpose of resource locks</li> <li>Describe the purpose of the Service Trust portal</li> </ul> <h3>10 - Describe features and tools for managing and deploying Azure resources</h3> <ul> <li>Describe tools for interacting with Azure</li> <li>Describe the purpose of Azure Arc</li> <li>Describe Azure Resource Manager and Azure ARM templates</li> </ul> <h3>11 - Describe monitoring tools in Azure</h3> <ul> <li>Describe the purpose of Azure Advisor</li> <li>Describe Azure Service Health</li> <li>Describe Azure Monitor</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans AZ-900T00 Microsoft Azure Fundamentals 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-900T00 Microsoft Azure Fundamentals 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>

AWS Certified Cloud Practitioner

AZ-900T00 Microsoft Azure Fundamentals

3380 Courses delivered Online

Microsoft Excel Masterclass in 2021

By John Academy

Adobe Photoshop CS3 for Beginners

By John Academy

Basic Excel Spreadsheet

By John Academy

Need to Know Advanced Excel Formulas and Functions

By John Academy

Advanced Excel Models using Formulas, VBA & Power Query

By John Academy

Functional Skills Maths - Level 1 (Updated 2022)

By Apex Learning

Microsoft Visio 2016 - Complete Bundle

By Apex Learning

C++ Development: The Complete Coding Guide

By Apex Learning

Programming AutoCAD to Excel using VB.NET

By Apex Learning

C++ Complete Coding Course

By Apex Learning