Name: Excel 2016 Formulas and Functions
Price: 25 GBP
Availability: InStock

<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div>
			<div></div>
		</div>
				</div>
				</div>
				<div>
				<div>
			
				</div>
				<div>
				<div>
					<div><p>Gain the solid skills and knowledge to kickstart a successful career and learn from the experts with this step-by-step Advanced Excel: Pivot Table, Pivot Charts, Slicers and Timelines training course. This Advanced Excel: Pivot Table, Pivot Charts, Slicers and Timelines course for Consistent Profits has been specially designed to help learners gain a good command of Advanced Excel: Pivot Table, Pivot Charts, Slicers and Timelines, providing them with a solid foundation of knowledge to understand relevant professionals' job roles.</p><p>Through this Advanced Excel: Pivot Table, Pivot Charts, Slicers and Timelines course, you will gain a theoretical understanding of Advanced Excel: Pivot Table, Pivot Charts, Slicers and Timelines and others relevant subjects that will increase your employability in this field, help you stand out from the competition, and boost your earning potential in no time.</p><p>Not only that, but this Advanced Excel: Pivot Table, Pivot Charts, Slicers and Timelines training includes up-to-date knowledge and techniques that will ensure you have the most in-demand skills to rise to the top of the industry. </p><p>This course is fully CPD-accredited and broken down into several manageable modules, making it ideal for aspiring professionals.</p></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</div></section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2><b> Learning outcome</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Familiar yourself with the recent development and updates of the relevant industry</span>
									</li>
								<li>
											<span>
													</span>
										<span>Know how to use your theoretical knowledge to adapt in any working environment</span>
									</li>
								<li>
											<span>
													</span>
										<span>Get help from our expert tutors anytime you need</span>
									</li>
								<li>
											<span>
													</span>
										<span>Access to course contents that are designed and prepared by industry professionals</span>
									</li>
								<li>
											<span>
													</span>
										<span>Study at your convenient time and from wherever you want</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					</div>
				</div>
				<div>
				<div>
					
			</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> <b>Why should I take this course?</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Affordable premium-quality E-learning content, you can learn at your own pace.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will receive a completion certificate upon completing the course.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Internationally recognized Accredited Qualification will boost up your resume.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will learn the researched and proven approach adopted by successful people to transform their careers.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will be able to incorporate various techniques successfully and understand your customers better.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> <b>Requirements</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>No formal qualifications required, anyone from any academic background can take this course.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Access to a computer or digital device with internet connectivity.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section><div>
                            <div>
                                <h2>Course Curriculum</h2>
                            </div>
                            			<div>
				

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4"><strong>Advanced Excel: Pivot Table, Pivot Charts, Slicers and Timelines</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Getting started with your Pivot Table</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Drill Down</td><td><span>🕐 00:01:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Managing the Field List</td><td><span>🕐 00:02:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Changing the Calculation type with Value Field Settings</td><td><span>🕐 00:06:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Growing your Pivot Table with Multiple Fields</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Formatting the Pivot Table</td><td><span>🕐 00:05:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Sorting and Filtering the Pivot Table</td><td><span>🕐 00:03:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Creating a Dashboard with Slicers, Timelines and Pivot Charts</td><td><span>🕐 00:09:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Reporting by day, month, qtr, or year within the Pivot Table</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Refreshing the Pivot Data with new data</td><td><span>🕐 00:03:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Adding your own calculations into the Pivot Table</td><td><span>🕐 00:03:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>The power of the Filter Section in the Pivot Table</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>PowerQuery</td><td><span>🕐 00:12:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>PowerPivot</td><td><span>🕐 00:21:00</span></td>
				</tr>
				</tbody></table></div>

			</div>
		                        </div>

Skill Up

Gain the solid skills and knowledge to kickstart a successful career and learn from the experts with this

Advanced Excel: Pivot Table, Pivot Charts, Slicers and Timelines

General Admission

<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div>
			<div></div>
		</div>
				</div>
				</div>
				<div>
				<div>
			
				</div>
				<div>
				<div>
					<div><p>Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step training course. This Microsoft Excel: PowerQuery and PowerPivot has been specially designed to help learners gain a good command of PowerQuery and PowerPivot, providing them with a solid foundation of knowledge to become a qualified professional.</p><p>Through this Microsoft Excel: PowerQuery and PowerPivot, you will gain both practical and theoretical understanding of PowerQuery and PowerPivot that will increase your employability in this field, help you stand out from the competition and boost your earning potential in no time.</p><p>Not only that, but this training includes up-to-date knowledge and techniques that will ensure you have the most in-demand skills to rise to the top of the industry. This qualification is fully accredited, broken down into several manageable modules, ideal for aspiring professionals.</p></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</div></section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2><b> Learning outcome</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Familiar yourself with the recent development and updates of the relevant industry</span>
									</li>
								<li>
											<span>
													</span>
										<span>Know how to use your theoretical knowledge to adapt in any working environment</span>
									</li>
								<li>
											<span>
													</span>
										<span>Get help from our expert tutors anytime you need</span>
									</li>
								<li>
											<span>
													</span>
										<span>Access to course contents that are designed and prepared by industry professionals</span>
									</li>
								<li>
											<span>
													</span>
										<span>Study at your convenient time and from wherever you want</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					</div>
				</div>
				<div>
				<div>
					
			</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> <b>Why should I take this course?</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Affordable premium-quality E-learning content, you can learn at your own pace.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will receive a completion certificate upon completing the course.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Internationally recognized Accredited Qualification will boost up your resume.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will learn the researched and proven approach adopted by successful people to transform their careers.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will be able to incorporate various techniques successfully and understand your customers better.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> <b>Requirements</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>No formal qualifications required, anyone from any academic background can take this course.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Access to a computer or digital device with internet connectivity.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section><div>
                            <div>
                                <h2>Course Curriculum</h2>
                            </div>
                            			<div>
				

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4"><strong>Microsoft Excel: PowerQuery and PowerPivot</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>pivot table power query power pivot - 1</td><td><span>🕐 00:09:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>pivot table power query power pivot - 2</td><td><span>🕐 00:01:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>pivot table power query power pivot - 3</td><td><span>🕐 00:02:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>pivot table power query power pivot - 4</td><td><span>🕐 00:03:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>pivot table power query power pivot - 5</td><td><span>🕐 00:01:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>pivot table power query power pivot - 6</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>pivot table power query power pivot - 7</td><td><span>🕐 00:08:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>pivot table power query power pivot - 8</td><td><span>🕐 00:05:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>pivot table power query power pivot - 9</td><td><span>🕐 00:03:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>pivot table power query power pivot - 10</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>pivot table power query power pivot - 11</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>pivot table power query power pivot - 12</td><td><span>🕐 00:02:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>pivot table power query power pivot - 13</td><td><span>🕐 00:03:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>pivot table power query power pivot - 14</td><td><span>🕐 00:05:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>pivot table power query power pivot - 15</td><td><span>🕐 00:02:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>pivot table power query power pivot - 16</td><td><span>🕐 00:03:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>pivot table power query power pivot - 17</td><td><span>🕐 00:03:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>pivot table power query power pivot - 18</td><td><span>🕐 00:08:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>pivot table power query power pivot - 19</td><td><span>🕐 00:02:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>pivot table power query power pivot - 20</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>pivot table power query power pivot - 21</td><td><span>🕐 00:05:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>pivot table power query power pivot - 22</td><td><span>🕐 00:09:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>pivot table power query power pivot - 23</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>pivot table power query power pivot - 24</td><td><span>🕐 00:03:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>pivot table power query power pivot - 25</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>pivot table power query power pivot - 26</td><td><span>🕐 00:09:00</span></td>
				</tr>
				</tbody></table></div>

			</div>
		                        </div>

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Microsoft Excel: PowerQuery and PowerPivot

