Name: Python Programming Level 2
Price: 5 GBP
Availability: InStock

Study Plex

Microsoft Excel Diploma

General Admission

<div> <div>     </div> <div>  <div> <div> <h3><strong>Highlights of the Course</strong></h3> <ul> <li><strong>Course Type:</strong> Online Learning</li> <li><strong>Duration:</strong> 1 Hour 37 Minutes</li> <li><strong>Tutor Support:</strong> Tutor support is included</li> <li><strong>Customer Support:</strong> 24/7 customer support is available</li> <li><strong>Quality Training:</strong> The course is designed by an industry expert</li> <li><strong>Recognised Credential:</strong> Recognised and Valuable Certification</li> <li><strong>Completion Certificate:</strong> Free Course Completion Certificate Included</li> <li><strong>Instalment:</strong> 3 Installment Plan on checkout</li> </ul> </div> </div> <div> <div> <hr /> <h3><strong>What you will learn from this course?</strong></h3> <ul> <li>Gain comprehensive knowledge about Microsoft Office Excel</li> <li>Understand the core competencies and principles of Microsoft Office Excel</li> <li>Explore the various areas of Microsoft Office Excel</li> <li>Know how to apply the skills you acquired from this course in a real-life context</li> <li>Become a confident and expert office admin</li> </ul> </div> </div> <div> <div> <div> <hr /> <div> <div> <div> <h3><strong>Microsoft Excel 2016: Part 3 (Expert Level) Course</strong></h3> <p>Master the skills you need to propel your career forward in Microsoft Office Excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive excel expert level<b> </b>course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this excel expert level course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career.</p> <p>This comprehensive course will teach you the theory of effective Microsoft Office Excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft Office Excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft Office Excel. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft Office Excel.</p> <p>Enrol in this excel expert level course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates.</p> </div> <div> <h3><strong>Who is this Course for?</strong></h3> <p>This comprehensive excel expert level course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Office Excel can also take this course.</p> <p>Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector.</p> </div> <div> <h3><strong>Entry Requirements</strong></h3> <p>This excel expert level course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection.</p> </div> <div> <h3><strong>Assessment</strong></h3> <p>This excel expert level course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%.</p> </div> <div> <h3><strong>Advance Your Career</strong></h3> <p>This excel expert level<b> </b>course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume.</p> </div> </div> </div> </div> </div> </div> </div> </div><h3><strong>Recognised Accreditation</strong></h3> <p></p> <p>This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement.</p><div> <h3> <span>Course Curriculum</span> </h3> <div> <table> <tbody><tr> <td colspan="4">Working With Multiple Worksheets and Workbooks</td> </tr> <tr> <td><i></i></td> <td> Use Links and External References - Introduction </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Use Links and External References </td> <td> </td> <td><span><i></i> 00:05:00</span></td> </tr> <tr> <td><i></i></td> <td> Use 3-D References - Introduction </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Use 3-D References </td> <td> </td> <td><span><i></i> 00:04:00</span></td> </tr> <tr> <td><i></i></td> <td> Consolidate Data - Introduction </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Consolidate Data </td> <td> </td> <td><span><i></i> 00:05:00</span></td> </tr> <tr> <td colspan="4">Using Lookup Functions and Formula Auditing</td> </tr> <tr> <td><i></i></td> <td> Use Lookup Functions - Introduction </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Use Lookup Functions </td> <td> </td> <td><span><i></i> 00:08:00</span></td> </tr> <tr> <td><i></i></td> <td> Trace Precedent and Dependent Cells - Introduction </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Trace Precedent and Dependent Cells </td> <td> </td> <td><span><i></i> 00:03:00</span></td> </tr> <tr> <td><i></i></td> <td> Watch and Evaluate Formulas - Introduction </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Watch and Evaluate Formulas </td> <td> </td> <td><span><i></i> 00:04:00</span></td> </tr> <tr> <td colspan="4">Sharing and Protecting Workbooks</td> </tr> <tr> <td><i></i></td> <td> Collaborate on a Workbook - Introduction </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Collaborate on a Workbook </td> <td> </td> <td><span><i></i> 00:05:00</span></td> </tr> <tr> <td><i></i></td> <td> Compare and Merge Workbooks - Introduction </td> <td> </td> <td><span><i></i> 00:03:00</span></td> </tr> <tr> <td><i></i></td> <td> Protect Worksheets and Workbooks </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Protect Worksheets and Workbooks </td> <td> </td> <td><span><i></i> 00:04:00</span></td> </tr> <tr> <td colspan="4">Automating Workbook Functionality</td> </tr> <tr> <td><i></i></td> <td> Apply Data Validation </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Apply Data Validation </td> <td> </td> <td><span><i></i> 00:04:00</span></td> </tr> <tr> <td><i></i></td> <td> Search for Invalid Data and Formulas with Errors - Introduction </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Search for Invalid Data and Formulas with Errors </td> <td> </td> <td><span><i></i> 00:03:00</span></td> </tr> <tr> <td><i></i></td> <td> Work with Macros - Introduction </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Work with Macros </td> <td> </td> <td><span><i></i> 00:05:00</span></td> </tr> <tr> <td><i></i></td> <td> Edit a Macro </td> <td> </td> <td><span><i></i> 00:02:00</span></td> </tr> <tr> <td colspan="4">Creating Sparklines and Mapping Data</td> </tr> <tr> <td><i></i></td> <td> Create Sparklines - Introduction </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Create Sparklines </td> <td> </td> <td><span><i></i> 00:03:00</span></td> </tr> <tr> <td><i></i></td> <td> Map Data - Introduction </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Map Data </td> <td> </td> <td><span><i></i> 00:04:00</span></td> </tr> <tr> <td colspan="4">Forecasting Data</td> </tr> <tr> <td><i></i></td> <td> Determine Potential Outcomes Using Data Tables - Introduction </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Determine Potential Outcomes Using Data Tables </td> <td> </td> <td><span><i></i> 00:05:00</span></td> </tr> <tr> <td><i></i></td> <td> Determine Potential Outcomes Using Data Scenarios - Introduction </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Determine Potential Outcomes Using Data Scenarios </td> <td> </td> <td><span><i></i> 00:05:00</span></td> </tr> <tr> <td><i></i></td> <td> Use the Goal Seek Feature - Introduction </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Use the Goal Seek Feature </td> <td> </td> <td><span><i></i> 00:03:00</span></td> </tr> <tr> <td><i></i></td> <td> Forecast Data Trends - Introduction </td> <td> </td> <td><span><i></i> 00:05:00</span></td> </tr> <tr> <td><i></i></td> <td> Forecast Data Trends </td> <td> </td> <td><span><i></i> 00:03:00</span></td> </tr> <tr> <td colspan="4">Obtain Your Certificate</td> </tr> <tr> <td><i></i></td> <td> Order Your Certificate of Achievement </td> <td> </td> <td><span><i></i> 00:00:00</span></td> </tr> <tr> <td colspan="4">Get Your Insurance Now</td> </tr> <tr> <td><i></i></td> <td> Get Your Insurance Now </td> <td> </td> <td><span><i></i> 00:00:00</span></td> </tr> <tr> <td colspan="4">Feedback</td> </tr> <tr> <td><i></i></td> <td> Feedback </td> <td> </td> <td><span><i></i> 00:00:00</span></td> </tr> </tbody></table></div> </div>

Microsoft Excel 2016: Part 3 (Expert Level) Course

Microsoft Excel Online Training

<div>
        <div>
            <h2>
                Recognised Accreditation
            </h2>
            <p>This course is accredited by continuing professional development (CPD). CPD UK is globally
                recognised by employers, professional organisations, and academic institutions, thus a
                certificate from CPD Certification Service creates value towards your professional goal
                and achievement.</p>

                

                <p>The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries.</p>
                
    </div>
    <div>
        <div>
            <div>
                
                <h3>What is CPD?</h3>
                <p>Employers, professional organisations, and academic institutions all recognise CPD,
                    therefore a credential from CPD Certification Service adds value to your professional
                    goals and achievements.</p>
                <h4>Benefits of CPD</h4>
                <ul>
                    <li>Improve your employment prospects </li>
                    <li>Boost your job satisfaction </li>
                    <li>Promotes career advancement </li>
                    <li>Enhances your CV </li>
                    <li>Provides you with a competitive edge in the job market </li>
                    <li>Demonstrate your dedication </li>
                    <li>Showcases your professional capabilities</li>
                </ul>
            </div>
        </div>
        <div>
            <div>
                
                <h3>What is IPHM? </h3>
                <p>The IPHM is an Accreditation Board that provides Training Providers with international
                    and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation
                    is a guarantee of quality and skill. </p>
                <h4>Benefits of IPHM </h4>
                <ul>
                    <li>It will help you establish a positive reputation in your chosen field </li>
                    <li>You can join a network and community of successful therapists that are dedicated to
                    providing excellent care to their client </li>
                    <li>You can flaunt this accreditation in your CV </li>
                    <li>It is a worldwide recognised accreditation </li>
                </ul>
            </div>
        </div>
        <div>
            <div>
                
                <h3>What is Quality Licence Scheme?</h3>
                <p>This course is endorsed by the Quality Licence Scheme for its high-quality,
                    non-regulated provision and training programmes. The Quality Licence Scheme is a brand
                    of the Skills and Education Group, a leading national awarding organisation for
                    providing high-quality vocational qualifications across a wide range of industries.</p>
                <h4> Benefits of Quality License Scheme </h4>
                <ul>
                    <li>Certificate is valuable</li>
                    <li>Provides a competitive edge in your career</li>
                    <li>It will make your CV stand out</li>
                </ul>
            </div>
        </div>
    </div>
                    </div><div>
				
<h3>
	<span>Course Curriculum</span>
</h3>

<div>
<table>				<tbody><tr>
					<td colspan="4">Introduction</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Introduction					</td>

					
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Excel Basics</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Basics					</td>

					
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Worksheet Basics					</td>

					
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Entering values and Formulas					</td>

					
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Data Formats					</td>

					
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Data Handling Basics - Cut, Copy and Paste					</td>

					
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Saving and Printing - Basics					</td>

					
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Essential Formulas</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Basic Formula Operations					</td>

					
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Mathematical Functions					</td>

					
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Textual Functions					</td>

					
					<td> </td>
					<td><span><i></i> 00:17:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Logical Functions					</td>

					
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Date-Time Functions					</td>

					
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Lookup Functions ( V Lookup, Hlookup, Index-Match )					</td>

					
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Data Tools</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Data Tools					</td>

					
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Formatting data and tables</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Formatting data and tables					</td>

					
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Pivot Tables</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Pivot Tables					</td>

					
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Excel Charts</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Excel Charts - Categories of messages that can be conveyed					</td>

					
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Elements of charts					</td>

					
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						The Easy way of creating charts					</td>

					
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Bar and column charts					</td>

					
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Formating charts					</td>

					
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Line Charts					</td>

					
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Area Charts					</td>

					
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Pie and Doughnut Charts					</td>

					
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Why we should avoid Pie charts					</td>

					
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Scatter plot or XY chart					</td>

					
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Frequency Distribution and Histograms					</td>

					
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Waterfall Charts					</td>

					
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Sparklines					</td>

					
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Pivot Charts</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Pivot Charts					</td>

					
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Named Ranges</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Named Ranges					</td>

					
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Indirect Function					</td>

					
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Excel Shortcuts</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Shortcuts					</td>

					
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Macros</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Macros					</td>

					
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Advanced Excel</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Advanced Excel: Analytics in Excel					</td>

					
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Final Assessment </td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Assessment - Microsoft Excel For Beginners</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Certificate of Achievement</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Certificate of Achievement					</td>

					
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Get Your Insurance Now</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Get Your Insurance Now					</td>

					
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Feedback</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>
						Feedback					</td>

					
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table></div>

			</div>

Microsoft Excel For Beginners

