Name: Paralegal & Legal Advisor - Advanced Diploma
Price: 279 GBP
Availability: InStock

<h2 style="color: var(--text-heading); box-sizing: border-box;" id="isPasted" fr-original-style="color: var(--text-heading);">This course at a glance</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;">Define Inventory Management.</li><li fr-original-style="" style="box-sizing: border-box;">Control inventory costs.</li><li fr-original-style="" style="box-sizing: border-box;">Utilize key metrics.</li><li fr-original-style="" style="box-sizing: border-box;">Understand inventory dynamics.</li><li fr-original-style="" style="box-sizing: border-box;">Calculate EOQ and price breaks.</li><li fr-original-style="" style="box-sizing: border-box;">Manage safety stock and risks.</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);">Do you aspire to master inventory management, a crucial component that significantly influences a company&rsquo;s profitability and operational efficiency? Our Inventory Management course is meticulously designed to equip you with comprehensive, industry-relevant knowledge and skills.The 10-module course begins with a fundamental understanding of what inventory management is, followed by an introduction to Little&rsquo;s Law and its applications. You&rsquo;ll delve into the financial aspects, learning to control and understand inventory costs. From key metrics to part classification and analysis, every topic is covered in-depth to ensure your proficiency in the field. Modules on inventory dynamics and Economic Order Quantity (EOQ) prepare you for real-world scenarios. Learn to perfectly time your orders, manage your safety stock effectively, and mitigate associated risks. The course concludes with insights into advanced inventory management strategies that set you apart in this competitive field.This course is an invaluable resource for logistics professionals, business analysts, and aspiring inventory managers who are committed to achieving excellence in their careers. Become an Inventory Management expert and make informed, effective decisions that drive success. Take the first step by enrolling today.</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);">Accredited by</h3>This course is CPDQE&nbsp;accredited, which serves as an impactful mechanism for skill enhancement.&nbsp;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.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.Course Curriculum<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;">Module 1: What is Inventory Management?</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Module 2: Introduction to Little&rsquo;s Law in Inventory Management</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Module 3: Understanding the Costs of Inventory</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Module 4: Metrics in Inventory Management</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Module 5: Part Classification and Analysis</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Module 6: Inventory Dynamics</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Module 7: Economic Order Quantity (EOQ) and Price Break Models</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Module 8: Order Timing and Inventory Control</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Module 9: Safety Stock Calculations and Risk Management</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Module 10: Advanced Inventory Management Strategies</li></ul>

LearnDrive UK

Cash Management

Business & Management

Building Management

Master the art of Inventory Management! Learn Little’s Law, control costs, optimize order timing, and implement advanced strategies. Enrol now to excel!


























Inventory Management

General Admission

<h2 style="color: var(--text-heading); box-sizing: border-box;" id="isPasted" fr-original-style="color: var(--text-heading);">This course at a glance</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;">Understand inventory control basics.</li><li fr-original-style="" style="box-sizing: border-box;">Analyze inventory dynamics.</li><li fr-original-style="" style="box-sizing: border-box;">Calculate safety stock.</li><li fr-original-style="" style="box-sizing: border-box;">Recognize statistical method limitations.</li><li fr-original-style="" style="box-sizing: border-box;">Assess risk tolerance in inventory.</li><li fr-original-style="" style="box-sizing: border-box;">Compute stockout risk over time.</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);">Inventory control is not just about counting stock; it&rsquo;s a science that, when mastered, can propel your career and add significant value to any organization. Why is effective inventory control crucial? Because poorly managed inventories can become a drain on resources, while optimized stock levels can be a key driver of profitability.This course is a thorough exploration of inventory control, segmented into 10 targeted modules. The curriculum starts with the basics of what inventory control entails, followed by an in-depth look into inventory dynamics. Learn the nuances of safety stock calculations and explore statistical methods to achieve this, along with their limitations. Risk plays a significant role in inventory control; our course enables you to assess risk tolerance and calculate the probability of stockouts over time. Further, you&rsquo;ll learn how to optimize safety stock levels, apply advanced inventory control techniques, and stay ahead by understanding future trends in inventory control.Whether you&rsquo;re new to the field or an experienced professional looking to upskill, this course will equip you with the tools to become an expert in inventory control. Unlock the door to new opportunities and take command of your professional growth. Enrol today!</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);">Accredited by</h3>This course is CPDQE&nbsp;accredited, which serves as an impactful mechanism for skill enhancement.&nbsp;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.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.Course Curriculum<ul fr-original-style="" style="box-sizing: border-box;"><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Module 1: What is Inventory Control?</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Module 2: Inventory Dynamics</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Module 3: Safety Stock Calculations</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Module 4: Calculating Safety Stock Using Statistics</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Module 5: Key Limitations of Using Statistical Methods</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Module 6: Tolerance for Risk in Inventory Control</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Module 7: Probability of a Stockout Over Time - Calculating Risk</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Module 8: Optimising Safety Stock Level</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Module 9: Advanced Inventory Control Techniques</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Module 10: Future Trends in Inventory Control</li></ul>

Boost your career with our Inventory Control course! Master safety stock calculations, optimize levels, and grasp future trends. Elevate your skills now!



























Inventory Control

<div>
	<h3>Description: </h3>
Business Administration is the study of different management departments and roles of the components in business. In business, you need to learn about business communication, finance management, human resource management, business administration, and business writing. Through this course, you will learn all the advanced skills, knowledge, and information about business administration. Gain the skills of each component of a business which will help you survive and succeed in the business industry. Find out how to deal with your clients and employees in the most difficult situations of business as well in this course.
<h3>Who is the course for?</h3>
<ul>
<li>Professionals working in the business industry </li>
<li>People who are interested in learning more about all business administration functions</li>
</ul>
<h3>Entry Requirement:</h3>
<ul>
<li>This course is available to all learners, of all academic backgrounds. </li>
<li>Learners should be aged 16 or over to undertake the qualification.</li>
<li>Good understanding of English language, numeracy and ICT are required to attend this course.</li>
</ul>
<h3>Assessment:  </h3>
<ul>
<li>At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful.</li>
<li>Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. </li>
</ul>
<h3>Certification: </h3>
<ul>
<li>After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. </li>
<li>PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days.</li>
</ul>
<h3>Why choose us?</h3>
<ul>
<li>Affordable, engaging &amp; high-quality e-learning study materials;</li>
<li>Tutorial videos/materials from the industry leading experts;</li>
<li>Study in a user-friendly, advanced online learning platform;</li>
<li>Efficient exam systems for the assessment and instant result; </li>
<li>The UK &amp; internationally recognized accredited qualification;</li>
<li>Access to course content on mobile, tablet or desktop from anywhere anytime;</li>
<li>The benefit of career advancement opportunities;</li>
<li>24/7 student support via email.</li>
</ul>
<h3>Career Path:</h3>
The Advanced Diploma in Business Administration Course will be useful and would be beneficial for every kind of occupations and careers like:
<ul>
<li>Account Manager</li>
<li>Businessmen</li>
<li>Business Development Specialist</li>
<li>Communication Department Head</li>
<li>Executive Producers</li>
<li>Financial Manager/Staff</li>
<li>Group Account Director</li>
<li>Human Resources Manager</li>
<li>Marketing Manager</li>
<li>Public Relations Officer</li>
<li>Social Media Specialist</li>
<li>Strategist.</li>
</ul>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Business Administration</td>
				</tr>
								<tr>
					<td></td>
					<td>What is Business Administration?</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Business and Organisations</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Management of Business</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Business Organization Perspectives</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Decision Making</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Approaches to Leadership</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td colspan="4"> Business Communication</td>
				</tr>
								<tr>
					<td></td>
					<td>Communication Basics</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Know Thyself and The Message</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Learn To Use Terms of Business Communication That Invoke Emotions</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Pay Attention To Body Language</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Learn To Use Terms That Spark Interest</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>The Benefits Of Presenting Your Message In 1 Minute</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Wrapping Up</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td colspan="4"> Finance Management</td>
				</tr>
								<tr>
					<td></td>
					<td>Financing Basics</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Record Your Income</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Make a List of Expenses First and Put Them in Categories</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Countdown &amp; Adjust</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Review Regularly</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td colspan="4">Human Resource Management</td>
				</tr>
								<tr>
					<td></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Two - Human Resources Today</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Three - Recruiting and Interviewing</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Four - Retention and Orientation</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Five - Following Up With New Employees</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Six - Workplace Health &amp; Safety</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Seven - Workplace Bullying, Harassment, and Violence</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eight - Workplace Wellness</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Nine - Providing Feedback to Employees</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Ten - Disciplining Employees</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eleven - Terminating Employees</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Activites-Diploma in Human Resource Management</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
								<tr>
					<td colspan="4">Business Writing</td>
				</tr>
								<tr>
					<td></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Two - Working with Words</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Three - Constructing Sentences</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Four - Creating Paragraphs</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Five - Writing Meeting Agendas</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Six - Writing E-mails</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Seven - Writing Business Letters</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eight - Writing Proposals</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Nine - Writing Reports</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Ten - Other Types of Documents</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eleven - Proofreading and Finishing</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td colspan="4">Microsoft Word</td>
				</tr>
								<tr>
					<td></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Two - Opening</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Three - Working with the Interface</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Four - Your First Document</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Five - Basic Editing Tasks</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Six - Basic Formatting Tasks</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Seven - Formatting Paragraphs</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eight - Advanced Formatting Tasks</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Nine - Working with Styles</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Ten - Formatting the Page</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eleven - Sharing Your Document</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td colspan="4">Microsoft PowerPoint</td>
				</tr>
								<tr>
					<td></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Two - Opening PowerPoint</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Three - Working with the Interface</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Four - Your First Presentation</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Five - Working with Text</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Six - Formatting Text and Paragraphs</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Seven - Adding Pictures</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eight - Advanced Formatting Tasks</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Nine - Working with Transitions and Animations</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Ten - Setting Up Your Slide Show</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eleven - Showtime!</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td colspan="4">Microsoft Excel</td>
				</tr>
								<tr>
					<td></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Two - Opening Excel</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Three - Working with the Interface</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Four - Your First Worksheet</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Five - Viewing Excel Data</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Six - Building Formulas</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Seven - Using Excel Functions</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eight - Using Quick Analysis</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Nine - Formatting Your Data</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Ten - Using Styles, Themes, and Effects</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eleven - Printing and Sharing Your Workbook</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td colspan="4">Microsoft Access</td>
				</tr>
								<tr>
					<td></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Two - Opening and Closing Access</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Three - An Introduction to Databases</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Four - Sharing Data Using Apps</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Five - Working in Your App</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Six - An Introduction to Desktop Databases</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Seven - Performing Basic Table Tasks</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eight - Working with Fields</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Nine - Working with Table Relationships</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Ten - An Introduction to Queries, Forms, and Reports</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eleven - Protecting Your Data</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td colspan="4">Refer A Friend</td>
				</tr>
								<tr>
					<td></td>
					<td>Refer A Friend</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
								<tr>
					<td colspan="4">Mock Exam</td>
				</tr>
								<tr>
					<td></td>
					<td>Mock Exam- Advanced Diploma in Business Administration</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td colspan="4">Final Exam</td>
				</tr>
								<tr>
					<td></td>
					<td>Final Exam- Advanced Diploma in Business Administration</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
				</tbody></table>