<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div>
			<div></div>
		</div>
				</div>
				</div>
				<div>
				<div>
			
				</div>
				<div>
				<div>
					<div><p>Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step training course. This Microsoft Excel Training: Depreciation Accounting has been specially designed to help learners gain a good command of Microsoft Excel Training: Depreciation Accounting, providing them with a solid foundation of knowledge to become a qualified professional.</p><p>Through this Microsoft Excel Training: Depreciation Accounting, you will gain both practical and theoretical understanding of Microsoft Excel Training: Depreciation Accounting that will increase your employability in this field, help you stand out from the competition and boost your earning potential in no time.</p><p>Not only that, but this training includes up-to-date knowledge and techniques that will ensure you have the most in-demand skills to rise to the top of the industry. This qualification is fully accredited, broken down into several manageable modules, ideal for aspiring professionals.</p></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</div></section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2><b> Learning outcome</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Familiar yourself with the recent development and updates of the relevant industry</span>
									</li>
								<li>
											<span>
													</span>
										<span>Know how to use your theoretical knowledge to adapt in any working environment</span>
									</li>
								<li>
											<span>
													</span>
										<span>Get help from our expert tutors anytime you need</span>
									</li>
								<li>
											<span>
													</span>
										<span>Access to course contents that are designed and prepared by industry professionals</span>
									</li>
								<li>
											<span>
													</span>
										<span>Study at your convenient time and from wherever you want</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					</div>
				</div>
				<div>
				<div>
					
			</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> <b>Why should I take this course?</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Affordable premium-quality E-learning content, you can learn at your own pace.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will receive a completion certificate upon completing the course.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Internationally recognized Accredited Qualification will boost up your resume.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will learn the researched and proven approach adopted by successful people to transform their careers.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will be able to incorporate various techniques successfully and understand your customers better.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> <b>Requirements</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>No formal qualifications required, anyone from any academic background can take this course.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Access to a computer or digital device with internet connectivity.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section><div>
                            <div>
                                <h2>Course Curriculum</h2>
                            </div>
                            			<div>
				

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4"><strong> Introduction</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Introduction</td><td><span>🕐 00:03:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Minimum requirements before taking the course</td><td><span>🕐 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Download master depreciation template</td><td><span>🕐 00:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Depreciation Amortization and Related Terms</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Definition of Depreciation</td><td><span>🕐 00:02:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Amortization: Depreciation vs Amortization</td><td><span>🕐 00:02:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Related Terms to Depreciation</td><td><span>🕐 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Various Methods of Depreciation and Depreciation Accounting</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Most Common Methods of Depreciation</td><td><span>🕐 00:09:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Accounting for Depreciation</td><td><span>🕐 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Depreciation and Taxation</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Depreciation Tax Shield</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Depreciation Tax Shield Under Various Depreciation Methods</td><td><span>🕐 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Master Depreciation Model</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Introduction and basics of Depreciation Model in Excel</td><td><span>🕐 00:01:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Deep Dive into Depreciation Model</td><td><span>🕐 00:07:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>How to use the model with Example</td><td><span>🕐 00:10:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Advanced functionalities of the Model</td><td><span>🕐 00:11:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Conclusion</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Thank you for Enrolling</td><td><span>🕐 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Resources</strong></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Resources - Microsoft Excel Training: Depreciation Accounting</td><td><span>🕐 00:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Assignment</strong></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Assignment - Microsoft Excel Training Depreciation Accounting</td><td><span>🕐 00:00:00</span></td>
				</tr>
				</tbody></table></div>

			</div>
		                        </div>

Microsoft Excel Training: Depreciation Accounting

<p><strong>***Limited Time Offer***</strong></p> <p>Tired of browsing and searching for the course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this 14-in-1 extensive bundle that has everything you need to succeed in Real Estate and Property Development and other relevant fields!</p> <p>After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Real Estate and Property Development bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Real Estate and Property Development course that will enhance your skills and prepare you for the competitive job market.</p> <p>Also, our Real Estate and Property Development experts are available for answering your queries and help you along your learning journey. Advanced audio-visual learning modules of these courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once.</p> <p>Furthermore, to help you showcase your expertise in Real Estate and Property Development, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest.</p> <p><strong>This Real Estate and Property Development Bundle Consists of the following Premium courses: </strong></p> <ul> <li><strong>Course 01: </strong>Real Estate Investor Level 3</li><li><strong>Course 02: </strong>Property Development Diploma</li><li><strong>Course 03: </strong>Decision-Making</li><li><strong>Course 04: </strong>Property Law and Legislation</li><li><strong>Course 05: </strong>Mortgage Adviser Course</li><li><strong>Course 06: </strong>Social Housing and Tenant Management Level 2</li><li><strong>Course 07: </strong>Contract Manager Diploma</li><li><strong>Course 08: </strong>Understanding Wills and Probate Laws - Level 2</li><li><strong>Course 09: </strong>Marketing Fundamentals</li><li><strong>Course 10: </strong>Sales: Psychology of Customers</li><li><strong>Course 11: </strong>Digital Marketing and Advertising Level 3</li><li><strong>Course 12: </strong>Business Analysis Level 3</li><li><strong>Course 13: </strong>Business Writing</li><li><strong>Course 14: </strong>Effective Communication Skills</li></ul> <p><strong>Benefits you'll get choosing Apex Learning:</strong></p> <ul> <li>Pay once and get lifetime access to 14 CPD courses</li><li>Free e-Learning App for engaging reading materials &amp; helpful assistance</li><li>Certificates, student ID for the title course included in a one-time fee</li><li>Free up your time - don't waste time and money travelling for classes</li><li>Accessible, informative modules designed by expert instructors</li><li>Learn at your ease - anytime, from anywhere</li><li>Study the course from your computer, tablet or mobile device</li><li>CPD accredited course - improve the chance of gaining professional skills</li></ul> <p><strong>How will I get my Certificate?</strong></p> <p>After successfully completing the course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.</p> <ul> <li><strong>PDF Certificate: Free (For The Title Course)</strong></li><li><strong>Hard Copy Certificate: Free (For The Title Course)</strong></li></ul><p>Curriculum of <strong>Bundle</strong></p> <p><strong>Course 01: Real Estate Investor Level 3</strong></p> <ul> <li>Property Development</li><li>Different Types of Property</li><li>Land Law Principles- Rights and Interests</li><li>Ownership, Co-ownership and Possession of the Property</li><li>Lease Bailment, License, Mortgage and Insurance Related Law</li><li>Real Estate Investment</li><li>Strategies for a Real Estate Investor</li><li>Marketing Your Property</li><li>Introduction to Property Management</li><li>The Property Management Process</li><li>The Role and Responsibilities of a Property Manager</li><li>Listing Properties and Marketing</li></ul> <p><strong>Course 02: Property Development Diploma</strong></p> <ul> <li>Introduction to Property Development</li><li>Different Types of Property</li><li>Property Research</li><li>Property and the Law</li><li>Different Methods of Finance Option</li><li>Building Regulation</li><li>The Planning Process</li><li>Project Management</li><li>Marketing Your Property</li></ul> <p><strong>Course 03: Decision-Making<br /></strong></p> <ul> <li>Module 01: What is Decision Making?</li><li>Module 02: Stress and Its Impact</li><li>Module 03: Time Stress and Decision Making</li><li>Module 04: Personal Level Decision making Under Stress</li><li>Module 05: Organisational Level Decision making Under Stress</li><li>Module 06: Decision Making for Conflict Management</li></ul> <p><strong>Course 04: Property Law and Legislation</strong></p> <ul> <li>Introduction to Property Law</li><li>Land Law Principles- Rights and Interests</li><li>Registered and Unregistered Land</li><li>Ownership and Possession of the Property</li><li>Co-Ownership in Property</li><li>Leases and Bailment</li><li>Property Law: License</li><li>The Mortgage Law</li><li>Insurance for Property Maintenance</li><li>Proprietary Estoppel (Property Rights)</li><li>Security Interests in Property</li></ul> <p><strong>Course 05: Mortgage Adviser Course</strong></p> <ul> <li>Introduction to Mortgage and Mortgage Adviser</li><li>Basics of Mortgage Purchase</li><li>Understanding the Buyer's Perspective</li><li>Mortgage Finances</li><li>Being a Successful Mortgage Advisor</li><li>Mortgage Regulation and Law: UK</li><li>The Mortgage Conduct of Business (MCOB)</li><li>The Mortgage Conduct of Business (MCOB), Part 2</li><li>UK Mortgage Market and Borrowers</li></ul> <p><strong>Course 06: Social Housing and Tenant Management Level 2</strong></p> <ul> <li>Introduction to Social Housing</li><li>Tenant Selection and Tenant Management</li><li>Managing Rental Income and Arrears</li><li>Maintenance, Safety, and Security of Social Housing</li><li>Resident Involvement in Social Housing</li><li>Dealing with Anti-Social Behaviours</li><li>Career Prospects of Social Housing Manager</li></ul> <p><strong>Course 07: Contract Manager Diploma</strong></p> <ul> <li>Introduction to Contract Management</li><li>Classification of Contracts</li><li>Contract Lifecycle - Understanding The Stages</li><li>Principles of English Contract Law</li><li>Contract Management Plan &amp; Efficiency</li><li>Contract Manager's Roles, Responsibilities &amp; Career Opportunities</li><li>Risks, Disputes &amp; Supplier Relation In Contract Management</li><li>Negotiation, Variation &amp; Changes in Contract Management</li><li>Contract Management Process Evaluation &amp; KPI</li><li>Contract Review, Challenges and Future</li></ul> <p><strong>Course 08: Understanding Wills and Probate Laws - Level 2</strong></p> <ul> <li>An Introduction to Estate and Wills</li><li>Making a Will</li><li>Trusts and Dispositions</li><li>Intestacy</li><li>Probate</li><li>Correcting Errors in a Will</li><li>Revocation of Wills</li><li>Power of Attorney</li></ul> <p><strong>Course 09: Marketing Fundamentals</strong></p> <ul> <li>Introduction to Marketing Fundamentals</li><li>Definitions of Marketing</li><li>Traditional vs Contemporary Marketing</li><li>Marketing Management Orientations</li><li>Understand your Customers</li><li>Segmentation</li></ul> <p><strong>Course 10: Sales: Psychology of Customers<br /></strong></p> <ul> <li>Introduction</li><li>Introducing A.S.K - concentrating on 'A' for ATTRACT.</li><li>Section 3 The 'S' of A.S.K. - SERVING</li><li>Section 4 The K of A.S.K</li><li>Section 5 ...And lastly...</li></ul> <p><strong>Course 11: Digital Marketing and Advertising Level 3</strong></p> <ul> <li>Introduction</li><li>General Tips &amp; Tricks Series</li><li>SEO (Search Engine Optimisation)</li><li>YouTube</li><li>Google Adwords</li><li>Google Analytics</li><li>Email Marketing</li><li>Linkedln</li><li>Twitter</li><li>Facebook</li><li>Instagram</li><li>Mobile App</li></ul> <p><strong>Course 12: Business Analysis Level 3</strong></p> <ul> <li>Introduction to Business Analysis</li><li>Business Processes</li><li>Business Analysis Planning and Monitoring</li><li>Strategic Analysis and Product Scope</li><li>Solution Evaluation</li><li>Investigation Techniques</li><li>Ratio Analysis</li><li>Stakeholder Analysis and Management</li><li>Process Improvement with Gap Analysis</li><li>Documenting and Managing Requirements</li><li>Career Prospect as a Business Analyst in the UK</li></ul> <p><strong>Course 13: Business Writing</strong></p> <ul> <li>Words to Cut</li><li>Building Strong Sentences</li><li>SCQA</li><li>How to Write Punchy Summaries</li><li>Words that Work, Feedback that Improves</li><li>Proof Reading Makes Perfect</li></ul> <p><strong>Course 14: Effective Communication Skills</strong></p> <ul> <li>Introduction To Communication - Goals &amp; Benefits</li><li>Key Principles Of Communication</li><li>We are Always Communicating</li><li>Fundamentals Of Communication - Part 1</li><li>Fundamentals Of Communication - Part 2</li><li>Great Communication Tips - Part 1</li><li>Great Communication Tips - Part 2</li><li>Self-Talk &amp; Powerful Language</li><li>Miscommunication</li><li>Still MORE Great Tips! Part 1</li><li>Still MORE Great Tips! Part 2</li><li>Still MORE Great Tips! Part 3</li><li>Final Thoughts and Suggestions</li><li>PROMO Communication (BEST)</li></ul><h2>
        
        <div>CPD</div>
    </h2>

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

                        <div id="who_is_this_course_for">
                             <p>Anyone from any background can enrol in this Real Estate and Property Development bundle. </p> 
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>Our Real Estate and Property Development is fully compatible with PC's, Mac's, laptops, tablets and Smartphone devices.</p> 
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Having this various expertise will increase the value of your CV and open you up to multiple job sectors.</p> 
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Apex Learning