<div> <div>     </div> <div>  <div> <div> <h3><strong>Highlights of the Course</strong></h3> <ul> <li><strong>Course Type:</strong> Online Learning</li> <li><strong>Duration:</strong> 11 Hours 11 Minutes</li> <li><strong>Tutor Support:</strong> Tutor support is included</li> <li><strong>Customer Support:</strong> 24/7 customer support is available</li> <li><strong>Quality Training:</strong> The course is designed by an industry expert</li> <li><strong>Recognised Credential:</strong> Recognised and Valuable Certification</li> <li><strong>Completion Certificate:</strong> Free Course Completion Certificate Included</li> <li><strong>Instalment:</strong> 3 Installment Plan on checkout</li> </ul> </div> </div> <div> <div> <hr /> <h3><strong>What you will learn from this course?</strong></h3> <ul> <li>Gain comprehensive knowledge about retail analytics and management</li> <li>Understand the core competencies and principles of retail analytics and management</li> <li>Explore the various areas of retail analytics and management</li> <li>Know how to apply the skills you acquired from this course in a real-life context</li> <li>Become a confident and expert retail manager</li> </ul> </div> </div> <div> <div> <div> <hr /> <h3><strong>Retail Analytics In Microsoft Excel Course</strong></h3> <p>Master the skills you need to propel your career forward in Microsoft excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive retail analytics in Microsoft excel<b> </b>course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this retail analytics in Microsoft excel course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career.</p> <p>This comprehensive course will teach you the theory of effective Microsoft excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft excel. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialize in Microsoft excel.</p> <p>Enroll in this retail analytics in Microsoft excel course today and take the next step towards your personal and professional goals. Earn industry-recognized credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates.</p> </div> <div> <h3><strong>Who is this Course for?</strong></h3> <p>This comprehensive retail analytics in Microsoft excel course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft excel can also take this course.</p> <p>Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector.</p> </div> <div> <h3><strong>Entry Requirements</strong></h3> <p>This retail analytics in Microsoft excel course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection.</p> </div> <div> <h3><strong>Assessment</strong></h3> <p>This retail analytics in Microsoft excel course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%.</p> </div> <div> <h3><strong>Advance Your Career</strong></h3> <p>This retail analytics in Microsoft excel<b> </b>course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume.</p> </div> </div> </div> </div> </div><div> <div> <h2> Recognised Accreditation </h2> <p>This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement.</p>  <p>The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries.</p>  </div> <div> <div> <div> <h3>What is CPD?</h3> <p>Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements.</p> <h4>Benefits of CPD</h4> <ul> <li>Improve your employment prospects </li> <li>Boost your job satisfaction </li> <li>Promotes career advancement </li> <li>Enhances your CV </li> <li>Provides you with a competitive edge in the job market </li> <li>Demonstrate your dedication </li> <li>Showcases your professional capabilities</li> </ul> </div> </div> <div> <div>  <h3>What is IPHM? </h3> <p>The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. </p> <h4>Benefits of IPHM </h4> <ul> <li>It will help you establish a positive reputation in your chosen field </li> <li>You can join a network and community of successful therapists that are dedicated to providing excellent care to their client </li> <li>You can flaunt this accreditation in your CV </li> <li>It is a worldwide recognised accreditation </li> </ul> </div> </div> <div> <div>  <h3>What is Quality Licence Scheme?</h3> <p>This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries.</p> <h4> Benefits of Quality License Scheme </h4> <ul> <li>Certificate is valuable</li> <li>Provides a competitive edge in your career</li> <li>It will make your CV stand out</li> </ul> </div> </div> </div> </div><div> <h3> <span>Course Curriculum</span> </h3> <div> <table> <tbody><tr> <td colspan="4">Course Introduction</td> </tr> <tr> <td><i></i></td> <td> Introduction </td> <td> </td> <td><span><i></i> 00:03:00</span></td> </tr> <tr> <td colspan="4">Part 1: Forecasting</td> </tr> <tr> <td><i></i></td> <td> Basics of Forecasting </td> <td> </td> <td><span><i></i> 00:05:00</span></td> </tr> <tr> <td><i></i></td> <td> Creating Linear Model with Trendlines </td> <td> </td> <td><span><i></i> 00:08:00</span></td> </tr> <tr> <td colspan="4">1.1 Getting Data Ready For Regression Model</td> </tr> <tr> <td><i></i></td> <td> Gathering Business Knowledge </td> <td> </td> <td><span><i></i> 00:03:00</span></td> </tr> <tr> <td><i></i></td> <td> Data Exploration </td> <td> </td> <td><span><i></i> 00:03:00</span></td> </tr> <tr> <td><i></i></td> <td> The Data and the Data Dictionary </td> <td> </td> <td><span><i></i> 00:07:00</span></td> </tr> <tr> <td><i></i></td> <td> Univariate analysis and EDD </td> <td> </td> <td><span><i></i> 00:03:00</span></td> </tr> <tr> <td><i></i></td> <td> Discriptive Data Analytics in Excel </td> <td> </td> <td><span><i></i> 00:10:00</span></td> </tr> <tr> <td><i></i></td> <td> Outlier Treatment </td> <td> </td> <td><span><i></i> 00:04:00</span></td> </tr> <tr> <td><i></i></td> <td> Identifying and Treating Outliers in Excel </td> <td> </td> <td><span><i></i> 00:04:00</span></td> </tr> <tr> <td><i></i></td> <td> Missing Value Imputation </td> <td> </td> <td><span><i></i> 00:03:00</span></td> </tr> <tr> <td><i></i></td> <td> Identifying and Treating missing values in Excel </td> <td> </td> <td><span><i></i> 00:04:00</span></td> </tr> <tr> <td><i></i></td> <td> Variable Transformation in Excel </td> <td> </td> <td><span><i></i> 00:03:00</span></td> </tr> <tr> <td><i></i></td> <td> Dummy variable creation: Handling qualitative data </td> <td> </td> <td><span><i></i> 00:04:00</span></td> </tr> <tr> <td><i></i></td> <td> Dummy Variable Creation in Excel </td> <td> </td> <td><span><i></i> 00:07:00</span></td> </tr> <tr> <td><i></i></td> <td> Correlation Analysis </td> <td> </td> <td><span><i></i> 00:09:00</span></td> </tr> <tr> <td><i></i></td> <td> Creating Correlation Matrix in Excel </td> <td> </td> <td><span><i></i> 00:08:00</span></td> </tr> <tr> <td colspan="4">1.2 Forecasting Using Regression Model</td> </tr> <tr> <td><i></i></td> <td> The Problem Statement </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Basic Equations and Ordinary Least Squares (OLS) method </td> <td> </td> <td><span><i></i> 00:08:00</span></td> </tr> <tr> <td><i></i></td> <td> Assessing accuracy of predicted coefficients </td> <td> </td> <td><span><i></i> 00:14:00</span></td> </tr> <tr> <td><i></i></td> <td> Assessing Model Accuracy: RSE and R squared </td> <td> </td> <td><span><i></i> 00:07:00</span></td> </tr> <tr> <td><i></i></td> <td> Creating Simple Linear Regression model </td> <td> </td> <td><span><i></i> 00:02:00</span></td> </tr> <tr> <td><i></i></td> <td> Multiple Linear Regression </td> <td> </td> <td><span><i></i> 00:05:00</span></td> </tr> <tr> <td><i></i></td> <td> The F - statistic </td> <td> </td> <td><span><i></i> 00:08:00</span></td> </tr> <tr> <td><i></i></td> <td> Interpreting results of Categorical variables </td> <td> </td> <td><span><i></i> 00:05:00</span></td> </tr> <tr> <td><i></i></td> <td> Creating Multiple Linear Regression model </td> <td> </td> <td><span><i></i> 00:07:00</span></td> </tr> <tr> <td colspan="4">1.3 Handling Special Events Like Holiday Sales</td> </tr> <tr> <td><i></i></td> <td> Forecasting in presence of special events </td> <td> </td> <td><span><i></i> 00:02:00</span></td> </tr> <tr> <td><i></i></td> <td> Excel: Running Linear Regression using Solver </td> <td> </td> <td><span><i></i> 00:08:00</span></td> </tr> <tr> <td><i></i></td> <td> Excel: Including the impact of Special Events </td> <td> </td> <td><span><i></i> 00:22:00</span></td> </tr> <tr> <td colspan="4">1.4 Identifying Seasonality &amp; Trend for Forecasting</td> </tr> <tr> <td><i></i></td> <td> Models to identify Trend &amp; Seasonality </td> <td> </td> <td><span><i></i> 00:06:00</span></td> </tr> <tr> <td><i></i></td> <td> Excel: Additive model to identify Trend &amp; Seasonality </td> <td> </td> <td><span><i></i> 00:09:00</span></td> </tr> <tr> <td><i></i></td> <td> Excel: Multiplicative model to identify Trend &amp; Seasonality </td> <td> </td> <td><span><i></i> 00:06:00</span></td> </tr> <tr> <td colspan="4">Market Basket Analysis</td> </tr> <tr> <td><i></i></td> <td> Market Basket and Lift - Introduction </td> <td> </td> <td><span><i></i> 00:08:00</span></td> </tr> <tr> <td><i></i></td> <td> Named Ranges - Excel </td> <td> </td> <td><span><i></i> 00:10:00</span></td> </tr> <tr> <td><i></i></td> <td> Indirect Function - Excel </td> <td> </td> <td><span><i></i> 00:05:00</span></td> </tr> <tr> <td><i></i></td> <td> 2-way lift calculation in Excel </td> <td> </td> <td><span><i></i> 00:11:00</span></td> </tr> <tr> <td><i></i></td> <td> 2-way lift calculation - Dynamic </td> <td> </td> <td><span><i></i> 00:07:00</span></td> </tr> <tr> <td><i></i></td> <td> 2-way lift data table creation </td> <td> </td> <td><span><i></i> 00:07:00</span></td> </tr> <tr> <td><i></i></td> <td> 3-way lift calculation </td> <td> </td> <td><span><i></i> 00:19:00</span></td> </tr> <tr> <td><i></i></td> <td> Store Layout optimization using Lift values </td> <td> </td> <td><span><i></i> 00:15:00</span></td> </tr> <tr> <td colspan="4">RFM (Recency, Frequency, Monetary) Analysis</td> </tr> <tr> <td><i></i></td> <td> RFM (recency, frequency, monetary) Analysis </td> <td> </td> <td><span><i></i> 00:08:00</span></td> </tr> <tr> <td><i></i></td> <td> RFM Analysis in Excel- Part 1 </td> <td> </td> <td><span><i></i> 00:16:00</span></td> </tr> <tr> <td><i></i></td> <td> RFM Analysis in Excel- Part 2 </td> <td> </td> <td><span><i></i> 00:12:00</span></td> </tr> <tr> <td colspan="4">Part 2: Pricing</td> </tr> <tr> <td colspan="4">Part 2: Pricing</td> </tr> <tr> <td><i></i></td> <td> Steps of setting a Pricing policy </td> <td> </td> <td><span><i></i> 00:03:00</span></td> </tr> <tr> <td><i></i></td> <td> Different Pricing Objectives </td> <td> </td> <td><span><i></i> 00:07:00</span></td> </tr> <tr> <td colspan="4">2.1 Estimating Demand</td> </tr> <tr> <td><i></i></td> <td> Estimating Demand </td> <td> </td> <td><span><i></i> 00:07:00</span></td> </tr> <tr> <td><i></i></td> <td> Forms of Demand Curve </td> <td> </td> <td><span><i></i> 00:02:00</span></td> </tr> <tr> <td><i></i></td> <td> Excel: Estimating Linear Demand Curve </td> <td> </td> <td><span><i></i> 00:08:00</span></td> </tr> <tr> <td><i></i></td> <td> Excel: Estimating Power Demand curve with Elasticity </td> <td> </td> <td><span><i></i> 00:05:00</span></td> </tr> <tr> <td><i></i></td> <td> Excel: Estimating Power Demand Curve with points </td> <td> </td> <td><span><i></i> 00:03:00</span></td> </tr> <tr> <td><i></i></td> <td> Subjective Demand curve </td> <td> </td> <td><span><i></i> 00:01:00</span></td> </tr> <tr> <td><i></i></td> <td> Excel: Estimating Subjective Demand Curve </td> <td> </td> <td><span><i></i> 00:02:00</span></td> </tr> <tr> <td colspan="4">2.3 Evaluating Pricing Strategies</td> </tr> <tr> <td><i></i></td> <td> Price Bundling </td> <td> </td> <td><span><i></i> 00:07:00</span></td> </tr> <tr> <td><i></i></td> <td> Types of Bundling </td> <td> </td> <td><span><i></i> 00:08:00</span></td> </tr> <tr> <td><i></i></td> <td> The Bundling Problem </td> <td> </td> <td><span><i></i> 00:04:00</span></td> </tr> <tr> <td><i></i></td> <td> Excel: Solving Bundling problem Part 1 </td> <td> </td> <td><span><i></i> 00:14:00</span></td> </tr> <tr> <td><i></i></td> <td> Excel: Solving Bundling problem Part 2 </td> <td> </td> <td><span><i></i> 00:08:00</span></td> </tr> <tr> <td><i></i></td> <td> Non-Linear Pricing Strategies </td> <td> </td> <td><span><i></i> 00:03:00</span></td> </tr> <tr> <td><i></i></td> <td> Excel: Solving Bundling problem (Price Reversal) </td> <td> </td> <td><span><i></i> 00:08:00</span></td> </tr> <tr> <td colspan="4">3.1 Lifetime Customer Value</td> </tr> <tr> <td><i></i></td> <td> Lifetime Customer Value - Key concepts </td> <td> </td> <td><span><i></i> 00:09:00</span></td> </tr> <tr> <td><i></i></td> <td> Lifetime Customer Value - Excel model </td> <td> </td> <td><span><i></i> 00:11:00</span></td> </tr> <tr> <td colspan="4">3.2 Variations And Sensitivity Analysis</td> </tr> <tr> <td><i></i></td> <td> Sensitivity Analysis in Excel </td> <td> </td> <td><span><i></i> 00:07:00</span></td> </tr> <tr> <td><i></i></td> <td> Variations in finding customer value </td> <td> </td> <td><span><i></i> 00:07:00</span></td> </tr> <tr> <td colspan="4">Appendix 1: Excel Crash Course</td> </tr> <tr> <td><i></i></td> <td> Basics </td> <td> </td> <td><span><i></i> 00:08:00</span></td> </tr> <tr> <td><i></i></td> <td> Worksheet Basics </td> <td> </td> <td><span><i></i> 00:16:00</span></td> </tr> <tr> <td><i></i></td> <td> Entering values and Formulas </td> <td> </td> <td><span><i></i> 00:07:00</span></td> </tr> <tr> <td><i></i></td> <td> Data Handling Basics - Cut, Copy and Paste </td> <td> </td> <td><span><i></i> 00:14:00</span></td> </tr> <tr> <td><i></i></td> <td> Saving and Printing - Basics </td> <td> </td> <td><span><i></i> 00:09:00</span></td> </tr> <tr> <td><i></i></td> <td> Basic Formula Operations </td> <td> </td> <td><span><i></i> 00:13:00</span></td> </tr> <tr> <td><i></i></td> <td> Mathematical Formulas </td> <td> </td> <td><span><i></i> 00:19:00</span></td> </tr> <tr> <td><i></i></td> <td> Textual Formulas </td> <td> </td> <td><span><i></i> 00:17:00</span></td> </tr> <tr> <td><i></i></td> <td> Logical Formulas </td> <td> </td> <td><span><i></i> 00:11:00</span></td> </tr> <tr> <td><i></i></td> <td> Date-Time Formulas </td> <td> </td> <td><span><i></i> 00:07:00</span></td> </tr> <tr> <td><i></i></td> <td> Lookup Formulas ( V Lookup, Hlookup, Index-Match ) </td> <td> </td> <td><span><i></i> 00:08:00</span></td> </tr> <tr> <td><i></i></td> <td> Data Tools </td> <td> </td> <td><span><i></i> 00:19:00</span></td> </tr> <tr> <td><i></i></td> <td> Formatting data and tables </td> <td> </td> <td><span><i></i> 00:18:00</span></td> </tr> <tr> <td><i></i></td> <td> Pivot Tables </td> <td> </td> <td><span><i></i> 00:08:00</span></td> </tr> <tr> <td><i></i></td> <td> Advance Excel- Solver, Data tables </td> <td> </td> <td><span><i></i> 00:15:00</span></td> </tr> <tr> <td colspan="4">Assessment</td> </tr> <tr> <td><i></i></td> <td>Assessment - Retail Analytics In Microsoft Excel</td> <td> </td> <td><span><i></i> 00:10:00</span></td> </tr> <tr> <td colspan="4">Certificate of Achievement</td> </tr> <tr> <td><i></i></td> <td> Certificate of Achievement </td> <td> </td> <td><span><i></i> 00:00:00</span></td> </tr> <tr> <td colspan="4">Get Your Insurance Now</td> </tr> <tr> <td><i></i></td> <td> Get Your Insurance Now </td> <td> </td> <td><span><i></i> 00:00:00</span></td> </tr> <tr> <td colspan="4">Feedback</td> </tr> <tr> <td><i></i></td> <td> Feedback </td> <td> </td> <td><span><i></i> 00:00:00</span></td> </tr> </tbody></table></div> </div>