John Academy

Business Administration

Business Studies

Diploma for School Business Leaders (DSBM)

Office Administration

Business Admin

Advanced Diploma in Business Administration

<div>
	<h3>Description</h3>
Do you want to know about MS Visio 365? Are you interested to get some specific and effective ideas about it? Do you want to learn how it works? Look at the MS Visio 365 Online course and mitigate your quest.
MS Visio 365 is one of the parts of MS office. It is actually used to draw some critical and complex diagrams. 
The curse is designed in such a way that will assist you to learn the crucial methods of sketching shapes, diagrams. The purpose of this course is to enable you to make shapes, diagrams, and objects by using various templates and patterns. This course also enables you to draw your own shape. It teaches you to create diagrams, flow chart, connect shapes, and work with text, theme, and pages perfectly. 
<h3>Assessment:</h3>
This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work.
<h3>Certification:</h3>
After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.
<h3>Who is this Course for?</h3>
MS Visio 365 Online is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.
As there is no experience and qualification required for this course, it is available for all students from any academic background.
<h3>Requirements</h3>
Our MS Visio 365 Online is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.
<h3>Career Path</h3>
After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Introduction</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction</td>
					<td>FREE </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Understanding Visio Online</td>
				</tr>
								<tr>
					<td></td>
					<td>What Is Visio</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Comparing Visio Online vs 2016</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Launching Visio Online</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Getting Started with Visio</td>
				</tr>
								<tr>
					<td></td>
					<td>Understanding the Visio Environment</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Navigating and Zooming</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Creating New Diagrams</td>
				</tr>
								<tr>
					<td></td>
					<td>Accessing Visio Templates</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating a Visio Diagram in OneDrive</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Opening a Diagram in Visio</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Working with Shapes</td>
				</tr>
								<tr>
					<td></td>
					<td>Adding Shapes</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Formatting Shapes</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Manipulating Shapes</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Changing Stacking Order</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Selecting and Grouping Shapes</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Searching for Shapes</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Creating a Flow Chart</td>
				</tr>
								<tr>
					<td></td>
					<td>Working with Basic Flowchart Template</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Connecting Shapes</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Adding Text to Shapes</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Working with Visio Diagrams</td>
				</tr>
								<tr>
					<td></td>
					<td>Inserting Pictures</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Changing the Document Theme</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Adding Pages to a Diagram</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Sharing Visio Diagrams</td>
				</tr>
								<tr>
					<td></td>
					<td>Sharing Diagrams in OneDrive</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Reviewing Diagrams in OneDrive</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Conclusion</td>
				</tr>
								<tr>
					<td></td>
					<td>Course Recap</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
				</tbody></table>

Microsoft Certification

Microsoft 365

Microsoft Virtual Academy (MVA)

Visio

Microsoft Office

Microsoft Visio

MS Visio 365 Online

Online Course Marketing

Microsoft Excel

Microsoft AZ-303

Microsoft Excel Masterclass in 2021

<div>
	<h3>Course Overview</h3>
Take your career to the next level by mastering new Excel functions. This The New functions in Microsoft Excel in 2021 course aims to provide you with a greater understanding of Excel's new formulas to boost your work output.
Microsoft Excel is a widely used spreadsheet program in various organizations.  It simplifies the process of calculation, analysis and visualization of data and information. Having Excel skills adds a considerable amount of weight to your resume. In this The New functions in Microsoft Excel in 2021 course, you will learn about the latest functions of Excel to simplify your Excel tasks. You will learn the principles behind dynamic arrays and explore how to create a table of random numbers or random dates with Randarray. It will teach you the new ways of dynamically sorting data with the sort by function. You will also delve into other functions such as XLOOKUP, SWITCH and CONCAT and determine how they work. 
<h3>Learning Outcomes</h3>
<ul>
<li>Familiarize with the new functions of Excel</li>
<li>Understand how the FILTER function works</li>
<li>Explore how the new UNIQUE, SORT and SORTBY Excel functions work</li>
<li>Know how to use RANDARRAY function to randomly sort lists</li>
<li>Be able to use DYNAMIC array formulas</li>
<li>Understand how to use the new functions in reports</li>
</ul>
<h3>Who is this course for?</h3>
The New functions in Microsoft Excel in 2021 course is highly relevant for professionals who want to excel in their position with their  Excel skills.  Gaining the skills adds weight to the resume and provides tremendous career opportunities.
<h3>Entry Requirement</h3>
<ul>
<li>This course is available to all learners, of all academic backgrounds.</li>
<li>Learners should be aged 16 or over to undertake the qualification.</li>
<li>Good understanding of English language, numeracy and ICT are required to attend this course.</li>
</ul>
<h3>Certification</h3>
<ul>
<li>After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24.</li>
<li>PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days.</li>
</ul>
<h3>Why choose us?</h3>
<ul>
<li>Affordable, engaging &amp; high-quality e-learning study materials;</li>
<li>Tutorial videos/materials from the industry-leading experts;</li>
<li>Study in a user-friendly, advanced online learning platform;</li>
<li>Efficient exam systems for the assessment and instant result;</li>
<li>The UK &amp; internationally recognized accredited qualification;</li>
<li>Access to course content on mobile, tablet or desktop from anywhere anytime;</li>
<li>The benefit of career advancement opportunities;</li>
<li>24/7 student support via email.</li>
</ul>
<h3>Career Path</h3>
The New functions in Microsoft Excel in 2021 course provides useful skills to possess and would be beneficial for any related profession or industry such as:
<ul>
<li>Office administrators</li>
<li>Accounting officers</li>
<li>Managers</li>
<li>HR</li>
<li>Project Supervisors</li>
<li>Data analyst</li>
<li>Teachers</li>
<li>Sales Representatives</li>
</ul>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">The New functions in Microsoft Excel in 2021</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 01: Introduction and Agenda</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 02: RANDARRAY</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 03: UNIQUE</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 04: SEQUENCE</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 05: SORT and SORTBY</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 06: SORT A Practical Example</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 07: FILTER</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 08: FILTER A Practical Example</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 09: Other Useful New Functions</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 10: Using the New Functions in Reports</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
				</tbody></table>

Office Skills & Productivity

Microsoft AZ-900

Microsoft AZ-700

The New functions in Microsoft Excel in 2021

<div>
	<h3>Course Overview</h3>
Microsoft Excel has brought a revolutionary change in the field of data management. It is one of the key skills that every employer looks for in a potential employee. The 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course is designed to equip you with adequate expertise in Excel. This course is a golden opportunity to add a highly beneficial skill to your resume and impress your employers.
In this 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course, you will receive a wide range of valuable tips to elevate your MS Excel skills. The course will show you the process of adding a link in the formula bar and adding multiple columns and rows within a blink. You will become skilled in quick calculations in the status bar. From the informative modules, you will identify the shortcut keys and learn to navigate between worksheets. The lessons will introduce you to the method of ZIP code format. You will understand how to move cell directions and convert numbers to text. 
This 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course is packed with valuable information about MS Excel. So enroll in the course and become a proficient MS Excel user.
<h3>Learning Outcomes</h3>
<ul>
<li>Learn how to navigate between worksheets using shortcut keys</li>
<li>Understand the process of creating a custom autofill list and importing data from webpages</li>
<li>Build the skills to hide workbook elements</li>
<li>Enrich your understanding of advanced transpose</li>
<li>Grasp the techniques of moving cell directions and deleting data</li>
<li>Know how to convert text to numbers</li>
</ul>
<h3>Who is this course for?</h3>
This 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course is for those who want to improve their Excel skills.
<h3>Entry Requirement</h3>
<ul>
<li>This course is available to all learners, of all academic backgrounds.</li>
<li>Learners should be aged 16 or over to undertake the qualification.</li>
<li>Good understanding of English language, numeracy and ICT are required to attend this course.</li>
</ul>
<h3>Certification</h3>
<ul>
<li>After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24.</li>
<li>PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days.</li>
</ul>
<h3>Why choose us?</h3>
<ul>
<li>Affordable, engaging &amp; high-quality e-learning study materials;</li>
<li>Tutorial videos/materials from the industry-leading experts;</li>
<li>Study in a user-friendly, advanced online learning platform;</li>
<li>Efficient exam systems for the assessment and instant result;</li>
<li>The UK &amp; internationally recognized accredited qualification;</li>
<li>Access to course content on mobile, tablet or desktop from anywhere anytime;</li>
<li>The benefit of career advancement opportunities;</li>
<li>24/7 student support via email.</li>
</ul>
<h3>Career Path</h3>
 The 50 MS Excel Tips to Upgrade your Excel Skill to next Level course is a useful qualification to possess and would be beneficial for any related profession or industry such as:
<ul>
<li>Administrative Assistant</li>
<li>Data Analyst</li>
<li>Accountants</li>
<li>Financial Analyst</li>
<li>Retail Store Manager</li>
<li>Project Manager</li>
<li>Business Analyst</li>
</ul>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4"> Unit 01: Introduction</td>
				</tr>
								<tr>
					<td></td>
					<td>Welcome</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 02: Excel Productivity Tips -Part 1</td>
				</tr>
								<tr>
					<td></td>
					<td>Camera Tool</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Add Line Break in Formula Bar</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Advanced Copy-Paste using Office Clipboard</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Navigation between Worksheets using Shortcut Keys</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Flash Fill</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Add Multiple Rows and Columns Quickly</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Delete Blank Rows</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Multi Level Row and Column Sorting</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Add Sparklines</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Paste Special - Transpose</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 03: Excel Productivity Tips - Part 2</td>
				</tr>
								<tr>
					<td></td>
					<td>Snap to Grid</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create Custom Auto fill List</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Absolute Cell Reference</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Import Data from Web page</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Move Cell Direction</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Delete Data using Mouse</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Status Bar Quick Calculations</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Link Text Boxes to Cell</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Phone Number and ZIP Code Format</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Speaking Cell</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 04: Excel Productivity Tips - Part 3</td>
				</tr>
								<tr>
					<td></td>
					<td>Invisible Text</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Worksheet Grouping</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Advanced Transpose</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>XLStart Folder</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Use Slicers</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Convert Text to Numbers</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Hiding Workbook Elements</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Useful Shortcut Keys</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Sort data from Left to Right</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Advanced Filter (Complex)</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 05: Excel Productivity Tips - Part 4</td>
				</tr>
								<tr>
					<td></td>
					<td>Email as PDF</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Synchronous Scrolling</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Quick Analysis of data within Excel</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Fill blank cells with Value</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Hidden Chart Source Data</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Two more Shortcuts</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Add Blank Rows</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Custom views in Excel</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>EMBED Feature</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Adding Country code in Mobile Numbers</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 05: Excel Productivity Tips - Part 5</td>
				</tr>
								<tr>
					<td></td>
					<td>Plot an Average Line to a Chart</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3D Referencing</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Extract Unique Values</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Excel Array Formula</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Forecast Sheet</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Add Spin Controls in Excel</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Move Data using Mouse</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Add new entry in Auto Correct to use across Office Applications</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Find Differences between Two Lists</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Find formulas Quickly</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit: 06 Wrap Up</td>
				</tr>
								<tr>
					<td></td>
					<td>Thank You</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
				</tbody></table>

Computing Skills

Computer Skills

Top 50 MS Excel Advanced Tips to Upgrade Skill to next Level

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

Online Course Creation

Trainers Course

Spreadsheet

Basic Excel Spreadsheet

24 Hour Flash Deal **25-in-1 Materials Engineering and Processing Mega Bundle** Materials Engineering and Processing Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter **Take the initial steps toward a successful long-term career by studying the Materials Engineering and Processing package online with Studyhub through our online learning platform. The Materials Engineering and Processing bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass.This Materials Engineering and Processing course provides complete 360-degree training on Materials Engineering and Processing. You'll get not one, not two, not three, but twenty-five Materials Engineering and Processing courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Materials Engineering and Processing courses are yours for as long as you want them once you enrol in this courseThis Materials Engineering and Processing Bundle consists the following career oriented courses:<ul><li>Course 01: Material Management</li><li>Course 02: Industrial Microbiology in Practice: Microorganisms and Industry</li><li>Course 03: Electronic &amp; Electrical Devices Maintenance &amp; Troubleshooting</li><li>Course 04: Electronic Device Maintenance and Troubleshooting Course</li><li>Course 05: MATLAB Simulink for Electrical Power Engineering</li><li>Course 06: Electrical Circuits Laws and Methods</li><li>Course 07: Electrical Engineering - Light Current System</li><li>Course 08: Data Center Training Essentials: Mechanical &amp; Cooling</li><li>Course 09: HVAC Basics and Refrigeration Diploma</li><li>Course 10: Solidworks Foundation Training</li><li>Course 11: Solidworks Drawing Tools Training: Test Preparation</li><li>Course 12: Blender 3D Character Modeling &amp; Rendering</li><li>Course 13: 3D Modeling for 3D Printing</li><li>Course 14: Autodesk Revit Complete Training</li><li>Course 15: CAD Designer with 3D and 2D Drawings Training</li><li>Course 16: Solidworks: Beginner to Advanced</li><li>Course 17: Construction Industry Scheme (CIS)</li><li>Course 18: Construction Management</li><li>Course 19: Power Electronics for Electrical Engineering</li><li>Course 20: Introduction to Petroleum Engineering and Exploration</li><li>Course 21: Petroleum Products : Specifications Properties Market Demand</li><li>Course 22: Logistics of Crude Oil and Petroleum Products</li><li>Course 23: Petroleum Refining Demystified</li><li>Course 24: Mechanical Engineering</li><li>Course 25: Engineering Mechanics Course for Beginners</li></ul> The Materials Engineering and Processing course has been prepared by focusing largely on Materials Engineering and Processing career readiness. It has been designed by our Materials Engineering and Processing specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners.The Materials Engineering and Processing Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Materials Engineering and Processing bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field.This Materials Engineering and Processing Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Materials Engineering and Processing Elementary modules, allowing our students to grasp each lesson quickly.The Materials Engineering and Processing course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc.In this exclusive Materials Engineering and Processing bundle, you really hit the jackpot. Here's what you get:<ul><li>Step by step Materials Engineering and Processing lessons</li><li>One to one assistance from Materials Engineering and Processingprofessionals if you need it</li><li>Innovative exams to test your knowledge after the Materials Engineering and Processingcourse</li><li>24/7 customer support should you encounter any hiccups</li><li>Top-class learning portal</li><li>Unlimited lifetime access to all twenty-five Materials Engineering and Processing courses</li><li>Digital Certificate, Transcript and student ID are all included in the price</li><li>PDF certificate immediately after passing</li><li>Original copies of your Materials Engineering and Processing certificate and transcript on the next working day</li><li>Easily learn the Materials Engineering and Processing skills and knowledge you want from the comfort of your home</li></ul> <h2>
 
 <div>CPD</div>
 </h2>

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

 <div id="who_is_this_course_for">
 This Materials Engineering and Processing training is suitable for -<ul><li>Students</li><li>Recent graduates</li><li>Job Seekers</li><li>Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Materials Engineering and Processing</li></ul>
 </div> <h2>
 
 <div>Requirements</div>
 </h2>

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

 <div id="career_path">
 You will be able to kickstart your Materials Engineering and Processing career because this course includes various courses as a bonus. This Materials Engineering and Processing is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Materials Engineering and Processing career opportunities.
 </div> <h2>
 
 <div>Certificates</div>
 </h2>

 <div id="optional_extras">
 <h4>CPD Accredited Certificate</h4>
 
 Digital certificate -
 Included
 
 <div><ul><li>CPD Accredited e-Certificate - Free</li><li>CPD Accredited Hardcopy Certificate - Free</li><li>Enrolment Letter - Free</li><li>Student ID Card - Free</li></ul></div>

 </div>

Studyhub UK

Materials Science

Finance Cert & Exam Prep

Design & Technology Courses (DT)

Material Science

Materials Engineering and Processing - CPD Certified