Real Estate: Real Estate and Property Development

<h3><b>Overview</b></h3>
<span>Gain the most in-demand skills in the foreign exchange market with our <strong>Forex Trading and Anti Money Laundering Complete Diploma</strong></span><b> </b><span>course.</span>

<span>This industry expert-designed <strong>Forex Trading and Anti Money Laundering Complete Diploma</strong></span><span> course will educate you </span><span>on</span><span> every </span><span>basics </span><span>and help you develop essential skills and much more. Furthermore, it will coach you in all the fundamentals and provide you with a solid foundation to become a qualified professional.</span>

<span>So, enrol in the <strong>Forex Trading and Anti Money Laundering Complete Diploma</strong></span><span> course and enjoy immersive, engaging training.</span>
<h3><b>How will I get my certificate?</b></h3>
You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.
<h3><b>Who is this course for?</b></h3>
<span>There is no experience or previous qualifications required for enrolment on this Forex Trading and Anti Money Laundering Complete Diploma</span><span>. It is available to all students, of all academic backgrounds.</span>
<h3><b>Requirements</b></h3>
<span>Our Forex Trading and Anti Money Laundering Complete Diploma</span><span> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.</span>

<span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span>
<h3><b>Career path</b></h3>
<span>Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business &amp; Management , Admin, Accountancy &amp; Finance, Secretarial &amp; PA, Teaching &amp; Mentoring etc.</span> <h3>Course Curriculum</h3><div><p>3 sections • 18 lectures • 05:17:00 total length</p></div><div><div><div><div><div></div></div></div></div><div><div><div><div><div><div><p>•Introduction to Forex Trading: 00:11:00</p></div><div><div><p>•Major Currencies and Market Structure87: 00:10:00</p></div><div><div><p>•Kinds of Foreign Exchange Market: 00:14:00</p></div><div><div><p>•Money Management: 00:11:00</p></div><div><div><p>•Fundamental Analysis: 00:21:00</p></div><div><div><p>•Technical Analysis: 00:32:00</p></div><div><div><p>•Pitfalls and Risks: 00:11:00</p></div><div><div><p>•Managing Risk: 00:16:00</p></div><div><div><p>•Trading Psychology: 00:14:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Module 01: Introduction to Money Laundering: 00:15:00</p></div><div><div><p>•Module 02: Proceeds of Crime Act 2002: 00:18:00</p></div><div><div><p>•Module 03: Development of Anti-Money Laundering Regulation: 00:24:00</p></div><div><div><p>•Module 04: Responsibility of the Money Laundering Reporting Office: 00:19:00</p></div><div><div><p>•Module 05: Risk-based Approach: 00:22:00</p></div><div><div><p>•Module 06: Customer Due Diligence: 00:22:00</p></div><div><div><p>•Module 07: Record Keeping: 00:19:00</p></div><div><div><p>•Module 08: Suspicious Conduct and Transactions: 00:20:00</p></div><div><div><p>•Module 09: Awareness and Training: 00:18:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Finance Cert & Exam Prep

Accredited Trading

Anti-Money Laundering (AML)

Forex Trading

Money Laundering

Trainers Course