Retail Analytics In Microsoft Excel

Packt

Data Visualization

Tableau

Data Analysis

Python

This course explains how huge chunks of data can be analyzed and visualized using the power of the data analyst toolbox. You will learn Python programming, advanced pivot tables' concepts, the magic of Power BI, perform analysis with Alteryx, master Qlik Sense, R Programming using R and R Studio, and create stunning visualizations in Tableau Desktop.

Data Analysts' Toolbox - Excel, Python, Power BI, Alteryx, Qlik Sense, R, Tableau

Skill Up

Performance Management

Career Development

Leadership Skills

Professional Development

Management Skills

40-in-1 CPD Accredited Bundle| Special Gifts: Free PDF & Transcript Certificate| Updated course materials| Learner Support


Performance Management, Team Management & Crisis Management


<h2 style="color: var(--text-heading); box-sizing: border-box;" id="isPasted" fr-original-style="color: var(--text-heading);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">This course at a glance</span></strong></h2><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Accredited by CPDQE</li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(38, 99, 82) !important; box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">Get a guide to becoming a professional Python developer</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(38, 99, 82) !important; box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">Learn the basic Python structures: strings, lists, and dictionaries</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(38, 99, 82) !important; box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">Know the Python Object-Oriented Programming (OOP) language</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(38, 99, 82) !important; box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">Explore how from scratch to create a Python program</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(38, 99, 82) !important; box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">Learn how to calculate, retrieve, and store information using variables</span></li></ul><p style="color: rgb(38, 99, 82) !important; font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 99, 82) !important;">A Python developer is a programmer who builds server-side web application logic. They create, maintain, and execute Python applications. Python developers are in high demand in the job market. The course will provide you with step-by-step instructions for becoming a Python developer. &nbsp;&nbsp;</p><p style="color: rgb(38, 99, 82) !important; font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">Throughout this course, you&rsquo;ll receive all the necessary instructions for pursuing a career in Python development. In the beginning, you&rsquo;ll be guided on how to get your first employment as a Python developer. This course will cover developing Python scripts to carry out automated tasks as well as how to create the fundamental Python structures. You&rsquo;ll also receive instructions on how to use fundamental programming constructs like loops and functions. Our professional instructor helps you equip you with theoretical and practical knowledge of Python to excel in this industry<b fr-original-style="" style="box-sizing: border-box;">.</b></p><p style="color: rgb(38, 99, 82) !important; font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">An expert instructor designed this &ldquo;Python &nbsp;Programming &rdquo; course to provide you with the best learning experience possible. Our goal is for you to learn and apply the lessons from this course to improve your skills.&nbsp;</p><p style="color: rgb(38, 99, 82) !important; font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">Hurry up. Enrol now!</p><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">Accredited by</span></h3><p style="color: rgb(15, 21, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);">This course is <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">CPDQE&nbsp;</strong>accredited, which serves as an impactful mechanism for skill enhancement.&nbsp;</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Continuing Professional Development (CPD) stands as a crucial, widely acknowledged method that aids individuals, organisations, and entire industries in staying current with their skills and knowledge.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">CPD not only facilitates the elevation of global standards and benchmarks, aligning with the growing forces of globalisation and consumer expectations but also transforms learning into a deliberate and proactive process. It motivates professionals to uphold a consistently high level of performance and demonstrates their unwavering commitment to a specific job role or profession.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">Course Curriculum</span></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Section 1: Introduction to Python Programming from A-Z</strong></li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Section 2: Getting Familiar with Python</strong></li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Section 3: Python Basic Data Types</strong></li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Section 4: Python Operators</strong></li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Section 5: Python Advanced Data Types</strong></li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Section 6: Python Control Flow Part 1</strong></li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Section 7: Python Control Flow Part 2</strong></li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Section 8: Python Functions</strong></li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Section 9: User Input and Error Handling</strong></li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Section 10: Python Advanced Functions</strong></li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Section 11: Python Scripting and Libraries</strong></li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Section 12: NumPy</strong></li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Section 13: Pandas</strong></li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Section 14: Intro To OOP</strong></li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Section 15: Advanced OOP</strong></li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Section 16: Starting a Career in Python</strong></li></ul>

LearnDrive UK

Python Scripting

You will learn how to become a Python developer through this course.



Python Programming


<h2 style="color: var(--text-heading); box-sizing: border-box;" id="isPasted" fr-original-style="color: var(--text-heading);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">This course at a glance</span></strong></h2><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Accredited by CPDQE</li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(38, 99, 82) !important; box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">Learn how to work as a team</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(38, 99, 82) !important; box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">Identify the three pillars of high-performance teams</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(38, 99, 82) !important; box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">Manage culturally diverse teams effectively</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(38, 99, 82) !important; box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">Oversee remote teams</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(38, 99, 82) !important; box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">Know how to inspire your team members</span></li></ul><div data-id="4afcd14" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(35, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 35, 35);"><div data-id="4afcd14" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(35, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 35, 35);"><div data-id="4afcd14" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(35, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 35, 35);"><div data-id="4afcd14" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(35, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 35, 35);"><div data-id="4afcd14" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(35, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 35, 35);"><div data-id="4afcd14" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(35, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 35, 35);"><div data-id="4afcd14" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(35, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 35, 35);"><p style="color: rgb(38, 99, 82) !important; font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 99, 82) !important;">Teamwork is essential for the success of your business. It makes your dream come true. The collaboration, efficiency, and intelligence of your entire team will allow you to achieve greater&nbsp;<a href="https://learndrive.org/course/secrets-of-entrepreneurial-success/" target="_blank" rel="noopener" style="color: rgb(6, 122, 0); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(6, 122, 0);">success</a>&nbsp;together. When everyone in your team works together, success will follow. For this reason, effective team management is of paramount importance nowadays.</p><p style="color: rgb(38, 99, 82) !important; font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">Taking this interactive online course will help you improve your team management skills. You will learn how to establish a&nbsp;<a href="https://www.togetherplatform.com/blog/team-culture#:~:text=What%20is%20a%20team%20culture,working%20that%20a%20team%20shares." target="_blank" rel="noopener" style="color: rgb(6, 122, 0); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(6, 122, 0);">team culture</a>, build high-performance teams, and manage multicultural teams. Additionally, this course will discuss the qualities of leadership and encourage you to become a better leader by improving your communication and mentoring skills. Furthermore, you will learn different ideas and strategies to keep your team motivated.</p></div></div></div></div></div></div></div><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">Accredited by</span></h3><p style="color: rgb(15, 21, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);">This course is <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">CPDQE&nbsp;</strong>accredited, which serves as an impactful mechanism for skill enhancement.&nbsp;</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Continuing Professional Development (CPD) stands as a crucial, widely acknowledged method that aids individuals, organisations, and entire industries in staying current with their skills and knowledge.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">CPD not only facilitates the elevation of global standards and benchmarks, aligning with the growing forces of globalisation and consumer expectations but also transforms learning into a deliberate and proactive process. It motivates professionals to uphold a consistently high level of performance and demonstrates their unwavering commitment to a specific job role or profession.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">Course Curriculum</span></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Module 1: Understanding Team</strong></li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Module 2: Team Building</strong></li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Module 3: Leadership and Management</strong></li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Module 4: Creating a High-Performance Team</strong></li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Module 5: Communication and Leadership</strong></li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Module 6: Levelling-Up Team Motivation</strong></li></ul>

Business Relationship Management Professional (BRMP)

Business & Management

Team management course will teach you how to build high-performance teams, and how to manage multicultural teams effectively.




















Team Management