24 Hour Flash Deal **25-in-1 Paralegal &amp; Legal Advisor Mega Bundle** Paralegal &amp; Legal Advisor Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Paralegal &amp; Legal Advisor package online with Studyhub through our online learning platform. The Paralegal &amp; Legal Advisor bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Paralegal &amp; Legal Advisor course provides complete 360-degree training on Paralegal &amp; Legal Advisor. You'll get not one, not two, not three, but twenty-five Paralegal &amp; Legal Advisor courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Paralegal &amp; Legal Advisor courses are yours for as long as you want them once you enrol in this course This Paralegal &amp; Legal Advisor Bundle consists the following career oriented courses:<ul><li>Course 01: Paralegal (Legal Professional) Certification</li><li>Course 02: Legal Advisor Training: Property, Employment , Family and Criminal Law</li><li>Course 03: Business Law</li><li>Course 04: English Law Basics: Understanding Legal Principles</li><li>Course 05: Uk Commercial Law and Consumer Protection Training</li><li>Course 06: Understanding UK Insurance (General, Commercial, Liability, Life)</li><li>Course 07: Data Protection Level 3 and Data Security (GDPR) Training Certification</li><li>Course 08: Cyber Security Law</li><li>Course 09: Family Law</li><li>Course 10: Workplace Violence, Harassment and Conflict Resolution Training</li><li>Course 11: Tort Law Simplified: Understanding Legal Principles and Rights</li><li>Course 12: Criminology: Criminal Law</li><li>Course 13: Criminal Intelligence &amp; Counterterrorism Analysis</li><li>Course 14: International Law Certificate</li><li>Course 15: GDPR Training</li><li>Course 16: Workplace Confidentiality</li><li>Course 17: Business Contract &amp; Compliance Manager: Ensuring Legal Integrity Diploma</li><li>Course 18: Corporate Social Responsibility Diploma</li><li>Course 19: Emotional Intelligence and Social Management Diploma</li><li>Course 20: Resilience Masterclass</li><li>Course 21: Cross-Cultural Awareness Training Diploma Certificate</li><li>Course 22: Office Skills (Administration, Communication and Management) Diploma</li><li>Course 23: Public Speaking: Presentations like a Boss</li><li>Course 24: Strategic Business Management</li><li>Course 25: Middle Manager Management</li></ul>In this exclusive Paralegal &amp; Legal Advisor bundle, you really hit the jackpot. Here's what you get:<ul><li>Step by step Paralegal &amp; Legal Advisor lessons</li><li>One to one assistance from Paralegal &amp; Legal Advisor professionals if you need it</li><li>Innovative exams to test your knowledge after the Paralegal &amp; Legal Advisor course</li><li>24/7 customer support should you encounter any hiccups</li><li>Top-class learning portal</li><li>Unlimited lifetime access to all twenty-five Paralegal &amp; Legal Advisor courses</li><li>Digital Certificate, Transcript and student ID are all included in the price</li><li>PDF certificate immediately after passing</li><li>Original copies of your Paralegal &amp; Legal Advisor certificate and transcript on the next working day</li><li>Easily learn the Paralegal &amp; Legal Advisor skills and knowledge you want from the comfort of your home</li></ul> The Paralegal &amp; Legal Advisor course has been prepared by focusing largely on Paralegal &amp; Legal Advisor career readiness. It has been designed by our Paralegal &amp; Legal Advisor specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Paralegal &amp; Legal Advisor Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Paralegal &amp; Legal Advisor bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Paralegal &amp; Legal Advisor Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Paralegal &amp; Legal Advisor Elementary modules, allowing our students to grasp each lesson quickly. The Paralegal &amp; Legal Advisor course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. <h2>
 
 <div>CPD</div>
 </h2>

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

 <div id="who_is_this_course_for">
 This Paralegal &amp; Legal Advisor training is suitable for -<ul><li>Students</li><li>Recent graduates</li><li>Job Seekers</li><li>Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Paralegal &amp; Legal Advisor</li><li>The Institute of Legal Secretaries and PAs</li><li>ILSPA's Legal Secretaries Diploma</li><li>ILSPA's Legal Secretary Advanced Diploma</li><li>ILSPA's Legal Secretary Foundation Certificate</li></ul>Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses.
 </div> <h2>
 
 <div>Requirements</div>
 </h2>

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

 <div id="career_path">
 You will be able to kickstart your Paralegal &amp; Legal Advisor career because this course includes various courses as a bonus. This Paralegal &amp; Legal Advisor is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Paralegal &amp; Legal Advisor career opportunities.
 </div> <h2>
 
 <div>Certificates</div>
 </h2>

 <div id="optional_extras">
 <h4>CPD Accredited Certificate</h4>
 
 Digital certificate -
 Included
 
 <div><ul><li>CPD Accredited e-Certificate - Free</li><li>CPD Accredited Hardcopy Certificate - Free</li><li>Enrolment Letter - Free</li><li>Student ID Card - Free</li></ul></div>

 </div>

Paralegal

Legal Practice Course (LPC)

Professional Skills Course (PSC)

Graduate Diploma in Law (GDL)

Paralegal & Legal Advisor - Advanced Diploma

Learn how smart property investors create Passive Income and Long-term Wealth through property.&nbsp; The key is the right Property Investment strategy, discover how to:Create &pound;1,000s in recurring property income year after yearSupercharge property profits, value and rentSecure financial freedom through propertyRecycle your investment capitalBuild a portfolio with limited cash investmentCreate property income without even needing a depositWe&#39;ve been investing in property for over 30 years between us, and training people for over 10 years. &nbsp;Learn the tools, techniques and strategies that we use in today&#39;s market to convert Property into Pounds and make regular, recurring profits while building real long-term wealth. &nbsp;From using your hard-earned savings to buy the right property that builds the foundations of your portfolio and financial future to showing you innovative ways to start Investing in Property, even if you don&#39;t have loads of capital now. &nbsp;In this taster session, we&#39;ll focus on the key steps you need to follow to turn Property into Pounds.

Property investment is a proven income and wealth generation tool. Ask anyone who's financially successful and they will own investment property.
But…I bet if you asked 5 people, you'd find at least one with a property horror story where it went completely wrong!
Learn the difference between making a smart property investment decision that turns Property into Pounds rather than getting lured into the wrong type of property deal that loses value, makes a loss and drags you down!
Discover our foolproof system based on over 30 years of combined experience to turn Property Into Pounds
Identify more valuable opportunities
Increase your property income
Reduce your risk
Make the most of your capital
Start with limited funds and build steadily
Do the right deal and 10X your profits
Learn to build a secure, sustainable property business, with tried and tested tools and techniques.
Join our free taster session to discover how you can turn Property into Pounds!





Property SQ2

Wealth Management

Property Investment

Real Estate Investing

Passive Income

Investment

Taster session. Passive income from Property. Professional Investor secrets to build a Property Portfolio, even if you're starting with little capital

Discover Property to Pounds

Webinar Seat



Bayfield Training and the University of Cambridge Department of Land Economy
This prestigious eight-week online Real Estate course is suitable for modellers new to Real Estate and experienced Real Estate Analysts looking to formalise their skill set. This course will equip you with skills to start building your own financial models and the certificate will give your employers and colleagues reassurance of your expertise.
If you want to enhance your financial modelling skills over an extended period, the Real Estate Financial Modelling Certificate is the course for you.
This online real estate course has been put together exclusively for the Real Estate Financial Modelling certificate, using state of the art digital resources such as animations, video-steps, digital whiteboard and video-interactions as well as the spreadsheets, text based resources and tutor contact you would expect from any of Bayfield Training’s classroom based courses.
 Assessment is in the form of a guided model build exercise and written model appraisal. Participants benefit from an additional months access to the course platform after submission of the assessment.


On this course you will:
Become a competent model builder, building Real Estate Financial Models from scratch
Learn tricks and concepts from financial modelling experts with decades of experience in practice and academia
Learn how to use Real Estate Financial Models to make informed investment decisions
Learn at a consistent pace over 8 weeks allowing you to take the time to fully grasp this important skill
This course is suitable for:
Chartered Surveyors
Asset Managers
Financial Controllers
Financial Analysts
Investment Managers
Property Managers
Real Estate Students/Recent Graduates
Course Outline:
Module 1 - Economic Context
Introduction to Real Estate Asset Modelling and how it relates to and is distinct from Econometric Models.
Introduction to Real Estate Asset Modelling and how it relates to and is distinct from Econometric Models.
Why Real Estate Asset Modelling is important
Understanding the occupier, asset and development markets and the relevant modelling approaches for each
Real Estate Sub-Sector Key Performance Indicators
Introduction to conventional valuations and financial mathematics
Understanding and minimising errors in Financial Models


Module 2 - Cash Flow Fundamentals
Constructing a financial model from first principles.
Understanding all the components of a basic cash flow model
Understand why Corporate Finance Models and Real Estate Models are different
Financial Model Design
Making the link between valuations, income mathematics and discounted cash flows
Internal Rate of Return, Net Present Value,Worth and other metrics
Features and techniques to aid fast model building


Module 3 - Developing the Cash Flow
Adapting financial models for different periodicities and building rent functions for different rent behaviour.
Understanding how leases vary with respect to rent over time: Rent Reviews, Break Clauses, Rent Free Periods, Lease Expiries etc.
Developing the concept of a Rent Function in Excel
Logic mathematics and Logic functions
Projecting rent to adapt to different lease contracts and growth patterns
Alternative solutions to Logic functions
Comparative analysis of lease structures in different jurisdictions and adapting financial models


Module 4 - Real Estate Data
Understanding the different sources of data, constructing basic time series models and recognising basic patterns.
Key Property market indicators
Characteristics and application of key input metrics for Real Estate Appraisals
Understanding the eight components of Real Estate Price Dynamics
Awareness of the different sources of data
Reading and using general property market reports
Constructing basic time series models and recognising basic patterns


Module 5 - Development Appraisals
Constructing a development appraisal from first principles and understanding development return metrics.
Understanding the key components of a development project
Understanding the difference between development and investment appraisals
Residual Appraisals and Profit Calculations
Cost orientated cash flows and phased sales
Cumulative construction cost patterns: incidental, fixed, loaded and S-curve
Development return metrics and Modified IRRs


Module 6 - Multi-let Cash Flows
Constructing an advanced multi-let cash flow model and learn different techniques to build flexible rent functions.
Multi-let and portfolio model design principles
Building complex date functions and date series
The three multi-let rent projection techniques
Perpendicular Rent Functions
Incorporate advanced rent adjustments into the Rent Function
Incorporate sector and period varying rental growth rates
Simplifying OPEX and CAPEX projections
Discounting techniques on complex and volatile cash flows


Module 7 - Project Finance
Constructing a flexible Real Estate Debt Finance model.
Revision of the Mathematics of amortisation and debt finance
Basic senior debt models and geared net cash flow
LTV, IRR and Interest Rate Dynamics
Flexible term, repayment options and deferred interest
Loan covenant tests
Understanding different tranches of debt
Understanding how complex debt structures impact the returns to different parties


Module 8 - Model Interpretation and Risk Analysis
Learn how to read, analyse and report on real estate financial models.
Understand how to read models and develop an investment narrative
Visualise model outputs using graph functions, conditional formatting, dynamic symbols and dashboards
Learn how to use built-in Sensitivity, Scenario Analysis tools and third-party add-ins
Learn how to construct varied project scenarios in a systematic way
Introduction to Monte Carlo Analysis and VBA
Optimising sale dates and other parameters
Create well written, attractive and persuasive reports


Included in the Course
Bayfield Training and University of Cambridge Accredited Certificate & LinkedIn Proficiency Badge
64 CPD Hours
1 Month Post-Course Access to the Digital Platform - 12 Months Post-Course Access to the Platform can be purchased for an additional fee
Course Files
Q&A Webinars and Guest Speaker Webinars
Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers


2024 Cohort Dates Include:
3rd June to 29th July
5th August to 25th September 2024
30th September to 25th November


For more information, 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

Professional Development

Continuous Professional Development (CPD)

University of Cambridge & Bayfield Training - Real Estate Financial Modelling Certificate (Online Self-Study)

Southend-On-Sea