Forex Trading and Anti Money Laundering Complete Diploma

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Step into the realm of legal mastery, where property landscapes unfold as your canvas, and tax intricacies become your art-introducing the "<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">UK Property Law and Taxation Fundamentals for Lawyers</strong>" bundle - an odyssey through the corridors of property jurisprudence. Imagine harnessing the power of knowledge as you navigate the ever-shifting tides of real estate law.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">With each course of the <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">UK Property Law and Taxation Fundamentals for Lawyers</strong> bundle, you craft your legal saga, from untangling the complexities of wills to orchestrating seamless property transactions through contract expertise. Embark on a journey where "<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">UK Property Law and Taxation Fundamentals for Lawyers</strong>" resounds as a guiding mantra woven harmoniously into each lesson. Empower your practice and wield your legal quill with unwavering precision. Unleash the potential of property mastery today!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">The Eight CPD Accredited courses that the bundle includes are:</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 1:</strong> Property Law and Taxation for Accountants and Lawyers<br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 2:</strong> Wills and Probate Law - Level 3<br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 3:</strong> Contract Management Course<br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 4:</strong> Conveyancing- Online Diploma Course<br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 5:</strong> Mortgage Adviser Course<br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 6:</strong> Property Development Diploma<br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 7:</strong> Estate Agent<br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 8:</strong> Social Housing Management</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Learning Outcomes</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Master complex property law concepts for adept handling of real estate legalities.</li><li fr-original-style="" style="box-sizing: border-box;">Navigate property taxation intricacies, optimising financial strategies.</li><li fr-original-style="" style="box-sizing: border-box;">Contract Management: Craft, manage, and safeguard contracts for seamless property transactions.</li><li fr-original-style="" style="box-sizing: border-box;">Handle property transfers, due diligence, and leases with confidence.</li><li fr-original-style="" style="box-sizing: border-box;">Manage inheritance, wills, probate, and estate planning comprehensively.</li><li fr-original-style="" style="box-sizing: border-box;">Provide informed guidance on mortgages, agreements, and regulations.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Experience a realm of legal mastery with the comprehensive "<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">UK Property Law and Taxation Fundamentals for Lawyers</strong>&#39;&#39; bundle. From dissecting complex contracts to facilitating smooth property transactions, this <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">UK Property Law and Taxation Fundamentals for Lawyers </strong>bundle will enrich you with theoretical insights directly applicable to your legal practice.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Unlock the secrets of Wills and Probate Law - Level 3, ensuring comprehensive estate planning and management. Elevate your abilities as an Estate Agent, seamlessly bridging clients with properties. With a strong foundation in property development, conveyancing, estate management, and mortgage advisory, you become the go-to legal expert in property law matters. In a landscape where property disputes and taxation intricacies are commonplace, this <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">UK Property Law and Taxation Fundamentals for Lawyers</strong> bundle empowers you to shine as a legal beacon. With reverberating throughout the courses, you&#39;re armed with both knowledge and spirit.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Whether you&#39;re a seasoned practitioner or venturing into this terrain anew, the <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">UK Property Law and Taxation Fundamentals for Lawyers</strong> bundle reshape your legal toolkit. Empower your career, cater to client needs, and navigate legal complexities effortlessly. The "<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">UK Property Law and Taxation Fundamentals for Lawyers</strong>" bundle is your compass to navigating the dynamic legal terrain with finesse and prowess. Enrol today to sculpt a path of distinction.</p><h2 fr-original-style="" style="box-sizing: border-box;">
        
        <div fr-original-style="" style="box-sizing: border-box;">CPD</div>
    </h2>

                        <div id="cpd" fr-original-style="" style="box-sizing: border-box;">
                            <div fr-original-style="" style="box-sizing: border-box;">
                                <div fr-original-style="" style="box-sizing: border-box;">
                                    <div fr-original-style="" style="box-sizing: border-box;">
                                        80 CPD hours / points
                                    </div>
                                        <div fr-original-style="" style="box-sizing: border-box;">
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2 fr-original-style="" style="box-sizing: border-box;">
        
        <div fr-original-style="" style="box-sizing: border-box;">Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for" fr-original-style="" style="box-sizing: border-box;">
                            <ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Experienced Lawyers</li><li fr-original-style="" style="box-sizing: border-box;">Aspiring Legal Professionals</li><li fr-original-style="" style="box-sizing: border-box;">Contract Managers</li><li fr-original-style="" style="box-sizing: border-box;">Real Estate Agents</li><li fr-original-style="" style="box-sizing: border-box;">Mortgage Advisors</li><li fr-original-style="" style="box-sizing: border-box;">Estate Planners</li></ul>
                        </div><h2 fr-original-style="" style="box-sizing: border-box;">
        
        <div fr-original-style="" style="box-sizing: border-box;">Requirements</div>
    </h2>

                        <div id="requirements" fr-original-style="" style="box-sizing: border-box;">
                            <p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Without any formal requirements, you can delightfully enrol in thiscourse.</p>
                        </div><h2 fr-original-style="" style="box-sizing: border-box;">
        
        <div fr-original-style="" style="box-sizing: border-box;">Career path</div>
    </h2>

                        <div id="career_path" fr-original-style="" style="box-sizing: border-box;">
                            <ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Property Lawyer</li><li fr-original-style="" style="box-sizing: border-box;">Tax Consultant</li><li fr-original-style="" style="box-sizing: border-box;">Contract Manager</li><li fr-original-style="" style="box-sizing: border-box;">Conveyancer</li><li fr-original-style="" style="box-sizing: border-box;">Mortgage Advisor</li><li fr-original-style="" style="box-sizing: border-box;">Property Developer</li><li fr-original-style="" style="box-sizing: border-box;">Estate Agent</li></ul>
                        </div><h2 fr-original-style="" style="box-sizing: border-box;">
        
        <div fr-original-style="" style="box-sizing: border-box;">Certificates</div>
    </h2>

                        <div id="optional_extras" fr-original-style="" style="box-sizing: border-box;">
                                    <h4 fr-original-style="" style="box-sizing: border-box;">CPD Certificate Of Completion</h4>
        <p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">
            Digital certificate -
            Included
        </p>
            <div fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">8 Digital Certificates Are Included With This Bundle</p></div>
        <h4 fr-original-style="" style="box-sizing: border-box;">CPD Quality Standard Hardcopy Certificate (FREE UK Delivery)</h4>
        <p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">
            Hard copy certificate -
            &pound;9.99
        </p>
            <div fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Hardcopy Transcript: &pound;9.99</p></div>

                        </div>

NextGen Learning

Legal Practice Course (LPC)

Bar Professional Training Course (BPTC)

Bar Practice Course (BPC)

Licensed Conveyancer

Legal Practice

Graduate Diploma in Law (GDL)

UK Property Law and Taxation Fundamentals for Lawyers - 8 Courses Bundle

<div>
						<div>
				<div>
									<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
								<div>
				<p><span>Register on the Excel 2016 Advanced Formulas and Functions today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career.</span></p><p><span>The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials.</span></p><p><span>Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion.</span></p><p><span>The Excel 2016 Advanced Formulas and Functions is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones.</span></p><p><span>The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly!</span></p><h5><b>What You Get With The Excel 2016 Advanced Formulas and Functions </b></h5><ul><li><span>Receive a e-certificate upon successful completion of the course</span></li><li><span>Get taught by experienced, professional instructors</span></li><li><span>Study at a time and pace that suits your learning style</span></li><li><span>Get instant feedback on assessments </span></li><li><span>24/7 help and advice via email or live chat</span></li><li><span>Get full tutor support on weekdays (Monday to Friday)</span></li></ul>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					<div>
							
					<div></div>
											<div></div>
														
							
					<div></div>
											<div></div>
														
							
					<div></div>
											<div></div>
														
							
					<div></div>
											<div></div>
														
					</div>
			</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Course Design</h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<div id="course-home"><div><p><span>The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.</span></p><p><span>You are taught through a combination of</span></p><ul><li><span>Video lessons</span></li><li><span>Online study materials</span></li></ul></div></div>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Certification</h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<p><span>Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who Is This Course For:</h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<p><span>The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge.</span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Requirements:</h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<p><span>The online training is open to all students and has no formal entry requirements. To study the Excel 2016 Advanced Formulas and Functions, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16.</span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
									</div>
			</div>
					</div><div>
				<h3>Course Content</h3>