<h2 style="color: var(--text-heading); box-sizing: border-box;" id="isPasted" fr-original-style="color: var(--text-heading);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">This course at a glance</span></strong></h2><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Accredited by CPDQE</li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(38, 99, 82) !important; box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">Build a solid foundation in Python programming basics.</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(38, 99, 82) !important; box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">Master Python strings, operators, and sequence handling.</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(38, 99, 82) !important; box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">Develop proficiency in control flow statements for robust coding.</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(38, 99, 82) !important; box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">Create engaging games as practical Python applications.</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(38, 99, 82) !important; box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">Implement Python functions and regular expressions effectively.</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(38, 99, 82) !important; box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">Gain hands-on experience with file structures and a comprehensive Python project.</span></li></ul><div data-id="4afcd14" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(35, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 35, 35);"><div data-id="4afcd14" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(35, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 35, 35);"><div data-id="4afcd14" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(35, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 35, 35);"><div data-id="4afcd14" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(35, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 35, 35);"><div data-id="4afcd14" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(35, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 35, 35);"><div data-id="4afcd14" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(35, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 35, 35);"><p style="color: rgb(38, 99, 82) !important; font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 99, 82) !important;">&ldquo;Python Programming Level 2&rdquo; is crafted to elevate your programming skills to the next level, providing a deeper dive into the world of Python. Whether you&rsquo;re looking to enhance your coding expertise for professional development or personal interest, this course offers a comprehensive pathway.</p><p style="color: rgb(38, 99, 82) !important; font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">Start with &ldquo;Introduction to Python and Setting Up,&rdquo; which ensures you have the right foundation and tools to proceed. &ldquo;Python Basic&rdquo; revisits and reinforces core concepts, setting the stage for more advanced topics.</p><p style="color: rgb(38, 99, 82) !important; font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">&ldquo;Python Strings&rdquo; and &ldquo;Python Operators&rdquo; delve into more complex aspects of Python, enabling you to manipulate text and perform various operations effectively. &ldquo;Python Sequences&rdquo; and &ldquo;Python Statements&rdquo; further your understanding of Python&rsquo;s capabilities in handling data and executing commands.</p><p style="color: rgb(38, 99, 82) !important; font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">Critical to any programming language is the control of flow. &ldquo;Python Control Flow Statements&rdquo; teaches you to direct the execution paths of your programs, a crucial skill for any programmer. Then, add a fun dimension to your learning with &ldquo;Python Games for Beginners,&rdquo; where you apply your skills to create engaging games.</p><p style="color: rgb(38, 99, 82) !important; font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">Building on these skills, &ldquo;Python Functions&rdquo; introduces the concept of reusable code blocks, enhancing your efficiency and coding style. &ldquo;Working with File Structure&rdquo; and &ldquo;Regular Expressions&rdquo; provide essential skills in managing data and patterns within Python.</p><p style="color: rgb(38, 99, 82) !important; font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">The course culminates in a &ldquo;Python Project,&rdquo; where you&rsquo;ll bring together all the elements you&rsquo;ve learned in a practical, hands-on application. This project solidifies your learning and gives you a tangible piece of work to showcase your new skills.</p><p style="color: rgb(38, 99, 82) !important; font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">By the end of this course, you&rsquo;ll not only have a deeper understanding of Python but also practical experience in applying your knowledge to real-world scenarios. Enroll now and take your Python skills to new heights!</p></div></div></div></div></div></div><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">Accredited by</span></h3><p style="color: rgb(15, 21, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);">This course is <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">CPDQE&nbsp;</strong>accredited, which serves as an impactful mechanism for skill enhancement.&nbsp;</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Continuing Professional Development (CPD) stands as a crucial, widely acknowledged method that aids individuals, organisations, and entire industries in staying current with their skills and knowledge.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">CPD not only facilitates the elevation of global standards and benchmarks, aligning with the growing forces of globalisation and consumer expectations but also transforms learning into a deliberate and proactive process. It motivates professionals to uphold a consistently high level of performance and demonstrates their unwavering commitment to a specific job role or profession.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">Course Curriculum</span></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Introduction</strong></li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Introduction to Python and Setting Up</strong></li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Python Basic</strong></li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Python Strings</strong></li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Python Operators</strong></li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Python Sequences</strong></li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Python Statements</strong></li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Python Control Flow Statements</strong></li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Python Games for Beginners</strong></li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Python Functions</strong></li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Working with File Structure</strong></li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Regular Expressions</strong></li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Python Project</strong></li></ul>

Database Programming

Advance your Python skills with Level 2 Programming! From strings and operators to control flow and games, this course sharpens your coding prowess, culminating in a hands-on Python project. Ideal for those seeking to deepen their understanding and application of Python.






Python Programming Level 2

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience.</p>Overview<p>Upon successful completion of this course, students will be able to enhance productivity and efficiency by streamlining workflow, collaborate with others, and audit and analyse data.</p><p>This course is designed for students desiring to gain skills necessary to create macros, collaborate with others, audit and analyse data, incorporate multiple data sources, and import data.</p></div><div id="course-pills-2"><h4>Working with Multiple Worksheets and Workbooks </h4><ul><li>Working with Named Ranges</li><li>Link Cells Across Worksheets and Workbooks </li><li>Use 3D References to Calculate Across Worksheets</li><li>Consolidate Data</li></ul><h4>Use Formula Auditing and Error Checking</h4><ul><li>Reveal Formulas</li><li>Trace Cell Precedents and Dependents </li><li>Locate Errors in Formulas </li><li>Watch and Evaluate Formulas </li></ul><h4>Reviewing and Protecting Workbooks </h4><ul><li>Control Data Entry via Data Validation</li><li>Protect Workbook Access</li><li>Protect Worksheets and Cell Content </li><li>Add and Edit Comments</li><li>Prepare a Workbook for Distribution </li><li>Modify Excel's Default Settings</li></ul><h4>Using Macros to Automate Workbook Functionality</h4><ul><li>Create Macros via Recording </li><li>Run Macros via Buttons and Shortcuts</li><li>Assign Macros to the Quick Access Toolbar and Ribbon </li><li>Assign Macros to Objects </li><li>View Macro Code</li></ul><h4>Forecasting and Analysis Data</h4><ul><li>Use Conditional Formatting to Highlight, Sort and Filter Key Data</li><li>Advanced Conditional Formatting using Formulas</li><li>Create Sparklines to Visualise Data</li><li>Add Trendlines to Charts to Visualise and Forecast Trends</li><li>Use Data Tables and Scenarios to Project Potential Outcomes </li><li>Use Goal Seek to Calculate Outcomes</li><li>Forecast Data Trends Using Solver</li></ul></div>

Nexus Human

Office Skills & Productivity

Excel Analytics

Access VBA

Visual Basic Analysis

Microsoft Excel

Microsoft Power Automate

Excel - Automating Excel with Macros and Analysis Tools