In this 2-day course, you&rsquo;ll gain a basic understanding of finance and accounting concepts to drive the success of your business.This workshop aims to demystify the accounting language so that you are in control of the financial performance of your business, helping you forecast for the future, evaluate your current efforts, and establish strategies to meet your goals.Dates: Tuesday 1st &amp; Wednesday 2nd October 2024Time: 9:30am - 4:30pmLocation: Launchpad Southend, Airport Business Park, Launchpad, Rochford SS4 1YHCost: FreeFor: Businesses based in or shortly moving to Southend-On-SeaEven if you plan to hire an accountant, you still need to understand accounting information to make better, more informed decisions about your business. This course will give you the tools necessary to have a better understanding of what the professionals are saying down the line, so you can run your business better.You&rsquo;ll learn about double-entry bookkeeping, trial balances, profit and loss statements, and other must-have accounting topics, and in further sessions, you&rsquo;ll learn how to apply these techniques to manage your business better, which will give you confidence and control when making financial decisions.**The course will be run in person over two days, in 7 hour sessions (with 1 hour lunch breaks) on 1st October &amp; 2nd October.&nbsp;Please note: lunch is not provided however, there is a refreshments area for drinks and snacks**<h3 fr-original-style="" style="box-sizing: border-box;">What it covers:</h3><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Double-entry bookkeeping</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Preparation of profit and loss accounts, balance sheets, and cash-flow statements</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Analysis of accounting reports</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Controlling cash</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Sources of funding</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Business planning, budgets, cash flow forecasting, and variance analysis</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Break-even analysis</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Capital appraisal</li><li value="9" fr-original-style="" style="box-sizing: border-box;">Product costing</li></ul><h3 fr-original-style="" style="box-sizing: border-box;">Who should attend:</h3>The course is aimed at a whole range of businesses from start-up founders to local business owners to corporates and is geared to anyone without a finance or accounting background. Your business must be based in or shortly relocating to Southend-On-Sea.<h3 fr-original-style="" style="box-sizing: border-box;">Who should attend:</h3><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Entrepreneurs</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Micro business owners</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Small business owners</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Middle managers</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Consultants</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Coaches</li><li value="7" fr-original-style="" style="box-sizing: border-box;">E-commerce businesses</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Digital marketers</li><li value="9" fr-original-style="" style="box-sizing: border-box;">Service based business owners</li></ul><h3 fr-original-style="" style="box-sizing: border-box;">Skills gained:</h3>The full value from this course is only be gained by full participation in both days. After completing the course, delegates will be able to:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Understand basic financial documents used in business</li><li fr-original-style="" style="box-sizing: border-box;">Interpret the information in these documents, and use it to manage day-to-day business activity</li><li fr-original-style="" style="box-sizing: border-box;">Be more effective in their role</li></ul>About the host:Jim Fletcher ACMA GCMAJim is a dedicated business coach with 40 years&rsquo; commercial leadership experience. Drawing on his long career in the manufacturing and engineering sector, Jim provides tailored coaching, consultancy, non-executive directorship and project management services, across a full range of management, finance, sales &amp; marketing and operations functions.<hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;">This workshop is organised by Let&#39;s Do Business Group on behalf of Southend-On-Sea City Council and is funded by the UK Government through the <a href="https://www.gov.uk/government/publications/uk-shared-prosperity-fund-prospectus" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.gov.uk/government/publications/uk-shared-prosperity-fund-prospectus" data-airgap-id="106" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">UK Shared Prosperity Fund</a>.The UK Shared Prosperity Fund is a central pillar of the UK government&#39;s Levelling Up agenda and provides &pound;2.6 billion of funding for local investment by March 2025. The Fund aims to improve pride in place and increase life chances across the UK investing in communities and place, supporting local business, and people and skills.View our&nbsp;<a href="https://backingessexbusiness.co.uk/privacy-policy" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://backingessexbusiness.co.uk/privacy-policy" data-airgap-id="107" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">privacy policy</a>

In this course, you’ll gain a basic understanding of finance and accounting concepts to drive the success of your business.
This workshop aims to demystify the accounting language so that you are in control of the financial performance of your business, helping you forecast for the future, evaluate your current efforts, and establish strategies to meet your goals.
Dates: Tuesday 1st October 2024
Time: 9:30am - 12:30pm
Location: Online (ZOOM)
Cost: Free
For: Businesses based in or shortly moving to Southend-On-Sea
Even if you plan to hire an accountant, you still need to understand accounting information to make better, more informed decisions about your business. This course will give you the tools necessary to have a better understanding of what the professionals are saying down the line, so you can run your business better.
You’ll learn about double-entry bookkeeping, trial balances, profit and loss statements, and other must-have accounting topics, and in further sessions, you’ll learn how to apply these techniques to manage your business better, which will give you confidence and control when making financial decisions.
What it covers:
Double-entry bookkeeping
Preparation of profit and loss accounts, balance sheets, and cash-flow statements
Analysis of accounting reports
Controlling cash
Sources of funding
Business planning, budgets, cash flow forecasting, and variance analysis
Break-even analysis
Capital appraisal
Product costing
Who should attend:
The course is aimed at a whole range of businesses from start-up founders to local business owners to corporates and is geared to anyone without a finance or accounting background. Your business must be based in or shortly relocating to Southend-On-Sea.
Who should attend:
Entrepreneurs
Micro business owners
Small business owners
Middle managers
Consultants
Coaches
E-commerce businesses
Digital marketers
Service based business owners
Skills gained:
The full value from this course is only be gained by full participation in both days. After completing the course, delegates will be able to:
Understand basic financial documents used in business
Interpret the information in these documents, and use it to manage day-to-day business activity
Be more effective in their role
About the host:
Jim Fletcher ACMA GCMA
Jim is a dedicated business coach with 40 years’ commercial leadership experience. Drawing on his long career in the manufacturing and engineering sector, Jim provides tailored coaching, consultancy, non-executive directorship and project management services, across a full range of management, finance, sales & marketing and operations functions.



This workshop is organised by Let's Do Business Group on behalf of Southend-On-Sea City Council and is funded by the UK Government through the UK Shared Prosperity Fund.
The UK Shared Prosperity Fund is a central pillar of the UK government's Levelling Up agenda and provides £2.6 billion of funding for local investment by March 2025. The Fund aims to improve pride in place and increase life chances across the UK investing in communities and place, supporting local business, and people and skills.
View our privacy policy

Let’s Do Business Group

In this 3-hour course, you’ll gain a basic understanding of finance and accounting concepts to drive the success of your business.

Finance for Non-Financial Entrepreneurs - Southend-On-Sea

Are you looking to enter the dynamic world of real estate?Our course is designed to equip you with the knowledge and tools you need to communicate effectively with real estate professionals and develop key skills in real estate investment strategy and analytics.At the end of the course, you&#39;ll be able to read and interpret real estate market reports, and have a firm grasp of how iconic buildings, cities, and companies fit into the overall picture of the real estate sector. On this course, you will&hellip;<ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">Become familiar with the players, structure, general terminology and overall needs of Real Estate.</li><li fr-original-style="" style="box-sizing: border-box;">Learn what is Real Estate and why it is different from other asset classes</li><li fr-original-style="" style="box-sizing: border-box;">Get to grips with the overall size and structure of the UK Real Estate Market</li><li fr-original-style="" style="box-sizing: border-box;">Learn and analyse the links between the different parts of the property market</li><li fr-original-style="" style="box-sizing: border-box;">Understand who works in the Real Estate Market, their qualifications and their job descriptions</li><li fr-original-style="" style="box-sizing: border-box;">Recognise how and when to use basic real estate concepts: Rent, Value, Yield, Risk and Return, etc&hellip;</li><li fr-original-style="" style="box-sizing: border-box;">Learn how to read a real estate market report</li><li fr-original-style="" style="box-sizing: border-box;">Understand how current affairs, politics and economics affects Real Estate Investment</li><li fr-original-style="" style="box-sizing: border-box;">Use household names and iconic companies, cities and buildings to help consolidate your appreciation of this exciting sector</li></ul> Who will benefit from this course:<ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">Graduates or undergraduates studying economics, finance.</li><li fr-original-style="" style="box-sizing: border-box;">Professionals working in Marketing or Accounting teams within Real Estate firms.</li><li fr-original-style="" style="box-sizing: border-box;">APC students.</li><li fr-original-style="" style="box-sizing: border-box;">Anyone interested in Real Estate.</li><li fr-original-style="" style="box-sizing: border-box;">School leavers/A-Level Students looking to gain an understanding of Real Estate.</li><li fr-original-style="" style="box-sizing: border-box;">Non cognate students who wish to transfer into Real Estate/Finance careers.</li></ul> Course OutlineModule 1: What is and why buy Real Estate?<ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">The property Market</li><li fr-original-style="" style="box-sizing: border-box;">The Size and Structure of the UK property market</li><li fr-original-style="" style="box-sizing: border-box;">The impact of Real Estate in the Economy</li></ul> Module 2: The Real Estate Market System<ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">The Space Market</li><li fr-original-style="" style="box-sizing: border-box;">The Asset Market</li><li fr-original-style="" style="box-sizing: border-box;">The Development Market</li></ul> Module 3: How to value Real Estate<ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">An Introduction to Financial Mathematics</li><li fr-original-style="" style="box-sizing: border-box;">The difference between Price, Value and Worth</li><li fr-original-style="" style="box-sizing: border-box;">Property Yield</li><li fr-original-style="" style="box-sizing: border-box;">Conventional Valuation Methods</li></ul> Module 4: How to read a Real Estate Market Report<ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">Property Market Indicators: Stock Indicators</li><li fr-original-style="" style="box-sizing: border-box;">Property Market Indicators: Investment Indicators</li></ul> Module 5: Who works in Real Estate?<ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">The build Environment by Cobalt Recruitment</li><li fr-original-style="" style="box-sizing: border-box;">Rea; Estate Agents</li><li fr-original-style="" style="box-sizing: border-box;">Examples of Real Estate Market Agents CVs</li><li fr-original-style="" style="box-sizing: border-box;">Real Estate Network</li></ul> Included in the Course<ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate</li><li fr-original-style="" style="box-sizing: border-box;">12 Months Access to the Course</li><li fr-original-style="" style="box-sizing: border-box;">Course Files</li><li fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li 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> For more information about the Introduction to Real Estate, please contact Sam on the Bayfield Training Sales team:E - s.musgrave@bayfieldtraining.comT - 01223 517851W - <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>