<div id="course_curriculum">
<table width="100%">				<tbody><tr>
					<td colspan="4">Advanced Functions</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Work with Ranges</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Specialized Functions</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Work with Logical Functions</td>
					<td> </td>
					<td><span><i></i> 00:24:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Work with Date &amp; Time Functions</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Work with Text Functions@</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Working with Lists</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Query Data with Database Functions</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Outline and Subtotal Data</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Using Lookup Functions and Formula Auditing</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Lookup Functions</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Trace Cells</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Watch and Evaluate Formulas</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Automating Workbook Functionality</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Search for Invalid Data and Formulas with Errors</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Troubleshoot Invalid Data and Formula Errors</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Other Functions and Formulas</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Text Functions</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Specialized Functions</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Date Functions</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Financial Functions</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Automate SUM Functions</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
				</tbody></table></div>

			</div>
			<h2>Frequently Asked Questions</h2>
                        <div>
                            <div>
                                <span>
                                    Are there any prerequisites for taking the course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        There are no specific prerequisites for this course, nor
                                        are there any formal entry requirements. All you need is
                                        an internet connection, a good understanding of English
                                        and a passion for learning for this course.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    Can I access the course at any time, or is there a set
                                    schedule?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        You have the flexibility to access the course at any time
                                        that suits your schedule. Our courses are self-paced,
                                        allowing you to study at your own pace and convenience.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    How long will I have access to the course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        For this course, you will have access to the course
                                        materials for 1 year only. This means you can review the
                                        content as often as you like within the year, even after
                                        you've completed the course. However, if you buy Lifetime
                                        Access for the course, you will be able to access the
                                        course for a lifetime.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    Is there a certificate of completion provided after
                                    completing the course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        Yes, upon successfully completing the course, you will
                                        receive a certificate of completion. This certificate can
                                        be a valuable addition to your professional portfolio and
                                        can be shared on your various social networks.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    Can I switch courses or get a refund if I'm not satisfied
                                    with the course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        We want you to have a positive learning experience. If
                                        you're not satisfied with the course, you can request a
                                        course transfer or refund within 14 days of the initial
                                        purchase.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    How do I track my progress in the course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        Our platform provides tracking tools and progress
                                        indicators for each course. You can monitor your progress,
                                        completed lessons, and assessments through your learner
                                        dashboard for the course.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    What if I have technical issues or difficulties with the
                                    course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        If you encounter technical issues or content-related
                                        difficulties with the course, our support team is
                                        available to assist you. You can reach out to them for
                                        prompt resolution.
                                    </p>
                                </div>
                            </div>
                        </div>

Janets

Microsoft Excel

Excel 2016 Advanced Formulas and Functions

Office Skills & Productivity

Online Course Creation

Office Skills

Office Administration

European Computer Driving Licence (ECDL)

Excel Essentials for Office Administrators

Microsoft Certification

Office Productivity

Microsoft Office

Microsoft Office 2016 Essentials

<div>
						<div>
				<div>
									<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
								<div>
				<p><span>Register on the Excel 2016 Formulas and Functions today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career.</span></p><p><span>The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials.</span></p><p><span>Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a certificate as proof of your course completion.</span></p><p><span>The Excel 2016 Formulas and Functions course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablets, and smartphones.</span></p><p><span>The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly!</span></p><p><b>What You Get With The Excel 2016 Formulas and Functions course</b></p><ul><li><span>         </span><span>Receive a digital certificate upon successful completion of the course</span></li><li><span>         </span><span>Get taught by experienced, professional instructors</span></li><li><span>         </span><span>Study at a time and pace that suits your learning style</span></li><li><span>         </span><span>Get instant feedback on assessments </span></li><li><span>         </span><span>24/7 help and advice via email or live chat</span></li><li><span>         </span><span>Get full tutor support on weekdays (Monday to Friday)</span></li></ul>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Course Design</h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<div id="course-home"><div><p><span>The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.</span></p><p><span>You are taught through a combination of</span></p><ul><li><span>         </span><span>Video lessons</span></li><li><span>         </span><span>Online study materials</span></li></ul></div></div>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Certification</h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<p><span>After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who Is This Course For:</h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<p><span>The course is ideal for those who already work in this sector or are aspiring professionals. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge.</span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Requirements:</h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<p><span>The online training is open to all students and has no formal entry requirements. To study the Excel 2016 Formulas and Functions course, all you need is a passion for learning, A good understanding of English, numeracy, and IT skills. You must also be over the age of 16.</span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
									</div>
			</div>
					</div><div>
				<h3>Course Content</h3>

<div id="course_curriculum">
<table width="100%">				<tbody><tr>
					<td colspan="4">Getting Started with Microsoft Excel 2016</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Excel Commands</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create and Save a Basic Workbook</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Enter Cell Data</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Excel Help</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Basic Formulas and Functions</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create Worksheet Formulas</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Insert Functions</td>
					<td> </td>
					<td><span><i></i> 00:17:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Reuse Formulas and Functions</td>
					<td> </td>
					<td><span><i></i> 00:17:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Formulas and Functions Activities</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create Formulas in a Worksheet</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Activity - Create Formulas in a Worksheet</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Insert Functions in a Worksheet</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Activity - Insert Functions in a Worksheet</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Reuse Formulas</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Activity - Reuse Formulas</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Customize Formula Options</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Activity - Customize Formula Options</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Order your Certificates &amp; Transcripts</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order your Certificates &amp; Transcripts</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table></div>

			</div>
			<h2>Frequently Asked Questions</h2>
                        <div>
                            <div>
                                <span>
                                    Are there any prerequisites for taking the course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        There are no specific prerequisites for this course, nor
                                        are there any formal entry requirements. All you need is
                                        an internet connection, a good understanding of English
                                        and a passion for learning for this course.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    Can I access the course at any time, or is there a set
                                    schedule?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        You have the flexibility to access the course at any time
                                        that suits your schedule. Our courses are self-paced,
                                        allowing you to study at your own pace and convenience.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    How long will I have access to the course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        For this course, you will have access to the course
                                        materials for 1 year only. This means you can review the
                                        content as often as you like within the year, even after
                                        you've completed the course. However, if you buy Lifetime
                                        Access for the course, you will be able to access the
                                        course for a lifetime.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    Is there a certificate of completion provided after
                                    completing the course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        Yes, upon successfully completing the course, you will
                                        receive a certificate of completion. This certificate can
                                        be a valuable addition to your professional portfolio and
                                        can be shared on your various social networks.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    Can I switch courses or get a refund if I'm not satisfied
                                    with the course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        We want you to have a positive learning experience. If
                                        you're not satisfied with the course, you can request a
                                        course transfer or refund within 14 days of the initial
                                        purchase.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    How do I track my progress in the course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        Our platform provides tracking tools and progress
                                        indicators for each course. You can monitor your progress,
                                        completed lessons, and assessments through your learner
                                        dashboard for the course.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    What if I have technical issues or difficulties with the
                                    course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        If you encounter technical issues or content-related
                                        difficulties with the course, our support team is
                                        available to assist you. You can reach out to them for
                                        prompt resolution.
                                    </p>
                                </div>
                            </div>
                        </div>

Excel 2016 Formulas and Functions

<span dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">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.</span></p><span dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">This course will cover the following to assist support staff in understanding the fundamental aspects of AML.</span></p><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></span><h2 fr-original-style="" style="box-sizing: border-box;">Target Audience</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;">The online course is suitable for support staff or legal practitioners wanting to understand the basics of AML.</span></p></span><h2 data-key="21" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Resources</h2><p data-key="28" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span data-key="29" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="29:0" fr-original-style="" style="box-sizing: border-box;">Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training.</span></span></p><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);"><span data-key="31" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="31:0" fr-original-style="" style="box-sizing: border-box;">Please note a recording of the course will&nbsp;</span><span data-offset-key="31:1" fr-original-style="" style="box-sizing: border-box;"><strong data-slate-leaf="true" fr-original-style="" style="font-weight: 700; box-sizing: border-box;">not&nbsp;</strong></span><span data-offset-key="31:2" fr-original-style="" style="box-sizing: border-box;">be made available.</span></span></p><h2 data-key="35" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span data-key="36" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="36:0" fr-original-style="" style="box-sizing: border-box;">Speaker</span></span></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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 180, 205); box-sizing: border-box;" fr-original-style="color: rgb(0, 180, 205);">Helen Torresi, Consultant, DG Legal</span></strong></a></h3><p style="color: rgb(89, 89, 91); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(89, 89, 91);"><span style="color: rgb(89, 89, 91); box-sizing: border-box;" fr-original-style="color: rgb(89, 89, 91);">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.</span></p><p style="color: rgb(89, 89, 91); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(89, 89, 91);"><span style="color: rgb(89, 89, 91); box-sizing: border-box;" fr-original-style="color: rgb(89, 89, 91);">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).</span></p>

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) 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">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>To 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.</p>Overview<p>Upon 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.</p><p>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.</p></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