<div data-node="61658ba442cd6" style="color: rgb(117, 117, 117); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(117, 117, 117);"><div data-node="61658ba442cd7" fr-original-style="" style="box-sizing: border-box;"><div data-node="61658ba442cd8" fr-original-style="" style="box-sizing: border-box;"><div data-node="61658ba442cd9" data-animation-delay="0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><div data-node="6165945ab79d7" style="color: rgb(117, 117, 117); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(117, 117, 117);"><div data-node="6165945ab79d8" fr-original-style="" style="box-sizing: border-box;"><div data-node="6165945ab79d9" fr-original-style="" style="box-sizing: border-box;"><div data-node="6165945ab79da" data-animation-delay="0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><div data-node="61657d76a40c2" style="color: rgb(117, 117, 117); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(117, 117, 117);"><div data-node="61657d76a40c3" fr-original-style="" style="box-sizing: border-box;"><div data-node="61657d76a40c4" fr-original-style="" style="box-sizing: border-box;"><div data-node="61657d76a40c5" data-animation-delay="0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Digital Electronics Course</span></h3></div><div data-node="618322664d7fd" data-animation-delay="0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Aim</span></h3><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">This <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Digital Electronics Course</strong>&nbsp;is designed to give practical knowledge of the type of electronic circuitry used in a modern Computer System or in any type of Computer Controlled equipment such as Photocopiers, Cash Registers, Tablets, mobile phones and many other types of IT equipment.&nbsp;</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Digital Electronics involves the use of Silicon chips (Integrated Circuits). The internal structure of a computer is to a large extent comprised of Digital Electronic Circuits.</p></div></div><div data-node="618322b7d4864" data-animation-delay="0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Duration and Schedule</span></h3><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">This <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Digital Electronics Course</strong> runs over 10 evenings (every Monday and Wednesday) from 7.00pm to 10.00pm with the next course commencing on&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(255, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(255, 0, 0);">Monday 2nd September 2024 at 7.00 pm</span>.</strong></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(255, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(255, 0, 0);"><b style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">A payment of &pound;65 secures your place on your chosen course.</b><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">&nbsp;The balance of the course fees of &pound;600 can be paid shortly before course commencement.</span></span><br fr-original-style="" style="box-sizing: border-box;"></strong></p></div></div></div></div></div><div data-node="61657d76a40c7" style="color: rgb(117, 117, 117); box-sizing: border-box;" fr-original-style=" color: rgb(117, 117, 117);"><div data-node="61657d76a40c8" fr-original-style="" style="box-sizing: border-box;"><div data-node="61657d76a40c9" fr-original-style="" style="box-sizing: border-box;"><div data-node="6183230b58256" data-animation-delay="0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Online Virtual Classroom &ndash; how it works?</span></h3><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">The course will be delivered through 9 online virtual classroom sessions. The 10th and last session will involve the additional practical work for the course as well as the written examination (multiple choice for City &amp; Guilds and written for Hi-Tech Training) which will take place at our training centre at 43 North Great Georges Street, Dublin 1 (completed online for non ROI learners).</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">During the virtual classroom sessions, trainees will have a live video feed with their instructor talking to them, doing practical live demonstrations on equipment being involved actively in the learning.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">We will send out a practical kit so that trainees can complete assignments and practical work at home. The kit is the property of Hi-Tech Training and will be returned to Hi-Tech Training on the last day of the course.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">(The kits may also be purchased by the learner&hellip;.see the&nbsp;<a href="http://hitechtraining.ie/product-category/electronics-courses/digital-electronics-course/" target="_blank" rel="noopener" style="color: rgb(209, 33, 56); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(209, 33, 56);">Kits Page Link</a>&nbsp;for more details).<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">The kit consists of power supply unit breadboard, multimeter, cables, The kit consists of breadboard, multimeter, oscilloscope, battery and connectors, components including resistors, LEDs and ICs (AND, NAND, OR, NOR, X-OR, X-NOR, Inverter, Buffer, Latches, Flip-Flops, Timers, etc). Trainees will build various projects as part of the course. The kit forms an integral part of the course, so full course fees need to be paid at least 7 days prior to course commencement to allow time to ship the kit in time for the course.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">* If attending the course from outside of Ireland the course practical training kit must be purchased via our online shop in time for delivery before course commencement. The equipment will then remain the property of the trainee.</strong></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">In preparation for each course, we have a quick informal free 1 hr online meeting approx. 7 days prior to course commencement, to make sure that trainees get connected through Zoom properly, let them know what the virtual classroom will be like and go through any questions they may have. To join the virtual sessions, you will need a PC/Laptop or Tablet with an internet connection. Joining instructions (login IDs, etc.) will be sent before the Informal Induction session.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></p></div></div><div data-node="61657d76a40d2" data-animation-delay="0.0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Learning Objectives</span></h3><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">This course equips participants with practical &ldquo;Hands-on&rdquo; skills relevant to the workplace and the theory required for certification. Participants can expect to have the skills to:&nbsp;</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Build and fault-finding a range of Digital Electronic circuits used in computers and computer-controlled equipment</li><li fr-original-style="" style="box-sizing: border-box;">Use test equipment including Multimeters, Oscilloscopes, logic probes and pulsers to implement systematic fault-finding techniques.</li><li fr-original-style="" style="box-sizing: border-box;">Study and use of popular Digital Electronic gates and more advanced circuits</li></ul></div></div><div data-node="61657d76a40d7" data-animation-delay="0.0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Course Content</span></h3><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Introduction to Electronics: &ndash; Electric Current, OHMS Law, Insulation, Conduction and related Formulae. Resistor colour codes.</li><li fr-original-style="" style="box-sizing: border-box;">Practical study of Digital I.C.s including AND, NAND, OR, NOR, X-OR, X-NOR, Inverter, Buffer, SR Latches and D-Latches and Flip-Flops.</li><li fr-original-style="" style="box-sizing: border-box;">Oscillators, Multivibrators and 555 Timers. Switches and Switch De-bounce circuits and their applications.</li><li fr-original-style="" style="box-sizing: border-box;">Numbering systems, TTL and CMOS technologies</li><li fr-original-style="" style="box-sizing: border-box;">Counters, Counter Decoding Circuitry, Shift Registers</li><li fr-original-style="" style="box-sizing: border-box;">A-D and D-A converters</li><li fr-original-style="" style="box-sizing: border-box;">Digital Displays: &ndash; LED and LCD, numeric and alphanumeric, operating currents, voltages and power requirements. Display decoders and drivers.</li><li fr-original-style="" style="box-sizing: border-box;">Test Equipment: &ndash; Practical use of Analogue and Digital Multimeters, Oscilloscopes, Logic probes, Logic Pulsers, etc.</li><li fr-original-style="" style="box-sizing: border-box;">Fault-finding techniques: &ndash; Diagnosing and rectifying faults on circuits built during course.</li><li fr-original-style="" style="box-sizing: border-box;">Health &amp; Safety, Care of Tools and instruments for assembly and repair</li></ul></div></div></div></div></div><div data-node="61657d76a40d3" style="color: rgb(117, 117, 117); box-sizing: border-box;" fr-original-style=" color: rgb(117, 117, 117);"><div data-node="61657d76a40d4" fr-original-style="" style="box-sizing: border-box;"><div data-node="61657d76a40d5" fr-original-style="" style="box-sizing: border-box;"><div data-node="61657d76a40d6" data-animation-delay="0.0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Certification</span></h3><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds of London Institute Digital Electronics 2 (Examination No. 7267-425). This examination consists of 1 written paper and 4 practical assignments. The qualification can be used as part of the requirement for <a title="City & Guilds Diploma in IT Systems Support" href="http://hitechtraining.ie/city-guilds-certification/" style="color: rgb(209, 33, 56); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(209, 33, 56);">City &amp; Guilds Diploma in IT Systems Support (7267-24).</a></li><li fr-original-style="" style="box-sizing: border-box;">On completion of the Course, having been successful in an examination, the participant will receive a Hi-Tech Training Certificate.</li></ul></div></div><div data-node="61657d76a40d8" data-animation-delay="0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><img width="794" height="602" src="http://hitechtraining.ie/wp-content/uploads/2022/02/Hi-Tech-City-Guilds-Diploma-in-IT-Systems-Support-7267-24.png" alt="Hi Tech - City & Guilds Diploma in IT Systems Support (7267-24)" itemprop="image" srcset="https://hitechtraining.ie/wp-content/uploads/2022/02/Hi-Tech-City-Guilds-Diploma-in-IT-Systems-Support-7267-24.png 794w, https://hitechtraining.ie/wp-content/uploads/2022/02/Hi-Tech-City-Guilds-Diploma-in-IT-Systems-Support-7267-24-300x227.png 300w, https://hitechtraining.ie/wp-content/uploads/2022/02/Hi-Tech-City-Guilds-Diploma-in-IT-Systems-Support-7267-24-768x582.png 768w, https://hitechtraining.ie/wp-content/uploads/2022/02/Hi-Tech-City-Guilds-Diploma-in-IT-Systems-Support-7267-24-600x455.png 600w, https://hitechtraining.ie/wp-content/uploads/2022/02/Hi-Tech-City-Guilds-Diploma-in-IT-Systems-Support-7267-24-64x49.png 64w" sizes="(max-width: 794px) 100vw, 794px" title="Hi Tech - City & Guilds Diploma in IT Systems Support (7267-24)" fr-original-style="" style="cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-class="fr-draggable"></div></div></div></div></div></div></div></div></div></div></div></div><div data-node="61658ba442ce7" style="color: rgb(117, 117, 117); box-sizing: border-box;" fr-original-style=" color: rgb(117, 117, 117);"><div data-node="61658ba442ce8" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div></div>

Hi-Tech Training

City & Guilds

Electronics

Digital Design

Electrical Engineering

Analog Electronics

Computer Engineering

Digital Skills

Online Education

This Digital Electronics Course is designed to give practical knowledge of the type of electronic circuitry used in a modern Computer System or in any type of Computer Controlled equipment such as Photocopiers, Cash Registers, Tablets, mobile phones and many other types of IT equipment. 

Digital Electronics involves the use of Silicon chips (Integrated Circuits). The internal structure of a computer is to a large extent comprised of Digital Electronic Circuits.

Digital Electronics Course Online

Deposit Only

Full Price (including Deposit)

<h2 id="isPasted" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This advanced financial modelling course will benefit Real Estate Professionals looking to develop their financial modelling skills to the next level. This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course you will...</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Understand how the application and use of Structured Finance products in Real Estate</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Learn how to introduce several tranches of debt in a development project</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Understand how to model different parties to a project</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Create Joint Venture structures between Developers, Lenders and Equity Partners</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Learn advanced modelling techniques to analyse underlying asset risk</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Understand how underlying asset risk impacts return to all parties to a project</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Real Estate professionals from a mid to senior level with exposure to Real Estate financial models</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts who would like to advance their financial modelling skills in areas such as development, portfolio analysis, and risk analysis</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Real Estate Investors who would like to expand their knowledge and understanding of Real Estate cash flow models to an advanced level</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outline</strong></strong>:</p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Mezzanine debt modelling</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Joint Venture structures between developers and lender/equity partners</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Promote and profit share structure calculations</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Advanced project cash flows with mezzanine debts</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Key Real Estate and investment risks, risk adjustment of exit yields</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Sensitivity and Scenario Analysis</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Monte Carlo Analysis</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Course Files</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the Real Estate Modelling Masterclass such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a></p>



This advanced financial modelling course will benefit Real Estate Professionals looking to develop their financial modelling skills to the next level. This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models.


On this course you will...
Understand how the application and use of Structured Finance products in Real Estate
Learn how to introduce several tranches of debt in a development project
Understand how to model different parties to a project
Create Joint Venture structures between Developers, Lenders and Equity Partners
Learn advanced modelling techniques to analyse underlying asset risk
Understand how underlying asset risk impacts return to all parties to a project


Who will benefit from this course?
Real Estate professionals from a mid to senior level with exposure to Real Estate financial models
Mid-level to senior Real Estate Analysts who would like to advance their financial modelling skills in areas such as development, portfolio analysis, and risk analysis
Real Estate Investors who would like to expand their knowledge and understanding of Real Estate cash flow models to an advanced level


Course Outline:
Mezzanine debt modelling
Joint Venture structures between developers and lender/equity partners
Promote and profit share structure calculations
Advanced project cash flows with mezzanine debts
Key Real Estate and investment risks, risk adjustment of exit yields
Sensitivity and Scenario Analysis
Monte Carlo Analysis


Included in the Course
CPD Accredited Certificate & LinkedIn Proficiency Badge
Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee
Course Files
Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee


For more information about the Real Estate Modelling Masterclass such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Bayfield Training

Financial Modelling & Analysis

Real Estate Finance

Financial Modelling

Investment Management

Continuous Professional Development (CPD)

This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models.

Real Estate Modelling Masterclass (Advanced Cash Flow Modelling)

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Investments are unique in that they generate both rental income and capital appreciation, making cash flow modelling an essential tool for Real Estate Investors, Lenders, and Analysts.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">On this course, we will use case studies to enhance the delegates understanding of Real Estate financial appraisals, and help them fully appreciate the theory behind the numbers. We will cover topics such as discounting, compounding, forecasting rental income and expenses, calculating net operating income (NOI), factoring in capital expenditures, modelling debt service, and determining the internal rate of return (IRR).</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">This course will provide you with a solid foundation for understanding and analysing real estate cash flows.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course you will...</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Study the financial concepts of compounding, discounting and in-perpetuity</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Consider the importance of the timing and uncertainty of both fixed and growing income streams</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Contrast different property yield metrics</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Build-up risk premiums for discount rates, discuss the importance of liquidity, transparency and volatility</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Compare and contrast time and money-weighted measures of return</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn about valuation principles</li><li value="7" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Contrast value and worth</li><li value="8" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Discuss the importance and sourcing of inputs and outputs</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Professional Real Estate Transaction Managers</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Asset Managers</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Portfolio Managers</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Recent graduates with exposure to real estate financial modelling</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">New employees with exposure to real estate financial modelling</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">People working in Argus, Anaplan or any commercial real estate software and would like to understand financial modelling key principles.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outline</strong>:</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Morning</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Financial Mathematics</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Time Value of Money</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Net Present Value (NPV)</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Internal Rate of Return (IRR)</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Growth</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">What Discount Rate?</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Certainty of a cash flow</li><li value="7" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Liquidity</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Price, Value and Worth</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Comparing Price, Value and Worth</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Conventional Valuation Methods</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Term and Reversion, Layer Method</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Property Yields and Capitalisation Method</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Exit calculations across Europe</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Afternoon</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Discounted Cash Flow Models</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Investment Appraisal Models</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Cash flow inputs: Rents, Yields, Growth Rates, Target Returns</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Cash-on-Cash and Equity Multiple</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Discount Rates &amp; Exit Cap Rate</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Operating Assumptions</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Adding borrowing and analysing geared returns</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Model Interpretation and Analysis</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Sensitivity analysis and scenario analysis</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Growth and inflation</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Performance measures</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Contemporary issues for analysis (such as the rise in interest rates)</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Quizzes | Q&amp;A</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">A Bayfield Training Certificate &amp; 7.5 CPD Hours</li><li value="2" style="font-size: 16px; box-sizing: border-box;" id="isPasted" fr-original-style="font-size: 16px;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Course Files</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the Understanding Key Principles of Real Estate Financial Modelling such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a></p>



Real Estate Investments are unique in that they generate both rental income and capital appreciation, making cash flow modelling an essential tool for Real Estate Investors, Lenders, and Analysts.
On this course, we will use case studies to enhance the delegates understanding of Real Estate financial appraisals, and help them fully appreciate the theory behind the numbers. We will cover topics such as discounting, compounding, forecasting rental income and expenses, calculating net operating income (NOI), factoring in capital expenditures, modelling debt service, and determining the internal rate of return (IRR).
This course will provide you with a solid foundation for understanding and analysing real estate cash flows.


On this course you will...
Study the financial concepts of compounding, discounting and in-perpetuity
Consider the importance of the timing and uncertainty of both fixed and growing income streams
Contrast different property yield metrics
Build-up risk premiums for discount rates, discuss the importance of liquidity, transparency and volatility
Compare and contrast time and money-weighted measures of return
Learn about valuation principles
Contrast value and worth
Discuss the importance and sourcing of inputs and outputs


Who will benefit from this course?
Professional Real Estate Transaction Managers
Asset Managers
Portfolio Managers
Recent graduates with exposure to real estate financial modelling
New employees with exposure to real estate financial modelling
People working in Argus, Anaplan or any commercial real estate software and would like to understand financial modelling key principles.


Course Outline:
Morning
Real Estate Financial Mathematics
Time Value of Money
Net Present Value (NPV)
Internal Rate of Return (IRR)
Growth
What Discount Rate?
Certainty of a cash flow
Liquidity
Price, Value and Worth
Comparing Price, Value and Worth
Conventional Valuation Methods
Term and Reversion, Layer Method
Property Yields and Capitalisation Method
Exit calculations across Europe


Afternoon
Discounted Cash Flow Models
Investment Appraisal Models
Cash flow inputs: Rents, Yields, Growth Rates, Target Returns
Cash-on-Cash and Equity Multiple
Discount Rates & Exit Cap Rate
Operating Assumptions
Adding borrowing and analysing geared returns
Model Interpretation and Analysis
Sensitivity analysis and scenario analysis
Growth and inflation
Performance measures
Contemporary issues for analysis (such as the rise in interest rates)


Quizzes | Q&A


Included in the Course
A Bayfield Training Certificate & 7.5 CPD Hours
Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee
Course Files
Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee


For more information about the Understanding Key Principles of Real Estate Financial Modelling such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Property Investment

Risk Management

Investment

Financial Risk Management

On this course, we will use case studies to enhance the delegates understanding of Real Estate financial appraisals, and help them fully appreciate the theory behind the numbers. 

Understanding Key Principles of Real Estate Modelling (Advanced Theoretical Course)

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>Candidates for this exam are users who aspire to improve productivity by automating business processes, analyzing data to produce business insights, and acting more effectively by creating simple app experiences.</p>Overview<p>After completing this course, you will be able to:<br />Describe Microsoft Power Platform components<br />Describe Microsoft Dataverse and connectors<br />Describe cross-cloud scenarios across M365, Dynamics 365, Microsoft Azure and 3rd party services<br />Identify benefits and capabilities of Microsoft Power Platform<br />Identify the basic functionality and business value Microsoft Power Platform components<br />Implement simple solutions with Power Apps, Power Automate, and Power BI</p><p>Learn the business value and product capabilities of Microsoft Power Platform. Create simple Power Apps, connect data with Dataverse, build a Power BI Dashboard, and automate processes with Power Automate. </p></div><div id="course-pills-2"><h4>Module 1: Introduction to Microsoft Power Platform</h4><ul><li>Identify when to use each Microsoft Power Platform component application to create business solution</li><li>Learn the value of using Microsoft Power Platform to create business solutions</li><li>Learn the components and features of Microsoft Power Platform</li></ul><h4>Module 2: Introduction to Microsoft Dataverse</h4><ul><li>Microsoft Dataverse Overview</li></ul><h4>Module 3: Get Started with Power Apps</h4><ul><li>Introduction to Power Apps</li><li>How to build a canvas app</li><li>How to build a model-driven app</li></ul><h4>Module 4: Get Started with Power Automate</h4><ul><li>Power Automate Overview</li><li>How to Build an Automated Solution</li></ul><h4>Module 5: Get Started with Power BI</h4><ul><li>Power BI Overview</li><li>How to Build a Simple Dashboard</li></ul><h4>Module 6: Introduction to Power Virtual Agents</h4><ul><li>Power Virtual Agents overview</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans PL-900T00 Microsoft Power Platform 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 PL-900T00 Microsoft Power Platform 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>

Microsoft PL-900

Microsoft Power Apps

Microsoft AZ-900

Microsoft Power Platform

Microsoft AZ-303

Microsoft AZ-700

PL-900T00 Microsoft Power Platform Fundamentals

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>Collaboration Communications Systems Engineers are responsible for planning, deploying, configuring, maintaining, and troubleshooting Microsoft Teams Phone, meetings, and personal and shared space devices, including Microsoft Teams Rooms and Surface Hub.</p> <p>Collaboration Communications Systems Engineers have a fundamental understanding ofÃ¿networking, telecommunications, audio/visual and meeting room technologies, identity and access management.</p> <p>They are proficient in managing and monitoring Teams Phone, meetings, and certified devices using the Microsoft Teams admin center, PowerShell, the Microsoft Teams Rooms Pro Portal, and the Call Quality Dashboard. They deploy and configure Microsoft Teams Phone with PSTN connectivity through Microsoft Calling Plans, Operator Connect, Teams Phone Mobile, and Direct Routing.</p> <p>Collaboration Communications Systems Engineers work with Teams Administrators, Microsoft Identity and Access Administrators, and Microsoft 365Ã¿Administrators. In addition, they may work with owners of other workloads, including facilitiesÃ¿managers, network engineers, security engineers, device manufacturers, telephony providers, and Microsoft Certified solutions providers.</p><p></p><p></p><p>This training course is designed to give participants the knowledge and skills to become a Collaboration Communications Systems Engineer. Participants should understand the fundamentals of networking, telecommunications, audio/visual and meeting room technologies, identity and access management, and Microsoft Teams.</p> <p>They will gain hands-on experience configuring and deploying Microsoft Teams Phone, meetings and certified devices including Microsoft Teams Rooms and Surface Hub. The course will also cover how to manage and monitor Teams Phone, meetings, and certified devices using the Microsoft Teams admin center, PowerShell, the Microsoft Teams Rooms Pro Portal, and the Call Quality Dashboard.</p> <p>In addition, the course will cover configuring and deploying Microsoft Teams Phone with PSTN connectivity through Microsoft Calling Plans, Operator Connect, Teams Phone Mobile, and Direct Routing.</p><p></p>Prerequisites<p></p><ul> <li>Microsoft 365 and Microsoft Teams</li> <li>Networking, telecommunications, and audio/visual basics</li> <li>Identity and access management basics</li> </ul><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Teams meetings and calling</h3> <ul> <li>Overview of Teams meetings and events</li> <li>Overview of Teams Phone</li> <li>Overview of auto attendants and call queues</li> <li>Overview of Teams devices</li> </ul> <h3>2 - Plan for Teams Phone</h3> <ul> <li>Plan to deploy Teams Phone</li> <li>Plan for Teams Phone PSTN connectivity</li> <li>Determine license requirements</li> <li>Plan for Teams Phone devices</li> <li>Plan and design Teams Phone features</li> <li>Plan for voicemail</li> </ul> <h3>3 - Plan for Microsoft Teams Rooms and Surface Hub</h3> <ul> <li>Determine license requirements for Microsoft Teams Rooms and shared devices</li> <li>Understand differences between Microsoft Teams Rooms on Android and Windows</li> <li>Understand Microsoft Teams Rooms on Surface Hub 2S</li> <li>Understand and plan Teams Room accessories, components, and peripherals</li> <li>Understand Teams Rooms management options</li> </ul> <h3>4 - Plan and optimize network performance for Teams media</h3> <ul> <li>Understand Teams network requirements</li> <li>Design network for media optimization</li> <li>Design and implement QoS</li> </ul> <h3>5 - Configure and deploy Teams Phone</h3> <ul> <li>Configure emergency calling for Teams Calling Plans</li> <li>Manage and configure Microsoft PSTN numbers</li> <li>Configure Operator Connect and Teams Phone Mobile</li> <li>Configure Teams Phone policies</li> <li>Create and manage Teams policies</li> <li>Configure Audio Conferencing</li> </ul> <h3>6 - Configure and deploy Teams Phone with Direct Routing</h3> <ul> <li>Design Direct Routing call flows</li> <li>Implement SIP trunking with Direct Routing</li> <li>Configure Emergency Calling for Direct Routing</li> <li>Extend Teams Direct Routing infrastructure</li> <li>Deploy and maintain a survivable branch appliance</li> </ul> <h3>7 - Extend Teams Phone with additional services</h3> <ul> <li>Understand how Teams interacts with additional services</li> <li>Configure compliance recording in Teams</li> <li>Configure and integrate a certified contact center in Teams</li> <li>Design and deploy voice bots in Teams</li> </ul> <h3>8 - Manage meetings and events experiences</h3> <ul> <li>Explore meetings and events in Microsoft Teams</li> <li>Configure meeting settings</li> <li>Create and manage meeting policies</li> <li>Configure audio conferencing</li> <li>Create and manage meeting templates and template policies</li> <li>Create and manage meetings customization policies</li> <li>Configure live events settings</li> <li>Create and manage live events policies</li> <li>Examine live events across Microsoft 365</li> </ul> <h3>9 - Guided project - Create and assign Teams policies to meet business requirements in Microsoft Teams</h3> <ul> <li>Prepare</li> </ul> <h3>10 - Configure and manage voice users</h3> <ul> <li>Enable users for Teams Phone</li> <li>Enable users for Direct Routing with Teams Phone</li> <li>Enable additional calling features for Teams Phone</li> <li>Enable users for Teams Phone Mobile</li> </ul> <h3>11 - Configure auto attendants and call queues</h3> <ul> <li>Design call flows for auto attendants and call queues</li> <li>Configure auto attendants and call queues</li> <li>Deploy a channel-based call queue</li> <li>Configure resource accounts</li> <li>Configure Microsoft 365 groups for voicemail</li> <li>Interpret call queue conference modes</li> <li>Interpret call queue routing methods</li> <li>Configure holidays for auto attendants and call queues</li> <li>Configure custom music on hold</li> </ul> <h3>12 - Configure, deploy, and manage Teams devices</h3> <ul> <li>Manage Microsoft Teams Phones</li> <li>Manage Microsoft Teams Room Systems</li> <li>Microsoft Teams Rooms management options</li> <li>Manage Surface Hub 2S devices</li> <li>Configure Microsoft Teams SIP gateway</li> <li>Manage Microsoft Teams displays</li> <li>Remote provisioning and sign in for Teams Phones</li> <li>Update Microsoft Teams devices remotely</li> <li>Manage Microsoft Teams device tags</li> </ul> <h3>13 - Guided project - Prepare meeting room experiences</h3> <ul> <li>Prepare</li> </ul> <h3>14 - Monitor and troubleshoot Teams collaboration communications systems</h3> <ul> <li>Diagnose and troubleshoot phone number assignment</li> <li>Diagnose and troubleshoot Teams client issues</li> <li>Diagnose and troubleshoot call failure and call quality issues</li> <li>Report on and troubleshoot Teams calls with Call Quality Dashboard</li> <li>Diagnose and troubleshoot Direct Routing issues</li> <li>Troubleshoot and monitor Teams devices</li> <li>Troubleshoot Teams meetings and calling</li> <li>Troubleshoot Teams Rooms devices</li> </ul></div>

Microsoft Teams

Microsoft Certification

Microsoft Certified Trainer (MCT)

Clinical Engineer

MS-721T00 Collaboration Communications Systems Engineer

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is designed for Administrators who need to setup, configure and manage SharePoint Online as part of their Office 365 Administration.</p>Overview<p>After completing this course, students will gain the skills to:  - Understand the architecture of SharePoint Online  - Have knowledge of all the components in SharePoint Online  - Have on hands on experience configuring the components of SharePoint Online  - Have hands on experience configuring the options  - Work with Site Collections and storage options  - Manage user profiles and social profiling  - Understand and configure data connectivity in SharePoint Online  - Build a taxonomy structure   - Understand and configure Search in SharePoint Online  - Configure and deploy apps  - Understand and define Enterprise content management and data loss prevention.  - Configure additional options and features in SharePoint Online such as Information Rights Management</p><p>This course will introduce the audience to SharePoint Online Administration in Office 365 and explain and demonstrate the configuration options for SharePoint Online. The course is appropriate for existing SharePoint on-premises administrators and new administrators to Office 365 who need to understand how to correctly setup SharePoint Online for their company. The course will also help SharePoint on-premise administrators understand the differences between SharePoint on-premises and SharePoint Online.</p></div><div id="course-pills-2"><h3>1 - INTRODUCTION TO OFFICE 365 AND SHAREPOINT ONLINE</h3> <ul> <li>Introduction to the Office 365 Administration Center</li> <li>Configure Reporting</li> <li>Accessing SharePoint management tools</li> <li>Accessing security and compliancy</li> <li>Managing Office 365 and SharePoint Online with PowerShell</li> <li>Comparing On Premises SharePoint with SharePoint Online</li> <li>User identity in Office 365 and SharePoint Online</li> <li>Manging user domains</li> <li>Building Hybrid scenarios</li> <li>OneDrive and Sites redirection</li> <li>Yammer redirection</li> <li>Understand hybrid search</li> <li>Hybrid business data connectivity</li> <li>Hybrid taxonomy</li> </ul> <h3>2 - WORKING WITH SITE COLLECTIONS</h3> <ul> <li>Introduction to classic and modern admin centers</li> <li>Creating Site Collections</li> <li>Defining ownership and security for site collections</li> <li>Configuring Storage</li> <li>Configure External Access to site collections</li> <li>Recovering site collections</li> <li>Configure external sharing</li> <li>Managing site collections with PowerShell</li> </ul> <h3>3 - MANAGING USER PROFILES</h3> <ul> <li>Overview of the profile service</li> <li>Defining profile properties</li> <li>Map profile properties to a term store</li> <li>Creating custom profile properties</li> <li>Managing audiences</li> <li>Creating audiences</li> <li>Managing user profile policies</li> <li>Configure trusted my site host locations</li> <li>Configure preferred search center locations</li> <li>Defining read access permission levels</li> <li>Configuring newsfeed options</li> <li>Setup email notifications</li> <li>Configure my site cleanup</li> </ul> <h3>4 - WORKING WITH DATA CONNECTIONS</h3> <ul> <li>Introduction to Data Connections</li> <li>Overview of PowerApps, Flow and PowerBi</li> <li>Overview of the business connectivity service</li> <li>Introduction to BDC definition files</li> <li>Creating BDC definition files</li> <li>Introduction to the secure store service</li> <li>Configuring the secure store service</li> <li>Creating secure store target application settings</li> <li>Configure connections to cloud services</li> <li>Configure connections to on-premises services</li> <li>Tools to build data connections</li> <li>Creating external content types</li> <li>Building external lists using external data</li> </ul> <h3>5 - MANAGING THE TERM STORE</h3> <ul> <li>Overview of the term store</li> <li>Understanding terms and life cycle management</li> <li>Creating term groups</li> <li>Creating the term store</li> <li>Creating Term Sets in the UI</li> <li>Creating Term Sets via importing via a CSV</li> <li>Creating terms in the UI</li> <li>Creating terms via PowerShell and CSOM</li> <li>Manage terms with synonyms and pinning</li> <li>Configure delegated administration</li> </ul> <h3>6 - CONFIGURING SEARCH</h3> <ul> <li>An Introduction to the search service</li> <li>Classic versus Modern search experience</li> <li>Understanding Managed Properties</li> <li>Create Managed Properties</li> <li>Manage Authoritative pages</li> <li>Understand Result sources</li> <li>Create and configure result sources</li> <li>Understand Query rules</li> <li>Promoting results through query rules</li> <li>Remove search results from the index</li> <li>Exporting search configurations</li> <li>Importing search configurations</li> </ul> <h3>7 - CONFIGURING APPS</h3> <ul> <li>An Introduction to Apps</li> <li>Understanding the App Catalog</li> <li>Building the App catalog</li> <li>Adding Apps to the catalog</li> <li>Add Apps to your SharePoint sites</li> <li>Adding Apps via the marketplace store</li> <li>Manage App licensing</li> <li>Configure store access settings</li> <li>Monitoring app usage</li> </ul> <h3>8 - ENTERPRISE CONTENT MANAGEMENT IN SHAREPOINT ONLINE</h3> <ul> <li>An Introduction to ECM in SharePoint Online</li> <li>Components of ECM</li> <li>Office 365 versus classic compliancy</li> <li>Understanding In-Place records management</li> <li>Configure In-Place records management</li> <li>Understanding the records center</li> <li>Build and configure a records center</li> <li>Understanding the compliancy policy center</li> <li>Build a compliancy policy center and configure policies</li> <li>Discover the security and compliancy center</li> <li>Configure an eDiscovery center</li> <li>Build an eDiscovery case</li> <li>Understand data loss prevention</li> <li>Build a data loss prevention policy and query</li> <li>Working with classification and data governance</li> </ul> <h3>9 - MANAGE OPTIONS FOR SHAREPOINT ONLINE</h3> <ul> <li>Configure OneDrive features</li> <li>Configure use of Yammer or Newsfeeds</li> <li>Understand Information Rights Management</li> <li>Configure Information Rights Management</li> <li>Define site classification options</li> <li>Understand early release options for Office 365</li> <li>Configure Early release options for your Office 365 tenant</li> <li>Manage Access Control</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55238 SharePoint Online for Administrators 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 55238 SharePoint Online for Administrators 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 Sharepoint

Microsoft 365

Microsoft AZ-104

SharePoint

55238 SharePoint Online for Administrators

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>The Microsoft Security Operations Analyst collaborates with organizational stakeholders to secure information technology systems for the organization. Their goal is to reduce organizational risk by rapidly remediating active attacks in the environment, advising on improvements to threat protection practices, and referring violations of organizational policies to appropriate stakeholders. Responsibilities include threat management, monitoring, and response by using a variety of security solutions across their environment. The role primarily investigates, responds to, and hunts for threats using Microsoft Sentinel, Microsoft Defender for Cloud, Microsoft 365 Defender, and third-party security products. Since the Security Operations Analyst consumes the operational output of these tools, they are also a critical stakeholder in the configuration and deployment of these technologies.</p><p></p><p></p><p>Learn how to investigate, respond to, and hunt for threats using Microsoft Sentinel, Microsoft Defender for Cloud, and Microsoft 365 Defender. In this course you will learn how to mitigate cyberthreats using these technologies. Specifically, you will configure and use Microsoft Sentinel as well as utilize Kusto Query Language (KQL) to perform detection, analysis, and reporting. The course was designed for people who work in a Security Operations job role and helps learners prepare for the exam SC-200: Microsoft Security Operations Analyst.</p><p></p>Prerequisites<p></p><li>Basic understanding of Microsoft 365</li>  <li>Fundamental understanding of Microsoft security, compliance, and identity products</li>   <li> Intermediate understanding of Windows 10</li>  <li> Familiarity with Azure services, specifically Azure SQL Database and Azure Storage</li>   <li> Familiarity with Azure virtual machines and virtual networking</li>   <li>Basic understanding of scripting concepts.</li><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Microsoft 365 threat protection</h3> <ul> <li>Explore Extended Detection &amp; Response (XDR) response use cases</li> <li>Understand Microsoft Defender XDR in a Security Operations Center (SOC)</li> <li>Explore Microsoft Security Graph</li> <li>Investigate security incidents in Microsoft Defender XDR</li> </ul> <h3>2 - Mitigate incidents using Microsoft 365 Defender</h3> <ul> <li>Use the Microsoft Defender portal</li> <li>Manage incidents</li> <li>Investigate incidents</li> <li>Manage and investigate alerts</li> <li>Manage automated investigations</li> <li>Use the action center</li> <li>Explore advanced hunting</li> <li>Investigate Microsoft Entra sign-in logs</li> <li>Understand Microsoft Secure Score</li> <li>Analyze threat analytics</li> <li>Analyze reports</li> <li>Configure the Microsoft Defender portal</li> </ul> <h3>3 - Protect your identities with Microsoft Entra ID Protection</h3> <ul> <li>Microsoft Entra ID Protection overview</li> <li>Detect risks with Microsoft Entra ID Protection policies</li> <li>Investigate and remediate risks detected by Microsoft Entra ID Protection</li> </ul> <h3>4 - Remediate risks with Microsoft Defender for Office 365</h3> <ul> <li>Automate, investigate, and remediate</li> <li>Configure, protect, and detect</li> <li>Simulate attacks</li> </ul> <h3>5 - Safeguard your environment with Microsoft Defender for Identity</h3> <ul> <li>Configure Microsoft Defender for Identity sensors</li> <li>Review compromised accounts or data</li> <li>Integrate with other Microsoft tools</li> </ul> <h3>6 - Secure your cloud apps and services with Microsoft Defender for Cloud Apps</h3> <ul> <li>Understand the Defender for Cloud Apps Framework</li> <li>Explore your cloud apps with Cloud Discovery</li> <li>Protect your data and apps with Conditional Access App Control</li> <li>Walk through discovery and access control with Microsoft Defender for Cloud Apps</li> <li>Classify and protect sensitive information</li> <li>Detect Threats</li> </ul> <h3>7 - Respond to data loss prevention alerts using Microsoft 365</h3> <ul> <li>Describe data loss prevention alerts</li> <li>Investigate data loss prevention alerts in Microsoft Purview</li> <li>Investigate data loss prevention alerts in Microsoft Defender for Cloud Apps</li> </ul> <h3>8 - Manage insider risk in Microsoft Purview</h3> <ul> <li>Insider risk management overview</li> <li>Create and manage insider risk policies</li> <li>Investigate insider risk alerts</li> <li>Take action on insider risk alerts through cases</li> <li>Manage insider risk management forensic evidence</li> <li>Create insider risk management notice templates</li> </ul> <h3>9 - Investigate threats by using audit features in Microsoft Defender XDR and Microsoft Purview Standard</h3> <ul> <li>Explore Microsoft Purview Audit solutions</li> <li>Implement Microsoft Purview Audit (Standard)</li> <li>Start recording activity in the Unified Audit Log</li> <li>Search the Unified Audit Log (UAL)</li> <li>Export, configure, and view audit log records</li> <li>Use audit log searching to investigate common support issues</li> </ul> <h3>10 - Investigate threats using audit in Microsoft Defender XDR and Microsoft Purview (Premium)</h3> <ul> <li>Explore Microsoft Purview Audit (Premium)</li> <li>Implement Microsoft Purview Audit (Premium)</li> <li>Manage audit log retention policies</li> <li>Investigate compromised email accounts using Purview Audit (Premium)</li> </ul> <h3>11 - Investigate threats with Content search in Microsoft Purview</h3> <ul> <li>Explore Microsoft Purview eDiscovery solutions</li> <li>Create a content search</li> <li>View the search results and statistics</li> <li>Export the search results and search report</li> <li>Configure search permissions filtering</li> <li>Search for and delete email messages</li> </ul> <h3>12 - Protect against threats with Microsoft Defender for Endpoint</h3> <ul> <li>Practice security administration</li> <li>Hunt threats within your network</li> </ul> <h3>13 - Deploy the Microsoft Defender for Endpoint environment</h3> <ul> <li>Create your environment</li> <li>Understand operating systems compatibility and features</li> <li>Onboard devices</li> <li>Manage access</li> <li>Create and manage roles for role-based access control</li> <li>Configure device groups</li> <li>Configure environment advanced features</li> </ul> <h3>14 - Implement Windows security enhancements with Microsoft Defender for Endpoint</h3> <ul> <li>Understand attack surface reduction</li> <li>Enable attack surface reduction rules</li> </ul> <h3>15 - Perform device investigations in Microsoft Defender for Endpoint</h3> <ul> <li>Use the device inventory list</li> <li>Investigate the device</li> <li>Use behavioral blocking</li> <li>Detect devices with device discovery</li> </ul> <h3>16 - Perform actions on a device using Microsoft Defender for Endpoint</h3> <ul> <li>Explain device actions</li> <li>Run Microsoft Defender antivirus scan on devices</li> <li>Collect investigation package from devices</li> <li>Initiate live response session</li> </ul> <h3>17 - Perform evidence and entities investigations using Microsoft Defender for Endpoint</h3> <ul> <li>Investigate a file</li> <li>Investigate a user account</li> <li>Investigate an IP address</li> <li>Investigate a domain</li> </ul> <h3>18 - Configure and manage automation using Microsoft Defender for Endpoint</h3> <ul> <li>Configure advanced features</li> <li>Manage automation upload and folder settings</li> <li>Configure automated investigation and remediation capabilities</li> <li>Block at risk devices</li> </ul> <h3>19 - Configure for alerts and detections in Microsoft Defender for Endpoint</h3> <ul> <li>Configure advanced features</li> <li>Configure alert notifications</li> <li>Manage alert suppression</li> <li>Manage indicators</li> </ul> <h3>20 - Utilize Vulnerability Management in Microsoft Defender for Endpoint</h3> <ul> <li>Understand vulnerability management</li> <li>Explore vulnerabilities on your devices</li> <li>Manage remediation</li> </ul> <h3>21 - Plan for cloud workload protections using Microsoft Defender for Cloud</h3> <ul> <li>Explain Microsoft Defender for Cloud</li> <li>Describe Microsoft Defender for Cloud workload protections</li> <li>Enable Microsoft Defender for Cloud</li> </ul> <h3>22 - Connect Azure assets to Microsoft Defender for Cloud</h3> <ul> <li>Explore and manage your resources with asset inventory</li> <li>Configure auto provisioning</li> <li>Manual log analytics agent provisioning</li> </ul> <h3>23 - Connect non-Azure resources to Microsoft Defender for Cloud</h3> <ul> <li>Protect non-Azure resources</li> <li>Connect non-Azure machines</li> <li>Connect your AWS accounts</li> <li>Connect your GCP accounts</li> </ul> <h3>24 - Manage your cloud security posture management?</h3> <ul> <li>Explore Secure Score</li> <li>Explore Recommendations</li> <li>Measure and enforce regulatory compliance</li> <li>Understand Workbooks</li> </ul> <h3>25 - Explain cloud workload protections in Microsoft Defender for Cloud</h3> <ul> <li>Understand Microsoft Defender for servers</li> <li>Understand Microsoft Defender for App Service</li> <li>Understand Microsoft Defender for Storage</li> <li>Understand Microsoft Defender for SQL</li> <li>Understand Microsoft Defender for open-source databases</li> <li>Understand Microsoft Defender for Key Vault</li> <li>Understand Microsoft Defender for Resource Manager</li> <li>Understand Microsoft Defender for DNS</li> <li>Understand Microsoft Defender for Containers</li> <li>Understand Microsoft Defender additional protections</li> </ul> <h3>26 - Remediate security alerts using Microsoft Defender for Cloud</h3> <ul> <li>Understand security alerts</li> <li>Remediate alerts and automate responses</li> <li>Suppress alerts from Defender for Cloud</li> <li>Generate threat intelligence reports</li> <li>Respond to alerts from Azure resources</li> </ul> <h3>27 - Construct KQL statements for Microsoft Sentinel</h3> <ul> <li>Understand the Kusto Query Language statement structure</li> <li>Use the search operator</li> <li>Use the where operator</li> <li>Use the let statement</li> <li>Use the extend operator</li> <li>Use the order by operator</li> <li>Use the project operators</li> </ul> <h3>28 - Analyze query results using KQL</h3> <ul> <li>Use the summarize operator</li> <li>Use the summarize operator to filter results</li> <li>Use the summarize operator to prepare data</li> <li>Use the render operator to create visualizations</li> </ul> <h3>29 - Build multi-table statements using KQL</h3> <ul> <li>Use the union operator</li> <li>Use the join operator</li> </ul> <h3>30 - Work with data in Microsoft Sentinel using Kusto Query Language</h3> <ul> <li>Extract data from unstructured string fields</li> <li>Extract data from structured string data</li> <li>Integrate external data</li> <li>Create parsers with functions</li> </ul> <h3>31 - Introduction to Microsoft Sentinel</h3> <ul> <li>What is Microsoft Sentinel?</li> <li>How Microsoft Sentinel works</li> <li>When to use Microsoft Sentinel</li> </ul> <h3>32 - Create and manage Microsoft Sentinel workspaces</h3> <ul> <li>Plan for the Microsoft Sentinel workspace</li> <li>Create a Microsoft Sentinel workspace</li> <li>Manage workspaces across tenants using Azure Lighthouse</li> <li>Understand Microsoft Sentinel permissions and roles</li> <li>Manage Microsoft Sentinel settings</li> <li>Configure logs</li> </ul> <h3>33 - Query logs in Microsoft Sentinel</h3> <ul> <li>Query logs in the logs page</li> <li>Understand Microsoft Sentinel tables</li> <li>Understand common tables</li> <li>Understand Microsoft Defender XDR tables</li> </ul> <h3>34 - Use watchlists in Microsoft Sentinel</h3> <ul> <li>Plan for watchlists</li> <li>Create a watchlist</li> <li>Manage watchlists</li> </ul> <h3>35 - Utilize threat intelligence in Microsoft Sentinel</h3> <ul> <li>Define threat intelligence</li> <li>Manage your threat indicators</li> <li>View your threat indicators with KQL</li> </ul> <h3>36 - Connect data to Microsoft Sentinel using data connectors</h3> <ul> <li>Ingest log data with data connectors</li> <li>Understand data connector providers</li> <li>View connected hosts</li> </ul> <h3>37 - Connect Microsoft services to Microsoft Sentinel</h3> <ul> <li>Plan for Microsoft services connectors</li> <li>Connect the Microsoft Office 365 connector</li> <li>Connect the Microsoft Entra connector</li> <li>Connect the Microsoft Entra ID Protection connector</li> <li>Connect the Azure Activity connector</li> </ul> <h3>38 - Connect Microsoft Defender XDR to Microsoft Sentinel</h3> <ul> <li>Plan for Microsoft Defender XDR connectors</li> <li>Connect the Microsoft Defender XDR connector</li> <li>Connect Microsoft Defender for Cloud connector</li> <li>Connect Microsoft Defender for IoT</li> <li>Connect Microsoft Defender legacy connectors</li> </ul> <h3>39 - Connect Windows hosts to Microsoft Sentinel</h3> <ul> <li>Plan for Windows hosts security events connector</li> <li>Connect using the Windows Security Events via AMA Connector</li> <li>Connect using the Security Events via Legacy Agent Connector</li> <li>Collect Sysmon event logs</li> </ul> <h3>40 - Connect Common Event Format logs to Microsoft Sentinel</h3> <ul> <li>Plan for Common Event Format connector</li> <li>Connect your external solution using the Common Event Format connector</li> </ul> <h3>41 - Connect syslog data sources to Microsoft Sentinel</h3> <ul> <li>Plan for syslog data collection</li> <li>Collect data from Linux-based sources using syslog</li> <li>Configure the Data Collection Rule for Syslog Data Sources</li> <li>Parse syslog data with KQL</li> </ul> <h3>42 - Connect threat indicators to Microsoft Sentinel</h3> <ul> <li>Plan for threat intelligence connectors</li> <li>Connect the threat intelligence TAXII connector</li> <li>Connect the threat intelligence platforms connector</li> <li>View your threat indicators with KQL</li> </ul> <h3>43 - Threat detection with Microsoft Sentinel analytics</h3> <ul> <li>What is Microsoft Sentinel Analytics?</li> <li>Types of analytics rules</li> <li>Create an analytics rule from templates</li> <li>Create an analytics rule from wizard</li> <li>Manage analytics rules</li> </ul> <h3>44 - Automation in Microsoft Sentinel</h3> <ul> <li>Understand automation options</li> <li>Create automation rules</li> </ul> <h3>45 - Threat response with Microsoft Sentinel playbooks</h3> <ul> <li>What are Microsoft Sentinel playbooks?</li> <li>Trigger a playbook in real-time</li> <li>Run playbooks on demand</li> </ul> <h3>46 - Security incident management in Microsoft Sentinel</h3> <ul> <li>Understand incidents</li> <li>Incident evidence and entities</li> <li>Incident management</li> </ul> <h3>47 - Identify threats with Behavioral Analytics</h3> <ul> <li>Understand behavioral analytics</li> <li>Explore entities</li> <li>Display entity behavior information</li> <li>Use Anomaly detection analytical rule templates</li> </ul> <h3>48 - Data normalization in Microsoft Sentinel</h3> <ul> <li>Understand data normalization</li> <li>Use ASIM Parsers</li> <li>Understand parameterized KQL functions</li> <li>Create an ASIM Parser</li> <li>Configure Azure Monitor Data Collection Rules</li> </ul> <h3>49 - Query, visualize, and monitor data in Microsoft Sentinel</h3> <ul> <li>Monitor and visualize data</li> <li>Query data using Kusto Query Language</li> <li>Use default Microsoft Sentinel Workbooks</li> <li>Create a new Microsoft Sentinel Workbook</li> </ul> <h3>50 - Manage content in Microsoft Sentinel</h3> <ul> <li>Use solutions from the content hub</li> <li>Use repositories for deployment</li> </ul> <h3>51 - Explain threat hunting concepts in Microsoft Sentinel</h3> <ul> <li>Understand cybersecurity threat hunts</li> <li>Develop a hypothesis</li> <li>Explore MITRE ATT&amp;CK</li> </ul> <h3>52 - Threat hunting with Microsoft Sentinel</h3> <ul> <li>Explore creation and management of threat-hunting queries</li> <li>Save key findings with bookmarks</li> <li>Observe threats over time with livestream</li> </ul> <h3>53 - Use Search jobs in Microsoft Sentinel</h3> <ul> <li>Hunt with a Search Job</li> <li>Restore historical data</li> </ul> <h3>54 - Hunt for threats using notebooks in Microsoft Sentinel</h3> <ul> <li>Access Azure Sentinel data with external tools</li> <li>Hunt with notebooks</li> <li>Create a notebook</li> <li>Explore notebook code</li> </ul></div>

Microsoft SC-200

SC-200T00 Microsoft Security Operations Analyst

<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

Microsoft Azure

AZ-900T00 Microsoft Azure Fundamentals

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>This course is designed for data scientists with existing knowledge of Python and machine learning frameworks like Scikit-Learn, PyTorch, and Tensorflow, who want to build and operate machine learning solutions in the cloud.</p><p></p>Overview<p>Learn how to operate machine learning solutions at cloud scale using Azure Machine Learning. This course teaches you to leverage your existing knowledge of Python and machine learning to manage data ingestion and preparation, model training and deployment, and machine learning solution monitoring in Microsoft Azure.</p><p></p><p>Learn how to operate machine learning solutions at cloud scale using Azure Machine Learning. This course teaches you to leverage your existing knowledge of Python and machine learning to manage data ingestion and preparation, model training and deployment, and machine learning solution monitoring with Azure Machine Learning and MLflow.</p><p></p>Prerequisites<p></p><li>Creating cloud resources in Microsoft Azure.</li>  <li>Using Python to explore and visualize data.</li>  <li>Training and validating machine learning models using common frameworks like Scikit-Learn, PyTorch, and TensorFlow.</li>  <li>Working with containers</li>  <li>AI-900T00: Microsoft Azure AI Fundamentals is recommended, or the equivalent experience.</li><p></p></div><div id="course-pills-2"><h3>1 - Design a data ingestion strategy for machine learning projects</h3> <ul> <li>Identify your data source and format</li> <li>Choose how to serve data to machine learning workflows</li> <li>Design a data ingestion solution</li> </ul> <h3>2 - Design a machine learning model training solution</h3> <ul> <li>Identify machine learning tasks</li> <li>Choose a service to train a machine learning model</li> <li>Decide between compute options</li> </ul> <h3>3 - Design a model deployment solution</h3> <ul> <li>Understand how model will be consumed</li> <li>Decide on real-time or batch deployment</li> </ul> <h3>4 - Design a machine learning operations solution</h3> <ul> <li>Explore an MLOps architecture</li> <li>Design for monitoring</li> <li>Design for retraining</li> </ul> <h3>5 - Explore Azure Machine Learning workspace resources and assets</h3> <ul> <li>Create an Azure Machine Learning workspace</li> <li>Identify Azure Machine Learning resources</li> <li>Identify Azure Machine Learning assets</li> <li>Train models in the workspace</li> </ul> <h3>6 - Explore developer tools for workspace interaction</h3> <ul> <li>Explore the studio</li> <li>Explore the Python SDK</li> <li>Explore the CLI</li> </ul> <h3>7 - Make data available in Azure Machine Learning</h3> <ul> <li>Understand URIs</li> <li>Create a datastore</li> <li>Create a data asset</li> </ul> <h3>8 - Work with compute targets in Azure Machine Learning</h3> <ul> <li>Choose the appropriate compute target</li> <li>Create and use a compute instance</li> <li>Create and use a compute cluster</li> </ul> <h3>9 - Work with environments in Azure Machine Learning</h3> <ul> <li>Understand environments</li> <li>Explore and use curated environments</li> <li>Create and use custom environments</li> </ul> <h3>10 - Find the best classification model with Automated Machine Learning</h3> <ul> <li>Preprocess data and configure featurization</li> <li>Run an Automated Machine Learning experiment</li> <li>Evaluate and compare models</li> </ul> <h3>11 - Track model training in Jupyter notebooks with MLflow</h3> <ul> <li>Configure MLflow for model tracking in notebooks</li> <li>Train and track models in notebooks</li> </ul> <h3>12 - Run a training script as a command job in Azure Machine Learning</h3> <ul> <li>Convert a notebook to a script</li> <li>Run a script as a command job</li> <li>Use parameters in a command job</li> </ul> <h3>13 - Track model training with MLflow in jobs</h3> <ul> <li>Track metrics with MLflow</li> <li>View metrics and evaluate models</li> </ul> <h3>14 - Perform hyperparameter tuning with Azure Machine Learning</h3> <ul> <li>Define a search space</li> <li>Configure a sampling method</li> <li>Configure early termination</li> <li>Use a sweep job for hyperparameter tuning</li> </ul> <h3>15 - Run pipelines in Azure Machine Learning</h3> <ul> <li>Create components</li> <li>Create a pipeline</li> <li>Run a pipeline job</li> </ul> <h3>16 - Register an MLflow model in Azure Machine Learning</h3> <ul> <li>Log models with MLflow</li> <li>Understand the MLflow model format</li> <li>Register an MLflow model</li> </ul> <h3>17 - Create and explore the Responsible AI dashboard for a model in Azure Machine Learning</h3> <ul> <li>Understand Responsible AI</li> <li>Create the Responsible AI dashboard</li> <li>Evaluate the Responsible AI dashboard</li> </ul> <h3>18 - Deploy a model to a managed online endpoint</h3> <ul> <li>Explore managed online endpoints</li> <li>Deploy your MLflow model to a managed online endpoint</li> <li>Deploy a model to a managed online endpoint</li> <li>Test managed online endpoints</li> </ul> <h3>19 - Deploy a model to a batch endpoint</h3> <ul> <li>Understand and create batch endpoints</li> <li>Deploy your MLflow model to a batch endpoint</li> <li>Deploy a custom model to a batch endpoint</li> <li>Invoke and troubleshoot batch endpoints</li> </ul></div>

3369 Office Skills courses delivered Online

Microsoft Excel Diploma

By Study Plex

Microsoft Excel 2016: Part 3 (Expert Level) Course

By Study Plex

Microsoft Excel Online Training

By Study Plex

Microsoft Excel For Beginners

By Study Plex

Retail Analytics In Microsoft Excel

By Study Plex

Data Analysts' Toolbox - Excel, Python, Power BI, Alteryx, Qlik Sense, R, Tableau

By Packt

Performance Management, Team Management & Crisis Management

By Skill Up

Python Programming

By LearnDrive UK

Team Management

By LearnDrive UK

Python Programming Level 2

By LearnDrive UK