Financial Analysis

Are you looking to enter the dynamic world of real estate?

Our course is designed to equip you with the knowledge and tools you need to communicate effectively with real estate professionals and develop key skills in real estate investment strategy and analytics.

At the end of the course, you'll be able to read and interpret real estate market reports, and have a firm grasp of how iconic buildings, cities, and companies fit into the overall picture of the real estate sector.



On this course, you will…

Become familiar with the players, structure, general terminology and overall needs of Real Estate.
Learn what is Real Estate and why it is different from other asset classes
Get to grips with the overall size and structure of the UK Real Estate Market
Learn and analyse the links between the different parts of the property market
Understand who works in the Real Estate Market, their qualifications and their job descriptions
Recognise how and when to use basic real estate concepts: Rent, Value, Yield, Risk and Return, etc…
Learn how to read a real estate market report
Understand how current affairs, politics and economics affects Real Estate Investment
Use household names and iconic companies, cities and buildings to help consolidate your appreciation of this exciting sector


Who will benefit from this course:

Graduates or undergraduates studying economics, finance.
Professionals working in Marketing or Accounting teams within Real Estate firms.
APC students.
Anyone interested in Real Estate.
School leavers/A-Level Students looking to gain an understanding of Real Estate.
Non cognate students who wish to transfer into Real Estate/Finance careers.


Course Outline

Module 1: What is and why buy Real Estate?

The property Market
The Size and Structure of the UK property market
The impact of Real Estate in the Economy


Module 2: The Real Estate Market System

The Space Market
The Asset Market
The Development Market


Module 3: How to value Real Estate

An Introduction to Financial Mathematics
The difference between Price, Value and Worth
Property Yield
Conventional Valuation Methods


Module 4: How to read a Real Estate Market Report

Property Market Indicators: Stock Indicators
Property Market Indicators: Investment Indicators


Module 5: Who works in Real Estate?

The build Environment by Cobalt Recruitment
Rea; Estate Agents
Examples of Real Estate Market Agents CVs
Real Estate Network


An Introduction to Real Estate (12 Hours Online Self-Study)

In January 2024 alone, reports were published about the SRA taking enforcement action against 3 firms and 4 individuals for failure to comply with the Money Laundering Regulations 2017. The fines issued for these non-compliances total over &pound;570,000 plus costs. The absence of staff training, or requirement to complete additional training, was noted in a number of these cases.Action has not only been taken against solicitors, but also other individuals who are not regulated by the SRA, whose breaches were so serious that the SRA felt compelled to take action.&nbsp;As all SRA enforcement action, from rebukes to fines, is published by the SRA, the potential financial and reputational impact upon firms may be felt by all staff, regardless of whether they had any direct involvement with the non-compliance.This course will cover the following to assist support staff in understanding the fundamental aspects of AML.<ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The basics of what AML is</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">In scope / not in scope work for AML</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">POCA / TA</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">PCPs - CDD &amp; EDD</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Clients</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Risks &ndash; what could raise a risk?</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Reporting to the MLRO / MLCO</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Tipping off</li></ul><h2 fr-original-style="" style="box-sizing: border-box;">Target Audience</h2>The online course is suitable for support staff or legal practitioners wanting to understand the basics of AML.<h2 data-key="21" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Resources</h2>Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training.<p data-key="30" data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJoZWFkaW5nLXRocmVlJTIyJTJDJTIyZGF0YSUyMiUzQSU3QiUyMmNsYXNzTmFtZSUyMiUzQW51bGwlN0QlMkMlMjJub2RlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMnRleHQlMjIlMkMlMjJsZWF2ZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMkNvdXJzZSUyME5vdGVzJTIyJTJDJTIybWFya3MlMjIlM0ElNUIlNUQlN0QlNUQlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyQ29tcHJlaGVuc2l2ZSUyMGFuZCUyMHVwJTIwdG8lMjBkYXRlJTIwY291cnNlJTIwbm90ZXMlMjB3aWxsJTIwYmUlMjBwcm92aWRlZCUyMHRvJTIwYWxsJTIwZGVsZWdhdGVzJTIwd2hpY2glMjBtYXklMjBiZSUyMHVzZWZ1bCUyMGZvciUyMG9uZ29pbmclMjByZWZlcmVuY2UlMjBvciUyMGNhc2NhZGUlMjB0cmFpbmluZy4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCUyQyU3QiUyMm9iamVjdCUyMiUzQSUyMmJsb2NrJTIyJTJDJTIydHlwZSUyMiUzQSUyMnBhcmFncmFwaCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlMjJjbGFzc05hbWUlMjIlM0FudWxsJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJ0ZXh0JTIyJTJDJTIybGVhdmVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJQbGVhc2UlMjBub3RlJTIwYSUyMHJlY29yZGluZyUyMG9mJTIwdGhlJTIwY291cnNlJTIwd2lsbCUyMCUyMiUyQyUyMm1hcmtzJTIyJTNBJTVCJTVEJTdEJTJDJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJub3QlMjAlMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMm1hcmslMjIlMkMlMjJ0eXBlJTIyJTNBJTIyYm9sZCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlN0QlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMmJlJTIwbWFkZSUyMGF2YWlsYWJsZS4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCU1RCU3RA==" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Please note a recording of the course will&nbsp;not&nbsp;be made available.<h2 data-key="35" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Speaker</h2><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><a href="https://dglegal.co.uk/the-team/helen-torresi/" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Helen Torresi, Consultant, DG Legal</a></h3>Helen is a qualified solicitor with a diverse professional background spanning leadership roles in both the legal and tech/corporate sectors. Throughout her career, she has held key positions such as COLP, HOLP, MLCO, MLRO and DPO for law firms and various regulated businesses and services.Helen&rsquo;s specialised areas encompass AML, complaint and firm negligence handling, DPA compliance, file review and auditing, law management, and operational effectiveness in law firms, particularly in conveyancing (CQS).

In January 2024 alone, reports were published about the SRA taking enforcement action against 3 firms and 4 individuals for failure to comply with the Money Laundering Regulations 2017. The fines issued for these non-compliances total over £570,000 plus costs. The absence of staff training, or requirement to complete additional training, was noted in a number of these cases.
Action has not only been taken against solicitors, but also other individuals who are not regulated by the SRA, whose breaches were so serious that the SRA felt compelled to take action. 
As all SRA enforcement action, from rebukes to fines, is published by the SRA, the potential financial and reputational impact upon firms may be felt by all staff, regardless of whether they had any direct involvement with the non-compliance.
This course will cover the following to assist support staff in understanding the fundamental aspects of AML.
The basics of what AML is
In scope / not in scope work for AML
POCA / TA
PCPs - CDD & EDD
Clients
Risks – what could raise a risk?
Reporting to the MLRO / MLCO
Tipping off
Target Audience
The online course is suitable for support staff or legal practitioners wanting to understand the basics of AML.
Resources
Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training.
Please note a recording of the course will not be made available.
Speaker
Helen Torresi, Consultant, DG Legal
Helen is a qualified solicitor with a diverse professional background spanning leadership roles in both the legal and tech/corporate sectors. Throughout her career, she has held key positions such as COLP, HOLP, MLCO, MLRO and DPO for law firms and various regulated businesses and services.
Helen’s specialised areas encompass AML, complaint and firm negligence handling, DPA compliance, file review and auditing, law management, and operational effectiveness in law firms, particularly in conveyancing (CQS).

DG Legal

Anti-Money Laundering (AML)

Anti-Money Laundering (AML) Training For Support Staff Course

General Delegate

A discount is available for delegates attending from firms with a current retainer contract with DG Legal (please contact us by email to admin@dglegal.co.uk for confirmation of eligibility).   If you choose this option and are not eligible, you are still bound to pay the full rate and will be invoiced accordingly.

Retainer Delegate

<div id="course-pills-1">Duration1 Days6 CPD hoursThis course is intended forTo ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to manage information on their computers.OverviewUpon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation.This course is intended for those who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organise, calculate, analyse, revise, update, and present your data.</div><div id="course-pills-2"><h4>Getting Started with Excel</h4><ul><li>Navigate the Excel User Interface</li><li>Use Excel Commands</li><li>Create and Save a Basic Workbook</li><li>Enter and Edit Cell Data</li><li>Fill Cells with Series of Data (AutoFill and Flash Fill)</li><li>Use Excel Help</li></ul><h4>Performing Calculations</h4><ul><li>Create Worksheet Formulas</li><li>Insert Functions and use Autocomplete</li><li>Reuse Formulas and Functions</li><li>Create an Absolute Reference</li></ul><h4>Modifying a Worksheet</h4><ul><li>Insert, Delete, and Adjust Cells, Columns, and Rows</li><li>Move and Copy Data between Cells</li><li>Search for and Replace Data</li><li>Use Spellcheck and Proofing</li></ul><h4>Formatting a Worksheet</h4><ul><li>Apply Text Formats</li><li>Apply Number Formats</li><li>Align Cell Contents</li><li>Apply and Copy Cell Styles</li><li>Apply Basic Conditional Formatting</li></ul><h4>Printing Workbooks</h4><ul><li>Preview and Print a Workbook</li><li>Controlling Page Layout</li><li>Adding Headers and Footers</li><li>Set Print Titles and Print Ranges</li></ul><h4>Managing Workbooks</h4><ul><li>Manage Worksheets</li><li>Insert and Delete Worksheets</li><li>Manage Workbook and Worksheet Views</li><li>Manage Workbook Properties</li></ul></div>