Excel Analytics

Spreadsheet

Excel - Excel Essentials and Formulas

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Welcome</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Hello and welcome to our 1-day Introduction to Coaching.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Join Colin Brett, Founder, and Director of Training, who facilitates these free learning days online. If you select which day you&#39;d like to attend on our website we&rsquo;ll reserve and confirm a space for you.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Why Free?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We recognise that signing up to a coach training involves work, time, effort, energy, finance and commitment. We thought the opportunity to join us for an experiential day may be useful in your decision-making process. Although the majority of those joining will be exploring training options, these days are also about &lsquo;coach education&rsquo; for those who would like to learn more about it&hellip;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">This day may be a good investment of your time if:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">You&rsquo;re curious about what coaching actually is</li><li fr-original-style="" style="box-sizing: border-box;">You&rsquo;ve never tried it before, but would like to</li><li fr-original-style="" style="box-sizing: border-box;">You want to change career direction</li><li fr-original-style="" style="box-sizing: border-box;">Coach training would be an augment to your current skillset/role</li><li fr-original-style="" style="box-sizing: border-box;">Coaching is an approach you&#39;d like to bring into your current organisation</li><li fr-original-style="" style="box-sizing: border-box;">You&rsquo;d like to gain a practical understanding of what coaching is and how to do it</li><li fr-original-style="" style="box-sizing: border-box;">An opportunity to explore our approach to training would be useful</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;</strong><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What does the day offer?&nbsp;</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">It&rsquo;s a day-long experiential opportunity for you to explore coaching in a safe, engaged environment. You will leave with a clear understanding of what coaching is and isn&#39;t; how it sits along-side the other talking modalities; what it would be like to train with us, and whether professional coach training is for you.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">During the day we will work through topics such as:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Contracting and the importance of it</li><li fr-original-style="" style="box-sizing: border-box;">Core Competencies (as set down by the International Coaching Federation)</li><li fr-original-style="" style="box-sizing: border-box;">Comparisons between Formal and Informal Coaching</li><li fr-original-style="" style="box-sizing: border-box;">Definitions (as set down by the International Coaching Federation)</li><li fr-original-style="" style="box-sizing: border-box;">Practice Sessions (am and pm for comparison)</li><li fr-original-style="" style="box-sizing: border-box;">Live Coaching Demonstration and a Feedback Session based on it</li><li fr-original-style="" style="box-sizing: border-box;">Levels of Listening</li><li fr-original-style="" style="box-sizing: border-box;">Questioning</li><li fr-original-style="" style="box-sizing: border-box;">Q&amp;A Session</li><li fr-original-style="" style="box-sizing: border-box;">and more..!</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">About Coaching Development:</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a href="https://www.coachingdevelopment.com/" target="_blank" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Coaching Development</a> has been established for over 20 years and is one of the premier international coach training institutes. Based in the UK, we have trained hundreds of coaches across the world and are proud to state that the majority of our graduates come to us via personal recommendation. The programmes we offer will equip you to practice in any sector: executive, business, individual, wellness, academia, fitness, therapeutic and many more; they are aimed at developing your skillset as a coach.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Our promise to you:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">No selling! We will not attempt to sell our programmes to you, this day is a safe learning space.&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">We will be open and honest with you and tell you anything you want to know about us, our approach and our training.</li><li fr-original-style="" style="box-sizing: border-box;">This free day embodies Coaching Development&rsquo;s usual approach to training offering the deepest professional integrity, incorporating highly experiential, in-depth, adult-to-adult development.</li><li fr-original-style="" style="box-sizing: border-box;">Our commitment to your learning - we will be clear about the objectives for the day and partner with you to meet these.</li><li fr-original-style="" style="box-sizing: border-box;">Opportunities to practice, take advantage of feedback, collaborate and experience practical translation of the skillset.</li><li fr-original-style="" style="box-sizing: border-box;">Our training material is accredited by the International Coach Federation - the leading global body for professional coaching and coaches.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;If you&rsquo;d like an informal chat about any aspects of the introductory day or our training you&rsquo;re very welcome to give Isy a call on: 020 8541 1313 or visit : <a href="//www.coachingdevelopment.com" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.coachingdevelopment.com</a>&nbsp;</p>

Coaching Development Ltd

An ICF accredited coach training programme.

Coaching Development's FREE Introduction to Coaching Day

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T<span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">his 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;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">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"></span></p><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);"><span data-key="22" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="22:0" fr-original-style="" style="box-sizing: border-box;">Target Audience</span></span></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.</p><h2 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Resources</h2><p data-key="28" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">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><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);"><span data-key="31" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="31:0" fr-original-style="" style="box-sizing: border-box;">Please note a recording of the course will&nbsp;</span><span data-offset-key="31:1" fr-original-style="" style="box-sizing: border-box;"><strong data-slate-leaf="true" fr-original-style="" style="font-weight: 700; box-sizing: border-box;">not&nbsp;</strong></span><span data-offset-key="31:2" fr-original-style="" style="box-sizing: border-box;">be made available.</span></span></p><h2 data-key="35" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span data-key="36" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="36:0" fr-original-style="" style="box-sizing: border-box;">Speaker</span></span></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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 180, 205); box-sizing: border-box;" fr-original-style="color: rgb(0, 180, 205);">Sarah Charlton, Consultant, DG Legal</span></strong></a></h3><p data-key="39" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);"><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.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p>

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

<span dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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.</p></span><span dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course will cover the following to assist fee earners in the application of AML in their casework.</p><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></span></span><h2 fr-original-style="" style="box-sizing: border-box;">Target Audience</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;">The online course is suitable for fee earners or legal practitioners that want to improve their AML knowledge.</span></p></span><h2 data-key="21" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Resources</h2><p data-key="28" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span data-key="29" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="29:0" fr-original-style="" style="box-sizing: border-box;">Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training.</span></span></p><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);"><span data-key="31" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="31:0" fr-original-style="" style="box-sizing: border-box;">Please note a recording of the course will&nbsp;</span><span data-offset-key="31:1" fr-original-style="" style="box-sizing: border-box;"><strong data-slate-leaf="true" fr-original-style="" style="font-weight: 700; box-sizing: border-box;">not&nbsp;</strong></span><span data-offset-key="31:2" fr-original-style="" style="box-sizing: border-box;">be made available.</span></span></p><h2 data-key="35" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span data-key="36" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="36:0" fr-original-style="" style="box-sizing: border-box;">Speaker</span></span></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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 180, 205); box-sizing: border-box;" fr-original-style="color: rgb(0, 180, 205);">Helen Torresi, Consultant, DG Legal</span></strong></a></h3><p style="color: rgb(89, 89, 91); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(89, 89, 91);"><span style="color: rgb(89, 89, 91); box-sizing: border-box;" fr-original-style="color: rgb(89, 89, 91);">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.</span></p><p style="color: rgb(89, 89, 91); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(89, 89, 91);"><span style="color: rgb(89, 89, 91); box-sizing: border-box;" fr-original-style="color: rgb(89, 89, 91);">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).</span></p>

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

Anti-Money Laundering (AML) Training For Fee Earners Course

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>The 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.</p>Overview<p>The 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.</p><p>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.</p></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>

Design & Technology Courses (DT)

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)

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Create &pound;1,000s in recurring property income year after year</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Supercharge property profits, value and rent</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Secure financial freedom through property</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Recycle your investment capital</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Build a portfolio with limited cash investment</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Create property income without even needing a deposit</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We&#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.</p>

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

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Looking to bring your business growth ideas to life but need a cash injection?</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Join us at our FREE online webinar, where we demystify the intricate world of business funding, equipping you with the knowledge and strategies needed to secure the resources your business needs and deserves.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">In this course, you&#39;ll gain a wider knowledge of funding options for your business to scale/expand.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Dates</strong>: Wednesday 16th October 2024</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Time</strong>: 10:00am - 11:00am</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Where</strong>: Online (Zoom)</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Fee</strong>: Free</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">For</strong>: <span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);">Businesses based in North Essex (Braintree, Chelmsford, Colchester, Maldon, and Tendring)</span></p><h3 fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></h3><h3 fr-original-style="" style="box-sizing: border-box;">What it covers:</h3><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Covering topics such as GGS (Growth Guarantee Scheme), Growth Loans, Start-up Loans, and the importance of an accountant in a business relationship, participants will leave with a robust toolkit of knowledge to navigate the intricate world of business financing.</p><h3 fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></h3><h3 fr-original-style="" style="box-sizing: border-box;">Who it is for:</h3><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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 looking to access finance.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><h3 id="isPasted" 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="1" fr-original-style="" style="box-sizing: border-box;">Micro business owners</li><li value="1" fr-original-style="" style="box-sizing: border-box;">Small business owners</li><li value="1" fr-original-style="" style="box-sizing: border-box;">Middle managers</li><li value="1" fr-original-style="" style="box-sizing: border-box;">Consultants</li><li value="1" fr-original-style="" style="box-sizing: border-box;">Coaches</li><li value="1" fr-original-style="" style="box-sizing: border-box;">E-commerce businesses</li><li value="1" fr-original-style="" style="box-sizing: border-box;">Digital marketers</li><li value="1" fr-original-style="" style="box-sizing: border-box;">Service based business owners</li></ul><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">About the hosts:</strong></p><p style="color: rgb(34, 3, 96); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(34, 3, 96);"><u fr-original-style="" style="box-sizing: border-box;">Peter Disney - </u><a href="https://www.woodanddisney.co.uk/" 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;"><u fr-original-style="" style="box-sizing: border-box;">Wood and Disney</u></a></p><p style="color: rgb(34, 3, 96); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(34, 3, 96);">Managing Director, Chartered Accountant, Certified Business and Finance Professional, Certified Profit Consultant and Accredited Business Navigator Provider. Creator of TroubleShooterPlus a business diagnostic program. Creator of Plus4Business an online business advisory system.&nbsp;</p><p style="color: rgb(34, 3, 96); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 3, 96);">Peter has many years of experience in not only all the financial aspects of running a successful business but also in growth strategies. In particular marketing, strategic thinking implementation and control, and leveraging technology for growth, are areas he specialises in.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: var(--text);"><u fr-original-style="" style="box-sizing: border-box;">Robert Laurie -&nbsp;</u><a href="https://backingessexbusiness.co.uk/" target="_blank" rel="noopener noreferrer nofollow" style="color: var(--cademy-blue); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: var(--cademy-blue);"><u fr-original-style="" style="box-sizing: border-box;">Backing Essex Business</u></a></p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">Robert is a Business Advisory Manager at Backing Essex Business (delivered by Let&#39;s Do Business Group) and has 35 years of banking relationship and finance experience, providing support and advice to businesses of all sizes across Essex. He has an extensive network of key partners who also support businesses with non-financial issues, as well as good links to Local Councils and Grant providers.</p><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;"><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: var(--text);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">This programme is delivered by the North Essex Economic Board (NEEB) in partnership with Let&#39;s Do Business Group.</strong></p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Let&#39;s Do Business Group is undertaking this project jointly with the&nbsp;</strong></em><a href="https://neeb.org.uk/" target="_blank" rel="noopener noreferrer nofollow" title="https://neeb.org.uk/" style="color: var(--cademy-blue); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: var(--cademy-blue);"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">North Essex Economic Board (NEEB)</strong></em></a><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">. The Board is a partnership of local authorities in the area: Braintree, Maldon, and Tendring district councils, Colchester Borough Council, Chelmsford City Council and Essex County Council.</strong></em></p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">This project is funded by the UK Government through the UK Shared Prosperity Fund.</strong></em></p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">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. For more information, visit&nbsp;</strong></em><a href="https://www.gov.uk/government/publications/uk-shared-prosperity-fund-prospectus" target="_blank" rel="noopener noreferrer nofollow" title="https://www.gov.uk/government/publications/uk-shared-prosperity-fund-prospectus" style="color: var(--cademy-blue); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: var(--cademy-blue);"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">https://www.gov.uk/government/publications/uk-shared-prosperity-fund-prospectus</strong></em></a></p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Please click here to see our&nbsp;</strong><a href="https://backingessexbusiness.co.uk/privacy-policy" target="_blank" rel="noopener noreferrer nofollow" title="https://backingessexbusiness.co.uk/privacy-policy" style="color: var(--cademy-blue); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: var(--cademy-blue);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Privacy Policy</strong></a><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">. Please note that your details may be shared with the North Essex Economic Board who are funding this project.</strong></p>

Looking to bring your business growth ideas to life but need a cash injection?
Join us at our FREE online webinar, where we demystify the intricate world of business funding, equipping you with the knowledge and strategies needed to secure the resources your business needs and deserves.
In this course, you'll gain a wider knowledge of funding options for your business to scale/expand.


Dates: Wednesday 16th October 2024
Time: 10:00am - 11:00am
Where: Online (Zoom)
Fee: Free
For: Businesses based in North Essex (Braintree, Chelmsford, Colchester, Maldon, and Tendring)


What it covers:
Covering topics such as GGS (Growth Guarantee Scheme), Growth Loans, Start-up Loans, and the importance of an accountant in a business relationship, participants will leave with a robust toolkit of knowledge to navigate the intricate world of business financing.


Who it is for:
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 looking to access finance. 