Nexus Human

Office Skills

Excel Analytics

Excel - Excel Essentials and Formulas

This 2 hour session will combine knowledge as well as practical interactive scenarios to work through to assist delegates in evaluating themselves to identify areas they might need to improve on.&nbsp;The course will cover:<img src="https://images.cademy.co.uk/cd74539b-d6a2-46d2-9df6-1144792fca8b/ccf32df0-3acf-4386-9008-ca93939f3bb8/original.png" style="width: 188px; display: inline-block; vertical-align: bottom; margin: 5px 0px 5px 5px; text-align: right; cursor: auto; max-width: calc(100% - 5px); float: right; padding: 0px 1px; user-select: none; position: relative; box-sizing: border-box;" fr-original-style="width: 188px; display: inline-block; vertical-align: bottom; margin: 5px 0px 5px 5px; text-align: right; cursor: auto; max-width: calc(100% - 5px); float: right;" fr-original-class="fr-draggable"><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The purpose of the role (reminder)</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">How the role has evolved</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">What lessons can be gained so far</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">How do you create a culture of compliance</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">What good systems, policies and procedures look like</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Easy tips on what, where and how you should be looking</li></ul><h2 data-key="21" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Target Audience</h2><p data-key="23" data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJoZWFkaW5nLXRocmVlJTIyJTJDJTIyZGF0YSUyMiUzQSU3QiUyMmNsYXNzTmFtZSUyMiUzQW51bGwlN0QlMkMlMjJub2RlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMnRleHQlMjIlMkMlMjJsZWF2ZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMlRhcmdldCUyMEF1ZGllbmNlJTIyJTJDJTIybWFya3MlMjIlM0ElNUIlNUQlN0QlNUQlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyVGhlJTIwb25saW5lJTIwY291cnNlJTIwaXMlMjBzdWl0YWJsZSUyMGZvciUyMHN0YWZmJTIwb2YlMjBhbGwlMjBsZXZlbHMlMkMlMjBmcm9tJTIwc3VwcG9ydCUyMHN0YWZmJTIwdG8lMjBzZW5pb3IlMjBwYXJ0bmVycy4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCU1RCU3RA==" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">This online course is suitable for those new to the COFA role, those supporting the COFA and for those that would like a refresher of the role and their responsibilities.<h2 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Resources</h2>An information pack including the course slides, scenarios and suggested answers will be provided to all delegates, which may be useful for ongoing reference.<p data-key="30" data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJoZWFkaW5nLXRocmVlJTIyJTJDJTIyZGF0YSUyMiUzQSU3QiUyMmNsYXNzTmFtZSUyMiUzQW51bGwlN0QlMkMlMjJub2RlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMnRleHQlMjIlMkMlMjJsZWF2ZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMkNvdXJzZSUyME5vdGVzJTIyJTJDJTIybWFya3MlMjIlM0ElNUIlNUQlN0QlNUQlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyQ29tcHJlaGVuc2l2ZSUyMGFuZCUyMHVwJTIwdG8lMjBkYXRlJTIwY291cnNlJTIwbm90ZXMlMjB3aWxsJTIwYmUlMjBwcm92aWRlZCUyMHRvJTIwYWxsJTIwZGVsZWdhdGVzJTIwd2hpY2glMjBtYXklMjBiZSUyMHVzZWZ1bCUyMGZvciUyMG9uZ29pbmclMjByZWZlcmVuY2UlMjBvciUyMGNhc2NhZGUlMjB0cmFpbmluZy4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCUyQyU3QiUyMm9iamVjdCUyMiUzQSUyMmJsb2NrJTIyJTJDJTIydHlwZSUyMiUzQSUyMnBhcmFncmFwaCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlMjJjbGFzc05hbWUlMjIlM0FudWxsJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJ0ZXh0JTIyJTJDJTIybGVhdmVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJQbGVhc2UlMjBub3RlJTIwYSUyMHJlY29yZGluZyUyMG9mJTIwdGhlJTIwY291cnNlJTIwd2lsbCUyMCUyMiUyQyUyMm1hcmtzJTIyJTNBJTVCJTVEJTdEJTJDJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJub3QlMjAlMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMm1hcmslMjIlMkMlMjJ0eXBlJTIyJTNBJTIyYm9sZCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlN0QlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMmJlJTIwbWFkZSUyMGF2YWlsYWJsZS4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCU1RCU3RA==" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Please note a recording of the course will&nbsp;not&nbsp;be made available.<h2 data-key="35" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Speaker</h2><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><a href="https://dglegal.co.uk/the-team/sarah-charlton/" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Sarah Charlton, Consultant, DG Legal</a></h3><img src="https://images.cademy.co.uk/cd74539b-d6a2-46d2-9df6-1144792fca8b/be6c499f-96da-4f30-ab0b-c93b88a4fb82/original.png" style="width: 194px; display: inline-block; vertical-align: bottom; margin: 5px 0px; text-align: left; cursor: auto; max-width: calc(100% - 5px); float: left; padding: 0px 1px; user-select: none; position: relative; box-sizing: border-box;" fr-original-style="width: 194px; display: inline-block; vertical-align: bottom; margin: 5px 0px; text-align: left; cursor: auto; max-width: calc(100% - 5px); float: left;" fr-original-class="fr-draggable">Sarah has a BSc (Hons) in Applied Accounting and is a Fellow member of the Association of Chartered and Certified Accountants. Her career spans over 35 years working within the legal sector, fulfilling roles from COFA through to CEO. During her career she has worked with a number of legal regulators, professional bodies and government organisations. Sarah has been a member of the Institute of Legal Finance and Management throughout her career, qualifying as a Fellow member in 2005. Sarah also served as chairperson between 2010-2012 and continues to serve as an Executive Council Member.

This 2 hour session will combine knowledge as well as practical interactive scenarios to work through to assist delegates in evaluating themselves to identify areas they might need to improve on. 
The course will cover:

The purpose of the role (reminder)
How the role has evolved
What lessons can be gained so far
How do you create a culture of compliance
What good systems, policies and procedures look like
Easy tips on what, where and how you should be looking
Target Audience
This online course is suitable for those new to the COFA role, those supporting the COFA and for those that would like a refresher of the role and their responsibilities.
Resources
An information pack including the course slides, scenarios and suggested answers will be provided to all delegates, which may be useful for ongoing reference.
Please note a recording of the course will not be made available.
Speaker
Sarah Charlton, Consultant, DG Legal

Sarah has a BSc (Hons) in Applied Accounting and is a Fellow member of the Association of Chartered and Certified Accountants. Her career spans over 35 years working within the legal sector, fulfilling roles from COFA through to CEO. During her career she has worked with a number of legal regulators, professional bodies and government organisations. Sarah has been a member of the Institute of Legal Finance and Management throughout her career, qualifying as a Fellow member in 2005. Sarah also served as chairperson between 2010-2012 and continues to serve as an Executive Council Member.





Compliance Officer For Finance and Administration (COFA) Masterclass Course

This Real Estate Financial Modelling course will enhance delegates skills in crafting sophisticated financial models tailored for debt financing within the Real Estate sector.This is another One-Day course that is intended for the most ambitious modellers in the property industry, with a focus on constructing a flexible Real Estate Debt Model. This Real Estate Finance course follows on perfectly from our Real Estate Analyst and Real Estate Developer training courses. On this course delegates will... &bull; Learn how to build senior debt models with geared net cash flow. &bull; Explore and assess the influence of complex debt structures on returns. &bull; Develop advanced mezzanine debt models affecting project cash flows. &bull; Model joint venture structures for optimised partnerships. &bull; Calculate promote and profit share structures in Real Estate transactions. &bull; Construct sophisticated project cash flow models with mezzanine debts. Who will benefit from this course? &bull; Real Estate Professionals who have had exposure to Real Estate financial models &bull; Mid to Senior level Real Estate Analysts looking to develop their financial modelling skills in development, portfolio analysis &bull; Real Estate Developers &bull; Financial Analysts &bull; Investment Managers &bull; Banking and Finance Professionals in Real Estate Course Outline &bull; Mathematics of amortisation and debt finance. &bull; Basic senior debt models and geared net cash flow. &bull; Debt Cash Flow metrics: LTV, IRR and Interest Rate Dynamics. &bull; Mezzanine debt modelling. &bull; Joint Venture structures between developers and lender/equity partners. &bull; Promote and profit share structure calculations. &bull; Advanced project cash flows with mezzanine debt. Included in the Course<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</li><li value="2" style="font-size: 16px; box-sizing: border-box;" 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> For more information about the Real Estate Finance such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:E - s.musgrave@bayfieldtraining.comT - 01223 517851W - <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>



This Real Estate Financial Modelling course will enhance delegates skills in crafting sophisticated financial models tailored for debt financing within the Real Estate sector.
This is another One-Day course that is intended for the most ambitious modellers in the property industry, with a focus on constructing a flexible Real Estate Debt Model. This Real Estate Finance course follows on perfectly from our Real Estate Analyst and Real Estate Developer training courses.

On this course delegates will...
• Learn how to build senior debt models with geared net cash flow.
• Explore and assess the influence of complex debt structures on returns.
• Develop advanced mezzanine debt models affecting project cash flows.
• Model joint venture structures for optimised partnerships.
• Calculate promote and profit share structures in Real Estate transactions.
• Construct sophisticated project cash flow models with mezzanine debts.

Who will benefit from this course?
• Real Estate Professionals who have had exposure to Real Estate financial models
• Mid to Senior level Real Estate Analysts looking to develop their financial modelling skills in development, portfolio analysis
• Real Estate Developers
• Financial Analysts
• Investment Managers
• Banking and Finance Professionals in Real Estate