Who should attend:
Entrepreneurs
Micro business owners
Small business owners
Middle managers
Consultants
Coaches
E-commerce businesses
Digital marketers
Service based business owners
About the hosts:
Peter Disney - Wood and Disney
Managing Director, Chartered Accountant, Certified Business and Finance Professional, Certified Profit Consultant and Accredited Business Navigator Provider. Creator of TroubleShooterPlus a business diagnostic program. Creator of Plus4Business an online business advisory system. 
Peter has many years of experience in not only all the financial aspects of running a successful business but also in growth strategies. In particular marketing, strategic thinking implementation and control, and leveraging technology for growth, are areas he specialises in.
Robert Laurie - Backing Essex Business
Robert is a Business Advisory Manager at Backing Essex Business (delivered by Let's Do Business Group) and has 35 years of banking relationship and finance experience, providing support and advice to businesses of all sizes across Essex. He has an extensive network of key partners who also support businesses with non-financial issues, as well as good links to Local Councils and Grant providers.



This programme is delivered by the North Essex Economic Board (NEEB) in partnership with Let's Do Business Group.
Let's Do Business Group is undertaking this project jointly with the North Essex Economic Board (NEEB). The Board is a partnership of local authorities in the area: Braintree, Maldon, and Tendring district councils, Colchester Borough Council, Chelmsford City Council and Essex County Council.
This project 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. For more information, visit https://www.gov.uk/government/publications/uk-shared-prosperity-fund-prospectus
Please click here to see our Privacy Policy. Please note that your details may be shared with the North Essex Economic Board who are funding this project.

Let’s Do Business Group

Looking to bring your business growth ideas to life but need a cash injection? Join us at our FREE online webinar!

Access to Funding

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This Real Estate Financial Modelling course will enhance delegates skills in crafting sophisticated financial models tailored for debt financing within the Real Estate sector.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course delegates will...</strong></strong><br fr-original-style="" style="box-sizing: border-box;">&bull; Learn how to build senior debt models with geared net cash flow.<br fr-original-style="" style="box-sizing: border-box;">&bull; Explore and assess the influence of complex debt structures on returns.<br fr-original-style="" style="box-sizing: border-box;">&bull; Develop advanced mezzanine debt models affecting project cash flows.<br fr-original-style="" style="box-sizing: border-box;">&bull; Model joint venture structures for optimised partnerships.<br fr-original-style="" style="box-sizing: border-box;">&bull; Calculate promote and profit share structures in Real Estate transactions.<br fr-original-style="" style="box-sizing: border-box;">&bull; Construct sophisticated project cash flow models with mezzanine debts.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></strong><br fr-original-style="" style="box-sizing: border-box;">&bull; Real Estate Professionals who have had exposure to Real Estate financial models<br fr-original-style="" style="box-sizing: border-box;">&bull; Mid to Senior level Real Estate Analysts looking to develop their financial modelling skills in development, portfolio analysis<br fr-original-style="" style="box-sizing: border-box;">&bull; Real Estate Developers<br fr-original-style="" style="box-sizing: border-box;">&bull; Financial Analysts<br fr-original-style="" style="box-sizing: border-box;">&bull; Investment Managers<br fr-original-style="" style="box-sizing: border-box;">&bull; Banking and Finance Professionals in Real Estate</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outline</strong></strong><br fr-original-style="" style="box-sizing: border-box;">&bull; Mathematics of amortisation and debt finance.<br fr-original-style="" style="box-sizing: border-box;">&bull; Basic senior debt models and geared net cash flow.<br fr-original-style="" style="box-sizing: border-box;">&bull; Debt Cash Flow metrics: LTV, IRR and Interest Rate Dynamics.<br fr-original-style="" style="box-sizing: border-box;">&bull; Mezzanine debt modelling.<br fr-original-style="" style="box-sizing: border-box;">&bull; Joint Venture structures between developers and lender/equity partners.<br fr-original-style="" style="box-sizing: border-box;">&bull; Promote and profit share structure calculations.<br fr-original-style="" style="box-sizing: border-box;">&bull; Advanced project cash flows with mezzanine debt.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">A Bayfield Training Certificate</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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the Real Estate Finance such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a></p>



This 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

Bayfield Training

Financial Modelling & Analysis

Real Estate Finance

Financial Modelling

Financial Analysis

Professional Development

Continuous Professional Development (CPD)

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)

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Real Estate Development cash flows require greater skill and flexibility from Analysts, and an ability to work with simultaneously with project partners. Value add and opportunistic property investments are complex both in their initial scope and their cash flow projections.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course will show delegates how to appraise projects in Excel, incorporate and communicate updates as they happen and ultimately understand how to convert an opportunistic property investment into a core asset that can be sold on.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Residual models (profit &amp; site) are demonstrated first to illustrate the main components of any scheme and the traditional methods of evaluation such as profit on cost ratio, rental yield and interest cover. Development cash flows are then constructed in detail looking in particular at phased income as well as fixed, variable and incidental construction costs and their impact on the net cash flow. Additional performance metrics are calculated including geared IRR and return on equity.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Development financing can be trickier than straightforward senior debt investment financing. This is because finance is often required in stages. The brought forward carried forward method demonstrated on the course, is the easiest way to deal with programmed debt drawdown functions and rolled-up interest.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The assessment of project specific risk is arguably much more important in development schemes. Sensitivity analysis and scenario analysis are covered in the final section of the course.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course you will&hellip;</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Learn how to calculate land and profit residuals</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Learn how to structure a full development cash flow, including phased sales, S-curve and straight line cost functions</li><li value="3" fr-original-style="" style="box-sizing: border-box;">You will be taught how to find maximum bidding prices for site development and building refurbishments</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Understanding development financing considerations and learn how to optimise financing</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analyse financial and project completion risks</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Employ best practice and find solutions to common modelling problems</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Developers</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Surveyors</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Real Estate professionals at any level with exposure to real estate financial models on a frequent basis</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Fund managers</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Asset managers</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Land managers</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Planning managers</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Lenders</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outline</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day One</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Learn how to build a discounted cash flow, analyse returns and understand the components of development models</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Gross versus Net Yields, calculating Net Development Value (NDV)</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Profit residual, with and without financing</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Site residual, how to calculate profit without knowing your costs.</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Introducing financing to site residual calculations</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Purchase price and acquisition costs</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Phased Sales, marketing and disposal costs</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Modelling construction costs using straight line basis, fixed costs, variable costs, incidental costs and construction fees</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Professional fees</li><li value="9" fr-original-style="" style="box-sizing: border-box;">Income and expenditure project functions</li><li value="10" fr-original-style="" style="box-sizing: border-box;">Logic functions, logic tables and array formulae</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day Two</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Learn how to build a detailed property development project cash flow, add financing and perform risk analysis on commercial development projects</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Multiple IRRs, competing projects, scoping and linear programming, maximising performance</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Return metrics: Equity profit ratio (EPR), Costs paid out of proceeds (POP), Profit on cost ratio (PCR)</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Alternative site calculation, Net present value (NPV),</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Modelling construction costs using S-curve , variable costs, incidental costs and construction fees</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Switching between scenarios</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Introduction to Development financing, Pari Passu versus Equity First Financing</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Debt scheduling: brought forward and carried forward method</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Consideration of the impact of development finance interest, fees and covenants</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Course Files</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the Real Estate Developer such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a></p>



Real Estate Development cash flows require greater skill and flexibility from Analysts, and an ability to work with simultaneously with project partners. Value add and opportunistic property investments are complex both in their initial scope and their cash flow projections.
This course will show delegates how to appraise projects in Excel, incorporate and communicate updates as they happen and ultimately understand how to convert an opportunistic property investment into a core asset that can be sold on.
Residual models (profit & site) are demonstrated first to illustrate the main components of any scheme and the traditional methods of evaluation such as profit on cost ratio, rental yield and interest cover. Development cash flows are then constructed in detail looking in particular at phased income as well as fixed, variable and incidental construction costs and their impact on the net cash flow. Additional performance metrics are calculated including geared IRR and return on equity.
Development financing can be trickier than straightforward senior debt investment financing. This is because finance is often required in stages. The brought forward carried forward method demonstrated on the course, is the easiest way to deal with programmed debt drawdown functions and rolled-up interest.
The assessment of project specific risk is arguably much more important in development schemes. Sensitivity analysis and scenario analysis are covered in the final section of the course.


On this course you will…
Learn how to calculate land and profit residuals
Learn how to structure a full development cash flow, including phased sales, S-curve and straight line cost functions
You will be taught how to find maximum bidding prices for site development and building refurbishments
Understanding development financing considerations and learn how to optimise financing
Analyse financial and project completion risks
Employ best practice and find solutions to common modelling problems


Who will benefit from this course?
Developers
Surveyors
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
Fund managers
Asset managers
Land managers
Planning managers
Lenders


Course Outline
Day One
Learn how to build a discounted cash flow, analyse returns and understand the components of development models
Gross versus Net Yields, calculating Net Development Value (NDV)
Profit residual, with and without financing
Site residual, how to calculate profit without knowing your costs.
Introducing financing to site residual calculations
Purchase price and acquisition costs
Phased Sales, marketing and disposal costs
Modelling construction costs using straight line basis, fixed costs, variable costs, incidental costs and construction fees
Professional fees
Income and expenditure project functions
Logic functions, logic tables and array formulae


Day Two
Learn how to build a detailed property development project cash flow, add financing and perform risk analysis on commercial development projects
Multiple IRRs, competing projects, scoping and linear programming, maximising performance
Return metrics: Equity profit ratio (EPR), Costs paid out of proceeds (POP), Profit on cost ratio (PCR)
Alternative site calculation, Net present value (NPV),
Modelling construction costs using S-curve , variable costs, incidental costs and construction fees
Switching between scenarios
Introduction to Development financing, Pari Passu versus Equity First Financing
Debt scheduling: brought forward and carried forward method
Consideration of the impact of development finance interest, fees and covenants


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


For more information about the Real Estate Developer 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

Financial Risk Management

This course will show delegates how to appraise projects in Excel, incorporate and communicate updates as they happen and ultimately understand how to convert an opportunistic property investment into a core asset that can be sold on.

6408 Courses

Advanced Excel: Pivot Table, Pivot Charts, Slicers and Timelines

By Skill Up

Microsoft Excel: PowerQuery and PowerPivot

By Skill Up

Microsoft Excel Training: Depreciation Accounting

By Skill Up

Real Estate: Real Estate and Property Development

By Apex Learning

Forex Trading and Anti Money Laundering Complete Diploma

By Apex Learning

UK Property Law and Taxation Fundamentals for Lawyers - 8 Courses Bundle

By NextGen Learning

Excel 2016 Advanced Formulas and Functions

By Janets

Excel Essentials for Office Administrators

By Janets

Microsoft Office 2016 Essentials

By Janets

Excel 2016 Formulas and Functions

By Janets

Search By Location