Course Outline
• Mathematics of amortisation and debt finance.
• Basic senior debt models and geared net cash flow.
• Debt Cash Flow metrics: LTV, IRR and Interest Rate Dynamics.
• Mezzanine debt modelling.
• Joint Venture structures between developers and lender/equity partners.
• Promote and profit share structure calculations.
• Advanced project cash flows with mezzanine debt.


Included in the Course
A Bayfield Training Certificate
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 Finance 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

This Real Estate Financial Modelling course will enhance delegates skills in crafting sophisticated financial models tailored for debt financing within the Real Estate sector.

Real Estate Finance (Debt Financing)

<div id="course-pills-1">Duration2 Days12 CPD hoursThis course is intended forThe audience for this course is anyone who wants to acquire foundation level knowledge on data centre infrastructure. This course is ideally suited for data centre new hires, internal data centre support staff, IT support staff who work in the data centre, helpdesk staff, vendors/suppliers who install/maintain data centre equipment, building maintenance staff including data centre cleaners and other supporting functions, and fresh graduates. This course is also well suited for individuals working in data centre business support functions such as sales/pre-sales, HR, Finance and business administration.OverviewThe DCFC course will prepare participants for entry into the exciting and high-growth data centre industry. It will ensure that participants acquire the required basic knowledge to take on a wide variety of jobs in the data centre industry. It will also provide the required knowledge and skill to further their training into specialised areas on data centre design/build, operations/governance or standards/compliance.The Data Centre Foundation Certificate (DCFCÂ©) is a 2-day course designed to deliver foundation knowledge about data centre facilities infrastructure. It provides participants with global overview and knowledge on data centres which will be of advantage to the participants who are looking at joining the ranks of professionals working in the data centre, ICT, infrastructure or the mechanical and electrical (M&amp;E) design industries. It will also form a solid foundation for participants who wish to pursue his/her studies either academically or to further his/her industry specialisation with professional certification courses on data centre design/build, operations/governance and/or standards/compliance. With the tremendous growth of data and the data centres to support it, the demand for data centre professionals will grow in tandem.</div><div id="course-pills-2"><h4>Introduction to Data Centres</h4><ul><li>History of data centres</li><li>Definition of different type data centres</li></ul><h4>Data Centre Standards</h4><ul><li>List of standards</li><li>Rating definitions</li></ul><h4>Data Centre Facilities Areas</h4><ul><li>Listing of all areas and their functions</li></ul><h4>Topology Designs</h4><ul><li>Definition of Ratings</li></ul><h4>Components of the Power Infrastructure</h4><ul><li>Utility power</li><li>Transformers</li><li>Generators</li><li>Fuel systems</li><li>ATS</li><li>UPS systems</li><li>Batteries</li><li>Electric panels</li><li>Cabling/busbar systems</li><li>Power rails/strips</li></ul><h4>Lights</h4><ul><li>Lights</li><li>Emergency lights</li></ul><h4>Cooling Infrastructure</h4><ul><li>Chillers</li><li>DX Systems</li><li>Evaporators</li><li>CRAC/CRAU/HVAC</li><li>Raised floor</li><li>Non-raised floor</li><li>Containment</li></ul><h4>ICT/Network Infrastructure</h4><ul><li>Equipment racks</li><li>Network cabling (fibre, copper)</li><li>Cable trays and pathways</li><li>TIA-606 labelling</li></ul><h4>Data Centre Security</h4><ul><li>Perimeter security</li><li>Physical protection</li><li>CCTV</li><li>Access control</li><li>Security management</li></ul><h4>Fire Suppression</h4><ul><li>Detection systems</li><li>Suppression systems</li><li>Prevention systems</li><li>Fire extinguishers</li><li>Fire Safety</li></ul><h4>Monitoring and reporting</h4><ul><li>DCIM</li><li>EMS/BMS</li></ul></div>

Service Design Courses (SDC)

IT Certifications

Cyber Security Foundation

Certified in Data Protection (CDP)

ICDL (International Certification of Digital Literacy)

Data Centre Foundation Certificate (DCFC)

In January 2024 alone, reports were published about the SRA taking enforcement action against 3 firms and 4 individuals for failure to comply with the Money Laundering Regulations 2017. The fines issued for these non-compliances total over &pound;570,000 plus costs. The absence of staff training, or requirement to complete additional training, was noted in a number of these cases.Many of the breaches resulting in enforcement action involved failures by the fee earners to conduct appropriate due diligence, adequately check the source of funds and/or wealth or recognise and report red flags. As highlighted by enforcement action being taken against individuals as well as firms, fee earners cannot hide behind their firm when AML failures occur and may be held personally accountable by the SRA for non-compliances with the MLR 2017.This course will cover the following to assist fee earners in the application of AML in their casework.<ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">How to comply with your obligations and stay compliant</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Written CRA &amp; MRA</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Client</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Booms</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Risks &ndash; what to consider?</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">PCPs &ndash; CDD &amp;EDD</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">POCA / TA</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">SOF and SOW</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">On going monitoring</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Reporting to MLRO/MLCO</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Tipping off</li></ul><h2 fr-original-style="" style="box-sizing: border-box;">Target Audience</h2>The online course is suitable for fee earners or legal practitioners that want to improve their AML knowledge.<h2 data-key="21" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Resources</h2>Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training.<p data-key="30" data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJoZWFkaW5nLXRocmVlJTIyJTJDJTIyZGF0YSUyMiUzQSU3QiUyMmNsYXNzTmFtZSUyMiUzQW51bGwlN0QlMkMlMjJub2RlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMnRleHQlMjIlMkMlMjJsZWF2ZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMkNvdXJzZSUyME5vdGVzJTIyJTJDJTIybWFya3MlMjIlM0ElNUIlNUQlN0QlNUQlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyQ29tcHJlaGVuc2l2ZSUyMGFuZCUyMHVwJTIwdG8lMjBkYXRlJTIwY291cnNlJTIwbm90ZXMlMjB3aWxsJTIwYmUlMjBwcm92aWRlZCUyMHRvJTIwYWxsJTIwZGVsZWdhdGVzJTIwd2hpY2glMjBtYXklMjBiZSUyMHVzZWZ1bCUyMGZvciUyMG9uZ29pbmclMjByZWZlcmVuY2UlMjBvciUyMGNhc2NhZGUlMjB0cmFpbmluZy4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCUyQyU3QiUyMm9iamVjdCUyMiUzQSUyMmJsb2NrJTIyJTJDJTIydHlwZSUyMiUzQSUyMnBhcmFncmFwaCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlMjJjbGFzc05hbWUlMjIlM0FudWxsJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJ0ZXh0JTIyJTJDJTIybGVhdmVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJQbGVhc2UlMjBub3RlJTIwYSUyMHJlY29yZGluZyUyMG9mJTIwdGhlJTIwY291cnNlJTIwd2lsbCUyMCUyMiUyQyUyMm1hcmtzJTIyJTNBJTVCJTVEJTdEJTJDJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJub3QlMjAlMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMm1hcmslMjIlMkMlMjJ0eXBlJTIyJTNBJTIyYm9sZCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlN0QlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMmJlJTIwbWFkZSUyMGF2YWlsYWJsZS4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCU1RCU3RA==" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Please note a recording of the course will&nbsp;not&nbsp;be made available.<h2 data-key="35" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Speaker</h2><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><a href="https://dglegal.co.uk/the-team/helen-torresi/" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Helen Torresi, Consultant, DG Legal</a></h3>Helen is a qualified solicitor with a diverse professional background spanning leadership roles in both the legal and tech/corporate sectors. Throughout her career, she has held key positions such as COLP, HOLP, MLCO, MLRO and DPO for law firms and various regulated businesses and services.Helen&rsquo;s specialised areas encompass AML, complaint and firm negligence handling, DPA compliance, file review and auditing, law management, and operational effectiveness in law firms, particularly in conveyancing (CQS).

In January 2024 alone, reports were published about the SRA taking enforcement action against 3 firms and 4 individuals for failure to comply with the Money Laundering Regulations 2017. The fines issued for these non-compliances total over £570,000 plus costs. The absence of staff training, or requirement to complete additional training, was noted in a number of these cases.
Many of the breaches resulting in enforcement action involved failures by the fee earners to conduct appropriate due diligence, adequately check the source of funds and/or wealth or recognise and report red flags. As highlighted by enforcement action being taken against individuals as well as firms, fee earners cannot hide behind their firm when AML failures occur and may be held personally accountable by the SRA for non-compliances with the MLR 2017.
This course will cover the following to assist fee earners in the application of AML in their casework.
How to comply with your obligations and stay compliant
Written CRA & MRA
Client
Booms
Risks – what to consider?
PCPs – CDD &EDD
POCA / TA
SOF and SOW
On going monitoring
Reporting to MLRO/MLCO
Tipping off
Target Audience
The online course is suitable for fee earners or legal practitioners that want to improve their AML knowledge.
Resources
Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training.
Please note a recording of the course will not be made available.
Speaker
Helen Torresi, Consultant, DG Legal
Helen is a qualified solicitor with a diverse professional background spanning leadership roles in both the legal and tech/corporate sectors. Throughout her career, she has held key positions such as COLP, HOLP, MLCO, MLRO and DPO for law firms and various regulated businesses and services.
Helen’s specialised areas encompass AML, complaint and firm negligence handling, DPA compliance, file review and auditing, law management, and operational effectiveness in law firms, particularly in conveyancing (CQS).

6404 Courses

Inventory Management

By LearnDrive UK

Inventory Control

By LearnDrive UK

Advanced Diploma in Business Administration

By John Academy

MS Visio 365 Online

By John Academy

Microsoft Excel Masterclass in 2021

By John Academy

The New functions in Microsoft Excel in 2021

By John Academy

Top 50 MS Excel Advanced Tips to Upgrade Skill to next Level

By John Academy

Basic Excel Spreadsheet

By John Academy

Materials Engineering and Processing - CPD Certified

By Studyhub UK

Paralegal & Legal Advisor - Advanced Diploma

By Studyhub UK

Search By Location